names

280 rows where place_id = 588010

✎ 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
3593093 1865467 1865467 defendant Bowre Walter yeoman 588010 588010 Bowre, Walter, of Newent, yeoman 1
3596048 1866392 1866392 defendant Hook Guy gent 588010 588010 Hook, Guy, of Newent, gent 0
3596050 1866393 1866393 defendant Hook John clerk 588010 588010 Hook, John, of Newent, clerk 0
3602068 1868309 1868309 defendant Adys Thomas cordwainer 588010 588010 Adys, Thomas, of Newent, cordwainer 1
3602069 1868309 1868309 defendant Comedowe Thomas carpenter 588010 588010 Comedowe, Thomas, of Newent, carpenter 2
3604913 1869202 1869202 defendant Hoke William yeoman 588010 588010 Hoke, William, of Newent, yeoman 1
3702831 1927157 1927157 defendant Porter Arthur gent 588010 588010 Porter, Arthur, of Newent, gent 1
3703409 1927343 1927343 defendant Lee Florence yeoman 588010 588010 Lee, Florence, of Newent, yeoman 1
3706140 1928214 1928214 defendant Overthrowe William husbandman 588010 588010 Overthrowe, William, of Newent, husbandman 1
3706141 1928214 1928214 defendant Overthrowe John yeoman 588010 588010 Overthrowe, John, of Newent, yeoman 2
3729687 1935536 1935536 defendant Yede Robert husbandman 588010 588010 Yede, Robert, of Newent, husbandman 1
3751046 1942260 1942260 defendant Whytford William husbandman 588010 588010 Whytford, William, of Newent, husbandman 1
3764549 1946570 1946570 defendant Mody William yeoman 588010 588010 (Mody, William, of Newent, yeoman 6
3781424 1951926 1951926 defendant Horne Thomas husbandman 588010 588010 Horne, Thomas, of Newent, husbandman 1
3813224 1962046 1962046 defendant Knollys John, senior husbandman 588010 588010 Knollys, John, senior, of Newent, husbandman 0
3813225 1962046 1962046 defendant Knollys John, junior husbandman 588010 588010 Knollys, John, junior, of Newent, husbandman 1
3813226 1962046 1962046 defendant Davys John husbandman 588010 588010 Davys, John, of Newent, husbandman 2
3824787 1965628 1965628 defendant Yonge John husbandman 588010 588010 Yonge, John, of Newent, husbandman 0
3874957 1981847 1981847 plaintiff Don Thomas yeoman 588010 588010 Don, Thomas, of Newent, yeoman 0
3897422 1989351 1989351 defendant Bower John tanner 588010 588010 Bower, John, of Newent, tanner 0
3904579 1991780 1991780 defendant Huntley Richard butcher 588010 588010 Huntley, Richard, of Newent, butcher 0
3904895 1991900 1991900 defendant Adys John husbandman 588010 588010 Adys, John, of Newent, husbandman 7
3904908 1991901 1991901 defendant Bromage William laborer 588010 588010 Bromage, William, of Newent, laborer 4
3932438 2001137 2001137 defendant Cutler John clerk 588010 588010 Cutler, John, of Newent, clerk 0
3932439 2001137 2001137 defendant Crawse Richard husbandman 588010 588010 Crawse, Richard, of Newent, husbandman 1
3953786 2008400 2008400 defendant Gryne Thomas butcher 588010 588010 Gryne, Thomas, of Newent, butcher 0
4072164 2050344 2050344 defendant Morgan Rice tailor 588010 588010 Morgan, Rice, of Newent, tailor 0
4089173 2056416 2056416 defendant Beacke Richard husbandman 588010 588010 Beacke, Richard, of Newent, husbandman 1
4089174 2056416 2056416 defendant Coxe Robert husbandman 588010 588010 Coxe, Robert, of Newent, husbandman 2
4089175 2056416 2056416 defendant Coxe Thomas husbandman 588010 588010 Coxe, Thomas, of Newent, husbandman 3
4129419 2070826 2070826 defendant Bower Robert butcher 588010 588010 Bower, Robert, of Newent, butcher 0
4129421 2070827 2070827 defendant Bower Thomas, senior glover 588010 588010 Bower, Thomas, senior, of Newent, glover 0
4141574 2075217 2075217 defendant Horne Thomas yeoman 588010 588010 Horne, Thomas, of Newent, yeoman 0
4142417 2075521 2075521 defendant Wattes William   588010 588010 Wattes, William, of Newent, Glos shoemaker 0
4154476 2079656 2079656 defendant Drue Alexander yeoman 588010 588010 Drue, Alexander, of Newent, yeoman 0
4157906 2080837 2080837 defendant Dobyns Alexander gent 588010 588010 Dobyns, Alexander, of Newent, gent 2
4165425 2083410 2083410 defendant Drewe Alexander yeoman 588010 588010 Drewe, Alexander, of Newent, yeoman 1
4171543 2085512 2085512 defendant Curteise Robert, junior tanner 588010 588010 Curteise, Robert, junior, of Newent, husbandman, tanner 0
4173387 2086149 2086149 defendant Bower Philip glover 588010 588010 Bower, Philip, of Newent, glover 0
4173388 2086149 2086149 defendant Hill James husbandman 588010 588010 Hill, James, of Newent, husbandman 1
4176281 2087181 2087181 defendant Wall Thomas yeoman 588010 588010 Wall, Thomas, of Newent, yeoman 1
4176282 2087181 2087181 defendant Hill John gent 588010 588010 Hill, John, of Newent, gent 2
4177643 2087656 2087656 defendant Nelme or Neline Thomas shoemaker 588010 588010 Nelme or Neline, Thomas, of Newent, shoemaker 1
4177644 2087656 2087656 defendant Hope John husbandman 588010 588010 Hope, John, of Newent, husbandman 2
4190212 2092084 2092084 defendant Bower Robert butcher 588010 588010 Bower, Robert, of Newent, butcher 0
4195641 2094029 2094029 defendant Drynckwater Robert yeoman 588010 588010 Drynckwater, Robert, of Newent, yeoman 0
4200772 2095828 2095828 defendant Hooper Richard tanner 588010 588010 Hooper, Richard, of Newent, tanner 0
4205252 2097388 2097388 defendant Grene Richard gent 588010 588010 Grene, Richard, of Newent, gent 0
4205253 2097388 2097388 defendant Sheyle John tucker 588010 588010 Sheyle, John, of Newent, tucker 1
4211012 2099408 2099408 defendant Hill Nicholas weaver 588010 588010 Hill, Nicholas, of Newent, weaver 0
4214926 2100721 2100721 defendant Donne or Doune Thomas gent 588010 588010 Donne or Doune, Thomas, of Newent, gent 1
4222587 2103394 2103394 defendant Donne or Doune Christopher clothier 588010 588010 Donne or Doune, Christopher, of Newent, clothier 0
4222588 2103394 2103394 defendant Curtys John tailor 588010 588010 Curtys, John, of Newent, tailor 1
4224412 2104022 2104022 defendant Donne or Doune Thomas gent 588010 588010 Donne or Doune, Thomas, of Newent, gent 1
4234489 2107606 2107606 defendant Morgan Rice tailor 588010 588010 Morgan, Rice, of Newent, tailor 0
4234490 2107606 2107606 defendant Hulyns William joiner 588010 588010 Hulyns, William, of Newent, joiner 1
4238163 2108960 2108960 defendant Bradford Thomas yeoman 588010 588010 Bradford, Thomas, of Newent, yeoman 0
4238168 2108961 2108961 defendant Bradford Thomas yeoman 588010 588010 Bradford, Thomas, of Newent, yeoman 0
4239714 2109521 2109521 defendant Donne or Doune Christopher clothier 588010 588010 Donne or Doune, Christopher, of Newent, clothier 0
4239715 2109521 2109521 defendant Curtes John tailor 588010 588010 Curtes, John, of Newent, tailor 1
4292712 2127456 2127456 defendant Bower John tanner 588010 588010 Bower, John, of Newent, tanner 0
4292714 2127456 2127456 defendant Gilford Arthur yeoman 588010 588010 Gilford, Arthur, of Newent, yeoman 2
4292715 2127456 2127456 defendant Farre Silvester yeoman 588010 588010 Farre, Silvester, of Newent, yeoman 3
4293316 2127670 2127670 defendant Colwell Arnold yeoman 588010 588010 Colwell, Arnold, of Newent, yeoman 0
4295814 2128596 2128596 defendant Hill Richard   588010 588010 Hill, Richard, of Newent, gent, his son 1
4300238 2130184 2130184 defendant Morgan Thomas gent 588010 588010 Morgan, Thomas, of Newent, gent 0
4301470 2130631 2130631 defendant Bower John tanner 588010 588010 Bower, John, of Newent, tanner 0
4301472 2130631 2130631 defendant Gylford Arthur yeoman 588010 588010 Gylford, Arthur, of Newent, yeoman 2
4301473 2130631 2130631 defendant Farre Silvester yeoman 588010 588010 Farre, Silvester, of Newent, yeoman 3
4302399 2130960 2130960 defendant Willyams alias Baker John clothier 588010 588010 Willyams alias Baker, John, of Newent, clothier 0
4304911 2131856 2131856 defendant Pypard John   588010 588010 Pypard, John, of Newent, Glos yeoman 1
4305332 2132004 2132004 defendant Burton William brasier 588010 588010 Burton, William, of Newent, brasier 1
4305334 2132005 2132005 defendant Lambe John glover 588010 588010 Lambe, John, of Newent, glover 0
4322068 2137797 2137797 defendant Morgan Thomas   588010 588010 Morgan, Thomas, of Newent 0
4337480 2142845 2142845 defendant Kyrle Anne widow 588010 588010 Kyrle, Anne, of Newent, widow 0
4359644 2150609 2150609 defendant Beeche John yeoman 588010 588010 Beeche John, of Newent, yeoman 3
4364067 2152202 2152202 defendant Donne or Doune Arthur yeoman 588010 588010 Donne or Doune, Arthur, of Newent, yeoman 0
4366065 2152905 2152905 defendant Beake Thomas husbandman 588010 588010 Beake, Thomas, of Newent, husbandman 2
4367032 2153264 2153264 defendant Greene Thomas butcher 588010 588010 Greene, Thomas, of Newent, butcher 0
4367033 2153264 2153264 defendant Coxe Thomas yeoman 588010 588010 Coxe, Thomas, of Newent, yeoman 1
4374221 2155852 2155852 defendant Baughe John saddler 588010 588010 Baughe, John, of Newent, saddler 2
4374354 2155895 2155895 defendant Kirle Anne widow 588010 588010 Kirle, Anne, of Newent, widow 0
4375427 2156266 2156266 defendant Grene Thomas butcher 588010 588010 Grene, Thomas, of Newent, butcher 0
4377859 2157150 2157150 defendant Knowles James yeoman 588010 588010 Knowles, James, of Newent, yeoman 0
4377860 2157150 2157150 defendant Clarke John yeoman 588010 588010 Clarke, John, of Newent, yeoman 1
4378898 2157529 2157529 defendant Coxe Thomas yeoman 588010 588010 Coxe, Thomas, of Newent, yeoman 0
4384895 2159638 2159638 defendant Heyward William tailor 588010 588010 Heyward, William, of Newent, tailor 0
4384897 2159639 2159639 defendant Hill Thomas yeoman 588010 588010 Hill, Thomas, of Newent, yeoman 0
4390434 2161421 2161421 defendant Astman Thomas   588010 588010 Astman, Thomas, of Newent, yeoman, son of John Astman 0
4391182 2161668 2161668 defendant Morgan Thomas gent 588010 588010 Morgan, Thomas, of Newent, gent 0
4391183 2161668 2161668 defendant Vearnoll Thomas laborer 588010 588010 Vearnoll, Thomas, of Newent, laborer 1
4391185 2161669 2161669 defendant Jenkyns Thomas yeoman 588010 588010 Jenkyns, Thomas, of Newent, yeoman 0
4393049 2162287 2162287 defendant Dobbyns Thomas gent 588010 588010 Dobbyns, Thomas, of Newent, gent 0
4393050 2162287 2162287 defendant Dobbyns Guy gent 588010 588010 Dobbyns, Guy, of Newent, gent 1
4393052 2162287 2162287 defendant Wilkins alias Baker John gent 588010 588010 Wilkins alias Baker, John, of Newent, gent 3
4398452 2164064 2164064 defendant Bradley Christopher gent 588010 588010 Bradley, Christopher, of Newent, gent 0
4398618 2164117 2164117 defendant Bradley Christopher gent 588010 588010 Bradley, Christopher, of Newent, gent 0
4399144 2164298 2164298 defendant Morgan Thomas gent 588010 588010 Morgan, Thomas, of Newent, or of Ockley, gent 0
4403926 2165884 2165884 defendant Heathe William husbandman 588010 588010 Heathe, William, of Newent, husbandman 0
4403927 2165884 2165884 defendant Bayneham Henry husbandman 588010 588010 Bayneham, Henry, of Newent, 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);