names

561 rows where place_id = 589127

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596619 1866576 1866576 defendant Foliambe Henry esq 589127 589127 Foliambe, Henry, of Walton, esq 0
3599621 1867520 1867520 defendant Blakeman William butcher 589127 589127 Blakeman, William, of Walton, butcher 3
3600636 1867847 1867847 defendant Foliambe Henry esq 589127 589127 Foliambe, Henry, of Walton, esq 0
3600637 1867847 1867847 defendant Cantrell Henry husbandman 589127 589127 Cantrell, Henry, of Walton, husbandman 1
3600638 1867847 1867847 defendant Lyngard Robert laborer 589127 589127 Lyngard, Robert, of Walton, laborer 2
3600639 1867847 1867847 defendant Crychelowe Roger yeoman 589127 589127 Crychelowe, Roger, of Walton, yeoman 3
3603945 1868903 1868903 plaintiff Foliambe Henry esq 589127 589127 Foliambe, Henry, of Walton, esq 0
3610093 1870824 1870824 defendant Foliambe Henry esq 589127 589127 Foliambe, Henry, of Walton, esq 0
3610094 1870824 1870824 defendant Cantrell Henry husbandman 589127 589127 Cantrell, Henry, of Walton, husbandman 1
3610095 1870824 1870824 defendant Lyngard Robert laborer 589127 589127 Lyngard, Robert, of Walton, laborer 2
3610096 1870824 1870824 defendant Crychelowe Roger yeoman 589127 589127 Crychelowe, Roger, of Walton, yeoman 3
3624824 1875299 1875299 defendant Oldhall Henry husbandman 589127 589127 Oldhall, Henry, of Walton, husbandman 4
3629526 1904092 1904092 defendant Storris Robert gent 589127 589127 Storris, Robert, of Walton, gent 0
3644558 1908716 1908716 defendant Garbott Richard yeoman 589127 589127 Garbott, Richard, of Walton, yeoman 0
3644559 1908716 1908716 defendant Garbott Thomas husbandman 589127 589127 Garbott, Thomas, of Walton, husbandman 1
3644560 1908716 1908716 defendant Garbott John husbandman 589127 589127 Garbott, John, of Walton, husbandman 2
3651335 1910782 1910782 defendant Fyste Thomas laborer 589127 589127 Fyste, Thomas, of Walton, laborer 1
3652586 1911143 1911143 defendant Miners John husbandman 589127 589127 Miners, John, of Walton, husbandman 0
3658210 1912822 1912822 defendant Wakerley John gent 589127 589127 Wakerley, John, of Walton, gent 0
3659785 1913314 1913314 defendant Grene John carpenter 589127 589127 Grene, John, of Walton, carpenter 0
3659786 1913314 1913314 defendant Howson Peter husbandman 589127 589127 Howson, Peter, of Walton, husbandman 1
3659787 1913314 1913314 defendant Harvy Robert husbandman 589127 589127 Harvy, Robert, of Walton, husbandman 2
3660645 1913593 1913593 plaintiff Hoppar John yeoman 589127 589127 Hoppar, John, of Walton, yeoman 0
3664966 1914986 1914986 defendant Foliambe Geoffrey esq 589127 589127 Foliambe, Geoffrey, of Walton, esq 0
3668910 1916209 1916209 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3672592 1917425 1917425 defendant Russheton John husbandman 589127 589127 Russheton, John, of Walton, husbandman 1
3677032 1918856 1918856 defendant Pygot John yeoman 589127 589127 Pygot, John, of Walton, yeoman 0
3680185 1919875 1919875 defendant Giller John smith 589127 589127 Giller, John, of Walton, smith 0
3680194 1919877 1919877 defendant Dameron Henry yeoman 589127 589127 Dameron, Henry, of Walton, yeoman 0
3681758 1920394 1920394 defendant Sparry Thomas husbandman 589127 589127 Sparry, Thomas, of Walton, husbandman 1
3682935 1920775 1920775 defendant Wakerley John gent 589127 589127 Wakerley, John, of Walton, gent 0
3690293 1923125 1923125 defendant Cawse Thomas mariner 589127 589127 Cawse, Thomas, of Walton, mariner 0
3694406 1924455 1924455 plaintiff Newport alias Holbrook John   589127 589127 Newport alias Holbrook, John, of Walton 0
3696510 1925137 1925137 defendant Garbett William chaplain 589127 589127 Garbett, William, of Walton, chaplain 0
3698012 1925603 1925603 defendant Wakerley John gent 589127 589127 Wakerley, John, of Walton, gent 0
3699786 1926156 1926156 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3702104 1926914 1926914 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3702487 1927042 1927042 defendant Carter Robert husbandman 589127 589127 Carter, Robert, of Walton, husbandman 0
3703302 1927306 1927306 defendant Gymbald Thomas yeoman 589127 589127 Gymbald, Thomas, of Walton, yeoman 0
3705857 1928114 1928114 defendant Pygot John yeoman 589127 589127 Pygot, John, of Walton, yeoman 4
3706641 1928363 1928363 defendant Dunston Lionel yeoman 589127 589127 Dunston, Lionel, of Walton, yeoman 0
3708877 1929067 1929067 defendant Long Thomas mariner 589127 589127 Long, Thomas, of Walton, mariner 1
3710775 1929687 1929687 defendant Webbe John weaver 589127 589127 Webbe, John, of Walton, weaver 4
3710976 1929747 1929747 defendant Ellys William husbandman 589127 589127 Ellys, William, of Walton, husbandman 0
3711481 1929898 1929898 defendant Farraunt Robert laborer 589127 589127 Farraunt, Robert, of Walton, laborer 0
3711774 1929998 1929998 defendant Wakerley John gent 589127 589127 Wakerley, John, of Walton, gent 0
3717162 1931653 1931653 defendant Gymbald Thomas   589127 589127 Gymbald, Thomas, of Walton, twill weaver 0
3717503 1931761 1931761 defendant Whyte William yeoman 589127 589127 Whyte, William, of Walton, yeoman 0
3719241 1932303 1932303 defendant Langley Richard husbandman 589127 589127 Langley, Richard, of Walton, husbandman 0
3722935 1933439 1933439 plaintiff Newport alias Holbroke John   589127 589127 Newport alias Holbroke, John, of Walton 0
3723481 1933610 1933610 defendant Long Thomas mariner 589127 589127 Long, Thomas, of Walton, mariner 1
3725370 1934226 1934226 defendant Webbe John weaver 589127 589127 Webbe, John, of Walton, weaver 4
3730974 1935920 1935920 plaintiff Burugh John   589127 589127 Burugh, John, of Walton 0
3730975 1935920 1935920 defendant Donham Edmund (legal representative) 589127 589127 Donham, Edmund, of Walton, executor of 0
3730976 1935920 1935920 defendant Donham William husbandman 589127 589127 Donham, William, of Walton, husbandman 1
3732833 1936497 1936497 defendant Gymbald Thomas   589127 589127 Gymbald, Thomas, of Walton, twill weaver 0
3739435 1938542 1938542 defendant Harnesse William husbandman 589127 589127 Harnesse, William, of Walton, husbandman 0
3739445 1938545 1938545 defendant Penyffather Nicholas husbandman 589127 589127 Penyffather, Nicholas, of Walton, husbandman 0
3739842 1938676 1938676 defendant Long Richard husbandman 589127 589127 Long, Richard, of Walton, husbandman 10
3739843 1938676 1938676 defendant Newbobull John husbandman 589127 589127 Newbobull, John, of Walton, husbandman 11
3740391 1938855 1938855 defendant Harward Thomas carpenter 589127 589127 Harward, Thomas, of Walton, carpenter 3
3740392 1938855 1938855 defendant Gymbald Thomas yeoman 589127 589127 Gymbald, Thomas, of Walton, yeoman 4
3743093 1939693 1939693 defendant Webster Thomas chaplain 589127 589127 Webster, Thomas, of Walton, chaplain 0
3745804 1940592 1940592 defendant Gymbald Thomas yeoman 589127 589127 Gymbald, Thomas, of Walton, yeoman 0
3748686 1941517 1941517 defendant Dameron Henry merchant 589127 589127 Dameron, Henry, of Walton, merchant 0
3751016 1942249 1942249 defendant Garbott Richard husbandman 589127 589127 Garbott, Richard, of Walton, Morveler, husbandman 0
3757423 1944300 1944300 defendant Burgh Richard yeoman 589127 589127 Burgh, Richard, of Walton, yeoman 1
3760470 1945279 1945279 defendant Mascall Richard husbandman 589127 589127 Mascall, Richard, of Walton, husbandman 0
3760471 1945279 1945279 defendant Lancaster John gent 589127 589127 Lancaster, John, of Walton, gent 1
3760474 1945280 1945280 defendant Gymbod Thomas husbandman 589127 589127 Gymbod, Thomas, of Walton, husbandman 1
3760576 1945307 1945307 defendant Wytton Richard tanner 589127 589127 Wytton, Richard, of Walton, tanner 0
3761815 1945706 1945706 defendant Smyth Richard husbandman 589127 589127 Smyth, Richard, of Walton, husbandman 1
3763119 1946096 1946096 defendant Dameron Henry merchant 589127 589127 Dameron, Henry, of Walton, merchant 0
3763370 1946171 1946171 defendant Burgh Richard yeoman 589127 589127 Burgh, Richard, of Walton, yeoman 1
3764302 1946496 1946496 defendant Burgh Richard yeoman 589127 589127 Burgh, Richard, of Walton, yeoman 1
3765821 1946975 1946975 defendant Burgh Richard yeoman 589127 589127 Burgh, Richard, of Walton, yeoman 1
3767698 1947533 1947533 defendant Corbet Edmund gent 589127 589127 Corbet, Edmund, of Walton, gent 0
3770293 1948379 1948379 defendant Burgh Richard yeoman 589127 589127 Burgh, Richard, of Walton, yeoman 1
3770545 1948470 1948470 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3771321 1948721 1948721 defendant Burgh Richard yeoman 589127 589127 Burgh, Richard, of Walton, yeoman 1
3775880 1950208 1950208 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 2
3776903 1950516 1950516 defendant Gymbald Thomas husbandman 589127 589127 Gymbald, Thomas, of Walton, husbandman 0
3776909 1950518 1950518 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3777075 1950579 1950579 defendant Foster William husbandman 589127 589127 Foster, William, of Walton, husbandman 0
3778557 1951006 1951006 defendant Gymbald Thomas weaver 589127 589127 Gymbald, Thomas, of Walton, weaver 1
3782524 1952277 1952277 defendant Lancaster John yeoman 589127 589127 Lancaster, John, of Walton, yeoman 0
3784057 1952793 1952793 defendant Mace Thomas husbandman 589127 589127 Mace, Thomas, of Walton, husbandman 1
3785399 1953220 1953220 defendant Corbette Edmund gent 589127 589127 Corbette, Edmund, of Walton, gent 0
3785833 1953358 1953358 plaintiff Pakwood William   589127 589127 Pakwood, William, of Walton 0
3785875 1953374 1953374 plaintiff Palwood William   589127 589127 Palwood, William, of Walton 0
3789596 1954574 1954574 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3791506 1955183 1955183 defendant Pygott John yeoman 589127 589127 Pygott, John, of Walton, yeoman 0
3791514 1955185 1955185 defendant Dyer John butcher 589127 589127 Dyer, John, of Walton, butcher 3
3796873 1956900 1956900 plaintiff Foliambe James esq 589127 589127 Foliambe, James, of Walton, esq 0
3799098 1957628 1957628 plaintiff Hunt John yeoman 589127 589127 Hunt, John, of Walton, yeoman 0
3802799 1958773 1958773 defendant Witton Richard tanner 589127 589127 Witton, Richard, of Walton, tanner 0
3803540 1959014 1959014 defendant Lavyle William yeoman 589127 589127 Lavyle, William, of Walton, yeoman 1
3809030 1960706 1960706 defendant Lancastre John gent 589127 589127 Lancastre, John, of Walton, gent 0
3809031 1960706 1960706 defendant Mascall Richard husbandman 589127 589127 Mascall, Richard, of Walton, husbandman 1
3810950 1961325 1961325 defendant Dameron Richard cordwainer 589127 589127 Dameron, Richard, of Walton, cordwainer 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);