names

14 rows where case_id = 2432894

✎ 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
5258869 2432894 2432894 plaintiff Haunsert Richard     Haunsert, Richard 0
5258870 2432894 2432894 defendant Hende Walter merchant 590061 590061 Hende, Walter, of Barton on Humber, merchant 0
5258871 2432894 2432894 defendant Foulstowe Thomas merchant 590061 590061 Foulstowe, Thomas, of Barton on Humber, merchant 1
5258872 2432894 2432894 defendant (not given) John vicar of Gandeby 590061 590061 Gandeby, John, of Barton on Humber, vicar of Burton on Stather 2
5258873 2432894 2432894 defendant Slygh Richard husbandman 586344 586344 Slygh, Richard, of Burton on Stather, husbandman 3
5258874 2432894 2432894 defendant Jagger John   586344 586344 Jagger, John, of Burton on Stather, wright 4
5258875 2432894 2432894 defendant Armyn John husbandman 865211 865211 Armyn, John, of Sylke Wylughby, husbandman 5
5258876 2432894 2432894 defendant Pyse Gilbert chaplain 865212 865212 Pyse, Gilbert, of Market Synton, chaplain 6
5258877 2432894 2432894 defendant Brigge Robert mercer 586846 586846 Brigge, Robert, of Lincoln, mercer 7
5258878 2432894 2432894 defendant Wysbech Richard chaplain 865213 865213 Wysbech, Richard, of Byrton juxta Bylchefeld, or of Grantham, chaplain 8
5258879 2432894 2432894 defendant Moston Richar of Poynton husbandman   Moston, Richar of Poynton, husbandman 9
5258880 2432894 2432894 defendant Almot John husbandman 601769 601769 Almot, John, of Howell, husbandman 10
5258881 2432894 2432894 defendant Thorney John   772921 772921 Thorney, John, of Stretton, Notts, court holder 11
5258882 2432894 2432894 defendant Locok William husbandman 602351 602351 Locok, William, of Stretton, 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);