names

10 rows where case_id = 2345497

✎ 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
4961826 2345497 2345497 plaintiff Boynton Christopher     Boynton, Christopher 0
4961827 2345497 2345497 defendant Smythson John husbandman 641375 641375 Smythson, John, of Gillyng, husbandman 0
4961828 2345497 2345497 defendant Esyk Richard slater 641375 641375 Esyk, Richard, of Gillyng, slater 1
4961829 2345497 2345497 defendant Prestman John husbandman 590061 590061 Prestman, John, of Barton, husbandman 2
4961830 2345497 2345497 defendant Welbank John husbandman 820869 820869 Welbank, John, of Coweton, husbandman 3
4961831 2345497 2345497 defendant Potter John yeoman 820869 820869 Potter, John, of Coweton, yeoman 4
4961832 2345497 2345497 defendant Walker John yeoman 815003 815003 Walker, John, of Leyburn, yeoman 5
4961833 2345497 2345497 defendant Walker Thomas yeoman 815003 815003 Walker, Thomas, of Leyburn, yeoman 6
4961834 2345497 2345497 defendant del Wraa Henry herder 827823 827823 del Wraa, Henry, of Gille in Wenselawedale, herder 7
4961835 2345497 2345497 defendant Skarre Hugh yeoman 777543 777543 Skarre, Hugh, of Ayscogh, yeoman 8

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