names

206 rows where place_id = 592109

✎ 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
3606592 1869735 1869735 defendant Wulnerd William, junior yeoman 592109 592109 Wulnerd, William, junior, of Kersey, yeoman 1
3606593 1869735 1869735 defendant Parker Robert clothmaker 592109 592109 Parker, Robert, of Kersey, clothmaker 2
3626709 1903199 1903199 defendant Smyth John carpenter 592109 592109 Smyth, John, of Kersey, carpenter 2
3627244 1903367 1903367 defendant Page Robert clothmaker 592109 592109 Page, Robert, of Kersey, clothmaker 2
3630294 1904323 1904323 defendant Skete John butcher 592109 592109 Skete, John, of Kersey, butcher 0
3630296 1904323 1904323 defendant Belcham John, senior husbandman 592109 592109 Belcham, John, senior, of Kersey, husbandman 2
3631293 1904602 1904602 defendant Horswreth John husbandman 592109 592109 Horswreth, John, of Kersey, husbandman 1
3631308 1904602 1904602 defendant Skete John butcher 592109 592109 Skete, John, of Kersey, butcher 16
3648838 1910025 1910025 defendant Man Andrew husbandman 592109 592109 Man, Andrew, of Kersey, husbandman 0
3648840 1910025 1910025 defendant Man James husbandman 592109 592109 Man, James, of Kersey, husbandman 2
3650202 1910434 1910434 defendant Broke John husbandman 592109 592109 Broke, John, of Kersey, husbandman 0
3657491 1912604 1912604 defendant Rygby John weaver 592109 592109 Rygby, John, of Kersey, weaver 0
3706214 1928231 1928231 defendant Nooke Robert yeoman 592109 592109 Nooke, Robert, of Kersey, yeoman 0
3708404 1928925 1928925 defendant Syer Richard butcher 592109 592109 Syer, Richard, of Kersey, butcher 0
3709828 1929388 1929388 defendant Ball John clothman 592109 592109 Ball, John, of Kersey, clothman 4
3712171 1930124 1930124 defendant Cutteler John clothmaker 592109 592109 Cutteler, John, of Kersey, clothmaker 0
3722999 1933458 1933458 defendant Syer Richard butcher 592109 592109 Syer, Richard, of Kersey, butcher 0
3738864 1938361 1938361 defendant Page Thomas fuller 592109 592109 Page, Thomas, of Kersey, fuller 1
3755453 1943658 1943658 defendant Man Richard husbandman 592109 592109 Man, Richard, of Kersey, husbandman 4
3759638 1945003 1945003 defendant Coke William pedder 592109 592109 Coke, William, of Kersey, pedder 0
3762427 1945892 1945892 defendant Cooke William pedder 592109 592109 Cooke, William, of Kersey, pedder 1
3768140 1947672 1947672 defendant Manne Richard husbandman 592109 592109 Manne, Richard, of Kersey, husbandman 1
3779184 1951212 1951212 defendant Tomson James clothmaker 592109 592109 Tomson, James, of Kersey, clothmaker 1
3779185 1951212 1951212 defendant Butler John clothmaker 592109 592109 Butler, John, of Kersey, clothmaker 2
3787782 1953968 1953968 defendant Tompson James clothmaker 592109 592109 Tompson, James, of Kersey, clothmaker 0
3826132 1966015 1966015 plaintiff Anger John   592109 592109 Anger, John, of Kersey, administrators of 0
3829768 1967203 1967203 defendant Ballys John clothmaker 592109 592109 Ballys, John, of Kersey, clothmaker 0
3836827 1969420 1969420 defendant Ballys John yeoman 592109 592109 Ballys, John, of Kersey, yeoman 3
3837825 1969743 1969743 defendant Molyns John yeoman 592109 592109 Molyns, John, of Kersey, yeoman 1
3845395 1972121 1972121 defendant Paton Robert husbandman 592109 592109 Paton, Robert, of Kersey, husbandman 3
3854130 1974929 1974929 defendant Balle John husbandman 592109 592109 Balle, John, of Kersey, husbandman 2
3861437 1977286 1977286 defendant Man James husbandman 592109 592109 Man, James, of Kersey, husbandman 0
3861861 1977425 1977425 defendant Coke William husbandman 592109 592109 Coke, William, of Kersey, husbandman 3
3899008 1989875 1989875 defendant Ambroos Emma widow 592109 592109 Ambroos, Emma, of Kersey, widow 0
3899009 1989875 1989875 defendant Ambroos William her son 592109 592109 Ambroos, William, of Kersey, yeoman, her son 1
3962249 2011378 2011378 defendant Myllar Robert clothier 592109 592109 Myllar, Robert, of Kersey, clothier 1
3967633 2013315 2013315 defendant Ambrose Richard clothier 592109 592109 Ambrose, Richard, of Kersey, clothier 0
3971148 2014464 2014464 defendant Rasshebrook Robert clothier 592109 592109 Rasshebrook, Robert, of Kersey, clothier 1
3971149 2014464 2014464 defendant Rasshebrook John clothier 592109 592109 Rasshebrook, John, of Kersey, clothier 2
3988619 2020672 2020672 defendant Martyn John husbandman 592109 592109 Martyn, John, of Kersey, husbandman 4
3988620 2020672 2020672 defendant Cooke John husbandman 592109 592109 Cooke, John, of Kersey, husbandman 5
3994937 2022940 2022940 defendant Raschebroke John clothier 592109 592109 Raschebroke, John, of Kersey, clothier 0
4006484 2027097 2027097 defendant Gowche or Gowege Simon yeoman or smith 592109 592109 Gowche or Gowege, Simon, of Kersey, yeoman or smith 0
4010637 2028575 2028575 defendant Gowge Simon smith 592109 592109 Gowge, Simon, of Kersey, smith 1
4015403 2030204 2030204 defendant Grymwade Richard yeoman 592109 592109 Grymwade, Richard, of Kersey, yeoman 2
4019262 2031624 2031624 defendant Gowge or Gowiche Simon husbandman 592109 592109 Gowge or Gowiche, Simon, of Kersey, husbandman 0
4019263 2031624 2031624 defendant Gowge or Gowiche John husbandman 592109 592109 Gowge or Gowiche, John, of Kersey, husbandman 1
4027985 2034659 2034659 defendant Grymwood Richard husbandman 592109 592109 Grymwood, Richard, of Kersey, husbandman 1
4100207 2060407 2060407 defendant Welham John husbandman 592109 592109 Welham, John, of Kersey, husbandman 0
4122444 2068335 2068335 defendant Hawkyns alias Halfyn John sherman 592109 592109 Hawkyns alias Halfyn, John, of Kersey, sherman 1
4126426 2069736 2069736 defendant Herst Thomas shoemaker 592109 592109 Herst, Thomas, of Kersey, shoemaker 3
4142841 2075671 2075671 defendant Ambrose Richard clothier 592109 592109 Ambrose, Richard, of Kersey, clothier 1
4142842 2075671 2075671 defendant Ambrose Robert sherman 592109 592109 Ambrose, Robert, of Kersey, sherman 2
4151775 2078738 2078738 defendant Potter Robert husbandman 592109 592109 Potter, Robert, of Kersey, husbandman 0
4167220 2084037 2084037 defendant Turnor Richard yeoman 592109 592109 Turnor, Richard, of Kersey, or of Lynsy, yeoman 0
4167319 2084068 2084068 defendant Skeete Robert husbandman 592109 592109 Skeete, Robert, of Kersey, husbandman 3
4171951 2085652 2085652 defendant Gooche Simon yeoman 592109 592109 Gooche, Simon, of Kersey, yeoman 0
4200003 2095551 2095551 defendant Gooche Simon yeoman 592109 592109 Gooche, Simon, of Kersey, yeoman 0
4201075 2095929 2095929 defendant Skeete Robert husbandman 592109 592109 Skeete, Robert, of Kersey, husbandman 0
4207992 2098354 2098354 defendant Gooche Simon yeoman 592109 592109 Gooche, Simon, of Kersey, yeoman 1
4213142 2100121 2100121 defendant Gooche Simon yeoman 592109 592109 Gooche, Simon, of Kersey, yeoman 0
4235141 2107849 2107849 defendant Heyward John husbandman 592109 592109 Heyward, John, of Kersey, husbandman 1
4269579 2119415 2119415 defendant Tomson William husbandman 592109 592109 Tomson, William, of Kersey, husbandman 0
4269580 2119415 2119415 defendant Honnes or Hounes William husbandman 592109 592109 Honnes or Hounes, William, of Kersey, husbandman 1
4285920 2125019 2125019 defendant Man Robert yeoman 592109 592109 Man, Robert, of Kersey, yeoman 0
4290162 2126549 2126549 defendant Cooke Edmund, junior clothier 592109 592109 Cooke, Edmund, junior, of Kersey, clothier 0
4332216 2141070 2141070 defendant Rowe Giles butcher 592109 592109 Rowe, Giles, of Kersey, butcher 0
4332217 2141070 2141070 defendant Heyward John husbandman 592109 592109 Heyward, John, of Kersey, husbandman 1
4354041 2148640 2148640 defendant Forthe Israel gent 592109 592109 Forthe, Israel, of Kersey, gent 1
4382957 2159015 2159015 defendant Cooke Edmund, senior clothier 592109 592109 Cooke, Edmund, senior, of Kersey, clothier 0
4384268 2159432 2159432 defendant Johnson William shoemaker 592109 592109 Johnson, William, of Kersey, shoemaker 0
4390293 2161376 2161376 defendant Geymer Thomas yeoman 592109 592109 Geymer, Thomas, of Kersey, yeoman 1
4392172 2162005 2162005 defendant Cadge James   592109 592109 Cadge, James, of Kersey, woollen draper 2
4400229 2164668 2164668 defendant Bryce Edmund tailor 592109 592109 Bryce, Edmund, of Kersey, tailor 0
4474801 2192790 2192790 defendant Taverner John   592109 592109 Taverner, John, of Kersey 0
4527265 2208807 2208807 defendant Noke Robert   592109 592109 Noke, Robert, of Kersey 0
4553536 2217035 2217035 defendant Bog or Bogi Thomas   592109 592109 Bog or Bogi, Thomas, of Kersey 0
4562222 2219753 2219753 plaintiff Polsted John   592109 592109 Polsted, John, of Kersey, prior 0
4565064 2220643 2220643 defendant Pyry William   592109 592109 Pyry, William, of Kersey 0
4570490 2222344 2222344 defendant Kayby George   592109 592109 Kayby, George, of Kersey 1
4570836 2222447 2222447 defendant Pyrye William   592109 592109 Pyrye, William, of Kersey 0
4570837 2222447 2222447 defendant Taillour Adam   592109 592109 Taillour, Adam, of Kersey 1
4571716 2222733 2222733 defendant Arnald John   592109 592109 Arnald, John, of Kersey 0
4571717 2222733 2222733 defendant Jakelot Richard   592109 592109 Jakelot, Richard, of Kersey 1
4571719 2222734 2222734 defendant Arnald John   592109 592109 Arnald, John, of Kersey 0
4571720 2222734 2222734 defendant Jakelot Richard   592109 592109 Jakelot, Richard, of Kersey 1
4594864 2229647 2229647 defendant Parker John   592109 592109 Parker, John, of Kersey 4
4597086 2230332 2230332 defendant Garlond John   592109 592109 Garlond, John, of Kersey 0
4604952 2232710 2232710 defendant Godwene William   592109 592109 Godwene, William, of Kersey 2
4614657 2235595 2235595 defendant Basset John fuller 592109 592109 Basset, John, of Kersey, fuller 0
4619337 2237041 2237041 defendant Arnold John   592109 592109 Arnold, John, of Kersey 4
4619339 2237041 2237041 defendant Wryght John   592109 592109 Wryght, John, of Kersey 6
4634920 2241766 2241766 defendant Boudener John   592109 592109 Boudener, John, of Kersey 0
4642175 2243825 2243825 defendant Arnold John   592109 592109 Arnold, John, of Kersey 0
4642876 2244026 2244026 defendant Arnold John   592109 592109 Arnold, John, of Kersey 3
4642878 2244026 2244026 defendant Wryghte John   592109 592109 Wryghte, John, of Kersey 5
4647937 2245465 2245465 defendant Calye James   592109 592109 Calye, James, of Kersey 2
4651471 2246462 2246462 defendant Alcote William weaver 592109 592109 Alcote, William, of Kersey, weaver 5
4654691 2247343 2247343 defendant Wryghte John yeoman 592109 592109 Wryghte, John, of Kersey, yeoman 0
4661214 2249331 2249331 defendant Polstede John weaver 592109 592109 Polstede, John, of Kersey, weaver 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);