names

171 rows where place_id = 590270

✎ 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
3600443 1867786 1867786 defendant Penley Thomas husbandman 590270 590270 Penley, Thomas, of Agmondesham, husbandman 1
3602244 1868367 1868367 defendant Clerke Emma widow 590270 590270 Clerke, Emma, of Agmondesham, widow 1
3604060 1868938 1868938 defendant Mowyer Roger husbandman 590270 590270 Mowyer, Roger, of Agmondesham, husbandman 2
3612404 1871507 1871507 defendant Dyer Edmund yeoman 590270 590270 Dyer, Edmund, of Agmondesham, yeoman 1
3623595 1874911 1874911 defendant Glasebroke John miller 590270 590270 Glasebroke, John, of Agmondesham, miller 0
3631343 1904613 1904613 defendant Benet Roger tanner 590270 590270 Benet, Roger, of Agmondesham, tanner 1
3631347 1904614 1904614 defendant Benet Roger tanner 590270 590270 Benet, Roger, of Agmondesham, tanner 1
3649056 1910096 1910096 defendant Adkyns William yeoman 590270 590270 Adkyns, William, of Agmondesham, yeoman 0
3649231 1910148 1910148 defendant Pek John husbandman 590270 590270 Pek, John, of Agmondesham, husbandman 1
3668138 1915982 1915982 defendant Salcotwe John tailor 590270 590270 Salcotwe, John, of Agmondesham, tailor 0
3672685 1917460 1917460 defendant Grove Thomas butcher 590270 590270 Grove, Thomas, of Agmondesham, butcher 1
3675175 1918268 1918268 defendant Copland Thomas butcher 590270 590270 Copland, Thomas, of Agmondesham, butcher 0
3678427 1919307 1919307 defendant Alee Robert tailor 590270 590270 Alee, Robert, of Agmondesham, tailor 0
3693318 1924122 1924122 defendant Ogbanke Thomas laborer 590270 590270 Ogbanke, Thomas, of Agmondesham, laborer 0
3700220 1926303 1926303 defendant Crane John husbandman 590270 590270 Crane, John, of Agmondesham, husbandman 0
3713447 1930518 1930518 defendant Stevyns Richard husbandman 590270 590270 Stevyns, Richard, of Agmondesham, husbandman 0
3713496 1930533 1930533 defendant Butteler William smith 590270 590270 Butteler, William, of Agmondesham, smith 0
3719165 1932278 1932278 defendant Halffacre Thomas capper 590270 590270 Halffacre, Thomas, of Agmondesham, capper 0
3729235 1935394 1935394 defendant Copland Thomas butcher 590270 590270 Copland, Thomas, of Agmondesham, butcher 0
3735319 1937280 1937280 defendant Tredewey James husbandman 590270 590270 Tredewey, James, of Agmondesham, husbandman 0
3736795 1937758 1937758 defendant Myton alias Halfacre Thomas capper 590270 590270 Myton alias Halfacre, Thomas, of Agmondesham, capper 0
3746411 1940797 1940797 defendant Rose Edward husbandman 590270 590270 Rose, Edward, of Agmondesham, husbandman 1
3756465 1943995 1943995 defendant Coplond Thomas butcher 590270 590270 Coplond, Thomas, of Agmondesham, butcher 0
3765701 1946939 1946939 defendant Copelond Thomas butcher 590270 590270 Copelond, Thomas, of Agmondesham, butcher 0
3769703 1948180 1948180 defendant Wyllys Edward butcher 590270 590270 Wyllys, Edward, of Agmondesham, butcher 2
3773476 1949415 1949415 defendant Coplande Thomas butcher 590270 590270 Coplande, Thomas, of Agmondesham, butcher 0
3773477 1949415 1949415 defendant Copland Richard butcher 590270 590270 Copland, Richard, of Agmondesham, butcher 1
3774363 1949704 1949704 defendant Copland Thomas butcher 590270 590270 Copland, Thomas, of Agmondesham, butcher 0
3780653 1951676 1951676 defendant Copland Thomas butcher 590270 590270 Copland, Thomas, of Agmondesham, butcher 0
3782850 1952385 1952385 defendant Coplond Thomas butcher 590270 590270 Coplond, Thomas, of Agmondesham, butcher 2
3783722 1952672 1952672 defendant Rose Edmund husbandman 590270 590270 Rose, Edmund, of Agmondesham, husbandman 0
3784436 1952914 1952914 defendant Roos Edmund husbandman 590270 590270 Roos, Edmund, of Agmondesham, husbandman 0
3800171 1957975 1957975 defendant Rose Edmund husbandman 590270 590270 Rose, Edmund, of Agmondesham, husbandman 0
3800193 1957980 1957980 defendant Coplond Thomas butcher 590270 590270 Coplond, Thomas, of Agmondesham, butcher 0
3806781 1960023 1960023 defendant Coplond Thomas butcher 590270 590270 Coplond, Thomas, of Agmondesham, butcher 0
3825373 1965786 1965786 defendant Longe Richard butcher 590270 590270 Longe, Richard, of Agmondesham, butcher 1
3825379 1965787 1965787 defendant Long Richard butcher 590270 590270 Long, Richard, of Agmondesham, butcher 2
3828598 1966822 1966822 defendant Mitton alias Halffeaker Thomas yeoman 590270 590270 Mitton alias Halffeaker, Thomas, of Agmondesham, yeoman 1
3836817 1969417 1969417 defendant Rose Edward husbandman 590270 590270 Rose, Edward, of Agmondesham, husbandman 0
3865751 1978772 1978772 defendant Brown Roger miller 590270 590270 Brown, Roger, of Agmondesham, miller 0
3867380 1979323 1979323 defendant Cutler Richard fisher 590270 590270 Cutler, Richard, of Agmondesham, fisher 0
3872708 1981088 1981088 defendant Rose Edmund husbandman 590270 590270 Rose, Edmund, of Agmondesham, husbandman 0
3888259 1986334 1986334 defendant Keterigge Robert butcher 590270 590270 Keterigge, Robert, of Agmondesham, butcher 0
3891888 1987539 1987539 defendant Keterege Robert butcher 590270 590270 Keterege, Robert, of Agmondesham, butcher 0
3922858 1997947 1997947 defendant Ryce John yeoman 590270 590270 Ryce, John, of Agmondesham, yeoman 2
3968402 2013581 2013581 plaintiff Cheyne John esq 590270 590270 Cheyne, John, of Agmondesham, esq 0
4041809 2039551 2039551 defendant Sapperton or Stapperton John gent 590270 590270 Sapperton or Stapperton, John, of Agmondesham, or of New Inn, gent 0
4041811 2039552 2039552 defendant Sapperton or Stapperton John gent 590270 590270 Sapperton or Stapperton, John, of Agmondesham, or of New Inn, gent 0
4110162 2063897 2063897 defendant Ball Walter yeoman 590270 590270 Ball, Walter, of Agmondesham, yeoman 1
4119229 2067170 2067170 defendant Baker Aaron yeoman 590270 590270 Baker, Aaron, of Agmondesham, yeoman 0
4194547 2093645 2093645 defendant Cheyne Henry esq 590270 590270 Cheyne, Henry, of Agmondesham, or of Sharlowes, esq 0
4194550 2093646 2093646 defendant Lered William tanner 590270 590270 Lered, William, of Agmondesham, tanner 1
4305902 2132202 2132202 defendant Wyer John tiler 590270 590270 Wyer, John, of Agmondesham, tiler 1
4429744 2174088 2174088 defendant Ran John le   590270 590270 Ran, John le, of Agmondesham 0
4446213 2183727 2183727 defendant Waryner John   590270 590270 Waryner, John, of Agmondesham, son of William 1
4855718 2313161 2313161 defendant Hosyer William hosier 590270 590270 Hosyer, William, of Agmondesham, hosier 0
4855719 2313161 2313161 defendant Tyllesworth Thomas fuller 590270 590270 together with Tyllesworth, Thomas, of Agmondesham, fuller 1
4855721 2313162 2313162 defendant Tyllesworth Thomas fuller 590270 590270 Tyllesworth, Thomas, of Agmondesham, fuller 0
4855722 2313162 2313162 defendant Hosyer William hosier 590270 590270 together wuth Hosyer, William, of Agmondesham, hosier 1
4880068 2320676 2320676 defendant Barbour John barber 590270 590270 Barbour, John, of Agmondesham, barber 0
4905501 2328318 2328318 plaintiff Brudenell Edmund   590270 590270 Brudenell, Edmund, of Agmondesham 0
4945581 2340597 2340597 defendant Glover Thomas hosier 590270 590270 Glover, Thomas, of Agmondesham, hosier 0
4960035 2344967 2344967 defendant Wryght Robert sawyer 590270 590270 Wryght, Robert, of Agmondesham, sawyer 0
4960037 2344967 2344967 defendant Bandon or Baudon John husbandman 590270 590270 Bandon or Baudon, John, of Agmondesham, husbandman 2
4960038 2344967 2344967 defendant Bryan John pedder 590270 590270 Bryan, John, of Agmondesham, pedder 3
4979678 2350877 2350877 defendant Webbe Thomas weaver 590270 590270 Webbe, Thomas, of Agmondesham, weaver 2
4995649 2355538 2355538 defendant Bryan John mercer 590270 590270 Bryan, John, of Agmondesham, mercer 0
5022952 2363622 2363622 defendant Delle Richard skinner 590270 590270 Delle, Richard, of Agmondesham, skinner 3
5034454 2366936 2366936 defendant Collys John baker 590270 590270 Collys, John, of Agmondesham, baker 2
5058778 2374190 2374190 defendant Fleccher Richard fletcher 590270 590270 Fleccher, Richard, of Agmondesham, fletcher 0
5058779 2374190 2374190 defendant Smyth John fletcher 590270 590270 Smyth, John, of Agmondesham, fletcher 1
5071836 2378071 2378071 defendant Somervyle Richard yeoman 590270 590270 Somervyle, Richard, of Agmondesham, yeoman 3
5080032 2380508 2380508 defendant Dyer John yeoman 590270 590270 Dyer, John, of Agmondesham, yeoman 0
5082316 2381204 2381204 defendant Colles Richard husbandman 590270 590270 Colles, Richard, of Agmondesham, husbandman 0
5082318 2381204 2381204 defendant Gromet John husbandman 590270 590270 Gromet, John, of Agmondesham, husbandman 2
5083780 2381652 2381652 defendant Holwey John butcher 590270 590270 Holwey, John, of Agmondesham, butcher 1
5110420 2389450 2389450 defendant Culverhous Joan widow 590270 590270 Culverhous, Joan, of Agmondesham, widow 0
5113520 2390343 2390343 defendant Baret William dyer 590270 590270 Baret, William, of Agmondesham, dyer 0
5118361 2391807 2391807 defendant Bovyndon Thomas carpenter 590270 590270 Bovyndon, Thomas, of Agmondesham, carpenter 0
5118373 2391809 2391809 defendant Glover Thomas draper 590270 590270 Glover, Thomas, of Agmondesham, draper 3
5221142 2421887 2421887 defendant Gullofre Simon dyer 590270 590270 Gullofre, Simon, of Agmondesham, dyer 0
5221144 2421887 2421887 defendant Barat William dyer 590270 590270 Barat, William, of Agmondesham, dyer 2
5226651 2423458 2423458 defendant Scryvener Robert smith 590270 590270 Scryvener, Robert, of Agmondesham, smith 0
5249502 2429967 2429967 defendant Clerk Thomas yeoman 590270 590270 Clerk, Thomas, of Agmondesham, yeoman 0
5252321 2430836 2430836 defendant Dyer John yeoman 590270 590270 Dyer, John, of Agmondesham, yeoman 0
5263296 2434266 2434266 defendant Dyer John yeoman 590270 590270 Dyer, John, of Agmondesham, yeoman 0
5263700 2434396 2434396 defendant Cok Robert butcher 590270 590270 Cok, Robert, of Agmondesham, butcher 0
5263711 2434400 2434400 defendant Civitas Thomas draper 590270 590270 Civitas, Thomas, of Agmondesham, draper 0
5274751 2437691 2437691 defendant Glover Thomas draper 590270 590270 Glover, Thomas, of Agmondesham, draper 1
5275927 2438031 2438031 defendant Edmundes Thomas   590270 590270 Edmundes, Thomas, of Agmondesham 0
5275928 2438031 2438031 defendant Emonde John miller 590270 590270 Emonde, John, of Agmondesham, miller 1
5276985 2438348 2438348 defendant Edmund Thomas clerk 590270 590270 Edmund, Thomas, of Agmondesham, clerk 0
5276986 2438348 2438348 defendant Emonde John miller 590270 590270 Emonde, John, of Agmondesham, miller 1
5286226 2440982 2440982 defendant Halder John husbandman 590270 590270 Halder, John, of Agmondesham, husbandman 3
5286231 2440983 2440983 defendant Halder John husbandman 590270 590270 Halder, John, of Agmondesham, husbandman 3
5294862 2443484 2443484 defendant Ed- Thomas clerk 590270 590270 Ed-, Thomas, of Agmondesham, clerk 0
5299414 2444803 2444803 plaintiff Brudenell Drew gent 590270 590270 Brudenell, Drew, of Agmondesham, gent 0
5299417 2444804 2444804 plaintiff Brudenell Drew gent 590270 590270 Brudenell, Drew, of Agmondesham, gent 0
5333120 2454975 2454975 defendant Holme William dyer 590270 590270 Holme, William, of Agmondesham, dyer 1
5333803 2455182 2455182 defendant Holmes Thomas dyer 590270 590270 Holmes, Thomas, of Agmondesham, dyer 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);