names

1,772 rows where place_id = 586487

✎ 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
3588846 1864160 1864160 defendant Stafford alias Staffordshire Roger waterman 586487 586487 Stafford alias Staffordshire, Roger, of Suthwerk, waterman 0
3589302 1864296 1864296 defendant Barton Robert baker 586487 586487 Barton, Robert, of Suthwerk, baker 0
3589303 1864296 1864296 defendant Tuppenson Brian baker 586487 586487 Tuppenson, Brian, of Suthwerk, baker 1
3589304 1864296 1864296 defendant Skot John brewer 586487 586487 Skot, John, of Suthwerk, brewer 2
3594233 1865838 1865838 plaintiff Kebbes Thomas butcher 586487 586487 Kebbes, Thomas, of Suthwerk, butcher 0
3594234 1865838 1865838 defendant Rouncyvale John yeoman 586487 586487 Rouncyvale, John, of Suthwerk, yeoman 0
3594235 1865838 1865838 defendant Shoveler John   586487 586487 Shoveler, John, of Suthwerk, fustian shearer 1
3594774 1865991 1865991 defendant Byrte Ralph yeoman 586487 586487 Byrte, Ralph, of Suthwerk, yeoman 0
3594775 1865991 1865991 defendant Walton John yeoman 586487 586487 Walton, John, of Suthwerk, yeoman 1
3594776 1865991 1865991 defendant Aldenham John tanner 586487 586487 Aldenham, John, of Suthwerk, tanner 2
3594778 1865991 1865991 defendant Turnebulle John whitawer 586487 586487 Turnebulle, John, of Suthwerk, whitawer 4
3594821 1866009 1866009 defendant Graystok William esq 586487 586487 Graystok, William, of Suthwerk, esq 0
3596519 1866545 1866545 defendant Couper Robert   586487 586487 Couper, Robert, of Suthwerk, tallow chandler 0
3596520 1866545 1866545 defendant Cornysshe John dyer 586487 586487 Cornysshe, John, of Suthwerk, dyer 1
3596521 1866545 1866545 defendant Calverley Richard fuller 586487 586487 Calverley, Richard, of Suthwerk, fuller 2
3597845 1866945 1866945 defendant Averey Thomas gent 586487 586487 Averey, Thomas, of Suthwerk, gent 0
3598116 1867040 1867040 plaintiff Shorte Thomas (legal representative) 586487 586487 Shorte, Thomas, of Suthwerk, butcher, executors of 0
3598120 1867041 1867041 plaintiff Shorte Thomas (legal representative) 586487 586487 Shorte, Thomas, of Suthwerk, butcher, executors of 0
3598810 1867254 1867254 defendant Peper John brewer 586487 586487 Peper, John, of Suthwerk, brewer 1
3598827 1867257 1867257 defendant Peper John brewer 586487 586487 Peper, John, of Suthwerk, brewer 1
3599063 1867343 1867343 defendant Thurstone John innholder 586487 586487 Thurstone, John, of Suthwerk, innholder 2
3600621 1867841 1867841 defendant Priour Richard dyer 586487 586487 Priour, Richard, of Suthwerk, dyer 0
3600625 1867843 1867843 defendant Pryour Richard dyer 586487 586487 Pryour, Richard, of Suthwerk, dyer 0
3600765 1867899 1867899 defendant Pydyok Geoffrey gent 586487 586487 Pydyok, Geoffrey, of Suthwerk, gent 1
3600780 1867905 1867905 defendant Shethasen Robert drayman 586487 586487 Shethasen, Robert, of Suthwerk, drayman 0
3601109 1868010 1868010 defendant Marchaunt William   586487 586487 Marchaunt, William, of Suthwerk, parish clerk 0
3601110 1868010 1868010 defendant Skynner Robert sherman 586487 586487 Skynner, Robert, of Suthwerk, sherman 1
3601111 1868010 1868010 defendant Speryng Robert carpenter 586487 586487 Speryng, Robert, of Suthwerk, carpenter 2
3601112 1868010 1868010 defendant Underhyll William dyer 586487 586487 Underhyll, William, of Suthwerk, dyer 3
3601113 1868010 1868010 defendant Skynner Michael skinner 586487 586487 Skynner, Michael, of Suthwerk, skinner 4
3601309 1868075 1868075 defendant Goddysmarke Nicholas husbandman 586487 586487 Goddysmarke, Nicholas, of Suthwerk, husbandman 0
3602048 1868301 1868301 plaintiff Bowele John   586487 586487 Bowele, John, of Suthwerk, tallow chandler 0
3602359 1868398 1868398 defendant Godfrey Elizabeth widow 586487 586487 Godfrey, Elizabeth, of Suthwerk, widow 0
3602360 1868398 1868398 defendant Bryggys Thomas dyer 586487 586487 Bryggys, Thomas, of Suthwerk, dyer 1
3602361 1868398 1868398 defendant Armerer Joce armorer 586487 586487 Armerer, Joce, of Suthwerk, armorer 2
3602362 1868398 1868398 defendant Duke John   586487 586487 Duke, John, of Suthwerk, card maker 3
3602363 1868398 1868398 defendant Lonan or Lovan Anthony   586487 586487 Lonan or Lovan, Anthony, of Suthwerk, hat maker 4
3602921 1868577 1868577 defendant Bagger Thomas saddler 586487 586487 Bagger, Thomas, of Suthwerk, saddler 0
3602922 1868577 1868577 defendant Hynton William foyster 586487 586487 Hynton, William, of Suthwerk, foyster 1
3602924 1868577 1868577 defendant Bowen Thomas brewer 586487 586487 Bowen, Thomas, of Suthwerk, brewer 3
3603239 1868682 1868682 defendant Sympson Nicholas brewer 586487 586487 Sympson, Nicholas, of Suthwerk, brewer 0
3604458 1869062 1869062 defendant Bowle John armorer 586487 586487 Bowle, John, of Suthwerk, armorer 0
3605503 1869386 1869386 plaintiff Kebbes Thomas (legal representative) 586487 586487 Kebbes, Thomas, of Suthwerk, butcher, executors of 0
3605507 1869386 1869386 defendant Rouncevall John yeoman 586487 586487 Rouncevall, John, of Suthwerk, yeoman 2
3605508 1869387 1869387 plaintiff Kebbes Thomas (legal representative) 586487 586487 Kebbes, Thomas, of Suthwerk, butcher, executors of 0
3605626 1869425 1869425 defendant Kyng Henry yeoman 586487 586487 Kyng, Henry, of Suthwerk, yeoman 0
3606818 1869802 1869802 defendant Sparowe Thomas currier 586487 586487 Sparowe, Thomas, of Suthwerk, currier 0
3606849 1869808 1869808 defendant Alynne Richard cooper 586487 586487 Alynne, Richard, of Suthwerk, cooper 1
3607026 1869862 1869862 defendant Hardwyke John brewer 586487 586487 Hardwyke, John, of Suthwerk, brewer 0
3607542 1870016 1870016 defendant Gryme Robert clerk 586487 586487 Gryme, Robert, of Suthwerk, clerk 3
3608360 1870273 1870273 defendant Grafton Henry barber 586487 586487 Grafton, Henry, of Suthwerk, barber 2
3608719 1870389 1870389 defendant Brandon Elizabeth widow 586487 586487 Brandon, Elizabeth, of Suthwerk, widow 0
3609353 1870585 1870585 defendant Marshall Ralph   586487 586487 Marshall, Ralph, of Suthwerk, fell monger 4
3610605 1870982 1870982 defendant Marchall Ralph glover 586487 586487 Marchall, Ralph, of Suthwerk, glover 0
3612647 1871594 1871594 defendant Wode Agnes widow 586487 586487 Wode, Agnes, of Suthwerk, widow 1
3612791 1871652 1871652 defendant Kyng Henry yeoman 586487 586487 Kyng, Henry, of Suthwerk, yeoman 0
3613015 1871720 1871720 defendant Kyng Henry yeoman 586487 586487 Kyng, Henry, of Suthwerk, yeoman 0
3613222 1871789 1871789 defendant Williamson John brewer 586487 586487 Williamson, John, of Suthwerk, brewer 1
3614238 1872121 1872121 plaintiff Stanley Lionel yeoman 586487 586487 Stanley, Lionel, of Suthwerk, yeoman 1
3614239 1872121 1872121 plaintiff Yong William yeoman 586487 586487 Yong, William, of Suthwerk, yeoman 2
3614240 1872121 1872121 plaintiff Burneham Robert yeoman 586487 586487 Burneham, Robert, of Suthwerk, yeoman 3
3614243 1872122 1872122 plaintiff Stanley Lionel yeoman 586487 586487 Stanley, Lionel, of Suthwerk, yeoman 1
3614244 1872122 1872122 plaintiff Yong William yeoman 586487 586487 Yong, William, of Suthwerk, yeoman 2
3614245 1872122 1872122 plaintiff Burneham Robert yeoman 586487 586487 Burneham, Robert, of Suthwerk, yeoman 3
3614352 1872143 1872143 defendant Foster John smith 586487 586487 Foster, John, of Suthwerk, smith 1
3614353 1872143 1872143 defendant Freman John glover 586487 586487 Freman, John, of Suthwerk, glover 2
3614456 1872171 1872171 defendant Wodford Roger brewer 586487 586487 Wodford, Roger, of Suthwerk, brewer 0
3614479 1872176 1872176 defendant Wodford Roger brewer 586487 586487 Wodford, Roger, of Suthwerk, brewer 3
3616245 1872722 1872722 defendant Yong William yeoman 586487 586487 Yong, William, of Suthwerk, yeoman 1
3616246 1872722 1872722 defendant Burneham Robert yeoman 586487 586487 Burneham, Robert, of Suthwerk, yeoman 2
3617918 1873228 1873228 defendant Asshcombe John butcher 586487 586487 Asshcombe, John, of Suthwerk, butcher 2
3618099 1873283 1873283 defendant Nobyll William carpenter 586487 586487 Nobyll, William, of Suthwerk, carpenter 0
3619429 1873652 1873652 defendant Shacler John dyer 586487 586487 Shacler, John, of Suthwerk, dyer 2
3619577 1873690 1873690 defendant Danne Walter yeoman 586487 586487 Danne, Walter, of Suthwerk, yeoman 0
3620242 1873909 1873909 defendant Wodewarde Richard gent 586487 586487 Wodewarde, Richard, of Suthwerk, gent 0
3620243 1873909 1873909 defendant Moton Thomas gent 586487 586487 Moton, Thomas, of Suthwerk, gent 1
3621083 1874149 1874149 defendant Grey William yeoman 586487 586487 Grey, William, of Suthwerk, yeoman 0
3621218 1874177 1874177 defendant Turpynson Brian baker 586487 586487 Turpynson, Brian, of Suthwerk, baker 0
3621571 1874288 1874288 defendant Wylde Lewis skinner 586487 586487 Wylde, Lewis, of Suthwerk, skinner 0
3621770 1874347 1874347 defendant Gryme Robert clerk 586487 586487 Gryme, Robert, of Suthwerk, clerk 2
3623100 1874748 1874748 defendant Curlewe William miller 586487 586487 Curlewe, William, of Suthwerk, miller 0
3624525 1875207 1875207 defendant Wodeward Richard gent 586487 586487 Wodeward, Richard, of Suthwerk, gent 0
3624676 1875254 1875254 defendant Newyngton Robert carpenter 586487 586487 Newyngton, Robert, of Suthwerk, carpenter 0
3624834 1875303 1875303 defendant Hylton William fellmonger 586487 586487 Hylton, William, of Suthwerk, fellmonger 0
3624835 1875303 1875303 defendant Rammysgate John yeoman 586487 586487 Rammysgate, John, of Suthwerk, yeoman 1
3624836 1875303 1875303 defendant Bryan William currier 586487 586487 Bryan, William, of Suthwerk, currier 2
3624837 1875303 1875303 defendant Fox John fellmonger 586487 586487 Fox, John, of Suthwerk, fellmonger 3
3624838 1875303 1875303 defendant Calverley Richard fuller 586487 586487 Calverley, Richard, of Suthwerk, fuller 4
3624839 1875303 1875303 defendant Chessher John   586487 586487 Chessher, John, of Suthwerk, hat maker 5
3624842 1875304 1875304 defendant Lymmes alias Rammysgate John laborer 586487 586487 (Lymmes alias Rammysgate, John, of Suthwerk, laborer 1
3625502 1875516 1875516 defendant Sympson Thomas brasier 586487 586487 Sympson, Thomas, of Suthwerk, brasier 1
3625580 1875534 1875534 defendant Courtman William brewer 586487 586487 Courtman, William, of Suthwerk, brewer 0
3626145 1903039 1903039 defendant Sharperowe William miller 586487 586487 Sharperowe, William, of Suthwerk, miller 1
3627337 1903401 1903401 defendant Drake Richard butcher 586487 586487 Drake, Richard, of Suthwerk, butcher 0
3628451 1903765 1903765 defendant Elyot Thomas roper 586487 586487 Elyot, Thomas, of Suthwerk, roper 0
3631756 1904739 1904739 defendant Dymor John tailor 586487 586487 (Dymor, John, of Suthwerk, tailor 4
3637386 1906500 1906500 defendant Lytelcarre John yeoman 586487 586487 Lytelcarre, John, of Suthwerk, yeoman 0
3637969 1906695 1906695 defendant Croft Maurice fisher 586487 586487 Croft, Maurice, of Suthwerk, fisher 3
3637970 1906695 1906695 defendant Webbe John waterman 586487 586487 Webbe, John, of Suthwerk, waterman 4
3638796 1906954 1906954 defendant Gregorye John goldsmith 586487 586487 Gregorye, John, of Suthwerk, goldsmith 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);