names

16 rows where case_id = 2479374

✎ 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
5414846 2479374 2479374 plaintiff Horn Edward     Horn, Edward, on his own account 0
5414847 2479374 2479374 defendant Scarlet Richard husbandman 885163 885163 Scarlet, Richard, of Myleham by Lucham, husbandman 0
5414848 2479374 2479374 defendant Hawe Richard butcher 589532 589532 Hawe, Richard, of Fakenham, butcher 1
5414849 2479374 2479374 defendant (illegible) John chaplain 588755 588755 _, John, of Teryngton, chaplain 2
5414850 2479374 2479374 defendant Marham William husbandman 586346 586346 Marham, William, of Langham, husbandman 3
5414851 2479374 2479374 defendant (illegible) of Beston by Mileham husbandman   _, of Beston by Mileham, husbandman 4
5414852 2479374 2479374 defendant (illegible) John husbandman 761744 761744 _, John, of Great Ryburgh, husbandman 5
5414853 2479374 2479374 defendant Bartram John   603983 603983 Bartram, John, of Little Walsyngham 6
5414854 2479374 2479374 defendant (illegible) of Swafham shoemaker   _, of Swafham, shoemaker 7
5414855 2479374 2479374 defendant Wotton William   604697 604697 Wotton, William,of Castle Acre 8
5414856 2479374 2479374 defendant Crysten William   587172 587172 Crysten, William, of East Derham 9
5414857 2479374 2479374 defendant (illegible) of Hyllyngton husbandman   _, of Hyllyngton, husbandman 10
5414858 2479374 2479374 defendant Mony Robert   823307 823307 Mony, Robert, of Wellys next the Sea 11
5414859 2479374 2479374 defendant Clyfton Agnes widow 587553 587553 Clyfton, Agnes, of Toftrys, widow 12
5414860 2479374 2479374 defendant Spencer Edward (legal representative) 595176 595176 Spencer, Edward, of Hunstanton, yeoman, executor of 13
5414861 2479374 2479374 defendant Spencer John   595176 595176 Spencer, John, of Hunstanton 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);