names

333 rows where place_id = 590362

✎ 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
3600814 1867917 1867917 defendant Maundy Thomas smith 590362 590362 Maundy, Thomas, of Eston, smith 0
3660045 1913405 1913405 plaintiff Harold John chaplain 590362 590362 Harold, John, of Eston, chaplain 0
3664519 1914854 1914854 defendant Stanney John gent 590362 590362 Stanney, John, of Eston, gent 0
3679797 1919747 1919747 defendant Langley Richard gent 590362 590362 Langley, Richard, of Eston, gent 0
3681403 1920271 1920271 defendant Kyngesman John clerk 590362 590362 Kyngesman, John, of Eston, clerk 0
3681404 1920271 1920271 defendant Fynyngham John clerk 590362 590362 Fynyngham, John, of Eston, clerk 1
3681405 1920271 1920271 defendant Godfrey Walter spooner 590362 590362 Godfrey, Walter, of Eston, spooner 2
3681407 1920272 1920272 defendant Kyngesman John clerk 590362 590362 Kyngesman, John, of Eston, clerk 0
3681408 1920272 1920272 defendant Fynyngham John clerk 590362 590362 Fynyngham, John, of Eston, clerk 1
3681409 1920272 1920272 defendant Godfrey Walter spooner 590362 590362 Godfrey, Walter, of Eston, spooner 2
3696428 1925107 1925107 defendant Glausters Roland yeoman 590362 590362 Glausters, Roland, of Eston, yeoman 3
3696797 1925224 1925224 defendant Shymmyng Thomas husbandman 590362 590362 Shymmyng, Thomas, of Eston, husbandman 0
3699140 1925942 1925942 defendant Wyot Richard husbandman 590362 590362 Wyot, Richard, of Eston, husbandman 0
3707476 1928630 1928630 defendant Lyngham John yeoman 590362 590362 Lyngham, John, of Eston, yeoman 4
3710524 1929613 1929613 defendant Shymmyng Thomas husbandman 590362 590362 Shymmyng, Thomas, of Eston, husbandman 0
3712924 1930363 1930363 plaintiff Stone John   590362 590362 Stone, John, of Eston 1
3714571 1930854 1930854 defendant Byle John   590362 590362 Byle, John, of Eston, worsted sherman 3
3714890 1930953 1930953 defendant Vyncent John, senior yeoman 590362 590362 Vyncent, John, senior, of Eston, yeoman 0
3724197 1933855 1933855 defendant Bronde John yeoman 590362 590362 Bronde, John, of Eston, yeoman 0
3734825 1937136 1937136 defendant Maundy Robert smith 590362 590362 Maundy, Robert, of Eston, smith 0
3735213 1937249 1937249 defendant Brond John yeoman 590362 590362 Brond, John, of Eston, yeoman 0
3735310 1937276 1937276 defendant Shymmyng Thomas husbandman 590362 590362 Shymmyng, Thomas, of Eston, husbandman 0
3740680 1938948 1938948 defendant Bronde John yeoman 590362 590362 Bronde, John, of Eston, yeoman 0
3755593 1943706 1943706 plaintiff Ston John   590362 590362 Ston, John, of Eston 1
3756427 1943982 1943982 defendant Reynoldys alias Tayler John tailor 590362 590362 Reynoldys alias Tayler, John, of Eston, tailor 1
3758540 1944669 1944669 defendant Smyth Roger tanner 590362 590362 Smyth, Roger, of Eston, tanner 1
3768232 1947704 1947704 plaintiff Partrich John   590362 590362 Partrich, John, of Eston 0
3770849 1948571 1948571 defendant Wellys Nicholas mariner 590362 590362 Wellys, Nicholas, of Eston, mariner 0
3773353 1949379 1949379 defendant Burgeys Thomas clerk 590362 590362 Burgeys, Thomas, of Eston, clerk 0
3773541 1949436 1949436 plaintiff Ston or Stoner John   590362 590362 Ston or Stoner, John, of Eston 1
3780614 1951664 1951664 plaintiff Goche John   590362 590362 Goche, John, of Eston 0
3782052 1952138 1952138 defendant Whitehed John husbandman 590362 590362 Whitehed, John, of Eston, husbandman 0
3782116 1952159 1952159 defendant Byng Richard husbandman 590362 590362 Byng, Richard, of Eston, husbandman 0
3784766 1953026 1953026 defendant Cryspe Thomas husbandman 590362 590362 Cryspe, Thomas, of Eston, husbandman 4
3791129 1955059 1955059 defendant Andrewe Richard husbandman 590362 590362 Andrewe, Richard, of Eston, husbandman 1
3792917 1955638 1955638 defendant Fawne John clerk 590362 590362 Fawne, John, of Eston, clerk 0
3792977 1955660 1955660 defendant Cordall John yeoman 590362 590362 Cordall, John, of Eston, yeoman 0
3804076 1959200 1959200 plaintiff Sclater John   590362 590362 Sclater, John, of Eston 0
3804821 1959451 1959451 plaintiff Sponer James   590362 590362 Sponer, James, of Eston 0
3821841 1964720 1964720 defendant Colyour John husbandman 590362 590362 Colyour, John, of Eston, husbandman 0
3822461 1964925 1964925 defendant Kedell Thomas   590362 590362 Kedell, Thomas, of Eston, parish clerk 0
3825020 1965697 1965697 defendant Wyatt Richard husbandman 590362 590362 Wyatt, Richard, of Eston, husbandman 0
3834022 1968581 1968581 defendant Keynnesman Geoffrey chaplain 590362 590362 Keynnesman, Geoffrey, of Eston, chaplain 2
3834023 1968581 1968581 defendant Shymmyng Thomas yeoman 590362 590362 Shymmyng, Thomas, of Eston, yeoman 3
3850068 1973612 1973612 defendant Shymmyng Thomas husbandman 590362 590362 Shymmyng, Thomas, of Eston, husbandman 0
3853350 1974671 1974671 defendant Nele John husbandman 590362 590362 Nele, John, of Eston, husbandman 0
3854857 1975164 1975164 defendant Ivys John slater 590362 590362 Ivys, John, of Eston, slater 2
3854859 1975164 1975164 defendant Jackson Richard slater 590362 590362 Jackson, Richard, of Eston, slater 4
3859794 1976776 1976776 defendant Thaxster Richard laborer 590362 590362 Thaxster, Richard, of Eston, laborer 1
3864969 1978489 1978489 defendant Shymmyng Thomas husbandman 590362 590362 Shymmyng, Thomas, of Eston, husbandman 0
3867859 1979482 1979482 defendant Nele John husbandman 590362 590362 Nele, John, of Eston, husbandman 0
3868916 1979845 1979845 defendant Nele John husbandman 590362 590362 Nele, John, of Eston, husbandman 0
3869391 1980001 1980001 defendant Wolrigge William husbandman 590362 590362 Wolrigge, William, of Eston, husbandman 0
3869397 1980003 1980003 plaintiff Waldron Thomas, senior gent 590362 590362 Waldron, Thomas, senior, of Eston, gent 0
3883194 1984642 1984642 plaintiff Waldram Thomas gent 590362 590362 Waldram, Thomas, of Eston, Leics, senior, gent 0
3888924 1986538 1986538 defendant Dandesey Thomas gent 590362 590362 Dandesey, Thomas, of Eston, gent 1
3893661 1988106 1988106 plaintiff Pope William husbandman 590362 590362 Pope, William, of Eston, husbandman 0
3902975 1991223 1991223 defendant Dansey alias Dandesey Thomas gent 590362 590362 Dansey alias Dandesey, Thomas, of Eston, gent 1
3904663 1991815 1991815 defendant Phellyppys Richard husbandman 590362 590362 Phellyppys, Richard, of Eston, husbandman 0
3914264 1995114 1995114 defendant Wyott Richard yeoman 590362 590362 Wyott, Richard, of Eston, yeoman 0
3919753 1996946 1996946 defendant Cooke George husbandman 590362 590362 Cooke, George, of Eston, husbandman 1
3919754 1996946 1996946 defendant Wade John yeoman 590362 590362 Wade, John, of Eston, yeoman 2
3949633 2006947 2006947 plaintiff Eve Henry   590362 590362 Eve, Henry, of Eston 0
3951661 2007634 2007634 defendant Croftes John yeoman 590362 590362 Croftes, John, of Eston, yeoman 1
3967922 2013408 2013408 defendant Cottrell John husbandman 590362 590362 Cottrell, John, of Eston, husbandman 2
3973258 2015221 2015221 defendant Gladdan Ralph yeoman 590362 590362 Gladdan, Ralph, of Eston, yeoman 3
3977535 2016712 2016712 defendant Chestre George tailor 590362 590362 Chestre, George, of Eston, tailor 0
3979950 2017591 2017591 defendant Burton Edward butcher 590362 590362 Burton, Edward, of Eston, butcher 0
4017054 2030805 2030805 plaintiff Tampon Thomas yeoman 590362 590362 Tampon, Thomas, of Eston, yeoman 0
4017055 2030805 2030805 defendant Clarke John laborer 590362 590362 Clarke, John, of Eston, laborer 0
4040329 2039046 2039046 plaintiff Meres Henry yeoman 590362 590362 Meres, Henry, of Eston, yeoman 0
4055220 2044261 2044261 defendant Cleasbye Asculphus gent 590362 590362 Cleasbye, Asculphus, of Eston, gent 0
4056249 2044620 2044620 defendant Cleasbye Asculphus gent 590362 590362 Cleasbye, Asculphus, of Eston, gent 0
4059147 2045672 2045672 defendant Poole Thomas husbandman 590362 590362 Poole, Thomas, of Eston, husbandman 1
4059821 2045906 2045906 defendant Planten John yeoman 590362 590362 Planten, John, of Eston, yeoman 0
4070793 2049849 2049849 defendant Hynde Thomas yeoman 590362 590362 Hynde, Thomas, of Eston, yeoman 1
4072328 2050406 2050406 defendant Farmer George esq 590362 590362 Farmer, George, of Eston, esq 0
4078886 2052746 2052746 defendant Harman William husbandman 590362 590362 Harman, William, of Eston, husbandman 1
4081135 2053564 2053564 defendant Farmer John   590362 590362 Farmer, John, of Eston, knight 0
4092216 2057518 2057518 defendant Shylley Thomas yeoman 590362 590362 Shylley, Thomas, of Eston, yeoman 0
4098040 2059628 2059628 defendant Pyman Cecily spinster 590362 590362 Pyman, Cecily, of Eston, spinster 3
4111330 2064300 2064300 defendant Tredwey Robert gent 590362 590362 Tredwey, Robert, of Eston, gent 0
4141165 2075069 2075069 defendant Farror Alan blacksmith 590362 590362 Farror, Alan, of Eston, blacksmith 2
4169100 2084691 2084691 defendant Becke John gent 590362 590362 Becke, John, of Eston, gent 0
4207964 2098345 2098345 defendant Jacob William husbandman 590362 590362 Jacob, William, of Eston, husbandman 0
4239939 2109605 2109605 defendant Massam Henry fishmonger 590362 590362 Massam, Henry, of Eston, fishmonger administratrix of 0
4242842 2110597 2110597 defendant Jacobbe William yeoman 590362 590362 Jacobbe, William, of Eston, yeoman 0
4270913 2119846 2119846 defendant Barnys Christopher gent 590362 590362 Barnys, Christopher, of Eston, gent 1
4288085 2125788 2125788 defendant Hamond David husbandman 590362 590362 Hamond, David, of Eston, husbandman 0
4301963 2130810 2130810 defendant Connyngton Alan husbandman 590362 590362 Connyngton, Alan, of Eston, husbandman 1
4302235 2130897 2130897 defendant Clare Edward yeoman 590362 590362 Clare, Edward, of Eston, yeoman 0
4337050 2142680 2142680 defendant Clare Edmund yeoman 590362 590362 Clare, Edmund, of Eston, yeoman 0
4353848 2148566 2148566 defendant Newman Henry yeoman 590362 590362 Newman, Henry, of Eston, yeoman 5
4406716 2166814 2166814 defendant Atkinson George yeoman 590362 590362 Atkinson, George, of Eston, yeoman 1
4407421 2167044 2167044 defendant Goodwyn Brachiel tailor 590362 590362 Goodwyn, Brachiel, of Eston, tailor 1
4425930 2172912 2172912 defendant Pough Thomas   590362 590362 Pough, Thomas, of Eston 1
4425931 2172912 2172912 defendant atte Mulle Geoffrey   590362 590362 atte Mulle, Geoffrey, of Eston 2
4430794 2174388 2174388 defendant smyth William le   590362 590362 smyth, William le, of Eston, son of Robert 2
4445847 2183644 2183644 defendant Gilberd Thomas   590362 590362 Gilberd, Thomas, of Eston 0
4448855 2184581 2184581 defendant Miller John   590362 590362 Miller, John, of Eston, son of Richard Miller 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);