names

183 rows where place_id = 603462

✎ 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
3654621 1911708 1911708 defendant Lendale William clothman 603462 603462 Lendale, William, of Reading, Berks, clothman 0
3656641 1912330 1912330 defendant Lynacre Robert dyer 603462 603462 Lynacre, Robert, of Reading, Berks, dyer 0
3656955 1912432 1912432 defendant Allbrute Lawrence   603462 603462 Allbrute, Lawrence, of Reading, Berks, "coke" 3
3933107 2001366 2001366 defendant Godfrey John   603462 603462 Godfrey, John, of Reading, Berks, soap maker 1
3934403 2001800 2001800 defendant Beeke Joan widow 603462 603462 Beeke, Joan, of Reading, Berks, widow 0
3939779 2003606 2003606 defendant Clerke Richard   603462 603462 Clerke, Richard, of Reading, Berks 3
3939903 2003645 2003645 defendant Clarke Richard yeoman & servant to the King's majesty 603462 603462 Clarke, Richard, of Reading, Berks, yeoman & servant to the King's majesty 3
3976617 2016398 2016398 plaintiff Knyght Richard clothman 603462 603462 Knyght, Richard, of Reading, Berks, clothman 0
4005005 2026572 2026572 defendant Bristoo or Briscoo Hugh gent 603462 603462 Bristoo or Briscoo, Hugh, of Reading, Berks, gent 1
4014277 2029836 2029836 defendant Pile John merchant 603462 603462 Pile, John, of Reading, Berks, merchant 1
4063273 2047161 2047161 plaintiff Gatley John (legal representative) 603462 603462 Gatley, John, of Reading, Berks, yeoman, executors of 0
4063278 2047162 2047162 plaintiff Gatley John (legal representative) 603462 603462 Gatley, John, of Reading, Berks, yeoman, executors of 0
4065316 2047879 2047879 defendant Raynoldes Thomas yeoman 603462 603462 Raynoldes, Thomas, of Reading, Berks, yeoman 0
4065411 2047919 2047919 defendant Aslett Thomas draper 603462 603462 Aslett, Thomas, of Reading, Berks, draper 0
4102385 2061145 2061145 defendant Hodson William butcher 603462 603462 Hodson, William, of Reading, Berks, butcher 0
4128802 2070595 2070595 defendant Burnham John chapman 603462 603462 Burnham, John, of Reading, Berks, chapman 0
4144715 2076312 2076312 defendant Hillary Christopher mercer 603462 603462 Hillary, Christopher, of Reading, Berks, mercer 0
4206844 2097936 2097936 defendant Nicolas Anthony yeoman 603462 603462 Nicolas, Anthony, of Reading, Berks, yeoman 3
4267049 2118621 2118621 defendant Newman John chapman 603462 603462 Newman, John, of Reading, Berks, chapman 0
4271910 2120178 2120178 defendant Moore John haberdasher 603462 603462 Moore, John, of Reading, Berks, haberdasher 3
4299496 2129911 2129911 defendant Hamlen Edward butcher 603462 603462 Hamlen, Edward, of Reading, Berks, butcher 0
4301240 2130554 2130554 defendant Key John harbinger to her Majesty 603462 603462 Key, John, of Reading, Berks, yeoman, harbinger to her Majesty 0
4341130 2144169 2144169 defendant Bide Thomas miller 603462 603462 (Bide, Thomas, of Reading, Berks, miller 2
4351327 2147715 2147715 defendant Collett Gideon yeoman 603462 603462 Collett, Gideon, of Reading, Berks, yeoman 0
4353676 2148505 2148505 defendant Wickens Thomas wharfinger or wharf keeper 603462 603462 Wickens, Thomas, of Reading, Berks, wharfinger or wharf keeper 0
4365536 2152741 2152741 defendant Belehamber Clement clothier 603462 603462 Belehamber, Clement, of Reading, Berks, clothier 0
4395721 2163154 2163154 defendant Drewe Francis carrier 603462 603462 Drewe, Francis, of Reading, Berks, yeoman, carrier 0
4478223 2193862 2193862 defendant Thorn William   603462 603462 Thorn, William, of Reading, Berks 0
4690211 2262495 2262495 defendant Broghton John tailor 603462 603462 Broghton, John, of Reading, Berks, tailor 0
4691157 2262754 2262754 defendant Keylok John husbandman 603462 603462 Keylok, John, of Reading, Berks, husbandman 3
4693102 2263348 2263348 defendant Fyssher William fishmonger 603462 603462 Fyssher, William, of Reading, Berks, fishmonger 2
4698626 2265047 2265047 defendant Pernod Richard husbandman 603462 603462 Pernod, Richard, of Reading, Berks, husbandman 0
4705388 2267054 2267054 defendant Mare Peter de la gent 603462 603462 Mare, Peter de la, of Reading, Berks, gent 1
4715998 2270313 2270313 defendant Gylot Nicholas   603462 603462 Gylot, Nicholas, of Reading, Berks, franklin 0
4716345 2270426 2270426 defendant Vayre John yeoman 603462 603462 Vayre, John, of Reading, Berks, yeoman 1
4718759 2271208 2271208 defendant Stappere Stephen weaver 603462 603462 Stappere, Stephen, of Reading, Berks, weaver 0
4722037 2272220 2272220 defendant Sope William butcher 603462 603462 Sope, William, of Reading, Berks, butcher 4
4727422 2273822 2273822 defendant Hasteler Thomas yeoman 603462 603462 Hasteler, Thomas, of Reading, Berks, yeoman 0
4734544 2275972 2275972 defendant Crosse Richard hosier 603462 603462 Crosse, Richard, of Reading, Berks, hosier 1
4738219 2277049 2277049 defendant Mustard Walter yeoman 603462 603462 Mustard, Walter, of Reading, Berks, yeoman 0
4738623 2277168 2277168 defendant Veyer John yeoman 603462 603462 Veyer, John, of Reading, Berks, yeoman 2
4744119 2278806 2278806 defendant Cros Richard draper 603462 603462 Cros, Richard, of Reading, Berks, draper 0
4748155 2279971 2279971 defendant Mustard Walter   603462 603462 Mustard, Walter, of Reading, Berks, bailiff 0
4754066 2281651 2281651 defendant Kaylok John yeoman 603462 603462 Kaylok, John, of Reading, Berks, yeoman 1
4755910 2282232 2282232 defendant Pecok William dyer 603462 603462 Pecok, William, of Reading, Berks, dyer 2
4759612 2283351 2283351 defendant Chapman William fishmonger 603462 603462 Chapman, William, of Reading, Berks, fishmonger 0
4767994 2285959 2285959 defendant Shepcombe John chapman 603462 603462 Shepcombe, John, of Reading, Berks, chapman 0
4768213 2286029 2286029 defendant Byddenham Thomas   603462 603462 Byddenham, Thomas, of Reading, Berks, warden of the house of the brothers minor 3
4769179 2286338 2286338 defendant Sadeler John sadler 603462 603462 Sadeler, John, of Reading, Berks, sadler 0
4806068 2298106 2298106 defendant colsell John yeoman 603462 603462 colsell, John, of Reading, Berks, yeoman 3
4806077 2298107 2298107 defendant Colsell John yeoman 603462 603462 Colsell, John, of Reading, Berks, yeoman 3
4809134 2299033 2299033 defendant Tournour Roger fisher 603462 603462 Tournour, Roger, of Reading, Berks, fisher 0
4809168 2299045 2299045 defendant Tournour Roger fisher 603462 603462 Tournour, Roger, of Reading, Berks, fisher 0
4816496 2301250 2301250 defendant Laurence John chapman 603462 603462 Laurence, John, of Reading, Berks, chapman 3
4816677 2301311 2301311 defendant Savage Richard fuller 603462 603462 Savage, Richard, of Reading, Berks, fuller 0
4816869 2301380 2301380 defendant Cresse Richard draper 603462 603462 Cresse, Richard, of Reading, Berks, draper 0
4816871 2301381 2301381 defendant Cresse Richard draper 603462 603462 Cresse, Richard, of Reading, Berks, draper 0
4821506 2302812 2302812 defendant Dyer Robert dyer 603462 603462 Dyer, Robert, of Reading, Berks, dyer 0
4830082 2305454 2305454 defendant Crosse Richard hosier 603462 603462 Crosse, Richard, of Reading, Berks, hosier 0
4830088 2305455 2305455 defendant Crosse Richard hosier 603462 603462 Crosse, Richard, of Reading, Berks, hosier 0
4830228 2305491 2305491 defendant Brasyer Thomas chapman 603462 603462 Brasyer, Thomas, of Reading, Berks, chapman 3
4830236 2305493 2305493 defendant Brassworker Thomas chapman 603462 603462 Brassworker, Thomas, of Reading, Berks, chapman 3
4842050 2309051 2309051 defendant Wylyer John weaver 603462 603462 Wylyer, John, of Reading, Berks, weaver 0
4846938 2310548 2310548 defendant Clynton John sadler 603462 603462 Clynton, John, of Reading, Berks, sadler 0
4848548 2311020 2311020 defendant Pond Thomas esq 603462 603462 Pond, Thomas, of Reading, Berks, esq 1
4853365 2312463 2312463 defendant Lambyn John   603462 603462 Lambyn, John, of Reading, Berks, parish clerk 0
4853974 2312651 2312651 defendant Erlegh John gent 603462 603462 Erlegh, John, of Reading, Berks, gent 0
4915332 2331302 2331302 defendant Henley Thomas   603462 603462 Henley, Thomas, of Reading, Berks, abbot 0
4915338 2331304 2331304 defendant Henley Thomas   603462 603462 Henley, Thomas, of Reading, Berks, abbot 0
4917562 2332008 2332008 defendant Barton Henry butcher 603462 603462 Barton, Henry, of Reading, Berks, butcher 0
4921960 2333276 2333276 defendant Skryvener Robert   603462 603462 Skryvener, Robert, of Reading, Berks, parchment maker 1
4928100 2335220 2335220 defendant Talbot John hostiller 603462 603462 Talbot, John, of Reading, Berks, hostiller 0
5003582 2357940 2357940 defendant Lylbourne Walter hosteler 603462 603462 Lylbourne, Walter, of Reading, Berks, hosteler 0
5003588 2357941 2357941 defendant Lylbourne Walter hosteler 603462 603462 Lylbourne, Walter, of Reading, Berks, hosteler 0
5007390 2359054 2359054 defendant Pynweke William chapman 603462 603462 Pynweke, William, of Reading, Berks, chapman 2
5007395 2359055 2359055 defendant Pynweke William chapman 603462 603462 Pynweke, William, of Reading, Berks, chapman 2
5009306 2359612 2359612 defendant Lylborne Walter yeoman 603462 603462 Lylborne, Walter, of Reading, Berks, yeoman 0
5039693 2368514 2368514 defendant Kent Simon chapman 603462 603462 Kent, Simon, of Reading, Berks, chapman 2
5042500 2369362 2369362 defendant Warmyngton Robert merchant 603462 603462 Warmyngton, Robert, of Reading, Berks, merchant 0
5045233 2370202 2370202 defendant Payne Thomas chapman 603462 603462 Payne, Thomas, of Reading, Berks, chapman 0
5047256 2370801 2370801 defendant Payne Thomas merchant 603462 603462 Payne, Thomas, of Reading, Berks, merchant 0
5048623 2371228 2371228 defendant Rudham alias Lylbourne Walter yeoman 603462 603462 Rudham alias Lylbourne, Walter, of Reading, Berks, yeoman 1
5048631 2371229 2371229 defendant Rudham alias Lilbourne Walter yeoman 603462 603462 Rudham alias Lilbourne, Walter, of Reading, Berks, yeoman 1
5124708 2393702 2393702 defendant Tauke Richard   603462 603462 Tauke, Richard, of Reading, Berks, gold smith 0
5130536 2395413 2395413 defendant Wilcokkes William chapman 603462 603462 Wilcokkes, William, of Reading, Berks, chapman 0
5132384 2395969 2395969 defendant Strang William smith 603462 603462 Strang, William, of Reading, Berks, smith 1
5133180 2396182 2396182 defendant Farley Robert draper 603462 603462 Farley, Robert, of Reading, Berks, draper 0
5133183 2396183 2396183 defendant Farley Robert draper 603462 603462 Farley, Robert, of Reading, Berks, draper 0
5136144 2397083 2397083 defendant Smyth William dyer 603462 603462 Smyth, William, of Reading, Berks, dyer 0
5137707 2397542 2397542 defendant Ludbroke Simon merchant 603462 603462 Ludbroke, Simon, of Reading, Berks, merchant 3
5139318 2397988 2397988 defendant Bruer Thomas gent 603462 603462 Bruer, Thomas, of Reading, Berks, gent 3
5141606 2398656 2398656 defendant Morys John   603462 603462 Morys, John, of Reading, Berks, tallow chandler 0
5143285 2399172 2399172 defendant Tauke Richard goldsmith 603462 603462 Tauke, Richard, of Reading, Berks, goldsmith 0
5145999 2399953 2399953 defendant Playse Robert yeoman 603462 603462 Playse, Robert, of Reading, Berks, yeoman 0
5146003 2399953 2399953 defendant Aylesham John tailor 603462 603462 Aylesham, John, of Reading, Berks, tailor 4
5151261 2401516 2401516 defendant Colyngburn William yeoman 603462 603462 Colyngburn, William, of Reading, Berks, yeoman 0
5151263 2401517 2401517 defendant Colyngburn William yeoman 603462 603462 Colyngburn, William, of Reading, Berks, yeoman 0
5152142 2401764 2401764 defendant Strang William smith 603462 603462 Strang, William, of Reading, Berks, smith 1
5152979 2402009 2402009 defendant Farley Robert draper 603462 603462 Farley, Robert, of Reading, Berks, draper 0
5156459 2403043 2403043 defendant Smyth William dyer 603462 603462 Smyth, William, of Reading, Berks, dyer 0

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