names

14 rows where case_id = 2279857

✎ 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
4747771 2279857 2279857 plaintiff Leek William     Leek, William 0
4747772 2279857 2279857 defendant Ka John tailor 586070 586070 Ka, John, of Beverley, tailor 0
4747773 2279857 2279857 defendant Sherman Thomas sheerman 586070 586070 Sherman, Thomas, of Beverley, sheerman 1
4747774 2279857 2279857 defendant Raulynson William yeoman 759777 759777 Raulynson, William, of Nafftreton, yeoman 2
4747775 2279857 2279857 defendant Tynmouth William baker 586070 586070 Tynmouth, William, of Beverley, baker 3
4747776 2279857 2279857 defendant Driffeld Richard husbandman 586070 586070 Driffeld, Richard, of Beverley, yeoman;d Woderer--, of Beford, husbandman 4
4747777 2279857 2279857 defendant Kilpyn John husbandman 619006 619006 Kilpyn, John, of Beford, husbandman 5
4747778 2279857 2279857 defendant Rerey William husbandman 779195 779195 Rerey, William, of Skipse, husbandman 6
4747779 2279857 2279857 defendant Howeson William gent 621963 621963 Howeson, William, of Elmeswell, gent 7
4747780 2279857 2279857 defendant Burnebuttes John yeoman 621963 621963 Burnebuttes, John, of Elmeswell, yeoman 8
4747781 2279857 2279857 defendant Baynton Robert laborer 614243 614243 Baynton, Robert, of Boynton, laborer 9
4747782 2279857 2279857 defendant Skllater Walter yeoman 776541 776541 Skllater, Walter, of Ake, yeoman 10
4747783 2279857 2279857 defendant Scarffe John husbandman 765388 765388 Scarffe, John, of Lunde, husbandman 11
4747784 2279857 2279857 defendant Hardy Henry husbandman 589509 589509 Hardy, Henry, of Aldeburgh, 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);