names

96 rows where place_id = 591261

✎ 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
3603877 1868884 1868884 defendant Shepard Robert courser 591261 591261 Shepard, Robert, of Tamworth, Staffs, courser 0
3634084 1905459 1905459 defendant Hill John yeoman or roper 591261 591261 Hill, John, of Tamworth, Staffs, yeoman or roper 0
3637823 1906647 1906647 defendant Wystowe John gent 591261 591261 Wystowe, John, of Tamworth, Staffs, gent 0
3640196 1907375 1907375 defendant Blunt John esq 591261 591261 Blunt, John, of Tamworth, Staffs, esq 1
3640248 1907386 1907386 defendant Blount John gent 591261 591261 Blount, John, of Tamworth, Staffs, gent 0
3640253 1907387 1907387 defendant Blount John gent 591261 591261 Blount, John, of Tamworth, Staffs, gent 0
3640930 1907607 1907607 defendant Blount John esq 591261 591261 Blount, John, of Tamworth, Staffs, esq 0
3640936 1907608 1907608 defendant Blount John esq 591261 591261 Blount, John, of Tamworth, Staffs, esq 0
3677427 1918991 1918991 defendant Walden John dyer 591261 591261 Walden, John, of Tamworth, Staffs, dyer 0
3745218 1940412 1940412 defendant Wylcockys Robert baker 591261 591261 Wylcockys, Robert, of Tamworth, Staffs, baker 3
3791639 1955226 1955226 defendant Blount John gent 591261 591261 Blount, John, of Tamworth, Staffs, gent 0
3808041 1960404 1960404 defendant Blunt John gent 591261 591261 Blunt, John, of Tamworth, Staffs, gent 0
3901183 1990622 1990622 defendant Grenefeld George gent 591261 591261 (Grenefeld, George, of Tamworth, Staffs, gent 1
3910133 1993699 1993699 defendant Jekys John gent 591261 591261 Jekys, John, of Tamworth, Staffs, gent 0
3950980 2007410 2007410 defendant Harecourt Walter gent 591261 591261 Harecourt, Walter, of Tamworth, Staffs, gent 0
3970114 2014147 2014147 defendant Sponer John chapman 591261 591261 Sponer, John, of Tamworth, Staffs, chapman 0
3975244 2015909 2015909 defendant Sponer John chapman 591261 591261 Sponer, John, of Tamworth, Staffs, chapman 0
4017536 2030976 2030976 defendant Harshall Henry gent 591261 591261 Harshall, Henry, of Tamworth, Staffs, gent 0
4082643 2054103 2054103 defendant Harecourte Walter gent 591261 591261 Harecourte, Walter, of Tamworth, Staffs, gent 0
4160358 2081697 2081697 defendant Harecourt Edward gent 591261 591261 Harecourt, Edward, of Tamworth, Staffs, gent 0
4172386 2085802 2085802 defendant Wylloughbye Henry gent 591261 591261 Wylloughbye, Henry, of Tamworth, Staffs, gent 0
4222325 2103298 2103298 defendant Breton John gent 591261 591261 Breton, John, of Tamworth, Staffs, gent 1
4283163 2124010 2124010 defendant Bretton Nicholas gent 591261 591261 Bretton, Nicholas, of Tamworth, Staffs, gent 2
4637880 2242617 2242617 defendant White John   591261 591261 White, John, of Tamworth, Staffs 0
4657399 2248207 2248207 defendant Jeke Henry yeoman 591261 591261 Jeke, Henry, of Tamworth, Staffs, yeoman 0
4669979 2256309 2256309 defendant Stoke John butcher 591261 591261 Stoke, John, of Tamworth, Staffs, butcher 0
4669981 2256310 2256310 defendant Stoke John butcher 591261 591261 Stoke, John, of Tamworth, Staffs, butcher 0
4745567 2279215 2279215 defendant Danyell Ralph butcher 591261 591261 Danyell, Ralph, of Tamworth, Staffs, butcher 0
4757602 2282756 2282756 defendant Brugge Adam baker 591261 591261 Brugge, Adam, of Tamworth, Staffs, baker 0
4781342 2290175 2290175 defendant Walker Richard mercer 591261 591261 Walker, Richard, of Tamworth, Staffs, mercer 0
4785695 2291557 2291557 defendant Jeke Henry gent 591261 591261 Jeke, Henry, of Tamworth, Staffs, gent 1
4785698 2291558 2291558 defendant Jeke Henry gent 591261 591261 Jeke, Henry, of Tamworth, Staffs, gent 1
4789652 2292831 2292831 defendant Walker alias Dalton Richard husbandman 591261 591261 Walker alias Dalton, Richard, of Tamworth, Staffs, husbandman 0
4794308 2294361 2294361 defendant Danyell Ralph butcher 591261 591261 Danyell, Ralph, of Tamworth, Staffs, butcher 2
4804179 2297496 2297496 defendant Walker Richard chapman 591261 591261 Walker, Richard, of Tamworth, Staffs, chapman 0
4806748 2298321 2298321 defendant Walker Richard chapman 591261 591261 Walker, Richard, of Tamworth, Staffs, chapman 0
4828231 2304873 2304873 defendant Danyell Ralph butcher 591261 591261 Danyell, Ralph, of Tamworth, Staffs, butcher 0
4832985 2306335 2306335 defendant Rost Henry yeoman 591261 591261 Rost, Henry, of Tamworth, Staffs, yeoman 1
4881744 2321187 2321187 defendant Danyell Ralph butcher 591261 591261 Danyell, Ralph, of Tamworth, Staffs, butcher 0
4883752 2321828 2321828 defendant Warley John skinner 591261 591261 Warley, John, of Tamworth, Staffs, skinner 2
4892769 2324463 2324463 defendant Dalton Richard, senior chapman 591261 591261 Dalton, Richard, senior, of Tamworth, Staffs, chapman 0
4902643 2327446 2327446 defendant Dalton John, senior mercer 591261 591261 Dalton, John, senior, of Tamworth, Staffs, mercer 1
4907007 2328766 2328766 defendant Baille John tailor 591261 591261 Baille, John, of Tamworth, Staffs, tailor 2
4907931 2329038 2329038 defendant Dalton Richard chapman 591261 591261 Dalton, Richard, of Tamworth, Staffs, chapman 1
4913931 2330866 2330866 defendant Tony Robert weaver 591261 591261 Tony, Robert, of Tamworth, Staffs, weaver 0
4942553 2339648 2339648 defendant Dalton Richard chapman 591261 591261 Dalton, Richard, of Tamworth, Staffs, chapman 2
4942574 2339650 2339650 defendant Dalton Richard chapman 591261 591261 Dalton, Richard, of Tamworth, Staffs, chapman 2
4946856 2341024 2341024 defendant Hyne or Hyve Thomas husbandman 591261 591261 Hyne or Hyve, Thomas, of Tamworth, Staffs, husbandman 0
4958995 2344657 2344657 defendant Salton Richard yeoman 591261 591261 Salton, Richard, of Tamworth, Staffs, yeoman 1
4959000 2344658 2344658 defendant Swanne John chaplain 591261 591261 Swanne, John, of Tamworth, Staffs, chaplain 0
4980842 2351200 2351200 defendant Stoke Robert gent 591261 591261 Stoke, Robert, of Tamworth, Staffs, gent 0
5055133 2373110 2373110 defendant Russell John yeoman 591261 591261 Russell, John, of Tamworth, Staffs, yeoman 0
5072292 2378200 2378200 defendant More Hugh yeoman 591261 591261 More, Hugh, of Tamworth, Staffs, yeoman 1
5072297 2378201 2378201 defendant More Hugh yeoman 591261 591261 More, Hugh, of Tamworth, Staffs,, yeoman 1
5078402 2380038 2380038 defendant Jeke Henry husbandman 591261 591261 Jeke, Henry, of Tamworth, Staffs, husbandman 1
5080538 2380671 2380671 plaintiff Coke Ellen widow 591261 591261 Coke, Ellen, of Tamworth, Staffs, widow 0
5115360 2390919 2390919 defendant Jeke Henry gent 591261 591261 Jeke, Henry, of Tamworth, Staffs, gent 0
5155753 2402844 2402844 defendant Horton John yeoman 591261 591261 Horton, John, of Tamworth, Staffs, yeoman 0
5158184 2403514 2403514 defendant Potter Thomas husbandman 591261 591261 Potter, Thomas, of Tamworth, Staffs, husbandman 0
5160282 2404102 2404102 defendant Couper Thomas cooper 591261 591261 Couper, Thomas, of Tamworth, Staffs, cooper 4
5160285 2404102 2404102 defendant Bosworth John baker 591261 591261 Bosworth, John, of Tamworth, Staffs, baker 7
5160286 2404102 2404102 defendant Spencer Henry baker 591261 591261 Spencer, Henry, of Tamworth, Staffs, baker 8
5160288 2404102 2404102 defendant Coton Thomas, sen   591261 591261 Coton, Thomas, sen, of Tamworth, Staffs, gold beater 10
5160289 2404102 2404102 defendant Glover William tanner 591261 591261 Glover, William, of Tamworth, Staffs, tanner 11
5160290 2404102 2404102 defendant Bosworth William husbandman 591261 591261 Bosworth, William, of Tamworth, Staffs, husbandman 12
5165152 2405555 2405555 plaintiff Bate John clerk 591261 591261 Bate, John, of Tamworth, Staffs, clerk 0
5175121 2408418 2408418 defendant Couper Thomas cooper 591261 591261 Couper, Thomas, of Tamworth, Staffs, cooper 4
5175124 2408418 2408418 defendant Bosworth John baker 591261 591261 Bosworth, John, of Tamworth, Staffs, baker 7
5175125 2408418 2408418 defendant Spencer Henry baker 591261 591261 Spencer, Henry, of Tamworth, Staffs, baker 8
5175127 2408418 2408418 defendant Coton Thomas, sen   591261 591261 Coton, Thomas, sen, of Tamworth, Staffs, gold beater 10
5175128 2408418 2408418 defendant Glover William tanner 591261 591261 Glover, William, of Tamworth, Staffs, tanner 11
5175129 2408418 2408418 defendant Bosworth William husbandman 591261 591261 Bosworth, William, of Tamworth, Staffs, husbandman 12
5272051 2436907 2436907 defendant Wylshawe John yeoman 591261 591261 Wylshawe, John, of Tamworth, Staffs, yeoman 1
5304306 2446291 2446291 defendant Wylshawe John yeoman 591261 591261 Wylshawe, John, of Tamworth, Staffs, yeoman 2
5316090 2449886 2449886 defendant Goabowete Peter cordwainer 591261 591261 Goabowete, Peter, of Tamworth, Staffs, cordwainer 1
5331006 2454339 2454339 defendant Irpe William baker 591261 591261 Irpe, William, of Tamworth, Staffs, baker 0
5388446 2471743 2471743 defendant Wodshawe Richard butcher 591261 591261 Wodshawe, Richard, of Tamworth, Staffs, butcher 0
5394820 2473589 2473589 defendant Fawn John   591261 591261 Fawn, John, of Tamworth, Staffs, gent, administrators of 0
5394822 2473589 2473589 defendant Jekes William yeoman 591261 591261 Jekes, William, of Tamworth, Staffs, yeoman 2
5408064 2477385 2477385 defendant Fawn Eleanor widow 591261 591261 (Fawn, Eleanor, of Tamworth, Staffs, widow 1
5408072 2477386 2477386 defendant Fawn Eleanor gent 591261 591261 (Fawn, Eleanor, of Tamworth, Staffs, widow, formerly wife of John Fawn, gent 1
5430741 2484134 2484134 defendant Wylshawe John yeoman 591261 591261 Wylshawe, John, of Tamworth, Staffs, yeoman 0
5447346 2489099 2489099 defendant Wylshawe John yeoman 591261 591261 Wylshawe, John, of Tamworth, Staffs, yeoman 0
5447350 2489100 2489100 defendant Wilshawe John yeoman 591261 591261 Wilshawe, John, of Tamworth, Staffs, yeoman 0
5465565 2494607 2494607 defendant Fawn John   591261 591261 Fawn, John, of Tamworth, Staffs, gent, adminstrators of 0
5465566 2494607 2494607 defendant Fawn Eleanor   591261 591261 (Fawn, Eleanor, of Tamworth, Staffs, widow, of John 1
5510062 2507986 2507986 defendant Williamson Henry draper 591261 591261 Williamson, Henry, of Tamworth, Staffs, draper 0
5510068 2507987 2507987 defendant Williamson Henry draper 591261 591261 Williamson, Henry, of Tamworth, Staffs, draper 0
5511991 2508608 2508608 defendant Raynold William yeoman 591261 591261 Raynold, William, of Tamworth, Staffs, yeoman 2
5511996 2508609 2508609 defendant Raynold William yeoman 591261 591261 Raynold, William, of Tamworth, Staffs, yeoman 2
5535857 2515719 2515719 defendant Wystowe Alice widow 591261 591261 Wystowe, Alice, of Tamworth, Staffs, widow 2
5535860 2515720 2515720 defendant Wystowe John gent 591261 591261 Wystowe, John, of Tamworth, Staffs, gent 1
5579663 2528722 2528722 defendant Blount John gent 591261 591261 Blount, John, of Tamworth, Staffs, gent 0
5587227 2531031 2531031 defendant Blount John, junior esq 591261 591261 Blount, John, junior, of Tamworth, Staffs, esq 2
5587234 2531032 2531032 defendant Blount John, junior esq 591261 591261 Blount, John, junior, of Tamworth, Staffs, esq 2
5629389 2553174 2553174 defendant Jeke Henry yeoman 591261 591261 Jeke, Henry, of Tamworth, Staffs, yeoman 0

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