home / cp40x

names

170 rows where place_id = 587936

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592878 1865390 1865390 defendant Amyot William shipman 587936 587936 Amyot, William, of Feversham, Kent, shipman 0
3601221 1868044 1868044 defendant Hode John taverner 587936 587936 Hode, John, of Feversham, Kent, taverner 1
3606861 1869812 1869812 defendant Hode John carver 587936 587936 Hode, John, of Feversham, Kent, carver 0
3608041 1870166 1870166 defendant Wygmore Edith widow 587936 587936 Wygmore, Edith, of Feversham, Kent, widow 1
3608045 1870167 1870167 defendant Wygmore Edith widow 587936 587936 Wygmore, Edith, of Feversham, Kent, widow 1
3615868 1872603 1872603 defendant Andrewe Simon yeoman 587936 587936 Andrewe, Simon, of Feversham, Kent, yeoman 0
3615874 1872604 1872604 defendant Andrew Simon yeoman 587936 587936 Andrew, Simon, of Feversham, Kent, yeoman 4
3615880 1872605 1872605 defendant Andrew Simon yeoman 587936 587936 Andrew, Simon, of Feversham, Kent, yeoman 4
3618609 1873445 1873445 defendant Byrche Thomas yeoman 587936 587936 Byrche, Thomas, of Feversham, Kent, yeoman 0
3620649 1874038 1874038 defendant Hellys Thomas yeoman 587936 587936 Hellys, Thomas, of Feversham, Kent, yeoman 0
3667785 1915866 1915866 defendant Drylande Richard, junior gent 587936 587936 Drylande, Richard, junior, of Feversham, Kent, gent 0
3674370 1918028 1918028 defendant Exbrigge Robert yeoman 587936 587936 Exbrigge, Robert, of Feversham, Kent, yeoman 0
3683922 1921105 1921105 defendant Nicols Lawrence salter 587936 587936 Nicols, Lawrence, of Feversham, Kent, salter 1
3694425 1924461 1924461 defendant Wylkyn David   587936 587936 Wylkyn, David, of Feversham, Kent, yeoman, of the crown 0
3732721 1936465 1936465 defendant Cryour Richard yeoman 587936 587936 Cryour, Richard, of Feversham, Kent, yeoman 0
3741784 1939292 1939292 defendant Horn Margaret (legal representative) 587936 587936 Horn, Margaret, of Feversham, Kent, widow, executor of 7
3752131 1942590 1942590 defendant Perne Thomas yeoman or sherman 587936 587936 Perne, Thomas, of Feversham, Kent, yeoman or sherman 0
3770981 1948612 1948612 defendant Mantell William yeoman 587936 587936 Mantell, William, of Feversham, Kent, yeoman 0
3770983 1948613 1948613 defendant Norton William gent 587936 587936 Norton, William, of Feversham, Kent, gent 0
3770985 1948614 1948614 defendant Norton William gent 587936 587936 Norton, William, of Feversham, Kent, gent 0
3788701 1954268 1954268 defendant Norton William gent 587936 587936 Norton, William, of Feversham, Kent, gent 0
3804950 1959492 1959492 defendant Mantell William yeoman 587936 587936 Mantell, William, of Feversham, Kent, yeoman 0
3831751 1967831 1967831 defendant Bryngborne John merchant 587936 587936 Bryngborne, John, of Feversham, Kent, merchant 0
3837468 1969623 1969623 defendant Bolte William barber 587936 587936 Bolte, William, of Feversham, Kent, barber 2
3837999 1969795 1969795 defendant Somerstales John thatcher 587936 587936 Somerstales, John, of Feversham, Kent, thatcher 2
3858390 1976285 1976285 defendant Bygrave alias Botelson John yeoman 587936 587936 Bygrave alias Botelson, John, of Feversham, Kent, yeoman 1
3858393 1976286 1976286 defendant Bygrave alias Betelson John yeoman 587936 587936 Bygrave alias Betelson, John, of Feversham, Kent, yeoman 1
3859414 1976637 1976637 defendant Thornevall Thomas smith 587936 587936 Thornevall, Thomas, of Feversham, Kent, smith 0
3872569 1981047 1981047 defendant Botelson alias Bygram John yeoman 587936 587936 Botelson alias Bygram, John, of Feversham, Kent, yeoman 0
3884602 1985123 1985123 defendant Scott Nicholas farmer of Ewell 587936 587936 Scott, Nicholas, of Feversham, Kent, yeoman, farmer of Ewell 0
3884605 1985124 1985124 defendant Scott Nicholas yeoman 587936 587936 Scott, Nicholas, of Feversham, Kent, yeoman 0
3887461 1986070 1986070 defendant Fowle Adam gent 587936 587936 Fowle, Adam, of Feversham, Kent, gent 2
3887542 1986084 1986084 defendant Fowle Adam gent 587936 587936 Fowle, Adam, of Feversham, Kent, gent 2
3888183 1986301 1986301 defendant Morden Lionel yeoman 587936 587936 Morden, Lionel, of Feversham, Kent, yeoman 4
3888403 1986382 1986382 defendant Fowle Adam gent 587936 587936 Fowle, Adam, of Feversham, Kent, gent 0
3905890 1992253 1992253 defendant Martyn Thomas yeoman 587936 587936 Martyn, Thomas, of Feversham, Kent, yeoman 0
3914739 1995274 1995274 defendant Fowle Adam gent 587936 587936 Fowle, Adam, of Feversham, Kent, gent 0
3914743 1995275 1995275 defendant Fowle Adam gent 587936 587936 Fowle, Adam, of Feversham, Kent, gent 0
3943149 2004724 2004724 defendant Hampton William chapman 587936 587936 Hampton, William, of Feversham, Kent, chapman 1
3943420 2004814 2004814 defendant Love Anthony yeoman 587936 587936 Love, Anthony, of Feversham, Kent, yeoman 0
3945016 2005351 2005351 defendant Fynche Thomas gent 587936 587936 Fynche, Thomas, of Feversham, Kent, gent 1
3946050 2005694 2005694 defendant Bonde Henry yeoman 587936 587936 Bonde, Henry, of Feversham, Kent, yeoman 0
3947489 2006194 2006194 defendant Love Anthony innholder 587936 587936 Love, Anthony, of Feversham, Kent, innholder 0
3959995 2010594 2010594 defendant Tomlynson John mariner 587936 587936 Tomlynson, John, of Feversham, Kent, mariner 2
3963884 2011973 2011973 plaintiff Ambrose John yeoman 587936 587936 Ambrose, John, of Feversham, Kent, yeoman 0
3972937 2015109 2015109 defendant Bewe Thomas clothworker 587936 587936 Bewe, Thomas, of Feversham, Kent, clothworker 0
3974657 2015704 2015704 defendant Wrenke John mercer 587936 587936 Wrenke, John, of Feversham, Kent, mercer 0
3982715 2018587 2018587 defendant Pymbell Robert yeoman 587936 587936 Pymbell, Robert, of Feversham, Kent, yeoman 2
3990047 2021193 2021193 defendant Pellam Thomas gent 587936 587936 Pellam, Thomas, of Feversham, Kent, gent 1
3999702 2024656 2024656 defendant Vesse John merchant 587936 587936 Vesse, John, of Feversham, Kent, merchant 0
4001026 2025141 2025141 defendant Oldefelde John merchant 587936 587936 Oldefelde, John, of Feversham, Kent, merchant 0
4007729 2027549 2027549 defendant Merefylde Thomas yeoman 587936 587936 Merefylde, Thomas, of Feversham, kent, yeoman 0
4012456 2029179 2029179 defendant Paclesham John beer brewer 587936 587936 Paclesham, John, of Feversham, Kent, beer brewer 1
4014668 2029967 2029967 defendant Hampton William merchant 587936 587936 Hampton, William, of Feversham, Kent, merchant 0
4014677 2029969 2029969 defendant Hampton William merchant 587936 587936 Hampton, William, of Feversham, Kent, merchant 0
4020025 2031892 2031892 defendant Gyll Thomas chapman 587936 587936 Gyll, Thomas, of Feversham, kent, chapman 3
4020030 2031893 2031893 defendant Gyll Thomas chapman 587936 587936 Gyll, Thomas, of Feversham, Kent, chapman 3
4029360 2035141 2035141 defendant Hamond Thomas saddler 587936 587936 Hamond, Thomas, of Feversham, Kent, saddler 4
4070196 2049630 2049630 defendant Fynche John gent 587936 587936 Fynche, John, of Feversham, Kent, gent 0
4072444 2050447 2050447 defendant Bond Christopher yeoman 587936 587936 Bond, Christopher, of Feversham, Kent, yeoman 0
4092514 2057630 2057630 defendant Bewe Thomas chapman 587936 587936 Bewe, Thomas, of Feversham, Kent, chapman 0
4098279 2059709 2059709 defendant Ward Lawrence chapman 587936 587936 Ward, Lawrence, of Feversham, Kent, chapman 2
4150536 2078321 2078321 defendant Saxten John merchant 587936 587936 Saxten, John, of Feversham, Kent, merchant 1
4162836 2082542 2082542 defendant Webbe German gent 587936 587936 Webbe, German, of Feversham, Kent, gent 22
4171156 2085379 2085379 defendant Celande John wharfinger 587936 587936 Celande, John, of Feversham, Kent, wharfinger 1
4177853 2087727 2087727 defendant Collewelle Robert yeoman 587936 587936 Collewelle, Robert, of Feversham, Kent, yeoman 0
4194540 2093642 2093642 defendant Well Jerman gent 587936 587936 Well, Jerman, of Feversham, Kent, gent 2
4195654 2094034 2094034 defendant Hubbard Gregory mercer 587936 587936 Hubbard, Gregory, of Feversham, Kent, mercer 0
4197782 2094779 2094779 defendant Gilboroughe Stephen merchant 587936 587936 Gilboroughe, Stephen, of Feversham, Kent, merchant 0
4216967 2101428 2101428 defendant Tomlyn William yeoman 587936 587936 Tomlyn, William, of Feversham, Kent, yeoman 0
4253473 2114153 2114153 defendant Tomlyn William yeoman 587936 587936 Tomlyn, William, of Feversham, Kent, yeoman 0
4264491 2117764 2117764 defendant Fynche Thomas gent 587936 587936 Fynche, Thomas, of Feversham, Kent, gent 0
4278484 2122410 2122410 defendant Tylman Richard yeoman 587936 587936 Tylman, Richard, of Feversham, Kent, yeoman 1
4285525 2124873 2124873 defendant Tomblyn William beer brewer 587936 587936 Tomblyn, William, of Feversham, Kent, beer brewer 2
4292246 2127293 2127293 defendant Somers Henry chapman 587936 587936 Somers, Henry, of Feversham, Kent, chapman 0
4314341 2135126 2135126 defendant Swayton John chapman 587936 587936 Swayton, John, of Feversham, Kent, chapman 0
4320409 2137236 2137236 defendant Paynter Anne spinster 587936 587936 Paynter, Anne, of Feversham, Kent, spinster 3
4331945 2140979 2140979 defendant Shrobsall Robert (legal representative) 587936 587936 Shrobsall, Robert, of Feversham, Kent, gent, executrix of 0
4348917 2146883 2146883 defendant Thurstone William salter 587936 587936 Thurstone, William, of Feversham, Kent, salter 0
4348920 2146884 2146884 defendant Thurstone James salter 587936 587936 Thurstone, James, of Feversham, Kent, salter 0
4366248 2152970 2152970 defendant Wilson Edward brewer 587936 587936 Wilson, Edward, of Feversham, Kent, brewer 0
4376263 2156578 2156578 defendant Bennett John yeoman 587936 587936 Bennett, John, of Feversham, Kent, yeoman 0
4680495 2259512 2259512 defendant Carre John yeoman 587936 587936 Carre, John, of Feversham, Kent, yeoman 2
4691060 2262727 2262727 defendant Dreylond John gent 587936 587936 Dreylond, John, of Feversham, Kent, gent 0
4746296 2279413 2279413 defendant Maynard John smith 587936 587936 Maynard, John, of Feversham, Kent, smith 1
4873561 2318678 2318678 defendant Taillour Thomas smith 587936 587936 Taillour, Thomas, of Feversham, Kent, smith 0
4873569 2318679 2318679 defendant Taillour Thomas smith 587936 587936 Taillour, Thomas, of Feversham, Kent, smith 0
4880922 2320941 2320941 defendant Morse John smith 587936 587936 Morse, John, of Feversham, Kent, smith 2
4880927 2320942 2320942 defendant Morse John smith 587936 587936 Morse, John, of Feversham, Kent, smith 2
4888989 2323346 2323346 defendant Whittehede John dyer 587936 587936 Whittehede, John, of Feversham, Kent, dyer 0
4889160 2323397 2323397 defendant Drylond John gent 587936 587936 Drylond, John, of Feversham, Kent, gent 3
4889798 2323601 2323601 defendant Malsham Nicholas chapman 587936 587936 Malsham, Nicholas, of Feversham, Kent, chapman 2
4890663 2323835 2323835 defendant Wyse Ellen widow 587936 587936 Wyse, Ellen, of Feversham, Kent, widow 0
4890670 2323836 2323836 defendant Thornbury Richard draper 587936 587936 Thornbury, Richard, of Feversham, Kent, or of London, draper 2
4894852 2325056 2325056 defendant Malsham Nicholas chapman 587936 587936 Malsham, Nicholas, of Feversham, Kent, chapman 2
4896118 2325442 2325442 defendant Drylond John gent 587936 587936 Drylond, John, of Feversham, Kent, gent 3
4899268 2326413 2326413 defendant Wyse Ellen widow 587936 587936 Wyse, Ellen, of Feversham, Kent, widow 0
4900926 2326919 2326919 defendant Thornebury John gent 587936 587936 Thornebury, John, of Feversham, Kent, gent 0
4940873 2339171 2339171 defendant Seyntclere John gent 587936 587936 Seyntclere, John, of Feversham, Kent, gent 2
4955742 2343683 2343683 defendant Drylond Richard esq 587936 587936 Drylond, Richard, of Feversham, Kent, esq 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);
Powered by Datasette · Queries took 20.068ms