names

16 rows where case_id = 2459386

✎ 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
5347524 2459386 2459386 plaintiff Berkeley William esq 592976 592976 Berkeley, William, of Beverston, esq 0
5347525 2459386 2459386 defendant Hille Maurice yeoman 597083 597083 Hille, Maurice, of Olveston, yeoman 0
5347526 2459386 2459386 defendant Puffe William husbandman 597083 597083 Puffe, William, of Olveston, husbandman 1
5347527 2459386 2459386 defendant Broun Walter husbandman 597083 597083 Broun, Walter, of Olveston, husbandman 2
5347528 2459386 2459386 defendant Gyde Henry husbandman 597083 597083 Gyde, Henry, of Olveston, husbandman 3
5347529 2459386 2459386 defendant Colyne Richard husbandman 872702 872702 Colyne, Richard, of Auste, husbandman 4
5347530 2459386 2459386 defendant Godman John, junior husbandman 597083 597083 Godman, John, junior, of Olveston, husbandman 5
5347531 2459386 2459386 defendant Brigge William husbandman 782067 782067 Brigge, William, of Tidryngton, husbandman 6
5347532 2459386 2459386 defendant Brygge Richard laborer 782067 782067 Brygge, Richard, of Tidryngton, laborer 7
5347533 2459386 2459386 defendant Hegys Thomas of Aloweston laborer   Hegys, Thomas of Aloweston, laborer 8
5347534 2459386 2459386 defendant Levy or Leny John laborer 669174 669174 Levy or Leny, John, of Aylberton, laborer 9
5347535 2459386 2459386 defendant Lenche Richard laborer 782067 782067 Lenche, Richard, of Tidryngton, laborer 10
5347536 2459386 2459386 defendant Haynes John husbandman 782428 782428 Haynes, John, of Laurens Weston, husbandman 11
5347537 2459386 2459386 defendant Wyllys John laborer 597083 597083 Wyllys, John, of Olveston, laborer 12
5347538 2459386 2459386 defendant More John laborer 669174 669174 More, John, of Aylberton, laborer 13
5347539 2459386 2459386 defendant Dymerey John husbandman 868361 868361 Dymerey, John, of Aloweston, husbandman 14

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