names

10 rows where case_id = 2508585

✎ 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
5511918 2508585 2508585 plaintiff Leventhorp Nicholas esq   Leventhorp, Nicholas, esq 0
5511919 2508585 2508585 defendant Radclyff Robert yeoman 895051 895051 Radclyff, Robert, of Bolton juxta Bradford, yeoman 0
5511920 2508585 2508585 defendant Norton Richard yeoman 600493 600493 Norton, Richard, of Bolton, yeoman 1
5511921 2508585 2508585 defendant Horton William tanner 586349 586349 Horton, William, of Bradford, tanner 2
5511922 2508585 2508585 defendant Wylkynson Lawrence husbandman 895052 895052 Wylkynson, Lawrence, of Wilseden, husbandman 3
5511923 2508585 2508585 defendant Stayneton William yeoman 589605 589605 Stayneton, William, of Wolley, yeoman 4
5511924 2508585 2508585 defendant Stayneton Lawrence yeoman 589605 589605 Stayneton, Lawrence, of Wolley, yeoman 5
5511925 2508585 2508585 defendant Passelewe John yeoman 588253 588253 Passelewe, John, of Clayton, yeoman 6
5511926 2508585 2508585 defendant Dycson Robert husbandman 589200 589200 Dycson, Robert, of Knaresburgh, husbandman 7
5511927 2508585 2508585 defendant Smyth alias Atkynson Richard smith 589200 589200 Smyth alias Atkynson, Richard, of Knaresburgh, smith 8

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