names

21 rows where place_id = 601762

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646900 1909428 1909428 defendant Roos John husbandman 601762 601762 Roos, John, of Saxham, husbandman 0
3734762 1937117 1937117 defendant Folkys Thomas laborer 601762 601762 Folkys, Thomas, of Saxham, laborer 5
3736666 1937721 1937721 defendant Gilly Robert husbandman 601762 601762 Gilly, Robert, of Saxham, husbandman 1
3750196 1941977 1941977 defendant Newhawe John husbandman 601762 601762 Newhawe, John, of Saxham, husbandman 0
3756220 1943902 1943902 defendant Gille Thomas husbandman 601762 601762 Gille, Thomas, of Saxham, husbandman 3
3904557 1991773 1991773 defendant Peyton Thomas husbandman 601762 601762 Peyton, Thomas, of Saxham, husbandman 1
4303807 2131461 2131461 defendant Croft Thomas esq 601762 601762 Croft, Thomas, of Saxham, esq 0
4448438 2184443 2184443 defendant Hermere Richard   601762 601762 Hermere, Richard, of Saxham 0
4681772 2259911 2259911 defendant Peytenyn Robert chaplain 601762 601762 Peytenyn, Robert, of Saxham, chaplain 0
4704924 2266918 2266918 defendant Wyfford John miller 601762 601762 Wyfford, John, of Saxham, miller 0
4714361 2269821 2269821 defendant Ilger Thomas husbandman 601762 601762 Ilger, Thomas, of Saxham, husbandman 2
4963923 2346121 2346121 plaintiff Chapman John   601762 601762 Chapman, John, of Saxham 0
5159128 2403786 2403786 defendant Kynght Robert husbandman 601762 601762 Kynght, Robert, of Saxham, husbandman 3
5235607 2425996 2425996 defendant Elger John husbandman 601762 601762 Elger, John, of Saxham, husbandman 1
5255982 2431994 2431994 defendant Toppesfeld Ralph gent 601762 601762 Toppesfeld, Ralph, of Saxham, gent 1
5422428 2481656 2481656 defendant Duke Richard husbandman 601762 601762 Duke, Richard, of Saxham, husbandman 1
5442076 2487551 2487551 defendant Duke Richard husbandman 601762 601762 Duke, Richard, of Saxham, husbandman 1
5454815 2491361 2491361 defendant Duke Richard husbandman 601762 601762 Duke, Richard, of Saxham, husbandman 1
5454822 2491362 2491362 defendant Duke Richard husbandman 601762 601762 Duke, Richard, of Saxham, husbandman 1
5454829 2491363 2491363 defendant Duke Richard husbandman 601762 601762 Duke, Richard, of Saxham, husbandman 1
5574681 2527155 2527155 defendant Ylger Robert husbandman 601762 601762 Ylger, Robert, of Saxham, husbandman 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);