names

167 rows where place_id = 588180

✎ 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
3593632 1865642 1865642 defendant Johnson Ralph innholder 588180 588180 Johnson, Ralph, of Aylesbury, Bucks, innholder 1
3593635 1865643 1865643 defendant Johnson Ralph innholder 588180 588180 Johnson, Ralph, of Aylesbury, Bucks, innholder 1
3598643 1867199 1867199 defendant Blekenhale Edward chapman 588180 588180 Blekenhale, Edward, of Aylesbury, Bucks, chapman 0
3604145 1868962 1868962 defendant Jones Richard yeoman 588180 588180 (Jones, Richard, of Aylesbury, Bucks, yeoman 2
3615173 1872391 1872391 defendant Kyttewell Thomas yeoman 588180 588180 Kyttewell, Thomas, of Aylesbury, Bucks, yeoman 0
3626992 1903301 1903301 defendant Bevendon Richard shoemaker 588180 588180 Bevendon, Richard, of Aylesbury, Bucks, shoemaker 0
3642248 1908023 1908023 defendant Polle John yeoman 588180 588180 Polle, John, of Aylesbury, Bucks, yeoman 3
3657265 1912532 1912532 defendant Jones Richard yeoman 588180 588180 Jones, Richard, of Aylesbury, Bucks, yeoman 1
3688264 1922476 1922476 defendant Cokys Roger buthcer 588180 588180 Cokys, Roger, of Aylesbury, Bucks, buthcer 3
3751923 1942517 1942517 defendant Josselyn John gent 588180 588180 Josselyn, John, of Aylesbury, Bucks, gent 0
3756563 1944032 1944032 defendant Traves John yeoman 588180 588180 Traves, John, of Aylesbury, Bucks, yeoman 0
3763756 1946310 1946310 defendant Traves John alderman of Oxford 588180 588180 Traves, John, of Aylesbury, Bucks, innholder, alderman of Oxford 0
3765312 1946814 1946814 defendant Dollys Tristram innholder 588180 588180 Dollys, Tristram, of Aylesbury, Bucks, innholder 2
3770779 1948548 1948548 defendant Fayreclyff Lawrence gent 588180 588180 Fayreclyff, Lawrence, of Aylesbury, Bucks, gent 0
3785508 1953256 1953256 defendant Appryce John mercer 588180 588180 Appryce, John, of Aylesbury, Bucks, mercer 2
3811825 1961601 1961601 defendant Bonyngton Richard shoemaker 588180 588180 Bonyngton, Richard, of Aylesbury, Bucks, shoemaker 0
3837577 1969660 1969660 defendant Stretely Thomas gent 588180 588180 Stretely, Thomas, of Aylesbury, Bucks, gent 0
3844882 1971943 1971943 defendant Hoskyns William tailor 588180 588180 Hoskyns, William, of Aylesbury, Bucks, tailor 2
3868139 1979580 1979580 defendant Colyngburn Richard gent 588180 588180 Colyngburn, Richard, of Aylesbury, Bucks, gent 0
3886746 1985825 1985825 defendant Bovynden Richard shoemaker 588180 588180 Bovynden, Richard, of Aylesbury, Bucks, shoemaker 1
3913401 1994818 1994818 defendant Walwyn John gent 588180 588180 Walwyn, John, of Aylesbury, Bucks, gent 0
3915201 1995443 1995443 defendant Walwyn John gent 588180 588180 Walwyn, John, of Aylesbury, Bucks, gent 0
3937178 2002766 2002766 defendant Walken John gent 588180 588180 Walken, John, of Aylesbury, Bucks, gent 0
3937180 2002767 2002767 defendant Walwen John gent 588180 588180 Walwen, John, of Aylesbury, Bucks, gent 0
3956811 2009452 2009452 defendant Jones alias Capper John chapman 588180 588180 Jones alias Capper, John, of Aylesbury, Bucks, chapman 2
3957004 2009513 2009513 defendant Dornynge Robert clerk 588180 588180 Dornynge, Robert, of Aylesbury, Bucks, or of Omberley, clerk 0
3961916 2011263 2011263 defendant Bank John fishmonger 588180 588180 Bank, John, of Aylesbury, Bucks, fishmonger 0
3983035 2018711 2018711 defendant Bryan Robert tailor 588180 588180 Bryan, Robert, of Aylesbury, Bucks, tailor 0
3983042 2018713 2018713 defendant Bryan Robert tailor 588180 588180 Bryan, Robert, of Aylesbury, Bucks, tailor 0
3992427 2022058 2022058 defendant Rawlyns Richard chapmman 588180 588180 Rawlyns, Richard, of Aylesbury, Bucks, chapmman 0
3996485 2023503 2023503 defendant Pykes Peter mercer 588180 588180 Pykes, Peter, of Aylesbury, Bucks, mercer 0
4011098 2028741 2028741 defendant Chapman Thomas chapman 588180 588180 Chapman, Thomas, of Aylesbury, Bucks, chapman 3
4012221 2029094 2029094 defendant Bank John innholder 588180 588180 Bank, John, of Aylesbury, Bucks, innholder 0
4019926 2031857 2031857 defendant Banck John innholder 588180 588180 Banck, John, of Aylesbury, Bucks, innholder 6
4044014 2040311 2040311 defendant Bludde John shoemaker 588180 588180 Bludde, John, of Aylesbury, Bucks, shoemaker 0
4075827 2051653 2051653 defendant Bryan Robert draper 588180 588180 Bryan, Robert, of Aylesbury, Bucks, draper 0
4101107 2060708 2060708 defendant Haydon Ralph gent 588180 588180 Haydon, Ralph, of Aylesbury, Bucks, gent 3
4127523 2070136 2070136 defendant Hatley Richard gent 588180 588180 Hatley, Richard, of Aylesbury, Bucks, gent 0
4201793 2096171 2096171 defendant Packington Thomas gent 588180 588180 Packington, Thomas, of Aylesbury, Bucks, gent 10
4235118 2107840 2107840 defendant Packington Thomas esq 588180 588180 Packington, Thomas, of Aylesbury, Bucks, esq 0
4237494 2108704 2108704 defendant Worrall John yeoman 588180 588180 Worrall, John, of Aylesbury, Bucks, yeoman 3
4254200 2114402 2114402 defendant Packington Thomas esq 588180 588180 Packington, Thomas, of Aylesbury, Bucks, esq 0
4293253 2127649 2127649 defendant Pewsie Bartholomew clerk 588180 588180 Pewsie, Bartholomew, of Aylesbury, Bucks, clerk 3
4301940 2130803 2130803 defendant Rye George glasier 588180 588180 Rye, George, of Aylesbury, Bucks, glasier 0
4306524 2132421 2132421 defendant Packington Thomas esq 588180 588180 Packington, Thomas, of Aylesbury, Bucks, esq 0
4317399 2136199 2136199 defendant Wyett John gent 588180 588180 Wyett, John, of Aylesbury, Bucks, gent 0
4474744 2192767 2192767 defendant Symond Thomas   588180 588180 Symond, Thomas, of Aylesbury, Bucks 0
4496460 2199569 2199569 defendant Spiner William   588180 588180 Spiner, William, of Aylesbury, Bucks 0
4516932 2205701 2205701 defendant Spicer William   588180 588180 Spicer, William, of Aylesbury, Bucks 0
4516936 2205702 2205702 defendant Spicer William   588180 588180 Spicer, William, of Aylesbury, Bucks 0
4607698 2233517 2233517 defendant Talbot Nicholas esq 588180 588180 Talbot, Nicholas, of Aylesbury, Bucks, esq 0
4636934 2242363 2242363 defendant Talbot Nicholas esq 588180 588180 Talbot, Nicholas, of Aylesbury, Bucks, esq 1
4636941 2242364 2242364 defendant Talbot Nicholas esq 588180 588180 Talbot, Nicholas, of Aylesbury, Bucks, esq 1
4661737 2249513 2249513 defendant Abraham John chapman 588180 588180 Abraham, John, of Aylesbury, Bucks, chapman 1
4661741 2249514 2249514 defendant Abraham John chapman 588180 588180 Abraham, John, of Aylesbury, Bucks, chapman 1
4674937 2257772 2257772 defendant Abraham John chapman 588180 588180 Abraham, John, of Aylesbury, Bucks, chapman 0
4686216 2261286 2261286 defendant Haman John butcher 588180 588180 Haman, John, of Aylesbury, bucks, butcher 2
4712867 2269335 2269335 defendant Overton Richard chapman 588180 588180 Overton, Richard, of Aylesbury, Bucks, chapman 2
4716394 2270447 2270447 defendant Derham Edmund writer 588180 588180 Derham, Edmund, of Aylesbury, Bucks, writer 0
4730584 2274764 2274764 defendant Sheest Walter yeoman 588180 588180 Sheest, Walter, of Aylesbury, Bucks, yeoman 1
4751706 2280986 2280986 defendant Dranfeld John, senior butcher 588180 588180 Dranfeld, John, senior, of Aylesbury, Bucks, butcher 4
4753353 2281425 2281425 defendant Mayws John chandler 588180 588180 Mayws, John, of Aylesbury, Bucks, chandler 1
4765854 2285317 2285317 defendant Bomsted Robert chapman 588180 588180 Bomsted, Robert, of Aylesbury, Bucks, chapman 0
4768012 2285963 2285963 defendant Tannere Thomas husbandman 588180 588180 Tannere, Thomas, of Aylesbury, Bucks, husbandman 0
4768834 2286231 2286231 defendant Rogger Thomas clerk 588180 588180 Rogger, Thomas, of Aylesbury, Bucks, clerk 0
4772436 2287346 2287346 defendant Dranfeld John, sen butcher 588180 588180 Dranfeld, John, sen, of Aylesbury, Bucks, butcher 0
4822972 2303268 2303268 defendant Dranfeld John butcher 588180 588180 Dranfeld, John, of Aylesbury, Bucks, butcher 2
4825992 2304163 2304163 defendant Goolde John, junior baker 588180 588180 Goolde, John, junior, of Aylesbury, Bucks, baker 0
4826025 2304177 2304177 defendant Twychene John smith 588180 588180 Twychene, John, of Aylesbury, Bucks, smith 0
4828686 2305014 2305014 defendant Mante John chapman 588180 588180 Mante, John, of Aylesbury, Bucks, chapman 2
4828690 2305015 2305015 defendant Mante John chapman 588180 588180 Mante, John, of Aylesbury, Bucks, chapman 2
4829481 2305262 2305262 defendant Mawe John chapman 588180 588180 Mawe, John, of Aylesbury, Bucks, chapman 1
4835143 2306990 2306990 defendant Smarte Richard chapman 588180 588180 Smarte, Richard, of Aylesbury, Bucks, chapman 3
4860892 2314764 2314764 defendant Smert Richard mercer 588180 588180 Smert, Richard, of Aylesbury, Bucks, mercer 0
4872933 2318489 2318489 defendant Payn John skinner 588180 588180 Payn, John, of Aylesbury, Bucks, skinner 0
4883471 2321748 2321748 defendant Mans or Maus John chapman 588180 588180 Mans or Maus, John, of Aylesbury, Bucks, chapman 1
4883720 2321819 2321819 defendant Thomas Richard butcher 588180 588180 Thomas, Richard, of Aylesbury, Bucks, butcher 0
4895266 2325179 2325179 defendant Smert Richard chapman 588180 588180 Smert, Richard, of Aylesbury, Bucks, chapman 0
4902596 2327431 2327431 defendant Smert Richard chapman 588180 588180 Smert, Richard, of Aylesbury, Bucks, chapman 0
4904580 2328045 2328045 defendant Howeman William chapman 588180 588180 Howeman, William, of Aylesbury, Bucks, chapman 0
4911400 2330067 2330067 defendant Clerk William yeoman 588180 588180 Clerk, William, of aylesbury, Bucks, yeoman 1
4918485 2332300 2332300 defendant Godeman John yeoman 588180 588180 Godeman, John, of Aylesbury, Bucks, yeoman 0
4931616 2336275 2336275 defendant Goodman John husbandman 588180 588180 Goodman, John, of Aylesbury, Bucks, husbandman 1
4952824 2342802 2342802 defendant Clerk William yeoman 588180 588180 Clerk, William, of Aylesbury, Bucks, yeoman 1
4955154 2343499 2343499 defendant Hardy Henry chapman 588180 588180 Hardy, Henry, of Aylesbury, Bucks, chapman 0
4986450 2352875 2352875 defendant Exham John glasier 588180 588180 Exham, John, of Aylesbury, Bucks, glasier 1
4989412 2353769 2353769 defendant Love or Lone John husbandman 588180 588180 Love or Lone, John, of Aylesbury, Bucks, husbandman 0
4989414 2353770 2353770 defendant Lone or Love John husbandman 588180 588180 Lone or Love, John, of Aylesbury, Bucks, husbandman 0
4994711 2355274 2355274 defendant Clerk John husbandman 588180 588180 Clerk, John, of Aylesbury, Bucks, husbandman 1
4994715 2355275 2355275 defendant Clerk John husbandman 588180 588180 Clerk, John, of Aylesbury, Bucks, husbandman 1
5002290 2357575 2357575 defendant Mawe John chapman 588180 588180 Mawe, John, of Aylesbury, Bucks, chapman 1
5002576 2357666 2357666 defendant Mawes John chapman 588180 588180 Mawes, John, of Aylesbury, Bucks, chapman 2
5009249 2359589 2359589 defendant Halton Thomas   588180 588180 Halton, Thomas, of Aylesbury, Bucks, shoe maker 0
5009251 2359590 2359590 defendant Halton Thomas shoemaker 588180 588180 Halton,Thomas, of Aylesbury, Bucks, shoemaker 0
5070764 2377756 2377756 defendant Clerk alias Chapman John chapman 588180 588180 Clerk alias Chapman, John, of Aylesbury, Bucks, chapman 0
5072426 2378242 2378242 defendant Cawode John mercer 588180 588180 Cawode, John, of Aylesbury, Bucks, mercer 2
5074618 2378911 2378911 defendant Spereman William merchant 588180 588180 Spereman, William, of Aylesbury, Bucks, merchant 0
5136021 2397045 2397045 defendant Crowlond Walter butcher 588180 588180 Crowlond, Walter, of Aylesbury, Bucks, butcher 0
5136023 2397046 2397046 defendant Jeffes John carpenter 588180 588180 Jeffes, John, of Aylesbury, Bucks, carpenter 0
5155332 2402710 2402710 defendant Goodman John gent 588180 588180 Goodman, John, of Aylesbury, Bucks, gent 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);