Family Historian User Group

Hello Board

I am using the Lost Cousins website and while most of my direct ancestors' censuses are logged on this website, the siblings and cousins' censuses are not and keeping track of where I'm up to is a pain.    So two individual questions:

1.  How can I create a query that will show me each census record that I have assigned to individuals - I don't need a list of each person on the census, only each census with perhaps the head of household from which I can load the census image media and complete the Lost Cousins website.  I did manage a query which showed me every individual with an 1881 census flag but I'm not after a list of individuals, and while I can see how to filter a list of individuals to those with the 1881 census flag, I can't see how then to only show the census descriptions relating to 1881, if that makes sense.

2. Once I've logged all my 1881 censuses on Lost Cousins, I would like to be able to see which individuals present on my Family Historian file are likely to have been alive at 1881 AND do NOT have an 1881 census entry - this will give me a kind of automatic to-do list of which censuses I still need to find/investigate.  In fact the facility to alter the alive at date and census required would be fab so I could then repeat the to-do list facility for all the censuses 1841-1911.

I have been using the fab Ancestral Sources and it's predecessor to put the census onto FH, using the 'method 1' way.

Hope these requests make sense.

Regards

Jules

ID:4751

Have you tried the census queries already in the Query Store?

Plus the Alive At and age at a selected date one?

Finally once you enter them into Lost Cousins why not add a flag to say you have done them, and add that into a custom version of the query.

Hello Jane

Thank you for your response.

I'm not quite sure how to execute your suggestions as I can't figure out how to link two criteria together using the query mechanism (alive in 1881 and 1881 census record attached) and I also can't work out how to get a diagram based on just individuals returned by a query (in order to display a Lost Cousins flag).  

I've downloaded and installed lots of the Query Store queries and although quite a few of them show present and missing census years (eg Census_Missing_Years_1911)I'm either not using them correctly or they don't show what I'm after.

Here is a list of the custom queries I've installed:



Suppose the simplest way would be a query that will show me all the censuses on FH just for 1881.  I could then export that list to Excel and tick off as I add to Lost Cousins.  Shame as adding a flag for those individuals added in seems a good idea but Lost Cousins is census based not individual based.

Feel in a right pickle and apologise for not understanding your suggestion.  I'm feeling very rusty with FH and was only a fairly basic user even at the height of my use before.  [confused]

Regards

Jules

If you use recording method 1 then this suggests that each of your census households will be linked to a separate source. So wouldn't a query that looks at your sources be more useful than one that looks at your individuals? e.g. something based on the 'Sources Records All' standard query? You could filter on those with source type 'Census' (assuming you used this default setting in Ancestral Sources and before that Gedcom Census).

I have recently designed a complex Custom Query that identifies every Census Event for each Individual for each year 1941 to 1911.
It either shows the Date of the Census Event, or 'n/a' if not alive, or is left blank.
It checks both Individual Census Events and Family Census Events which I use to temporarily record where I have found a likely Census. These events only have the Census Year and not the full date.
Would this be useful?
[ Jane - I tried uploading an image of the query results but it always failed - any suggestions of what I am doing wrong? ]

The most common reason for it to fail to upload is it's over 50Kb (one day I will dig through the forum code and change that) try a .png file as they are often smaller.

You can upload your Query to the Query Store and then put a link to it in the forum if you want.

Thanks for that Jane - Yes, 50KB is a bit small, but PNG did not help, so here is the JPG for earlier post.
It is a little fuzzy because of the size reduction, but it gives an idea of the result of the query.

This might not serve the purpose, but this is what I would do.

1) Use a query to make a list of people who might be alive in 1881.

2) send the results to a named list in FH: 'add 1881 census to Lost Cousins'

3) as you find census records and add each household to Lost Cousins, remove each individual from the named list

4) if you need to have a separate record of which households are missing 1881 census images, make a separate named list

Return to step 1 and repeat for whichever other census you like.

Ooooh, lovely, lots of responses for me to work through steadily to see if my FH rusty brain can assimilate the information.

Thank you all for all your help on this - I'm very grateful and looking forward to doing this when hubbie has turned the telly off and I can be quiet and concentrate. [lol]

Jules

Well I've re-read chapters 13 & 14 on queries and custom queries in the Getting the Most From FH and have worked through the suggestions and tinkered a bit and am much more confident that I can achieve my original requirements.  Will have to re-read the whole thing as I've forgotten more than I learnt originally somehow. [confused]

From Nick's suggestion, I can now see that I've only got a miserable 24 1881 census source records which I find amazing from the seemingly hundreds I've put on. [wink] I'm going to be a very busy girl hunting down and putting all the myriad missing ones onto FH.

I've also create a good few named lists so that I can keep track of where I'm up to with what has been added to Lost Cousins and what is to be added.

Finally I've PMed Tatewise to take him up on his kind offer of the super-duper custom query which will show with blanks all the individuals for whom I need to find census records.

Many thanks to all of you again. [smile]

Regards

Jules

tatewise

Sounds like your census query would be really useful. Are you planning to upload it to the Query Store?

David

It is now there in the Query Store under the title of Kinsfolk Census Queries to download and enjoy.

Excellent!

Many thanks.

Just a quick update.  The Kinsfolk query is fantastic and I'm surging forward both in updating my Lost Cousins site by using Nick's suggestions of a slightly amended Source Records - All and also now have a lovely list of rellies for whom I need to track down various census records, including 1881 through the Kinsfolk Census To Do Table.

Thank you all, especially Mike & Nick! [dancing-banana]