names

119 rows where place_id = 588359

✎ 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
3594217 1865832 1865832 defendant Pulter William clothier 588359 588359 Pulter, William, of Hadlowe, clothier 1
3594221 1865833 1865833 defendant Pulter William glover 588359 588359 Pulter, William, of Hadlowe, glover 1
3597851 1866947 1866947 defendant Godyng John husbandman 588359 588359 Godyng, John, of Hadlowe, husbandman 0
3610738 1871023 1871023 defendant Humfrey John yeoman 588359 588359 Humfrey, John, of Hadlowe, yeoman 0
3613990 1872034 1872034 defendant Humfrey John yeoman 588359 588359 Humfrey, John, of Hadlowe, yeoman 0
3632637 1905026 1905026 defendant Aulond or Anlond Thomas clerk 588359 588359 Aulond or Anlond, Thomas, of Hadlowe, clerk 0
3644886 1908812 1908812 defendant Forner John clerk 588359 588359 Forner, John, of Hadlowe, clerk 0
3662844 1914294 1914294 defendant Awlan Thomas   588359 588359 Awlan, Thomas, of Hadlowe, vicar in the diocese of Rochester 0
3669303 1916337 1916337 defendant Crotynden John husbandman 588359 588359 Crotynden, John, of Hadlowe, husbandman 0
3687803 1922349 1922349 defendant Kent Thomas yeoman 588359 588359 (Kent, Thomas, of Hadlowe, yeoman 1
3698706 1925811 1925811 defendant Bexley James   588359 588359 Bexley, James, of Hadlowe, millwright 0
3707616 1928679 1928679 defendant Broke John husbandman 588359 588359 Broke, John, of Hadlowe, husbandman 5
3715083 1931014 1931014 defendant Master John thatcher 588359 588359 Master, John, of Hadlowe, thatcher 0
3717984 1931921 1931921 defendant Salman William husbandman 588359 588359 Salman, William, of Hadlowe, husbandman 2
3719312 1932328 1932328 defendant Somer John yeoman 588359 588359 Somer, John, of Hadlowe, yeoman 0
3719313 1932328 1932328 defendant Somer Richard husbandman 588359 588359 Somer, Richard, of Hadlowe, husbandman 1
3723486 1933611 1933611 defendant Style Walter husbandman 588359 588359 Style, Walter, of Hadlowe, husbandman 3
3733932 1936859 1936859 defendant Couper Thomas husbandman 588359 588359 Couper, Thomas, of Hadlowe, husbandman 0
3733933 1936859 1936859 defendant Couper William husbandman 588359 588359 Couper, William, of Hadlowe, husbandman 1
3733934 1936859 1936859 defendant Couper Richard husbandman 588359 588359 Couper, Richard, of Hadlowe, husbandman 2
3759794 1945057 1945057 defendant Hale John husbandman 588359 588359 Hale, John, of Hadlowe, husbandman 1
3769468 1948110 1948110 defendant Style Walter yeoman 588359 588359 Style, Walter, of Hadlowe, yeoman 3
3772348 1949037 1949037 defendant Stoperffeld Nicholas yeoman 588359 588359 Stoperffeld, Nicholas, of Hadlowe, yeoman 1
3789797 1954640 1954640 defendant Curde John husbandman 588359 588359 Curde, John, of Hadlowe, husbandman 1
3789802 1954641 1954641 defendant Rygon John butcher 588359 588359 Rygon, John, of Hadlowe, butcher 1
3797216 1957011 1957011 defendant Wekys John husbandman 588359 588359 Wekys, John, of Hadlowe, husbandman 1
3812037 1961674 1961674 defendant FitzHerbert Anthony yeoman 588359 588359 FitzHerbert, Anthony, of Hadlowe, yeoman 2
3814428 1962426 1962426 defendant Wekys John husbandman 588359 588359 Wekys, John, of Hadlowe, husbandman 0
3845964 1972294 1972294 plaintiff Fyssher John yeoman 588359 588359 Fyssher, John, of Hadlowe, yeoman 0
3845966 1972295 1972295 plaintiff Fyssher John yeoman 588359 588359 Fyssher, John, of Hadlowe, yeoman 0
3857457 1975967 1975967 defendant Chapleyn Thomas husbandman 588359 588359 Chapleyn, Thomas, of Hadlowe, husbandman 2
3861262 1977237 1977237 defendant A Kente Thomas yeoman 588359 588359 A Kente, Thomas, of Hadlowe, yeoman 0
3861954 1977458 1977458 defendant Inge John smith 588359 588359 Inge, John, of Hadlowe, smith 0
3977986 2016875 2016875 plaintiff Manley William yeoman 588359 588359 Manley, William, of Hadlowe, yeoman 0
3983359 2018821 2018821 defendant Holte Robert yeoman 588359 588359 Holte, Robert, of Hadlowe, yeoman 0
3983360 2018821 2018821 defendant Ware Thomas yeoman 588359 588359 Ware, Thomas, of Hadlowe, yeoman 1
3985248 2019481 2019481 defendant Weller William yeoman 588359 588359 Weller, William, of Hadlowe, yeoman 0
3994755 2022876 2022876 defendant Pattenden James yeoman 588359 588359 Pattenden, James, of Hadlowe, yeoman 3
4028214 2034739 2034739 defendant Pattenden James yeoman 588359 588359 Pattenden, James, of Hadlowe, yeoman 2
4028594 2034872 2034872 defendant Willard David yeoman 588359 588359 Willard, David, of Hadlowe, yeoman 1
4090035 2056719 2056719 defendant Rotes Richard butcher 588359 588359 Rotes, Richard, of Hadlowe, butcher 0
4136930 2073556 2073556 defendant Rott or Rottes Richard butcher 588359 588359 Rott or Rottes, Richard, of Hadlowe, or of Townbridge, butcher 0
4153584 2079345 2079345 defendant Hayes Nevell yeoman 588359 588359 Hayes, Nevell, of Hadlowe, yeoman 0
4195309 2093906 2093906 defendant Patynden James laborer 588359 588359 Patynden, James, of Hadlowe, laborer 3
4310191 2133720 2133720 defendant Willard Edmund yeoman 588359 588359 Willard, Edmund, of Hadlowe, yeoman 0
4312022 2134342 2134342 defendant Abraham Richard husbandman 588359 588359 Abraham, Richard, of Hadlowe, husbandman 0
4314821 2135296 2135296 defendant Mathewe John carpenter 588359 588359 Mathewe, John, of Hadlowe, carpenter 2
4321061 2137462 2137462 defendant Holmewoode Daniel husbandman 588359 588359 Holmewoode, Daniel, of Hadlowe, husbandman 2
4341609 2144341 2144341 defendant Borne John yeoman 588359 588359 Borne, John, of Hadlowe, yeoman 0
4341613 2144343 2144343 defendant Borne John yeoman 588359 588359 Borne, John, of Hadlowe, yeoman 0
4362147 2151508 2151508 defendant Ryvers Richard gent 588359 588359 Ryvers, Richard, of Hadlowe, gent executor of 0
4362150 2151509 2151509 defendant Ryvers Richard (legal representative) 588359 588359 Ryvers, Richard, of Hadlowe, gent, executor of 0
4386807 2160256 2160256 defendant Chatfeild George yeoman 588359 588359 Chatfeild, George, of Hadlowe, yeoman executrix of 1
4386808 2160256 2160256 defendant Chatfeild Elizabeth widow 588359 588359 Chatfeild, Elizabeth, of Hadlowe, widow 2
4386810 2160257 2160257 defendant Bowrne John yeoman 588359 588359 Bowrne, John, of Hadlowe, yeoman 0
4402457 2165408 2165408 defendant Rose William tailor 588359 588359 Rose William, of Hadlowe, tailor 2
4411877 2168566 2168566 defendant Borne Francis yeoman 588359 588359 Borne, Francis, of Hadlowe, or of Byrlynge, Kent, yeoman 0
4773879 2287810 2287810 defendant Burdon Richard husbandman 588359 588359 Burdon, Richard, of Hadlowe, husbandman 0
4793629 2294119 2294119 defendant Burdon John yeoman 588359 588359 Burdon, John, of Hadlowe, yeoman 1
4793927 2294228 2294228 defendant Lemman John husbandman 588359 588359 Lemman, John, of Hadlowe, husbandman 0
4869811 2317530 2317530 defendant Kentworth William ripier or fishmonger 588359 588359 Kentworth, William, of Hadlowe, ripier or fishmonger 2
4869816 2317531 2317531 defendant Kentworth William ripier 588359 588359 Kentworth, William, of Hadlowe, ripier 2
4882089 2321296 2321296 defendant Bouryng John yeoman 588359 588359 Bouryng, John, of Hadlowe, yeoman 0
5018506 2362293 2362293 defendant Birdon Thomas ripier or fishmonger 588359 588359 Birdon, Thomas, of Hadlowe, ripier or fishmonger 3
5056624 2373553 2373553 defendant Knyght Richard husbandman 588359 588359 Knyght, Richard, of Hadlowe, husbandman 0
5095393 2385072 2385072 defendant Storefeld Nicholas husbandman 588359 588359 Storefeld, Nicholas, of Hadlowe, husbandman 2
5095398 2385073 2385073 defendant Storefeld Nicholas husbandman 588359 588359 Storefeld, Nicholas, of Hadlowe, husbandman 2
5116371 2391215 2391215 defendant May John fuller 588359 588359 May, John, of Hadlowe, fuller 0
5119573 2392155 2392155 defendant Stopefeld Nichlas husbandman 588359 588359 Stopefeld, Nichlas, of Hadlowe, husbandman 2
5138583 2397781 2397781 defendant Mayne John fuller 588359 588359 Mayne, John, of Hadlowe, fuller 3
5144856 2399646 2399646 defendant Andrewe William laborer 588359 588359 Andrewe, William, of Hadlowe, laborer 3
5144857 2399646 2399646 defendant Symond Thomas laborer 588359 588359 Symond, Thomas, of Hadlowe, laborer 4
5159336 2403846 2403846 defendant Mayne John fuller 588359 588359 Mayne, John, of Hadlowe, fuller 3
5165537 2405664 2405664 defendant Andrewe William laborer 588359 588359 Andrewe, William, of Hadlowe, laborer 3
5165538 2405664 2405664 defendant Symond Thomas laborer 588359 588359 Symond, Thomas, of Hadlowe, laborer 4
5181808 2410423 2410423 defendant Knyght Thomas tailor 588359 588359 Knyght, Thomas, of Hadlowe, tailor 0
5217949 2420984 2420984 defendant at Stabyll John yeoman 588359 588359 at Stabyll, John, of Hadlowe, yeoman 2
5224633 2422876 2422876 defendant Fyssher Richard husbandman 588359 588359 Fyssher, Richard, of Hadlowe, husbandman 2
5226344 2423372 2423372 defendant Stoperfelde Nicholas husbandman 588359 588359 Stoperfelde, Nicholas, of Hadlowe, husbandman 1
5312347 2448728 2448728 defendant Bysshop John   588359 588359 Bysshop, John, of Hadlowe 3
5316777 2450104 2450104 defendant Symond John, senior husbandman 588359 588359 Symond, John, senior, of Hadlowe, husbandman 0
5319596 2450954 2450954 defendant Steperfeld Nicholas husbandman 588359 588359 (Steperfeld, Nicholas, of Hadlowe, husbandman 1
5322185 2451707 2451707 defendant Asshdoune Willam husbandman 588359 588359 Asshdoune, Willam, of Hadlowe, husbandman 2
5350298 2460213 2460213 defendant Benynden John   588359 588359 Benynden, John, of Hadlowe, parish clerk 1
5353915 2461289 2461289 defendant Tuessnoth Thomas pulter 588359 588359 Tuessnoth, Thomas, of Hadlowe, pulter 2
5371591 2466700 2466700 defendant Neweman John laborer 588359 588359 Neweman, John, of Hadlowe, laborer 3
5385918 2471044 2471044 defendant Osbarn John, senior husbandman 588359 588359 Osbarn, John, senior, of Hadlowe, husbandman 0
5398107 2474525 2474525 defendant Osbarn John, senior husbandman 588359 588359 Osbarn, John, senior, of Hadlowe, husbandman 0
5447832 2489234 2489234 defendant Humfrey John yeoman 588359 588359 Humfrey, John, of Hadlowe, yeoman 0
5496549 2503880 2503880 defendant Gosse James husbandman 588359 588359 Gosse, James, of Hadlowe, husbandman 0
5497112 2504074 2504074 defendant Godyng John yeoman 588359 588359 Godyng, John, of Hadlowe, yeoman 0
5514623 2509419 2509419 defendant John Henry repyer 588359 588359 John, Henry, of Hadlowe, repyer 4
5523422 2512155 2512155 defendant Lenesoth or Levesoth John, senior cutler 588359 588359 Lenesoth or Levesoth, John, senior, of Hadlowe, cutler 0
5523423 2512155 2512155 defendant Neweman Reginald husbandman 588359 588359 Neweman, Reginald, of Hadlowe, husbandman 1
5532610 2514743 2514743 defendant Kebyll Richard yeoman 588359 588359 Kebyll, Richard, of Hadlowe, yeoman 0
5568801 2525425 2525425 defendant Aberton John husbandman 588359 588359 Aberton, John, of Hadlowe, husbandman 0
5568802 2525425 2525425 defendant Moys Thomas laborer 588359 588359 Moys, Thomas, of Hadlowe, laborer 1
5570512 2525948 2525948 defendant Pulter William husbandman 588359 588359 Pulter, William, of Hadlowe, husbandman 0
5573146 2526698 2526698 defendant Burges Thomas husbandman 588359 588359 Burges, Thomas, of Hadlowe, husbandman 0
5573147 2526698 2526698 defendant Style John husbandman 588359 588359 Style, John, of Hadlowe, husbandman 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);