names

81 rows where place_id = 755065

✎ 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
4425388 2172764 2172764 defendant Lesong John   755065 755065 Lesong, John, of Haverbergh 1
4451603 2185472 2185472 defendant Coo Roger   755065 755065 Coo, Roger, of Haverbergh 0
4505463 2202238 2202238 plaintiff Spycer William   755065 755065 Spycer, William, of Haverbergh 0
4578614 2224800 2224800 plaintiff Clypston Thomas clerk 755065 755065 Clypston, Thomas, of Haverbergh, clerk 0
4622074 2237884 2237884 plaintiff Leycestre Richard   755065 755065 Leycestre, Richard, of Haverbergh 0
4646061 2244922 2244922 defendant Couper Richard   755065 755065 Couper, Richard, of Haverbergh 3
4650944 2246296 2246296 defendant Hayward William   755065 755065 Hayward, William, of Haverbergh 0
4662844 2249841 2249841 defendant Merston John sherman 755065 755065 Merston, John, of Haverbergh, sherman 0
4681642 2259871 2259871 plaintiff Michel Robert (legal representative) 755065 755065 Michel, Robert, of Haverbergh, executors of 0
4686288 2261315 2261315 plaintiff Shit John   755065 755065 Shit, John, of Haverbergh 0
4742210 2278212 2278212 defendant Page Thomas husbandman 755065 755065 Page, Thomas, of Haverbergh, husbandman 3
4742211 2278212 2278212 defendant Laughton Thomas husbandman 755065 755065 Laughton, Thomas, of Haverbergh, husbandman 4
4751379 2280881 2280881 plaintiff Shitte John   755065 755065 Shitte, John, of Haverbergh 0
4751380 2280881 2280881 defendant Harper John tanner 755065 755065 Harper, John, of Haverbergh, tanner 0
4755432 2282079 2282079 defendant Monde John laborer 755065 755065 Monde, John, of Haverbergh, laborer 0
4755439 2282080 2282080 defendant Monde John laborer 755065 755065 Monde, John, of Haverbergh, laborer 0
4763665 2284623 2284623 defendant Warmyngton Richard chapman 755065 755065 Warmyngton, Richard, of Haverbergh, chapman 0
4767292 2285756 2285756 plaintiff Andrewe John   755065 755065 Andrewe, John, of Haverbergh 1
4771345 2287020 2287020 defendant Merston John sheer man 755065 755065 Merston, John, of Haverbergh, sheer man 1
4780554 2289912 2289912 defendant Laughton John husbandman 755065 755065 Laughton, John, of Haverbergh, husbandman 3
4806798 2298337 2298337 defendant Warmyngton John yeoman 755065 755065 Warmyngton, John, of Haverbergh, yeoman 0
4806799 2298337 2298337 defendant Warmyngton Richard butcher 755065 755065 Warmyngton, Richard, of Haverbergh, butcher 1
4806800 2298337 2298337 defendant Shytte Thomas mercer 755065 755065 Shytte, Thomas, of Haverbergh, mercer 2
4806802 2298338 2298338 defendant Warnyngton John yeoman 755065 755065 Warnyngton, John, of Haverbergh, yeoman 0
4806803 2298338 2298338 defendant Warmyngton Richard butcher 755065 755065 Warmyngton, Richard, of Haverbergh, butcher 1
4806804 2298338 2298338 defendant Shytoe Thomas mercer 755065 755065 Shytoe, Thomas, of Haverbergh, mercer 2
4868410 2317091 2317091 defendant Reve Thomas husbandman 755065 755065 Reve, Thomas, of Haverbergh, husbandman 1
4905421 2328288 2328288 defendant Warmyngton John mercer 755065 755065 Warmyngton, John, of Haverbergh, mercer 1
4936200 2337724 2337724 defendant Smyth John yeoman 755065 755065 Smyth, John, of Haverbergh, yeoman 0
4936201 2337724 2337724 defendant Machon Thomas miller 755065 755065 Machon, Thomas, of Haverbergh, miller 1
4936202 2337724 2337724 defendant Stanton or Stauton Robert mercer 755065 755065 Stanton or Stauton, Robert, of Haverbergh, mercer 2
4936205 2337726 2337726 plaintiff Borewsorth Robert   755065 755065 Borewsorth, Robert, of Haverbergh 0
4958594 2344536 2344536 defendant Roper William piper 755065 755065 Roper, William, of Haverbergh, piper 0
4973258 2348937 2348937 defendant Gote Thomas draper 755065 755065 Gote, Thomas, of Haverbergh, draper 1
4979512 2350831 2350831 defendant Bysshop Thomas clerk 755065 755065 Bysshop, Thomas, of Haverbergh, clerk 2
4989553 2353809 2353809 defendant Wermyngton Robert chapman 755065 755065 Wermyngton, Robert, of Haverbergh, chapman 0
4989555 2353810 2353810 defendant Wermyngton Robert chapman 755065 755065 Wermyngton, Robert, of Haverbergh, chapman 0
5015674 2361470 2361470 defendant Warmyngton Robert chapman 755065 755065 Warmyngton, Robert, of Haverbergh, chapman 0
5016683 2361769 2361769 defendant Wermyngton Robert chapman 755065 755065 Wermyngton, Robert, of Haverbergh, chapman 2
5026151 2364544 2364544 defendant Warmyngton Robert husbandman 755065 755065 Warmyngton, Robert, of Haverbergh, husbandman 4
5033472 2366673 2366673 defendant Hamond Henry butcher 755065 755065 Hamond, Henry, of Haverbergh, butcher 0
5045568 2370305 2370305 defendant Wermyngton Robert chapman 755065 755065 Wermyngton, Robert, of Haverbergh, chapman 0
5065577 2376239 2376239 defendant Warmyngton Robert husbandman 755065 755065 Warmyngton, Robert, of Haverbergh, husbandman 1
5065578 2376239 2376239 defendant Iremonger Richard husbandman 755065 755065 Iremonger, Richard, of Haverbergh, husbandman 2
5071745 2378041 2378041 defendant Stonton John chapman 755065 755065 Stonton, John, of Haverbergh, chapman 0
5071746 2378041 2378041 defendant Spenser Thomas barber 755065 755065 Spenser, Thomas, of Haverbergh, barber 1
5071747 2378041 2378041 defendant Smyth Henry smith 755065 755065 Smyth, Henry, of Haverbergh, smith 2
5115666 2391010 2391010 defendant Thorwale Richard tailor 755065 755065 Thorwale, Richard, of Haverbergh, tailor 1
5115667 2391010 2391010 defendant Andrewe John cordwainer 755065 755065 Andrewe, John, of Haverbergh, cordwainer 2
5115668 2391010 2391010 defendant Louta or Lonta William butcher 755065 755065 Louta or Lonta, William, of Haverbergh, butcher 3
5122584 2393038 2393038 defendant Langton John husbandman 755065 755065 Langton, John, of Haverbergh, husbandman 0
5138989 2397897 2397897 defendant Page John   755065 755065 Page, John, of Haverbergh, fish monger 0
5141850 2398734 2398734 defendant Robard Thomas   755065 755065 Robard, Thomas, of Haverbergh 0
5141851 2398734 2398734 defendant Wryght Robert husbandman 755065 755065 Wryght, Robert, of Haverbergh, husbandman 1
5141852 2398734 2398734 defendant Marchall William shoemaker 755065 755065 Marchall, William, of Haverbergh, shoemaker 2
5174853 2408340 2408340 defendant Page John (legal representative) 755065 755065 Page, John, of Haverbergh, fishmonger, executors of 0
5176806 2408903 2408903 defendant Robard Thomas butcher 755065 755065 Robard, Thomas, of Haverbergh, butcher 0
5176807 2408903 2408903 defendant Wryght Robert husbandman 755065 755065 Wryght, Robert, of Haverbergh, husbandman 1
5176808 2408903 2408903 defendant Marchall William shoemaker 755065 755065 Marchall, William, of Haverbergh, shoemaker 2
5195693 2414484 2414484 plaintiff Schit Thomas (legal representative) 755065 755065 Schit, Thomas, of Haverbergh, woolman, executrix of 0
5195695 2414484 2414484 defendant Page John (legal representative) 755065 755065 Page, John, of Haverbergh, fishmonger, executors of 0
5225497 2423132 2423132 defendant Cook Robert cordwainer 755065 755065 together with Cook, Robert, of Haverbergh, cordwainer 2
5225498 2423132 2423132 defendant Loute or Lonte William butcher 755065 755065 Loute or Lonte, William, of Haverbergh, butcher 3
5225503 2423133 2423133 defendant Loute William butcher 755065 755065 Loute, William, of Haverbergh, butcher 3
5260799 2433499 2433499 defendant Joye Lambert   755065 755065 Joye, Lambert, of Haverbergh, yeoman, single man, son of Joye, Nicholas 0
5323527 2452118 2452118 defendant Rose Michael baker 755065 755065 Rose, Michael, of Haverbergh, baker 1
5619126 2549830 2549830 defendant Coley Robert   755065 755065 Coley, Robert, of Haverbergh, 1
5620557 2550290 2550290 defendant Ragge Thomas   755065 755065 Ragge, Thomas, of Haverbergh 0
5628165 2552770 2552770 defendant Potter John husbandman 755065 755065 Potter, John, of Haverbergh, husbandman 0
5628166 2552770 2552770 defendant Laughton John husbandman 755065 755065 Laughton, John, of Haverbergh, husbandman 1
5628302 2552812 2552812 defendant Wermyngton John yeoman 755065 755065 Wermyngton, John, of Haverbergh, yeoman 1
5628304 2552812 2552812 defendant atte Kirke William butcher 755065 755065 atte Kirke, William, of Haverbergh, butcher 3
5628305 2552812 2552812 defendant West John butcher 755065 755065 West, John, of Haverbergh, butcher 4
5628306 2552812 2552812 defendant Oxenden John butcher 755065 755065 Oxenden, John, of Haverbergh, butcher 5
5628307 2552812 2552812 defendant Edmund John butcher 755065 755065 Edmund, John, of Haverbergh, butcher 6
5628308 2552812 2552812 defendant Deraunt John fletcher 755065 755065 Deraunt, John, of Haverbergh, fletcher 7
5628309 2552812 2552812 defendant Hoke Robert   755065 755065 Hoke, Robert, of Haverbergh, "elymonger" 8
5628310 2552812 2552812 defendant Affrey John pedder 755065 755065 Affrey, John, of Haverbergh, pedder 9
5630312 2553485 2553485 defendant Smyth Thomas smith 755065 755065 Smyth, Thomas, of Haverbergh, smith 0
5632642 2554231 2554231 defendant Alyngton John mercer 755065 755065 Alyngton, John, of Haverbergh, mercer 0
5635310 2555009 2555009 plaintiff Deyster John   755065 755065 Deyster, John, of Haverbergh 1

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