names

84 rows where place_id = 586541

✎ 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
3588995 1864208 1864208 defendant Howesyng William fisher or husbandman 586541 586541 Howesyng, William, of Exmouth, fisher or husbandman 1
3611593 1871291 1871291 defendant Hogge William waterman 586541 586541 Hogge, William, of Exmouth, waterman 0
3722418 1933271 1933271 defendant Pope John weaver 586541 586541 Pope, John, of Exmouth, weaver 1
3754042 1943211 1943211 defendant Swyfte Richard gent 586541 586541 Swyfte, Richard, of Exmouth, gent 3
3760896 1945413 1945413 plaintiff Drake John gent 586541 586541 Drake, John, of Exmouth, gent 0
3833686 1968465 1968465 defendant Smyth Richard laborer 586541 586541 Smyth, Richard, of Exmouth, laborer 2
3915883 1995692 1995692 plaintiff Drakys John   586541 586541 Drakys, John, of Exmouth 0
4095109 2058580 2058580 defendant Jenkyn William husbandman 586541 586541 Jenkyn, William, of Exmouth, husbandman 0
4374387 2155907 2155907 defendant Meare William   586541 586541 Meare, William, of Exmouth, Devon, sailor 0
4440121 2181840 2181840 plaintiff Beanys or Beauys John   586541 586541 Beanys or Beauys, John, of Exmouth 0
4440122 2181840 2181840 defendant Lude John   586541 586541 Lude, John, of Exmouth 0
4478040 2193802 2193802 plaintiff Harry John   586541 586541 Harry, John, of Exmouth 0
4509915 2203586 2203586 defendant Lange William   586541 586541 Lange, William, of Exmouth 2
4527497 2208878 2208878 defendant Bradenynche John   586541 586541 Bradenynche, John, of Exmouth 0
4547074 2215020 2215020 defendant Baker Walter   586541 586541 Baker, Walter, of Exmouth 0
4695425 2264047 2264047 defendant Levermore Richard tailor 586541 586541 Levermore, Richard, of Exmouth, tailor 0
4722431 2272336 2272336 defendant Spark Henry husbandman 586541 586541 Spark, Henry, of Exmouth, husbandman 0
4722434 2272336 2272336 defendant Belston Richard fishmonger 586541 586541 Belston, Richard, of Exmouth, fishmonger 3
4735698 2276313 2276313 defendant Cole William fishmonger 586541 586541 Cole, William, of Exmouth, fishmonger 1
4759576 2283336 2283336 defendant Dyryngton John tailor 586541 586541 Dyryngton, John, of Exmouth, tailor 4
4764138 2284774 2284774 defendant Danny Nicholas mariner 586541 586541 Danny, Nicholas, of Exmouth, mariner 0
4814627 2300686 2300686 defendant Sheryngton Roger   586541 586541 Sheryngton, Roger, of Exmouth, milward 1
4829458 2305255 2305255 defendant Kede Roger seaman 586541 586541 Kede, Roger, of Exmouth, seaman 0
4841275 2308809 2308809 defendant Grogge Ralph yeoman 586541 586541 Grogge, Ralph, of Exmouth, yeoman 0
4844138 2309677 2309677 defendant Lyndesey Richard mariner 586541 586541 Lyndesey, Richard, of Exmouth, mariner 3
4844139 2309677 2309677 defendant Canon John mariner 586541 586541 Canon, John, of Exmouth, mariner 4
4864890 2315995 2315995 defendant Galewey John mercer 586541 586541 Galewey, John, of Exmouth, mercer 2
4928784 2335426 2335426 defendant Lyndese Richard mariner 586541 586541 Lyndese, Richard, of Exmouth, mariner 1
4973564 2349045 2349045 defendant Wilkyn William mariner 586541 586541 Wilkyn, William, of Exmouth, mariner 0
4973565 2349045 2349045 defendant Haydon Robert mariner 586541 586541 Haydon, Robert, of Exmouth, mariner 1
4978864 2350634 2350634 defendant Malefaunt John shipman 586541 586541 Malefaunt, John, of Exmouth, shipman 5
4993017 2354797 2354797 defendant Haydon Robert shipman 586541 586541 Haydon, Robert, of Exmouth, shipman 0
5062857 2375424 2375424 defendant Barne Edward merchant 586541 586541 Barne, Edward, of Exmouth, merchant 0
5062859 2375424 2375424 defendant Felier Philip tailor 586541 586541 Felier, Philip, of Exmouth, tailor 2
5082704 2381328 2381328 defendant atte Berne Edward mariner 586541 586541 atte Berne, Edward, of Exmouth, mariner 3
5085122 2382053 2382053 defendant Lermore John husbandman 586541 586541 Lermore, John, of Exmouth, husbandman 1
5086967 2382571 2382571 defendant Barne Edward merchant 586541 586541 Barne, Edward, of Exmouth, merchant 0
5099230 2386202 2386202 defendant Barne Edward mariner 586541 586541 Barne, Edward, of Exmouth, mariner 1
5113996 2390483 2390483 defendant Brigge John butcher 586541 586541 Brigge, John, of Exmouth, butcher 2
5135700 2396952 2396952 defendant Hele John   586541 586541 Hele, John, of Exmouth, shoe maker 0
5139263 2397973 2397973 defendant Riggewey John butcher 586541 586541 Riggewey, John, of Exmouth, butcher 0
5155957 2402900 2402900 defendant Hele John shoemaker 586541 586541 Hele, John, of Exmouth, shoemaker 0
5160200 2404079 2404079 defendant Raggeway John butcher 586541 586541 Raggeway, John, of Exmouth, butcher 0
5171530 2407393 2407393 defendant Brygge John butcher 586541 586541 Brygge, John, of Exmouth, butcher 0
5175053 2408397 2408397 defendant Riggeway John butcher 586541 586541 Riggeway, John, of Exmouth, butcher 0
5185512 2411513 2411513 defendant Wyllet John shoemaker 586541 586541 Wyllet, John, of Exmouth, shoemaker 0
5196059 2414595 2414595 defendant Ryggewey John butcher 586541 586541 Ryggewey, John, of Exmouth, butcher 0
5224707 2422895 2422895 defendant Tacy John mariner 586541 586541 Tacy, John, of Exmouth, mariner 1
5255926 2431976 2431976 defendant Russell Walter tanner 586541 586541 Russell, Walter, of Exmouth, tanner 0
5256508 2432158 2432158 defendant Kyde John mariner 586541 586541 Kyde, John, of Exmouth, mariner 8
5264531 2434661 2434661 defendant Stoklegh William merchant 586541 586541 Stoklegh, William, of Exmouth, merchant 0
5264532 2434661 2434661 defendant Powe Hugh   586541 586541 Powe, Hugh, of Exmouth, "fyssheiouter" 1
5264533 2434661 2434661 defendant Erle Richard husbandman 586541 586541 Erle, Richard, of Exmouth, husbandman 2
5281002 2439524 2439524 defendant Russell John yeoman 586541 586541 Russell, John, of Exmouth, yeoman 1
5282006 2439807 2439807 defendant Russell Walter tanner 586541 586541 Russell, Walter, of Exmouth, tanner 1
5283022 2440094 2440094 defendant Sherlond Henry yeoman 586541 586541 Sherlond, Henry, of Exmouth, yeoman 0
5301368 2445362 2445362 defendant Russell Walter tanner 586541 586541 Russell, Walter, of Exmouth, tanner 0
5302059 2445572 2445572 defendant Sherlond Henry yeoman 586541 586541 Sherlond, Henry, of Exmouth, yeoman 0
5302065 2445575 2445575 defendant Shirlond Henry husbandman 586541 586541 Shirlond, Henry, of Exmouth, husbandman 0
5302067 2445576 2445576 defendant Shyrlond Henry husbandman 586541 586541 Shyrlond, Henry, of Exmouth, husbandman 0
5329629 2453931 2453931 defendant Russell Walter tanner 586541 586541 Russell, Walter, of Exmouth, tanner 0
5332155 2454694 2454694 defendant Cole John yeoman 586541 586541 Cole, John, of Exmouth, yeoman 0
5333636 2455132 2455132 defendant Edward Henry   586541 586541 Edward, Henry, of Exmouth, dyer, administrators of 0
5333637 2455132 2455132 defendant Wylstre Henry yeoman 586541 586541 (Wylstre, Henry, of Exmouth, yeoman 1
5337934 2456430 2456430 defendant Yane or Yave Thomas mariner 586541 586541 Yane or Yave, Thomas, of Exmouth, mariner 1
5350270 2460207 2460207 plaintiff Cole John   586541 586541 Cole, John, of Exmouth 0
5353578 2461191 2461191 defendant Potter Richard yeoman 586541 586541 Potter, Richard, of Exmouth, yeoman 0
5356310 2462046 2462046 defendant Rede John fisher 586541 586541 Rede, John, of Exmouth, fisher 8
5364722 2464629 2464629 defendant Faryngdon William husbandman 586541 586541 Faryngdon, William, of Exmouth, husbandman 0
5375567 2467947 2467947 defendant Clyffe Richard baker 586541 586541 Clyffe, Richard, of Exmouth, baker 2
5378358 2468811 2468811 defendant Hert John fisher 586541 586541 Hert, John, of Exmouth, fisher 0
5426567 2482891 2482891 defendant Whyte Thomas husbandman 586541 586541 Whyte, Thomas, of Exmouth, husbandman 3
5469036 2495665 2495665 defendant Whyte Thomas husbandman 586541 586541 Whyte, Thomas, of Exmouth, husbandman 2
5469227 2495725 2495725 defendant Whyte Thomas husbandman 586541 586541 Whyte, Thomas, of Exmouth, husbandman 2
5471733 2496495 2496495 defendant Bassse William yeoman 586541 586541 Bassse, William, of Exmouth, yeoman 2
5474313 2497295 2497295 defendant Clyffe Richard baker 586541 586541 Clyffe, Richard, of Exmouth, baker 1
5485767 2500639 2500639 defendant Clyff Richard baker 586541 586541 Clyff, Richard, of Exmouth, baker 2
5485774 2500640 2500640 defendant Clyffe Richard baker 586541 586541 Clyffe, Richard, of Exmouth, baker 2
5486948 2500992 2500992 defendant Yane or Yave Thomas mariner 586541 586541 Yane or Yave, Thomas, of Exmouth, mariner 0
5523104 2512053 2512053 defendant Drake John, junior yeoman 586541 586541 Drake, John, junior, of Exmouth, yeoman 1
5546557 2518993 2518993 defendant Tapper John merchant 586541 586541 Tapper, John, of Exmouth, merchant 0
5558901 2522554 2522554 defendant Whyte William fisher 586541 586541 Whyte, William, of Exmouth, fisher 0
5570068 2525820 2525820 defendant Bouryng John husbandman 586541 586541 Bouryng, John, of Exmouth, husbandman 0
5588676 2531470 2531470 defendant Vonell or Vouell Robert yeoman 586541 586541 Vonell or Vouell, Robert, of Exmouth, yeoman 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);