names

18 rows where case_id = 2353522

✎ 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
4988499 2353522 2353522 plaintiff Brame Thomas     Brame, Thomas 0
4988500 2353522 2353522 defendant Hardwyk Henry yeoman 784874 784874 Hardwyk, Henry, of Medilton, yeoman 0
4988501 2353522 2353522 defendant Atkynson Robert yeoman 784874 784874 Atkynson, Robert, of Medilton, yeoman 1
4988502 2353522 2353522 defendant Crombok William yeoman 796289 796289 Crombok, William, of Ilkelay, yeoman 2
4988503 2353522 2353522 defendant Smyth Henry yeoman 831216 831216 Smyth, Henry, of Berwyk, in Craven, yeoman 3
4988504 2353522 2353522 defendant Water Robert yeoman 779648 779648 Water, Robert, of Stokkeld, yeoman 4
4988505 2353522 2353522 defendant Thornton William yeoman 831217 831217 Thornton, William, of Tyrsall, yeoman 5
4988506 2353522 2353522 defendant Bank Robert   779648 779648 Bank, Robert, of Stokkeld, mason 6
4988507 2353522 2353522 defendant Skalwra Thomas yeoman 586742 586742 Skalwra, Thomas, of Whitley, yeoman 7
4988508 2353522 2353522 defendant Smyth John smith 618012 618012 Smyth, John, of North Dighton, smith 8
4988509 2353522 2353522 defendant Smyth Richard husbandman 618012 618012 Smyth, Richard, of North Dighton, husbandman 9
4988510 2353522 2353522 defendant Wright John husbandman 618012 618012 Wright, John, of North Dighton, husbandman 10
4988511 2353522 2353522 defendant Jenaker William husbandman 618012 618012 Jenaker, William, of North Dighton, husbandman 11
4988512 2353522 2353522 defendant Roos John esq 599033 599033 together with Roos, John, of Laxton, Notts, esq 12
4988513 2353522 2353522 defendant Medilton William esq 613305 613305 Medilton, William, of Stokkeld, Yorks, esq 13
4988514 2353522 2353522 defendant Ledes Thomas esq 779958 779958 Ledes, Thomas, of Westwyk, Yorks, esq 14
4988515 2353522 2353522 defendant Clapeham Thomas gent 831219 831219 Clapeham, Thomas, of Bemeslay, Yorks, gent 15
4988516 2353522 2353522 defendant Clapeham Nicholas gent 831219 831219 Clapeham, Nicholas, of Bemeslay, Yorks, gent 16

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