names

237 rows where place_id = 589276

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597084 1866711 1866711 defendant Lay Richard husbandman 589276 589276 Lay, Richard, of Overton, husbandman 1
3611054 1871133 1871133 defendant Tounrowe Richard husbandman 589276 589276 Tounrowe, Richard, of Overton, husbandman 2
3611055 1871133 1871133 defendant Padley Philip husbandman 589276 589276 Padley, Philip, of Overton, husbandman 3
3611056 1871133 1871133 defendant broke John husbandman 589276 589276 broke, John, of Overton, husbandman 4
3611057 1871133 1871133 defendant Couleshawe Thomas husbandman 589276 589276 Couleshawe, Thomas, of Overton, husbandman 5
3611058 1871133 1871133 defendant Broke Henry husbandman 589276 589276 Broke, Henry, of Overton, husbandman 6
3616215 1872713 1872713 defendant Botiller Henry yeoman 589276 589276 Botiller, Henry, of Overton, yeoman 0
3616217 1872714 1872714 defendant Botiller Henry yeoman 589276 589276 Botiller, Henry, of Overton, yeoman 0
3620031 1873838 1873838 defendant Boteler Henry dyer 589276 589276 Boteler, Henry, of Overton, dyer 0
3628884 1903909 1903909 defendant Browne Edward chapman 589276 589276 Browne, Edward, of Overton, chapman 2
3649216 1910143 1910143 defendant Est William mercer 589276 589276 Est, William, of Overton, mercer 1
3650365 1910490 1910490 defendant Englysshe William yeoman 589276 589276 Englysshe, William, of Overton, yeoman 1
3650366 1910490 1910490 defendant Gardyner Michael yeoman 589276 589276 Gardyner, Michael, of Overton, yeoman 2
3657254 1912530 1912530 defendant Broune Edward mercer 589276 589276 Broune, Edward, of Overton, mercer 4
3666404 1915443 1915443 defendant Kyrkebey Robert gent 589276 589276 Kyrkebey, Robert, of Overton, gent 0
3677944 1919146 1919146 defendant Wested Richard yeoman 589276 589276 Wested, Richard, of Overton, yeoman 2
3694010 1924328 1924328 defendant Curwen Roger gent 589276 589276 Curwen, Roger, of Overton, gent 0
3695019 1924653 1924653 defendant Joins John husbandman 589276 589276 Joins, John, of Overton, husbandman 0
3695225 1924724 1924724 defendant Sherman Thomas yeoman 589276 589276 Sherman, Thomas, of Overton, yeoman 1
3710094 1929468 1929468 defendant Weggewode William yeoman 589276 589276 Weggewode, William, of Overton, yeoman 2
3718837 1932172 1932172 plaintiff Godard Thomas gent 589276 589276 Godard, Thomas, of Overton, gent 0
3732520 1936401 1936401 defendant Smyth Thomas husbandman 589276 589276 Smyth, Thomas, of Overton, husbandman 4
3736260 1937580 1937580 defendant Wattys Richard chapman 589276 589276 Wattys, Richard, of Overton, chapman 0
3736262 1937581 1937581 defendant Wattys Richard chapman 589276 589276 Wattys, Richard, of Overton, chapman 0
3742875 1939626 1939626 defendant Bylond Robert yeoman 589276 589276 Bylond, Robert, of Overton, yeoman 0
3746360 1940779 1940779 defendant Smyth Thomas husbandman 589276 589276 Smyth, Thomas, of Overton, husbandman 0
3783978 1952770 1952770 defendant Fygen Thomas husbandman 589276 589276 Fygen, Thomas, of Overton, husbandman 0
3790209 1954757 1954757 defendant Wattys Richard yeoman 589276 589276 Wattys, Richard, of Overton, yeoman 1
3790224 1954760 1954760 defendant Wattys Richard yeoman 589276 589276 Wattys, Richard, of Overton, yeoman 1
3807513 1960256 1960256 defendant Curwen Roger gent 589276 589276 Curwen, Roger, of Overton, gent 0
3842122 1971086 1971086 defendant Orton John husbandman 589276 589276 Orton, John, of Overton under Ardern, husbandman 0
3856684 1975720 1975720 defendant Whytehede Oliver husbandman 589276 589276 Whytehede, Oliver, of Overton, husbandman 0
3975807 2016101 2016101 defendant Franckelyn Richard yeoman 589276 589276 Franckelyn, Richard, of Overton, yeoman 0
3980977 2017953 2017953 defendant Ley Thomas (legal representative) 589276 589276 Ley, Thomas, of Overton, gent, executors of 0
3980978 2017953 2017953 defendant Hydley John gent 589276 589276 (Hydley, John, of Overton, gent 1
3989332 2020926 2020926 defendant Overton Thomas ap John gent 589276 589276 Overton, Thomas ap John, of Overton, gent 1
3997938 2024021 2024021 defendant Herbert Elizabeth widow 589276 589276 Herbert, Elizabeth, of Overton, widow 0
3998023 2024052 2024052 defendant Herbert Elizabeth widow 589276 589276 Herbert, Elizabeth, of Overton, widow 0
3999095 2024436 2024436 defendant Cleyford alias Bartlemewe Thomas clerk 589276 589276 Cleyford alias Bartlemewe, Thomas, of Overton, clerk 0
4026515 2034133 2034133 defendant Wescott Thomas husbandman 589276 589276 Wescott, Thomas, of Overton, husbandman 0
4031782 2036027 2036027 defendant Mascalle Roger husbandman 589276 589276 Mascalle, Roger, of Overton, husbandman 1
4031785 2036028 2036028 defendant Mascolle Roger husbandman 589276 589276 Mascolle, Roger, of Overton, husbandman 1
4038876 2038525 2038525 defendant Wescott Thomas husbandman 589276 589276 Wescott, Thomas, of Overton, husbandman 0
4042243 2039706 2039706 defendant Palmes Francis gent 589276 589276 Palmes, Francis, of Overton, gent 0
4061514 2046516 2046516 defendant Hughes George yeoman 589276 589276 Hughes, George, of Overton, yeoman 0
4061515 2046516 2046516 defendant Tyler Thomas yeoman 589276 589276 Tyler, Thomas, of Overton, yeoman 1
4061518 2046517 2046517 defendant Hughes George yeoman 589276 589276 Hughes, George, of Overton, yeoman 0
4061519 2046517 2046517 defendant Tyler Thomas yeoman 589276 589276 Tyler, Thomas, of Overton, yeoman 1
4065961 2048117 2048117 defendant Mastell Roger yeoman 589276 589276 Mastell, Roger, of Overton, yeoman 0
4071641 2050153 2050153 defendant Clarke Arthur weaver 589276 589276 Clarke, Arthur, of Overton, weaver 0
4071642 2050153 2050153 defendant Gyles John, senior husbandman 589276 589276 Gyles, John, senior, of Overton, husbandman 1
4071643 2050153 2050153 defendant Parkes Edward laborer 589276 589276 Parkes, Edward, of Overton, laborer 2
4071644 2050153 2050153 defendant Andreos William laborer 589276 589276 Andreos, William, of Overton, laborer 3
4073296 2050738 2050738 defendant Meryll William yeoman 589276 589276 Meryll, William, of Overton, yeoman 1
4118664 2066968 2066968 defendant Wynne alias Haukyn Thomas yeoman 589276 589276 Wynne alias Haukyn, Thomas, of Overton, yeoman 0
4141021 2075018 2075018 defendant Cranwell Richard yeoman 589276 589276 Cranwell, Richard, of Overton, yeoman 0
4151765 2078733 2078733 defendant Blande John husbandman 589276 589276 Blande, John, of Overton, husbandman 0
4171233 2085400 2085400 defendant Clifford Thomas clerk 589276 589276 Clifford, Thomas, of Overton, clerk 2
4204012 2096955 2096955 defendant Hunt Adam yeoman 589276 589276 Hunt, Adam, of Overton, Asheover, yeoman 0
4218121 2101835 2101835 defendant Aylife Richard yeoman 589276 589276 Aylife, Richard, of Overton, yeoman 1
4219867 2102449 2102449 defendant Palmes Richard gent 589276 589276 Palmes, Richard, of Overton, gent 0
4234421 2107580 2107580 defendant Mecon William shoemaker 589276 589276 Mecon, William, of Overton, shoemaker 1
4234422 2107580 2107580 defendant Hall John yeoman 589276 589276 Hall, John, of Overton, yeoman 2
4257253 2115404 2115404 defendant Houghe John husbandman 589276 589276 Houghe, John, of Overton, husbandman 2
4269467 2119378 2119378 defendant Houghe John husbandman 589276 589276 Houghe, John, of Overton, husbandman 2
4280524 2123095 2123095 plaintiff Pennye Maud spinster 589276 589276 Maud his wife, formerly Maud Turner, of Overton, spinster 1
4361504 2151275 2151275 defendant Dowse John gent 589276 589276 Dowse, John, of Overton, gent 0
4380255 2158039 2158039 defendant Calton Henry yeoman 589276 589276 Calton, Henry, of Overton, yeoman 0
4384811 2159608 2159608 defendant Dowce John gent 589276 589276 Dowce, John, of Overton, gent 0
4413730 2169190 2169190 plaintiff Broun Joan   589276 589276 Broun, Joan, of Overton, formerly wife of John 0
4413734 2169191 2169191 plaintiff Broun Joan   589276 589276 Broun, Joan, of Overton, formerly wife of John 1
4427428 2173416 2173416 defendant Reve John le   589276 589276 Reve, John le, of Overton 5
4427435 2173417 2173417 defendant Reve John le   589276 589276 Reve, John le, of Overton 5
4439963 2181781 2181781 defendant Geffrey William (legal representative) 589276 589276 Geffrey, William, of Overton, executors of 0
4454244 2186346 2186346 defendant Orpud William   589276 589276 Orpud, William, of Overton 0
4474794 2192787 2192787 plaintiff Dyere Henry   589276 589276 Dyere, Henry, of Overton 0
4501959 2201209 2201209 plaintiff Marham John   589276 589276 Marham, John, of Overton 0
4511281 2203975 2203975 defendant Otele John   589276 589276 Otele, John, of Overton 0
4534948 2211209 2211209 defendant Bailly Henry   589276 589276 Bailly, Henry, of Overton 0
4534951 2211210 2211210 defendant Bailly Henry   589276 589276 Bailly, Henry, of Overton 1
4540718 2213003 2213003 defendant Pychener Agnes   589276 589276 Pychener, Agnes, of Overton 0
4548023 2215316 2215316 defendant Foxe John   589276 589276 Foxe, John, of Overton 4
4561098 2219425 2219425 defendant Sawer John   589276 589276 Sawer, John, of Overton 0
4563070 2220018 2220018 defendant Othe John   589276 589276 Othe, John, of Overton 0
4569099 2221924 2221924 defendant Bocher William   589276 589276 Bocher, William, of Overton 0
4583157 2226156 2226156 defendant Taillour John   589276 589276 Taillour, John, of Overton 2
4584407 2226539 2226539 defendant Dawe John   589276 589276 Dawe, John, of Overton 0
4584409 2226539 2226539 defendant Piers William   589276 589276 Piers, William, of Overton 2
4584410 2226539 2226539 defendant Piers Roger   589276 589276 Piers, Roger, of Overton 3
4584417 2226541 2226541 defendant Smyth Hugh   589276 589276 Smyth, Hugh, of Overton 2
4590064 2228253 2228253 defendant Helyer Thomas   589276 589276 Helyer, Thomas, of Overton 0
4597528 2230472 2230472 defendant Kygyll Robert tailor 589276 589276 Kygyll, Robert, of Overton, tailor 0
4609391 2234038 2234038 plaintiff Bryne John   589276 589276 Bryne, John, of Overton 0
4609392 2234038 2234038 defendant Burde Richard   589276 589276 Burde, Richard, of Overton 0
4609393 2234038 2234038 defendant Lemman Richard   589276 589276 Lemman, Richard, of Overton 1
4609394 2234038 2234038 defendant Symmes Robert   589276 589276 Symmes, Robert, of Overton 2
4609395 2234038 2234038 defendant Haukyn Thomas   589276 589276 Haukyn, Thomas, of Overton 3
4609396 2234038 2234038 defendant Burde John   589276 589276 Burde, John, of Overton 4
4611712 2234726 2234726 defendant Batty John   589276 589276 Batty, John, of Overton 0
4661859 2249556 2249556 defendant Dautre or Dantre Robert brasier 589276 589276 Dautre or Dantre, Robert, of Overton, brasier 1

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