names

249 rows where place_id = 599338

✎ 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
3636339 1906158 1906158 defendant Clerk John tailor 599338 599338 Clerk, John, of Bruton, tailor 1
3654764 1911747 1911747 defendant Aysshe John weaver 599338 599338 Aysshe, John, of Bruton, weaver 0
3681082 1920162 1920162 defendant Court John merchant 599338 599338 Court, John, of Bruton, merchant 0
3691440 1923481 1923481 defendant Parsons John husbandman 599338 599338 Parsons, John, of Bruton, husbandman 2
3691442 1923481 1923481 defendant Hart John yeoman 599338 599338 Hart, John, of Bruton, yeoman 4
3692177 1923722 1923722 defendant Bugley John butcher 599338 599338 Bugley, John, of Bruton, butcher 1
3707415 1928612 1928612 plaintiff Love Walter goldsmith 599338 599338 Love, Walter, of Bruton, goldsmith 0
3712671 1930277 1930277 defendant Samwyse Robert innholder 599338 599338 Samwyse, Robert, of Bruton, innholder 1
3714273 1930763 1930763 defendant Stynte Walter butcher 599338 599338 Stynte, Walter, of Bruton, butcher 0
3731672 1936137 1936137 plaintiff Chike Stephen mercer 599338 599338 Chike, Stephen, of Bruton, mercer 0
3755100 1943543 1943543 defendant Amottys John butcher 599338 599338 Amottys, John, of Bruton, butcher 0
3780573 1951654 1951654 defendant Lucocke John carpenter 599338 599338 Lucocke, John, of Bruton, carpenter 0
3856221 1975566 1975566 defendant Styro Roger yeoman 599338 599338 (Styro, Roger, of Bruton, yeoman 1
3858369 1976278 1976278 defendant Tayler John carpenter 599338 599338 Tayler, John, of Bruton, carpenter 0
3875208 1981948 1981948 defendant Fayle John, junior tucker 599338 599338 Fayle, John, junior, of Bruton, tucker 0
3904098 1991613 1991613 defendant Ottys Henry yeoman 599338 599338 Ottys, Henry, of Bruton, yeoman 0
3916926 1996026 1996026 defendant Colles William mercer 599338 599338 Colles, William, of Bruton, mercer 0
3918521 1996520 1996520 defendant Colyns Thomas smith 599338 599338 Colyns, Thomas, of Bruton, smith 0
3937422 2002851 2002851 defendant Stephens Christopher mercer 599338 599338 Stephens, Christopher, of Bruton, mercer 0
3973815 2015410 2015410 defendant Lambell Nicholas chapman 599338 599338 Lambell, Nicholas, of Bruton, chapman 1
4048115 2041760 2041760 defendant M---e Henry gent 599338 599338 M---e, Henry, of Bruton, gent 0
4056013 2044531 2044531 defendant Wilton William husbandman 599338 599338 Wilton, William, of Bruton, husbandman 0
4057602 2045100 2045100 defendant Stydman William yeoman 599338 599338 Stydman, William, of Bruton, yeoman 0
4075373 2051496 2051496 plaintiff Ruddocke William tailor 599338 599338 Ruddocke, William, of Bruton, tailor 0
4083848 2054496 2054496 defendant Kyngston William husbandman 599338 599338 Kyngston, William, of Bruton, husbandman 1
4099643 2060196 2060196 defendant Bartlett Thomas husbandman 599338 599338 Bartlett, Thomas, of Bruton, husbandman 0
4130172 2071098 2071098 defendant Atkyns alias Taver William yeoman 599338 599338 Atkyns alias Taver, William, of Bruton, yeoman 3
4140013 2074673 2074673 defendant Horner William pewterer 599338 599338 Horner, William, of Bruton, pewterer 1
4205778 2097569 2097569 defendant Flynger Nicholas   599338 599338 Flynger, Nicholas, of Bruton, woollen draper 0
4205779 2097569 2097569 defendant Colborne John yeoman 599338 599338 Colborne, John, of Bruton, yeoman 1
4211608 2099610 2099610 defendant Constable Robert gent 599338 599338 Constable, Robert, of Bruton, gent 0
4302993 2131172 2131172 defendant Lane alias Jordan Richard mercer 599338 599338 Lane alias Jordan, Richard, of Bruton, mercer 0
4306679 2132474 2132474 defendant Lane alias Jordan Richard mercer 599338 599338 Lane alias Jordan, Richard, of Bruton, mercer 0
4314647 2135236 2135236 defendant Colborne John yeoman 599338 599338 Colborne, John, of Bruton, yeoman 2
4330098 2140365 2140365 defendant Korke Richard blacksmith 599338 599338 Korke, Richard, of Bruton, blacksmith 0
4382316 2158785 2158785 defendant Dycer Edward butcher 599338 599338 Dycer, Edward, of Bruton, butcher 0
4402556 2165442 2165442 defendant Colborne John yeoman 599338 599338 Colborne, John, of Bruton, yeoman 0
4439985 2181791 2181791 defendant Lode William   599338 599338 Lode, William, of Bruton 0
4447892 2184268 2184268 defendant Loode William   599338 599338 Loode, William, of Bruton 0
4453942 2186250 2186250 plaintiff Lode Walter   599338 599338 Lode, Walter, of Bruton 0
4467425 2190492 2190492 plaintiff atte Wodemill Thomas   599338 599338 atte Wodemill, Thomas, of Bruton 0
4467426 2190492 2190492 defendant Bury Thomas   599338 599338 Bury, Thomas, of Bruton 0
4476324 2193259 2193259 plaintiff Frere Nicholas   599338 599338 Frere, Nicholas, of Bruton 0
4476327 2193260 2193260 plaintiff Frere Nicholas   599338 599338 Frere, Nicholas, of Bruton 0
4478048 2193805 2193805 defendant Merston John   599338 599338 Merston, John, of Bruton 0
4479373 2194200 2194200 defendant Bury Thomas   599338 599338 Bury, Thomas, of Bruton 0
4486884 2196613 2196613 defendant Hufle Roger   599338 599338 Hufle, Roger, of Bruton 0
4487504 2196808 2196808 plaintiff Smyth Ralph   599338 599338 Smyth, Ralph, of Bruton 0
4495785 2199366 2199366 plaintiff Chaumberlayn William   599338 599338 Chaumberlayn, William, of Bruton 0
4495786 2199366 2199366 defendant Hoke Robert   599338 599338 Hoke, Robert, of Bruton 0
4506207 2202446 2202446 defendant Lode William   599338 599338 Lode, William, of Bruton 3
4509048 2203302 2203302 plaintiff Asshe William   599338 599338 Asshe, William, of Bruton 0
4509049 2203302 2203302 defendant Buskyn William   599338 599338 Buskyn, William, of Bruton 0
4509876 2203574 2203574 plaintiff Bailly Robert   599338 599338 Bailly, Robert, of Bruton 0
4509877 2203574 2203574 defendant Countwyche Robert   599338 599338 Countwyche, Robert, of Bruton 0
4510681 2203798 2203798 defendant Walteres Nicholas   599338 599338 Walteres, Nicholas, of Bruton 1
4535164 2211275 2211275 defendant Paddok William   599338 599338 Paddok, William, of Bruton 0
4538379 2212288 2212288 defendant Lode William   599338 599338 Lode, William, of Bruton 0
4542616 2213574 2213574 defendant Whitfeld John weaver 599338 599338 Whitfeld, John, of Bruton, weaver 7
4544889 2214319 2214319 defendant Hoke Robert   599338 599338 Hoke, Robert, of Bruton 4
4553034 2216889 2216889 plaintiff Bemystre Robert   599338 599338 Bemystre, Robert, of Bruton, parson 1
4558140 2218486 2218486 plaintiff Lode Walter   599338 599338 Lode, Walter, of Bruton 0
4562924 2219969 2219969 defendant Lode William   599338 599338 Lode, William, of Bruton 1
4564962 2220608 2220608 defendant Paddok William   599338 599338 Paddok, William, of Bruton 0
4565430 2220757 2220757 plaintiff Smyth Ralph   599338 599338 Smyth, Ralph, of Bruton 0
4565434 2220758 2220758 plaintiff Smyth Ralph   599338 599338 Smyth, Ralph, of Bruton 0
4566643 2221139 2221139 defendant Hoke Robert   599338 599338 Hoke, Robert, of Bruton 1
4575502 2223846 2223846 defendant Cosham John   599338 599338 Cosham, John, of Bruton, prior 1
4588508 2227774 2227774 defendant Hoke Robert chapman 599338 599338 Hoke, Robert, of Bruton, chapman 4
4599296 2230996 2230996 defendant Meere John   599338 599338 Meere, John, of Bruton 0
4599297 2230996 2230996 defendant Glover Geoffrey   599338 599338 Glover, Geoffrey, of Bruton 1
4599937 2231201 2231201 defendant Waryner John   599338 599338 Waryner, John, of Bruton 1
4599975 2231215 2231215 defendant Parkere Ro_   599338 599338 Parkere, Ro_, of Bruton 1
4610499 2234355 2234355 defendant Touker Hugh   599338 599338 Touker, Hugh, of Bruton 1
4610500 2234355 2234355 defendant Brice John   599338 599338 Brice, John, of Bruton 2
4617600 2236513 2236513 plaintiff Smyth William   599338 599338 Smyth, William, of Bruton 2
4629267 2240091 2240091 plaintiff Smyth Walter   599338 599338 Smyth, Walter, of Bruton 0
4635097 2241823 2241823 defendant Hole Robert   599338 599338 Hole, Robert, of Bruton 0
4638137 2242692 2242692 defendant Baylebyn Robert   599338 599338 Baylebyn, Robert, of Bruton 0
4641129 2243496 2243496 defendant Abbey Hugh   599338 599338 Abbey, Hugh, of Bruton 2
4642833 2244015 2244015 defendant Warner John chaplain 599338 599338 Warner, John, of Bruton, chaplain 0
4655625 2247644 2247644 defendant Barwe William   599338 599338 Barwe, William, of Bruton, franklin 0
4655631 2247644 2247644 defendant Gryse John   599338 599338 Gryse, John, of Bruton, mason 6
4660968 2249254 2249254 defendant Barwe William gent 599338 599338 Barwe, William, of Bruton, gent 0
4662982 2249885 2249885 defendant atte Wodemylle Thomas tucker 599338 599338 atte Wodemylle, Thomas, of Bruton, tucker 0
4668944 2255987 2255987 defendant Yrysshe William butcher 599338 599338 Yrysshe, William, of Bruton, butcher 0
4670398 2256432 2256432 defendant Cook William   599338 599338 Cook, William, of Bruton, cook 4
4670418 2256435 2256435 defendant Cosham John   599338 599338 Cosham, John, of Bruton, prior 0
4671707 2256796 2256796 defendant Ben John husbandman 599338 599338 Ben, John, of Bruton, husbandman 0
4674202 2257540 2257540 plaintiff Drape Robert   599338 599338 Drape, Robert, of Bruton 0
4684562 2260774 2260774 defendant Smuth William yeoman 599338 599338 Smuth, William, of Bruton, yeoman 0
4686615 2261422 2261422 plaintiff Smyth Walter   599338 599338 Smyth, Walter, of Bruton 0
4686632 2261430 2261430 plaintiff Smyth William   599338 599338 Smyth, William, of Bruton, on his own account 0
4699354 2265261 2265261 plaintiff Draper Robert   599338 599338 Draper, Robert, of Bruton 0
4706664 2267466 2267466 defendant Cheseman John laborer 599338 599338 Cheseman, John, of Bruton, laborer 0
4706997 2267570 2267570 defendant Hoper William yeoman 599338 599338 Hoper, William, of Bruton, yeoman 0
4712339 2269174 2269174 plaintiff Shoyll John   599338 599338 Shoyll, John, of Bruton, prior 0
4712340 2269174 2269174 defendant Turnepeny John yeoman 599338 599338 Turnepeny, John, of Bruton, yeoman 0
4712612 2269263 2269263 plaintiff Smyth William   599338 599338 Smyth, William, of Bruton 0
4712613 2269263 2269263 defendant Becham Robert fuller 599338 599338 Becham, Robert, of Bruton, fuller 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);