names

352 rows where place_id = 586569

✎ 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
3589060 1864226 1864226 defendant Herman Henry tailor 586569 586569 Herman, Henry, of Merden, tailor 0
3589061 1864226 1864226 defendant Maplesden Thomas butcher 586569 586569 Maplesden, Thomas, of Merden, butcher 1
3590404 1864642 1864642 defendant Reve Robert wheeler 586569 586569 Reve, Robert, of Merden, wheeler 0
3590565 1864689 1864689 defendant Afforde Thomas weaver 586569 586569 Afforde, Thomas, of Merden, weaver 2
3590730 1864741 1864741 defendant Cornell John husbandman 586569 586569 Cornell, John, of Merden, husbandman 0
3594969 1866056 1866056 defendant Nedeham Richard fuller 586569 586569 Nedeham, Richard, of Merden, fuller 0
3595628 1866259 1866259 defendant Astyn Thomas husbandman 586569 586569 Astyn, Thomas, of Merden, husbandman 1
3597794 1866926 1866926 defendant Rolf John husbandman 586569 586569 Rolf, John, of Merden, husbandman 1
3597795 1866926 1866926 defendant Marden William butcher 586569 586569 Marden, William, of Merden, butcher 2
3600651 1867850 1867850 defendant Aford Thomas yeoman 586569 586569 Aford, Thomas, of Merden, yeoman 0
3600652 1867850 1867850 defendant Hopkyn Roger husbandman 586569 586569 Hopkyn, Roger, of Merden, husbandman 1
3600653 1867850 1867850 defendant Lorymer Hugh husbandman 586569 586569 Lorymer, Hugh, of Merden, husbandman 2
3600654 1867850 1867850 defendant Couper John husbandman 586569 586569 Couper, John, of Merden, husbandman 3
3600655 1867850 1867850 defendant Sherppey Thomas husbandman 586569 586569 Sherppey, Thomas, of Merden, husbandman 4
3602381 1868406 1868406 defendant Calche Robert husbandman 586569 586569 Calche, Robert, of Merden, husbandman 0
3603306 1868707 1868707 defendant Leneshoth Robert (legal representative) 586569 586569 Leneshoth, Robert, of Merden, executrix of 2
3604926 1869205 1869205 defendant Cornell John husbandman 586569 586569 Cornell, John, of Merden, husbandman 5
3607312 1869949 1869949 defendant Harteregge Thomas yeoman 586569 586569 Harteregge, Thomas, of Merden, yeoman 0
3607313 1869949 1869949 defendant Bixpyxch William yeoman 586569 586569 Bixpyxch, William, of Merden, yeoman 1
3607314 1869949 1869949 defendant Cornhill Stephen yeoman 586569 586569 Cornhill, Stephen, of Merden, yeoman 2
3608455 1870306 1870306 defendant Merden William butcher 586569 586569 Merden, William, of Merden, butcher 0
3612166 1871449 1871449 defendant Hamshere John husbandman 586569 586569 Hamshere, John, of Merden, husbandman 0
3612167 1871449 1871449 defendant Lound William laborer 586569 586569 Lound, William, of Merden, laborer 1
3613125 1871758 1871758 defendant Cornell John husbandman 586569 586569 Cornell, John, of Merden, husbandman 0
3613703 1871934 1871934 defendant Rolfe John husbandman 586569 586569 Rolfe, John, of Merden, husbandman 0
3613704 1871934 1871934 defendant Felde Thomas yeoman 586569 586569 Felde, Thomas, of Merden, yeoman 1
3615883 1872606 1872606 defendant Atherst William husbandman 586569 586569 Atherst, William, of Merden, husbandman 1
3617123 1872980 1872980 plaintiff Feld Thomas   586569 586569 Feld, Thomas, of Merden 0
3617124 1872980 1872980 defendant Terry Richard husbandman 586569 586569 Terry, Richard, of Merden, husbandman 0
3620056 1873849 1873849 defendant Carpenter John husbandman 586569 586569 Carpenter, John, of Merden, husbandman 0
3620125 1873869 1873869 defendant Blasden Thomas weaver 586569 586569 Blasden, Thomas, of Merden, weaver 2
3620343 1873944 1873944 defendant Nedam Richard yeoman 586569 586569 Nedam, Richard, of Merden, yeoman 0
3620725 1874057 1874057 defendant Strode Stephen laborer 586569 586569 Strode, Stephen, of Merden, laborer 0
3620727 1874058 1874058 defendant Nedham Richard fuller 586569 586569 Nedham, Richard, of Merden, fuller 0
3620878 1874092 1874092 defendant Dyne or Dyve Thomas yeoman 586569 586569 Dyne or Dyve, Thomas, of Merden, yeoman 1
3621034 1874136 1874136 defendant Terry Richard husbandman 586569 586569 Terry, Richard, of Merden, husbandman 0
3621885 1874387 1874387 plaintiff Parleben John   586569 586569 Parleben, John, of Merden 0
3621886 1874387 1874387 defendant Terry Richard husbandman 586569 586569 Terry, Richard, of Merden, husbandman 0
3624326 1875142 1875142 defendant Draner John clothmaker 586569 586569 Draner, John, of Merden, clothmaker 2
3624368 1875156 1875156 defendant Merden William butcher 586569 586569 Merden, William, of Merden, butcher 0
3630695 1904429 1904429 defendant Dyke Thomas yeoman 586569 586569 Dyke, Thomas, of Merden, yeoman 0
3630696 1904429 1904429 defendant Affyld Thomas husbandman 586569 586569 Affyld, Thomas, of Merden, husbandman 1
3630697 1904429 1904429 defendant Affyld John husbandman 586569 586569 Affyld, John, of Merden, husbandman 2
3650034 1910379 1910379 defendant Spencer Ralph laborer 586569 586569 Spencer, Ralph, of Merden, laborer 0
3671106 1916929 1916929 defendant Umfrey William tinker 586569 586569 Umfrey, William, of Merden, tinker 2
3687208 1922176 1922176 defendant Langley William yeoman 586569 586569 Langley, William, of Merden, yeoman 1
3702380 1927004 1927004 plaintiff Cheseman John yeoman 586569 586569 Cheseman, John, of Merden, yeoman 0
3703237 1927283 1927283 defendant Hunt Edmund laborer 586569 586569 Hunt, Edmund, of Merden, laborer 0
3711491 1929902 1929902 plaintiff Thirkeld William yeoman 586569 586569 Thirkeld, William, of Merden, yeoman 0
3711492 1929902 1929902 defendant Smyth John husbandman 586569 586569 Smyth, John, of Merden, husbandman 0
3717057 1931620 1931620 defendant Hunt Edmund laborer 586569 586569 Hunt, Edmund, of Merden, laborer 0
3717526 1931769 1931769 defendant Colt George butcher 586569 586569 Colt, George, of Merden, butcher 0
3722102 1933176 1933176 defendant Colyer Henry weaver 586569 586569 Colyer, Henry, of Merden, weaver 0
3726966 1934701 1934701 defendant Foule Thomas husbandman 586569 586569 Foule, Thomas, of Merden, husbandman 3
3746913 1940950 1940950 defendant Hayes Thomas weaver 586569 586569 Hayes, Thomas, of Merden, weaver 0
3822058 1964793 1964793 defendant Collyer Henry weaver 586569 586569 Collyer, Henry, of Merden, weaver 1
3833495 1968408 1968408 defendant Stokys Richard butcher 586569 586569 Stokys, Richard, of Merden, butcher 0
3847315 1972720 1972720 defendant Turke John husbandman 586569 586569 Turke, John, of Merden, husbandman 0
3847316 1972720 1972720 defendant Swynnarton John yeoman 586569 586569 Swynnarton, John, of Merden, yeoman 1
3853705 1974790 1974790 defendant Lawnder George laborer 586569 586569 Lawnder, George, of Merden, laborer 0
3853706 1974790 1974790 defendant Lawnder Thomas laborer 586569 586569 Lawnder, Thomas, of Merden, laborer 1
3974631 2015693 2015693 defendant Barnes Henry clerk 586569 586569 Barnes, Henry, of Merden, clerk 0
4019679 2031768 2031768 defendant Usborne James yeoman 586569 586569 Usborne, James, of Merden, yeoman 0
4019680 2031768 2031768 defendant Waynman William yeoman 586569 586569 Waynman, William, of Merden, yeoman 1
4052702 2043396 2043396 defendant Norton Robert yeoman 586569 586569 Norton, Robert, of Merden, yeoman 8
4138823 2074258 2074258 defendant Carter Peter husbandman 586569 586569 Carter, Peter, of Merden, husbandman 1
4438419 2181307 2181307 defendant Harcheregge Thomas   586569 586569 Harcheregge, Thomas, of Merden 2
4438422 2181307 2181307 defendant Rolf John   586569 586569 Rolf, John, of Merden 5
4438424 2181307 2181307 defendant Bachelere Henry   586569 586569 Bachelere, Henry, of Merden 7
4594816 2229633 2229633 defendant Heselden John   586569 586569 Heselden, John, of Merden 1
4609026 2233925 2233925 plaintiff Broke Thomas   586569 586569 Broke, Thomas, of Merden 0
4651421 2246450 2246450 plaintiff Archeregge John   586569 586569 Archeregge, John, of Merden 0
4656827 2248031 2248031 defendant Brekynden William chapman 586569 586569 Brekynden, William, of Merden, chapman 2
4658985 2248682 2248682 defendant Kyng John sawyer 586569 586569 Kyng, John, of Merden, sawyer 0
4658986 2248683 2248683 plaintiff Dageselle John   586569 586569 Dageselle, John, of Merden 0
4658987 2248683 2248683 defendant Mahew William husbandman 586569 586569 Mahew, William, of Merden, husbandman 0
4664202 2250293 2250293 defendant Page John fuller 586569 586569 Page, John, of Merden, fuller 2
4676664 2258318 2258318 defendant Knyght John smith 586569 586569 Knyght, John, of Merden, smith 0
4677236 2258498 2258498 defendant Clerk John whitawyer or sadler 586569 586569 Clerk, John, of Merden, whitawyer or sadler 0
4684219 2260667 2260667 defendant Kynght John smith 586569 586569 Kynght, John, of Merden, smith 0
4695771 2264160 2264160 plaintiff Woderove John   586569 586569 Woderove, John, of Merden 1
4702788 2266271 2266271 defendant Knyght John smith 586569 586569 Knyght, John, of Merden, smith 1
4703054 2266337 2266337 defendant Amour thoams husbandman 586569 586569 Amour, thoams, of Merden, husbandman 0
4707224 2267639 2267639 plaintiff Merden Simon   586569 586569 Merden, Simon, of Merden 2
4714245 2269785 2269785 defendant Tylden Thomas husbandman 586569 586569 Tylden, Thomas, of Merden, husbandman 0
4719887 2271565 2271565 defendant Grene John carpenter 586569 586569 Grene, John, of Merden, carpenter 3
4727742 2273921 2273921 defendant Halpeny John butcher 586569 586569 Halpeny, John, of Merden, butcher 1
4731311 2274993 2274993 defendant Richard Nicholas skinner 586569 586569 Richard, Nicholas, of Merden, skinner 0
4733186 2275558 2275558 plaintiff Pultier Richard   586569 586569 Pultier, Richard, of Merden 0
4739796 2277524 2277524 plaintiff Aleyn John   586569 586569 Aleyn, John, of Merden, on his own account 0
4739797 2277524 2277524 defendant Knyth John smith 586569 586569 Knyth, John, of Merden, smith 0
4739798 2277524 2277524 defendant Halpeny John butcher 586569 586569 Halpeny, John, of Merden, butcher 1
4742816 2278406 2278406 defendant Ippyngbery John husbandman 586569 586569 Ippyngbery, John, of Merden, husbandman 0
4745716 2279259 2279259 defendant Halpeny John butcher 586569 586569 Halpeny, John, of Merden, butcher 2
4746579 2279490 2279490 defendant Bonewelle John fletcher 586569 586569 Bonewelle, John, of Merden, fletcher 1
4764526 2284892 2284892 defendant Gunthrop Peter   586569 586569 Gunthrop, Peter, of Merden, vicar 0
4772895 2287494 2287494 defendant Floyre William gent 586569 586569 Floyre, William, of Merden, gent 0
4787879 2292275 2292275 defendant Rychard Nicholas husbandman 586569 586569 Rychard, Nicholas, of Merden, husbandman 1
4799158 2295914 2295914 plaintiff Threle Richard   586569 586569 Threle, Richard, of Merden 0
4808760 2298907 2298907 defendant Floyer William gent 586569 586569 Floyer, William, of Merden, gent 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);