names

144 rows where place_id = 587025

✎ 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
3590283 1864605 1864605 defendant Ashby alias Mychell Richard husbandman 587025 587025 Ashby alias Mychell, Richard, of Houghton, husbandman 0
3603662 1868813 1868813 defendant Fyske Richard husbandman 587025 587025 Fyske, Richard, of Houghton, husbandman 5
3605265 1869314 1869314 defendant Cokkys John, senior husbandman 587025 587025 Cokkys, John, senior, of Houghton, husbandman 0
3605266 1869314 1869314 defendant Cokkys Stephen husbandman 587025 587025 Cokkys, Stephen, of Houghton, husbandman 1
3605267 1869314 1869314 defendant Cokkys John, junior husbandman 587025 587025 Cokkys, John, junior, of Houghton, husbandman 2
3605272 1869315 1869315 defendant Cokkys Joan widow 587025 587025 Cokkys, Joan, of Houghton, widow 2
3611040 1871131 1871131 defendant Antony John yeoman 587025 587025 Antony, John, of Houghton, yeoman 0
3612973 1871705 1871705 defendant Mawedes Thomas husbandman 587025 587025 Mawedes, Thomas, of Houghton, husbandman 2
3619071 1873566 1873566 defendant Graunt John husbandman 587025 587025 Graunt, John, of Houghton, husbandman 1
3655330 1911925 1911925 defendant Feld Walter husbandman 587025 587025 Feld, Walter, of Houghton, husbandman 2
3670607 1916770 1916770 defendant Barber Roger husbandman 587025 587025 Barber, Roger, of Houghton, husbandman 0
3691087 1923374 1923374 defendant Cheyny Thomas gent 587025 587025 Cheyny, Thomas, of Houghton, gent 0
3691089 1923375 1923375 defendant Cheyny Thomas gent 587025 587025 Cheyny, Thomas, of Houghton, gent 0
3712041 1930086 1930086 defendant Walpole Edward gent 587025 587025 Walpole, Edward, of Houghton, gent 0
3713183 1930429 1930429 defendant Ranson or Rauson Robert yeoman 587025 587025 Ranson or Rauson, Robert, of Houghton, yeoman 2
3728587 1935186 1935186 defendant Rawson Robert yeoman 587025 587025 Rawson, Robert, of Houghton, yeoman 1
3729075 1935344 1935344 defendant Ramshawe Thomas miller 587025 587025 Ramshawe, Thomas, of Houghton, miller 3
3729080 1935345 1935345 defendant Ramshawe Thomas miller 587025 587025 Ramshawe, Thomas, of Houghton, miller 3
3729334 1935428 1935428 defendant Melborne William yeoman 587025 587025 Melborne, William, of Houghton, yeoman 0
3731884 1936203 1936203 defendant Palgrave John husbandman 587025 587025 Palgrave, John, of Houghton, husbandman 0
3732678 1936451 1936451 defendant Cheyney Thomas gent 587025 587025 Cheyney, Thomas, of Houghton, gent 0
3742893 1939633 1939633 defendant Walpole Edward gent 587025 587025 Walpole, Edward, of Houghton, gent 0
3746823 1940926 1940926 defendant Cheyne Thomas gent 587025 587025 Cheyne, Thomas, of Houghton, gent 0
3750698 1942143 1942143 defendant Ingram Robert butcher 587025 587025 Ingram, Robert, of Houghton, butcher 1
3752218 1942619 1942619 defendant Taillour Robert yeoman 587025 587025 Taillour, Robert, of Houghton, yeoman 0
3752219 1942619 1942619 defendant Taillour John laborer 587025 587025 Taillour, John, of Houghton, laborer 1
3752220 1942619 1942619 defendant Sutton William laborer 587025 587025 Sutton, William, of Houghton, laborer 2
3752221 1942619 1942619 defendant Sutton Thomas laborer 587025 587025 Sutton, Thomas, of Houghton, laborer 3
3752222 1942619 1942619 defendant Toll William laborer 587025 587025 Toll, William, of Houghton, laborer 4
3755744 1943758 1943758 defendant Melborne Thomas husbandman 587025 587025 Melborne, Thomas, of Houghton, husbandman 2
3760259 1945211 1945211 defendant Fuller Robert husbandman 587025 587025 Fuller, Robert, of Houghton, husbandman 1
3766474 1947171 1947171 defendant Sykman John husbandman 587025 587025 Sykman, John, of Houghton, husbandman 2
3777382 1950671 1950671 defendant Melborne Thomas husbandman 587025 587025 Melborne, Thomas, of Houghton, husbandman 0
3777384 1950671 1950671 defendant Barenger Thomas husbandman 587025 587025 Barenger, Thomas, of Houghton, husbandman 2
3778083 1950857 1950857 defendant Pruse John yeoman 587025 587025 Pruse, John, of Houghton, yeoman 0
3780627 1951669 1951669 defendant Lowe Thomas husbandman 587025 587025 Lowe, Thomas, of Houghton, husbandman 0
3781932 1952098 1952098 defendant Walpole Edward gent 587025 587025 Walpole, Edward, of Houghton, gent 0
3786440 1953549 1953549 defendant Clerke John husbandman 587025 587025 Clerke, John, of Houghton, husbandman 1
3810411 1961147 1961147 defendant Walpole Edward gent 587025 587025 Walpole, Edward, of Houghton, gent 0
3826750 1966218 1966218 defendant Graunt Robert husbandman 587025 587025 Graunt, Robert, of Houghton, husbandman 0
3826752 1966219 1966219 defendant Graunt Alice widow 587025 587025 Graunt, Alice, of Houghton, widow 0
3837797 1969735 1969735 plaintiff Stoner John   587025 587025 Stoner, John, of Houghton 0
3839286 1970216 1970216 defendant Tayler Morgan husbandman 587025 587025 Tayler, Morgan, of Houghton, husbandman 1
3865638 1978727 1978727 defendant Nokys John yeoman 587025 587025 Nokys, John, of Houghton, yeoman 0
3876241 1982296 1982296 defendant Courtman Thomas limeburner 587025 587025 Courtman, Thomas, of Houghton, limeburner 2
3893006 1987905 1987905 defendant Yongys William husbandman 587025 587025 Yongys, William, of Houghton, husbandman 0
3906886 1992590 1992590 defendant Meddley Robert yeoman 587025 587025 Meddley, Robert, of Houghton, yeoman 3
3906936 1992608 1992608 defendant Walpole Edward gent 587025 587025 Walpole, Edward, of Houghton, gent 0
3933954 2001656 2001656 defendant Hegley John husbandman 587025 587025 Hegley, John, of Houghton, husbandman 0
3942984 2004660 2004660 defendant Prestall Margaret widow 587025 587025 Prestall, Margaret, of Houghton, widow 1
3956800 2009448 2009448 defendant Rede Francis gent 587025 587025 Rede, Francis, of Houghton, gent 0
3967577 2013292 2013292 defendant Flemyng Robert husbandman 587025 587025 Flemyng, Robert, of Houghton, husbandman 0
4067243 2048582 2048582 defendant Dyneley Arthur gent 587025 587025 Dyneley, Arthur, of Houghton, gent 0
4067245 2048583 2048583 defendant Dyneley Arthur gent 587025 587025 Dyneley, Arthur, of Houghton, gent 0
4069946 2049534 2049534 defendant Tooley Thomas husbandman 587025 587025 Tooley, Thomas, of Houghton, husbandman 0
4075680 2051606 2051606 defendant Oldinge Robert smith 587025 587025 Oldinge, Robert, of Houghton, smith 0
4075682 2051606 2051606 defendant Lynney Thomas husbandman 587025 587025 Lynney, Thomas, of Houghton, husbandman 2
4125595 2069438 2069438 defendant Carter Thomas laborer 587025 587025 Carter, Thomas, of Houghton, laborer 1
4163323 2082700 2082700 defendant Well Humphrey husbandman 587025 587025 Well, Humphrey, of Houghton, husbandman 0
4193158 2093176 2093176 defendant Watson William shoemaker 587025 587025 Watson, William, of Houghton, shoemaker 1
4252705 2113891 2113891 defendant Durant Richard yeoman 587025 587025 Durant, Richard, of Houghton, yeoman 0
4260121 2116349 2116349 defendant Sandeford George yeoman 587025 587025 Sandeford, George, of Houghton, miller, yeoman 0
4261307 2116748 2116748 defendant Fenn Nicholas yeoman 587025 587025 Fenn, Nicholas, of Houghton, or of Houlton juxta Walsingham, yeoman 1
4262719 2117200 2117200 defendant Marschall William yeoman 587025 587025 Marschall, William, of Houghton, yeoman 0
4294053 2127951 2127951 defendant Reason Robert yeoman 587025 587025 Reason, Robert, of Houghton, yeoman 1
4306414 2132384 2132384 defendant Gyrney Henry husbandman 587025 587025 Gyrney, Henry, of Houghton, husbandman 2
4306424 2132387 2132387 defendant Gurney Henry husbandman 587025 587025 Gurney, Henry, of Houghton, husbandman 2
4326748 2139300 2139300 defendant Durante Robert   587025 587025 Durante, Robert, of Houghton, yeoman, his son 1
4328926 2139987 2139987 defendant Brooke John yeoman 587025 587025 Brooke, John, of Houghton, yeoman 1
4380488 2158134 2158134 defendant Nelson Richard husbandman 587025 587025 Nelson, Richard, of Houghton, husbandman 0
4395888 2163202 2163202 defendant Nelson John yeoman 587025 587025 Nelson, John, of Houghton, yeoman 2
4412738 2168853 2168853 defendant Gaye John, junior limeburner 587025 587025 Gaye, John, junior, of Houghton, limeburner 1
4415086 2169619 2169619 plaintiff Geffrey John   587025 587025 Geffrey, John, of Houghton 0
4436583 2176179 2176179 defendant Brentynghby Simon de   587025 587025 Brentynghby, Simon de, of Houghton, parson 1
4436587 2176179 2176179 defendant Adekyn Roger   587025 587025 Adekyn, Roger, of Houghton 5
4436776 2176243 2176243 plaintiff Styword Peter   587025 587025 Styword, Peter, of Houghton 0
4461389 2188645 2188645 defendant Apthorp Philip   587025 587025 with Apthorp, Philip, of Houghton, parson 1
4461393 2188646 2188646 defendant Apthorp Philip   587025 587025 Apthorp, Philip, of Houghton, parson 1
4461397 2188647 2188647 defendant Apthorp Phlip   587025 587025 Apthorp, Phlip, of Houghton, parson 1
4489156 2197325 2197325 defendant Smyth John   587025 587025 Smyth, John, of Houghton 1
4509557 2203461 2203461 defendant Baillyf Thomas   587025 587025 Baillyf, Thomas, of Houghton 1
4530637 2209877 2209877 defendant Somnour Michael   587025 587025 Somnour, Michael, of Houghton 0
4576142 2224040 2224040 defendant Kytewyne Richard   587025 587025 Kytewyne, Richard, of Houghton 0
4576587 2224188 2224188 defendant Vance Henry milner 587025 587025 Vance, Henry, of Houghton, milner 0
4594876 2229651 2229651 plaintiff Purchas Joan   587025 587025 Purchas, Joan, of Houghton 0
4633265 2241275 2241275 plaintiff Warrewyk John   587025 587025 Warrewyk, John, of Houghton 0
4643360 2244163 2244163 defendant Couper William   587025 587025 Couper, William, of Houghton 0
4667022 2255418 2255418 defendant Barker John yeoman 587025 587025 Barker, John, of Houghton, yeoman 0
4667023 2255418 2255418 defendant Purse Thomas butcher 587025 587025 Purse, Thomas, of Houghton, butcher 1
4667024 2255418 2255418 defendant Andrewe William husbandman 587025 587025 Andrewe, William, of Houghton, husbandman 2
4667025 2255418 2255418 defendant atte Chirche Margaret widow 587025 587025 atte Chirche, Margaret, of Houghton, widow 3
4703298 2266408 2266408 defendant Petyt Richard husbandman 587025 587025 Petyt, Richard, of Houghton, husbandman 0
4705887 2267218 2267218 defendant Faryndon John husbandman 587025 587025 Faryndon, John, of Houghton, husbandman 0
4746428 2279449 2279449 defendant Assheby William gent 587025 587025 Assheby, William, of Houghton, gent 0
4755338 2282061 2282061 plaintiff atte Noke William   587025 587025 atte Noke, William, of Houghton 0
4764029 2284737 2284737 defendant Frenssh John husbandman 587025 587025 Frenssh, John, of Houghton, husbandman 0
4764449 2284867 2284867 defendant Assheby William gent 587025 587025 Assheby, William, of Houghton, gent 0
4785296 2291418 2291418 defendant Fullere William fuller 587025 587025 Fullere, William, of Houghton, fuller 3
4805648 2297975 2297975 defendant Doughty John husbandman 587025 587025 Doughty, John, of Houghton, husbandman 0
4809208 2299054 2299054 defendant Pecche John   587025 587025 Pecche, John, of Houghton, mason 6

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