names

25 rows where case_id = 2329097

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4908118 2329097 2329097 plaintiff Andrewe John   655953 655953 Andrewe, John, of Huntingdon, Hunts, notary 0
4908119 2329097 2329097 defendant Porker John tailor 585869 585869 Porker, John, of London, tailor 0
4908120 2329097 2329097 defendant Freleme John butcher   Freleme, John, butcher 1
4908121 2329097 2329097 defendant Charwelton Thomas gent   Charwelton, Thomas, gent 2
4908122 2329097 2329097 defendant Carlemen Michael skinner   Carlemen, Michael, skinner 3
4908123 2329097 2329097 defendant Squier Richard butcher   Squier, Richard, butcher 4
4908124 2329097 2329097 defendant Denton William barber   Denton, William, barber 5
4908125 2329097 2329097 defendant Toly William weaver   Toly, William, weaver 6
4908126 2329097 2329097 defendant Herforth Stephen cooper   Herforth, Stephen, cooper 7
4908127 2329097 2329097 defendant Skynner Robert yeoman   Skynner, Robert, yeoman 8
4908128 2329097 2329097 defendant Robyns John shoemaker   Robyns, John, shoemaker 9
4908129 2329097 2329097 defendant Oswester John shoemaker   Oswester, John, shoemaker 10
4908130 2329097 2329097 defendant Mott Richard mercer   Mott, Richard, mercer 11
4908131 2329097 2329097 defendant Mexhey John ostler   Mexhey, John, ostler 12
4908132 2329097 2329097 defendant Chardere Alan glover   Chardere, Alan, glover 13
4908133 2329097 2329097 defendant Rande John husbandman 820191 820191 Rande, John, of Great Stucle, Hunts, husbandman 14
4908134 2329097 2329097 defendant Somerset George barber   Somerset, George, barber 15
4908135 2329097 2329097 defendant Hede William shoemaker   Hede, William, shoemaker 16
4908136 2329097 2329097 defendant Walys John butcher   Walys, John, butcher 17
4908137 2329097 2329097 defendant Ive John glover   Ive, John, glover 18
4908138 2329097 2329097 defendant Wolle John shoemaker   Wolle, John, shoemaker 19
4908139 2329097 2329097 defendant Symson Richard husbandman 654795 654795 Symson, Richard, of Stelton, Hunts, husbandman 20
4908140 2329097 2329097 defendant Sone or Sove John husbandman 820192 820192 Sone or Sove, John, of Steilton, husbandman 21
4908141 2329097 2329097 defendant Brygges Richard mercer   Brygges, Richard, mercer 22
4908142 2329097 2329097 defendant all of Huntingdon except where stated otherwise     all of Huntingdon, except where stated otherwise 23

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