names

449 rows where place_id = 587309

✎ 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
3591037 1864823 1864823 defendant Carton Thomas husbandman 587309 587309 Carton, Thomas, of Holbeche, husbandman 0
3600227 1867718 1867718 defendant Carton Thomas yeoman 587309 587309 Carton, Thomas, of Holbeche, yeoman 0
3606598 1869737 1869737 defendant Weller William husbandman 587309 587309 Weller, William, of Holbeche, husbandman 0
3613003 1871714 1871714 defendant Bradowe William husbandman 587309 587309 Bradowe, William, of Holbeche, husbandman 1
3618323 1873360 1873360 defendant Flete John gent 587309 587309 Flete, John, of Holbeche, gent 0
3621796 1874355 1874355 defendant Storer Thomas butcher 587309 587309 Storer, Thomas, of Holbeche, butcher 3
3623796 1874975 1874975 defendant Howeson John chaplain 587309 587309 (Howeson, John, of Holbeche, chaplain 2
3623797 1874975 1874975 defendant Botheby Robert husbandman 587309 587309 Botheby, Robert, of Holbeche, husbandman 3
3632736 1905052 1905052 defendant Flete John gent 587309 587309 Flete, John, of Holbeche, gent 0
3632737 1905052 1905052 defendant Goye Thomas husbandman 587309 587309 Goye, Thomas, of Holbeche, husbandman 1
3633022 1905148 1905148 defendant Blisset Thomas husbandman 587309 587309 Blisset, Thomas, of Holbeche, husbandman 1
3633023 1905148 1905148 defendant Fawkoner David roper 587309 587309 Fawkoner, David, of Holbeche, roper 2
3633029 1905148 1905148 defendant Geryng Henry   587309 587309 Geryng, Henry, of Holbeche, "boller" 8
3633038 1905149 1905149 defendant Blisset Thomas husbandman 587309 587309 Blisset, Thomas, of Holbeche, husbandman 1
3633039 1905149 1905149 defendant Fawkoner David roper 587309 587309 Fawkoner, David, of Holbeche, roper 2
3633045 1905149 1905149 defendant Geryng Henry   587309 587309 Geryng, Henry, of Holbeche, "boller" 8
3633128 1905172 1905172 defendant Smyth John yeoman 587309 587309 Smyth, John, of Holbeche, yeoman 0
3633129 1905172 1905172 defendant Watson Richard yeoman 587309 587309 Watson, Richard, of Holbeche, yeoman 1
3636545 1906225 1906225 defendant Bennet Thomas   587309 587309 Bennet, Thomas, of Holbeche, shepherd 1
3636546 1906225 1906225 defendant Brodyng Thomas   587309 587309 Brodyng, Thomas, of Holbeche, shepherd 2
3636547 1906225 1906225 defendant Parker Robert husbandman 587309 587309 Parker, Robert, of Holbeche, husbandman 3
3636548 1906225 1906225 defendant Maltby Richard husbandman 587309 587309 Maltby, Richard, of Holbeche, husbandman 4
3639370 1907122 1907122 defendant Flete John gent 587309 587309 Flete, John, of Holbeche, gent 0
3639379 1907126 1907126 defendant Weller William husbandman 587309 587309 Weller, William, of Holbeche, husbandman 0
3642223 1908015 1908015 defendant Wylot John laborer 587309 587309 Wylot, John, of Holbeche, laborer 0
3652726 1911173 1911173 defendant Howeson William husbandman 587309 587309 Howeson, William, of Holbeche, husbandman 2
3652727 1911173 1911173 defendant Stokes John husbandman 587309 587309 Stokes, John, of Holbeche, husbandman 3
3652728 1911173 1911173 defendant Botheby Thomas husbandman 587309 587309 Botheby, Thomas, of Holbeche, husbandman 4
3652845 1911213 1911213 defendant Flete John gent 587309 587309 Flete, John, of Holbeche, gent 0
3658718 1912981 1912981 defendant Weller William yeoman 587309 587309 Weller, William, of Holbeche, yeoman 0
3667456 1915761 1915761 defendant Hunt Thomas husbandman 587309 587309 Hunt, Thomas, of Holbeche, husbandman 0
3676559 1918710 1918710 defendant Flete John gent 587309 587309 Flete, John, of Holbeche, gent 0
3681944 1920456 1920456 defendant Weller William husbandman 587309 587309 Weller, William, of Holbeche, husbandman 2
3682279 1920555 1920555 defendant Sugar William glover 587309 587309 Sugar, William, of Holbeche, glover 0
3687444 1922253 1922253 plaintiff Clerk John (legal representative) 587309 587309 Clerk, John, of Holbeche, executors of 0
3687447 1922253 1922253 defendant Glee Margaret widow 587309 587309 Glee, Margaret, of Holbeche, widow 0
3693417 1924157 1924157 defendant Pory John sherman 587309 587309 Pory, John, of Holbeche, sherman 2
3693418 1924157 1924157 defendant Pye Thomas   587309 587309 Pye, Thomas, of Holbeche, parish clerk 3
3695886 1924949 1924949 defendant Pye Thomas husbandman 587309 587309 Pye, Thomas, of Holbeche, husbandman 0
3697415 1925411 1925411 plaintiff Sugar William glover 587309 587309 Sugar, William, of Holbeche, glover 0
3716110 1931325 1931325 defendant Calowe William yeoman 587309 587309 Calowe, William, of Holbeche, yeoman 0
3743154 1939720 1939720 defendant Betson Richard husbandman 587309 587309 Betson, Richard, of Holbeche, husbandman 0
3758750 1944725 1944725 defendant Anderton John tailor 587309 587309 Anderton, John, of Holbeche, tailor 0
3758751 1944725 1944725 defendant Weller Edmund husbandman 587309 587309 Weller, Edmund, of Holbeche, husbandman 1
3760664 1945337 1945337 defendant Wright Adam   587309 587309 Wright, Adam, of Holbeche, millwright 1
3760721 1945352 1945352 defendant Holand John husbandman 587309 587309 Holand, John, of Holbeche, husbandman 1
3764390 1946523 1946523 defendant Crane Roger husbandman 587309 587309 Crane, Roger, of Holbeche, husbandman 1
3764391 1946524 1946524 plaintiff Howell Robert   587309 587309 Howell, Robert, of Holbeche 0
3764393 1946525 1946525 plaintiff Howell Robert   587309 587309 Howell, Robert, of Holbeche 0
3766173 1947074 1947074 defendant Wadyngton William butcher 587309 587309 Wadyngton, William, of Holbeche, butcher 0
3766174 1947074 1947074 defendant Storkys John butcher 587309 587309 Storkys, John, of Holbeche, butcher 1
3772329 1949031 1949031 defendant Wadyngton William butcher 587309 587309 Wadyngton, William, of Holbeche, butcher 0
3772330 1949031 1949031 defendant Storkys John butcher 587309 587309 Storkys, John, of Holbeche, butcher 1
3787344 1953834 1953834 defendant Benet William, junior husbandman 587309 587309 Benet, William, junior, of Holbeche, husbandman 0
3795798 1956553 1956553 defendant Manby John husbandman 587309 587309 Manby, John, of Holbeche, husbandman 2
3805501 1959659 1959659 defendant Haynes Geoffrey chaplain 587309 587309 Haynes, Geoffrey, of Holbeche, chaplain 1
3822760 1965020 1965020 defendant Storkes Richard husbandman 587309 587309 Storkes, Richard, of Holbeche, husbandman 0
3840762 1970677 1970677 defendant Elman Henry yeoman 587309 587309 Elman, Henry, of Holbeche, yeoman 0
3900521 1990404 1990404 defendant Burnet William husbandman 587309 587309 Burnet, William, of Holbeche, husbandman 0
4032110 2036150 2036150 defendant Callowe William gent 587309 587309 Callowe, William, of Holbeche, gent 0
4121391 2067944 2067944 defendant Dixson Richard   587309 587309 Dixson, Richard, of Holbeche, surgeon 0
4134110 2072524 2072524 defendant Ordinge Emma widow 587309 587309 Ordinge, Emma, of Holbeche, widow 1
4181930 2089160 2089160 defendant Glover Edward yeoman 587309 587309 Glover, Edward, of Holbeche, yeoman 0
4231674 2106579 2106579 defendant Glover Edward yeoman 587309 587309 Glover, Edward, of Holbeche, yeoman 3
4232912 2107019 2107019 defendant Jackson Robert yeoman 587309 587309 Jackson, Robert, of Holbeche, yeoman 2
4233673 2107300 2107300 defendant Orden John yeoman 587309 587309 Orden, John, of Holbeche, yeoman 1
4235216 2107878 2107878 defendant Kay John gent 587309 587309 Kay, John, of Holbeche, gent 0
4235217 2107878 2107878 defendant Kay William yeoman 587309 587309 Kay, William, of Holbeche, yeoman 1
4238509 2109081 2109081 defendant Jackson Robert husbandman 587309 587309 Jackson, Robert, of Holbeche, husbandman 0
4238511 2109081 2109081 defendant Glover William gent 587309 587309 Glover, William, of Holbeche, gent 2
4283388 2124094 2124094 defendant Jackson Robert husbandman 587309 587309 Jackson, Robert, of Holbeche, husbandman 2
4287169 2125468 2125468 defendant Weste Thomas clerk 587309 587309 Weste, Thomas, of Holbeche, clerk 0
4311569 2134186 2134186 defendant Burde John carpenter 587309 587309 Burde, John, of Holbeche, carpenter 0
4361245 2151185 2151185 defendant Frende Edward husbandman 587309 587309 Frende, Edward, of Holbeche, husbandman 0
4361921 2151421 2151421 defendant Key William gent 587309 587309 Key, William, of Holbeche, gent 1
4361922 2151421 2151421 defendant Forster Nicholas gent 587309 587309 Forster, Nicholas, of Holbeche, gent 2
4361925 2151422 2151422 defendant Key William gent 587309 587309 Key, William, of Holbeche, gent 1
4361926 2151422 2151422 defendant Forster Nicholas gent 587309 587309 Forster, Nicholas, of Holbeche, gent 2
4445117 2183444 2183444 defendant Amabille Thomas   587309 587309 Amabille, Thomas, of Holbeche 1
4445119 2183445 2183445 defendant Houchonson Thomas   587309 587309 Houchonson, Thomas, of Holbeche 0
4464756 2189642 2189642 defendant Bullok John   587309 587309 Bullok, John, of Holbeche, salt weller 0
4487255 2196731 2196731 plaintiff Sibsey John   587309 587309 Sibsey, John, of Holbeche 0
4492350 2198285 2198285 plaintiff Wyse Thomas   587309 587309 Wyse, Thomas, of Holbeche 0
4492352 2198286 2198286 plaintiff Wyse Thomas   587309 587309 Wyse, Thomas, of Holbeche 0
4498609 2200206 2200206 defendant White Thomas   587309 587309 White, Thomas, of Holbeche 0
4521029 2206912 2206912 defendant Bullok Thomas   587309 587309 Bullok, Thomas, of Holbeche 0
4521030 2206912 2206912 defendant Bullok Simon chaplain 587309 587309 Bullok, Simon, of Holbeche, chaplain 1
4535593 2211409 2211409 defendant Smyth Ralph   587309 587309 Smyth, Ralph, of Holbeche 0
4550672 2216153 2216153 defendant Braytofte William   587309 587309 Braytofte, William, of Holbeche 1
4551340 2216357 2216357 plaintiff Flete John   587309 587309 Flete, John, of Holbeche 1
4570099 2222222 2222222 defendant Jonesson Sarah   587309 587309 Jonesson, Sarah, of Holbeche, formerly wife of Thomas 0
4574178 2223449 2223449 defendant Thacker Bartholomew   587309 587309 Thacker, Bartholomew, of Holbeche 0
4581038 2225548 2225548 defendant Wewelsay Robert   587309 587309 Wewelsay, Robert, of Holbeche 0
4595717 2229916 2229916 defendant Flete John de   587309 587309 Flete, John de, of Holbeche 1
4603486 2232278 2232278 defendant Walssh John   587309 587309 Walssh, John, of Holbeche 1
4603487 2232278 2232278 defendant Silf_ John   587309 587309 Silf_, John, of Holbeche 2
4639851 2243158 2243158 defendant Baxter William   587309 587309 Baxter, William, of Holbeche 6
4641311 2243552 2243552 defendant Sayere Richard   587309 587309 Sayere, Richard, of Holbeche 3
4641314 2243552 2243552 defendant Clerk Thomas   587309 587309 Clerk, Thomas, of Holbeche 6
4656228 2247839 2247839 defendant Callowe John husbandman 587309 587309 Callowe, John, of Holbeche, husbandman 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);