names

17 rows where case_id = 2444191

✎ 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
5297250 2444191 2444191 plaintiff Yerburgh John     Yerburgh, John 0
5297251 2444191 2444191 defendant Dughty William gent 586981 586981 Dughty, William,of Louth, gent 0
5297252 2444191 2444191 defendant Eman or Evian Richard   870004 870004 Eman or Evian, Richard, of Louth, yema 1
5297253 2444191 2444191 defendant Wardrope Thomas yeoman 870005 870005 Wardrope, Thomas, of Marchapell, yeoman 2
5297254 2444191 2444191 defendant Spynk William sawyer 586981 586981 Spynk, William, of Louth, sawyer 3
5297255 2444191 2444191 defendant Ukke William husbandman 870006 870006 Ukke, William, of Sjydbroke, husbandman 4
5297256 2444191 2444191 defendant Smeton Robert clerk 615147 615147 Smeton, Robert, of Stuton, clerk 5
5297257 2444191 2444191 defendant Coke Roger shoemaker 586981 586981 Coke, Roger, of Louth, shoemaker 6
5297258 2444191 2444191 defendant Johnson William miller 586981 586981 Johnson, William, of Louth, miller 7
5297259 2444191 2444191 defendant Ely Robert husbandman 594002 594002 Ely, Robert, of Thedylthorp, husbandman 8
5297260 2444191 2444191 defendant Coke Gilbert husbandman 594002 594002 Coke, Gilbert, of Thedylthorp, husbandman 9
5297261 2444191 2444191 defendant Tayllour John tailor 586981 586981 Tayllour, John, of Louth, tailor 10
5297262 2444191 2444191 defendant Cawode John yeoman 586981 586981 together with Cawode, John, of Louth, yeoman 11
5297263 2444191 2444191 defendant Nicholson George barker 586981 586981 Nicholson, George, of Louth, barker 12
5297264 2444191 2444191 defendant Maynerd George   586981 586981 Maynerd, George, of Louth, mason 13
5297265 2444191 2444191 defendant Seler Robert barker 586981 586981 Seler, Robert, of Louth, barker 14
5297266 2444191 2444191 defendant Hopkynson Richard barker 586981 586981 Hopkynson, Richard, of Louth, barker 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);