names

91 rows where place_id = 593216

✎ 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
3610952 1871099 1871099 defendant Alyne or Alyve Thomas clerk 593216 593216 Alyne or Alyve, Thomas, of Elme, clerk 0
3635975 1906047 1906047 defendant Atwode Joan widow 593216 593216 Atwode, Joan, of Elme, widow 0
3635976 1906047 1906047 defendant Atwode Thomas husbandman 593216 593216 Atwode, Thomas, of Elme, husbandman 1
3638320 1906802 1906802 defendant Harvy William (legal representative) 593216 593216 Harvy, William, of Elme, husbandman, executor of 0
3664425 1914821 1914821 defendant Slegge John fuller of cloth 593216 593216 Slegge, John, of Elme, fuller of cloth 1
4014650 2029961 2029961 defendant Balam Alexander gent 593216 593216 Balam, Alexander, of Elme, gent 1
4134966 2072825 2072825 defendant Singer Richard yeoman 593216 593216 Singer, Richard, of Elme, yeoman 0
4261193 2116712 2116712 defendant Pearse Joan widow 593216 593216 Pearse, Joan, of Elme, widow 1
4281207 2123335 2123335 defendant Maye Christopher husbandman 593216 593216 Maye, Christopher, of Elme, husbandman 1
4371701 2154937 2154937 defendant Singer William clothier 593216 593216 Singer, William, of Elme, clothier 0
4402547 2165438 2165438 defendant Clarke Robert yeoman 593216 593216 Clarke Robert, of Elme, yeoman 1
4496214 2199492 2199492 plaintiff Cokere Thomas   593216 593216 Cokere, Thomas, of Elme 0
4496219 2199493 2199493 plaintiff Cokere Thomas   593216 593216 Cokere, Thomas, of Elme, on his own account 0
4496683 2199630 2199630 defendant Essex John   593216 593216 Essex, John, of Elme 0
4501704 2201135 2201135 defendant Walsham (illegible)   593216 593216 Walsham, -----, of Elme 5
4552502 2216738 2216738 defendant Essex Bartholomew   593216 593216 Essex, Bartholomew, of Elme 2
4579071 2224934 2224934 defendant Essex John   593216 593216 Essex, John, of Elme 1
4595874 2229965 2229965 defendant Gybbes John   593216 593216 Gybbes, John, of elme 0
4595879 2229966 2229966 defendant Gybbes John   593216 593216 Gybbes, John, of Elme 0
4614973 2235694 2235694 plaintiff Erswell William   593216 593216 Erswell, William, of Elme 0
4614974 2235694 2235694 plaintiff Bonyng John   593216 593216 Bonyng, John, of Elme 1
4629689 2240208 2240208 defendant Essex John   593216 593216 Essex, John, of Elme 2
4642781 2244000 2244000 plaintiff Hervy Raoph   593216 593216 Hervy, Raoph, of Elme 0
4723750 2272732 2272732 defendant Stegge Thomas husbandman 593216 593216 Stegge, Thomas, of Elme, husbandman 0
4723935 2272785 2272785 plaintiff Dunton James   593216 593216 Dunton, James, of Elme 0
4726470 2273559 2273559 defendant Dunton James husbandman 593216 593216 Dunton, James, of Elme, husbandman 0
4729831 2274534 2274534 defendant Smyth John husbandman 593216 593216 Smyth, John, of Elme, husbandman 0
4761821 2284041 2284041 plaintiff Essex John   593216 593216 Essex, John, of Elme 0
4761822 2284041 2284041 defendant Poule William   593216 593216 Poule, William, of Elme, shoe maker 0
4761823 2284042 2284042 plaintiff Essex John   593216 593216 Essex, John, of Elme 0
4761825 2284042 2284042 defendant Poule William   593216 593216 Poule, William, of Elme, shoe maker 1
4764530 2284894 2284894 defendant Brys Nicholas husbandman 593216 593216 Brys, Nicholas, of Elme, husbandman 0
4764531 2284894 2284894 defendant Dauntre Ralph husbandman 593216 593216 Dauntre, Ralph, of Elme, husbandman 1
4767270 2285750 2285750 defendant Paule William shoemaker 593216 593216 Paule, William, of Elme, shoemaker 0
4767910 2285938 2285938 defendant Estmond John husbandman 593216 593216 Estmond, John, of Elme, husbandman 0
4767911 2285938 2285938 defendant Bonyng Nicholas fishmonger 593216 593216 Bonyng, Nicholas, of Elme, fishmonger 1
4775609 2288366 2288366 defendant Hobson John husbandman 593216 593216 Hobson, John, of Elme, husbandman 0
4777365 2288913 2288913 defendant Estmond John husbandman 593216 593216 Estmond, John, of Elme, husbandman 0
4786475 2291816 2291816 defendant Hamond John husbandman 593216 593216 Hamond, John, of Elme, husbandman 1
4786476 2291816 2291816 defendant Dauntre Ralph husbandman 593216 593216 Dauntre, Ralph, of Elme, husbandman 2
4786477 2291816 2291816 defendant Dannok John husbandman 593216 593216 Dannok, John, of Elme, husbandman 3
4786481 2291817 2291817 defendant Essex John husbandman 593216 593216 Essex, John, of Elme, husbandman 0
4792334 2293689 2293689 defendant Estmond John husbandman 593216 593216 Estmond, John, of Elme, husbandman 0
4799186 2295926 2295926 defendant Essex John husbandman 593216 593216 Essex, John, of Elme, husbandman 0
4799187 2295926 2295926 defendant Essex Nicholas husbandman 593216 593216 Essex, Nicholas, of Elme, husbandman 1
4807673 2298591 2298591 defendant Essex Nicholas yeoman 593216 593216 Essex, Nicholas, of Elme, yeoman 1
4812356 2299977 2299977 defendant Bonyng Nicholas husbandman 593216 593216 Bonyng, Nicholas, of Elme, husbandman 3
4814747 2300728 2300728 defendant Woford William fuller 593216 593216 Woford, William, of Elme, fuller 2
4817755 2301637 2301637 defendant Wonsford William fuller 593216 593216 Wonsford, William, of Elme, fuller 4
4822573 2303136 2303136 defendant Palmer John yeoman 593216 593216 Palmer, John, of Elme, yeoman 0
4852093 2312086 2312086 defendant Walpole John yeoman 593216 593216 Walpole, John, of Elme, yeoman 0
4866415 2316464 2316464 defendant Bonyng or Bovyng Richard clerk 593216 593216 Bonyng or Bovyng, Richard, of Elme, clerk 0
4918424 2332280 2332280 defendant Stevenson Adam husbandman 593216 593216 Stevenson, Adam, of Elme, husbandman 1
4918425 2332280 2332280 defendant Hamond John husbandman 593216 593216 Hamond, John, of Elme, husbandman 2
4918426 2332280 2332280 defendant Reynold Geoffrey husbandman 593216 593216 Reynold, Geoffrey, of Elme, husbandman 3
4949990 2341967 2341967 defendant Mannyng John, junior yeoman 593216 593216 Mannyng, John, junior, of Elme, yeoman 1
4972344 2348666 2348666 plaintiff Medylton John   593216 593216 Medylton, John, of Elme 3
4972351 2348667 2348667 plaintiff Middelton John   593216 593216 Middelton, John, of Elme 3
4980974 2351243 2351243 defendant Hamond John husbandman 593216 593216 Hamond, John, of Elme, husbandman 0
4980975 2351243 2351243 defendant Bryse Nicholas husbandman 593216 593216 Bryse, Nicholas, of Elme, husbandman 1
4980977 2351243 2351243 defendant Harvy Thomas, senior husbandman 593216 593216 Harvy, Thomas, senior, of Elme, husbandman 3
4983100 2351850 2351850 defendant Reynold Geoffrey husbandman 593216 593216 Reynold, Geoffrey, of Elme, husbandman 0
4983101 2351850 2351850 defendant Campe John tailor 593216 593216 Campe, John, of Elme, tailor 1
4983102 2351850 2351850 defendant Coker William laborer 593216 593216 Coker, William, of Elme, laborer 2
4983103 2351850 2351850 defendant Aubre John laborer 593216 593216 Aubre, John, of Elme, laborer 3
5005218 2358423 2358423 plaintiff Reynold Thomas clerk & parson 593216 593216 Reynold, Thomas, of Elme, clerk & parson 0
5009218 2359581 2359581 defendant Estmond John (legal representative) 593216 593216 Estmond, John, of Elme, executors of 0
5009220 2359581 2359581 defendant Estmond Nicholas husbandman 593216 593216 Estmond, Nicholas, of Elme, husbandman 2
5018936 2362426 2362426 defendant Blowyk Robert husbandman 593216 593216 Blowyk, Robert, of Elme, husbandman 0
5057038 2373684 2373684 defendant Hervy Robert husbandman 593216 593216 Hervy, Robert, of Elme, husbandman 0
5088282 2382947 2382947 plaintiff Kervyle Edward (legal representative) 593216 593216 Kervyle, Edward, of Elme, executors of 0
5090138 2383486 2383486 defendant Barker Edmund husbandman 593216 593216 Barker, Edmund, of Elme, husbandman 0
5090140 2383487 2383487 defendant Barker Edmund husbandman 593216 593216 Barker, Edmund, of Elme, husbandman 0
5184208 2411124 2411124 defendant Credelyng Thomas husbandman 593216 593216 Credelyng, Thomas, of Elme, husbandman 0
5204223 2416990 2416990 defendant Credelyng Thomas husbandman 593216 593216 Credelyng, Thomas, of Elme, husbandman 0
5218409 2421115 2421115 defendant Hervy John husbandman 593216 593216 Hervy, John, of Elme, husbandman 1
5235854 2426066 2426066 defendant Nedham John husbandman 593216 593216 Nedham, John, of Elme, husbandman 3
5258396 2432741 2432741 plaintiff Gryce Thomas merchant 593216 593216 Gryce, Thomas, of Elme, merchant 0
5258399 2432742 2432742 plaintiff Gryce Thomas tucker 593216 593216 Gryce, Thomas, of Elme, tucker 0
5272890 2437145 2437145 defendant Coke John husbandman 593216 593216 Coke, John, of Elme, husbandman 0
5285343 2440734 2440734 plaintiff Gryce Thomas clothman 593216 593216 Gryce, Thomas, of Elme, clothman 0
5286031 2440926 2440926 defendant Hervy John husbandman 593216 593216 Hervy, John, of Elme, husbandman 2
5335009 2455542 2455542 defendant Cooke John, senior husbandman 593216 593216 Cooke, John, senior, of Elme, husbandman 0
5336636 2456025 2456025 defendant Harvy John husbandman 593216 593216 Harvy, John, of Elme, husbandman 3
5409599 2477837 2477837 defendant Mees John husbandman 593216 593216 Mees, John, of Elme, husbandman 2
5452979 2490771 2490771 defendant Barker John, sen laborer 593216 593216 Barker, John, sen, of Elme, laborer 0
5510767 2508208 2508208 defendant Ferman John carpenter 593216 593216 Ferman, John, of Elme, carpenter 4
5581160 2529176 2529176 defendant Reynold William husbandman 593216 593216 Reynold, William, of Elme, husbandman 2
5603564 2535990 2535990 defendant Barker John laborer 593216 593216 Barker, John, of Elme, laborer 1
5603565 2535990 2535990 defendant Colte Henry laborer 593216 593216 Colte, Henry, of Elme, laborer 2
5619495 2549947 2549947 plaintiff Petteworth William   593216 593216 Petteworth, William, of Elme, parson 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);