names

99 rows where place_id = 600510

✎ 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
3641289 1907727 1907727 defendant Creme John husbandman 600510 600510 Creme, John, of Thurston, husbandman 2
3644233 1908627 1908627 defendant Clerk Thomas husbandman 600510 600510 Clerk, Thomas, of Thurston, husbandman 3
3645375 1908962 1908962 defendant Clerke Thomas husbandman 600510 600510 Clerke, Thomas, of Thurston, husbandman 3
3648517 1909934 1909934 defendant Lynge John husbandman 600510 600510 Lynge, John, of Thurston, husbandman 8
3648948 1910059 1910059 defendant Creme John husbandman 600510 600510 Creme, John, of Thurston, husbandman 3
3649921 1910340 1910340 defendant Noot John husbandman 600510 600510 Noot, John, of Thurston, husbandman 0
3659210 1913136 1913136 defendant Verby William husbandman 600510 600510 Verby, William, of Thurston, husbandman 0
3734757 1937117 1937117 defendant Sterne William carpenter 600510 600510 Sterne, William, of Thurston, carpenter 0
3734758 1937117 1937117 defendant Bettys John laborer 600510 600510 Bettys, John, of Thurston, laborer 1
3738178 1938155 1938155 defendant Wulff Ralph yeoman 600510 600510 Wulff, Ralph, of Thurston, yeoman 0
3765966 1947025 1947025 defendant Page William husbandman 600510 600510 Page, William, of Thurston, husbandman 0
3798259 1957352 1957352 defendant Nott William husbandman 600510 600510 Nott, William, of Thurston, husbandman 1
3799833 1957866 1957866 defendant Sygo John pardoner 600510 600510 Sygo, John, of Thurston, pardoner 2
3808278 1960463 1960463 defendant Sygo John brickmaker 600510 600510 Sygo, John, of Thurston, brickmaker 0
3840505 1970590 1970590 defendant Skynner William husbandman 600510 600510 Skynner, William, of Thurston, husbandman 0
3842998 1971341 1971341 defendant Bokyll John butcher 600510 600510 Bokyll, John, of Thurston, butcher 0
3857204 1975886 1975886 defendant Skynner William husbandman 600510 600510 Skynner, William, of Thurston, husbandman 2
3863589 1978013 1978013 defendant Forde John   600510 600510 Forde, John, of Thurston, groom 0
3895473 1988695 1988695 defendant Skynner William husbandman 600510 600510 Skynner, William, of Thurston, husbandman 3
3897426 1989352 1989352 defendant Gavell Alice widow 600510 600510 Gavell, Alice, of Thurston, widow 1
3907339 1992743 1992743 defendant Howe Walter husbandman 600510 600510 Howe, Walter, of Thurston, husbandman 0
3944053 2005030 2005030 defendant Spenser Thomas husbandman 600510 600510 Spenser, Thomas, of Thurston, husbandman 2
3975763 2016084 2016084 defendant Herd John smith 600510 600510 Herd, John, of Thurston, smith 0
3977492 2016698 2016698 defendant Dyckeman William sherman 600510 600510 Dyckeman, William, of Thurston, sherman 3
3977812 2016811 2016811 defendant Page John yeoman 600510 600510 Page, John, of Thurston, yeoman 0
3979887 2017564 2017564 defendant Spencer Thomas husbandman 600510 600510 Spencer, Thomas, of Thurston, husbandman 0
4010197 2028413 2028413 defendant Herde George smith 600510 600510 Herde, George, of Thurston, yeoman, son of John Herde, of Thurston, smith 0
4010316 2028455 2028455 plaintiff Page William yeoman 600510 600510 Page, William, of Thurston, yeoman 0
4171769 2085585 2085585 defendant Herde George husbandman 600510 600510 Herde, George, of Thurston, husbandman 0
4194871 2093769 2093769 defendant Herde George husbandman 600510 600510 Herde, George, of Thurston, husbandman 0
4203661 2096838 2096838 defendant Page Thomas yeoman 600510 600510 Page, Thomas, of Thurston, yeoman 1
4203662 2096838 2096838 defendant Colbold or Cobbold Robert yeoman 600510 600510 Colbold or Cobbold, Robert, of Thurston, yeoman 2
4203663 2096838 2096838 defendant Chenery or Chevery George   600510 600510 Chenery or Chevery, George, of Thurston, shepherd 3
4278799 2122523 2122523 defendant Chevery John maltster 600510 600510 Chevery, John, of Thurston, maltster 0
4282723 2123861 2123861 defendant Marshall Felix yeoman 600510 600510 Marshall, Felix, of Thurston, clothier, yeoman 0
4389620 2161158 2161158 defendant Yarmer Isaiah clerk 600510 600510 Yarmer, Isaiah, of Thurston, or of Withersfield, Suff, clerk 0
4412667 2168826 2168826 defendant Chenerye or Cheverye Robert yeoman 600510 600510 Chenerye or Cheverye, Robert, of Thurston, yeoman 0
4415781 2169824 2169824 defendant del Wode Nicholas   600510 600510 del Wode, Nicholas, of Thurston, son of Adam 1
4419280 2170910 2170910 defendant atte Wode Nicholas   600510 600510 atte Wode, Nicholas, of Thurston, son of Adam 0
4419282 2170911 2170911 defendant del Wode Nicholas   600510 600510 del Wode, Nicholas, of Thurston, son of Adam 0
4419493 2170984 2170984 plaintiff Becles Roger de (legal representative) 600510 600510 Becles, Roger de, of Thurston, formerly parson, executors of 0
4421324 2171570 2171570 defendant atte Wode Adam   600510 600510 atte Wode, Adam, of Thurston, son of Randolf 0
4424486 2172497 2172497 defendant del Wode Nicholas   600510 600510 del Wode, Nicholas, of Thurston, son of Adam 1
4431014 2174456 2174456 defendant atte Wode Adam   600510 600510 atte Wode, Adam, of Thurston 0
4434257 2175473 2175473 defendant del Wode Nicholas   600510 600510 del Wode, Nicholas, of Thurston, son of Adam 1
4449046 2184646 2184646 defendant Coupere Walter   600510 600510 Coupere, Walter, of Thurston 0
4449047 2184646 2184646 defendant Kent John   600510 600510 Kent, John, of Thurston 1
4475012 2192855 2192855 defendant Bate Adam   600510 600510 Bate, Adam, of Thurston, mason 1
4631055 2240606 2240606 defendant Helyer John   600510 600510 Helyer, John, of Thurston 5
4640657 2243375 2243375 defendant Clare Thomas   600510 600510 Clare, Thomas, of Thurston 4
4640664 2243376 2243376 defendant Clare Thomas   600510 600510 Clare, Thomas, of Thurston 4
4699348 2265260 2265260 defendant Howeton John husbandman 600510 600510 Howeton, John, of Thurston, husbandman 0
4768643 2286172 2286172 defendant Bernvyll Robert yeoman 600510 600510 Bernvyll, Robert, of Thurston, yeoman 1
4811379 2299668 2299668 defendant Halle John yeoman 600510 600510 Halle, John, of Thurston, yeoman 2
4849567 2311340 2311340 defendant Wechy William husbandman 600510 600510 Wechy, William, of Thurston, husbandman 1
4868483 2317114 2317114 defendant Cowpere John husbandman 600510 600510 Cowpere, John, of Thurston, husbandman 0
4886651 2322689 2322689 defendant Rose John, junior husbandman 600510 600510 Rose, John, junior, of Thurston, husbandman 3
4886652 2322689 2322689 defendant Lyng John husbandman 600510 600510 Lyng, John, of Thurston, husbandman 4
4893668 2324714 2324714 defendant Taillour John laborer 600510 600510 Taillour, John, of Thurston, laborer 9
4904665 2328067 2328067 defendant Grene henry husbandman 600510 600510 Grene, henry, of Thurston, husbandman 0
4917514 2331992 2331992 defendant Sethy William laborer 600510 600510 Sethy, William, of Thurston, laborer 1
5013550 2360804 2360804 defendant Wytton Thomas yeoman 600510 600510 Wytton, Thomas, of Thurston, yeoman 1
5022365 2363436 2363436 defendant Smyth John   600510 600510 Smyth, John, of Thurston, smith, bailiff of Ixworth Priory 3
5033442 2366662 2366662 defendant Cole John laborer 600510 600510 Cole, John, of Thurston, laborer 3
5038293 2368094 2368094 defendant Greme Nicholas   600510 600510 Greme, Nicholas, of Thurston 1
5057382 2373776 2373776 defendant Saykyn William husbandman 600510 600510 Saykyn, William, of Thurston, husbandman 3
5079056 2380223 2380223 defendant Martyn William summoner 600510 600510 Martyn, William, of Thurston, or of Melford, summoner 0
5168420 2406479 2406479 defendant Mannale Nicholas husbandman 600510 600510 Mannale, Nicholas, of Thurston, husbandman 0
5210583 2418831 2418831 defendant Agas John tailor 600510 600510 Agas, John, of Thurston, tailor 0
5252342 2430843 2430843 defendant Bright John husbandman 600510 600510 Bright, John, of Thurston, husbandman 0
5259719 2433165 2433165 defendant Lynde William laborer 600510 600510 Lynde, William, of Thurston, laborer 0
5281173 2439568 2439568 defendant Beusheffe Thomas husbandman 600510 600510 Beusheffe, Thomas, of Thurston, husbandman 3
5285097 2440667 2440667 defendant Rychemond William yeoman 600510 600510 Rychemond, William, of Thurston, yeoman 1
5301428 2445379 2445379 defendant Lanys William husbandman 600510 600510 Lanys, William, of Thurston, husbandman 1
5308751 2447656 2447656 defendant Bryght John laborer 600510 600510 Bryght, John, of Thurston, laborer 0
5308752 2447656 2447656 defendant _as Adam carpenter 600510 600510 _as, Adam, of Thurston, carpenter 1
5364619 2464594 2464594 defendant Pekerell Thomas   600510 600510 Pekerell, Thomas, of Thurston, sow gelder 0
5382786 2470141 2470141 defendant Crosse John husbandman 600510 600510 Crosse, John, of Thurston, husbandman 4
5393351 2473155 2473155 defendant Cresse John husbandman 600510 600510 Cresse, John, of Thurston, husbandman 1
5402570 2475807 2475807 defendant Taillour Stephen thatcher 600510 600510 Taillour, Stephen, of Thurston, thatcher 0
5406539 2476940 2476940 defendant Crosse John husbandman 600510 600510 Crosse, John, of Thurston, husbandman 1
5419650 2480795 2480795 defendant Crosse John husbandman 600510 600510 Crosse, John, of Thurston, husbandman 1
5422900 2481805 2481805 defendant Taillour Stephen thatcher 600510 600510 Taillour, Stephen, of Thurston, thatcher 0
5455121 2491453 2491453 defendant Taillour Stephen thatcher 600510 600510 Taillour, Stephen, of Thurston, thatcher 0
5537365 2516179 2516179 defendant Lyng John husbandman 600510 600510 Lyng, John, of Thurston, husbandman 0
5553669 2521110 2521110 defendant Turnour Richard laborer 600510 600510 Turnour, Richard, of Thurston, laborer 0
5561211 2523258 2523258 defendant Bullok William husbandman 600510 600510 Bullok, William, of Thurston, husbandman 1
5577947 2528175 2528175 defendant Lyng John husbandman 600510 600510 Lyng, John, of Thurston, husbandman 4
5579743 2528743 2528743 defendant Austyn Walter husbandman 600510 600510 Austyn, Walter, of Thurston, husbandman 1
5579744 2528743 2528743 defendant Newman Henry husbandman 600510 600510 Newman, Henry, of Thurston, husbandman 2
5579747 2528744 2528744 defendant Austyn Walter husbandman 600510 600510 Austyn, Walter, of Thurston, husbandman 1
5579748 2528744 2528744 defendant Newman Henry husbandman 600510 600510 Newman, Henry, of Thurston, husbandman 2
5581769 2529379 2529379 plaintiff Creme John (legal representative) 600510 600510 Creme, John, of Thurston, executor of 0
5581781 2529380 2529380 plaintiff Creme John (legal representative) 600510 600510 Creme, John, of Thurston, yeoman, executor of 0
5596574 2533846 2533846 defendant Manale Thomas carpenter 600510 600510 Manale, Thomas, of Thurston, carpenter 0
5601364 2535319 2535319 defendant Noote William husbandman 600510 600510 Noote, William, of Thurston, husbandman 1
5605187 2536497 2536497 defendant Creme John husbandman 600510 600510 Creme, John, of Thurston, husbandman 0
5633107 2554359 2554359 defendant Helyer John roofer 600510 600510 Helyer, John, of Thurston, roofer 1
5633108 2554359 2554359 defendant Selkyn Richard tailor 600510 600510 Selkyn, Richard, of Thurston, tailor 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);