names

255 rows where place_id = 589679

✎ 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
3598397 1867128 1867128 defendant Pygon Thomas yeoman 589679 589679 Pygon, Thomas, of Knapton, yeoman 1
3604297 1869008 1869008 plaintiff Glaswryght alias Skeynesburgh Thomas   589679 589679 Glaswryght alias Skeynesburgh, Thomas, of Knapton, wool chapman 0
3606752 1869787 1869787 defendant Pygon Thomas yeoman 589679 589679 Pygon, Thomas, of Knapton, yeoman 0
3616439 1872778 1872778 defendant Smyth Thomas butcher 589679 589679 Smyth, Thomas, of Knapton, butcher 1
3628738 1903866 1903866 defendant Watson John, junior husbandman 589679 589679 Watson, John, junior, of Knapton, husbandman 0
3647627 1909643 1909643 defendant Mawe Robert weaver 589679 589679 Mawe, Robert, of Knapton, weaver 0
3647628 1909643 1909643 defendant Mawe Thomas weaver 589679 589679 Mawe, Thomas, of Knapton, weaver 1
3647629 1909643 1909643 defendant Hogeson Lawrence carpenter 589679 589679 Hogeson, Lawrence, of Knapton, carpenter 2
3652792 1911195 1911195 defendant Mawe Robert weaver 589679 589679 Mawe, Robert, of Knapton, weaver 0
3664479 1914838 1914838 defendant Smyth Clement husbandman 589679 589679 Smyth, Clement, of Knapton, husbandman 0
3668090 1915963 1915963 plaintiff Alen Robert   589679 589679 Alen, Robert, of Knapton 0
3668092 1915963 1915963 defendant Stebyrd John yeoman 589679 589679 Stebyrd, John, of Knapton, yeoman 0
3670426 1916706 1916706 defendant Smythe Clement husbandman 589679 589679 Smythe, Clement, of Knapton, husbandman 2
3670987 1916899 1916899 defendant Atfen John laborer 589679 589679 Atfen, John, of Knapton, laborer 1
3680707 1920047 1920047 defendant Baker Thomas butcher 589679 589679 Baker, Thomas, of Knapton, butcher 1
3680708 1920047 1920047 defendant Baker John butcher 589679 589679 Baker, John, of Knapton, butcher 2
3680763 1920064 1920064 defendant Stubbard John husbandman 589679 589679 Stubbard, John, of Knapton, husbandman 0
3681597 1920336 1920336 plaintiff Smyth Thomas   589679 589679 Smyth, Thomas, of Knapton 1
3681598 1920336 1920336 defendant Baker Thomas butcher 589679 589679 Baker, Thomas, of Knapton, butcher 0
3681599 1920336 1920336 defendant Baker John laborer 589679 589679 Baker, John, of Knapton, laborer 1
3683639 1921014 1921014 defendant Hynde Nicholas husbandman 589679 589679 Hynde, Nicholas, of Knapton, husbandman 1
3686639 1921974 1921974 defendant Smyth Clement husbandman 589679 589679 Smyth, Clement, of Knapton, husbandman 0
3686789 1922024 1922024 defendant Smythe Clement husbandman 589679 589679 Smythe, Clement, of Knapton, husbandman 0
3687490 1922267 1922267 defendant Stubberd John husbandman 589679 589679 Stubberd, John, of Knapton, husbandman 0
3695228 1924725 1924725 defendant Smyth Clement husbandman 589679 589679 Smyth, Clement, of Knapton, husbandman 0
3695229 1924725 1924725 defendant Stubberd John husbandman 589679 589679 Stubberd, John, of Knapton, husbandman 1
3701896 1926846 1926846 defendant Smyth Clement laborer 589679 589679 Smyth, Clement, of Knapton, laborer 2
3701897 1926846 1926846 defendant Aleyn Gregory butcher 589679 589679 Aleyn, Gregory, of Knapton, butcher 3
3702407 1927011 1927011 defendant Henryson or Herryson John husbandman 589679 589679 Henryson or Herryson, John, of Knapton, husbandman 0
3702861 1927168 1927168 defendant Hunt William yeoman 589679 589679 Hunt, William, of Knapton, yeoman 0
3705893 1928127 1928127 defendant Stubberd John husbandman 589679 589679 Stubberd, John, of Knapton, husbandman 0
3715252 1931056 1931056 defendant Fenne Edmund butcher 589679 589679 Fenne, Edmund, of Knapton, butcher 1
3718773 1932150 1932150 defendant Steberd John husbandman 589679 589679 Steberd, John, of Knapton, husbandman 0
3727121 1934752 1934752 defendant Steberd John husbandman 589679 589679 Steberd, John, of Knapton, husbandman 0
3727123 1934753 1934753 defendant Steberd John husbandman 589679 589679 Steberd, John, of Knapton, husbandman 0
3745369 1940458 1940458 defendant Fenne John butcher 589679 589679 Fenne, John, of Knapton, butcher 0
3752108 1942581 1942581 defendant Smyth Clement husbandman 589679 589679 Smyth, Clement, of Knapton, husbandman 0
3821285 1964548 1964548 defendant Stubberd John husbandman 589679 589679 Stubberd, John, of Knapton, husbandman 0
3825837 1965929 1965929 plaintiff Aleyn Gregory   589679 589679 Aleyn, Gregory, of Knapton 0
3829395 1967082 1967082 defendant Hornyngton John husbandman 589679 589679 Hornyngton, John, of Knapton, husbandman 2
3837935 1969778 1969778 defendant Hynde John husbandman 589679 589679 Hynde, John, of Knapton, husbandman 0
3837942 1969780 1969780 defendant Hynde John husbandman 589679 589679 Hynde, John, of Knapton, husbandman 0
3842716 1971254 1971254 defendant Fen John husbandman 589679 589679 Fen, John, of Knapton, husbandman 0
3842930 1971323 1971323 plaintiff Cady Edmund husbandman 589679 589679 Cady, Edmund, of Knapton, husbandman 0
3846533 1972472 1972472 defendant Fenne John husbandman 589679 589679 Fenne, John, of Knapton, husbandman 4
3852799 1974481 1974481 defendant Andrewes Richard husbandman 589679 589679 Andrewes, Richard, of Knapton, husbandman 3
3853610 1974758 1974758 defendant Kecham Nicholas yeoman 589679 589679 Kecham, Nicholas, of Knapton, yeoman 0
3862761 1977738 1977738 defendant Algar Henry   589679 589679 Algar, Henry, of Knapton, wheelwright 0
3866713 1979100 1979100 defendant Cutler William clerk 589679 589679 Cutler, William, of Knapton, clerk 0
3868392 1979667 1979667 defendant Stybberd William husbandman 589679 589679 Stybberd, William, of Knapton, husbandman 0
3868393 1979667 1979667 defendant Kecham Adam husbandman 589679 589679 Kecham, Adam, of Knapton, husbandman 1
3868726 1979780 1979780 defendant Stubberd John husbandman 589679 589679 Stubberd, John, of Knapton, husbandman 3
3868967 1979862 1979862 defendant Ansley George yeoman 589679 589679 Ansley, George, of Knapton, yeoman 0
3869846 1980161 1980161 defendant Algate Henry   589679 589679 Algate, Henry, of Knapton, cartwright 0
3870965 1980540 1980540 defendant Farman Thomas husbandman 589679 589679 Farman, Thomas, of Knapton, husbandman 2
3878163 1982942 1982942 defendant Cutler William clerk 589679 589679 Cutler, William, of Knapton, clerk 6
3892365 1987697 1987697 defendant Grene Thomas yeoman 589679 589679 Grene, Thomas, of Knapton, yeoman 0
3894001 1988211 1988211 defendant Tutty William chapman 589679 589679 Tutty, William, of Knapton, chapman 0
3894007 1988212 1988212 defendant Tutty William chapman 589679 589679 Tutty, William, of Knapton, chapman 0
3896756 1989126 1989126 defendant Marche Giles yeoman 589679 589679 Marche, Giles, of Knapton, yeoman 2
3899947 1990201 1990201 defendant Algore Henry   589679 589679 Algore, Henry, of Knapton, wheelwright 0
3905257 1992025 1992025 defendant Fenne John butcher 589679 589679 Fenne, John, of Knapton, butcher 0
3906922 1992603 1992603 defendant Chapman James husbandman 589679 589679 Chapman, James, of Knapton, husbandman 0
3910102 1993687 1993687 defendant Wellys John husbandman 589679 589679 Wellys, John, of Knapton, husbandman 0
3910103 1993687 1993687 defendant Cokkeman Edward husbandman 589679 589679 Cokkeman, Edward, of Knapton, husbandman 1
3910729 1993906 1993906 defendant Grene Thomas yeoman 589679 589679 Grene, Thomas, of Knapton, yeoman 0
3914424 1995168 1995168 defendant Mannyng William husbandman 589679 589679 Mannyng, William, of Knapton, husbandman 1
3917643 1996257 1996257 defendant Algar Henry   589679 589679 Algar, Henry, of Knapton, wheel wright 1
3924341 1998449 1998449 plaintiff Thymbylthorp Robert gent 589679 589679 Thymbylthorp, Robert, of Knapton, gent 0
3924656 1998561 1998561 defendant Flyght James husbandman 589679 589679 Flyght, James, of Knapton, husbandman 1
3951191 2007484 2007484 defendant Fenne Christopher butcher 589679 589679 Fenne, Christopher, of Knapton, butcher 0
3951192 2007484 2007484 defendant Fenne John husbandman 589679 589679 Fenne John, of Knapton, husbandman 1
3951194 2007485 2007485 defendant Fenne Christopher butcher 589679 589679 Fenne, Christopher, of Knapton, butcher 0
3951195 2007485 2007485 defendant Fenne John husbandman 589679 589679 Fenne, John, of Knapton, husbandman 1
3951542 2007594 2007594 defendant Kynge John butcher 589679 589679 Kynge, John, of Knapton, butcher 1
3989749 2021077 2021077 defendant Bretton Humphrey gent 589679 589679 Bretton, Humphrey, of Knapton, gent 1
3990663 2021412 2021412 defendant Bretten Thomas gent 589679 589679 Bretten, Thomas, of Knapton, gent 0
3991866 2021846 2021846 defendant Bretton Thomas gent 589679 589679 Bretton, Thomas, of Knapton, gent 0
4007714 2027545 2027545 defendant Lorymer Joan widow 589679 589679 Lorymer, Joan, of Knapton, widow 0
4007715 2027545 2027545 defendant Cartwright William husbandman 589679 589679 Cartwright, William, of Knapton, husbandman 1
4007716 2027545 2027545 defendant Smythe Thomas yeoman 589679 589679 Smythe, Thomas, of Knapton, yeoman 2
4007717 2027545 2027545 defendant Smythe Constance widow 589679 589679 Smythe, Constance, of Knapton, widow 3
4016927 2030755 2030755 defendant Bretton Thomas gent 589679 589679 Bretton, Thomas, of Knapton, gent 2
4017335 2030906 2030906 defendant Bretton Humphrey gent 589679 589679 Bretton, Humphrey, of Knapton, gent 0
4017339 2030908 2030908 defendant Grene Richard clerk 589679 589679 Grene, Richard, of Knapton, clerk 0
4017425 2030937 2030937 defendant Bretten Thomas gent 589679 589679 Bretten, Thomas, of Knapton, gent 0
4017427 2030938 2030938 defendant Bretten Thomas gent 589679 589679 Bretten, Thomas, of Knapton, gent 0
4017767 2031064 2031064 defendant Bretten Thomas gent 589679 589679 Bretten, Thomas, of Knapton, gent 0
4020825 2032175 2032175 defendant Hewes Alban gent 589679 589679 Hewes, Alban, of Knapton, gent 0
4021309 2032347 2032347 defendant Burye Robert clerk 589679 589679 Burye, Robert, of Knapton, clerk 2
4023872 2033240 2033240 defendant Huse Albam gent 589679 589679 Huse, Albam, of Knapton, gent 1
4023873 2033240 2033240 defendant Relyne John husbandman 589679 589679 Relyne, John, of Knapton, husbandman 2
4025216 2033681 2033681 defendant Hewse Alban gent 589679 589679 Hewse, Alban, of Knapton, gent 0
4026142 2033995 2033995 defendant Kecham John husbandman 589679 589679 Kecham, John, of Knapton, husbandman 0
4026143 2033995 2033995 defendant Relyng Robert husbandman 589679 589679 Relyng, Robert, of Knapton, husbandman 1
4026145 2033996 2033996 defendant Kecham John husbandman 589679 589679 Kecham, John, of Knapton, husbandman 0
4026146 2033996 2033996 defendant Relynge Robert husbandman 589679 589679 Relynge, Robert, of Knapton, husbandman 1
4026983 2034302 2034302 defendant Huse Alban gent 589679 589679 Huse, Alban, of Knapton, gent 2
4026984 2034302 2034302 defendant Bretton Thomas gent 589679 589679 Bretton, Thomas, of Knapton, gent 3
4026988 2034303 2034303 defendant Huse Alban gent 589679 589679 Huse, Alban, of Knapton, gent 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);