names

15 rows where case_id = 2434762

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5264832 2434762 2434762 plaintiff Sothill Henry     Sothill, Henry 0
5264833 2434762 2434762 defendant Wright John, junior laborer 609585 609585 Wright, John, junior, of Halton juxta Spyllesby, laborer 0
5264834 2434762 2434762 defendant Lound William fisher 587721 587721 Lound, William, of Toynton, fisher 1
5264835 2434762 2434762 defendant Jakson William laborer 586055 586055 Jakson, William, of Westerkele, laborer 2
5264836 2434762 2434762 defendant Dalby Thomas laborer 754185 754185 Dalby, Thomas, of Stykeney, laborer 3
5264837 2434762 2434762 defendant Dyconson William laborer 771581 771581 Dyconson, William, of Sybsay, laborer 4
5264838 2434762 2434762 defendant Croft John husbandman 771581 771581 Croft, John, of Sybsay, husbandman 5
5264839 2434762 2434762 defendant Thekar William husbandman 771581 771581 Thekar, William, of Sybsay, husbandman 6
5264840 2434762 2434762 defendant Sleyght John husbandman 771581 771581 Sleyght, John, of Sybsay, husbandman 7
5264841 2434762 2434762 defendant Colle John husbandman 619528 619528 Colle, John, of Sybsey, husbandman 8
5264842 2434762 2434762 defendant Hatfote Robert husbandman 619528 619528 Hatfote, Robert, of Sybsey, husbandman 9
5264843 2434762 2434762 defendant West William husbandman 619528 619528 West, William, of Sybsey, husbandman 10
5264844 2434762 2434762 defendant Theker Stephe husbandman 619528 619528 Theker, Stephe, of Sybsey, husbandman 11
5264845 2434762 2434762 defendant Fauconer Stephen husbandman 619528 619528 Fauconer, Stephen, of Sybsey, husbandman 12
5264846 2434762 2434762 defendant Poryell Robert husbandman 754185 754185 Poryell, Robert, of Stykeney, 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);