names

17 rows where place_id = 604837

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659447 1913214 1913214 defendant Spellys Thomas carpenter 604837 604837 Spellys, Thomas, of Copdok, carpenter 1
3664396 1914815 1914815 defendant Clark Joan widow 604837 604837 Clark, Joan, of Copdok, widow 1
3665322 1915109 1915109 defendant Serle Thomas miller 604837 604837 Serle, Thomas, of Copdok, miller 1
4923258 2333695 2333695 defendant Bouchmaler John yeoman 604837 604837 Bouchmaler, John, of Copdok, yeoman 2
5104273 2387671 2387671 defendant Tascard Richard husbandman 604837 604837 Tascard, Richard, of Copdok, husbandman 0
5104274 2387671 2387671 defendant Tascard John laborer 604837 604837 Tascard, John, of Copdok, laborer 1
5107113 2388510 2388510 defendant Tastard or Tascard Richard husbandman 604837 604837 Tastard or Tascard, Richard, of Copdok, husbandman 0
5216747 2420633 2420633 defendant Cok Robert clerk 604837 604837 Cok, Robert, of Copdok, clerk 0
5310769 2448258 2448258 defendant Tastard William husbandman 604837 604837 Tastard, William, of Copdok, husbandman 0
5351464 2460556 2460556 defendant Rukwod Roger gent 604837 604837 together with Rukwod, Roger, of Copdok, gent 2
5351486 2460561 2460561 defendant Rukwod Roger gent 604837 604837 Rukwod, Roger, of Copdok, gent 0
5355446 2461778 2461778 defendant Rikwod Roger gent 604837 604837 Rikwod, Roger, of Copdok, gent 0
5380905 2469594 2469594 defendant Tastard William yeoman 604837 604837 Tastard, William, of Copdok, yeoman 2
5412213 2478605 2478605 defendant Tastard William husbandman 604837 604837 Tastard, William, of Copdok, husbandman 2
5481238 2499336 2499336 defendant Pascall John husbandman 604837 604837 Pascall, John, of Copdok, husbandman 5
5531574 2514406 2514406 defendant Blosse Thomas husbandman 604837 604837 Blosse, Thomas, of Copdok, husbandman 2
5552248 2520700 2520700 defendant Archer John husbandman 604837 604837 Archer, John, of Copdok, husbandman 0

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