names

380 rows where place_id = 588663

✎ 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
3588224 1863971 1863971 defendant Burton Robert (legal representative) 588663 588663 Burton, Robert, of Tylney, administrator of 0
3595212 1866136 1866136 defendant Nele John, junior yeoman 588663 588663 Nele, John, junior, of Tylney, yeoman 0
3595476 1866220 1866220 defendant Reed Thomas husbandman 588663 588663 Reed, Thomas, of Tylney, husbandman 0
3595478 1866220 1866220 defendant Palmer Thomas husbandman 588663 588663 Palmer, Thomas, of Tylney, husbandman 2
3597468 1866828 1866828 defendant Baldyng Richard husbandman 588663 588663 Baldyng, Richard, of Tylney, husbandman 0
3597470 1866829 1866829 defendant Baldyng Richard husbandman 588663 588663 Baldyng, Richard, of Tylney, husbandman 0
3613611 1871902 1871902 defendant Hewesson Peter husbandman 588663 588663 Hewesson, Peter, of Tylney, husbandman 0
3613612 1871902 1871902 defendant Baldyng William chaplain 588663 588663 Baldyng, William, of Tylney, chaplain 1
3613613 1871902 1871902 defendant Eme John husbandman 588663 588663 Eme, John, of Tylney, husbandman 2
3613614 1871902 1871902 defendant Cobbe David husbandman 588663 588663 Cobbe, David, of Tylney, husbandman 3
3613615 1871902 1871902 defendant Cuttyng Richard husbandman 588663 588663 Cuttyng, Richard, of Tylney, husbandman 4
3621386 1874229 1874229 defendant Launde Robert husbandman 588663 588663 Launde, Robert, of Tylney, husbandman 0
3630041 1904243 1904243 defendant Mower Thomas husbandman 588663 588663 Mower, Thomas, of Tylney, husbandman 0
3630061 1904248 1904248 defendant Mower Thomas husbandman 588663 588663 Mower, Thomas, of Tylney, husbandman 0
3631764 1904743 1904743 defendant Lany Thomas husbandman 588663 588663 Lany, Thomas, of Tylney, husbandman 0
3644152 1908604 1908604 defendant Halyday John husbandman 588663 588663 Halyday, John, of Tylney, husbandman 0
3648504 1909932 1909932 defendant Smyth Robert husbandman 588663 588663 Smyth, Robert, of Tylney, husbandman 0
3648698 1909980 1909980 defendant Cobbe David husbandman 588663 588663 Cobbe, David, of Tylney, husbandman 0
3650189 1910428 1910428 defendant Ladde John husbandman 588663 588663 Ladde, John, of Tylney, husbandman 0
3650190 1910428 1910428 defendant Nell William husbandman 588663 588663 Nell, William, of Tylney, husbandman 1
3653786 1911442 1911442 defendant Lany Thomas husbandman 588663 588663 Lany, Thomas, of Tylney, husbandman 1
3653787 1911442 1911442 defendant Lany Robert husbandman 588663 588663 Lany, Robert, of Tylney, husbandman 2
3658768 1912998 1912998 defendant Baldyng John husbandman 588663 588663 Baldyng, John, of Tylney, husbandman 1
3661529 1913878 1913878 defendant Walden Robert husbandman 588663 588663 Walden, Robert, of Tylney, husbandman 0
3664575 1914874 1914874 defendant Saye Nicholas (legal representative) 588663 588663 Saye, Nicholas, of Tylney, husbandman, executor of 0
3664576 1914874 1914874 defendant Middleton Geoffrey   588663 588663 Middleton, Geoffrey, of Tylney 1
3672518 1917407 1917407 defendant Jacon Geoffrey smith 588663 588663 Jacon, Geoffrey, of Tylney, smith 1
3672525 1917408 1917408 defendant Wright William husbandman 588663 588663 Wright, William, of Tylney, husbandman 3
3680104 1919844 1919844 defendant Crane Thomas husbandman 588663 588663 Crane, Thomas, of Tylney, husbandman 1
3681593 1920334 1920334 defendant Waleyn Robert husbandman 588663 588663 Waleyn, Robert, of Tylney, husbandman 0
3703310 1927308 1927308 defendant Elver John husbandman 588663 588663 Elver, John, of Tylney, husbandman 2
3711535 1929919 1929919 defendant Nicholl Humphrey husbandman 588663 588663 Nicholl, Humphrey, of Tylney, husbandman 2
3711536 1929919 1929919 defendant Coke John husbandman 588663 588663 Coke, John, of Tylney, husbandman 3
3719229 1932299 1932299 defendant Nele Richard (legal representative) 588663 588663 Nele, Richard, of Tylney, gent, executors of 2
3719230 1932299 1932299 defendant Wylloughby John gent 588663 588663 (Wylloughby, John, of Tylney, gent 3
3726437 1934537 1934537 defendant Nelle Richard (legal representative) 588663 588663 Nelle, Richard, of Tylney, executors of 0
3726438 1934537 1934537 defendant Wylloughby John gent 588663 588663 (Wylloughby, John, of Tylney, gent 1
3726440 1934538 1934538 defendant Nelle Richard (legal representative) 588663 588663 Nelle, Richard, of Tylney, executors of 0
3726441 1934538 1934538 defendant Wylloughby John gent 588663 588663 (Wylloughby, John, of Tylney, gent 1
3728833 1935265 1935265 defendant Goolde Edmund husbandman 588663 588663 Goolde, Edmund, of Tylney, husbandman 0
3732221 1936315 1936315 defendant Wasy Gilbert yeoman 588663 588663 Wasy, Gilbert, of Tylney, yeoman 0
3742811 1939605 1939605 defendant Boston alias Tyler Thomas husbandman 588663 588663 Boston alias Tyler, Thomas, of Tylney, husbandman 0
3748318 1941403 1941403 defendant Halle Robert husbandman 588663 588663 Halle, Robert, of Tylney, husbandman 1
3750148 1941961 1941961 defendant Mower John husbandman 588663 588663 Mower, John, of Tylney, husbandman 0
3750149 1941961 1941961 defendant Tayllour John husbandman 588663 588663 Tayllour, John, of Tylney, husbandman 1
3754446 1943348 1943348 defendant Nele Richard (legal representative) 588663 588663 Nele, Richard, of Tylney, gent, executors of 0
3768894 1947921 1947921 defendant Elwyn Thomas gent 588663 588663 Elwyn, Thomas, of Tylney, gent 0
3768895 1947921 1947921 defendant Gold Edmund husbandman 588663 588663 Gold, Edmund, of Tylney, husbandman 1
3772855 1949204 1949204 defendant Wake John tailor 588663 588663 Wake, John, of Tylney, tailor 1
3780277 1951561 1951561 defendant Gawsell Thomas gent 588663 588663 Gawsell, Thomas, of Tylney, gent 0
3787551 1953897 1953897 defendant Cotton Gilbert gent 588663 588663 Cotton, Gilbert, of Tylney, gent 0
3787884 1954001 1954001 defendant Brown John carpenter 588663 588663 Brown, John, of Tylney, carpenter 0
3792245 1955428 1955428 defendant Wryght William husbandman 588663 588663 Wryght, William, of Tylney, husbandman 1
3800255 1958000 1958000 defendant Pelham William (legal representative) 588663 588663 Pelham, William, of Tylney, husbandman, executor of 0
3800256 1958000 1958000 defendant Lacy Richard yeoman 588663 588663 Lacy, Richard, of Tylney, yeoman 1
3831414 1967712 1967712 defendant Hakerd Walter husbandman 588663 588663 Hakerd, Walter, of Tylney, husbandman 0
3831415 1967712 1967712 defendant Hakerd Nicholas tailor 588663 588663 Hakerd, Nicholas, of Tylney, tailor 1
3831418 1967712 1967712 defendant Hakerd John tailor 588663 588663 Hakerd, John, of Tylney, tailor 4
3857211 1975888 1975888 defendant Smythe William laborer 588663 588663 Smythe, William, of Tylney, laborer 2
3857213 1975889 1975889 defendant Stedman Thomas husbandman 588663 588663 Stedman, Thomas, of Tylney, husbandman 0
3862298 1977577 1977577 defendant Farthyng John husbandman 588663 588663 Farthyng, John, of Tylney, husbandman 1
3862436 1977630 1977630 defendant Edwarde John husbandman 588663 588663 Edwarde, John, of Tylney, husbandman 3
3868869 1979830 1979830 defendant Crysteyne John carpenter 588663 588663 Crysteyne, John, of Tylney, carpenter 1
3868870 1979830 1979830 defendant Wake John draper 588663 588663 Wake, John, of Tylney, draper 2
3868871 1979830 1979830 defendant Browne Edward husbandman 588663 588663 Browne, Edward, of Tylney, husbandman 3
3873505 1981354 1981354 plaintiff Carter Thomas yeoman 588663 588663 Carter, Thomas, of Tylney, yeoman 0
3882654 1984464 1984464 defendant Crysteyn John carpenter 588663 588663 Crysteyn, John, of Tylney, carpenter 1
3882655 1984464 1984464 defendant Wake John draper 588663 588663 Wake, John, of Tylney, draper 2
3882656 1984464 1984464 defendant Browne Edward husbandman 588663 588663 Browne, Edward, of Tylney, husbandman 3
3889757 1986810 1986810 defendant Saye Robert gent 588663 588663 Saye, Robert, of Tylney, gent 0
3890344 1987019 1987019 defendant Fraunceys Thomas husbandman 588663 588663 Fraunceys, Thomas, of Tylney, husbandman 0
3892006 1987577 1987577 defendant Saye Robert gent 588663 588663 Saye, Robert, of Tylney, gent 0
3904833 1991880 1991880 defendant Howson Richard husbandman 588663 588663 Howson, Richard, of Tylney, husbandman 1
3907077 1992654 1992654 defendant Noreys Thomas husbandman 588663 588663 Noreys, Thomas, of Tylney, husbandman 0
3910221 1993732 1993732 defendant Haward William husbandman 588663 588663 Haward, William, of Tylney, husbandman 0
3912557 1994530 1994530 defendant Stede Thomas husbandman 588663 588663 Stede, Thomas, of Tylney, husbandman 3
3916673 1995947 1995947 defendant Say Robert gent 588663 588663 Say, Robert, of Tylney, gent 0
3916674 1995947 1995947 defendant Say Richard yeoman 588663 588663 Say, Richard, of Tylney, yeoman 1
3916675 1995947 1995947 defendant Crane John yeoman 588663 588663 Crane, John, of Tylney, yeoman 2
3917141 1996094 1996094 defendant Wryght William husbandman 588663 588663 Wryght, William, of Tylney, husbandman 3
3917480 1996204 1996204 defendant Lynse William   588663 588663 Lynse, William, of Tylney, shepherd 0
3927689 1999598 1999598 defendant Sprewe John husbandman 588663 588663 Sprewe, John, of Tylney, husbandman 2
3929383 2000174 2000174 defendant Manne Thomas gent 588663 588663 Manne, Thomas, of Tylney, gent 0
3930850 2000658 2000658 defendant Barker Edmund husbandman 588663 588663 Barker, Edmund, of Tylney, husbandman 0
3950412 2007226 2007226 plaintiff Fyssher Henry yeoman 588663 588663 Fyssher, Henry, of Tylney, or of South Lenne, yeoman 0
3983688 2018937 2018937 plaintiff Stallon Thomas yeoman 588663 588663 Stallon, Thomas, of Tylney, yeoman 0
3985434 2019550 2019550 defendant Pelham John yeoman 588663 588663 Pelham, John, of Tylney, yeoman 0
3985436 2019551 2019551 defendant Pelham John yeoman 588663 588663 Pelham, John, of Tylney, yeoman 0
3989659 2021047 2021047 plaintiff Barvell alias Wandham Thomas husbandman 588663 588663 Barvell alias Wandham, Thomas, of Tylney, husbandman 0
3989999 2021176 2021176 defendant Tomlyng John blacksmith 588663 588663 Tomlyng, John, of Tylney, blacksmith 0
4009617 2028210 2028210 plaintiff Nicholl Humphrey (legal representative) 588663 588663 Nicholl, Humphrey, of Tylney, executor of 0
4009619 2028210 2028210 defendant Carter William   588663 588663 Carter, William, of Tylney, husbandman, administrators of 0
4009624 2028211 2028211 plaintiff Nicholl Humphrey (legal representative) 588663 588663 Nicholl, Humphrey, of Tylney, yeoman, executor of 0
4009627 2028212 2028212 plaintiff Nicholl Richard esq 588663 588663 Nicholl, Richard, of Tylney, esq 0
4009646 2028220 2028220 plaintiff Nicoll Richard esq 588663 588663 Nicoll, Richard, of Tylney, esq 0
4009872 2028307 2028307 plaintiff Nycholl Richard esq 588663 588663 Nycholl, Richard, of Tylney, esq 0
4021322 2032350 2032350 defendant Woodhous George gent 588663 588663 Woodhous, George, of Tylney, gent 1
4025976 2033940 2033940 defendant Nicolson Richard tailor 588663 588663 Nicolson, Richard, of Tylney, tailor 0
4033783 2036732 2036732 defendant Broun Robert   588663 588663 Broun, Robert, of Tylney, shepherd 0
4045813 2040948 2040948 defendant Deane Edward gent 588663 588663 Deane, Edward, of Tylney, gent 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);