names

14 rows where case_id = 2492883

✎ 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
5459869 2492883 2492883 plaintiff Horton Roger     Horton, Roger 0
5459870 2492883 2492883 defendant Alsop William husbandman 717459 717459 Alsop, William, of Stapenhull, husbandman 0
5459871 2492883 2492883 defendant Dawekyn Thomas husbandman 717459 717459 Dawekyn, Thomas, of Stapenhull, husbandman 1
5459872 2492883 2492883 defendant Blount Thomas yeoman 717459 717459 Blount, Thomas, of Stapenhull, yeoman 2
5459873 2492883 2492883 defendant Wryght William husbandman 717459 717459 Wryght, William, of Stapenhull, husbandman 3
5459874 2492883 2492883 defendant Jakson Ralph husbandman 717459 717459 Jakson, Ralph, of Stapenhull, husbandman 4
5459875 2492883 2492883 defendant Sheperd William husbandman 717459 717459 Sheperd, William, of Stapenhull, husbandman 5
5459876 2492883 2492883 defendant Alsop Ralph husbandman 717459 717459 Alsop, Ralph, of Stapenhull, husbandman 6
5459877 2492883 2492883 defendant Savage Richard husbandman 717459 717459 Savage, Richard, of Stapenhull, husbandman 7
5459878 2492883 2492883 defendant Waren Thomas husbandman 717459 717459 Waren, Thomas, of Stapenhull, husbandman 8
5459879 2492883 2492883 defendant Bysshop Henry laborer 717459 717459 Bysshop, Henry, of Stapenhull, laborer 9
5459880 2492883 2492883 defendant Roundell Henry husbandman 717459 717459 Roundell, Henry, of Stapenhull, husbandman 10
5459881 2492883 2492883 defendant Porter Robert herdman 717459 717459 Porter, Robert, of Stapenhull, herdman 11
5459882 2492883 2492883 defendant Jakson John husbandman 889879 889879 Jakson, John, of Byrmaston, husbandman 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);