names

13 rows where case_id = 2418614

✎ 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
5209841 2418614 2418614 plaintiff Stafford Humphrey esq   Stafford, Humphrey, esq 0
5209842 2418614 2418614 defendant Baron Thomas carpenter 588135 588135 Baron, Thomas, of Somerton, carpenter 0
5209843 2418614 2418614 defendant Godyholde Walter   772880 772880 Godyholde, Walter, of Eggeford, groom 1
5209844 2418614 2418614 defendant Gybon Thomas husbandman 772880 772880 Gybon, Thomas, of Eggeford, husbandman 2
5209845 2418614 2418614 defendant Broun William husbandman 612586 612586 Broun, William, of Bekyngton, husbandman 3
5209846 2418614 2418614 defendant Stevenes John weaver 602962 602962 Stevenes, John, of Lullyngton, weaver 4
5209847 2418614 2418614 defendant Pegge John husbandman 623490 623490 Pegge, John, of Myllys, husbandman 5
5209848 2418614 2418614 defendant Frencheman William   606659 606659 Frencheman, William, of Mellys, servant 6
5209849 2418614 2418614 defendant Lyngcoll William jun, of West Chynnok, husbandman   Lyngcoll, William, jun, of West Chynnok, husbandman 7
5209850 2418614 2418614 defendant Sex Thomas   765427 765427 Sex, Thomas, of East Chynnok, husb 8
5209851 2418614 2418614 defendant Broune John husbandman 600346 600346 Broune, John, of Hardyngton, husbandman 9
5209852 2418614 2418614 defendant Nicolas John laborer 699018 699018 Nicolas, John, of Oterhampton, laborer 10
5209853 2418614 2418614 defendant Walsheman Thomas husbandman 699018 699018 Walsheman, Thomas, of Oterhampton, husbandman 11

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