Individual Queries – Page 2 – Family Historian User Group

Sub Categories

How Related – Between 2 Individuals: “How Related” is a query that gives the relationship(s) between two selected individuals (“Starting Person” and “Ending Person”)
Individuals updated in recent days: Simple query which prompts for a number of days and then lists only records updated in the period for the days entered
Kinsfolk Census Done Report: This query evolved from the earlier Census – The Missing Years download
Kinsfolk Census To Do Table: This query evolved from the earlier Census – The Missing Years download
Line of Ascent: The query will list the direct line of ascent from the “Starting Person” to the “Ending Person”
Line of Descent: The query will list the direct line of descent from the “Starting Person” to the “Ending Person”
Linked Individuals: Returns a person of interest together with all of the people connected to them
List Single Relation Pool: Prompts for a Relation Pool number and lists all members of that pool
Living in List: Simple Query which lists everyone in a Named List called “Living”, that can be used in conjunction with the Split Tree function
Living List: Can be used to load the Individual Records Window with a column of tick boxes for a “Living” Named List
Living List Create: Query to attempt to identify all living people, that can be used to create a “Living” Named List
Location: Shows the Date and Place of Birth plus the Date and Place of Death locations for every person
Male Lines: This Query selects only male descendants of a male start person
Marriage Not Found: This Query displays: Individuals with a specific surname Individuals who have no marriage recorded Probable earliest marriage date (say 15 yrs after birth) Probable latest marriage date (say 60 yrs of age) Census place (if known) for nearest census before earliest marriage date and for each census year up to latest marriage date It excludes: […]
Married Women: List of Married Women by married name with Date of Birth and Marriage
Married Women Names: List of Married Women by married name with Date of Birth and Marriage
Missing Certificates – Ancestors: This Query shows the Birth, Marriage, Death and source information of all the Ancestors of a selected person
Missing Statutory Birth Certificate: A checklist to identify individuals where birth dates are not fully recorded (estimates, ranges, etc), and may indicate certificates still to be sourced
Missing Statutory Death Certificate: A checklist to identify individuals where death dates are not fully recorded (estimates, ranges, etc), and may indicate certificates still to be sourced
More Than One Parental Family: Query to identify possible duplicate individuals through their children
Most Recent Common Ancestors: This Query asks you to select 2 people and the Result Set should include the originally selected people and their most recent common ancestors
Name Search: This Query is designed predominantly for finding women, as it searches by Surname and “contained in” Given Names, but includes women who match the pattern, by the fact that one of the first 5 husbands had that Surname
Name Search with Dates: This Query is designed predominately for finding women, as it searches by Surname and “contained in” Given Names or Nick Name, but includes women who match the pattern, by the fact that one of the first 5 husbands had that Surname
Nicknames: Identifies all people with Nicknames – for use when the first Given Name cannot be recalled
No Family As Child (Orphan?): Find all people without a “family as child” i
Occupations: Query selects all people with one or more Occupations sorted by name
Occupations List: Displays Occupation information recorded for Individuals
ONS – [given] born in [place]: One-Name Study query selecting Individuals by their place of birth
ONS – [given] census in [place]: One-Name Study query selecting Individuals who appear in census records for a specific place
ONS – [given] child of [given]: One-Name Study query selecting Individuals by the given name(s) of their father or mother
ONS – [given] married to [given]: One-Name Study query selecting married couples by their given names
ONS – [given] sibling of [given]: One-Name Study query selecting Individuals by the given name(s) of one of their siblings
ONS – [surname] married to [surname]: One-Name Study query selecting married couples by their surnames
Parent Ages: Lists Individuals sorted by name, whose birth occurred when either parent was potentially too young (<16), or old (father >65 or mother >50), or may have already died
People at a Place before 1837: Lists all the people who have a primary life event – currently includes Birth, Baptism, Christening, (first) Marriage, Death, Burial – that is recorded at an identified PLACE (not Address or Residence) e
People Linked to Source: Lists people linked to a Source, which have been changed since a specific date
Person Existence Check: Enter a “Surname” and “Forename” and this Query Lists all people who match
Pinpoint by Location: This identifies relevant Records by reviewing Name (or part of Name), a Birth year range and location, such as a Place name (or part of a Place name)
Pinpoint Using Parents: This identifies relevant Records by reviewing Parents’ names in a large dataset containing many individuals with the same name and/or variant surnames
Places: This query allows the selection of a “Place” and then displays all individuals who have life events – Birth, Baptism, 1st Marriage, Death, Burial – in that Place
Places of Burial: Lists all individuals with a Burial event where a Place is present
Private Flag is Set: Query to select all persons with the Private Flag Set – useful for using with Mark and Select on Diagrams to hide Private people
Ready for Census 1921: This query allows you to create a list of those ancestors with a specified surname who might appear in the 1921 Census
Record IDs (Superseded): Simple Query sorting individual records by Custom Id and standard Record Id, as well as listing Automated Record Id and Permanent Record Number
Records Window with Parents: Simple Query showing both Parents Preferred Names
Records Window with Spouse Surname: Individual Records Window based Query columns as per the installation configuration, but with additional “Spouse Surname” column
Relations – Same Generation: Simple custom query to list all the relations who are in the same generation as a specified person
Search For Orphans: This is based on the standard Search For Orphans Query, but only lists records that have no Family as Child and no Family as Spouse information recorded
Single Surname: Lists all people that match exactly with a selected “Surname”
Sort by Initials: Query to sort Individuals by their First and Middle names, where the initials match “First Initial” and “Middle Initial” parameter prompts