names

13 rows where case_id = 2385248

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5095958 2385248 2385248 plaintiff Spirk Thomas     Spirk, Thomas 0
5095959 2385248 2385248 defendant Wacy Simon husbandman 593003 593003 Wacy, Simon, of Bodney, husbandman 0
5095960 2385248 2385248 defendant Basse Robert yeoman 599639 599639 Basse, Robert, of Lycham, yeoman 1
5095961 2385248 2385248 defendant Thornkyn Edmund yeoman 609752 609752 Thornkyn, Edmund, of Beeston, yeoman 2
5095962 2385248 2385248 defendant Kyng Richard husbandman 756620 756620 Kyng, Richard, of Kymberle, husbandman 3
5095963 2385248 2385248 defendant Howard John husbandman 647495 647495 Howard, John, of Ranyngham, husbandman 4
5095964 2385248 2385248 defendant Skrevener John clerk 591104 591104 Skrevener, John, of Runhale, clerk 5
5095965 2385248 2385248 defendant Gayteford Simon husbandman 662331 662331 Gayteford, Simon, of Geystwheyt, husbandman 6
5095966 2385248 2385248 defendant Bocher John husbandman 597384 597384 Bocher, John, of Parva Fraunsham, husbandman 7
5095967 2385248 2385248 defendant Waleys Richard yeoman 589340 589340 Waleys, Richard, of Est Todenham, yeoman 8
5095968 2385248 2385248 defendant Skot William yeoman 587782 587782 Skot, William, of Hokeryng, yeoman 9
5095969 2385248 2385248 defendant Peket Thomas husbndman 587331 587331 Peket, Thomas, of Causton, husbndman 10
5095970 2385248 2385248 defendant Inges Richard husbandman 771609 771609 Inges, Richard, of Wode Rysyng, 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);