US-UK-Canadian Census Report Extension

This extension cycles through census events for US, UK or Canada for every individual in the current database or for just selected individuals. It creates a color-code table of census events to help you view and improve your census research.

Getting Census Report

To get a census report:

  1. Choose "US-UK-Canadian Census Report" from the Extensions menu.
  2. You can choose two styles for the report. The "one large table" shows all results in a standard html table. The table with "searching options" shows the report (in a scrollable subfield if it is large) and has a "Search" field. It has additional features:
  3. Choose which census data to examine and click "All" or "Selected" to look for census reports in all records or just the currently selected records, respectively. Note that if your data has individuals from more than one of the listed countries, it is usually best to preselect records from just one country and then use the "Selected" option to get the report.
  4. You will then be prompted to enter a maximum age. This is the age after which individuals are assumed to be probably dead (if death date is not available)
  5. Finally, click "OK" and the report will be generated. A window will appear showing percentage progress while creating the report.

The Color-Coded Census Table

The census report appears in a table. Each row of the table has information for one individual giving their name, birth, and death dates. The rest of the row will have a cell for each census examined. The cells will be colored coded and some will have census place information as follows:

Below is a key to the colors used in the table. The dark green are done. The light green are done as well, but it would be better to open that event and enter the place for the census event (to get to the event, click the person's name and then look in the "Events" tab). To research for new census information, you should start with amber cells and then move through red cells in order of their red intensity. You can ignore all grey cells because that person will not be in that census.

Census Report Colors
Census done, place entered
Census done, place not entered
Alive, not done
Alive likelihood = 8, not done
Alive likelihood = 7, not done
Alive likelihood = 6, not done
Alive likelihood = 5, not done
Alive likelihood = 4, not done
Alive likelihood = 3, not done
Alive likelihood = 2, not done
Alive likelihood = 1, not done
Not Alive

Hints on Use

The census dates are looked up by date and not place. Although the script has dates for census data from US, UK, or Canada, the events can get confused when individuals are from multiple countries and dates used in census events are imprecise. For best results, therefore, you should usually run this extension on selected individuals and when using it select individuals known to be in the country of interest. Here is a good way to achieve this goal:

  1. Open the search window and search for "Any Place" "contains" the country name such as "United States," "United Kingdom," or "Canada." (or whatever text you used to enter those countries in your place names).
  2. When found, save all search hits in a new album
  3. Select all records in that album, run this extension, and chose "Selected" individuals

Acknowledgement

This report was designed and written by Simon Robbins.