names

16 rows where case_id = 2481243

✎ 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
5421110 2481243 2481243 plaintiff Wolman Thomas     Wolman, Thomas, on his own account 0
5421111 2481243 2481243 defendant Barker William chaplain 589398 589398 Barker, William, of Blofeld, chaplain 0
5421112 2481243 2481243 defendant Roket John chapman 598258 598258 Roket, John, of Bury St Edmunds, Suff, chapman 1
5421113 2481243 2481243 defendant Barker Robert clerk 602137 602137 Barker, Robert, of Ingworth, clerk 2
5421114 2481243 2481243 defendant Wether William carpenter 603983 603983 Wether, William, of Little Walsyngham, carpenter 3
5421115 2481243 2481243 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 4
5421116 2481243 2481243 defendant Stokes Thomas husbandman 594663 594663 Stokes, Thomas, of Swenyngton, husbandman 5
5421117 2481243 2481243 defendant Blome Roger husbandman 586819 586819 Blome, Roger, of Worsted, husbandman 6
5421118 2481243 2481243 defendant Smyth Robert husbandman 594337 594337 Smyth, Robert, of Asshyll, husbandman 7
5421119 2481243 2481243 defendant Lombe Robert (legal representative) 587331 587331 Lombe, Robert, of Causton, husbandman, executors of 8
5421120 2481243 2481243 defendant Goodman Henry husbandman 587331 587331 (Goodman, Henry, of Causton, husbandman 9
5421121 2481243 2481243 defendant Holme Simon husbandman 587331 587331 Holme, Simon, of Causton, husbandman 10
5421122 2481243 2481243 defendant Funteyn Thomas husbandman 587166 587166 Funteyn, Thomas, of Salle, husbandman 11
5421123 2481243 2481243 defendant Funteyn John husbandman 587166 587166 (Funteyn, John, of Salle, husbandman 12
5421124 2481243 2481243 defendant Funteyn William husbandman 587166 587166 Funteyn, William, of Salle, husbandman 13
5421125 2481243 2481243 defendant Hanson Edmund clerk 595471 595471 Hanson, Edmund, of Whitwell, clerk 14

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