names

101 rows where place_id = 588457

✎ 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
3594563 1865929 1865929 defendant Tayllour William fishmonger 588457 588457 Tayllour, William, of Thaxsted, Essex, fishmonger 0
3600994 1867974 1867974 defendant Quadryng Alexander esq 588457 588457 (Quadryng, Alexander, of Thaxsted, Essex, esq 1
3622560 1874592 1874592 defendant Merlyng John esq 588457 588457 Merlyng, John, of Thaxsted, Essex, esq 1
3662593 1914220 1914220 defendant Petytt Anne widow 588457 588457 Petytt, Anne, of Thaxsted, Essex, widow 0
3674323 1918014 1918014 plaintiff Glover John (legal representative) 588457 588457 Glover, John, of Thaxsted, Essex, executors of 0
3683255 1920883 1920883 defendant Cutt John   588457 588457 Cutt, John, of Thaxsted, Essex, knight 2
3684635 1921328 1921328 plaintiff Aburford John draper 588457 588457 Aburford, John, of Thaxsted, Essex, draper 0
3720087 1932558 1932558 defendant Appulford John, senior draper 588457 588457 Appulford, John, senior, of Thaxsted, Essex, draper 0
3733262 1936637 1936637 defendant Symson Richard paler 588457 588457 Symson, Richard, of Thaxsted, Essex, paler 3
3737878 1938066 1938066 defendant Aberforth John draper 588457 588457 Aberforth, John, of Thaxsted, Essex, draper 0
3748673 1941512 1941512 defendant Appylford John draper 588457 588457 Appylford, John, of Thaxsted, Essex, draper 0
3748674 1941512 1941512 defendant Appylford William, senior draper 588457 588457 Appylford, William, senior, of Thaxsted, Essex, draper 1
3748675 1941512 1941512 defendant Appylford John, junior draper 588457 588457 Appylford, John, junior, of Thaxsted, Essex, draper 2
3753493 1943029 1943029 defendant Appulforth John, senior draper 588457 588457 Appulforth, John, senior, of Thaxsted, Essex, draper 1
3766054 1947049 1947049 defendant Love Richard husbandman 588457 588457 Love, Richard, of Thaxsted, Essex, husbandman 0
3781238 1951872 1951872 defendant Davy John pardoner 588457 588457 Davy, John, of Thaxsted, Essex, pardoner 1
3793653 1955877 1955877 defendant Abarforth William yeoman 588457 588457 Abarforth, William, of Thaxsted, Essex, yeoman 0
3817758 1963458 1963458 defendant More alias Talyer William yeoman 588457 588457 More alias Talyer, William, of Thaxsted, Essex, yeoman 0
3832211 1967985 1967985 defendant Longe William chapman 588457 588457 Longe, William, of Thaxsted, Essex, chapman 3
3833481 1968402 1968402 defendant More alias Taylor John fishmonger 588457 588457 More alias Taylor, John, of Thaxsted, Essex, fishmonger 0
3849234 1973352 1973352 defendant Kyng William chapman 588457 588457 Kyng, William, of Thaxsted, Essex, chapman 3
3880106 1983601 1983601 plaintiff Patsall Walter (legal representative) 588457 588457 Patsall, Walter, of Thaxsted, Essex, executrix of 0
3893737 1988126 1988126 defendant Northe Thomas chapman 588457 588457 Northe, Thomas, of Thaxsted, Essex, chapman 0
3894703 1988434 1988434 defendant Northe Thomas chapman 588457 588457 Northe, Thomas, of Thaxsted, Essex, chapman 0
3902688 1991131 1991131 plaintiff Fanne John yeoman 588457 588457 Fanne, John, of Thaxsted, Essex, yeoman 0
3932093 2001038 2001038 defendant Gowghey John tanner 588457 588457 Gowghey, John, of Thaxsted, Essex, tanner 0
4130498 2071219 2071219 defendant Symon William yeoman 588457 588457 Symon, William, of Thaxsted, Essex, yeoman 0
4179930 2088459 2088459 defendant Ryche Rook yeoman 588457 588457 Ryche, Rook, of Thaxsted, Essex, yeoman 1
4213868 2100371 2100371 defendant Scotte Thomas yeoman 588457 588457 Scotte, Thomas, of Thaxsted, Essex, yeoman 0
4307198 2132654 2132654 defendant Holland Thomas gent 588457 588457 Holland, Thomas, of Thaxsted, Essex, gent 1
4346364 2145985 2145985 defendant Key Jeremy yeoman 588457 588457 Key, Jeremy, of Thaxsted, Essex, yeoman 0
4351927 2147912 2147912 defendant Scott Thomas yeoman 588457 588457 Scott, Thomas, of Thaxsted, Essex, yeoman 0
4681681 2259880 2259880 defendant Hasilbrook John sheather 588457 588457 Hasilbrook, John, of Thaxsted, Essex, sheather 1
4806703 2298305 2298305 defendant White John butcher 588457 588457 White, John, of Thaxsted, Essex, butcher 0
4834385 2306761 2306761 defendant Crouse John husbandman 588457 588457 Crouse, John, of Thaxsted, Essex, husbandman 0
4845964 2310244 2310244 defendant Feld John   588457 588457 Feld, John, of Thaxsted, Essex, smyth 0
4845970 2310245 2310245 defendant Ponde John cutler 588457 588457 Ponde, John, of Thaxsted, Essex, cutler 2
4852910 2312330 2312330 defendant Squery Thomas gent 588457 588457 Squery, Thomas, of Thaxsted, Essex, gent 0
4909978 2329648 2329648 defendant Whithed Robert, junior cutler 588457 588457 Whithed, Robert, junior, of Thaxsted, Essex, cutler 0
4910100 2329681 2329681 defendant Spylman Thomas draper 588457 588457 Spylman, Thomas, of Thaxsted, Essex, draper 0
4910102 2329682 2329682 defendant Spylman Thomas draper 588457 588457 Spylman, Thomas, of Thaxsted, Essex, draper 0
4922073 2333312 2333312 defendant Hadstoke John cutler 588457 588457 Hadstoke, John, of Thaxsted, Essex, cutler 2
4929369 2335603 2335603 defendant Sower Richard pedder 588457 588457 Sower, Richard, of Thaxsted, Essex, pedder 1
4932493 2336557 2336557 defendant Porter John merchant 588457 588457 Porter, John, of Thaxsted, Essex, merchant 2
4933371 2336824 2336824 defendant Rede Thomas yeoman 588457 588457 Rede, Thomas, of Thaxsted, Essex, yeoman 0
4986682 2352950 2352950 defendant Colyn William dyer 588457 588457 Colyn, William, of Thaxsted, Essex, dyer 1
4991835 2354443 2354443 defendant Parker John chapman 588457 588457 Parker, John, of Thaxsted, Essex, chapman 0
5022803 2363582 2363582 defendant Crakebon Mathew dyer 588457 588457 Crakebon, Mathew, of Thaxsted, Essex, dyer 0
5022809 2363583 2363583 defendant Crakebon Mathew dyer 588457 588457 Crakebon, Mathew, of Thaxsted, Essex, dyer 0
5035240 2367170 2367170 defendant Grantisden Nicholas cutler 588457 588457 Grantisden, Nicholas, of Thaxsted, Essex, cutler 2
5035246 2367171 2367171 defendant Grantisden Nicholas cutler 588457 588457 Grantisden, Nicholas, of Thaxsted, Essex, cutler 2
5043480 2369672 2369672 defendant Boydon Henry yeoman 588457 588457 Boydon, Henry, of Thaxsted, Essex, yeoman 0
5101287 2386785 2386785 defendant Smyth John cordwainer 588457 588457 Smyth,John, of Thaxsted, Essex, cordwainer 0
5101290 2386786 2386786 defendant Smyth John (legal representative) 588457 588457 Smyth, John, of Thaxsted, cordewainer, Essex, executor of 0
5114695 2390712 2390712 defendant Balston Richard chapman 588457 588457 Balston, Richard, of Thaxsted, Essex, chapman 1
5114702 2390713 2390713 defendant Durwald William chapman 588457 588457 Durwald, William, of Thaxsted, Essex, chapman 4
5114711 2390717 2390717 defendant Damere John chapman 588457 588457 Damere, John, of Thaxsted, Essex, chapman 1
5114719 2390719 2390719 defendant Shether John chapman 588457 588457 Shether, John, of Thaxsted, Essex, chapman 0
5118903 2391959 2391959 defendant James John chapman 588457 588457 James, John, of Thaxsted, Essex, chapman 0
5121424 2392698 2392698 defendant Wann Henry cutler 588457 588457 Wann, Henry, of Thaxsted, Essex, cutler 0
5130025 2395266 2395266 defendant Fryday William draper 588457 588457 Fryday, William, of Thaxsted, Essex, draper 1
5150006 2401134 2401134 defendant Cutteler John cutler 588457 588457 Cutteler, John, of Thaxsted, Essex, cutler 2
5166732 2405994 2405994 defendant Waterforthe John   588457 588457 Waterforthe, John, of Thaxsted, Essex, blade smith 0
5168721 2406576 2406576 defendant Cutteler John cuttler 588457 588457 Cutteler, John, of Thaxsted, Essex, cuttler 2
5169395 2406783 2406783 defendant Feld Roger cutler 588457 588457 Feld, Roger, of Thaxsted, Essex, cutler 0
5184746 2411288 2411288 defendant Cuteler John cutler 588457 588457 Cuteler, John, of Thaxsted, Essex, cutler 2
5184751 2411289 2411289 defendant Cuteler John cutler 588457 588457 Cuteler, John, of Thaxsted, Essex, cutler 2
5186644 2411842 2411842 defendant Janys John chapman 588457 588457 Janys, John, of Thaxsted, Essex, chapman 4
5205282 2417301 2417301 defendant Jamys John chapman 588457 588457 Jamys, John, of Thaxsted, Essex, chapman 1
5221426 2421963 2421963 defendant Glover William glover 588457 588457 Glover, William, of Thaxsted, Essex, glover 2
5304145 2446248 2446248 defendant Fryday William draper 588457 588457 Fryday, William, of Thaxsted, Essex, draper 0
5321947 2451633 2451633 defendant Damary Richard husbandman 588457 588457 Damary, Richard, of Thaxsted, Essex, husbandman 2
5329168 2453801 2453801 defendant Haruf or Harus William barker 588457 588457 Haruf or Harus, William, of Thaxsted, Essex, barker 0
5351182 2460468 2460468 plaintiff Dadon John, junior   588457 588457 Dadon, John, junior, of Thaxsted, Essex 0
5351495 2460563 2460563 defendant Fan Richard butcher 588457 588457 Fan, Richard, of Thaxsted, Essex, butcher 0
5356725 2462167 2462167 defendant Damary Richard yeoman 588457 588457 Damary, Richard, of Thaxsted, Essex, yeoman 2
5373691 2467368 2467368 defendant Jemes John chapman 588457 588457 Jemes, John, of Thaxsted, Essex, chapman 0
5373693 2467368 2467368 defendant Barnard John chapman 588457 588457 Barnard, John, of Thaxsted, Essex, chapman 2
5374332 2467575 2467575 defendant Quadryng Alexander gent 588457 588457 (Quadryng, Alexander, of Thaxsted, Essex, gent 1
5374909 2467745 2467745 defendant Hanchech John gent 588457 588457 Hanchech, John, of Thaxsted, Essex, gent 3
5391445 2472627 2472627 defendant Hencheth John yeoman 588457 588457 Hencheth, John, of Thaxsted, Essex, yeoman 4
5398961 2474773 2474773 defendant Bultell John cutler 588457 588457 Bultell, John, of Thaxsted, Essex, cutler 0
5403310 2476023 2476023 defendant Wedowe Richard yeoman 588457 588457 Wedowe, Richard, of Thaxsted, Essex, yeoman 1
5416359 2479810 2479810 defendant Wedowe Richard yeoman 588457 588457 Wedowe, Richard, of Thaxsted, Essex, yeoman 1
5417600 2480181 2480181 defendant Honcheche John yeoman 588457 588457 Honcheche, John, of Thaxsted, Essex, yeoman 4
5425566 2482622 2482622 defendant Colman Agnes widow 588457 588457 Colman, Agnes, of Thaxsted, Essex, widow 2
5433153 2484882 2484882 defendant Wedowe Richard yeoman 588457 588457 Wedowe, Richard, of Thaxsted, Essex, yeoman 1
5433158 2484883 2484883 defendant Wedowe Richard yeoman 588457 588457 Wedowe, Richard, of Thaxsted, Essex, yeoman 1
5436579 2485872 2485872 defendant Damery Richard cutler 588457 588457 Damery, Richard, of Thaxsted, Essex, cutler 2
5436584 2485873 2485873 defendant Damery Richard cutler 588457 588457 Damery, Richard, of Thaxsted, Essex, cutler 2
5460866 2493198 2493198 defendant Alman Richard chapman 588457 588457 Alman, Richard, of Thaxsted, Essex, chapman 4
5482524 2499715 2499715 defendant Gateward John yeoman 588457 588457 Gateward, John, of Thaxsted, Essex, yeoman 1
5489575 2501763 2501763 defendant Travys John carver 588457 588457 Travys, John, of Thaxsted, Essex, carver 1
5489580 2501764 2501764 defendant Travys John carver 588457 588457 Travys, John, of Thaxsted, Essex, carver 1
5500610 2505118 2505118 defendant Quyle John smith 588457 588457 Quyle, John, of Thaxsted, Essex, smith 4
5500619 2505120 2505120 defendant Guyle or Evyle John smith 588457 588457 Guyle or Evyle, John, of Thaxsted, Essex, smith 3
5501508 2505405 2505405 defendant Plomme John cutler 588457 588457 Plomme, John, of Thaxsted, Essex, cutler 3
5523772 2512258 2512258 defendant Wale William cutler 588457 588457 Wale, William, of Thaxsted, Essex, cutler 2
5541650 2517495 2517495 defendant Spylman John draper 588457 588457 Spylman, John, of Thaxsted, Essex, draper 2
5543669 2518128 2518128 defendant Hasilwode Thomas husbandman 588457 588457 Hasilwode, Thomas, of Thaxsted, Essex, 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);