names

49 rows where place_id = 588332

✎ 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
3594137 1865810 1865810 defendant Hurston Hugh merchant 588332 588332 Hurston, Hugh, of Westchester, Cheshire, merchant 0
3609011 1870474 1870474 defendant Jelybronde James chapman 588332 588332 Jelybronde, James, of Westchester, Cheshire, chapman 1
3660098 1913418 1913418 defendant Smyth Thomas, junior mercer 588332 588332 Smyth, Thomas, junior, of Westchester, Cheshire, mercer 0
3671659 1917123 1917123 defendant Smyth John chapman 588332 588332 Smyth, John, of Westchester, Cheshire, chapman 2
3671689 1917131 1917131 defendant Smyth John, junior chapman 588332 588332 Smyth, John, junior, of Westchester, Cheshire, chapman 0
3671694 1917132 1917132 defendant Smyth John, junior chapman 588332 588332 Smyth, John, junior, of Westchester, Cheshire, chapman 0
3673269 1917655 1917655 defendant Hopwode John gent 588332 588332 Hopwode, John, of Westchester, Cheshire, gent 1
3688712 1922630 1922630 defendant Lowe Richard mercer 588332 588332 Lowe, Richard, of Westchester, Cheshire, mercer 1
3706409 1928292 1928292 defendant Dutton Peter   588332 588332 Dutton, Peter, of Westchester, Cheshire, knight 1
3717618 1931807 1931807 defendant Mercer William merchant 588332 588332 Mercer, William, of Westchester, Cheshire, merchant 1
3717628 1931808 1931808 defendant Smythe Peter mercer 588332 588332 Smythe, Peter, of Westchester, Cheshire, mercer 4
3726452 1934541 1934541 defendant Eton Charles merchant 588332 588332 Eton, Charles, of Westchester, Cheshire, merchant 0
3726468 1934546 1934546 defendant Eton Charles merchant 588332 588332 Eton, Charles, of Westchester, Cheshire, merchant 0
3726898 1934682 1934682 defendant Bolton Oliver carpenter 588332 588332 Bolton, Oliver, of Westchester, Cheshire, carpenter 0
3762481 1945909 1945909 defendant Law Richard mercer 588332 588332 Law, Richard, of Westchester, Cheshire, mercer 0
3773645 1949475 1949475 defendant Holande Giles chapman 588332 588332 Holande, Giles, of Westchester, Cheshire, chapman 0
3779882 1951437 1951437 defendant Wethyns William merchant 588332 588332 Wethyns, William, of Westchester, Cheshire, merchant 0
3800109 1957959 1957959 plaintiff Lawe William merchant and pewterer 588332 588332 Lawe, William, of Westchester, Cheshire, merchant and pewterer 0
3800162 1957972 1957972 defendant Fraunceys Henry chapman 588332 588332 Fraunceys, Henry, of Westchester, Cheshire, chapman 1
3800678 1958124 1958124 defendant Gestlyn Henry chapman 588332 588332 Gestlyn, Henry, of Westchester, Cheshire, chapman 0
3814154 1962331 1962331 defendant Smyth Hugh mercer 588332 588332 Smyth, Hugh, of Westchester, Cheshire, mercer 1
3819620 1964013 1964013 defendant Smyth Thomas, junior mercer 588332 588332 Smyth, Thomas, junior, of Westchester, Cheshire, mercer 0
3819622 1964014 1964014 defendant Smyth Thomas, junior mercer 588332 588332 Smyth, Thomas, junior, of Westchester, Cheshire, mercer 0
3851757 1974138 1974138 defendant Holland Guy merchant 588332 588332 Holland, Guy, of Westchester, Cheshire, merchant 0
3866565 1979044 1979044 defendant Smyth Thomas   588332 588332 Smyth, Thomas, of Westchester, Cheshire, chapman, son of Smyth, Thomas 0
3868936 1979853 1979853 defendant Walton Adam merchant 588332 588332 Walton, Adam, of Westchester, Cheshire, merchant 1
3886499 1985739 1985739 defendant Massye Thomas chapman 588332 588332 Massye, Thomas, of Westchester, Cheshire, chapman 0
3887195 1985982 1985982 defendant Longley Thomas chapman 588332 588332 Longley, Thomas, of Westchester, Cheshire, chapman 0
3888556 1986431 1986431 defendant Hankey John chapman 588332 588332 Hankey, John, of Westchester, Cheshire, chapman 1
3891475 1987415 1987415 defendant Alowe Richard yeoman 588332 588332 Alowe, Richard, of Westchester, Cheshire, yeoman 1
3893738 1988126 1988126 defendant Smythe Ralph chapman 588332 588332 Smythe, Ralph, of Westchester, Cheshire, chapman 1
3902944 1991214 1991214 defendant Smyth Thomas mercer 588332 588332 Smyth, Thomas, of Westchester, Cheshire, mercer 0
3908359 1993093 1993093 defendant Redford Richard ironmonger 588332 588332 (Redford, Richard, of Westchester, Cheshire, ironmonger 1
3913539 1994867 1994867 defendant Waryne Ralph esq 588332 588332 Waryne, Ralph, of Westchester, Cheshire, esq 1
3914266 1995115 1995115 defendant Dutton Fulk draper 588332 588332 Dutton, Fulk, of Westchester, Cheshire, draper 0
3920180 1997088 1997088 defendant Wryne Ralph recorder of Chester 588332 588332 Wryne, Ralph, of Westchester, Cheshire, gent, recorder of Chester 0
3977268 2016620 2016620 plaintiff Lee Thomas gent 588332 588332 Lee, Thomas, of Westchester, Cheshire, gent 0
4127906 2070270 2070270 defendant Jones Elias mercer 588332 588332 Jones, Elias, of Westchester, Cheshire, mercer 2
4139362 2074442 2074442 defendant Glasyer James (legal representative) 588332 588332 Glasyer, James, of Westchester, Cheshire, gent, executrix of 0
4932950 2336693 2336693 defendant Dolbyn Henry chapman 588332 588332 Dolbyn, Henry, of Westchester, Cheshire, chapman 2
5379821 2469272 2469272 defendant Stanwey Richard   588332 588332 Stanwey, Richard, of Westchester, Cheshire 0
5461766 2493461 2493461 defendant Holyngworth William repyer or inland fish seller 588332 588332 Holyngworth, William, of Westchester, Cheshire, repyer or inland fish seller 0
5523562 2512199 2512199 defendant Goodman Richard, senior mercer 588332 588332 Goodman, Richard, senior, of Westchester, Cheshire, mercer 2
5549872 2519996 2519996 defendant Damporte Ralph gent 588332 588332 Damporte, Ralph, of Westchester, Cheshire, gent 0
5557816 2522239 2522239 defendant Carewe Thomas chaplain 588332 588332 Carewe, Thomas, of Westchester, Cheshire, chaplain 2
5584396 2530182 2530182 defendant Gryffyth John chapman 588332 588332 Gryffyth, John, of Westchester, Cheshire, chapman 3
5587823 2531208 2531208 defendant Crewe Thomas chaplain 588332 588332 Crewe, Thomas, of Westchester, Cheshire, chaplain 1
5587846 2531211 2531211 defendant Crewe Thomas chaplain 588332 588332 Crewe, Thomas, of Westchester, Cheshire, chaplain 1
5587858 2531212 2531212 defendant Letsham Richard dyer 588332 588332 Letsham, Richard, of Westchester, Cheshire, dyer 5

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);