names

12 rows where case_id = 2491595

✎ 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
5455653 2491595 2491595 plaintiff Brampton Thomas     Brampton, Thomas, on his own account 0
5455654 2491595 2491595 defendant Musterder Thomas husbandman 655131 655131 Musterder, Thomas, of Canston, husbandman 0
5455655 2491595 2491595 defendant Barnard Thomas husbandman 588126 588126 Barnard, Thomas, of North Walsham, husbandman 1
5455656 2491595 2491595 defendant Rychardys Thomas husbandman 655131 655131 Rychardys, Thomas, of Canston, husbandman 2
5455657 2491595 2491595 defendant Mony Edmund husbandman 600826 600826 Mony, Edmund, of Sheryngton, husbandman 3
5455658 2491595 2491595 defendant Hachet Richard   588926 588926 Hachet, Richard, of North Elmham, shepherd 4
5455659 2491595 2491595 defendant Molet Richard tailor 613860 613860 Molet, Richard, of Matyshale, tailor 5
5455660 2491595 2491595 defendant Wattys Robert husbandman 586471 586471 Wattys, Robert,of Aylesham, husbandman 6
5455661 2491595 2491595 defendant Choket William husbandman 586168 586168 Choket, William, of Skernyng, husbandman 7
5455662 2491595 2491595 defendant Hamme John husbandman 587172 587172 Hamme, John, of East Derham, husbandman 8
5455663 2491595 2491595 defendant Loveday John esq 585936 585936 Loveday, John, of Norwich, esq 9
5455664 2491595 2491595 defendant Ony or Ovy of Oby or Quy Robert husbandman 609683 609683 Ony or Ovy of Oby or Quy, Robert, of Eccles, husbandman 10

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