names

21 rows where case_id = 1904602

✎ 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
3631291 1904602 1904602 plaintiff Gelgelt Edmund   586134 586134 Gelgelt, Edmund, of Ipswich 0
3631292 1904602 1904602 defendant Gosenold Thomas smith 586941 586941 Gosenold, Thomas, of Boxford, smith 0
3631293 1904602 1904602 defendant Horswreth John husbandman 592109 592109 Horswreth, John, of Kersey, husbandman 1
3631294 1904602 1904602 defendant Baker Simon smith 598138 598138 Baker, Simon, of Botolvysdale, smith 2
3631295 1904602 1904602 defendant Smyth Robert yeoman 586587 586587 Smyth, Robert, of Rekynghale Inferior, yeoman 3
3631296 1904602 1904602 defendant Russhbroke Robert clothmaker 588273 588273 Russhbroke, Robert, of Stowmarket, clothmaker 4
3631297 1904602 1904602 defendant Collys George merchant 598139 598139 Collys, George, of Walberiswyke, merchant 5
3631298 1904602 1904602 defendant Harforth Thomas merchant 586134 586134 Harforth, Thomas, of Ipswich, merchant 6
3631299 1904602 1904602 defendant Leche John smith 596671 596671 Leche, John, of Wykham Market, smith 7
3631300 1904602 1904602 defendant Leche Geoffrey husbandman 594202 594202 Leche, Geoffrey, of Eston juxta Letheryngham, husbandman 8
3631301 1904602 1904602 defendant Ufford Thomas merchant 585933 585933 Ufford, Thomas, of Great Yarmouth, merchant 9
3631302 1904602 1904602 defendant Reynold John clothmaker 586134 586134 Reynold, John, of Ipswich, clothmaker 10
3631303 1904602 1904602 defendant Brade John merchant 586134 586134 Brade, John, of Ipswich, merchant 11
3631304 1904602 1904602 defendant Denny George husbandman 590991 590991 Denny, George, of Gyppyng, husbandman 12
3631305 1904602 1904602 defendant Whitlee William smith 591296 591296 Whitlee, William, of Hadlee, smith 13
3631306 1904602 1904602 defendant Smyth Robert (legal representative) 598140 598140 Smyth, Robert, of Storyngston Strete, smith, executors of 14
3631307 1904602 1904602 defendant Smyth Joan widow 596344 596344 (Smyth, Joan, of Stoke juxta Neylond, widow 15
3631308 1904602 1904602 defendant Skete John butcher 592109 592109 Skete, John, of Kersey, butcher 16
3631309 1904602 1904602 defendant Whitman Richard husbandman 586160 586160 Whitman, Richard, of Henley, husbandman 17
3631310 1904602 1904602 defendant Hacche Nicholas husbandman 586160 586160 Hacche, Nicholas, of Henley, husbandman 18
3631311 1904602 1904602 defendant Aleyn or Aldyn Nicholas husbandman 593991 593991 Aleyn or Aldyn, Nicholas, of Gosbak, husbandman 19

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