names

169 rows where place_id = 586809

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589696 1864415 1864415 defendant Drapere John chapman 586809 586809 Drapere, John, of Wellys, Soms, chapman 1
3591325 1864913 1864913 defendant Colum John mercer 586809 586809 Colum, John, of Wellys, Soms, mercer 0
3592598 1865302 1865302 defendant Draper John chapman 586809 586809 Draper, John, of Wellys, Soms, chapman 0
3592603 1865303 1865303 defendant Draper John chapman 586809 586809 Draper, John, of Wellys, Soms, chapman 0
3600092 1867679 1867679 defendant Agranntoft John brasier 586809 586809 Agranntoft, John, of Wellys, Soms, brasier 1
3606916 1869827 1869827 defendant Prys John yeoman 586809 586809 Prys, John, of Wellys, Soms, yeoman 0
3619541 1873679 1873679 defendant Walbeef William brasier 586809 586809 Walbeef, William, of Wellys, Soms, brasier 0
3619694 1873730 1873730 defendant Hunt John clothman 586809 586809 Hunt, John, of Wellys, Soms, clothman 0
3619698 1873731 1873731 defendant Hunt John clothman 586809 586809 Hunt, John, of Wellys, Soms, clothman 0
3625836 1875615 1875615 defendant Draper John (legal representative) 586809 586809 Draper, John, of Wellys, Soms, chapman, executrix of 0
3625840 1875616 1875616 defendant Draper John (legal representative) 586809 586809 Draper, John, of Wellys, Soms, chapman, executrix of 0
3643929 1908532 1908532 defendant Dytte William chapman 586809 586809 Dytte, William, of Wellys, Soms, chapman 2
3643933 1908533 1908533 defendant Dytte William chapman 586809 586809 Dytte, William, of Wellys, Soms, chapman 1
3643948 1908537 1908537 defendant Dytte William mercer 586809 586809 Dytte, William, of Wellys, Soms, mercer 2
3643953 1908538 1908538 defendant Dytte William mercer 586809 586809 Dytte, William, of Wellys, Soms, mercer 2
3648786 1910010 1910010 defendant Dytte William clothman 586809 586809 Dytte, William, of Wellys, Soms, clothman 1
3656923 1912422 1912422 defendant Sargeant Walter chapman 586809 586809 Sargeant, Walter, of Wellys, Soms, chapman 0
3662218 1914100 1914100 defendant Hakelet Thomas clerk 586809 586809 Hakelet, Thomas, of Wellys, Soms, clerk 1
3664988 1914993 1914993 defendant Vowell William gent 586809 586809 Vowell, William, of Wellys, Soms, gent 1
3669400 1916368 1916368 defendant Abell George capper 586809 586809 Abell, George, of Wellys, Soms, capper 0
3685235 1921535 1921535 defendant Wyllys Nicholas innholder 586809 586809 Wyllys, Nicholas, of Wellys, Soms, innholder 0
3689111 1922756 1922756 defendant Brawder William brasier 586809 586809 Brawder, William, of Wellys, Soms, brasier 2
3689910 1923003 1923003 defendant Deverell John yoman 586809 586809 Deverell, John, of Wellys, Soms, yoman 1
3694082 1924353 1924353 defendant Hoper Robert chapman 586809 586809 Hoper, Robert, of Wellys, Soms, chapman 3
3696693 1925191 1925191 defendant Cornyshe Thomas baker 586809 586809 Cornyshe, Thomas, of Wellys, Soms, baker 0
3696696 1925192 1925192 defendant Campe John plumber 586809 586809 Campe, John, of Wellys, Soms, plumber 0
3700216 1926301 1926301 defendant Hooper Robert draper 586809 586809 Hooper, Robert, of Wellys, Soms, draper 0
3703667 1927427 1927427 defendant Detty William chapman 586809 586809 Detty, William, of Wellys, Soms, chapman 3
3705445 1927992 1927992 defendant Sarger Walter merchant 586809 586809 Sarger, Walter, of Wellys, Soms, merchant 0
3712638 1930269 1930269 defendant Bythemore Thomas gent 586809 586809 Bythemore, Thomas, of Wellys, Soms, gent 0
3713009 1930392 1930392 defendant Jonys John yeoman 586809 586809 Jonys, John, of Wellys, Soms, yeoman 0
3713322 1930479 1930479 defendant Pawlett Richard merchant 586809 586809 Pawlett, Richard, of Wellys, Soms, merchant 0
3716116 1931328 1931328 defendant Whyte Patrick gent 586809 586809 Whyte, Patrick, of Wellys, Soms, gent 0
3727435 1934854 1934854 defendant Hoper Robert draper 586809 586809 Hoper, Robert, of Wellys, Soms, draper 0
3729399 1935442 1935442 defendant Foxse John clothmaker 586809 586809 Foxse, John, of Wellys, Soms, clothmaker 2
3740344 1938842 1938842 defendant Goldwege John chapman 586809 586809 Goldwege, John, of Wellys, Soms, chapman 0
3746005 1940657 1940657 defendant Lyne John baker 586809 586809 Lyne, John, of Wellys, Soms, baker 0
3755433 1943652 1943652 defendant Deverell John yeoman 586809 586809 (Deverell, John, of Wellys, Soms, yeoman 2
3757818 1944421 1944421 defendant Rogers Thomas clerk 586809 586809 Rogers, Thomas, of Wellys, Soms, clerk 5
3773217 1949332 1949332 defendant Gane William (legal representative) 586809 586809 Gane, William, of Wellys, Soms, husbandman, executors of 0
3777612 1950749 1950749 defendant Sergar Walter chapman 586809 586809 Sergar, Walter, of Wellys, Soms, chapman 2
3784568 1952962 1952962 plaintiff Medley Thomas yeoman 586809 586809 Medley, Thomas, of Wellys, Soms, yeoman 0
3792357 1955469 1955469 defendant Fox John clothmaker 586809 586809 Fox, John, of Wellys, Soms, clothmaker 4
3797445 1957088 1957088 defendant Ledeatt alias Browdear William brasier 586809 586809 Ledeatt alias Browdear, William, of Wellys, Soms, brasier 0
3801091 1958259 1958259 plaintiff Medley Thomas yeoman 586809 586809 Medley, Thomas, of Wellys, Soms, yeoman 0
3813958 1962276 1962276 defendant Adams Thomas yeoman 586809 586809 Adams, Thomas, of Wellys, Soms, yeoman 0
3819934 1964116 1964116 defendant Bray Robert mercer 586809 586809 Bray, Robert, of Wellys, Soms, mercer 0
3836636 1969363 1969363 defendant Powell Richard mercer 586809 586809 Powell, Richard, of Wellys, Soms, mercer 0
3839109 1970154 1970154 defendant Bell William gent 586809 586809 Bell, William, of Wellys, Soms, gent 1
3843511 1971507 1971507 defendant Goodman John clerk 586809 586809 Goodman, John, of Wellys, Soms, clerk 0
3870659 1980429 1980429 defendant Kenard Richard pewterer 586809 586809 Kenard, Richard, of Wellys, Soms, pewterer 0
3873565 1981380 1981380 defendant Bowe Thomas yeoman 586809 586809 Bowe, Thomas, of Wellys, Soms, yeoman 0
3878901 1983195 1983195 defendant Godwyn John chapman 586809 586809 Godwyn, John, of Wellys, Soms, chapman 1
3918835 1996622 1996622 defendant Bracheley Thomas yeoman 586809 586809 Bracheley, Thomas, of Wellys, Soms, yeoman 3
3918842 1996623 1996623 defendant Bracheley Thomas yeoman 586809 586809 Bracheley, Thomas, of Wellys, Soms, yeoman 3
4659819 2248922 2248922 defendant Lambroke William clerk 586809 586809 Lambroke, William, of Wellys, Soms, clerk 0
4723961 2272793 2272793 defendant Chisulden Robert gent 586809 586809 (Chisulden, Robert, of Wellys, Soms, gent 1
4726704 2273622 2273622 defendant Gybbys Henry dyer 586809 586809 Gybbys, Henry, of Wellys, Soms, dyer 1
4753712 2281534 2281534 defendant Polglas Robert chapman 586809 586809 Polglas, Robert, of Wellys, Soms, chapman 0
4753739 2281544 2281544 defendant Polglas Robert chapman 586809 586809 Polglas, Robert, of Wellys, Soms, chapman 0
4782243 2290446 2290446 defendant Burgh Robert clerk 586809 586809 (Burgh, Robert, of Wellys, Soms, clerk 1
4791897 2293567 2293567 defendant Settour Richard jeweler 586809 586809 Settour, Richard, of Wellys, Soms, jeweler 0
4821725 2302868 2302868 defendant Bubbewyth Thomas clerk 586809 586809 Bubbewyth, Thomas, of Wellys, Soms, clerk 0
4869946 2317575 2317575 defendant Bubwyth Thomas clerk 586809 586809 Bubwyth, Thomas, of Wellys, Soms, clerk 0
4870465 2317734 2317734 defendant Bubwith Thomas clerk 586809 586809 Bubwith, Thomas, of Wellys, Soms, clerk 0
4872566 2318376 2318376 defendant Port alias Perys William tanner 586809 586809 Port alias Perys, William, of Wellys, Soms, tanner 1
4872570 2318377 2318377 defendant Port alias Perys William tanner 586809 586809 Port alias Perys, William, of Wellys, Soms, tanner 1
4893239 2324596 2324596 defendant Polglase Sarah widow 586809 586809 Polglase, Sarah, of Wellys, Soms, widow 8
4895671 2325320 2325320 defendant Dulverton Walter merchant 586809 586809 Dulverton, Walter, of Wellys, Soms, merchant 0
4900930 2326919 2326919 defendant Machon Robert brasier 586809 586809 Machon, Robert, of Wellys, Soms, brasier 4
4901869 2327193 2327193 defendant Calton Nicholas clerk 586809 586809 Calton, Nicholas, of Wellys, Soms, clerk 0
4901871 2327194 2327194 defendant Calton Nicholas clerk 586809 586809 Calton, Nicholas, of Wellys, Soms, clerk 0
4908805 2329305 2329305 defendant Selwode Henry chapman 586809 586809 Selwode, Henry, of Wellys, Soms, chapman 0
4911845 2330207 2330207 defendant Merston Stephen weaver 586809 586809 Merston, Stephen, of Wellys, Soms, weaver 0
4911847 2330208 2330208 defendant Merston Stephen weaver 586809 586809 Merston, Stephen, of Wellys, Soms, weaver 0
4931530 2336243 2336243 defendant Selwode Henry   586809 586809 Selwode, Henry, of Wellys, Soms 2
4946740 2340981 2340981 defendant Billyng John tucker 586809 586809 Billyng, John, of Wellys, Soms, tucker 4
4950352 2342075 2342075 defendant Wyche John clothmaker 586809 586809 Wyche, John, of Wellys, Soms, clothmaker 2
4955704 2343672 2343672 defendant Kelverton Walter yeoman 586809 586809 Kelverton, Walter, of Wellys, Soms, yeoman 3
4963640 2346038 2346038 defendant Poule John tucker 586809 586809 Poule, John, of Wellys, Soms, tucker 2
4963799 2346085 2346085 defendant Halle Thomas gent 586809 586809 Halle, Thomas, of Wellys, Soms, gent 1
4971376 2348367 2348367 defendant Fuge Edward ostler 586809 586809 Fuge, Edward, of Wellys, Soms, ostler 0
4995241 2355425 2355425 defendant Lane John clerk 586809 586809 Lane, John, of Wellys, Soms, clerk 0
5000785 2357106 2357106 defendant Wyche John merchant 586809 586809 Wyche, John, of Wellys, Soms, merchant 0
5003108 2357813 2357813 defendant Hedley John gent 586809 586809 Hedley, John, of Wellys, Soms, gent 0
5003433 2357901 2357901 defendant Panter Edward ostler 586809 586809 Panter, Edward, of Wellys, Soms, ostler 0
5003855 2358019 2358019 defendant Panter Edward ostler 586809 586809 Panter, Edward, of Wellys, Soms, ostler 0
5014208 2361005 2361005 defendant Pederton John gent 586809 586809 Pederton, John, of Wellys, Soms, gent 0
5023092 2363662 2363662 defendant Wansford John clerk 586809 586809 Wansford, John, of Wellys, Soms, clerk 0
5029736 2365569 2365569 defendant Seyntclere Henry chapman 586809 586809 Seyntclere, Henry, of Wellys, Soms, chapman 0
5032336 2366336 2366336 defendant Bubwyth Thomas   586809 586809 Bubwyth, Thomas, of Wellys, Soms 0
5032338 2366337 2366337 defendant Bulwyth Thomas clerk 586809 586809 Bulwyth, Thomas, of Wellys, Soms, clerk 0
5033659 2366725 2366725 defendant Selwode Henry merchant 586809 586809 Selwode, Henry, of Wellys, Soms, merchant 0
5037035 2367702 2367702 defendant Clerke William carpenter 586809 586809 Clerke, William, of Wellys, Soms, carpenter 1
5037047 2367706 2367706 defendant Petyrton John clerk 586809 586809 (Petyrton, John, of Wellys, Soms, clerk 1
5037052 2367707 2367707 defendant Petyrton John clerk 586809 586809 (Petyrton, John, of Wellys, Soms, clerk 1
5045506 2370284 2370284 defendant Morgon John chapman 586809 586809 Morgon, John, of Wellys, Soms, chapman 0
5047579 2370895 2370895 defendant Langford Thomas goldsmith 586809 586809 Langford, Thomas, of Wellys, Soms, goldsmith 1
5083592 2381596 2381596 defendant Tesdale Richard chapman 586809 586809 Tesdale, Richard, of Wellys, Soms, chapman 0
5118135 2391738 2391738 defendant Skypper John mercer 586809 586809 Skypper, John, of Wellys, Soms, mercer 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);