names

107 rows where place_id = 594655

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616222 1872715 1872715 defendant Hale Thomas   594655 594655 Hale, Thomas, of Houghton Conquest, ash burner 0
3617032 1872949 1872949 defendant Conquest Richard, senior gent 594655 594655 Conquest, Richard, senior, of Houghton Conquest, gent 0
3617033 1872949 1872949 defendant Conquest Richard, junior gent 594655 594655 Conquest, Richard, junior, of Houghton Conquest, gent 1
3617035 1872950 1872950 defendant Conquest Richard, senior gent 594655 594655 Conquest, Richard, senior, of Houghton Conquest, gent 0
3617036 1872950 1872950 defendant Conquest Richard, junior gent 594655 594655 Conquest, Richard, junior, of Houghton Conquest, gent 1
3619592 1873697 1873697 defendant Conquest Richard, junior gent 594655 594655 Conquest, Richard, junior, of Houghton Conquest, gent 0
3619593 1873697 1873697 defendant Conquest Richard, senior gent 594655 594655 Conquest, Richard, senior, of Houghton Conquest, gent 1
3625783 1875602 1875602 defendant Conquest Richard, junior gent 594655 594655 Conquest, Richard, junior, of Houghton Conquest, gent 0
3625784 1875602 1875602 defendant Conquest Richard, senior gent 594655 594655 Conquest, Richard, senior, of Houghton Conquest, gent 1
3628250 1903695 1903695 defendant Audeley Thomas yeoman 594655 594655 Audeley, Thomas, of Houghton Conquest, yeoman 0
3628252 1903696 1903696 defendant Audeley Thomas yeoman 594655 594655 Audeley, Thomas, of Houghton Conquest, yeoman 0
3628253 1903696 1903696 defendant Stratton Simon husbandman 594655 594655 Stratton, Simon, of Houghton Conquest, husbandman 1
3686340 1921886 1921886 defendant Conquest Richard gent 594655 594655 Conquest, Richard, of Houghton Conquest, gent 0
3686341 1921886 1921886 defendant Conquest Edmund, junior gent 594655 594655 Conquest, Edmund, junior, of Houghton Conquest, gent 1
3696904 1925252 1925252 defendant Audeley Thomas   594655 594655 Audeley, Thomas, of Houghton Conquest, Beds. Yeoman 3
3755958 1943817 1943817 defendant Stratton Simon husbandman 594655 594655 Stratton, Simon, of Houghton Conquest, husbandman 0
3776724 1950466 1950466 defendant Purser Richard yeoman 594655 594655 Purser, Richard, of Houghton Conquest, yeoman 0
3786276 1953504 1953504 defendant Davy John yeoman 594655 594655 Davy, John, of Houghton Conquest, yeoman 1
3792232 1955423 1955423 defendant Graunt Richard chaplain 594655 594655 Graunt, Richard, of Houghton Conquest, chaplain 0
3792233 1955424 1955424 plaintiff Awdeley Thomas yeoman 594655 594655 Awdeley, Thomas, of Houghton Conquest, yeoman 0
3797220 1957012 1957012 defendant Conquest Richard gent 594655 594655 Conquest, Richard, of Houghton Conquest, gent 1
3808758 1960618 1960618 plaintiff Audeley Thomas yeoman 594655 594655 Audeley, Thomas, of Houghton Conquest, yeoman 0
3843851 1971616 1971616 defendant Nycollys Reginald husbandman 594655 594655 Nycollys, Reginald, of Houghton Conquest, husbandman 0
3843852 1971616 1971616 defendant Alen John, junior husbandman 594655 594655 Alen, John, junior, of Houghton Conquest, husbandman 1
3850402 1973714 1973714 defendant Nycoll Reginald husbandman 594655 594655 Nycoll, Reginald, of Houghton Conquest, husbandman 4
4000420 2024918 2024918 defendant Stratton Edmund husbandman 594655 594655 Stratton, Edmund, of Houghton Conquest, husbandman 0
4094309 2058301 2058301 defendant Cony Edward husbandman 594655 594655 Cony, Edward, of Houghton Conquest, husbandman 2
4152256 2078899 2078899 defendant Carter Mathew laborer 594655 594655 Carter, Mathew, of Houghton Conquest, laborer 0
4306707 2132483 2132483 defendant Robynson John husbandman 594655 594655 Robynson, John, of Houghton Conquest, husbandman 0
4307256 2132676 2132676 defendant Kinge Richard gent 594655 594655 Kinge, Richard, of Houghton Conquest, gent 2
4307257 2132676 2132676 defendant Woodward Edward yeoman 594655 594655 Woodward, Edward, of Houghton Conquest, yeoman 3
4392198 2162014 2162014 defendant Hull Thomas husbandman 594655 594655 Hull, Thomas, of Houghton Conquest, husbandman 1
4437858 2181164 2181164 plaintiff Ai--n John chaplain 594655 594655 Ai--n, John, of Houghton Conquest, chaplain, on his own account 0
4437859 2181164 2181164 defendant Spenser Thomas butcher 594655 594655 Spenser, Thomas, of Houghton Conquest, butcher 0
4572747 2223015 2223015 defendant Bailly Thomas smith 594655 594655 Bailly, Thomas, of Houghton Conquest, smith 4
4645999 2244903 2244903 plaintiff Bodard John   594655 594655 Bodard, John, of Houghton Conquest 1
4651107 2246346 2246346 plaintiff Bilcok John   594655 594655 Bilcok, John, of Houghton Conquest 1
4686212 2261285 2261285 defendant atte Sloo John laborer 594655 594655 atte Sloo, John, of Houghton Conquest, laborer 2
4704827 2266888 2266888 defendant Hare Ralph husbandman 594655 594655 Hare, Ralph, of Houghton Conquest, husbandman 1
4704829 2266888 2266888 defendant Conquest John husbandman 594655 594655 Conquest, John, of Houghton Conquest, husbandman 3
4704830 2266888 2266888 defendant atte Sllo William husbandman 594655 594655 atte Sllo, William, of Houghton Conquest, husbandman 4
4709655 2268385 2268385 defendant Tranell John tanner 594655 594655 Tranell, John, of Houghton Conquest, tanner 0
4737258 2276772 2276772 defendant atte Slowe William husbandman 594655 594655 atte Slowe, William, of Houghton Conquest, husbandman 1
4774193 2287909 2287909 defendant Conquest J_ husbandman 594655 594655 Conquest, J_, of Houghton Conquest, husbandman 5
4816859 2301377 2301377 plaintiff Mason John clerk & parson 594655 594655 Mason, John, of Houghton Conquest, clerk & parson, on his own account 0
4917904 2332115 2332115 plaintiff Goldsmyth Robert clerk 594655 594655 Goldsmyth, Robert, of Houghton Conquest, clerk 0
4917905 2332115 2332115 defendant Mason John (legal representative) 594655 594655 Mason, John, of Houghton Conquest, clerk, executors of 0
4935825 2337595 2337595 plaintiff Bilcok John clerk 594655 594655 Bilcok, John, of Houghton Conquest, clerk 0
4935826 2337595 2337595 defendant Conquest John husbandman 594655 594655 Conquest, John, of Houghton Conquest, husbandman 0
4969272 2347769 2347769 defendant Legger Thomas clerk 594655 594655 Legger, Thomas, of Houghton Conquest, clerk 2
5050756 2371850 2371850 defendant Dylcok Henry chaplain 594655 594655 Dylcok, Henry, of Houghton Conquest, chaplain 0
5061386 2374991 2374991 defendant Launder William husbandman 594655 594655 Launder, William, of Houghton Conquest, husbandman 0
5078404 2380039 2380039 defendant Hare Thomas husbandman 594655 594655 Hare, Thomas, of Houghton Conquest, husbandman 0
5078405 2380039 2380039 defendant Arnold Thomas husbandman 594655 594655 Arnold, Thomas, of Houghton Conquest, husbandman 1
5078406 2380039 2380039 defendant Nicoll William husbandman 594655 594655 Nicoll, William, of Houghton Conquest, husbandman 2
5078407 2380039 2380039 defendant Ascheby Richard singleman 594655 594655 Ascheby, Richard, of Houghton Conquest, singleman 3
5085323 2382100 2382100 defendant Laundere William husbandman 594655 594655 Laundere, William, of Houghton Conquest, husbandman 1
5114170 2390544 2390544 defendant Whitamore Ralph husbandman 594655 594655 Whitamore, Ralph, of Houghton Conquest, husbandman 2
5116913 2391372 2391372 defendant Whitamore William (legal representative) 594655 594655 Whitamore, William, of Houghton Conquest, yeoman, executor of 2
5116914 2391372 2391372 defendant Whitamore Ralph husbandman 594655 594655 Whitamore, Ralph, of Houghton Conquest, husbandman 3
5269436 2436157 2436157 defendant Slowe Robert husbandman 594655 594655 Slowe, Robert, of Houghton Conquest, husbandman 0
5303404 2446012 2446012 defendant Sloo John husbandman 594655 594655 Sloo, John, of Houghton Conquest, husbandman 3
5315474 2449693 2449693 defendant Hale Richard tailor 594655 594655 Hale, Richard, of Houghton Conquest, tailor 1
5315475 2449693 2449693 defendant Hale Thomas tailor 594655 594655 Hale, Thomas, of Houghton Conquest, tailor 2
5315476 2449693 2449693 defendant Hale Thomas husbandman 594655 594655 Hale, Thomas, of Houghton Conquest, husbandman 3
5315477 2449693 2449693 defendant Dyer William husbandman 594655 594655 Dyer, William, of Houghton Conquest, husbandman 4
5338204 2456515 2456515 defendant Sloo John husbandman 594655 594655 Sloo, John, of Houghton Conquest, husbandman 2
5362162 2463831 2463831 defendant Michell alias Assheby John husbandman 594655 594655 Michell alias Assheby, John, of Houghton Conquest, husbandman 1
5362163 2463831 2463831 defendant Slough Robert husbandman 594655 594655 Slough, Robert, of Houghton Conquest, husbandman 2
5363450 2464220 2464220 defendant Assheby Richard husbandman 594655 594655 Assheby, Richard, of Houghton Conquest, husbandman 0
5366341 2465126 2465126 defendant Asheby alias Michell John husbandman 594655 594655 Asheby alias Michell, John, of Houghton Conquest, husbandman 1
5366346 2465127 2465127 defendant Asheby alias Michell John husbandman 594655 594655 Asheby alias Michell, John, of Houghton Conquest, husbandman 2
5366348 2465128 2465128 defendant Dyer William husbandman 594655 594655 Dyer, William, of Houghton Conquest, husbandman 0
5366349 2465128 2465128 defendant Ashebe alias Mecheill John husbandman 594655 594655 Ashebe alias Mecheill, John, of Houghton Conquest, husbandman 1
5366350 2465128 2465128 defendant Clerk John husbandman 594655 594655 Clerk, John, of Houghton Conquest, husbandman 2
5370908 2466489 2466489 defendant Couper John drover 594655 594655 Couper, John, of Houghton Conquest, drover 0
5370910 2466489 2466489 defendant Mychell alias Assheby John drover 594655 594655 Mychell alias Assheby, John, of Houghton Conquest, drover 2
5380414 2469448 2469448 defendant Dyer William husbandman 594655 594655 Dyer, William, of Houghton Conquest, husbandman 0
5380415 2469448 2469448 defendant Hasehele alias Michell John husbandman 594655 594655 Hasehele alias Michell, John, of Houghton Conquest, husbandman 1
5380416 2469448 2469448 defendant Clerke John husbandman 594655 594655 Clerke, John, of Houghton Conquest, husbandman 2
5380417 2469448 2469448 defendant Couper John husbandman 594655 594655 Couper, John, of Houghton Conquest, husbandman 3
5380419 2469449 2469449 defendant Dyer William husbandman 594655 594655 Dyer, William, of Houghton Conquest, husbandman 0
5380420 2469449 2469449 defendant Hasthele alias Michell John husbandman 594655 594655 Hasthele alias Michell, John, of Houghton Conquest, husbandman 1
5380421 2469449 2469449 defendant Couper John husbandman 594655 594655 Couper, John, of Houghton Conquest, husbandman 2
5380422 2469449 2469449 defendant Clerke John husbandman 594655 594655 Clerke, John, of Houghton Conquest, husbandman 3
5382718 2470119 2470119 defendant Couper John   594655 594655 Couper, John, of Houghton Conquest 0
5382719 2470119 2470119 defendant Stanford William chaplain 594655 594655 Stanford, William, of Houghton Conquest, chaplain 1
5382721 2470120 2470120 defendant Pouter or Ponter Henry husbandman 594655 594655 Pouter or Ponter, Henry, of Houghton Conquest, husbandman 0
5392996 2473067 2473067 defendant Couper John husbandman 594655 594655 Couper, John, of Houghton Conquest, husbandman 0
5406136 2476831 2476831 defendant Stanford William chaplain 594655 594655 Stanford, William, of Houghton Conquest, chaplain 1
5406140 2476833 2476833 defendant Couper John husbandman 594655 594655 Couper, John, of Houghton Conquest, husbandman 0
5407274 2477142 2477142 defendant Ruold alias Clerk John husbandman 594655 594655 Ruold alias Clerk, John, of Houghton Conquest, husbandman 0
5420515 2481058 2481058 defendant Ruold John husbandman 594655 594655 Ruold, John, of Houghton Conquest, husbandman 0
5420517 2481059 2481059 defendant Ruold John husbandman 594655 594655 Ruold, John, of Houghton Conquest, husbandman 0
5500467 2505080 2505080 defendant Nicholl John husbandman 594655 594655 Nicholl, John, of Houghton Conquest, husbandman 1
5545283 2518620 2518620 defendant Bylcok Anne widow 594655 594655 (Bylcok, Anne, of Houghton Conquest, widow 2
5545284 2518620 2518620 defendant Bylcok Richard husbandman 594655 594655 Bylcok, Richard, of Houghton Conquest, husbandman 3
5554435 2521332 2521332 defendant Slough John chaplain 594655 594655 Slough, John, of Houghton Conquest, chaplain 0
5554438 2521333 2521333 defendant Slough John chaplain 594655 594655 Slough, John, of Houghton Conquest, chaplain 0
5580311 2528925 2528925 defendant Tayllour John husbandman 594655 594655 Tayllour, John, of Houghton Conquest, husbandman 4

Next page

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