names

408 rows where place_id = 585929

✎ 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
3587520 1863744 1863744 defendant Knot Richard butcher 585929 585929 Knot, Richard, of St Clement Danes, butcher 0
3587535 1863749 1863749 defendant Redknape George   585929 585929 Redknape, George, of St Clement Danes, pouch maker 0
3587536 1863749 1863749 defendant Roo John   585929 585929 Roo, John, of St Clement Danes, wax chandler 1
3596071 1866399 1866399 defendant Nunny Katherine widow 585929 585929 Nunny, Katherine, of St Clement Danes, widow 2
3602885 1868570 1868570 defendant Stokes John gent 585929 585929 Stokes, John, of St Clement Danes, gent 0
3602906 1868571 1868571 defendant Stokys John gent 585929 585929 Stokys, John, of St Clement Danes, gent 0
3603005 1868607 1868607 defendant Eton Thomas gent 585929 585929 Eton, Thomas, of St Clement Danes, gent 1
3605320 1869330 1869330 plaintiff Hyll Richard (legal representative) 585929 585929 Hyll, Richard, of St Clement Danes, brewer, executors of 0
3605815 1869485 1869485 defendant Hunt Thomas yeoman 585929 585929 Hunt, Thomas, of St Clement Danes, yeoman 4
3608359 1870273 1870273 defendant Berde John weaver 585929 585929 Berde, John, of St Clement Danes, weaver 1
3608706 1870383 1870383 defendant Kelham James gent 585929 585929 Kelham, James, of St Clement Danes, gent 3
3608768 1870406 1870406 defendant Brocas William gent 585929 585929 Brocas, William, of St Clement Danes, gent 1
3608778 1870409 1870409 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, tailor, executors of 0
3608781 1870409 1870409 defendant Kyrkham George gent 585929 585929 Kyrkham, George, of St Clement Danes, gent 0
3608783 1870409 1870409 defendant Barkeley Richard gent 585929 585929 Barkeley, Richard, of St Clement Danes, gent 2
3608784 1870410 1870410 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, tailor, executors of 0
3608792 1870411 1870411 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, tailor, executors of 0
3608795 1870411 1870411 defendant Kyrkeham George gent 585929 585929 Kyrkeham, George, of St Clement Danes, gent 0
3608797 1870411 1870411 defendant Barkeley Richard gent 585929 585929 Barkeley, Richard, of St Clement Danes, gent 2
3608798 1870412 1870412 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, tailor, executors of 0
3614332 1872137 1872137 defendant Walker John yeoman 585929 585929 Walker, John, of St Clement Danes, yeoman 3
3616757 1872870 1872870 defendant Johnson Gilbert waterman 585929 585929 Johnson, Gilbert, of St Clement Danes, waterman 1
3618485 1873407 1873407 defendant Whyte Thomas currier 585929 585929 Whyte, Thomas, of St Clement Danes, currier 0
3618486 1873407 1873407 defendant Emson Henry currier 585929 585929 Emson, Henry, of St Clement Danes, currier 1
3618877 1873515 1873515 defendant Berkeley Maurice   585929 585929 Berkeley, Maurice, of St Clement Danes, knight 0
3619040 1873561 1873561 defendant Wodeward Richard saddler 585929 585929 Wodeward, Richard, of St Clement Danes, saddler 4
3619044 1873562 1873562 defendant Wodeward Richard saddler 585929 585929 Wodeward, Richard, of St Clement Danes, saddler 2
3620926 1874106 1874106 defendant Bustard John gent 585929 585929 Bustard, John, of St Clement Danes, gent 1
3620929 1874107 1874107 defendant Bustard John gent 585929 585929 Bustard, John, of St Clement Danes, gent 1
3623460 1874871 1874871 defendant Fortescu John   585929 585929 Fortescu, John, of St Clement Danes, knight 0
3624221 1875108 1875108 defendant Harman William laborer 585929 585929 Harman, William, of St Clement Danes, laborer 1
3624635 1875239 1875239 defendant Warwyk Richard grocer 585929 585929 Warwyk, Richard, of St Clement Danes, grocer 0
3624960 1875340 1875340 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, executors of 0
3624967 1875341 1875341 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, tailor, executors of 0
3624974 1875342 1875342 plaintiff Walker Thomas (legal representative) 585929 585929 Walker, Thomas, of St Clement Danes, tailor, executors of 0
3625319 1875455 1875455 defendant Bothe Humphrey gent 585929 585929 Bothe, Humphrey, of St Clement Danes, gent 0
3628294 1903711 1903711 defendant Clervys or Clernys William yeoman 585929 585929 Clervys or Clernys, William, of St Clement Danes, yeoman 0
3639048 1907034 1907034 defendant Bateman Richard smith 585929 585929 Bateman, Richard, of St Clement Danes, smith 0
3640411 1907432 1907432 defendant Lorkyn John butcher 585929 585929 Lorkyn, John, of St Clement Danes, butcher 0
3640613 1907505 1907505 defendant Lorkyn John butcher 585929 585929 Lorkyn, John, of St Clement Danes, butcher 0
3642046 1907962 1907962 defendant Lorkyn John butcher 585929 585929 Lorkyn, John, of St Clement Danes, butcher 0
3643214 1908313 1908313 defendant Torkenton John capper 585929 585929 Torkenton, John, of St Clement Danes, capper 2
3643222 1908314 1908314 defendant Torkenton John capper 585929 585929 Torkenton, John, of St Clement danes, capper 2
3670512 1916739 1916739 defendant Copcot Richard gent 585929 585929 Copcot, Richard, of St Clement Danes, gent 0
3672335 1917348 1917348 defendant Stanhop Michael gent 585929 585929 Stanhop, Michael, of St Clement Danes, gent 0
3677088 1918872 1918872 defendant Woodhousse John (legal representative) 585929 585929 Woodhousse, John, of St Clement Danes, butcher, executrix of 0
3677091 1918873 1918873 defendant Woodhousse John (legal representative) 585929 585929 Woodhousse, John, of St Clement Danes, butcher, executrix of 0
3677092 1918873 1918873 defendant Woodhousse Margaret widow 585929 585929 Woodhousse, Margaret, of St Clement Danes, widow 1
3678480 1919325 1919325 defendant Skynner William butcher 585929 585929 Skynner, William, of St CLement Danes, butcher 1
3692197 1923726 1923726 defendant Barker William tailor 585929 585929 Barker, William, of St Clement Danes, tailor 0
3693378 1924144 1924144 plaintiff Makeryth Gilbert   585929 585929 Makeryth, Gilbert, of St Clement Danes 0
3698974 1925889 1925889 defendant Makerith Gilbert brewer or cook 585929 585929 Makerith, Gilbert, of St Clement Danes, brewer or cook 0
3698975 1925889 1925889 defendant Davyes Thomas baker 585929 585929 Davyes, Thomas, of St Clement Danes, baker 1
3701008 1926562 1926562 defendant Marshall Thomas tailor 585929 585929 Marshall, Thomas, of St Clement Danes, tailor 10
3701623 1926757 1926757 defendant Sleford Richard gent 585929 585929 Sleford, Richard, of St Clement Danes, gent 0
3701624 1926757 1926757 defendant Russheton Henry gent 585929 585929 Russheton, Henry, of St Clement Danes, gent 1
3701651 1926757 1926757 defendant Wastlyn William gent 585929 585929 Wastlyn, William, of St Clement Danes, gent 28
3712989 1930386 1930386 plaintiff Wylkynson Richard barber 585929 585929 Wylkynson, Richard, of St Clement Danes, barber 0
3716341 1931402 1931402 plaintiff Clyff Nicholas innholder 585929 585929 Clyff, Nicholas, of St Clement Danes, innholder 0
3716343 1931402 1931402 defendant Dyconson John tailor 585929 585929 Dyconson, John, of St Clement Danes, tailor 1
3730576 1935798 1935798 defendant Lucas John yeoman 585929 585929 Lucas, John, of St Clement Danes, yeoman 4
3735752 1937420 1937420 defendant Trygg Edward gent 585929 585929 Trygg, Edward, of St Clement Danes, gent 0
3736338 1937607 1937607 defendant Trygg Edward gent 585929 585929 Trygg, Edward, of St Clement Danes, gent 0
3739248 1938496 1938496 defendant Hoppyng Charles gent 585929 585929 Hoppyng, Charles, of St Clement Danes, or of Colaton Ralegh, Devon, gent 0
3744384 1940143 1940143 defendant Dyconson Anne   585929 585929 Dyconson, Anne, of St Clement Danes 1
3756513 1944014 1944014 plaintiff Atkynson William (legal representative) 585929 585929 Atkynson, William, of St Clement Danes, blacksmith, executors of 0
3756516 1944014 1944014 defendant Westlyn William sheeter 585929 585929 Westlyn, William, of St Clement Danes, sheeter 0
3757425 1944301 1944301 defendant Kyrkeham Nicholas esq 585929 585929 Kyrkeham, Nicholas, of St Clement Danes, esq 0
3757426 1944301 1944301 defendant Goodyere Richard gent 585929 585929 Goodyere, Richard, of St Clement Danes, gent 1
3758581 1944680 1944680 defendant Dyker Robert clerk 585929 585929 Dyker, Robert, of St Clement Danes, clerk 1
3760938 1945427 1945427 defendant Swyket John (legal representative) 585929 585929 Swyket, John, of St Clement Danes, butcher, executors of 0
3760939 1945427 1945427 defendant Whyte William butcher 585929 585929 (Whyte, William, of St Clement Danes, butcher 1
3765281 1946806 1946806 defendant Caton Gilbert joiner 585929 585929 Caton, Gilbert, of St Clement Danes, joiner 0
3771597 1948817 1948817 plaintiff Taylour Thomas   585929 585929 Taylour, Thomas, of St Clement Danes, brewer, warden of guild of St Clement 0
3773074 1949282 1949282 defendant Hunter Thomas yeoman 585929 585929 Hunter, Thomas, of St Clement Danes, yeoman 2
3773075 1949282 1949282 defendant Cokkys Geoffrey carpenter 585929 585929 Cokkys, Geoffrey, of St Clement Danes, carpenter 3
3774417 1949721 1949721 defendant Wastlyn William sheather 585929 585929 Wastlyn, William, of St Clement Danes, sheather 0
3779090 1951186 1951186 defendant Swyket John (legal representative) 585929 585929 Swyket, John, of St Clement Danes, butcher, executors of 0
3779094 1951187 1951187 defendant White William butcher 585929 585929 (White, William, of St Clement Danes, butcher 1
3781313 1951896 1951896 defendant Lancaster Ambrose gent 585929 585929 Lancaster, Ambrose, of St Clement Danes, gent 3
3785609 1953289 1953289 defendant Symson Andrew skinner 585929 585929 Symson, Andrew, of St Clement Danes, skinner 0
3793573 1955852 1955852 plaintiff Brmwych Alice widow 585929 585929 Brmwych, Alice, of St Clement Danes, widow 0
3796186 1956675 1956675 defendant Swyket John (legal representative) 585929 585929 Swyket, John, of St Clement Danes, butcher, executors of 0
3797181 1957003 1957003 defendant Fryswell John   585929 585929 Fryswell, John, of St Clement Danes, point maker 0
3797200 1957007 1957007 defendant Fryswell John   585929 585929 Fryswell, John, of St Clement Danes, point maker 0
3798107 1957306 1957306 defendant Wheteley John carpenter 585929 585929 Wheteley, John, of St Clement Danes, carpenter 0
3798108 1957306 1957306 defendant Raynold Richard   585929 585929 Raynold, Richard, of St Clement Danes, pouch maker 1
3798373 1957390 1957390 defendant Cary Richard grocer 585929 585929 Cary, Richard, of St Clement Danes, grocer 1
3798382 1957392 1957392 defendant Cary Richard grocer 585929 585929 Cary, Richard, of St Clement Danes, grocer 1
3806673 1959985 1959985 plaintiff Wastlyn William sheather 585929 585929 Wastlyn, William, of St Clement Danes, sheather 0
3806675 1959986 1959986 plaintiff Wastlyn William sheather 585929 585929 Wastlyn, William, of St Clement Danes, sheather 0
3806677 1959987 1959987 plaintiff Wastlyn William sheather 585929 585929 Wastlyn, William, of St Clement Danes, sheather 0
3807113 1960116 1960116 defendant Wastlyn William sheather 585929 585929 Wastlyn, William, of St Clement Danes, sheather 0
3807115 1960117 1960117 defendant Wastlyn William sheather 585929 585929 Wastlyn, William, of St Clement Danes, sheather 0
3807334 1960196 1960196 plaintiff Stanley John   585929 585929 Stanley, John, of St Clement Danes 1
3811146 1961381 1961381 defendant Rogers Thomas yeoman 585929 585929 Rogers, Thomas, of St Clement Danes, yeoman 2
3822350 1964897 1964897 plaintiff Stanley John   585929 585929 Stanley, John, of St Clement Danes 0
3839234 1970199 1970199 defendant Sylvester George tailor 585929 585929 Sylvester, George, of St Clement Danes, tailor 0
3851730 1974129 1974129 defendant Byrd William currier 585929 585929 Byrd, William, of St Clement Danes, currier 0
3853875 1974846 1974846 defendant Rede Leonard gent 585929 585929 Rede, Leonard, of St Clement Danes, gent 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);