names

108 rows where place_id = 685531

✎ 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
4062963 2047056 2047056 defendant Lane John shoemaker 685531 685531 Lane, John, of Chesterfield, shoemaker 0
4093839 2058120 2058120 defendant Parker William husbandman 685531 685531 Parker, William, of Chesterfield, husbandman 0
4425417 2172775 2172775 plaintiff Manger Roger   685531 685531 Manger, Roger, of Chesterfield 0
4425418 2172775 2172775 defendant Percer William   685531 685531 Percer, William, of Chesterfield 0
4426409 2173069 2173069 defendant Eyre Roger le   685531 685531 Eyre, Roger le, of Chesterfield 0
4479048 2194102 2194102 plaintiff Barley John de   685531 685531 Barley, John de, of Chesterfield 3
4484979 2196002 2196002 defendant Pees Roger   685531 685531 Pees, Roger, of Chesterfield 0
4487102 2196690 2196690 plaintiff Potter Richard chaplain 685531 685531 Potter, Richard, of Chesterfield, chaplain 1
4493692 2198725 2198725 defendant Tapton John de   685531 685531 Tapton, John de, of Chesterfield 2
4502674 2201419 2201419 plaintiff Nettilworth Robert   685531 685531 Nettilworth, Robert, of Chesterfield 0
4518842 2206258 2206258 plaintiff Draper Hugh   685531 685531 Draper, Hugh, of Chesterfield 0
4518844 2206259 2206259 plaintiff Draper Hugh   685531 685531 Draper, Hugh, of Chesterfield 0
4530709 2209896 2209896 defendant Kylyngton Robert de   685531 685531 Kylyngton, Robert de, of Chesterfield 0
4532006 2210274 2210274 defendant Whyte Agnes   685531 685531 Whyte, Agnes, of Chesterfield 2
4534952 2211211 2211211 plaintiff Shawe William   685531 685531 Shawe, William, of Chesterfield 0
4535001 2211228 2211228 defendant Bate William   685531 685531 (Bate, William, of Chesterfield 1
4536656 2211744 2211744 defendant Nettelworth Robert de   685531 685531 Nettelworth, Robert de, of Chesterfield 0
4540304 2212864 2212864 defendant Clerk Henry   685531 685531 Clerk, Henry, of Chesterfield 0
4544651 2214239 2214239 defendant Laverok Thomas   685531 685531 Laverok, Thomas, of Chesterfield 0
4547523 2215158 2215158 plaintiff Calcroft John   685531 685531 Calcroft, John, of Chesterfield 0
4558281 2218532 2218532 defendant Nettelworth Roger   685531 685531 Nettelworth, Roger, of Chesterfield 0
4562415 2219804 2219804 plaintiff Porter Richard   685531 685531 Porter, Richard, of Chesterfield, vicar 0
4564983 2220616 2220616 defendant Pees Roger   685531 685531 Pees, Roger, of Chesterfield 1
4564984 2220616 2220616 defendant Stanley Robert de   685531 685531 Stanley, Robert de, of Chesterfield 2
4571975 2222807 2222807 defendant Hull Roger de   685531 685531 Hull, Roger de, of Chesterfield 11
4580234 2225305 2225305 defendant Calale John   685531 685531 Calale, John, of Chesterfield 0
4580511 2225392 2225392 defendant Kylyngton Richard   685531 685531 Kylyngton, Richard, of Chesterfield 0
4580512 2225392 2225392 defendant Lylyngton Robert   685531 685531 Lylyngton, Robert, of Chesterfield 1
4581099 2225573 2225573 plaintiff Draper Hugh   685531 685531 Draper, Hugh, of Chesterfield 0
4583441 2226240 2226240 defendant Colyer William   685531 685531 Colyer, William, of Chesterfield 1
4597412 2230433 2230433 defendant Selston John   685531 685531 Selston, John, of Chesterfield 5
4598897 2230880 2230880 defendant Pees Roger   685531 685531 Pees, Roger, of Chesterfield 0
4613863 2235351 2235351 defendant Marre John   685531 685531 Marre, John, of Chesterfield 2
4620888 2237512 2237512 defendant Normanton John   685531 685531 Normanton, John, of Chesterfield 4
4624575 2238669 2238669 plaintiff Normanton John   685531 685531 Normanton, John, of Chesterfield 0
4626035 2239099 2239099 defendant del Hyllys Roger   685531 685531 del Hyllys, Roger, of Chesterfield 0
4636394 2242220 2242220 plaintiff Baret Thomas   685531 685531 Baret, Thomas, of Chesterfield 0
4636608 2242276 2242276 plaintiff Baxster John   685531 685531 Baxster, John, of Chesterfield 0
4638132 2242690 2242690 defendant Lees Thomas of the   685531 685531 Lees, Thomas of the, of Chesterfield 0
4638211 2242719 2242719 defendant Hilles (illegible)   685531 685531 Hilles, _, of Chesterfield 1
4640325 2243285 2243285 defendant Wryght John   685531 685531 Wryght, John, of Chesterfield, son of Roger 0
4645082 2244632 2244632 defendant Berygh William   685531 685531 Berygh, William, of Chesterfield 0
4674697 2257696 2257696 defendant Aleyn Thomas sheerman 685531 685531 Aleyn, Thomas, of Chesterfield, sheerman 0
4679778 2259288 2259288 defendant Cook Richard draper 685531 685531 Cook, Richard, of Chesterfield, draper 1
4688236 2261889 2261889 defendant Gunner John milner 685531 685531 Gunner, John, of Chesterfield, milner 1
4696131 2264273 2264273 plaintiff Calcroft Thomas   685531 685531 Calcroft, Thomas, of Chesterfield 0
4696802 2264479 2264479 defendant Sergeaunt Robert yeoman 685531 685531 Sergeaunt, Robert, of Chesterfield, yeoman 0
4697780 2264802 2264802 plaintiff Cooke Richard   685531 685531 Cooke, Richard, of Chesterfield 0
4698795 2265104 2265104 plaintiff del Boure Thurstan   685531 685531 del Boure, Thurstan, of Chesterfield 0
4705457 2267074 2267074 defendant Gawle Thomas mercer 685531 685531 Gawle, Thomas, of Chesterfield, mercer 0
4705458 2267074 2267074 defendant Cook Richard draper 685531 685531 Cook, Richard, of Chesterfield, draper 1
4718578 2271149 2271149 plaintiff Baret Thomas   685531 685531 Baret, Thomas, of Chesterfield 0
4725847 2273372 2273372 defendant Reper Adam   685531 685531 Reper, Adam, of Chesterfield, rope maker 0
4731858 2275150 2275150 defendant Smythson William yeoman 685531 685531 Smythson, William, of Chesterfield, yeoman 5
4734088 2275845 2275845 defendant Barker John tanner 685531 685531 Barker, John, of Chesterfield, tanner 1
4734089 2275845 2275845 defendant Edenson Robert (legal representative) 685531 685531 Edenson, Robert, of Chesterfield, butcher, executors of 2
4734090 2275845 2275845 defendant Haukynman Thomas butcher 685531 685531 (Haukynman, Thomas, of Chesterfield, butcher 3
4734091 2275845 2275845 defendant Barley Thomas chaplain 685531 685531 Barley, Thomas, of Chesterfield, chaplain 4
4734156 2275864 2275864 plaintiff Saer William   685531 685531 Saer, William, of Chesterfield 0
4738100 2277020 2277020 defendant Heyndeley Henry   685531 685531 Heyndeley, Henry, of Chesterfield, nail maker 0
4738630 2277171 2277171 defendant Lees Thomas yeoman 685531 685531 Lees, Thomas, of Chesterfield, yeoman 0
4738633 2277171 2277171 defendant Barton Thomas yeoman 685531 685531 together with Barton, Thomas, of Chesterfield, yeoman 3
4741394 2277981 2277981 plaintiff Boler Roger (legal representative) 685531 685531 Boler, Roger, of Chesterfield, executors of 0
4741399 2277982 2277982 plaintiff Boler Roger (legal representative) 685531 685531 Boler, Roger, of Chesterfield, executors of 0
4755785 2282192 2282192 plaintiff Baret Thomas   685531 685531 Baret, Thomas, of Chesterfield 0
4756091 2282283 2282283 defendant Porter William sheerman 685531 685531 Porter, William, of Chesterfield, sheerman 3
4756093 2282283 2282283 defendant Netilworth Roger yeoman 685531 685531 Netilworth, Roger, of Chesterfield, yeoman 5
4766387 2285479 2285479 plaintiff Leche John   685531 685531 Leche, John, of Chesterfield 0
4771259 2286992 2286992 defendant Cutteler William cutler 685531 685531 Cutteler, William, of Chesterfield, cutler 3
4771260 2286992 2286992 defendant Rygot Roger   685531 685531 Rygot, Roger, of Chesterfield, cart wright 4
4771261 2286992 2286992 defendant Webster William clerk 685531 685531 Webster, William, of Chesterfield, clerk 5
4771264 2286993 2286993 defendant Smyth William husbandman 685531 685531 Smyth, William, of Chesterfield, husbandman 1
4772954 2287512 2287512 defendant Plattes Robert de yeoman 685531 685531 Plattes, Robert de, of Chesterfield, yeoman 0
4773481 2287677 2287677 defendant Gounour John miller 685531 685531 Gounour, John, of Chesterfield, miller 0
4773482 2287677 2287677 defendant Kame Thomas   685531 685531 Kame, Thomas, of Chesterfield, shoe maker 1
4773483 2287677 2287677 defendant Masun Richard   685531 685531 Masun, Richard, of Chesterfield, glove maker 2
4773484 2287677 2287677 defendant Kame John   685531 685531 Kame, John, of Chesterfield, shoe maker 3
4773485 2287677 2287677 defendant Burton John yeoman 685531 685531 Burton, John, of Chesterfield, yeoman 4
4833744 2306565 2306565 plaintiff Coke Richard   685531 685531 Coke, Richard, of Chesterfield 0
4833745 2306565 2306565 plaintiff Bradschaghe William draper 685531 685531 Bradschaghe, William, of Chesterfield, draper 1
4833747 2306565 2306565 defendant Blore Alice widow 685531 685531 Blore, Alice, of Chesterfield, widow 1
4838908 2308100 2308100 defendant Grenelefe John mercer 685531 685531 Grenelefe, John, of Chesterfield, mercer 0
4838909 2308100 2308100 defendant Cheyne John yeoman 685531 685531 Cheyne, John, of Chesterfield, yeoman 1
4841951 2309019 2309019 defendant Grenelefe John mercer 685531 685531 Grenelefe, John, of Chesterfield, mercer 0
4841953 2309020 2309020 defendant Grenelefe John merter or mercer 685531 685531 Grenelefe, John, of Chesterfield, merter or mercer 0
4843000 2309352 2309352 defendant Sergeant Robert yeoman 685531 685531 Sergeant, Robert, of Chesterfield, yeoman 1
4843040 2309358 2309358 defendant Chaloner Robert yeoman 685531 685531 Chaloner, Robert, of Chesterfield, yeoman 2
4846129 2310296 2310296 defendant Dykson Ellis yeoman 685531 685531 Dykson, Ellis, of Chesterfield, yeoman 1
4923759 2333873 2333873 defendant Bullok John yeoman & son of Thomas 685531 685531 Bullok, John, of Chesterfield, yeoman & son of Thomas 0
4994548 2355235 2355235 defendant Fithet or Fichet John yeoman 685531 685531 Fithet or Fichet, John, of Chesterfield, yeoman 0
4994549 2355235 2355235 defendant Bryg Roger shoemaker 685531 685531 Bryg, Roger, of Chesterfield, shoemaker 1
4994557 2355236 2355236 defendant Bryd Thomas fishmonger 685531 685531 Bryd, Thomas, of Chesterfield, fishmonger 1
5007645 2359137 2359137 defendant Bemick Nicholas yeoman 685531 685531 Bemick, Nicholas, of Chesterfield, yeoman 1
5007650 2359138 2359138 defendant Moltson John husbandman 685531 685531 Moltson, John, of Chesterfield, husbandman 2
5185201 2411418 2411418 defendant Glover Ralph   685531 685531 Glover, Ralph, of Chesterfield, glove maker 1
5185202 2411418 2411418 defendant Pecok William smith 685531 685531 Pecok, William, of Chesterfield, smith 2
5302735 2445800 2445800 plaintiff Fox William   685531 685531 Fox, William, of Chesterfield 0
5303958 2446188 2446188 defendant Hethcotes James chapman 685531 685531 Hethcotes, James, of Chesterfield, chapman 2
5369354 2466017 2466017 defendant Tounend Richard butcher 685531 685531 Tounend, Richard, of Chesterfield, butcher 1
5369377 2466019 2466019 defendant Canon Thomas yeoman 685531 685531 Canon, Thomas, of Chesterfield, yeoman 2

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