names

422 rows where place_id = 593495

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612098 1871428 1871428 defendant Broun Robert laborer 593495 593495 Broun, Robert, of Luton, laborer 3
3612099 1871428 1871428 defendant Colyns John tiler 593495 593495 Colyns, John, of Luton, tiler 4
3612100 1871428 1871428 defendant Haweman William husbandman 593495 593495 Haweman, William, of Luton, husbandman 5
3612233 1871462 1871462 defendant Broun Robert laborer 593495 593495 Broun, Robert, of Luton, laborer 3
3612234 1871462 1871462 defendant Colyns John tiler 593495 593495 Colyns, John, of Luton, tiler 4
3612235 1871462 1871462 defendant Haweman William husbandman 593495 593495 Haweman, William, of Luton, husbandman 5
3616554 1872813 1872813 defendant Lande or Laude Edward husbandman 593495 593495 Lande or Laude, Edward, of Luton, husbandman 1
3621518 1874272 1874272 defendant Wynche Thomas husbandman 593495 593495 Wynche, Thomas, of Luton, husbandman 0
3621984 1874418 1874418 defendant Norreys Robert innholder 593495 593495 Norreys, Robert, of Luton, innholder 0
3625848 1875618 1875618 defendant Smyth Thomas husbandman 593495 593495 Smyth, Thomas, of Luton, husbandman 0
3634768 1905672 1905672 plaintiff Mower William (legal representative) 593495 593495 Mower, William, of Luton, executors of 0
3634771 1905672 1905672 defendant Godys Richard, junior maltman 593495 593495 Godys, Richard, junior, of Luton, maltman 0
3641281 1907725 1907725 defendant Gode Richard, senior husbandman 593495 593495 Gode, Richard, senior, of Luton, husbandman 0
3641282 1907725 1907725 defendant Gode Richard, junior husbandman 593495 593495 Gode, Richard, junior, of Luton, husbandman 1
3643345 1908344 1908344 defendant Stoppley Henry husbandman 593495 593495 Stoppley, Henry, of Luton, husbandman 1
3643346 1908344 1908344 defendant Bonstret Richard husbandman 593495 593495 Bonstret, Richard, of Luton, husbandman 2
3643347 1908344 1908344 defendant Pykeryng William husbandman 593495 593495 Pykeryng, William, of Luton, husbandman 3
3643348 1908344 1908344 defendant Careles Hjugh laborer 593495 593495 Careles, Hjugh, of Luton, laborer 4
3645455 1908985 1908985 defendant Acworth George gent 593495 593495 Acworth, George, of Luton, gent 0
3647899 1909739 1909739 defendant Pyrot John, junior maltman 593495 593495 Pyrot, John, junior, of Luton, maltman 0
3653972 1911507 1911507 defendant Daldron Robert husbandman 593495 593495 Daldron, Robert, of Luton, husbandman 0
3654192 1911571 1911571 defendant Daldron Robert husbandman 593495 593495 Daldron, Robert, of Luton, husbandman 0
3655679 1912041 1912041 defendant Pyrrot John, junior maltman 593495 593495 Pyrrot, John, junior, of Luton, maltman 0
3657309 1912546 1912546 defendant Bonstren Richard husbandman 593495 593495 Bonstren, Richard, of Luton, husbandman 2
3657310 1912546 1912546 defendant Pykeryng William husbandman 593495 593495 Pykeryng, William, of Luton, husbandman 3
3657311 1912546 1912546 defendant Careles Hugh laborer 593495 593495 Careles, Hugh, of Luton, laborer 4
3663766 1914600 1914600 defendant Corne Henry husbandman 593495 593495 Corne, Henry, of Luton, husbandman 4
3664611 1914887 1914887 defendant Peret Agnes widow 593495 593495 Peret, Agnes, of Luton, widow 0
3668915 1916210 1916210 defendant Pett John maltman 593495 593495 Pett, John, of Luton, maltman 2
3668924 1916212 1916212 defendant Salter William tinker 593495 593495 Salter, William, of Luton, tinker 2
3669716 1916472 1916472 defendant Thredar Andrew miller 593495 593495 Thredar, Andrew, of Luton, miller 0
3669717 1916472 1916472 defendant Dey Richard miller 593495 593495 Dey, Richard, of Luton, miller 1
3669718 1916472 1916472 defendant Leycrofte Thomas laborer 593495 593495 Leycrofte, Thomas, of Luton, laborer 2
3669719 1916472 1916472 defendant Chapman Thomas yeoman 593495 593495 Chapman, Thomas, of Luton, yeoman 3
3672554 1917414 1917414 defendant Purvey Henry yeoman 593495 593495 Purvey, Henry, of Luton, yeoman 0
3672555 1917414 1917414 defendant Tyler John butcher 593495 593495 Tyler, John, of Luton, butcher 1
3672556 1917414 1917414 defendant Lowdy Roger husbandman 593495 593495 Lowdy, Roger, of Luton, husbandman 2
3681201 1920203 1920203 defendant Parot Thomas maltman 593495 593495 Parot, Thomas, of Luton, maltman 0
3681763 1920396 1920396 plaintiff Spayn Richard (legal representative) 593495 593495 Spayn, Richard, of Luton, executor of 0
3681769 1920396 1920396 defendant Smyth Thomas, senior husbandman 593495 593495 Smyth, Thomas, senior, of Luton, husbandman 4
3688503 1922561 1922561 defendant Purvey Henry yeoman 593495 593495 Purvey, Henry, of Luton, yeoman 0
3689634 1922918 1922918 defendant Nicolson William sawyer 593495 593495 Nicolson, William, of Luton, sawyer 2
3696604 1925172 1925172 defendant Kyng John yeoman 593495 593495 Kyng, John, of Luton, yeoman 0
3697011 1925290 1925290 defendant Purvey Henry   593495 593495 Purvey, Henry, of Luton 0
3697755 1925521 1925521 defendant Stoppesley Henry husbandman 593495 593495 Stoppesley, Henry, of Luton, husbandman 0
3697756 1925521 1925521 defendant Stoppesley Valentine laborer 593495 593495 Stoppesley, Valentine, of Luton, laborer 1
3697757 1925521 1925521 defendant Careles Hugh laborer 593495 593495 Careles, Hugh, of Luton, laborer 2
3713052 1930407 1930407 plaintiff Wynche Robert yeoman 593495 593495 Wynche, Robert, of Luton, yeoman 0
3713053 1930407 1930407 defendant Style Richard yeoman 593495 593495 Style, Richard, of Luton, yeoman 0
3714102 1930710 1930710 plaintiff Barbour Roger maltman 593495 593495 Barbour, Roger, of Luton, maltman 0
3715013 1930990 1930990 defendant Bystok Robert yeoman 593495 593495 Bystok, Robert, of Luton, yeoman 0
3715014 1930990 1930990 defendant Adyngham Henry yeoman 593495 593495 Adyngham, Henry, of Luton, yeoman 1
3717131 1931642 1931642 defendant Nicolles William sawyer 593495 593495 Nicolles, William, of Luton, sawyer 0
3717419 1931730 1931730 defendant Phelypp Thomas husbandman 593495 593495 Phelypp, Thomas, of Luton, husbandman 3
3717438 1931737 1931737 defendant Phelyp Thomas husbandman 593495 593495 Phelyp, Thomas, of Luton, husbandman 3
3728792 1935251 1935251 defendant Tyler John butcher 593495 593495 Tyler, John, of Luton, butcher 0
3739687 1938625 1938625 defendant Laurence William fuller 593495 593495 Laurence, William, of Luton, fuller 2
3739944 1938710 1938710 defendant Tyler John butcher 593495 593495 Tyler, John, of Luton, butcher 0
3743802 1939946 1939946 plaintiff Wynche Robert yeoman 593495 593495 Wynche, Robert, of Luton, yeoman 0
3747698 1941200 1941200 defendant Saltworth Thomas laborer 593495 593495 Saltworth, Thomas, of Luton, laborer 3
3759314 1944903 1944903 defendant Crawley John   593495 593495 Crawley, John, of Luton, husbandman, son of Crawley, John 0
3759315 1944903 1944903 defendant Thrale John husbandman 593495 593495 Thrale, John, of Luton, husbandman 1
3761092 1945470 1945470 defendant Leper Thomas butcher 593495 593495 Leper, Thomas, of Luton, butcher 0
3764166 1946443 1946443 defendant Dey John yeoman 593495 593495 Dey, John, of Luton, yeoman 0
3768935 1947936 1947936 defendant Crowe Roger maltman 593495 593495 Crowe, Roger, of Luton, maltman 0
3770643 1948504 1948504 defendant Lody Roger husbandman 593495 593495 Lody, Roger, of Luton, husbandman 0
3770645 1948504 1948504 defendant Dyer William husbandman 593495 593495 Dyer, William, of Luton, husbandman 2
3770647 1948504 1948504 defendant Crowlay Humphrey husbandman 593495 593495 Crowlay, Humphrey, of Luton, husbandman 4
3773763 1949509 1949509 defendant Spayne Barnard maltman 593495 593495 Spayne, Barnard, of Luton, maltman 0
3773764 1949509 1949509 defendant Crawley John husbandman 593495 593495 Crawley, John, of Luton, husbandman 1
3774793 1949844 1949844 defendant Bukby Edmund maltman 593495 593495 Bukby, Edmund, of Luton, maltman 0
3783263 1952517 1952517 defendant Tanner William butcher 593495 593495 Tanner, William, of Luton, butcher 2
3784486 1952933 1952933 defendant Byrde John butcher 593495 593495 Byrde, John, of Luton, butcher 0
3786274 1953504 1953504 plaintiff Perott John   593495 593495 Perott, John, of Luton 0
3786277 1953504 1953504 defendant Howse Robert maltman 593495 593495 Howse, Robert, of Luton, maltman 2
3786278 1953504 1953504 defendant Gere Thomas carpenter 593495 593495 Gere, Thomas, of Luton, carpenter 3
3786280 1953505 1953505 plaintiff Perott John   593495 593495 Perott, John, of Luton 0
3786775 1953661 1953661 defendant Tanner William butcher 593495 593495 Tanner, William, of Luton, butcher 0
3790503 1954851 1954851 defendant Bukby John maltman 593495 593495 Bukby, John, of Luton, maltman 3
3791800 1955281 1955281 plaintiff Akworth Alice (legal representative) 593495 593495 Akworth, Alice, of Luton, administrator of 0
3792432 1955496 1955496 defendant Thrale William brewer 593495 593495 Thrale, William, of Luton, brewer 0
3792436 1955497 1955497 defendant Threder Thomas shoemaker 593495 593495 Threder, Thomas, of Luton, shoemaker 0
3792439 1955498 1955498 plaintiff Barbour Roger yeoman 593495 593495 Barbour, Roger, of Luton, yeoman 0
3795378 1956425 1956425 plaintiff Crawley Richard singleman 593495 593495 Crawley, Richard, of Luton, singleman 0
3796012 1956614 1956614 defendant Crawley Thomas husbandman 593495 593495 Crawley, Thomas, of Luton, husbandman 0
3796013 1956614 1956614 defendant Laurence John maltman 593495 593495 Laurence, John, of Luton, maltman 1
3797913 1957245 1957245 defendant Wye Edward fissher 593495 593495 Wye, Edward, of Luton, fissher 0
3803793 1959100 1959100 defendant Thrale William husbandman 593495 593495 Thrale, William, of Luton, husbandman 0
3804842 1959459 1959459 plaintiff Spycer alias Heldor Edward   593495 593495 Spycer alias Heldor, Edward, of Luton 0
3804843 1959459 1959459 defendant Style Richard husbandman 593495 593495 Style, Richard, of Luton, husbandman 0
3807535 1960265 1960265 defendant Barbour Roger yeoman 593495 593495 Barbour, Roger, of Luton, yeoman 0
3809291 1960786 1960786 defendant Day John yeoman 593495 593495 Day, John, of Luton, yeoman 0
3810154 1961066 1961066 defendant Dey John, junior husbandman 593495 593495 Dey, John, junior, of Luton, husbandman 0
3810192 1961079 1961079 defendant Marten Thomas smith 593495 593495 Marten, Thomas, of Luton, smith 1
3811506 1961490 1961490 defendant Godes John maltman 593495 593495 Godes, John, of Luton, maltman 0
3812564 1961818 1961818 plaintiff Crawley Richard   593495 593495 Crawley, Richard, of Luton, single man 0
3816240 1962988 1962988 defendant Dey John, senior husbandman 593495 593495 Dey, John, senior, of Luton, husbandman 0
3821304 1964554 1964554 defendant Chamfell or Chamsell Thomas husbandman 593495 593495 Chamfell or Chamsell, Thomas, of Luton, husbandman 1
3822227 1964856 1964856 defendant Petman Thomas husbandman 593495 593495 Petman, Thomas, of Luton, husbandman 0
3824813 1965637 1965637 defendant Dyer William husbandman 593495 593495 Dyer, William, of Luton, husbandman 1

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);