names

96 rows where place_id = 597880

✎ 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
3630223 1904302 1904302 defendant Markys Robert fuller 597880 597880 Markys, Robert, of Bergholt, fuller 0
3691962 1923648 1923648 defendant Deye Robert (legal representative) 597880 597880 Deye, Robert, of Bergholt, executors of 0
3691964 1923648 1923648 defendant Cole Thomas yeoman 597880 597880 Cole, Thomas, of Bergholt, yeoman 2
3769452 1948106 1948106 defendant Marler Thomas (legal representative) 597880 597880 Marler, Thomas, of Bergholt, executor of 1
3769453 1948106 1948106 defendant Marler William yeoman 597880 597880 Marler, William, of Bergholt, yeoman 2
3890330 1987013 1987013 defendant Coove Richard clothmaker 597880 597880 Coove, Richard, of Bergholt, clothmaker 1
4477402 2193598 2193598 defendant atte Hegge John   597880 597880 atte Hegge, John, of Bergholt 0
4509241 2203369 2203369 defendant Gorton John   597880 597880 Gorton, John, of Bergholt 0
4509962 2203600 2203600 defendant Cukhook Robert weaver 597880 597880 Cukhook, Robert, of Bergholt, weaver 1
4553516 2217030 2217030 defendant Staunpys John baker 597880 597880 Staunpys, John, of Bergholt, baker 4
4557928 2218409 2218409 defendant Hegge John smith 597880 597880 Hegge, John, of Bergholt, smith 3
4572634 2222979 2222979 defendant Grote Roger   597880 597880 Grote, Roger, of Bergholt 0
4575731 2223919 2223919 defendant Corton John   597880 597880 Corton, John, of Bergholt 2
4584554 2226586 2226586 defendant Corton John   597880 597880 Corton, John, of Bergholt 0
4607995 2233619 2233619 defendant Sherwynd William   597880 597880 Sherwynd, William, of Bergholt 4
4624068 2238505 2238505 defendant Cokhok Robert   597880 597880 Cokhok, Robert, of Bergholt 0
4624946 2238770 2238770 defendant Smyth John, sen   597880 597880 Smyth, John, sen, of Bergholt 2
4648607 2245648 2245648 defendant Sherwynd John   597880 597880 Sherwynd, John, of Bergholt 0
4724617 2272999 2272999 defendant Lenne Stephen tailor 597880 597880 Lenne, Stephen, of Bergholt, tailor 0
4758745 2283091 2283091 defendant Regelage Thomas yeoman 597880 597880 Regelage, Thomas, of Bergholt, yeoman 1
4772688 2287429 2287429 defendant Saltmedwe John yeoman 597880 597880 Saltmedwe, John, of Bergholt, yeoman 2
4780048 2289764 2289764 defendant Cukcok Thomas   597880 597880 Cukcok, Thomas, of Bergholt, bailiff 0
4780907 2290029 2290029 defendant Regelage Thomas yeoman 597880 597880 Regelage, Thomas, of Bergholt, yeoman 1
4799789 2296119 2296119 defendant Smyth John husbandman 597880 597880 Smyth, John, of Bergholt, husbandman 2
4799790 2296119 2296119 defendant Wodehous John, junior (legal representative) 597880 597880 Wodehous, John, junior, of Bergholt, executors of 3
4800528 2296346 2296346 defendant Darnell John husbandman 597880 597880 Darnell, John, of Bergholt, husbandman 1
4800529 2296346 2296346 defendant Walden John husbandman 597880 597880 Walden, John, of Bergholt, husbandman 2
4806263 2298166 2298166 defendant Reynold John yeoman 597880 597880 (Reynold, John, of Bergholt, yeoman 4
4806264 2298166 2298166 defendant Bysshop John yeoman 597880 597880 Bysshop, John, of Bergholt, yeoman 5
4806271 2298167 2298167 defendant Reynold John yeoman 597880 597880 (Reynold, John, of Bergholt, yeoman 4
4806272 2298167 2298167 defendant Bysshop John yeoman 597880 597880 Bysshop, John, of Bergholt, yeoman 5
4808949 2298974 2298974 defendant Bysshoppe John yeoman 597880 597880 Bysshoppe, John, of Bergholt, yeoman 0
4812624 2300065 2300065 defendant Darnell William yeoman 597880 597880 Darnell, William, of Bergholt, yeoman 0
4826635 2304365 2304365 defendant Hamstede John yeoman 597880 597880 Hamstede, John, of Bergholt, yeoman 3
4841532 2308883 2308883 defendant Brook William yeoman 597880 597880 Brook, William, of Bergholt, yeoman 1
4904631 2328058 2328058 defendant Plogh William yeoman 597880 597880 Plogh, William, of Bergholt, yeoman 4
4915259 2331277 2331277 defendant Warde Lawrence yeoman 597880 597880 Warde, Lawrence, of Bergholt, yeoman 3
4962223 2345603 2345603 defendant Cukhowe Thomas husbandman 597880 597880 Cukhowe, Thomas, of Bergholt, husbandman 0
4962224 2345603 2345603 defendant Cukhowe William   597880 597880 Cukhowe, William, of Bergholt 1
4963056 2345858 2345858 defendant Baker Simon husbandman 597880 597880 Baker, Simon, of Bergholt, husbandman 2
4966362 2346873 2346873 defendant Hakon John yeoman 597880 597880 Hakon, John, of Bergholt, yeoman 0
4989941 2353900 2353900 defendant Grewener Thomas weaver 597880 597880 Grewener, Thomas, of Bergholt, weaver 0
5025723 2364427 2364427 defendant Bate Thomas tailor 597880 597880 Bate, Thomas, of Bergholt, tailor 0
5025724 2364427 2364427 defendant Hanspe or Hauspe Robert husbandman 597880 597880 Hanspe or Hauspe, Robert, of Bergholt, husbandman 1
5026861 2364725 2364725 plaintiff Longe John   597880 597880 Longe, John, of Bergholt 0
5044176 2369885 2369885 defendant Hakon William yeoman 597880 597880 Hakon, William, of Bergholt, yeoman 0
5054632 2372962 2372962 defendant Golde John butcher 597880 597880 Golde, John, of Bergholt, butcher 1
5054635 2372963 2372963 defendant Golde John butcher 597880 597880 Golde, John, of Bergholt, butcher 1
5058733 2374176 2374176 defendant Hacon William husbandman 597880 597880 Hacon, William, of Bergholt, husbandman 1
5069427 2377353 2377353 defendant Warde Lawrence mercer 597880 597880 Warde, Lawrence, of Bergholt, mercer 0
5104262 2387669 2387669 defendant Warde Lawrence yeoman 597880 597880 Warde, Lawrence, of Bergholt, yeoman 2
5123636 2393371 2393371 defendant Breton Robert baker 597880 597880 Breton, Robert, of Bergholt, baker 0
5123638 2393371 2393371 defendant Sherwyn Thomas, junior butcher 597880 597880 Sherwyn, Thomas, junior, of Bergholt, butcher 2
5129397 2395086 2395086 defendant Breton Robert baker 597880 597880 Breton, Robert, of Bergholt, baker 0
5129398 2395086 2395086 defendant Skilman John shoemaker 597880 597880 Skilman, John, of Bergholt, shoemaker 1
5143574 2399257 2399257 defendant Baker Simon (legal representative) 597880 597880 Baker, Simon, of Bergholt, executrix of 0
5143736 2399299 2399299 defendant Hakon John (legal representative) 597880 597880 Hakon, John, of Bergholt, tile maker, executors of 1
5143738 2399299 2399299 defendant Hauteyn Roger laborer 597880 597880 Hauteyn, Roger, of Bergholt, laborer 3
5146857 2400220 2400220 defendant Hunte William husbandman 597880 597880 Hunte, William, of Bergholt, husbandman 3
5146862 2400221 2400221 defendant Hunte William husbandman 597880 597880 Hunte, William, of Bergholt, husbandman 3
5147092 2400287 2400287 defendant Breton Robert baker 597880 597880 Breton, Robert, of Bergholt, baker 1
5147095 2400288 2400288 defendant Breton Robert baker 597880 597880 Breton, Robert, of Bergholt, baker 1
5161787 2404553 2404553 defendant Plumme Thomas fuler 597880 597880 Plumme, Thomas, of Bergholt, fuler 1
5176068 2408685 2408685 defendant Plumme Thomas fuller 597880 597880 Plumme, Thomas, of Bergholt, fuller 1
5192208 2413454 2413454 defendant Devenysche Richard chaplain 597880 597880 (Devenysche, Richard, of Bergholt, chaplain 1
5192209 2413454 2413454 defendant Warde Lawrence yeoman 597880 597880 Warde, Lawrence, of Bergholt, yeoman 2
5197911 2415127 2415127 defendant Plimme Thomas fuller 597880 597880 Plimme, Thomas, of Bergholt, fuller 1
5201328 2416145 2416145 defendant Baker Simon (legal representative) 597880 597880 Baker, Simon, of Bergholt, executrix of 0
5207672 2417983 2417983 defendant Devenysche Richard chaplain 597880 597880 (Devenysche, Richard, of Bergholt, chaplain 1
5207673 2417983 2417983 defendant Warde Lawrence yeoman 597880 597880 Warde, Lawrence, of Bergholt, yeoman 2
5211735 2419174 2419174 defendant Skilman John shoemaker 597880 597880 Skilman, John, of Bergholt, shoemaker 1
5216530 2420564 2420564 defendant Peverell Richard clothmaker 597880 597880 Peverell, Richard, of Bergholt, clothmaker 1
5218764 2421215 2421215 defendant Breton Robert baker 597880 597880 Breton, Robert, of Bergholt, baker 0
5218799 2421225 2421225 defendant Skilman John shoemaker 597880 597880 Skilman, John, of Bergholt, shoemaker 1
5230253 2424467 2424467 defendant Cole Thomas   597880 597880 Cole, Thomas, of Bergholt, laborer, son of Cole, Thomas 0
5242801 2428099 2428099 defendant Peverell William clothmaker 597880 597880 Peverell, William, of Bergholt, clothmaker 0
5245391 2428807 2428807 defendant Peverell Thomas   597880 597880 Peverell, Thomas, of Bergholt, administrators of 0
5250028 2430119 2430119 defendant Cosyn Thomas yeoman 597880 597880 Cosyn, Thomas, of Bergholt, yeoman 0
5258201 2432687 2432687 defendant Peverell Richard clothmaker 597880 597880 Peverell, Richard, of Bergholt, clothmaker 0
5258202 2432687 2432687 defendant Peverell William clothmaker 597880 597880 Peverell, William, of Bergholt, clothmaker 1
5258203 2432687 2432687 defendant Breton John baker 597880 597880 Breton, John, of Bergholt, baker 2
5269245 2436111 2436111 defendant Peverll William yeoman 597880 597880 Peverll, William, of Bergholt, yeoman 1
5269246 2436111 2436111 defendant Cole John yeoman 597880 597880 Cole, John, of Bergholt, yeoman 2
5269247 2436111 2436111 defendant Cole Thomas yeoman 597880 597880 Cole, Thomas, of Bergholt, yeoman 3
5284048 2440355 2440355 defendant Reynold Thomas clothmaker 597880 597880 Reynold, Thomas, of Bergholt, clothmaker 4
5353907 2461286 2461286 defendant Warner George butcher 597880 597880 Warner, George, of Bergholt, butcher 0
5432435 2484672 2484672 defendant Butte John shoemaker 597880 597880 Butte, John, of Bergholt, shoemaker 1
5527565 2513201 2513201 defendant Vanyour Richard courser 597880 597880 Vanyour, Richard, of Bergholt, courser 0
5527571 2513202 2513202 defendant Venyour Richard cordwainer 597880 597880 Venyour, Richard, of Bergholt, cordwainer 0
5550413 2520140 2520140 defendant Paterell Henry husbandman 597880 597880 Paterell, Henry, of Bergholt, husbandman 2
5575385 2527391 2527391 defendant Archer John husbandman 597880 597880 Archer, John, of Bergholt, husbandman 0
5576236 2527628 2527628 defendant Hyll William gent 597880 597880 Hyll, William, of Bergholt, gent 1
5593578 2532973 2532973 defendant Hyll William   597880 597880 Hyll, William, of Bergholt 1
5601363 2535319 2535319 defendant Debneham William shoemaker 597880 597880 Debneham, William, of Bergholt, shoemaker 0
5614999 2548485 2548485 defendant Clerk John   597880 597880 Clerk, John, of Bergholt 3
5622410 2550934 2550934 plaintiff Vynte John   597880 597880 Vynte, John, of Bergholt 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);