names

14 rows where case_id = 2456184

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5337141 2456184 2456184 plaintiff Holer John     Holer, John 0
5337142 2456184 2456184 defendant Wyrmyngey Robert yeoman 821611 821611 Wyrmyngey, Robert, of Wyttelyngham, yeoman 0
5337143 2456184 2456184 defendant Banburgh Thomas husbandman 587331 587331 Banburgh, Thomas, of Causton, husbandman 1
5337144 2456184 2456184 defendant Marsham Andrew husbandman 823832 823832 Marsham, Andrew, of Bakonesthorp, husbandman 2
5337145 2456184 2456184 defendant Byrcham John   585936 585936 Byrcham, John, of Norwich, notary 3
5337146 2456184 2456184 defendant Godered John husbandman 587072 587072 Godered, John, of Magna Melton, husbandman 4
5337147 2456184 2456184 defendant Sylveryn Roger husbandman 874959 874959 Sylveryn, Roger, of Panyford, husbandman 5
5337148 2456184 2456184 defendant Maunfreys Adam husbandman 594403 594403 Maunfreys, Adam, of Moweton, husbandman 6
5337149 2456184 2456184 defendant Knot John sherman 585936 585936 Knot, John, of Norwich, sherman 7
5337150 2456184 2456184 defendant Hornyng Giles husbandman 768148 768148 Hornyng, Giles, of Southwode, husbandman 8
5337151 2456184 2456184 defendant Fitlyng John husbandman 586664 586664 Fitlyng, John, of Kymberley, husbandman 9
5337152 2456184 2456184 defendant Tynwryght Edmund husbandman 596676 596676 Tynwryght, Edmund, of Halvergate, husbandman 10
5337153 2456184 2456184 defendant Wasyn or Wafyn William grocer 585936 585936 Wasyn or Wafyn, William, of Norwich, grocer 11
5337154 2456184 2456184 defendant Tony John husbandman 594403 594403 Tony, John, of Moweton, husbandman 12

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