names

170 rows where place_id = 586043

✎ 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
3587766 1863821 1863821 defendant Wode Hugh (legal representative) 586043 586043 Wode, Hugh, of Reymerston, husbandman, executors of 0
3587767 1863821 1863821 defendant Wode Joan widow 586043 586043 (Wode, Joan, of Reymerston, widow 1
3591289 1864901 1864901 defendant Candeler Thomas butcher 586043 586043 Candeler, Thomas, of Reymerston, butcher 0
3606908 1869825 1869825 defendant Wroo John husbandman 586043 586043 Wroo, John, of Reymerston, husbandman 0
3616372 1872759 1872759 defendant Saunders Joan widow 586043 586043 Saunders, Joan, of Reymerston, widow 2
3620658 1874040 1874040 defendant Savage John husbandman 586043 586043 Savage, John, of Reymerston, husbandman 2
3625097 1875384 1875384 defendant Byrde William yeoman 586043 586043 Byrde, William, of Reymerston, yeoman 0
3625098 1875384 1875384 defendant Calwyn Thomas yeoman 586043 586043 Calwyn, Thomas, of Reymerston, yeoman 1
3657476 1912600 1912600 defendant Saye John   586043 586043 Saye, John, of Reymerston, shepherd 1
3657480 1912601 1912601 defendant Isak William yeoman 586043 586043 Isak, William, of Reymerston, yeoman 1
3663693 1914580 1914580 defendant Hunt Thomas husbandman 586043 586043 Hunt, Thomas, of Reymerston, husbandman 0
3683882 1921093 1921093 defendant Savage Robert husbandman 586043 586043 Savage, Robert, of Reymerston, husbandman 2
3712755 1930305 1930305 defendant Savage Robert husbandman 586043 586043 Savage, Robert, of Reymerston, husbandman 0
3712757 1930306 1930306 defendant Soppe William husbandman 586043 586043 Soppe, William, of Reymerston, husbandman 0
3717883 1931893 1931893 defendant Hunt Thomas husbandman 586043 586043 Hunt, Thomas, of Reymerston, husbandman 2
3724799 1934040 1934040 defendant Eglyn John husbandman 586043 586043 Eglyn, John, of Reymerston, husbandman 3
3743552 1939859 1939859 defendant Savage Robert husbandman 586043 586043 Savage, Robert, of Reymerston, husbandman 0
3749098 1941647 1941647 defendant Mere Richard   586043 586043 Mere, Richard, of Reymerston, hop hewer 0
3780338 1951582 1951582 defendant Talwyn Richard husbandman 586043 586043 Talwyn, Richard, of Reymerston, husbandman 0
3783657 1952649 1952649 defendant Wroo Robert husbandman 586043 586043 Wroo, Robert, of Reymerston, husbandman 4
3795548 1956489 1956489 defendant Hunte Thomas husbandman 586043 586043 Hunte, Thomas, of Reymerston, husbandman 2
3796716 1956860 1956860 defendant Talwyn Richard husbandman 586043 586043 Talwyn, Richard, of Reymerston, husbandman 0
3802172 1958575 1958575 defendant Hyndy Nicholas clerk 586043 586043 Hyndy, Nicholas, of Reymerston, clerk 3
3803134 1958881 1958881 defendant Hunt Thomas husbandman 586043 586043 Hunt, Thomas, of Reymerston, husbandman 0
3814899 1962576 1962576 defendant Moye Edmund husbandman 586043 586043 Moye, Edmund, of Reymerston, husbandman 1
3815574 1962788 1962788 defendant Raven William husbandman 586043 586043 Raven, William, of Reymerston, husbandman 1
3823600 1965279 1965279 defendant Deye Thomas husbandman 586043 586043 Deye, Thomas, of Reymerston, husbandman 1
3844201 1971735 1971735 defendant Cole William husbandman 586043 586043 Cole, William, of Reymerston, husbandman 0
3845944 1972289 1972289 defendant Pycher John blacksmith 586043 586043 Pycher, John, of Reymerston, blacksmith 1
3846339 1972408 1972408 defendant Talwyn Richard husbandman 586043 586043 Talwyn, Richard, of Reymerston, husbandman 1
3850501 1973745 1973745 defendant le Wroo Robert husbandman 586043 586043 le Wroo, Robert, of Reymerston, husbandman 0
3888484 1986408 1986408 defendant Wroo Richard husbandman 586043 586043 Wroo, Richard, of Reymerston, husbandman 2
3889372 1986677 1986677 defendant Talmyn Richard husbandman 586043 586043 Talmyn, Richard, of Reymerston, husbandman 0
3911112 1994043 1994043 defendant Talwyn Richard husbandman 586043 586043 Talwyn, Richard, of Reymerston, husbandman 1
3956040 2009181 2009181 plaintiff Moy Edmund   586043 586043 Moy, Edmund, of Reymerston 0
4010499 2028529 2028529 defendant Chase alias Chauncey William gent 586043 586043 Chase alias Chauncey, William, of Reymerston, or of Shipdam, gent 0
4016937 2030758 2030758 defendant Chasye or Chafye William gent 586043 586043 Chasye or Chafye, William, of Reymerston, gent 3
4025996 2033946 2033946 defendant Moye Francis husbandman 586043 586043 Moye, Francis, of Reymerston, husbandman 1
4042525 2039794 2039794 plaintiff Clypwyn Thomas   586043 586043 Clypwyn, Thomas, of Reymerston, hoop maker 2
4042526 2039794 2039794 defendant Bostocke Thomas clerk 586043 586043 Bostocke, Thomas, of Reymerston, clerk 0
4045027 2040676 2040676 defendant Hanserd William yeoman 586043 586043 Hanserd, William, of Reymerston, yeoman 0
4058982 2045608 2045608 defendant Reven Robert husbandman 586043 586043 Reven, Robert, of Reymerston, husbandman 0
4058983 2045608 2045608 defendant Atkynson John collier 586043 586043 Atkynson, John, of Reymerston, collier 1
4058984 2045608 2045608 defendant Mowse Geoffrey laborer 586043 586043 Mowse, Geoffrey, of Reymerston, laborer 2
4094642 2058423 2058423 defendant Levens Christopher gent 586043 586043 Levens, Christopher, of Reymerston, or of manor of Houlton, gent 0
4100921 2060645 2060645 defendant Dey Thomas thatcher 586043 586043 Dey, Thomas, of Reymerston, thatcher 0
4100923 2060645 2060645 defendant Soctt John weaver 586043 586043 Soctt, John, of Reymerston, weaver 2
4100924 2060645 2060645 defendant Wyther William tanner 586043 586043 Wyther, William, of Reymerston, tanner 3
4108684 2063359 2063359 defendant Beacon William butcher 586043 586043 Beacon, William, of Reymerston, butcher 3
4151922 2078783 2078783 defendant Dey Ruben husbandman 586043 586043 Dey, Ruben, of Reymerston, husbandman 0
4157615 2080737 2080737 defendant Parkyn Thomas yeoman 586043 586043 Parkyn, Thomas, of Reymerston, yeoman 0
4159164 2081272 2081272 defendant Hollond Robert husbandman 586043 586043 Hollond, Robert, of Reymerston, husbandman 3
4173275 2086113 2086113 defendant Moye Francis husbandman 586043 586043 Moye, Francis, of Reymerston, husbandman 3
4176434 2087237 2087237 defendant Gunton Henry husbandman 586043 586043 Gunton, Henry, of Reymerston, husbandman 0
4176435 2087237 2087237 defendant Hansard George husbandman 586043 586043 Hansard, George, of Reymerston, husbandman 1
4193696 2093363 2093363 defendant Norton Edward husbandman 586043 586043 Norton, Edward, of Reymerston, husbandman 1
4193697 2093363 2093363 defendant Norton Robert husbandman 586043 586043 Norton, Robert, of Reymerston, husbandman 2
4205293 2097400 2097400 defendant Talwyn Walter yeoman 586043 586043 Talwyn, Walter, of Reymerston, yeoman 1
4210860 2099357 2099357 defendant Hansard George husbandman 586043 586043 Hansard, George, of Reymerston, husbandman 0
4220669 2102728 2102728 defendant Harkyn or Larkyn Thomas   586043 586043 Harkyn or Larkyn, Thomas, of Reymerston, coal burner 1
4229655 2105854 2105854 defendant Halman Roger yeoman 586043 586043 Halman, Roger, of Reymerston, yeoman 1
4238786 2109185 2109185 defendant Gunton Henry yeoman 586043 586043 Gunton, Henry, of Reymerston, yeoman 0
4313221 2134735 2134735 defendant Gunton Henry yeoman 586043 586043 Gunton, Henry, of Reymerston, yeoman 1
4336156 2142378 2142378 defendant Moye John husbandman 586043 586043 Moye, John, of Reymerston, husbandman 0
4388711 2160858 2160858 defendant Parkyn Thomas   586043 586043 Parkyn, Thomas, of Reymerston, coal burner 3
4390947 2161588 2161588 defendant Moy John husbandman 586043 586043 Moy, John, of Reymerston, husbandman 0
4390948 2161588 2161588 defendant Savage Christopher yeoman 586043 586043 Savage, Christopher, of Reymerston, yeoman 1
4391781 2161871 2161871 defendant Moye John husbandman 586043 586043 Moye, John, of Reymerston, husbandman 0
4396104 2163271 2163271 defendant Moy John husbandman 586043 586043 Moy, John, of Reymerston, husbandman 0
4407202 2166972 2166972 defendant Turner Richard yeoman 586043 586043 Turner, Richard, of Reymerston, yeoman 1
4410185 2168009 2168009 defendant Moye Edmund husbandman 586043 586043 Moye, Edmund, of Reymerston, husbandman 1
4412193 2168671 2168671 defendant Moye John husbandman 586043 586043 Moye, John, of Reymerston, husbandman 1
4544911 2214326 2214326 defendant Nowell Thomas   586043 586043 Nowell, Thomas, of Reymerston 2
4557883 2218398 2218398 defendant Yalop John   586043 586043 Yalop, John, of Reymerston 0
4570529 2222356 2222356 defendant Mustell Hugh   586043 586043 Mustell, Hugh, of Reymerston 1
4579215 2224980 2224980 defendant Yallok John   586043 586043 Yallok, John, of Reymerston 5
4600562 2231398 2231398 plaintiff Toly John   586043 586043 Toly, John, of Reymerston, parson 0
4611285 2234593 2234593 defendant Cullyng John   586043 586043 Cullyng, John, of Reymerston 2
4625346 2238892 2238892 defendant Swathyng Edmund   586043 586043 Swathyng, Edmund, of Reymerston 1
4639233 2242993 2242993 plaintiff Cok William   586043 586043 Cok, William, of Reymerston 0
4639239 2242994 2242994 plaintiff cok William   586043 586043 cok, William, of Reymerston 0
4639240 2242994 2242994 defendant Mayfeld John   586043 586043 Mayfeld, John, of Reymerston 0
4657548 2248253 2248253 plaintiff Cok William   586043 586043 Cok, William, of Reymerston 0
4657553 2248254 2248254 plaintiff Cok William   586043 586043 Cok, William, of Reymerston 0
4657560 2248255 2248255 plaintiff Cok William   586043 586043 Cok, William, of Reymerston or of Lyrlyngge 0
4657563 2248255 2248255 defendant Mayfeld Thomas yeoman 586043 586043 Mayfeld, Thomas, of Reymerston, yeoman 2
4657564 2248256 2248256 plaintiff Cok William   586043 586043 Cok, William, of Reymerston or of Lyrlyngge 0
4657566 2248256 2248256 defendant Maydefeld John yeoman 586043 586043 Maydefeld, John, of Reymerston, yeoman 1
4672458 2257037 2257037 defendant Talwyn John husbandman 586043 586043 Talwyn, John, of Reymerston, husbandman 0
4680840 2259629 2259629 defendant Talwyn John yeoman 586043 586043 Talwyn, John, of Reymerston, yeoman 4
4824024 2303590 2303590 defendant Vergeons Margaret gent 586043 586043 Vergeons, Margaret, of Reymerston, gent 0
4849216 2311228 2311228 defendant Kyng Richard   586043 586043 Kyng, Richard, of Reymerston, parson 3
4877889 2320039 2320039 defendant Swathyng Edmund esq 586043 586043 Swathyng, Edmund, of Reymerston, esq 0
4888453 2323187 2323187 defendant Cros John husbandman 586043 586043 Cros, John, of Reymerston, husbandman 1
4895736 2325342 2325342 defendant Grey Richard turner 586043 586043 Grey, Richard, of Reymerston, turner 2
4930771 2336031 2336031 defendant Saundre Henry husbandman 586043 586043 Saundre, Henry, of Reymerston, husbandman 2
4955021 2343455 2343455 defendant Barker Robert laborer 586043 586043 Barker, Robert, of Reymerston, laborer 4
4955022 2343455 2343455 defendant Mustale Richard laborer 586043 586043 Mustale, Richard, of Reymerston, laborer 5
4970362 2348082 2348082 defendant Crosse John husbandman 586043 586043 Crosse, John, of Reymerston, husbandman 8
4981398 2351355 2351355 defendant Mustale Richard yeoman 586043 586043 Mustale, Richard, of Reymerston, yeoman 2

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