names

272 rows where place_id = 590628

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601835 1868232 1868232 defendant Wyldyng alias Coke Ralph innholder 590628 590628 Wyldyng alias Coke, Ralph, of Tewkesbury, innholder 0
3601836 1868232 1868232 defendant Pecok William yeoman 590628 590628 Pecok, William, of Tewkesbury, yeoman 1
3602722 1868515 1868515 defendant Mathewe William yeoman 590628 590628 Mathewe, William, of Tewkesbury, yeoman 0
3608772 1870407 1870407 defendant Coton Alan gent 590628 590628 Coton, Alan, of Tewkesbury, gent 0
3627361 1903410 1903410 defendant Bayly William husbandman 590628 590628 Bayly, William, of Tewkesbury, husbandman 0
3632237 1904899 1904899 defendant Becke John tanner 590628 590628 Becke, John, of Tewkesbury, tanner 0
3632478 1904977 1904977 defendant Reve John butcher 590628 590628 Reve, John, of Tewkesbury, butcher 0
3632888 1905104 1905104 defendant Bounde William husbandman 590628 590628 Bounde, William, of Tewkesbury, husbandman 0
3641152 1907682 1907682 defendant Cappe William tailor 590628 590628 Cappe, William, of Tewkesbury, tailor 0
3671626 1917112 1917112 defendant Cotton Stephen gent 590628 590628 Cotton, Stephen, of Tewkesbury, gent 0
3672027 1917252 1917252 defendant Bett John gent 590628 590628 Bett, John, of Tewkesbury, gent 0
3705029 1927863 1927863 defendant Cotton George (legal representative) 590628 590628 Cotton, George, of Tewkesbury, gent, executrix of 4
3705030 1927863 1927863 defendant Cotton Anne widow 590628 590628 Cotton, Anne, of Tewkesbury, or of Guppishill, Worcs, widow 5
3710415 1929576 1929576 defendant Garrott William (legal representative) 590628 590628 Garrott, William, of Tewkesbury, waterman, executors of 4
3715604 1931166 1931166 defendant Negyn Patrick hosteler 590628 590628 Negyn, Patrick, of Tewkesbury, hosteler 0
3721316 1932972 1932972 defendant Dyer William yeoman 590628 590628 Dyer, William, of Tewkesbury, yeoman 0
3727152 1934764 1934764 defendant Kendale John yeoman 590628 590628 Kendale, John, of Tewkesbury, yeoman 0
3729532 1935482 1935482 plaintiff Baron William   590628 590628 Baron, William, of Tewkesbury 0
3740447 1938870 1938870 defendant Comynm Robert gent 590628 590628 Comynm, Robert, of Tewkesbury, gent 1
3769766 1948197 1948197 defendant Comyn Robert gent 590628 590628 Comyn, Robert, of Tewkesbury, gent 1
3774198 1949644 1949644 defendant Nuttall Baldwin weaver 590628 590628 Nuttall, Baldwin, of Tewkesbury, weaver 0
3774199 1949644 1949644 defendant Rogers Henry haberdasher 590628 590628 Rogers, Henry, of Tewkesbury, haberdasher 1
3799035 1957609 1957609 defendant Breten John hooper 590628 590628 Breten, John, of Tewkesbury, hooper 0
3806435 1959925 1959925 defendant Bayly John yeoman 590628 590628 Bayly, John, of Tewkesbury, yeoman 0
3809540 1960869 1960869 defendant Bydfyld Robert innholder 590628 590628 Bydfyld, Robert, of Tewkesbury, innholder 0
3826048 1965990 1965990 defendant Chicheley John yeoman 590628 590628 Chicheley, John, of Tewkesbury, yeoman 1
3854455 1975033 1975033 defendant Bell Hugh butcher 590628 590628 Bell, Hugh, of Tewkesbury, butcher 0
3854456 1975033 1975033 defendant Polton Richard   590628 590628 Polton, Richard, of Tewkesbury 1
3854457 1975033 1975033 defendant Myles Richard yeoman 590628 590628 Myles, Richard, of Tewkesbury, yeoman 2
3867132 1979248 1979248 defendant Comyn Robert gent 590628 590628 Comyn, Robert, of Tewkesbury, gent 1
3873688 1981416 1981416 defendant Peers John innholder 590628 590628 Peers, John, of Tewkesbury, innholder 0
3877998 1982885 1982885 defendant Kendall John laborer 590628 590628 Kendall, John, of Tewkesbury, laborer 0
3880104 1983600 1983600 defendant Dryver Lawrence laborer 590628 590628 Dryver, Lawrence, of Tewkesbury, laborer 3
3911032 1994017 1994017 defendant Beke Henry butcher 590628 590628 Beke, Henry, of Tewkesbury, butcher 0
3911033 1994017 1994017 defendant Harley William mariner 590628 590628 Harley, William, of Tewkesbury, mariner 1
3911035 1994017 1994017 defendant Hawkyns Walter yeoman 590628 590628 Hawkyns, Walter, of Tewkesbury, yeoman 3
3921904 1997673 1997673 plaintiff Pyrry Alexander (legal representative) 590628 590628 Pyrry, Alexander, of Tewkesbury, draper, executor of 0
3921906 1997673 1997673 defendant Grene Henry tailor 590628 590628 Grene, Henry, of Tewkesbury, tailor 0
3921907 1997673 1997673 defendant Frebanke alias Walker William brewer 590628 590628 Frebanke alias Walker, William, of Tewkesbury, brewer 1
3921908 1997673 1997673 defendant Jones alias Capper Thomas   590628 590628 Jones alias Capper, Thomas, of Tewkesbury 2
3924432 1998482 1998482 defendant Pers Alice widow 590628 590628 Pers, Alice, of Tewkesbury, widow 1
3939835 2003622 2003622 defendant Haselock Peter clothier 590628 590628 Haselock, Peter, of Tewkesbury, clothier 3
3953240 2008200 2008200 defendant Forender Richard butcher 590628 590628 Forender, Richard, of Tewkesbury, butcher 0
3953244 2008201 2008201 defendant Grenewood Nicholas draper 590628 590628 Grenewood, Nicholas, of Tewkesbury, draper 0
3955485 2008986 2008986 defendant Feld John mercer 590628 590628 Feld, John, of Tewkesbury, mercer 0
3970900 2014387 2014387 defendant Geste Thomas yeoman 590628 590628 Geste, Thomas, of Tewkesbury, yeoman 1
3974922 2015795 2015795 defendant Moreton Thomas husbandman 590628 590628 Moreton, Thomas, of Tewkesbury, husbandman 0
3974923 2015795 2015795 defendant Combley John yeoman 590628 590628 Combley, John, of Tewkesbury, yeoman 1
3974924 2015795 2015795 defendant Kent Thomas husbandman 590628 590628 Kent, Thomas, of Tewkesbury, husbandman 2
3974925 2015795 2015795 defendant Flowere Anthony weaver 590628 590628 Flowere, Anthony, of Tewkesbury, weaver 3
3981645 2018192 2018192 defendant Combley Richard yeoman 590628 590628 Combley, Richard, of Tewkesbury, yeoman 0
3981646 2018192 2018192 defendant Corney William yeoman 590628 590628 Corney, William, of Tewkesbury, yeoman 1
4016486 2030602 2030602 plaintiff Stratford Charles gent 590628 590628 Stratford, Charles, of Tewkesbury, gent 0
4019636 2031749 2031749 defendant Huslocke Peter weaver 590628 590628 Huslocke, Peter, of Tewkesbury, weaver 0
4019637 2031749 2031749 defendant James Gilbert weaver 590628 590628 James, Gilbert, of Tewkesbury, weaver 1
4031541 2035945 2035945 defendant Rogers Thomas yeoman 590628 590628 Rogers, Thomas, of Tewkesbury, yeoman 1
4037164 2037953 2037953 defendant Hurste Humphrey miller 590628 590628 Hurste, Humphrey, of Tewkesbury, miller 0
4037165 2037953 2037953 defendant Gest Giles chapman 590628 590628 Gest, Giles, of Tewkesbury, chapman 1
4037166 2037953 2037953 defendant Richardes Humphrey (legal representative) 590628 590628 Richardes, Humphrey, of Tewkesbury, mercer, executrix of 2
4037167 2037953 2037953 defendant Richard Dorothy widow 590628 590628 Richard, Dorothy, of Tewkesbury, widow 3
4081554 2053710 2053710 defendant Millington John mercer 590628 590628 Millington, John, of Tewkesbury, mercer 2
4084967 2054902 2054902 defendant Barebone Elizabeth widow 590628 590628 Barebone, Elizabeth, of Tewkesbury, widow 1
4100747 2060585 2060585 defendant Skull James yeoman 590628 590628 Skull, James, of Tewkesbury, yeoman 1
4123571 2068731 2068731 defendant Hughes Charles glasier 590628 590628 Hughes, Charles, of Tewkesbury, glasier 1
4127237 2070033 2070033 defendant Butler Richard yeoman 590628 590628 Butler, Richard, of Tewkesbury, yeoman 0
4137700 2073839 2073839 defendant Williams alias Plomer John yeoman 590628 590628 Williams alias Plomer, John, of Tewkesbury, yeoman 0
4137701 2073839 2073839 defendant Cokynsoll Richard saddler 590628 590628 Cokynsoll, Richard, of Tewkesbury, saddler 1
4139133 2074362 2074362 defendant Butler John yeoman 590628 590628 Butler, John, of Tewkesbury, yeoman 0
4159702 2081461 2081461 defendant Phelpes William merchant 590628 590628 Phelpes, William, of Tewkesbury, merchant 2
4162146 2082316 2082316 defendant Williams alias Plomer John yeoman 590628 590628 Williams alias Plomer, John, of Tewkesbury, yeoman 0
4166602 2083815 2083815 defendant Nanfan Richard gent 590628 590628 Nanfan, Richard, of Tewkesbury, gent 0
4172716 2085916 2085916 defendant Cotterell Kenelm vintner 590628 590628 Cotterell, Kenelm, of Tewkesbury, vintner 0
4172718 2085916 2085916 defendant Dutton Richard fuller 590628 590628 Dutton, Richard, of Tewkesbury, fuller 2
4172719 2085916 2085916 defendant Snowe John weaver 590628 590628 Snowe, John, of Tewkesbury, weaver 3
4172721 2085917 2085917 defendant Cotterell Kenelm vintner 590628 590628 Cotterell, Kenelm, of Tewkesbury, vintner 0
4172723 2085917 2085917 defendant Dutton Richard fuller 590628 590628 Dutton, Richard, of Tewkesbury, fuller 2
4172724 2085917 2085917 defendant Snowe John weaver 590628 590628 Snowe, John, of Tewkesbury, weaver 3
4176847 2087370 2087370 defendant Dryver Thomas shoemaker 590628 590628 Dryver, Thomas, of Tewkesbury, shoemaker 0
4176848 2087370 2087370 defendant Snowe John yeoman 590628 590628 Snowe, John, of Tewkesbury, yeoman 1
4176849 2087370 2087370 defendant Poole John yeoman 590628 590628 Poole, John, of Tewkesbury, yeoman 2
4180210 2088560 2088560 defendant Greene James butcher 590628 590628 Greene, James, of Tewkesbury, butcher 1
4180211 2088560 2088560 defendant Greene Robert butcher 590628 590628 Greene, Robert, of Tewkesbury, butcher 2
4180230 2088563 2088563 defendant Greene James butcher 590628 590628 Greene, James, of Tewkesbury, butcher 1
4180231 2088563 2088563 defendant Greene Robert butcher 590628 590628 Greene, Robert, of Tewkesbury, butcher 2
4181744 2089095 2089095 defendant Poole John yeoman 590628 590628 Poole, John, of Tewkesbury, yeoman 0
4181758 2089099 2089099 defendant Poole John yeoman 590628 590628 Poole, John, of Tewkesbury, yeoman 0
4189381 2091786 2091786 defendant Hyett Richard yeoman 590628 590628 Hyett, Richard, of Tewkesbury, or of Walton Kerdyff, yeoman 1
4202344 2096363 2096363 defendant Butler John yeoman 590628 590628 Butler, John, of Tewkesbury, yeoman 1
4214925 2100721 2100721 defendant Poole John, junior gent 590628 590628 Poole, John, junior, of Tewkesbury, gent 0
4217945 2101768 2101768 defendant Richardes Thomas dyer 590628 590628 Richardes, Thomas, of Tewkesbury, dyer 0
4218519 2101975 2101975 defendant Trigge Alice widow 590628 590628 Trigge, Alice, of Tewkesbury, widow 2
4224411 2104022 2104022 defendant Poole John, junior gent 590628 590628 Poole, John, junior, of Tewkesbury, gent 0
4225360 2104339 2104339 defendant Davys Hugh gent 590628 590628 Davys, Hugh, of Tewkesbury, gent 0
4226043 2104578 2104578 defendant Hassarde John tailor 590628 590628 Hassarde, John, of Tewkesbury, tailor 0
4227646 2105153 2105153 defendant Trigge Alice widow 590628 590628 Trigge, Alice, of Tewkesbury, widow 2
4229415 2105770 2105770 defendant Edward Thomas yeoman 590628 590628 Edward, Thomas, of Tewkesbury, yeoman 1
4234782 2107716 2107716 defendant Frewe George chandler 590628 590628 Frewe, George, of Tewkesbury, yeoman, chandler 0
4274947 2121190 2121190 defendant Morgan Thomas gent 590628 590628 Morgan, Thomas, of Tewkesbury, or of Newent, gent 0
4278731 2122497 2122497 defendant Barston Edward gent 590628 590628 Barston, Edward, of Tewkesbury, gent 0
4278732 2122497 2122497 defendant Barston John gent 590628 590628 Barston, John, of Tewkesbury, gent 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);