names

140 rows where place_id = 586480

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588829 1864154 1864154 defendant Havejoye William husbandman 586480 586480 Havejoye, William, of Leneham, husbandman 0
3615649 1872538 1872538 defendant Kyngeslond Hugh carpenter 586480 586480 Kyngeslond, Hugh, of Leneham, carpenter 0
3627870 1903575 1903575 defendant Brewston Robert chapman 586480 586480 Brewston, Robert, of Leneham, chapman 6
3627871 1903575 1903575 defendant Badnor Hugh glover 586480 586480 Badnor, Hugh, of Leneham, glover 7
3630953 1904501 1904501 defendant Meryall John yeoman 586480 586480 Meryall, John, of Leneham, yeoman 2
3633307 1905232 1905232 defendant Bealde John yeoman 586480 586480 Bealde, John, of Leneham, yeoman 2
3633308 1905232 1905232 defendant Sare Lawrence husbandman 586480 586480 Sare, Lawrence, of Leneham, husbandman 3
3635501 1905900 1905900 defendant Partryche Thomas   586480 586480 Partryche, Thomas, of Leneham 0
3644388 1908663 1908663 defendant Broode John husbandman 586480 586480 Broode, John, of Leneham, husbandman 0
3649255 1910155 1910155 defendant Alyn Thomas husbandman 586480 586480 Alyn, Thomas, of Leneham, husbandman 1
3649490 1910229 1910229 defendant Beald John, senior yeoman 586480 586480 Beald, John, senior, of Leneham, yeoman 1
3658017 1912761 1912761 defendant Myllys John, junior gent 586480 586480 Myllys, John, junior, of Leneham, gent 0
3665640 1915203 1915203 defendant Adam John husbandman 586480 586480 Adam, John, of Leneham, husbandman 3
3666001 1915301 1915301 defendant Adams John, junior husbandman 586480 586480 Adams, John, junior, of Leneham, husbandman 0
3671561 1917090 1917090 defendant Hey Lawrence husbandman 586480 586480 Hey, Lawrence, of Leneham, husbandman 0
3671562 1917090 1917090 defendant Hey John laborer 586480 586480 Hey, John, of Leneham, laborer 1
3672256 1917321 1917321 defendant Beald John husbandman 586480 586480 Beald, John, of Leneham, husbandman 0
3694173 1924383 1924383 defendant Boram David yeoman 586480 586480 Boram, David, of Leneham, yeoman 1
3694988 1924645 1924645 defendant Baker John husbandman 586480 586480 Baker, John, of Leneham, husbandman 0
3694998 1924646 1924646 defendant Crotynden Richard husbandman 586480 586480 Crotynden, Richard, of Leneham, husbandman 4
3701813 1926818 1926818 defendant Sare Stephen husbandman 586480 586480 Sare, Stephen, of Leneham, husbandman 0
3701814 1926818 1926818 defendant Bedell Richard husbandman 586480 586480 Bedell, Richard, of Leneham, husbandman 1
3708970 1929099 1929099 defendant Baker John husbandman 586480 586480 Baker, John, of Leneham, husbandman 0
3708972 1929099 1929099 defendant Crotynden Richard husbandman 586480 586480 Crotynden, Richard, of Leneham, husbandman 2
3708980 1929102 1929102 defendant Holyman John glover 586480 586480 Holyman, John, of Leneham, glover 2
3710035 1929449 1929449 defendant Dyve Thomas husbandman 586480 586480 Dyve, Thomas, of Leneham, husbandman 0
3711429 1929879 1929879 defendant Adams John, junior husbandman 586480 586480 Adams, John, junior, of Leneham, husbandman 3
3719562 1932383 1932383 defendant Hasyll John clothmaker 586480 586480 Hasyll, John, of Leneham, clothmaker 1
3732596 1936425 1936425 defendant Bedyll Richard husbandman 586480 586480 Bedyll, Richard, of Leneham, husbandman 0
3732597 1936425 1936425 defendant Lenaker Robert husbandman 586480 586480 Lenaker, Robert, of Leneham, husbandman 1
3732598 1936425 1936425 defendant Rayner Edmund husbandman 586480 586480 Rayner, Edmund, of Leneham, husbandman 2
3735556 1937356 1937356 defendant Hewet Nicholas husbandman 586480 586480 Hewet, Nicholas, of Leneham, husbandman 1
3749577 1941780 1941780 defendant Holyman John husbandman 586480 586480 Holyman, John, of Leneham, husbandman 0
3774647 1949799 1949799 defendant Balden George clothier 586480 586480 Balden, George, of Leneham, clothier 2
3776421 1950381 1950381 plaintiff Burges Richard yeoman 586480 586480 Burges, Richard, of Leneham, yeoman 0
3782249 1952201 1952201 defendant Elnot John husbandman 586480 586480 Elnot, John, of Leneham, husbandman 0
3787918 1954012 1954012 defendant Tylden John yeoman 586480 586480 Tylden, John, of Leneham, yeoman 1
3789251 1954455 1954455 defendant Paknam Simon husbandman 586480 586480 Paknam, Simon, of Leneham, husbandman 2
3791672 1955240 1955240 defendant Horpe alias Hopp John carpenter 586480 586480 Horpe alias Hopp, John, of Leneham, carpenter 0
3802567 1958699 1958699 defendant Baker John laborer 586480 586480 Baker, John, of Leneham, laborer 0
3806756 1960013 1960013 defendant Brewster John mercer 586480 586480 Brewster, John, of Leneham, mercer 1
3817210 1963297 1963297 defendant Baldon George clothier 586480 586480 Baldon, George, of Leneham, clothier 0
3842696 1971248 1971248 plaintiff Burges Richard (legal representative) 586480 586480 Burges, Richard, of Leneham, administrator of 0
3845933 1972285 1972285 defendant Tylbye Christopher butcher 586480 586480 Tylbye, Christopher, of Leneham, butcher 2
3858959 1976489 1976489 defendant at Water John yeoman 586480 586480 at Water, John, of Leneham, yeoman 0
3858960 1976489 1976489 defendant Balden George yeoman 586480 586480 Balden, George, of Leneham, yeoman 1
3862097 1977509 1977509 defendant Sare Philip yeoman 586480 586480 Sare, Philip, of Leneham, yeoman 1
3873786 1981453 1981453 defendant Alen John husbandman 586480 586480 Alen, John, of Leneham, husbandman 2
3880123 1983605 1983605 defendant Sare Philip yeoman 586480 586480 Sare, Philip, of Leneham, yeoman 0
3894888 1988497 1988497 defendant Aleyn John husbandman 586480 586480 Aleyn, John, of Leneham, husbandman 2
3902083 1990930 1990930 defendant Wyllyamson Robert husbandman 586480 586480 Wyllyamson, Robert, of Leneham, husbandman 0
3906483 1992460 1992460 defendant Trendell Nicholas   586480 586480 Trendell, Nicholas, of Leneham, "brotherer" 2
3923933 1998313 1998313 defendant Clerke William yeoman 586480 586480 Clerke, William, of Leneham, yeoman 1
3923934 1998313 1998313 defendant Pope Thomas yeoman 586480 586480 Pope, Thomas, of Leneham, yeoman 2
3923938 1998314 1998314 defendant Clerke William yeoman 586480 586480 Clerke, William, of Leneham, yeoman 1
3923939 1998314 1998314 defendant Pope Thomas yeoman 586480 586480 Pope, Thomas, of Leneham, yeoman 2
3943802 2004942 2004942 defendant Bankyn Richard yeoman 586480 586480 Bankyn, Richard, of Leneham, yeoman 0
3993532 2022432 2022432 defendant Pratt Francis gent 586480 586480 Pratt, Francis, of Leneham, gent 0
3998256 2024121 2024121 defendant Gyll William sherman 586480 586480 Gyll, William, of Leneham, sherman 0
3998257 2024121 2024121 defendant Gorram Ralph clothier 586480 586480 Gorram, Ralph, of Leneham, clothier 1
4046696 2041271 2041271 defendant Delman John clothier 586480 586480 Delman, John, of Leneham, clothier 1
4046699 2041272 2041272 defendant Dolman John clothier 586480 586480 Dolman, John, of Leneham, clothier 1
4089103 2056397 2056397 defendant Allen John yeoman 586480 586480 Allen, John, of Leneham, yeoman 0
4092241 2057526 2057526 defendant Packenham Mathew gent 586480 586480 Packenham, Mathew, of Leneham, gent 0
4126110 2069627 2069627 defendant Wynckfylde Richard butcher 586480 586480 Wynckfylde, Richard, of Leneham, butcher 0
4126111 2069627 2069627 defendant Pratt Francis gent 586480 586480 Pratt, Francis, of Leneham, gent 1
4128306 2070407 2070407 defendant Wynckfeld Richard butcher 586480 586480 Wynckfeld, Richard, of Leneham, butcher 0
4129490 2070851 2070851 defendant Pratt Francis gent 586480 586480 Pratt, Francis, of Leneham, gent 0
4166720 2083856 2083856 defendant Bagnor Christopher glover 586480 586480 Bagnor, Christopher, of Leneham, glover 0
4166721 2083856 2083856 defendant Coker Thomas glover 586480 586480 Coker, Thomas, of Leneham, glover 1
4198865 2095159 2095159 defendant Gardyner John, junior yeoman 586480 586480 Gardyner, John, junior, of Leneham, yeoman 1
4224591 2104077 2104077 defendant Allen Simon yeoman 586480 586480 Allen, Simon, of Leneham, yeoman 1
4230803 2106273 2106273 defendant Cryssylde or Crysfylde Walter shoemaker 586480 586480 Cryssylde or Crysfylde, Walter, of Leneham, shoemaker 1
4275068 2121233 2121233 defendant Dowle James yeoman 586480 586480 Dowle, James, of Leneham, yeoman 0
4275069 2121233 2121233 defendant Elson Richard husbandman 586480 586480 Elson, Richard, of Leneham, husbandman 1
4275070 2121233 2121233 defendant Burges Thomas husbandman 586480 586480 Burges, Thomas, of Leneham, husbandman 2
4275071 2121233 2121233 defendant Robynson Jeremiah glover 586480 586480 Robynson, Jeremiah, of Leneham, glover 3
4278453 2122400 2122400 defendant Dowle James yeoman 586480 586480 Dowle, James, of Leneham, yeoman 0
4278454 2122400 2122400 defendant Elson Richard husbandman 586480 586480 Elson, Richard, of Leneham, husbandman 1
4278455 2122400 2122400 defendant Burges Thomas husbandman 586480 586480 Burges, Thomas, of Leneham, husbandman 2
4278456 2122400 2122400 defendant Robynson Jeremiah glover 586480 586480 Robynson, Jeremiah, of Leneham, glover 3
4309421 2133455 2133455 defendant Allen Simon yeoman 586480 586480 Allen, Simon, of Leneham, yeoman 0
4312870 2134629 2134629 defendant Dowle James yeoman 586480 586480 Dowle, James, of Leneham, yeoman 0
4312871 2134629 2134629 defendant Elson Richard husbandman 586480 586480 Elson, Richard, of Leneham, husbandman 1
4312872 2134629 2134629 defendant Burges Thomas husbandman 586480 586480 Burges, Thomas, of Leneham, husbandman 2
4312873 2134629 2134629 defendant Robynson Jeremy glover 586480 586480 Robynson, Jeremy, of Leneham, glover 3
4312883 2134633 2134633 defendant Dowle James yeoman 586480 586480 Dowle, James, of Leneham, yeoman 0
4318312 2136512 2136512 defendant Farley John tailor 586480 586480 Farley, John, of Leneham, tailor 0
4318313 2136512 2136512 defendant Brencheley Thomas husbandman 586480 586480 Brencheley, Thomas, of Leneham, husbandman 1
4320842 2137381 2137381 defendant Rede Thomas butcher 586480 586480 Rede, Thomas, of Leneham, butcher 0
4332195 2141063 2141063 defendant Pratt Thomas gent 586480 586480 Pratt, Thomas, of Leneham, gent 0
4360165 2150799 2150799 defendant Forman Geoffrey shoemaker 586480 586480 Forman, Geoffrey, of Leneham, shoemaker 1
4369669 2154206 2154206 defendant Packnam Ralph yeoman 586480 586480 Packnam, Ralph, of Leneham, yeoman 1
4940722 2339125 2339125 defendant Howet William husbandman 586480 586480 Howet, William, of Leneham, husbandman 0
4978487 2350514 2350514 plaintiff Rogger Robert   586480 586480 Rogger, Robert, of Leneham 0
4994900 2355326 2355326 defendant Frere Henry laborer 586480 586480 Frere, Henry, of Leneham, laborer 0
5031782 2366167 2366167 defendant Charleton Hugh husbandman 586480 586480 Charleton, Hugh, of Leneham, husbandman 2
5263850 2434450 2434450 defendant Rederede Walter chaplain 586480 586480 Rederede, Walter, of Leneham, chaplain 0
5275084 2437793 2437793 defendant Penyngton John husbandman 586480 586480 Penyngton, John, of Leneham, husbandman 0
5275085 2437793 2437793 defendant Rogger Robert husbandman 586480 586480 Rogger, Robert, of Leneham, husbandman 1

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);