names

81 rows where place_id = 611011

✎ 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
3686332 1921883 1921883 defendant Walker Richard chapman 611011 611011 Walker, Richard, of Scardeburgh, Yorks, chapman 0
3925998 1999016 1999016 defendant Smyth Thomas gent 611011 611011 Smyth, Thomas, of Scardeburgh, Yorks, gent 0
4661098 2249295 2249295 defendant Acclom Robert merchant 611011 611011 Acclom, Robert, of Scardeburgh, Yorks, merchant 0
4661100 2249296 2249296 defendant Acclom Robert merchant 611011 611011 Acclom, Robert, of Scardeburgh, Yorks, merchant 0
4664994 2250533 2250533 defendant Helperby William merchant 611011 611011 Helperby, William, of Scardeburgh, Yorks, merchant 0
4698740 2265089 2265089 defendant Sage William   611011 611011 Sage, William, of Scardeburgh, Yorks, burgess & merchant 0
4698820 2265110 2265110 defendant Rasyn Hugh   611011 611011 Rasyn, Hugh, of Scardeburgh, Yorks, school master 3
4698824 2265111 2265111 defendant Alneth Robert merchant 611011 611011 Alneth, Robert, of Scardeburgh, Yorks, merchant 2
4718540 2271136 2271136 defendant Yarum William merchant 611011 611011 Yarum, William, of Scardeburgh, Yorks, merchant 1
4725584 2273288 2273288 defendant Hogeson William husbandman 611011 611011 Hogeson, William, of Scardeburgh, Yorks, husbandman 2
4727183 2273764 2273764 defendant Spark Peter shipman 611011 611011 Spark, Peter, of Scardeburgh, Yorks, shipman 1
4727189 2273765 2273765 defendant Symson William merchant 611011 611011 Symson, William, of Scardeburgh, Yorks, merchant 1
4756709 2282462 2282462 defendant Breme John tailor 611011 611011 Breme, John, of Scardeburgh, Yorks, tailor 4
4762427 2284233 2284233 defendant Lestryk Thomas chapman 611011 611011 Lestryk, Thomas, of Scardeburgh, Yorks, chapman 0
4762432 2284235 2284235 defendant _ryk Thomas chapman 611011 611011 _ryk, Thomas, of Scardeburgh, Yorks, chapman 0
4773737 2287759 2287759 defendant Carter John gent 611011 611011 Carter, John, of Scardeburgh, Yorks, gent 0
4773739 2287760 2287760 defendant Carter John gent 611011 611011 Carter, John, of Scardeburgh, Yorks, gent 0
4784031 2291014 2291014 defendant Dawe John merchant 611011 611011 Dawe, John, of Scardeburgh, Yorks, merchant 0
4801184 2296552 2296552 defendant Sage William gent 611011 611011 Sage, William, of Scardeburgh, Yorks, gent 0
4816775 2301344 2301344 defendant Carter John gent 611011 611011 Carter, John, of Scardeburgh, Yorks, gent 1
4843466 2309475 2309475 defendant Bamburgh Robert gent 611011 611011 Bamburgh, Robert, of Scardeburgh, Yorks, gent 0
4844545 2309813 2309813 defendant Baumbugh Robert   611011 611011 Baumbugh, Robert, of Scardeburgh, Yorks, burgess & merchant 0
4865188 2316088 2316088 defendant Baumburgh Robert   611011 611011 Baumburgh, Robert, of Scardeburgh, Yorks 0
4865191 2316089 2316089 defendant Baumburgh Robert   611011 611011 Baumburgh, Robert, of Scardeburgh, Yorks 0
4905473 2328306 2328306 defendant Collom John chapman 611011 611011 Collom, John, of Scardeburgh, Yorks, chapman 0
4909311 2329454 2329454 defendant Drynge William merchant 611011 611011 Drynge, William, of Scardeburgh, Yorks, merchant 0
4909314 2329455 2329455 defendant Drynge William merchant 611011 611011 Drynge, William, of Scardeburgh, Yorks, merchant 0
4912085 2330282 2330282 defendant Lambhird John fisherman 611011 611011 Lambhird, John, of Scardeburgh, Yorks, fisherman 0
4929979 2335783 2335783 defendant Thorp John gent 611011 611011 Thorp, John, of Scardeburgh, Yorks, gent 0
4929981 2335784 2335784 defendant Thorp John gent 611011 611011 Thorp, John, of Scardeburgh, Yorks, gent 0
4934292 2337112 2337112 defendant Sage John merchant 611011 611011 Sage, John, of Scardeburgh, Yorks, merchant 0
4935118 2337392 2337392 defendant Appulby William mariner 611011 611011 Appulby, William, of Scardeburgh, Yorks, mariner 0
4935122 2337393 2337393 defendant Appulby William mariner 611011 611011 Appulby, William, of Scardeburgh, Yorks, mariner 0
4954966 2343444 2343444 defendant Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 0
4965167 2346507 2346507 defendant Brereton John, junior merchant 611011 611011 Brereton, John, junior, of Scardeburgh, Yorks, merchant 0
4973127 2348896 2348896 defendant Wardale Thomas merchant 611011 611011 Wardale, Thomas, of Scardeburgh, Yorks, merchant 0
4977795 2350317 2350317 defendant Topclyf George merchant 611011 611011 Topclyf, George, of Scardeburgh, Yorks, merchant 3
4977802 2350318 2350318 defendant Topclyf George merchant 611011 611011 Topclyf, George, of Scardeburgh, Yorks, merchant 3
4998704 2356499 2356499 defendant Dryng William merchant 611011 611011 Dryng, William, of Scardeburgh, Yorks, merchant 0
5024394 2364044 2364044 defendant Artherne Thomas gent 611011 611011 Artherne, Thomas, of Scardeburgh, Yorks, gent 2
5033232 2366601 2366601 defendant Carethorp Robert gent 611011 611011 Carethorp, Robert, of Scardeburgh, Yorks, gent 0
5047764 2370947 2370947 defendant Helperby Joan widow 611011 611011 Helperby, Joan, of Scardeburgh, Yorks, widow 0
5071649 2378014 2378014 defendant Suthake Henry vintner 611011 611011 Suthake, Henry, of Scardeburgh, Yorks, vintner 0
5080666 2380706 2380706 defendant Werdale Thomas merchant 611011 611011 Werdale, Thomas, of Scardeburgh, Yorks, merchant 0
5085461 2382139 2382139 defendant Helperby William gent 611011 611011 Helperby, William, of Scardeburgh, Yorks, gent 0
5102003 2387009 2387009 defendant Herryson John yeoman 611011 611011 Herryson, John, of Scardeburgh, Yorks, yeoman 1
5103464 2387440 2387440 defendant Sage Thomas merchant 611011 611011 Sage, Thomas, of Scardeburgh, Yorks, merchant 0
5108251 2388846 2388846 defendant Lambert John merchant 611011 611011 Lambert, John, of Scardeburgh, Yorks, merchant 0
5108565 2388944 2388944 defendant Lamberd John mariner 611011 611011 Lamberd, John, of Scardeburgh, Yorks, mariner 0
5154059 2402346 2402346 plaintiff Lambert John esq 611011 611011 Lambert, John, of Scardeburgh, Yorks, esq 0
5159141 2403789 2403789 plaintiff Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 0
5163957 2405197 2405197 defendant Mitford William merchant 611011 611011 Mitford, William, of Scardeburgh, Yorks, merchant 2
5163961 2405198 2405198 defendant Mitford William merchant 611011 611011 Mitford, William, of Scardeburgh, Yorks, merchant 2
5171283 2407323 2407323 plaintiff Lambert John esq 611011 611011 Lambert, John, of Scardeburgh, Yorks, esq 0
5174383 2408209 2408209 plaintiff Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 0
5177406 2409088 2409088 defendant Mitford William merchant 611011 611011 Mitford, William, of Scardeburgh, Yorks, merchant 2
5189597 2412700 2412700 plaintiff Lambert John esq 611011 611011 Lambert, John, of Scardeburgh, Yorks, esq 0
5195002 2414287 2414287 plaintiff Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 0
5209050 2418378 2418378 plaintiff Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 0
5224064 2422721 2422721 defendant Herryson Richard jeweller 611011 611011 Herryson, Richard, of Scardeburgh, Yorks, jeweller 2
5232054 2424946 2424946 defendant Boure Robert merchant 611011 611011 Boure, Robert, of Scardeburgh, Yorks, merchant 1
5239141 2427037 2427037 plaintiff Henryson John   611011 611011 Henryson, John, of Scardeburgh, Yorks 0
5239145 2427038 2427038 defendant Butler John mariner 611011 611011 Butler, John, of Scardeburgh, Yorks, mariner 0
5250872 2430384 2430384 defendant Robynson Richard merchant 611011 611011 Robynson, Richard, of Scardeburgh, Yorks, merchant 0
5250892 2430388 2430388 defendant Robynson Richard merchant 611011 611011 Robynson, Richard, of Scardeburgh, Yorks, merchant 0
5266167 2435170 2435170 defendant Helperby William gent 611011 611011 Helperby, William, of Scardeburgh, Yorks, gent 0
5267130 2435478 2435478 defendant Tomson David weaver 611011 611011 Tomson, David, of Scardeburgh, Yorks, weaver 0
5323813 2452205 2452205 defendant Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 3
5330132 2454089 2454089 defendant Harryson John yeoman 611011 611011 Harryson, John, of Scardeburgh, Yorks, yeoman 1
5395011 2473638 2473638 defendant Willesthorp William gent 611011 611011 Willesthorp, William, of Scardeburgh, Yorks, gent 0
5408282 2477445 2477445 defendant Willesthorp William gent 611011 611011 Willesthorp, William, of Scardeburgh, Yorks, gent 0
5421499 2481362 2481362 defendant Robynson John, sen merchant 611011 611011 Robynson, John, sen, of Scardeburgh, Yorks, merchant 0
5440843 2487172 2487172 defendant Willesthorp William gent 611011 611011 Willesthorp, William, of Scardeburgh, Yorks, gent 0
5462945 2493830 2493830 plaintiff Robynson John merchant 611011 611011 Robynson, John, of Scardeburgh, Yorks, merchant 0
5522221 2511766 2511766 defendant Conyers Christopher gent 611011 611011 Conyers, Christopher, of Scardeburgh, Yorks, gent 3
5523522 2512187 2512187 plaintiff Fysche John   611011 611011 Fysche, John, of Scardeburgh, Yorks 0
5529566 2513746 2513746 defendant Fissher Robert merchant 611011 611011 Fissher, Robert, of Scardeburgh, Yorks, merchant 0
5543472 2518075 2518075 defendant Fyssher Robert merchant 611011 611011 Fyssher, Robert, of Scardeburgh, Yorks, merchant 0
5578299 2528282 2528282 plaintiff Anderson Thomas merchant 611011 611011 Anderson, Thomas, of Scardeburgh, Yorks, merchant 0
5578526 2528355 2528355 defendant Paulyn Robert gent 611011 611011 Paulyn, Robert, of Scardeburgh, Yorks, gent 0
5629256 2553125 2553125 defendant Castell John   611011 611011 Castell, John, of Scardeburgh, Yorks, holy water clerk 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);