names

102 rows where place_id = 589715

✎ 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
3598491 1867157 1867157 defendant Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 1
3603039 1868618 1868618 defendant Hare John butcher 589715 589715 Hare, John, of Chesthunt, Herts, butcher 2
3632612 1905018 1905018 defendant Couper William collier 589715 589715 Couper, William, of Chesthunt, Herts, collier 0
3632614 1905019 1905019 defendant Couper William collier 589715 589715 Couper, William, of Chesthunt, Herts, collier 0
3642973 1908252 1908252 defendant Browne John yeoman 589715 589715 Browne, John, of Chesthunt, Herts, yeoman 0
3770873 1948577 1948577 defendant Cressy Robert husbandman 589715 589715 Cressy, Robert, of Chesthunt, Herts, husbandman 0
3942089 2004368 2004368 defendant Fuller Thomas brewer 589715 589715 Fuller, Thomas, of Chesthunt, Herts, brewer 1
3947535 2006208 2006208 defendant Beane Richard collier 589715 589715 Beane, Richard, of Chesthunt, Herts, collier 1
3956568 2009363 2009363 defendant Denny Henry esq 589715 589715 Denny, Henry, of Chesthunt, Herts, esq 0
3971697 2014662 2014662 defendant Parrott John yeoman 589715 589715 Parrott, John, of Chesthunt, Herts, yeoman 0
4000619 2024994 2024994 defendant Fletcher John yeoman 589715 589715 Fletcher, John, of Chesthunt, Herts, yeoman 2
4027234 2034389 2034389 plaintiff Chare Richard   589715 589715 Chare, Richard, of Chesthunt, Herts 0
4034985 2037194 2037194 defendant Parrat John gent 589715 589715 Parrat, John, of Chesthunt, Herts, gent 0
4034987 2037195 2037195 defendant Parratt John gent 589715 589715 Parratt, John, of Chesthunt, Herts, gent 0
4147215 2077164 2077164 defendant Rey Richard yeoman 589715 589715 Rey, Richard, of Chesthunt, Herts, yeoman 0
4260309 2116413 2116413 defendant Curle Thomas yeoman 589715 589715 Curle, Thomas, of Chesthunt, Herts, yeoman 1
4262353 2117079 2117079 defendant Marridge William yeoman 589715 589715 Marridge, William, of Chesthunt, Herts, yeoman 1
4262357 2117080 2117080 defendant Marrige William yeoman 589715 589715 Marrige, William, of Chesthunt, Herts, yeoman 1
4269296 2119324 2119324 defendant Hope Ralph gent 589715 589715 Hope, Ralph, of Chesthunt, Herts, gent 1
4269301 2119325 2119325 defendant Hope Ralph gent 589715 589715 Hope, Ralph, of Chesthunt, Herts, gent 1
4271653 2120102 2120102 defendant Curle Thomas yeoman 589715 589715 Curle, Thomas, of Chesthunt, Herts, yeoman 1
4272551 2120397 2120397 defendant Angell Cuthbert yeoman 589715 589715 Angell, Cuthbert, of Chesthunt, Herts, yeoman 2
4305466 2132051 2132051 defendant Pierson Thomas husbandman 589715 589715 Pierson, Thomas, of Chesthunt, Herts, husbandman 2
4339706 2143661 2143661 defendant Wardrop alias Hearde Humphrey husbandman 589715 589715 Wardrop alias Hearde, Humphrey, of Chesthunt, Herts, husbandman 2
4349482 2147083 2147083 defendant Chare or Chayer Richard yeoman 589715 589715 Chare or Chayer, Richard, of Chesthunt, Herts, yeoman 1
4357844 2149983 2149983 defendant Sawell John maltman 589715 589715 Sawell, John, of Chesthunt, Herts, pewterer, maltman 2
4365322 2152661 2152661 defendant Shanbrooke John maltman 589715 589715 Shanbrooke, John, of Chesthunt, Herts, maltman 3
4554452 2217323 2217323 defendant Hovyle John   589715 589715 Hovyle, John, of Chesthunt, Herts, glove maker 0
4554455 2217324 2217324 defendant Hovyle John   589715 589715 Hovyle, John, of Chesthunt, Herts, glove maker 0
4576044 2224004 2224004 plaintiff Breton John   589715 589715 Breton, John, of Chesthunt, Herts 0
4655907 2247725 2247725 defendant Tornowre William maltman 589715 589715 Tornowre, William, of Chesthunt, Herts, maltman 0
4655909 2247726 2247726 defendant Tornowre William maltman 589715 589715 Tornowre, William, of Chesthunt, Herts, maltman 0
4655911 2247727 2247727 defendant Tornowre William maltman 589715 589715 Tornowre, William, of Chesthunt, Herts, maltman 0
4658686 2248589 2248589 defendant Southwell Robert esq 589715 589715 Southwell, Robert, of Chesthunt, Herts, esq 2
4661597 2249462 2249462 defendant Southwell Robert esq 589715 589715 Southwell, Robert, of Chesthunt, Herts, esq 2
4669856 2256270 2256270 defendant Gervays William husbandman 589715 589715 Gervays, William, of Chesthunt, Herts, husbandman 3
4677956 2258723 2258723 defendant Bryd John miller 589715 589715 Bryd, John, of Chesthunt, Herts, miller 1
4677964 2258726 2258726 defendant Bryd John miller 589715 589715 Bryd, John, of Chesthunt, Herts, miller 1
4697414 2264678 2264678 defendant Brode John tailor 589715 589715 Brode, John, of Chesthunt, Herts, tailor 0
4780022 2289753 2289753 defendant Waleys Richard yeoman 589715 589715 Waleys, Richard, of Chesthunt, Herts, yeoman 0
4780023 2289753 2289753 defendant Donber or Douber Thomas husbandman 589715 589715 Donber or Douber, Thomas, of Chesthunt, Herts, husbandman 1
4839783 2308355 2308355 defendant Suthwell Robert   589715 589715 Suthwell, Robert, of Chesthunt, Herts, gent, formerly receiver general of John, earl marshall & of Nottingham 0
4849089 2311187 2311187 plaintiff Southwell Robert esq 589715 589715 Southwell, Robert, of Chesthunt, Herts, esq 0
4849921 2311446 2311446 defendant Rogger William laborer 589715 589715 Rogger, William, of Chesthunt, Herts, laborer 0
4862487 2315262 2315262 defendant Suthwell Robert gent 589715 589715 Suthwell, Robert, of Chesthunt, Herts, gent 0
4980192 2351022 2351022 defendant Colles William gent 589715 589715 Colles, William, of Chesthunt, Herts, gent 2
4980197 2351023 2351023 defendant Colles William gent 589715 589715 Colles, William, of Chesthunt, Herts, gent 2
5042591 2369385 2369385 defendant Peterowe John, senior laborer 589715 589715 (Peterowe, John, senior, of Chesthunt, Herts, laborer 3
5048162 2371078 2371078 defendant Byse William carpenter 589715 589715 Byse, William, of Chesthunt, Herts, carpenter 0
5081293 2380914 2380914 defendant Norbury Henry   589715 589715 together with Norbury, Henry, of Chesthunt, Herts, knight 1
5081313 2380920 2380920 defendant Norbury Henry   589715 589715 Norbury, Henry, of Chesthunt, Herts, knight 0
5090337 2383558 2383558 defendant Burton Edmund tailor 589715 589715 Burton, Edmund, of Chesthunt, Herts, tailor 0
5107973 2388772 2388772 defendant Reynold John ostler 589715 589715 Reynold, John, of Chesthunt, Herts, ostler 0
5109105 2389086 2389086 defendant Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 0
5170365 2407061 2407061 defendant Thomas John husbandman 589715 589715 Thomas, John, of Chesthunt, Herts, husbandman 0
5217843 2420949 2420949 defendant Baker Robert husbandman 589715 589715 Baker, Robert, of Chesthunt, Herts, husbandman 3
5237105 2426437 2426437 defendant Baker Robert husbandman 589715 589715 Baker, Robert, of Chesthunt, Herts, husbandman 1
5268521 2435913 2435913 defendant Ketylton William butcher 589715 589715 Ketylton, William, of Chesthunt, Herts, butcher 1
5268524 2435914 2435914 defendant Ketylton William butcher 589715 589715 Ketylton, William, of Chesthunt, Herts, butcher 1
5273484 2437316 2437316 defendant Horley Robert maltman 589715 589715 Horley, Robert, of Chesthunt, Herts, maltman 2
5276960 2438341 2438341 defendant Pyke John, senior husbandman 589715 589715 Pyke, John, senior, of Chesthunt, Herts, husbandman 2
5282666 2439994 2439994 defendant Whaplod alias Dixon Robert husbandman 589715 589715 Whaplod alias Dixon, Robert, of Chesthunt, Herts, husbandman 0
5305704 2446715 2446715 plaintiff Lovyngton John gent 589715 589715 Lovyngton, John, of Chesthunt, Herts, gent 0
5328872 2453713 2453713 defendant Lucas William laborer 589715 589715 Lucas, William, of Chesthunt, Herts, laborer 0
5328882 2453716 2453716 defendant Adam Thomas husbandman 589715 589715 Adam, Thomas, of Chesthunt, Herts, husbandman 0
5341793 2457627 2457627 defendant Lonyngton or Lovyngton John gent 589715 589715 Lonyngton or Lovyngton, John, of Chesthunt, Herts, gent 0
5346219 2458955 2458955 defendant Hardwyn Thomas yeoman 589715 589715 Hardwyn, Thomas, of Chesthunt, Herts, yeoman 0
5357071 2462270 2462270 defendant Kekylton William butcher 589715 589715 Kekylton, William, of Chesthunt, Herts, butcher 1
5363982 2464388 2464388 defendant Luthyngton John esq 589715 589715 Luthyngton, John, of Chesthunt, Herts, esq 0
5364119 2464437 2464437 defendant Hardewyn Thomas yeoman 589715 589715 Hardewyn, Thomas, of Chesthunt, Herts, yeoman 0
5378395 2468822 2468822 defendant Shepey Henry husandman 589715 589715 Shepey, Henry, of Chesthunt, Herts, husandman 4
5383140 2470251 2470251 defendant Pyke John yeoman 589715 589715 Pyke, John, of Chesthunt, Herts, yeoman 4
5394808 2473584 2473584 defendant Pyke John yeoman 589715 589715 Pyke, John, of Chesthunt, Herts, yeoman 1
5402880 2475905 2475905 plaintiff Luthyngnton John gent 589715 589715 Luthyngnton, John, of Chesthunt, Herts, gent 0
5415835 2479671 2479671 plaintiff Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 0
5418323 2480406 2480406 defendant Hardwyn Thomas baler 589715 589715 Hardwyn, Thomas, of Chesthunt, Herts, baler 2
5422544 2481689 2481689 defendant Barkeley William   589715 589715 Barkeley, William, of Chesthunt, Herts, knight & Lord Barkeley of Nottingham 0
5432330 2484643 2484643 plaintiff Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 0
5432332 2484644 2484644 plaintiff Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 0
5432378 2484655 2484655 defendant Adys Thomas clerk 589715 589715 Adys, Thomas, of Chesthunt, Herts, clerk 3
5436223 2485772 2485772 defendant Hardwyn Thomas baker 589715 589715 Hardwyn, Thomas, of Chesthunt, Herts, baker 2
5436229 2485773 2485773 defendant Hardwyn Thomas baker 589715 589715 Hardwyn, Thomas, of Chesthunt, Herts, baker 1
5441723 2487445 2487445 defendant Kynnersbury David clerk & vicar 589715 589715 Kynnersbury, David, of Chesthunt, Herts, clerk & vicar 0
5455583 2491577 2491577 defendant Devaunt John yeoman 589715 589715 Devaunt, John, of Chesthunt, Herts, yeoman 2
5456664 2491917 2491917 defendant Horley Robert brewer 589715 589715 Horley, Robert, of Chesthunt, Herts, brewer 3
5461905 2493503 2493503 defendant Devaunt John yeoman 589715 589715 Devaunt, John, of Chesthunt, Herts, yeoman 4
5466411 2494891 2494891 defendant Kynnesbury David clerk & vicar 589715 589715 Kynnesbury, David, of Chesthunt, Herts, clerk & vicar 0
5467337 2495178 2495178 defendant Devaunt John yeoman 589715 589715 Devaunt, John, of Chesthunt, Herts, yeoman 2
5467338 2495178 2495178 defendant Both Thomas butcher 589715 589715 Both, Thomas, of Chesthunt, Herts, butcher 3
5467344 2495179 2495179 defendant Devaunt John yeoman 589715 589715 Devaunt, John, of Chesthunt, Herts, yeoman 4
5468514 2495524 2495524 defendant Horley Robert brewer 589715 589715 Horley, Robert, of Chesthunt, Herts, brewer 2
5472404 2496712 2496712 plaintiff Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 0
5472406 2496713 2496713 plaintiff Luthyngton John gent 589715 589715 Luthyngton, John, of Chesthunt, Herts, gent 0
5473441 2497019 2497019 defendant Denaunt John yeoman 589715 589715 Denaunt, John, of Chesthunt, Herts, yeoman 4
5473449 2497020 2497020 defendant Devaunt John yeoman 589715 589715 Devaunt, John, of Chesthunt, Herts, yeoman 4
5473450 2497020 2497020 defendant Bothe Thomas butcher 589715 589715 Bothe, Thomas, of Chesthunt, Herts, butcher 5
5483524 2500018 2500018 defendant Welles John smith 589715 589715 Welles, John, of Chesthunt, Herts, smith 1
5488863 2501542 2501542 defendant Pyke John yeoman 589715 589715 Pyke, John, of Chesthunt, Herts, yeoman 0
5496858 2503989 2503989 defendant Welles John smith 589715 589715 Welles, John, of Chesthunt, Herts, smith 0
5500352 2505051 2505051 defendant Bocher Thomas butcher 589715 589715 Bocher, Thomas, of Chesthunt, Herts, butcher 1

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