names

16 rows where case_id = 2483720

✎ 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
5429367 2483720 2483720 plaintiff Graynevyle Thomas esq   Graynevyle, Thomas, esq 0
5429368 2483720 2483720 plaintiff Stukeley Nicholas esq   Stukeley, Nicholas, esq 1
5429369 2483720 2483720 plaintiff Ferrers Martin     Ferrers, Martin 2
5429370 2483720 2483720 defendant Yeo William gent 603080 603080 Yeo, William, of Bradworthy, gent 0
5429371 2483720 2483720 defendant Wode John husbandman 603080 603080 Wode, John, of Bradworthy, husbandman 1
5429372 2483720 2483720 defendant Parkman Thomas husbandman 603080 603080 Parkman, Thomas, of Bradworthy, husbandman 2
5429373 2483720 2483720 defendant Hurde Robert   603080 603080 Hurde, Robert, of Bradworthy, groom 3
5429374 2483720 2483720 defendant Gilberd John husbandman 609984 609984 Gilberd, John, of Pyworthy, husbandman 4
5429375 2483720 2483720 defendant Wayte Thomas husbandman 609984 609984 Wayte, Thomas, of Pyworthy, husbandman 5
5429376 2483720 2483720 defendant Jule John husbandman 788018 788018 Jule, John, of Claweton, husbandman 6
5429377 2483720 2483720 defendant Surdecote Robert yeoman 592141 592141 Surdecote, Robert, of Shepewasshe, yeoman 7
5429378 2483720 2483720 defendant Loder Hugh yeoman 592141 592141 Loder, Hugh, of Shepewasshe, yeoman 8
5429379 2483720 2483720 defendant Walshe Thomas tailor 592141 592141 Walshe, Thomas, of Shepewasshe, tailor 9
5429380 2483720 2483720 defendant Lambell Richard husbandman 592141 592141 Lambell, Richard, of Shepewasshe, husbandman 10
5429381 2483720 2483720 defendant Pote John husbandman 592141 592141 Pote, John, of Shepewasshe, husbandman 11
5429382 2483720 2483720 defendant Tosbe Walter husbandman 592141 592141 Tosbe, Walter, of Shepewasshe, 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);