*More query help please

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

More query help please

Post by E Wilcock » 20 Jul 2019 08:49

Mike kindly coached me in fact queries. i.e. queries that allow an individual to be listed more than once.
But I seem a bit lost with individual queries.

I would like to find married women with children in the census household but whose husbands are not listed in the same census household. That may be due to death, divorce, army service, occupation, prison.

My assumption is that if I expect each individual to appear only once, it is simpler to use an individual query, as it is easier to set up the columns one wants.

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 20 Jul 2019 09:39

In this case it might actually be easier to use a Family Query as each Family record has links to the Spouses & Children.
Nevertheless, I have not yet ruled out an Individual Query or a Fact Query as the easiest solution.

However, before going any further, the details of the Query depend on how each household is associated with each Census.
Does each Individual record have a Census Event with the same Date, Place, Address and Source Citation?
OR are the Individual records associated by Fact Witness links to the head of household Census Event?

One thing is certain, the Rows tab will need multiple filters, one for each Census[year], and that may not work satisfactorily for the cases where people are in both the 1939 UK Register and 1939 German Census.
Thus it may need a Plugin rather than a Query to produce perfect results, or if the filters get too complex.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 20 Jul 2019 10:09

Mike I am looking at only one census.
I need to single out by a particular town. I have already, through an individual query, included only people with a census entry for that date and that place.

I dont have witnesses at all. I have not used ancestral sources in these place studies.

My method in the place studies is (I think I was advised to do this as a newbie)
I enter the census for the head of household. I put the census address in the place field. I add the general source for that census and then paste the place field contents into the text from source field.

I then copy that census event (with its citation and text from source field) and paste it into as many other people as I need, all the occupants of that house.

Any other information from the census about an individual e.g. birth date, birth place, occupation, goes into a specific event or attribute of its own.

A subsequent text search (binocular icon) by the address brings up every person listed at that address, even if they are not related.

This system which I think either you or Jane taught me works extremely well.

I cannot be sure that the source citation will be identical for everyone in this particular census as I started by reading films (page images) so entered film numbers and eventually the census went on line first as a partial transcript and later as a much fuller transcript.

Now as more databases have come on line, I am interested in finding the number of absent fathers and may be tracking them down.

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 20 Jul 2019 10:10

There is no hurry - this can easily wait till next week. I dont want to spoil your weekend.

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 20 Jul 2019 11:12

Can I suggest a slightly different approach.
Use a Query to create a Named List of all Males with a Spouse (and a Child if that is important).
Then use the Lookup Missing Census Facts Plugin and for Choose the Individuals to investigate choose Anyone via the Select Records dialogue and select the Named List.
You can also review the other options to select certain Census Records and lookup web sites.

In the resulting browser window click on any web site column header to sort into Census date order.
Then scroll down to the desired Census year and the fathers of interest should all be there and the links to search the popular online records ready to be used.

There will also be a FH Result Set of fathers of interest, but covering all Census years.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 20 Jul 2019 13:57

My aim is somewhat different Mike. To find the number of women listed with their children and no husband.

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 20 Jul 2019 14:12

Sorry, I assumed your last statement:
Now as more databases have come on line, I am interested in finding the number of absent fathers and may be tracking them down.
meant you wanted to search online to track down their census records.

I'll look at it next week.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 21 Jul 2019 17:49

I've found time to work on this and think I have a Family Query for you.
See attached Family in Census without Husband.fhq custom query.

It prompts for the Census Date and Census Place that identifies the Census.
The Census Place only needs to partially match with the Place field contents.

If the Wife and at least one of the first 9 Children have a Census Event for the chosen Date and Place, but the Husband does not, then that Family is listed in the Result Set.
It would be easy to check the Wife's or Husband's Father or Mother in addition to the 9 Children.

The Row filters have to use the quite complex GetField(...) function to incorporate the Year extracted from the Census Date into the CENS[year=yyyy] special index so that the correct event instance is selected.
Attachments
Family in Census without Husband.fhq
(6.6 KiB) Downloaded 4 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 22 Jul 2019 08:17

Mike, that is so kind of you and a brilliant help. I didnt understand that it was so complicated.

I didnt want to trouble you by posting again over the weekend but I believed that I had managed this with an individual query. Your query is better as divorced husbands may be elsewhere in the same town. But I would appreciate your looking through my query rows.

First to add if female.
Then exclude unless the census place contains xxxx.
Then exclude if husband's census place also contains xxxx
Then exclude unless birth date was before 1918 (removes any children in the households)
Then exclude if the woman has no children.

It leaves me with a list of mothers on their own with children whose husbands are elsewhere - in the armed forces, emigrated to USA, in prison etc. or divorced or dead.
For people who might want to look at the 1939 register but whose family projects include censuses for other years, one could narrow it further by Census year.

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 22 Jul 2019 10:25

It is difficult to review your Query filter Rows without the actual Expressions.
However, there are numerous potential problems.

How are you selecting the appropriate instance of the multiple Census Events that any Individual may have?
e.g. Are you using such as %INDI.CENS[year=1901].PLAC% for census in 1901?

How are you coping with multiple husbands where the woman has remarried, i.e. multiple FAMS[n] or ~SPOU[n]?

How are you coping with children from 2nd or subsequent Family partnerships?

Those complications are why I chose a Family Query as that reviews every Wife, Husband, Children relationship.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 22 Jul 2019 10:47

Thank you Mike. You have provided for proper family historians.

Since I am looking at only one town in one particular census my needs are much narrower.
I have snipped an image of my rows but clearly am not very expert at editing snips to remove the town name. I dont seem to have my wits about me today and cant now remember why I wrote it like that.
My idea was to find women on their own and then check for divorces which in Germany are entered on the marriage certificates..
querycensus2JPG.JPG
querycensus2JPG.JPG (28.09 KiB) Viewed 282 times

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 22 Jul 2019 11:01

So are you saying that each person has at most only one Census Event?

Your Query is only ever looking at first CENS[1] instance.

Your Query only looks at the first Family FAMS[1] so if the woman has multiple partnerships/marriages FAMS[2], etc, the later husbands & children are ignored.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 22 Jul 2019 12:25

They only have one census event in that town. Because this is a place study.
But you are right, there might be women with more than one husband. That will affect both rows and columns.

User avatar
tatewise
Megastar
Posts: 16175
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: More query help please

Post by tatewise » 22 Jul 2019 18:03

Forget about the town.
Is it possible that some people (wives, husbands, children) in the Project may have more than one Census Event?
If so, then your Query filters are not working correctly for all cases.

I would be interested in how your Individual Query Result Set compares with my Family Query Result Set.
Is there an extensive overlap?
Does yours list wives/husbands than mine does not, and vice versa?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

E Wilcock
Megastar
Posts: 855
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: More query help please

Post by E Wilcock » 23 Jul 2019 17:26

Sorry Mike. I will get back to this. But other things intervening with school holidays etc. just now.

Post Reply