names

14 rows where case_id = 2355926

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4996878 2355926 2355926 plaintiff Hawe John     Hawe, John 0
4996879 2355926 2355926 defendant Miller Roger miller 832574 832574 Miller, Roger, of Euston, Suffolk, miller 0
4996880 2355926 2355926 defendant Howys Edmund husbandman 603315 603315 Howys, Edmund, of Great Melton, husbandman 1
4996881 2355926 2355926 defendant Combys Simon husbandman 586364 586364 Combys, Simon, of Long Stratton, husbandman 2
4996882 2355926 2355926 defendant Goodwyn Thomas smith 782337 782337 Goodwyn, Thomas, of Carleton by Langele, smith 3
4996883 2355926 2355926 defendant Brond Robert husbandman 585936 585936 Brond, Robert, of Norwich, husbandman 4
4996884 2355926 2355926 defendant Cook Geoffrey husbandman 794550 794550 Cook, Geoffrey, of Spronston, husbandman 5
4996885 2355926 2355926 defendant Topias John husbandman 799802 799802 Topias, John, of Heygham by Norwich, husbandman 6
4996886 2355926 2355926 defendant Turnour John turner 606209 606209 Turnour, John, of Wyndham, turner 7
4996887 2355926 2355926 defendant Elsyng John husbandman 756620 756620 Elsyng, John, of Kymberle, husbandman 8
4996888 2355926 2355926 defendant Balle John husbandman 586005 586005 Balle, John, of Upton, husbandman 9
4996889 2355926 2355926 defendant Baron John baker 759963 759963 Baron, John, of Lodne, baker 10
4996890 2355926 2355926 defendant Wysman John husbandman 606209 606209 Wysman, John, of Wyndham, husbandman 11
4996891 2355926 2355926 defendant Everard John   585936 585936 Everard, John, of Norwich, mason 12

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