names

14 rows where case_id = 2535097

✎ 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
5600667 2535097 2535097 plaintiff Huby Marmaduke abbot of Fountains Abbey   Huby, Marmaduke, abbot of Fountains Abbey 0
5600668 2535097 2535097 defendant Holme James husbandman 904615 904615 Holme, James, of Helthwate, Herwod, husbandman 0
5600669 2535097 2535097 defendant Wharton William husbandman 904615 904615 Wharton, William, of Helthwate, Herwod, husbandman 1
5600670 2535097 2535097 defendant Wilson Simon husbandman 904615 904615 Wilson, Simon, of Helthwate, Herwod, husbandman 2
5600671 2535097 2535097 defendant Wade John carpenter 904616 904616 Wade, John, of Dunkeswik, Herwod, carpenter 3
5600672 2535097 2535097 defendant Flesshour Robert husbandman 904616 904616 Flesshour, Robert, of Dunkeswik, Herwod, husbandman 4
5600673 2535097 2535097 defendant Flesshour William husbandman 608909 608909 Flesshour, William, of Dunkeswik, husbandman 5
5600674 2535097 2535097 defendant Cragge Richard husbandman 608909 608909 Cragge, Richard, of Dunkeswik, husbandman 6
5600675 2535097 2535097 defendant Suttell Richard husbandman 595178 595178 Suttell, Richard, of Weton, husbandman 7
5600676 2535097 2535097 defendant Knyghtson John husbandman 595178 595178 Knyghtson, John, of Weton, husbandman 8
5600677 2535097 2535097 defendant Fletcher John husbandman 595178 595178 Fletcher, John, of Weton, husbandman 9
5600678 2535097 2535097 defendant Roodes Parcival husbandman 601642 601642 Roodes, Parcival, of Westowe, husbandman 10
5600679 2535097 2535097 defendant Heirfeld Richard laborer 904614 904614 Heirfeld, Richard, of Helstanbotham, Otley, laborer 11
5600680 2535097 2535097 defendant Bradley Lawrence laborer 904614 904614 Bradley, Lawrence, of Helstanbotham, Otley, laborer 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);