names

15 rows where case_id = 2345077

✎ 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
4960398 2345077 2345077 plaintiff Basset Ralph esq   Basset, Ralph, esq 0
4960399 2345077 2345077 defendant FitzHerberd Nicholas esq 591260 591260 FitzHerberd, Nicholas, of Norbury, esq 0
4960400 2345077 2345077 defendant Petur John yeoman 591260 591260 Petur, John, of Norbury, yeoman 1
4960401 2345077 2345077 defendant Lyghtwode John miller 591260 591260 Lyghtwode, John, of Norbury, miller 2
4960402 2345077 2345077 defendant Hyde William husbandman 637950 637950 Hyde, William, of Rossyngton, husbandman 3
4960403 2345077 2345077 defendant Hyde Thomas husbandman 637950 637950 Hyde, Thomas, of Rossyngton, husbandman 4
4960404 2345077 2345077 defendant Philipotte John husbandman 637950 637950 Philipotte, John, of Rossyngton, husbandman 5
4960405 2345077 2345077 defendant Calton Richard husbandman 637950 637950 Calton, Richard, of Rossyngton, husbandman 6
4960406 2345077 2345077 defendant Smyth John laborer 637950 637950 Smyth, John, of Rossyngton, laborer 7
4960407 2345077 2345077 defendant Adbaston Thomas husbandman 637950 637950 Adbaston, Thomas, of Rossyngton, husbandman 8
4960408 2345077 2345077 defendant Prynce Ralph laborer 624989 624989 Prynce, Ralph, of Glaston, laborer 9
4960409 2345077 2345077 defendant Mylner John laborer 591260 591260 Mylner, John, of Norbury, laborer 10
4960410 2345077 2345077 defendant Calton William chapman 637950 637950 Calton, William, of Rossyngton, chapman 11
4960411 2345077 2345077 defendant Pecok John tailor 637950 637950 Pecok, John, of Rossyngton, tailor 12
4960412 2345077 2345077 defendant Frenshman John husbandman 591260 591260 Frenshman, John, of Norbury, 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);