names

139 rows where place_id = 595515

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620807 1874077 1874077 defendant Fenton Thomas yeoman 595515 595515 Fenton, Thomas, of Fenton, yeoman 2
3627494 1903457 1903457 defendant Gybbys William esq 595515 595515 Gybbys, William, of Fenton, esq 0
3644536 1908708 1908708 defendant Fenton Thomas   595515 595515 Fenton, Thomas, of Fenton 0
3658553 1912928 1912928 plaintiff Fenton Thomas   595515 595515 Fenton, Thomas, of Fenton 0
3667605 1915811 1915811 plaintiff Wybill William husbandman 595515 595515 Wybill, William, of Fenton, husbandman 0
3674962 1918200 1918200 defendant Gybbys William esq 595515 595515 Gybbys, William, of Fenton, esq 0
3674963 1918200 1918200 defendant Gybbys Thomas esq 595515 595515 Gybbys, Thomas, of Fenton, esq 1
3692529 1923850 1923850 defendant Lanson Robert husbandman 595515 595515 Lanson, Robert, of Fenton, husbandman 0
3692530 1923850 1923850 defendant Duffeld William husbandman 595515 595515 Duffeld, William, of Fenton, husbandman 1
3692531 1923850 1923850 defendant Wright Robert laborer 595515 595515 Wright, Robert, of Fenton, laborer 2
3694962 1924635 1924635 defendant Gybbes William esq 595515 595515 Gybbes, William, of Fenton, esq 0
3702402 1927010 1927010 defendant Hopton Thomas yeoman 595515 595515 Hopton, Thomas, of Fenton, yeoman 1
3702403 1927010 1927010 defendant Barker William yeoman 595515 595515 Barker, William, of Fenton, yeoman 2
3719036 1932230 1932230 defendant Berker William yeoman 595515 595515 Berker, William, of Fenton, yeoman 0
3719038 1932230 1932230 defendant Berker John yeoman 595515 595515 Berker, John, of Fenton, yeoman 2
3733573 1936744 1936744 defendant Twyvell William husbandman 595515 595515 Twyvell, William, of Fenton, husbandman 0
3733574 1936744 1936744 defendant Styrton Thomas husbandman 595515 595515 Styrton, Thomas, of Fenton, husbandman 1
3734802 1937131 1937131 defendant Barker William   595515 595515 Barker, William, of Fenton yeoman 0
3734804 1937131 1937131 defendant Baker John yeoman 595515 595515 Baker, John, of Fenton, yeoman 2
3743299 1939775 1939775 defendant Gybbis William esq 595515 595515 Gybbis, William, of Fenton, esq 0
3747652 1941185 1941185 defendant Eyton Richard husbandman 595515 595515 Eyton, Richard, of Fenton, husbandman 0
3747653 1941185 1941185 defendant Eyton William husbandman 595515 595515 Eyton, William, of Fenton, husbandman 1
3759304 1944898 1944898 defendant Gibbes William esq 595515 595515 Gibbes, William, of Fenton, esq 0
3769307 1948055 1948055 defendant Gybbys Thomas esq 595515 595515 Gybbys, Thomas, of Fenton, esq 0
3772684 1949150 1949150 defendant Lynne Thomas gent 595515 595515 (Lynne, Thomas, of Fenton, gent 1
3778263 1950912 1950912 defendant Alger Philip husbandman 595515 595515 Alger, Philip, of Fenton, husbandman 0
3787153 1953772 1953772 defendant Gybbys Thomas esq 595515 595515 Gybbys, Thomas, of Fenton, esq 0
3793322 1955772 1955772 defendant Gybbes Thomas gent 595515 595515 Gybbes, Thomas, of Fenton, gent 0
3794966 1956289 1956289 defendant Reche Robert yeoman 595515 595515 Reche, Robert, of Fenton, yeoman 0
3797463 1957094 1957094 defendant Reche Robert husbandman 595515 595515 Reche, Robert, of Fenton, husbandman 0
3799117 1957633 1957633 defendant Gybbes Thomas gent 595515 595515 Gybbes, Thomas, of Fenton, gent 0
3800624 1958107 1958107 defendant Abram Richard husbandman 595515 595515 Abram, Richard, of Fenton, husbandman 0
3802559 1958696 1958696 defendant Lynne Thomas gent 595515 595515 Lynne, Thomas, of Fenton, gent 0
3803409 1958967 1958967 defendant Gilbys alias Gibbes Thomas esq 595515 595515 Gilbys alias Gibbes, Thomas, of Fenton, esq 0
3810144 1961063 1961063 defendant Gybbes Thomas gent 595515 595515 Gybbes, Thomas, of Fenton, gent 0
3810145 1961063 1961063 defendant Gybbes William gent 595515 595515 Gybbes, William, of Fenton, gent 1
3834030 1968584 1968584 defendant Barker William husbandman 595515 595515 Barker, William, of Fenton, husbandman 0
3834034 1968584 1968584 defendant Atkynson William yeoman 595515 595515 Atkynson, William, of Fenton, yeoman 4
3838530 1969975 1969975 defendant Gibbes Thomas esq 595515 595515 Gibbes, Thomas, of Fenton, esq 0
3840697 1970655 1970655 defendant German Richard yeoman 595515 595515 German, Richard, of Fenton, yeoman 1
3854730 1975129 1975129 defendant Gybbes Thomas esq 595515 595515 Gybbes, Thomas, of Fenton, esq 0
3869078 1979903 1979903 defendant Gybbes Thomas esq 595515 595515 Gybbes, Thomas, of Fenton, esq 0
3870657 1980428 1980428 defendant Robenet William husbandman 595515 595515 Robenet, William, of Fenton, husbandman 0
3882934 1984557 1984557 defendant Gybbys Thomas esq 595515 595515 Gybbys, Thomas, of Fenton, esq 0
3902981 1991226 1991226 defendant Gybbes William esq 595515 595515 Gybbes, William, of Fenton, esq 0
3925590 1998872 1998872 defendant Gybbes Thomas esq 595515 595515 Gybbes, Thomas, of Fenton, esq 0
3926843 1999310 1999310 defendant Vyse Thomas yeoman 595515 595515 Vyse, Thomas, of Fenton, yeoman 1
3929083 2000067 2000067 defendant Post Thomas husbandman 595515 595515 Post, Thomas, of Fenton, husbandman 0
3969230 2013848 2013848 defendant Beverley James gent 595515 595515 Beverley, James, of Fenton, gent 0
4137665 2073824 2073824 defendant Stedes John husbandman 595515 595515 Stedes, John, of Fenton, husbandman 0
4139947 2074652 2074652 defendant Wheatley William   595515 595515 Wheatley, William, of Fenton, husbandman, "cif" or sieve maker 0
4149536 2077964 2077964 defendant Newbye Edward gent 595515 595515 Newbye, Edward, of Fenton, gent 1
4149537 2077964 2077964 defendant Byrke Charles clerk 595515 595515 Byrke, Charles, of Fenton, clerk 2
4160091 2081594 2081594 defendant Morrett John husbandman 595515 595515 Morrett, John, of Fenton, husbandman 0
4293508 2127741 2127741 defendant Elliott Robert blacksmith 595515 595515 Elliott, Robert, of Fenton, blacksmith 0
4293509 2127741 2127741 defendant Pattinson Thomas husbandman 595515 595515 Pattinson, Thomas, of Fenton, husbandman 1
4347249 2146297 2146297 defendant Powlter Kenelm yeoman 595515 595515 Powlter, Kenelm, of Fenton, yeoman 0
4347250 2146297 2146297 defendant Slade John yeoman 595515 595515 Slade, John, of Fenton, yeoman 1
4347251 2146297 2146297 defendant Bushe Mathew yeoman 595515 595515 Bushe, Mathew, of Fenton, yeoman 2
4347252 2146297 2146297 defendant Rosse Thomas yeoman 595515 595515 Rosse, Thomas, of Fenton, yeoman 3
4364672 2152423 2152423 defendant Lucas Peter (legal representative) 595515 595515 Lucas, Peter, of Fenton, esq, administrator of 0
4364673 2152423 2152423 defendant Lucas Brian esq 595515 595515 Lucas, Brian, of Fenton, esq 1
4375827 2156415 2156415 defendant Lucas Brian esq 595515 595515 Lucas, Brian, of Fenton, esq 0
4375828 2156415 2156415 defendant Thorpe John yeoman 595515 595515 Thorpe, John, of Fenton, yeoman 1
4393837 2162540 2162540 defendant Poulter Kenelm clerk 595515 595515 Poulter, Kenelm, of Fenton, clerk 0
4427579 2173461 2173461 plaintiff Scut Adam   595515 595515 Scut, Adam, of Fenton, son of John 0
4427580 2173461 2173461 defendant atte Halle Alesia   595515 595515 atte Halle, Alesia, of Fenton, formerly wife of John 0
4427582 2173461 2173461 defendant atte Grene John   595515 595515 atte Grene, John, of Fenton 2
4427583 2173461 2173461 defendant Long Alice le   595515 595515 Long, Alice le, of Fenton 3
4427585 2173462 2173462 defendant Upton John de   595515 595515 Upton, John de, of Fenton 0
4520248 2206673 2206673 defendant Gybonson Hardulphus   595515 595515 Gybonson, Hardulphus, of Fenton 0
4520631 2206802 2206802 plaintiff Forester John   595515 595515 Forester, John, of Fenton 0
4520632 2206802 2206802 defendant Gibson Ralph   595515 595515 Gibson, Ralph, of Fenton 0
4521726 2207128 2207128 plaintiff Gibbes William   595515 595515 Gibbes, William, of Fenton 0
4522715 2207441 2207441 plaintiff Gybbes William   595515 595515 Gybbes, William, of Fenton 0
4527155 2208777 2208777 defendant Couper John   595515 595515 Couper, John, of Fenton 2
4536994 2211839 2211839 defendant Payn William   595515 595515 Payn, William, of Fenton 1
4549164 2215676 2215676 defendant Hele John merchant 595515 595515 Hele, John, of Fenton, merchant 0
4585255 2226812 2226812 defendant Hopkynson William   595515 595515 Hopkynson, William, of Fenton 4
4597185 2230360 2230360 plaintiff Seme Robert   595515 595515 Seme, Robert, of Fenton 0
4623763 2238409 2238409 plaintiff Milner John   595515 595515 Milner, John, of Fenton 0
4631889 2240858 2240858 plaintiff Totty John   595515 595515 Totty, John, of Fenton 0
4651457 2246460 2246460 defendant del Gille John yeoman 595515 595515 del Gille, John, of Fenton, yeoman 2
4663083 2249918 2249918 defendant Otur John gent 595515 595515 Otur, John, of Fenton, gent 0
4679814 2259297 2259297 plaintiff Lambe John   595515 595515 Lambe, John, of Fenton 0
4691248 2262783 2262783 plaintiff Wylburdon John   595515 595515 Wylburdon, John, of Fenton, on his own account 0
4726643 2273604 2273604 defendant Wilberdon John butcher 595515 595515 (Wilberdon, John, of Fenton, butcher 1
4726644 2273604 2273604 defendant Steert Joan widow 595515 595515 Steert, Joan, of Fenton, widow 2
4731266 2274979 2274979 defendant Chaumbir Robert tailor 595515 595515 Chaumbir, Robert, of Fenton, tailor 0
4733599 2275684 2275684 defendant Mone William husbandman 595515 595515 Mone, William, of Fenton, husbandman 1
4734123 2275856 2275856 defendant Wylberdon John butcher 595515 595515 Wylberdon, John, of Fenton, butcher 1
4736907 2276671 2276671 defendant Hyndeley Agnes   595515 595515 Hyndeley, Agnes, of Fenton, widow, formerly wife of John Hyndeley, of York 0
4741593 2278037 2278037 defendant Fenton Nicholas husbandman 595515 595515 Fenton, Nicholas, of Fenton, husbandman 0
4750873 2280738 2280738 defendant Willerdon John butcher 595515 595515 Willerdon, John, of Fenton, butcher 3
4753234 2281396 2281396 defendant Hopkynson William husbandman 595515 595515 Hopkynson, William, of Fenton, husbandman 0
4773896 2287814 2287814 defendant Forster William husbandman 595515 595515 Forster, William, of Fenton, husbandman 2
4796015 2294902 2294902 defendant Crey John husbandman 595515 595515 Crey, John, of Fenton, husbandman 2
4799328 2295965 2295965 defendant Forster William husbandman 595515 595515 Forster, William, of Fenton, husbandman 2
4812340 2299974 2299974 plaintiff Gybbys William (legal representative) 595515 595515 Gybbys, William, of Fenton, executor of 0
4833435 2306463 2306463 defendant Halle Thomas husbandman 595515 595515 Halle, Thomas, of Fenton, husbandman 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);