names

14 rows where case_id = 2383879

✎ 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
5091421 2383879 2383879 plaintiff Nesfeld Richard     Nesfeld, Richard 0
5091422 2383879 2383879 defendant Grym Robert husbandman 639462 639462 Grym, Robert, of Rylston in Craven, husbandman 0
5091423 2383879 2383879 defendant Horton William husbandman 660441 660441 Horton, William, of Rylston, husbandman 1
5091424 2383879 2383879 defendant Wylson William husbandman 660441 660441 Wylson, William, of Rylston, husbandman 2
5091425 2383879 2383879 defendant Caly William husbandman 660441 660441 Caly, William, of Rylston, husbandman 3
5091426 2383879 2383879 defendant Blakburn Robert husbandman 660441 660441 Blakburn, Robert, of Rylston, husbandman 4
5091427 2383879 2383879 defendant Wylson Robert husbandman 660441 660441 Wylson, Robert, of Rylston, husbandman 5
5091428 2383879 2383879 defendant Katerynson Henry husbandman 660441 660441 Katerynson, Henry, of Rylston, husbandman 6
5091429 2383879 2383879 defendant Hargraves Robert husbandman 660441 660441 Hargraves, Robert, of Rylston, husbandman 7
5091430 2383879 2383879 defendant Morehous William husbandman 660441 660441 Morehous, William, of Rylston, husbandman 8
5091431 2383879 2383879 defendant Blakburn Henry husbandman 660441 660441 Blakburn, Henry, of Rylston, husbandman 9
5091432 2383879 2383879 defendant Kechyn JOhn husbandman 660441 660441 Kechyn, JOhn, of Rylston, husbandman 10
5091433 2383879 2383879 defendant Wilson John husbandman 600786 600786 Wilson, John, of Heton, husbandman 11
5091434 2383879 2383879 defendant Rylston William esq 660441 660441 together with Rylston, William, of Rylston, esq 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);