names

14 rows where case_id = 2331759

✎ 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
4916791 2331759 2331759 plaintiff Foliambe William     Foliambe, William, on his own account 0
4916792 2331759 2331759 defendant Multon William yeoman 610619 610619 Multon, William, of Hokerton, yeoman 0
4916793 2331759 2331759 defendant Yonge William husbandman 591976 591976 Yonge, William, of Wynkeburn, husbandman 1
4916794 2331759 2331759 defendant Forset Robert yeoman 821628 821628 Forset, Robert, of Erygley, yeoman 2
4916795 2331759 2331759 defendant Willeson Richard husbandman 821629 821629 Willeson, Richard, of Fledeburgh, husbandman 3
4916796 2331759 2331759 defendant Vicars John husbandman 590873 590873 Vicars, John, of Normanton, husbandman 4
4916797 2331759 2331759 defendant Forster John husbandman 590873 590873 Forster, John, of Normanton, husbandman 5
4916798 2331759 2331759 defendant Cressy Peter husbandman 752745 752745 Cressy, Peter, of Markham, husbandman 6
4916799 2331759 2331759 defendant Hoker Thomas husbandman 821630 821630 Hoker, Thomas, of South Cliston, husbandman 7
4916800 2331759 2331759 defendant Adam John husbandman 791317 791317 Adam, John, of South Clifton, husbandman 8
4916801 2331759 2331759 defendant Fyssher John husbandman 821631 821631 Fyssher, John, of Bonbush, husbandman 9
4916802 2331759 2331759 defendant Fyssher William husbandman 610144 610144 Fyssher, William, of Creswell, husbandman 10
4916803 2331759 2331759 defendant Snowe John husbandman 593657 593657 Snowe, John, of Blithe, husbandman 11
4916804 2331759 2331759 defendant Caward Richard husbandman 772421 772421 Caward, Richard, of Carburton, 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);