names

154 rows where place_id = 608637

✎ 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
3674611 1918110 1918110 defendant Bulle Hugh yeoman 608637 608637 Bulle, Hugh, of Bromyard, yeoman 1
3683231 1920874 1920874 defendant Bridde John cordwainer 608637 608637 Bridde, John, of Bromyard, cordwainer 2
3696255 1925050 1925050 defendant Pery Richard yeoman 608637 608637 Pery, Richard, of Bromyard, yeoman 1
3726566 1934566 1934566 defendant Smyth Hugh yeoman 608637 608637 Smyth, Hugh, of Bromyard, yeoman 1
3757106 1944204 1944204 defendant Bryde John, senior yeoman 608637 608637 Bryde, John, senior, of Bromyard, yeoman 0
3757129 1944208 1944208 defendant Nycolett William yeoman 608637 608637 Nycolett, William, of Bromyard, yeoman 0
3763912 1946356 1946356 defendant Brydde John, senior cordwainer 608637 608637 Brydde, John, senior, of Bromyard, cordwainer 0
3764534 1946566 1946566 defendant Bilfeld Walter baker 608637 608637 Bilfeld, Walter, of Bromyard, baker 0
3765014 1946724 1946724 defendant Taillour Roger cooper 608637 608637 Taillour, Roger, of Bromyard, cooper 0
3768331 1947736 1947736 defendant Trowe Elizabeth spinster 608637 608637 Trowe, Elizabeth, of Bromyard, spinster 0
3768333 1947737 1947737 defendant Trowte Elizabeth spinster 608637 608637 Trowte, Elizabeth, of Bromyard, spinster 0
3768335 1947738 1947738 defendant Wight Richard cordwainer 608637 608637 Wight, Richard, of Bromyard, cordwainer 0
3775280 1950007 1950007 defendant Benett John tailor 608637 608637 Benett, John, of Bromyard, tailor 0
3776868 1950506 1950506 plaintiff Camme Henry   608637 608637 Camme, Henry, of Bromyard 0
3778024 1950838 1950838 defendant Tarboxe John, senior miller 608637 608637 Tarboxe, John, senior, of Bromyard, miller 0
3778026 1950839 1950839 defendant Tarboxe John, senior miller 608637 608637 Tarboxe, John, senior, of Bromyard, miller 0
3781912 1952090 1952090 defendant Brydde John, senior cordwainer 608637 608637 Brydde, John, senior, of Bromyard, cordwainer 0
3781952 1952104 1952104 defendant Lawton William laborer 608637 608637 Lawton, William, of Bromyard, laborer 7
3789242 1954453 1954453 defendant Symson John miller 608637 608637 Symson, John, of Bromyard, miller 0
3789546 1954557 1954557 defendant Benett John tailor 608637 608637 Benett, John, of Bromyard, tailor 0
3789547 1954557 1954557 defendant Barker John tanner 608637 608637 Barker, John, of Bromyard, tanner 1
3789548 1954557 1954557 defendant Collys Richard laborer 608637 608637 Collys, Richard, of Bromyard, laborer 2
3805679 1959720 1959720 defendant Benett John tailor 608637 608637 Benett, John, of Bromyard, tailor 0
3805680 1959720 1959720 defendant Berker John tanner 608637 608637 Berker, John, of Bromyard, tanner 1
3805681 1959720 1959720 defendant Collys Richard laborer 608637 608637 Collys, Richard, of Bromyard, laborer 2
3853034 1974568 1974568 defendant Gyttyns Lewis yeoman 608637 608637 Gyttyns, Lewis, of Bromyard, yeoman 0
3858244 1976234 1976234 defendant ap Howell John carpenter 608637 608637 ap Howell, John, of Bromyard, carpenter 0
3858804 1976431 1976431 defendant Oliver John husbandman 608637 608637 Oliver, John, of Bromyard, husbandman 0
3858806 1976432 1976432 defendant Oliver John husbandman 608637 608637 Oliver, John, of Bromyard, husbandman 0
3859790 1976775 1976775 plaintiff Cole Richard   608637 608637 Cole, Richard, of Bromyard 0
3871060 1980573 1980573 defendant Bangell John yeoman 608637 608637 Bangell, John, of Bromyard, yeoman 0
3878487 1983050 1983050 defendant Smythe Richard innholder 608637 608637 Smythe, Richard, of Bromyard, innholder 0
3889902 1986862 1986862 defendant Blunte John gent 608637 608637 Blunte, John, of Bromyard, gent 1
3932806 2001276 2001276 defendant Wynton John yeoman 608637 608637 Wynton, John, of Bromyard, yeoman 0
3932807 2001276 2001276 defendant Elmore John yeoman 608637 608637 Elmore, John, of Bromyard, yeoman 1
3932834 2001276 2001276 defendant Carter James laborer 608637 608637 Carter, James, of Bromyard, laborer 28
3945227 2005416 2005416 defendant Blunte John gent 608637 608637 Blunte, John, of Bromyard, gent 0
3945228 2005416 2005416 defendant Byrde John husbandman 608637 608637 Byrde, John, of Bromyard, husbandman 1
3948705 2006613 2006613 defendant Hunt Henry yeoman 608637 608637 Hunt, Henry, of Bromyard, yeoman 0
3952113 2007810 2007810 defendant Hunt Roland gent 608637 608637 Hunt, Roland, of Bromyard, gent 0
3955322 2008931 2008931 defendant Blunte John gent 608637 608637 Blunte, John, of Bromyard, gent 1
3960687 2010837 2010837 defendant Bawlle Roger yeoman 608637 608637 Bawlle, Roger, of Bromyard, yeoman 0
3974915 2015792 2015792 defendant Monyngton Roger gent 608637 608637 Monyngton, Roger, of Bromyard, gent 0
3974916 2015792 2015792 defendant Wynton John yeoman 608637 608637 Wynton, John, of Bromyard, yeoman 1
3975151 2015873 2015873 defendant Jones Hugh fuller 608637 608637 Jones, Hugh, of Bromyard, fuller 0
3982048 2018339 2018339 defendant Hill Richard husbandman 608637 608637 Hill, Richard, of Bromyard, husbandman 0
3986925 2020066 2020066 defendant Smythe Thomas husbandman 608637 608637 Smythe, Thomas, of Bromyard, husbandman 0
4009152 2028041 2028041 plaintiff Myle Thomas husbandman 608637 608637 Myle, Thomas, of Bromyard, or of Grysmonderfeld, husbandman 0
4009166 2028048 2028048 plaintiff Myll Thomas yeoman 608637 608637 Myll, Thomas, of Bromyard, yeoman 0
4009168 2028049 2028049 plaintiff Myll Thomas yeoman 608637 608637 Myll, Thomas, of Bromyard, yeoman 0
4009173 2028050 2028050 defendant Tyler Humphrey tanner 608637 608637 Tyler, Humphrey, of Bromyard, tanner 2
4015367 2030189 2030189 defendant Danyell Walter mercer 608637 608637 Danyell, Walter, of Bromyard, mercer 1
4030597 2035603 2035603 defendant Danyell Walter chapman 608637 608637 Danyell, Walter, of Bromyard, chapman 1
4034177 2036886 2036886 defendant Blount John, junior gent 608637 608637 Blount, John, junior, of Bromyard, gent 0
4034179 2036887 2036887 defendant Blount John, junior gent 608637 608637 Blount, John, junior, of Bromyard, gent 0
4046612 2041239 2041239 defendant Cowell William butcher 608637 608637 Cowell, William, of Bromyard, butcher 0
4046614 2041240 2041240 defendant Cowell William butcher 608637 608637 Cowell, William, of Bromyard, butcher 0
4046616 2041241 2041241 defendant Cowell William butcher 608637 608637 Cowell, William, of Bromyard, butcher 0
4051567 2042979 2042979 plaintiff Wodnester Roger   608637 608637 Wodnester, Roger, of Bromyard 0
4059455 2045776 2045776 defendant Jones Richard   608637 608637 Jones, Richard, of Bromyard, carpenter, his son 1
4080874 2053470 2053470 plaintiff Wednester Roger gent 608637 608637 Wednester, Roger, of Bromyard, gent 0
4101037 2060685 2060685 defendant Grene John   608637 608637 Grene, John, of Bromyard, mason 3
4106620 2062658 2062658 defendant Cowell William butcher 608637 608637 Cowell, William, of Bromyard, butcher 0
4143463 2075873 2075873 defendant Akerwood John yeoman 608637 608637 Akerwood, John, of Bromyard, yeoman 0
4169212 2084735 2084735 defendant Bennett Robert husbandman 608637 608637 Bennett, Robert, of Bromyard, husbandman 2
4170588 2085211 2085211 defendant Hollyns Anthony innholder 608637 608637 Hollyns, Anthony, of Bromyard, innholder 0
4189970 2091995 2091995 defendant Munne Thomas glover 608637 608637 Munne, Thomas, of Bromyard, glover 0
4189971 2091995 2091995 defendant Capper Robert shoemaker 608637 608637 Capper, Robert, of Bromyard, shoemaker 1
4189972 2091995 2091995 defendant Hancoxe John fishmonger 608637 608637 together with Hancoxe, John, of Bromyard, fishmonger 2
4213478 2100232 2100232 defendant Hancockes John fishmonger 608637 608637 Hancockes, John, of Bromyard, fishmonger 0
4213479 2100232 2100232 defendant Mune Thomas glover 608637 608637 together with Mune, Thomas, of Bromyard, glover 1
4213480 2100232 2100232 defendant Capper Robert shoemaker 608637 608637 Capper, Robert, of Bromyard, shoemaker 2
4213539 2100252 2100252 defendant Payne alias Tanner John, junior yeoman 608637 608637 Payne alias Tanner, John, junior, of Bromyard, yeoman 0
4214264 2100507 2100507 defendant Heath Meredith yeoman 608637 608637 Heath, Meredith, of Bromyard, yeoman 0
4214265 2100507 2100507 defendant Bennett Robert yeoman 608637 608637 Bennett, Robert, of Bromyard, yeoman 1
4214788 2100678 2100678 defendant Heathe Meredith husbandman 608637 608637 Heathe, Meredith, of Bromyard, husbandman 0
4229584 2105832 2105832 defendant Bullocke William yeoman 608637 608637 Bullocke, William, of Bromyard, yeoman 2
4232825 2106986 2106986 defendant Hunt Richard gent 608637 608637 Hunt, Richard, of Bromyard, gent 0
4232827 2106986 2106986 defendant Hunt Henry gent 608637 608637 Hunt, Henry, of Bromyard, gent 2
4241084 2110004 2110004 defendant Grove William gent 608637 608637 Grove, William, of Bromyard, gent 0
4292696 2127450 2127450 defendant Browne William innholder 608637 608637 Browne, William, of Bromyard, innholder 2
4292697 2127450 2127450 defendant Bucknam Richard husbandman 608637 608637 Bucknam, Richard, of Bromyard, husbandman 3
4292779 2127479 2127479 defendant Browne Richard gent 608637 608637 Browne, Richard, of Bromyard, gent 0
4292838 2127502 2127502 defendant Carter James husbandman 608637 608637 Carter, James, of Bromyard, husbandman 0
4293571 2127764 2127764 defendant Cheswald Kenelm yeoman 608637 608637 Cheswald, Kenelm, of Bromyard, yeoman 0
4299078 2129768 2129768 defendant Glase Thomas butcher 608637 608637 Glase, Thomas, of Bromyard, butcher 1
4306672 2132472 2132472 defendant Bradford John mercer 608637 608637 Bradford, John, of Bromyard, mercer 0
4307497 2132760 2132760 defendant Glase Thomas butcher 608637 608637 Glase, Thomas, of Bromyard, butcher 1
4318039 2136416 2136416 defendant Bullocke William yeoman 608637 608637 Bullocke, William, of Bromyard, yeoman 1
4319289 2136855 2136855 defendant Perk Richard yeoman 608637 608637 Perk, Richard, of Bromyard, yeoman 0
4319734 2137015 2137015 defendant Jones William husbandman 608637 608637 Jones, William, of Bromyard, husbandman 0
4322142 2137824 2137824 defendant Rees John cordwainer 608637 608637 Rees, John, of Bromyard, cordwainer 0
4322143 2137824 2137824 defendant Hall Richard butcher 608637 608637 Hall, Richard, of Bromyard, butcher 1
4322144 2137824 2137824 defendant Brian Richard smith 608637 608637 Brian, Richard, of Bromyard, smith 2
4322145 2137824 2137824 defendant Stokes William tailor 608637 608637 Stokes, William, of Bromyard, tailor 3
4322955 2138092 2138092 defendant Grove William yeoman 608637 608637 Grove, William, of Bromyard, yeoman 2
4326466 2139214 2139214 defendant Cowell John butcher 608637 608637 Cowell, John, of Bromyard, butcher 0
4334040 2141665 2141665 defendant Hunt Richard gent 608637 608637 Hunt, Richard, of Bromyard, gent 0
4383241 2159113 2159113 defendant Ferrington Thomas shoemaker 608637 608637 Ferrington, Thomas, of Bromyard, shoemaker 1
4385135 2159716 2159716 defendant Synam John husbandman 608637 608637 Synam, John, of Bromyard, husbandman 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);