names

164 rows where place_id = 587283

✎ 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
3590988 1864806 1864806 defendant Cotys Thomas esq 587283 587283 Cotys, Thomas, of Honyngham, esq 0
3594121 1865803 1865803 defendant Doget William gent 587283 587283 Doget, William, of Honyngham, gent 0
3595805 1866322 1866322 defendant Curteys John, junior husbandman 587283 587283 Curteys, John, junior, of Honyngham, husbandman 1
3603422 1868739 1868739 defendant Estwyk William miller 587283 587283 Estwyk, William, of Honyngham, miller 11
3609320 1870574 1870574 defendant Whitby Stephen esq 587283 587283 Whitby, Stephen, of Honyngham, esq 0
3629361 1904043 1904043 defendant Blakeney John gent 587283 587283 Blakeney, John, of Honyngham, gent 0
3629362 1904043 1904043 defendant Hille Robert yeoman 587283 587283 Hille, Robert, of Honyngham, yeoman 1
3629363 1904043 1904043 defendant Haille Richard yeoman 587283 587283 Haille, Richard, of Honyngham, yeoman 2
3629364 1904043 1904043 defendant Illyngworth Robert yeoman 587283 587283 Illyngworth, Robert, of Honyngham, yeoman 3
3629365 1904043 1904043 defendant Amys William laborer 587283 587283 Amys, William, of Honyngham, laborer 4
3629366 1904043 1904043 defendant Camplyn Thomas laborer 587283 587283 Camplyn, Thomas, of Honyngham, laborer 5
3629367 1904043 1904043 defendant Calie William laborer 587283 587283 Calie, William, of Honyngham, laborer 6
3629368 1904043 1904043 defendant Neve John laborer 587283 587283 Neve, John, of Honyngham, laborer 7
3633719 1905355 1905355 defendant Dogett Edmund gent 587283 587283 Dogett, Edmund, of Honyngham, gent 1
3653748 1911433 1911433 defendant Campyon Thomas laborer 587283 587283 Campyon, Thomas, of Honyngham, laborer 2
3669029 1916244 1916244 defendant Chapman John husbandman 587283 587283 Chapman, John, of Honyngham, husbandman 0
3684207 1921196 1921196 defendant Dogett Edmund gent 587283 587283 Dogett, Edmund, of Honyngham, gent 0
3711962 1930057 1930057 plaintiff Vyncent Richard   587283 587283 Vyncent, Richard, of Honyngham 0
3728533 1935174 1935174 defendant Dogett Edmund gent 587283 587283 Dogett, Edmund, of Honyngham, gent 0
3728534 1935174 1935174 defendant Sharpyn William husbandman 587283 587283 Sharpyn, William, of Honyngham, husbandman 1
3755764 1943762 1943762 defendant Doget Edward gent 587283 587283 Doget, Edward, of Honyngham, gent 0
3765672 1946929 1946929 defendant Dorman Alexander yeoman 587283 587283 Dorman, Alexander, of Honyngham, yeoman 0
3783710 1952669 1952669 defendant Dorman Alexander yeoman 587283 587283 Dorman, Alexander, of Honyngham, yeoman 2
3831659 1967798 1967798 defendant Haile John clerk 587283 587283 Haile, John, of Honyngham, clerk 5
3850803 1973845 1973845 defendant Hayle John chaplain 587283 587283 Hayle, John, of Honyngham, chaplain 2
3852098 1974252 1974252 defendant Underhyll William husbandman 587283 587283 Underhyll, William, of Honyngham, husbandman 0
3870832 1980495 1980495 defendant Hale John chaplain 587283 587283 Hale, John, of Honyngham, chaplain 1
3873638 1981398 1981398 defendant Jaye Nicholas husbandman 587283 587283 Jaye, Nicholas, of Honyngham, husbandman 1
3873639 1981398 1981398 defendant Dogett Edmund gent 587283 587283 Dogett, Edmund, of Honyngham, gent 2
3881838 1984178 1984178 defendant Godfrey John tailor 587283 587283 Godfrey, John, of Honyngham, tailor 1
3906616 1992507 1992507 plaintiff Methwold Richard gent 587283 587283 Methwold, Richard, of Honyngham, gent 0
3910982 1993998 1993998 plaintiff Vyncent Richard   587283 587283 Vyncent, Richard, of Honyngham 0
3910983 1993998 1993998 defendant Andrewes alias Robarde John husbandman 587283 587283 Andrewes alias Robarde, John, of Honyngham, husbandman 0
3917750 1996292 1996292 plaintiff Vyncent Thomas butcher 587283 587283 Vyncent, Thomas, of Honyngham, butcher 1
3924764 1998600 1998600 defendant Detill Henry yeoman 587283 587283 Detill, Henry, of Honyngham, yeoman 2
3924765 1998600 1998600 defendant Estwik Edmund yeoman 587283 587283 Estwik, Edmund, of Honyngham, yeoman 3
3973612 2015342 2015342 defendant Savage William yeoman 587283 587283 Savage, William, of Honyngham, yeoman 0
3973613 2015342 2015342 defendant Brygg John yeoman 587283 587283 Brygg, John, of Honyngham, yeoman 1
4002398 2025635 2025635 defendant Davyson John miller 587283 587283 Davyson, John, of Honyngham, miller 0
4014996 2030072 2030072 defendant Spencer Henry gent 587283 587283 Spencer, Henry, of Honyngham, gent 4
4018314 2031278 2031278 defendant Marshall Cuthbert yeoman 587283 587283 Marshall, Cuthbert, of Honyngham, yeoman 0
4048135 2041769 2041769 defendant Marshall Cuthbert yeoman 587283 587283 Marshall, Cuthbert, of Honyngham, yeoman 0
4092575 2057651 2057651 defendant Crickmere Robert baker 587283 587283 Crickmere, Robert, of Honyngham, baker 2
4202281 2096339 2096339 defendant Westgate Robert yeoman 587283 587283 Westgate, Robert, of Honyngham, yeoman 0
4207154 2098047 2098047 defendant Westgate Robert husbandman 587283 587283 Westgate, Robert, of Honyngham, husbandman 0
4265031 2117939 2117939 defendant Hawes Thomas laborer 587283 587283 Hawes, Thomas, of Honyngham, laborer 0
4281713 2123508 2123508 defendant Westgate William yeoman 587283 587283 Westgate, William, of Honyngham, yeoman 0
4290833 2126778 2126778 defendant Spenser Henry gent 587283 587283 Spenser, Henry, of Honyngham, gent 2
4332913 2141291 2141291 defendant Phipers John husbandman 587283 587283 Phipers, John, of Honyngham, husbandman 1
4386969 2160299 2160299 defendant Spencer Henry gent 587283 587283 Spencer, Henry, of Honyngham, gent 1
4486203 2196389 2196389 defendant Semere John   587283 587283 Semere, John, of Honyngham 0
4498109 2200061 2200061 defendant Baude William smith 587283 587283 Baude, William, of Honyngham, smith 0
4529925 2209649 2209649 defendant Horn Richard   587283 587283 Horn,Richard, of Honyngham 2
4533821 2210845 2210845 plaintiff Rous Eustace   587283 587283 Rous, Eustace, of Honyngham 0
4562396 2219799 2219799 defendant Harom John   587283 587283 Harom, John, of Honyngham 0
4580271 2225312 2225312 defendant Smyth Thomas   587283 587283 Smyth, Thomas, of Honyngham 7
4580274 2225312 2225312 defendant Lyve Robert   587283 587283 Lyve, Robert, of Honyngham 10
4585789 2226976 2226976 defendant Brandesby William   587283 587283 Brandesby, William, of Honyngham 0
4621971 2237848 2237848 defendant Alcok Robert   587283 587283 Alcok, Robert, of Honyngham 1
4630387 2240413 2240413 defendant Rous Eustace   587283 587283 Rous, Eustace, of Honyngham 0
4630389 2240414 2240414 defendant Rous Eustace   587283 587283 Rous, Eustace, of Honyngham 0
4630428 2240427 2240427 defendant Cotes John de   587283 587283 Cotes, John de, of Honyngham 0
4630797 2240522 2240522 defendant Fullere Henry   587283 587283 Fullere, Henry, of Honyngham 2
4640433 2243313 2243313 defendant Rous Eustace   587283 587283 Rous, Eustace, of Honyngham 0
4640437 2243314 2243314 defendant Rous Eustace   587283 587283 Rous, Eustace, of Honyngham 0
4654220 2247201 2247201 defendant Flesshewer John butcher 587283 587283 Flesshewer, John, of Honyngham, butcher 5
4683238 2260369 2260369 defendant Rous Eustace husbandman 587283 587283 Rous, Eustace, of Honyngham, husbandman 3
4715764 2270249 2270249 defendant Brandesby William yeoman 587283 587283 Brandesby, William, of Honyngham, yeoman 3
4724467 2272946 2272946 defendant Rows Eustace yeoman 587283 587283 Rows, Eustace, of Honyngham, yeoman 0
4730432 2274713 2274713 defendant Rous Eustace husbandman 587283 587283 Rous, Eustace, of Honyngham, husbandman 2
4735067 2276116 2276116 defendant Warde William husbandman 587283 587283 Warde, William, of Honyngham, husbandman 0
4739627 2277467 2277467 defendant Hoton Alice   587283 587283 Hoton, Alice, of Honyngham, widow, formerly wife of William 3
4752624 2281227 2281227 defendant Bacon John yeoman 587283 587283 Bacon, John, of Honyngham, yeoman 4
4761927 2284075 2284075 defendant Rowt Eustace yeoman 587283 587283 Rowt, Eustace, of Honyngham, yeoman 0
4767050 2285682 2285682 defendant Tylman Robert yeoman 587283 587283 Tylman, Robert, of Honyngham, yeoman 7
4776651 2288689 2288689 defendant Clerk Richard husbandman 587283 587283 Clerk, Richard, of Honyngham, husbandman 0
4778592 2289289 2289289 defendant Walpoll William yeoman 587283 587283 Walpoll, William, of Honyngham, yeoman 1
4778604 2289291 2289291 defendant Rous Eustace   587283 587283 Rous, Eustace, of Honyngham, franklin 0
4786162 2291710 2291710 defendant Rous Eustace husbandman 587283 587283 Rous, Eustace, of Honyngham, husbandman 0
4786168 2291711 2291711 defendant Rous Eustace husbandman 587283 587283 Rous, Eustace, of Honyngham, husbandman 0
4786434 2291803 2291803 defendant de Hoton Alice widow 587283 587283 de Hoton, Alice, of Honyngham, widow 0
4787385 2292123 2292123 defendant Clerk Richard yeoman 587283 587283 Clerk, Richard, of Honyngham, yeoman 0
4793794 2294177 2294177 defendant Rous Eustace husbandman 587283 587283 Rous, Eustace, of Honyngham, husbandman 2
4796394 2295023 2295023 defendant Rous Eustace   587283 587283 Rous, Eustace, of Honyngham, franklin 0
4801292 2296593 2296593 defendant Rous Eustace husbandman 587283 587283 Rous, Eustace, of Honyngham, husbandman 0
4803680 2297336 2297336 defendant Momtfoud John husbandman 587283 587283 Momtfoud, John, of Honyngham, husbandman 1
4806476 2298236 2298236 defendant Tilman Robert yeoman 587283 587283 Tilman, Robert, of Honyngham, yeoman 0
4807218 2298458 2298458 defendant Warmyngton William husbandman 587283 587283 Warmyngton, William, of Honyngham, husbandman 2
4818803 2301966 2301966 defendant Grout John yeoman 587283 587283 Grout, John, of Honyngham, yeoman 1
4827121 2304528 2304528 defendant Bakun John yeoman 587283 587283 Bakun, John, of Honyngham, yeoman 0
4851998 2312058 2312058 defendant Smyth Geoffrey husbandman 587283 587283 Smyth, Geoffrey, of Honyngham, husbandman 0
4851999 2312058 2312058 defendant Koo William husbandman 587283 587283 Koo, William, of Honyngham, husbandman 1
4852001 2312058 2312058 defendant Kot or Koc John husbandman 587283 587283 Kot or Koc, John, of Honyngham, husbandman 3
4891699 2324146 2324146 defendant Bakon John yeoman 587283 587283 Bakon, John, of Honyngham, yeoman 0
4897878 2325996 2325996 defendant Bakon John yeoman 587283 587283 Bakon, John, of Honyngham, yeoman 1
4900861 2326900 2326900 defendant Childe John   587283 587283 Childe, John, of Honyngham, shepherd 0
4942130 2339522 2339522 defendant Crook William husbandman 587283 587283 Crook, William, of Honyngham, husbandman 2
4942131 2339522 2339522 defendant Smyth William husbandman 587283 587283 Smyth, William, of Honyngham, husbandman 3
4962003 2345548 2345548 defendant Fedell John yeoman 587283 587283 Fedell, John, of Honyngham, yeoman 0
4966629 2346954 2346954 defendant Frampton John, senior husbandman 587283 587283 Frampton, John, senior, of Honyngham, husbandman 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);