names

16 rows where case_id = 2475614

✎ 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
5401931 2475614 2475614 plaintiff Horn Edward   588220 588220 Horn, Edward, of Wesenham 0
5401932 2475614 2475614 defendant Scarlet Richard husbandman 883601 883601 Scarlet, Richard, of Myleham by Ludham, husbandman 0
5401933 2475614 2475614 defendant Hawe Richard butcher 589532 589532 Hawe, Richard, of Fakenham, butcher 1
5401934 2475614 2475614 defendant Clerke John chaplain 588755 588755 Clerke, John, of Teryngton, chaplain 2
5401935 2475614 2475614 defendant Marham William husbandman 586346 586346 Marham, William, of Langham, husbandman 3
5401936 2475614 2475614 defendant Stede Peter husbandman 783452 783452 Stede, Peter, of Beston by Mileham, husbandman 4
5401937 2475614 2475614 defendant Neell John husbandman 761744 761744 Neell, John, of Great Ryburgh, husbandman 5
5401938 2475614 2475614 defendant Bartram John   883602 883602 Bartram, John, of Little Walsyngham, cepell 6
5401939 2475614 2475614 defendant Payn John   588219 588219 Payn, John, of Swafham, shoe maker 7
5401940 2475614 2475614 defendant Wotton William gent 586651 586651 Wotton, William, of Castel Acre, gent 8
5401941 2475614 2475614 defendant Crysten William   587172 587172 Crysten, William, of East Derham, shoe maker 9
5401942 2475614 2475614 defendant Wandham Robert husbandman 853110 853110 Wandham, Robert, of Hillygnton, husbandman 10
5401943 2475614 2475614 defendant Mony Robert butcher 604612 604612 Mony, Robert, of Wells next the sea, butcher 11
5401944 2475614 2475614 defendant Clyfton Agnes widow 587553 587553 Clyfton, Agnes, of Toftrys, widow 12
5401945 2475614 2475614 defendant Spencer Edward (legal representative) 595176 595176 Spencer, Edward, of Hunstanton, yeoman, executor of 13
5401946 2475614 2475614 defendant Spencer John husbandman 595176 595176 Spencer, John, of Hunstanton, husbandman 14

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