names

138 rows where place_id = 596172

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623480 1874877 1874877 defendant Warde Richard laborer 596172 596172 Warde, Richard, of Wareham, laborer 1
3623481 1874877 1874877 defendant Wyllyamson Nicholas mercer 596172 596172 Wyllyamson, Nicholas, of Wareham, mercer 2
3623483 1874877 1874877 defendant Gylot John husbandman 596172 596172 Gylot, John, of Wareham, husbandman 4
3623484 1874877 1874877 defendant Gerard John, junior gent 596172 596172 Gerard, John, junior, of Wareham, gent 5
3623491 1874879 1874879 defendant Squyer John laborer 596172 596172 Squyer, John, of Wareham, laborer 2
3623492 1874879 1874879 defendant Hyncheston John husbandman 596172 596172 Hyncheston, John, of Wareham, husbandman 3
3623493 1874879 1874879 defendant Groce Thomas husbandman 596172 596172 Groce, Thomas, of Wareham, husbandman 4
3623494 1874879 1874879 defendant Pondre or Poudre Joan laborer 596172 596172 Pondre or Poudre, Joan, of Wareham, widow of Pondre or Poudre, John, of Wareham, laborer 5
3625797 1875606 1875606 defendant Stede John gent 596172 596172 Stede, John, of Wareham, gent 1
3636223 1906120 1906120 defendant Trym Henry mercer 596172 596172 Trym, Henry, of Wareham, mercer 1
3638839 1906970 1906970 defendant Desperkes Stephen clerk 596172 596172 Desperkes, Stephen, of Wareham, clerk 0
3718767 1932148 1932148 plaintiff Gerard John gent 596172 596172 Gerard, John, of Wareham, gent 0
3718768 1932148 1932148 defendant Arnaye John yeoman 596172 596172 Arnaye, John, of Wareham, yeoman 0
3764396 1946526 1946526 defendant Gay John mercer 596172 596172 Gay, John, of Wareham, mercer 0
3838558 1969985 1969985 defendant Gerard George gent 596172 596172 Gerard, George, of Wareham, gent 0
3858138 1976201 1976201 defendant Baker alias Glover Thomas tanner 596172 596172 Baker alias Glover, Thomas, of Wareham, tanner 0
3858139 1976201 1976201 defendant Purse Thomas mercer 596172 596172 Purse, Thomas, of Wareham, mercer 1
3858317 1976261 1976261 defendant Mogge Robert butcher 596172 596172 Mogge, Robert, of Wareham, butcher 0
3858318 1976261 1976261 defendant Mogge Walter butcher 596172 596172 Mogge, Walter, of Wareham, butcher 1
3866295 1978959 1978959 defendant Jerrerd George gent 596172 596172 Jerrerd, George, of Wareham, gent 0
3927065 1999391 1999391 defendant Rounde Richard baker 596172 596172 Rounde, Richard, of Wareham, baker 0
4041030 2039283 2039283 defendant Croke William merchant 596172 596172 Croke, William, of Wareham, merchant 0
4046986 2041372 2041372 defendant Dernelove John clerk 596172 596172 Dernelove, John, of Wareham, clerk 0
4046987 2041372 2041372 defendant Roune Richard baker 596172 596172 Roune, Richard, of Wareham, baker 1
4054211 2043891 2043891 defendant Toppe William tailor 596172 596172 Toppe, William, of Wareham St Peter, tailor 0
4060706 2046233 2046233 defendant Jerard John gent 596172 596172 Jerard, John, of Wareham, gent, son of Thomas Jerard, of Warham, gent 0
4063225 2047140 2047140 defendant Coleman Nicholas beer brewer 596172 596172 Coleman, Nicholas, of Wareham, beer brewer 0
4067380 2048638 2048638 defendant Dorsett George merchant 596172 596172 Dorsett, George, of Wareham, merchant 0
4071161 2049991 2049991 defendant Gold Robert yeoman 596172 596172 Gold, Robert, of Wareham, yeoman 0
4071163 2049991 2049991 defendant Asheborn John gent 596172 596172 Asheborn, John, of Wareham, gent 2
4071170 2049993 2049993 defendant Longe Richard barber 596172 596172 Longe, Richard, of Wareham, barber 1
4073603 2050849 2050849 defendant Assheborne John gent 596172 596172 Assheborne, John, of Wareham, gent 0
4083362 2054333 2054333 defendant Gold Robert yeoman 596172 596172 Gold, Robert, of Wareham, yeoman 0
4086621 2055502 2055502 defendant Barker Robert brewer 596172 596172 Barker, Robert, of Wareham, brewer 2
4089740 2056627 2056627 defendant Jerrard Christopher gent 596172 596172 Jerrard, Christopher, of Wareham, gent 0
4096824 2059196 2059196 defendant Golde Robert yeoman 596172 596172 Golde, Robert, of Wareham, yeoman 0
4096833 2059200 2059200 defendant Keyle Robert gent 596172 596172 Keyle, Robert, of Wareham, gent 0
4109307 2063589 2063589 defendant Popinjaye Maud widow 596172 596172 Popinjaye, Maud, of Wareham, widow 1
4121682 2068052 2068052 defendant Asheborne John yeoman 596172 596172 Asheborne, John, of Wareham, yeoman 0
4121684 2068052 2068052 defendant Ryce Sybil widow 596172 596172 Ryce, Sybil, of Wareham, widow 2
4122478 2068349 2068349 defendant Arney or Arvey John husbandman 596172 596172 Arney or Arvey, John, of Wareham, husbandman 0
4122707 2068415 2068415 defendant Tappe or Toppe William yeoman 596172 596172 Tappe or Toppe, William, of Wareham, yeoman 2
4127494 2070128 2070128 defendant Sarrett Richard tanner 596172 596172 Sarrett, Richard, of Wareham, tanner 0
4128095 2070339 2070339 defendant Golde Roger yeoman 596172 596172 Golde, Roger, of Wareham, yeoman 0
4143961 2076050 2076050 defendant Parkyns Thomas gent 596172 596172 Parkyns, Thomas, of Wareham, gent 0
4144680 2076299 2076299 defendant Hardinge Lawrence chandler 596172 596172 Hardinge, Lawrence, of Wareham, chandler 0
4144774 2076336 2076336 defendant Rowne John baker 596172 596172 Rowne, John, of Wareham, baker 0
4144775 2076336 2076336 defendant Rowne Richard yeoman 596172 596172 Rowne, Richard, of Wareham, yeoman 1
4144776 2076336 2076336 defendant Covent John yeoman 596172 596172 Covent, John, of Wareham, yeoman 2
4149889 2078091 2078091 defendant Edwardes Richard   596172 596172 Edwardes, Richard, of Wareham, woollen draper 0
4159865 2081517 2081517 defendant Bysshopp Humphrey chapman 596172 596172 Bysshopp, Humphrey, of Wareham, chapman 0
4163820 2082871 2082871 defendant Gerarde Thomas   596172 596172 Gerarde, Thomas, of Wareham, linen draper 0
4169731 2084902 2084902 defendant Rice Sybil widow 596172 596172 Rice, Sybil, of Wareham, widow 0
4173902 2086328 2086328 defendant Bearde Richard yeoman 596172 596172 Bearde, Richard, of Wareham, yeoman 0
4181278 2088932 2088932 defendant Edwardes John tailor 596172 596172 Edwardes, John, of Wareham, tailor 2
4189819 2091934 2091934 defendant Levett Gilbert butcher 596172 596172 Levett, Gilbert, of Wareham, butcher 1
4192412 2092900 2092900 defendant Sarrett Richard tanner 596172 596172 Sarrett, Richard, of Wareham, tanner 1
4197217 2094577 2094577 defendant Bearde Richard yeoman 596172 596172 Bearde, Richard, of Wareham, yeoman 0
4200931 2095882 2095882 defendant Edwardes Richard   596172 596172 Edwardes, Richard, of Wareham, woollen draper 0
4200933 2095883 2095883 defendant Edwardes Richard   596172 596172 Edwardes, Richard, of Wareham, woollen draper 0
4201743 2096156 2096156 defendant Sarrett Richard tanner 596172 596172 Sarrett, Richard, of Wareham, tanner 0
4204714 2097195 2097195 defendant Cadburye Thomas vintner 596172 596172 Cadburye, Thomas, of Wareham, vintner 2
4212500 2099918 2099918 defendant Perkyns Thomas yeoman 596172 596172 Perkyns, Thomas, of Wareham, yeoman 1
4212511 2099920 2099920 defendant Sarrett Richard yeoman 596172 596172 Sarrett, Richard, of Wareham, yeoman 2
4217908 2101753 2101753 defendant Wyldey John weaver 596172 596172 Wyldey, John, of Wareham, weaver 0
4220328 2102616 2102616 defendant Cleves Augustine chapman 596172 596172 Cleves, Augustine, of Wareham, chapman 0
4234903 2107760 2107760 defendant Sewarde John miller 596172 596172 Sewarde, John, of Wareham, miller 1
4238370 2109033 2109033 defendant Moulam William haberdasher 596172 596172 Moulam, William, of Wareham, haberdasher 0
4243521 2110823 2110823 defendant Sewarde John miller 596172 596172 Sewarde, John, of Wareham, miller 1
4254506 2114496 2114496 defendant Yaxley Luke blacksmith 596172 596172 Yaxley, Luke, of Wareham, blacksmith 0
4271461 2120033 2120033 defendant Mowlam William haberdasher 596172 596172 Mowlam, William, of Wareham, haberdasher 0
4290620 2126702 2126702 defendant Cole George yeoman 596172 596172 Cole, George, of Wareham, yeoman 3
4291864 2127165 2127165 defendant Parkyns John tanner 596172 596172 Parkyns, John, of Wareham, tanner 2
4302063 2130842 2130842 defendant Rowne Edward baker 596172 596172 Rowne, Edward, of Wareham, baker 3
4302347 2130940 2130940 defendant Shepster John innholder 596172 596172 Shepster, John, of Wareham, innholder 0
4306534 2132424 2132424 defendant Hurst Anne widow 596172 596172 Hurst, Anne, of Wareham, or of Est Martyn, Wilts, widow 0
4306535 2132424 2132424 defendant Clarke John yeoman 596172 596172 Clarke, John, of Wareham, yeoman 1
4306536 2132424 2132424 defendant Bylles Roger yeoman 596172 596172 Bylles, Roger, of Wareham, yeoman 2
4309648 2133533 2133533 defendant Cole George gent 596172 596172 Cole, George, of Wareham, gent 0
4312098 2134371 2134371 defendant Byshoppe William merchant 596172 596172 Byshoppe, William, of Wareham, merchant 0
4332532 2141169 2141169 defendant Ecke George yeoman 596172 596172 Ecke, George, of Wareham, yeoman 3
4333632 2141531 2141531 defendant Burgis William yeoman 596172 596172 Burgis, William, of Wareham, yeoman 0
4333633 2141531 2141531 defendant Cooke Charles gent 596172 596172 Cooke, Charles, of Wareham, or of Litchet Matravers, gent 1
4338277 2143130 2143130 defendant Darby Henry yeoman 596172 596172 Darby, Henry, of Wareham, or of Athepudell, Dorset, yeoman 0
4338281 2143132 2143132 defendant Darby Nicholas yeoman 596172 596172 Darby, Nicholas, of Wareham, , or of Burton, yeoman 0
4357435 2149829 2149829 defendant Johnson William vintner 596172 596172 Johnson, William, of Wareham, or of Waymouth & Melcomb Regis, Dorset, vintner 0
4362880 2151785 2151785 defendant White Thomas clerk 596172 596172 White, Thomas, of Wareham, clerk 0
4363392 2151980 2151980 defendant Barrett John chapman 596172 596172 Barrett, John, of Wareham, chapman 0
4363393 2151980 2151980 defendant Barrett Robert fishmonger 596172 596172 Barrett, Robert, of Wareham, fishmonger 1
4367752 2153519 2153519 defendant Dowlon John husbandman 596172 596172 Dowlon, John, of Wareham, husbandman 0
4375650 2156350 2156350 defendant Shepster John innholder 596172 596172 Shepster, John, of Wareham, vintner, innholder 0
4377513 2157034 2157034 defendant Barrett Robert   596172 596172 Barrett, Robert, of Wareham, or of Swallowcliff, merchant, his son 1
4393176 2162325 2162325 defendant Baker William husbandman 596172 596172 Baker, William, of Wareham, or of Makeperton , husbandman 0
4393177 2162325 2162325 defendant Trygall Oliver yeoman 596172 596172 Trygall, Oliver, of Wareham, yeoman 1
4402640 2165468 2165468 defendant Squier Nicholas victualer 596172 596172 Squier, Nicholas, of Wareham, victualer 0
4402641 2165468 2165468 defendant Nighamgall George yeoman 596172 596172 Nighamgall , George, of Wareham, or of Westwood, Isle of Purbeck, yeoman 1
4406417 2166712 2166712 defendant Fleminge Henry tailor 596172 596172 Fleminge, Henry, of Wareham, or of Corff Castle, tailor 0
4406418 2166712 2166712 defendant Harvy Richard yeoman 596172 596172 Harvy, Richard, of Wareham, or of Lynche, Corffe Castle, yeoman 1
4451676 2185496 2185496 plaintiff Horewod John   596172 596172 Horewod, John, of Wareham, burgess 0
4479410 2194214 2194214 defendant Tange Thomas   596172 596172 Tange, Thomas, of Wareham 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);