names

18 rows where case_id = 2353818

✎ 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
4989605 2353818 2353818 plaintiff Bury John     Bury, John 0
4989606 2353818 2353818 defendant Hese Stephen   601709 601709 Hese, Stephen, of Kelsale 0
4989607 2353818 2353818 defendant Baret Alan gent 586180 586180 Baret, Alan, of Bury St Edmunds, gent 1
4989608 2353818 2353818 defendant Saym John yeoman 831371 831371 Saym, John, of Fakenham or Faltenham, yeoman 2
4989609 2353818 2353818 defendant Wellys John yeoman 831372 831372 Wellys, John, of Sysewellys, yeoman 3
4989610 2353818 2353818 defendant Mynter John husbandman 621402 621402 Mynter, John, of Tudenham, husbandman 4
4989611 2353818 2353818 defendant Ditton William of South Emham husbandman   Ditton, William of South Emham, husbandman 5
4989612 2353818 2353818 defendant Bust John chaplain 586134 586134 Bust, John, of Ipswich, chaplain 6
4989613 2353818 2353818 defendant Dunch John dyer 586134 586134 Dunch, John, of Ipswich, dyer 7
4989614 2353818 2353818 defendant Hayle John yeoman 586134 586134 Hayle, John, of Ipswich, yeoman 8
4989615 2353818 2353818 defendant Mildenhale John husbandman 769003 769003 Mildenhale, John, of Brysete, husbandman 9
4989616 2353818 2353818 defendant Monk Robert yeoman 585934 585934 Monk, Robert, of Becclys, yeoman 10
4989617 2353818 2353818 defendant Ravene John tailor 586405 586405 Ravene, John, of Nedham Market, tailor 11
4989618 2353818 2353818 defendant Thweyt Mathew   753777 753777 Thweyt, Mathew, of Wetheryngsete, husb 12
4989619 2353818 2353818 defendant Lynge John clerk 831374 831374 Lynge, John, of Cretyngham All Saints, clerk 13
4989620 2353818 2353818 defendant Syllvestre Richard husbandman 779337 779337 Syllvestre, Richard, of Moneweden, husbandman 14
4989621 2353818 2353818 defendant Starlyng Robert husbandman 601078 601078 Starlyng, Robert, of Framesden, husbandman 15
4989622 2353818 2353818 defendant Aldhowe Thomas gent 589167 589167 Aldhowe, Thomas, of Mendelysham, gent 16

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