names

2,030 rows where place_id = 586254

✎ 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
3588271 1863987 1863987 defendant James Walter   586254 586254 James, Walter, of Southampton, merchant, administrators of 1
3588272 1863987 1863987 defendant Surnet or Survet Bernard merchant 586254 586254 (Surnet or Survet, Bernard, of Southampton, merchant 2
3588279 1863988 1863988 defendant James Walter   586254 586254 James, Walter, of Southampton, merchant, administrators of 1
3588280 1863988 1863988 defendant Surnet or Survet Bernard merchant 586254 586254 (Surnet or Survet, Bernard, of Southampton, merchant 2
3590474 1864667 1864667 defendant Ite Stephen merchant 586254 586254 Ite, Stephen, of Southampton, merchant 0
3590476 1864668 1864668 defendant Ite Stephen merchant 586254 586254 Ite, Stephen, of Southampton, merchant 0
3591886 1865076 1865076 defendant Lathom John gent 586254 586254 Lathom, John, of Southampton, gent 21
3592865 1865385 1865385 plaintiff Gryffyth German merchant 586254 586254 Gryffyth, German, of Southampton, merchant 0
3594483 1865903 1865903 defendant Gyldon John merchant 586254 586254 Gyldon, John, of Southampton, merchant 0
3595453 1866211 1866211 defendant Blewet Robert merchant 586254 586254 Blewet, Robert, of Southampton, merchant 0
3595454 1866211 1866211 defendant Wylson Thomas merchant 586254 586254 Wylson, Thomas, of Southampton, merchant 1
3595455 1866211 1866211 defendant Myclowe William merchant 586254 586254 Myclowe, William, of Southampton, merchant 2
3597687 1866903 1866903 defendant White Anthony merchant 586254 586254 White, Anthony, of Southampton, merchant 0
3600687 1867864 1867864 defendant Cokke George fishmonger 586254 586254 Cokke, George, of Southampton, fishmonger 0
3601197 1868038 1868038 plaintiff Ambrose Christopher merchant 586254 586254 Ambrose, Christopher, of Southampton, merchant 0
3601422 1868105 1868105 plaintiff Bagworth Robert (legal representative) 586254 586254 Bagworth, Robert, of Southampton, merchant, executor of 0
3601424 1868105 1868105 defendant de la Ferga Peter (legal representative) 586254 586254 de la Ferga, Peter, of Southampton, merchant, executors of 0
3603368 1868726 1868726 plaintiff de la farga Peter (legal representative) 586254 586254 de la farga, Peter, of Southampton, merchant, executors of 0
3604054 1868936 1868936 defendant Whyte Anthony merchant 586254 586254 Whyte, Anthony, of Southampton, merchant 0
3606643 1869751 1869751 defendant Bluet Richard merchant 586254 586254 Bluet, Richard, of Southampton, merchant 0
3606865 1869813 1869813 defendant Gryffyth German merchant 586254 586254 Gryffyth, German, of Southampton, merchant 0
3606906 1869824 1869824 defendant Bluet Richard merchant 586254 586254 Bluet, Richard, of Southampton, merchant 0
3607648 1870048 1870048 defendant Reynold Thomas merchant 586254 586254 Reynold, Thomas, of Southampton, merchant 0
3607649 1870048 1870048 defendant Reynold Andrew merchant 586254 586254 Reynold, Andrew, of Southampton, merchant 1
3607650 1870048 1870048 defendant White Anthony merchant 586254 586254 White, Anthony, of Southampton, merchant 2
3607651 1870048 1870048 defendant Aleyn alias Pers Thomas husbandman 586254 586254 Aleyn alias Pers, Thomas, of Southampton, husbandman 3
3607656 1870049 1870049 defendant Waleys Ralph butcher 586254 586254 Waleys, Ralph, of Southampton, butcher 0
3607899 1870121 1870121 plaintiff Skyllyng John gent 586254 586254 Skyllyng, John, of Southampton, gent 0
3612983 1871709 1871709 plaintiff Ambrose Christopher merchant 586254 586254 Ambrose, Christopher, of Southampton, merchant 0
3613330 1871817 1871817 defendant Walsshe John merchant 586254 586254 Walsshe, John, of Southampton, merchant 0
3613345 1871819 1871819 defendant Walsshe John merchant 586254 586254 Walsshe, John, of Southampton, merchant 0
3613592 1871897 1871897 defendant Cokke George merchant 586254 586254 Cokke, George, of Southampton, merchant 0
3613594 1871898 1871898 defendant Cokke George merchant 586254 586254 Cokke, George, of Southampton, merchant 0
3614355 1872143 1872143 defendant Reynold Thomas merchant 586254 586254 Reynold, Thomas, of Southampton, merchant 4
3614762 1872266 1872266 defendant Godfray John draper 586254 586254 Godfray, John, of Southampton, draper 0
3615634 1872532 1872532 defendant Kirkham Richard mercer 586254 586254 Kirkham, Richard, of Southampton, mercer 0
3615756 1872568 1872568 defendant Coke George yeoman 586254 586254 Coke, George, of Southampton, yeoman 0
3616214 1872713 1872713 plaintiff Dawetrey John gent 586254 586254 Dawetrey, John, of Southampton, gent 0
3616216 1872714 1872714 plaintiff Dawetrey John gent 586254 586254 Dawetrey, John, of Southampton, gent 0
3617619 1873132 1873132 defendant White Anthony merchant 586254 586254 White, Anthony, of Southampton, merchant 0
3617620 1873132 1873132 defendant Grigge John merchant 586254 586254 Grigge, John, of Southampton, merchant 1
3620540 1873999 1873999 defendant Mounbray Joan widow 586254 586254 Mounbray, Joan, of Southampton, widow 0
3620541 1873999 1873999 defendant Yokeley William tailor 586254 586254 Yokeley, William, of Southampton, tailor 1
3620585 1874015 1874015 defendant Ball Thomas bowyer 586254 586254 Ball, Thomas, of Southampton, bowyer 0
3620587 1874015 1874015 defendant Coty Richard baker 586254 586254 Coty, Richard, of Southampton, baker 2
3622188 1874474 1874474 defendant Thay alias Vyncent William mercer 586254 586254 Thay alias Vyncent, William, of Southampton, mercer 0
3622190 1874475 1874475 defendant Thay alias Vyncent William mercer 586254 586254 Thay alias Vyncent, William, of Southampton, mercer 0
3623712 1874949 1874949 defendant Ummerey or Vunnery William merchant 586254 586254 Ummerey or Vunnery, William, of Southampton, merchant 0
3625043 1875365 1875365 plaintiff Warde John merchant 586254 586254 Warde, John, of Southampton, merchant 0
3625044 1875365 1875365 defendant Jackson Robert merchant 586254 586254 Jackson, Robert, of Southampton, merchant 0
3625045 1875365 1875365 defendant Jackson Thomas draper 586254 586254 Jackson, Thomas, of Southampton, draper 1
3625677 1875567 1875567 defendant Welys Reginald butcher 586254 586254 Welys, Reginald, of Southampton, butcher 0
3630355 1904331 1904331 defendant Flemyng John esq 586254 586254 Flemyng, John, of Southampton, esq 5
3633179 1905190 1905190 defendant Rygge Edward   586254 586254 Rygge, Edward, of Southampton, clerk, warden of St Julian Hospital 0
3633454 1905276 1905276 defendant Kyng John baker 586254 586254 Kyng, John, of Southampton, baker 1
3634948 1905732 1905732 plaintiff Newman Agnes widow 586254 586254 Newman, Agnes, of Southampton, widow 1
3638479 1906853 1906853 defendant Pechard John merchant 586254 586254 Pechard, John, of Southampton, merchant 0
3638480 1906853 1906853 defendant Raynold Robert merchant 586254 586254 Raynold, Robert, of Southampton, merchant 1
3639706 1907227 1907227 defendant Mershe Thomas yeoman 586254 586254 Mershe, Thomas, of Southampton, yeoman 0
3640122 1907356 1907356 defendant Mersshe Thomas merchant 586254 586254 Mersshe, Thomas, of Southampton, merchant 0
3640203 1907376 1907376 defendant Flemyng John esq 586254 586254 Flemyng, John, of Southampton, esq 2
3641606 1907835 1907835 defendant Crayn William merchant 586254 586254 Crayn, William, of Southampton, merchant 0
3645406 1908971 1908971 defendant Percher John merchant 586254 586254 Percher, John, of Southampton, merchant 0
3646013 1909148 1909148 defendant Kyng John baker 586254 586254 Kyng, John, of Southampton, baker 0
3646014 1909148 1909148 defendant Meddeler Robert baker 586254 586254 Meddeler, Robert, of Southampton, baker 1
3646016 1909149 1909149 defendant Kyng John baker 586254 586254 Kyng, John, of Southampton, baker 0
3646017 1909149 1909149 defendant Meddeler Robert baker 586254 586254 Meddeler, Robert, of Southampton, baker 1
3647229 1909519 1909519 defendant Wright Robert yeoman 586254 586254 Wright, Robert, of Southampton, yeoman 0
3649804 1910302 1910302 defendant Wodshaa Thomas gent 586254 586254 Wodshaa, Thomas, of Southampton, gent 1
3652144 1911010 1911010 defendant Montageue Gilbert merchant 586254 586254 Montageue, Gilbert, of Southampton, merchant 0
3652146 1911011 1911011 defendant Montageue William merchant 586254 586254 Montageue, William, of Southampton, merchant 0
3653549 1911377 1911377 defendant White John merchant 586254 586254 White, John, of Southampton, merchant 0
3653553 1911379 1911379 defendant White John merchant 586254 586254 White, John, of Southampton, merchant 0
3653650 1911406 1911406 defendant Husee John gent 586254 586254 Husee, John, of Southampton, gent 0
3653734 1911430 1911430 defendant Perchard John merchant 586254 586254 Perchard, John, of Southampton, merchant 0
3657071 1912474 1912474 defendant Flemyng John merchant 586254 586254 Flemyng, John, of Southampton, merchant 0
3659392 1913197 1913197 defendant Faune John clerk 586254 586254 Faune, John, of Southampton, clerk 1
3659394 1913198 1913198 defendant Faune John clerk 586254 586254 Faune, John, of Southampton, clerk 0
3659486 1913225 1913225 defendant Faune John clerk 586254 586254 Faune, John, of Southampton, clerk 1
3662206 1914096 1914096 defendant Palshot Richard gent 586254 586254 Palshot, Richard, of Southampton, gent 0
3663439 1914492 1914492 defendant Pebeles Henry (legal representative) 586254 586254 Pebeles, Henry, of Southampton, gold smith, executrix of 0
3663440 1914492 1914492 defendant Pebeles Marion widow 586254 586254 Pebeles, Marion, of Southampton, widow 1
3663442 1914493 1914493 defendant Pebeles Henry (legal representative) 586254 586254 Pebeles, Henry, of Southampton, gold smith, administratrix of 0
3663443 1914493 1914493 defendant Pebeles Marion widow 586254 586254 Pebeles, Marion, of Southampton, widow 1
3663572 1914537 1914537 plaintiff Perchard John   586254 586254 Perchard, John, of Southampton merchant & burgess 0
3666178 1915367 1915367 defendant Veysy John merchant 586254 586254 Veysy, John, of Southampton, merchant 0
3666739 1915543 1915543 plaintiff Walsshe Philip   586254 586254 Walsshe, Philip, of Southampton 0
3678297 1919269 1919269 defendant Payn John (legal representative) 586254 586254 Payn, John, of Southampton, draper, administrator of 0
3678298 1919269 1919269 defendant Kyllecke John draper 586254 586254 Kyllecke, John, of Southampton, draper 1
3679101 1919529 1919529 defendant Walssh John (legal representative) 586254 586254 Walssh, John, of Southampton, merchant, executors of 0
3679102 1919529 1919529 defendant Chalk William merchant 586254 586254 (Chalk, William, of Southampton, merchant 1
3684613 1921320 1921320 defendant Faver John merchant 586254 586254 Faver, John, of Southampton, merchant 0
3684615 1921320 1921320 defendant Clerke Henry yeoman 586254 586254 Clerke, Henry, of Southampton, yeoman 2
3686072 1921804 1921804 defendant Palshid Richard husbandman 586254 586254 Palshid, Richard, of Southampton, husbandman 0
3688601 1922594 1922594 plaintiff Dawtry John (legal representative) 586254 586254 Dawtry, John, of Southampton, knight, executors of 0
3688604 1922595 1922595 plaintiff Dawtry John (legal representative) 586254 586254 Dawtry, John, of Southampton, knight, executors of 0
3688648 1922610 1922610 defendant Marshe Thomas keeper of the tin house 586254 586254 Marshe, Thomas, of Southampton, yeoman, keeper of the tin house 1
3690321 1923135 1923135 defendant Marsshe Thomas merchant 586254 586254 Marsshe, Thomas, of Southampton, merchant 0
3690893 1923315 1923315 defendant Marshe Thomas merchant 586254 586254 Marshe, Thomas, of Southampton, merchant 0
3697496 1925437 1925437 defendant Lyster Thomas merchant 586254 586254 Lyster, Thomas, of Southampton, merchant 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);