names

14 rows where case_id = 2395182

✎ 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
5129722 2395182 2395182 plaintiff Dean & Canons of the King's Free chapel of St Stephen within the Palace of Westminster     Dean & Canons, of the King's Free chapel of St Stephen within the Palace of Westminster 0
5129723 2395182 2395182 defendant Lyster Richard, senior yeoman 586731 586731 Lyster, Richard, senior, of Wakefeld, Yorks, yeoman 0
5129724 2395182 2395182 defendant Hike Robert yeoman 612968 612968 Hike, Robert, of Yorkshire, yeoman 1
5129725 2395182 2395182 defendant Watirton Robert   813543 813543 Watirton, Robert, of Metheley, Yorks, kinight 2
5129726 2395182 2395182 defendant another of Yorkshire clerk   another, of Yorkshire, clerk 3
5129727 2395182 2395182 defendant Bammy John gent 586887 586887 Bammy, John, of Wakefeld, gent 4
5129728 2395182 2395182 defendant Mason John yeoman 850161 850161 Mason, John, of N---, yeoman 5
5129729 2395182 2395182 defendant Maunsell John yeoman 586887 586887 Maunsell, John, of Wakefeld, yeoman 6
5129730 2395182 2395182 defendant Lyster Richard yeoman   Lyster, Richard, yeoman 7
5129731 2395182 2395182 defendant Horbury Christopher gent 586887 586887 Horbury, Christopher, of Wakefeld, gent 8
5129732 2395182 2395182 defendant Hipperon John gent 590096 590096 Hipperon, John, of Lofthous, gent 9
5129733 2395182 2395182 defendant Hobson John yeoman 598218 598218 Hobson, John, of Stanley, yeoman 10
5129734 2395182 2395182 defendant Bollyng William   772645 772645 Bollyng, William, of Allerthorp 11
5129735 2395182 2395182 defendant Grayffe William yeoman 850162 850162 Grayffe, William, of Flansow, Yorks, yeoman 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);