names

33 rows where place_id = 640800

✎ 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
3857559 1976000 1976000 defendant Wescott John butcher 640800 640800 Wescott, John, of Newton Abbott, butcher 0
3863100 1977857 1977857 defendant Wyll John currier 640800 640800 Wyll, John, of Newton Abbott, currier 0
3885344 1985354 1985354 defendant Babbe William butcher 640800 640800 Babbe, William, of Newton Abbott, butcher 1
3885345 1985354 1985354 defendant Idell Richard butcher 640800 640800 Idell, Richard, of Newton Abbott, butcher 2
3896303 1988975 1988975 defendant Wyll John   640800 640800 Wyll, John, of Newton Abbott, "coryer" 0
3898707 1989774 1989774 defendant Harvy Andrew butcher 640800 640800 Harvy, Andrew, of Newton Abbott, butcher 2
3898708 1989774 1989774 defendant Edyll Richard butcher 640800 640800 Edyll, Richard, of Newton Abbott, butcher 3
3904972 1991925 1991925 defendant Wyll John   640800 640800 Wyll, John, of Newton Abbott, "coryer" 0
3904974 1991926 1991926 defendant Segar John butcher 640800 640800 Segar, John, of Newton Abbott, butcher 0
3910617 1993867 1993867 defendant Wyll William currier 640800 640800 Wyll, William, of Newton Abbott, currier 0
3934221 2001739 2001739 defendant Throweston John butcher 640800 640800 Throweston, John, of Newton Abbott, butcher 0
3938695 2003285 2003285 plaintiff Raynold Henry chapman 640800 640800 Raynold, Henry, of Newton Abbott, chapman 0
3950658 2007304 2007304 plaintiff Gaveroke John (legal representative) 640800 640800 Gaveroke, John, of Newton Abbott, executors of 0
3950660 2007304 2007304 defendant Coyle or Boyle John baker 640800 640800 Coyle or Boyle, John, of Newton Abbott, baker 0
3950661 2007305 2007305 plaintiff Gaveroke John (legal representative) 640800 640800 Gaveroke, John, of Newton Abbott, executors of 0
3967545 2013280 2013280 defendant Harvey Roger butcher 640800 640800 Harvey, Roger, of Newton Abbott, butcher 0
3980748 2017876 2017876 defendant Hole Thomas tanner 640800 640800 Hole, Thomas, of Newton Abbott, tanner 2
3981665 2018199 2018199 defendant Glawen Robert butcher 640800 640800 Glawen, Robert, of Newton Abbott, butcher 0
3981692 2018209 2018209 defendant Bratfield Thomas shoemaker 640800 640800 Bratfield, Thomas, of Newton Abbott, shoemaker 0
3981694 2018210 2018210 defendant Hervey Andrew butcher 640800 640800 Hervey, Andrew, of Newton Abbott, butcher 0
3982233 2018411 2018411 defendant Harvye Roger butcher 640800 640800 Harvye, Roger, of Newton Abbott, butcher 0
4009651 2028221 2028221 defendant Harvye Roger butcher 640800 640800 Harvye, Roger, of Newton Abbott, butcher 0
4017997 2031153 2031153 defendant Wyll or Wylly William baker 640800 640800 Wyll or Wylly, William, of Newton Abbott, baker 0
4034868 2037148 2037148 plaintiff Hayman Robert yeoman 640800 640800 Hayman, Robert, of Newton Abbott, yeoman 0
4108818 2063405 2063405 defendant Ball Robert weaver 640800 640800 Ball, Robert, of Newton Abbott, weaver 0
4199863 2095502 2095502 defendant Langworthie Daniel weaver 640800 640800 Langworthie, Daniel, of Newton Abbott, weaver 0
4199865 2095503 2095503 defendant Langworthye Daniel weaver 640800 640800 Langworthye, Daniel, of Newton Abbott, weaver 0
4213849 2100364 2100364 defendant Redford Elizabeth widow 640800 640800 Redford, Elizabeth, of Newton Abbott, widow 0
4213850 2100364 2100364 defendant Hore Elizabeth spinster 640800 640800 Hore, Elizabeth, of Newton Abbott, spinster 1
4228379 2105408 2105408 defendant Heyman Richard yeoman 640800 640800 Heyman, Richard, of Newton Abbott, yeoman 0
4228382 2105409 2105409 defendant Heyman Richard yeoman 640800 640800 Heyman, Richard, of Newton Abbott, yeoman 0
4284519 2124511 2124511 defendant Brice James glover 640800 640800 Brice, James, of Newton Abbott, glover 0
4389025 2160960 2160960 defendant Langdon John yeoman 640800 640800 Langdon, John, of Newton Abbott, yeoman 2

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