Author Topic: Extracting data from a UK census  (Read 934 times)

Offline Daffodilica

  • RootsChat Extra
  • **
  • Posts: 47
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Extracting data from a UK census
« on: Tuesday 17 September 19 14:51 BST (UK) »
Is it possible to somehow extract a list of all occurences of one surname from a UK census? I want to create a list, e.g. all people with the surname Saull from the 1841 census, that I can then use to create a map of where those surnames appear.

Thanks - any advice on how to do this would be gratefully received!

Offline KGarrad

  • RootsChat Marquessate
  • *******
  • Posts: 26,104
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Extracting data from a UK census
« Reply #1 on: Tuesday 17 September 19 15:02 BST (UK) »
I did that myself on the 1851 census for Vanstone ;D

Cut-and-Paste into an Excel spreadsheet worked for me.

I used the free index on FindMyPast.

Saull should be easy - there's only 78 of them ;D
Garrad (Suffolk, Essex, Somerset), Crocker (Somerset), Vanstone (Devon, Jersey), Sims (Wiltshire), Bridger (Kent)

Offline Daffodilica

  • RootsChat Extra
  • **
  • Posts: 47
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Extracting data from a UK census
« Reply #2 on: Tuesday 17 September 19 15:15 BST (UK) »
Thanks - I'll give it a go. Just created an excel list from FamilySearch, so I'll try Find My Past next!

Offline rosie99

  • RootsChat Marquessate
  • *******
  • Posts: 42,073
  • ALFIE 2009 - 2021 (Rosbercon Sky's the Limit)
    • View Profile
Re: Extracting data from a UK census
« Reply #3 on: Tuesday 17 September 19 16:14 BST (UK) »
Thanks - I'll give it a go. Just created an excel list from FamilySearch, so I'll try Find My Past next!

Doesn't familysearch draw its information for most census from findmypast.  They certainly give a link to it.
Census information is Crown Copyright, from www.nationalarchives.gov.uk


Offline Daffodilica

  • RootsChat Extra
  • **
  • Posts: 47
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Extracting data from a UK census
« Reply #4 on: Tuesday 17 September 19 17:42 BST (UK) »
I think so - I'll try and extract from both sites and see if there are any differences  :)

Offline jc26red

  • RootsChat Marquessate
  • *******
  • Posts: 5,345
  • Census information Crown Copyright.
    • View Profile
Re: Extracting data from a UK census
« Reply #5 on: Friday 20 September 19 14:33 BST (UK) »
You might also want to consider doing the same with spelling variations.
Please acknowledge when a restorer works on your photos, it can take hours for them to work their magic

Please scan at 300dpi minimum to help save the restorers eyesight.

Offline Daffodilica

  • RootsChat Extra
  • **
  • Posts: 47
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Extracting data from a UK census
« Reply #6 on: Friday 20 September 19 17:30 BST (UK) »
Thanks - will do. I'm going to have a play around with data over the weekend.  ;)