names

294 rows where place_id = 586360

✎ 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
3588522 1864054 1864054 defendant Egyll Robert tailor 586360 586360 Egyll, Robert, of Chelmesford, Essex, tailor 3
3595136 1866110 1866110 defendant Monde William chapman 586360 586360 Monde, William, of Chelmesford, Essex, chapman 1
3602417 1868415 1868415 defendant Gamston John gent 586360 586360 Gamston, John, of Chelmesford, Essex, gent 0
3604375 1869036 1869036 defendant Bygmore John innholder 586360 586360 Bygmore, John, of Chelmesford, Essex, innholder 1
3615317 1872434 1872434 defendant Horwode John innholder 586360 586360 Horwode, John, of Chelmesford, Essex, innholder 4
3615321 1872436 1872436 defendant Horwode John innholder 586360 586360 Horwode, John, of Chelmesford, Essex, innholder 0
3617183 1872998 1872998 defendant Mountney John gent 586360 586360 Mountney, John, of Chelmesford, Essex, gent 3
3619006 1873554 1873554 defendant Mounteney John gent 586360 586360 Mounteney, John, of Chelmesford, Essex, gent 0
3634751 1905666 1905666 plaintiff Mounteney John gent 586360 586360 Mounteney, John, of Chelmesford, Essex, gent 0
3644666 1908739 1908739 defendant Cornysshe John yeoman 586360 586360 Cornysshe, John, of Chelmesford, Essex, yeoman 0
3645032 1908854 1908854 defendant Brownyng William haberdasher or barber 586360 586360 Brownyng, William, of Chelmesford, Essex, haberdasher or barber 0
3669845 1916513 1916513 defendant Veryng John yeoman 586360 586360 Veryng, John, of Chelmesford, Essex, yeoman 1
3676481 1918688 1918688 defendant Curteys Thomas tailor 586360 586360 Curteys, Thomas, of Chelmesford, Essex, tailor 4
3682200 1920538 1920538 defendant Clerk William smith 586360 586360 Clerk, William, of Chelmesford, Essex, smith 0
3694080 1924353 1924353 defendant Wilmot William chapman 586360 586360 Wilmot, William, of Chelmesford, Essex, chapman 1
3694917 1924619 1924619 defendant Coke Nicholas clothmaker 586360 586360 Coke, Nicholas, of Chelmesford, Essex, clothmaker 0
3705733 1928075 1928075 defendant Rawlyns William yeoman 586360 586360 Rawlyns, William, of Chelmesford, Essex, yeoman 1
3709852 1929396 1929396 defendant Notte William yeoman 586360 586360 Notte, William, of Chelmesford, Essex, yeoman 1
3712667 1930276 1930276 defendant Harvy Thomas husbandman 586360 586360 Harvy, Thomas, of Chelmesford, Essex, husbandman 4
3731975 1936233 1936233 defendant Aylnoth William gent 586360 586360 Aylnoth, William, of Chelmesford, Essex, gent 0
3759349 1944913 1944913 defendant Bentley Nicholas chapman 586360 586360 Bentley, Nicholas, of Chelmesford, Essex, chapman 3
3765893 1946996 1946996 defendant Balle Henry dyer 586360 586360 Balle, Henry, of Chelmesford, Essex, dyer 2
3768786 1947887 1947887 defendant May John chapman 586360 586360 May, John, of Chelmesford, Essex, chapman 4
3777173 1950613 1950613 defendant Bowdon William chapman 586360 586360 Bowdon, William, of Chelmesford, Essex, chapman 2
3777178 1950614 1950614 defendant Turnour John, senior cpaman 586360 586360 Turnour, John, senior, of Chelmesford, Essex, cpaman 2
3800164 1957972 1957972 defendant Bowdon William haberdasher 586360 586360 Bowdon, William, of Chelmesford, Essex, haberdasher 3
3800365 1958031 1958031 defendant Balle Henry dyer 586360 586360 Balle, Henry, of Chelmesford, Essex, dyer 2
3803715 1959076 1959076 defendant Harres Thomas miller 586360 586360 Harres, Thomas, of Chelmesford, Essex, miller 3
3828627 1966832 1966832 defendant Dowve John yeoman 586360 586360 Dowve, John, of Chelmesford, Essex, yeoman 2
3833045 1968258 1968258 defendant Bowden William merchant 586360 586360 Bowden, William, of Chelmesford, Essex, merchant 0
3833525 1968418 1968418 defendant Scot Geoffrey innholder 586360 586360 Scot, Geoffrey, of Chelmesford, Essex, innholder 0
3835289 1968978 1968978 defendant Bowden William   586360 586360 Bowden, William, of Chelmesford, Essex, "raffeman" 0
3855095 1975225 1975225 defendant Bowden William haberdasher 586360 586360 Bowden, William, of Chelmesford, Essex, haberdasher 0
3864620 1978363 1978363 defendant Scott Geoffrey innholder 586360 586360 Scott, Geoffrey, of Chelmesford, Essex, innholder 2
3868697 1979773 1979773 defendant Byge Thomas innholder 586360 586360 Byge, Thomas, of Chelmesford, Essex, innholder 0
3886860 1985868 1985868 defendant Grene John innkeeper 586360 586360 Grene, John, of Chelmesford, Essex, innkeeper 2
3889147 1986605 1986605 defendant Warren Thomas yeoman 586360 586360 Warren, Thomas, of Chelmesford, Essex, yeoman 0
3921678 1997593 1997593 defendant Done John chapman 586360 586360 Done, John, of Chelmesford, Essex, chapman 2
3927562 1999560 1999560 defendant Studeley Richard yeoman 586360 586360 Studeley, Richard, of Chelmesford, Essex, yeoman 3
3936494 2002530 2002530 defendant Creke Thomas clerk 586360 586360 Creke, Thomas, of Chelmesford, Essex, clerk 0
3951936 2007740 2007740 defendant West John yeoman 586360 586360 West, John, of Chelmesford, Essex, yeoman 1
3953740 2008382 2008382 defendant Pyers Robert innholder 586360 586360 Pyers, Robert, of Chelmesford, Essex, innholder 0
3955182 2008877 2008877 plaintiff Maldon Richard haberdasher 586360 586360 Maldon, Richard, of Chelmesford, Essex, haberdasher 0
3973642 2015352 2015352 defendant Blomffylde Miles   586360 586360 Blomffylde, Miles, of Chelmesford, Essex, physician 2
3973646 2015353 2015353 defendant Blomefyld Miles   586360 586360 Blomefyld, Miles, of Chelmesford, Essex, physician 2
3978145 2016935 2016935 plaintiff Martendale George grocer 586360 586360 Martendale, George, of Chelmesford, Essex, grocer 0
3994529 2022790 2022790 plaintiff Cole William gent 586360 586360 Cole, William, of Chelmesford, Essex, gent 0
4021583 2032446 2032446 defendant Baker alias Wylk Walter beer brewer 586360 586360 Baker alias Wylk, Walter, of Chelmesford, Essex, beer brewer 2
4025033 2033614 2033614 defendant Wallynger Thomas gent 586360 586360 Wallynger, Thomas, of Chelmesford, Essex, gent 0
4027695 2034553 2034553 defendant Strowde William gent 586360 586360 Strowde, William, of Chelmesford, Essex, gent 0
4054957 2044167 2044167 defendant Mowncke John merer 586360 586360 Mowncke, John, of Chelmesford, Essex, merer 0
4062886 2047026 2047026 defendant West John yeoman 586360 586360 (West, John, of Chelmesford, Essex, yeoman 1
4066878 2048450 2048450 defendant Howlett Thomas clerk 586360 586360 Howlett, Thomas, of Chelmesford, Essex, clerk 0
4089565 2056556 2056556 defendant Hyll or Hylles William   586360 586360 Hyll or Hylles, William, of Chelmesford, Essex, woollen draper 0
4114803 2065582 2065582 defendant Dunne Richard gent 586360 586360 Dunne, Richard, of Chelmesford, Essex, gent 0
4122118 2068216 2068216 defendant Asser Richard yeoman 586360 586360 Asser, Richard, of Chelmesford, Essex, yeoman 0
4156365 2080298 2080298 defendant Harryson Ralph brewer 586360 586360 Harryson, Ralph, of Chelmesford, Essex, brewer 0
4190654 2092294 2092294 defendant Wood Robert mercer 586360 586360 Wood, Robert, of Chelmesford, Essex, mercer 2
4191365 2092546 2092546 defendant Popleton Thomas mercer 586360 586360 Popleton, Thomas, of Chelmesford, Essex, mercer 0
4202907 2096562 2096562 defendant Howlbarde Thomas mercer 586360 586360 Howlbarde, Thomas, of Chelmesford, Essex, mercer 1
4207665 2098238 2098238 defendant Graye Thomas chapman 586360 586360 Graye, Thomas, of Chelmesford, Essex, chapman 2
4210569 2099252 2099252 defendant Andrewe Henry butcher 586360 586360 Andrewe, Henry, of Chelmesford, Essex, butcher 0
4230689 2106229 2106229 defendant Burghley George clerk 586360 586360 Burghley, George, of Chelmesford, Essex, clerk 0
4232688 2106938 2106938 defendant Lawrence William gent 586360 586360 Lawrence, William, of Chelmesford, Essex, gent 0
4236081 2108189 2108189 defendant Browne John chapman 586360 586360 Browne, John, of Chelmesford, Essex, chapman 0
4244556 2111161 2111161 defendant Luddington Richard gent 586360 586360 Luddington, Richard, of Chelmesford, Essex, gent 0
4272473 2120368 2120368 defendant Tatem Thomas yeoman 586360 586360 Tatem, Thomas, of Chelmesford, Essex, yeoman 0
4273079 2120557 2120557 defendant May Thomas chapman 586360 586360 May, Thomas, of Chelmesford, Essex, chapman 2
4273400 2120663 2120663 defendant Burrells Richard glover 586360 586360 Burrells, Richard, of Chelmesford, Essex, glover 2
4292960 2127544 2127544 defendant Kynge John mercer 586360 586360 Kynge, John, of Chelmesford, Essex, mercer 0
4301635 2130689 2130689 defendant Wood William gent 586360 586360 Wood, William, of Chelmesford, Essex, gent 0
4316469 2135877 2135877 defendant Newton Thomas clerk 586360 586360 Newton, Thomas, of Chelmesford, Essex, clerk 3
4321525 2137619 2137619 defendant Kynge John chapman 586360 586360 Kynge, John, of Chelmesford, Essex, chapman 1
4329443 2140155 2140155 defendant Browne Richard scrivener 586360 586360 Browne, Richard, of Chelmesford, Essex, scrivener 0
4335293 2142076 2142076 defendant Newton Richard chapman 586360 586360 Newton, Richard, of Chelmesford, Essex, chapman 1
4341689 2144372 2144372 defendant Hytchyns Stephen yeoman 586360 586360 Hytchyns, Stephen, of Chelmesford, Essex, yeoman 2
4346740 2146113 2146113 defendant Wood William gent 586360 586360 Wood, William, of Chelmesford, Essex, gent 0
4348083 2146577 2146577 defendant Watson Thomas   586360 586360 Watson, Thomas, of Chelmesford, Essex, apothecary 0
4354737 2148882 2148882 defendant Stilleman alias Camper Edward chapman 586360 586360 Stilleman alias Camper, Edward, of Chelmesford, Essex, chapman 0
4355508 2149148 2149148 defendant Maulden John haberdasher 586360 586360 Maulden, John, of Chelmesford, Essex, haberdasher 0
4355974 2149307 2149307 defendant Wood Thomas   586360 586360 Wood, Thomas, of Chelmesford, Essex, "burer" 0
4371950 2155030 2155030 defendant Watson Thomas   586360 586360 Watson, Thomas, of Chelmesford, Essex, apothecary 0
4379591 2157792 2157792 defendant Mauldon John haberdasher 586360 586360 Mauldon, John, of Chelmesford, Essex, haberdasher 0
4380076 2157978 2157978 defendant Wood Thomas brewer 586360 586360 Wood, Thomas, of Chelmesford, Essex, brewer 0
4394197 2162660 2162660 defendant Hall William butcher 586360 586360 Hall, William, of Chelmesford, Essex, butcher 2
4476089 2193193 2193193 defendant Isbrond Lawrence   586360 586360 Isbrond, Lawrence, of Chelmesford, Essex 1
4580456 2225373 2225373 defendant Isbrond Lawrence   586360 586360 Isbrond, Lawrence, of Chelmesford, Essex 0
4589631 2228125 2228125 defendant Isbrond Lawrence   586360 586360 Isbrond, Lawrence, of Chelmesford, Essex 0
4664671 2250428 2250428 defendant Chelmesford Robert gent 586360 586360 Chelmesford, Robert, of Chelmesford, Essex, gent 0
4664673 2250429 2250429 defendant Chelmesford Robert gent 586360 586360 Chelmesford, Robert, of Chelmesford, Essex, gent 0
4698095 2264891 2264891 defendant Soterle Richard husbandman 586360 586360 Soterle, Richard, of Chelmesford, Essex, husbandman 0
4709608 2268366 2268366 defendant Tufte John hostler 586360 586360 Tufte, John, of Chelmesford, Essex, hostler 0
4725123 2273154 2273154 defendant Savage William husbandman 586360 586360 Savage, William, of Chelmesford, Essex, husbandman 1
4738798 2277224 2277224 defendant Skynner Thomas skinner 586360 586360 Skynner, Thomas, of Chelmesford, Essex, skinner 0
4746483 2279464 2279464 defendant Bryght William Master & parson of St Mary's church 586360 586360 Bryght, William, of Chelmesford, Essex, Master & parson of St Mary's church 0
4748355 2280026 2280026 defendant Cobb e jOhn bedmaker 586360 586360 Cobb,e jOhn, of Chelmesford, Essex, bedmaker 1
4751269 2280849 2280849 defendant Chelmesford Robert gent 586360 586360 Chelmesford, Robert, of Chelmesford, Essex, gent 0
4759181 2283214 2283214 defendant Chelmesford Robert gent 586360 586360 Chelmesford, Robert, of Chelmesford, Essex, gent 3
4760837 2283728 2283728 defendant Marche William   586360 586360 Marche, William, of Chelmesford, Essex, pedlar 0
4763885 2284697 2284697 defendant Warrewyk John chapman 586360 586360 Warrewyk, John, of Chelmesford, Essex, chapman 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);