names

89 rows where place_id = 601686

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646507 1909306 1909306 defendant Arnold Thomas butcher 601686 601686 Arnold, Thomas, of Carleton Colvyle, butcher 1
3656938 1912427 1912427 defendant Aldryche Robert husbandman 601686 601686 Aldryche, Robert, of Carleton Colvyle, husbandman 1
3679318 1919592 1919592 defendant Aldryche Robert, senior tailor 601686 601686 Aldryche, Robert, senior, of Carleton Colvyle, tailor 2
3693052 1924034 1924034 defendant Downyng John mercer 601686 601686 Downyng, John, of Carleton Colvyle, mercer 0
3699824 1926169 1926169 defendant Downyng John draper 601686 601686 Downyng, John, of Carleton Colvyle, draper 0
3699826 1926170 1926170 defendant Downyng John draper 601686 601686 Downyng, John, of Carleton Colvyle, draper 0
3705957 1928151 1928151 defendant Kegell John husbandman 601686 601686 Kegell, John, of Carleton Colvyle, husbandman 0
3713310 1930474 1930474 defendant Downyng John mercer 601686 601686 Downyng, John, of Carleton Colvyle, mercer 0
3718398 1932034 1932034 defendant Aldryche Robert husbandman 601686 601686 Aldryche, Robert, of Carleton Colvyle, husbandman 1
3720774 1932787 1932787 defendant Andrews Robert husbandman 601686 601686 Andrews, Robert, of Carleton Colvyle, husbandman 0
3720777 1932788 1932788 defendant Downyng John mercer 601686 601686 Downyng, John, of Carleton Colvyle, mercer 1
3720876 1932825 1932825 defendant Downyng John mercer 601686 601686 Downyng, John, of Carleton Colvyle, mercer 0
3734161 1936924 1936924 defendant Aldryche Robert husbandman 601686 601686 Aldryche, Robert, of Carleton Colvyle, husbandman 1
3739002 1938404 1938404 defendant Downyng John mercer 601686 601686 Downyng, John, of Carleton Colvyle, mercer 1
3739004 1938404 1938404 defendant Sellyng Richard yeoman 601686 601686 Sellyng, Richard, of Carleton Colvyle, yeoman 3
3739628 1938609 1938609 defendant Hatclyf Nicholas husbandman 601686 601686 Hatclyf, Nicholas, of Carleton Colvyle, husbandman 0
3745399 1940468 1940468 defendant Cowper Robert carpenter 601686 601686 Cowper, Robert, of Carleton Colvyle, carpenter 0
3752550 1942724 1942724 defendant Carman John husbandman 601686 601686 Carman, John, of Carleton Colvyle, husbandman 2
3758124 1944527 1944527 defendant Cowper Robert carpenter 601686 601686 Cowper, Robert, of Carleton Colvyle, carpenter 0
3770248 1948363 1948363 defendant Harrold John husbandman 601686 601686 Harrold, John, of Carleton Colvyle, husbandman 2
3774029 1949592 1949592 defendant Craske George husbandman 601686 601686 Craske, George, of Carleton Colvyle, husbandman 0
3778858 1951102 1951102 defendant Craske George husbandman 601686 601686 Craske, George, of Carleton Colvyle, husbandman 0
3783518 1952598 1952598 defendant Fyske John husbandman 601686 601686 Fyske, John, of Carleton Colvyle, husbandman 0
3798231 1957344 1957344 defendant Cowper John   601686 601686 Cowper, John, of Carleton Colvyle, mill wright 1
3833517 1968414 1968414 defendant Bettys William carpenter 601686 601686 Bettys, William, of Carleton Colvyle, carpenter 0
3866325 1978970 1978970 defendant Burnham John clerk 601686 601686 Burnham, John, of Carleton Colvyle, clerk 0
3870598 1980407 1980407 defendant Cowper John carpenter 601686 601686 Cowper, John, of Carleton Colvyle, carpenter 0
3872481 1981021 1981021 defendant Burneham John clerk 601686 601686 Burneham, John, of Carleton Colvyle, clerk 0
3872486 1981023 1981023 defendant Burneham John clerk 601686 601686 Burneham, John, of Carleton Colvyle, clerk 0
3884522 1985096 1985096 defendant Carman Robert husbandman 601686 601686 Carman, Robert, of Carleton Colvyle, husbandman 1
3909993 1993649 1993649 defendant Carman Robert husbandman 601686 601686 (Carman, Robert, of Carleton Colvyle, husbandman 2
3909994 1993649 1993649 defendant Coker Joan widow 601686 601686 Coker, Joan, of Carleton Colvyle, widow 3
3920126 1997066 1997066 defendant Thompson Richard yeoman 601686 601686 Thompson, Richard, of Carleton Colvyle, yeoman 0
3920923 1997344 1997344 defendant Andrewys Robert husbandman 601686 601686 Andrewys, Robert, of Carleton Colvyle, husbandman 0
3927320 1999478 1999478 defendant Tompson Richard yeoman 601686 601686 Tompson, Richard, of Carleton Colvyle, yeoman 0
3930223 2000457 2000457 defendant Mabbys Robert husbandman 601686 601686 Mabbys, Robert, of Carleton Colvyle, husbandman 2
3931635 2000876 2000876 defendant Plowman John husbandman 601686 601686 Plowman, John, of Carleton Colvyle, husbandman 0
3932061 2001026 2001026 defendant Porter Robert husbandman 601686 601686 Porter, Robert, of Carleton Colvyle, husbandman 0
3936437 2002508 2002508 defendant Mabbys Alice   601686 601686 (Mabbys, Alice, of Carleton Colvyle, widow, formerly wife of Testator 1
3936442 2002509 2002509 defendant Andrewes Robert yeoman 601686 601686 Andrewes, Robert, of Carleton Colvyle, yeoman 0
3939855 2003630 2003630 defendant Ploughtman John yeoman 601686 601686 Ploughtman, John, of Carleton Colvyle, yeoman 0
3940185 2003735 2003735 defendant Andrews Robert yeoman 601686 601686 Andrews, Robert, of Carleton Colvyle, yeoman 0
3940189 2003736 2003736 defendant Tompson Richard yeoman 601686 601686 Tompson, Richard, of Carleton Colvyle, yeoman 0
3941146 2004041 2004041 defendant Thompson Richard yeoman 601686 601686 Thompson, Richard, of Carleton Colvyle, yeoman 0
3941148 2004042 2004042 defendant Tomson Richard yeoman 601686 601686 Tomson, Richard, of Carleton Colvyle, yeoman 0
3957962 2009848 2009848 defendant Plowman John yeoman 601686 601686 Plowman, John, of Carleton Colvyle, yeoman 2
3959132 2010280 2010280 plaintiff Sellyn Richard yeoman 601686 601686 Sellyn, Richard, of Carleton Colvyle, yeoman 0
3966684 2012984 2012984 defendant West Theodor husbandman 601686 601686 West, Theodor, of Carleton Colvyle, husbandman 0
3966685 2012984 2012984 defendant Carter Thomas husbandman 601686 601686 Carter, Thomas, of Carleton Colvyle, husbandman 1
3966686 2012984 2012984 defendant Mabbes Robert husbandman 601686 601686 together with Mabbes, Robert, of Carleton Colvyle, husbandman 2
3966687 2012984 2012984 defendant Meryman John husbandman 601686 601686 Meryman, John, of Carleton Colvyle, husbandman 3
3966688 2012984 2012984 defendant Carter William husbandman 601686 601686 Carter, William, of Carleton Colvyle, husbandman 4
3966689 2012984 2012984 defendant Sellyng Richard husbandman 601686 601686 Sellyng, Richard, of Carleton Colvyle, husbandman 5
3975482 2015991 2015991 defendant Carman Vincent yeoman 601686 601686 Carman, Vincent, of Carleton Colvyle, yeoman 0
4038002 2038238 2038238 defendant Hullocke Ambrose husbandman 601686 601686 Hullocke, Ambrose, of Carleton Colvyle, husbandman 1
4063671 2047299 2047299 plaintiff Gooche Richard (legal representative) 601686 601686 Gooche, Richard, of Carleton Colvyle, yeoman, executors of 0
4071534 2050112 2050112 defendant Durram Margery widow 601686 601686 Durram, Margery, of Carleton Colvyle, widow 3
4133534 2072323 2072323 defendant Stone Robert husbandman 601686 601686 Stone, Robert, of Carleton Colvyle, husbandman 1
4136212 2073296 2073296 defendant Ryche Thomas yeoman 601686 601686 Ryche, Thomas, of Carleton Colvyle, yeoman 3
4181484 2089002 2089002 defendant Stone Robert husbandman 601686 601686 Stone, Robert, of Carleton Colvyle, husbandman 1
4245766 2111561 2111561 defendant Deacon William husbandman 601686 601686 Deacon, William, of Carleton Colvyle, husbandman 0
4391211 2161678 2161678 defendant Martyn Thomas husbandman 601686 601686 Martyn, Thomas, of Carleton Colvyle, husbandman 0
4397835 2163854 2163854 defendant Smyth Thomas blacksmith 601686 601686 Smyth, Thomas, of Carleton Colvyle, blacksmith 0
4454685 2186476 2186476 defendant Day Alan   601686 601686 Day, Alan, of Carleton Colvyle 26
4497218 2199782 2199782 plaintiff Denyell John, senior   601686 601686 Denyell, John, senior, of Carleton Colvyle, on his own account 0
4497222 2199783 2199783 defendant Oldyng Simon   601686 601686 Oldyng, Simon, of Carleton Colvyle 0
4528063 2209061 2209061 plaintiff Maghald Thomas   601686 601686 Maghald, Thomas, of Carleton Colvyle 0
4528066 2209061 2209061 defendant Stubbere Waren   601686 601686 Stubbere, Waren, of Carleton Colvyle 2
4664950 2250519 2250519 defendant de Geddyng Thomas husbandman 601686 601686 de Geddyng, Thomas, of Carleton Colvyle, husbandman 1
4731325 2274997 2274997 defendant Reve Robert yeoman 601686 601686 Reve, Robert, of Carleton Colvyle, yeoman 3
4962401 2345659 2345659 defendant Skyn or Skynner Robert husbandman 601686 601686 Skyn or Skynner, Robert, of Carleton Colvyle, husbandman 0
5051078 2371930 2371930 defendant Dolfyn Adam husbandman 601686 601686 Dolfyn, Adam, of Carleton Colvyle, husbandman 2
5163910 2405182 2405182 defendant Henle Nicholas clerk 601686 601686 Henle, Nicholas, of Carleton Colvyle, clerk 0
5296130 2443859 2443859 defendant Andrewe Robert husbandman 601686 601686 Andrewe, Robert, of Carleton Colvyle, husbandman 0
5349921 2460106 2460106 defendant Oldryng John husbandman 601686 601686 Oldryng, John, of Carleton Colvyle, husbandman 0
5349923 2460106 2460106 defendant Cuttyng Robert husbandman 601686 601686 Cuttyng, Robert, of Carleton Colvyle, husbandman 2
5349953 2460115 2460115 defendant Craske Henry husbandman 601686 601686 Craske, Henry, of Carleton Colvyle, husbandman 0
5349954 2460115 2460115 defendant Craske Thomas husbandman 601686 601686 Craske, Thomas, of Carleton Colvyle, husbandman 1
5380741 2469543 2469543 defendant Cuttyng Robert husbandman 601686 601686 Cuttyng, Robert, of Carleton Colvyle, husbandman 2
5398042 2474507 2474507 defendant Olderyng John husbandman 601686 601686 Olderyng, John, of Carleton Colvyle, husbandman 0
5398044 2474507 2474507 defendant Cuttyng Robert husbandman 601686 601686 Cuttyng, Robert, of Carleton Colvyle, husbandman 2
5398046 2474508 2474508 defendant Oldryng John husbandman 601686 601686 Oldryng, John, of Carleton Colvyle, husbandman 0
5398048 2474508 2474508 defendant Cuttyng Robert husbandman 601686 601686 Cuttyng, Robert, of Carleton Colvyle, husbandman 2
5537127 2516096 2516096 defendant Dolfyn Nicholas husbandman 601686 601686 Dolfyn, Nicholas, of Carleton Colvyle, husbandman 1
5537128 2516096 2516096 defendant Dolfyn Robert, senior husbandman 601686 601686 Dolfyn, Robert, senior, of Carleton Colvyle, husbandman 2
5573596 2526843 2526843 defendant Elyngham William husbandman 601686 601686 Elyngham, William, of Carleton Colvyle, husbandman 0
5588267 2531333 2531333 defendant Flete John husbandman 601686 601686 Flete, John, of Carleton Colvyle, husbandman 1
5598274 2534349 2534349 defendant Colman Richard clerk 601686 601686 Colman, Richard, of Carleton Colvyle, clerk 0
5598275 2534349 2534349 defendant Colman John laborer 601686 601686 Colman, John, of Carleton Colvyle, laborer 1

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);