names

111 rows where place_id = 587033

✎ 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
3590304 1864611 1864611 defendant Aleynson Lawrence yeoman 587033 587033 Aleynson, Lawrence, of Crowemere, yeoman 0
4419010 2170810 2170810 defendant Monk Michael   587033 587033 Monk, Michael, of Crowemere 0
4442435 2182579 2182579 plaintiff Brynyng Robert   587033 587033 Brynyng, Robert, of Crowemere 0
4521819 2207159 2207159 defendant Tucke John   587033 587033 Tucke, John, of Crowemere 1
4523355 2207626 2207626 plaintiff Harsyk Robert   587033 587033 Harsyk, Robert, of Crowemere 0
4523359 2207627 2207627 plaintiff Harsyk Robert   587033 587033 Harsyk, Robert, of Crowemere 0
4527058 2208742 2208742 defendant Hestyng John   587033 587033 Hestyng, John, of Crowemere 1
4531675 2210170 2210170 defendant Bakere Peter   587033 587033 Bakere, Peter, of Crowemere 0
4550171 2215997 2215997 defendant Hestynge John   587033 587033 Hestynge, John, of Crowemere 1
4552100 2216605 2216605 plaintiff Everad Bartholomew   587033 587033 Everad, Bartholomew, of Crowemere 0
4554347 2217287 2217287 defendant Harsyk Robert   587033 587033 Harsyk, Robert, of Crowemere 0
4562829 2219933 2219933 defendant Look Agnes   587033 587033 Look, Agnes, of Crowemere, formerly wife of John 2
4563330 2220104 2220104 defendant Rous John   587033 587033 Rous, John, of Crowemere 0
4567148 2221285 2221285 plaintiff Taillour Henry   587033 587033 Taillour, Henry, of Crowemere 0
4567150 2221285 2221285 defendant Clerk Nicholas   587033 587033 Clerk, Nicholas, of Crowemere 1
4584055 2226433 2226433 plaintiff Gees John   587033 587033 Gees, John, of Crowemere 0
4590099 2228268 2228268 plaintiff Clerk John   587033 587033 Clerk, John, of Crowemere 1
4619255 2237017 2237017 plaintiff Heythe Geoffrey (legal representative) 587033 587033 Heythe, Geoffrey, of Crowemere, executors of 0
4636027 2242100 2242100 plaintiff atte Heythe Geoffrey (legal representative) 587033 587033 atte Heythe, Geoffrey, of Crowemere, executors of 0
4647662 2245372 2245372 plaintiff Skynnere John   587033 587033 Skynnere, John, of Crowemere 0
4649823 2245972 2245972 defendant Panrych William   587033 587033 Panrych, William, of Crowemere 1
4660448 2249093 2249093 defendant Risburgh John turner 587033 587033 Risburgh, John, of Crowemere, turner 3
4660453 2249094 2249094 defendant Risburgh John turner 587033 587033 Risburgh, John, of Crowemere, turner 3
4663133 2249937 2249937 plaintiff Gees John   587033 587033 Gees, John, of Crowemere 0
4666363 2250954 2250954 defendant Penreth William butcher 587033 587033 Penreth, William, of Crowemere, butcher 1
4682629 2260183 2260183 defendant Harsyke Robert husbandman 587033 587033 Harsyke, Robert, of Crowemere, husbandman 2
4684888 2260868 2260868 defendant Hoppe William husbandman 587033 587033 Hoppe, William, of Crowemere, husbandman 0
4703251 2266395 2266395 defendant Jonell Walter yeoman 587033 587033 Jonell, Walter, of Crowemere, yeoman 1
4716982 2270645 2270645 plaintiff Wylyot John   587033 587033 Wylyot, John, of Crowemere 0
4723727 2272725 2272725 defendant Skot William shipman 587033 587033 Skot, William, of Crowemere, shipman 1
4738256 2277058 2277058 plaintiff Welyot Adam   587033 587033 Welyot, Adam, of Crowemere 0
4744758 2278982 2278982 defendant Draper John draper 587033 587033 Draper, John, of Crowemere, draper 0
4762151 2284140 2284140 defendant Gylmyn William tailor 587033 587033 Gylmyn, William, of Crowemere, tailor 1
4774960 2288166 2288166 defendant Maryot William yeoman 587033 587033 Maryot, William, of Crowemere, yeoman 0
4777319 2288898 2288898 defendant Coupere Thomas cooper 587033 587033 Coupere, Thomas, of Crowemere, cooper 0
4780219 2289810 2289810 defendant Baxtere Alice widow 587033 587033 Baxtere, Alice, of Crowemere, widow 2
4786417 2291796 2291796 defendant Bryd John shipman 587033 587033 Bryd, John, of Crowemere, shipman 0
4786418 2291796 2291796 defendant Suffolke Thomas draper 587033 587033 Suffolke, Thomas, of Crowemere, draper 1
4786421 2291797 2291797 defendant Gunnore Alexander shipman 587033 587033 Gunnore, Alexander, of Crowemere, shipman 1
4786697 2291893 2291893 defendant Maggys Edmund   587033 587033 Maggys, Edmund, of Crowemere, shipwright 0
4787319 2292104 2292104 defendant Postele John butcher 587033 587033 Postele, John, of Crowemere, butcher 1
4789687 2292842 2292842 defendant Hardy Thomas cooper 587033 587033 Hardy, Thomas, of Crowemere, cooper 1
4795354 2294701 2294701 defendant Brithwell Thomas shipman 587033 587033 Brithwell, Thomas, of Crowemere, shipman 0
4800760 2296423 2296423 defendant Mariot William yeoman 587033 587033 Mariot, William, of Crowemere, yeoman 0
4802833 2297075 2297075 defendant Southfolk Thomas yeoman 587033 587033 Southfolk, Thomas, of Crowemere, yeoman 0
4802834 2297075 2297075 defendant Toneys William cooper 587033 587033 Toneys, William, of Crowemere, cooper 1
4802835 2297075 2297075 defendant Couper Thomas cooper 587033 587033 Couper, Thomas, of Crowemere, cooper 2
4802836 2297075 2297075 defendant bocher Thomas butcher 587033 587033 bocher, Thomas, of Crowemere, butcher 3
4808677 2298880 2298880 defendant Gouche John yeoman 587033 587033 Gouche, John, of Crowemere, yeoman 2
4810170 2299327 2299327 defendant Southfolk Thomas husbandman 587033 587033 Southfolk, Thomas, of Crowemere, husbandman 0
4814196 2300546 2300546 defendant Southfolk Thomas husbandman 587033 587033 Southfolk, Thomas, of Crowemere, husbandman 0
4821066 2302668 2302668 defendant Nene or Neve Thomas butcher 587033 587033 Nene or Neve, Thomas, of Crowemere, butcher 0
4825771 2304096 2304096 defendant Nese Thomas butcher 587033 587033 Nese, Thomas, of Crowemere, butcher 0
4841308 2308818 2308818 defendant Botell John   587033 587033 Botell, John, of Crowemere, hoke or hook maker 0
4857543 2313747 2313747 defendant Wysseter Alan husbandman 587033 587033 Wysseter, Alan, of Crowemere, husbandman 0
4860370 2314605 2314605 defendant Jonyour Richard husbandman 587033 587033 Jonyour, Richard, of Crowemere, husbandman 0
4860372 2314605 2314605 defendant Smyth Richard laborer 587033 587033 Smyth, Richard, of Crowemere, laborer 2
4860374 2314605 2314605 defendant Smyth Alice widow 587033 587033 Smyth, Alice, of Crowemere, widow 4
4865322 2316125 2316125 defendant Postill Richard butcher 587033 587033 Postill, Richard, of Crowemere, butcher 4
4872467 2318348 2318348 defendant Chapman Simon husbandman 587033 587033 Chapman, Simon, of Crowemere, husbandman 3
4873014 2318519 2318519 defendant Gees John   587033 587033 Gees, John, of Crowemere, merchant, administrators of 0
4875389 2319259 2319259 defendant Neve Thomas butcher 587033 587033 Neve, Thomas, of Crowemere, butcher 1
4876398 2319578 2319578 plaintiff Skylman John   587033 587033 Skylman, John, of Crowemere 0
4878686 2320273 2320273 defendant Throwere John (legal representative) 587033 587033 Throwere, John, of Crowemere, executors of 0
4888422 2323178 2323178 defendant Madson Robert yeoman 587033 587033 Madson, Robert, of Crowemere, yeoman 0
4888423 2323178 2323178 defendant Stacy John butcher 587033 587033 Stacy, John, of Crowemere, butcher 1
4888424 2323178 2323178 defendant Myleham John barker 587033 587033 Myleham, John, of Crowemere, barker 2
4888425 2323178 2323178 defendant Osaunt Simon butcher 587033 587033 Osaunt, Simon, of Crowemere, butcher 3
4892214 2324310 2324310 defendant Couche or Conche John yeoman 587033 587033 Couche or Conche, John, of Crowemere, yeoman 3
4892245 2324316 2324316 defendant Lente John yeoman 587033 587033 Lente, John, of Crowemere, yeoman 0
4897815 2325981 2325981 defendant Chapman Simon husbandman 587033 587033 Chapman, Simon, of Crowemere, husbandman 1
4924547 2334113 2334113 defendant Coche John goldsmith 587033 587033 Coche, John, of Crowemere, goldsmith 1
4926568 2334728 2334728 defendant Lente John yeoman 587033 587033 Lente, John, of Crowemere, yeoman 0
4928337 2335287 2335287 plaintiff Skylman John yeoman 587033 587033 Skylman, John, of Crowemere, yeoman 0
4941604 2339392 2339392 defendant Fyngge William shipman 587033 587033 Fyngge, William, of Crowemere, shipman 5
4945612 2340608 2340608 defendant Roo William butcher 587033 587033 Roo, William, of Crowemere, butcher 0
4963981 2346136 2346136 defendant Maryot John mariner 587033 587033 Maryot, John, of Crowemere, mariner 0
4964099 2346173 2346173 defendant Bocher Robert butcher 587033 587033 Bocher, Robert, of Crowemere, butcher 1
4964100 2346173 2346173 defendant Stacy John butcher 587033 587033 together with Stacy, John, of Crowemere, butcher 2
4964101 2346173 2346173 defendant Postell Richard butcher 587033 587033 Postell, Richard, of Crowemere, butcher 3
4984412 2352270 2352270 defendant Wortys Thomas husbandman 587033 587033 Wortys, Thomas, of Crowemere, husbandman 1
4984413 2352270 2352270 defendant Auncell John husbandman 587033 587033 Auncell, John, of Crowemere, husbandman 2
4986795 2352989 2352989 defendant Southfeld William   587033 587033 Southfeld, William, of Crowemere, shoe maker 0
4990687 2354124 2354124 defendant Sexteyn Walter baker 587033 587033 Sexteyn, Walter, of Crowemere, baker 0
4995651 2355539 2355539 defendant Lyster Robert dyer 587033 587033 Lyster, Robert, of Crowemere, dyer 0
5000999 2357171 2357171 plaintiff Maryot John   587033 587033 Maryot, John, of Crowemere 1
5001004 2357172 2357172 plaintiff Maryot John   587033 587033 Maryot, John, of Crowemere 1
5002467 2357633 2357633 defendant Lent John yeoman 587033 587033 Lent, John, of Crowemere, yeoman 6
5012219 2360423 2360423 plaintiff Wyndam Richard   587033 587033 Wyndam, Richard, of Crowemere, notary 0
5013124 2360668 2360668 defendant Metton Robert yeoman 587033 587033 Metton, Robert, of Crowemere, yeoman 0
5019187 2362501 2362501 defendant Postell Richard butcher 587033 587033 Postell, Richard, of Crowemere, butcher 0
5019188 2362501 2362501 defendant Bocher Robert butcher 587033 587033 Bocher, Robert, of Crowemere, butcher 1
5019190 2362501 2362501 defendant Stacy John butcher 587033 587033 Stacy, John, of Crowemere, butcher 3
5027606 2364950 2364950 plaintiff Maryot John   587033 587033 Maryot, John, of Crowemere 1
5031518 2366078 2366078 defendant Gylmyn William tailor 587033 587033 Gylmyn, William, of Crowemere, tailor 2
5043433 2369658 2369658 defendant Fraunceys Roger (legal representative) 587033 587033 Fraunceys, Roger, of Crowemere, executors of 0
5043434 2369658 2369658 defendant Gravour Thomas yeoman 587033 587033 (Gravour, Thomas, of Crowemere, yeoman 1
5051927 2372190 2372190 defendant Aunsell John husbandman 587033 587033 Aunsell, John, of Crowemere, husbandman 1
5092517 2384191 2384191 defendant James John gent 587033 587033 James, John, of Crowemere, gent 0
5097363 2385659 2385659 defendant Roo Maud widow 587033 587033 Roo, Maud, of Crowemere, widow 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);