names

527 rows where place_id = 586464

✎ 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
3588788 1864137 1864137 defendant Mylle John yeoman 586464 586464 Mylle, John, of Croydon, yeoman 2
3589102 1864239 1864239 defendant Cooke Richard yeoman 586464 586464 Cooke, Richard, of Croydon, yeoman 3
3590575 1864694 1864694 defendant Canseler Thomas gent 586464 586464 Canseler, Thomas, of Croydon, gent 0
3593716 1865674 1865674 defendant Waker John husbandman 586464 586464 Waker, John, of Croydon, husbandman 0
3595426 1866202 1866202 defendant Edward John   586464 586464 Edward, John, of Croydon, Surrey, yailor 0
3596840 1866647 1866647 defendant Melche Mathew smith 586464 586464 Melche, Mathew, of Croydon, smith 1
3596843 1866647 1866647 defendant Ludby John carpenter 586464 586464 Ludby, John, of Croydon, carpenter 4
3598341 1867110 1867110 defendant Bradshawe Robert goldsmith 586464 586464 Bradshawe, Robert, of Croydon or of London, goldsmith 0
3600301 1867740 1867740 defendant Colgrem William husbandman 586464 586464 Colgrem, William, of Croydon, husbandman 0
3614464 1872173 1872173 defendant Bolt Robert baker 586464 586464 Bolt, Robert, of Croydon, baker 0
3614465 1872173 1872173 defendant Comfort William yeoman 586464 586464 Comfort, William, of Croydon, yeoman 1
3614466 1872173 1872173 defendant Vyttyll Henry butcher 586464 586464 Vyttyll, Henry, of Croydon, butcher 2
3614468 1872174 1872174 defendant Squyre Henry yeoman 586464 586464 Squyre, Henry, of Croydon, yeoman 0
3614469 1872174 1872174 defendant Bolt Robert baker 586464 586464 Bolt, Robert, of Croydon, baker 1
3614470 1872174 1872174 defendant Vityll Henry butcher 586464 586464 Vityll, Henry, of Croydon, butcher 2
3614471 1872174 1872174 defendant Comfort William yeoman 586464 586464 Comfort, William, of Croydon, yeoman 3
3614997 1872334 1872334 defendant Squery Henry yeoman 586464 586464 Squery, Henry, of Croydon, yeoman 0
3619646 1873714 1873714 defendant Baudewyn John yeoman 586464 586464 Baudewyn, John, of Croydon, yeoman 1
3619651 1873714 1873714 defendant Isacke William laborer 586464 586464 Isacke, William, of Croydon, laborer 6
3621496 1874264 1874264 defendant Page William collier 586464 586464 Page, William, of Croydon, collier 0
3621497 1874264 1874264 defendant Dayn Thomas collier 586464 586464 Dayn, Thomas, of Croydon, collier 1
3624682 1875257 1875257 defendant Mapylton William collier 586464 586464 Mapylton, William, of Croydon, collier 0
3634188 1905495 1905495 defendant Atwode William laborer 586464 586464 Atwode, William, of Croydon, laborer 0
3634189 1905495 1905495 defendant Smyth John collier 586464 586464 Smyth, John, of Croydon, collier 1
3634190 1905495 1905495 defendant Atwode Henry yeoman 586464 586464 Atwode, Henry, of Croydon, yeoman 2
3634191 1905495 1905495 defendant Chappleyn John laborer 586464 586464 Chappleyn, John, of Croydon, laborer 3
3639278 1907097 1907097 defendant Mathewe Robert yeoman 586464 586464 Mathewe, Robert, of Croydon, yeoman 0
3639279 1907097 1907097 defendant Storer William yeoman 586464 586464 Storer, William, of Croydon, yeoman 1
3639280 1907097 1907097 defendant Grymell Walter laborer 586464 586464 Grymell, Walter, of Croydon, laborer 2
3639281 1907097 1907097 defendant Baylly John yeoman 586464 586464 Baylly, John, of Croydon, yeoman 3
3643902 1908523 1908523 defendant Garrett Thomas tiler 586464 586464 Garrett, Thomas, of Croydon, tiler 0
3644626 1908730 1908730 defendant Sydnam Christopher gent 586464 586464 Sydnam, Christopher, of Croydon, gent 2
3645023 1908851 1908851 defendant Sydnam Christopher gent 586464 586464 Sydnam, Christopher, of Croydon, gent 1
3645523 1908996 1908996 defendant Westwode John yeoman 586464 586464 Westwode, John, of Croydon, yeoman 4
3645960 1909129 1909129 defendant Kyng John yeoman 586464 586464 Kyng, John, of Croydon, yeoman 0
3648329 1909878 1909878 defendant Forde John weaver 586464 586464 Forde, John, of Croydon, weaver 0
3648330 1909878 1909878 defendant Harmond Robert laborer 586464 586464 Harmond, Robert, of Croydon, laborer 1
3648331 1909878 1909878 defendant Huntman John husbandman 586464 586464 Huntman, John, of Croydon, husbandman 2
3649434 1910213 1910213 defendant Slyxston Robert fuller 586464 586464 Slyxston, Robert, of Croydon, fuller 0
3652489 1911110 1911110 defendant Burton John yeoman 586464 586464 Burton, John, of Croydon, yeoman 0
3652490 1911110 1911110 defendant Monday John yeoman 586464 586464 Monday, John, of Croydon, yeoman 1
3652491 1911110 1911110 defendant Stevyn John yeoman 586464 586464 Stevyn, John, of Croydon, yeoman 2
3657969 1912745 1912745 defendant Warre John yeoman 586464 586464 Warre, John, of Croydon, yeoman 0
3666648 1915514 1915514 defendant Nicoles Edmund laborer 586464 586464 Nicoles, Edmund, of Croydon, laborer 0
3666649 1915514 1915514 defendant Elys John laborer 586464 586464 Elys, John, of Croydon, laborer 1
3666845 1915573 1915573 defendant Squery Henry yeoman 586464 586464 Squery, Henry, of Croydon, yeoman 0
3666847 1915573 1915573 defendant Vytell John   586464 586464 Vytell, John, of Croydon, shoe maker 2
3672809 1917505 1917505 defendant Garrett Thomas tiler 586464 586464 Garrett, Thomas, of Croydon, tiler 0
3675576 1918397 1918397 defendant Talbott William chaplain 586464 586464 Talbott, William, of Croydon, chaplain 0
3675577 1918397 1918397 defendant Crokys John painter 586464 586464 Crokys, John, of Croydon, painter 1
3675734 1918445 1918445 defendant Warr John yeoman 586464 586464 Warr, John, of Croydon, yeoman 0
3675739 1918446 1918446 defendant Warre John yeoman 586464 586464 Warre, John, of Croydon, yeoman 0
3679736 1919732 1919732 defendant Smyth John butcher 586464 586464 Smyth, John, of Croydon, butcher 2
3680885 1920105 1920105 defendant Shelok William laborer 586464 586464 Shelok, William, of Croydon, laborer 0
3688730 1922637 1922637 defendant Snowe John butcher 586464 586464 Snowe, John, of Croydon, butcher 0
3696946 1925267 1925267 defendant Titerton John yeoman 586464 586464 Titerton, John, of Croydon, yeoman 1
3696947 1925267 1925267 defendant Snowe John butcher 586464 586464 Snowe, John, of Croydon, butcher 2
3699904 1926199 1926199 defendant Denham Robert collier 586464 586464 Denham, Robert, of Croydon, collier 0
3703527 1927378 1927378 defendant Snowe John butcher 586464 586464 Snowe, John, of Croydon, butcher 0
3709794 1929378 1929378 defendant Dowce Thomas baker 586464 586464 Dowce, Thomas, of Croydon, baker 0
3709795 1929378 1929378 defendant Chepman Thomas laborer 586464 586464 Chepman, Thomas, of Croydon, laborer 1
3712175 1930126 1930126 defendant Heron Thomas gent 586464 586464 Heron, Thomas, of Croydon, gent 0
3712176 1930126 1930126 defendant Vytell John cordwainer 586464 586464 Vytell, John, of Croydon, cordwainer 1
3712177 1930126 1930126 defendant Busted John yeoman 586464 586464 Busted, John, of Croydon, yeoman 2
3715019 1930992 1930992 defendant Denys Michael (legal representative) 586464 586464 Denys, Michael, of Croydon, gent, executrix of 1
3718778 1932152 1932152 defendant Dowce Thomas yeoman 586464 586464 Dowce, Thomas, of Croydon, yeoman 0
3719286 1932317 1932317 defendant Dowse Thomas husbandman 586464 586464 Dowse, Thomas, of Croydon, husbandman 0
3719287 1932317 1932317 defendant Benskyn John husbandman 586464 586464 Benskyn, John, of Croydon, husbandman 1
3719288 1932317 1932317 defendant Howland Robert husbandman 586464 586464 Howland, Robert, of Croydon, husbandman 2
3719315 1932329 1932329 defendant Staunton Richard yeoman 586464 586464 Staunton, Richard, of Croydon, yeoman 0
3719929 1932503 1932503 plaintiff Heron Thomas esq 586464 586464 Heron, Thomas, of Croydon, esq 0
3728365 1935114 1935114 defendant Lambethe John butcher 586464 586464 Lambethe, John, of Croydon, butcher 3
3730181 1935665 1935665 defendant Snowe John butcher 586464 586464 Snowe, John, of Croydon, butcher 0
3735080 1937213 1937213 defendant Staunton Richard yeoman 586464 586464 Staunton, Richard, of Croydon, yeoman 0
3743036 1939670 1939670 defendant Heron Thomas esq 586464 586464 Heron, Thomas, of Croydon, esq 0
3743960 1939999 1939999 defendant Ownsted Thomas husbandman 586464 586464 Ownsted, Thomas, of Croydon, husbandman 0
3744025 1940024 1940024 defendant Cheke William yeoman 586464 586464 Cheke, William, of Croydon, yeoman 0
3750895 1942203 1942203 defendant Cosyn Henry tiler 586464 586464 Cosyn, Henry, of Croydon, tiler 0
3753989 1943199 1943199 defendant Stokfeld Thomas husbandman 586464 586464 Stokfeld, Thomas, of Croydon, husbandman 0
3755662 1943727 1943727 defendant Storer William, senior yeoman 586464 586464 Storer, William, senior, of Croydon, yeoman 0
3755663 1943727 1943727 defendant Storer William, junior yeoman 586464 586464 Storer, William, junior, of Croydon, yeoman 1
3757853 1944435 1944435 defendant Johnson Adrian butcher 586464 586464 Johnson, Adrian, of Croydon, butcher 0
3757854 1944435 1944435 defendant Bartlott John smith 586464 586464 Bartlott, John, of Croydon, smith 1
3768813 1947894 1947894 defendant Wakerell John, senior yeoman 586464 586464 Wakerell, John, senior, of Croydon, yeoman 3
3771216 1948687 1948687 defendant Stokfeld Thomas husbandman 586464 586464 Stokfeld, Thomas, of Croydon, husbandman 0
3773632 1949470 1949470 defendant Storer William, senior yeoman 586464 586464 Storer, William, senior, of Croydon, yeoman 0
3773633 1949470 1949470 defendant Storer William, junior yeoman 586464 586464 Storer, William, junior, of Croydon, yeoman 1
3775874 1950207 1950207 defendant Hudson Henry beer brewer 586464 586464 Hudson, Henry, of Croydon, beer brewer 1
3776388 1950367 1950367 defendant Heron Thomas esq 586464 586464 Heron, Thomas, of Croydon, esq 0
3788845 1954315 1954315 defendant Stokfeld Thomas husbandman 586464 586464 Stokfeld, Thomas, of Croydon, husbandman 0
3794054 1956002 1956002 defendant Cadborne John wheeler 586464 586464 (Cadborne, John, of Croydon, wheeler 1
3816004 1962906 1962906 defendant Hancok John yeoman of the guard 586464 586464 Hancok, John, of Croydon, yeoman of the guard 1
3862757 1977736 1977736 defendant Fesaunt Christopher barber 586464 586464 Fesaunt, Christopher, of Croydon, barber 0
3877644 1982763 1982763 defendant Ryder Edward laborer 586464 586464 Ryder, Edward, of Croydon, laborer 3
3887318 1986025 1986025 defendant Thornton John husbandman 586464 586464 Thornton, John, of Croydon, husbandman 0
3887320 1986026 1986026 defendant Bridges Richard chandler 586464 586464 Bridges, Richard, of Croydon, chandler 0
3887635 1986112 1986112 defendant Heron Thomas esq 586464 586464 Heron, Thomas, of Croydon, esq 0
3892382 1987703 1987703 defendant Tyrrell William butcher 586464 586464 Tyrrell, William, of Croydon, butcher 0
3892384 1987704 1987704 defendant Tyrrell William butcher 586464 586464 Tyrrell, William, of Croydon, butcher 0
3909293 1993402 1993402 defendant Smyth John yeoman 586464 586464 Smyth, John, of Croydon, yeoman 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);