names

9 rows where case_id = 2397563

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5137788 2397563 2397563 plaintiff Pye Robert (legal representative)   Pye, Robert, executor of 0
5137789 2397563 2397563 plaintiff Pye John   587058 587058 Pye, John, of Sutton 1
5137790 2397563 2397563 defendant Margetson William husbandman 593810 593810 Margetson, William, of West Retford, husbandman 0
5137791 2397563 2397563 defendant Woller Henry laborer 593810 593810 Woller, Henry, of West Retford, laborer 1
5137792 2397563 2397563 defendant Milford Robert husbandman 851607 851607 Milford, Robert, of Laughton in the mornyng or Laughton en le Morthen, Yorks, husbandman 2
5137793 2397563 2397563 defendant Holmefeld John husbandman 851608 851608 Holmefeld, John, of Anston, Yorsk, husbandman 3
5137794 2397563 2397563 defendant Warde Henry yeoman 587043 587043 Warde, Henry, of Blythe, Notts, yeoman 4
5137795 2397563 2397563 defendant Emore Thomas husbandman 603496 603496 Emore, Thomas, of Plesley, Derbs, husbandman 5
5137796 2397563 2397563 defendant Wode John   631856 631856 Wode, John, of Dronfeld, Derbs, scyth smith 6

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