names

235 rows where place_id = 588420

✎ 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
3594474 1865900 1865900 plaintiff Kylham William yeoman 588420 588420 Kylham, William, of Holme, yeoman 0
3617347 1873047 1873047 defendant Eyre Roger gent 588420 588420 Eyre, Roger, of Holme, gent 0
3617349 1873048 1873048 defendant Eyre Roger gent 588420 588420 Eyre, Roger, of Holme, gent 0
3633091 1905161 1905161 defendant Barton Ralph (legal representative) 588420 588420 Barton, Ralph, of Holme, esq, executors of 0
3646410 1909273 1909273 defendant Colynson Robert husbandman 588420 588420 Colynson, Robert, of Holme, husbandman 0
3646958 1909448 1909448 defendant Howes William chaplain 588420 588420 Howes, William, of Holme, chaplain 0
3656444 1912262 1912262 plaintiff Chamber Robert   588420 588420 Chamber, Robert, of Holme, abbot of the Monastery of the Blessed Mary 0
3659716 1913290 1913290 defendant Whyte Richard gent 588420 588420 Whyte, Richard, of Holme, gent 0
3689279 1922809 1922809 defendant Hygden Thomas yeoman 588420 588420 Hygden, Thomas, of Holme, yeoman 1
3692801 1923939 1923939 defendant Peerson William butcher 588420 588420 Peerson, William, of Holme, butcher 0
3709268 1929197 1929197 defendant Peerson William butcher 588420 588420 Peerson, William, of Holme, butcher 0
3740653 1938937 1938937 defendant Est Thomas husbandman 588420 588420 Est, Thomas, of Holme, husbandman 0
3775037 1949925 1949925 defendant Higdon Thomas pewterer 588420 588420 Higdon, Thomas, of Holme, pewterer 1
3795139 1956344 1956344 defendant Mortymer William chaplain 588420 588420 Mortymer, William, of Holme, chaplain 0
3796940 1956923 1956923 defendant Nicholas William laborer 588420 588420 Nicholas, William, of Holme, laborer 0
3824833 1965644 1965644 defendant Berdsill George yeoman 588420 588420 Berdsill, George, of Holme, yeoman 3
3852613 1974423 1974423 defendant Dyneley Dorothy widow 588420 588420 Dyneley, Dorothy, of Holme, widow 1
3858590 1976359 1976359 defendant Ussher Richard husbandman 588420 588420 Ussher, Richard, of Holme, husbandman 0
3866177 1978916 1978916 defendant Wygham Thomas mariner 588420 588420 Wygham, Thomas, of Holme, mariner 0
3875555 1982061 1982061 defendant Todd John yeoman 588420 588420 Todd, John, of Holme, yeoman 0
3893755 1988130 1988130 defendant Peerson William butcher 588420 588420 Peerson, William, of Holme, butcher 0
3893756 1988130 1988130 defendant Peerson Andrew husbandman 588420 588420 Peerson, Andrew, of Holme, husbandman 1
3905354 1992059 1992059 plaintiff Kervyle Humphrey (legal representative) 588420 588420 Kervyle, Humphrey, of Holme, gent, executors of 0
3906603 1992502 1992502 defendant Bukkyll Edward husbandman 588420 588420 Bukkyll, Edward, of Holme, husbandman 1
3921661 1997589 1997589 defendant Tompson Robert glover 588420 588420 Tompson, Robert, of Holme, glover 0
3921662 1997589 1997589 defendant Ryght Robert husbandman 588420 588420 Ryght, Robert, of Holme, husbandman 1
3921663 1997589 1997589 defendant Skye William husbandman 588420 588420 Skye, William, of Holme, husbandman 2
3924975 1998669 1998669 defendant Boradale Gavin clerk 588420 588420 Boradale, Gavin, of Holme Cultran, Cumber, clerk 1
3937139 2002754 2002754 defendant Peerson William husbandman 588420 588420 Peerson, William, of Holme, husbandman 5
3940871 2003955 2003955 defendant Stone Richard yeoman 588420 588420 Stone, Richard, of Holme, yeoman 1
3940880 2003956 2003956 defendant Stone Richard yeoman 588420 588420 Stone, Richard, of Holme, yeoman 1
3965229 2012450 2012450 defendant ap Rees Richard husbandman 588420 588420 ap Rees, Richard, of Holme, husbandman 3
3986112 2019805 2019805 plaintiff Welche Edward husbandman 588420 588420 Welche, Edward, of Holme, husbandman 0
3986115 2019806 2019806 plaintiff Welche Edward husbandman 588420 588420 Welche, Edward, of Holme, husbandman 0
3986118 2019807 2019807 plaintiff Welche Edward husbandman 588420 588420 Welche, Edward, of Holme, husbandman 0
4015677 2030305 2030305 defendant Dalton Robert tailor 588420 588420 Dalton, Robert, of Holme, tailor 1
4016175 2030484 2030484 plaintiff Stebbyng or Steppyng John husbandman 588420 588420 Stebbyng or Steppyng, John, of Holme, husbandman 0
4035807 2037480 2037480 plaintiff Hopkynson Edward gent 588420 588420 Hopkynson, Edward, of Holme, gent 0
4179497 2088306 2088306 defendant Ellys Anthony gent 588420 588420 Ellys, Anthony, of Holme, gent 0
4179498 2088306 2088306 defendant Hudson Thomas yeoman 588420 588420 Hudson, Thomas, of Holme, yeoman 1
4192285 2092863 2092863 defendant Morton Richard husbandman 588420 588420 Morton, Richard, of Holme, husbandman 0
4193942 2093442 2093442 defendant Golde John yeoman 588420 588420 Golde, John, of Holme, yeoman 2
4201744 2096156 2096156 defendant Golde John yeoman 588420 588420 Golde, John, of Holme, yeoman 1
4201745 2096156 2096156 defendant Golde Robert yeoman 588420 588420 Golde, Robert, of Holme, yeoman 2
4212530 2099924 2099924 defendant Golde William yeoman 588420 588420 Golde, William, of Holme, yeoman 1
4218331 2101908 2101908 defendant Rowley Thomas yeoman 588420 588420 Rowley, Thomas, of Holme, yeoman 0
4237021 2108529 2108529 defendant Golde William yeoman 588420 588420 Golde, William, of Holme, yeoman 0
4245630 2111519 2111519 defendant Golde William yeoman 588420 588420 Golde, William, of Holme, yeoman 0
4277820 2122168 2122168 defendant Brackenburie Anthony gent 588420 588420 Brackenburie, Anthony, of Holme, gent 0
4285235 2124770 2124770 defendant Ingram John gent 588420 588420 Ingram, John, of Holme, gent 2
4299020 2129744 2129744 defendant Dale Mathew gent 588420 588420 Dale, Mathew, of Holme, gent 0
4303573 2131375 2131375 defendant Fynche Robert yeoman 588420 588420 Fynche, Robert, of Holme, yeoman 0
4305936 2132214 2132214 defendant Railton Edward yeoman 588420 588420 Railton, Edward, of Holme Coultrain, Cumber, yeoman 0
4310775 2133911 2133911 defendant Lawton Randolph clothworker 588420 588420 Lawton, Randolph, of Holme, clothworker 3
4311642 2134215 2134215 defendant Peandreth or Peandragh Lawrence husbandman 588420 588420 Peandreth or Peandragh, Lawrence, of Holme, husbandman 0
4311643 2134215 2134215 defendant Peandreth or Peandraghe John husbandman 588420 588420 Peandreth or Peandraghe, John, of Holme, husbandman 1
4314571 2135210 2135210 defendant Bullocke Thomas yeoman 588420 588420 Bullocke, Thomas, of Holme, yeoman 0
4315084 2135391 2135391 defendant Tammes Stephen laborer 588420 588420 Tammes, Stephen, of Holme, laborer 1
4315800 2135636 2135636 defendant Aughtenthwaite John husbandman 588420 588420 Aughtenthwaite, John, of Holme, husbandman 0
4315805 2135637 2135637 defendant Aughtenthwaite John husbandman 588420 588420 Aughtenthwaite, John, of Holme, husbandman 0
4322867 2138064 2138064 defendant Musgrave Leonard gent 588420 588420 Musgrave, Leonard, of Holme, gent 0
4322868 2138064 2138064 defendant Musgrave Cuthbert gent 588420 588420 Musgrave, Cuthbert, of Holme, gent 1
4324260 2138513 2138513 defendant Railton Christopher yeoman 588420 588420 Railton, Christopher, of Holme Cultram, Cumber, yeoman 0
4324267 2138515 2138515 defendant Hodgson Gawin chapman 588420 588420 Hodgson, Gawin, of Holme Colthrom, Cumber, chapman 0
4324620 2138624 2138624 defendant Lawton Randolph clothwortker 588420 588420 Lawton, Randolph, of Holme, clothwortker 3
4327461 2139506 2139506 defendant Wolfrys John (legal representative) 588420 588420 Wolfrys, John, of Holme, yeoman, executors of 0
4327462 2139506 2139506 defendant Wolfrys John yeoman 588420 588420 (Wolfrys, John, of Holme, yeoman 1
4327463 2139506 2139506 defendant Wolfrys Margaret widow 588420 588420 Wolfrys, Margaret, of Holme, widow 2
4331706 2140902 2140902 defendant Styfley Henry husbandman 588420 588420 Styfley, Henry, of Holme, husbandman 1
4355539 2149160 2149160 defendant Wekes John yeoman 588420 588420 Wekes, John, of Holme, yeoman 0
4356804 2149609 2149609 defendant Lambert Thomas gent 588420 588420 Lambert, Thomas, of Holme, gent 0
4356806 2149610 2149610 defendant Lambert Francis gent 588420 588420 Lambert, Francis, of Holme, gent 0
4359319 2150493 2150493 defendant Askewghe Hugh yeoman 588420 588420 Askewghe, Hugh, of Holme, yeoman 2
4365743 2152788 2152788 defendant Penrise Anthony yeoman 588420 588420 Penrise, Anthony, of Holme, yeoman 0
4365744 2152788 2152788 defendant Smithe William yeoman 588420 588420 Smithe, William, of Holme, yeoman 1
4365745 2152788 2152788 defendant Parker Richard yeoman 588420 588420 Parker, Richard, of Holme, yeoman 2
4365746 2152788 2152788 defendant Willson John yeoman 588420 588420 Willson, John, of Holme, yeoman 3
4370315 2154440 2154440 defendant Peander Thomas husbandman 588420 588420 Peander, Thomas, of Holme, husbandman 0
4370316 2154440 2154440 defendant Tompson Thomas husbandman 588420 588420 Tompson, Thomas, of Holme, husbandman 1
4371347 2154817 2154817 defendant Bradley John yeoman 588420 588420 Bradley, John, of Holme, or of North Muskam, Notts, yeoman 3
4374311 2155881 2155881 defendant Hodgson Gawin yeoman 588420 588420 Hodgson, Gawin, of Holme, yeoman 1
4383738 2159270 2159270 defendant Ingram Richard yeoman 588420 588420 Ingram, Richard, of Holme, yeoman 1
4388561 2160815 2160815 defendant Wylberfosse Robert yeoman 588420 588420 Wylberfosse, Robert, of Holme, yeoman 2
4388562 2160815 2160815 defendant Lambert Francis yeoman 588420 588420 Lambert, Francis, of Holme, yeoman 3
4394016 2162599 2162599 defendant Wright Christopher cooper 588420 588420 Wright, Christopher, of Holme, cooper 3
4398865 2164202 2164202 defendant Preston Jane widow 588420 588420 Preston, Jane, of Holme, widow 1
4399928 2164565 2164565 defendant Stamper John yeoman 588420 588420 Stamper, John, of Holme, yeoman 0
4399929 2164565 2164565 defendant Wilkinson John yeoman 588420 588420 Wilkinson, John, of Holme, yeoman 1
4399930 2164565 2164565 defendant Paipe Robert yeoman 588420 588420 Paipe, Robert, of Holme, yeoman 2
4399931 2164565 2164565 defendant Alonbie Edward yeoman 588420 588420 Alonbie, Edward, of Holme, yeoman 3
4408771 2167530 2167530 defendant Hodgeson Robert yeoman 588420 588420 Hodgeson, Robert, of Holme, yeoman 0
4408813 2167545 2167545 defendant Wallis Richard yeoman 588420 588420 Wallis, Richard, of Holme, yeoman 1
4410409 2168082 2168082 defendant Thomson John yeoman 588420 588420 Thomson, John, of Holme, yeoman 1
4410652 2168154 2168154 defendant Roper James yeoman 588420 588420 Roper, James, of Holme, yeoman 0
4444969 2183400 2183400 defendant Godewyne Ralph   588420 588420 Godewyne, Ralph, of Holme 4
4474246 2192597 2192597 defendant Lelham Richard   588420 588420 Lelham, Richard, of Holme 1
4475173 2192911 2192911 defendant Hastynges John   588420 588420 Hastynges, John, of Holme 0
4475175 2192911 2192911 defendant Refam William carter 588420 588420 Refam, William, of Holme, carter 2
4484495 2195843 2195843 defendant Julyan John   588420 588420 Julyan, John, of Holme 0
4484497 2195843 2195843 defendant Hawys Robert   588420 588420 Hawys, Robert, of Holme 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);