names

108 rows where place_id = 594894

✎ 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
3618035 1873262 1873262 defendant Harryes John yeoman 594894 594894 Harryes, John, of Wyngham, yeoman 0
3634420 1905565 1905565 defendant Abery or Avery John husbandman 594894 594894 Abery or Avery, John, of Wyngham, husbandman 0
3666834 1915568 1915568 defendant Guylter William gent 594894 594894 Guylter, William, of Wyngham, gent 0
3684403 1921253 1921253 defendant Fann Peter husbandman 594894 594894 Fann, Peter, of Wyngham, husbandman 0
3684405 1921253 1921253 defendant Jerves Simon tailor 594894 594894 Jerves, Simon, of Wyngham, tailor 2
3685147 1921503 1921503 defendant A Bery John   594894 594894 A Bery, John, of Wyngham, wax chandler 2
3743042 1939672 1939672 defendant Mathewe William yeoman 594894 594894 Mathewe, William, of Wyngham, yeoman 0
3793374 1955790 1955790 defendant Benger Richard clerk 594894 594894 Benger, Richard, of Wyngham, clerk 0
3800989 1958219 1958219 plaintiff Mathew William merchant 594894 594894 Mathew, William, of Wyngham, merchant 0
3821028 1964469 1964469 defendant Spakysley Thomas   594894 594894 Spakysley, Thomas, of Wyngham, brick maker 0
3827373 1966426 1966426 defendant Fysher John yeoman 594894 594894 Fysher, John, of Wyngham, yeoman 0
3863362 1977942 1977942 defendant Sawnder Henry husbandman 594894 594894 Sawnder, Henry, of Wyngham, husbandman 0
3870155 1980264 1980264 defendant Fyssher John yeoman 594894 594894 Fyssher, John, of Wyngham, yeoman 0
3890014 1986896 1986896 defendant Benger Richard clerk 594894 594894 Benger, Richard, of Wyngham, clerk 0
3904129 1991624 1991624 defendant Benger Richard clerk 594894 594894 Benger, Richard, of Wyngham, clerk 0
3966891 2013053 2013053 defendant Arrundell Thomas esq 594894 594894 Arrundell, Thomas, of Wyngham, esq 0
3966892 2013053 2013053 defendant Tymbe Thomas laborer 594894 594894 Tymbe, Thomas, of Wyngham, laborer 1
3966893 2013053 2013053 defendant Vyncent John laborer 594894 594894 Vyncent, John, of Wyngham, laborer 2
3989836 2021115 2021115 defendant Arrundell Thomas gent 594894 594894 Arrundell, Thomas, of Wyngham, gent 0
4008157 2027684 2027684 defendant Fludde William weaver 594894 594894 Fludde, William, of Wyngham, weaver 0
4008800 2027908 2027908 defendant Morrice Edmund yeoman 594894 594894 Morrice, Edmund, of Wyngham, yeoman 0
4010239 2028430 2028430 defendant Palmer Thomas gent 594894 594894 Palmer, Thomas, of Wyngham, gent 0
4010244 2028431 2028431 defendant Palmer Thomas gent 594894 594894 Palmer, Thomas, of Wyngham, gent 0
4024427 2033415 2033415 defendant Hodgekyn Thomas gent 594894 594894 Hodgekyn, Thomas, of Wyngham, gent 0
4037241 2037984 2037984 plaintiff Jones Henry, senior yeoman 594894 594894 Jones, Henry, senior, of Wyngham, yeoman 0
4037243 2037985 2037985 plaintiff Jones Henry, senior yeoman 594894 594894 Jones, Henry, senior, of Wyngham, yeoman 0
4050734 2042697 2042697 defendant Hodgekyn Thomas gent 594894 594894 Hodgekyn, Thomas, of Wyngham, gent 0
4052383 2043274 2043274 defendant Hollowell William   594894 594894 Hollowell, William, of Wyngham yeoman 0
4098971 2059956 2059956 defendant Hodgkyn Thomas innholder 594894 594894 Hodgkyn, Thomas, of Wyngham, innholder 1
4104132 2061752 2061752 defendant Ratclyff Bartholomew butcher 594894 594894 Ratclyff, Bartholomew, of Wyngham, butcher 0
4402066 2165280 2165280 defendant Curtyce John carpenter 594894 594894 Curtyce, John, of Wyngham, carpenter 0
4402067 2165280 2165280 defendant Averell William butcher 594894 594894 Averell, William, of Wyngham, butcher 1
4402068 2165280 2165280 defendant Cowell Benett widow 594894 594894 Cowell, Benett, of Wyngham, widow 2
4481389 2194870 2194870 defendant Woghelete John   594894 594894 Woghelete, John, of Wyngham 0
4481391 2194871 2194871 defendant Mattere Thomas   594894 594894 Mattere, Thomas, of Wyngham 0
4489079 2197302 2197302 defendant Matter John   594894 594894 Matter, John, of Wyngham 2
4516416 2205544 2205544 defendant Parkere William   594894 594894 Parkere, William, of Wyngham 3
4531097 2210005 2210005 plaintiff Parkere William   594894 594894 Parkere, William, of Wyngham 0
4610955 2234499 2234499 plaintiff Cherchegate William   594894 594894 Cherchegate, William, of Wyngham 0
4630442 2240432 2240432 defendant Aldemed Thomas   594894 594894 Aldemed, Thomas, of Wyngham 1
4651632 2246501 2246501 defendant Twytham James husbandman 594894 594894 Twytham, James, of Wyngham, husbandman 1
4651807 2246513 2246513 defendant Twytham James husbandman 594894 594894 Twytham, James, of Wyngham, husbandman 1
4656832 2248031 2248031 defendant Loges Robert laborer 594894 594894 (Loges, Robert, of Wyngham, laborer 7
4656833 2248031 2248031 defendant Neketon Michael laborer 594894 594894 Neketon, Michael, of Wyngham, laborer 8
4686413 2261355 2261355 defendant Herry Henry skinner 594894 594894 Herry, Henry, of Wyngham, skinner 2
4688977 2262109 2262109 defendant D-ahere Joan widow 594894 594894 D-ahere, Joan, of Wyngham, widow 0
4690203 2262493 2262493 plaintiff Welmyston Isabel   594894 594894 Welmyston, Isabel, of Wyngham, formerly wife of Thomas Welmyston 0
4696697 2264444 2264444 defendant Pryket John   594894 594894 Pryket, John, of Wyngham, rope maker 2
4744473 2278905 2278905 defendant Jardyn John baker 594894 594894 Jardyn, John, of Wyngham, baker 0
4757173 2282611 2282611 defendant Keleras William husbandman 594894 594894 Keleras, William, of Wyngham, husbandman 0
4779203 2289472 2289472 defendant Tropham John, junior laborer 594894 594894 Tropham, John, junior, of Wyngham, laborer 0
4781254 2290150 2290150 defendant Watier John chaplain 594894 594894 Watier, John, of Wyngham, chaplain 0
4893810 2324760 2324760 defendant Jardyn John baker 594894 594894 Jardyn, John, of Wyngham, baker 0
4906866 2328732 2328732 defendant Jardyn John husbandman 594894 594894 Jardyn, John, of Wyngham, husbandman 2
4920482 2332921 2332921 defendant Bonyngton William gent 594894 594894 Bonyngton, William, of Wyngham, gent 0
4930693 2336012 2336012 defendant Hewet James carpenter 594894 594894 Hewet, James, of Wyngham, carpenter 0
4937367 2338054 2338054 defendant Pecok Robert clerk 594894 594894 Pecok, Robert, of Wyngham, clerk 0
4937386 2338062 2338062 defendant Lynde William husbandman 594894 594894 Lynde, William, of Wyngham, husbandman 1
4937389 2338063 2338063 defendant Lynde William husbandman 594894 594894 Lynde, William, of Wyngham, husbandman 1
4962811 2345788 2345788 defendant Lynde William husbandman 594894 594894 Lynde, William, of Wyngham, husbandman 0
4964988 2346445 2346445 defendant Geredyn John baker 594894 594894 Geredyn, John, of Wyngham, baker 0
4973038 2348867 2348867 defendant Langham Thomas tanner 594894 594894 Langham, Thomas, of Wyngham, tanner 0
4983898 2352113 2352113 defendant Jerdyn John husbandman 594894 594894 Jerdyn, John, of Wyngham, husbandman 0
4987646 2353267 2353267 defendant Jardyn John yeoman 594894 594894 Jardyn, John, of Wyngham, yeoman 1
4999245 2356646 2356646 defendant Pette Thomas husbandman 594894 594894 Pette, Thomas, of Wyngham, husbandman 0
5060631 2374759 2374759 defendant Faykyn Richard butcher 594894 594894 Faykyn, Richard, of Wyngham, butcher 0
5066974 2376647 2376647 defendant Ildirgate John esq 594894 594894 Ildirgate, John, of Wyngham, esq 0
5075162 2379069 2379069 defendant Hardys Robert laborer 594894 594894 Hardys, Robert, of Wyngham, laborer 1
5083726 2381636 2381636 defendant Sharp John husbandman 594894 594894 Sharp, John, of Wyngham, husbandman 1
5087987 2382862 2382862 defendant Huwet James husbandman 594894 594894 Huwet, James, of Wyngham, husbandman 0
5091964 2384028 2384028 defendant Ildirgate John esq 594894 594894 Ildirgate, John, of Wyngham, esq 0
5102526 2387142 2387142 plaintiff Bille John   594894 594894 Bille, John, of Wyngham 0
5102774 2387229 2387229 defendant Hardes Robert laborer 594894 594894 Hardes, Robert, of Wyngham, laborer 0
5104983 2387898 2387898 defendant Ildergate John gent 594894 594894 Ildergate, John, of Wyngham, gent 0
5108928 2389031 2389031 defendant Jardyn John baker 594894 594894 Jardyn, John, of Wyngham, baker 4
5128120 2394698 2394698 defendant Ildergate John gent 594894 594894 Ildergate, John, of Wyngham, gent 0
5131603 2395724 2395724 defendant Bomide Thomas carpenter 594894 594894 Bomide, Thomas, of Wyngham, carpenter 0
5136103 2397070 2397070 defendant Jardeyn John husbandman 594894 594894 Jardeyn, John, of wyngham, husbandman 2
5147196 2400319 2400319 defendant Ildergate John gent 594894 594894 Ildergate, John, of Wyngham, gent 0
5151080 2401458 2401458 defendant Bounde Thomas carpenter 594894 594894 Bounde, Thomas, of Wyngham, carpenter 0
5159514 2403899 2403899 defendant Tropham Robert yeoman 594894 594894 Tropham, Robert, of Wyngham, yeoman 0
5202153 2416394 2416394 defendant Sharp John   594894 594894 Sharp, John, of Wyngham, tallow chandler 0
5202154 2416394 2416394 defendant Sheteryngden James yeoman 594894 594894 Sheteryngden, James, of Wyngham, yeoman 1
5202155 2416394 2416394 defendant Taillour John laborer 594894 594894 Taillour, John, of Wyngham, laborer 2
5209249 2418436 2418436 defendant Tropham Robert yeoman 594894 594894 Tropham, Robert, of Wyngham, yeoman 0
5293353 2443037 2443037 plaintiff Shetyrden John   594894 594894 Shetyrden, John, of Wyngham 0
5293354 2443037 2443037 defendant Norton William laborer 594894 594894 Norton, William, of Wyngham, laborer 0
5325044 2452571 2452571 defendant Whitnay Ricard butcher 594894 594894 Whitnay, Ricard, of Wyngham, butcher 1
5336660 2456035 2456035 defendant Brounyng Robert yeoman 594894 594894 Brounyng, Robert, of Wyngham, yeoman 0
5350509 2460279 2460279 defendant Beche William tiler 594894 594894 Beche, William, of Wyngham, tiler 0
5350510 2460279 2460279 defendant Frigge Thomas laborer 594894 594894 Frigge, Thomas, of Wyngham, laborer 1
5357788 2462506 2462506 defendant Overton Thomas gent 594894 594894 Overton, Thomas, of Wyngham, gent 0
5360193 2463230 2463230 defendant Overton Thomas gent 594894 594894 Overton, Thomas, of Wyngham, gent 0
5362666 2463972 2463972 defendant Neweman Edward husbandman 594894 594894 Neweman, Edward, of Wyngham, husbandman 2
5362668 2463972 2463972 defendant Berteyn James husbandman 594894 594894 Berteyn, James, of Wyngham, husbandman 4
5370645 2466408 2466408 defendant Whitmay Richard butcher 594894 594894 Whitmay, Richard, of Wyngham, butcher 0
5371444 2466651 2466651 defendant Peverll Richard gent 594894 594894 Peverll, Richard, of Wyngham, gent 0
5371445 2466651 2466651 defendant Gorham William husbandman 594894 594894 Gorham, William, of Wyngham, husbandman 1
5371446 2466651 2466651 defendant Herney Henry chaplain 594894 594894 Herney, Henry, of Wyngham, chaplain 2
5383732 2470431 2470431 defendant Gybbes Thomas butcher 594894 594894 Gybbes, Thomas, of Wyngham, butcher 3

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);