home / cp40x

names

249 rows where place_id = 586009

✎ 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
3587685 1863793 1863793 defendant Willowes William fisher 586009 586009 Willowes, William, of Feversham, fisher 0
3587686 1863793 1863793 defendant Hamond Geoffrey fisher 586009 586009 Hamond, Geoffrey, of Feversham, fisher 1
3589851 1864467 1864467 plaintiff Chapman John carpenter 586009 586009 Chapman, John, of Feversham, carpenter 0
3589852 1864467 1864467 defendant Lincolle John merchant 586009 586009 Lincolle, John, of Feversham, merchant 0
3592879 1865390 1865390 defendant Orwell William shipman 586009 586009 Orwell, William, of Feversham, shipman 1
3608040 1870166 1870166 defendant Wygmore John (legal representative) 586009 586009 Wygmore, John, of Feversham, gent, administratrix of 0
3608044 1870167 1870167 defendant Wygmore John (legal representative) 586009 586009 Wygmore, John, of Feversham, gent, administratrix of 0
3614412 1872158 1872158 defendant Coke Thomas tanner 586009 586009 (Coke, Thomas, of Feversham, tanner 1
3614689 1872247 1872247 defendant Materas Thomas butcher 586009 586009 Materas, Thomas, of Feversham, butcher 0
3619184 1873600 1873600 defendant Best William husbandman 586009 586009 Best, William, of Feversham, husbandman 0
3620059 1873850 1873850 defendant A York John butcher 586009 586009 A York, John, of Feversham, butcher 1
3620060 1873850 1873850 defendant Sherewod Robert laborer 586009 586009 Sherewod, Robert, of Feversham, laborer 2
3623312 1874818 1874818 defendant Blake Thomas barber 586009 586009 Blake, Thomas, of Feversham, barber 0
3624372 1875157 1875157 plaintiff Thomasson Edward (legal representative) 586009 586009 Thomasson, Edward, of Feversham, brewer, executors of 0
3624376 1875158 1875158 plaintiff Thomasson Edward (legal representative) 586009 586009 Thomasson, Edward, of Feversham, brewer, executors of 0
3624380 1875159 1875159 plaintiff Thomasson Edward (legal representative) 586009 586009 Thomasson, Edward, of Feversham, brewer, executors of 0
3625070 1875375 1875375 defendant Birche Thomas yeoman 586009 586009 Birche, Thomas, of Feversham, yeoman 0
3625072 1875376 1875376 defendant Byrche Thomas yeoman 586009 586009 Byrche, Thomas, of Feversham, yeoman 0
3627864 1903575 1903575 defendant Clarke William (legal representative) 586009 586009 Clarke, William, of Feversham, chaplain, executor of 0
3627868 1903575 1903575 defendant Hardy John (legal representative) 586009 586009 Hardy, John, of Feversham, butcher, executor of 4
3627869 1903575 1903575 defendant Hardyman Denis tanner 586009 586009 Hardyman, Denis, of Feversham, tanner 5
3627878 1903576 1903576 defendant Malpas Thomas (legal representative) 586009 586009 Malpas, Thomas, of Feversham, pewterer, executors of 4
3631942 1904803 1904803 defendant Straynsham Lawrence yeoman 586009 586009 Straynsham, Lawrence, of Feversham, yeoman 0
3631944 1904804 1904804 defendant Straynsham Lawrence yeoman 586009 586009 Straynsham, Lawrence, of Feversham, yeoman 0
3632182 1904881 1904881 defendant Haukyswell Thomas, junior yeoman 586009 586009 Haukyswell, Thomas, junior, of Feversham, yeoman 0
3632183 1904881 1904881 defendant Fale Robert yeoman 586009 586009 Fale, Robert, of Feversham, yeoman 1
3632423 1904958 1904958 defendant Browne Agnes widow 586009 586009 Browne, Agnes, of Feversham, widow 0
3635587 1905932 1905932 defendant Brynkborn John   586009 586009 Brynkborn, John, of Feversham, wax chandler 1
3635644 1905949 1905949 defendant Crotynden Nicholas husbandman or mariner 586009 586009 Crotynden, Nicholas, of Feversham, husbandman or mariner 3
3636696 1906269 1906269 defendant Fenner John yeoman or baker 586009 586009 Fenner, John, of Feversham, yeoman or baker 0
3639707 1907228 1907228 plaintiff Withiott Robert (legal representative) 586009 586009 Withiott, Robert, of Feversham, gent, executors of 0
3639831 1907271 1907271 defendant Sherwode William husbandman 586009 586009 Sherwode, William, of Feversham, husbandman 0
3642169 1907999 1907999 plaintiff Byrche Thomas   586009 586009 Byrche, Thomas, of Feversham 0
3645985 1909137 1909137 defendant Haukyswell Thomas, junior yeoman 586009 586009 Haukyswell, Thomas, junior, of Feversham, yeoman 0
3651743 1910898 1910898 defendant Greneham John husbandman 586009 586009 Greneham, John, of Feversham, husbandman 2
3664696 1914910 1914910 defendant Partrich Thomas gent 586009 586009 Partrich, Thomas, of Feversham, gent 0
3665555 1915177 1915177 defendant Sybthorp William butcher 586009 586009 Sybthorp, William, of Feversham, butcher 0
3665583 1915186 1915186 defendant Norton William gent 586009 586009 Norton, William, of Feversham, gent 0
3665666 1915211 1915211 defendant Norton William gent 586009 586009 Norton, William, of Feversham, gent 0
3671293 1916996 1916996 defendant Byrche Thomas butcher 586009 586009 Byrche, Thomas, of Feversham, butcher 1
3671313 1917002 1917002 defendant Byrche Thomas butcher 586009 586009 Byrche, Thomas, of Feversham, butcher 0
3671314 1917002 1917002 defendant Roche John yeoman 586009 586009 Roche, John, of Feversham, yeoman 1
3672925 1917544 1917544 defendant Hogen John butcher 586009 586009 Hogen, John, of Feversham, butcher 0
3689337 1922829 1922829 defendant Sayer John yeoman 586009 586009 Sayer, John, of Feversham, yeoman 0
3744730 1940246 1940246 defendant Cryour Richard baker or miller 586009 586009 Cryour, Richard, of Feversham, baker or miller 0
3756190 1943895 1943895 defendant Fynnar William baker 586009 586009 Fynnar, William, of Feversham, baker 0
3757207 1944236 1944236 defendant Cryour or Caryour Richard baker or miller 586009 586009 Cryour or Caryour, Richard, of Feversham, baker or miller 0
3761885 1945725 1945725 defendant Wyllard John (legal representative) 586009 586009 Wyllard, John, of Feversham, executor of 3
3770986 1948614 1948614 defendant Mantell William yeoman 586009 586009 Mantell, William, of Feversham, yeoman 1
3777209 1950622 1950622 defendant Seyer John yeoman 586009 586009 Seyer, John, of Feversham, yeoman 2
3820950 1964447 1964447 defendant Fowle Edward yeoman 586009 586009 Fowle, Edward, of Feversham, yeoman 0
3820952 1964448 1964448 defendant Fowle Edward yeoman 586009 586009 Fowle, Edward, of Feversham, yeoman 0
3822410 1964907 1964907 defendant Norton John gent 586009 586009 Norton, John, of Feversham, gent, son of Norton, William, of Feversham, gent 0
3823263 1965193 1965193 defendant Glover Thomas grocer 586009 586009 Glover, Thomas, of Feversham, grocer 0
3862096 1977509 1977509 defendant Sharpe Richard gent 586009 586009 Sharpe, Richard, of Feversham, gent 0
3884377 1985043 1985043 defendant Newman John butcher 586009 586009 Newman, John, of Feversham, butcher 0
3884603 1985123 1985123 defendant Scott William yeoman 586009 586009 Scott, William, of Feversham, yeoman 1
3888156 1986294 1986294 defendant Grover Robert butcher 586009 586009 Grover, Robert, of Feversham, butcher 0
3915965 1995720 1995720 plaintiff Dunkyn Thomas merchant 586009 586009 Dunkyn, Thomas, of Feversham, merchant 0
3946051 2005694 2005694 defendant Mylles John yeoman 586009 586009 Mylles, John, of Feversham, yeoman 1
3957389 2009648 2009648 plaintiff Philpott Henry yeoman 586009 586009 Philpott, Henry, of Feversham, yeoman 0
3980237 2017697 2017697 defendant Warner Nicholas yeoman 586009 586009 Warner, Nicholas, of Feversham, yeoman 0
3980239 2017698 2017698 defendant Warner Nicholas yeoman 586009 586009 Warner, Nicholas, of Feversham, yeoman 0
3983972 2019036 2019036 plaintiff Stone John draper 586009 586009 Stone, John, of Feversham, draper 0
3991783 2021814 2021814 defendant Oldfeld John merchant 586009 586009 Oldfeld, John, of Feversham, merchant 1
3999703 2024656 2024656 defendant Bromefeld Thomas grocer 586009 586009 Bromefeld, Thomas, of Feversham, grocer 1
4002392 2025632 2025632 defendant Snode or Snothe John yeoman 586009 586009 Snode or Snothe, John, of Feversham, yeoman 0
4002394 2025633 2025633 defendant Snode ot Snothe John yeoman 586009 586009 Snode ot Snothe, John, of Feversham, yeoman 0
4007726 2027548 2027548 defendant Merefylde Thomas yeoman 586009 586009 Merefylde, Thomas, of Feversham, , yeoman 0
4007727 2027548 2027548 defendant Gill Thomas yeoman 586009 586009 Gill, Thomas, of Feversham, yeoman 1
4007730 2027549 2027549 defendant Gyll Thomas yeoman 586009 586009 Gyll, Thomas, of Feversham, yeoman 1
4019479 2031695 2031695 defendant Oldfeld Clement merchant 586009 586009 Oldfeld, Clement, of Feversham, merchant 0
4025602 2033811 2033811 defendant Oldfild John merchant 586009 586009 Oldfild, John, of Feversham, merchant 1
4030020 2035382 2035382 defendant Hampton William merchant 586009 586009 Hampton, William, of Feversham, merchant 0
4030024 2035383 2035383 defendant Hampton William merchant 586009 586009 Hampton, William, of Feversham, merchant 0
4031074 2035785 2035785 defendant Philpott John yeoman 586009 586009 Philpott, John, of Feversham, yeoman 0
4031075 2035785 2035785 defendant Neale John yeoman 586009 586009 Neale, John, of Feversham, yeoman 1
4031076 2035785 2035785 defendant Otterton Edward yeoman 586009 586009 Otterton, Edward, of Feversham, yeoman 2
4031078 2035786 2035786 defendant Philpott John yeoman 586009 586009 Philpott, John, of Feversham, yeoman 0
4031079 2035786 2035786 defendant Neale John yeoman 586009 586009 Neale, John, of Feversham, yeoman 1
4031080 2035786 2035786 defendant Otterton Edward yeoman 586009 586009 Otterton, Edward, of Feversham, yeoman 2
4032119 2036154 2036154 defendant Hubberd Gregory merchant 586009 586009 Hubberd, Gregory, of Feversham, merchant 1
4032122 2036155 2036155 defendant Hubberd Gregory merchant 586009 586009 Hubberd, Gregory, of Feversham, merchant 1
4045360 2040795 2040795 plaintiff Rye Robert mariner 586009 586009 Rye, Robert, of Feversham, mariner 0
4045362 2040796 2040796 plaintiff Rye Robert mariner 586009 586009 Rye, Robert, of Feversham, mariner 0
4050746 2042703 2042703 defendant Hampton William merchant 586009 586009 Hampton, William, of Feversham, merchant 0
4050748 2042704 2042704 defendant Hampton William merchant 586009 586009 Hampton, William, of feversham, merchant 0
4057632 2045110 2045110 defendant Olfild Clement yeoman 586009 586009 Olfild, Clement, of Feversham, yeoman 0
4073357 2050761 2050761 plaintiff Philpott John gent 586009 586009 Philpott, John, of Feversham, gent 0
4077894 2052395 2052395 plaintiff Straunsham John gent 586009 586009 Straunsham, John, of Feversham, gent 0
4125908 2069550 2069550 defendant Hawke Thomas yeoman 586009 586009 Hawke, Thomas, of Feversham, yeoman 0
4150537 2078321 2078321 defendant Harman Philip mariner 586009 586009 Harman, Philip, of Feversham, mariner 2
4161802 2082197 2082197 defendant Bradburne alias Fathers Nicholas gent 586009 586009 Bradburne alias Fathers, Nicholas, of Feversham, gent 0
4171712 2085573 2085573 defendant Romney Richard miller 586009 586009 Romney, Richard, of Feversham, miller 0
4174931 2086697 2086697 defendant Nashe Thomas husbandman 586009 586009 Nashe, Thomas, of Feversham, husbandman 1
4175475 2086895 2086895 defendant Cloke Thomas gent 586009 586009 Cloke, Thomas, of Feversham, gent 0
4190681 2092302 2092302 defendant Tylman Richard yeoman 586009 586009 Tylman, Richard, of Feversham, yeoman 0
4198300 2094954 2094954 defendant Fynche Christopher gent 586009 586009 Fynche, Christopher, of Feversham, gent 1
4199569 2095398 2095398 defendant Wood Thomas gent 586009 586009 Wood, Thomas, of Feversham, gent 0
4203023 2096608 2096608 defendant Onneslye Nicholas fishmonger 586009 586009 Onneslye, Nicholas, of Feversham, fishmonger 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.082ms