names

16 rows where place_id = 775703

✎ 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
4625817 2239026 2239026 defendant Pound William   775703 775703 Pound, William, of Kyngeston, upon Hull 0
4714490 2269861 2269861 defendant Founteney William merchant 775703 775703 Founteney, William, of Kyngeston, upon Hull, merchant 1
4743550 2278641 2278641 defendant Swynflete Isabel widow of John Swynflete 775703 775703 Swynflete, Isabel, of Kyngeston, upon Hull, widow of John Swynflete 1
4845769 2310186 2310186 defendant Marchall Thomas merchant 775703 775703 Marchall, Thomas, of Kyngeston, upon Hull, merchant 0
4916888 2331783 2331783 defendant Serby Agnes widow 775703 775703 Serby, Agnes, of Kyngeston, upon Hull, widow 0
4923740 2333867 2333867 defendant Ripley Richard chapman 775703 775703 Ripley, Richard, of Kyngeston, upon Hull, chapman 0
5001919 2357461 2357461 defendant Arkylby John merchant 775703 775703 Arkylby, John, of Kyngeston, upon Hull, merchant 0
5005704 2358564 2358564 defendant Forster William merchant 775703 775703 Forster, William, of Kyngeston, upon Hull, merchant 1
5005705 2358564 2358564 defendant Percy Robert merchant 775703 775703 Percy,Robert, of Kyngeston, upon Hull, merchant 2
5153793 2402269 2402269 plaintiff Hadelsey John   775703 775703 Hadelsey, John, of Kyngeston, upon Hull 1
5156398 2403024 2403024 defendant Dobson Richard mariner 775703 775703 Dobson, Richard, of Kyngeston, upon Hull, mariner 0
5171069 2407262 2407262 plaintiff Hadelsey John   775703 775703 Hadelsey, John, of Kyngeston, upon Hull 1
5191032 2413119 2413119 defendant Bussell Roger merchant 775703 775703 Bussell, Roger, of Kyngeston, upon Hull, merchant 0
5191180 2413162 2413162 defendant Bussell Roger merchant 775703 775703 Bussell, Roger, of Kyngeston, upon Hull, merchant 0
5207995 2418072 2418072 defendant Etton Thomas merchant 775703 775703 Etton, Thomas, of Kyngeston, upon Hull, merchant 4
5208003 2418073 2418073 defendant Etton Thomas merchant 775703 775703 Etton, Thomas, of Kyngeston, upon Hull, merchant 5

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