names

164 rows where place_id = 590846

✎ 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
3588044 1863913 1863913 defendant Frende Thomas   590846 590846 Frende, Thomas, of Shipdam, carpenter, administrators of 0
3602489 1868439 1868439 defendant Colynys Thomas clerk 590846 590846 Colynys, Thomas, of Shipdam, clerk 3
3606231 1869616 1869616 defendant Symond John husbandman 590846 590846 Symond, John, of Shipdam, husbandman 0
3607059 1869873 1869873 defendant Platfote John husbandman 590846 590846 Platfote, John, of Shipdam, husbandman 1
3608440 1870300 1870300 plaintiff Tenaunt John   590846 590846 Tenaunt, John, of Shipdam 0
3620657 1874040 1874040 defendant Vyncent William husbandman 590846 590846 Vyncent, William, of Shipdam, husbandman 1
3622986 1874716 1874716 defendant Platfot Ralph yeoman 590846 590846 Platfot, Ralph, of Shipdam, yeoman 0
3634058 1905450 1905450 defendant Wenne Thomas, junior carpenter 590846 590846 Wenne, Thomas, junior, of Shipdam, carpenter 0
3636332 1906155 1906155 defendant Tuddenham John butcher 590846 590846 Tuddenham, John, of Shipdam, butcher 0
3660277 1913475 1913475 defendant Pye William glover 590846 590846 Pye, William, of Shipdam, glover 0
3732967 1936533 1936533 defendant Harward Thomas husbandman 590846 590846 Harward, Thomas, of Shipdam, husbandman 1
3735910 1937471 1937471 defendant Jen or Gen Joan husbandman 590846 590846 Jen or Gen, Joan, of Shipdam, husbandman 2
3738884 1938366 1938366 defendant Bayly Thomas weaver 590846 590846 Bayly, Thomas, of Shipdam, weaver 0
3741269 1939129 1939129 defendant Gynne John butcher 590846 590846 Gynne, John, of Shipdam, butcher 0
3741270 1939129 1939129 defendant Goldburgh Thomas butcher 590846 590846 Goldburgh, Thomas, of Shipdam, butcher 1
3741271 1939129 1939129 defendant Harleston Thomas husbandman 590846 590846 Harleston, Thomas, of Shipdam, husbandman 2
3750490 1942066 1942066 defendant Johnson Thomas tanner 590846 590846 Johnson, Thomas, of Shipdam, tanner 3
3755464 1943661 1943661 defendant Gyrlyng Robert   590846 590846 Gyrlyng, Robert, of Shipdam, "heyerwever" 2
3783292 1952526 1952526 defendant Grynne John husbandman 590846 590846 Grynne, John, of Shipdam, husbandman 2
3786487 1953565 1953565 defendant Bogge Stephen   590846 590846 Bogge, Stephen, of Shipdam, rake maker 0
3786488 1953565 1953565 defendant Platfote Ralph husbandman 590846 590846 Platfote, Ralph, of Shipdam, husbandman 1
3802704 1958741 1958741 defendant Russelyn John husbandman 590846 590846 Russelyn, John, of Shipdam, husbandman 1
3802783 1958766 1958766 defendant Platfote Ralph laborer 590846 590846 Platfote, Ralph, of Shipdam, laborer 1
3804898 1959475 1959475 defendant Elyngham Edmund husbandman 590846 590846 Elyngham, Edmund, of Shipdam, husbandman 3
3814984 1962607 1962607 defendant Borowe Thomas   590846 590846 Borowe, Thomas, of Shipdam, wax chandler 3
3816512 1963069 1963069 plaintiff Howlyng Thomas   590846 590846 Howlyng, Thomas, of Shipdam 0
3817231 1963304 1963304 defendant Gyn John husbandman 590846 590846 Gyn, John, of Shipdam, husbandman 5
3825797 1965915 1965915 defendant Herward Thomas husbandman 590846 590846 Herward, Thomas, of Shipdam, husbandman 0
3924553 1998527 1998527 defendant Downyng William carpenter 590846 590846 Downyng, William, of Shipdam, carpenter 1
3966571 2012942 2012942 defendant Tuddenham John butcher 590846 590846 Tuddenham, John, of Shipdam, butcher 0
3966573 2012943 2012943 defendant Bushate or Busgate Thomas tanner 590846 590846 Bushate or Busgate, Thomas, of Shipdam, tanner 0
3967290 2013192 2013192 plaintiff Bullocke Robert husbandman 590846 590846 Bullocke, Robert, of Shipdam, husbandman 0
3975851 2016116 2016116 defendant Jones Peter husbandman 590846 590846 Jones, Peter, of Shipdam, husbandman 3
3984247 2019132 2019132 defendant Leverton William husbandman 590846 590846 Leverton, William, of Shipdam, husbandman 3
4015063 2030076 2030076 defendant Tuddenham John husbandman 590846 590846 Tuddenham, John, of Shipdam, husbandman 14
4015206 2030130 2030130 defendant Foker John miller 590846 590846 Foker, John, of Shipdam, or of Swaffham Market, miller 0
4018061 2031178 2031178 defendant Garden John rurner 590846 590846 Garden, John, of Shipdam, rurner 1
4023069 2032967 2032967 defendant Mordewe John cooper 590846 590846 Mordewe, John, of Shipdam, cooper 3
4049428 2042241 2042241 defendant Tudnam Thomas butcher 590846 590846 Tudnam, Thomas, of Shipdam, butcher 0
4088783 2056289 2056289 defendant Thompson Simon miller 590846 590846 Thompson, Simon, of Shipdam, miller 1
4091047 2057087 2057087 defendant Busshoppe John cooper 590846 590846 Busshoppe, John, of Shipdam, or of Wentlyng, late of Leystoft, cooper 0
4092099 2057469 2057469 defendant Sparke John   590846 590846 Sparke, John, of Shipdam, ploughwright 3
4099696 2060218 2060218 defendant Legate John gent 590846 590846 Legate, John, of Shipdam, gent 0
4154661 2079724 2079724 defendant Duning alias Buckenham Richard yeoman 590846 590846 Duning alias Buckenham, Richard, of Shipdam, yeoman 1
4167359 2084084 2084084 defendant Barlowe Henry gent 590846 590846 Barlowe, Henry, of Shipdam, gent 0
4213647 2100294 2100294 defendant Mutton Alan   590846 590846 Mutton, Alan, of Shipdam, ploughwright 2
4241137 2110023 2110023 defendant Bushe Richard husbandman 590846 590846 Bushe, Richard, of Shipdam, husbandman 1
4241141 2110024 2110024 defendant Bushe Richard husbandman 590846 590846 Bushe, Richard, of Shipdam, husbandman 2
4257937 2115626 2115626 defendant Walsingham Thomas yeoman 590846 590846 Walsingham, Thomas, of Shipdam, yeoman 2
4330076 2140358 2140358 defendant Harryson John comber 590846 590846 Harryson, John, of Shipdam, comber 3
4337043 2142678 2142678 defendant Brackett Henry husbandman 590846 590846 Brackett, Henry, of Shipdam, husbandman 0
4388692 2160852 2160852 defendant Muryell Stephen gent 590846 590846 Muryell, Stephen, of Shipdam, gent 0
4566401 2221061 2221061 defendant Palmer John shoemaker 590846 590846 Palmer, John, of Shipdam, shoemaker 0
4598058 2230644 2230644 defendant Houlyn Walter   590846 590846 Houlyn, Walter, of Shipdam 0
4633891 2241449 2241449 defendant Lacy John   590846 590846 Lacy, John, of Shipdam 0
4667493 2255555 2255555 plaintiff atte Ker William   590846 590846 atte Ker, William, of Shipdam 0
4667494 2255555 2255555 defendant Norman Richard yeoman 590846 590846 Norman, Richard, of Shipdam, yeoman 0
4667496 2255555 2255555 defendant Somerlot William yeoman 590846 590846 Somerlot, William, of Shipdam, yeoman 2
4667499 2255555 2255555 defendant Parker William parker 590846 590846 Parker, William, of Shipdam, parker 5
4691888 2262997 2262997 defendant Collesson John   590846 590846 Collesson, John, of Shipdam 2
4693234 2263384 2263384 defendant Hawys John laborer 590846 590846 Hawys, John, of Shipdam, laborer 0
4708420 2267999 2267999 defendant Turnour John husbandman 590846 590846 Turnour, John, of Shipdam, husbandman 0
4708421 2267999 2267999 defendant Williamesson John husbandman 590846 590846 Williamesson, John, of Shipdam, husbandman 1
4708422 2267999 2267999 defendant Pope William barber 590846 590846 Pope, William, of Shipdam, barber 2
4708423 2267999 2267999 defendant atte Ker Robert yeoman 590846 590846 atte Ker, Robert, of Shipdam, yeoman 3
4708424 2267999 2267999 defendant Stubbard Ellen widow 590846 590846 Stubbard, Ellen, of Shipdam, widow 4
4718878 2271246 2271246 defendant Smyth Walter smith 590846 590846 Smyth, Walter, of Shipdam, smith 3
4726765 2273641 2273641 defendant Houlyn Walter yeoman 590846 590846 Houlyn, Walter, of Shipdam, yeoman 0
4735937 2276390 2276390 defendant Collesson John yeoman 590846 590846 Collesson, John, of Shipdam, yeoman 0
4736012 2276404 2276404 defendant Hegge James husbandman 590846 590846 Hegge, James, of Shipdam, husbandman 1
4738118 2277023 2277023 defendant atte Kerre William husbandman 590846 590846 atte Kerre, William, of Shipdam, husbandman 0
4738119 2277023 2277023 defendant atte Kerre Edmund laborer 590846 590846 atte Kerre, Edmund, of Shipdam, laborer 1
4738121 2277023 2277023 defendant Westhawe John   590846 590846 Westhawe, John, of Shipdam, holy water clerk 3
4746128 2279362 2279362 defendant Oldecorne William yeoman 590846 590846 Oldecorne, William, of Shipdam, yeoman 7
4746129 2279362 2279362 defendant Houlyn Walter husbandman 590846 590846 Houlyn, Walter, of Shipdam, husbandman 8
4749582 2280362 2280362 defendant Smyth Richard smith 590846 590846 Smyth, Richard, of Shipdam, smith 0
4749583 2280362 2280362 defendant Godreve Adam yeoman 590846 590846 Godreve, Adam, of Shipdam, yeoman 1
4752062 2281089 2281089 defendant Howesson John yeoman 590846 590846 Howesson, John, of Shipdam, yeoman 5
4755135 2281993 2281993 defendant Oldeo_n William husbandman 590846 590846 Oldeo_n, William, of Shipdam, husbandman 0
4828621 2304991 2304991 defendant Oldcorne William husbandman 590846 590846 Oldcorne, William, of Shipdam, husbandman 0
4839306 2308219 2308219 defendant Collesson John shragger or trimmer or pruner of trees 590846 590846 Collesson, John, of Shipdam, shragger or trimmer or pruner of trees 4
4882581 2321460 2321460 plaintiff Gardiner Edmund   590846 590846 Gardiner, Edmund, of Shipdam 0
4888398 2323170 2323170 defendant Walpoll John clerk 590846 590846 Walpoll, John, of Shipdam, clerk 5
4916126 2331544 2331544 defendant Turnour Thomas husbandman 590846 590846 Turnour, Thomas, of Shipdam, husbandman 0
4916128 2331544 2331544 defendant Pyke Robert husbandman 590846 590846 Pyke, Robert, of Shipdam, husbandman 2
4916129 2331544 2331544 defendant Platfote Thomas husbandman 590846 590846 Platfote, Thomas, of Shipdam, husbandman 3
4925626 2334448 2334448 defendant Colson John husbandman 590846 590846 Colson, John, of Shipdam, husbandman 0
4930109 2335825 2335825 defendant Colson John   590846 590846 Colson, John, of Shipdam, "shregger" 0
4942807 2339721 2339721 plaintiff Roche Thomas   590846 590846 Roche, Thomas, of Shipdam 3
4949859 2341940 2341940 defendant Turnour Roger husbandman 590846 590846 Turnour, Roger, of Shipdam, husbandman 11
4955084 2343473 2343473 defendant Wyndham Katherine widow 590846 590846 Wyndham, Katherine, of Shipdam, widow 0
4961876 2345504 2345504 defendant Marwe or Marowe John yeoman 590846 590846 Marwe or Marowe, John, of Shipdam, yeoman 0
4973995 2349184 2349184 defendant Godyeve Adam husbandman 590846 590846 Godyeve, Adam, of Shipdam, husbandman 0
4979446 2350808 2350808 defendant atte Ker John husbandman 590846 590846 atte Ker, John, of Shipdam, husbandman 2
4982713 2351742 2351742 defendant Mawedby Henry husbandman 590846 590846 Mawedby, Henry, of Shipdam, husbandman 0
4987313 2353154 2353154 defendant Coo Richard, sen   590846 590846 Coo, Richard, sen, of Shipdam, wright 0
5007424 2359064 2359064 defendant Marwe John husbandman 590846 590846 Marwe, John, of Shipdam, husbandman 6
5009605 2359688 2359688 defendant Maltby Henry husbandman 590846 590846 Maltby, Henry, of Shipdam, husbandman 0
5091091 2383790 2383790 defendant Burgh Robert husbandman 590846 590846 Burgh, Robert, of Shipdam, husbandman 2
5104046 2387607 2387607 defendant Webster Alice widow 590846 590846 Webster, Alice, of Shipdam, widow 1

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