names

234 rows where place_id = 588456

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594562 1865929 1865929 plaintiff Lambe Richard   588456 588456 Lambe, Richard, of Yarmouth 0
3606618 1869742 1869742 defendant Dadon Robert butcher 588456 588456 Dadon, Robert, of Yarmouth, butcher 4
3640467 1907450 1907450 defendant Tasseborowe Robert yeoman 588456 588456 Tasseborowe, Robert, of Yarmouth, yeoman 0
3656114 1912166 1912166 plaintiff Bysshop William   588456 588456 Bysshop, William, of Yarmouth 0
3672739 1917480 1917480 plaintiff Dice John   588456 588456 Dice, John, of Yarmouth 0
3690653 1923241 1923241 defendant Nicholson Roland shoemaker 588456 588456 Nicholson, Roland, of Yarmouth, shoemaker 1
3690672 1923246 1923246 defendant Nicholas Roland shoemaker 588456 588456 Nicholas, Roland, of Yarmouth, shoemaker 2
3705004 1927858 1927858 defendant Nicholason Roland shoemaker 588456 588456 Nicholason, Roland, of Yarmouth, shoemaker 0
3716618 1931495 1931495 defendant Ylberd John, junior roper 588456 588456 Ylberd, John, junior, of Yarmouth, roper 0
3741596 1939242 1939242 defendant Cowper Robert mercer 588456 588456 Cowper, Robert, of Yarmouth, mercer 0
3753043 1942888 1942888 defendant Hytchecoke Thomas yeoman 588456 588456 Hytchecoke, Thomas, of Yarmouth, yeoman 0
3757688 1944385 1944385 plaintiff Borowe William merchant 588456 588456 Borowe, William, of Yarmouth, merchant 0
3768219 1947698 1947698 defendant Tailler Brian   588456 588456 Tailler, Brian, of Yarmouth, gent, customs collector of Great Yarmouth 0
3768237 1947705 1947705 defendant Tasborow Robert fismonger 588456 588456 Tasborow, Robert, of Yarmouth, fismonger 0
3786429 1953544 1953544 defendant Bryse Gilbert merchant 588456 588456 Bryse, Gilbert, of Yarmouth, merchant 0
3800302 1958014 1958014 defendant Grise Gilbert gent 588456 588456 Grise, Gilbert, of Yarmouth, gent 0
3802366 1958639 1958639 defendant Tayller Brian   588456 588456 Tayller, Brian, of Yarmouth, gent, customer, port of Yarmouth 0
3803048 1958855 1958855 defendant Tasburgh Robert merchant 588456 588456 Tasburgh, Robert, of Yarmouth, merchant 0
3837291 1969570 1969570 defendant Person John shoemaker 588456 588456 Person, John, of Yarmouth, shoemaker 1
3840152 1970492 1970492 defendant Barret John tailor 588456 588456 Barret, John, of Yarmouth, tailor 0
3846680 1972517 1972517 defendant Grey Thomas gent 588456 588456 Grey, Thomas, of Yarmouth, gent 1
3855542 1975376 1975376 plaintiff Watt John   588456 588456 Watt, John,of Yarmouth, worsted weaver 0
3866322 1978969 1978969 plaintiff Plattyng Richard butcher 588456 588456 Plattyng, Richard, of Yarmouth, butcher 0
3874858 1981811 1981811 plaintiff Dene Ralph merchant 588456 588456 Dene, Ralph, of Yarmouth, merchant 0
3884421 1985058 1985058 defendant Bysshop Richard, junior merchant 588456 588456 Bysshop, Richard, junior, of Yarmouth, merchant 1
3891565 1987443 1987443 defendant Shawe William merchant 588456 588456 Shawe, William, of Yarmouth, merchant 1
3922880 1997955 1997955 defendant Echard Thomas merchant 588456 588456 Echard, Thomas, of Yarmouth, merchant 0
3929915 2000347 2000347 defendant Bysshoppe William, junior merchant 588456 588456 Bysshoppe, William, junior, of Yarmouth, merchant 1
3929918 2000348 2000348 defendant Bysshoppe William, junior merchant 588456 588456 Bysshoppe, William, junior, of Yarmouth, merchant 1
3938376 2003175 2003175 defendant Markond Thomas drpaer 588456 588456 Markond, Thomas, of Yarmouth, drpaer 0
3943546 2004861 2004861 defendant Hunt or Hount Henry gent 588456 588456 Hunt or Hount, Henry, of Yarmouth, gent, son of Thomas Hount, of Yarmouth, gent 0
3943941 2004992 2004992 defendant Cowper Roger merchant 588456 588456 Cowper, Roger, of Yarmouth, merchant 1
3946690 2005908 2005908 defendant Harebrowne William merchant 588456 588456 Harebrowne, William, of Yarmouth, merchant 0
3948200 2006433 2006433 defendant Ollyott John (legal representative) 588456 588456 Ollyott, John, of Yarmouth, mariner, executor of 0
3957647 2009734 2009734 defendant Collynge William   588456 588456 Collynge, William, of Yarmouth, rope maker 0
3962915 2011625 2011625 plaintiff Wolhouse Ralph merchant 588456 588456 Wolhouse, Ralph, of Yarmouth, merchant 0
3962917 2011626 2011626 plaintiff Wolhouse Ralph merchant 588456 588456 Wolhouse, Ralph, of Yarmouth, merchant 0
3975829 2016109 2016109 plaintiff Ingram John (legal representative) 588456 588456 Ingram, John, of Yarmouth, tailor, administratrix of 0
3978182 2016950 2016950 defendant Ladde Robert yeooman 588456 588456 Ladde, Robert, of Yarmouth, yeooman 1
3979655 2017481 2017481 defendant Foster Richard   588456 588456 Foster, Richard, of Yarmouth 1
3982757 2018604 2018604 defendant Eyer Robert (legal representative) 588456 588456 Eyer, Robert, of Yarmouth, gent, executors of 0
3994181 2022671 2022671 defendant Browne John butcher 588456 588456 Browne, John, of Yarmouth, butcher 0
4011695 2028917 2028917 defendant More Thomas merchant 588456 588456 More, Thomas, of Yarmouth, merchant 0
4014999 2030072 2030072 defendant Grygson Thomas mariner 588456 588456 Grygson, Thomas, of Yarmouth, mariner 7
4015053 2030076 2030076 defendant Peresen William yeoman 588456 588456 Peresen, William, of Yarmouth, yeoman 4
4032488 2036265 2036265 plaintiff Garton Thomas merchant 588456 588456 Garton, Thomas, of Yarmouth, merchant 0
4038360 2038360 2038360 defendant Reynoldes John chapman 588456 588456 Reynoldes, John, of Yarmouth, chapman 0
4053281 2043550 2043550 defendant Garrard John miller 588456 588456 Garrard, John, of Yarmouth, miller 6
4081986 2053858 2053858 plaintiff Woodgate Richard merchant 588456 588456 Woodgate, Richard, of Yarmouth, merchant 0
4131613 2071627 2071627 defendant Bradshawe Roger merchant, administrators of 588456 588456 Bradshawe Roger, of Yarmouth, merchant, administrators of 0
4131617 2071628 2071628 defendant Bradshawe Roger   588456 588456 Bradshawe, Roger, of Yarmouth, merchant, administrators of 0
4200325 2095667 2095667 defendant Drurye Roger gent 588456 588456 Drurye, Roger, of Yarmouth, gent 2
4248266 2112410 2112410 defendant Ouldinge Richard merchant 588456 588456 Ouldinge, Richard, of Yarmouth, merchant 2
4260019 2116320 2116320 defendant Moore Simon chapman 588456 588456 Moore, Simon, of Yarmouth, chapman 1
4277108 2121926 2121926 defendant Tuttill William yeoman 588456 588456 Tuttill, William, of Yarmouth, yeoman 0
4297166 2129088 2129088 defendant Woodzen Thomas chapman 588456 588456 Woodzen, Thomas, of Yarmouth, chapman 1
4299276 2129836 2129836 defendant Percivall Christopher Englishman 588456 588456 Percivall, Christopher, of Yarmouth, merchant, or of Horne in Northalland, Englishman 2
4326859 2139331 2139331 defendant Palmer Thomas chapman 588456 588456 Palmer, Thomas, of Yarmouth, chapman 4
4336603 2142528 2142528 defendant Muskett Henry gent 588456 588456 Muskett, Henry, of Yarmouth, gent 3
4352610 2148149 2148149 defendant Cowper Edmund smith 588456 588456 Cowper, Edmund, of Yarmouth, smith 0
4354440 2148783 2148783 defendant Michelson Arthur mariner 588456 588456 Michelson, Arthur, of Yarmouth, mariner 0
4361085 2151131 2151131 defendant Elward Charles mariner 588456 588456 Elward, Charles, of Yarmouth, mariner 3
4379156 2157626 2157626 defendant Osborne James gent 588456 588456 Osborne, James, of Yarmouth, gent 6
4381334 2158437 2158437 defendant Couldam William draper 588456 588456 Couldam, William, of Yarmouth, draper 1
4382434 2158825 2158825 defendant Tolwyn Richard gent 588456 588456 Tolwyn, Richard, of Yarmouth, gent 3
4385094 2159702 2159702 defendant Muskett Henry gent 588456 588456 Muskett, Henry, of Yarmouth, gent 3
4399960 2164575 2164575 defendant Ladd John merchant 588456 588456 Ladd, John, of Yarmouth, merchant 2
4399964 2164576 2164576 defendant Creke Richard upholsterer 588456 588456 Creke, Richard, of Yarmouth, upholsterer 2
4401983 2165256 2165256 defendant Soamer John mariner 588456 588456 Soamer, John, of Yarmouth, mariner 0
4404528 2166082 2166082 defendant Taylor Edward gent 588456 588456 (Taylor, Edward, of Yarmouth, gent 1
4412944 2168922 2168922 defendant Bedeford John   588456 588456 Bedeford, John, of Yarmouth 0
4459408 2187993 2187993 defendant Skyrak Thomas   588456 588456 Skyrak, Thomas, of Yarmouth 1
4459409 2187993 2187993 defendant Patryk William   588456 588456 Patryk, William, of Yarmouth 2
4459410 2187993 2187993 defendant Crummok John   588456 588456 Crummok, John, of Yarmouth 3
4463005 2189133 2189133 plaintiff Topcroft Robert de   588456 588456 Topcroft, Robert de, of Yarmouth, burgess 0
4471051 2191603 2191603 defendant Fordele Geoffrey   588456 588456 Fordele, Geoffrey, of Yarmouth, burgess 1
4489892 2197545 2197545 defendant Kyrkeowe Thomas   588456 588456 Kyrkeowe, Thomas, of Yarmouth 0
4501937 2201206 2201206 defendant Alotes Adam   588456 588456 Alotes, Adam, of Yarmouth 0
4531967 2210264 2210264 plaintiff Plomere William   588456 588456 Plomere, William, of Yarmouth 0
4551170 2216307 2216307 defendant Melton John   588456 588456 Melton, John, of Yarmouth 2
4552065 2216598 2216598 defendant Norman Robert   588456 588456 Norman, Robert, of Yarmouth 2
4554463 2217328 2217328 defendant Colun John   588456 588456 Colun, John, of Yarmouth 0
4560069 2219096 2219096 defendant Sheperfeld John   588456 588456 Sheperfeld, John, of Yarmouth 0
4560218 2219145 2219145 defendant Parker William esq 588456 588456 Parker, William, of Yarmouth, esq 1
4564794 2220554 2220554 defendant atte Gap Alexander   588456 588456 atte Gap, Alexander, of Yarmouth 0
4564795 2220554 2220554 defendant Colkyrke William   588456 588456 Colkyrke, William, of Yarmouth 1
4568534 2221734 2221734 defendant Crigges Nicholas skinner 588456 588456 Crigges, Nicholas, of Yarmouth, skinner 0
4571453 2222655 2222655 defendant Elys Robert, sen   588456 588456 Elys, Robert, sen, of Yarmouth 1
4578137 2224664 2224664 defendant Perys Thomas   588456 588456 Perys, Thomas, of Yarmouth 1
4578977 2224907 2224907 plaintiff Colkyrke William   588456 588456 Colkyrke, William, of Yarmouth 0
4597685 2230527 2230527 defendant Beyton John de   588456 588456 Beyton, John de, of Yarmouth 0
4597692 2230528 2230528 defendant Beyton John   588456 588456 Beyton, John, of Yarmouth 0
4604767 2232658 2232658 defendant Fresyngfeld Roger   588456 588456 Fresyngfeld, Roger, of Yarmouth 0
4606433 2233124 2233124 defendant Neve Edmund   588456 588456 Neve, Edmund, of Yarmouth 0
4606434 2233124 2233124 defendant Neve Robert   588456 588456 Neve, Robert, of Yarmouth 1
4606436 2233125 2233125 defendant Neve Edmund   588456 588456 Neve, Edmund, of Yarmouth 0
4606437 2233125 2233125 defendant Neve Robert   588456 588456 Neve, Robert, of Yarmouth 1
4608753 2233843 2233843 defendant Budde Adam   588456 588456 Budde, Adam, of Yarmouth 0
4611796 2234751 2234751 plaintiff Colkirke William   588456 588456 Colkirke, William, of Yarmouth 0
4612817 2235072 2235072 defendant Spitlyng Henry   588456 588456 Spitlyng, Henry, of Yarmouth 0

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