names

158 rows where place_id = 593027

✎ 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
3610122 1870830 1870830 defendant Spekcote John esq 593027 593027 Spekcote, John, of Thornbury, esq 0
3610124 1870830 1870830 defendant Marshall John husbandman 593027 593027 Marshall, John, of Thornbury, husbandman 2
3617901 1873222 1873222 defendant Spekcote John esq 593027 593027 Spekcote, John, of Thornbury, esq 0
3617903 1873222 1873222 defendant Mershall John husbandman 593027 593027 Mershall, John, of Thornbury, husbandman 2
3633215 1905202 1905202 defendant Hayne William innholder 593027 593027 Hayne, William, of Thornbury, innholder 0
3633216 1905202 1905202 defendant Hayne Margery spinster 593027 593027 Hayne, Margery, of Thornbury, spinster 1
3651193 1910740 1910740 defendant Seynt George John gent 593027 593027 Seynt George, John, of Thornbury, gent 0
3713617 1930570 1930570 defendant Colwey Richard husbandman 593027 593027 Colwey, Richard, of Thornbury, husbandman 0
3720844 1932812 1932812 defendant Gay Robert husbandman 593027 593027 Gay, Robert, of Thornbury, husbandman 0
3733174 1936607 1936607 defendant Thomas Robert yeoman 593027 593027 Thomas, Robert, of Thornbury, yeoman 4
3747727 1941209 1941209 defendant Colanton Henry tanner 593027 593027 Colanton, Henry, of Thornbury, tanner 0
3759910 1945092 1945092 defendant Orchard Thomas tailor 593027 593027 Orchard, Thomas, of Thornbury, tailor 0
3771682 1948842 1948842 defendant Colynge John husbandman 593027 593027 Colynge, John, of Thornbury, husbandman 3
3773881 1949541 1949541 defendant Fowler John miller 593027 593027 Fowler, John, of Thornbury, miller 0
3799743 1957841 1957841 defendant Lynke John husbandman 593027 593027 Lynke, John, of Thornbury, husbandman 0
3879872 1983527 1983527 defendant Heynes Thomas husbandman 593027 593027 Heynes, Thomas, of Thornbury, husbandman 0
3884467 1985078 1985078 plaintiff Acham William   593027 593027 Acham, William, of Thornbury 0
3890998 1987251 1987251 defendant A Morgan John tanner 593027 593027 A Morgan, John, of Thornbury, tanner 0
3907395 1992765 1992765 defendant Typper John yeoman 593027 593027 Typper, John, of Thornbury, yeoman 1
3914256 1995112 1995112 defendant Keddy Richard tanner 593027 593027 Keddy, Richard, of Thornbury, tanner 0
3914257 1995112 1995112 defendant More John weaver 593027 593027 More, John, of Thornbury, weaver 1
3914258 1995112 1995112 defendant Hamden Richard gent 593027 593027 Hamden, Richard, of Thornbury, gent 2
3917844 1996327 1996327 defendant More John clothier 593027 593027 More, John, of Thornbury, clothier 0
3942063 2004361 2004361 defendant Wynt Henry yeoman 593027 593027 Wynt, Henry, of Thornbury, yeoman 1
4037271 2037994 2037994 plaintiff Jones John, junior clothier 593027 593027 Jones, John, junior, of Thornbury, clothier 0
4165778 2083531 2083531 defendant Newell Thomas yeoman 593027 593027 Newell, Thomas, of Thornbury, or of Horton, yeoman 0
4165779 2083531 2083531 defendant Newell Julian or Gillian widow 593027 593027 Newell, Julian or Gillian, of Thornbury, or of Horton, widow 1
4177477 2087597 2087597 defendant Lewes Gregory carpenter 593027 593027 Lewes, Gregory, of Thornbury, carpenter 2
4187558 2091149 2091149 defendant Segar James husbandman 593027 593027 Segar, James, of Thornbury, husbandman 0
4188325 2091421 2091421 defendant Segar James husbandman 593027 593027 Segar, James, of Thornbury, husbandman 0
4188332 2091423 2091423 defendant Segar James husbandman 593027 593027 Segar, James, of Thornbury, husbandman 0
4200266 2095645 2095645 defendant Haynes William husbandman 593027 593027 Haynes, William, of Thornbury, husbandman 0
4212929 2100051 2100051 defendant Earle William husbandman 593027 593027 Earle, William, of Thornbury, husbandman 0
4216136 2101133 2101133 defendant Crondall Katherine widow 593027 593027 Crondall, Katherine, of Thornbury, widow 1
4225441 2104362 2104362 defendant Crondall Katherine widow 593027 593027 Crondall, Katherine, of Thornbury, widow 1
4243199 2110717 2110717 defendant Eddys James tanner 593027 593027 Eddys, James, of Thornbury, tanner 0
4248756 2112569 2112569 defendant Hopkyns Richard weaver 593027 593027 Hopkyns, Richard, of Thornbury, weaver 0
4281237 2123347 2123347 defendant Hickman Richard gent 593027 593027 Hickman, Richard, of Thornbury, or of Yates Court, Glos, gent 0
4284856 2124630 2124630 defendant Eddice James tanner 593027 593027 Eddice, James, of Thornbury, tanner 0
4306541 2132426 2132426 defendant Pooler Henry gent 593027 593027 Pooler, Henry, of Thornbury, gent 1
4309958 2133642 2133642 defendant Earle John husbandman 593027 593027 Earle, John, of Thornbury, husbandman 0
4309962 2133644 2133644 defendant Moore William tanner 593027 593027 Moore, William, of Thornbury, tanner 0
4309964 2133645 2133645 defendant Williames William butcher 593027 593027 Williames, William, of Thornbury, butcher 0
4311675 2134226 2134226 defendant Whitfeyld John yeoman 593027 593027 Whitfeyld, John, of Thornbury, or of Kyngton, yeoman 0
4315618 2135573 2135573 defendant Barton William butcher 593027 593027 Barton, William, of Thornbury, butcher 0
4320723 2137343 2137343 defendant Jones   husbandman 593027 593027 Jones, , of Thornbury, husbandman 0
4321428 2137587 2137587 defendant Huntley William gent 593027 593027 Huntley, William, of Thornbury, or of Boxwell, Glos, gent 0
4328634 2139891 2139891 defendant Jones Philip yeoman 593027 593027 Jones, Philip, of Thornbury, yeoman 0
4328636 2139892 2139892 defendant Wisse or Wishe John gent 593027 593027 Wisse or Wishe, John, of Thornbury, gent 0
4328637 2139892 2139892 defendant Wisse or Wishe Nicholas gent 593027 593027 Wisse or Wishe, Nicholas, of Thornbury, gent 1
4344870 2145484 2145484 defendant Eddice James tanner 593027 593027 Eddice, James, of Thornbury, tanner 0
4344936 2145507 2145507 defendant Ogborne William yeoman 593027 593027 Ogborne, William, of Thornbury, yeoman 2
4366419 2153032 2153032 defendant Ogborne William husbandman 593027 593027 Ogborne, William, of Thornbury, husbandman 0
4372204 2155124 2155124 defendant Earle William yeoman 593027 593027 Earle, William, of Thornbury, yeoman 1
4394783 2162841 2162841 defendant Lawrence James gent 593027 593027 Lawrence, James, of Thornbury, gent 0
4396926 2163542 2163542 defendant Whittingham Thomas gent 593027 593027 Whittingham, Thomas, of Thornbury, or of Kyneton, gent 0
4398955 2164233 2164233 defendant Laurence James gent 593027 593027 Laurence, James, of Thornbury, or of Hope, gent 1
4408066 2167268 2167268 defendant London Geoffrey yeoman 593027 593027 London, Geoffrey, of Thornbury, yeoman 0
4449859 2184907 2184907 plaintiff Lye Peter de   593027 593027 Lye, Peter de, of Thornbury 1
4475816 2193107 2193107 defendant Kyng William   593027 593027 Kyng, William, of Thornbury 0
4475817 2193107 2193107 defendant Kyng John   593027 593027 Kyng, John, of Thornbury 1
4548873 2215583 2215583 plaintiff Clyvedon William   593027 593027 Clyvedon, William, of Thornbury 0
4577473 2224469 2224469 defendant Haukyns Robert   593027 593027 Haukyns, Robert, of Thornbury 0
4607518 2233464 2233464 defendant Edewyth Robert   593027 593027 Edewyth, Robert, of Thornbury 1
4623420 2238298 2238298 defendant Southmede Simon   593027 593027 (Southmede, Simon, of Thornbury 3
4651562 2246488 2246488 defendant Jon Richard, junior   593027 593027 Jon, Richard, junior, of Thornbury, bailiff 7
4677379 2258543 2258543 plaintiff Hany or Havy William   593027 593027 Hany or Havy, William, of Thornbury 0
4677646 2258625 2258625 defendant Hanynges John laborer 593027 593027 Hanynges, John, of Thornbury, laborer 1
4682020 2259994 2259994 defendant Keysote Walter baker 593027 593027 Keysote, Walter, of Thornbury, baker 0
4687463 2261673 2261673 defendant Bussher John baker 593027 593027 Bussher, John, of Thornbury, baker 1
4687464 2261673 2261673 defendant Champeneys John cornmonger 593027 593027 Champeneys, John, of Thornbury, cornmonger 2
4695246 2263994 2263994 defendant Poyte William drover 593027 593027 Poyte, William, of Thornbury, drover 0
4695247 2263994 2263994 defendant Poyte Richard drover 593027 593027 Poyte, Richard, of Thornbury, drover 1
4698932 2265144 2265144 defendant Tethyngman Richard husbandman 593027 593027 Tethyngman, Richard, of Thornbury, husbandman 5
4703118 2266352 2266352 defendant Hanynges John laborer 593027 593027 Hanynges, John, of Thornbury, laborer 1
4707039 2267584 2267584 defendant Lytmay Thomas husbandman 593027 593027 Lytmay, Thomas, of Thornbury, husbandman 0
4719627 2271482 2271482 defendant Pengreseka John esq 593027 593027 Pengreseka, John, of Thornbury, esq 0
4782079 2290396 2290396 plaintiff Clyvedon William (legal representative) 593027 593027 Clyvedon, William, of Thornbury, executors of 0
4787509 2292164 2292164 defendant Danyell John husbandman 593027 593027 Danyell, John, of Thornbury, husbandman 2
4824364 2303682 2303682 defendant Tyler John mercer 593027 593027 Tyler, John, of Thornbury, mercer 0
4835052 2306964 2306964 defendant Maryfeld Thomas belymaker 593027 593027 Maryfeld, Thomas, of Thornbury, belymaker 0
4838283 2307892 2307892 defendant Knyght Richard husbandman 593027 593027 Knyght, Richard, of Thornbury, husbandman 4
4838284 2307892 2307892 defendant Glonvyle or Glouvyle John husbandman 593027 593027 Glonvyle or Glouvyle, John, of Thornbury, husbandman 5
4838447 2307940 2307940 defendant Tonell John chapman 593027 593027 Tonell, John, of Thornbury, chapman 3
4843940 2309622 2309622 defendant Plommer William baker 593027 593027 Plommer, William, of Thornbury, baker 0
4843941 2309622 2309622 defendant Marschall Agnes widow 593027 593027 Marschall, Agnes, of Thornbury, widow 1
4846342 2310362 2310362 defendant Wyth William laborer 593027 593027 Wyth, William, of Thornbury, laborer 4
4846343 2310362 2310362 defendant Kere Nicholas tanner 593027 593027 Kere, Nicholas, of Thornbury, tanner 5
4846344 2310362 2310362 defendant Jones Prest Erneburgh John clerk 593027 593027 Jones Prest Erneburgh, John, of Thornbury, clerk 6
4854012 2312664 2312664 defendant Whyte William husbandman 593027 593027 Whyte, William, of Thornbury, husbandman 0
4856182 2313307 2313307 defendant Corveser Mathew cordwainer 593027 593027 Corveser, Mathew, of Thornbury, cordwainer 0
4859019 2314201 2314201 defendant Benet John dyer 593027 593027 Benet, John, of Thornbury, dyer 0
4881023 2320976 2320976 defendant Bernys Richard husbandman 593027 593027 Bernys, Richard, of Thornbury, husbandman 0
4940779 2339144 2339144 defendant Knyght Henry husbandman 593027 593027 Knyght, Henry, of Thornbury, husbandman 2
4940780 2339144 2339144 defendant Vyell Robert husbandman 593027 593027 Vyell, Robert, of Thornbury, husbandman 3
4940781 2339144 2339144 defendant Tomme John husbandman 593027 593027 Tomme, John, of Thornbury, husbandman 4
4965137 2346497 2346497 defendant Downe John husbandman 593027 593027 Downe, John, of Thornbury, husbandman 0
4965139 2346498 2346498 defendant Vyell Robert husbandman 593027 593027 Vyell, Robert, of Thornbury, husbandman 0
4965140 2346498 2346498 defendant Prous Robert husbandman 593027 593027 together with Prous, Robert, of Thornbury, husbandman 1
4965148 2346501 2346501 defendant Vyell Robert husbandman 593027 593027 Vyell, Robert, of Thornbury, 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);