names

16 rows where place_id = 717459

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4219767 2102417 2102417 defendant Butler John gent 717459 717459 Butler, John, of Stapenhull, gent 0
4670785 2256542 2256542 defendant Caldewell Henry husbandman 717459 717459 Caldewell, Henry, of Stapenhull, husbandman 1
4670790 2256544 2256544 defendant Abell John gent 717459 717459 Abell, John, of Stapenhull, gent 0
4719753 2271524 2271524 defendant Allerton Simon husbandman 717459 717459 Allerton, Simon, of Stapenhull, husbandman 2
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

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