names

21 rows where place_id = 604792

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659305 1913168 1913168 defendant Flemyng Martin clothman 604792 604792 Flemyng, Martin, of Chyppenham, clothman 0
3703762 1927455 1927455 defendant Parysshe John laborer 604792 604792 Parysshe, John, of Chyppenham, laborer 3
3755679 1943734 1943734 defendant Pontley John weaver 604792 604792 Pontley, John, of Chyppenham, weaver 0
3755680 1943734 1943734 defendant Blyke John husbandman 604792 604792 Blyke, John, of Chyppenham, husbandman 1
3784299 1952880 1952880 defendant Alyzaunderson Robert clerk 604792 604792 Alyzaunderson, Robert, of Chyppenham, clerk 0
3804632 1959389 1959389 defendant Baker Robert butcher 604792 604792 Baker, Robert, of Chyppenham, butcher 0
3804638 1959390 1959390 defendant Baker Robert butcher 604792 604792 Baker, Robert, of Chyppenham, butcher 0
3813262 1962060 1962060 plaintiff Drake Thomas   604792 604792 Drake, Thomas, of Chyppenham 0
3839648 1970325 1970325 defendant Gee Nicholas husbandman 604792 604792 Gee, Nicholas, of Chyppenham, husbandman 3
3895383 1988665 1988665 defendant Vynsent John tanner 604792 604792 Vynsent, John, of Chyppenham, tanner 2
3901261 1990646 1990646 defendant Braser John laborer 604792 604792 Braser, John, of Chyppenham, laborer 2
3929201 2000109 2000109 defendant Andrew James yeoman 604792 604792 Andrew, James, of Chyppenham, yeoman 0
3971014 2014419 2014419 defendant Motte John yeoman 604792 604792 Motte, John, of Chyppenham, yeoman 2
5072963 2378400 2378400 defendant Deveros or Deneros Robert ostler 604792 604792 Deveros or Deneros, Robert, of Chyppenham, ostler 0
5214845 2420062 2420062 defendant Brouker or Bronker John   604792 604792 Brouker or Bronker, John, of Chyppenham, franklin 0
5272328 2436977 2436977 defendant Harryes John husbandman 604792 604792 Harryes, John, of Chyppenham, husbandman 0
5325903 2452833 2452833 defendant Wheler John clothier 604792 604792 Wheler, John, of Chyppenham, clothier 0
5325904 2452833 2452833 defendant Style Richard husbandman 604792 604792 Style, Richard, of Chyppenham, husbandman 1
5325907 2452834 2452834 defendant Wheler John clothier 604792 604792 Wheler, John, of Chyppenham, clothier 0
5325908 2452834 2452834 defendant Style Richard husbandman 604792 604792 Style, Richard, of Chyppenham, husbandman 1
5506924 2507080 2507080 defendant Kyng Thomas innholder 604792 604792 Kyng, Thomas, of Chyppenham, innholder 1

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