names

203 rows where place_id = 595192

✎ 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
3619326 1873643 1873643 defendant Spenser John yeoman 595192 595192 Spenser, John, of Lee, yeoman 16
3619327 1873643 1873643 defendant Clayton Robert, senior yeoman 595192 595192 Clayton, Robert, senior, of Lee, yeoman 17
3619334 1873643 1873643 defendant Clayton Robert, junior yeoman 595192 595192 Clayton, Robert, junior, of Lee, yeoman 24
3623107 1874749 1874749 defendant Brigge John gent 595192 595192 Brigge, John, of Lee, gent 3
3631921 1904795 1904795 defendant Cowley Robert yeoman 595192 595192 Cowley, Robert, of Lee, yeoman 0
3631946 1904805 1904805 defendant Cowley Robert yeoman 595192 595192 Cowley, Robert, of Lee, yeoman 0
3662344 1914137 1914137 defendant Grainger John chaplain 595192 595192 Grainger, John, of Lee, chaplain 2
3662346 1914137 1914137 defendant Kyrom William   595192 595192 Kyrom, William, of Lee 4
3670887 1916861 1916861 defendant Alysaunder John husbandman 595192 595192 Alysaunder, John, of Lee, husbandman 2
3671488 1917065 1917065 defendant Lovell John, senior husbandman 595192 595192 Lovell, John, senior, of Lee, husbandman 0
3671489 1917065 1917065 defendant Lovell John, junior husbandman 595192 595192 Lovell, John, junior, of Lee, husbandman 1
3672682 1917459 1917459 defendant Halle Thomas husbandman 595192 595192 Halle, Thomas, of Lee, husbandman 2
3678631 1919377 1919377 defendant Flemyng John husbandman 595192 595192 Flemyng, John, of Lee, husbandman 0
3678632 1919377 1919377 defendant Flemyng Thomas husbandman 595192 595192 Flemyng, Thomas, of Lee, husbandman 1
3684984 1921440 1921440 defendant Washaburne William receiver for Abbot of Malmesbury 595192 595192 Washaburne, William, of Lee, gent, receiver for Abbot of Malmesbury 0
3684985 1921440 1921440 defendant Washaburne John gent 595192 595192 Washaburne, John, of Lee, gent 1
3687603 1922295 1922295 defendant Markys William husbandman 595192 595192 Markys, William, of Lee, husbandman 2
3690783 1923283 1923283 defendant White Christpher husbandman 595192 595192 White, Christpher, of Lee, husbandman 0
3700118 1926268 1926268 defendant Wasshaburne John receiver for abbot of Malmesbury 595192 595192 Wasshaburne, John, of Lee, gent, son of Wasshaburne, William, receiver for abbot of Malmesbury 0
3724391 1933917 1933917 defendant Pagett Thomas laborer 595192 595192 Pagett, Thomas, of Lee, laborer 1
3724393 1933917 1933917 defendant Smyth John mariner 595192 595192 Smyth, John, of Lee, mariner 3
3732284 1936339 1936339 plaintiff Corbet John esq 595192 595192 Corbet, John, of Lee, esq 0
3732288 1936340 1936340 plaintiff Corbet John esq 595192 595192 Corbet, John, of Lee, esq 0
3732292 1936341 1936341 plaintiff Corbet John esq 595192 595192 Corbet, John, of Lee, esq 0
3732296 1936342 1936342 plaintiff Corbet John esq 595192 595192 Corbet, John, of Lee, esq 0
3746583 1940845 1940845 plaintiff Corbet John esq 595192 595192 Corbet, John, of Lee, esq 0
3758094 1944516 1944516 defendant Hamer John gent 595192 595192 Hamer, John, of Lee, gent 3
3759980 1945116 1945116 plaintiff Corbett John esq 595192 595192 Corbett, John, of Lee, esq 0
3778005 1950832 1950832 plaintiff Corbet John esq 595192 595192 Corbet, John, of Lee, esq 0
3800038 1957937 1957937 defendant Hill William husbandman 595192 595192 Hill, William, of Lee, husbandman 0
3809911 1960985 1960985 defendant Rowte Thomas butcher 595192 595192 Rowte, Thomas, of Lee, butcher 0
3814390 1962415 1962415 defendant Whyte Christopher husbandman 595192 595192 Whyte, Christopher, of Lee, husbandman 1
3814391 1962415 1962415 defendant Wakeham Thomas husbandman 595192 595192 Wakeham, Thomas, of Lee, husbandman 2
3816984 1963219 1963219 defendant Tayler Henry mercer 595192 595192 Tayler, Henry, of Lee, mercer 2
3827515 1966470 1966470 defendant Davyes Thomas clerk 595192 595192 Davyes, Thomas, of Lee, clerk 0
3827516 1966470 1966470 defendant Elly William yeoman 595192 595192 Elly, William, of Lee, yeoman 1
3827517 1966470 1966470 defendant Davyes John husbandman 595192 595192 Davyes, John, of Lee, husbandman 2
3827518 1966470 1966470 defendant ap Hoell Rees laborer 595192 595192 ap Hoell, Rees, of Lee, laborer 3
3831503 1967738 1967738 plaintiff Hadok William   595192 595192 Hadok, William, of Lee 0
3831782 1967841 1967841 defendant Bromley Alice widow 595192 595192 Bromley, Alice, of Lee, widow 0
3838068 1969820 1969820 defendant Brystow John yeoman 595192 595192 Brystow, John, of Lee, yeoman 2
3841753 1971007 1971007 defendant Kynglond Robert mariner 595192 595192 Kynglond, Robert, of Lee, mariner 0
3858242 1976233 1976233 defendant Drakeford Thomas husbandman 595192 595192 Drakeford, Thomas, of Lee, husbandman 1
3864000 1978139 1978139 defendant Yonge John   595192 595192 Yonge, John, of Lee, parish clerk 1
3880770 1983833 1983833 defendant Stampe Robert husbandman 595192 595192 Stampe, Robert, of Lee, husbandman 0
3886711 1985811 1985811 defendant Rygge John husbandman 595192 595192 Rygge, John, of Lee, husbandman 0
3894296 1988310 1988310 defendant Cuttyll John   595192 595192 Cuttyll, John, of Lee, shipwright 4
3894664 1988421 1988421 defendant Byrkys William husbandman 595192 595192 Byrkys, William, of Lee, husbandman 2
3910764 1993921 1993921 defendant Jakes William husbandman 595192 595192 Jakes, William, of Lee, husbandman 0
3945505 2005503 2005503 defendant Kymmerley William cooper 595192 595192 Kymmerley, William, of Lee, cooper 1
3945506 2005503 2005503 defendant Tayler Thomas laborer 595192 595192 Tayler, Thomas, of Lee, laborer 2
3953433 2008273 2008273 defendant Newton William husbandman 595192 595192 Newton, William, of Lee, husbandman 0
3955475 2008981 2008981 defendant Rudge John husbandman 595192 595192 Rudge, John, of Lee, husbandman 0
3964348 2012134 2012134 defendant Milles William yeoman 595192 595192 Milles, William, of Lee, yeoman 0
3989000 2020806 2020806 defendant Nott Richard innholder 595192 595192 Nott, Richard, of Lee, innholder 0
3994082 2022633 2022633 defendant Caverd Richard husbandman 595192 595192 Caverd, Richard, of Lee, husbandman 0
3997804 2023971 2023971 defendant Wylkynson Robert husbandman 595192 595192 Wylkynson, Robert, of Lee, husbandman 0
4022797 2032876 2032876 defendant Banner Thomas yeoman 595192 595192 Banner, Thomas, of Lee, yeoman 0
4025275 2033701 2033701 defendant Nurs Henry laborer 595192 595192 Nurs, Henry, of Lee, laborer 0
4025276 2033701 2033701 defendant Younge Morgan yeoman 595192 595192 Younge, Morgan, of Lee, yeoman 1
4042181 2039686 2039686 plaintiff Pagett William   595192 595192 Pagett, William, of Lee 0
4047470 2041546 2041546 defendant Myll William yeoman 595192 595192 Myll, William, of Lee, yeoman 0
4065602 2047988 2047988 defendant Nurse Henry yeoman 595192 595192 Nurse, Henry, of Lee, yeoman 0
4065604 2047989 2047989 defendant Nurse Henry yeoman 595192 595192 Nurse, Henry, of Lee, yeoman 0
4089928 2056689 2056689 defendant Gough John smith 595192 595192 Gough, John, of Lee, smith 0
4092021 2057440 2057440 defendant Weate Andrew husbandman 595192 595192 Weate, Andrew, of Lee, husbandman 0
4102714 2061269 2061269 defendant Taylor William husbandman 595192 595192 Taylor, William, of lee, husbandman 0
4119129 2067131 2067131 defendant Taylor George   595192 595192 together with Taylor, George, of Lee yeoman 2
4135766 2073119 2073119 defendant Bonner George husbandman 595192 595192 Bonner, George, of Lee, husbandman 0
4136191 2073289 2073289 defendant Clerke Thomas yeoman 595192 595192 Clerke, Thomas, of Lee, yeoman 0
4136192 2073289 2073289 defendant Calverd alias Smyth Richard husbandman 595192 595192 Calverd alias Smyth, Richard, of Lee, husbandman 1
4142952 2075706 2075706 defendant Ades Nicholas laborer 595192 595192 Ades, Nicholas, of Lee, laborer 2
4144614 2076275 2076275 defendant Goodwyn Roger yeoman 595192 595192 Goodwyn, Roger, of Lee, yeoman 2
4159836 2081509 2081509 defendant Bonner George husbandman 595192 595192 Bonner, George, of Lee, husbandman 0
4160485 2081740 2081740 defendant Clerke Thomas yeoman 595192 595192 Clerke, Thomas, of Lee, yeoman 0
4160486 2081740 2081740 defendant Calbard alias Smythe alias Cawber Richard husbandman 595192 595192 Calbard alias Smythe alias Cawber, Richard, of Lee, husbandman 1
4172014 2085675 2085675 defendant Taylor George husbandman 595192 595192 Taylor, George, of Lee, husbandman 2
4182094 2089216 2089216 defendant Lloyde Mathew gent 595192 595192 Lloyde, Mathew, of Lee, gent 0
4188804 2091563 2091563 defendant Maule or Manle Thomas butcher 595192 595192 Maule or Manle, Thomas, of Lee, butcher 0
4190947 2092396 2092396 defendant Lloid Mathew gent 595192 595192 Lloid, Mathew, of Lee, gent 1
4219808 2102432 2102432 defendant Merricke Richard husbandman 595192 595192 Merricke, Richard, of Lee, husbandman 0
4263647 2117504 2117504 defendant Corbett George esq 595192 595192 (Corbett, George, of Lee, esq 2
4296815 2128961 2128961 defendant Tailer George yeoman 595192 595192 Tailer, George, of Lee, yeoman 1
4318967 2136748 2136748 defendant Forster Nicholas gent 595192 595192 Forster, Nicholas, of Lee, gent 0
4323877 2138398 2138398 defendant Ades Nicholas yeoman 595192 595192 Ades, Nicholas, of Lee, yeoman 2
4334111 2141687 2141687 defendant Meredith Francis gent 595192 595192 Meredith, Francis, of Lee, gent 1
4381704 2158557 2158557 defendant Palmer George husbandman 595192 595192 Palmer, George, of lee, husbandman 1
4383653 2159244 2159244 defendant Nurse Henry yeoman 595192 595192 Nurse, Henry, of Lee, yeoman 2
4401923 2165239 2165239 defendant Lovell Mary widow 595192 595192 Lovell, Mary, of Lee, widow 0
4401924 2165239 2165239 defendant Lovell Henry husbandman 595192 595192 Lovell, Henry, of Lee, husbandman 1
4401925 2165239 2165239 defendant Woodward John laborer 595192 595192 Woodward, John, of Lee, laborer 2
4401926 2165239 2165239 defendant Rudge John   595192 595192 Rudge, John, of Lee husbandman 3
4414071 2169304 2169304 plaintiff Clerk Richard le   595192 595192 Clerk, Richard le, of Lee 0
4460030 2188195 2188195 defendant Lymbervere Richard   595192 595192 Lymbervere, Richard, of Lee 0
4477830 2193734 2193734 defendant Tyburnell Adam   595192 595192 Tyburnell, Adam, of Lee 0
4486918 2196624 2196624 defendant Hamson John   595192 595192 Hamson, John, of Lee 0
4538308 2212271 2212271 defendant Eton John   595192 595192 Eton, John, of Lee 1
4560410 2219195 2219195 defendant Hancokke John   595192 595192 Hancokke, John, of Lee 0
4561456 2219517 2219517 defendant Langeford John   595192 595192 Langeford, John, of Lee 3
4563669 2220203 2220203 defendant Aleyn Thomas   595192 595192 Aleyn, Thomas, of Lee 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);