names

33 rows where place_id = 651982

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3920867 1997323 1997323 defendant Wyllye Thomas clerk 651982 651982 Wyllye, Thomas, of Yoxforde, clerk 0
3967375 2013217 2013217 defendant Cooke William, junior yeoman 651982 651982 Cooke, William, junior, of Yoxforde, yeoman 1
3967503 2013270 2013270 defendant Rushe Robert   651982 651982 Rushe, Robert, of Yoxforde, mason 0
3974933 2015799 2015799 defendant Hopton Owen   651982 651982 Hopton, Owen, of Yoxforde, or of Cockefilde Hanle, Suff, knight 0
4019203 2031605 2031605 defendant Feveryere Thomas (legal representative) 651982 651982 Feveryere, Thomas, of Yoxforde, husbandman, executors of 0
4019204 2031605 2031605 defendant Smyth Richard blacksmith 651982 651982 (Smyth, Richard, of Yoxforde, blacksmith 1
4020758 2032153 2032153 plaintiff Woodcoke William yeoman 651982 651982 Woodcoke, William, of Yoxforde, yeoman 0
4020759 2032153 2032153 defendant Russhe Robert yeoman 651982 651982 Russhe, Robert, of Yoxforde, yeoman 0
4061894 2046650 2046650 defendant Block Nicholas husbandman 651982 651982 Block, Nicholas, of Yoxforde, husbandman 1
4072337 2050408 2050408 defendant Godynge John shoemaker 651982 651982 Godynge, John, of Yoxforde, shoemaker 1
4072338 2050408 2050408 defendant Wysbyche William husbandman 651982 651982 Wysbyche, William, of Yoxforde, husbandman 2
4086196 2055336 2055336 defendant Cocke James yeoman 651982 651982 Cocke, James, of Yoxforde, yeoman 1
4104944 2062045 2062045 defendant Osborne Thomas yeoman 651982 651982 Osborne, Thomas, of Yoxforde, yeoman 1
4141386 2075144 2075144 defendant Cappe John butcher 651982 651982 Cappe, John, of Yoxforde, butcher 0
4150927 2078455 2078455 defendant Smythe Richard husbandman 651982 651982 Smythe, Richard, of Yoxforde, husbandman 3
4150947 2078461 2078461 defendant Whynnery Nicholas yeoman 651982 651982 Whynnery, Nicholas, of Yoxforde, yeoman 1
4154497 2079665 2079665 defendant Whynerye or Whinwerye Nicholas grocer 651982 651982 Whynerye or Whinwerye, Nicholas, of Yoxforde, grocer 0
4155822 2080116 2080116 defendant Crispe Mathew gent 651982 651982 Crispe, Mathew, of Yoxforde, gent 1
4162297 2082373 2082373 defendant Whynnerye Robert yeoman 651982 651982 Whynnerye, Robert, of Yoxforde, yeoman 0
4166254 2083693 2083693 defendant Cappe John butcher 651982 651982 Cappe, John, of Yoxforde, butcher 0
4175594 2086933 2086933 defendant Whinnerye Nicholas yeoman 651982 651982 Whinnerye, Nicholas, of Yoxforde, yeoman 1
4205071 2097319 2097319 defendant Baldwyn Robert yeoman 651982 651982 Baldwyn, Robert, of Yoxforde, yeoman 0
4227507 2105104 2105104 defendant Whynnery Nicholas yeoman 651982 651982 Whynnery, Nicholas, of Yoxforde, yeoman 0
4244988 2111306 2111306 defendant Darbye Hugh gardiner 651982 651982 Darbye, Hugh, of Yoxforde, gardiner 3
4329268 2140102 2140102 defendant Crispe Mathew (legal representative) 651982 651982 Crispe, Mathew, of Yoxforde, gent, administrator of 0
4330964 2140656 2140656 defendant Whynerye Nicholas yeoman 651982 651982 Whynerye, Nicholas, of Yoxforde, yeoman 1
4342545 2144666 2144666 defendant Whynrey Nicholas yeoman 651982 651982 Whynrey, Nicholas, of Yoxforde, yeoman 0
4393510 2162430 2162430 defendant Whenerye or Wheverye Nicholas yeoman 651982 651982 Whenerye or Wheverye, Nicholas, of Yoxforde, yeoman 2
4400492 2164758 2164758 defendant Rushe Lionel   651982 651982 Rushe, Lionel, of Yoxforde, mason 1
4406337 2166686 2166686 defendant Hancocke Robert yeoman 651982 651982 Hancocke, Robert, of Yoxforde, yeoman 1
4406338 2166686 2166686 defendant Farrowe Henry yeoman 651982 651982 Farrowe, Henry, of Yoxforde, yeoman 2
4406339 2166686 2166686 defendant Mise Nicholas yeoman 651982 651982 Mise, Nicholas, of Yoxforde, yeoman 3
4669178 2256065 2256065 defendant Skothawe John husbandman 651982 651982 Skothawe, John, of Yoxforde, husbandman 3

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