names

98 rows where place_id = 757185

✎ 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
4443995 2183090 2183090 defendant Ropere John   757185 757185 Ropere, John, of Yevelchestre 0
4443996 2183090 2183090 defendant Ropere William   757185 757185 Ropere, William, of Yevelchestre 1
4461043 2188529 2188529 defendant Gofford William   757185 757185 Gofford, William, of Yevelchestre 0
4465667 2189937 2189937 defendant Blaunkepayn Walter   757185 757185 Blaunkepayn, Walter, of Yevelchestre 0
4477030 2193475 2193475 defendant Folky Thomas   757185 757185 Folky, Thomas, of Yevelchestre 5
4477677 2193685 2193685 defendant Brice Thomas   757185 757185 Brice, Thomas, of Yevelchestre 0
4487114 2196695 2196695 plaintiff Shephurd John   757185 757185 Shephurd, John, of Yevelchestre 0
4490382 2197695 2197695 defendant Dyere Richard   757185 757185 Dyere, Richard, of Yevelchestre 0
4491360 2197984 2197984 defendant Brice Thomas   757185 757185 Brice, Thomas, of Yevelchestre 0
4496787 2199662 2199662 defendant Boucher Walter   757185 757185 Boucher, Walter, of Yevelchestre 2
4513096 2204530 2204530 defendant Taillour John   757185 757185 Taillour, John, of Yevelchestre 0
4513097 2204530 2204530 defendant Tannere Richard   757185 757185 Tannere, Richard, of Yevelchestre 1
4513098 2204530 2204530 defendant Carpenter John   757185 757185 Carpenter, John, of Yevelchestre 2
4518876 2206269 2206269 plaintiff Drapere John   757185 757185 Drapere, John, of Yevelchestre 0
4518878 2206270 2206270 plaintiff Drapere John   757185 757185 Drapere, John, of Yevelchestre 0
4518881 2206271 2206271 plaintiff Drapere John   757185 757185 Drapere, John, of Yevelchestre 0
4525460 2208296 2208296 defendant Cole William   757185 757185 Cole, William, of Yevelchestre 4
4528815 2209295 2209295 defendant Hastynge William   757185 757185 Hastynge, William, of Yevelchestre 2
4537548 2212018 2212018 defendant Bocher Walter   757185 757185 Bocher, Walter, of Yevelchestre 0
4539650 2212660 2212660 defendant Bocher Thomas   757185 757185 Bocher, Thomas, of Yevelchestre 1
4539915 2212748 2212748 defendant Scote Joan   757185 757185 Scote, Joan, of Yevelchestre, formerly wife of William 2
4541685 2213295 2213295 defendant Dole Richard   757185 757185 Dole, Richard, of Yevelchestre 0
4543663 2213914 2213914 defendant Bryce John   757185 757185 Bryce, John, of Yevelchestre 0
4551206 2216320 2216320 plaintiff Draper John   757185 757185 Draper, John, of Yevelchestre 0
4556905 2218091 2218091 defendant Bocher William   757185 757185 Bocher, William, of Yevelchestre 2
4568947 2221873 2221873 defendant Sete Joan   757185 757185 Sete, Joan, of Yevelchestre, formerly wife of William 2
4577182 2224376 2224376 defendant Brysse John   757185 757185 Brysse, John, of Yevelchestre 0
4577186 2224378 2224378 defendant Boucher Walter   757185 757185 Boucher, Walter, of Yevelchestre 0
4580145 2225276 2225276 defendant Boucher Walter   757185 757185 Boucher, Walter, of Yevelchestre 1
4590734 2228455 2228455 defendant Shepherd John   757185 757185 Shepherd, John, of Yevelchestre 2
4598882 2230874 2230874 defendant Dorset Walter   757185 757185 Dorset, Walter, of Yevelchestre 3
4614254 2235471 2235471 plaintiff Draperre John   757185 757185 Draperre, John, of Yevelchestre 0
4621708 2237769 2237769 defendant Brys John   757185 757185 Brys, John, of Yevelchestre 3
4641457 2243599 2243599 defendant Neweton William   757185 757185 Neweton, William, of Yevelchestre 1
4653186 2246932 2246932 defendant Boucher Walter yeoman 757185 757185 Boucher, Walter, of Yevelchestre, yeoman 0
4660837 2249215 2249215 defendant Draper John clothier 757185 757185 Draper, John, of Yevelchestre, clothier 0
4666060 2250854 2250854 defendant Fowy Thomas butcher 757185 757185 Fowy, Thomas, of Yevelchestre, butcher 1
4668367 2255818 2255818 defendant Folky Thomas butcher 757185 757185 Folky, Thomas, of Yevelchestre, butcher 0
4671410 2256707 2256707 defendant Tothe Robert clerk 757185 757185 Tothe, Robert, of Yevelchestre, clerk 0
4673247 2257272 2257272 defendant Skynner John fisher 757185 757185 Skynner, John, of Yevelchestre, fisher 0
4673248 2257272 2257272 defendant Folkewey Thomas butcher 757185 757185 Folkewey, Thomas, of Yevelchestre, butcher 1
4674186 2257534 2257534 defendant Baker Thomas yeoman 757185 757185 Baker, Thomas, of Yevelchestre or Ilchester, yeoman 0
4674187 2257534 2257534 defendant Payn John laborer 757185 757185 Payn, John, of Yevelchestre, laborer 1
4674462 2257622 2257622 defendant To the Robert   757185 757185 To the, Robert, of Yevelchestre, parson of the church of Saint Mary the Great 0
4675178 2257848 2257848 defendant Crukern John husbandman 757185 757185 Crukern, John, of Yevelchestre, husbandman 0
4684198 2260660 2260660 defendant Tothe Robert clerk 757185 757185 Tothe, Robert, of Yevelchestre, clerk 0
4687610 2261709 2261709 defendant Baker Thomas yeoman 757185 757185 Baker, Thomas, of Yevelchestre, yeoman 2
4698031 2264873 2264873 defendant Deghe John vintner 757185 757185 Deghe, John, of Yevelchestre, vintner 0
4703264 2266398 2266398 defendant Deighter John fuller 757185 757185 Deighter, John, of Yevelchestre, fuller 3
4724974 2273104 2273104 defendant Bryce John gent 757185 757185 Bryce, John, of Yevelchestre, gent 0
4731778 2275128 2275128 plaintiff Newton William   757185 757185 Newton, William, of Yevelchestre 0
4749748 2280405 2280405 defendant Baker Thomas husbandman 757185 757185 Baker, Thomas, of Yevelchestre, husbandman 1
4768523 2286131 2286131 defendant Skynner John fishmonger 757185 757185 Skynner, John, of Yevelchestre, fishmonger 0
4768524 2286131 2286131 defendant Draper Thomas draper 757185 757185 Draper, Thomas, of Yevelchestre, draper 1
4771129 2286952 2286952 defendant Draper Thomas draper 757185 757185 Draper, Thomas, of Yevelchestre, draper 3
4810386 2299396 2299396 defendant atte Wille James setter 757185 757185 atte Wille, James, of Yevelchestre, setter 1
4815851 2301061 2301061 defendant Henle William laborer 757185 757185 Henle, William, of Yevelchestre, laborer 0
4816304 2301184 2301184 defendant Devenysshe John carpenter 757185 757185 Devenysshe, John, of Yevelchestre, carpenter 0
4819234 2302095 2302095 defendant Draper David husbandman 757185 757185 Draper, David, of Yevelchestre, husbandman 2
4831469 2305874 2305874 defendant Chepman John   757185 757185 Chepman, John, of Yevelchestre, linen draper 0
4831470 2305874 2305874 defendant Goldon John weaver 757185 757185 Goldon, John, of Yevelchestre, weaver 1
4831471 2305874 2305874 defendant Rempa Robert laborer 757185 757185 Rempa, Robert, of Yevelchestre, laborer 2
4858373 2313990 2313990 defendant Golde John weaver 757185 757185 Golde, John, of Yevelchestre, weaver 0
4858374 2313990 2313990 defendant Rempe Robert laborer 757185 757185 Rempe, Robert, of Yevelchestre, laborer 1
4859430 2314326 2314326 defendant Kynge Robert hosteler 757185 757185 Kynge, Robert, of Yevelchestre, hosteler 4
4861454 2314953 2314953 defendant Newelond Peter   757185 757185 Newelond, Peter, of Yevelchestre, bailiff 2
4865409 2316150 2316150 defendant Devenyssh John laborer 757185 757185 Devenyssh, John, of Yevelchestre, laborer 2
4868096 2316994 2316994 defendant Newelond Peter   757185 757185 Newelond, Peter, of Yevelchestre, bailiff 2
4875596 2319325 2319325 defendant Kynge Robert   757185 757185 Kynge, Robert, of Yevelchestre, wine taverner 0
4876456 2319599 2319599 defendant Chapman John chapman 757185 757185 Chapman, John, of Yevelchestre, chapman 0
4882817 2321547 2321547 plaintiff Bysshop John   757185 757185 Bysshop, John, of Yevelchestre 0
4882818 2321547 2321547 defendant Lyte Peter falconer 757185 757185 Lyte, Peter, of Yevelchestre, falconer 0
4882819 2321547 2321547 defendant Lyte Thomas yeoman 757185 757185 Lyte, Thomas, of Yevelchestre, yeoman 1
4882820 2321547 2321547 defendant Lyte Edmund falconer 757185 757185 Lyte, Edmund, of Yevelchestre, falconer 2
4943256 2339861 2339861 defendant Taillour John yeoman 757185 757185 Taillour, John, of Yevelchestre, yeoman 4
5003431 2357900 2357900 defendant Saymour Thomas butcher 757185 757185 Saymour, Thomas, of Yevelchestre, butcher 0
5028112 2365097 2365097 defendant atte Will James cordwainer 757185 757185 atte Will, James, of Yevelchestre, cordwainer 6
5054648 2372967 2372967 defendant Hunt John butcher 757185 757185 Hunt, John, of Yevelchestre, butcher 2
5054649 2372967 2372967 defendant Bontailour John butcher 757185 757185 Bontailour, John, of Yevelchestre, butcher 3
5076256 2379401 2379401 defendant Bontayllour John butcher 757185 757185 Bontayllour, John, of Yevelchestre, butcher 0
5077725 2379833 2379833 defendant Hunt John butcher 757185 757185 Hunt, John, of Yevelchestre, butcher 1
5087853 2382828 2382828 defendant Hunte John butcher 757185 757185 Hunte, John, of Yevelchestre, butcher 0
5125366 2393902 2393902 plaintiff Baker Thomas   757185 757185 Baker, Thomas, of Yevelchestre 0
5126355 2394189 2394189 defendant Bontaylour John yeoman 757185 757185 Bontaylour, John, of Yevelchestre, yeoman 3
5127745 2394595 2394595 defendant Wode John yeoman 757185 757185 Wode, John, of Yevelchestre, yeoman 1
5174325 2408194 2408194 defendant Veryng John yeoman 757185 757185 Veryng, John, of Yevelchestre, yeoman 2
5174326 2408194 2408194 defendant Broune John   757185 757185 Broune, John, of Yevelchestre, groom 3
5174327 2408194 2408194 defendant Worsley John   757185 757185 Worsley, John, of Yevelchestre, groom 4
5177630 2409152 2409152 defendant Veryng John yeoman 757185 757185 Veryng, John, of Yevelchestre, yeoman 2
5177631 2409152 2409152 defendant Broune John   757185 757185 Broune, John, of Yevelchestre, groom 3
5177632 2409152 2409152 defendant Worsley John   757185 757185 Worsley, John, of Yevelchestre, groom 4
5212384 2419365 2419365 defendant Dyrdo John butcher 757185 757185 Dyrdo, John, of Yevelchestre, butcher 0
5281362 2439620 2439620 defendant Bonetaylour John butcher 757185 757185 Bonetaylour, John, of Yevelchestre, butcher 4
5286501 2441058 2441058 defendant Berdon Peter yeoman 757185 757185 Berdon, Peter, of Yevelchestre, yeoman 0
5289473 2441920 2441920 defendant Bontaillour John butcher 757185 757185 Bontaillour, John, of Yevelchestre, butcher 2
5440440 2487044 2487044 defendant Walford John yeoman 757185 757185 Walford, John, of Yevelchestre, yeoman 1
5615534 2548648 2548648 defendant Fissher William   757185 757185 Fissher, William, of Yevelchestre 0
5620735 2550353 2550353 defendant Blankepayn Walter   757185 757185 Blankepayn, Walter, of Yevelchestre 0

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