names

197 rows where place_id = 589192

✎ 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
3596854 1866652 1866652 defendant Welsshe William yeoman 589192 589192 Welsshe, William, of Dunstaple, Beds, yeoman 1
3601695 1868184 1868184 defendant Parkyn William yeoman 589192 589192 Parkyn, William, of Dunstaple, Beds, yeoman 0
3606488 1869702 1869702 plaintiff Neweton William clerk 589192 589192 Neweton, William, of Dunstaple, Beds, clerk 0
3616905 1872918 1872918 defendant Leonard John hosteler 589192 589192 Leonard, John, of Dunstaple, Beds, hosteler 2
3616940 1872923 1872923 defendant Leonard John yeoman 589192 589192 Leonard, John, of Dunstaple, Beds, yeoman 2
3616964 1872927 1872927 defendant Halsy William yeoman 589192 589192 Halsy, William, of Dunstaple, Beds, yeoman 0
3618731 1873480 1873480 defendant Mannyng John husbandman 589192 589192 Mannyng, John, of Dunstaple, Beds, husbandman 2
3626223 1903058 1903058 defendant Elys John chapman 589192 589192 Elys, John, of Dunstaple, Beds, chapman 0
3642249 1908023 1908023 defendant Symon William yeoman 589192 589192 Symon, William, of Dunstaple, Beds, yeoman 4
3653778 1911440 1911440 defendant Elys Richard yeoman 589192 589192 Elys, Richard, of Dunstaple, Beds, yeoman 0
3664730 1914919 1914919 defendant Symondys William yeoman 589192 589192 Symondys, William, of Dunstaple, Beds, yeoman 1
3737938 1938080 1938080 defendant Kent John maltman 589192 589192 Kent, John, of Dunstaple, Beds, maltman 1
3788673 1954257 1954257 defendant Holden Edward maltman 589192 589192 Holden, Edward, of Dunstaple, Beds, maltman 0
3788675 1954258 1954258 defendant Holden Edward maltman 589192 589192 Holden, Edward, of Dunstaple, Beds, maltman 0
3835036 1968898 1968898 defendant Brewse William yeoman or wax chandler 589192 589192 Brewse, William, of Dunstaple, Beds, yeoman or wax chandler 1
3835039 1968899 1968899 defendant Brewse William yeoman or wax chandler 589192 589192 Brewse, William, of Dunstaple, Beds, yeoman or wax chandler 1
3877700 1982784 1982784 defendant Cavendisshe George gent 589192 589192 Cavendisshe, George, of Dunstaple, Beds, gent 0
3918686 1996578 1996578 defendant Barnesley Richard gent 589192 589192 Barnesley, Richard, of Dunstaple, Beds, gent 2
3927550 1999556 1999556 defendant Bowstr-- Edward (legal representative) 589192 589192 Bowstr--, Edward, of Dunstaple, Beds, yeoman, executor of 0
3951869 2007714 2007714 defendant Grantham Edward (legal representative) 589192 589192 Grantham, Edward, of Dunstaple, Beds, mason, administratrix of 0
3992375 2022039 2022039 defendant Langtoo Thomas yeoman 589192 589192 Langtoo, Thomas, of Dunstaple, Beds, yeoman 0
3994331 2022725 2022725 defendant Davye John, senior (legal representative) 589192 589192 Davye, John, senior, of Dunstaple, Beds, yeoman, executors of 0
4017610 2031007 2031007 plaintiff Tiplady John mercer 589192 589192 Tiplady, John, of Dunstaple, Beds, mercer 0
4182629 2089404 2089404 defendant Typlady John chapman 589192 589192 Typlady, John, of Dunstaple, Beds, chapman 0
4182631 2089405 2089405 defendant Typlady John, senior chapman 589192 589192 Typlady, John, senior, of Dunstaple, Beds, chapman 0
4358850 2150329 2150329 defendant Bannell William yeoman 589192 589192 Bannell, William, of Dunstaple, Beds, yeoman 1
4510619 2203779 2203779 defendant Hoke Richard mercer 589192 589192 Hoke, Richard, of Dunstaple, Beds, mercer 0
4510626 2203780 2203780 defendant Hoke Richard mercer 589192 589192 Hoke, Richard, of Dunstaple, Beds, mercer 0
4640857 2243425 2243425 defendant Mylys Richard   589192 589192 Mylys, Richard, of Dunstaple, Beds 1
4640865 2243426 2243426 defendant Mylys Richard   589192 589192 Mylys, Richard, of Dunstaple, Beds 1
4641039 2243471 2243471 defendant Troute John   589192 589192 Troute, John, of Dunstaple, Beds 1
4654286 2247220 2247220 defendant Russell Roger hosteler 589192 589192 Russell, Roger, of Dunstaple, Beds, hosteler 0
4658943 2248668 2248668 defendant Parker John butcher 589192 589192 Parker, John, of Dunstaple, Beds, butcher 0
4658946 2248669 2248669 defendant Parker John butcher 589192 589192 Parker, John, of Dunstaple, Beds, butcher 0
4685053 2260924 2260924 defendant Umfrey Simon yeoman 589192 589192 Umfrey, Simon, of Dunstaple, Beds, yeoman 0
4716037 2270322 2270322 defendant Gerveys Roger cutler 589192 589192 Gerveys, Roger, of Dunstaple, Beds, cutler 1
4716040 2270323 2270323 defendant Gerveys Roger cutler 589192 589192 Gerveys, Roger, of Dunstaple, Beds, cutler 1
4728511 2274153 2274153 defendant Deer William   589192 589192 Deer, William, of Dunstaple, Beds, lock maker 0
4738368 2277096 2277096 defendant Hele Thomas esq 589192 589192 Hele, Thomas, of Dunstaple, Beds, esq 0
4746196 2279382 2279382 defendant Luchelade Simon butcher 589192 589192 Luchelade, Simon, of Dunstaple, Beds, butcher 0
4746667 2279516 2279516 defendant Smyth William butcher 589192 589192 Smyth, William, of Dunstaple, Beds, butcher 1
4749687 2280393 2280393 defendant Smyth William butcher 589192 589192 Smyth, William, of dunstaple, Beds, butcher 1
4749692 2280394 2280394 defendant Smyth William butcher 589192 589192 Smyth, William, of Dunstaple, Beds, butcher 0
4767623 2285859 2285859 defendant Cokke Richard grocer 589192 589192 Cokke, Richard, of Dunstaple, Beds, formerly of London, grocer 1
4773527 2287689 2287689 defendant Heydon Thomas cutler 589192 589192 Heydon, Thomas, of Dunstaple, Beds, cutler 0
4785163 2291376 2291376 defendant Hele Thomas gent 589192 589192 Hele, Thomas, of Dunstaple, Beds, gent 1
4789831 2292886 2292886 defendant Estgore John cobbler 589192 589192 Estgore, John, of Dunstaple, Beds, cobbler 2
4792024 2293611 2293611 defendant Cokke Ralph grocer 589192 589192 Cokke, Ralph, of Dunstaple, Beds, or of London, grocer 0
4796185 2294958 2294958 defendant Heydon Thomas yeoman 589192 589192 Heydon, Thomas, of Dunstaple, Beds, yeoman 1
4800598 2296367 2296367 defendant Hele Thomas gent 589192 589192 Hele, Thomas, of Dunstaple, Beds, gent 0
4800685 2296396 2296396 defendant Parker John yeoman 589192 589192 Parker, John, of Dunstaple, Beds, yeoman 1
4808103 2298710 2298710 plaintiff Coterell William   589192 589192 Coterell, William, of Dunstaple, Beds 0
4814095 2300507 2300507 defendant Blankpayn John butcher 589192 589192 Blankpayn, John, of Dunstaple, Beds, butcher 0
4814097 2300508 2300508 defendant Blankpayn John butcher 589192 589192 Blankpayn, John, of Dunstaple, Beds, butcher 0
4820202 2302391 2302391 plaintiff Pycot Lawrence   589192 589192 Pycot, Lawrence, of Dunstaple, Beds, wool man 1
4820208 2302392 2302392 plaintiff Pycot Lawrence   589192 589192 Pycot, Lawrence, of Dunstaple, Beds, wool man 1
4821055 2302663 2302663 defendant Man John chapman 589192 589192 Man, John, of Dunstaple, Beds, chapman 3
4827808 2304743 2304743 defendant Conquest William yeoman 589192 589192 Conquest, William, of Dunstaple, Beds, yeoman 0
4827810 2304744 2304744 defendant Conquest William yeoman 589192 589192 Conquest, William, of Dunstaple, Beds, yeoman 0
4827812 2304745 2304745 defendant Lytilton Thomas   589192 589192 Lytilton, Thomas, of Dunstaple, Beds, yeoman, 0
4831407 2305855 2305855 defendant Pycot Lawrence   589192 589192 Pycot, Lawrence, of Dunstaple, Beds, wool man 0
4834382 2306760 2306760 defendant Jakes John mercer 589192 589192 Jakes, John, of Dunstaple, Beds, mercer 1
4842653 2309238 2309238 plaintiff London Thomas maltman 589192 589192 London, Thomas, of Dunstaple, Beds, maltman 0
4851575 2311927 2311927 defendant Barry Roger husbandman 589192 589192 Barry, Roger, of Dunstaple, Beds, husbandman 2
4851581 2311928 2311928 defendant Barry Roger husbandman 589192 589192 Barry, Roger, of Dunstaple, Beds, husbandman 2
4857087 2313596 2313596 defendant Boney or Bouey William fellmonger 589192 589192 Boney or Bouey, William, of Dunstaple, Beds, fellmonger 3
4868561 2317142 2317142 defendant Rede Richard   589192 589192 Rede, Richard, of Dunstaple, Beds, mason 0
4871692 2318114 2318114 defendant Russell Roger husbandman 589192 589192 Russell, Roger, of Dunstaple, Beds, husbandman 0
4871694 2318115 2318115 defendant Russell Roger husbandman 589192 589192 Russell, Roger, of Dunstaple, Beds, husbandman 0
4880944 2320948 2320948 defendant Marchall Edmund smith 589192 589192 Marchall, Edmund, of Dunstaple, Beds, smith 0
4880948 2320949 2320949 defendant Marchall Edmund smith 589192 589192 Marchall, Edmund, of Dunstaple, Beds, smith 0
4883008 2321608 2321608 defendant Lytell Thomas husbandman 589192 589192 Lytell, Thomas, of Dunstaple, Beds, husbandman 0
4902173 2327291 2327291 defendant Davy William fuller 589192 589192 Davy, William, of Dunstaple, Beds, fuller 0
4909671 2329553 2329553 defendant Mows John, junior yeoman 589192 589192 Mows, John, junior, of Dunstaple, Beds, yeoman 0
4910740 2329868 2329868 defendant Parker John husbandman 589192 589192 Parker, John, of Dunstaple, Beds, husbandman 3
4912612 2330446 2330446 defendant Elys John shoemaker 589192 589192 Elys, John, of Dunstaple, Beds, shoemaker 0
4928105 2335222 2335222 defendant Parker Henry taverner 589192 589192 Parker, Henry, of Dunstaple, Beds, taverner 1
4928111 2335223 2335223 defendant Parker Henry taverner 589192 589192 Parker, Henry, of Dunstaple, Beds, taverner 1
4929481 2335638 2335638 defendant Neell William husbandman 589192 589192 Neell, William, of Dunstaple, Beds, husbandman 2
4930120 2335828 2335828 defendant Mons John husbandman 589192 589192 Mons, John, of Dunstaple, Beds, husbandman 0
4936297 2337752 2337752 defendant Blaunkepayn John butcher 589192 589192 Blaunkepayn, John, of Dunstaple, Beds, butcher 0
4942552 2339648 2339648 defendant Banham John chapman 589192 589192 Banham, John, of Dunstaple, Beds, chapman 1
4942573 2339650 2339650 defendant Banham John chapman 589192 589192 Banham, John, of Dunstaple, Beds, chapman 1
4945497 2340570 2340570 defendant Wakefeld John chapman 589192 589192 Wakefeld, John, of Dunstaple, Beds, chapman 0
4945499 2340571 2340571 defendant Wakefeld John chapman 589192 589192 Wakefeld, John, of Dunstaple, Beds, chapman 0
4948075 2341373 2341373 defendant Barry Roger yeoman 589192 589192 Barry, Roger, of Dunstaple, Beds, yeoman 1
4948080 2341374 2341374 defendant Barry Roger yeoman 589192 589192 Barry, Roger, of Dunstaple, Beds, yeoman 1
4948102 2341379 2341379 defendant Barry Roger yeoman 589192 589192 Barry, Roger, of Dunstaple, Beds, yeoman 1
4948489 2341505 2341505 defendant Bate John yeoman 589192 589192 Bate, John, of Dunstaple, Beds, yeoman 2
4953020 2342870 2342870 defendant Parker Henry hosteler 589192 589192 Parker, Henry, of Dunstaple, Beds, hosteler 0
4953024 2342871 2342871 defendant Parker Henry hosteler 589192 589192 Parker, Henry, of Dunstaple, Beds, hosteler 0
5000010 2356883 2356883 defendant Blount Walter husbandman 589192 589192 Blount, Walter, of Dunstaple, Beds, husbandman 0
5029477 2365494 2365494 defendant Harpham Thomas chapman 589192 589192 Harpham, Thomas, of Dunstaple, Beds, chapman 0
5031858 2366190 2366190 defendant Russell alias Bayly John yeoman 589192 589192 Russell alias Bayly, John, of Dunstaple, Beds, yeoman 2
5040910 2368901 2368901 defendant Wambourne John husbandman 589192 589192 Wambourne, John, of Dunstaple, Beds, husbandman 0
5043247 2369599 2369599 defendant Barry Ralph   589192 589192 Barry, Ralph, of Dunstaple, Beds, coke 4
5047048 2370740 2370740 defendant Nele Reginal esq 589192 589192 Nele, Reginal, of Dunstaple, Beds, esq 0
5047060 2370744 2370744 defendant Nele Reginald armourer 589192 589192 Nele, Reginald, of Dunstaple, Beds, armourer 0
5059690 2374460 2374460 defendant Brame or Braine Robert mercer 589192 589192 Brame or Braine, Robert, of Dunstaple, Beds, mercer 4
5066401 2376479 2376479 defendant Baldok Lawrence maltman 589192 589192 Baldok, Lawrence, of Dunstaple, Beds, maltman 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);