names

17 rows where case_id = 1917200

✎ 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
3671861 1917200 1917200 plaintiff Cookyssey John     Cookyssey, John 0
3671862 1917200 1917200 defendant Ruddyng Thomas gent 607319 607319 Ruddyng, Thomas, of Birlyngham, gent 0
3671863 1917200 1917200 defendant Philippes John yeoman 608018 608018 Philippes, John, of Aburton, yeoman 1
3671864 1917200 1917200 defendant Blockley William yeoman 608019 608019 Blockley, William, of Kydermynster, yeoman 2
3671865 1917200 1917200 defendant Lyrcoke John husbandman 607999 607999 Lyrcoke, John, of Kemsey, husbandman 3
3671866 1917200 1917200 defendant Lyrcoke Thomas yeoman 608020 608020 Lyrcoke, Thomas, of Clent, Staffs, yeoman 4
3671867 1917200 1917200 defendant Sondyll Robert husbandman 608021 608021 Sondyll, Robert, of Bradley Grene, husbandman 5
3671868 1917200 1917200 defendant Gybbyns William husbandman 597103 597103 Gybbyns, William, of Pepulton, husbandman 6
3671869 1917200 1917200 defendant Shrape William husbandman 608022 608022 Shrape, William, of Abblenche, husbandman 7
3671870 1917200 1917200 defendant Arnewey John husbandman 599859 599859 Arnewey, John, of Naunton, husbandman 8
3671871 1917200 1917200 defendant Dorley Roger husbandman 608023 608023 Dorley, Roger, of Churche Lenche, husbandman 9
3671872 1917200 1917200 defendant Dorley Edmund yeoman 608023 608023 Dorley, Edmund, of Churche Lenche, yeoman 10
3671873 1917200 1917200 defendant Sharpe John husbandman 608023 608023 Sharpe, John, of Churche Lenche, husbandman 11
3671874 1917200 1917200 defendant Powell Richard weaver 608023 608023 Powell, Richard, of Churche Lenche, weaver 12
3671875 1917200 1917200 defendant Andrewys Thomas yeoman 608023 608023 Andrewys, Thomas, of Churche Lenche, yeoman 13
3671876 1917200 1917200 defendant Appulby John butcher 608024 608024 Appulby, John, of Achelenche, butcher 14
3671877 1917200 1917200 defendant Lempster Richard husbandman 590688 590688 Lempster, Richard, of More, husbandman 15

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