names

190 rows where place_id = 593160

✎ 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
3610744 1871025 1871025 defendant Saker Robert husbandman 593160 593160 Saker, Robert, of Dorkyng, husbandman 0
3631697 1904726 1904726 defendant More Thomas sawyer 593160 593160 More, Thomas, of Dorkyng, sawyer 0
3631700 1904726 1904726 defendant Stylewill John husbandman 593160 593160 Stylewill, John, of Dorkyng, husbandman 3
3634572 1905616 1905616 defendant Elyot William chapman 593160 593160 Elyot, William, of Dorkyng, chapman 0
3645522 1908996 1908996 defendant Stylewell John yeoman 593160 593160 Stylewell, John, of Dorkyng, yeoman 3
3655779 1912067 1912067 plaintiff Bristowe William   593160 593160 Bristowe, William, of Dorkyng 3
3655784 1912068 1912068 plaintiff Brystowe William   593160 593160 Brystowe, William, of Dorkyng 3
3655790 1912069 1912069 plaintiff Brystowe William   593160 593160 Brystowe, William, of Dorkyng 3
3665996 1915299 1915299 defendant Lusted Edward yeoman 593160 593160 Lusted, Edward, of Dorkyng, yeoman 0
3665997 1915299 1915299 defendant Hegger Richard husbandman 593160 593160 Hegger, Richard, of Dorkyng, husbandman 1
3683711 1921039 1921039 defendant Godnam alias Skynner John sminner 593160 593160 Godnam alias Skynner, John, of Dorkyng, sminner 1
3686566 1921948 1921948 defendant Palmer Robert fletcher 593160 593160 Palmer, Robert, of Dorkyng, fletcher 0
3710615 1929642 1929642 defendant Broket Richard husbandman 593160 593160 Broket, Richard, of Dorkyng, husbandman 1
3710616 1929642 1929642 defendant Broker John husbandman 593160 593160 Broker, John, of Dorkyng, husbandman 2
3710617 1929642 1929642 defendant Wonam or Wovam Robert   593160 593160 Wonam or Wovam, Robert, of Dorkyng, tile maker 3
3718451 1932050 1932050 defendant Brokett William yeoman 593160 593160 Brokett, William, of Dorkyng, yeoman 1
3718452 1932050 1932050 defendant Stapylton William yeoman 593160 593160 Stapylton, William, of Dorkyng, yeoman 2
3721176 1932922 1932922 defendant Wyllot John carpenter 593160 593160 Wyllot, John, of Dorkyng, carpenter 0
3721177 1932922 1932922 defendant Broket William smith 593160 593160 Broket, William, of Dorkyng, smith 1
3721178 1932922 1932922 defendant Palmer John husbandman 593160 593160 Palmer, John, of Dorkyng, husbandman 2
3732502 1936396 1936396 defendant Burdett Henry yeoman 593160 593160 Burdett, Henry, of Dorkyng, yeoman 3
3758445 1944636 1944636 defendant Fraunces John yeoman 593160 593160 Fraunces, John, of Dorkyng, yeoman 4
3758774 1944731 1944731 defendant Stevyn John butcher 593160 593160 Stevyn, John, of Dorkyng, butcher 0
3759081 1944825 1944825 defendant Wheler William tailor 593160 593160 Wheler, William, of Dorkyng, tailor 2
3778315 1950931 1950931 defendant Elyott William yeoman 593160 593160 Elyott, William, of Dorkyng, yeoman 0
3784044 1952790 1952790 plaintiff Lucas Thomas   593160 593160 Lucas, Thomas, of Dorkyng 0
3785518 1953260 1953260 defendant Vyvyan Thomas clerk 593160 593160 Vyvyan, Thomas, of Dorkyng, clerk 0
3788617 1954243 1954243 defendant Ancell John laborer 593160 593160 Ancell, John, of Dorkyng, laborer 1
3788618 1954243 1954243 defendant Auncell Thomas laborer 593160 593160 Auncell, Thomas, of Dorkyng, laborer 2
3788619 1954243 1954243 defendant Elyoott Henry laborer 593160 593160 Elyoott, Henry, of Dorkyng, laborer 3
3792393 1955482 1955482 defendant Barons William husbandman 593160 593160 Barons, William, of Dorkyng, husbandman 0
3797989 1957270 1957270 defendant Lusted Edward yeoman 593160 593160 Lusted, Edward, of Dorkyng, yeoman 0
3797990 1957270 1957270 defendant Wonam Robert yeoman 593160 593160 Wonam, Robert, of Dorkyng, yeoman 1
3797991 1957270 1957270 defendant Oxborne William husbandman 593160 593160 Oxborne, William, of Dorkyng, husbandman 2
3797993 1957271 1957271 defendant Lusted Edward yeoman 593160 593160 Lusted, Edward, of Dorkyng, yeoman 0
3797994 1957271 1957271 defendant Wonam Robert yeoman 593160 593160 Wonam, Robert, of Dorkyng, yeoman 1
3797995 1957271 1957271 defendant Oxborne William husbandman 593160 593160 Oxborne, William, of Dorkyng, husbandman 2
3810535 1961192 1961192 defendant Wyllott John carpenter 593160 593160 Wyllott, John, of Dorkyng, carpenter 0
3842277 1971129 1971129 defendant Ellys Richard butcher 593160 593160 Ellys, Richard, of Dorkyng, butcher 0
3853721 1974795 1974795 plaintiff Stancyall Nicholas gent 593160 593160 Stancyall, Nicholas, of Dorkyng, gent 0
3853723 1974795 1974795 defendant Wyllett John carpenter 593160 593160 Wyllett, John, of Dorkyng, carpenter 1
3860397 1976972 1976972 defendant Dalton Christopher husbandman 593160 593160 Dalton, Christopher, of Dorkyng, husbandman 0
3862482 1977648 1977648 defendant Dalton Christopher yeoman 593160 593160 Dalton, Christopher, of Dorkyng, yeoman 0
3864773 1978414 1978414 defendant Hether John (legal representative) 593160 593160 Hether, John, of Dorkyng, husbandman, executors of 0
3864774 1978414 1978414 defendant Hether John husbandman 593160 593160 (Hether, John, of Dorkyng, husbandman 1
3864775 1978414 1978414 defendant Lusted Edward yeoman 593160 593160 Lusted, Edward, of Dorkyng, yeoman 2
3868146 1979584 1979584 plaintiff Stanciall Nicholas gent 593160 593160 Stanciall, Nicholas, of Dorkyng, gent 0
3868147 1979584 1979584 defendant Welet John carpenter 593160 593160 Welet, John, of Dorkyng, carpenter 0
3871940 1980848 1980848 defendant Kempe John yeoman 593160 593160 Kempe, John, of Dorkyng, yeoman 2
3871942 1980848 1980848 defendant Yong Thomas laborer 593160 593160 Yong, Thomas, of Dorkyng, laborer 4
3874666 1981745 1981745 defendant Wheler William tailor 593160 593160 Wheler, William, of Dorkyng, tailor 1
3875853 1982179 1982179 defendant Broket Clemence widow 593160 593160 Broket, Clemence, of Dorkyng, widow 1
3894508 1988372 1988372 defendant Wyllott John, senior carpenter 593160 593160 Wyllott, John, senior, of Dorkyng, carpenter 0
3899181 1989931 1989931 defendant Palmer William smith 593160 593160 Palmer, William, of Dorkyng, smith 0
3899182 1989931 1989931 defendant Palmer Elizabeth widow 593160 593160 Palmer, Elizabeth, of Dorkyng, widow 1
3900088 1990252 1990252 defendant Dalton Christopher yeoman 593160 593160 Dalton, Christopher, of Dorkyng, yeoman 1
3905131 1991981 1991981 defendant Lusted Edward yeoman 593160 593160 Lusted, Edward, of Dorkyng, yeoman 0
3923769 1998254 1998254 defendant Staplehurste John husbandman 593160 593160 Staplehurste, John, of Dorkyng, husbandman 0
3930513 2000547 2000547 defendant Heyther John husbandman 593160 593160 Heyther, John, of Dorkyng, husbandman 0
3964378 2012145 2012145 defendant Taylor John, senior yeoman 593160 593160 Taylor, John, senior, of Dorkyng, yeoman 0
3969649 2013989 2013989 defendant Gaynesford Nicholas gent 593160 593160 Gaynesford, Nicholas, of Dorkyng, gent 0
4329960 2140320 2140320 defendant Chatryngham Thomas yeoman 593160 593160 Chatryngham, Thomas, of Dorkyng, yeoman 1
4424893 2172624 2172624 defendant Kyng Robert   593160 593160 Kyng, Robert, of Dorkyng 1
4434532 2175557 2175557 defendant Kyng Robert   593160 593160 Kyng, Robert, of Dorkyng 1
4539889 2212739 2212739 defendant atte Detto John   593160 593160 atte Detto, John, of Dorkyng 1
4540171 2212829 2212829 defendant atte Dene John   593160 593160 atte Dene, John, of Dorkyng 1
4565397 2220746 2220746 plaintiff Smyth John   593160 593160 Smyth, John, of Dorkyng 0
4667229 2255482 2255482 defendant atte Heglond William shoemaker 593160 593160 atte Heglond, William, of Dorkyng, shoemaker 2
4667451 2255541 2255541 defendant atte Heghlond William shoemaker 593160 593160 atte Heghlond, William, of Dorkyng, shoemaker 0
4671190 2256650 2256650 defendant atte Pyree Henry laborer 593160 593160 atte Pyree, Henry, of Dorkyng, laborer 2
4671192 2256650 2256650 defendant atte Heglylonde William shoemaker 593160 593160 atte Heglylonde, William, of Dorkyng, shoemaker 4
4671194 2256651 2256651 defendant Chaumberlayn Robert hosteler 593160 593160 Chaumberlayn, Robert, of Dorkyng, hosteler 0
4671196 2256651 2256651 defendant Smyth William smith 593160 593160 Smyth, William, of Dorkyng, smith 2
4671197 2256651 2256651 defendant Lichiare John fletcher 593160 593160 Lichiare, John, of Dorkyng, fletcher 3
4671198 2256651 2256651 defendant Skete Richard husbandman 593160 593160 Skete, Richard, of Dorkyng, husbandman 4
4671203 2256651 2256651 defendant Potrythe John warner 593160 593160 Potrythe, John, of Dorkyng, warner 9
4671204 2256651 2256651 defendant Mulsey John laborer 593160 593160 Mulsey, John, of Dorkyng, laborer 10
4671207 2256651 2256651 defendant atte Pyree Henry laborer 593160 593160 atte Pyree, Henry, of Dorkyng, laborer 13
4671209 2256651 2256651 defendant atte Heglylonde William shoemaker 593160 593160 atte Heglylonde, William, of Dorkyng, shoemaker 15
4692451 2263157 2263157 defendant atte Shete Robert husbandman 593160 593160 atte Shete, Robert, of Dorkyng, husbandman 0
4733662 2275706 2275706 defendant Shudde William husbandman 593160 593160 Shudde, William, of Dorkyng, husbandman 0
4739246 2277365 2277365 defendant Skete Richard husbandman 593160 593160 Skete, Richard, of Dorkyng, husbandman 0
4739247 2277365 2277365 defendant Lethyere John   593160 593160 Lethyere, John, of Dorkyng, arrow maker 1
4739250 2277365 2277365 defendant Tanner William husbandman 593160 593160 together with Tanner, William, of Dorkyng, husbandman 4
4743382 2278594 2278594 plaintiff Cotere Thomas   593160 593160 Cotere, Thomas, of Dorkyng, on his own account 0
4750586 2280658 2280658 defendant Shudde William husbandman 593160 593160 Shudde, William, of Dorkyng, husbandman 0
4751077 2280797 2280797 defendant atte Redefford William husbandman 593160 593160 atte Redefford, William, of Dorkyng, husbandman 4
4775943 2288479 2288479 defendant Netelfold Robert husbandman 593160 593160 Netelfold, Robert, of Dorkyng, husbandman 0
4840225 2308490 2308490 defendant Dawe John shoemaker 593160 593160 Dawe, John, of Dorkyng, shoemaker 0
4840226 2308490 2308490 defendant Turnour William mercer 593160 593160 Turnour, William, of Dorkyng, mercer 1
4871686 2318111 2318111 defendant Bromman Walter husbandman 593160 593160 Bromman, Walter, of Dorkyng, husbandman 0
4908405 2329185 2329185 defendant Clyve Richard clerk 593160 593160 Clyve, Richard, of Dorkyng, clerk 0
4911339 2330049 2330049 defendant Asshehurst William husbandman 593160 593160 Asshehurst, William, of Dorkyng, husbandman 1
4966613 2346947 2346947 defendant Assheherst Thomas gent 593160 593160 Assheherst, Thomas, of Dorkyng, gent 0
5009751 2359732 2359732 defendant Carpenter Henry husbandman 593160 593160 Carpenter, Henry, of Dorkyng, husbandman 1
5013193 2360691 2360691 defendant Sakre William fisher 593160 593160 Sakre, William, of Dorkyng, fisher 2
5025282 2364288 2364288 defendant Tanner John husbandman 593160 593160 Tanner, John, of Dorkyng, husbandman 1
5037628 2367881 2367881 defendant Plachynghurst Thomas husbandman 593160 593160 Plachynghurst, Thomas, of Dorkyng, husbandman 0
5037629 2367881 2367881 defendant Godewyn Thomas husbandman 593160 593160 Godewyn, Thomas, of Dorkyng, husbandman 1
5052865 2372447 2372447 defendant Getur John husbandman 593160 593160 Getur, John, of Dorkyng, husbandman 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);