names

103 rows where place_id = 590821

✎ 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
3602407 1868414 1868414 defendant Bonde Robert husbandman 590821 590821 Bonde, Robert, of North Cory, husbandman 0
3610534 1870957 1870957 defendant Speler John mercer 590821 590821 Speler, John, of North Cory, mercer 0
3621221 1874178 1874178 defendant Uttemere John husbandman 590821 590821 Uttemere, John, of North Cory, husbandman 0
3698815 1925847 1925847 defendant Comset Thomas tailor 590821 590821 Comset, Thomas, of North Cory, tailor 0
3806785 1960025 1960025 defendant Somer William husbandman 590821 590821 Somer, William, of North Cory, husbandman 0
3829176 1967008 1967008 defendant Nurton Robert husbandman 590821 590821 Nurton, Robert, of North Cory, husbandman 1
3829178 1967008 1967008 defendant Trapnell Robert husbandman 590821 590821 Trapnell, Robert, of North Cory, husbandman 3
3858324 1976263 1976263 defendant Somer William husbandman 590821 590821 Somer, William, of North Cory, husbandman 0
4448376 2184420 2184420 defendant Caucy Hugh   590821 590821 Caucy, Hugh, of North Cory 0
4450761 2185202 2185202 defendant Craddol John   590821 590821 Craddol, John, of North Cory 0
4464682 2189622 2189622 defendant Chapelayn John   590821 590821 Chapelayn, John, of North Cory 0
4464683 2189622 2189622 defendant Cradok John   590821 590821 Cradok, John, of North Cory 1
4464684 2189622 2189622 defendant Palmere William   590821 590821 Palmere, William, of North Cory 2
4464685 2189622 2189622 defendant Bocher John   590821 590821 Bocher, John, of North Cory 3
4486339 2196437 2196437 defendant Sopere William   590821 590821 Sopere, William, of North Cory 0
4501868 2201185 2201185 defendant Boucher John   590821 590821 Boucher, John, of North Cory 0
4507184 2202714 2202714 defendant Boucher Richard   590821 590821 Boucher, Richard, of North Cory 0
4509650 2203496 2203496 defendant Chaundeler John   590821 590821 Chaundeler, John, of North Cory 0
4518543 2206172 2206172 defendant Boucher John, sen   590821 590821 Boucher, John, sen, of North Cory 4
4518549 2206174 2206174 defendant Byndon Roger   590821 590821 Byndon, Roger, of North Cory 2
4518550 2206174 2206174 defendant Broun Hugh   590821 590821 Broun, Hugh, of North Cory 3
4533750 2210823 2210823 defendant Davy John   590821 590821 Davy, John, of North Cory 0
4540206 2212840 2212840 plaintiff Webbe John   590821 590821 Webbe, John, of North Cory 0
4549060 2215641 2215641 defendant Priour William   590821 590821 Priour, William, of North Cory 0
4549061 2215641 2215641 defendant Roke John   590821 590821 Roke, John, of North Cory 1
4549062 2215641 2215641 defendant Cummell John   590821 590821 Cummell, John, of North Cory 2
4554594 2217365 2217365 defendant Combe Henry   590821 590821 Combe, Henry, of North Cory 0
4554598 2217365 2217365 defendant Dare Thomas   590821 590821 Dare, Thomas, of North Cory 4
4554599 2217365 2217365 defendant Pytte John   590821 590821 Pytte, John, of North Cory 5
4554600 2217365 2217365 defendant Hugh Robert   590821 590821 Hugh, Robert, of North Cory 6
4554601 2217365 2217365 defendant Lovehill Richard   590821 590821 Lovehill, Richard, of North Cory 7
4554602 2217365 2217365 defendant Sprake John   590821 590821 Sprake, John, of North Cory 8
4562988 2219992 2219992 defendant Hille John   590821 590821 Hille, John, of North Cory, bailiff 0
4591959 2228838 2228838 defendant Bocher Richard   590821 590821 Bocher, Richard, of North Cory 4
4614065 2235413 2235413 defendant Durham John   590821 590821 Durham, John, of North Cory 4
4614337 2235497 2235497 defendant Stonard Richard   590821 590821 Stonard, Richard, of North Cory 0
4616487 2236151 2236151 defendant Sopere William   590821 590821 Sopere, William, of North Cory 1
4621785 2237797 2237797 defendant Boucher Richard   590821 590821 Boucher, Richard, of North Cory 0
4624187 2238546 2238546 defendant Burgoyne Robert   590821 590821 Burgoyne, Robert, of North Cory 1
4641538 2243623 2243623 defendant Sopere William   590821 590821 Sopere, William, of North Cory 1
4647700 2245384 2245384 defendant Burgoyn Robert   590821 590821 Burgoyn, Robert, of North Cory 0
4654866 2247401 2247401 defendant Cras Thomas husbandman 590821 590821 Cras, Thomas, of North Cory, husbandman 0
4656302 2247862 2247862 defendant Frie William husbandman 590821 590821 Frie, William, of North Cory, husbandman 0
4688795 2262051 2262051 plaintiff Wyllyng William chaplain of the chantry 590821 590821 Wyllyng, William, of North Cory, chaplain of the chantry 2
4688830 2262062 2262062 defendant Scarlet John yeoman 590821 590821 Scarlet, John, of North Cory, yeoman 3
4690178 2262485 2262485 defendant Palmer Adam husbandman 590821 590821 Palmer, Adam, of North Cory, husbandman 1
4691507 2262868 2262868 defendant Golde John yeoman 590821 590821 Golde, John, of North Cory, yeoman 0
4707971 2267863 2267863 defendant Tournour John laborer 590821 590821 Tournour, John, of North Cory, laborer 0
4712698 2269284 2269284 defendant Tanner William   590821 590821 Tanner, William, of North Cory, swine drover 1
4712701 2269284 2269284 defendant Chaundeller John husbandman 590821 590821 Chaundeller, John, of North Cory, husbandman 4
4722917 2272485 2272485 defendant Dyght Robert husbandman 590821 590821 Dyght, Robert, of North Cory, husbandman 3
4722918 2272485 2272485 defendant Sopere Hugh husbandman 590821 590821 Sopere, Hugh, of North Cory, husbandman 4
4722921 2272485 2272485 defendant Halneacre Henry yeoman 590821 590821 Halneacre, Henry, of North Cory, yeoman 7
4745223 2279109 2279109 defendant Wodehele Hugh husbandman 590821 590821 Wodehele, Hugh, of North Cory, husbandman 1
4763148 2284457 2284457 defendant Wodehele Hugh husbandman 590821 590821 together with Wodehele, Hugh, of North Cory, husbandman 1
4786297 2291757 2291757 defendant Wodehele Hugh husbandman 590821 590821 together with Wodehele, Hugh, of North Cory, husbandman 1
4809431 2299127 2299127 defendant Pytte Simon husbandman 590821 590821 Pytte, Simon, of North Cory, husbandman 0
4809432 2299127 2299127 defendant Shote John butcher 590821 590821 Shote, John, of North Cory, butcher 1
4809433 2299127 2299127 defendant Cabbell John husbandman 590821 590821 Cabbell, John, of North Cory, husbandman 2
4835786 2307187 2307187 defendant Fox Philip butcher 590821 590821 Fox, Philip, of North Cory, butcher 2
4835826 2307195 2307195 defendant Combe William husbandman 590821 590821 (Combe, William, of North Cory, husbandman 4
4846548 2310429 2310429 defendant Bryte Richard husbandman 590821 590821 Bryte, Richard, of North Cory, husbandman 0
4859497 2314343 2314343 defendant Fox Philip husbandman 590821 590821 Fox, Philip, of North Cory, husbandman 1
4859498 2314343 2314343 defendant Webbe William   590821 590821 Webbe, William, of North Cory 2
4865852 2316290 2316290 defendant Conne William husbandman 590821 590821 Conne, William, of North Cory, husbandman 2
4866050 2316352 2316352 defendant Conne or Coune Henry   590821 590821 (Conne or Coune, Henry, of North Cory, Soms husbandman 1
4866051 2316352 2316352 defendant Conne or Coune William husbandman 590821 590821 Conne or Coune, William, of North Cory, husbandman 2
4918382 2332266 2332266 defendant Sherman William husbandman 590821 590821 Sherman, William, of North Cory, husbandman 0
4918384 2332266 2332266 defendant dyght John husbandman 590821 590821 dyght, John, of North Cory, husbandman 2
4923976 2333937 2333937 defendant Gent William husbandman 590821 590821 Gent, William, of North Cory, husbandman 0
4945338 2340519 2340519 defendant Wylmote Robert, senior husbandman 590821 590821 Wylmote, Robert, senior, of North Cory, husbandman 0
4945339 2340519 2340519 defendant Serle William husbandman 590821 590821 Serle, William, of North Cory, husbandman 1
4945340 2340519 2340519 defendant Carpenter William husbandman 590821 590821 Carpenter, William, of North Cory, husbandman 2
4945341 2340519 2340519 defendant Hous Thomas husbandman 590821 590821 Hous, Thomas, of North Cory, husbandman 3
4951596 2342455 2342455 defendant Sherman William husbandman 590821 590821 Sherman, William, of North Cory, husbandman 1
4981654 2351429 2351429 defendant Fox Richard husbandman 590821 590821 Fox, Richard, of North Cory, husbandman 0
5011457 2360216 2360216 defendant Benet Thomas husbandman 590821 590821 Benet, Thomas, of North Cory, husbandman 0
5042693 2369421 2369421 defendant Fox Richard husbandman 590821 590821 Fox, Richard, of North Cory, husbandman 2
5077621 2379802 2379802 defendant Shete John butcher 590821 590821 Shete, John, of North Cory, butcher 0
5090915 2383737 2383737 defendant Mychildever Thomas gent 590821 590821 (Mychildever, Thomas, of North Cory, gent 1
5097108 2385587 2385587 defendant Boroughwyll Thomas husbandman 590821 590821 Boroughwyll, Thomas, of North Cory, husbandman 0
5097109 2385587 2385587 defendant Boroughwyll William husbandman 590821 590821 Boroughwyll, William, of North Cory, husbandman 1
5102299 2387090 2387090 defendant Foster William husbandman 590821 590821 Foster, William, of North Cory, husbandman 0
5110346 2389429 2389429 defendant Shete John butcher 590821 590821 Shete, John, of North Cory, butcher 0
5123077 2393185 2393185 defendant White Richard clerk 590821 590821 White, Richard, of North Cory, clerk 0
5259703 2433159 2433159 defendant Blake Thomas clerk 590821 590821 Blake, Thomas, of North Cory, clerk 0
5303340 2445996 2445996 defendant Foxe Richard husbandman 590821 590821 Foxe, Richard, of North Cory, husbandman 0
5303341 2445996 2445996 defendant Foxe Thomas husbandman 590821 590821 Foxe, Thomas, of North Cory, husbandman 1
5303343 2445996 2445996 defendant Drake William husbandman 590821 590821 Drake, William, of North Cory, husbandman 3
5303567 2446063 2446063 defendant Horscove Henry chapman 590821 590821 Horscove, Henry, of North Cory, chapman 0
5324972 2452547 2452547 defendant Bonde Robert husbandman 590821 590821 Bonde, Robert, of North Cory, husbandman 0
5325950 2452851 2452851 defendant Garleke Thomas butcher 590821 590821 Garleke, Thomas, of North Cory, butcher 0
5335122 2455572 2455572 defendant Bonde Robert drover 590821 590821 Bonde, Robert, of North Cory, drover 0
5387813 2471576 2471576 defendant Dare John husbandman 590821 590821 Dare, John, of North Cory, husbandman 1
5413433 2478944 2478944 defendant Dyght John husbandman 590821 590821 Dyght, John, of North Cory, husbandman 3
5470285 2496031 2496031 defendant Dyght John husbandman 590821 590821 Dyght, John, of North Cory, husbandman 2
5490673 2502100 2502100 defendant Speler John mercer 590821 590821 Speler, John, of North Cory, mercer 2
5496852 2503986 2503986 defendant Speler John mercer 590821 590821 Speler, John, of North Cory, mercer 0
5498843 2504593 2504593 defendant Lyny or Lyvy John husbandman 590821 590821 Lyny or Lyvy, John, of North Cory, husbandman 1
5504214 2506232 2506232 defendant Dreycote John husbandman 590821 590821 Dreycote, John, of North Cory, husbandman 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);