Generate a list of people who were alive on Census Date

I have recently upgraded to RM 10 and also gained access to the 1921 England and Wales census via Ancestry.

I thought it might be useful for me to be able to generate a list of or mark people who were alive on the UK 1921 census date (19th June 1921) so that I could work my way through my tree to add the census data.

I tried experimenting with the new advanced person search facility within RM 10, what it really needs is a Alive on ..(“enter date”) criteria but I that does not seem to exist, or if it does I cannot find it. I tried setting the criteria of “Birth date is before 19th June 1921” which did indeed generate a list of people before that date, but goes right back to the 1600s.

I have tried all sorts of combinations of Death and Birth criteria and so far the one that seems to work is

Birth date is before 19th June 1921
AND
Birth date is after 19th June 1821 (assume that back then not many lived to be 100)
AND
Death Date is after 19th June 1921

This seems to work and generates a list of people. I just wondered if this is the best way to achieve a list of people who, assuming that they are somewhere in England and Wales, should have been enumerated in the 1921 census. Or is there a more elegant way of doing this, or perhaps my logic is faulty?

I have considered that as I add census data if might be useful to exclude these people from the list after they have been processed. So I tried adding census data to a small group of people (I used the copy fact addition to RM 10 which seems to work fine) . I then added an additional rule
AND Census date not equal to 19th June 1921
which did indeed exclude those people I had added 1921 census data to. I have added a screen capture to show all of the rules.

I am going to explore the use of groups (which I have never used before) to try and keep the list of people that need 1921 census date added up to date.

Again any thoughts from the clever people on here would be useful.

My brain is fried now so I am going for a lay down, after a beer perhaps.

Regards

Michael

1 Like

Any fact date equals between 19 Jun 1821 and 19 Jun 1921 could be the first “narrowing” criteria.

My first try would be Birth Date > Before > 1921 AND Any Fact > Date > After 1921. But I suspect that it would require additional filtering. For example, what if I had someone who was married in 1812 but I had no birth or death information for the person. So I would probably add additional filters as needed. My experience with this sort of thing is that I usually need first to add people to the search and then need to delete people from the search. It’s really hard to get things perfect all in one go.

The Who Was There List may help with this.
You can put in the Place & Date of census. Along with other options.

I used it for the US 1940 & then 1950 census.

1 Like

If you’re willing to go the SQL route, I have a query I use every day for US census that should be easily adapted.

Use it along with my utility to create a group and you’re all set.

It also handles shared facts.

2 Likes

Sorry for the delay in responding, life took over! Thanks for all of the suggestions, I will investigate all, and create a test DB and have a look at the SQL solution, I have been meaning to look at SQL and RM for ages so this is an ideal opportunity.

Again thanks for the help