* Specifying Source ID in a query [Solved]

[Gowermick]

I have a query that shows me all individuals who were around in 1841, so could potentially appear in 1841 census. How can I exclude all those whom I have already found, who will all be using my source 'Census 1841' ( ID 19)

i.e. Where do I find Source ID in the data list, so that I can add it to a Column so I can use its value as a filter?

[tatewise]

You need =RecordId(%INDI.CENS[year=1841].SOUR[1]>%) to get Record Id number.
For more on functions such as =RecordId(...) see how_to:understanding_functions|> Understanding Functions.

But also %INDI.CENS[year=1841].SOUR[1]>TITL% will give you the Source Title that you could check against Census 1841.

Presumably though either there is a Census Event for 1841 with a Source Citation, or there is no Census Event at all for 1841? So all you need to check for is the existence or not of %INDI.CENS[year=1841]%.

I presume you are also aware of the Lookup Missing Census Facts Plugin that does all that for you, and provides the search Census commands for Ancestry and FindMyPast?

Also I am sure there are similar ready-made Queries in the FHUG Downloads.

[Gowermick]

Thanks Mike,

The first expression was what I was looking for. My list of potential individuals has now dropped from around 1800 to 693!

I was aware of the plugin you suggested, but it seemed over the top for what I wanted. With the census source incorporated into the query, I can further modify it at will to cover different years, different counties etc.

[tatewise]

Did you understand the point about only needing to check %INDI.CENS[year=1841]% instead of existence of the Source record?

It might be safer to check the Title than the Record Id just in case you choose to renumber them later.
Bear in mind that the expressions posted only check the 1st Citation.

The Plugin may be 'over the top' but it already exists, and does the filtering, and provides the commands to search the online Census records, which presumably is your goal. Note that it does not just search by name, but also often with dates, places, and relatives, to narrow the search, but easily edited to adjust the search. Did you actually try it?

See fhugdownloads:queriesindi|> Downloads and Links ~ Query Type: Individual that offers several Census checking Queries that may not do exactly what you want, but contain examples of Column and Row expressions you might learn from.

[Gowermick]

I do understand now, and will try this tommorrow, as I've just found out that not all use the 'Census 1841' source citation. So looking for the actual census fact may be more sensible.

[tatewise]

Are you sure that not all use the 'Census 1841' source citation, by actually checking the Facts tab, or are you relying on the %INDI.CENS[year=1841].SOUR[1]>% data in the Query?

As I said, that only checks the [1]st Source Citation.
If you check %INDI.CENS[year=1841].SOUR[2]>% you may find 'Census 1841' is the [2]nd Source Citation, or maybe even the [3]rd...

What is more sensible depends on your objective, which you have never stated.
If it is to find missing Census Source Citations then you must check for them, and the results will include Census Events without Citations.
If it is to only find missing Census Events then you must check just for them regardless of their Citations.

[Gowermick]

No, i found some rogue entries that used 'Ancestry' as the source. They appeared in the result set because they didn't use 'Census 1841'. I need to change these to 'Census 1841' as and when I find them. (I assume the same will apply to other years too).