names

18 rows where case_id = 2358511

✎ 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
5005493 2358511 2358511 plaintiff Roos Robert knight   Roos, Robert, knight 0
5005494 2358511 2358511 defendant Hardwyk Henry yeoman 784874 784874 Hardwyk, Henry, of Medilton, yeoman 0
5005495 2358511 2358511 defendant Atkynson Robert yeoman 784874 784874 Atkynson, Robert, of Medilton, yeoman 1
5005496 2358511 2358511 defendant Crombok William yeoman 796289 796289 Crombok, William, of Ilkelay, yeoman 2
5005497 2358511 2358511 defendant Smyth Henry yeoman 831216 831216 Smyth, Henry, of Berwyk, in Craven, yeoman 3
5005498 2358511 2358511 defendant Water Robert yeoman 779648 779648 Water, Robert, of Stokkeld, yeoman 4
5005499 2358511 2358511 defendant Thornton William yeoman 831217 831217 Thornton, William, of Tyrsall, yeoman 5
5005500 2358511 2358511 defendant Bank Robert   779648 779648 Bank, Robert, of Stokkeld, mason 6
5005501 2358511 2358511 defendant Skalwra Thomas yeoman 586742 586742 Skalwra, Thomas, of Whitley, yeoman 7
5005502 2358511 2358511 defendant Smyth John smith 618012 618012 Smyth, John, of North Dighton, smith 8
5005503 2358511 2358511 defendant Smyth Richard husbandman 618012 618012 Smyth, Richard, of North Dighton, husbandman 9
5005504 2358511 2358511 defendant Wright John husbandman 618012 618012 Wright, John, of North Dighton, husbandman 10
5005505 2358511 2358511 defendant Jenaker William husbandman 618012 618012 Jenaker, William, of North Dighton, husbandman 11
5005506 2358511 2358511 defendant Roos John esq 599033 599033 together with Roos, John, of Laxton, Notts, esq 12
5005507 2358511 2358511 defendant Medilton William esq 613305 613305 Medilton, William, of Stokkeld, Yorks, esq 13
5005508 2358511 2358511 defendant Ledes Thomas esq 779958 779958 Ledes, Thomas, of Westwyk, Yorks, esq 14
5005509 2358511 2358511 defendant Clapeham Thomas gent 831219 831219 Clapeham, Thomas, of Bemeslay, Yorks, gent 15
5005510 2358511 2358511 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);