names

14 rows where case_id = 2533991

✎ 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
5597057 2533991 2533991 plaintiff Compton William abbot of Parshore Abbey   Compton, William, abbot of Parshore Abbey 0
5597058 2533991 2533991 defendant Salwey Robert gent 611406 611406 Salwey, Robert, of Bredon, gent 0
5597059 2533991 2533991 defendant Genyns Robert husbandman 611406 611406 Genyns, Robert, of Bredon, husbandman 1
5597060 2533991 2533991 defendant Turvile Richard husbandman 611406 611406 Turvile, Richard, of Bredon, husbandman 2
5597061 2533991 2533991 defendant Hyggyns John husbandman 611406 611406 Hyggyns, John, of Bredon, husbandman 3
5597062 2533991 2533991 defendant Marten William husbandman 611406 611406 Marten, William, of Bredon, husbandman 4
5597063 2533991 2533991 defendant Collys John husbandman 611406 611406 Collys, John, of Bredon, husbandman 5
5597064 2533991 2533991 defendant Hunt Thomas husbandman 611406 611406 Hunt, Thomas, of Bredon, husbandman 6
5597065 2533991 2533991 defendant Harvy Thomas husbandman 611406 611406 Harvy, Thomas, of Bredon, husbandman 7
5597066 2533991 2533991 defendant Hobbys Richard husbandman 611406 611406 Hobbys, Richard, of Bredon, husbandman 8
5597067 2533991 2533991 defendant Holder John husbandman 611406 611406 Holder, John, of Bredon, husbandman 9
5597068 2533991 2533991 defendant Tomson Thomas husbandman 611406 611406 Tomson, Thomas, of Bredon, husbandman 10
5597069 2533991 2533991 defendant Halcok Robert husbandman 611406 611406 Halcok, Robert, of Bredon, husbandman 11
5597070 2533991 2533991 defendant Carmilan Peter clerk 586033 586033 Carmilan, Peter, of Westminster, clerk 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);