names

24 rows where place_id = 761414

✎ 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
4476160 2193209 2193209 plaintiff Fournour William (legal representative) 761414 761414 Fournour, William, of Axebrugge, executor of 0
4476168 2193210 2193210 plaintiff Fournour William (legal representative) 761414 761414 Fournour, William, of Axebrugge, executor of 0
4478737 2194016 2194016 defendant Haynes John tanner 761414 761414 Haynes, John, of Axebrugge, tanner 1
4484236 2195770 2195770 defendant Payn Robert   761414 761414 Payn, Robert, of Axebrugge 0
4494821 2199069 2199069 defendant Clere Stephen   761414 761414 Clere, Stephen, of Axebrugge 0
4494822 2199069 2199069 defendant Do--- Edward   761414 761414 Do---, Edward, of Axebrugge 1
4544874 2214316 2214316 defendant Bray John   761414 761414 Bray, John, of Axebrugge 0
4551530 2216418 2216418 defendant Diere Robert   761414 761414 Diere, Robert, of Axebrugge 2
4556786 2218057 2218057 defendant Wynchecombe John   761414 761414 Wynchecombe, John, of Axebrugge 0
4570876 2222458 2222458 defendant Roudon Peter   761414 761414 Roudon, Peter, of Axebrugge 0
4583860 2226369 2226369 defendant Furnour Robert   761414 761414 Furnour, Robert, of Axebrugge 0
4590715 2228449 2228449 defendant Tannere John   761414 761414 Tannere, John, of Axebrugge 0
4676409 2258232 2258232 defendant Yevan John tanner 761414 761414 Yevan, John, of Axebrugge, tanner 0
4676410 2258232 2258232 defendant Payn William tanner 761414 761414 Payn, William, of Axebrugge, tanner 1
4676412 2258233 2258233 defendant Yevan John tanner 761414 761414 Yevan, John, of Axebrugge, tanner 0
4812384 2299985 2299985 defendant Baker Nicholas baker 761414 761414 Baker, Nicholas, of Axebrugge, baker 0
5081388 2380939 2380939 defendant Wethir John tucker 761414 761414 Wethir, John, of Axebrugge, tucker 0
5081389 2380939 2380939 defendant Hayn John tucker 761414 761414 Hayn, John, of Axebrugge, tucker 1
5081391 2380939 2380939 defendant Gryce John tucker 761414 761414 Gryce, John, of Axebrugge, tucker 3
5106883 2388441 2388441 defendant Hayne John merchant 761414 761414 Hayne, John, of Axebrugge, merchant 0
5123071 2393182 2393182 defendant Forst John yeoman 761414 761414 Forst, John, of Axebrugge, yeoman 0
5125787 2394027 2394027 defendant Payn John merchant 761414 761414 Payn, John, of Axebrugge, merchant 1
5165191 2405562 2405562 defendant Payn Thomas tanner 761414 761414 Payn, Thomas, of Axebrugge, tanner 0
5165192 2405562 2405562 defendant Payn John merchant 761414 761414 Payn, John, of Axebrugge, merchant 1

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