names

13 rows where case_id = 2495102

✎ 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
5467076 2495102 2495102 plaintiff Bisshop John gent 585936 585936 Bisshop, John, of Norwich, gent, on his own account 0
5467077 2495102 2495102 defendant Eston Robert gent 590362 590362 Eston, Robert, of Eston, gent 0
5467078 2495102 2495102 defendant Wyllys William yeoman 603616 603616 Wyllys, William, of Cley next the sea, yeoman 1
5467079 2495102 2495102 defendant Corne William innholder 585936 585936 Corne, William, of Norwich, innholder 2
5467080 2495102 2495102 defendant Moine Thomas husbandman 589537 589537 Moine, Thomas, of Banburgh, husbandman 3
5467081 2495102 2495102 defendant Noteman John husbandman 703866 703866 Noteman, John, of Burnham St Andrew, husbandman 4
5467082 2495102 2495102 defendant Grogon Walter husbandman 875538 875538 Grogon, Walter, of Burnham Ulp, husbandman 5
5467083 2495102 2495102 defendant Everard Henry husbandman 588732 588732 Everard, Henry, of Acle, husbandman 6
5467084 2495102 2495102 defendant Lenot John yeoman 585936 585936 Lenot, John, of Norwich, yeoman 7
5467085 2495102 2495102 defendant Thwayte Richard husbandman 890554 890554 Thwayte, Richard, of Stenynghale, husbandman 8
5467086 2495102 2495102 defendant Hulle John husbandman 587294 587294 Hulle, John,of Todyngton, husbandman 9
5467087 2495102 2495102 defendant Elres John husbandman 768418 768418 Elres, John, of Burgh by Aylesham, husbandman 10
5467088 2495102 2495102 defendant Braffeld Richard husbandman 587294 587294 Braffeld, Richard, of Todyngton, husbandman 11

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);