names

51 rows where place_id = 605668

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662512 1914191 1914191 defendant Broke William   605668 605668 Broke, William, of Crowland 1
3763217 1946131 1946131 defendant Broke William chapman 605668 605668 Broke, William, of Crowland, chapman 0
3820374 1964250 1964250 defendant Peycok Richard yeoman 605668 605668 Peycok, Richard, of Crowland, yeoman 1
3867254 1979284 1979284 defendant Comforth Henry fisher 605668 605668 Comforth, Henry, of Crowland, fisher 0
3867255 1979284 1979284 defendant Tewe Richard fisher 605668 605668 Tewe, Richard, of Crowland, fisher 1
3867256 1979284 1979284 defendant Alegh William tailor 605668 605668 Alegh, William, of Crowland, tailor 2
4005234 2026652 2026652 defendant Collyer William chandler 605668 605668 Collyer, William, of Crowland, chandler 1
4033296 2036561 2036561 defendant Rogers Thomas fisherman or husbandman 605668 605668 Rogers, Thomas, of Crowland, fisherman or husbandman 1
4033297 2036561 2036561 defendant Collyer William chandler 605668 605668 Collyer, William, of Crowland, chandler 2
4033306 2036563 2036563 defendant Rogers Thomas fisherman 605668 605668 Rogers, Thomas, of Crowland, fisherman 1
4033307 2036563 2036563 defendant Collyer William chandler 605668 605668 Collyer, William, of Crowland, chandler 2
4051208 2042871 2042871 defendant Durant John yeoman 605668 605668 Durant, John, of Crowland, yeoman 1
4051209 2042871 2042871 defendant Rogers Thomas yeoman 605668 605668 Rogers, Thomas, of Crowland, yeoman 2
4051212 2042872 2042872 defendant Durant John yeoman 605668 605668 Durant, John, of Crowland, yeoman 1
4081411 2053660 2053660 defendant Durrant John yeoman 605668 605668 Durrant, John, of Crowland, yeoman 0
4081414 2053661 2053661 defendant Walker Roger yeoman 605668 605668 Walker, Roger, of Crowland, yeoman 1
4120925 2067770 2067770 defendant Richardson Richard waterman 605668 605668 Richardson, Richard, of Crowland, waterman 0
4140434 2074823 2074823 defendant Sampson Robert yeoman 605668 605668 Sampson, Robert, of Crowland, yeoman 0
4140435 2074823 2074823 defendant Bridgforth William yeoman 605668 605668 Bridgforth, William, of Crowland, yeoman 1
4167180 2084025 2084025 defendant Costonne William tanner 605668 605668 Costonne, William, of Crowland, tanner 1
4167181 2084025 2084025 defendant Robert Thomas laborer 605668 605668 Robert, Thomas, of Crowland, laborer 2
4171672 2085558 2085558 defendant Cosonne or Cowsonne William tanner 605668 605668 Cosonne or Cowsonne, William, of Crowland, tanner 1
4171673 2085558 2085558 defendant Robert Thomas laborer 605668 605668 Robert, Thomas, of Crowland, laborer 2
4175073 2086745 2086745 defendant Durante John fisher 605668 605668 Durante, John, of Crowland, yeoman, fisher 0
4178011 2087780 2087780 defendant Gamble William yeoman 605668 605668 Gamble, William, of Crowland, yeoman 0
4187380 2091088 2091088 defendant Cherington Richard fisher 605668 605668 Cherington, Richard, of Crowland, fisher 0
4187381 2091088 2091088 defendant Allatt John fisher 605668 605668 Allatt, John, of Crowland, yeoman, fisher 1
4187382 2091088 2091088 defendant Chester Arden tanner 605668 605668 Chester, Arden, of Crowland, yeoman, tanner 2
4187383 2091088 2091088 defendant Weeche Thomas fisher 605668 605668 Weeche, Thomas, of Crowland, yeoman, fisher 3
4187389 2091090 2091090 defendant Gamble William yeoman 605668 605668 Gamble, William, of Crowland, yeoman 0
4187390 2091090 2091090 defendant Weech or Wyche Robert yeoman 605668 605668 Weech or Wyche, Robert, of Crowland, yeoman 1
4187391 2091090 2091090 defendant Fysher John yeoman 605668 605668 Fysher, John, of Crowland, yeoman 2
4187392 2091090 2091090 defendant Cowson William yeoman or tanner 605668 605668 Cowson, William, of Crowland, yeoman or tanner 3
4187409 2091095 2091095 defendant Addyson Robert fisher 605668 605668 Addyson, Robert, of Crowland, yeoman, fisher 0
4187410 2091095 2091095 defendant Robertes Thomas yeoman 605668 605668 Robertes, Thomas, of Crowland, yeoman 1
4198410 2094990 2094990 defendant Durant John yeoman 605668 605668 Durant, John, of Crowland, yeoman 0
4201262 2095995 2095995 defendant Gamble William yeoman 605668 605668 Gamble, William, of Crowland, yeoman 0
4210714 2099304 2099304 defendant Gamble William yeoman 605668 605668 Gamble, William, of Crowland, yeoman 0
4210717 2099304 2099304 defendant Cowsen or Cosen William tanner 605668 605668 Cowsen or Cosen, William, of Crowland, yeoman, tanner 3
4210957 2099392 2099392 defendant Addison Robert fisher 605668 605668 Addison, Robert, of Crowland, yeoman, fisher 0
4210958 2099392 2099392 defendant Robert or Robartes Thomas   605668 605668 Robert or Robartes, Thomas, of Crowland yeoman or laborer 1
4210959 2099392 2099392 defendant Warde John   605668 605668 Warde, John, of Crowland, yeoman, boatwright 2
4210962 2099393 2099393 defendant Cherington Richard fisher 605668 605668 Cherington, Richard, of Crowland, yeoman, fisher 0
4210963 2099393 2099393 defendant Allatt John fisher 605668 605668 Allatt, John, of Crowland, yeoman, fisher 1
4210964 2099393 2099393 defendant Chester Arden fisher 605668 605668 Chester, Arden, of Crowland, yeoman, fisher 2
4210965 2099393 2099393 defendant Weeche Thomas fisher 605668 605668 Weeche, Thomas, of Crowland, yeoman, fisher 3
4236010 2108169 2108169 defendant Durrante John yeoman 605668 605668 Durrante, John, of Crowland, yeoman 0
4293373 2127693 2127693 defendant Smartfont or Smartfout Richard baker 605668 605668 Smartfont or Smartfout, Richard, of Crowland, or of Wysbiche, Isle of Ely, Cams, baker 0
4353995 2148624 2148624 defendant Bend John husbandman 605668 605668 Bend, John, of Crowland, husbandman 1
4379162 2157629 2157629 defendant Durant Roger yeoman 605668 605668 Durant, Roger, of Crowland, yeoman 0
5031319 2366015 2366015 defendant Wryght John husbandman 605668 605668 Wryght, John, of Crowland, husbandman 6

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