names

17 rows where place_id = 606739

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666361 1915429 1915429 plaintiff Tulye Cecilia widow 606739 606739 Tulye, Cecilia, of Crowmer, Norf, widow 1
3670813 1916836 1916836 defendant Haylys Henry husbandman 606739 606739 Haylys, Henry, of Crowmer, Norf, husbandman 0
3680331 1919925 1919925 defendant Haylys Henry merchant 606739 606739 Haylys, Henry, of Crowmer, Norf, merchant 0
3753940 1943181 1943181 defendant Haykys Henry merchant 606739 606739 Haykys, Henry, of Crowmer, Norf, merchant 0
3820622 1964334 1964334 defendant Hayles Henry merchant 606739 606739 Hayles, Henry, of Crowmer, Norf, merchant 1
3842003 1971054 1971054 defendant Arnold William gent 606739 606739 Arnold, William, of Crowmer, Norf, gent 5
3888167 1986297 1986297 defendant Fenne Robert yeoman 606739 606739 Fenne, Robert, of Crowmer, Norf, yeoman 1
4699358 2265262 2265262 defendant Suffolke Thomas draper 606739 606739 Suffolke, Thomas, of Crowmer, Norf, draper 0
5050474 2371763 2371763 defendant Fowllar Roger mariner 606739 606739 Fowllar, Roger, of Crowmer, Norf, mariner 0
5090161 2383494 2383494 defendant Draper William draper 606739 606739 Draper, William, of Crowmer, Norf, draper 5
5184821 2411310 2411310 defendant Hornyngtoft Warren yeoman 606739 606739 Hornyngtoft, Warren, of Crowmer, Norf, yeoman 0
5204548 2417080 2417080 defendant Hornyngtoft Warren yeoman 606739 606739 Hornyngtoft, Warren, of Crowmer, Norf, yeoman 0
5257117 2432359 2432359 defendant Warde William yeoman 606739 606739 Warde, William, of Crowmer, Norf, yeoman 0
5257122 2432360 2432360 defendant Warde William yeoman 606739 606739 Warde, William, of Crowmer, Norf, yeoman 0
5481177 2499323 2499323 defendant Stronge Robert shipman 606739 606739 Stronge, Robert, of Crowmer, Norf, shipman 2
5514443 2509363 2509363 defendant Elys Adam cooper 606739 606739 Elys, Adam, of Crowmer, Norf, cooper 0
5599844 2534836 2534836 defendant Wode Thomas yeoman 606739 606739 Wode, Thomas, of Crowmer, Norf, yeoman 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);