names

15 rows where case_id = 2009241

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3956200 2009241 2009241 plaintiff Myne Henry     Myne, Henry 0
3956201 2009241 2009241 defendant Balam Robert esq 598213 598213 Balam, Robert, of Walsyngham, esq 0
3956202 2009241 2009241 defendant Symond Robert husbandman 587203 587203 Symond, Robert, of Wychyngham, husbandman 1
3956203 2009241 2009241 defendant Oxwycke John husbandman 589532 589532 Oxwycke, John, of Fakenham, husbandman 2
3956204 2009241 2009241 defendant Woodcoke Richard innkeeper 586517 586517 Woodcoke, Richard, of Hyngham, innkeeper 3
3956205 2009241 2009241 defendant Alyson James merchant 637452 637452 Alyson, James, of Clay juxta Mare, merchant 4
3956206 2009241 2009241 defendant Bang Thomas husbandman 660364 660364 Bang, Thomas, of Smalburrowe, husbandman 5
3956207 2009241 2009241 defendant Makender John merchant 640775 640775 Makender, John, of Kings Lenn, merchant 6
3956208 2009241 2009241 defendant Wolcey Edmund   659085 659085 Wolcey, Edmund, of Newton juxta Norwich 7
3956209 2009241 2009241 defendant Wolcey Dorothy widow   Dorothy his wife, formerly Dorothy Phipson, widow 8
3956210 2009241 2009241 defendant Tele William husbandman 633811 633811 Tele, William, of Houghton juxta Walsyngham, husbandman 9
3956211 2009241 2009241 defendant Shelton Ralph esq   Shelton, Ralph, esq, executrix of 10
3956212 2009241 2009241 defendant Shelton Anne widow 591106 591106 Shelton, Anne, of Depeham, widow 11
3956213 2009241 2009241 defendant Stone William (legal representative)   Stone, William, administratrix of 12
3956214 2009241 2009241 defendant Stone Elizabeth widow 588926 588926 Stone, Elizabeth, of North Elmham, widow 13

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