names

234 rows where place_id = 606667

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656642 1912330 1912330 defendant Ivys Richard   606667 606667 Ivys, Richard, of Reading, inn holder 1
3657150 1912500 1912500 defendant White John   606667 606667 White, John, of Reading, bell founder 0
3661200 1913777 1913777 plaintiff Justice William   606667 606667 Justice, William, of Reading, senior 0
3666101 1915342 1915342 defendant Rawlyns Robert dyer 606667 606667 Rawlyns, Robert, of Reading, dyer 0
3666312 1915414 1915414 defendant Mirthe Thomas mercer 606667 606667 Mirthe, Thomas, of Reading, mercer 0
3666314 1915415 1915415 defendant Mirthe Thomas mercer 606667 606667 Mirthe, Thomas, of Reading, mercer 0
3931551 2000852 2000852 defendant Varney John yeoman 606667 606667 Varney, John, of Reading, yeoman 0
4109143 2063524 2063524 defendant Payse John yeoman 606667 606667 Payse, John, of Reading, yeoman 1
4109391 2063621 2063621 defendant Mounseye Christopher tanner 606667 606667 Mounseye, Christopher, of Reading, tanner 1
4128803 2070595 2070595 defendant Allatt Nicholas chapman 606667 606667 Allatt, Nicholas, of Reading, chapman 1
4220672 2102729 2102729 defendant Badger Thomas gent 606667 606667 Badger, Thomas, of Reading, or of Middle Temple, London, gent 0
4220674 2102730 2102730 defendant Badger Thomas gent 606667 606667 Badger, Thomas, of Reading, or of Middle Temple, London, gent 0
4305133 2131934 2131934 defendant Wilson John mercer 606667 606667 Wilson, John, of Reading, mercer 0
4305134 2131934 2131934 defendant Bredd Richard schoolmaster 606667 606667 Bredd, Richard, of Reading, schoolmaster 1
4305135 2131934 2131934 defendant Mathewe John tailor 606667 606667 Mathewe, John, of Reading, tailor 2
4305136 2131934 2131934 defendant Nicholson Richard yeoman 606667 606667 Nicholson, Richard, of Reading, yeoman 3
4341129 2144169 2144169 defendant Dumper John (legal representative) 606667 606667 Dumper, John, of Reading, shoemaker, executors of 1
4389587 2161146 2161146 defendant Dee Robert   606667 606667 Dee, Robert, of Reading, tallow chandler 0
4394730 2162824 2162824 defendant Sewell Christopher currier 606667 606667 Sewell, Christopher, of Reading, currier 0
4394731 2162824 2162824 defendant Cleere Daniel yeoman 606667 606667 Cleere, Daniel, of Reading, yeoman 1
4397308 2163677 2163677 defendant Fisher Thomas yeoman 606667 606667 Fisher, Thomas, of Reading, or of West Shefford, yeoman 0
4397310 2163678 2163678 defendant Goddard Roger yeoman 606667 606667 Goddard, Roger, of Reading, or of Henwick, Thacham, yeoman 0
4416414 2170014 2170014 plaintiff Milbych John   606667 606667 Milbych, John, of Reading, son of William 0
4416415 2170014 2170014 defendant Peyntour John butcher 606667 606667 Peyntour, John, of Reading, butcher 0
4417419 2170331 2170331 plaintiff Sellych John   606667 606667 Sellych, John, of Reading, son of William 0
4417420 2170331 2170331 defendant Peyntour John butcher 606667 606667 Peyntour, John, of Reading, butcher 0
4434851 2175656 2175656 defendant Waryner John le   606667 606667 Waryner, John le, of Reading 0
4435482 2175855 2175855 defendant Wynmundham Richard draper 606667 606667 Wynmundham, Richard, of Reading, draper 0
4474599 2192716 2192716 defendant Thorn John   606667 606667 Thorn, John, of Reading 3
4485046 2196022 2196022 defendant Catour William   606667 606667 Catour, William, of Reading 2
4485231 2196085 2196085 defendant atte Lee Robert shoemaker 606667 606667 atte Lee, Robert, of Reading, shoemaker 0
4509927 2203590 2203590 defendant Goldsmyth William   606667 606667 Goldsmyth, William, of Reading 0
4514514 2204960 2204960 defendant Shirman John   606667 606667 Shirman, John, of Reading 2
4521998 2207220 2207220 defendant Fister Henry   606667 606667 Fister, Henry, of Reading 2
4522208 2207289 2207289 defendant Goldsmyth William   606667 606667 Goldsmyth, William, of Reading 1
4525308 2208258 2208258 defendant Fuller Thomas   606667 606667 Fuller, Thomas, of Reading 4
4550943 2216230 2216230 defendant Shepherd Thomas   606667 606667 Shepherd, Thomas, of Reading 3
4551221 2216323 2216323 defendant Chorne William   606667 606667 Chorne, William, of Reading 1
4551222 2216323 2216323 defendant Stodham John   606667 606667 Stodham, John, of Reading 2
4577823 2224568 2224568 defendant Hay Roger   606667 606667 Hay, Roger, of Reading 0
4593845 2229350 2229350 plaintiff Pernecote Richard   606667 606667 Pernecote, Richard, of Reading 0
4598930 2230888 2230888 defendant Hay Roger   606667 606667 Hay, Roger, of Reading 0
4614310 2235490 2235490 defendant Sadeler William   606667 606667 Sadeler, William, of Reading 0
4614312 2235490 2235490 defendant Scorryer Robert   606667 606667 Scorryer, Robert, of Reading 2
4635806 2242042 2242042 plaintiff Arle John   606667 606667 Arle, John, of Reading 0
4638872 2242892 2242892 defendant Stappere Stephen   606667 606667 Stappere, Stephen, of Reading 0
4638873 2242892 2242892 defendant Chaundeler William   606667 606667 Chaundeler, William, of Reading 1
4647561 2245344 2245344 defendant Wolnare John   606667 606667 Wolnare, John, of Reading 1
4648232 2245546 2245546 defendant Wilton William   606667 606667 Wilton, William, of Reading 1
4672540 2257058 2257058 defendant Maihen William butcher 606667 606667 Maihen, William, of Reading, butcher 0
4676014 2258108 2258108 defendant Fyssher William fisher 606667 606667 Fyssher, William, of Reading, fisher 1
4687639 2261716 2261716 defendant Wilton William   606667 606667 Wilton, William, of Reading 2
4693347 2263423 2263423 plaintiff Baron William (legal representative) 606667 606667 Baron, William, of Reading, executors of 0
4694306 2263717 2263717 defendant Swalcleve John chapman 606667 606667 Swalcleve, John, of Reading, chapman 1
4698956 2265151 2265151 plaintiff Derby William dyer 606667 606667 Derby, William, of Reading, dyer 0
4699013 2265163 2265163 defendant Boteler Henry yeoman 606667 606667 Boteler, Henry, of Reading, formerly with Lady la Despenser, Berks, yeoman 2
4699017 2265164 2265164 defendant Boteler Henry yeoman 606667 606667 Boteler, Henry, of Reading, formerly with Lady la Despenser, Berks, yeoman 2
4705079 2266961 2266961 defendant Fynchamstede Bernard chapman 606667 606667 Fynchamstede, Bernard, of Reading, chapman 1
4708042 2267889 2267889 plaintiff Mustard Walter   606667 606667 Mustard, Walter, of Reading 0
4708044 2267890 2267890 plaintiff Mustard Walter   606667 606667 Mustard, Walter, of Reading 0
4708046 2267891 2267891 plaintiff Mustard Walter   606667 606667 Mustard, Walter, of Reading 0
4708048 2267892 2267892 plaintiff Mustard Walter   606667 606667 Mustard, Walter, of Reading 0
4722033 2272220 2272220 defendant Bryght William dyer 606667 606667 Bryght, William, of Reading, dyer 0
4722034 2272220 2272220 defendant Pecok William dyer 606667 606667 Pecok, William, of Reading, dyer 1
4722035 2272220 2272220 defendant Chapman William fishmonger 606667 606667 Chapman, William, of Reading, fishmonger 2
4723493 2272656 2272656 plaintiff Derby William dyer 606667 606667 Derby, William, of Reading, dyer 0
4732996 2275499 2275499 defendant Goolde John butcher 606667 606667 Goolde, John, of Reading, butcher 1
4738390 2277104 2277104 defendant Horewod Lawrence clerk 606667 606667 Horewod, Lawrence, of Reading, clerk 0
4744495 2278914 2278914 plaintiff Erle Thomas   606667 606667 Erle, Thomas, of Reading, abbot 0
4744497 2278915 2278915 plaintiff Erle Thomas   606667 606667 Erle, Thomas, of Reading, abbot 0
4746293 2279412 2279412 defendant Fissher William fisher 606667 606667 Fissher, William, of Reading, fisher 1
4750412 2280600 2280600 defendant Sydenale John husbandman 606667 606667 Sydenale, John, of Reading, husbandman 2
4755552 2282116 2282116 defendant _dem Thomas   606667 606667 _dem, Thomas, of Reading 0
4769046 2286297 2286297 defendant Mustard Walter husbandman 606667 606667 Mustard, Walter, of Reading, husbandman 0
4769053 2286299 2286299 defendant Goolde John butcher 606667 606667 Goolde, John, of Reading, butcher 0
4769954 2286576 2286576 plaintiff Porter Simon   606667 606667 Porter, Simon, of Reading 0
4769957 2286576 2286576 defendant Yde John fisherman 606667 606667 Yde, John, of Reading, fisherman 2
4771413 2287041 2287041 plaintiff (not given) John vicar of Saunford 606667 606667 Saunford, John, of Reading, vicar of St Giles church 0
4772418 2287341 2287341 plaintiff Spyrlyng William   606667 606667 Spyrlyng, William, of Reading, bow maker 0
4812333 2299970 2299970 defendant Boteler Henry barber 606667 606667 Boteler, Henry, of Reading, barber 0
4814250 2300561 2300561 plaintiff Hunt William fisher 606667 606667 Hunt, William, of Reading, fisher, on his own account 0
4814251 2300561 2300561 defendant Smyth William fisher 606667 606667 Smyth, William, of Reading, fisher 0
4820974 2302647 2302647 defendant Belam John yeoman 606667 606667 Belam, John, of Reading, yeoman 0
4825765 2304093 2304093 defendant Canon John laborer 606667 606667 Canon, John, of Reading, laborer 1
4830086 2305454 2305454 defendant Morys John hosier 606667 606667 Morys, John, of Reading, hosier 4
4830092 2305455 2305455 defendant Morys John hosier 606667 606667 Morys, John, of Reading, hosier 4
4831097 2305757 2305757 defendant Boughton John ostler 606667 606667 Boughton, John, of Reading, ostler 0
4833631 2306525 2306525 plaintiff Clynton John   606667 606667 Clynton, John, of Reading 0
4833633 2306526 2306526 plaintiff Clynton John   606667 606667 Clynton, John, of Reading 0
4833816 2306583 2306583 defendant Pake Richard husbandman 606667 606667 Pake, Richard, of Reading, husbandman 1
4842893 2309319 2309319 plaintiff Godsale William   606667 606667 (Godsale, William, of Reading 1
4842895 2309319 2309319 defendant Counseyll William   606667 606667 Counseyll, William, of Reading, weaver, administrators of 0
4846439 2310393 2310393 plaintiff Prestwold alias Jekes Ivan (legal representative) 606667 606667 Prestwold alias Jekes, Ivan, of Reading, esq, executrix of 0
4847416 2310696 2310696 plaintiff Roolf Henry draper 606667 606667 Roolf, Henry, of Reading, draper 0
4849492 2311314 2311314 plaintiff Stapper William   606667 606667 Stapper, William, of Reading 0
4917563 2332008 2332008 defendant Canon John yeoman 606667 606667 Canon, John, of Reading, yeoman 1
4919100 2332487 2332487 plaintiff Henley Thomas   606667 606667 Henley, Thomas, of Reading, abbot of the monastery 0
4931937 2336375 2336375 defendant Date John smith 606667 606667 Date, John, of Reading, smith 0
4987242 2353134 2353134 plaintiff Beke Thomas   606667 606667 Beke, Thomas, of Reading 0
4987247 2353134 2353134 defendant Goldry Thomas fuller 606667 606667 Goldry, Thomas, of Reading, fuller 4

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