names

127 rows where place_id = 591216

✎ 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
3603735 1868839 1868839 defendant Hunter John yeoman 591216 591216 Hunter, John, of Westerham, yeoman 0
3633300 1905231 1905231 defendant Lynton John yeoman 591216 591216 Lynton, John, of Westerham, yeoman 0
3662499 1914186 1914186 defendant Skelton John tanner 591216 591216 Skelton, John, of Westerham, tanner 1
3673386 1917696 1917696 defendant Brewode Robert husbandman 591216 591216 Brewode, Robert, of Westerham, husbandman 0
3674384 1918034 1918034 defendant Williamson John tanner 591216 591216 Williamson, John, of Westerham, tanner 1
3693335 1924129 1924129 plaintiff Lystney Ralph butterman 591216 591216 Lystney, Ralph, of Westerham, butterman 0
3693336 1924129 1924129 defendant Jakys Thomas yeoman 591216 591216 Jakys, Thomas, of Westerham, yeoman 0
3693337 1924129 1924129 defendant Dekyn Richard yeoman 591216 591216 Dekyn, Richard, of Westerham, yeoman 1
3693338 1924129 1924129 defendant Potter John baker 591216 591216 Potter, John, of Westerham, baker 2
3708166 1928854 1928854 defendant Herd Thomas butterman 591216 591216 Herd, Thomas, of Westerham, butterman 0
3708167 1928854 1928854 defendant Michell Simon   591216 591216 Michell, Simon, of Westerham, pin maker 1
3734438 1937015 1937015 defendant Lambe John yeoman 591216 591216 Lambe, John, of Westerham, yeoman 2
3739135 1938448 1938448 defendant Father John husbandman 591216 591216 Father, John, of Westerham, husbandman 0
3739743 1938642 1938642 defendant Jakes Thomas yeoman 591216 591216 Jakes, Thomas, of Westerham, yeoman 0
3744973 1940334 1940334 defendant Cryppys John yeoman 591216 591216 Cryppys, John, of Westerham, yeoman 0
3744974 1940334 1940334 defendant Harman John weaver 591216 591216 Harman, John, of Westerham, weaver 1
3761466 1945598 1945598 defendant Berde Thomas butterman 591216 591216 Berde, Thomas, of Westerham, butterman 4
3820383 1964255 1964255 plaintiff Potter John (legal representative) 591216 591216 Potter, John, of Westerham, gent, executors of 0
3890301 1987003 1987003 defendant Weston William yeoman 591216 591216 Weston, William, of Westerham, yeoman 4
3890308 1987004 1987004 defendant Weston William yeoman 591216 591216 Weston, William, of Westerham, yeoman 4
3891575 1987445 1987445 defendant Weston William yeoman 591216 591216 Weston, William, of Westerham, yeoman 4
3891582 1987446 1987446 defendant Weston William yeoman 591216 591216 Weston, William, of Westerham, yeoman 4
3891589 1987447 1987447 defendant Weston William yeoman 591216 591216 Weston, William, of Westerham, yeoman 4
3948717 2006618 2006618 defendant Stydolff William husbandman 591216 591216 Stydolff, William, of Westerham, husbandman 0
3957424 2009661 2009661 defendant Tydeman John   591216 591216 Tydeman, John, of Westerham, ploughwright 0
3957425 2009661 2009661 defendant Peake John laborer 591216 591216 Peake, John, of Westerham, laborer 1
4033542 2036649 2036649 defendant Holmeden William yeoman 591216 591216 Holmeden, William, of Westerham, yeoman 0
4033543 2036649 2036649 defendant Hurtlyng Richard   591216 591216 Hurtlyng, Richard, of Westerham, tile maker 1
4033544 2036649 2036649 defendant Sherman John tiler 591216 591216 Sherman, John, of Westerham, tiler 2
4033545 2036649 2036649 defendant Holmeden Richard mercer 591216 591216 Holmeden, Richard, of Westerham, mercer 3
4103450 2061519 2061519 defendant Myddilton William gent 591216 591216 Myddilton, William, of Westerham, gent 0
4228964 2105612 2105612 defendant Man Robert butcher 591216 591216 Man, Robert, of Westerham, butcher 2
4368964 2153961 2153961 defendant Coker William   591216 591216 Coker, William, of Westerham, husbandman, administrators of 0
4394450 2162741 2162741 defendant Burstowe Robert yeoman 591216 591216 Burstowe, Robert, of Westerham, yeoman 1
4394451 2162741 2162741 defendant Hayward Michael yeoman 591216 591216 Hayward, Michael, of Westerham, yeoman 2
4396621 2163435 2163435 defendant Stephen William husbandman 591216 591216 Stephen, William, of Westerham, husbandman 1
4438893 2181459 2181459 defendant Casteleyn Lawrence   591216 591216 Casteleyn, Lawrence, of Westerham 0
4451836 2185552 2185552 defendant Cordere William   591216 591216 Cordere, William, of Westerham 0
4478073 2193813 2193813 defendant Dorant Richard   591216 591216 Dorant, Richard, of Westerham 0
4485219 2196081 2196081 plaintiff Pulter William   591216 591216 Pulter, William, of Westerham 0
4485220 2196081 2196081 defendant Casynghest Richard   591216 591216 Casynghest, Richard, of Westerham 0
4523398 2207640 2207640 defendant Doraunt Richard   591216 591216 Doraunt, Richard, of Westerham 0
4523404 2207641 2207641 defendant Gardener Simon   591216 591216 Gardener, Simon, of Westerham 2
4542774 2213627 2213627 defendant Gardyner John butcher 591216 591216 Gardyner, John, of Westerham, butcher 0
4543895 2213992 2213992 plaintiff Baker Edmund   591216 591216 Baker, Edmund, of Westerham 0
4550150 2215988 2215988 defendant Clerk John   591216 591216 Clerk, John, of Westerham 0
4566256 2221009 2221009 plaintiff Stake John   591216 591216 Stake, John, of Westerham 0
4572607 2222969 2222969 plaintiff atte Lynde William   591216 591216 atte Lynde, William, of Westerham 0
4629838 2240255 2240255 defendant Sprygurnell John   591216 591216 Sprygurnell, John, of Westerham 0
4667018 2255416 2255416 defendant Stonehale Ralph husbandman 591216 591216 Stonehale, Ralph, of Westerham, husbandman 0
4697213 2264608 2264608 defendant Northwode John yeoman 591216 591216 Northwode, John, of Westerham, yeoman 0
4724810 2273056 2273056 defendant Kenefeld Robert butcher 591216 591216 Kenefeld, Robert, of Westerham, butcher 0
4741482 2278005 2278005 defendant Donmowe John laborer 591216 591216 Donmowe, John, of Westerham, laborer 1
4745177 2279094 2279094 defendant Herman Richard collier 591216 591216 Herman, Richard, of Westerham, collier 0
4768073 2285982 2285982 defendant Kenfeld Robert butcher 591216 591216 Kenfeld, Robert, of Westerham, butcher 0
4768074 2285982 2285982 defendant Lynder William yeoman 591216 591216 Lynder, William, of Westerham, yeoman 1
4781256 2290151 2290151 defendant Bakere William husbandman 591216 591216 Bakere, William, of Westerham, husbandman 0
4781257 2290151 2290151 defendant Gerlond William husbandman 591216 591216 Gerlond, William, of Westerham, husbandman 1
4786662 2291882 2291882 defendant Helmeden Lawrence collier 591216 591216 Helmeden, Lawrence, of Westerham, collier 0
4833242 2306407 2306407 defendant Jay Richard tanner 591216 591216 Jay, Richard, of Westerham, tanner 0
4833243 2306407 2306407 defendant Stokkere John   591216 591216 Stokkere, John, of Westerham, glove maker 1
4878101 2320102 2320102 defendant atte Welle Thomas laborer 591216 591216 atte Welle, Thomas, of Westerham, laborer 0
4927371 2334994 2334994 defendant Smyth Thomas   591216 591216 Smyth, Thomas, of Westerham, vicar 0
4927886 2335158 2335158 plaintiff Seman John   591216 591216 Seman, John, of Westerham 0
4997060 2355973 2355973 plaintiff Helwys John   591216 591216 Helwys, John, of Westerham 0
4997062 2355974 2355974 plaintiff Helwys John   591216 591216 Helwys, John, of Westerham 0
4997064 2355975 2355975 plaintiff Helwys John   591216 591216 Helwys, John, of Westerham 0
5001556 2357348 2357348 defendant Gerlond John husbandman 591216 591216 Gerlond, John, of Westerham, husbandman 4
5005642 2358548 2358548 defendant Bakere William husbandman 591216 591216 Bakere, William, of Westerham, husbandman 3
5005764 2358582 2358582 defendant Helwys John   591216 591216 Helwys, John, of Westerham 0
5005766 2358583 2358583 defendant Howys John tailor 591216 591216 Howys, John, of Westerham, tailor 0
5026037 2364509 2364509 defendant Stacy Thomas tranner 591216 591216 Stacy, Thomas, of Westerham, tranner 0
5026038 2364509 2364509 defendant atte Cesho Walter husbandman 591216 591216 atte Cesho, Walter, of Westerham, husbandman 1
5026039 2364509 2364509 defendant atte Welle James husbandman 591216 591216 atte Welle, James, of Westerham, husbandman 2
5026040 2364509 2364509 defendant Smyth Richard husbandman 591216 591216 Smyth, Richard, of Westerham, husbandman 3
5026041 2364509 2364509 defendant Marchaunt John husbandman 591216 591216 Marchaunt, John, of Westerham, husbandman 4
5026042 2364509 2364509 defendant Rundell John husbandman 591216 591216 Rundell, John, of Westerham, husbandman 5
5038859 2368265 2368265 defendant Lambe John husbandman 591216 591216 Lambe, John, of Westerham, husbandman 0
5038860 2368265 2368265 defendant Machon John clerk 591216 591216 with Machon, John, of Westerham, clerk 1
5041845 2369159 2369159 defendant Lambe John husbandman 591216 591216 Lambe, John, of Westerham, husbandman 0
5041846 2369159 2369159 defendant Machon John clerk 591216 591216 Machon, John, of Westerham, clerk 1
5043094 2369552 2369552 defendant Machon John clerk 591216 591216 Machon, John, of Westerham, clerk 0
5043095 2369552 2369552 defendant Lambe John husbandman 591216 591216 Lambe, John, of Westerham, husbandman 1
5049353 2371439 2371439 defendant Whyte John miller 591216 591216 Whyte, John, of Westerham, miller 2
5133586 2396315 2396315 defendant Chanewe James gent 591216 591216 Chanewe, James, of Westerham, gent 1
5138766 2397835 2397835 defendant Fynche John draper 591216 591216 Fynche, John, of Westerham, draper 2
5152972 2402007 2402007 defendant Howeton Thomas clerk 591216 591216 Howeton, Thomas, of Westerham, clerk 1
5153397 2402147 2402147 defendant Chanewe James gent 591216 591216 Chanewe, James, of Westerham, gent 1
5159536 2403905 2403905 defendant Fynche John draper & tailor 591216 591216 Fynche, John, of Westerham, draper & tailor 2
5164490 2405346 2405346 defendant Chanewe James gent 591216 591216 Chanewe, James, of Westerham, gent 1
5166189 2405838 2405838 defendant Dunmowe Richard   591216 591216 Dunmowe, Richard, of Westerham, shoe maker 1
5174633 2408281 2408281 defendant Fynche John draper & tailor 591216 591216 Fynche, John, of Westerham, draper & tailor 2
5181393 2410301 2410301 defendant Frowede Richard   591216 591216 Frowede, Richard, of Westerham, 4
5185809 2411596 2411596 defendant Wylkyn John husbandman 591216 591216 Wylkyn, John, of Westerham, husbandman 0
5188843 2412466 2412466 defendant Chanewe James gent 591216 591216 Chanewe, James, of Westerham, gent 1
5204941 2417191 2417191 defendant Wylkyn John husbandman 591216 591216 Wylkyn, John, of Westerham, husbandman 0
5209263 2418439 2418439 defendant Fynche John draper 591216 591216 Fynche, John, of Westerham, draper 0
5212039 2419260 2419260 defendant Fynche John tailor 591216 591216 Fynche, John, of Westerham, tailor 3
5218318 2421089 2421089 defendant Fynche John tailor 591216 591216 Fynche, John, of Westerham, tailor 4
5298657 2444581 2444581 defendant Walkelyn John   591216 591216 Walkelyn, John, of Westerham, tile maker 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);