names

17 rows where case_id = 2038781

✎ 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
4039606 2038781 2038781 plaintiff Mannynge Christopher gent, attorney of the bench   Mannynge, Christopher, gent, attorney of the bench 0
4039607 2038781 2038781 defendant Govers or Gouers Christopher yeoman 680248 680248 Govers or Gouers, Christopher, of Hemberye, yeoman 0
4039608 2038781 2038781 defendant Bromley Lawrence hosier 588557 588557 Bromley, Lawrence, of Tyverton, hosier 1
4039609 2038781 2038781 defendant Sterne Roger of Weare Gyfforde husbandman   Sterne, Roger of Weare Gyfforde, husbandman 2
4039610 2038781 2038781 defendant Comer Thomas husbandman 587196 587196 Comer, Thomas, of Fremyngton, husbandman 3
4039611 2038781 2038781 defendant Comer Robert husbandman 587196 587196 Comer, Robert, of Fremyngton, husbandman 4
4039612 2038781 2038781 defendant Loman Elizabeth widow 660974 660974 Loman, Elizabeth, of Luppitt, widow 5
4039613 2038781 2038781 defendant Norryngton Edward husbandman 635693 635693 Norryngton, Edward, of Luppytt, husbandman 6
4039614 2038781 2038781 defendant Hylmer Lawrence yeoman 596160 596160 Hylmer, Lawrence, of Sylverton, yeoman 7
4039615 2038781 2038781 defendant Andrewe James husbandman 587196 587196 Andrewe, James, of Fremyngton, husbandman 8
4039616 2038781 2038781 defendant Androwe George yeoman 587196 587196 Androwe, George, of Fremyngton, yeoman 9
4039617 2038781 2038781 defendant Richard John husbandman 671592 671592 Richard, John, of Dolton, husbandman 10
4039618 2038781 2038781 defendant Tanner Nicholas   680254 680254 Tanner, Nicholas, of Fremyngton, marchant 11
4039619 2038781 2038781 defendant Bonde John shoemaker 601694 601694 Bonde, John, of Northam, shoemaker 12
4039620 2038781 2038781 defendant Fulford John yeoman 680252 680252 Fulford, John, of Borington, yeoman 13
4039621 2038781 2038781 defendant Pounde John husbandman 665432 665432 Pounde, John, of Plymptree, husbandman 14
4039622 2038781 2038781 defendant Havont Robert husbandman 666239 666239 Havont, Robert, of Wyncklegh, 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);