names

119 rows where place_id = 596244

✎ 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
3623827 1874982 1874982 defendant Wode John hosier 596244 596244 Wode, John, of Thaxstede, Essex, hosier 0
3662598 1914222 1914222 defendant Petyt Anne widow 596244 596244 Petyt, Anne, of Thaxstede, Essex, widow 0
3781725 1952030 1952030 defendant Crafte Joan widow 596244 596244 Crafte, Joan, of Thaxstede, Essex, widow 0
3804241 1959260 1959260 defendant Davy John yeoman 596244 596244 Davy, John, of Thaxstede, Essex, yeoman 0
3813187 1962034 1962034 defendant Appulford John draper 596244 596244 Appulford, John, of Thaxstede, Essex, draper 3
4319251 2136844 2136844 defendant Hollonde Thomas gent 596244 596244 Hollonde, Thomas, of Thaxstede, Essex, gent 0
4620912 2237523 2237523 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4658219 2248451 2248451 defendant Harry Andrew cutler 596244 596244 Harry, Andrew, of Thaxstede, Essex, cutler 1
4679487 2259199 2259199 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4679491 2259200 2259200 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4679494 2259201 2259201 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4690055 2262441 2262441 defendant Beenge John husbandman 596244 596244 Beenge, John, of Thaxstede, Essex, husbandman 4
4695879 2264195 2264195 defendant Holburgh Edmund yeoman 596244 596244 Holburgh, Edmund, of Thaxstede, Essex, yeoman 0
4704997 2266937 2266937 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4704999 2266938 2266938 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4705002 2266939 2266939 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4705004 2266940 2266940 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4705008 2266941 2266941 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4705010 2266942 2266942 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4710797 2268733 2268733 defendant Maundevyle John fishmonger 596244 596244 Maundevyle, John, of Thaxstede, Essex, fishmonger 0
4722104 2272242 2272242 defendant Alwyn Thomas chapman 596244 596244 Alwyn, Thomas, of Thaxstede, Essex, chapman 4
4725469 2273257 2273257 defendant Smert William husbandman 596244 596244 Smert, William, of Thaxstede, Essex, husbandman 0
4732694 2275405 2275405 defendant Herd William yeoman 596244 596244 Herd, William, of Thaxstede, Essex, yeoman 0
4733022 2275506 2275506 defendant Virly John cutler 596244 596244 Virly, John, of Thaxstede, Essex, cutler 0
4735770 2276335 2276335 defendant Longe John pinner 596244 596244 Longe, John, of Thaxstede, Essex, pinner 1
4735773 2276336 2276336 defendant Longe John pinner 596244 596244 Longe, John, of Thaxstede, Essex, pinner 1
4747397 2279742 2279742 plaintiff Kent John   596244 596244 Kent, John, of Thaxstede, Essex 0
4751234 2280837 2280837 defendant Reynoldes William yeoman 596244 596244 Reynoldes, William, of Thaxstede, Essex, yeoman 1
4752313 2281138 2281138 defendant Janekyn Richard merchant 596244 596244 Janekyn, Richard, of Thaxstede, Essex, merchant 1
4753354 2281425 2281425 defendant Yerdelee Thomas cutler 596244 596244 Yerdelee, Thomas, of Thaxstede, Essex, cutler 2
4773555 2287700 2287700 defendant Wymbyssh William cutler 596244 596244 Wymbyssh, William, of Thaxstede, Essex, cutler 0
4778400 2289223 2289223 defendant Wangeford John mercer 596244 596244 Wangeford, John, of Thaxstede, Essex, mercer 1
4778449 2289238 2289238 defendant Wangeford John mercer 596244 596244 Wangeford, John, of Thaxstede, Essex, mercer 1
4788271 2292402 2292402 defendant Glover John husbandman 596244 596244 Glover, John, of Thaxstede, Essex, husbandman 0
4788273 2292403 2292403 defendant Glover John husbandman 596244 596244 Glover, John, of Thaxstede, Essex, husbandman 0
4794033 2294269 2294269 defendant Herde William yeoman 596244 596244 Herde, William, of Thaxstede, Essex, yeoman 0
4794096 2294287 2294287 defendant Squyry John esq 596244 596244 Squyry, John, of Thaxstede, Essex, esq 0
4821738 2302874 2302874 defendant Allewyne Thomas mercer 596244 596244 Allewyne, Thomas, of Thaxstede, Essex, mercer 1
4825883 2304128 2304128 plaintiff Waldene John esq 596244 596244 Waldene, John, of Thaxstede, Essex, esq 0
4841518 2308877 2308877 defendant Hassere John hcapman 596244 596244 Hassere, John, of Thaxstede, Essex, hcapman 2
4841683 2308932 2308932 defendant Stansfeld John dyer 596244 596244 Stansfeld, John, of Thaxstede, Essex, dyer 0
4841685 2308933 2308933 defendant Stansfeld John dyer 596244 596244 Stansfeld, John, of Thaxstede, Essex, dyer 0
4845146 2309995 2309995 defendant Hancok John yeoman 596244 596244 Hancok, John, of Thaxstede, Essex, yeoman 0
4845390 2310071 2310071 defendant Stansfeld John dyer 596244 596244 Stansfeld, John, of Thaxstede, Essex, dyer 0
4845959 2310243 2310243 defendant Bale Bartholomew cutler 596244 596244 Bale, Bartholomew, of Thaxstede, Essex, cutler 0
4856294 2313341 2313341 defendant Astyrle Thomas yeoman 596244 596244 Astyrle, Thomas, of Thaxstede, Essex, yeoman 0
4858719 2314102 2314102 defendant Virley Thomas cutler 596244 596244 Virley, Thomas, of Thaxstede, Essex, cutler 0
4858721 2314103 2314103 defendant Virly Thomas cutler 596244 596244 Virly, Thomas, of Thaxstede, Essex, cutler 0
4875129 2319176 2319176 defendant Squery Thomas esq 596244 596244 Squery, Thomas, of Thaxstede, Essex, esq 0
4880808 2320904 2320904 defendant Squery Thomas gent 596244 596244 Squery, Thomas, of Thaxstede, Essex, gent 0
4888206 2323117 2323117 defendant Stelman Robert goldsmith 596244 596244 Stelman, Robert, of Thaxstede, Essex, goldsmith 1
4896189 2325467 2325467 defendant Squery Thomas gent 596244 596244 Squery, Thomas, of Thaxstede, Essex, gent 0
4900924 2326918 2326918 defendant Squery Thomas gent 596244 596244 Squery, Thomas, of Thaxstede, Essex, gent 0
4903449 2327686 2327686 defendant Stelman Robert goldsmith 596244 596244 Stelman, Robert, of Thaxstede, Essex, goldsmith 1
4911615 2330134 2330134 defendant Squyry Thomas esq 596244 596244 Squyry, Thomas, of Thaxstede, Essex, esq 0
4925551 2334424 2334424 defendant Edward John   596244 596244 Edward, John, of Thaxstede, Essex, blade smith 3
4974118 2349220 2349220 defendant Basset John cutler 596244 596244 Basset, John, of Thaxstede, Essex, cutler 1
4974124 2349221 2349221 defendant Basset John cutler 596244 596244 Basset, John, of Thaxstede, Essex, cutler 1
4976049 2349800 2349800 defendant Benge or Denge Reginald cutler 596244 596244 Benge or Denge, Reginald, of Thaxstede, Essex, cutler 0
4976964 2350065 2350065 defendant Edward John   596244 596244 Edward, John, of Thaxstede, Essex, bladesmith 1
4976970 2350066 2350066 defendant Edward John   596244 596244 Edward, John, of Thaxstede, Essex, bladesmith 2
4977435 2350215 2350215 defendant Brodoke Thomas yeoman 596244 596244 Brodoke, Thomas, of Thaxstede, Essex, yeoman 2
5016013 2361567 2361567 defendant Hadstoke John cutler 596244 596244 Hadstoke, John, of Thaxstede, Essex, cutler 0
5016140 2361604 2361604 defendant Hadstoke John cutler 596244 596244 Hadstoke, John, of Thaxstede, Essex, cutler 0
5016349 2361674 2361674 defendant Wydowe Richard cutler 596244 596244 Wydowe, Richard, of Thaxstede, Essex, cutler 0
5016641 2361758 2361758 defendant Asterle Thomas yeoman 596244 596244 Asterle, Thomas, of Thaxstede, Essex, yeoman 0
5018887 2362410 2362410 defendant Hanham John husbandman 596244 596244 Hanham, John, of Thaxstede, Essex, husbandman 4
5023299 2363719 2363719 defendant Henham John, senior husbandman 596244 596244 Henham, John, senior, of Thaxstede, Essex, husbandman 0
5023303 2363720 2363720 defendant Henham John, senior husbandman 596244 596244 Henham, John, senior, of Thaxstede, Essex, husbandman 0
5027371 2364881 2364881 defendant Reyne Thomas smith 596244 596244 Reyne, Thomas, of Thaxstede, Essex, smith 3
5027376 2364882 2364882 defendant Reyne Thomas smith 596244 596244 Reyne, Thomas, of Thaxstede, Essex, smith 3
5034957 2367083 2367083 defendant Hanham John yeoman 596244 596244 Hanham, John, of Thaxstede, Essex, yeoman 1
5039040 2368322 2368322 defendant Asterley Thomas yeoman 596244 596244 Asterley, Thomas, of Thaxstede, Essex, yeoman 0
5039042 2368323 2368323 defendant Asterley Thomas yeoman 596244 596244 Asterley, Thomas, of Thaxstede, Essex, yeoman 0
5049009 2371339 2371339 defendant Asterley Thomas yeoman 596244 596244 Asterley, Thomas, of Thaxstede, Essex, yeoman 0
5051347 2372015 2372015 defendant Hestere John   596244 596244 Hestere, John, of Thaxstede, Essex, blade smith 0
5103207 2387367 2387367 defendant Spylman Thomas draper 596244 596244 Spylman, Thomas, of Thaxstede, Essex, draper 2
5110655 2389518 2389518 defendant Damery John, junior yeoman 596244 596244 Damery, John, junior, of Thaxstede, Essex, yeoman 0
5127699 2394584 2394584 defendant Waterforthe John   596244 596244 Waterforthe, John, of Thaxstede, Essex, glade smith 0
5127701 2394585 2394585 defendant Waterforthe John   596244 596244 Waterforthe, John, of Thaxstede, Essex, bladesmith 0
5129952 2395249 2395249 defendant att Fan John, junior cutler 596244 596244 att Fan, John, junior, of Thaxstede, Essex, cutler 0
5131630 2395732 2395732 defendant Fold Roger cutler 596244 596244 Fold, Roger, of Thaxstede, Essex, cutler 0
5144596 2399578 2399578 defendant Lawe William skinner 596244 596244 Lawe, William, of Thaxstede, Essex, skinner 1
5146746 2400189 2400189 defendant Waterforthe John   596244 596244 Waterforthe, John, of Thaxstede, Essex, blade smith 0
5151115 2401467 2401467 defendant Feld Roger cutler 596244 596244 Feld, Roger, of Thaxstede, Essex, cutler 0
5151118 2401468 2401468 defendant Feld Roger cutler 596244 596244 Feld, Roger, of Thaxstede, Essex, cutler 0
5157919 2403439 2403439 defendant Gateward John smith 596244 596244 Gateward, John, of Thaxstede, Essex, smith 2
5165372 2405620 2405620 defendant Lawe Walter skinner 596244 596244 Lawe, Walter, of Thaxstede, Essex, skinner 1
5198647 2415361 2415361 defendant Hamond Thomas cutler 596244 596244 Hamond, Thomas, of Thaxstede, Essex, cutler 2
5213631 2419721 2419721 defendant Byrde Robert gent 596244 596244 (Byrde, Robert, of Thaxstede, Essex, gent 1
5214698 2420027 2420027 defendant James John mercer 596244 596244 James, John, of Thaxstede, Essex, mercer 1
5275408 2437875 2437875 defendant Hosyer Robert   596244 596244 Hosyer, Robert, of Thaxstede, Essex, parish clerk 1
5278126 2438697 2438697 defendant Duke Robert tanner 596244 596244 Duke, Robert, of Thaxstede, Essex, tanner 1
5278132 2438698 2438698 defendant Duke Robert tanner 596244 596244 Duke, Robert, of Thaxstede, Essex, tanner 1
5285292 2440717 2440717 defendant Porter John, senior yeoman 596244 596244 Porter, John, senior, of Thaxstede, Essex, yeoman 3
5299923 2444942 2444942 defendant James John mercer 596244 596244 James, John, of Thaxstede, Essex, mercer 1
5299926 2444943 2444943 defendant James John mercer 596244 596244 James, John, of Thaxstede, Essex, mercer 1
5317994 2450471 2450471 defendant Stace John   596244 596244 Stace, John, of Thaxstede, Essex, bladesmith 2
5318717 2450688 2450688 defendant Felde John yeoman 596244 596244 Felde, John, of Thaxstede, Essex, yeoman 3
5343347 2458109 2458109 defendant Sheldrake William shoemaker 596244 596244 Sheldrake, William, of Thaxstede, Essex, shoemaker 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);