names

162 rows where place_id = 589383

✎ 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
3597444 1866819 1866819 defendant Roggewey James yeoman 589383 589383 Roggewey, James, of Maydeston, Kent, yeoman 0
3598611 1867191 1867191 defendant Shether William husbandman 589383 589383 Shether, William, of Maydeston, Kent, husbandman 0
3618196 1873316 1873316 defendant Dunmowe Stephen chapman 589383 589383 Dunmowe, Stephen, of Maydeston, Kent, chapman 0
3622559 1874592 1874592 defendant Bruer Robert mercer 589383 589383 Bruer, Robert, of Maydeston, Kent, mercer 0
3629004 1903947 1903947 defendant Bruer Robert yeoman 589383 589383 Bruer, Robert, of Maydeston, Kent, yeoman 2
3641041 1907637 1907637 defendant Kyng William tailor 589383 589383 Kyng, William, of Maydeston, Kent, tailor 1
3641043 1907638 1907638 defendant Kyng William tailor 589383 589383 Kyng, William, of Maydeston, Kent, tailor 0
3654992 1911824 1911824 defendant Lucke William husbandman 589383 589383 Lucke, William, of Maydeston, Kent, husbandman 0
3654995 1911825 1911825 defendant Lucke William husbandman 589383 589383 Lucke, William, of Maydeston, Kent, husbandman 0
3670840 1916845 1916845 defendant Elnott William clothman 589383 589383 Elnott, William, of Maydeston, Kent, clothman 2
3714348 1930787 1930787 defendant Forde Agnes widow 589383 589383 Forde, Agnes, of Maydeston, Kent, widow 0
3730468 1935761 1935761 defendant Tylman William yeoman 589383 589383 Tylman, William, of Maydeston, Kent, yeoman 0
3763885 1946347 1946347 defendant Haryngden Walter gent 589383 589383 Haryngden, Walter, of Maydeston, Kent, gent 1
3766681 1947240 1947240 defendant Audeley John yeoman 589383 589383 Audeley, John, of Maydeston, Kent, yeoman 2
3767808 1947567 1947567 defendant Coveney John clothier 589383 589383 Coveney, John, of Maydeston, Kent, clothier 0
3803322 1958936 1958936 defendant Harenden Walter clothier 589383 589383 Harenden, Walter, of Maydeston, Kent, clothier 0
3807904 1960359 1960359 defendant Ely alias Hely Richard mercer 589383 589383 Ely alias Hely, Richard, of Maydeston, Kent, mercer 0
3821538 1964633 1964633 defendant Hartyge Thomas tailor 589383 589383 Hartyge, Thomas, of Maydeston, Kent, tailor 0
3829306 1967049 1967049 defendant Boram David   589383 589383 Boram, David, of Maydeston, Kent, mason 0
3834937 1968865 1968865 defendant Borham David   589383 589383 Borham, David, of Maydeston, Kent, millwright 0
3838000 1969795 1969795 defendant Colney George husbandman 589383 589383 Colney, George, of Maydeston, Kent, husbandman 3
3838701 1970031 1970031 defendant Page Richard gent 589383 589383 Page, Richard, of Maydeston, Kent, gent 0
3853013 1974563 1974563 defendant Herendon Walter gent 589383 589383 Herendon, Walter, of Maydeston, Kent, gent 0
3859568 1976690 1976690 defendant Burdon William yeoman 589383 589383 Burdon, William, of Maydeston, Kent, yeoman 0
3867477 1979356 1979356 defendant Herenden Walter gent 589383 589383 Herenden, Walter, of Maydeston, Kent, gent 0
3874235 1981604 1981604 defendant Boreham David   589383 589383 Boreham, David, of Maydeston, Kent, millwright 0
3874246 1981606 1981606 defendant Boreham David   589383 589383 Boreham, David, of Maydeston, Kent, millwright 0
3888890 1986531 1986531 defendant Dosson John mercer 589383 589383 Dosson, John, of Maydeston, Kent, mercer 3
3890184 1986957 1986957 defendant Bodyam Mark chapman 589383 589383 Bodyam, Mark, of Maydeston, Kent, chapman 0
3899345 1989993 1989993 defendant Stortop John mercer 589383 589383 Stortop, John, of Maydeston, Kent, mercer 0
3907618 1992839 1992839 defendant Stertowte John mercer 589383 589383 Stertowte, John, of Maydeston, Kent, mercer 1
3941394 2004130 2004130 defendant Boram David chapman 589383 589383 Boram, David, of Maydeston, Kent, chapman 1
3952340 2007889 2007889 defendant Herenden Joan widow 589383 589383 Herenden, Joan, of Maydeston, Kent, widow 1
3956530 2009351 2009351 defendant Cristian William merchant 589383 589383 Cristian, William, of Maydeston, Kent, merchant 0
3992448 2022064 2022064 defendant Bingham Elias chapman 589383 589383 Bingham, Elias, of Maydeston, Kent, chapman 2
3999227 2024477 2024477 defendant Ippyngbury Ambrose (legal representative) 589383 589383 Ippyngbury, Ambrose, of Maydeston, Kent, pewterer, executor of 0
4019970 2031870 2031870 defendant Leigh or Lee Richard gent 589383 589383 (Leigh or Lee, Richard, of Maydeston, Kent, gent 1
4029358 2035141 2035141 defendant Mockett William saddler 589383 589383 Mockett, William, of Maydeston, Kent, saddler 2
4078529 2052619 2052619 plaintiff Tayler John mercer 589383 589383 Tayler, John, of Maydeston, Kent, mercer 0
4161893 2082229 2082229 defendant Strensham Michael gent 589383 589383 (Strensham, Michael, of Maydeston, Kent, gent 3
4253501 2114160 2114160 defendant Hubbart John carpenter 589383 589383 Hubbart, John, of Maydeston, Kent, carpenter 1
4294392 2128075 2128075 defendant Castell Robert goldsmith 589383 589383 Castell, Robert, of Maydeston, Kent, goldsmith 0
4334141 2141698 2141698 defendant Fagge John, junior yeoman 589383 589383 Fagge, John, junior, of Maydeston, Kent, or of Rye, Sussex, yeoman 0
4338628 2143266 2143266 defendant Syda John merchant 589383 589383 Syda, John, of Maydeston, Kent, merchant 0
4651642 2246501 2246501 defendant Thomasyn John husbandman 589383 589383 Thomasyn, John, of Maydeston, Kent, husbandman 11
4651818 2246513 2246513 defendant Thomasyn John husbandman 589383 589383 Thomasyn, John, of Maydeston, Kent, husbandman 12
4655722 2247673 2247673 defendant Dyne or Dyve Thomas draper 589383 589383 Dyne or Dyve, Thomas, of Maydeston, Kent, draper 0
4656661 2247978 2247978 defendant Gebon Robert   589383 589383 Gebon, Robert, of Maydeston, Kent, mason 0
4679328 2259148 2259148 defendant Maydeston William esq 589383 589383 Maydeston, William, of Maydeston, Kent, esq 0
4785437 2291465 2291465 defendant Cook Thomas chaplain 589383 589383 Cook, Thomas, of Maydeston, Kent, chaplain 3
4792419 2293713 2293713 defendant Derby William dyer 589383 589383 Derby, William, of Maydeston, Kent, dyer 0
4792440 2293720 2293720 defendant Derby William dyer 589383 589383 Derby, William, of Maydeston, Kent, dyer 0
4795937 2294877 2294877 defendant Colyn William spicer 589383 589383 Colyn, William, of Maydeston, Kent, spicer 0
4795943 2294878 2294878 defendant Colyn William spicer 589383 589383 Colyn, William, of Maydeston, Kent, spicer 0
4800934 2296482 2296482 defendant Broke Robert dyer 589383 589383 Broke, Robert, of Maydeston, Kent, dyer 0
4858423 2314007 2314007 defendant Starlyng William fisher 589383 589383 Starlyng, William, of Maydeston, Kent, fisher 0
4861626 2315009 2315009 defendant Warbilton John spicer 589383 589383 Warbilton, John, of Maydeston, Kent, spicer 2
4878025 2320081 2320081 defendant Ifeld Walter draper 589383 589383 Ifeld, Walter, of Maydeston, Kent, draper 1
4883704 2321814 2321814 defendant Stonstrete John dyer 589383 589383 Stonstrete, John, of Maydeston, Kent, dyer 0
4884155 2321951 2321951 defendant Kyrkeby Robert husbandman 589383 589383 Kyrkeby, Robert, of Maydeston, Kent, husbandman 0
4890873 2323894 2323894 defendant Hobcok Richard   589383 589383 Hobcok, Richard, of Maydeston, Kent, mason 1
4893206 2324590 2324590 defendant Potkyn John smith 589383 589383 Potkyn, John, of Maydeston, Kent, smith 0
4934140 2337066 2337066 defendant Potkyn William smith 589383 589383 Potkyn, William, of Maydeston, Kent, smith 0
4951234 2342352 2342352 defendant Waulter Thomas dyer 589383 589383 Waulter, Thomas, of Maydeston, Kent, dyer 0
4951242 2342354 2342354 defendant W- Thomas dyer 589383 589383 W-, Thomas, of Maydeston, Kent, dyer 0
4978317 2350464 2350464 defendant Wylmynton Hugh yeoman 589383 589383 Wylmynton, Hugh, of Maydeston, Kent, yeoman 0
5014996 2361265 2361265 defendant Feeld John gent 589383 589383 Feeld, John, of Maydeston, Kent, gent 0
5016287 2361654 2361654 defendant Heyton Thomas chapman 589383 589383 Heyton, Thomas, of Maydeston, Kent, chapman 4
5016293 2361655 2361655 defendant Heyton Thomas chapman 589383 589383 Heyton, Thomas, of Maydeston, Kent, chapman 4
5021157 2363085 2363085 defendant Florens Robert clerk 589383 589383 Florens, Robert, of Maydeston, Kent, clerk 0
5021163 2363086 2363086 defendant Florens Robert clerk 589383 589383 Florens, Robert, of Maydeston, Kent, clerk 0
5025274 2364286 2364286 defendant Morle Robert ostler 589383 589383 Morle, Robert, of Maydeston, Kent, ostler 2
5037452 2367824 2367824 defendant Depdale Andrew skinner 589383 589383 Depdale, Andrew, of Maydeston, Kent, skinner 0
5037461 2367827 2367827 defendant Depedale Andrew skinner 589383 589383 Depedale, Andrew, of Maydeston, Kent, skinner 0
5058232 2374020 2374020 defendant Brokke John gent 589383 589383 Brokke, John, of Maydeston, Kent, gent 0
5060656 2374766 2374766 defendant Aleynne Thomas chandler 589383 589383 Aleynne, Thomas, of Maydeston, Kent, chandler 0
5060923 2374840 2374840 defendant Alyn Richard dyer 589383 589383 Alyn, Richard, of Maydeston, Kent, dyer 0
5060928 2374841 2374841 defendant Alyn Richard dyer 589383 589383 Alyn, Richard, of Maydeston, Kent, dyer 0
5069527 2377383 2377383 defendant Moilde Robert chapman 589383 589383 Moilde, Robert, of Maydeston, Kent, chapman 3
5069985 2377517 2377517 defendant Morlee Robert chapman 589383 589383 Morlee, Robert, of Maydeston, Kent, chapman 3
5071920 2378096 2378096 defendant S- Thomas jayler or gaoler 589383 589383 S-, Thomas, of Maydeston, Kent, jayler or gaoler 1
5071932 2378097 2378097 defendant Snelgare Thomas gaoler 589383 589383 Snelgare, Thomas, of Maydeston, Kent, gaoler 1
5089006 2383162 2383162 defendant Banastre Thomas yeoman 589383 589383 Banastre, Thomas,of Maydeston, Kent, yeoman 2
5089010 2383163 2383163 defendant Banastre Thomas yeoman 589383 589383 Banastre, Thomas, of Maydeston, Kent, yeoman 2
5092762 2384262 2384262 defendant Feylde John esq 589383 589383 Feylde, John, of Maydeston, Kent, esq 2
5092768 2384263 2384263 defendant Feylde John esq 589383 589383 Feylde, John, of Maydeston, Kent, esq 2
5094546 2384816 2384816 defendant Blake John chapman 589383 589383 Blake, John, of Maydeston, Kent, chapman 2
5110318 2389422 2389422 defendant Parke Peter fuller 589383 589383 (Parke, Peter, of Maydeston, Kent, fuller 3
5110329 2389424 2389424 defendant Parke Peter fuller 589383 589383 (Parke, Peter, of Maydeston, Kent, fuller 3
5113783 2390426 2390426 defendant Fordemett Peter yeoman 589383 589383 Fordemett, Peter, of Maydeston, Kent, yeoman 2
5113788 2390427 2390427 defendant Fordemell Peter yeoman 589383 589383 Fordemell, Peter, of Maydeston, Kent, yeoman 0
5113793 2390428 2390428 defendant Fynche William tailor 589383 589383 Fynche, William, of Maydeston, Kent, tailor 0
5113799 2390429 2390429 defendant Fynche William tailor 589383 589383 Fynche, William, of Maydeston, Kent, tailor 0
5113807 2390430 2390430 defendant Lynche John yeoman 589383 589383 Lynche, John, of Maydeston, Kent, yeoman 2
5113813 2390431 2390431 defendant Lynche John yeoman 589383 589383 Lynche, John, of Maydeston, Kent, yeoman 2
5119828 2392234 2392234 defendant Holdernesse Margaret widow 589383 589383 Holdernesse, Margaret, of Maydeston, Kent, widow 4
5119834 2392235 2392235 defendant Holdyrnesse Margaret widow 589383 589383 Holdyrnesse, Margaret, of Maydeston, Kent, widow 4
5120898 2392543 2392543 defendant Snelgrave Thomas gaoler 589383 589383 Snelgrave, Thomas, of Maydeston, Kent, gaoler 1
5121296 2392662 2392662 defendant Seriaunt John saddler 589383 589383 Seriaunt, John, of Maydeston, Kent, saddler 0
5122756 2393090 2393090 defendant Holdernesse Margaret widow 589383 589383 Holdernesse, Margaret, of Maydeston, Kent, widow 2

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);