names

318 rows where place_id = 586030

✎ 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
3587738 1863811 1863811 defendant Warner Thomas merchant 586030 586030 Warner, Thomas, of Kyngeston on Hull, merchant 0
3588061 1863916 1863916 defendant Myndram Henry chapman 586030 586030 Myndram, Henry, of Kyngeston on Hull, chapman 2
3589237 1864278 1864278 defendant Brompton William (legal representative) 586030 586030 Brompton, William, of Kyngeston on Hull, merchant, executor of 0
3589238 1864278 1864278 defendant Brompton Robert merchant 586030 586030 Brompton, Robert, of Kyngeston on Hull, merchant 1
3590957 1864798 1864798 defendant Lyndeley Edward gent 586030 586030 Lyndeley, Edward, of Kyngeston on Hull, gent 1
3592897 1865396 1865396 defendant Thorn John merchant 586030 586030 Thorn, John, of Kyngeston on Hull, merchant 0
3594299 1865852 1865852 defendant Thorn John merchant 586030 586030 Thorn, John, of Kyngeston on Hull, merchant 0
3594300 1865852 1865852 defendant Warner Thomas merchant 586030 586030 Warner, Thomas, of Kyngeston on Hull, merchant 1
3595526 1866237 1866237 defendant Porter Robert merchant 586030 586030 Porter, Robert, of Kyngeston on Hull, merchant 0
3596478 1866528 1866528 defendant Brompton William (legal representative) 586030 586030 Brompton, William, of Kyngeston on Hull, merchant, executor of 0
3596479 1866528 1866528 defendant Brompton Robert merchant 586030 586030 Brompton, Robert, of Kyngeston on Hull, merchant 1
3597543 1866854 1866854 defendant Goodnape William merchant 586030 586030 Goodnape, William, of Kyngeston on Hull, merchant 0
3607509 1870008 1870008 defendant Baron Edward merchant 586030 586030 Baron, Edward, of Kyngeston on Hull, merchant 0
3607512 1870008 1870008 defendant Everyngham John (legal representative) 586030 586030 Everyngham, John, of Kyngeston on Hull, merchant, administrator of 3
3607513 1870008 1870008 defendant Fyssher William merchant 586030 586030 Fyssher, William, of Kyngeston on Hull, merchant 4
3608329 1870263 1870263 defendant Welysby Edmund merchant 586030 586030 (Welysby, Edmund, of Kyngeston on Hull, merchant 1
3609450 1870620 1870620 defendant Gysburgh Nicholas gent 586030 586030 Gysburgh, Nicholas, of Kyngeston on Hull, gent 1
3609452 1870621 1870621 defendant Thomlynson James merchant 586030 586030 Thomlynson, James, of Kyngeston on Hull, merchant 0
3612454 1871526 1871526 defendant Johnson Henry beer brewer 586030 586030 Johnson, Henry, of Kyngeston on Hull, beer brewer 0
3612455 1871526 1871526 defendant Quharton Alexander merchant 586030 586030 Quharton, Alexander, of Kyngeston on Hull, merchant 1
3612768 1871645 1871645 defendant Thomlynson James merchant 586030 586030 Thomlynson, James, of Kyngeston on Hull, merchant 0
3612769 1871645 1871645 defendant Eland John gent 586030 586030 Eland, John, of Kyngeston on Hull, gent 1
3612770 1871645 1871645 defendant Bank Thomas walker 586030 586030 Bank, Thomas, of Kyngeston on Hull, walker 2
3615324 1872437 1872437 defendant Felton Thomas merchant 586030 586030 Felton, Thomas, of Kyngeston on Hull, merchant 1
3619471 1873654 1873654 defendant Lyndley Margaret widow 586030 586030 (Lyndley, Margaret, of Kyngeston on Hull, widow 1
3619472 1873654 1873654 defendant Busshell Roger merchant 586030 586030 Busshell, Roger, of Kyngeston on Hull, merchant 2
3619842 1873781 1873781 defendant Colston Robert laborer 586030 586030 Colston, Robert, of Kyngeston on Hull, laborer 4
3621921 1874399 1874399 defendant Taverner John merchant 586030 586030 Taverner, John, of Kyngeston on Hull, merchant 0
3623355 1874835 1874835 defendant Belop John barber 586030 586030 Belop, John, of Kyngeston on Hull, barber 0
3623356 1874835 1874835 defendant Colyngwode Richard barber 586030 586030 Colyngwode, Richard, of Kyngeston on Hull, barber 1
3623357 1874835 1874835 defendant Saunderson Ralph smith 586030 586030 Saunderson, Ralph, of Kyngeston on Hull, smith 2
3623358 1874835 1874835 defendant Rychardson Robert yeoman 586030 586030 Rychardson, Robert, of Kyngeston on Hull, yeoman 3
3623359 1874835 1874835 defendant Brakenburgh Edmund yeoman 586030 586030 Brakenburgh, Edmund, of Kyngeston on Hull, yeoman 4
3624255 1875118 1875118 defendant Lyndsey John merchant 586030 586030 Lyndsey, John, of Kyngeston on Hull, merchant 0
3624257 1875119 1875119 defendant Lyndsey John merchant 586030 586030 Lyndsey, John, of Kyngeston on Hull, merchant 0
3647486 1909603 1909603 defendant Stevenson Robert barber 586030 586030 Stevenson, Robert, of Kyngeston on Hull, barber 0
3671637 1917117 1917117 defendant Madyson Edward merchant 586030 586030 Madyson, Edward, of Kyngeston on Hull, merchant 0
3678104 1919201 1919201 defendant Maxwell Charles merchant 586030 586030 Maxwell, Charles, of Kyngeston on Hull, merchant 0
3678106 1919202 1919202 defendant Maxwell Charles merchant 586030 586030 Maxwell, Charles, of Kyngeston on Hull, merchant 0
3678925 1919477 1919477 defendant Garnet Peter yeoman 586030 586030 Garnet, Peter, of Kyngeston on Hull, yeoman 1
3678926 1919477 1919477 defendant Walker Geoffrey yeoman 586030 586030 Walker, Geoffrey, of Kyngeston on Hull, yeoman 2
3685341 1921569 1921569 defendant Moor William miller 586030 586030 Moor, William, of Kyngeston on Hull, miller 0
3687083 1922132 1922132 defendant Madyson Edward merchant of the staple 586030 586030 Madyson, Edward, of Kyngeston on Hull, merchant of the staple 0
3687086 1922132 1922132 defendant Goodknap William merchant of the staple 586030 586030 Goodknap, William, of Kyngeston on Hull, merchant of the staple 3
3695823 1924927 1924927 defendant Eland John merchant of the staple 586030 586030 Eland, John, of Kyngeston on Hull, merchant of the staple 0
3702669 1927103 1927103 defendant Pellet Robert merchant 586030 586030 Pellet, Robert, of Kyngeston on Hull, merchant 0
3716388 1931418 1931418 defendant Buckton William gent 586030 586030 Buckton, William, of Kyngeston on Hull, gent 0
3718913 1932195 1932195 defendant Paynter Ralph master of the Mary Kateryn of Hull 586030 586030 Paynter, Ralph, of Kyngeston on Hull, mariner, master of the Mary Kateryn of Hull 0
3719444 1932353 1932353 defendant Mateson William merchant 586030 586030 Mateson, William, of Kyngeston on Hull, merchant 8
3732163 1936295 1936295 defendant Sall Richard merchant 586030 586030 Sall, Richard, of Kyngeston on Hull, merchant 0
3741900 1939332 1939332 defendant Madeson Edward merchant 586030 586030 Madeson, Edward, of Kyngeston on Hull, merchant 0
3746251 1940736 1940736 plaintiff Clerke William beer brewer 586030 586030 Clerke, William, of Kyngeston on Hull, beer brewer 0
3758983 1944799 1944799 defendant Laurens Thomas merchant 586030 586030 Laurens, Thomas, of Kyngeston on Hull, merchant 1
3758984 1944799 1944799 defendant Paterson George merchant 586030 586030 Paterson, George, of Kyngeston on Hull, merchant 2
3778629 1951027 1951027 defendant Radclyff John merchant 586030 586030 Radclyff, John, of Kyngeston on Hull, merchant 0
3789409 1954512 1954512 defendant Michelson William butcher 586030 586030 Michelson, William, of Kyngeston on Hull, butcher 0
3790304 1954785 1954785 defendant Smyth Thomas merchant 586030 586030 Smyth, Thomas, of Kyngeston on Hull, merchant 0
3803736 1959083 1959083 defendant Danyell Roger merchant 586030 586030 Danyell, Roger, of Kyngeston on Hull, merchant 0
3803737 1959083 1959083 defendant Danyell John merchant 586030 586030 Danyell, John, of Kyngeston on Hull, merchant 1
3806702 1959995 1959995 defendant Cottam Edmund glover 586030 586030 Cottam, Edmund, of Kyngeston on Hull, glover 0
3812748 1961881 1961881 defendant Saull Richard merchant 586030 586030 Saull, Richard, of Kyngeston on Hull, merchant 0
3832130 1967958 1967958 plaintiff Hewyk alias Clerk Thomas   586030 586030 Hewyk alias Clerk, Thomas, of Kyngeston on Hull 0
3832775 1968179 1968179 defendant Oversall Hugh merchant 586030 586030 Oversall, Hugh, of Kyngeston on Hull, merchant 0
3833941 1968553 1968553 defendant Mauman William merchant 586030 586030 (Mauman, William, of Kyngeston on Hull, merchant 1
3833945 1968555 1968555 defendant Sall Richard husbandman 586030 586030 Sall, Richard, of Kyngeston on Hull, husbandman 0
3837491 1969632 1969632 defendant Roy William merchant 586030 586030 Roy, William, of Kyngeston on Hull, merchant 0
3838879 1970088 1970088 plaintiff Walker Robert merchant 586030 586030 Walker, Robert, of Kyngeston on Hull, merchant 0
3839088 1970145 1970145 plaintiff Warker Robert merchant 586030 586030 Warker, Robert, of Kyngeston on Hull, merchant 0
3841576 1970950 1970950 plaintiff Bland Thomas merchant 586030 586030 Bland, Thomas, of Kyngeston on Hull, merchant 0
3843158 1971388 1971388 plaintiff Catterall William merchant 586030 586030 Catterall, William, of Kyngeston on Hull, merchant 0
3843160 1971389 1971389 plaintiff Catterall William merchant 586030 586030 Catterall, William, of Kyngeston on Hull, merchant 0
3844589 1971847 1971847 plaintiff Danyell John merchant 586030 586030 Danyell, John, of Kyngeston on Hull, merchant 0
3844590 1971847 1971847 plaintiff Sall Richard merchant 586030 586030 Sall, Richard, of Kyngeston on Hull, merchant 1
3844869 1971938 1971938 defendant Melborn Thomas yeoman 586030 586030 Melborn, Thomas, of Kyngeston on Hull, yeoman 2
3850158 1973639 1973639 plaintiff Maymond Robert merchant 586030 586030 Maymond, Robert, of Kyngeston on Hull, merchant 0
3850323 1973689 1973689 plaintiff Metterson John merchant 586030 586030 Metterson, John, of Kyngeston on Hull, merchant 0
3852183 1974282 1974282 defendant Lache Anthony merchant 586030 586030 Lache, Anthony, of Kyngeston on Hull, merchant 0
3852624 1974428 1974428 plaintiff Robynson William   586030 586030 Robynson, William, of Kyngeston on Hull, ship carpenter 0
3856324 1975596 1975596 defendant Meymond Robert merchant 586030 586030 Meymond, Robert, of Kyngeston on Hull, merchant 0
3856325 1975596 1975596 defendant Sheffeld Edmund merchant 586030 586030 Sheffeld, Edmund, of Kyngeston on Hull, merchant 1
3856340 1975601 1975601 defendant Dyngeley Henry merchant 586030 586030 Dyngeley, Henry, of Kyngeston on Hull, merchant 0
3856341 1975601 1975601 defendant Kyddale William merchant 586030 586030 Kyddale, William, of Kyngeston on Hull, merchant 1
3856406 1975626 1975626 defendant Bell Miles merchant 586030 586030 Bell, Miles, of Kyngeston on Hull, merchant 0
3866842 1979144 1979144 defendant Dove John merchant 586030 586030 Dove, John, of Kyngeston on Hull, merchant 0
3868835 1979818 1979818 defendant White David merchant 586030 586030 White, David, of Kyngeston on Hull, merchant 1
3870731 1980455 1980455 defendant Woode William merchant 586030 586030 Woode, William, of Kyngeston on Hull, merchant 0
3872232 1980940 1980940 defendant Mayman William merchant 586030 586030 Mayman, William, of Kyngeston on Hull, merchant 0
3873402 1981318 1981318 defendant Browne Thomas merchant 586030 586030 Browne, Thomas, of Kyngeston on Hull, merchant 0
3873405 1981319 1981319 defendant Browne Thomas merchant 586030 586030 Browne, Thomas, of Kyngeston on Hull, merchant 0
3874402 1981665 1981665 defendant Sall Richard merchant 586030 586030 Sall, Richard, of Kyngeston on Hull, merchant 0
3879928 1983545 1983545 defendant Browne Thomas merchant 586030 586030 Browne, Thomas, of Kyngeston on Hull, merchant 1
3879929 1983545 1983545 defendant Maymond Robert merchant 586030 586030 Maymond, Robert, of Kyngeston on Hull, merchant 2
3880703 1983809 1983809 defendant Lache Anthony merchant 586030 586030 Lache, Anthony, of Kyngeston on Hull, merchant 0
3883032 1984591 1984591 defendant Blannchard William merchant 586030 586030 Blannchard, William, of Kyngeston on Hull, merchant 1
3888375 1986373 1986373 defendant Thacker John chapman 586030 586030 Thacker, John, of Kyngeston on Hull, chapman 1
3892211 1987644 1987644 defendant Thomlynson Lawrence merchant 586030 586030 Thomlynson, Lawrence, of Kyngeston on Hull, merchant 0
3892945 1987887 1987887 plaintiff Oversall John merchant 586030 586030 Oversall, John, of Kyngeston on Hull, merchant 0
3892949 1987888 1987888 plaintiff Oversall John merchant 586030 586030 Oversall, John, of Kyngeston on Hull, merchant 0
3894380 1988338 1988338 plaintiff Roger William (legal representative) 586030 586030 Roger, William, of Kyngeston on Hull, merchant, executors of 0
3894384 1988339 1988339 plaintiff Roger William (legal representative) 586030 586030 Roger, William, of Kyngeston on Hull, merchant, executors of 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);