names

12 rows where place_id = 602387

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649896 1910331 1910331 defendant Goos Henry shoemaker 602387 602387 Goos, Henry, of Bodesdale, shoemaker 2
3662071 1914065 1914065 defendant Wykes William yeoman 602387 602387 Wykes, William, of Bodesdale, yeoman 13
3662091 1914066 1914066 defendant Wykes William yeoman 602387 602387 Wykes, William, of Bodesdale, yeoman 14
3965170 2012428 2012428 defendant Larke Anthony blacksmith 602387 602387 Larke, Anthony, of Bodesdale, blacksmith 0
3976744 2016433 2016433 defendant Lumm John innholder 602387 602387 Lumm, John, of Bodesdale, innholder 0
3992879 2022206 2022206 defendant Tompson Richard yeoman 602387 602387 Tompson, Richard, of Bodesdale, yeoman 0
4091799 2057360 2057360 defendant Harrys Edward husbandman 602387 602387 Harrys, Edward, of Bodesdale, husbandman 2
4091941 2057415 2057415 defendant Harrys Edmund husbandman 602387 602387 Harrys, Edmund, of Bodesdale, husbandman 2
4113781 2065212 2065212 defendant Harvie Edward yeoman 602387 602387 Harvie, Edward, of Bodesdale, yeoman 0
4232086 2106724 2106724 defendant Cocke John innholder 602387 602387 Cocke, John, of Bodesdale, innholder 0
4325175 2138800 2138800 defendant Richardson George husbandman 602387 602387 Richardson, George, of Bodesdale, husbandman 0
5001289 2357257 2357257 defendant Caudeler William chapman 602387 602387 Caudeler, William, of Bodesdale, chapman 0

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