names

298 rows where place_id = 587335

✎ 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
3591121 1864846 1864846 defendant Humfrey Richard weaver 587335 587335 Humfrey, Richard, of Henley on Thames, Oxon, weaver 1
3595281 1866157 1866157 defendant Marmyon William (legal representative) 587335 587335 Marmyon, William, of Henley on Thames, Oxon, esq, executrix of 0
3601203 1868039 1868039 defendant Colyns John baker 587335 587335 Colyns, John, of Henley on Thames, Oxon, baker 0
3608022 1870161 1870161 defendant White William mercer 587335 587335 White, William, of Henley on Thames, Oxon, mercer 0
3620704 1874050 1874050 defendant Mauncell Amice widow 587335 587335 Mauncell, Amice, of Henley on Thames, Oxon, widow 1
3621888 1874388 1874388 defendant Umfrey Richard weaver 587335 587335 Umfrey, Richard, of Henley on Thames, Oxon, weaver 0
3621890 1874389 1874389 defendant Umfrey Richard weaver 587335 587335 Umfrey, Richard, of Henley on Thames, Oxon, weaver 0
3642553 1908114 1908114 defendant Sawlton David gent 587335 587335 Sawlton, David, of Henley on Thames, Oxon, gent 0
3656927 1912423 1912423 defendant Sawelton David gent 587335 587335 Sawelton, David, of Henley on Thames, Oxon, gent 0
3657946 1912736 1912736 defendant Wydmore William chapman 587335 587335 Wydmore, William, of Henley on Thames, Oxon, chapman 1
3669092 1916265 1916265 defendant Strong Robert butcher 587335 587335 Strong, Robert, of Henley on Thames, Oxon, butcher 3
3671838 1917190 1917190 defendant Longland Luke husbandman 587335 587335 Longland, Luke, of Henley on Thames, Oxon, husbandman 1
3671841 1917191 1917191 defendant Longland Luke gent 587335 587335 Longland, Luke, of Henley on Thames, Oxon, gent 1
3672873 1917527 1917527 defendant Lokke Henry mercer 587335 587335 Lokke, Henry, of Henley on Thames, Oxon, mercer 2
3674597 1918106 1918106 defendant Dawson Thomas gent 587335 587335 Dawson, Thomas, of Henley on Thames, Oxon, gent 2
3678685 1919398 1919398 defendant Brokham Richard yeoman 587335 587335 Brokham, Richard, of Henley on Thames, Oxon, yeoman 0
3679158 1919548 1919548 defendant Stokeley Nicholas yeoman 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, yeoman 1
3679885 1919775 1919775 defendant Stokeley Nicholas cooper 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, cooper 0
3679888 1919776 1919776 defendant Stokeley Nicholas cooper 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, cooper 0
3679891 1919777 1919777 defendant Stokeley Nicholas cooper 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, cooper 0
3680340 1919928 1919928 defendant Stokley Nicholas yeoman 587335 587335 Stokley, Nicholas, of Henley on Thames, Oxon, yeoman 0
3681350 1920256 1920256 defendant Sawylton David gent 587335 587335 Sawylton, David, of Henley on Thames, Oxon, gent 0
3682076 1920503 1920503 plaintiff Stokeley Nicholas cooper 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, cooper 0
3685607 1921650 1921650 defendant Strong Robert butcher 587335 587335 Strong, Robert, of Henley on Thames, Oxon, butcher 3
3687307 1922211 1922211 plaintiff Chesilden Thomas fletcher 587335 587335 Chesilden, Thomas, of Henley on Thames, Oxon, fletcher 0
3689464 1922864 1922864 defendant Stokeley Nicholas cooper 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, cooper 1
3689651 1922921 1922921 defendant Stowkeley Nicholas cooper 587335 587335 Stowkeley, Nicholas, of Henley on Thames, Oxon, cooper 1
3689941 1923013 1923013 defendant Rawlyns Robert dyer 587335 587335 Rawlyns, Robert, of Henley on Thames, Oxon, dyer 0
3690753 1923272 1923272 defendant Richemond Nicholas innholder 587335 587335 Richemond, Nicholas, of Henley on Thames, Oxon, innholder 2
3692952 1923995 1923995 defendant Wydmer William chapman 587335 587335 Wydmer, William, of Henley on Thames, Oxon, chapman 0
3692954 1923996 1923996 defendant Wydmer William chapman 587335 587335 Wydmer, William, of Henley on Thames, Oxon, chapman 0
3694396 1924452 1924452 defendant Stone Thomas   587335 587335 Stone, Thomas, of Henley on Thames, Oxon, wax chandler 1
3694833 1924592 1924592 defendant Wigmore William clothmaker 587335 587335 Wigmore, William, of Henley on Thames, Oxon, clothmaker 0
3695696 1924886 1924886 defendant Oldman Thomas sherman 587335 587335 Oldman, Thomas, of Henley on Thames, Oxon, sherman 2
3695706 1924888 1924888 defendant Oldman Thomas sherman 587335 587335 Oldman, Thomas, of Henley on Thames, Oxon, sherman 2
3701154 1926609 1926609 defendant Boyland Thomas tanner 587335 587335 Boyland, Thomas, of Henley on Thames, Oxon, tanner 2
3715137 1931030 1931030 plaintiff Brokham Richard gent 587335 587335 Brokham, Richard, of Henley on Thames, Oxon, gent 0
3717545 1931777 1931777 defendant Thrustylle Stephen bargeman 587335 587335 Thrustylle, Stephen, of Henley on Thames, Oxon, bargeman 0
3717924 1931907 1931907 defendant Thompson John butcher 587335 587335 Thompson, John, of Henley on Thames, Oxon, butcher 1
3724515 1933953 1933953 defendant Boyland Thomas tanner 587335 587335 Boyland, Thomas, of Henley on Thames, Oxon, tanner 0
3731650 1936127 1936127 plaintiff Cheselden Thomas fletcher 587335 587335 Cheselden, Thomas, of Henley on Thames, Oxon, fletcher 0
3739091 1938437 1938437 defendant Stokeley Nicholas cooper 587335 587335 Stokeley, Nicholas, of Henley on Thames, Oxon, cooper 1
3750887 1942200 1942200 plaintiff Mershe John yeoman 587335 587335 Mershe, John, of Henley on Thames, Oxon, yeoman 0
3766789 1947276 1947276 plaintiff Mershe John yeoman or fisher or draper 587335 587335 Mershe, John, of Henley on Thames, Oxon, yeoman or fisher or draper 0
3776762 1950477 1950477 defendant Potter Thomas fuller 587335 587335 Potter, Thomas, of Henley on Thames, Oxon, fuller 3
3777237 1950628 1950628 defendant Oldman Thomas fuller 587335 587335 Oldman, Thomas, of Henley on Thames, Oxon, fuller 1
3778967 1951143 1951143 defendant Oldman Thomas sherman 587335 587335 Oldman, Thomas, of Henley on Thames, Oxon, sherman 0
3779336 1951259 1951259 defendant Hewerd John bargeman 587335 587335 Hewerd, John, of Henley on Thames, Oxon, bargeman 4
3781105 1951827 1951827 defendant Oldeman Thomas sherman 587335 587335 Oldeman, Thomas, of Henley on Thames, Oxon, sherman 2
3785857 1953366 1953366 defendant Oldeman Thomas fuller 587335 587335 Oldeman, Thomas, of Henley on Thames, Oxon, fuller 0
3785859 1953367 1953367 defendant Oldeman Thomas fuller 587335 587335 Oldeman, Thomas, of Henley on Thames, Oxon, fuller 0
3788789 1954298 1954298 defendant Loke Henry yeoman 587335 587335 Loke, Henry, of Henley on Thames, Oxon, yeoman 0
3796070 1956634 1956634 defendant Impye Thomas chapman 587335 587335 Impye, Thomas, of Henley on Thames, Oxon, chapman 1
3797889 1957236 1957236 defendant Oldman Thomas sherman 587335 587335 Oldman, Thomas, of Henley on Thames, Oxon, sherman 0
3800320 1958017 1958017 defendant Darell Thomas smith 587335 587335 Darell, Thomas, of Henley on Thames, Oxon, smith 1
3801600 1958400 1958400 defendant Smyth Richard bargeman 587335 587335 Smyth, Richard, of Henley on Thames, Oxon, bargeman 0
3802779 1958765 1958765 defendant Wheteley Thomas fuller 587335 587335 Wheteley, Thomas, of Henley on Thames, Oxon, fuller 0
3814561 1962466 1962466 defendant Rawlens Robert dyer 587335 587335 Rawlens, Robert, of Henley on Thames, Oxon, dyer 3
3838588 1969995 1969995 defendant Sare John fuller 587335 587335 Sare, John, of Henley on Thames, Oxon, fuller 1
3849134 1973327 1973327 defendant Strong Robert butcher 587335 587335 Strong, Robert, of Henley on Thames, Oxon, butcher 1
3861640 1977351 1977351 defendant Loke Robert chapman 587335 587335 Loke, Robert, of Henley on Thames, Oxon, chapman 3
3863055 1977842 1977842 defendant Draper John butcher 587335 587335 Draper, John, of Henley on Thames, Oxon, butcher 2
3871873 1980830 1980830 defendant Arden Thomas innholder 587335 587335 Arden, Thomas, of Henley on Thames, Oxon, innholder 0
3880046 1983585 1983585 defendant Rawlyns Robert dyer 587335 587335 Rawlyns, Robert, of Henley on Thames, Oxon, dyer 0
3881828 1984175 1984175 defendant Brownem William clothmaker 587335 587335 Brownem, William, of Henley on Thames, Oxon, clothmaker 0
3884931 1985229 1985229 defendant Tony Robert grocer 587335 587335 Tony, Robert, of Henley on Thames, Oxon, grocer 1
3892115 1987615 1987615 defendant Elmys Anthony gent 587335 587335 Elmys, Anthony, of Henley on Thames, Oxon, gent 0
3892713 1987813 1987813 defendant Smyth Richard waterman 587335 587335 Smyth, Richard, of Henley on Thames, Oxon, waterman 0
3900808 1990500 1990500 defendant Rawlyns Robert dyer 587335 587335 Rawlyns, Robert, of Henley on Thames, Oxon, dyer 0
3925559 1998862 1998862 plaintiff Wolley Thomas cooper 587335 587335 Wolley, Thomas, of Henley on Thames, Oxon, cooper 0
3933535 2001503 2001503 defendant Davye Richard clothier 587335 587335 Davye, Richard, of Henley on Thames, Oxon, clothier 0
3938855 2003336 2003336 defendant Thorpe William gent 587335 587335 Thorpe, William, of Henley on Thames, Oxon, gent 0
3949494 2006893 2006893 defendant Legge Thomas yeoman 587335 587335 Legge, Thomas, of Henley on Thames, Oxon, yeoman 0
3954322 2008581 2008581 defendant Cowper Thomas innholder 587335 587335 Cowper, Thomas, of Henley on Thames, Oxon, innholder 0
3962893 2011615 2011615 defendant Wyse Ambrose chapman 587335 587335 Wyse, Ambrose, of Henley on Thames, Oxon, chapman 1
3967664 2013327 2013327 plaintiff Bysshoppe Geoffrey yeoman 587335 587335 Bysshoppe, Geoffrey, of Henley on Thames, Oxon, yeoman 0
3982088 2018353 2018353 defendant Royse John yeoman 587335 587335 Royse, John, of Henley on Thames, Oxon, yeoman 0
3984837 2019332 2019332 defendant Vener John gent 587335 587335 Vener, John, of Henley on Thames, Oxon, gent 0
3986888 2020052 2020052 plaintiff Wolley Thomas yeoman 587335 587335 Wolley, Thomas, of Henley on Thames, Oxon, yeoman 0
3990946 2021525 2021525 defendant Gyldon John cooper 587335 587335 Gyldon, John, of Henley on Thames, Oxon, cooper 0
4000479 2024940 2024940 defendant Brackley Peter vintner 587335 587335 Brackley, Peter, of Henley on Thames, Oxon, vintner 0
4001846 2025433 2025433 defendant Carter John bargeman 587335 587335 Carter, John, of Henley on Thames, Oxon, bargeman 1
4002197 2025571 2025571 defendant Storye John yeoman 587335 587335 Storye, John, of Henley on Thames, Oxon, yeoman 0
4005295 2026673 2026673 defendant Cheyf Lewis yeoman 587335 587335 Cheyf, Lewis, of Henley on Thames, Oxon, yeoman 1
4022643 2032821 2032821 plaintiff Assenden John yeoman 587335 587335 Assenden, John, of Henley on Thames, Oxon, yeoman 0
4022645 2032822 2032822 plaintiff Assenden John yeoman 587335 587335 Assenden, John, of Henley on Thames, Oxon, yeoman 0
4026959 2034294 2034294 defendant Clere John butcher 587335 587335 Clere, John, of Henley on Thames, Oxon, butcher 0
4033094 2036487 2036487 defendant Davy Richard or Rice yeoman 587335 587335 Davy, Richard or Rice, of Henley on Thames, Oxon, yeoman 0
4033097 2036488 2036488 defendant Davy Richard yeoman 587335 587335 Davy, Richard, of Henley on Thames, Oxon, yeoman 0
4047606 2041595 2041595 defendant Webbe Richard chapman 587335 587335 Webbe, Richard, of Henley on Thames, Oxon, chapman 1
4053876 2043764 2043764 plaintiff Assenden John yeoman 587335 587335 Assenden, John, of Henley on Thames, Oxon, yeoman 0
4057643 2045114 2045114 defendant Knyghte Richard yeoman 587335 587335 Knyghte, Richard, of Henley on Thames, Oxon, yeoman 0
4061375 2046472 2046472 plaintiff Dunt Richard yeoman 587335 587335 Dunt, Richard, of Henley on Thames, Oxon, yeoman 0
4061377 2046473 2046473 plaintiff Dunt Richard yeoman 587335 587335 Dunt, Richard, of Henley on Thames, Oxon, yeoman 0
4061381 2046474 2046474 plaintiff Dunt Richard yeoman 587335 587335 Dunt, Richard, of Henley on Thames, Oxon, yeoman 0
4061383 2046475 2046475 plaintiff Dunt Richard yeoman 587335 587335 Dunt, Richard, of Henley on Thames, Oxon, yeoman 0
4061385 2046476 2046476 plaintiff Dunte Richard yeoman 587335 587335 Dunte, Richard, of Henley on Thames, Oxon, yeoman 0
4061392 2046479 2046479 plaintiff Duntte Richard yeoman 587335 587335 Duntte, Richard, of Henley on Thames, Oxon, yeoman 0
4062651 2046940 2046940 defendant Bennytt John chapman 587335 587335 Bennytt, John, of Henley on Thames, Oxon, chapman 1
4062654 2046941 2046941 defendant Bennytt John chapman 587335 587335 Bennytt, John, of Henley on Thames, Oxon, chapman 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);