names

13 rows where case_id = 2459430

✎ 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
5347680 2459430 2459430 plaintiff Bisshop John     Bisshop, John 0
5347681 2459430 2459430 defendant Ketilston Thomas husbandman 586130 586130 Ketilston, Thomas, of Hoo, husbandman 0
5347682 2459430 2459430 defendant Bayfeld Peter husbandman 587331 587331 Bayfeld, Peter, of Causton, husbandman 1
5347683 2459430 2459430 defendant Bon Thomas husbandman 586471 586471 Bon, Thomas, of Aylesham, husbandman 2
5347684 2459430 2459430 defendant Broun Thomas parker 602818 602818 Broun, Thomas, of Kelsale, Suff, parker 3
5347685 2459430 2459430 defendant Hallok Thomas husbandman 621736 621736 Hallok, Thomas, of Shetesham, husbandman 4
5347686 2459430 2459430 defendant Thwyte Richard husbandman 876097 876097 Thwyte, Richard, of Stanynghall, husbandman 5
5347687 2459430 2459430 defendant Warner John husbandman 591135 591135 Warner, John, of Dokkyng, husbandman 6
5347688 2459430 2459430 defendant Davy William husbandman 589534 589534 Davy, William, of Depham, husbandman 7
5347689 2459430 2459430 defendant Leem Thomas husbandman 876098 876098 Leem, Thomas, of Croseweyt, husbandman 8
5347690 2459430 2459430 defendant Waterman Henry chaplain 585914 585914 Waterman, Henry, of Nekton, chaplain 9
5347691 2459430 2459430 defendant London Geoffrey husbandman 585914 585914 London, Geoffrey, of Nekton, husbandman 10
5347692 2459430 2459430 defendant Broune Alice widow 585936 585936 Broune, Alice, of Norwich, widow 11

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