names

125 rows where place_id = 592153

✎ 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
3606753 1869787 1869787 defendant Spenyng Henry yeoman 592153 592153 Spenyng, Henry, of Wroxham, yeoman 1
3625770 1875597 1875597 defendant Lyng William yeoman 592153 592153 Lyng, William, of Wroxham, yeoman 2
3625774 1875598 1875598 defendant Lyng William yeoman 592153 592153 Lyng, William, of Wroxham, yeoman 1
3646707 1909372 1909372 defendant Catysby George gent 592153 592153 Catysby, George, of Wroxham, gent 2
3688737 1922640 1922640 plaintiff Dey Simon   592153 592153 Dey, Simon, of Wroxham 0
3692327 1923769 1923769 defendant Barker Reginald husbandman 592153 592153 Barker, Reginald, of Wroxham, husbandman 0
3709496 1929273 1929273 defendant Pygg Andrew laborer 592153 592153 Pygg, Andrew, of Wroxham, laborer 1
3724211 1933858 1933858 defendant Cokerell Henry husbandman 592153 592153 Cokerell, Henry, of Wroxham, husbandman 1
3724216 1933859 1933859 defendant Cokerell Henry husbandman 592153 592153 Cokerell, Henry, of Wroxham, husbandman 1
3732316 1936346 1936346 defendant Barker Reginald husbandman 592153 592153 Barker, Reginald, of Wroxham, husbandman 0
3732317 1936346 1936346 defendant Smyth Nicholas husbandman 592153 592153 Smyth, Nicholas, of Wroxham, husbandman 1
3752012 1942552 1942552 defendant Roo William carpenter 592153 592153 Roo, William, of Wroxham, carpenter 0
3752016 1942552 1942552 defendant Cooke Richard husbandman 592153 592153 Cooke, Richard, of Wroxham, husbandman 4
3757166 1944223 1944223 defendant Cokerell Henry husbandman 592153 592153 Cokerell, Henry, of Wroxham, husbandman 1
3757168 1944224 1944224 defendant Dey Simon   592153 592153 Dey, Simon, of Wroxham, wool chapman 0
3759986 1945117 1945117 defendant Barker Reginald yeoman 592153 592153 Barker, Reginald, of Wroxham, yeoman 0
3759987 1945117 1945117 defendant Smyth Nicholas husbandman 592153 592153 Smyth, Nicholas, of Wroxham, husbandman 1
3778466 1950981 1950981 defendant Bukker Ralph clerk 592153 592153 Bukker, Ralph, of Wroxham, clerk 0
3778467 1950981 1950981 defendant Berre John husbandman 592153 592153 Berre, John, of Wroxham, husbandman 1
3789699 1954608 1954608 defendant Dey Simon husbandman 592153 592153 Dey, Simon, of Wroxham, husbandman 1
3826808 1966236 1966236 defendant Large Edward husbandman 592153 592153 Large, Edward, of Wroxham, husbandman 1
3826815 1966237 1966237 defendant Large Edward husbandman 592153 592153 Large, Edward, of Wroxham, husbandman 1
3846448 1972443 1972443 defendant Bekker John butcher 592153 592153 Bekker John, of Wroxham, butcher 0
3849109 1973319 1973319 defendant Kempe James husbandman 592153 592153 Kempe, James, of Wroxham, husbandman 1
3895409 1988674 1988674 defendant Dey Simon yeoman 592153 592153 Dey, Simon, of Wroxham, yeoman 4
3990004 2021178 2021178 plaintiff Becker Thomas yeoman 592153 592153 Becker, Thomas, of Wroxham, yeoman 0
3990007 2021178 2021178 defendant Guner Thomas husbandman 592153 592153 Guner, Thomas, of Wroxham, husbandman 2
4064214 2047476 2047476 plaintiff Greye Thomas gent 592153 592153 Greye, Thomas, of Wroxham, gent 0
4066820 2048434 2048434 defendant Sammon Richard butcher 592153 592153 Sammon, Richard, of Wroxham, butcher 0
4076093 2051743 2051743 defendant Norgate Richard yeoman 592153 592153 Norgate, Richard, of Wroxham, yeoman 2
4076120 2051747 2051747 defendant Saman Richard butcher 592153 592153 Saman, Richard, of Wroxham, butcher 3
4081177 2053578 2053578 defendant Knevett Edmund gent 592153 592153 Knevett, Edmund, of Wroxham, gent 0
4104546 2061907 2061907 defendant Fenne John husbandman 592153 592153 Fenne, John, of Wroxham, husbandman 1
4107580 2062996 2062996 defendant Clarke Thomas tailor 592153 592153 Clarke, Thomas, of Wroxham, tailor 0
4126437 2069740 2069740 defendant Spendlove Hugh yeoman 592153 592153 Spendlove, Hugh, of Wroxham, yeoman 0
4137993 2073950 2073950 defendant Fordlye William gent 592153 592153 Fordlye, William, of Wroxham, gent 0
4145513 2076585 2076585 defendant Browne Robert blacksmith 592153 592153 Browne, Robert, of Wroxham, blacksmith 3
4149707 2078023 2078023 defendant Spendlove Hugh yeoman 592153 592153 Spendlove, Hugh, of Wroxham, yeoman 0
4152327 2078924 2078924 defendant Anyer or Avyer Thomas blacksmith 592153 592153 Anyer or Avyer, Thomas, of Wroxham, blacksmith 1
4155168 2079900 2079900 defendant Dey Nicholas husbandman 592153 592153 Dey, Nicholas, of Wroxham, husbandman 1
4175037 2086735 2086735 defendant Clarke Thomas tailor 592153 592153 Clarke, Thomas, of Wroxham, tailor 2
4182931 2089510 2089510 defendant Clarke Thomas tailor 592153 592153 Clarke, Thomas, of Wroxham, tailor 3
4183255 2089625 2089625 defendant Dey Nicholas husbandman 592153 592153 Dey, Nicholas, of Wroxham, husbandman 1
4190274 2092102 2092102 defendant Johnson William laborer 592153 592153 Johnson, William, of Wroxham, laborer 1
4197245 2094588 2094588 defendant Barker John husbandman 592153 592153 Barker, John, of Wroxham, husbandman 2
4198390 2094984 2094984 defendant Clarke Thomas tailor 592153 592153 Clarke, Thomas, of Wroxham, tailor 2
4281830 2123550 2123550 defendant Churche Richard husbandman 592153 592153 Churche, Richard, of Wroxham, husbandman 1
4339183 2143466 2143466 defendant Puttock John husbandman 592153 592153 Puttock, John, of Wroxham, husbandman 0
4347233 2146291 2146291 defendant Gryme William   592153 592153 Gryme, William, of Wroxham 0
4386971 2160299 2160299 defendant Pratt Ralph husbandman 592153 592153 Pratt, Ralph, of Wroxham, husbandman 3
4388557 2160814 2160814 defendant Puttocke John husbandman 592153 592153 Puttocke, John, of Wroxham, husbandman 2
4391517 2161774 2161774 defendant Puttock John husbandman 592153 592153 Puttock, John, of Wroxham, husbandman 3
4420749 2171389 2171389 defendant Tovy Thomas   592153 592153 Tovy, Thomas, of Wroxham 2
4424394 2172473 2172473 plaintiff Idanye John   592153 592153 Idanye, John, of Wroxham 0
4449077 2184654 2184654 defendant Margery William   592153 592153 Margery, William, of Wroxham 2
4465951 2190013 2190013 defendant Nicol John   592153 592153 Nicol, John, of Wroxham 0
4482225 2195149 2195149 defendant Fordeleye Geoffrey   592153 592153 Fordeleye, Geoffrey, of Wroxham 3
4523750 2207756 2207756 defendant Plumpstede John   592153 592153 Plumpstede, John, of Wroxham 1
4555327 2217601 2217601 defendant Plumstede John   592153 592153 Plumstede, John, of Wroxham 2
4583318 2226203 2226203 defendant Capelond Gilbert   592153 592153 Capelond, Gilbert, of Wroxham, Dors, rector 0
4635041 2241805 2241805 defendant Tovy Hugh   592153 592153 Tovy, Hugh, of Wroxham 10
4660749 2249186 2249186 defendant Chylde John husbandman 592153 592153 Chylde, John, of Wroxham, husbandman 0
4660751 2249186 2249186 defendant Fenhous William yeoman 592153 592153 Fenhous, William, of Wroxham, yeoman 2
4669153 2256060 2256060 defendant Fordlegh Geoffrey husbandman 592153 592153 Fordlegh, Geoffrey, of Wroxham, husbandman 1
4675228 2257865 2257865 defendant Child John husbandman 592153 592153 Child, John, of Wroxham, husbandman 2
4681710 2259890 2259890 defendant Bate William woolman 592153 592153 Bate, William, of Wroxham, woolman 0
4686597 2261418 2261418 defendant Smyth Alan clerk 592153 592153 Smyth, Alan, of Wroxham, clerk 0
4699209 2265219 2265219 defendant Beteleyn Alan yeoman 592153 592153 Beteleyn, Alan, of Wroxham, yeoman 0
4707996 2267873 2267873 defendant Glovere Peter   592153 592153 Glovere, Peter, of Wroxham, shepherd 0
4738836 2277235 2277235 defendant Yonge Thomas clerk 592153 592153 Yonge, Thomas, of Wroxham, clerk 0
4766129 2285396 2285396 defendant Cook William husbandman 592153 592153 Cook, William, of Wroxham, husbandman 2
4770343 2286696 2286696 defendant (not given) Thomas vicar of Yonge 592153 592153 Yonge, Thomas, of Wroxham, vicar of the church 0
4799580 2296049 2296049 defendant atte Fenhous William husbandman 592153 592153 atte Fenhous, William, of Wroxham, husbandman 0
4819902 2302300 2302300 defendant Benslyn or Benflyn John yeoman 592153 592153 Benslyn or Benflyn, John, of Wroxham, yeoman 0
4858426 2314007 2314007 defendant Benet William husbandman 592153 592153 Benet, William, of Wroxham, husbandman 3
4865279 2316112 2316112 defendant Fordley John husbandman 592153 592153 Fordley, John, of Wroxham, husbandman 3
4872452 2318345 2318345 defendant Fenne Adam yeoman 592153 592153 Fenne, Adam, of Wroxham, yeoman 13
4885041 2322217 2322217 plaintiff Benet William   592153 592153 Benet, William, of Wroxham 0
4909947 2329636 2329636 plaintiff Benet William   592153 592153 Benet, William, of Wroxham 0
4943008 2339788 2339788 defendant Hekelyng John laborer 592153 592153 Hekelyng, John, of Wroxham, laborer 2
4945708 2340639 2340639 defendant Deye Thomas husbandman 592153 592153 Deye, Thomas, of Wroxham, husbandman 1
4950165 2342018 2342018 defendant Benet William yeoman 592153 592153 Benet, William, of Wroxham, yeoman 0
4951608 2342459 2342459 defendant Pertryk John yeoman 592153 592153 Pertryk, John, of Wroxham, yeoman 2
4951609 2342459 2342459 defendant Haddon John husbandman 592153 592153 Haddon, John, of Wroxham, husbandman 3
4960168 2345013 2345013 defendant Benet William yeoman 592153 592153 Benet, William, of Wroxham, yeoman 1
5016857 2361826 2361826 defendant Benet William yeoman 592153 592153 Benet, William, of Wroxham, yeoman 2
5023197 2363685 2363685 defendant Amrynghale John yeoman 592153 592153 Amrynghale, John, of Wroxham, yeoman 2
5026353 2364597 2364597 defendant Kyrkeman Henry fuller 592153 592153 Kyrkeman, Henry, of Wroxham, fuller 2
5042552 2369378 2369378 plaintiff Deyp Henry   592153 592153 Deyp, Henry, of Wroxham 0
5045032 2370147 2370147 defendant Amerynghale John yeoman 592153 592153 Amerynghale, John, of Wroxham, yeoman 0
5047339 2370822 2370822 defendant Amerynghale John husbandman 592153 592153 Amerynghale, John, of Wroxham, husbandman 0
5057008 2373677 2373677 defendant Shepherd Richard husbandman 592153 592153 Shepherd, Richard, of Wroxham, husbandman 0
5067559 2376793 2376793 defendant Amerynghale John husbandman 592153 592153 Amerynghale, John, of Wroxham, husbandman 0
5137060 2397354 2397354 defendant Bettys Thomas engraver 592153 592153 Bettys, Thomas, of Wroxham, engraver 2
5157661 2403370 2403370 defendant Bettys Thomas grainer 592153 592153 Bettys, Thomas, of Wroxham, grainer 2
5173493 2407949 2407949 defendant Bettes Thomas grainer 592153 592153 Bettes, Thomas, of Wroxham, grainer 2
5214258 2419902 2419902 defendant Hamond Philip husbandman 592153 592153 Hamond, Philip, of Wroxham, husbandman 4
5220860 2421793 2421793 defendant Spenyng or Spevyng Henry yeoman 592153 592153 Spenyng or Spevyng, Henry, of Wroxham, yeoman 1
5237764 2426631 2426631 defendant Hardyng William husbandman 592153 592153 Hardyng, William, of Wroxham, husbandman 0
5237765 2426631 2426631 defendant Hardyng John   592153 592153 Hardyng, John, of Wroxham, servant 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);