names

603 rows where place_id = 590660

✎ 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
3601922 1868257 1868257 defendant Norton Nicholas tanner 590660 590660 Norton, Nicholas, of Carlisle, tanner 0
3601923 1868257 1868257 defendant Barton Thomas weaver 590660 590660 Barton, Thomas, of Carlisle, weaver 1
3601924 1868257 1868257 defendant Loweson William tanner 590660 590660 Loweson, William, of Carlisle, tanner 2
3627182 1903356 1903356 defendant Leighe John gent 590660 590660 Leighe, John, of Carlisle, Cumber, gent 1
3653923 1911493 1911493 defendant Hatherynton William yeoman 590660 590660 Hatherynton, William, of Carlisle, yeoman 0
3653925 1911493 1911493 defendant Roobynson John chaplain 590660 590660 Roobynson, John, of Carlisle, chaplain 2
3664797 1914937 1914937 plaintiff Sewell Robert merchant 590660 590660 Sewell, Robert, of Carlisle, merchant 0
3664801 1914938 1914938 plaintiff Sewell Robert   590660 590660 Sewell, Robert, of Carlisle 0
3664802 1914938 1914938 plaintiff Thomson John   590660 590660 Thomson, John, of Carlisle 1
3664982 1914991 1914991 defendant Nyson Richard glover 590660 590660 Nyson, Richard, of Carlisle, glover 2
3676534 1918705 1918705 defendant Bradyate Nicholas mercer 590660 590660 Bradyate, Nicholas, of Carlisle, Cumber, mercer 1
3696010 1924992 1924992 defendant Bristoo John esq 590660 590660 Bristoo, John, of Carlisle, Cumber, esq 0
3696011 1924992 1924992 defendant Skelton Clement esq 590660 590660 Skelton, Clement, of Carlisle, esq 1
3705345 1927962 1927962 defendant Berkbek Richard chapman 590660 590660 Berkbek, Richard, of Carlisle, Cumber, chapman 0
3705346 1927962 1927962 defendant Belle Robert chapman 590660 590660 Belle, Robert, of Carlisle, chapman 1
3716864 1931563 1931563 defendant Legh John gent 590660 590660 Legh, John, of Carlisle, Cumber, gent 0
3720327 1932637 1932637 defendant Dacre Christopher   590660 590660 Dacre, Christopher, of Carlisle, Cumber, knight 0
3720328 1932637 1932637 defendant Legh John esq 590660 590660 Legh, John, of Carlisle, esq 1
3722886 1933423 1933423 defendant Heryng John clerk 590660 590660 Heryng, John, of Carlisle, clerk 0
3728196 1935082 1935082 defendant Bristowe John esq 590660 590660 Bristowe, John, of Carlisle, Cumber, esq 0
3728198 1935082 1935082 defendant Skelton Clement   590660 590660 Skelton, Clement, of Carlisle, esq: Chamberleyn, Edward, of Sherborne, Oxon, knight 2
3732541 1936407 1936407 defendant Denton John gent 590660 590660 Denton, John, of Carlisle, Cumber, gent 0
3741927 1939340 1939340 defendant Birkbek Richard merchant 590660 590660 Birkbek, Richard, of Carlisle, merchant 0
3741928 1939340 1939340 defendant Levyns Peter chaplain 590660 590660 Levyns, Peter, of Carlisle, chaplain 1
3763213 1946129 1946129 defendant Raughton Richard merchant 590660 590660 Raughton, Richard, of Carlisle, Cumber, merchant 0
3763232 1946137 1946137 defendant Berbeke Richard chapman 590660 590660 Berbeke, Richard, of Carlisle, Cumber, chapman 1
3763273 1946146 1946146 defendant Berbeke Richard chapman 590660 590660 Berbeke, Richard, of Carlisle, Cumber, chapman 1
3773055 1949276 1949276 defendant Benson Thomas glasier 590660 590660 Benson, Thomas, of Carlisle, glasier 0
3773056 1949276 1949276 defendant Pantere John butcher 590660 590660 Pantere, John, of Carlisle, butcher 1
3773057 1949276 1949276 defendant Banys Richard yeoman 590660 590660 Banys, Richard, of Carlisle, yeoman 2
3773058 1949276 1949276 defendant Vescot Thomas yeoman 590660 590660 Vescot, Thomas, of Carlisle, yeoman 3
3798813 1957543 1957543 defendant Leigh or Leight John esq 590660 590660 Leigh or Leight, John, of Carlisle, Cumber, esq 0
3800263 1958003 1958003 plaintiff Tomson John merchant 590660 590660 Tomson, John, of Carlisle, merchant 1
3801258 1958317 1958317 defendant Dawson Edward gent 590660 590660 Dawson, Edward, of Carlisle, gent 0
3801259 1958317 1958317 defendant Sewell Thomas yeoman 590660 590660 Sewell, Thomas, of Carlisle, yeoman 1
3803210 1958907 1958907 defendant Talantyre Henry tanner 590660 590660 Talantyre, Henry, of Carlisle, tanner 0
3817819 1963484 1963484 plaintiff Tomson John merchant 590660 590660 Tomson, John, of Carlisle, merchant 1
3844494 1971819 1971819 defendant Syds Christopher yeoman 590660 590660 Syds, Christopher, of Carlisle, yeoman 12
3844495 1971819 1971819 defendant Barn Edward yeoman 590660 590660 Barn, Edward, of Carlisle, yeoman 13
3844496 1971819 1971819 defendant Fallder Thomas yeoman 590660 590660 Fallder, Thomas, of Carlisle, yeoman 14
3844497 1971819 1971819 defendant Rychardson William yeoman 590660 590660 Rychardson, William, of Carlisle, yeoman 15
3844498 1971819 1971819 defendant Hereman Thomas yeoman 590660 590660 Hereman, Thomas, of Carlisle, yeoman 16
3844499 1971819 1971819 defendant Clementson Robert yeoman 590660 590660 Clementson, Robert, of Carlisle, yeoman 17
3844500 1971819 1971819 defendant Stoddert Nicholas yeoman 590660 590660 Stoddert, Nicholas, of Carlisle, yeoman 18
3844501 1971819 1971819 defendant Person William yeoman 590660 590660 Person, William, of Carlisle, yeoman 19
3856470 1975650 1975650 defendant Awelton Clement esq 590660 590660 Awelton, Clement, of Carlisle, Cumber, esq 0
3901794 1990822 1990822 defendant Bleverhassett Edward (legal representative) 590660 590660 Bleverhassett, Edward, of Carlisle, gent, executors of 0
3901795 1990822 1990822 defendant Baverhassett John merchant 590660 590660 Baverhassett, John, of Carlisle, merchant 1
3926241 1999101 1999101 plaintiff Dalston Thomas esq 590660 590660 Dalston, Thomas, of Carlisle, Cumber, esq 0
3931575 2000859 2000859 plaintiff Dowson Edward merchant 590660 590660 Dowson, Edward, of Carlisle, merchant 0
3931577 2000859 2000859 defendant Stanwix James draper 590660 590660 Stanwix, James, of Carlisle, draper 1
3945928 2005655 2005655 defendant Hewett John draper 590660 590660 Hewett, John, of Carlisle, draper 2
3949618 2006941 2006941 defendant Dalton Robert merchant 590660 590660 Dalton, Robert, of Carlisle, Cumber, merchant 0
3957483 2009681 2009681 defendant Barns Thomas merchant 590660 590660 Barns, Thomas, of Carlisle, Cumber, merchant 0
3962345 2011414 2011414 defendant Monke Mathew merchant 590660 590660 Monke, Mathew, of Carlisle, Cumber, merchant 0
3972351 2014901 2014901 defendant Mulcaster Robert   590660 590660 Mulcaster, Robert, of Carlisle, Cumber, or of Clements Inn, Middx gent 0
3979077 2017268 2017268 defendant Sharp Robert merchant 590660 590660 Sharp, Robert, of Carlisle, merchant 0
3985450 2019558 2019558 defendant Collyer Robert yeoman 590660 590660 Collyer, Robert, of Carlisle, Cumber, yeoman 0
3985451 2019558 2019558 defendant Stephenson Robert tailor 590660 590660 Stephenson, Robert, of Carlisle, tailor 1
3985452 2019558 2019558 defendant Wylkynson Thomas goldsmith 590660 590660 Wylkynson, Thomas, of Carlisle, goldsmith 2
4018007 2031157 2031157 defendant James Achilles gent 590660 590660 James, Achilles, of Carlisle, Cumber, gent 0
4018008 2031157 2031157 defendant Mulcaster Robert gent 590660 590660 Mulcaster, Robert, of Carlisle, gent 1
4018009 2031157 2031157 defendant Barne Thomas merchant 590660 590660 Barne, Thomas, of Carlisle, merchant 2
4018036 2031167 2031167 defendant Boke Richard chapman 590660 590660 Boke, Richard, of Carlisle, Cumber, chapman 0
4018043 2031170 2031170 defendant Barnes Thomas merchant 590660 590660 Barnes, Thomas, of Carlisle, merchant 1
4023346 2033059 2033059 defendant Warcope John gent 590660 590660 Warcope, John, of Carlisle, gent 0
4023349 2033060 2033060 defendant Warcope John gent 590660 590660 Warcope, John, of Carlisle, gent 0
4025523 2033783 2033783 defendant Burton Thomas gent 590660 590660 Burton, Thomas, of Carlisle, Cumber, gent 3
4025529 2033784 2033784 defendant Burton Thomas gent 590660 590660 Burton, Thomas, of Carlisle, Cumber, gent 3
4038151 2038284 2038284 defendant Sharpe James chapman 590660 590660 Sharpe, James, of Carlisle, Cumber, chapman 1
4045435 2040819 2040819 defendant Burton Thomas gent 590660 590660 Burton, Thomas, of Carlisle, Cumber, gent 0
4056794 2044813 2044813 defendant Scotte Robert chapman 590660 590660 Scotte, Robert, of Carlisle, Cumber, chapman 0
4063881 2047364 2047364 defendant Corwen Thomas gent 590660 590660 Corwen, Thomas, of Carlisle, gent 3
4066602 2048350 2048350 defendant Mouncke Alexander vintner 590660 590660 Mouncke, Alexander, of Carlisle, Cumber, vintner 0
4066603 2048350 2048350 defendant Mouncke Thomas vintner 590660 590660 Mouncke, Thomas, of Carlisle, vintner 1
4067773 2048786 2048786 defendant Bushbye Thomas yeoman 590660 590660 Bushbye, Thomas, of Carlisle, Cumber, yeoman 0
4068684 2049088 2049088 defendant Moyser Lancelot glover 590660 590660 Moyser, Lancelot, of Carlisle, glover 3
4068685 2049088 2049088 defendant Dawson John cutler 590660 590660 Dawson, John, of Carlisle, cutler 4
4076513 2051895 2051895 defendant Curwen Thomas gent 590660 590660 Curwen, Thomas, of Carlisle, Cumber, gent 0
4080869 2053468 2053468 defendant Monke Mathew merchant 590660 590660 Monke, Mathew, of Carlisle, Cumber, merchant 0
4084455 2054716 2054716 defendant Munck Thomas yeoman 590660 590660 Munck, Thomas, of Carlisle, Cumber, yeoman 0
4097902 2059581 2059581 defendant Grayme Thomas tailor 590660 590660 Grayme, Thomas, of Carlisle, tailor 0
4097903 2059581 2059581 defendant Muncke Mathew merchant 590660 590660 Muncke, Mathew, of Carlisle, merchant 1
4097904 2059581 2059581 defendant Booke John chapman 590660 590660 Booke, John, of Carlisle, chapman 2
4097905 2059581 2059581 defendant Pattenson William merchant 590660 590660 Pattenson, William, of Carlisle, merchant 3
4097907 2059582 2059582 defendant Grayme Thomas tailor 590660 590660 Grayme, Thomas, of Carlisle, tailor 0
4097908 2059582 2059582 defendant Muncke Mathew merchant 590660 590660 Muncke, Mathew, of Carlisle, merchant 1
4097909 2059582 2059582 defendant Booke John chapman 590660 590660 Booke, John, of Carlisle, chapman 2
4097910 2059582 2059582 defendant Pattenson William merchant 590660 590660 Pattenson, William, of Carlisle, merchant 3
4097912 2059583 2059583 defendant Muncke Alexander merchant 590660 590660 Muncke, Alexander, of Carlisle, merchant 0
4097913 2059583 2059583 defendant Scott Thomas weaver 590660 590660 Scott, Thomas, of Carlisle, weaver 1
4097914 2059583 2059583 defendant Lowden Alexander   590660 590660 Lowden, Alexander, of Carlisle, clerk, petty canon of Carlisle Cathedral 2
4097915 2059583 2059583 defendant Pattenson Cuthbert merchant 590660 590660 Pattenson, Cuthbert, of Carlisle, merchant 3
4097917 2059584 2059584 defendant Muncke Alexander merchant 590660 590660 Muncke, Alexander, of Carlisle, merchant 0
4097918 2059584 2059584 defendant Scott Thomas weaver 590660 590660 Scott, Thomas, of Carlisle, weaver 1
4097919 2059584 2059584 defendant Lowdeyne Alexander   590660 590660 Lowdeyne, Alexander, of Carlisle, clerk, petty canon of Carlisle Cathedral 2
4097920 2059584 2059584 defendant Pattenson Cuthbert merchant 590660 590660 Pattenson, Cuthbert, of Carlisle, merchant 3
4105131 2062108 2062108 defendant Barnes Thomas chapman 590660 590660 Barnes, Thomas, of Carlisle, Cumber, chapman 0
4105132 2062108 2062108 defendant Barnes Thomas merchant 590660 590660 Barnes, Thomas, of Carlisle, merchant 1
4109477 2063652 2063652 plaintiff Robson Richard (legal representative) 590660 590660 Robson, Richard, of Carlisle, Cumber, glover, executors of 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);