names

254 rows where place_id = 586999

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590191 1864573 1864573 plaintiff Colepeper William esq 586999 586999 Colepeper, William, of Aylesford, esq 0
3597204 1866749 1866749 defendant Rowe Alexander husbandman 586999 586999 Rowe, Alexander, of Aylesford, husbandman 1
3613173 1871774 1871774 defendant Pesemeth Alexander laborer 586999 586999 Pesemeth, Alexander, of Aylesford, laborer 2
3615200 1872400 1872400 defendant Pessmyth Alexander husbandman 586999 586999 Pessmyth, Alexander, of Aylesford, husbandman 1
3615205 1872401 1872401 defendant Davy Alexander husbandman 586999 586999 Davy, Alexander, of Aylesford, husbandman 0
3615207 1872402 1872402 defendant Davy Alexander husbandman 586999 586999 Davy, Alexander, of Aylesford, husbandman 0
3615212 1872403 1872403 defendant Perys Roger husbandman 586999 586999 Perys, Roger, of Aylesford, husbandman 3
3615996 1872638 1872638 defendant Faire William yeoman 586999 586999 Faire, William, of Aylesford, yeoman 0
3615997 1872638 1872638 defendant Lytell Richard laborer 586999 586999 Lytell, Richard, of Aylesford, laborer 1
3615999 1872639 1872639 defendant Perys Roger husbandman 586999 586999 Perys, Roger, of Aylesford, husbandman 0
3616000 1872639 1872639 defendant Palmer Henry husbandman 586999 586999 Palmer, Henry, of Aylesford, husbandman 1
3616001 1872639 1872639 defendant Palmer John laborer 586999 586999 Palmer, John, of Aylesford, laborer 2
3616002 1872639 1872639 defendant Perys Thomas laborer 586999 586999 Perys, Thomas, of Aylesford, laborer 3
3616003 1872639 1872639 defendant Perys Richard laborer 586999 586999 Perys, Richard, of Aylesford, laborer 4
3616020 1872645 1872645 defendant Pyers Roger husbandman 586999 586999 Pyers, Roger, of Aylesford, husbandman 0
3620814 1874078 1874078 defendant Rowe Robert gent 586999 586999 Rowe, Robert, of Aylesford, gent 1
3621923 1874400 1874400 defendant Walter Edward husbandman 586999 586999 Walter, Edward, of Aylesford, husbandman 0
3621925 1874401 1874401 defendant Walter Edward husbandman 586999 586999 Walter, Edward, of Aylesford, husbandman 0
3623661 1874933 1874933 defendant Walter Edward husbandman 586999 586999 Walter, Edward, of Aylesford, husbandman 0
3638764 1906943 1906943 defendant Cosyngton Thomas gent 586999 586999 Cosyngton, Thomas, of Aylesford, gent 0
3640713 1907539 1907539 defendant Palmer John husbandman 586999 586999 Palmer, John, of Aylesford, husbandman 2
3651795 1910920 1910920 defendant Honevell William husbandman 586999 586999 Honevell, William, of Aylesford, husbandman 0
3651797 1910921 1910921 defendant Hovenell William husbandman 586999 586999 Hovenell, William, of Aylesford, husbandman 0
3652624 1911157 1911157 defendant Bryse John husbandman 586999 586999 Bryse, John, of Aylesford, husbandman 0
3652627 1911157 1911157 defendant Wilson Robert husbandman 586999 586999 Wilson, Robert, of Aylesford, husbandman 3
3652992 1911266 1911266 defendant Gate Thomas butcher 586999 586999 Gate, Thomas, of Aylesford, butcher 1
3654810 1911764 1911764 defendant Ivernden Lawrence fuller 586999 586999 Ivernden, Lawrence, of Aylesford, fuller 1
3663154 1914393 1914393 defendant Monde William husbandman 586999 586999 Monde, William, of Aylesford, husbandman 0
3663156 1914393 1914393 defendant Herberd John laborer 586999 586999 Herberd, John, of Aylesford, laborer 2
3679654 1919703 1919703 defendant Sale Richard laborer 586999 586999 Sale, Richard, of Aylesford, laborer 2
3679675 1919709 1919709 defendant Palmer John husbandman 586999 586999 Palmer, John, of Aylesford, husbandman 1
3679676 1919709 1919709 defendant Aleyn William carpenter 586999 586999 Aleyn, William, of Aylesford, carpenter 2
3680939 1920119 1920119 defendant Byrche John laborer 586999 586999 Byrche, John, of Aylesford, laborer 1
3680942 1920120 1920120 defendant Byrche John laborer 586999 586999 Byrche, John, of Aylesford, laborer 1
3681650 1920356 1920356 defendant Buntyng James butcher 586999 586999 Buntyng, James, of Aylesford, butcher 1
3699983 1926228 1926228 defendant Mund William husbandman 586999 586999 Mund, William, of Aylesford, husbandman 0
3703236 1927283 1927283 plaintiff Culpeper Edward esq 586999 586999 Culpeper, Edward, of Aylesford, esq 2
3707320 1928579 1928579 defendant Culpeper Edward esq 586999 586999 Culpeper, Edward, of Aylesford, esq 0
3717056 1931620 1931620 plaintiff Culpeper Edward esq 586999 586999 Culpeper, Edward, of Aylesford, esq 2
3718984 1932217 1932217 defendant Duke John gent 586999 586999 Duke, John, of Aylesford, gent 3
3721076 1932887 1932887 defendant Mund William yeoman 586999 586999 Mund, William, of Aylesford, yeoman 1
3722700 1933367 1933367 defendant Evenden Lawrence fuller 586999 586999 Evenden, Lawrence, of Aylesford, fuller 0
3734735 1937110 1937110 defendant Duke John gent 586999 586999 Duke, John, of Aylesford, gent 3
3746905 1940949 1940949 defendant Fuller Robert butcher 586999 586999 Fuller, Robert, of Aylesford, butcher 0
3746908 1940949 1940949 defendant Terrey William laborer 586999 586999 Terrey, William, of Aylesford, laborer 3
3790385 1954810 1954810 defendant Cokkes Thomas gent 586999 586999 Cokkes, Thomas, of Aylesford, gent 0
3794419 1956130 1956130 defendant Palmer John laborer 586999 586999 Palmer, John, of Aylesford, laborer 3
3795156 1956350 1956350 defendant Makenall Robert laborer 586999 586999 Makenall, Robert, of Aylesford, laborer 1
3800267 1958004 1958004 defendant Palmer John husbandman 586999 586999 Palmer, John, of Aylesford, husbandman 0
3809819 1960959 1960959 defendant Palmer John husbandman 586999 586999 Palmer, John, of Aylesford, husbandman 0
3824301 1965473 1965473 plaintiff Warwyk John (legal representative) 586999 586999 Warwyk, John, of Aylesford, beer brewer, executor of 0
3826121 1966011 1966011 defendant Godshalff Nicholas baker 586999 586999 Godshalff, Nicholas, of Aylesford, baker 0
3838158 1969849 1969849 defendant Hawke Richard (legal representative) 586999 586999 Hawke, Richard, of Aylesford, executors of 4
3838159 1969849 1969849 defendant Bull William miller 586999 586999 (Bull, William, of Aylesford, miller 5
3838978 1970119 1970119 defendant Thornton Henry laborer 586999 586999 Thornton, Henry, of Aylesford, laborer 2
3859801 1976779 1976779 defendant Rycardys Thomas thatcher 586999 586999 Rycardys, Thomas, of Aylesford, thatcher 0
3862700 1977719 1977719 defendant Bull William husbandman 586999 586999 Bull, William, of Aylesford, husbandman 0
3884896 1985221 1985221 defendant Bryce John husbandman 586999 586999 Bryce, John, of Aylesford, husbandman 1
3884902 1985222 1985222 defendant Bryce John husbandman 586999 586999 Bryce, John, of Aylesford, husbandman 1
3885350 1985355 1985355 defendant Mordole Robert shipman 586999 586999 Mordole, Robert, of Aylesford, shipman 3
3891852 1987527 1987527 defendant Wylcok John husbandman 586999 586999 Wylcok, John, of Aylesford, husbandman 3
3896816 1989146 1989146 defendant Palmer Robert laborer 586999 586999 Palmer, Robert, of Aylesford, laborer 3
3994575 2022806 2022806 defendant Wyssenden Richard butcher 586999 586999 Wyssenden, Richard, of Aylesford, butcher 0
4015302 2030167 2030167 defendant Warcoppe Henry gent 586999 586999 Warcoppe, Henry, of Aylesford, gent 0
4017742 2031052 2031052 plaintiff Tomlyn John husbandman 586999 586999 Tomlyn, John, of Aylesford, husbandman 0
4017744 2031053 2031053 plaintiff Tomlyn John husbandman 586999 586999 Tomlyn, John, of Aylesford, husbandman 0
4028187 2034728 2034728 defendant Whiskyns William   586999 586999 Whiskyns, William, of Aylesford, sailor 0
4028191 2034730 2034730 defendant Whyskyns William tailor or sailor 586999 586999 Whyskyns, William, of Aylesford, tailor or sailor 0
4046550 2041216 2041216 defendant Warcoppe Henry gent 586999 586999 Warcoppe, Henry, of Aylesford, gent 0
4048584 2041942 2041942 defendant Whyskyn William yeoman 586999 586999 Whyskyn, William, of Aylesford, yeoman 1
4061673 2046574 2046574 defendant Warcoppe Henry gent 586999 586999 Warcoppe, Henry, of Aylesford, gent 0
4063638 2047285 2047285 defendant Tomlyn John husbandman 586999 586999 Tomlyn, John, of Aylesford, husbandman 0
4080371 2053294 2053294 defendant Morse William gent 586999 586999 Morse, William, of Aylesford, gent 0
4111467 2064349 2064349 defendant Warcopp Henry gent 586999 586999 Warcopp, Henry, of Aylesford, gent 1
4150879 2078440 2078440 defendant Lurchen Stephen yeoman 586999 586999 Lurchen, Stephen, of Aylesford, yeoman 0
4150880 2078440 2078440 defendant Thomlynge John yeoman 586999 586999 Thomlynge, John, of Aylesford, yeoman 1
4150882 2078441 2078441 defendant Warcope henry gent 586999 586999 Warcope, henry, of Aylesford, gent 0
4159303 2081324 2081324 defendant Mucklie George smith 586999 586999 Mucklie, George, of Aylesford, smith 0
4175504 2086904 2086904 defendant Tomlynge John yeoman 586999 586999 Tomlynge, John, of Aylesford, yeoman 0
4188576 2091482 2091482 defendant Arowe John yeoman 586999 586999 Arowe John, of Aylesford, yeoman 0
4196994 2094500 2094500 defendant Warcope Henry gent 586999 586999 Warcope, Henry, of Aylesford, gent 0
4232017 2106699 2106699 defendant Mylls Richard carpenter 586999 586999 Mylls, Richard, of Aylesford, carpenter 0
4309970 2133647 2133647 defendant Mylls Richard carpenter 586999 586999 Mylls, Richard, of Aylesford, carpenter 0
4312333 2134449 2134449 defendant Whyskyn William yeoman 586999 586999 Whyskyn, William, of Aylesford, yeoman 2
4320081 2137131 2137131 defendant Palmer Robert yeoman 586999 586999 Palmer, Robert, of Aylesford, yeoman 1
4320082 2137131 2137131 defendant Gyllett Richard blacksmith 586999 586999 Gyllett, Richard, of Aylesford, blacksmith 2
4467315 2190456 2190456 plaintiff atte Seler Thomas   586999 586999 atte Seler, Thomas, of Aylesford 0
4467316 2190456 2190456 defendant Wolsy John   586999 586999 Wolsy, John, of aylesford 0
4518685 2206218 2206218 defendant Stok Nichaols   586999 586999 Stok, Nichaols, of Aylesford, vicar 0
4531875 2210232 2210232 defendant Wade John   586999 586999 Wade, John, of Aylesford 0
4561959 2219672 2219672 defendant Rowe Robert   586999 586999 Rowe, Robert, of Aylesford 0
4582683 2226023 2226023 defendant Prentys Henry   586999 586999 Prentys, Henry, of Aylesford 3
4597269 2230389 2230389 defendant Wolsy John   586999 586999 Wolsy, John, of Aylesford 0
4623748 2238403 2238403 defendant Milleward John   586999 586999 Milleward, John, of Aylesford 0
4646497 2245041 2245041 plaintiff Pyk John   586999 586999 Pyk, John, of Aylesford 0
4653572 2247052 2247052 defendant Hamond Richard shoemaker 586999 586999 Hamond, Richard, of Aylesford, shoemaker 0
4653573 2247052 2247052 defendant Hamond John laborer 586999 586999 Hamond, John, of Aylesford, laborer 1
4745272 2279127 2279127 defendant Bocher John butcher 586999 586999 Bocher, John, of Aylesford, butcher 0
4755874 2282221 2282221 defendant Smyth Robert   586999 586999 Smyth, Robert, of Aylesford 0
4760732 2283697 2283697 defendant Wottone Robert husbandman 586999 586999 Wottone, Robert, of Aylesford, husbandman 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);