names

140 rows where place_id = 599055

✎ 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
3635006 1905747 1905747 defendant Furse Nicholas husbandman 599055 599055 Furse, Nicholas, of Okehampton, husbandman 1
3635007 1905747 1905747 defendant Toker William tucker 599055 599055 Toker, William, of Okehampton, tucker 2
3663471 1914501 1914501 defendant Fursse William yeoman 599055 599055 Fursse, William, of Okehampton, yeoman 0
3665900 1915271 1915271 defendant Philbert John   599055 599055 Philbert, John, of Okehampton, clerk, & of Hardyngton, Soms 0
3678036 1919174 1919174 defendant Rowe John smith 599055 599055 Rowe, John, of Okehampton, smith 0
3678745 1919419 1919419 defendant Rowe John smith 599055 599055 Rowe, John, of Okehampton, smith 0
3678759 1919425 1919425 defendant Old Robert smith 599055 599055 Old, Robert, of Okehampton, smith 0
3678760 1919425 1919425 defendant Shapley John glover 599055 599055 Shapley, John, of Okehampton, glover 1
3687131 1922149 1922149 defendant Burdon Nicholas carrier 599055 599055 Burdon, Nicholas, of Okehampton, carrier 0
3687132 1922149 1922149 defendant Estecote Robert yeoman 599055 599055 Estecote, Robert, of Okehampton, yeoman 1
3705441 1927990 1927990 defendant Rowe John smith 599055 599055 Rowe, John, of Okehampton, smith 1
3708789 1929042 1929042 defendant Roo John husbandman 599055 599055 Roo, John, of Okehampton, husbandman 1
3732718 1936464 1936464 defendant Skykard William tanner 599055 599055 Skykard, William, of Okehampton, tanner 0
3734309 1936967 1936967 defendant Bekell alias Mylman Edmund capper 599055 599055 Bekell alias Mylman, Edmund, of Okehampton, capper 0
3734310 1936967 1936967 defendant Olde Robert carrier 599055 599055 Olde, Robert, of Okehampton, carrier 1
3745940 1940637 1940637 defendant Burdon Nicholas   599055 599055 Burdon, Nicholas, of Okehampton, "casoer" 0
3745941 1940637 1940637 defendant Escote Robert yeoman 599055 599055 Escote, Robert, of Okehampton, yeoman 1
3760623 1945322 1945322 defendant Escot Robert husbandman 599055 599055 Escot, Robert, of Okehampton, husbandman 0
3760624 1945322 1945322 defendant Batte John husbandman 599055 599055 Batte, John, of Okehampton, husbandman 1
3760625 1945322 1945322 defendant Cruse Thomas husbandman 599055 599055 Cruse, Thomas, of Okehampton, husbandman 2
3760626 1945322 1945322 defendant Ruylle Thomas husbandman 599055 599055 Ruylle, Thomas, of Okehampton, husbandman 3
3805941 1959796 1959796 defendant Ruell Thomas shoemaker 599055 599055 Ruell, Thomas, of Okehampton, shoemaker 5
3805942 1959796 1959796 defendant Wonacote Michael laborer 599055 599055 Wonacote, Michael, of Okehampton, laborer 6
3805943 1959796 1959796 defendant Browne William husbandman 599055 599055 Browne, William, of Okehampton, husbandman 7
3808627 1960578 1960578 defendant Olde Robert carrier 599055 599055 Olde Robert, of Okehampton, carrier 1
3810308 1961115 1961115 defendant Olde Robert carrier 599055 599055 Olde, Robert, of Okehampton, carrier 0
3812045 1961676 1961676 defendant Rowe John yeoman 599055 599055 Rowe, John, of Okehampton, yeoman 3
3823575 1965276 1965276 defendant Ruell Thomas shoemaker 599055 599055 Ruell, Thomas, of Okehampton, shoemaker 5
3823576 1965276 1965276 defendant Wonacote Michhael laborer 599055 599055 Wonacote, Michhael, of Okehampton, laborer 6
3823577 1965276 1965276 defendant Browne William husbandman 599055 599055 Browne, William, of Okehampton, husbandman 7
3823584 1965277 1965277 defendant Ruell Thomas shoemaker 599055 599055 Ruell, Thomas, of Okehampton, shoemaker 5
3823585 1965277 1965277 defendant Wonacote Michhael laborer 599055 599055 Wonacote, Michhael, of Okehampton, laborer 6
3823586 1965277 1965277 defendant Browne William husbandman 599055 599055 Browne, William, of Okehampton, husbandman 7
3838143 1969846 1969846 defendant Fursse Edward yeoman 599055 599055 Fursse, Edward, of Okehampton, yeoman 0
3838144 1969846 1969846 defendant Wonston John cordwainer 599055 599055 Wonston, John, of Okehampton, cordwainer 1
3840648 1970639 1970639 defendant Escot Robert yeoman 599055 599055 Escot, Robert, of Okehampton, yeoman 3
3846205 1972368 1972368 defendant Shapley John glover 599055 599055 Shapley, John, of Okehampton, glover 0
3864165 1978204 1978204 defendant Cary John esq 599055 599055 Cary, John, of Okehampton, esq 0
3878248 1982974 1982974 defendant Cary John esq 599055 599055 Cary, John, of Okehampton, esq 0
3886690 1985803 1985803 defendant Ever alias Capper Thomas capper 599055 599055 Ever alias Capper, Thomas, of Okehampton, capper 0
3904854 1991887 1991887 defendant Crary John esq 599055 599055 Crary, John, of Okehampton, esq 1
3918633 1996557 1996557 defendant Cary John esq 599055 599055 Cary, John, of Okehampton, esq 0
3925010 1998680 1998680 defendant Cary Richard esq 599055 599055 Cary, Richard, of Okehampton, esq 1
3934828 2001948 2001948 defendant Carwythan Edward gent 599055 599055 Carwythan, Edward, of Okehampton, gent 1
3974475 2015649 2015649 plaintiff Heller Henry   599055 599055 Heller, Henry, of Okehampton 0
3975636 2016037 2016037 defendant Dyer henry dyer 599055 599055 Dyer, henry, of Okehampton, dyer 2
3984119 2019085 2019085 defendant Alford John gent 599055 599055 Alford, John, of Okehampton, gent 0
3984120 2019085 2019085 defendant Woodmen Henry husbandman 599055 599055 Woodmen, Henry, of Okehampton, husbandman 1
3984121 2019085 2019085 defendant Bower John husbandman 599055 599055 Bower, John, of Okehampton, husbandman 2
4009505 2028165 2028165 defendant Helyar alias Dyer Henry dyer 599055 599055 Helyar alias Dyer, Henry, of Okehampton, dyer 0
4032041 2036128 2036128 plaintiff Furse Edmund   599055 599055 Furse, Edmund, of Okehampton 0
4041672 2039509 2039509 defendant Legge John yeoman 599055 599055 Legge, John, of Okehampton, yeoman 14
4054183 2043884 2043884 defendant Cornewe Anne widow 599055 599055 Cornewe, Anne, of Okehampton, widow 0
4068228 2048936 2048936 defendant Kyllygrewe John   599055 599055 Kyllygrewe, John, of Okehampton, or of Arwannyck, Cornw, knight 0
4096356 2059028 2059028 defendant Glanefyld George husbandman 599055 599055 Glanefyld, George, of Okehampton, husbandman 0
4128641 2070537 2070537 defendant Cornewe William gent 599055 599055 Cornewe, William, of Okehampton, gent 0
4129163 2070734 2070734 defendant Cornowe or Cornewe William gent 599055 599055 Cornowe or Cornewe, William, of Okehampton, gent 1
4159879 2081522 2081522 defendant Baron Stephen yeoman 599055 599055 Baron, Stephen, of Okehampton, yeoman 0
4207238 2098080 2098080 defendant Baron Stephen yeoman 599055 599055 Baron, Stephen, of Okehampton, yeoman 0
4233034 2107060 2107060 defendant Harnaman Thomas clothier 599055 599055 Harnaman, Thomas, of Okehampton, gent, son of Lawrence Harnaman, of Sampford Courtney, clothier 0
4245837 2111586 2111586 defendant Kennacott Thomas yeoman 599055 599055 Kennacott, Thomas, of Okehampton, yeoman 2
4258519 2115814 2115814 defendant Kinsman Thomas husbandman 599055 599055 Kinsman, Thomas, of Okehampton, husbandman 1
4291213 2126924 2126924 defendant Payne John husbandman 599055 599055 Payne, John, of Okehampton, husbandman 0
4291214 2126924 2126924 defendant Hooper William husbandman 599055 599055 together with Hooper, William, of Okehampton, husbandman 1
4291215 2126924 2126924 defendant Weare William husbandman 599055 599055 Weare, William, of Okehampton, husbandman 2
4308153 2132998 2132998 defendant Hooper William husbandman 599055 599055 Hooper, William, of Okehampton, husbandman 0
4308154 2132998 2132998 defendant Ware William husbandman 599055 599055 Ware, William, of Okehampton, husbandman 1
4383305 2159130 2159130 defendant Arscott Thomas cordwainer 599055 599055 Arscott, Thomas, of Okehampton, cordwainer 0
4389597 2161149 2161149 defendant Bartlett Nicholas tanner 599055 599055 Bartlett, Nicholas, of Okehampton, yeoman, tanner 1
4885275 2322284 2322284 defendant Totewill John   599055 599055 Totewill, John, of Okehampton 0
5056077 2373390 2373390 defendant atte Berne John   599055 599055 atte Berne, John, of Okehampton 0
5079164 2380255 2380255 defendant atte Berne John   599055 599055 atte Berne, John, of Okehampton 0
5103082 2387326 2387326 defendant Gascoigne Peter husbandman 599055 599055 Gascoigne, Peter, of Okehampton,husbandman 4
5103083 2387326 2387326 defendant Syneger William husbandman 599055 599055 Syneger, William, of Okehampton, husbandman 5
5142153 2398825 2398825 defendant Horewill Nicholas husbandman 599055 599055 Horewill, Nicholas, of Okehampton, husbandman 0
5142155 2398826 2398826 defendant Horewill Nicholas husbandman 599055 599055 Horewill, Nicholas, of Okehampton, husbandman 0
5163308 2405003 2405003 defendant Horewill Nicholas husbandman 599055 599055 Horewill, Nicholas, of Okehampton, husbandman 0
5229662 2424296 2424296 defendant Vyell Robert tanner 599055 599055 Vyell, Robert, of Okehampton, tanner 0
5263422 2434308 2434308 defendant Russell John barber 599055 599055 Russell, John, of Okehampton, barber 1
5273173 2437223 2437223 plaintiff Lytelwy-- William   599055 599055 Lytelwy--, William, of Okehampton administrators of 0
5281229 2439586 2439586 defendant Rowe John, senior smith 599055 599055 Rowe, John, senior, of Okehampton, smith 2
5281230 2439586 2439586 defendant Wylbury Henry husbandman 599055 599055 Wylbury, Henry, of Okehampton, husbandman 3
5282548 2439956 2439956 defendant at Barne Maud singlewoman 599055 599055 at Barne, Maud, of Okehampton, singlewoman 0
5290784 2442309 2442309 defendant Stephyn John shoemaker 599055 599055 Stephyn, John, of Okehampton, shoemaker 0
5293474 2443061 2443061 defendant Chipnam John husbandman 599055 599055 Chipnam, John, of Okehampton, husbandman 0
5295563 2443692 2443692 defendant Bayne Ralph yeoman 599055 599055 Bayne, Ralph, of Okehampton, yeoman 0
5296856 2444069 2444069 defendant Denbold William gent 599055 599055 Denbold, William, of Okehampton, gent 0
5296857 2444069 2444069 defendant Horewell Thomas yeoman 599055 599055 Horewell, Thomas, of Okehampton, yeoman 1
5304889 2446466 2446466 defendant Hoper John husbandman 599055 599055 Hoper, John, of Okehampton, husbandman 1
5304890 2446466 2446466 defendant Averey William husbandman 599055 599055 Averey, William, of Okehampton, husbandman 2
5305581 2446677 2446677 plaintiff Litelweke William   599055 599055 Litelweke, William, of Okehampton, administrators of 0
5311396 2448442 2448442 defendant Estcote William yeoman 599055 599055 Estcote, William, of Okehampton, yeoman 1
5311397 2448442 2448442 defendant Estcote Robert yeoman 599055 599055 Estcote, Robert, of Okehampton, yeoman 2
5311398 2448442 2448442 defendant Jurdeyn John yeoman 599055 599055 Jurdeyn, John, of Okehampton, yeoman 3
5311399 2448442 2448442 defendant Toker Nicholas carrier 599055 599055 Toker, Nicholas, of Okehampton, carrier 4
5311406 2448443 2448443 defendant Estcote William yeoman 599055 599055 Estcote, William, of Okehampton, yeoman 1
5311407 2448443 2448443 defendant Estcote Robert yeoman 599055 599055 Estcote, Robert, of Okehampton, yeoman 2
5311410 2448443 2448443 defendant Toker Nicholas carrier 599055 599055 Toker, Nicholas, of Okehampton, carrier 5
5311413 2448444 2448444 defendant Estcote William yeoman 599055 599055 Estcote, William, of Okehampton, yeoman 1
5311414 2448444 2448444 defendant Estcote Robert yeoman 599055 599055 Estcote, Robert, of Okehampton, 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);