names

13 rows where case_id = 2454058

✎ 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
5330013 2454058 2454058 plaintiff Basset William esq   Basset, William, esq 0
5330014 2454058 2454058 defendant Dawekyn William husbandman 867072 867072 Dawekyn, William, of Chelmardon, husbandman 0
5330015 2454058 2454058 defendant Jonson Hugh husbandman 613916 613916 Jonson, Hugh, of Hartyngton, husbandman 1
5330016 2454058 2454058 defendant Nedeham John yeoman 874095 874095 Nedeham, John, of Fernydale, yeoman 2
5330017 2454058 2454058 defendant Fleccher Richard husbandman 874096 874096 Fleccher, Richard, of Howesclogh, Staffs, husbandman 3
5330018 2454058 2454058 defendant Fleccher James, senior husbandman 874097 874097 Fleccher, James, senior, of Howesclogh, husbandman 4
5330019 2454058 2454058 defendant Fleccher Geffrey husbandman 874097 874097 Fleccher, Geffrey, of Howesclogh, husbandman 5
5330020 2454058 2454058 defendant Fleccher Henry husbandman 874097 874097 Fleccher, Henry, of Howesclogh, husbandman 6
5330021 2454058 2454058 defendant Fleccher James, junior husbandman 874097 874097 Fleccher, James, junior, of Howesclogh, husbandman 7
5330022 2454058 2454058 defendant Olyver John smith 874098 874098 Olyver, John, of Longnore, Staffs, smith 8
5330023 2454058 2454058 defendant Smyth John husbandman 819046 819046 Smyth, John, of Boterton, Staffs, husbandman 9
5330024 2454058 2454058 defendant Lomals Thomas husbandman 779194 779194 Lomals, Thomas, of Alstonfeld, Staffs, husbandman 10
5330025 2454058 2454058 defendant Lomals Ralph husbandman 620765 620765 Lomals, Ralph, of Alstonfeld, husbandman 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);