names

20 rows where case_id = 1868739

✎ 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
3603410 1868739 1868739 plaintiff Denne William     Denne, William 0
3603411 1868739 1868739 defendant Rous John yeoman 591123 591123 Rous, John, of West Lexham, yeoman 0
3603412 1868739 1868739 defendant Parke Henry husbandman 591124 591124 Parke, Henry, of Foxley, husbandman 1
3603413 1868739 1868739 defendant Maynard Robert husbandman 590405 590405 Maynard, Robert, of Martham, husbandman 2
3603414 1868739 1868739 defendant Ferrour Edmund yeoman 591125 591125 Ferrour, Edmund, of Welburne, yeoman 3
3603415 1868739 1868739 defendant Wodcroft Robert yeoman 590965 590965 Wodcroft, Robert, of Hyndolneston, yeoman 4
3603416 1868739 1868739 defendant Salthous John yeoman 591126 591126 Salthous, John, of Attylbrygge, yeoman 5
3603417 1868739 1868739 defendant Skulton Robert husbandman 591127 591127 Skulton, Robert, of Elsyng, husbandman 6
3603418 1868739 1868739 defendant Mony John butcher 591128 591128 Mony, John, of Geyswheyt, butcher 7
3603419 1868739 1868739 defendant Laverok John yeoman 587166 587166 Laverok, John, of Salle, yeoman 8
3603420 1868739 1868739 defendant Uttyng John yeoman 590486 590486 Uttyng, John, of Stoke Holy Cross, yeoman 9
3603421 1868739 1868739 defendant Monke John smith 585936 585936 Monke, John, of Norwich, smith 10
3603422 1868739 1868739 defendant Estwyk William miller 587283 587283 Estwyk, William, of Honyngham, miller 11
3603423 1868739 1868739 defendant Camond William yeoman 587449 587449 Camond, William, of Felmyngham, yeoman 12
3603424 1868739 1868739 defendant Goddyng William clerk 591129 591129 Goddyng, William, of Shirford, clerk 13
3603425 1868739 1868739 defendant Porlond Margaret widow 586471 586471 Porlond, Margaret, of Aylesham, widow 14
3603426 1868739 1868739 defendant Bysshop Edward (legal representative) 586940 586940 Bysshop, Edward, of Baldeswell, yeoman, administrator of 15
3603427 1868739 1868739 defendant Mason Thomas yeoman 591084 591084 Mason, Thomas, of Geyst, yeoman 16
3603428 1868739 1868739 defendant Mony William (legal representative) 588813 588813 Mony, William, of Themylthorp, yeoman, administrator of 17
3603429 1868739 1868739 defendant Gedge John chaplain 591132 591132 Gedge, John, of Stodey, chaplain 18

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