names

11 rows where case_id = 2043550

✎ 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
4053274 2043550 2043550 plaintiff Amyas Thomas gent, attorney of the bench   Amyas, Thomas, gent, attorney of the bench 0
4053275 2043550 2043550 defendant Seman William yeoman 648202 648202 Seman, William, of Carleton Roode, or of Dyckleborowe, yeoman 0
4053276 2043550 2043550 defendant Bore William alias Dyck Swasshe, of Laiston, Suff, horse leach, or Tompson, Norf, husbandman   Bore, William, alias Dyck Swasshe, of Laiston, Suff, horse leach, or Tompson, Norf, husbandman 1
4053277 2043550 2043550 defendant Edward John   587414 587414 Edward, John, of Thetford, burgess 2
4053278 2043550 2043550 defendant Lyghtwyn John husbandman 590539 590539 Lyghtwyn, John, of Hethersett, husbandman 3
4053279 2043550 2043550 defendant Byllysbye Edward gent 683269 683269 Byllysbye, Edward, of Byllysbye, Lincs, gent 4
4053280 2043550 2043550 defendant Moultyng John yeoman 586057 586057 Moultyng, John, of Walpole, yeoman 5
4053281 2043550 2043550 defendant Garrard John miller 588456 588456 Garrard, John, of Yarmouth, miller 6
4053282 2043550 2043550 defendant Cresse John husbandman 591527 591527 Cresse, John, of Gorleston, Suff, husbandman 7
4053283 2043550 2043550 defendant Beverley John mercer 618231 618231 Beverley, John, of Swaffham Markett, mercer 8
4053284 2043550 2043550 defendant Fyssher John clerk 629618 629618 Fyssher, John, of Elden, Suff, clerk 9

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