names

17 rows where case_id = 2425766

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5234795 2425766 2425766 defendant Lynsted Edmund yeoman 602186 602186 Lynsted, Edmund, of Happysburgh, yeoman 0
5234796 2425766 2425766 defendant Souter Thomas souter 602186 602186 Souter, Thomas, of Happysburgh, souter 1
5234797 2425766 2425766 defendant Horn Nicholas smith 602186 602186 Horn, Nicholas, of Happysburgh, smith 2
5234798 2425766 2425766 defendant Levedy Robert husbandman 602186 602186 Levedy, Robert, of Happysburgh, husbandman 3
5234799 2425766 2425766 defendant Turnour William thatcher 602186 602186 Turnour, William, of Happysburgh, thatcher 4
5234800 2425766 2425766 defendant Bevys Thomas husbandman 602186 602186 Bevys, Thomas, of Happysburgh, husbandman 5
5234801 2425766 2425766 defendant Auncell John husbandman 602186 602186 Auncell, John, of Happysburgh, husbandman 6
5234802 2425766 2425766 defendant Cryspyng Edmund husbandman 602186 602186 Cryspyng, Edmund, of Happysburgh, husbandman 7
5234803 2425766 2425766 defendant Bange John husbandman 602186 602186 Bange, John, of Happysburgh, husbandman 8
5234804 2425766 2425766 defendant Middelton Edmund husbandman 602186 602186 Middelton, Edmund, of Happysburgh, husbandman 9
5234805 2425766 2425766 defendant Lincoln William   862448 862448 Lincoln, William, of miller 10
5234806 2425766 2425766 defendant Lincoln Thomas   773310 773310 Lincoln, Thomas, of butcher 11
5234807 2425766 2425766 defendant Felbrigge John husbandman   Felbrigge, John, husbandman 12
5234808 2425766 2425766 defendant Felbrige Thomas husbandman   Felbrige, Thomas, husbandman 13
5234809 2425766 2425766 defendant Parker John husbandman   Parker, John, husbandman 14
5234810 2425766 2425766 defendant Litill Thomas husbandman   Litill, Thomas, husbandman 15
5234811 2425766 2425766 defendant Hoste Stephen merchant 833070 833070 Hoste, Stephen, of Nrowich, merchant 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);