names

714 rows where place_id = 586312

✎ 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
3588405 1864021 1864021 defendant Nycoll John draper 586312 586312 Nycoll, John, of Walden, draper 0
3601821 1868226 1868226 defendant Lawsell John shoemaker 586312 586312 Lawsell, John, of Walden, shoemaker 0
3601822 1868227 1868227 plaintiff Benne John, junior yeoman 586312 586312 Benne, John, junior, of Walden, yeoman 0
3604759 1869153 1869153 plaintiff Nicoll John, junior   586312 586312 Nicoll, John, junior, of Walden 1
3605161 1869279 1869279 defendant Carter John fisher 586312 586312 Carter, John, of Walden, fisher 0
3605162 1869279 1869279 defendant Hunte Robert   586312 586312 Hunte, Robert, of Walden, collar maker 1
3605229 1869303 1869303 defendant Penyfader John husbandman 586312 586312 Penyfader, John, of Walden Abbot, husbandman 1
3607452 1869990 1869990 plaintiff Rutlond John   586312 586312 Rutlond, John, of Walden 0
3607453 1869990 1869990 defendant Hunt Robert husbandman 586312 586312 Hunt, Robert, of Walden, husbandman 0
3607455 1869990 1869990 defendant Flak Thomas husbandman 586312 586312 Flak, Thomas, of Walden, husbandman 2
3607456 1869990 1869990 defendant Edward William   586312 586312 Edward, William, of Walden, wheel wright 3
3607749 1870074 1870074 plaintiff Semar Thomas   586312 586312 Semar, Thomas, of Walden 0
3607750 1870074 1870074 defendant Symson John yeoman 586312 586312 Symson, John, of Walden, yeoman 0
3607751 1870075 1870075 plaintiff Semer Thomas   586312 586312 Semer, Thomas, of Walden 0
3618231 1873326 1873326 plaintiff Greswell John grocer 586312 586312 Greswell, John, of Walden, grocer 0
3621127 1874162 1874162 defendant Brounesmyth Thomas yeoman 586312 586312 Brounesmyth, Thomas, of Walden, yeoman 10
3621132 1874162 1874162 defendant Bruett William yeoman 586312 586312 Bruett, William, of Walden, yeoman 15
3621598 1874295 1874295 defendant Knyght Thomas woolman 586312 586312 Knyght, Thomas, of Walden, woolman 0
3623005 1874721 1874721 defendant Mayhewe John husbandman 586312 586312 Mayhewe, John, of Walden, husbandman 1
3623341 1874831 1874831 plaintiff Semer Thomas   586312 586312 Semer, Thomas, of Walden 0
3623343 1874832 1874832 plaintiff Semer Thomas   586312 586312 Semer, Thomas, of Walden 0
3623344 1874832 1874832 defendant Hegge John dyer 586312 586312 Hegge, John, of Walden, dyer 0
3623345 1874832 1874832 defendant Walhed William glover 586312 586312 Walhed, William, of Walden, glover 1
3628326 1903721 1903721 defendant Martyn Ralph   586312 586312 Martyn, Ralph, of Walden, wheelwright 0
3628328 1903721 1903721 defendant Birgys Richard baker 586312 586312 Birgys, Richard, of Walden, baker 2
3633706 1905353 1905353 defendant Cleydon Robert shoemaker 586312 586312 Cleydon, Robert, of Walden, shoemaker 0
3633707 1905353 1905353 defendant Warde John   586312 586312 Warde, John, of Walden, collar maker 1
3633708 1905353 1905353 defendant Patenson William laborer 586312 586312 Patenson, William, of Walden, laborer 2
3634954 1905734 1905734 defendant Adam Nicholas   586312 586312 Adam, Nicholas, of Walden, grocer, administrators of 0
3634955 1905734 1905734 defendant Heron Thomas fishmonger 586312 586312 (Heron, Thomas, of Walden, fishmonger 1
3634956 1905734 1905734 defendant Adam Joan widow 586312 586312 Adam, Joan, of Walden, widow 2
3635608 1905941 1905941 plaintiff Pelham John (legal representative) 586312 586312 Pelham, John, of Walden, executor of 0
3635614 1905942 1905942 plaintiff Pelham John (legal representative) 586312 586312 Pelham, John, of Walden, executor of 0
3636315 1906149 1906149 defendant Rendham Robert Essex, draper 586312 586312 Rendham Robert, of Walden, Essex, draper 3
3637491 1906535 1906535 defendant Fesaunt William draper 586312 586312 Fesaunt, William, of Walden, draper 0
3639653 1907212 1907212 plaintiff Williamson James   586312 586312 Williamson, James, of Walden 0
3639654 1907212 1907212 defendant Cowper Richard tailor 586312 586312 Cowper, Richard, of Walden, tailor 0
3640397 1907427 1907427 plaintiff Adam Nicholas   586312 586312 Adam, Nicholas, of Walden, grocer, administrators of 0
3652372 1911079 1911079 defendant Langley John tanner 586312 586312 Langley, John, of Walden, tanner 0
3663096 1914369 1914369 plaintiff Nycolles John draper 586312 586312 Nycolles, John, of Walden, draper 0
3663304 1914447 1914447 defendant Adams John   586312 586312 Adams, John, of Walden, wax chandler 4
3678833 1919448 1919448 plaintiff Nycoll John draper 586312 586312 Nycoll, John, of Walden, draper 0
3679335 1919599 1919599 plaintiff Pecok John   586312 586312 Pecok, John, of Walden 0
3679447 1919637 1919637 defendant Reymont John shoemaker 586312 586312 Reymont, John, of Walden, shoemaker 0
3679449 1919637 1919637 defendant Patenmaker Benedict   586312 586312 Patenmaker, Benedict, of Walden, paten maker 2
3679450 1919637 1919637 defendant Reder Nicholas   586312 586312 Reder, Nicholas, of Walden, paten maker 3
3682538 1920642 1920642 defendant Lamberd Thomas yeoman 586312 586312 Lamberd, Thomas, of Walden, yeoman 0
3688462 1922545 1922545 plaintiff Smyth John   586312 586312 Smyth, John, of Walden 2
3688466 1922546 1922546 plaintiff Smyth John   586312 586312 Smyth, John, of Walden 2
3695177 1924713 1924713 defendant Raymont John shoemaker 586312 586312 Raymont, John, of Walden, shoemaker 1
3695178 1924713 1924713 defendant Raymont Thomas shoemaker 586312 586312 Raymont, Thomas, of Walden, shoemaker 2
3709411 1929243 1929243 defendant Gyva John   586312 586312 Gyva, John, of Walden, senior, fan maker 0
3709412 1929243 1929243 defendant Gyva John   586312 586312 Gyva, John, of Walden, junior, fan maker 1
3722978 1933452 1933452 plaintiff Nichollis John (legal representative) 586312 586312 Nichollis, John, of Walden, draper, executors of 0
3723537 1933632 1933632 defendant Hart John laborer 586312 586312 Hart, John, of Walden, laborer 0
3724022 1933797 1933797 defendant Gyva John, senior   586312 586312 Gyva, John, senior, of Walden, Essex, fanwright 0
3724023 1933797 1933797 defendant Gyva John, junior   586312 586312 Gyva, John, junior, of Walden, Essex, fanwright 1
3727147 1934762 1934762 defendant Dowson John yeoman 586312 586312 Dowson, John, of Walden, yeoman 0
3735568 1937359 1937359 defendant Benet John yeoman 586312 586312 Benet, John, of Walden, yeoman 4
3743767 1939934 1939934 defendant Adam John husbandman 586312 586312 Adam, John, of Walden, husbandman 1
3748022 1941301 1941301 defendant Wikham John yeoman 586312 586312 Wikham, John, of Walden, yeoman 0
3755981 1943825 1943825 defendant Rycard Thomas husbandman 586312 586312 Rycard, Thomas, of Walden, husbandman 0
3757777 1944413 1944413 defendant Butte John hosier 586312 586312 Butte, John, of Walden, hosier 0
3757778 1944413 1944413 defendant Wykham John barber 586312 586312 Wykham, John, of Walden, barber 1
3757779 1944413 1944413 defendant Bateman John haberdasher 586312 586312 Bateman, John, of Walden, haberdasher 2
3758173 1944545 1944545 defendant Gweyn Roger husbandman 586312 586312 Gweyn, Roger, of Walden, husbandman 0
3758174 1944545 1944545 defendant Stanes Thomas laborer 586312 586312 Stanes, Thomas, of Walden, laborer 1
3758175 1944545 1944545 defendant Jakson William laborer 586312 586312 Jakson, William, of Walden, laborer 2
3758176 1944545 1944545 defendant Cosse William husbandman 586312 586312 Cosse, William, of Walden, husbandman 3
3758430 1944632 1944632 defendant Carter John, junior   586312 586312 Carter, John, junior, of Walden, yeoman, son of Carter, John, senior 0
3758655 1944703 1944703 plaintiff Byrde Thomas yeoman 586312 586312 Byrde, Thomas, of Walden, yeoman 0
3758663 1944704 1944704 defendant Smyth Thomas yeoman 586312 586312 Smyth, Thomas, of Walden, yeoman 0
3758664 1944704 1944704 defendant Smyth Nicholas yeoman 586312 586312 Smyth, Nicholas, of Walden, yeoman 1
3758665 1944704 1944704 defendant Reder Thomas yeoman 586312 586312 Reder, Thomas, of Walden, yeoman 2
3759430 1944940 1944940 defendant Nuse Thomas yeoman 586312 586312 Nuse, Thomas, of Walden, yeoman 0
3760730 1945356 1945356 plaintiff Deryk William draper 586312 586312 Deryk, William, of Walden, draper 0
3760731 1945356 1945356 defendant Whyte Thomas tailor 586312 586312 Whyte, Thomas, of Walden, tailor 0
3766319 1947119 1947119 defendant Bende Thomas mercer 586312 586312 (Bende, Thomas, of Walden, mercer 1
3767486 1947468 1947468 defendant Rychard Thomas husbandman 586312 586312 Rychard, Thomas, of Walden, husbandman 1
3767683 1947529 1947529 defendant Mayer John smith 586312 586312 Mayer, John, of Walden, smith 0
3767684 1947529 1947529 defendant Adam William (legal representative) 586312 586312 Adam, William, of Walden, mercer, executors of 1
3769487 1948118 1948118 defendant Adam Thomas husbandman 586312 586312 Adam, Thomas, of Walden, husbandman 0
3772505 1949093 1949093 defendant Webbe Thomas husbandman 586312 586312 Webbe, Thomas, of Walden, husbandman 0
3772970 1949247 1949247 defendant James Thomas butcher 586312 586312 James, Thomas, of Walden, butcher 0
3773963 1949572 1949572 defendant Rycard Thomas husbandman 586312 586312 Rycard, Thomas, of Walden, husbandman 3
3774474 1949743 1949743 defendant Spruse John tailor 586312 586312 Spruse, John, of Walden, tailor 0
3774619 1949789 1949789 defendant Joyse Robert barber 586312 586312 Joyse, Robert, of Walden, barber 0
3776720 1950465 1950465 defendant Smyth Thomas yeoman 586312 586312 Smyth, Thomas, of Walden, yeoman 0
3776721 1950465 1950465 defendant Smyth Nicholas yeoman 586312 586312 Smyth, Nicholas, of Walden, yeoman 1
3776722 1950465 1950465 defendant Reder Thomas yeoman 586312 586312 Reder, Thomas, of Walden, yeoman 2
3779612 1951353 1951353 defendant Evys Thomas shoemaker 586312 586312 Evys, Thomas, of Walden, shoemaker 0
3784862 1953058 1953058 defendant Vawdy James yeoman 586312 586312 Vawdy, James, of Walden, yeoman 1
3790989 1955019 1955019 plaintiff Williamson James yeoman 586312 586312 Williamson, James, of Walden, yeoman 0
3793827 1955934 1955934 defendant Smyth Nicholas yeoman 586312 586312 Smyth, Nicholas, of Walden, yeoman 1
3793828 1955935 1955935 plaintiff Bryde Thomas mercer 586312 586312 Bryde, Thomas, of Walden, mercer 0
3795381 1956426 1956426 defendant Gryswell Richard haberdasher 586312 586312 Gryswell, Richard, of Walden, haberdasher 0
3796389 1956737 1956737 defendant Vawdy James gent 586312 586312 Vawdy, James, of Walden, gent 0
3796609 1956814 1956814 defendant Hogyn Thomas shoemaker 586312 586312 Hogyn, Thomas, of Walden, shoemaker 0
3798483 1957427 1957427 defendant Balle John glover 586312 586312 Balle, John, of Walden, glover 0
3798484 1957427 1957427 defendant Reddelond John butcher 586312 586312 Reddelond, John, of Walden, butcher 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);