names

448 rows where place_id = 586121

✎ 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
3587981 1863894 1863894 defendant Upgate Roger husbandman 586121 586121 Upgate, Roger, of Carleton, husbandman 1
3605703 1869447 1869447 defendant Langwath Margaret widow 586121 586121 (Langwath, Margaret, of Carleton, widow 1
3605704 1869447 1869447 defendant Langwath Robert husbandman 586121 586121 Langwath, Robert, of Carleton, husbandman 2
3613066 1871738 1871738 defendant Palmer John gent 586121 586121 Palmer, John, of Carleton, gent 0
3613067 1871738 1871738 defendant Palmer Thomas gent 586121 586121 Palmer, Thomas, of Carleton, gent 1
3624752 1875277 1875277 defendant Gillison William husbandman 586121 586121 Gillison, William, of Carleton, husbandman 0
3627105 1903339 1903339 defendant Pyle John husbandman 586121 586121 Pyle, John, of Carleton, husbandman 1
3636587 1906234 1906234 defendant Lonnesdale William husbandman 586121 586121 Lonnesdale, William, of Carleton, husbandman 2
3648132 1909811 1909811 defendant Halywell William weaver 586121 586121 Halywell, William, of Carleton, weaver 0
3648133 1909811 1909811 defendant Ingram Robert weaver 586121 586121 Ingram, Robert, of Carleton, weaver 1
3648134 1909811 1909811 defendant Ingram Richard weaver 586121 586121 Ingram, Richard, of Carleton, weaver 2
3648135 1909811 1909811 defendant Melros John husbandman 586121 586121 Melros, John, of Carleton, husbandman 3
3648136 1909811 1909811 defendant Haliwell Robert weaver 586121 586121 Haliwell, Robert, of Carleton, weaver 4
3648873 1910037 1910037 defendant Sysson Ralph husbandman 586121 586121 Sysson, Ralph, of Carleton, husbandman 0
3654944 1911807 1911807 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 1
3655011 1911831 1911831 defendant Barons John   586121 586121 Barons, John, of Carleton 2
3667854 1915887 1915887 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 1
3671585 1917097 1917097 defendant Knyght John yeoman 586121 586121 Knyght, John, of Carleton, yeoman 0
3672704 1917465 1917465 defendant Carnon John gent 586121 586121 Carnon, John, of Carleton, gent 0
3673113 1917601 1917601 defendant Hudson Nicholas laborer 586121 586121 Hudson, Nicholas, of Carleton, laborer 1
3678236 1919246 1919246 defendant Stertevant William yeoman 586121 586121 Stertevant, William, of Carleton, yeoman 0
3691012 1923352 1923352 defendant Pygeon John husbandman 586121 586121 Pygeon, John, of Carleton, husbandman 0
3698352 1925704 1925704 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 0
3698353 1925704 1925704 defendant Smyth Henry yeoman 586121 586121 Smyth, Henry, of Carleton, yeoman 1
3709708 1929348 1929348 plaintiff Reve Nicholas (legal representative) 586121 586121 Reve, Nicholas, of Carleton, executor of 0
3709713 1929349 1929349 plaintiff Reve Nicholas (legal representative) 586121 586121 Reve, Nicholas, of Carleton, executor of 0
3722608 1933330 1933330 defendant Humfrey Edward gent 586121 586121 Humfrey, Edward, of Carleton, gent 2
3730287 1935704 1935704 defendant Ponyent Thomas husbandman 586121 586121 Ponyent, Thomas, of Carleton, husbandman 1
3730288 1935704 1935704 defendant French John husbandman 586121 586121 French, John, of Carleton, husbandman 2
3730289 1935704 1935704 defendant French Robert husbandman 586121 586121 French, Robert, of Carleton, husbandman 3
3732172 1936299 1936299 plaintiff Constable William   586121 586121 Constable, William, of Carleton, knight 0
3740028 1938735 1938735 defendant Smyth John husbandman 586121 586121 Smyth, John, of Carleton, husbandman 0
3742017 1939371 1939371 defendant Edwarde Edward husbandman 586121 586121 Edwarde, Edward, of Carleton, husbandman 2
3764663 1946611 1946611 defendant Morgan Nicholas   586121 586121 Morgan, Nicholas, of Carleton 0
3783661 1952650 1952650 defendant Carter Richard husbandman 586121 586121 Carter, Richard, of Carleton, husbandman 2
3802648 1958724 1958724 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 0
3802650 1958725 1958725 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 0
3803531 1959011 1959011 defendant More Thomas husbandman 586121 586121 More, Thomas, of Carleton, husbandman 1
3806311 1959889 1959889 defendant Huchon Brian yeoman 586121 586121 Huchon, Brian, of Carleton, yeoman 1
3806312 1959889 1959889 defendant Frere Henry yeoman 586121 586121 Frere, Henry, of Carleton, yeoman 2
3806313 1959889 1959889 defendant Palmer Richard carpenter 586121 586121 Palmer, Richard, of Carleton, carpenter 3
3806714 1959998 1959998 defendant Page Robert yeoman 586121 586121 Page, Robert, of Carleton, yeoman 2
3806718 1959999 1959999 defendant Page Robert yeoman 586121 586121 Page, Robert, of Carleton, yeoman 2
3807445 1960231 1960231 defendant Hyndes Thomas laborer 586121 586121 Hyndes, Thomas, of Carleton, laborer 3
3811606 1961525 1961525 defendant Hotthon William tanner 586121 586121 Hotthon, William, of Carleton, tanner 0
3811609 1961526 1961526 defendant Huchon William tanner 586121 586121 Huchon, William, of Carleton, tanner 0
3815020 1962618 1962618 defendant Sapcote Thomas husbandman 586121 586121 Sapcote, Thomas, of Carleton, husbandman 2
3815124 1962649 1962649 defendant Hynde Thomas husbandman 586121 586121 Hynde, Thomas, of Carleton, husbandman 0
3840880 1970716 1970716 defendant Kempe William husbandman 586121 586121 Kempe, William, of Carleton, husbandman 2
3841241 1970841 1970841 defendant Lawte Thomas husbandman 586121 586121 Lawte, Thomas, of Carleton, husbandman 2
3842833 1971292 1971292 defendant More Thomas thatcher 586121 586121 More, Thomas, of Carleton, thatcher 2
3851293 1974003 1974003 defendant Ferrand William husbandman 586121 586121 Ferrand, William, of Carleton, husbandman 0
3852314 1974323 1974323 defendant Brygges Richard husbandman 586121 586121 Brygges, Richard, of Carleton, husbandman 4
3853590 1974749 1974749 defendant Kyrton Henry husbandman 586121 586121 Kyrton, Henry, of Carleton, husbandman 1
3858455 1976303 1976303 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 0
3858457 1976304 1976304 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 0
3859779 1976771 1976771 defendant Lorde Simon husbandman 586121 586121 Lorde, Simon, of Carleton, husbandman 2
3871575 1980734 1980734 defendant Tompson Andrew husbandman 586121 586121 Tompson, Andrew, of Carleton St Peter, husbandman 1
3871576 1980734 1980734 defendant Benselyn Thomas, junior husbandman 586121 586121 Benselyn, Thomas, junior, of Carleton St Peter, husbandman 2
3874184 1981588 1981588 defendant Cowpar John husbandman 586121 586121 Cowpar, John, of Carleton, husbandman 0
3875786 1982153 1982153 defendant Rede William husbandman 586121 586121 Rede, William, of Carleton, husbandman 1
3876707 1982452 1982452 defendant Bytheree William husbandman 586121 586121 Bytheree, William, of Carleton, husbandman 2
3883197 1984643 1984643 defendant Page Richard yeoman 586121 586121 Page, Richard, of Carleton, yeoman 0
3883198 1984643 1984643 defendant Sysson Robert husbandman 586121 586121 Sysson, Robert, of Carleton, husbandman 1
3888546 1986429 1986429 defendant Hynde William husbandman 586121 586121 Hynde, William, of Carleton, husbandman 1
3893171 1987956 1987956 defendant Brystowe John husbandman 586121 586121 Brystowe, John, of Carleton, husbandman 1
3893483 1988047 1988047 defendant Brystowe John husbandman 586121 586121 Brystowe, John, of Carleton, husbandman 1
3894532 1988380 1988380 defendant Bawde John gent 586121 586121 Bawde, John, of Carleton, gent 0
3898189 1989600 1989600 defendant Sherwyn Nicholas collarmaker 586121 586121 Sherwyn, Nicholas, of Carleton, collarmaker 0
3899257 1989962 1989962 defendant Leer alias Lee John tailor 586121 586121 Leer alias Lee, John, of Carleton, tailor 0
3902854 1991188 1991188 defendant Drury John gent 586121 586121 Drury, John, of Carleton, gent 1
3905712 1992188 1992188 defendant Crabtre Robert weaver 586121 586121 Crabtre, Robert, of Carleton, weaver 0
3907664 1992853 1992853 defendant Holcatt William husbandman 586121 586121 Holcatt, William, of Carleton, husbandman 0
3908140 1993020 1993020 plaintiff Pyckard Thomas   586121 586121 Pyckard, Thomas, of Carleton 0
3919949 1997010 1997010 plaintiff Mabbys John   586121 586121 Mabbys, John, of Carleton 0
3920144 1997073 1997073 plaintiff Marrys John gent 586121 586121 Marrys, John, of Carleton, gent 0
3930796 2000646 2000646 defendant Carleton Thomas gent 586121 586121 Carleton, Thomas, of Carleton, gent 0
3936438 2002508 2002508 defendant Mabbys Robert carpenter & son 586121 586121 Mabbys, Robert, of Carleton, carpenter & son 2
3940590 2003862 2003862 defendant Pers alias Smyth William weaver 586121 586121 Pers alias Smyth, William, of Carleton, weaver 0
3941710 2004243 2004243 defendant Plowman John yeoman 586121 586121 Plowman, John, of Carleton, yeoman 0
3946681 2005904 2005904 defendant Petingare John yeoman 586121 586121 Petingare, John, of Carleton, yeoman 0
3955835 2009114 2009114 defendant Edward Robert husbandman 586121 586121 Edward, Robert, of Carleton, husbandman 0
3957684 2009747 2009747 defendant Fryer Robert husbandman 586121 586121 Fryer, Robert, of Carleton, husbandman 3
3963346 2011781 2011781 defendant Nutt Valentine husbandman 586121 586121 Nutt, Valentine, of Carleton, husbandman 0
3968777 2013707 2013707 defendant Lever Thomas yeoman 586121 586121 Lever, Thomas, of Carleton, yeoman 0
3969296 2013864 2013864 defendant Dykeman Thomas husbandman 586121 586121 Dykeman, Thomas, of Carleton, husbandman 0
3972991 2015127 2015127 defendant Yongman John butcher 586121 586121 Yongman, John, of Carleton, butcher 0
3974075 2015502 2015502 plaintiff Hargreves John yeoman 586121 586121 Hargreves, John, of Carleton, yeoman 0
3980807 2017899 2017899 defendant Rows John husbandman 586121 586121 Rows, John, of Carleton, husbandman 0
4008375 2027761 2027761 plaintiff Middleton Thomas yeoman 586121 586121 Middleton, Thomas, of Carleton, yeoman 0
4008380 2027763 2027763 plaintiff Midleton Thomas yeoman 586121 586121 Midleton, Thomas, of Carleton, yeoman 0
4018247 2031252 2031252 defendant Walker Robert gent 586121 586121 Walker, Robert, of Carleton, gent 1
4021797 2032524 2032524 defendant Nubye John husbandman 586121 586121 Nubye, John, of Carleton, husbandman 3
4038063 2038255 2038255 defendant Nyveson Thomas yeoman 586121 586121 Nyveson, Thomas, of Carleton, yeoman 2
4041262 2039363 2039363 defendant Kent Robert yeoman 586121 586121 Kent, Robert, of Carleton, yeoman 1
4044811 2040596 2040596 defendant Barbor John husbandman 586121 586121 Barbor, John, of Carleton, husbandman 1
4080425 2053310 2053310 defendant Nones or Nunnes John yeoman 586121 586121 Nones or Nunnes, John, of Carleton, yeoman 0
4080426 2053310 2053310 defendant Ferneley John yeoman 586121 586121 Ferneley, John, of Carleton, yeoman 1
4087286 2055744 2055744 plaintiff Brysbye Richard gent 586121 586121 Brysbye, Richard, of Carleton, gent 1
4087287 2055744 2055744 defendant Atkynson Anthony gent 586121 586121 Atkynson, Anthony, of Carleton, gent 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);