names

17 rows where case_id = 2477960

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5409997 2477960 2477960 plaintiff Brampton Thomas     Brampton, Thomas, on his own account 0
5409998 2477960 2477960 defendant Michillys Geoffrey husbandman 588931 588931 Michillys, Geoffrey, of Horsham St Faith, husbandman 0
5409999 2477960 2477960 defendant Helmyng John laborer 586516 586516 Helmyng, John, of Marsham, laborer 1
5410000 2477960 2477960 defendant Musterder Thomas husbandman 587331 587331 Musterder, Thomas, of Causton, husbandman 2
5410001 2477960 2477960 defendant Barnard Thomas husbandman 588126 588126 Barnard, Thomas, of North Walsham, husbandman 3
5410002 2477960 2477960 defendant Richardys Thomas husbandman 588583 588583 Richardys, Thomas, of Caston, husbandman 4
5410003 2477960 2477960 defendant Mony Edmund husbandman 587201 587201 Mony, Edmund, of Sharyngton, husbandman 5
5410004 2477960 2477960 defendant Hachet Richard   588926 588926 Hachet, Richard, of North Elmham, shepherd 6
5410005 2477960 2477960 defendant Malor Richard tailor 613860 613860 Malor, Richard, of Matyshale, tailor 7
5410006 2477960 2477960 defendant Wattys Robert husbandman 586471 586471 Wattys, Robert, of Aylesham, husbandman 8
5410007 2477960 2477960 defendant Choket William husbandman 586168 586168 Choket, William, of Skernyng, husbandman 9
5410008 2477960 2477960 defendant Hamme John husbandman 587172 587172 Hamme, John, of East Derham, husbandman 10
5410009 2477960 2477960 defendant Lovedaye John esq 585936 585936 Lovedaye, John, of Norwich, esq 11
5410010 2477960 2477960 defendant Ony Robert esq 609683 609683 Ony, Robert, of Eccles, esq 12
5410011 2477960 2477960 defendant Willys William yeoman 603616 603616 Willys, William, of Cley next the sea, yeoman 13
5410012 2477960 2477960 defendant Wynter John (legal representative) 596088 596088 Wynter, John, of Kellyng, yeoman, executrix of 14
5410013 2477960 2477960 defendant Wynter Joan widow   Wynter, Joan, widow 15

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