names

302 rows where place_id = 589376

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597424 1866814 1866814 defendant Subberd John chapman 589376 589376 Subberd, John, of Thaxstede, chapman 1
3597425 1866814 1866814 defendant Stronge John blacksmith 589376 589376 Stronge, John, of Thaxstede, blacksmith 2
3714442 1930811 1930811 defendant Bulloke John husbandman 589376 589376 Bulloke, John, of Thaxstede, husbandman 3
3781726 1952030 1952030 defendant Croft Thomas husbandman 589376 589376 Croft, Thomas, of Thaxstede, husbandman 1
3804243 1959260 1959260 defendant Pateshale Agnes   589376 589376 Pateshale, Agnes, of Thaxstede, widow of Pateshale, Walter, of Thaxstede 2
3840602 1970626 1970626 defendant Aburfurth John, junior yeoman 589376 589376 Aburfurth, John, junior, of Thaxstede, yeoman 0
3840606 1970627 1970627 defendant Aburfurth John, senior yeoman 589376 589376 Aburfurth, John, senior, of Thaxstede, yeoman 0
4444214 2183172 2183172 plaintiff Clerkes Walter, junior   589376 589376 Clerkes, Walter, junior, of Thaxstede 0
4464381 2189530 2189530 plaintiff Warewyk Thomas   589376 589376 Warewyk, Thomas, of Thaxstede 0
4464382 2189530 2189530 defendant Patergos William   589376 589376 Patergos, William, of Thaxstede 0
4469312 2191074 2191074 defendant Geray John   589376 589376 Geray, John, of Thaxstede 0
4469897 2191249 2191249 defendant Drought Andrew cutler 589376 589376 Drought, Andrew, of Thaxstede, cutler 0
4472318 2192014 2192014 defendant Bayly Stephen   589376 589376 Bayly, Stephen, of Thaxstede 2
4475241 2192935 2192935 defendant Richemond Richard boteler 589376 589376 Richemond, Richard, of Thaxstede, boteler 0
4478123 2193831 2193831 defendant Symond William   589376 589376 Symond, William, of Thaxstede 0
4479918 2194384 2194384 defendant Gamelyn Roger   589376 589376 Gamelyn, Roger, of Thaxstede 0
4479932 2194387 2194387 defendant Bylmyn John   589376 589376 Bylmyn, John, of Thaxstede 1
4479933 2194387 2194387 defendant West William cutler 589376 589376 West, William, of Thaxstede, cutler 2
4479942 2194392 2194392 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4496251 2199500 2199500 defendant Ba--- Stephen   589376 589376 Ba---, Stephen, of Thaxstede 1
4498014 2200024 2200024 plaintiff Ewayn John butcher 589376 589376 Ewayn, John, of Thaxstede, butcher 0
4500739 2200847 2200847 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4500742 2200847 2200847 defendant Colman William   589376 589376 Colman, William, of Thaxstede 2
4500745 2200848 2200848 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4500750 2200849 2200849 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4500752 2200850 2200850 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4509316 2203389 2203389 defendant Sprygge Thomas   589376 589376 Sprygge, Thomas, of Thaxstede 0
4515271 2205190 2205190 defendant Venour John   589376 589376 Venour, John, of Thaxstede 0
4515273 2205191 2205191 defendant Venour John   589376 589376 Venour, John, of Thaxstede 0
4525090 2208190 2208190 defendant Benge John   589376 589376 Benge, John, of Thaxstede, son of John 0
4525967 2208422 2208422 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4525969 2208423 2208423 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede, on his own account 0
4533406 2210717 2210717 defendant Richemond John, sen   589376 589376 Richemond, John, sen, of Thaxstede 0
4539190 2212512 2212512 defendant Taillour Lawrence   589376 589376 Taillour, Lawrence, of Thaxstede 3
4539192 2212513 2212513 defendant Elys William cutler 589376 589376 Elys, William, of Thaxstede, cutler 0
4540375 2212887 2212887 defendant May Walter   589376 589376 May, Walter, of Thaxstede 0
4540377 2212888 2212888 defendant May Walter   589376 589376 May, Walter, of Thaxstede 0
4542061 2213409 2213409 defendant Hierde William   589376 589376 Hierde, William, of Thaxstede 0
4548453 2215455 2215455 defendant Alem Thomas   589376 589376 Alem, Thomas, of Thaxstede 0
4548456 2215455 2215455 defendant Bakere Thomas   589376 589376 Bakere, Thomas, of Thaxstede 3
4557048 2218132 2218132 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4573098 2223123 2223123 defendant Bocher John   589376 589376 Bocher, John, of Thaxstede 1
4574644 2223596 2223596 defendant Avenaunt Robert   589376 589376 Avenaunt, Robert, of Thaxstede 1
4585176 2226786 2226786 defendant Coupere John   589376 589376 Coupere, John, of Thaxstede 0
4588180 2227699 2227699 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4588189 2227700 2227700 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4588190 2227700 2227700 defendant Maynard Richard   589376 589376 Maynard, Richard, of Thaxstede 0
4589341 2228041 2228041 defendant Lynderthorp John   589376 589376 Lynderthorp, John, of Thaxstede 4
4595219 2229754 2229754 plaintiff Rande John   589376 589376 Rande, John, of Thaxstede 0
4596821 2230241 2230241 defendant Reynold William   589376 589376 Reynold, William, of Thaxstede 0
4596822 2230241 2230241 defendant Botaille William   589376 589376 Botaille, William, of Thaxstede 1
4596823 2230241 2230241 defendant Bocher Henry   589376 589376 Bocher, Henry, of Thaxstede 2
4596824 2230241 2230241 defendant Foot Henry   589376 589376 Foot, Henry, of Thaxstede 3
4596825 2230241 2230241 defendant Herry Andrew   589376 589376 Herry, Andrew, of Thaxstede 4
4596845 2230250 2230250 defendant Gamelyn Roger   589376 589376 Gamelyn, Roger, of Thaxstede 0
4596846 2230250 2230250 defendant Bedeford John butcher 589376 589376 Bedeford, John, of Thaxstede, butcher 1
4596847 2230250 2230250 defendant Swyrt John cutler 589376 589376 Swyrt, John, of Thaxstede, cutler 2
4600115 2231260 2231260 defendant Stace Willim   589376 589376 Stace, Willim, of Thaxstede 3
4609182 2233976 2233976 defendant Rous John   589376 589376 Rous, John, of Thaxstede 0
4610643 2234395 2234395 defendant Rous John   589376 589376 Rous, John, of Thaxstede 3
4614986 2235698 2235698 defendant Seman John   589376 589376 Seman, John, of Thaxstede 0
4620908 2237521 2237521 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4620910 2237522 2237522 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4627014 2239398 2239398 defendant Shethere John   589376 589376 Shethere, John, of Thaxstede 2
4636746 2242311 2242311 defendant fitz Richard John   589376 589376 fitz Richard, John, of Thaxstede 0
4638620 2242831 2242831 defendant Rous John   589376 589376 Rous, John, of Thaxstede 8
4649972 2246009 2246009 defendant Newelond Richard   589376 589376 Newelond, Richard, of Thaxstede 4
4652181 2246621 2246621 defendant Kent John furbisher 589376 589376 Kent, John, of Thaxstede, furbisher 1
4652584 2246766 2246766 plaintiff Bakere Thomas   589376 589376 Bakere, Thomas, of Thaxstede 0
4652585 2246766 2246766 defendant Hyde William cutler 589376 589376 Hyde, William, of Thaxstede, cutler 0
4652587 2246766 2246766 defendant Wangford John mercer 589376 589376 Wangford, John, of Thaxstede, mercer 2
4653152 2246922 2246922 defendant Huberd Peter carter 589376 589376 Huberd, Peter, of Thaxstede, carter 0
4668332 2255810 2255810 defendant Hamond Thomas cutler 589376 589376 Hamond, Thomas, of Thaxstede, cutler 3
4668348 2255813 2255813 defendant Arnold John husbandman 589376 589376 Arnold, John, of Thaxstede, husbandman 10
4671696 2256794 2256794 defendant Spilman William cutler 589376 589376 Spilman, William, of Thaxstede, cutler 0
4676798 2258363 2258363 defendant Gyle or Eyle John   589376 589376 Gyle or Eyle, John, of Thaxstede, tile maker 3
4679475 2259196 2259196 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4679478 2259197 2259197 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4679484 2259198 2259198 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4681528 2259834 2259834 defendant atte Grene Robert husbandman 589376 589376 atte Grene, Robert, of Thaxstede, husbandman 2
4687264 2261624 2261624 defendant Aleyn Ralph cutler 589376 589376 Aleyn, Ralph, of Thaxstede, cutler 0
4694176 2263680 2263680 defendant Barnesley Thomas clerk 589376 589376 Barnesley, Thomas, of Thaxstede, clerk 0
4695064 2263949 2263949 plaintiff (not given) John vicar of Brampton 589376 589376 Brampton, John, of Thaxstede, formerly vicar of Thaxstede, executors of 0
4695067 2263949 2263949 defendant Clerk alias Jankyn Ralph cutler 589376 589376 Clerk alias Jankyn, Ralph, of Thaxstede, cutler 0
4697723 2264779 2264779 defendant Spynke John   589376 589376 Spynke, John, of Thaxstede, blade smith 2
4700736 2265630 2265630 defendant Beenge John yeoman 589376 589376 Beenge, John, of Thaxstede, yeoman 0
4700738 2265630 2265630 defendant Holdeburgh Edmund yeoman 589376 589376 Holdeburgh, Edmund, of Thaxstede, yeoman 2
4700854 2265668 2265668 defendant Baker Thomas baker 589376 589376 Baker, Thomas, of Thaxstede, baker 2
4700860 2265669 2265669 defendant Baker Thomas baker 589376 589376 Baker, Thomas, of Thaxstede, baker 2
4704978 2266932 2266932 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4704980 2266933 2266933 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4704983 2266934 2266934 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4704988 2266935 2266935 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4704991 2266936 2266936 plaintiff Kent John   589376 589376 Kent, John, of Thaxstede 0
4704995 2266936 2266936 defendant Goldbeter John husbandman 589376 589376 Goldbeter, John, of Thaxstede, husbandman 3
4704996 2266936 2266936 defendant Sampforth John husbandman 589376 589376 Sampforth, John, of Thaxstede, husbandman 4
4708692 2268092 2268092 plaintiff Omond William   589376 589376 Omond, William, of Thaxstede 0
4711272 2268869 2268869 defendant Swetyng John cutler 589376 589376 Swetyng, John, of Thaxstede, cutler 9
4711296 2268870 2268870 defendant Swetyng John cutler 589376 589376 Swetyng, John, of Thaxstede, cutler 9
4711319 2268871 2268871 defendant Swetyng John cutler 589376 589376 Swetyng, John, of Thaxstede, cutler 8

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