names

292 rows where place_id = 586940

✎ 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
3590039 1864524 1864524 defendant Wygenhale Robert husbandman 586940 586940 Wygenhale, Robert, of Baldeswell, husbandman 2
3590040 1864524 1864524 defendant Bysshop Edward yeoman 586940 586940 Bysshop, Edward, of Baldeswell, yeoman 3
3600539 1867815 1867815 defendant Santon Richard yeoman 586940 586940 Santon, Richard, of Baldeswell, yeoman 2
3602190 1868350 1868350 defendant Wygnale Robert husbandman 586940 586940 Wygnale, Robert, of Baldeswell, husbandman 5
3602191 1868350 1868350 defendant Seward John husbandman 586940 586940 Seward, John, of Baldeswell, husbandman 6
3603426 1868739 1868739 defendant Bysshop Edward (legal representative) 586940 586940 Bysshop, Edward, of Baldeswell, yeoman, administrator of 15
3603440 1868740 1868740 defendant Bysshop Edward (legal representative) 586940 586940 Bysshop, Edward, of Baldeswell, yeoman, executrix of 9
3603441 1868740 1868740 defendant Bysshop Isabel widow 586940 586940 Bysshop, Isabel, of Baldeswell, widow 10
3606081 1869569 1869569 defendant Grene Richard yeoman 586940 586940 Grene, Richard, of Baldeswell, yeoman 1
3606402 1869668 1869668 defendant Wygnall Robert yeoman 586940 586940 Wygnall, Robert, of Baldeswell, yeoman 0
3606403 1869668 1869668 defendant Bettysson Peter yeoman 586940 586940 Bettysson, Peter, of Baldeswell, yeoman 1
3616359 1872755 1872755 defendant Pylton Thomas saddler 586940 586940 Pylton, Thomas, of Baldeswell, saddler 1
3622583 1874598 1874598 defendant Bysshop Isabel widow 586940 586940 Bysshop, Isabel, of Baldeswell, widow 0
3627822 1903561 1903561 defendant Wryght Richard clerk 586940 586940 Wryght, Richard, of Baldeswell, clerk 2
3627823 1903561 1903561 defendant Wryght Ralph yeoman 586940 586940 Wryght, Ralph, of Baldeswell, yeoman 3
3631507 1904669 1904669 defendant Thompson William husbandman 586940 586940 Thompson, William, of Baldeswell, husbandman 1
3775934 1950222 1950222 defendant Coo Thomas husbandman 586940 586940 Coo, Thomas, of Baldeswell, husbandman 4
3798311 1957370 1957370 defendant Coward Richard blacksmith 586940 586940 Coward, Richard, of Baldeswell, blacksmith 2
3815454 1962749 1962749 defendant Dobbys Robert chaplain 586940 586940 Dobbys, Robert, of Baldeswell, chaplain 5
4430183 2174216 2174216 defendant Davy John   586940 586940 Davy, John, of Baldeswell 0
4516648 2205620 2205620 defendant Smyth John   586940 586940 Smyth, John, of Baldeswell 0
4614361 2235500 2235500 defendant Smyth John, sen   586940 586940 Smyth, John, sen, of Baldeswell 6
4625127 2238823 2238823 defendant Baldeswell Thomas   586940 586940 Baldeswell, Thomas, of Baldeswell 1
4640415 2243311 2243311 defendant Smyth John   586940 586940 Smyth, John, of Baldeswell 1
4647645 2245365 2245365 defendant Kyng Thomas   586940 586940 Kyng, Thomas, of Baldeswell 2
4670629 2256496 2256496 defendant Willyngton John clerk 586940 586940 Willyngton, John, of Baldeswell, clerk 0
4678452 2258867 2258867 defendant Smyth John husbandman 586940 586940 Smyth, John, of Baldeswell, husbandman 5
4680838 2259629 2259629 defendant Smyth John husbandman 586940 586940 Smyth, John, of Baldeswell, husbandman 2
4680839 2259629 2259629 defendant Smyth Thomas husbandman 586940 586940 Smyth, Thomas, of Baldeswell, husbandman 3
4683011 2260300 2260300 defendant Baldeswell alias Kyng Thomas (legal representative) 586940 586940 Baldeswell alias Kyng, Thomas, of Baldeswell, executrix of 0
4688201 2261877 2261877 defendant Taliour John tailor 586940 586940 Taliour, John, of Baldeswell, tailor 2
4707287 2267656 2267656 defendant Frenge John tailor 586940 586940 Frenge, John, of Baldeswell, tailor 2
4714010 2269708 2269708 defendant Smyth John smith 586940 586940 Smyth, John, of Baldeswell, smith 2
4745825 2279285 2279285 defendant Tounesende Nicholas yeoman 586940 586940 Tounesende, Nicholas, of Baldeswell, yeoman 0
4777449 2288941 2288941 defendant Cordy Richard   586940 586940 Cordy, Richard, of Baldeswell, bailiff 1
4882582 2321460 2321460 defendant Gardener Simon yeoman 586940 586940 Gardener, Simon, of Baldeswell, yeoman 0
4916351 2331615 2331615 defendant Gardner Simon butcher 586940 586940 Gardner, Simon, of Baldeswell, butcher 1
4916357 2331617 2331617 defendant Gardyner Simon butcher 586940 586940 Gardyner, Simon, of Baldeswell, butcher 1
4924516 2334106 2334106 defendant Gardiner Simon husbandman 586940 586940 Gardiner, Simon, of Baldeswell, husbandman 4
4926969 2334865 2334865 defendant Goidy Richard yeoman 586940 586940 Goidy, Richard, of Baldeswell, yeoman 0
4951761 2342503 2342503 defendant Gardener Simon husbandman 586940 586940 Gardener, Simon, of Baldeswell, husbandman 1
4962528 2345695 2345695 defendant Gardyner Simon husbandman 586940 586940 Gardyner, Simon, of Baldeswell, husbandman 2
4968416 2347519 2347519 defendant Sonde John husbandman 586940 586940 Sonde, John, of Baldeswell, husbandman 1
4968580 2347567 2347567 defendant Santon or Sauton William laborer 586940 586940 Santon or Sauton, William, of Baldeswell, laborer 4
4971872 2348519 2348519 defendant Sond John husbandman 586940 586940 Sond, John, of Baldeswell, husbandman 0
4972320 2348661 2348661 defendant Gardener Simon husbandman 586940 586940 Gardener, Simon, of Baldeswell, husbandman 0
4972587 2348731 2348731 defendant Smyth Robert husbandman 586940 586940 Smyth, Robert, of Baldeswell, husbandman 1
4975794 2349726 2349726 defendant Gardener Simon husbandman 586940 586940 Gardener, Simon, of Baldeswell, husbandman 3
4979522 2350833 2350833 defendant Gardener Simon husbandman 586940 586940 Gardener, Simon, of Baldeswell, husbandman 0
4979662 2350872 2350872 defendant Gardyner Simon butcher 586940 586940 Gardyner, Simon, of Baldeswell, butcher 1
4995273 2355432 2355432 defendant Santon William laborer 586940 586940 Santon, William, of Baldeswell, laborer 4
5032691 2366444 2366444 defendant Syward John yeoman 586940 586940 Syward, John, of Baldeswell, yeoman 1
5051385 2372030 2372030 defendant Smyth Robert yeoman 586940 586940 Smyth, Robert, of Baldeswell, yeoman 0
5059087 2374282 2374282 defendant Touneshend John laborer 586940 586940 Touneshend, John, of Baldeswell, laborer 1
5064222 2375842 2375842 defendant Gardyner Simon husbandman 586940 586940 Gardyner, Simon, of Baldeswell, husbandman 0
5070432 2377649 2377649 defendant Smyth Robert yeoman 586940 586940 Smyth, Robert, of Baldeswell, yeoman 1
5075657 2379219 2379219 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5082840 2381373 2381373 defendant Pope Roger husbandman 586940 586940 Pope, Roger, of Baldeswell, husbandman 1
5084674 2381932 2381932 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5084675 2381932 2381932 defendant Gardyner Simon yeoman 586940 586940 Gardyner, Simon, of Baldeswell, yeoman 1
5084676 2381932 2381932 defendant Cley John smith 586940 586940 Cley, John, of Baldeswell, smith 2
5084677 2381932 2381932 defendant Grey William   586940 586940 Grey, William, of Baldeswell, wright 3
5084678 2381932 2381932 defendant Cave or Cane Robert   586940 586940 Cave or Cane, Robert, of Baldeswell, ploughwright 4
5085409 2382123 2382123 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5085410 2382123 2382123 defendant Gardyner Simon yeoman 586940 586940 Gardyner, Simon, of Baldeswell, yeoman 1
5085411 2382123 2382123 defendant Cley John smith 586940 586940 Cley, John, of Baldeswell, smith 2
5085412 2382123 2382123 defendant Grey William   586940 586940 Grey, William, of Baldeswell, wright 3
5085413 2382123 2382123 defendant Grysakyr William yeoman 586940 586940 Grysakyr, William, of Baldeswell, yeoman 4
5085414 2382123 2382123 defendant Cave or Cane Robert   586940 586940 Cave or Cane, Robert, of Baldeswell, ploughwright 5
5093719 2384559 2384559 defendant Busshop Nicholas yeoman 586940 586940 Busshop, Nicholas, of Baldeswell, yeoman 0
5093720 2384559 2384559 defendant Wygenhale Robert yeoman 586940 586940 Wygenhale, Robert, of Baldeswell, yeoman 1
5093902 2384617 2384617 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5093903 2384617 2384617 defendant Grysakyr William yeoman 586940 586940 Grysakyr, William, of Baldeswell, yeoman 1
5093904 2384617 2384617 defendant Cley John smith 586940 586940 Cley, John, of Baldeswell, smith 2
5093905 2384617 2384617 defendant Skrevener Thomas yeoman 586940 586940 Skrevener, Thomas, of Baldeswell, yeoman 3
5095405 2385076 2385076 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5095406 2385076 2385076 defendant Cley John smith 586940 586940 Cley, John, of Baldeswell, smith 1
5099737 2386359 2386359 defendant Smyth Robert yeoman 586940 586940 Smyth, Robert, of Baldeswell, yeoman 0
5099976 2386430 2386430 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5101033 2386715 2386715 defendant Fen Simon husbandman 586940 586940 Fen, Simon, of Baldeswell, husbandman 3
5101034 2386715 2386715 defendant Suffeld Peter husbandman 586940 586940 Suffeld, Peter, of Baldeswell, husbandman 4
5101656 2386908 2386908 defendant Roket Roger butcher 586940 586940 Roket, Roger, of Baldeswell, butcher 1
5105649 2388102 2388102 defendant Wignale Robert yeoman 586940 586940 Wignale, Robert, of Baldeswell, yeoman 3
5106635 2388369 2388369 defendant Bocher alias Halle Thomas butcher or husbandman 586940 586940 Bocher alias Halle, Thomas, of Baldeswell, butcher or husbandman 0
5119330 2392076 2392076 defendant Bisshop Nicholas yeoman 586940 586940 Bisshop, Nicholas, of Baldeswell, yeoman 0
5122081 2392876 2392876 defendant Roket Roger butcher or husbandman 586940 586940 Roket, Roger, of Baldeswell, butcher or husbandman 0
5122082 2392876 2392876 defendant Halle alias Bocher Thomas butcher 586940 586940 Halle alias Bocher, Thomas, of Baldeswell, butcher 1
5125490 2393941 2393941 defendant Grey William carpenter 586940 586940 Grey, William, of Baldeswell, carpenter 3
5129849 2395215 2395215 defendant Bisshop Nicholas yeoman 586940 586940 Bisshop, Nicholas, of Baldeswell, yeoman 3
5132865 2396106 2396106 defendant Gardener Simon husbandman 586940 586940 Gardener, Simon, of Baldeswell, husbandman 0
5132866 2396106 2396106 defendant Roket Roger husbandman 586940 586940 Roket, Roger, of Baldeswell, husbandman 1
5139730 2398096 2398096 plaintiff Soude or Sonde John   586940 586940 Soude or Sonde, John, of Baldeswell 0
5139732 2398096 2398096 defendant Gardyner Simon yeoman 586940 586940 Gardyner, Simon, of Baldeswell, yeoman 1
5139733 2398096 2398096 defendant Grey William yeoman 586940 586940 Grey, William, of Baldeswell, yeoman 2
5142957 2399066 2399066 defendant Roket Robert husbandman 586940 586940 Roket, Robert, of Baldeswell, husbandman 1
5144750 2399620 2399620 defendant Kempe Hugh husbandman 586940 586940 Kempe, Hugh, of Baldeswell, husbandman 0
5149062 2400852 2400852 defendant Bisshop Nicholas yeoman 586940 586940 Bisshop, Nicholas, of Baldeswell, yeoman 3
5152670 2401922 2401922 defendant Gardener Simon husbandman 586940 586940 Gardener, Simon, of Baldeswell, husbandman 0
5152671 2401922 2401922 defendant Roket Robert husbandman 586940 586940 Roket, Robert, of Baldeswell, husbandman 1
5156139 2402955 2402955 defendant Bisshop Nicholas yeoman 586940 586940 Bisshop, Nicholas, of Baldeswell, yeoman 2

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