Admin tools
Import bibliographies
Loads any prepared works list in
data/ onto the
matching person. Safe to run more than once — it never duplicates an entry.Backfill census occupations
Copies occupations recorded on census entries onto the people
themselves, so they appear in the People page, the group chips and the occupation filter.
Preview first — it shows what it would do without changing anything.
Extract Gazette references
Finds London Gazette links written into biographies and records
them as proper citations with their issue and page.
Search The Gazette for honours
Searches the official record for people whose entry already
suggests an honour or public office — not everyone, because a national record returns a
different person of the same name for most residents. Results are filtered against their
lifetime and appear as suggestions to confirm, never as facts.
Move a household to another property
For a household filed against the wrong house. Moves every
census record from one property to another, and the resident links with them. Leave
to blank to unfile instead, sending the records back to the unresolved queue
when the right address is not yet known. Fill only these people to move one
household out of an address holding several. Preview first — it lists each record by
name and year before anything changes.
→
Recover the slipped source column
A slipped column put "Married, Female" and the like into the
source field, where the provenance should be. Both halves are real: the sex fills a
blank on the person, the marital status moves to its own column. Only then is the
source cleared, so nothing is thrown away.
Backfill birth places onto people
The census entries hold far more birth places than the
person records do. Copies one onto anybody whose own record is blank. Never overwrites,
and leaves alone anyone whose entries disagree with each other.
Remove duplicate resident links
The same person can be linked to the same property twice —
nothing in the database prevents it. Keeps one of each and removes the rest.
Clear occupations that are not occupations
A slipped column in an import leaves a sex or a relationship
in the occupation field, and a spreadsheet's placeholder leaves a dash. "Servant" and
"wife" are plausible enough to survive the filter and skew the occupation counts.
Preview lists every one by name before anything is cleared.
Find rows that are not people
A pasted spreadsheet sometimes brings its own column headings
with it, and they end up filed as residents. This lists any record whose name is a
heading rather than a name, plus any with no name at all. Nothing is deleted — each one
links to its record, where the delete button lives.
Import people
Adds people prepared in
data/ — figures found in
someone else's biography with no record of their own — and links them to their
properties. Matches on name, so it never creates a duplicate.—
Total Properties
—
People Recorded
—
Houses Described
—
Occupations
—
With Photos
—
Houses + People
🏛️
Houses
Loading...
Houses for research
Loading...
👥
People
⚒️
Occupations & Social History
Connect database to see occupation data
🏆
Most Properties on The Park
Connect database to see data