names

106 rows where place_id = 645719

✎ 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
3588848 1864161 1864161 defendant Smale John husbandman 645719 645719 Smale, John, of Dene Prior, husbandman 0
3771060 1948637 1948637 defendant Sherwode Henry yeoman 645719 645719 Sherwode, Henry, of Dene Prior, yeoman 0
3786985 1953732 1953732 plaintiff Rasselegh Thomas   645719 645719 Rasselegh, Thomas, of Dene Prier 0
3850621 1973783 1973783 defendant Mugge Richard   645719 645719 Mugge, Richard, of Dene Prior, fish driver 1
3887055 1985936 1985936 plaintiff Cleyter Richard   645719 645719 Cleyter, Richard, of Dene 0
4440840 2182049 2182049 defendant Shryne or Shryve Robert   645719 645719 Shryne or Shryve, Robert, of Dene 4
4442706 2182670 2182670 defendant Hyche John   645719 645719 Hyche, John, of Dene 0
4462137 2188855 2188855 defendant Reynold John chaplain 645719 645719 Reynold, John, of Dene, chaplain 0
4480205 2194468 2194468 plaintiff Knyghton William   645719 645719 Knyghton, William, of Dene, parson 0
4505741 2202306 2202306 plaintiff Hoke Philip   645719 645719 Hoke, Philip, of Dene 1
4536609 2211730 2211730 plaintiff Hoke Philip   645719 645719 Hoke, Philip, of Dene 1
4556772 2218051 2218051 defendant Mathewe Thomas   645719 645719 Mathewe, Thomas, of Dene 4
4577956 2224610 2224610 defendant Smyth William   645719 645719 Smyth, William, of Dene 0
4577958 2224611 2224611 defendant Smyth William   645719 645719 Smyth, William, of Dene 0
4585853 2226998 2226998 defendant Hykkys William   645719 645719 Hykkys, William, of Dene 0
4585858 2226998 2226998 defendant Taillour Adam   645719 645719 Taillour, Adam, of Dene 5
4606289 2233078 2233078 defendant Canon William   645719 645719 Canon, William, of Dene 0
4649202 2245818 2245818 defendant Mason John   645719 645719 Mason, John, of Dene 1
4662505 2249743 2249743 defendant Hobbes Michael husbandman 645719 645719 Hobbes, Michael, of Dene, husbandman 4
4676662 2258317 2258317 defendant Russell John   645719 645719 Russell, John, of Dene Prior, vicar 1
4688817 2262058 2262058 defendant Moreshed Simon husbandman 645719 645719 Moreshed, Simon, of Dene Prior, husbandman 0
4699587 2265321 2265321 plaintiff Dygat Henry   645719 645719 Dygat, Henry, of Dene 0
4711542 2268938 2268938 defendant Moresheade Simon husbandman 645719 645719 Moresheade, Simon, of Dene Prior, husbandman 1
4715900 2270286 2270286 defendant Bakster Thoams   645719 645719 Bakster, Thoams, of Dene, bailiff 3
4733481 2275646 2275646 defendant Greder Henry weaver 645719 645719 Greder, Henry, of Dene Prior, weaver 3
4755405 2282073 2282073 defendant Stanton Henry husbandman 645719 645719 Stanton, Henry, of Dene, husbandman 0
4761063 2283811 2283811 defendant Marchall William maltman 645719 645719 Marchall, William, of Dene, maltman 0
4768469 2286114 2286114 defendant Gybuns William husbandman 645719 645719 Gybuns, William, of Dene, husbandman 0
4772274 2287298 2287298 defendant Bolle Thomas husbandman 645719 645719 Bolle, Thomas, of Dene, husbandman 0
4772277 2287298 2287298 defendant Salter John husbandman 645719 645719 Salter, John, of Dene, husbandman 3
4772278 2287298 2287298 defendant Broun William husbandman 645719 645719 Broun, William, of Dene, husbandman 4
4773518 2287686 2287686 defendant Patey Thomas husbandman 645719 645719 Patey, Thomas, of Dene Prior, husbandman 0
4777122 2288824 2288824 defendant Smyth Andrew husbandman 645719 645719 Smyth, Andrew, of Dene, husbandman 0
4777123 2288824 2288824 defendant Lote Thomas husbandman 645719 645719 Lote, Thomas, of Dene, husbandman 1
4777124 2288824 2288824 defendant Kebat John husbandman 645719 645719 Kebat, John, of Dene, husbandman 2
4793933 2294231 2294231 plaintiff West William   645719 645719 West, William, of Dene 1
4797440 2295371 2295371 defendant Bolle Thomas husbandman 645719 645719 Bolle, Thomas, of Dene, husbandman 0
4797443 2295371 2295371 defendant Salter John husbandman 645719 645719 Salter, John, of Dene, husbandman 3
4797444 2295371 2295371 defendant Broun William, junior husbandman 645719 645719 Broun, William, junior, of Dene, husbandman 4
4822854 2303233 2303233 defendant Hendesson William husbandman 645719 645719 Hendesson, William, of Dene, husbandman 0
4848675 2311056 2311056 defendant Raulyn Thomas laborer 645719 645719 Raulyn, Thomas, of Dene, laborer 4
4862058 2315143 2315143 defendant Hawenes John roper 645719 645719 Hawenes, John, of Dene, roper 4
4876336 2319561 2319561 defendant Raulyn Thomas laborer 645719 645719 Raulyn, Thomas, of Dene, laborer 3
4876787 2319712 2319712 defendant Marchall Richard husbandman 645719 645719 Marchall, Richard, of Dene, husbandman 5
4885760 2322417 2322417 defendant Blissot John husbandman 645719 645719 Blissot, John, of Dene, husbandman 8
4890324 2323743 2323743 defendant Thorn John yeoman 645719 645719 Thorn, John, of Dene, yeoman 0
4890330 2323744 2323744 defendant Ondeby or Oudeby John esq 645719 645719 Ondeby or Oudeby, John, of Dene, esq 0
4902897 2327521 2327521 defendant Moryshed Richard husbandman 645719 645719 Moryshed, Richard, of Dene, husbandman 1
4907001 2328764 2328764 defendant Thorne John yeoman 645719 645719 Thorne, John, of Dene, yeoman 0
4916665 2331723 2331723 defendant Marchall William woolman 645719 645719 Marchall, William, of Dene, woolman 0
4916667 2331724 2331724 defendant Marchall William woolman 645719 645719 Marchall, William, of Dene, woolman 0
4918598 2332332 2332332 defendant Balle John husbandman 645719 645719 Balle, John, of Dene, husbandman 1
4972715 2348775 2348775 defendant Godwey Richard husbandman 645719 645719 Godwey, Richard, of Dene, husbandman 1
4991964 2354484 2354484 defendant Hayman Warren husbandman 645719 645719 Hayman, Warren, of Dene Prior, husbandman 0
5009748 2359731 2359731 defendant Colle John husbandman 645719 645719 Colle, John, of Dene, husbandman 3
5029804 2365591 2365591 defendant Repynghale John skinner 645719 645719 Repynghale, John, of Dene, skinner 0
5043346 2369634 2369634 defendant Moryshed Richard husbandman 645719 645719 Moryshed, Richard, of Dene, husbandman 2
5058751 2374183 2374183 defendant Howham John husbandman 645719 645719 Howham, John, of Dene, husbandman 1
5082360 2381221 2381221 plaintiff Deye Thomas   645719 645719 Deye, Thomas, of Dene 0
5082361 2381221 2381221 defendant Deye Thomas husbandman 645719 645719 Deye, Thomas, of Dene, husbandman 0
5106168 2388242 2388242 defendant Bonde William husbandman 645719 645719 Bonde, William, of Dene, husbandman 0
5135902 2397014 2397014 defendant Colles John mylner 645719 645719 Colles, John, of Dene, mylner 1
5139920 2398158 2398158 defendant Belton John husbandman 645719 645719 Belton, John, of Dene, husbandman 2
5139924 2398159 2398159 defendant Neweman Peter husbandman 645719 645719 Neweman, Peter, of Dene, husbandman 0
5160941 2404306 2404306 defendant Neweman Peter husbandman 645719 645719 Neweman, Peter, of Dene, husbandman 0
5160944 2404307 2404307 defendant Neweman Peter husbandman 645719 645719 Neweman, Peter, of Dene, husbandman 0
5175557 2408536 2408536 defendant Neweman Peter husbandman 645719 645719 Neweman, Peter, of Dene, husbandman 0
5175560 2408537 2408537 defendant Neweman Peter husbandman 645719 645719 Neweman, Peter, of Dene, husbandman 0
5185297 2411445 2411445 defendant Moryshed Richard husbandman 645719 645719 Moryshed, Richard, of Dene, husbandman 0
5233075 2425258 2425258 defendant atte Halle William gent 645719 645719 atte Halle, William, of Dene, gent 0
5235612 2425997 2425997 defendant Hancoke John husbandman 645719 645719 Hancoke, John, of Dene, husbandman 2
5254634 2431570 2431570 defendant Mascall John husbandman 645719 645719 Mascall, John, of Dene, husbandman 0
5254635 2431570 2431570 defendant Mascall Nicholas husbandman 645719 645719 Mascall, Nicholas, of Dene, husbandman 1
5302916 2445858 2445858 defendant Rolston Thomas husbandman 645719 645719 Rolston, Thomas, of Dene, husbandman 0
5307095 2447123 2447123 defendant Taillour Richard husbandman 645719 645719 Taillour, Richard, of Dene, husbandman 0
5313638 2449106 2449106 defendant Wylcotes Eleanor widow 645719 645719 Wylcotes, Eleanor, of Dene, widow 1
5313644 2449107 2449107 defendant Wylcotes Eleanor widow 645719 645719 Wylcotes, Eleanor, of Dene, widow 1
5334752 2455461 2455461 defendant Bloxham Thomas laborer 645719 645719 Bloxham, Thomas, of Dene, laborer 1
5335612 2455723 2455723 defendant Mugge John yeoman 645719 645719 Mugge, John, of Dene Prior, yeoman 1
5335613 2455723 2455723 defendant Mugge William yeoman 645719 645719 Mugge, William, of Dene Prior, yeoman 2
5365380 2464846 2464846 plaintiff Halle William   645719 645719 Halle, William, of Dene 1
5374999 2467773 2467773 defendant Hychell John husbandman 645719 645719 Hychell, John, of Dene, husbandman 1
5387699 2471545 2471545 defendant S_ John husbandman 645719 645719 S_, John, of Dene Prior, husbandman 0
5391557 2472657 2472657 defendant Croppyng Thomas husbandman 645719 645719 Croppyng, Thomas, of Dene Prior, husbandman 0
5391558 2472657 2472657 defendant Moryshyde William husbandman 645719 645719 Moryshyde, William, of Dene Prior, husbandman 1
5391559 2472657 2472657 defendant Tokerman John husbandman 645719 645719 Tokerman, John, of Dene Prior, husbandman 2
5391560 2472657 2472657 defendant Hewe Michael husbandman 645719 645719 Hewe, Michael, of Dene Prior, husbandman 3
5400186 2475125 2475125 defendant Smale John husbandman 645719 645719 Smale, John, of Dene Prior, husbandman 0
5400285 2475155 2475155 defendant Smale John husbandman 645719 645719 Smale, John, of Dene Prior, husbandman 0
5404582 2476385 2476385 defendant Moryshare William husbandman 645719 645719 Moryshare, William, of Dene Prior, husbandman 0
5404583 2476385 2476385 defendant Tokerman John husbandman 645719 645719 Tokerman, John, of Dene Prior, husbandman 1
5404584 2476385 2476385 defendant H-w-e Michael husbandman 645719 645719 H-w-e, Michael, of Dene Prior, husbandman 2
5407300 2477151 2477151 defendant Wareyn John   645719 645719 Wareyn, John, of Dene Prior, husbandman, with Wareyn, Richard, groom 0
5413282 2478898 2478898 defendant Smale John husbandman 645719 645719 Smale, John, of Dene Prior, husbandman 0
5413284 2478899 2478899 defendant Smale John husbandman 645719 645719 Smale, John, of Dene Prior, husbandman 0
5420537 2481066 2481066 defendant Wareyn John husbandman 645719 645719 Wareyn, John, of Dene Prior, husbandman 0
5428438 2483431 2483431 defendant Smale Thomas husbandman 645719 645719 Smale, Thomas, of Dene Prior, husbandman 0
5439348 2486702 2486702 defendant Wareyn John husbandman 645719 645719 Wareyn, John, of Dene Prior, husbandman 0
5457124 2492029 2492029 defendant Wakeham John   645719 645719 Wakeham, John, of Dene prior, fish hawker 1
5457318 2492089 2492089 defendant Smale John husbandman 645719 645719 Smale, John, of Dene Prior, husbandman 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);