names

419 rows where place_id = 587287

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590994 1864809 1864809 defendant Knewebon John, junior tanner 587287 587287 Knewebon, John, junior, of Launceston, tanner 0
3594727 1865975 1865975 plaintiff Lawys John mercer 587287 587287 Lawys, John, of Launceston, mercer 0
3594729 1865976 1865976 plaintiff Lawys Thomas mercer 587287 587287 Lawys, Thomas, of Launceston, mercer 0
3599345 1867438 1867438 defendant Comyshed John cordwainer 587287 587287 Comyshed, John, of Launceston, cordwainer 0
3599346 1867438 1867438 defendant Knebon John yeoman 587287 587287 Knebon, John, of Launceston, yeoman 1
3624571 1875221 1875221 defendant Mylle John tanner 587287 587287 Mylle, John, of Launceston, tanner 0
3655623 1912022 1912022 plaintiff Briant Francis   587287 587287 Briant, Francis, of Launceston, hat maker 0
3663556 1914529 1914529 defendant Gorge Thomas tanner 587287 587287 Gorge, Thomas, of Launceston, tanner 0
3665230 1915081 1915081 plaintiff Sosan William (legal representative) 587287 587287 Sosan, William, of Launceston, merchant, executrix of 0
3676767 1918769 1918769 defendant White John gent 587287 587287 White, John, of Launceston, gent 0
3678899 1919469 1919469 defendant White John gent 587287 587287 White, John, of Launceston, gent 0
3680631 1920021 1920021 defendant Lenne William   587287 587287 Lenne, William, of Launceston 0
3687041 1922118 1922118 defendant Moncell Thomas saddler 587287 587287 Moncell, Thomas, of Launceston, saddler 0
3704268 1927632 1927632 plaintiff Floyer Richard gent 587287 587287 Floyer, Richard, of Launceston, gent 0
3714669 1930885 1930885 defendant Whyte John gent 587287 587287 Whyte, John, of Launceston, gent 1
3726294 1934493 1934493 defendant Pers Thomas   587287 587287 Pers, Thomas, of Launceston, hat maker 1
3733692 1936782 1936782 defendant Len William merchant 587287 587287 Len, William, of Launceston, merchant 0
3733925 1936856 1936856 plaintiff Floyer Richard gent 587287 587287 Floyer, Richard, of Launceston, gent 0
3745882 1940617 1940617 defendant Ewyn Christopher cordwainer 587287 587287 Ewyn, Christopher, of Launceston, cordwainer 0
3751138 1942280 1942280 defendant Juyll John laborer 587287 587287 Juyll, John, of Launceston, laborer 1
3753824 1943139 1943139 defendant Gewyne Christopher cordwainer 587287 587287 Gewyne, Christopher, of Launceston, cordwainer 0
3759729 1945035 1945035 defendant Crought John cordwainer 587287 587287 Crought, John, of Launceston, cordwainer 0
3759730 1945035 1945035 defendant Semer John capper 587287 587287 Semer, John, of Launceston, capper 1
3759731 1945035 1945035 defendant Richard Reginald cordwainer 587287 587287 Richard, Reginald, of Launceston, cordwainer 2
3765793 1946966 1946966 defendant Monke John weaver 587287 587287 Monke, John, of Launceston, weaver 0
3765794 1946966 1946966 defendant Pears Thomas hatter 587287 587287 Pears, Thomas, of Launceston, hatter 1
3765795 1946966 1946966 defendant Pears Cornelius weaver 587287 587287 Pears, Cornelius, of Launceston, weaver 2
3765798 1946966 1946966 defendant Croddecote John merchant 587287 587287 Croddecote, John, of Launceston, merchant 5
3775130 1949954 1949954 defendant William John chapman 587287 587287 William, John, of Launceston, chapman 0
3775131 1949954 1949954 defendant Escott John yeoman 587287 587287 Escott, John, of Launceston, yeoman 1
3777162 1950609 1950609 defendant Wyllyams John mercer 587287 587287 Wyllyams, John, of Launceston, mercer 0
3777412 1950682 1950682 defendant Lucas William husbandman 587287 587287 Lucas, William, of Launceston, husbandman 0
3783800 1952701 1952701 plaintiff Lenne William   587287 587287 Lenne, William, of Launceston 0
3783802 1952702 1952702 plaintiff Lenne William   587287 587287 Lenne, William, of Launceston 0
3783804 1952703 1952703 plaintiff Lenne William merchant 587287 587287 Lenne, William, of Launceston, merchant 0
3783806 1952704 1952704 plaintiff Lenne William merchant 587287 587287 Lenne, William, of Launceston, merchant 0
3783808 1952705 1952705 plaintiff Lenne William merchant 587287 587287 Lenne, William, of Launceston, merchant 0
3783810 1952706 1952706 plaintiff Lenne William   587287 587287 Lenne, William, of Launceston 0
3785150 1953144 1953144 defendant Owen Robert cordwainer 587287 587287 Owen, Robert, of Launceston, cordwainer 0
3785151 1953144 1953144 defendant Rychard John laborer 587287 587287 Rychard, John, of Launceston, laborer 1
3786425 1953542 1953542 defendant Hockyn William yeoman 587287 587287 Hockyn, William, of Launceston, yeoman 0
3790600 1954884 1954884 defendant Estcote John yeoman 587287 587287 Estcote, John, of Launceston, yeoman 0
3790602 1954885 1954885 defendant Whyte John yeoman 587287 587287 Whyte, John, of Launceston, yeoman 0
3790603 1954885 1954885 defendant Peers Thomas hatmaker 587287 587287 Peers, Thomas, of Launceston, hatmaker 1
3799588 1957792 1957792 defendant Cradecote John merchant 587287 587287 Cradecote, John, of Launceston, merchant 0
3800238 1957994 1957994 defendant Cordycott John merchant 587287 587287 Cordycott, John, of Launceston, merchant 0
3813247 1962054 1962054 defendant Marman Richard cordwainer 587287 587287 Marman, Richard, of Launceston, cordwainer 0
3813248 1962054 1962054 defendant Comer Thomas mercer 587287 587287 Comer, Thomas, of Launceston, mercer 1
3815478 1962756 1962756 defendant Dawe Stephen husbandman 587287 587287 Dawe, Stephen, of Launceston, husbandman 0
3817793 1963472 1963472 defendant Carlyon John gent 587287 587287 Carlyon, John, of Launceston, gent, son of Carlyon, Benedict, of Launceston, gent 0
3817794 1963473 1963473 plaintiff Lenne William merchant 587287 587287 Lenne, William, of Launceston, merchant 0
3817795 1963473 1963473 defendant Carlyon John gent 587287 587287 Carlyon, John, of Launceston, gent, son of Carlyon, Benedict, of Launceston, gent 0
3817796 1963474 1963474 plaintiff Lenne William merchant 587287 587287 Lenne, William, of Launceston, merchant 0
3822765 1965022 1965022 defendant Carlyon Benedict (legal representative) 587287 587287 Carlyon, Benedict, of Launceston, gent, administrator of 0
3823349 1965217 1965217 defendant Greston Henry yeoman 587287 587287 Greston, Henry, of Launceston, yeoman 1
3824679 1965593 1965593 defendant Peter Thomas butcher 587287 587287 Peter, Thomas, of Launceston, butcher 0
3826980 1966289 1966289 defendant Whyte John gent 587287 587287 Whyte, John, of Launceston, gent 0
3829155 1967001 1967001 defendant Tregodek Thomas tailor 587287 587287 Tregodek, Thomas, of Launceston, tailor 0
3829379 1967077 1967077 defendant Trelawne John clerk 587287 587287 Trelawne, John, of Launceston, clerk 0
3832425 1968061 1968061 defendant Ketyll Benedict husbandman 587287 587287 Ketyll, Benedict, of Launceston, husbandman 5
3833444 1968388 1968388 defendant Grefton or Greston John cordwainer 587287 587287 Grefton or Greston, John, of Launceston, cordwainer 1
3833445 1968388 1968388 defendant Bragge John glover 587287 587287 Bragge, John, of Launceston, glover 2
3833447 1968389 1968389 defendant Lanard John laborer 587287 587287 Lanard, John, of Launceston, laborer 0
3837974 1969789 1969789 plaintiff Susan William (legal representative) 587287 587287 Susan, William, of Launceston, executors of 0
3837978 1969789 1969789 defendant Cottyll William   587287 587287 Cottyll, William, of Launceston 2
3849139 1973328 1973328 defendant Whyte John gent 587287 587287 Whyte, John, of Launceston, gent 0
3856030 1975511 1975511 defendant Wyse John yeoman 587287 587287 Wyse, John, of Launceston, yeoman 0
3856032 1975512 1975512 defendant Gune Christopher husbandman 587287 587287 Gune, Christopher, of Launceston, husbandman 0
3856033 1975512 1975512 defendant Lee John husbandman 587287 587287 Lee, John, of Launceston, husbandman 1
3864466 1978316 1978316 plaintiff Lenne William (legal representative) 587287 587287 Lenne, William, of Launceston, executors of 0
3864470 1978317 1978317 plaintiff Lenne William (legal representative) 587287 587287 Lenne, William, of Launceston, executors of 0
3864474 1978318 1978318 plaintiff Lenne William (legal representative) 587287 587287 Lenne, William, of Launceston, executors of 0
3864477 1978319 1978319 plaintiff Lenne William (legal representative) 587287 587287 Lenne, William, of Launceston, merchant, executors of 0
3869035 1979888 1979888 defendant Kendall William gent 587287 587287 Kendall, William, of Launceston, gent 0
3869036 1979888 1979888 defendant Marman John cordwainer 587287 587287 Marman, John, of Launceston, cordwainer 1
3869037 1979888 1979888 defendant Fokke John chaplain 587287 587287 Fokke, John, of Launceston, chaplain 2
3874794 1981788 1981788 defendant Mayowe Nicholas husbandman 587287 587287 Mayowe, Nicholas, of Launceston, husbandman 0
3874795 1981788 1981788 defendant Seymour Richard   587287 587287 Seymour, Richard, of Launceston, groom 1
3874796 1981788 1981788 defendant Mille Robert tanner 587287 587287 Mille, Robert, of Launceston, tanner 2
3878377 1983015 1983015 defendant Whyte John gent 587287 587287 Whyte, John, of Launceston, gent 0
3878456 1983041 1983041 defendant Hickes Thomas merchant 587287 587287 Hickes, Thomas, of Launceston, merchant 0
3878457 1983041 1983041 defendant Chapell John   587287 587287 Chapell, John, of Launceston 1
3878458 1983041 1983041 defendant Ogler John butcher 587287 587287 Ogler, John, of Launceston, butcher 2
3878459 1983041 1983041 defendant Pratte John laborer 587287 587287 Pratte, John, of Launceston, laborer 3
3878534 1983065 1983065 plaintiff Lenne William (legal representative) 587287 587287 Lenne, William, of Launceston, executors of 0
3879505 1983399 1983399 plaintiff Myll Robert   587287 587287 Myll, Robert, of Launceston 0
3881351 1984028 1984028 defendant White John gent 587287 587287 White, John, of Launceston, gent 0
3904968 1991923 1991923 defendant Somer John capper 587287 587287 Somer, John, of Launceston, capper 0
3906779 1992558 1992558 defendant Monke John mercer 587287 587287 Monke, John, of Launceston, mercer 0
3910675 1993885 1993885 defendant Broughton George gent 587287 587287 Broughton, George, of Launceston, gent 0
3910676 1993885 1993885 defendant Southcott John gent 587287 587287 Southcott, John, of Launceston, gent 1
3910677 1993885 1993885 defendant Kelly Richard yeoman 587287 587287 Kelly, Richard, of Launceston, yeoman 2
3915565 1995575 1995575 defendant Braye William glover 587287 587287 Braye, William, of Launceston, glover 0
3915566 1995575 1995575 defendant Whyte John tailor 587287 587287 Whyte, John, of Launceston, tailor 1
3915567 1995575 1995575 defendant Glover George glover 587287 587287 Glover, George, of Launceston, glover 2
3935915 2002327 2002327 defendant Monke John yeoman 587287 587287 Monke, John, of Launceston, yeoman 0
3969921 2014080 2014080 plaintiff Crought Henry yeoman 587287 587287 Crought, Henry, of Launceston, yeoman 0
3981943 2018304 2018304 defendant Paynter William husbandman 587287 587287 Paynter, William, of Launceston, husbandman 0
4038622 2038452 2038452 defendant Wise John gent 587287 587287 Wise, John, of Launceston, gent 0
4064355 2047528 2047528 plaintiff Grylles William draper 587287 587287 Grylles, William, of Launceston, draper 0

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