names

17 rows where case_id = 2478620

✎ 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
5412262 2478620 2478620 plaintiff Denne (illegible)     Denne, _, on own account 0
5412263 2478620 2478620 defendant Myles Thomas   586102 586102 Myles, Thomas, of Hengham, mason 0
5412264 2478620 2478620 defendant (illegible) of B__leshale husbandman   _, of B__leshale, husbandman 1
5412265 2478620 2478620 defendant Coche Roger yeoman 884917 884917 Coche, Roger, of _y, yeoman 2
5412266 2478620 2478620 defendant Verdon Nicholas   589042 589042 Verdon, Nicholas, of Heydon 3
5412267 2478620 2478620 defendant Alpe Thomas butcher 586102 586102 Alpe, Thomas, of Hengham, butcher 4
5412268 2478620 2478620 defendant Crome John   884918 884918 Crome, John, of Bill_ 5
5412269 2478620 2478620 defendant (illegible) of Baldewell yeoman   _, of Baldewell, yeoman 6
5412270 2478620 2478620 defendant Wolle Walter husbandman 604304 604304 Wolle, Walter, of Upwell, Cambs, husbandman 7
5412271 2478620 2478620 defendant Elden Thomas miller 601937 601937 Elden, Thomas, of Ersham, miller 8
5412272 2478620 2478620 defendant Yarham John carpenter 598081 598081 Yarham, John, of Hyndolveston, carpenter 9
5412273 2478620 2478620 defendant Baret Thomas husbandman 587414 587414 Baret, Thomas, of Thetford, husbandman 10
5412274 2478620 2478620 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 11
5412275 2478620 2478620 defendant Groute William husbandman 587166 587166 Groute, William, of Salle, husbandman 12
5412276 2478620 2478620 defendant Boteld Thomas husbandman 592833 592833 Boteld, Thomas, of Wakton, husbandman 13
5412277 2478620 2478620 defendant Herryson John   586396 586396 Herryson, John, of Yaxham, mason 14
5412278 2478620 2478620 defendant Phyppys Richard husbandman 588926 588926 Phyppys, Richard, of North Elmham, husbandman 15

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