names

79 rows where place_id = 598043

✎ 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
3630874 1904476 1904476 plaintiff Fowey Thomas   598043 598043 Fowey, Thomas, of Cerne 0
3642740 1908177 1908177 plaintiff Clavell William gent 598043 598043 Clavell, William, of Cerne, gent 0
3694928 1924623 1924623 defendant Benet Thomas baker 598043 598043 Benet, Thomas, of Cerne, baker 0
3744618 1940212 1940212 defendant Benett Thomas husbandman 598043 598043 Benett, Thomas, of Cerne, husbandman 1
3752065 1942568 1942568 defendant Fowye Thomas (legal representative) 598043 598043 Fowye, Thomas, of Cerne, draper, executors of 1
3752066 1942568 1942568 defendant Fowey John draper 598043 598043 (Fowey, John, of Cerne, draper 2
3764398 1946526 1946526 defendant Foway John yeoman 598043 598043 Foway, John, of Cerne, yeoman 2
3811741 1961570 1961570 plaintiff Clavyle William gent 598043 598043 Clavyle, William, of Cerne, gent 0
3811742 1961570 1961570 defendant Fowey John yeoman 598043 598043 Fowey, John, of Cerne, yeoman 0
3837028 1969494 1969494 defendant Sampford Nicholas yeoman 598043 598043 Sampford, Nicholas, of Cerne, yeoman 0
3839981 1970433 1970433 defendant Alambrygge Thomas merchant 598043 598043 Alambrygge, Thomas, of Cerne, merchant 0
3880005 1983573 1983573 defendant Belle John husbandman 598043 598043 Belle, John, of Cerne, husbandman 0
3940738 2003908 2003908 defendant Skynner Edward yeoman 598043 598043 Skynner, Edward, of Cerne, yeoman 0
3940739 2003908 2003908 defendant Capon James   598043 598043 Capon, James, of Cerne, surgeon 1
3962825 2011589 2011589 plaintiff Williams Henry esq 598043 598043 Williams, Henry, of Cerne, esq 0
4007253 2027373 2027373 defendant Styckland John chapman 598043 598043 Styckland, John, of Cerne, chapman 1
4011059 2028729 2028729 defendant Styckland John chapman 598043 598043 Styckland, John, of Cerne, chapman 2
4017441 2030944 2030944 defendant Smarte John clerk 598043 598043 Smarte, John, of Cerne, clerk 0
4020631 2032107 2032107 defendant Sampforde Richard yeoman 598043 598043 Sampforde, Richard, of Cerne, yeoman 0
4026733 2034207 2034207 defendant Wasinge John yeoman 598043 598043 Wasinge, John, of Cerne, yeoman 0
4026734 2034207 2034207 defendant Dane Francis yeoman 598043 598043 Dane, Francis, of Cerne, yeoman 1
4029481 2035179 2035179 defendant Welman Simon butcher 598043 598043 Welman, Simon, of Cerne, butcher 0
4032634 2036322 2036322 defendant Welman Simon butcher 598043 598043 Welman, Simon, of Cerne, butcher 0
4032635 2036322 2036322 defendant Welman Hugh butcher 598043 598043 Welman, Hugh, of Cerne, butcher 1
4035050 2037219 2037219 defendant Kegill alias Gill John yeoman 598043 598043 Kegill alias Gill, John, of Cerne, yeoman 1
4041980 2039620 2039620 plaintiff Osborne Blase weaver 598043 598043 Osborne, Blase, of Cerne, weaver 0
4051619 2042999 2042999 defendant Sampford Richard yeoman 598043 598043 Sampford, Richard, of Cerne, yeoman 0
4138357 2074082 2074082 defendant Hayles William   598043 598043 Hayles, William, of Cerne Abbas, taylor 0
4207245 2098082 2098082 defendant Major William yeoman 598043 598043 Major, William, of Cerne, yeoman 0
4207246 2098082 2098082 defendant Stycklond John yeoman 598043 598043 Stycklond, John, of Cerne, yeoman 1
4238553 2109098 2109098 defendant Rykes John husbandman 598043 598043 Rykes, John, of Cerne, husbandman 1
4305703 2132131 2132131 defendant West Humphrey plumber 598043 598043 West, Humphrey, of Cerne, plumber 2
4371623 2154905 2154905 defendant Stownte Michael husbandman 598043 598043 Stownte, Michael, of Cerne, husbandman 1
4458723 2187774 2187774 plaintiff Rempel John   598043 598043 Rempel, John, of Cerne 0
4476405 2193285 2193285 defendant Mey John   598043 598043 Mey, John, of Cerne 4
4476671 2193363 2193363 defendant Metford John, senior   598043 598043 Metford, John, senior, of Cerne 5
4489069 2197301 2197301 plaintiff Tannere Richard   598043 598043 Tannere, Richard, of Cerne 0
4506199 2202445 2202445 defendant Smyth Nicholas   598043 598043 Smyth, Nicholas, of Cerne 4
4506206 2202446 2202446 defendant Illary Ralph   598043 598043 Illary, Ralph, of Cerne 2
4514999 2205098 2205098 defendant Houper William   598043 598043 Houper, William, of Cerne 0
4536040 2211551 2211551 defendant Symmesborgh John   598043 598043 Symmesborgh, John, of Cerne 3
4541210 2213148 2213148 defendant Bakere John   598043 598043 Bakere, John, of Cerne 1
4547994 2215305 2215305 defendant Clerk Henry   598043 598043 Clerk, Henry, of Cerne 0
4550109 2215974 2215974 defendant Baret John   598043 598043 Baret, John, of Cerne 0
4565187 2220685 2220685 defendant Roper Wioliam   598043 598043 Roper, Wioliam, of Cerne 0
4565895 2220890 2220890 defendant Symmesburgh John   598043 598043 Symmesburgh, John, of Cerne 1
4579554 2225089 2225089 plaintiff Couk Roger   598043 598043 Couk, Roger, of Cerne 0
4595905 2229975 2229975 defendant Trent John   598043 598043 Trent, John, of Cerne 1
4612320 2234921 2234921 defendant Ropere William   598043 598043 Ropere, William, of Cerne 0
4623404 2238293 2238293 defendant Wareyn John   598043 598043 Wareyn, John, of Cerne 1
4656894 2248052 2248052 defendant Trent John   598043 598043 Trent, John, of Cerne 8
4666065 2250854 2250854 defendant Dragge Robert yeoman 598043 598043 Dragge, Robert, of Cerne, yeoman 6
4671569 2256753 2256753 defendant Batecombe alias Clerk John yeoman 598043 598043 Batecombe alias Clerk, John, of Cerne, yeoman 0
4721581 2272080 2272080 defendant Martyn Edmund gent 598043 598043 Martyn, Edmund, of Cerne, gent 1
4742552 2278322 2278322 defendant Tomelyn Julia   598043 598043 Tomelyn, Julia, of Cerne, widow, formerly wife of John Tomelyn 4
4763313 2284512 2284512 defendant Mendylond John chapman 598043 598043 Mendylond, John, of Cerne Abbot, chapman 0
4773166 2287576 2287576 defendant Brit John husbandman 598043 598043 Brit, John, of Cerne Abbot, husbandman 0
4794978 2294571 2294571 defendant Dudman Walter yeoman 598043 598043 Dudman, Walter, of Cerne, yeoman 1
4794981 2294572 2294572 defendant Dudman Walter yeoman 598043 598043 Dudman, Walter, of Cerne, yeoman 0
4799562 2296044 2296044 defendant Bouler John   598043 598043 Bouler, John, of Cerne, servant 0
4826963 2304473 2304473 plaintiff Winterborne John   598043 598043 Winterborne, John, of Cerne, abbot 0
4826964 2304473 2304473 defendant Newelond Henry husbandman 598043 598043 Newelond, Henry, of Cerne, husbandman 0
4832837 2306293 2306293 defendant Newelond Henry husbandman 598043 598043 Newelond, Henry, of Cerne, husbandman 0
4881208 2321026 2321026 defendant Newelond Henry husbandman 598043 598043 Newelond, Henry, of Cerne, husbandman 0
4917874 2332102 2332102 plaintiff Godmanston John   598043 598043 Godmanston, John, of Cerne, abbot 0
4917875 2332102 2332102 defendant Goldryn John husbandman 598043 598043 Goldryn, John, of Cerne, husbandman 0
4922504 2333454 2333454 defendant Smyth William yeoman 598043 598043 Smyth, William, of Cerne, yeoman 0
5061277 2374958 2374958 defendant Porter Robert husbandman 598043 598043 Porter, Robert, of Cerne, husbandman 0
5141442 2398612 2398612 plaintiff Vanne John   598043 598043 Vanne, John, of Cerne, abbot 0
5141444 2398613 2398613 plaintiff Vanne John   598043 598043 Vanne, John, of Cerne, abbot 0
5243685 2428345 2428345 defendant Londe Thomas husbandman 598043 598043 Londe, Thomas, of Cerne Abbot, husbandman 4
5299770 2444902 2444902 defendant Thorne Thomas yeoman 598043 598043 Thorne, Thomas, of Cerne, yeoman 1
5301517 2445408 2445408 plaintiff Davy Thomas   598043 598043 Davy, Thomas, of Cerne 8
5532509 2514711 2514711 defendant Fowey Thomas draper 598043 598043 Fowey, Thomas, of Cerne, draper 0
5533192 2514932 2514932 plaintiff Webys Richard   598043 598043 Webys, Richard, of Cerne, mason 0
5534820 2515430 2515430 defendant Fowey Thomas merchant 598043 598043 Fowey, Thomas, of Cerne, merchant 0
5567192 2524983 2524983 defendant Dussell Robert mercer 598043 598043 Dussell, Robert, of Cerne, mercer 0
5598863 2534521 2534521 plaintiff Fowey Thomas merchant 598043 598043 Fowey, Thomas, of Cerne, merchant 0
5621648 2550673 2550673 defendant Deyghere John   598043 598043 Deyghere, John, of Cerne 0

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