names

247 rows where place_id = 593911

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590858 1864771 1864771 defendant Bethom William gent 593911 593911 Bethom, William, of Penreth, Cumber, gent 0
3592969 1865424 1865424 defendant Jakson Richard mercer 593911 593911 Jakson, Richard, of Penreth, Cumber, mercer 0
3613820 1871979 1871979 defendant Tunstall Edward merchant 593911 593911 Tunstall, Edward, of Penreth, merchant 0
3613821 1871979 1871979 defendant Crakenthorp Anthony gent 593911 593911 Crakenthorp, Anthony, of Penreth, gent 1
3622292 1874506 1874506 defendant Jakson William draper 593911 593911 Jakson, William, of Penreth, Cumber, draper 2
3646334 1909245 1909245 defendant Collynson Alice widow 593911 593911 Collynson, Alice, of Penreth, Cumber, widow 1
3652793 1911196 1911196 plaintiff Watson Robert dyer 593911 593911 Watson, Robert, of Penreth, dyer 0
3793712 1955899 1955899 defendant Whelpdale John, senior gent 593911 593911 Whelpdale, John, senior, of Penreth, gent 0
3793849 1955944 1955944 plaintiff Brysby John merchant 593911 593911 Brysby, John, of Penreth, merchant 0
3799186 1957656 1957656 plaintiff Hutton John, senior   593911 593911 Hutton, John, senior, of Penreth 0
3810521 1961185 1961185 defendant Colynson Robert barber 593911 593911 Colynson, Robert, of Penreth, barber 0
3819031 1963843 1963843 defendant Beke William merchant 593911 593911 Beke, William, of Penreth, merchant 0
3820041 1964147 1964147 plaintiff Penreth Edward chaplain 593911 593911 Penreth, Edward, of Penreth, Cumber, chaplain 0
3820042 1964147 1964147 defendant Slee Robert cordwainer 593911 593911 Slee, Robert, of Penreth, cordwainer 0
3820043 1964147 1964147 defendant Bartram Robert gent 593911 593911 Bartram, Robert, of Penreth, gent 1
3820044 1964147 1964147 defendant Wylkynson John mercer 593911 593911 Wylkynson, John, of Penreth, mercer 2
3820045 1964148 1964148 plaintiff Penreth Edward chaplain 593911 593911 Penreth, Edward, of Penreth, Cumber, chaplain 0
3820046 1964148 1964148 defendant Slee Robert cordwainer 593911 593911 Slee, Robert, of Penreth, cordwainer 0
3820047 1964148 1964148 defendant Bartram Robert gent 593911 593911 Bartram, Robert, of Penreth, gent 1
3820048 1964148 1964148 defendant Wylkynson John mercer 593911 593911 Wylkynson, John, of Penreth, mercer 2
3930797 2000646 2000646 defendant Mewrowse Hugh yeoman 593911 593911 Mewrowse, Hugh, of Penreth, yeoman 1
3945540 2005515 2005515 plaintiff Braithwait William yeoman 593911 593911 Braithwait, William, of Penreth, Cumber, yeoman 0
3961052 2010959 2010959 defendant Thompson Geoffrey chapman 593911 593911 Thompson, Geoffrey, of Penreth, Cumber, chapman 0
4154948 2079828 2079828 defendant Thompson Lancelot yeoman 593911 593911 Thompson, Lancelot, of Penreth, yeoman 1
4154950 2079829 2079829 defendant Noble Hugh yeoman 593911 593911 Noble, Hugh, of Penreth, yeoman 0
4154951 2079829 2079829 defendant Gybson Henry yeoman 593911 593911 Gybson, Henry, of Penreth, yeoman 1
4154952 2079829 2079829 defendant Waterson Richard yeoman 593911 593911 Waterson, Richard, of Penreth, yeoman 2
4154953 2079829 2079829 defendant Robynson Anthony yeoman 593911 593911 Robynson, Anthony, of Penreth, yeoman 3
4154955 2079829 2079829 defendant Emontson Robert yeoman 593911 593911 together with Emontson, Robert, of Penreth, yeoman 5
4154956 2079829 2079829 defendant Barwicke Robert yeoman 593911 593911 Barwicke, Robert, of Penreth, yeoman 6
4154958 2079829 2079829 defendant Graye Michael yeoman 593911 593911 Graye, Michael, of Penreth, yeoman 8
4154959 2079829 2079829 defendant Atkynson Anthony yeoman 593911 593911 Atkynson, Anthony, of Penreth, yeoman 9
4345185 2145592 2145592 defendant Holme Thomas yeoman 593911 593911 Holme, Thomas, of Penreth, Cumber, yeoman 0
4365800 2152802 2152802 defendant Atkynson John yeoman 593911 593911 Atkynson, John, of Penreth, yeoman 0
4446199 2183722 2183722 plaintiff Dautry William   593911 593911 Dautry, William, of Penreth 0
4451980 2185603 2185603 defendant Carter Alan   593911 593911 Carter, Alan, of Penreth 0
4451982 2185604 2185604 defendant Carter Alan   593911 593911 Carter, Alan, of Penreth 0
4454191 2186326 2186326 plaintiff Loweden John de   593911 593911 Loweden, John de, of Penreth 0
4459732 2188096 2188096 defendant Curtays Adam   593911 593911 Curtays, Adam, of Penreth 2
4459751 2188102 2188102 defendant Cartays Adam   593911 593911 Cartays, Adam, of Penreth 2
4466814 2190291 2190291 defendant Arnald Thomas   593911 593911 Arnald, Thomas, of Penreth 1
4477331 2193574 2193574 defendant Glover John   593911 593911 Glover, John, of Penreth 0
4478878 2194064 2194064 defendant Arnal Thomas   593911 593911 Arnal, Thomas, of Penreth 0
4479138 2194134 2194134 defendant Scot Nicholas   593911 593911 Scot, Nicholas, of Penreth 0
4487113 2196694 2196694 defendant Scot Nicholas   593911 593911 Scot, Nicholas, of Penreth 0
4491051 2197893 2197893 defendant fourmer Thomas   593911 593911 fourmer, Thomas, of Penreth 1
4494407 2198947 2198947 defendant Scot John   593911 593911 Scot, John, of Penreth 1
4494408 2198947 2198947 defendant Holme John   593911 593911 Holme, John, of Penreth 2
4494409 2198947 2198947 defendant Bristowe John de   593911 593911 Bristowe, John de, of Penreth 3
4495499 2199274 2199274 defendant Carter John   593911 593911 Carter, John, of Penreth 0
4496691 2199634 2199634 plaintiff Crukwath Robert de   593911 593911 Crukwath, Robert de, of Penreth 0
4496694 2199634 2199634 defendant Bristowe Richard   593911 593911 Bristowe, Richard, of Penreth 2
4500326 2200726 2200726 defendant Atkynson John   593911 593911 Atkynson, John, of Penreth 0
4500410 2200746 2200746 defendant Dolfanby John de   593911 593911 Dolfanby, John de, of Penreth 5
4503916 2201785 2201785 defendant Forster John butcher 593911 593911 Forster, John, of Penreth, butcher 0
4503917 2201785 2201785 defendant Chalonner John   593911 593911 Chalonner, John, of Penreth 1
4505097 2202126 2202126 defendant Cardemaker Nicholas   593911 593911 Cardemaker, Nicholas, of penreth 3
4505811 2202322 2202322 defendant Bolton Hugh de   593911 593911 Bolton, Hugh de, of Penreth, vicar 0
4505813 2202323 2202323 defendant Bolton Hugh de   593911 593911 Bolton, Hugh de, of Penreth, vicar 0
4517294 2205809 2205809 defendant Scot John   593911 593911 Scot, John, of Penreth 2
4518201 2206065 2206065 defendant Baxster John   593911 593911 Baxster, John, of Penreth 2
4526717 2208636 2208636 defendant Baxter John   593911 593911 Baxter, John, of Penreth 0
4543195 2213757 2213757 plaintiff Arnaldson John mercer 593911 593911 Arnaldson, John, of Penreth, mercer 0
4543196 2213757 2213757 defendant Baxster John   593911 593911 Baxster, John, of Penreth 0
4543197 2213757 2213757 defendant Clapannan John   593911 593911 Clapannan, John, of Penreth 1
4543198 2213757 2213757 defendant Gilmyn John   593911 593911 Gilmyn, John, of Penreth 2
4563498 2220157 2220157 defendant Bakster John   593911 593911 Bakster, John, of Penreth 0
4577426 2224457 2224457 defendant Bolton Hugh   593911 593911 Bolton, Hugh, of Penreth, vicar 0
4578570 2224788 2224788 defendant Jonson William   593911 593911 Jonson, William, of Penreth, wright 0
4578571 2224788 2224788 defendant Denton William de   593911 593911 Denton, William de, of Penreth 1
4578572 2224788 2224788 defendant Moston John de   593911 593911 Moston, John de, of Penreth 2
4578587 2224791 2224791 defendant Smyth William   593911 593911 Smyth, William, of Penreth 3
4588099 2227676 2227676 defendant Holme John   593911 593911 Holme, John, of Penreth 1
4608307 2233709 2233709 plaintiff Bost John   593911 593911 Bost, John, of Penreth 0
4609639 2234110 2234110 defendant Everard John   593911 593911 Everard, John, of Penreth 5
4609640 2234110 2234110 defendant Smyth Hugh   593911 593911 Smyth, Hugh, of Penreth 6
4613706 2235299 2235299 defendant Sclater John   593911 593911 Sclater, John, of Penreth 0
4619870 2237194 2237194 plaintiff Hoton Thomas   593911 593911 Hoton, Thomas, of Penreth 0
4636692 2242296 2242296 defendant Warderop William mercer 593911 593911 Warderop, William, of Penreth, mercer 4
4637346 2242477 2242477 plaintiff Bost John   593911 593911 Bost, John, of Penreth 0
4643102 2244092 2244092 plaintiff Hoton Thomas   593911 593911 Hoton, Thomas, of Penreth 0
4651454 2246460 2246460 plaintiff Arlossh John   593911 593911 Arlossh, John, of Penreth 0
4651458 2246460 2246460 defendant Baxster John yeoman 593911 593911 Baxster, John, of Penreth, yeoman 3
4651459 2246461 2246461 plaintiff Arlosshe John   593911 593911 Arlosshe, John, of Penreth 0
4653201 2246937 2246937 defendant Salkok William esq 593911 593911 Salkok, William, of Penreth, Cumber, esq 0
4653415 2247001 2247001 defendant Jakson William salter 593911 593911 Jakson, William, of Penreth, Cumber, salter 1
4653416 2247001 2247001 defendant Warderop William mercer 593911 593911 Warderop, William, of Penreth, mercer 2
4654698 2247345 2247345 plaintiff Bost or Best John   593911 593911 Bost or Best, John, of Penreth 0
4654700 2247345 2247345 defendant Davyson or Danyson John quarrier 593911 593911 Davyson or Danyson, John, of Penreth, quarrier 1
4656995 2248079 2248079 defendant de Brampton William yeoman 593911 593911 de Brampton, William, of Penreth, yeoman 0
4658678 2248587 2248587 defendant de Sandes Thomas tailor 593911 593911 de Sandes, Thomas, of Penreth, tailor 1
4659226 2248758 2248758 plaintiff de Arlosshe John   593911 593911 de Arlosshe, John, of Penreth 0
4659229 2248758 2248758 defendant Salcok William gent 593911 593911 Salcok, William, of Penreth, gent 2
4659232 2248758 2248758 defendant Arnaldson Thomas yeoman 593911 593911 Arnaldson, Thomas, of Penreth, yeoman 5
4660458 2249096 2249096 defendant Jakson Thomas tailor 593911 593911 Jakson, Thomas, of Penreth, tailor 0
4660609 2249144 2249144 defendant Boweman Walter yeoman 593911 593911 Boweman, Walter, of Penreth, yeoman 1
4661972 2249584 2249584 defendant Scot Richard husbandman 593911 593911 Scot, Richard, of Penreth, Cumber, husbandman 0
4663709 2250132 2250132 defendant Bakster John chapman 593911 593911 Bakster, John, of Penreth, chapman 2
4665958 2250827 2250827 defendant Litster Joan dyer 593911 593911 Litster, Joan, of Penreth, dyer 1
4665959 2250827 2250827 defendant Grisdale John yeoman 593911 593911 Grisdale, John, of Penreth, 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);