names

15 rows where case_id = 2284129

✎ 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
4762089 2284129 2284129 plaintiff (not given) Andrew prior of Faukes 587414 587414 Faukes, Andrew, of Thetford, prior of the brotherhood 0
4762090 2284129 2284129 plaintiff Henley Stephen   587414 587414 Henley, Stephen, of Thetford, a brother preacher 1
4762091 2284129 2284129 defendant Rudham Walter   607800 607800 Rudham, Walter, of Berdewell 0
4762092 2284129 2284129 defendant Parmafay John   607800 607800 Parmafay, John, of Berdewell 1
4762093 2284129 2284129 defendant Gleder John   760868 760868 Gleder, John, of Nether Rekynghale 2
4762094 2284129 2284129 defendant Wolleman Thomas   586143 586143 Wolleman, Thomas, of Norton 3
4762095 2284129 2284129 defendant Taillour Richard   586143 586143 Taillour, Richard, of Norton 4
4762096 2284129 2284129 defendant Caton John   595209 595209 Caton, John, of Bernham 5
4762097 2284129 2284129 defendant Broke John   586346 586346 Broke, John, of Langham 6
4762098 2284129 2284129 defendant Porte John   798483 798483 Porte, John, of Hoveweton 7
4762099 2284129 2284129 defendant Souser John   607800 607800 Souser, John, of Berdewell, vicar 8
4762100 2284129 2284129 defendant Balhed Thomas gent 587921 587921 Balhed, Thomas, of Stanton, gent 9
4762101 2284129 2284129 defendant Mannyng Walter husbandman 586143 586143 Mannyng, Walter, of Norton, husbandman 10
4762102 2284129 2284129 defendant Poye Peter husbandman 586308 586308 Poye, Peter, of Walsham, husbandman 11
4762103 2284129 2284129 defendant del Kechen Robert husbandman 586306 586306 del Kechen, Robert, of Ixworth, husbandman 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);