names

417 rows where place_id = 587336

✎ 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
3591122 1864846 1864846 defendant Colyns John yeoman 587336 587336 Colyns, John, of Henley on Thames, yeoman 2
3591123 1864846 1864846 defendant Leche Robert chapman 587336 587336 Leche, Robert, of Henley on Thames, chapman 3
3594155 1865814 1865814 defendant Haukwell Thomas tanner 587336 587336 Haukwell, Thomas, of Henley on Thames, tanner 2
3594157 1865814 1865814 defendant Huntelowe John weaver 587336 587336 Huntelowe, John, of Henley on Thames, weaver 4
3594172 1865819 1865819 defendant Baker John innholder 587336 587336 Baker, John, of Henley on Thames, innholder 0
3599766 1867570 1867570 plaintiff Wagge Nicholas merchant 587336 587336 Wagge, Nicholas, of Henley on Thames, merchant 0
3602029 1868295 1868295 defendant Colyns John baker 587336 587336 Colyns, John, of Henley on Thames, baker 1
3604270 1868999 1868999 plaintiff Gesop John   587336 587336 Gesop, John, of Henley on Thames 0
3607009 1869856 1869856 defendant Fuller Thomas fuller 587336 587336 Fuller, Thomas, of Henley on Thames, fuller 1
3607010 1869856 1869856 defendant Barnabe John mercer 587336 587336 Barnabe, John, of Henley on Thames, mercer 2
3607012 1869857 1869857 defendant Russell Amice widow 587336 587336 Russell, Amice, of Henley on Thames, widow 0
3608908 1870444 1870444 defendant Grene John yeoman 587336 587336 Grene, John, of Henley on Thames, yeoman 0
3608909 1870444 1870444 defendant Humfrey Richard weaver 587336 587336 Humfrey, Richard, of Henley on Thames, weaver 1
3618412 1873392 1873392 defendant Dounham Henry yeoman 587336 587336 Dounham, Henry, of Henley on Thames, yeoman 1
3619517 1873671 1873671 defendant Budde John (legal representative) 587336 587336 Budde, John, of Henley on Thames, yeoman, executors of 0
3620708 1874051 1874051 defendant Mauncell Amice widow 587336 587336 Mauncell, Amice, of Henley on Thames, widow 1
3625866 1902942 1902942 defendant Cale Thomas smith 587336 587336 Cale, Thomas, of Henley on Thames, smith 1
3625868 1902942 1902942 defendant White Humphrey miller 587336 587336 White, Humphrey, of Henley on Thames, miller 3
3627593 1903489 1903489 defendant Berde William husbandman 587336 587336 Berde, William, of Henley on Thames, husbandman 0
3630866 1904473 1904473 defendant Bottrell John innholder 587336 587336 Bottrell, John, of Henley on Thames, innholder 0
3631909 1904791 1904791 defendant Boterell John yeoman 587336 587336 Boterell, John, of Henley on Thames, yeoman 0
3632083 1904852 1904852 defendant Halys Thomas gent 587336 587336 Halys, Thomas, of Henley on thames, gent 0
3632084 1904852 1904852 defendant Arche William tanner 587336 587336 Arche, William, of Henley on Thames, tanner 1
3632454 1904967 1904967 defendant Turnour William bargeman 587336 587336 Turnour, William, of Henley on Thames, bargeman 0
3633238 1905211 1905211 defendant Byrche John fuller 587336 587336 Byrche, John, of Henley on Thames, fuller 0
3637838 1906651 1906651 defendant Wedouse Thomas chapman 587336 587336 Wedouse, Thomas, of Henley on Thames, chapman 2
3640039 1907336 1907336 defendant Stedeman Nicholas yeoman 587336 587336 Stedeman, Nicholas, of Henley on Thames, yeoman 0
3640047 1907337 1907337 defendant Stedeman Nicholas yeoman 587336 587336 Stedeman, Nicholas, of Henley on Thames, yeoman 0
3640055 1907338 1907338 defendant Boterell John yeoman 587336 587336 Boterell, John, of Henley on Thames, yeoman 0
3640056 1907338 1907338 defendant Ansty John yeoman 587336 587336 Ansty, John, of Henley on Thames, yeoman 1
3640464 1907449 1907449 defendant Archer Elizabeth widow 587336 587336 Archer, Elizabeth, of Henley on Thames, widow 0
3640743 1907550 1907550 defendant Archer Isabel   587336 587336 Archer, Isabel, of Henley on Thames widow 0
3641053 1907642 1907642 defendant Rede Lewis yeoman 587336 587336 Rede, Lewis, of Henley on Thames, yeoman 0
3641315 1907735 1907735 defendant Berde William turner 587336 587336 Berde, William, of Henley on Thames, turner 0
3641416 1907771 1907771 defendant Berde William husbandman 587336 587336 Berde, William, of Henley on Thames, husbandman 0
3641796 1907884 1907884 plaintiff Brokeham Richard   587336 587336 Brokeham, Richard, of Henley on Thames 0
3641797 1907884 1907884 defendant Rychemond Nicholas innholder 587336 587336 Rychemond, Nicholas, of Henley on Thames, innholder 0
3641819 1907890 1907890 defendant Oldeman Thomas fuller 587336 587336 Oldeman, Thomas, of Henley on Thames, fuller 0
3649563 1910252 1910252 defendant Stanley John butcher 587336 587336 Stanley, John, of Henley on Thames, butcher 0
3654271 1911594 1911594 defendant Potter Thomas fuller 587336 587336 Potter, Thomas, of Henley on Thames, fuller 4
3656088 1912156 1912156 defendant Bocher Robert butcher 587336 587336 Bocher, Robert, of Henley on Thames, butcher 0
3659554 1913249 1913249 defendant Bocher Robert butcher 587336 587336 Bocher, Robert, of Henley on Thames, butcher 1
3660818 1913649 1913649 defendant Kemes Thomas gent 587336 587336 Kemes, Thomas, of Henley on Thames, gent 0
3660819 1913649 1913649 defendant Kenton Robert fuller 587336 587336 Kenton, Robert, of Henley on Thames, fuller 1
3661311 1913813 1913813 defendant Huchyns John   587336 587336 Huchyns, John, of Henley on Thames, inn holder 0
3661314 1913814 1913814 defendant Huchyns John   587336 587336 Huchyns, John, of Henley on Thames, inn holder 0
3663683 1914577 1914577 defendant Butcher Robert butcher 587336 587336 Butcher, Robert, of Henley on Thames, butcher 0
3667607 1915812 1915812 plaintiff Wyddener William   587336 587336 Wyddener, William, of Henley on Thames 0
3668231 1916010 1916010 defendant Archer Elizabeth widow 587336 587336 Archer, Elizabeth, of Henley on Thames, widow 1
3669701 1916465 1916465 defendant Fynnamore Thomas yeoman 587336 587336 Fynnamore, Thomas, of Henley on Thames, yeoman 0
3672727 1917475 1917475 defendant Byrde Roger cordwainer 587336 587336 Byrde, Roger, of Henley on Thames, cordwainer 0
3674021 1917915 1917915 defendant Brokham Henry bargeman 587336 587336 Brokham, Henry, of Henley on Thames, bargeman 0
3678072 1919187 1919187 defendant Mathewe William waterman 587336 587336 Mathewe, William, of Henley on Thames, waterman 0
3682825 1920734 1920734 defendant Wheteley Gilbert (legal representative) 587336 587336 Wheteley, Gilbert, of Henley on Thames, executors of 0
3682826 1920734 1920734 defendant Boylond Thomas yeoman 587336 587336 (Boylond, Thomas, of Henley on Thames, yeoman 1
3682828 1920735 1920735 defendant Wyllyng Robert butcher 587336 587336 Wyllyng, Robert, of Henley on Thames, butcher 0
3684922 1921417 1921417 defendant Stronge Robert butcher 587336 587336 Stronge, Robert, of Henley on Thames, butcher 1
3684925 1921417 1921417 defendant Sawylton David yeoman 587336 587336 Sawylton, David, of Henley on Thames, yeoman 4
3685191 1921519 1921519 defendant Wygmore William capper 587336 587336 Wygmore, William, of Henley on Thames, capper 0
3685192 1921519 1921519 defendant Alesop Thomas dyer 587336 587336 Alesop, Thomas, of Henley on Thames, dyer 1
3685445 1921598 1921598 defendant Strong Robert butcher 587336 587336 Strong, Robert, of Henley on Thames, butcher 0
3685446 1921598 1921598 defendant Harrys Robert butcher 587336 587336 Harrys, Robert, of Henley on Thames, butcher 1
3685448 1921599 1921599 defendant Stronge Robert butcher 587336 587336 Stronge, Robert, of Henley on Thames, butcher 0
3685449 1921599 1921599 defendant Harrys Robert butcher 587336 587336 Harrys, Robert, of Henley on Thames, butcher 1
3687433 1922248 1922248 defendant Sawilton David yeoman 587336 587336 Sawilton, David, of Henley on Thames, yeoman 0
3688680 1922621 1922621 defendant Stronge Robert butcher 587336 587336 Stronge, Robert, of Henley on Thames, butcher 0
3688847 1922672 1922672 defendant Strong Robert butcher 587336 587336 Strong, Robert, of Henley on Thames, butcher 0
3689294 1922815 1922815 defendant Harrys Robert butcher 587336 587336 Harrys, Robert, of Henley on Thames, butcher 0
3690809 1923290 1923290 defendant Sawelton David gent 587336 587336 Sawelton, David, of Henley on Thames, gent 0
3691398 1923467 1923467 defendant Strong Robert butcher 587336 587336 Strong, Robert, of Henley on Thames, butcher 0
3691400 1923468 1923468 defendant Strong Robert butcher 587336 587336 Strong, Robert, of Henley on Thames, butcher 0
3701738 1926788 1926788 defendant Brokham Henry bargeman 587336 587336 Brokham, Henry, of Henley on Thames, bargeman 0
3703686 1927434 1927434 defendant Stone Thomas chandler 587336 587336 Stone, Thomas, of Henley on Thames, chandler 0
3703687 1927434 1927434 defendant Chyvenhurste Richard tanner 587336 587336 Chyvenhurste, Richard, of Henley on Thames, tanner 1
3703689 1927434 1927434 defendant Wellyn Robert butcher 587336 587336 Wellyn, Robert, of Henley on Thames, butcher 3
3704416 1927678 1927678 defendant Boylond Thomas tanner 587336 587336 Boylond, Thomas, of Henley on Thames, tanner 0
3707310 1928575 1928575 defendant Wydmore William mercer 587336 587336 Wydmore, William, of Henley on Thames, mercer 0
3707393 1928603 1928603 defendant Wydmer William, junior capper 587336 587336 Wydmer, William, junior, of Henley on Thames, capper 0
3708831 1929059 1929059 plaintiff Pate John (legal representative) 587336 587336 Pate, John, of Henley on Thames, yeoman, executors of 0
3708835 1929059 1929059 defendant Lawren Henry fuller 587336 587336 Lawren, Henry, of Henley on Thames, fuller 1
3708838 1929060 1929060 plaintiff Pate John (legal representative) 587336 587336 Pate, John, of Henley on Thames, yeoman, executors of 0
3708842 1929060 1929060 defendant Lawren Henry fuller 587336 587336 Lawren, Henry, of Henley on Thames, fuller 1
3708845 1929061 1929061 plaintiff Pate John (legal representative) 587336 587336 Pate, John, of Henley on Thames, yeoman, executors of 0
3708851 1929062 1929062 plaintiff Pate John (legal representative) 587336 587336 Pate, John, of Henley on Thames, yeoman, executors of 0
3708854 1929062 1929062 defendant Oldman Thomas fuller 587336 587336 Oldman, Thomas, of Henley on Thames, fuller 0
3709816 1929386 1929386 defendant Alsoppe Thomas dyer 587336 587336 Alsoppe, Thomas, of Henley on Thames, dyer 0
3711985 1930066 1930066 defendant Foster William capper 587336 587336 Foster, William, of Henley on Thames, capper 0
3715133 1931029 1931029 plaintiff Brokham Richard butcher 587336 587336 Brokham, Richard, of Henley on Thames, butcher 0
3715135 1931029 1931029 defendant Gybbyns Peter cooper 587336 587336 Gybbyns, Peter, of Henley on Thames, cooper 1
3715136 1931029 1931029 defendant Harry Robert butcher 587336 587336 Harry, Robert, of Henley on Thames, butcher 2
3724516 1933953 1933953 defendant Chypney Richard tanner 587336 587336 Chypney, Richard, of Henley on Thames, tanner 1
3726355 1934512 1934512 defendant Stokeley Nicholas cooper 587336 587336 Stokeley, Nicholas, of Henley on Thames, cooper 0
3727462 1934865 1934865 defendant Myllyngton alias Strong Robert butcher 587336 587336 Myllyngton alias Strong, Robert, of Henley on Thames, butcher 0
3729700 1935542 1935542 defendant Haywode John roper 587336 587336 Haywode, John, of Henley on Thames, roper 0
3730444 1935753 1935753 defendant Wellyng Robert butcher 587336 587336 Wellyng, Robert, of Henley on Thames, butcher 0
3730446 1935753 1935753 defendant Thompson John butcher 587336 587336 Thompson, John, of Henley on Thames, butcher 2
3730448 1935753 1935753 defendant Myllyngton Robert butcher 587336 587336 Myllyngton, Robert, of Henley on Thames, butcher 4
3733212 1936620 1936620 defendant Wollen alias Bocher Robert butcher 587336 587336 Wollen alias Bocher, Robert, of Henley on Thames, butcher 0
3734372 1936989 1936989 defendant Harrys Robert butcher 587336 587336 Harrys, Robert, of Henley on Thames, butcher 0
3734373 1936989 1936989 defendant Wellyn Robert butcher 587336 587336 Wellyn, Robert, of Henley on Thames, butcher 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);