names

26 rows where place_id = 658138

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3947176 2006078 2006078 defendant Elyet John husbandman 658138 658138 Elyet, John, of Tyntenhull, husbandman 0
3964387 2012149 2012149 defendant Napper Nicholas husbandman 658138 658138 Napper, Nicholas, of Tyntenhull, husbandman 0
4013065 2029404 2029404 defendant Napper Nicholas yeoman 658138 658138 Napper, Nicholas, of Tyntenhull, yeoman 0
4056972 2044876 2044876 plaintiff Gyll John yeoman 658138 658138 (Gyll, John, of Tyntenhull, yeoman 1
4092153 2057490 2057490 defendant Tucker Robert husbandman 658138 658138 Tucker, Robert, of Tyntenhull, husbandman 0
4092154 2057490 2057490 defendant Napper James husbandman 658138 658138 Napper, James, of Tyntenhull, husbandman 1
4092155 2057490 2057490 defendant Napper Launce husbandman 658138 658138 Napper, Launce, of Tyntenhull, husbandman 2
4096444 2059056 2059056 defendant Gyll John yeoman 658138 658138 Gyll, John, of Tyntenhull, yeoman 1
4108621 2063339 2063339 defendant Tucker Robert husbandman 658138 658138 Tucker, Robert, of Tyntenhull, husbandman 0
4129886 2071000 2071000 defendant Tucker Robert husbandman 658138 658138 Tucker, Robert, of Tyntenhull, husbandman 0
4135740 2073111 2073111 defendant Tucker Robert husbandman 658138 658138 Tucker, Robert, of Tyntenhull, husbandman 0
4135741 2073111 2073111 defendant Napper James yeoman 658138 658138 Napper, James, of Tyntenhull, yeoman 1
4152351 2078932 2078932 defendant Gill John yeoman 658138 658138 Gill, John, of Tyntenhull, yeoman 0
4192082 2092791 2092791 defendant Gyll John husbandman 658138 658138 Gyll, John, of Tyntenhull, husbandman 1
4207174 2098055 2098055 defendant Napper James yeoman 658138 658138 Napper, James, of Tyntenhull, yeoman 0
4454083 2186295 2186295 defendant Saundres John   658138 658138 Saundres, John, of Tyntenhull 0
4457762 2187441 2187441 defendant Saundres John   658138 658138 Saundres, John, of Tyntenhull 0
4463298 2189214 2189214 plaintiff Trot Nicholas   658138 658138 Trot, Nicholas, of Tyntenhull 0
4463299 2189214 2189214 defendant Saundres John   658138 658138 Saundres, John, of Tyntenhull 0
4489855 2197534 2197534 defendant Saundres John   658138 658138 Saundres, John, of Tyntenhull 0
4506494 2202529 2202529 defendant Smyth Roger   658138 658138 Smyth, Roger, of Tyntenhull 0
4506495 2202529 2202529 defendant Strech John   658138 658138 Strech, John, of Tyntenhull 1
4623881 2238447 2238447 defendant Houchones William   658138 658138 Houchones, William, of Tyntenhull 0
4623883 2238448 2238448 defendant Houchouns William   658138 658138 Houchouns, William, of Tyntenhull 0
4678479 2258878 2258878 defendant Axall John husbandman 658138 658138 Axall, John, of Tyntenhull, husbandman 0
4678487 2258878 2258878 defendant Bouryng Robert husbandman 658138 658138 Bouryng, Robert, of Tyntenhull, husbandman 8

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);