names

15 rows where case_id = 2383874

✎ 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
5091392 2383874 2383874 plaintiff Neffeld or Nesfeld Richard     Neffeld or Nesfeld, Richard 0
5091393 2383874 2383874 defendant Rilston William esq 845318 845318 Rilston, William, of Rilston in Craven, esq 0
5091394 2383874 2383874 defendant Grym Robert husbandman 845318 845318 together with Grym, Robert, of Rilston in Craven, husbandman 1
5091395 2383874 2383874 defendant Horton William husbandman 845318 845318 Horton, William, of Rilston in Craven, husbandman 2
5091396 2383874 2383874 defendant Wilson William husbandman 845318 845318 Wilson, William, of Rilston in Craven, husbandman 3
5091397 2383874 2383874 defendant Caly William husbandman 845318 845318 Caly, William, of Rilston in Craven, husbandman 4
5091398 2383874 2383874 defendant Blakburn Robert husbandman 845318 845318 Blakburn, Robert, of Rilston in Craven, husbandman 5
5091399 2383874 2383874 defendant Blakburn Richard husbandman 845318 845318 Blakburn, Richard, of Rilston in Craven, husbandman 6
5091400 2383874 2383874 defendant Wilson Robert husbandman 845318 845318 Wilson, Robert, of Rilston in Craven, husbandman 7
5091401 2383874 2383874 defendant Katerynson Henry husbandman 845318 845318 Katerynson, Henry, of Rilston in Craven, husbandman 8
5091402 2383874 2383874 defendant Hargraves Robert husbandman 845318 845318 Hargraves, Robert, of Rilston in Craven, husbandman 9
5091403 2383874 2383874 defendant Morehous William husbandman 845318 845318 Morehous, William, of Rilston in Craven, husbandman 10
5091404 2383874 2383874 defendant Blakburn Henry husbandman 845318 845318 Blakburn, Henry, of Rilston in Craven, husbandman 11
5091405 2383874 2383874 defendant Kechyn John husbandman 845318 845318 Kechyn, John, of Rilston in Craven, husbandman 12
5091406 2383874 2383874 defendant Wilson John husbandman 600786 600786 Wilson, John, of Heton, husbandman 13

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