names

133 rows where place_id = 587236

✎ 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
3590867 1864775 1864775 defendant Bygge Edward yeoman 587236 587236 Bygge, Edward, of Daventry, Nhants, yeoman 0
3647801 1909706 1909706 defendant Nundy Nicholas chapman 587236 587236 Nundy, Nicholas, of Daventry, Nhants, chapman 3
3783405 1952559 1952559 defendant Pewcoke John chapman 587236 587236 Pewcoke, John, of Daventry, Nhants, chapman 1
3808934 1960673 1960673 defendant Pell Edward draper 587236 587236 Pell, Edward, of Daventry, Nhants, draper 0
3814128 1962322 1962322 defendant Blysse John chapman 587236 587236 Blysse, John, of Daventry, Nhants, chapman 0
3934448 2001815 2001815 defendant Stalworth Edward draper 587236 587236 Stalworth, Edward, of Daventry, Nhants, draper 2
3952937 2008097 2008097 defendant Batman John yeoman 587236 587236 Batman, John, of Daventry, Nhants, yeoman 0
3962260 2011381 2011381 defendant Smalbon Richard glover 587236 587236 Smalbon, Richard, of Daventry, Nhants, glover 0
3983771 2018971 2018971 defendant Symes John innholder 587236 587236 Symes, John, of Daventry, Nhants, innholder 0
3998942 2024379 2024379 defendant Hallywell William chapman 587236 587236 Hallywell, William, of Daventry, Nhants, chapman 0
4006451 2027085 2027085 defendant Mounford Richard husbandman 587236 587236 Mounford, Richard, of Daventry, Nhants, husbandman 0
4012498 2029191 2029191 defendant Wrighte Henry chapman 587236 587236 Wrighte, Henry, of Daventry, Nhants, chapman 1
4031415 2035905 2035905 defendant Wright Richard husbandman 587236 587236 Wright, Richard, of Daventry, Nhants, husbandman 3
4034090 2036853 2036853 defendant Symes John yeoman 587236 587236 Symes, John, of Daventry, Nhants, yeoman 0
4034092 2036854 2036854 defendant Symes John yeoman 587236 587236 Symes, John, of Daventry, Nhants, yeoman 0
4034639 2037066 2037066 defendant Symes John innholder 587236 587236 Symes, John, of Daventry, Nhants, innholder 0
4034643 2037068 2037068 defendant Syms John innholder 587236 587236 Syms, John, of Daventry, Nhants, innholder 0
4045078 2040693 2040693 defendant Smalbone Richard glover 587236 587236 Smalbone, Richard, of Daventry, Nhants, glover 0
4051926 2043108 2043108 defendant Wrighte Henry chapman 587236 587236 Wrighte, Henry, of Daventry, Nhants, chapman 2
4061105 2046380 2046380 defendant Blysse henry chapman 587236 587236 Blysse, henry, of Daventry, Nhants, chapman 0
4081500 2053693 2053693 defendant Holywell William chapman 587236 587236 Holywell, William, of Daventry, Nhants, chapman 0
4097693 2059504 2059504 defendant Jesson John yeoman 587236 587236 Jesson, John, of Daventry, Nhants, yeoman 0
4110579 2064043 2064043 defendant Wawmonde Edward poulter 587236 587236 Wawmonde, Edward, of Daventry, Nhants, poulter 0
4119608 2067300 2067300 defendant Farmer William   587236 587236 Farmer, William, of Daventry, Nhants, linen draper 0
4153651 2079370 2079370 defendant Roydon Edmund   587236 587236 Roydon, Edmund, of Daventry, Nhants, or of Coventry, physician 0
4156528 2080359 2080359 defendant Simes John gent 587236 587236 Simes, John, of Daventry, Nhants, gent 0
4156530 2080360 2080360 defendant Simes John gent 587236 587236 Simes, John, of Daventry, Nhants, gent 0
4177593 2087638 2087638 defendant Farmer William chapman 587236 587236 Farmer, William, of Daventry, Nhants, chapman 2
4189467 2091812 2091812 defendant Waterhowse Charles gent 587236 587236 Waterhowse, Charles, of Daventry, Nhants, gent 0
4191031 2092427 2092427 defendant Farmer William   587236 587236 Farmer, William, of Daventry, Nhants, linen draper 0
4191043 2092432 2092432 defendant Smythe Henry   587236 587236 Smythe, Henry, of Daventry, Nhants, linen draper 0
4196552 2094340 2094340 defendant Symes John gent 587236 587236 Symes, John, of Daventry, Nhants, gent 2
4202190 2096309 2096309 defendant Parkes Richard chapman 587236 587236 Parkes, Richard, of Daventry, Nhants, chapman 3
4216360 2101214 2101214 defendant Potkyn Thomas gent 587236 587236 Potkyn, Thomas, of Daventry, Nhants, gent 0
4216362 2101215 2101215 defendant Potkyn Thomas gent 587236 587236 Potkyn, Thomas, of Daventry, Nhants, gent 0
4236633 2108386 2108386 defendant Neale John gent 587236 587236 Neale, John, of Daventry, Nhants, gent 0
4251634 2113529 2113529 defendant Neale John chapman 587236 587236 Neale, John, of Daventry, Nhants, chapman 1
4265478 2118091 2118091 defendant Neale John chapman 587236 587236 Neale, John, of Daventry, Nhants, chapman 1
4272398 2120344 2120344 plaintiff Symes John gent 587236 587236 Symes, John, of Daventry, Nhants, gent 0
4282732 2123865 2123865 defendant Jennyes Thomas ironmonger 587236 587236 Jennyes, Thomas, of Daventry, Nhants, ironmonger 0
4295515 2128480 2128480 defendant Awbery Mathew yeoman 587236 587236 (Awbery, Mathew, of Daventry, Nhants, yeoman 1
4301913 2130793 2130793 defendant Smythe Richard merchant 587236 587236 Smythe, Richard, of Daventry, Nhants, merchant 1
4326733 2139295 2139295 defendant Shukeburgh Thomas gent 587236 587236 Shukeburgh, Thomas, of Daventry, Nhants, gent 1
4373279 2155511 2155511 defendant Farmer William mercer 587236 587236 Farmer, William, of Daventry, Nhants, mercer 0
4396791 2163494 2163494 defendant Makepeace Thomas chapman 587236 587236 Makepeace, Thomas, of Daventry, Nhants, chapman 0
4401976 2165254 2165254 defendant Moore Thomas chapman 587236 587236 Moore, Thomas, of Daventry, Nhants, chapman 3
4704011 2266633 2266633 defendant Akon Thomas husbandman 587236 587236 Akon, Thomas, of Daventry, Nhants, husbandman 0
4706893 2267536 2267536 defendant Cleydon Hugh husbandman 587236 587236 Cleydon, Hugh, of Daventry, Nhants, husbandman 0
4741362 2277971 2277971 defendant Dyllyng John butcher 587236 587236 Dyllyng, John, of Daventry, Nhants, butcher 0
4743769 2278706 2278706 defendant Akun Thomas husbandman 587236 587236 Akun, Thomas, of Daventry, Nhants, husbandman 0
4748124 2279962 2279962 defendant Dyllyng John butcher 587236 587236 Dyllyng, John, of Daventry, Nhants, butcher 0
4770092 2286616 2286616 defendant Akun or Akim Thomas husbandman 587236 587236 Akun or Akim, Thomas, of Daventry, Nhants, husbandman 0
4774861 2288131 2288131 defendant Heywode John gent 587236 587236 Heywode, John, of Daventry, Nhants, gent 0
4790116 2292987 2292987 defendant Sergeant Robert smith 587236 587236 Sergeant, Robert, of Daventry, Nhants, smith 0
4809967 2299277 2299277 defendant Bruys Henry fisher 587236 587236 Bruys, Henry, of Daventry, Nhants, fisher 4
4817060 2301433 2301433 defendant Claydon Hugh yeoman 587236 587236 Claydon, Hugh, of Daventry, Nhants, yeoman 2
4847686 2310770 2310770 defendant Horn Simon husbandman 587236 587236 Horn, Simon, of Daventry, Nhants, husbandman 0
4850193 2311523 2311523 defendant Curtes John chapman 587236 587236 Curtes, John, of Daventry, Nhants, chapman 0
4852523 2312213 2312213 defendant Newell William   587236 587236 Newell, William, of Daventry, Nhants, spice seller 1
4852564 2312224 2312224 defendant Newell William   587236 587236 Newell, William, of Daventry, Nhants, spice man 1
4853469 2312494 2312494 defendant Haywode John   587236 587236 (Haywode, John, of Daventry, Nhants, burgess 2
4858466 2314020 2314020 defendant Nowell William chapman 587236 587236 Nowell, William, of Daventry, Nhants, chapman 1
4860167 2314541 2314541 defendant West Edmund gent 587236 587236 West, Edmund, of Daventry, Nhants, gent 0
4863659 2315605 2315605 defendant Brewes Henry fisher 587236 587236 Brewes, Henry, of Daventry, Nhants, fisher 2
4876661 2319671 2319671 defendant Starton John yeoman 587236 587236 Starton, John, of Daventry, Nhants, yeoman 1
4905174 2328216 2328216 defendant Cleydon Hugh husbandman 587236 587236 (Cleydon, Hugh, of Daventry, Nhants, husbandman 1
4912298 2330346 2330346 defendant Malore Thomas gent 587236 587236 (Malore, Thomas, of Daventry, Nhants, gent 2
4954788 2343389 2343389 defendant Fyppe Thomas husbandman 587236 587236 Fyppe, Thomas, of Daventry, Nhants, husbandman 1
4997823 2356205 2356205 defendant Scotour Richard butcher 587236 587236 Scotour, Richard, of Daventry, Nhants, butcher 0
4999710 2356792 2356792 defendant Horne John gent 587236 587236 Horne, John, of Daventry, Nhants, gent 0
4999714 2356793 2356793 defendant Horne John gent 587236 587236 Horne, John, of Daventry, Nhants, gent 0
5002932 2357762 2357762 defendant Chapeleyn Richard chapman 587236 587236 Chapeleyn, Richard, of Daventry, Nhants, chapman 2
5008052 2359242 2359242 defendant Barker John gent 587236 587236 Barker, John, of Daventry, Nhants, gent 4
5011495 2360228 2360228 defendant Mydewell William gent 587236 587236 Mydewell, William, of Daventry, Nhants, gent 0
5011501 2360229 2360229 defendant West Nicholas gent 587236 587236 West, Nicholas, of Daventry, Nhants, gent 0
5012226 2360425 2360425 defendant Venys Robert chapman 587236 587236 Venys, Robert, of Daventry, Nhants, chapman 0
5034835 2367043 2367043 defendant Brewes Henry fisher 587236 587236 Brewes, Henry, of Daventry, Nhants, fisher 2
5034846 2367046 2367046 defendant Brewes Henry fisher 587236 587236 Brewes, Henry, of Daventry, Nhants, fisher 2
5040857 2368882 2368882 defendant Deesse John skinner 587236 587236 Deesse, John, of Daventry, Nhants, skinner 4
5051845 2372167 2372167 defendant Baker John gent 587236 587236 Baker, John, of Daventry, Nhants, gent 0
5051847 2372168 2372168 defendant Baker John gent 587236 587236 Baker, John, of Daventry, Nhants, gent 0
5069415 2377348 2377348 defendant Barkere John gent 587236 587236 Barkere, John, of Daventry, Nhants, gent 0
5077216 2379689 2379689 defendant Horne John esq 587236 587236 Horne, John, of Daventry, Nhants, esq 0
5092748 2384260 2384260 defendant Marche Thomas   587236 587236 Marche, Thomas, of Daventry, Nhants, franklin 1
5093874 2384609 2384609 defendant Barkere John gent 587236 587236 Barkere, John, of Daventry, Nhants, gent 3
5099286 2386219 2386219 defendant Barker John gent 587236 587236 Barker, John, of Daventry, Nhants, gent 0
5099288 2386220 2386220 defendant Barker John gent 587236 587236 Barker, John, of Daventry, Nhants, gent 0
5099290 2386221 2386221 defendant Barker John gent 587236 587236 Barker, John, of Daventry, Nhants, gent 0
5100083 2386462 2386462 defendant Barker John gent 587236 587236 Barker, John, of Daventry, Nhants, gent 1
5100087 2386463 2386463 defendant Barker John gent 587236 587236 Barker, John, of Daventry, Nhants, gent 1
5107498 2388623 2388623 defendant Chapman John chapman 587236 587236 Chapman, John, of Daventry, Nhants, chapman 1
5127456 2394505 2394505 defendant Barker Joan widow 587236 587236 Barker, Joan, of Daventry, Nhants, widow 1
5143186 2399143 2399143 defendant Barker Joan widow 587236 587236 Barker, Joan, of Daventry, Nhants, widow 0
5143192 2399144 2399144 defendant Barker Joan widow 587236 587236 Barker, Joan, of Daventry, Nhants, widow 0
5146310 2400050 2400050 defendant Barker Joan widow 587236 587236 Barker, Joan, of Daventry, Nhants, widow 2
5149239 2400909 2400909 defendant Pryke William chapman 587236 587236 Pryke, William, of Daventry, Nhants, chapman 0
5149241 2400910 2400910 defendant Pryke William chapman 587236 587236 Pryke, William, of Daventry, Nhants, chapman 0
5163298 2405000 2405000 defendant Nowell William spicer 587236 587236 Nowell, William, of Daventry, Nhants, spicer 1
5164543 2405363 2405363 defendant Barker Joan widow 587236 587236 Barker, Joan, of Daventry, Nhants, widow 0
5165382 2405623 2405623 plaintiff Bery Richard yeoman 587236 587236 Bery, Richard, of Daventry, Nhants, yeoman 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);