names

15 rows where case_id = 2304033

✎ 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
4825549 2304033 2304033 plaintiff Upton William     Upton, William, on his own account 0
4825550 2304033 2304033 defendant Glaston William merchant 586286 586286 Glaston, William, of Boston, merchant 0
4825551 2304033 2304033 defendant Taillour Walter husbandman 594426 594426 Taillour, Walter, of Benyngton, husbandman 1
4825552 2304033 2304033 defendant Fyssher Ralph husbandman 808353 808353 Fyssher, Ralph, of Boteswyk, husbandman 2
4825553 2304033 2304033 defendant Curson John husbandman 593335 593335 Curson, John, of Toft, husbandman 3
4825554 2304033 2304033 defendant Iveson John husbandman 756733 756733 Iveson, John, of Kirketon in Holand, husbandman 4
4825555 2304033 2304033 defendant Wryght John   586286 586286 Wryght, John, of Boston, wright 5
4825556 2304033 2304033 defendant Wilughby William milner 594426 594426 Wilughby, William, of Benyngton, milner 6
4825557 2304033 2304033 defendant Warwyk Richard husbandman 772122 772122 Warwyk, Richard, of Fenne by Boston, husbandman 7
4825558 2304033 2304033 defendant Symson Thomas laborer 600531 600531 Symson, Thomas, of Fenne, laborer 8
4825559 2304033 2304033 defendant Loke Roger   589593 589593 Loke, Roger, of Swyneshed, mason 9
4825560 2304033 2304033 defendant Hervy Michael chaplain 739739 739739 Hervy, Michael, of Kirketon, chaplain 10
4825561 2304033 2304033 defendant Puttok John administrators of   Puttok, John, administrators of 11
4825562 2304033 2304033 defendant Pynchebek John laborer 597328 597328 (Pynchebek, John, of Leke, laborer 12
4825563 2304033 2304033 defendant Puttok Anne widow & formerly wife of John Puttok 597328 597328 Puttok, Anne, of Leke, widow & formerly wife of John Puttok 13

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