names

18 rows where case_id = 2355488

✎ 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
4995466 2355488 2355488 plaintiff Gerveys John     Gerveys, John 0
4995467 2355488 2355488 defendant Hardwyk Henry yeoman 784874 784874 Hardwyk, Henry, of Medilton, yeoman 0
4995468 2355488 2355488 defendant Atkynson Robert yeoman 784874 784874 Atkynson, Robert, of Medilton, yeoman 1
4995469 2355488 2355488 defendant Crombok William yeoman 796289 796289 Crombok, William, of Ilkelay, yeoman 2
4995470 2355488 2355488 defendant Smyth Henry yeoman 831216 831216 Smyth, Henry, of Berwyk, in Craven, yeoman 3
4995471 2355488 2355488 defendant Water Robert yeoman 779648 779648 Water, Robert, of Stokkeld, yeoman 4
4995472 2355488 2355488 defendant Thornton William yeoman 831217 831217 Thornton, William, of Tyrsall, yeoman 5
4995473 2355488 2355488 defendant Bank Robert   779648 779648 Bank, Robert, of Stokkeld, mason 6
4995474 2355488 2355488 defendant Skalwra Thomas yeoman 586742 586742 Skalwra, Thomas, of Whitley, yeoman 7
4995475 2355488 2355488 defendant Smyth John smith 618012 618012 Smyth, John, of North Dighton, smith 8
4995476 2355488 2355488 defendant Smyth Richard husbandman 618012 618012 Smyth, Richard, of North Dighton, husbandman 9
4995477 2355488 2355488 defendant Wright John husbandman 618012 618012 Wright, John, of North Dighton, husbandman 10
4995478 2355488 2355488 defendant Jenaker William husbandman 618012 618012 Jenaker, William, of North Dighton, husbandman 11
4995479 2355488 2355488 defendant Roos John esq 599033 599033 together with Roos, John, of Laxton, Notts, esq 12
4995480 2355488 2355488 defendant Medilton William esq 613305 613305 Medilton, William, of Stokkeld, Yorks, esq 13
4995481 2355488 2355488 defendant Ledes Thomas esq 779958 779958 Ledes, Thomas, of Westwyk, Yorks, esq 14
4995482 2355488 2355488 defendant Clapeham Thomas gent 831219 831219 Clapeham, Thomas, of Bemeslay, Yorks, gent 15
4995483 2355488 2355488 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);