names

332 rows where place_id = 590152

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600087 1867677 1867677 defendant Middelton Brian gent 590152 590152 Middelton, Brian, of Clyfton, gent 0
3615341 1872442 1872442 defendant Soper Humphrey husbandman 590152 590152 Soper, Humphrey, of Clyfton, husbandman 0
3616052 1872655 1872655 defendant Wybar Thomas gent 590152 590152 Wybar, Thomas, of Clyfton, gent 0
3616053 1872655 1872655 defendant Wybar William gent 590152 590152 Wybar, William, of Clyfton, gent 1
3616054 1872655 1872655 defendant Thwaytes Henry yeoman 590152 590152 Thwaytes, Henry, of Clyfton, yeoman 2
3616055 1872655 1872655 defendant Halyday John yeoman 590152 590152 Halyday, John, of Clyfton, yeoman 3
3617510 1873097 1873097 defendant Wybar William gent 590152 590152 Wybar, William, of Clyfton, gent 2
3628569 1903808 1903808 defendant Hilton William husbandman 590152 590152 Hilton, William, of Clyfton, husbandman 0
3630927 1904493 1904493 defendant Hylton William husbandman 590152 590152 Hylton, William, of Clyfton, husbandman 0
3636179 1906103 1906103 defendant Kendall John gent 590152 590152 Kendall, John, of Clyfton, gent 0
3665530 1915170 1915170 defendant Studysbury John husbandman 590152 590152 Studysbury, John, of Clyfton, husbandman 3
3672000 1917242 1917242 defendant Godyng John tailor 590152 590152 Godyng, John, of Clyfton, tailor 0
3672002 1917242 1917242 defendant Taillour Ibota spinster 590152 590152 Taillour, Ibota, of Clyfton, spinster 2
3674498 1918074 1918074 defendant Dryfeld Thomas husbandman 590152 590152 Dryfeld, Thomas, of Clyfton, husbandman 0
3674502 1918075 1918075 defendant Dryseley Thomas husbandman 590152 590152 Dryseley, Thomas, of Clyfton, husbandman 0
3674506 1918076 1918076 defendant Dryfeld Thomas husbandman 590152 590152 Dryfeld, Thomas, of Clyfton, husbandman 0
3678619 1919372 1919372 defendant Gosson John husbandman 590152 590152 Gosson, John, of Clyfton, husbandman 1
3684165 1921183 1921183 plaintiff Wood William   590152 590152 Wood, William, of Clyfton, 0
3688400 1922529 1922529 defendant Hopkyns Alice widow 590152 590152 Hopkyns, Alice, of Clyfton, widow 1
3702842 1927162 1927162 plaintiff Constable John esq 590152 590152 Constable, John, of Clyfton, esq 0
3703738 1927449 1927449 defendant Loryng William husbandman 590152 590152 Loryng, William, of Clyfton, husbandman 1
3704432 1927682 1927682 defendant Bromham John, junior husbandman 590152 590152 Bromham, John, junior, of Clyfton, husbandman 3
3704433 1927682 1927682 defendant Bromham John, senior husbandman 590152 590152 Bromham, John, senior, of Clyfton, husbandman 4
3728398 1935127 1935127 defendant Bromeham John, junior husbandman 590152 590152 Bromeham, John, junior, of Clyfton, husbandman 0
3735118 1937225 1937225 defendant Whyte William husbandman 590152 590152 Whyte, William, of Clyfton, husbandman 0
3738206 1938163 1938163 defendant Spore William   590152 590152 Spore, William, of Clyfton 0
3740517 1938893 1938893 defendant Peny Thomas laborer 590152 590152 Peny, Thomas, of Clyfton, laborer 2
3745793 1940588 1940588 defendant Horselay Agnes widow 590152 590152 Horselay, Agnes, of Clyfton, widow 1
3745794 1940588 1940588 defendant Horselay Thomas husbandman 590152 590152 Horselay, Thomas, of Clyfton, husbandman 2
3746032 1940664 1940664 defendant Acton John   590152 590152 Acton, John, of Clyfton 1
3753281 1942965 1942965 defendant Horseley Hugh husbandman 590152 590152 Horseley, Hugh, of Clyfton, husbandman 0
3753282 1942965 1942965 defendant Horseley Agnes spinster 590152 590152 Horseley, Agnes, of Clyfton, spinster 1
3753283 1942965 1942965 defendant Horseley Joan widow 590152 590152 Horseley, Joan, of Clyfton, widow 2
3753284 1942965 1942965 defendant Horseley Margaret spinster 590152 590152 Horseley, Margaret, of Clyfton, spinster 3
3758077 1944510 1944510 defendant Whyte William husbandman 590152 590152 Whyte, William, of Clyfton, husbandman 1
3772837 1949197 1949197 defendant Cooke John husbandman 590152 590152 Cooke, John, of Clyfton, husbandman 0
3780538 1951643 1951643 defendant Coke Simon husbandman 590152 590152 Coke, Simon, of Clyfton, husbandman 0
3785112 1953131 1953131 defendant Whyte William husbandman 590152 590152 Whyte, William, of Clyfton, husbandman 0
3788410 1954175 1954175 plaintiff Somer John husbandman 590152 590152 Somer, John, of Clyfton, husbandman 0
3790591 1954880 1954880 defendant Acton John   590152 590152 Acton, John, of Clyfton 1
3790593 1954881 1954881 defendant Tuttesbury Thomas yeoman 590152 590152 Tuttesbury, Thomas, of Clyfton, yeoman 0
3790594 1954881 1954881 defendant Kyng William yeoman 590152 590152 Kyng, William, of Clyfton, yeoman 1
3793774 1955917 1955917 defendant Hawkyns Thomas husbandman 590152 590152 Hawkyns, Thomas, of Clyfton, husbandman 0
3794989 1956296 1956296 defendant Forde William carpenter 590152 590152 Forde, William, of Clyfton, carpenter 0
3795808 1956555 1956555 defendant Horseley Thomas husbandman 590152 590152 Horseley, Thomas, of Clyfton, husbandman 0
3795809 1956555 1956555 defendant Horseley Agnes widow 590152 590152 Horseley, Agnes, of Clyfton, widow 1
3796812 1956883 1956883 defendant Dyson Richard husbandman 590152 590152 Dyson, Richard, of Clyfton, husbandman 1
3814432 1962428 1962428 plaintiff Fyssher John gent 590152 590152 Fyssher, John, of Clyfton, gent 0
3816416 1963044 1963044 defendant Iveson William husbandman 590152 590152 Iveson, William, of Clyfton, husbandman 0
3816912 1963197 1963197 defendant Kynyet John husbandman 590152 590152 Kynyet, John, of Clyfton, husbandman 0
3817879 1963508 1963508 defendant Clyfton Roger gent 590152 590152 Clyfton, Roger, of Clyfton, gent 0
3825580 1965852 1965852 defendant Kympe John, senior gent 590152 590152 Kympe, John, senior, of Clyfton, gent 0
3825581 1965852 1965852 defendant Kympe John, junior gent 590152 590152 Kympe, John, junior, of Clyfton, gent 1
3835534 1969053 1969053 defendant Sutton John husbandman 590152 590152 Sutton, John, of Clyfton, husbandman 0
3846583 1972484 1972484 defendant Sondesbury John yeoman 590152 590152 Sondesbury, John, of Clyfton, yeoman 9
3856244 1975573 1975573 defendant Orchard Richard husbandman 590152 590152 Orchard, Richard, of Clyfton, husbandman 0
3878217 1982962 1982962 defendant Coke John yeoman 590152 590152 Coke, John, of Clyfton, yeoman 1
3880648 1983793 1983793 defendant Sayvell Thomas gent 590152 590152 Sayvell, Thomas, of Clyfton, gent 0
3881242 1983995 1983995 defendant Wryght Edward clerk 590152 590152 Wryght, Edward, of Clyfton, clerk 0
3881243 1983995 1983995 defendant Bocher John laborer 590152 590152 Bocher, John, of Clyfton, laborer 1
3881244 1983995 1983995 defendant Hubbold William laborer 590152 590152 Hubbold, William, of Clyfton, laborer 2
3886667 1985794 1985794 defendant Webbe John weaver 590152 590152 Webbe, John, of Clyfton, weaver 0
3887099 1985948 1985948 defendant Somer John husbandman 590152 590152 Somer, John, of Clyfton, husbandman 0
3894810 1988470 1988470 plaintiff Sayvell Thomas gent 590152 590152 Sayvell, Thomas, of Clyfton, gent 0
3901147 1990609 1990609 defendant Somer John husbandman 590152 590152 Somer, John, of Clyfton, husbandman 0
3915941 1995711 1995711 defendant Boradall William yeoman 590152 590152 Boradall, William, of Clyfton, yeoman: Wathe, Geoffrey, of Clyfton, yeoman 0
3915942 1995711 1995711 defendant Wylson Thomas yeoman 590152 590152 Wylson, Thomas, of Clyfton, yeoman 1
3925075 1998702 1998702 defendant Haldesworth Richard (legal representative) 590152 590152 Haldesworth, Richard, of Clyfton, smith, executors of 0
3925076 1998702 1998702 defendant Haldysworth James yeoman 590152 590152 (Haldysworth, James, of Clyfton, yeoman 1
3931862 2000955 2000955 defendant Cowper William yeoman 590152 590152 Cowper, William, of Clyfton, yeoman 0
3948485 2006535 2006535 defendant Lyddall Thomas husbandman 590152 590152 Lyddall, Thomas, of Clyfton, husbandman 0
3951781 2007683 2007683 defendant Bysshop John husbandman 590152 590152 Bysshop, John, of Clyfton, husbandman 3
3957355 2009636 2009636 defendant Horsey John   590152 590152 Horsey, John, of Clyfton, knight 0
3957357 2009637 2009637 defendant Horsey John   590152 590152 Horsey, John, of Clyfton, knight 0
3969188 2013832 2013832 defendant Careless Thomas husbandman 590152 590152 Careless, Thomas, of Clyfton, husbandman 0
4002537 2025675 2025675 defendant Smyth Richard   590152 590152 Smyth, Richard, of Clyfton, wheelwright 0
4002538 2025675 2025675 defendant Harryson John laborer 590152 590152 Harryson, John, of Clyfton, laborer 1
4002539 2025675 2025675 defendant Burton Hugh husbandman 590152 590152 Burton, Hugh, of Clyfton, husbandman 2
4007339 2027407 2027407 defendant Tryppett Nicholas fuller 590152 590152 Tryppett, Nicholas, of Clyfton, fuller 0
4022684 2032836 2032836 defendant Barton Thomas blacksmith 590152 590152 Barton, Thomas, of Clyfton, blacksmith 2
4022685 2032836 2032836 defendant Steven alias Stepkyn Edmund husbandman 590152 590152 Steven alias Stepkyn, Edmund, of Clyfton, husbandman 3
4022688 2032837 2032837 defendant Barton James husbandman 590152 590152 Barton, James, of Clyfton, husbandman 1
4022689 2032837 2032837 defendant Steven alias Stepkyn Edmund husbandman 590152 590152 Steven alias Stepkyn, Edmund, of Clyfton, husbandman 2
4022690 2032837 2032837 defendant Ratclyff Richard husbandman 590152 590152 Ratclyff, Richard, of Clyfton, husbandman 3
4022691 2032837 2032837 defendant Bageley Richard husbandman 590152 590152 Bageley, Richard, of Clyfton, husbandman 4
4022692 2032837 2032837 defendant Palmer Lawrence laborer 590152 590152 Palmer, Lawrence, of Clyfton, laborer 5
4086022 2055275 2055275 defendant Arrundell Thomas (legal representative) 590152 590152 Arrundell, Thomas, of Clyfton, esq, executors of 0
4086023 2055275 2055275 defendant Arrundell Alexander esq 590152 590152 (Arrundell, Alexander, of Clyfton, esq 1
4086024 2055275 2055275 defendant Arrundell Thomasone widow 590152 590152 Arrundell, Thomasone, of Clyfton, widow 2
4108573 2063321 2063321 defendant Jones William yeoman 590152 590152 Jones, William, of Clyfton, yeoman 0
4110764 2064108 2064108 defendant Arundell Thomas gent 590152 590152 Arundell, Thomas, of Clyfton, gent 0
4130946 2071380 2071380 defendant Horsley Hanibal gent 590152 590152 Horsley, Hanibal, of Clyfton, gent 0
4149338 2077894 2077894 defendant Lyte John gent 590152 590152 Lyte, John, of Clyfton, gent 0
4151633 2078685 2078685 defendant Kookes William yeoman 590152 590152 Kookes, William, of Clyfton, yeoman 1
4160867 2081874 2081874 defendant Lynwood Robert husbandman 590152 590152 Lynwood, Robert, of Clyfton, husbandman 0
4168730 2084553 2084553 defendant Pyers Edward yeoman 590152 590152 Pyers, Edward, of Clyfton, yeoman 0
4170630 2085229 2085229 defendant Lynewood Robert yeoman 590152 590152 Lynewood, Robert, of Clyfton, yeoman 0
4209140 2098745 2098745 defendant Pettye John Beds, blacksmith 590152 590152 Pettye John, of Clyfton, Beds, blacksmith 1
4210896 2099372 2099372 defendant Cassye John gent 590152 590152 Cassye, John, of Clyfton, gent 0
4296854 2128974 2128974 defendant Kynnett John yeoman 590152 590152 Kynnett, John, of Clyfton, yeoman 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);