Prompt of the Day – From Census Page to FAN‑club Map

This prompt focuses on one full page (or small set of pages) from a census and your target ancestor on that page. The goal is to turn raw page‑level data into a structured neighborhood/FAN view and a research‑ready checklist.

Paste the prompt into your AI assistant, then paste:

• your page‑level census transcription or exported data, and
• a short note naming your target household(s).

 

<prompt>
 
I will provide a transcription or export of one or more full census pages that include my target ancestor.
The data will include at least: census year, location, dwelling/household number (or line number), names in each household, and, if available, street/address, birthplaces, and occupations.
I will also identify which household(s) contain my target ancestor.
Please complete the following tasks in clearly labeled sections.
1. Standardized neighborhood table
Create a table with one row per household on the page(s).
For each row, include:

Census year and location.

Dwelling or household number (or line range).

Street and house number, if present.

Head of household (name as written, plus a standardized form if obvious).

List of all surnames in the household.

Head’s reported birthplace.

Head’s occupation (if given).

Total number of people in the household.

An indicator for whether this is one of my target households.
If any field is not available, write “not stated” rather than guessing.

2. Surname and birthplace clusters
Using the table, identify:

Surnames that appear in more than one household on these page(s).

Groups of households whose heads share the same state or country of birth.

Any obvious clusters where several adjacent households share both a birthplace pattern and similar occupations.
Present this as short lists or mini‑tables, and briefly describe each cluster (for example, “three adjacent households headed by men born in Ohio, all coal miners”).
Do not infer relationships; just describe patterns.

3. Proximity‑based FAN candidates for my target ancestor
Focusing on the target household(s) I identify, list nearby households that are promising FAN‑club candidates.
Consider households:

On the same page and on the immediately preceding and following pages (if provided).

Above and below the target household, and across the same street if that is apparent from the data.
For each candidate household, provide:

Head of household’s name.

Distance in lines or household numbers from the target.

Any shared surname with the target family.

Any shared birthplace or occupation patterns.

A short note on why this household might belong in the FAN‑club (for example, “same rare surname,” “same birthplace and trade,” “cluster of people from same region”).
Clearly label all of these as candidates, not proven relatives.

4. Neighborhood observations
In no more than 10 bullet points, summarize what this census neighborhood suggests about:

The social and economic context (for example, a street of factory workers, a rural area of small farmers, a mixed boarding‑house area).

Any apparent ethnic, religious, or regional clusters (for example, many heads born in the same foreign country or U.S. state).

How typical or atypical the target household appears compared to its neighbors (in terms of size, occupation, birthplace, etc.).
Base these observations only on the census data I provide.

5. Research‑step checklist for FAN‑club follow‑up
Based on the FAN candidates and neighborhood patterns, list 10–15 specific follow‑up steps to investigate potential connections.
For each step, include:

The specific question (for example, “Is Household 23 head John Schmidt a brother of my ancestor?”).

The record types that could help answer it (for example, land records, city directories, church registers, naturalization records, probate, tax lists, marriage records, local histories).

Whether the step is based primarily on shared surname, shared birthplace, shared occupation, shared migration pattern, or mere proximity.

Important constraints:

Do not assert any familial relationships as facts unless they are explicitly stated in the census data I provide.

Treat all connections as hypotheses for me to confirm with other records.

Preserve at least one version of each name and place exactly as spelled, even if you also give a standardized form.

I will now paste the census page data, followed by the name(s) of my target household(s).

</prompt> 

1. Once you run this:

   • You can paste the neighborhood table into a spreadsheet or FAN‑tracking worksheet.

   • The cluster lists and proximity‑based candidates become the backbone of a FAN‑club research log for that place and period.

   • The research‑step checklist plugs neatly into a project plan or a teaching handout on using census neighbors to tackle brick walls.