names

17 rows where case_id = 2038780

✎ 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
4039589 2038780 2038780 plaintiff Mannynge Christopher gent, attorney of the bench   Mannynge, Christopher, gent, attorney of the bench 0
4039590 2038780 2038780 defendant Gover Christopher yeoman 680248 680248 Gover, Christopher, of Hemberye, yeoman 0
4039591 2038780 2038780 defendant Bremley Lawrence hosier 588557 588557 Bremley, Lawrence, of Tyverton, hosier 1
4039592 2038780 2038780 defendant Salterne Roger husbandman 680249 680249 Salterne, Roger, of Ware Gifford, husbandman 2
4039593 2038780 2038780 defendant Comer Thomas husbandman 587196 587196 Comer, Thomas, of Fremyngton, husbandman 3
4039594 2038780 2038780 defendant Comer Robert husbandman 587196 587196 Comer, Robert, of Fremyngton, husbandman 4
4039595 2038780 2038780 defendant Loman Elizabeth widow 680250 680250 Loman, Elizabeth, of Lyppytt, widow 5
4039596 2038780 2038780 defendant Norrington Edward husbandman 635693 635693 Norrington, Edward, of Luppytt, husbandman 6
4039597 2038780 2038780 defendant Hylner Lawrence yeoman 596160 596160 Hylner, Lawrence, of Sylverton, yeoman 7
4039598 2038780 2038780 defendant Andrewe James husbandman 587196 587196 Andrewe, James, of Fremyngton, husbandman 8
4039599 2038780 2038780 defendant Androwe George yeoman 587196 587196 Androwe, George, of Fremyngton, yeoman 9
4039600 2038780 2038780 defendant Richard John husbandman 671592 671592 Richard, John, of Dolton, husbandman 10
4039601 2038780 2038780 defendant Tanner Nicholas merchant 587196 587196 Tanner, Nicholas, of Fremyngton, merchant 11
4039602 2038780 2038780 defendant Bonde John shoemaker 680251 680251 Bonde, John, of Fortham, shoemaker 12
4039603 2038780 2038780 defendant Fulford John yeoman 680252 680252 Fulford, John, of Borington, yeoman 13
4039604 2038780 2038780 defendant Pound John husbandman 641379 641379 Pound, John, of Plymptre, husbandman 14
4039605 2038780 2038780 defendant Hamonte Robert husbandman 680253 680253 Hamonte, Robert, of Wynckligh, husbandman 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);