names

75 rows where place_id = 597093

✎ 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
3627269 1903375 1903375 plaintiff Blakwall Thomas yeoman 597093 597093 Blakwall, Thomas, of Wyrkesworth, yeoman 0
3634511 1905596 1905596 defendant Somer Christopher laborer 597093 597093 Somer, Christopher, of Wyrkesworth, laborer 0
3651436 1910813 1910813 defendant Stroke Nicholas   597093 597093 Stroke, Nicholas, of Wyrkesworth, organ maker 0
3670069 1916584 1916584 defendant Glossop William yeoman 597093 597093 Glossop, William, of Wyrkesworth, yeoman 0
3685279 1921550 1921550 defendant Foxe John yeoman 597093 597093 Foxe, John, of Wyrkesworth, yeoman 3
3775451 1950066 1950066 plaintiff Blakwall Thomas (legal representative) 597093 597093 Blakwall, Thomas, of Wyrkesworth, executors of 0
3780535 1951642 1951642 plaintiff Gell Roger   597093 597093 Gell, Roger, of Wyrkesworth 0
3796765 1956873 1956873 defendant Wygley Alice widow 597093 597093 Wygley, Alice, of Wyrkesworth, widow 1
3861252 1977235 1977235 plaintiff Ferne John   597093 597093 Ferne, John, of Wyrkesworth 0
3861257 1977235 1977235 defendant Hyll John shoemaker 597093 597093 Hyll, John, of Wyrkesworth, shoemaker 4
3863804 1978069 1978069 defendant Glossop William   597093 597093 Glossop, William, of Wyrkesworth 0
3875388 1982014 1982014 plaintiff Ferne John   597093 597093 Ferne, John, of Wyrkesworth 0
3875390 1982015 1982015 plaintiff Ferne John   597093 597093 Ferne, John, of Wyrkesworth 0
3875983 1982219 1982219 defendant Barton John laborer 597093 597093 Barton, John, of Wyrkesworth, laborer 0
3875985 1982219 1982219 defendant Beyghton Christopher smelter 597093 597093 Beyghton, Christopher, of Wyrkesworth, smelter 2
3875986 1982219 1982219 defendant Gambull Richard glover 597093 597093 Gambull, Richard, of Wyrkesworth, glover 3
3890194 1986961 1986961 defendant Cantrell William butcher 597093 597093 Cantrell, William, of Wyrkesworth, butcher 0
3913093 1994710 1994710 defendant Glossopp Henry yeoman 597093 597093 Glossopp, Henry, of Wyrkesworth, yeoman 0
4416690 2170086 2170086 defendant Porter Richard le   597093 597093 Porter, Richard le, of Wyrkesworth 0
4416691 2170086 2170086 defendant Flaxentop Thomas   597093 597093 Flaxentop, Thomas, of Wyrkesworth 1
4416700 2170089 2170089 defendant Archer Thomas   597093 597093 Archer, Thomas, of Wyrkesworth 2
4422981 2172045 2172045 defendant Cromford Thomas de   597093 597093 Cromford, Thomas de, of Wyrkesworth 0
4422982 2172045 2172045 defendant Porter Richard le   597093 597093 Porter, Richard le, of Wyrkesworth 1
4426349 2173048 2173048 defendant Flaxentop Thomas   597093 597093 Flaxentop, Thomas, of Wyrkesworth 1
4426358 2173051 2173051 defendant Archer Thomas   597093 597093 Archer, Thomas, of Wyrkesworth 2
4525236 2208230 2208230 defendant Couper John   597093 597093 Couper, John, of Wyrkesworth 0
4536395 2211668 2211668 defendant Smyth John   597093 597093 Smyth, John, of Wyrkesworth 0
4536396 2211668 2211668 defendant Smyth William   597093 597093 Smyth, William, of Wyrkesworth 1
4536400 2211668 2211668 defendant Potter John   597093 597093 Potter, John, of Wyrkesworth 5
4575116 2223739 2223739 defendant Broun John   597093 597093 Broun, John, of Wyrkesworth 0
4619929 2237215 2237215 plaintiff (not given) John vicar of Howes 597093 597093 Howes, John, of Wyrkesworth, formerly vicar of the church, executors of 0
4843020 2309355 2309355 defendant Storour William yeoman 597093 597093 Storour, William, of Wyrkesworth, yeoman 1
4843021 2309355 2309355 defendant Pereson Richard smith 597093 597093 Pereson, Richard, of Wyrkesworth, smith 2
5007649 2359138 2359138 defendant Cho Roger husbandman 597093 597093 Cho, Roger, of Wyrkesworth, husbandman 1
5007670 2359141 2359141 defendant Wygley John yeoman 597093 597093 Wygley, John, of Wyrkesworth, yeoman 2
5054403 2372894 2372894 defendant Broxstowe Hugh yeoman 597093 597093 Broxstowe, Hugh, of Wyrkesworth, yeoman 2
5081533 2380978 2380978 defendant More Hugh yeoman 597093 597093 More, Hugh, of Wyrkesworth, yeoman 0
5117778 2391633 2391633 defendant Blakwall John yeoman 597093 597093 Blakwall, John, of Wyrkesworth, yeoman 0
5117779 2391633 2391633 defendant Smyth John yeoman 597093 597093 Smyth, John, of Wyrkesworth, yeoman 1
5122936 2393137 2393137 defendant Storer Thomas yeoman 597093 597093 Storer, Thomas, of Wyrkesworth, yeoman 4
5185159 2411405 2411405 defendant Eton Thomas   597093 597093 Eton, Thomas, of Wyrkesworth, vicar 0
5346828 2459165 2459165 defendant Smyth Thomas yeoman 597093 597093 Smyth, Thomas, of Wyrkesworth, yeoman 0
5346830 2459166 2459166 defendant Smyth Thomas yeoman 597093 597093 Smyth, Thomas, of Wyrkesworth, yeoman 0
5395020 2473642 2473642 defendant Harny Thomas walker 597093 597093 Harny, Thomas, of Wyrkesworth, walker 0
5402951 2475924 2475924 defendant Smyth Thomas   597093 597093 Smyth, Thomas, of Wyrkesworth 1
5409575 2477830 2477830 plaintiff Blakwall Richard   597093 597093 Blakwall, Richard, of Wyrkesworth 0
5409584 2477832 2477832 defendant Pereson John smith 597093 597093 Pereson, John, of Wyrkesworth, smith 2
5415927 2479696 2479696 defendant Smyth John, sen brynner 597093 597093 Smyth, John, sen, of Wyrkesworth, brynner 0
5415928 2479696 2479696 defendant Smyth Thomas yeoman 597093 597093 Smyth, Thomas, of Wyrkesworth, yeoman 1
5454709 2491331 2491331 defendant Eton Thomas clerk 597093 597093 Eton, Thomas, of Wyrkesworth, clerk 0
5454710 2491331 2491331 defendant Bramall William yeoman 597093 597093 Bramall, William, of Wyrkesworth, yeoman 1
5467115 2495110 2495110 plaintiff Blakwall Richard   597093 597093 Blakwall, Richard, of Wyrkesworth 0
5467117 2495110 2495110 defendant Helot Thomas weaver 597093 597093 Helot, Thomas, of Wyrkesworth, weaver 1
5477889 2498410 2498410 defendant Eton Thomas clerk 597093 597093 Eton, Thomas, of Wyrkesworth, clerk 0
5477890 2498410 2498410 defendant Bramall William yeoman 597093 597093 Bramall, William, of Wyrkesworth, yeoman 1
5477891 2498410 2498410 defendant Eton William laborer 597093 597093 Eton, William, of Wyrkesworth, laborer 2
5501848 2505505 2505505 defendant Forest Roger husbandman 597093 597093 Forest, Roger, of Wyrkesworth, husbandman 0
5510341 2508073 2508073 defendant Wode Wlliam husbandman 597093 597093 Wode, Wlliam, of Wyrkesworth, husbandman 0
5541228 2517377 2517377 defendant Bromhall Thomas   597093 597093 Bromhall, Thomas, of Wyrkesworth, yeoman, son of Bromhall, William, of Wyrkesworth, and Margaret his wife 0
5543133 2517971 2517971 defendant Dirley Richard laborer 597093 597093 Dirley, Richard, of Wyrkesworth, laborer 2
5548551 2519617 2519617 defendant Ryley Ralph glover 597093 597093 Ryley, Ralph, of Wyrkesworth, glover 0
5556043 2521763 2521763 defendant Blakwall Richard   597093 597093 Blakwall, Richard, of Wyrkesworth, lead burner 0
5578638 2528386 2528386 defendant Adam Thomas miner 597093 597093 Adam, Thomas, of Wyrkesworth, miner 17
5579937 2528805 2528805 defendant Lendhop John husbandman 597093 597093 Lendhop, John, of Wyrkesworth, husbandman 0
5585687 2530594 2530594 defendant Lyndop Thomas tailor 597093 597093 Lyndop, Thomas, of Wyrkesworth, tailor 0
5585688 2530594 2530594 defendant Fowke Nicholas laborer 597093 597093 Fowke, Nicholas, of Wyrkesworth, laborer 1
5585689 2530594 2530594 defendant Renysshawe John smith 597093 597093 Renysshawe, John, of Wyrkesworth, smith 2
5591146 2532209 2532209 defendant Flecher Richard husbandman 597093 597093 Flecher, Richard, of Wyrkesworth, husbandman 0
5591147 2532209 2532209 defendant Nontton Thomas tailor 597093 597093 Nontton, Thomas, of Wyrkesworth, tailor 1
5591148 2532209 2532209 defendant Flecher William laborer 597093 597093 Flecher, William, of Wyrkesworth, laborer 2
5593031 2532808 2532808 defendant Storer Thomas yeoman 597093 597093 Storer, Thomas, of Wyrkesworth, yeoman 1
5593035 2532808 2532808 defendant Lyndop John miner 597093 597093 Lyndop, John, of Wyrkesworth, miner 5
5594784 2533342 2533342 plaintiff Blakwall Elizabeth (legal representative) 597093 597093 Blakwall, Elizabeth, of Wyrkesworth, widow, executor of 0
5598744 2534484 2534484 defendant Mereman Mathew miner 597093 597093 Mereman, Mathew, of Wyrkesworth, miner 1
5606968 2537072 2537072 defendant Hygget William yeoman 597093 597093 Hygget, William, of Wyrkesworth, yeoman 1

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