names

796 rows where place_id = 586143

✎ 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
3588024 1863907 1863907 defendant Harper Richard clerk 586143 586143 Harper, Richard, of Norton, clerk 0
3589264 1864283 1864283 defendant Smyth Richard husbandman 586143 586143 Smyth, Richard, of Norton, husbandman 0
3589265 1864283 1864283 defendant Smyth William husbandman 586143 586143 Smyth, William, of Norton, husbandman 1
3589266 1864283 1864283 defendant Lytell John husbandman 586143 586143 Lytell, John, of Norton, husbandman 2
3589267 1864283 1864283 defendant Symondis Robert husbandman 586143 586143 Symondis, Robert, of Norton, husbandman 3
3589268 1864283 1864283 defendant Iddrigge William husbandman 586143 586143 Iddrigge, William, of Norton, husbandman 4
3592237 1865187 1865187 defendant Agas Andrew husbandman 586143 586143 Agas, Andrew, of Norton, husbandman 3
3592242 1865188 1865188 defendant Agas Andrew husbandman 586143 586143 Agas, Andrew, of Norton, husbandman 3
3593412 1865574 1865574 defendant Atkyns Richard yeoman 586143 586143 Atkyns, Richard, of Norton, yeoman 0
3593413 1865574 1865574 defendant Pantewall William yeoman 586143 586143 Pantewall, William, of Norton, yeoman 1
3593414 1865574 1865574 defendant Esebache John husbandman 586143 586143 Esebache, John, of Norton, husbandman 2
3593415 1865574 1865574 defendant Tayls John husbandman 586143 586143 Tayls, John, of Norton, husbandman 3
3593416 1865574 1865574 defendant Heriett Richard husbandman 586143 586143 Heriett, Richard, of Norton, husbandman 4
3593418 1865575 1865575 defendant Chapelen Richard husbandman 586143 586143 Chapelen, Richard, of Norton, husbandman 0
3593419 1865575 1865575 defendant Chavenour Roger husbandman 586143 586143 Chavenour, Roger, of Norton, husbandman 1
3593420 1865575 1865575 defendant Vynche Richard husbandman 586143 586143 Vynche, Richard, of Norton, husbandman 2
3593421 1865575 1865575 defendant Vynche John husbandman 586143 586143 Vynche, John, of Norton, husbandman 3
3595748 1866301 1866301 defendant Hamelyng John butcher 586143 586143 Hamelyng, John, of Norton under Hamedon, butcher 0
3596974 1866680 1866680 defendant Rowyngton John yeoman 586143 586143 Rowyngton, John, of Norton, yeoman 2
3597862 1866951 1866951 defendant Seynt Nycolas Thomas gent 586143 586143 (Seynt Nycolas, Thomas, of Norton, gent 1
3598889 1867278 1867278 defendant Fryday Robert husbandman 586143 586143 Fryday, Robert, of Norton, husbandman 0
3598891 1867279 1867279 defendant Fryday Robert husbandman 586143 586143 Fryday, Robert, of Norton, husbandman 0
3598893 1867280 1867280 defendant Fryday Robert husbandman 586143 586143 Fryday, Robert, of Norton, husbandman 0
3601260 1868057 1868057 defendant Bremfeld John laborer 586143 586143 Bremfeld, John, of Norton, laborer 0
3601413 1868102 1868102 defendant Gocche Edmund smith 586143 586143 Gocche, Edmund, of Norton, smith 0
3601564 1868145 1868145 defendant Bloys John yeoman 586143 586143 Bloys, John, of Norton, yeoman 0
3602457 1868427 1868427 defendant Bydwell John gent 586143 586143 Bydwell, John, of Norton, gent 0
3604172 1868971 1868971 defendant Miller John husbandman 586143 586143 Miller, John, of Norton, husbandman 1
3607728 1870069 1870069 defendant Aleyn John yeoman 586143 586143 Aleyn, John, of Norton, yeoman 4
3607734 1870070 1870070 defendant Aleyn John yeoman 586143 586143 Aleyn, John, of Norton, yeoman 4
3608298 1870253 1870253 defendant Baker John husbandman 586143 586143 Baker, John, of Norton, husbandman 1
3616173 1872697 1872697 defendant Evot Richard husbandman 586143 586143 Evot, Richard, of Norton juxta Worcester, husbandman 0
3616718 1872859 1872859 defendant Hunt Stephen laborer 586143 586143 Hunt, Stephen, of Norton, laborer 1
3617330 1873044 1873044 defendant Bullok James yeoman 586143 586143 Bullok, James, of Norton, yeoman 0
3617337 1873045 1873045 defendant Bullok James yeoman 586143 586143 Bullok, James, of Norton, yeoman 0
3621249 1874186 1874186 defendant Ettekyns Richard, junior husbandman 586143 586143 Ettekyns, Richard, junior, of Norton, husbandman 0
3621251 1874187 1874187 defendant Ettekyns Richard, junior husbandman 586143 586143 Ettekyns, Richard, junior, of Norton, husbandman 0
3623805 1874977 1874977 defendant Goch Edmund smith 586143 586143 Goch, Edmund, of Norton, smith 1
3623809 1874978 1874978 defendant Goche Edmund smith 586143 586143 Goche, Edmund, of Norton, smith 1
3623939 1875017 1875017 defendant Sherard Thomas yeoman 586143 586143 Sherard, Thomas, of Norton, yeoman 1
3623940 1875017 1875017 defendant Cartlage Stephen husbandman 586143 586143 Cartlage, Stephen, of Norton, husbandman 2
3623941 1875017 1875017 defendant Badeley William husbandman 586143 586143 Badeley, William, of Norton, husbandman 3
3626843 1903247 1903247 defendant Etkyns Richard husbandman 586143 586143 Etkyns, Richard, of Norton, husbandman 2
3628175 1903668 1903668 defendant Emson Thomas yeoman 586143 586143 Emson, Thomas, of Norton, yeoman 1
3628394 1903745 1903745 defendant Clement John husbandman 586143 586143 Clement, John, of Norton, husbandman 3
3631376 1904624 1904624 defendant Ramerwyke William maltman 586143 586143 Ramerwyke, William, of Norton, maltman 1
3631377 1904624 1904624 defendant Awebrey John husbandman 586143 586143 Awebrey, John, of Norton, husbandman 2
3632057 1904843 1904843 defendant Goche Edmund smith 586143 586143 Goche, Edmund, of Norton, smith 2
3636132 1906093 1906093 defendant Knyght Thomas (legal representative) 586143 586143 Knyght, Thomas, of Norton, yeoman, executor of 0
3636510 1906213 1906213 defendant Bayleman Richard husbandman 586143 586143 Bayleman, Richard, of Norton, husbandman 1
3639264 1907091 1907091 defendant Emson Thomas husbandman 586143 586143 Emson, Thomas, of Norton, husbandman 0
3639266 1907092 1907092 defendant Emson Thomas husbandman 586143 586143 Emson, Thomas, of Norton, husbandman 0
3640124 1907356 1907356 defendant Greneham Thomas miller 586143 586143 Greneham, Thomas, of Norton under Hampton, miller 2
3640408 1907431 1907431 defendant Dale William sherman 586143 586143 Dale, William, of Norton, sherman 0
3642389 1908064 1908064 defendant Clement John husbandman 586143 586143 Clement, John, of Norton, husbandman 2
3648919 1910050 1910050 defendant Cudworth Thomas husbandman 586143 586143 Cudworth, Thomas, of Norton, husbandman 0
3649136 1910117 1910117 defendant Norton Richard esq 586143 586143 Norton, Richard, of Norton, esq 0
3649137 1910117 1910117 defendant Duffeld James yeoman 586143 586143 Duffeld, James, of Norton, yeoman 1
3652583 1911142 1911142 defendant Knyght John husbandman 586143 586143 Knyght, John, of Norton, husbandman 1
3652740 1911177 1911177 defendant Baron William chaplain 586143 586143 Baron, William, of Norton, chaplain 2
3661319 1913817 1913817 plaintiff Knyght John   586143 586143 Knyght, John, of Norton 0
3665161 1915057 1915057 defendant Aubyn Thomas yeoman 586143 586143 Aubyn, Thomas, of Norton, yeoman 0
3667940 1915912 1915912 defendant Roos Hugh husbandman 586143 586143 Roos, Hugh, of Norton, husbandman 3
3673528 1917747 1917747 defendant Goche Edmund smith 586143 586143 Goche, Edmund, of Norton, smith 3
3674182 1917962 1917962 plaintiff Smyth John   586143 586143 Smyth, John, of Norton 2
3674568 1918097 1918097 defendant Gryme John laborer 586143 586143 Gryme, John, of Norton, laborer 2
3675503 1918375 1918375 defendant Clifton William yeoman 586143 586143 Clifton, William, of Norton, yeoman 1
3677182 1918905 1918905 defendant Herryettys Ralph yeoman 586143 586143 Herryettys, Ralph, of Norton, yeoman 2
3679317 1919592 1919592 defendant Garard John husbandman 586143 586143 Garard, John, of Norton, husbandman 1
3698578 1925773 1925773 defendant Fordham George husbandman 586143 586143 Fordham, George, of Norton, husbandman 1
3700449 1926378 1926378 defendant Parker Robert yeoman 586143 586143 Parker, Robert, of Norton, yeoman 0
3700800 1926502 1926502 defendant Skipton Robert husbandman 586143 586143 Skipton, Robert, of Norton, husbandman 0
3700801 1926502 1926502 defendant Knyght Thomas gent 586143 586143 Knyght, Thomas, of Norton, gent 1
3706256 1928244 1928244 defendant Robyns John husbandman 586143 586143 Robyns, John, of Norton, husbandman 0
3710927 1929735 1929735 plaintiff Stane or Stave William yeoman 586143 586143 Stane or Stave, William, of Norton, yeoman 0
3714662 1930882 1930882 defendant Fuller Thomas husbandman 586143 586143 Fuller, Thomas, of Norton, husbandman 1
3718808 1932163 1932163 defendant Ronnold John husbandman 586143 586143 Ronnold, John, of Norton, husbandman 1
3720325 1932636 1932636 defendant Harriettis Ralph yeoman 586143 586143 Harriettis, Ralph, of Norton, yeoman 5
3723781 1933714 1933714 defendant Salesbery Thomas carpenter 586143 586143 Salesbery, Thomas, of Norton under Hamden, carpenter 0
3724272 1933879 1933879 defendant Garden John husbandman 586143 586143 Garden, John, of Norton, husbandman 1
3724348 1933903 1933903 plaintiff Roberde John   586143 586143 Roberde, John, of Norton 0
3725352 1934223 1934223 plaintiff Somerton Thomas   586143 586143 Somerton, Thomas, of Norton 0
3725353 1934223 1934223 defendant Edward Thomas shoemaker 586143 586143 Edward, Thomas, of Norton, shoemaker 0
3733707 1936789 1936789 defendant Parker John yeoman 586143 586143 Parker, John, of Norton, yeoman 0
3735784 1937430 1937430 defendant Yardley Hugh husbandman 586143 586143 Yardley, Hugh, of Norton, husbandman 3
3739419 1938538 1938538 defendant Cote Thomas   586143 586143 Cote, Thomas, of Norton, mason 0
3741423 1939184 1939184 defendant Howes Joan widow 586143 586143 Howes, Joan, of Norton, widow 1
3744130 1940064 1940064 defendant Knyght Thomas yeoman 586143 586143 Knyght, Thomas, of Norton, yeoman 0
3745749 1940572 1940572 plaintiff Bythell John   586143 586143 Bythell, John, of Norton 0
3748695 1941520 1941520 defendant Stevyn John laborer 586143 586143 Stevyn, John, of Norton, laborer 3
3748696 1941520 1941520 defendant Marten John laborer 586143 586143 Marten, John, of Norton, laborer 4
3748697 1941520 1941520 defendant Ryson John tailor 586143 586143 Ryson, John, of Norton, tailor 5
3753855 1943151 1943151 defendant Middelton John yeoman 586143 586143 Middelton, John, of Norton, yeoman 0
3756238 1943910 1943910 defendant Knyght Thomas yeoman 586143 586143 Knyght, Thomas, of Norton, yeoman 0
3758320 1944597 1944597 defendant Knyght Thomas gent 586143 586143 Knyght, Thomas, of Norton, gent 0
3758802 1944741 1944741 defendant Stane of Stave William, junior husbandman 586143 586143 Stane of Stave, William, junior, of Norton, husbandman 1
3760353 1945241 1945241 defendant Fynche Nicholas gent 586143 586143 Fynche, Nicholas, of Norton, gent 0
3763474 1946208 1946208 defendant Atkyns Richard   586143 586143 Atkyns, Richard, of Norton, yeoman, administrators of 1
3763475 1946208 1946208 defendant Long John husbandman 586143 586143 (Long, John, of Norton, husbandman 2
3763682 1946284 1946284 defendant Johns William carver 586143 586143 Johns, William, of Norton, carver 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);