names

101 rows where place_id = 595267

✎ 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
3619742 1873747 1873747 defendant Horne alias Lewelyn Richard merchant 595267 595267 Horne alias Lewelyn, Richard, of Melcombe Regis, merchant 0
3649978 1910359 1910359 defendant Pers Robert husbandman 595267 595267 Pers, Robert, of Melcombe Regis, husbandman 0
3679722 1919727 1919727 defendant Raynold John merchant 595267 595267 Raynold, John, of Melcombe Regis, merchant 0
3718423 1932040 1932040 defendant Reynold John merchant 595267 595267 Reynold, John, of Melcombe Regis, merchant 0
3718427 1932041 1932041 defendant Reynold John merchant 595267 595267 Reynold, John, of Melcombe Regis, merchant 0
3790432 1954829 1954829 defendant Reynold John merchant 595267 595267 Reynold, John, of Melcombe Regis, merchant 0
3854485 1975041 1975041 defendant Michell Henry merchant 595267 595267 Michell, Henry, of Melcombe Regis, merchant 0
3859601 1976705 1976705 plaintiff Clerke John   595267 595267 Clerke, John, of Melcombe Regis 0
3873801 1981458 1981458 plaintiff Clerke John   595267 595267 Clerke, John, of Melcombe Regis 0
3944621 2005216 2005216 defendant Reynoldys Lancelot merchant 595267 595267 Reynoldys, Lancelot, of Melcombe Regis, merchant 0
3944622 2005216 2005216 defendant Reynold Ewen merchant 595267 595267 Reynold, Ewen, of Melcombe Regis, merchant 1
3960403 2010736 2010736 defendant Gregorye Robert merchant 595267 595267 Gregorye, Robert, of Melcombe Regis, merchant 1
3964894 2012326 2012326 plaintiff Bagge George merchant 595267 595267 Bagge, George, of Melcombe Regis, merchant 0
3976282 2016273 2016273 defendant Jurden Edmund merchant 595267 595267 Jurden, Edmund, of Melcombe Regis, merchant 0
3976284 2016274 2016274 defendant Jurden Richard merchant 595267 595267 Jurden, Richard, of Melcombe Regis, merchant 0
3989181 2020868 2020868 defendant Reynold Owen merchant 595267 595267 Reynold, Owen, of Melcombe Regis, merchant 1
3991457 2021697 2021697 defendant Wakelyn Thomas yeoman 595267 595267 Wakelyn, Thomas, of Melcombe Regis, yeoman 1
3994652 2022839 2022839 defendant Mager Barnard merchant 595267 595267 Mager, Barnard, of Melcombe Regis, merchant 1
4007656 2027525 2027525 defendant Heynson Thomas butcher 595267 595267 Heynson, Thomas, of Melcombe Regis, butcher 0
4012960 2029366 2029366 defendant Webber Thomas   595267 595267 Webber, Thomas, of Melcombe Regis merchant 0
4033389 2036594 2036594 defendant Gregorye Robert merchant 595267 595267 Gregorye, Robert, of Melcombe Regis, merchant 0
4045123 2040708 2040708 defendant Webber Thomas merchant 595267 595267 Webber, Thomas, of Melcombe Regis, merchant 0
4126951 2069932 2069932 defendant Lyght John gent 595267 595267 Lyght, John, of Melcombe Regis, gent 0
4506204 2202446 2202446 defendant Laton Richard   595267 595267 Laton, Richard, of Melcombe Regis 0
4514997 2205097 2205097 defendant Helyer William   595267 595267 Helyer, William, of Melcombe Regis 1
4516808 2205664 2205664 defendant Laton Richard   595267 595267 Laton, Richard, of Melcombe Regis 0
4529370 2209472 2209472 defendant Cokeman John   595267 595267 Cokeman, John, of Melcombe Regis 1
4541209 2213148 2213148 defendant Cokeman John   595267 595267 Cokeman, John, of Melcombe Regis 0
4543954 2214016 2214016 defendant Benefeld John   595267 595267 Benefeld, John, of Melcombe Regis 1
4549071 2215644 2215644 defendant Benefeld John   595267 595267 Benefeld, John, of Melcombe Regis 0
4560202 2219138 2219138 defendant Benefeld John   595267 595267 Benefeld, John, of Melcombe Regis 0
4570241 2222265 2222265 defendant Cole Thomas   595267 595267 Cole, Thomas, of Melcombe Regis 0
4579555 2225089 2225089 defendant Cole Thomas   595267 595267 Cole, Thomas, of Melcombe Regis 0
4682116 2260026 2260026 defendant Abbot John, senior merchant 595267 595267 Abbot, John, senior, of Melcombe Regis, merchant 0
4682118 2260026 2260026 defendant Abbot Robeort   595267 595267 Abbot, Robeort, of Melcombe Regis, merchant, & son of John Abbot, senior 2
4686812 2261486 2261486 defendant Cokeman John husbandman 595267 595267 Cokeman, John, of Melcombe Regis, husbandman 0
4693520 2263475 2263475 defendant Causemond John merchant 595267 595267 Causemond, John, of Melcombe Regis, merchant 3
4701379 2265833 2265833 defendant Causmond John merchant 595267 595267 Causmond, John, of Melcombe Regis, merchant 0
4707936 2267852 2267852 defendant Pullchare John merchant 595267 595267 Pullchare, John, of Melcombe Regis, merchant 0
4731259 2274978 2274978 defendant Caymon John merchant 595267 595267 Caymon, John, of Melcombe Regis, merchant 0
4731261 2274978 2274978 defendant Pyn William merchant 595267 595267 Pyn, William, of Melcombe Regis, merchant 2
4731264 2274978 2274978 defendant Abbot Robert merchant 595267 595267 Abbot, Robert, of Melcombe Regis, merchant 5
4731459 2275039 2275039 defendant Burnage Alice   595267 595267 Burnage, Alice, of Melcombe Regis, widow, formerly wife of Ralph 2
4731465 2275041 2275041 defendant Burnage Alice   595267 595267 Burnage, Alice, of Melcombe Regis widow, formerly wife of Ralph 2
4733286 2275587 2275587 defendant Laurens Alice widow & formerly wife of Robert 595267 595267 Laurens, Alice, of Melcombe Regis, widow & formerly wife of Robert 3
4748923 2280174 2280174 defendant Burnage Ralph (legal representative) 595267 595267 Burnage, Ralph, of Melcombe Regis, executrix of 4
4758816 2283111 2283111 defendant Benevile William shipman 595267 595267 Benevile, William, of Melcombe Regis, shipman 1
4764561 2284903 2284903 defendant Frankeleyn Thomas shipman 595267 595267 Frankeleyn, Thomas, of Melcombe Regis, shipman 0
4764562 2284903 2284903 defendant Payn Thomas shipman 595267 595267 Payn, Thomas, of Melcombe Regis, shipman 1
4770609 2286789 2286789 defendant Pulhare John husbandman 595267 595267 Pulhare, John, of Melcombe Regis, husbandman 0
4801199 2296559 2296559 defendant Pyry Nicholas hosier 595267 595267 Pyry, Nicholas, of Melcombe Regis, hosier 0
4803571 2297303 2297303 defendant Walische John merchant 595267 595267 Walische, John, of Melcombe Regis, merchant 3
4832841 2306295 2306295 defendant Bonevyle William yeoman 595267 595267 Bonevyle, William, of Melcombe Regis, yeoman 0
4838068 2307827 2307827 defendant Russell John merchant 595267 595267 Russell, John, of Melcombe Regis, merchant 0
4854863 2312874 2312874 plaintiff Abbot Robert merchant 595267 595267 Abbot, Robert, of Melcombe Regis, merchant 0
4854866 2312875 2312875 plaintiff Abbot Robert merchant 595267 595267 Abbot, Robert, of Melcombe Regis, merchant 0
4913986 2330884 2330884 defendant Bonevyle William husbandman 595267 595267 Bonevyle, William, of Melcombe Regis, husbandman 3
4923754 2333871 2333871 defendant Ewsias Henry merchant 595267 595267 Ewsias, Henry, of Melcombe Regis, merchant 1
4950101 2341998 2341998 defendant Abbot Robert merchant 595267 595267 Abbot, Robert, of Melcombe Regis, merchant 0
5019374 2362548 2362548 defendant Chyney John   595267 595267 Chyney, John, of Melcombe Regis, shepherd 2
5019375 2362548 2362548 defendant Boweclyf John weaver 595267 595267 Boweclyf, John, of Melcombe Regis, weaver 3
5030095 2365674 2365674 defendant Abbot Robert merchant 595267 595267 Abbot, Robert, of Melcombe Regis, merchant 1
5040441 2368744 2368744 defendant Benet John helyer 595267 595267 Benet, John, of Melcombe Regis, helyer 0
5061053 2374880 2374880 defendant Rishetonne Thomas merchant 595267 595267 Rishetonne, Thomas, of Melcombe Regis, merchant 0
5061062 2374882 2374882 defendant Bowecher alias Grene John butcher 595267 595267 Bowecher alias Grene, John, of Melcombe Regis, butcher 1
5064790 2376007 2376007 defendant Grene John butcher 595267 595267 Grene, John, of Melcombe Regis, butcher 0
5065562 2376234 2376234 defendant Eustas or Enstas Henry merchant 595267 595267 Eustas or Enstas, Henry, of Melcombe Regis, merchant 0
5077710 2379829 2379829 defendant Eustas Henry shipman 595267 595267 Eustas, Henry, of Melcombe Regis, shipman 0
5113162 2390246 2390246 defendant Rix Simon merchant 595267 595267 Rix, Simon, of Melcombe Regis, merchant 1
5113163 2390246 2390246 defendant Freman John merchant 595267 595267 Freman, John, of Melcombe Regis, merchant 2
5125298 2393879 2393879 defendant Clerk John merchant 595267 595267 Clerk, John, of Melcombe Regis, merchant 1
5135787 2396981 2396981 defendant Riston Joan widow 595267 595267 Riston, Joan, of Melcombe Regis, widow 0
5142386 2398896 2398896 defendant Ruyssheton Joan widow 595267 595267 Ruyssheton, Joan, of Melcombe Regis, widow 0
5143890 2399353 2399353 defendant Clerke John merchant 595267 595267 Clerke, John, of Melcombe Regis, merchant 1
5164096 2405231 2405231 defendant Ruyssheton Joan widow 595267 595267 Ruyssheton, Joan, of Melcombe Regis, widow 0
5164927 2405479 2405479 defendant Clerk John merchant 595267 595267 Clerk, John, of Melcombe Regis, merchant 0
5172513 2407686 2407686 defendant Ryston Joan widow 595267 595267 Ryston, Joan, of Melcombe Regis, widow 0
5178508 2409425 2409425 defendant Clerk John merchant 595267 595267 Clerk, John, of Melcombe Regis, merchant 0
5178641 2409467 2409467 defendant Hustas Henry merchant 595267 595267 Hustas, Henry, of Melcombe Regis, merchant 1
5192022 2413395 2413395 defendant Ryston alias Russheton Joan widow 595267 595267 Ryston alias Russheton, Joan, of Melcombe Regis, widow 0
5204431 2417045 2417045 defendant Morton Thomas tailor 595267 595267 Morton, Thomas, of Melcombe Regis, tailor 0
5204432 2417045 2417045 defendant Couper Edward tailor 595267 595267 Couper, Edward, of Melcombe Regis, tailor 1
5210488 2418801 2418801 defendant Custas Henry merchant 595267 595267 Custas, Henry, of Melcombe Regis, merchant 0
5230745 2424600 2424600 defendant Grene alias Bonch John merchant 595267 595267 Grene alias Bonch, John, of Melcombe Regis, merchant 2
5240302 2427375 2427375 defendant Corffe John merchant 595267 595267 Corffe, John, of Melcombe Regis, merchant 0
5262466 2434005 2434005 defendant Turbervyle Richard gent 595267 595267 Turbervyle, Richard, of Melcombe Regis, gent 0
5277453 2438484 2438484 defendant Grene John merchant 595267 595267 Grene, John, of Melcombe Regis, merchant 0
5297376 2444234 2444234 defendant Corfe John   595267 595267 Corfe, John, of Melcombe Regis 0
5303620 2446078 2446078 defendant Corfe John merchant 595267 595267 Corfe, John, of Melcombe Regis, merchant 1
5305111 2446531 2446531 defendant Herman Nicholas yeoman 595267 595267 Herman, Nicholas, of Melcombe Regis, baker, Glover, William, of Dorchester, yeoman 0
5318377 2450592 2450592 defendant Harrys Richard yeoman 595267 595267 Harrys, Richard, of Melcombe Regis, yeoman 0
5516302 2509931 2509931 defendant Grene John merchant 595267 595267 Grene, John, of Melcombe Regis, merchant 1
5518984 2510780 2510780 defendant Michell Richard merchant 595267 595267 Michell, Richard, of Melcombe Regis, merchant 0
5562247 2523555 2523555 defendant Leweleyne Richard merchant 595267 595267 Leweleyne, Richard, of Melcombe Regis, merchant 0
5562248 2523555 2523555 defendant Horne Richard merchant 595267 595267 Horne, Richard, of Melcombe Regis, merchant 1
5564148 2524127 2524127 defendant Ragdale Stephen merchant 595267 595267 Ragdale, Stephen, of Melcombe Regis, merchant 3
5564154 2524128 2524128 defendant Tagdale Stephen merchant 595267 595267 Tagdale, Stephen, of Melcombe Regis, merchant 3
5574425 2527086 2527086 defendant Smyth John yeoman 595267 595267 Smyth, John, of Melcombe Regis, yeoman 1
5610471 2546991 2546991 plaintiff Bakere John   595267 595267 Bakere, John, of Melcombe Regis 0
5620921 2550416 2550416 plaintiff Smyth John   595267 595267 Smyth, John, of Melcombe Regis 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);