names

196 rows where place_id = 593156

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610732 1871021 1871021 defendant Lithego Oliver yeoman 593156 593156 Lithego, Oliver, of Dover, yeoman 0
3614495 1872181 1872181 defendant Lithego Oliver yeoman 593156 593156 Lithego, Oliver, of Dover, yeoman 0
3617720 1873166 1873166 defendant Yong Peter mariner 593156 593156 Yong, Peter, of Dover, mariner 0
3617721 1873166 1873166 defendant Lego Oliver merchant 593156 593156 Lego, Oliver, of Dover, merchant 1
3617722 1873166 1873166 defendant Balgay Henry merchant 593156 593156 Balgay, Henry, of Dover, merchant 2
3646056 1909165 1909165 defendant Vaugham Thomas yeoman 593156 593156 Vaugham, Thomas, of Dover, yeoman 0
3669463 1916387 1916387 defendant Gregory John yeoman 593156 593156 Gregory, John, of Dover, yeoman 0
3690583 1923220 1923220 defendant Sylver Thomas smith 593156 593156 Sylver, Thomas, of Dover, smith 3
3690589 1923221 1923221 defendant Sylver Thomas smith 593156 593156 Sylver, Thomas, of Dover, smith 3
3690593 1923222 1923222 defendant Welden Robert gent 593156 593156 Welden, Robert, of Dover, gent 1
3704711 1927760 1927760 defendant Nethersole Robert gent 593156 593156 Nethersole, Robert, of Dover, gent 0
3707988 1928793 1928793 defendant Vaughan Thomas gent 593156 593156 Vaughan, Thomas, of Dover, gent 0
3714919 1930962 1930962 defendant Ruttour Edward gent 593156 593156 Ruttour, Edward, of Dover, gent 1
3714923 1930962 1930962 defendant Elsham Nicholas brewer 593156 593156 Elsham, Nicholas, of Dover, brewer 5
3718726 1932134 1932134 defendant Nethersole Robert gent 593156 593156 Nethersole, Robert, of Dover, gent 0
3745166 1940394 1940394 defendant Rutter Edward gent 593156 593156 Rutter, Edward, of Dover, gent 1
3745170 1940394 1940394 defendant Elam Nicholas brewer 593156 593156 Elam, Nicholas, of Dover, brewer 5
3773195 1949323 1949323 defendant Vaghan Thomas yeoman 593156 593156 Vaghan, Thomas, of Dover, yeoman 0
3788631 1954248 1954248 defendant Cooper Robert clerk 593156 593156 Cooper, Robert, of Dover, clerk 0
3826692 1966196 1966196 defendant Inmyth Edward yeoman 593156 593156 Inmyth, Edward, of Dover, yeoman 1
3885703 1985474 1985474 defendant Flemyng Thomas gent 593156 593156 Flemyng, Thomas, of Dover, gent 4
3898363 1989664 1989664 defendant Colley Thomas beer brewer 593156 593156 Colley, Thomas, of Dover, beer brewer 0
3910092 1993683 1993683 defendant Colley Thomas beer brewer 593156 593156 Colley, Thomas, of Dover, beer brewer 0
3916919 1996024 1996024 defendant Foxley Thomas yeoman 593156 593156 Foxley, Thomas, of Dover, yeoman 1
3916923 1996025 1996025 defendant Foxley Thomas yeoman 593156 593156 Foxley, Thomas, of Dover, yeoman 1
3932360 2001121 2001121 defendant Foxley Thomas alderman 593156 593156 Foxley, Thomas, of Dover, alderman 2
3932361 2001121 2001121 defendant Fynet Thomas   593156 593156 Fynet, Thomas, of Dover 3
3937721 2002949 2002949 defendant Berwych Richard soldier 593156 593156 Berwych, Richard, of Dover, soldier 1
3951841 2007705 2007705 defendant Mychell Edmund (legal representative) 593156 593156 Mychell, Edmund, of Dover, executors of 1
3953047 2008130 2008130 defendant Allyn Thomas   593156 593156 Allyn, Thomas, of Dover, gent, jurat 1
3953048 2008130 2008130 defendant Allmanson John   593156 593156 Allmanson, John, of Dover, gent, jurat 2
3954618 2008679 2008679 defendant Wollflete Richard baker 593156 593156 Wollflete, Richard, of Dover, baker 0
3956176 2009232 2009232 defendant Smyth James butcher 593156 593156 Smyth, James, of Dover, butcher 0
3968976 2013765 2013765 defendant Burnam Hugh innholder 593156 593156 Burnam, Hugh, of Dover, innholder 0
3969540 2013958 2013958 plaintiff Courtney William merchant 593156 593156 Courtney, William, of Dover, merchant 0
3969542 2013958 2013958 defendant Greneway William yeoman 593156 593156 Greneway, William, of Dover, yeoman 1
3972127 2014812 2014812 defendant Barley John gent 593156 593156 Barley, John, of Dover, gent 2
3976578 2016381 2016381 plaintiff Knappe John, senior   593156 593156 Knappe, John, senior, of Dover, yeoman, "my brother" 0
3991582 2021750 2021750 defendant Hanyngton William gent 593156 593156 Hanyngton, William, of Dover, gent 0
4008486 2027807 2027807 plaintiff Monyng Thomas gent 593156 593156 Monyng, Thomas, of Dover, gent 0
4027383 2034441 2034441 defendant Courtney William   593156 593156 Courtney, William, of Dover, Kent, sailor 0
4027463 2034471 2034471 defendant Andrewes Thomas gent 593156 593156 Andrewes, Thomas, of Dover, gent 0
4028701 2034916 2034916 defendant Warren Thomas gent 593156 593156 Warren, Thomas, of Dover, gent 0
4031859 2036058 2036058 defendant Knap John vintner 593156 593156 Knap, John, of Dover, vintner 0
4045069 2040691 2040691 defendant Munns Richard yeoman 593156 593156 Munns, Richard, of Dover, yeoman 0
4055791 2044453 2044453 defendant Bennett John butcher 593156 593156 Bennett, John, of Dover, butcher 2
4059513 2045796 2045796 defendant Bedwood Edward chapman 593156 593156 Bedwood, Edward, of Dover, chapman 2
4063293 2047165 2047165 defendant Bracebridge William barber 593156 593156 Bracebridge, William, of Dover, barber 1
4070268 2049660 2049660 defendant Harwood Henry mariner 593156 593156 Harwood, Henry, of Dover, mariner 0
4072061 2050309 2050309 plaintiff Norton Clement innholder 593156 593156 Norton, Clement, of Dover, innholder 0
4073079 2050666 2050666 defendant Gryest Roger husbandman 593156 593156 Gryest, Roger, of Dover, husbandman 0
4073084 2050666 2050666 defendant Vaughan Philip husbandman 593156 593156 Vaughan, Philip, of Dover, husbandman 5
4073088 2050667 2050667 defendant Gryest Roger husbandman 593156 593156 Gryest, Roger, of Dover, husbandman 1
4073090 2050667 2050667 defendant Middelton Thomas tailor 593156 593156 Middelton, Thomas, of Dover, tailor 3
4073096 2050668 2050668 plaintiff Pepper Thomas (legal representative) 593156 593156 Pepper, Thomas, of Dover, executrix of 0
4075575 2051567 2051567 defendant Allen Thomas   593156 593156 Allen, Thomas, of Dover, gent, and of househild of Mathew, Archbishop of Canterbury 0
4079895 2053110 2053110 defendant Seintpere or Sempter Peter merchant 593156 593156 Seintpere or Sempter, Peter, of Dover, merchant 0
4081314 2053627 2053627 defendant Willis William beer brewer 593156 593156 Willis, William, of Dover, beer brewer 1
4082699 2054119 2054119 defendant Seyntpere Peter merchant 593156 593156 Seyntpere, Peter, of Dover, merchant 0
4082701 2054120 2054120 defendant Seyntpere Peter merchant 593156 593156 Seyntpere, Peter, of Dover, merchant 0
4105996 2062435 2062435 defendant Philpott Robert beer brewer 593156 593156 Philpott, Robert, of Dover, yeoman, beer brewer 0
4107175 2062862 2062862 plaintiff Pepper Thomas (legal representative) 593156 593156 Pepper, Thomas, of Dover, executrix of 0
4114359 2065421 2065421 defendant Haynes John innholder 593156 593156 Haynes, John, of Dover, innholder 0
4114360 2065421 2065421 defendant Glyde Geoffrey tailor 593156 593156 Glyde, Geoffrey, of Dover, tailor 1
4121813 2068101 2068101 defendant Carpenter John butcher 593156 593156 Carpenter, John, of Dover, butcher 0
4136295 2073325 2073325 defendant Byng George husbandman 593156 593156 Byng, George, of Dover, husbandman 0
4136976 2073572 2073572 defendant Mylward John gent 593156 593156 Mylward, John, of Dover, gent 0
4175896 2087045 2087045 defendant Gryse Roger gent 593156 593156 Gryse, Roger, of Dover, gent 1
4175897 2087045 2087045 defendant Atkyns William maltman 593156 593156 Atkyns, William, of Dover, maltman 2
4190707 2092312 2092312 defendant Almonson Margery widow of John Almonson 593156 593156 Almonson, Margery, of Dover, widow of John Almonson 0
4194855 2093762 2093762 defendant Warde William   593156 593156 Warde, William, of Dover, sailor 0
4204896 2097253 2097253 defendant Courtney William mariner 593156 593156 Courtney, William, of Dover, mariner 0
4226787 2104843 2104843 defendant Ovill alias Ouldfeild Thomas blacksmith 593156 593156 Ovill alias Ouldfeild, Thomas, of Dover, blacksmith 0
4226789 2104844 2104844 defendant Ovill alias Ouldfeild Thomas blacksmith 593156 593156 Ovill alias Ouldfeild, Thomas, of Dover, blacksmith 0
4260906 2116612 2116612 defendant Lowe Edmund mariner 593156 593156 Lowe, Edmund, of Dover, mariner 1
4260907 2116612 2116612 defendant Howson alias Stone Somer   593156 593156 Howson alias Stone, Somer, of Dover, sailor 2
4260908 2116612 2116612 defendant Hedge alias Gadge Robert   593156 593156 Hedge alias Gadge, Robert, of Dover, sailor 3
4260910 2116613 2116613 defendant Grenfilde John   593156 593156 Grenfilde, John, of Dover, Kent, sailor 0
4260911 2116613 2116613 defendant Gayne James   593156 593156 Gayne, James, of Dover, sailor 1
4260912 2116613 2116613 defendant Bever John mariner 593156 593156 Bever, John, of Dover, mariner 2
4260913 2116613 2116613 defendant Worthington John cooper 593156 593156 Worthington, John, of Dover, cooper 3
4260916 2116614 2116614 defendant Lowe Edmund mariner 593156 593156 Lowe, Edmund, of Dover, mariner 1
4260917 2116614 2116614 defendant Hedge alias Eadge Robert   593156 593156 Hedge alias Eadge, Robert, of Dover, sailor 2
4260934 2116618 2116618 defendant Grenfilde John   593156 593156 Grenfilde, John, of Dover, Kent, sailor 0
4260935 2116618 2116618 defendant Gayne James   593156 593156 Gayne, James, of Dover, sailor 1
4260936 2116618 2116618 defendant Bever John cooper 593156 593156 Bever, John, of Dover, cooper 2
4260937 2116618 2116618 defendant Worthington or Wordington John cooper 593156 593156 Worthington or Wordington, John, of Dover, cooper 3
4271801 2120144 2120144 defendant Osborne Nicholas merchant 593156 593156 Osborne, Nicholas, of Dover, merchant 1
4280812 2123192 2123192 defendant Pickeringe Richard clerk 593156 593156 Pickeringe, Richard, of Dover, clerk 0
4280871 2123213 2123213 defendant Pyckeringe Richard clerk 593156 593156 Pyckeringe, Richard, of Dover, clerk 0
4289866 2126436 2126436 defendant Pyckeringe Richard clerk 593156 593156 Pyckeringe, Richard, of Dover, clerk 0
4289868 2126437 2126437 defendant Pyckerynge Richard clerk 593156 593156 Pyckerynge, Richard, of Dover, clerk 0
4300537 2130285 2130285 defendant Packman Mathew gent 593156 593156 Packman, Mathew, of Dover, gent 0
4312799 2134606 2134606 defendant Swann Francis husbandman 593156 593156 Swann, Francis, of Dover, husbandman 0
4330762 2140589 2140589 defendant Bargrove John tanner 593156 593156 Bargrove, John, of Dover, tanner 0
4338230 2143112 2143112 defendant Kempe Edward merchant 593156 593156 Kempe, Edward, of Dover, merchant 1
4349892 2147224 2147224 defendant Smekert Mathew bricklayer 593156 593156 Smekert, Mathew, of Dover, bricklayer 0
4373850 2155715 2155715 defendant Fenner George, junior gent 593156 593156 Fenner, George, junior, of Dover, gent 1
4399717 2164494 2164494 defendant Bargar John tanner 593156 593156 Bargar, John, of Dover, tanner 0
4399718 2164494 2164494 defendant Meade Humphrey   593156 593156 Meade, Humphrey, of Dover, gent, jurat 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);