names

222 rows where place_id = 590659

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601915 1868254 1868254 defendant Trove or Trone Nicholas husbandman 590659 590659 Trove or Trone, Nicholas, of Leveryngton, husbandman 2
3611609 1871298 1871298 defendant Toke John husbandman 590659 590659 Toke, John, of Leveryngton, husbandman 0
3645528 1908999 1908999 plaintiff Gryse John (legal representative) 590659 590659 Gryse, John, of Leveryngton, executors of 0
3654722 1911735 1911735 defendant Lambard William yeoman 590659 590659 Lambard, William, of Leveryngton, yeoman 0
3654723 1911735 1911735 defendant Dryver William husbandman 590659 590659 Dryver, William, of Leveryngton, husbandman 1
3654724 1911735 1911735 defendant Vycars John husbandman 590659 590659 Vycars, John, of Leveryngton, husbandman 2
3799628 1957806 1957806 defendant Hunt Lawrence husbandman 590659 590659 Hunt, Lawrence, of Leveryngton, husbandman 1
3831417 1967712 1967712 defendant Plumbe Hugh husbandman 590659 590659 Plumbe, Hugh, of Leveryngton, husbandman 3
3848877 1973239 1973239 plaintiff Koxston John   590659 590659 Koxston, John, of Leveryngton 0
3880813 1983851 1983851 defendant Dygyll William husbandman 590659 590659 Dygyll, William, of Leveryngton, husbandman 0
3920025 1997036 1997036 defendant Benne William husbandman 590659 590659 Benne, William, of Parson Drove, Leveryngton, husbandman 1
3920028 1997037 1997037 defendant Dryver Henry husbandman 590659 590659 Dryver, Henry, of Parson Drove, Leveryngton, husbandman 1
3920031 1997038 1997038 defendant Goldyng alias Wright John husbandman 590659 590659 Goldyng alias Wright, John, of Parson Drove, Leveryngton, husbandman 1
3920032 1997038 1997038 defendant Peerson William husbandman 590659 590659 Peerson, William, of Parson Drove, Leveryngton, husbandman 2
3920033 1997038 1997038 defendant Peerson Thomas husbandman 590659 590659 Peerson, Thomas, of Parson Drove, Leveryngton, husbandman 3
3920037 1997039 1997039 defendant Hobson John yeoman 590659 590659 Hobson, John, of Parson Drove, Leveryngton, yeoman 2
3920051 1997043 1997043 defendant Ryott John husbandman 590659 590659 Ryott, John, of Parson Drove, Leveryngton, husbandman 1
3920501 1997206 1997206 defendant Hunt Thomas husbandman 590659 590659 Hunt, Thomas, of Leveryngton, husbandman 2
3920502 1997206 1997206 defendant Josep alias Tylson Thomas husbandman 590659 590659 Josep alias Tylson, Thomas, of Leveryngton, husbandman 3
3920504 1997206 1997206 defendant Tego John, senior husbandman 590659 590659 (Tego, John, senior, of Leveryngton, husbandman 5
3920505 1997206 1997206 defendant Tego John, junior husbandman 590659 590659 Tego, John, junior, of Leveryngton, husbandman 6
3920521 1997212 1997212 defendant Hunt Thomas husbandman 590659 590659 Hunt, Thomas, of Leveryngton, husbandman 2
3920524 1997212 1997212 defendant Tego Thomas husbandman 590659 590659 Tego, Thomas, of Leveryngton, husbandman 5
3933227 2001407 2001407 defendant Sowth John husbandman 590659 590659 Sowth, John, of Leveryngton, husbandman 0
4420162 2171208 2171208 plaintiff Brayton Thomas de   590659 590659 Brayton, Thomas de, of Leveryngton, parson 0
4447497 2184130 2184130 defendant Lawe Nicholas chaplain 590659 590659 Lawe, Nicholas, of Leveryngton, chaplain 0
4447499 2184130 2184130 defendant Nele Geoffrey   590659 590659 Nele, Geoffrey, of Leveryngton 2
4453652 2186155 2186155 defendant Clerk John   590659 590659 Clerk, John, of Leveryngton 3
4467732 2190585 2190585 defendant Richardysson Bartholomew   590659 590659 Richardysson, Bartholomew, of Leveryngton 0
4467733 2190585 2190585 defendant Adamson John   590659 590659 Adamson, John, of leveryngton 1
4470703 2191484 2191484 defendant Everard Thomas   590659 590659 Everard, Thomas, of Leveryngton 0
4470723 2191493 2191493 defendant Everard Thomas   590659 590659 Everard, Thomas, of Leveryngton 0
4481594 2194939 2194939 plaintiff Lyne John   590659 590659 Lyne, John, of Leveryngton, on his own account 0
4481595 2194939 2194939 defendant Frenge Thomas   590659 590659 Frenge, Thomas, of Leveryngton 0
4481596 2194940 2194940 plaintiff Lyne John   590659 590659 Lyne, John, of Leveryngton, on his own account 0
4493707 2198731 2198731 defendant Averill John   590659 590659 Averill, John, of Leveryngton 0
4497966 2200013 2200013 defendant Pappe Thomas   590659 590659 Pappe, Thomas, of Leveryngton 0
4503371 2201625 2201625 defendant Kene Richard   590659 590659 Kene, Richard, of Leveryngton 0
4513616 2204684 2204684 defendant Costyn Thomas   590659 590659 Costyn, Thomas, of Leveryngton 0
4552109 2216608 2216608 defendant Bettesson William   590659 590659 Bettesson, William, of Leveryngton 1
4552121 2216611 2216611 defendant Adamson Thomas   590659 590659 Adamson, Thomas, of Leveryngton 0
4552500 2216738 2216738 defendant Pynder Simon   590659 590659 Pynder, Simon, of Leveryngton 0
4552501 2216738 2216738 defendant Wattes Robert   590659 590659 Wattes, Robert, of Leveryngton 1
4552504 2216738 2216738 defendant Walden Thomas   590659 590659 Walden, Thomas, of Leveryngton 4
4553261 2216951 2216951 defendant Silk Thomas   590659 590659 Silk, Thomas, of Leveryngton 0
4555611 2217684 2217684 plaintiff Hervy Owen   590659 590659 Hervy, Owen, of Leveryngton 0
4555612 2217684 2217684 defendant Cokisdale John   590659 590659 Cokisdale, John, of Leveryngton 0
4555613 2217684 2217684 defendant Herryson Reginald   590659 590659 Herryson, Reginald, of Leveryngton 1
4555614 2217684 2217684 defendant Lowyn John   590659 590659 Lowyn, John, of Leveryngton 2
4580932 2225513 2225513 plaintiff Dogeshed John   590659 590659 Dogeshed, John, of Leveryngton 0
4582440 2225948 2225948 plaintiff Everrard Lawrence   590659 590659 Everrard, Lawrence, of Leveryngton, knight 0
4583895 2226380 2226380 plaintiff Ganne John   590659 590659 Ganne, John, of Leveryngton 0
4606168 2233039 2233039 defendant Custeyn Alan   590659 590659 Custeyn, Alan, of Leveryngton 2
4615781 2235931 2235931 plaintiff Fitton John   590659 590659 Fitton, John, of Leveryngton 1
4615782 2235931 2235931 defendant Henryson Reginald   590659 590659 Henryson, Reginald, of Leveryngton 0
4620641 2237445 2237445 plaintiff Jonson Williamm   590659 590659 Jonson, Williamm, of Leveryngton 0
4622944 2238154 2238154 plaintiff Marchall Adam   590659 590659 Marchall, Adam, of Leveryngton 0
4625888 2239050 2239050 defendant Sharpe John   590659 590659 Sharpe, John, of Leveryngton 0
4633580 2241359 2241359 plaintiff Welbourne John master & parson 590659 590659 Welbourne, John, of Leveryngton, master & parson 0
4639575 2243088 2243088 defendant Neweman Thomas   590659 590659 Neweman, Thomas, of Leveryngton 0
4639577 2243089 2243089 plaintiff atte Hill John chaplain 590659 590659 atte Hill, John, of Leveryngton, chaplain 1
4639578 2243089 2243089 defendant Mayhewe Bar_   590659 590659 Mayhewe, Bar_, of Leveryngton 0
4639580 2243089 2243089 defendant Reynold William   590659 590659 Reynold, William, of Leveryngton 2
4639581 2243089 2243089 defendant Dryvere William   590659 590659 Dryvere, William, of Leveryngton 3
4639582 2243089 2243089 defendant Reynold Thomas   590659 590659 Reynold, Thomas, of Leveryngton 4
4640830 2243417 2243417 defendant Harughdon John   590659 590659 Harughdon, John, of Leveryngton 1
4642058 2243786 2243786 defendant Weynnok Simon   590659 590659 Weynnok, Simon, of Leveryngton 0
4650073 2246036 2246036 plaintiff Welbourne John master & parson of the church 590659 590659 Welbourne, John, of Leveryngton, master & parson of the church 0
4650075 2246037 2246037 plaintiff Welbourne John master & parson of the church 590659 590659 Welbourne, John, of Leveryngton, master & parson of the church 0
4650967 2246301 2246301 defendant Yonet John laborer 590659 590659 Yonet, John, of Leveryngton, laborer 1
4667735 2255621 2255621 defendant Dunham Roger laborer 590659 590659 Dunham, Roger, of Leveryngton, laborer 0
4675322 2257892 2257892 defendant Ivet John husbandman 590659 590659 Ivet John, of Leveryngton, husbandman 0
4675460 2257933 2257933 defendant Caynnok Simon laborer 590659 590659 Caynnok, Simon, of Leveryngton, laborer 1
4678501 2258882 2258882 defendant Pappe Thomas husbandman 590659 590659 Pappe, Thomas, of Leveryngton, husbandman 0
4681456 2259816 2259816 defendant Wortheyn John husbandman 590659 590659 Wortheyn, John, of Leveryngton, husbandman 3
4681587 2259855 2259855 defendant Harwedon John   590659 590659 Harwedon, John, of Leveryngton, bailiff 2
4683505 2260442 2260442 defendant Bullesden John farmer 590659 590659 Bullesden, John, of Leveryngton, farmer 0
4688591 2261994 2261994 plaintiff Thorp William chaplain 590659 590659 Thorp, William, of Leveryngton, chaplain 0
4705994 2267249 2267249 defendant Everard John esq 590659 590659 Everard, John, of Leveryngton, esq 1
4718763 2271210 2271210 defendant Bausey Nicholas husbandman 590659 590659 Bausey, Nicholas, of Leveryngton, husbandman 0
4719368 2271400 2271400 plaintiff Beth Robert   590659 590659 Beth, Robert, of Leveryngton 0
4721967 2272200 2272200 defendant Deye John husbandman 590659 590659 Deye, John, of Leveryngton, husbandman 0
4723363 2272616 2272616 defendant Byrd William husbandman 590659 590659 Byrd, William, of Leveryngton, husbandman 0
4725636 2273304 2273304 defendant Bryd William yeoman 590659 590659 Bryd, William, of Leveryngton, yeoman 5
4726179 2273471 2273471 defendant Markaunt Henry husbandman 590659 590659 Markaunt, Henry, of Leveryngton, husbandman 1
4726858 2273666 2273666 defendant Stokyll William husbandman 590659 590659 Stokyll, William, of Leveryngton, husbandman 3
4728547 2274168 2274168 defendant Stokyll Robert husbandman 590659 590659 Stokyll, Robert, of Leveryngton, husbandman 0
4729651 2274485 2274485 defendant Everard John esq 590659 590659 Everard, John, of Leveryngton, esq 1
4730477 2274728 2274728 defendant Fitton John husbandman 590659 590659 Fitton, John, of Leveryngton, husbandman 0
4733556 2275671 2275671 defendant Stokyll Robert husbandman 590659 590659 Stokyll, Robert, of Leveryngton, husbandman 0
4733557 2275671 2275671 defendant Oberth John husbandman 590659 590659 Oberth, John, of Leveryngton, husbandman 1
4735034 2276104 2276104 defendant Costyn Thomas husbandman 590659 590659 Costyn, Thomas, of Leveryngton, husbandman 0
4752133 2281104 2281104 defendant Person Geoffrey husbandman 590659 590659 Person, Geoffrey, of Leveryngton, husbandman 2
4752134 2281104 2281104 defendant Pecok Thomas, junior husbandman 590659 590659 Pecok, Thomas, junior, of Leveryngton, husbandman 3
4752135 2281104 2281104 defendant Stokyll Robert husbandman 590659 590659 Stokyll, Robert, of Leveryngton, husbandman 4
4761902 2284066 2284066 defendant Wattes Robert husbandman 590659 590659 Wattes, Robert, of Leveryngton, husbandman 0
4761903 2284066 2284066 defendant Wattes John yeoman 590659 590659 Wattes, John, of Leveryngton, yeoman 1
4771245 2286989 2286989 defendant Danseye Nicholas yeoman 590659 590659 Danseye, Nicholas, of Leveryngton, yeoman 3
4771246 2286989 2286989 defendant Pecok Thomas yeoman 590659 590659 Pecok, Thomas, of Leveryngton, yeoman 4
4771247 2286989 2286989 defendant Stokyll Robert yeoman 590659 590659 Stokyll, Robert, of Leveryngton, yeoman 5

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