names

234 rows where place_id = 590479

✎ 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
3601338 1868085 1868085 defendant Newenton Hugh chaplain 590479 590479 Newenton, Hugh, of Southwerk, chaplain 0
3604281 1869002 1869002 defendant Kyng Henry innholder 590479 590479 Kyng, Henry, of Southwerk, innholder 0
3607541 1870016 1870016 defendant Scotte Richard yeoman 590479 590479 Scotte, Richard, of Southwerk, yeoman 2
3609396 1870599 1870599 defendant Comber Richard tailor 590479 590479 Comber, Richard, of Southwerk, tailor 0
3609459 1870623 1870623 defendant Kyng Henry innholder 590479 590479 Kyng, Henry, of Southwerk, innholder 2
3614477 1872176 1872176 defendant Herford John waterman 590479 590479 Herford, John, of Southwerk, waterman 1
3618701 1873472 1873472 defendant Barret Joan widow 590479 590479 Barret, Joan, of Southwerk, widow 0
3633213 1905201 1905201 defendant Couper John vintner 590479 590479 Couper, John, of Southwerk, vintner 0
3640447 1907444 1907444 defendant Heret Peter dyer 590479 590479 Heret, Peter, of Southwerk, dyer 0
3665627 1915200 1915200 defendant Bowyer John butcher 590479 590479 Bowyer, John, of Southwerk, butcher 0
3671850 1917196 1917196 plaintiff Cooke Richard brewer 590479 590479 Cooke, Richard, of Southwerk, brewer 0
3672367 1917360 1917360 defendant Magior Nicholas clerk 590479 590479 Magior, Nicholas, of Southwerk, clerk 1
3673374 1917690 1917690 defendant Sympson Robert barber 590479 590479 Sympson, Robert, of Southwerk, barber 0
3676389 1918661 1918661 plaintiff Jakson William fuller 590479 590479 Jakson, William, of Southwerk, fuller 0
3678931 1919478 1919478 defendant Pylkyngton Richard glasier 590479 590479 Pylkyngton, Richard, of Southwerk, glasier 1
3678933 1919478 1919478 defendant Sherburn William glasier 590479 590479 Sherburn, William, of Southwerk, glasier 3
3681958 1920461 1920461 defendant Hogell John butcher 590479 590479 Hogell, John, of Southwerk, butcher 2
3686652 1921979 1921979 defendant Michell John baker 590479 590479 Michell, John, of Southwerk, baker 0
3687663 1922310 1922310 defendant Johnson Andrew smith 590479 590479 Johnson, Andrew, of Southwerk, smith 0
3694866 1924602 1924602 defendant Bryan John fruiterer 590479 590479 Bryan, John, of Southwerk, fruiterer 1
3701743 1926790 1926790 defendant Michell John baker 590479 590479 Michell, John, of Southwerk, baker 0
3702130 1926925 1926925 defendant Bradley John smith 590479 590479 Bradley, John, of Southwerk, smith 0
3704518 1927707 1927707 defendant Cowper Richard   590479 590479 Cowper, Richard, of Southwerk, fell monger 1
3710255 1929523 1929523 plaintiff Scragge John leather seller 590479 590479 Scragge, John, of Southwerk, or of London, leather seller 0
3710257 1929524 1929524 plaintiff Scragge John leather seller 590479 590479 Scragge, John, of Southwerk, or of London, leather seller 0
3714428 1930807 1930807 defendant Tossy Thomas vintner 590479 590479 Tossy, Thomas, of Southwerk, vintner 0
3714720 1930904 1930904 defendant Flower Francis glasier to the king 590479 590479 Flower, Francis, of Southwerk, glasier to the king 0
3715875 1931250 1931250 plaintiff Cartwryght Richard butcher 590479 590479 Cartwryght, Richard, of Southwerk, butcher 0
3731299 1936015 1936015 defendant Williams Paul   590479 590479 Williams, Paul, of Southwerk, pouch maker 0
3739030 1938413 1938413 defendant Redyng Edmund grocer 590479 590479 Redyng, Edmund, of Southwerk, grocer 0
3740963 1939034 1939034 defendant Tyffyn Nicholas   590479 590479 Tyffyn, Nicholas, of Southwerk, hat maker 0
3740964 1939034 1939034 defendant Dovald Giles   590479 590479 Dovald, Giles, of Southwerk, hat maker 1
3741292 1939138 1939138 defendant Bradley John smith 590479 590479 Bradley, John, of Southwerk, smith 0
3741300 1939142 1939142 defendant Holt James gent 590479 590479 Holt, James, of Southwerk, gent 0
3741778 1939292 1939292 defendant Wentworth Thomas   590479 590479 Wentworth, Thomas, of Southwerk, knight 1
3745187 1940400 1940400 defendant Lyncolne James   590479 590479 Lyncolne, James, of Southwerk, cook 2
3747439 1941114 1941114 defendant Yong Henry barber 590479 590479 Yong, Henry, of Southwerk, barber 0
3765146 1946761 1946761 plaintiff Kellett Walter barber 590479 590479 Kellett, Walter, of Southwerk, barber 0
3768564 1947812 1947812 defendant Lamplowe Thomas glover 590479 590479 Lamplowe, Thomas, of Southwerk, glover 4
3774774 1949838 1949838 defendant Wentworth Thomas   590479 590479 Wentworth, Thomas, of Southwerk, knight 0
3788966 1954360 1954360 defendant Sykkyll William fuller 590479 590479 Sykkyll, William, of Southwerk, fuller 0
3789510 1954545 1954545 defendant Robers Thomas currier 590479 590479 Robers, Thomas, of Southwerk, currier 0
3789511 1954545 1954545 defendant Tyffyn John laborer 590479 590479 Tyffyn, John, of Southwerk, laborer 1
3789512 1954545 1954545 defendant Walys Elizabeth singlewoman 590479 590479 Walys, Elizabeth, of Southwerk, singlewoman 2
3797457 1957092 1957092 defendant Warde Thomas bnutcher 590479 590479 Warde, Thomas, of Southwerk, bnutcher 0
3799002 1957599 1957599 defendant Dasshaunce Lawrence   590479 590479 Dasshaunce, Lawrence, of Southwerk, hat maker 0
3803437 1958977 1958977 defendant Strowd Roger yeoman 590479 590479 Strowd, Roger, of Southwerk, yeoman 0
3806830 1960041 1960041 defendant Payne William yeoman 590479 590479 Payne, William, of Southwerk, yeoman 0
3810091 1961046 1961046 defendant Marshall William clerk 590479 590479 Marshall, William, of Southwerk, clerk 1
3832330 1968028 1968028 defendant Carew Gavin esq 590479 590479 Carew, Gavin, of Southwerk, esq 0
3834045 1968588 1968588 plaintiff Maye Robert grocer 590479 590479 Maye, Robert, of Southwerk, grocer 0
3834811 1968825 1968825 defendant Braggys William clerk 590479 590479 Braggys, William, of Southwerk, clerk 0
3843456 1971491 1971491 plaintiff Clerk John tailor 590479 590479 Clerk, John, of Southwerk, tailor 0
3843460 1971491 1971491 defendant Kellett Margaret widow 590479 590479 Kellett, Margaret, of Southwerk, widow 3
3843472 1971496 1971496 plaintiff Clerke John tailor 590479 590479 Clerke, John, of Southwerk, tailor 0
3843476 1971496 1971496 defendant Kelett Margaret widow 590479 590479 Kelett, Margaret, of Southwerk, widow 3
3843477 1971497 1971497 plaintiff Clerke John tailor 590479 590479 Clerke, John, of Southwerk, tailor 0
3848412 1973079 1973079 defendant Wheler Richard baker 590479 590479 Wheler, Richard, of Southwerk, baker 0
3848414 1973080 1973080 defendant Wheler Richard baker 590479 590479 Wheler, Richard, of Southwerk, baker 0
3849464 1973432 1973432 defendant Greneway Richard waterman 590479 590479 Greneway, Richard, of Southwerk, waterman 0
3849476 1973436 1973436 defendant Kellett William innholder 590479 590479 Kellett, William, of Southwerk, innholder 0
3852213 1974290 1974290 defendant Fox Cuthbert painter 590479 590479 Fox, Cuthbert, of Southwerk, painter 0
3854085 1974912 1974912 defendant Rychardson John osteler 590479 590479 Rychardson, John, of Southwerk, osteler 2
3854491 1975044 1975044 defendant Borwell John fuller 590479 590479 Borwell, John, of Southwerk, fuller 0
3859586 1976699 1976699 plaintiff Clerk John tailor 590479 590479 Clerk, John, of Southwerk, tailor 0
3859588 1976699 1976699 defendant Copwod Ralph skinner 590479 590479 Copwod, Ralph, of Southwerk, skinner 1
3873778 1981451 1981451 plaintiff Clerk John yeoman 590479 590479 Clerk, John, of Southwerk, yeoman 0
3873779 1981451 1981451 defendant Kellet Walter (legal representative) 590479 590479 Kellet, Walter, of Southwerk, executor of 0
3874373 1981654 1981654 plaintiff Cravyn Christopher   590479 590479 Cravyn, Christopher, of Southwerk, miller, administrators of 0
3874377 1981655 1981655 plaintiff Cravyn Christopher   590479 590479 Cravyn, Christopher, of Southwerk, miller, administrators of 0
3888542 1986428 1986428 plaintiff Eston John gent 590479 590479 Eston, John, of Southwerk, gent 0
3890123 1986930 1986930 defendant Hampton Christopher tailor 590479 590479 Hampton, Christopher, of Southwerk, tailor 1
3899112 1989911 1989911 defendant Gold Peter yeoman 590479 590479 Gold, Peter, of Southwerk, yeoman 0
3899113 1989912 1989912 plaintiff Barwicke John (legal representative) 590479 590479 Barwicke, John, of Southwerk, tailor, executors of 0
3907845 1992913 1992913 plaintiff Phillipp John (legal representative) 590479 590479 Phillipp, John, of Southwerk, capper, executors of 0
3907847 1992913 1992913 defendant Jones William yeoman 590479 590479 Jones, William, of Southwerk, yeoman 0
3939078 2003396 2003396 defendant Hampton Christopher yeoman & Marshall guardian for the King 590479 590479 Hampton, Christopher, of Southwerk, yeoman & Marshall guardian for the King 1
3983176 2018755 2018755 defendant Gumport Nicholas beer brewer 590479 590479 Gumport, Nicholas, of Southwerk, beer brewer 0
3983177 2018755 2018755 defendant Harmanson Alexander beer brewer 590479 590479 Harmanson, Alexander, of Southwerk, beer brewer 1
4492037 2198197 2198197 defendant Duke John skinner 590479 590479 Duke, John, of Southwerk, skinner 0
4503004 2201509 2201509 defendant Shem--- John   590479 590479 Shem---, John, of Southwerk 1
4539573 2212635 2212635 plaintiff Cutelere Richard   590479 590479 (Cutelere, Richard, of Southwerk, well monger 1
4556255 2217897 2217897 defendant Horner Richard   590479 590479 Horner, Richard, of Southwerk 0
4557681 2218337 2218337 defendant Bowod Robert   590479 590479 Bowod, Robert, of Southwerk 0
4557684 2218338 2218338 defendant Bowod Roger   590479 590479 Bowod, Roger, of Southwerk 0
4557687 2218339 2218339 defendant Dowod Roger   590479 590479 Dowod, Roger, of Southwerk 0
4560406 2219194 2219194 plaintiff Nevile Richard   590479 590479 Nevile, Richard, of Southwerk 0
4570053 2222205 2222205 defendant Preston John   590479 590479 Preston, John, of Southwerk 0
4570796 2222438 2222438 plaintiff Wylton Thomas   590479 590479 Wylton, Thomas, of Southwerk 0
4572523 2222942 2222942 plaintiff atte Gille Alice   590479 590479 atte Gille, Alice, of Southwerk, formerly wife of Thomas atte Gille, sen 0
4577493 2224474 2224474 defendant Stokes John   590479 590479 Stokes, John, of Southwerk 2
4604507 2232576 2232576 defendant Farnham John glover 590479 590479 Farnham, John, of Southwerk, glover 5
4622516 2238021 2238021 plaintiff Lybard John   590479 590479 Lybard, John, of Southwerk 0
4625295 2238878 2238878 plaintiff Parker Giles   590479 590479 Parker, Giles, of Southwerk 0
4628651 2239884 2239884 plaintiff Segrave Walter   590479 590479 Segrave, Walter, of Southwerk 0
4628653 2239885 2239885 plaintiff Segrave Walter   590479 590479 Segrave, Walter, of Southwerk 0
4695514 2264079 2264079 defendant Knyght William   590479 590479 Knyght, William, of Southwerk, shoe maker 0
4741881 2278123 2278123 defendant Knyght William shoemaker 590479 590479 Knyght, William, of Southwerk, shoemaker 0
4746307 2279416 2279416 defendant Dyer Richard dyer 590479 590479 Dyer, Richard, of Southwerk, dyer 0
4746308 2279416 2279416 defendant Dyer Geoffrey dyer 590479 590479 Dyer, Geoffrey, of Southwerk, dyer 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);