names

96 rows where place_id = 625176

✎ 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
3656234 1912198 1912198 defendant Smyth Thomas, junior mercer 625176 625176 Smyth, Thomas, junior, of West Chester, mercer 1
3726900 1934682 1934682 defendant Corkyn Edmund husbandman 625176 625176 Corkyn, Edmund, of West Chester, husbandman 2
3726901 1934682 1934682 defendant Byrche Henry tailor 625176 625176 Byrche, Henry, of West Chester, tailor 3
3762542 1945927 1945927 defendant Napper Thomas tanner 625176 625176 Napper, Thomas, of West Coker, tanner 0
3762544 1945928 1945928 defendant Napper Thomas tanner 625176 625176 Napper, Thomas, of West Coker, tanner 0
3918688 1996579 1996579 defendant Harman alias Rumsey Robert husbandman 625176 625176 Harman alias Rumsey, Robert, of West Harman, husbandman 0
3936574 2002557 2002557 plaintiff Masse Richard   625176 625176 Masse, Richard, of West Chester 0
3960331 2010710 2010710 defendant Kent Humphrey husbandman 625176 625176 Kent, Humphrey, of West Penner, or of Wollavyngton, Soms, husbandman 0
3966256 2012827 2012827 defendant Hache John husbandman 625176 625176 Hache, John, of West under Edge, husbandman 1
4011759 2028943 2028943 defendant Midleton John gent 625176 625176 Midleton, John, of West Coker, gent 2
4058594 2045465 2045465 defendant Napper John husbandman 625176 625176 Napper, John, of West Coker, husbandman 0
4058626 2045474 2045474 defendant Slade Roger husbandman 625176 625176 Slade, Roger, of West Coker, husbandman 1
4059370 2045743 2045743 defendant Middelton John gent 625176 625176 Middelton, John, of West Cocker, gent 0
4075119 2051406 2051406 defendant Whittington alias Wytten Francis gent 625176 625176 Whittington alias Wytten, Francis, of West Coker, gent 0
4082705 2054122 2054122 defendant Combe John weaver 625176 625176 Combe, John, of West Coker, weaver 0
4120769 2067713 2067713 defendant Slade Roger husbandman 625176 625176 Slade, Roger, of West Coker, husbandman 0
4125207 2069301 2069301 defendant Middleton John (legal representative) 625176 625176 Middleton, John, of West Coker, gent, executrix of 3
4125208 2069301 2069301 defendant Middleton Alice widow 625176 625176 Middleton, Alice, of West Coker, widow 4
4129513 2070859 2070859 defendant Whittington Francis gent 625176 625176 Whittington, Francis, of West Coker, gent 3
4145565 2076604 2076604 defendant Whittyngton ot Whitton Francis gent 625176 625176 Whittyngton ot Whitton, Francis, of West Coker, gent 2
4147022 2077103 2077103 defendant Middelton Henry yeoman 625176 625176 Middelton, Henry, of West Coker, yeoman 1
4149204 2077851 2077851 defendant Mydleton John (legal representative) 625176 625176 Mydleton, John, of West Coker, gent, administratrix of 2
4149205 2077851 2077851 defendant Mydleton Alice widow 625176 625176 Mydleton, Alice, of West Coker, widow 3
4156471 2080339 2080339 defendant Whitwick Richard gent 625176 625176 Whitwick, Richard, of West minster, gent 1
4177715 2087680 2087680 defendant Apseye William cerpenter 625176 625176 Apseye, William, of West Coker, cerpenter 1
4186338 2090708 2090708 defendant Sadler John husbandman 625176 625176 Sadler, John, of West super Mare, husbandman 1
4229213 2105701 2105701 defendant Slade Richard gent 625176 625176 Slade, Richard, of West Coker, gent 0
4276153 2121604 2121604 defendant Mydleton Henry gent 625176 625176 Mydleton, Henry, of West Coker, gent 0
4276154 2121604 2121604 defendant Whyte Richard husbandman 625176 625176 Whyte, Richard, of West Coker, husbandman 1
4279907 2122886 2122886 defendant Androwes alias Wilcoxe William   625176 625176 Androwes alias Wilcoxe, William, of West Coker 0
4289509 2126309 2126309 defendant Sampforde William husbandman 625176 625176 Sampforde, William, of West Coker, husbandman 0
4289511 2126310 2126310 defendant Sampforde William husbandman 625176 625176 Sampforde, William, of West Coker, husbandman 0
4303725 2131430 2131430 defendant Middleton Henry gent 625176 625176 Middleton, Henry, of West Coker, gent 0
4303726 2131430 2131430 defendant White Richard husbandman 625176 625176 White, Richard, of West Coker, husbandman 1
4307714 2132838 2132838 defendant Miller William yeoman 625176 625176 Miller, William, of West Coker, yeoman 0
4307715 2132838 2132838 defendant Gye John yeoman 625176 625176 Gye, John, of West Coker, yeoman 1
4307716 2132838 2132838 defendant Spore Thomas yeoman 625176 625176 Spore, Thomas, of West Coker, yeoman 2
4311854 2134283 2134283 defendant Bradford John victualer 625176 625176 Bradford, John, of West Coker, victualer 1
4329164 2140066 2140066 defendant Apsley William husbandman or yeoman 625176 625176 Apsley, William, of West Coker, husbandman or yeoman 0
4332541 2141172 2141172 defendant Slade Richard yeoman 625176 625176 Slade, Richard, of West Coker, yeoman 0
4332542 2141172 2141172 defendant Harvye John yeoman 625176 625176 Harvye, John, of West Coker, yeoman 1
4332544 2141173 2141173 defendant Slade Richard yeoman 625176 625176 Slade, Richard, of West Coker, yeoman 0
4332545 2141173 2141173 defendant Slade John   625176 625176 Slade, John, of West Coker, yeoman, his son 1
4369489 2154148 2154148 defendant Harte Richard clothier 625176 625176 Harte, Richard, of West Water, Axminster, clothier 1
4369875 2154280 2154280 defendant Brodforde John butcher 625176 625176 Brodforde, John, of West Coker, butcher 0
4372965 2155400 2155400 defendant Sherwood Simon weaver 625176 625176 Sherwood, Simon, of West Coker, weaver 0
4372966 2155400 2155400 defendant Rendall Simon tailor 625176 625176 Rendall, Simon, of West Coker, tailor 1
4389752 2161196 2161196 defendant Harvye John yeoman 625176 625176 Harvye, John, of West Coker, yeoman 0
4393825 2162536 2162536 defendant Paramore Mathew miller 625176 625176 Paramore, Mathew, of West Cocker, miller 0
4395709 2163150 2163150 defendant Middleton Henry gent 625176 625176 Middleton, Henry, of West Coker, gent 0
4457595 2187387 2187387 defendant Froggemer Lawrence   625176 625176 together with Froggemer, Lawrence, of West Coker 1
4459917 2188157 2188157 defendant Rose John   625176 625176 Rose, John, of West Tawer 0
4461503 2188677 2188677 defendant Punchard Richard   625176 625176 Punchard, Richard, of West Coker 0
4461504 2188677 2188677 defendant Punchard John   625176 625176 Punchard, John, of West Coker 1
4565854 2220875 2220875 defendant Peytrell John   625176 625176 Peytrell, John, of West Coker 0
4614027 2235400 2235400 defendant Burton William   625176 625176 Burton, William, of West Coker 1
4637561 2242535 2242535 plaintiff (not given) John rector of Bray 625176 625176 Bray, John, of West Coker, rector of the parish church 0
4637562 2242535 2242535 defendant Goore Robert   625176 625176 Goore, Robert, of West Coker 0
4658068 2248402 2248402 defendant Gore Robert husbandman 625176 625176 Gore, Robert, of West Coker, husbandman 0
4660824 2249210 2249210 defendant Burton William yeoman 625176 625176 Burton, William, of West Coker, yeoman 1
4672977 2257190 2257190 defendant Hacche Robert husbandman 625176 625176 Hacche, Robert, of West under Wetherley, husbandman 0
4683095 2260327 2260327 defendant Germyn John husbandman 625176 625176 Germyn, John, of West Coker, husbandman 0
4705617 2267129 2267129 defendant Gardener Beatrice widow 625176 625176 Gardener, Beatrice, of West Chester, widow 1
4705618 2267129 2267129 defendant Trenchefeld Joan widow 625176 625176 Trenchefeld, Joan, of West Chester, widow 2
4708939 2268164 2268164 defendant Germyn John husbandman 625176 625176 Germyn, John, of West Toker, husbandman 0
4845969 2310245 2310245 defendant Wodecok Hugh merchant 625176 625176 Wodecok, Hugh, of West Chester, merchant 1
4861128 2314838 2314838 defendant Barkare William warrener 625176 625176 Barkare, William, of West Aker, warrener 1
4920094 2332795 2332795 defendant Russell William husbandman 625176 625176 Russell, William, of West Tramner, husbandman 0
4920095 2332795 2332795 defendant Chyssocke John   625176 625176 Chyssocke, John, of West Tramner 1
4920096 2332795 2332795 defendant Lyne John husbandman 625176 625176 Lyne, John, of West Tramner, husbandman 2
4921099 2333113 2333113 defendant Walle John butcher 625176 625176 Walle, John, of West Coker, butcher 1
5025010 2364215 2364215 defendant Wylkyns John, senior   625176 625176 Wylkyns, John, senior, of West Coker, shepherd 1
5025011 2364215 2364215 defendant Penne William, junior husbandman 625176 625176 Penne, William, junior, of West Coker, husbandman 2
5025014 2364215 2364215 defendant Slade John husbandman 625176 625176 Slade, John, of West Coker, husbandman 5
5025016 2364215 2364215 defendant Houchyn Walter husbandman 625176 625176 Houchyn, Walter, of West Coker, husbandman 7
5087885 2382838 2382838 plaintiff Debracunhac John merchant 625176 625176 Debracunhac, John, of West Chester, merchant 1
5087886 2382838 2382838 plaintiff Dedewodd John merchant 625176 625176 Dedewodd, John, of West Chester, merchant 2
5087890 2382839 2382839 plaintiff Debracunhac John merchant 625176 625176 Debracunhac, John, of West Chester, merchant 1
5087891 2382839 2382839 plaintiff Dedewodd John merchant 625176 625176 Dedewodd, John, of West Chester, merchant 2
5087895 2382840 2382840 plaintiff Debracunhac John merchant 625176 625176 Debracunhac, John, of West Chester, merchant 1
5087896 2382840 2382840 plaintiff Dedewodd John merchant 625176 625176 Dedewodd, John, of West Chester, merchant 2
5120415 2392398 2392398 defendant Bridde William butcher 625176 625176 Bridde, William, of West Coker, butcher 0
5154614 2402505 2402505 defendant Wellywroght Thomas gent 625176 625176 Wellywroght, Thomas, of West Coker, gent 0
5196875 2414835 2414835 defendant Slade John husbandman 625176 625176 Slade, John, of West Coker, husbandman 2
5238531 2426862 2426862 defendant Williamson Robert   625176 625176 Williamson, Robert, of West 1
5260867 2433521 2433521 defendant Wykes John gent 625176 625176 Wykes, John, of West Coker, gent 0
5309657 2447929 2447929 defendant Coke John husbandman 625176 625176 Coke, John, of West Coker, husbandman 1
5355884 2461917 2461917 defendant Slade John husbandman 625176 625176 Slade, John, of West Coker, husbandman 0
5355886 2461918 2461918 defendant Slade John husbandman 625176 625176 Slade, John, of West Coker, husbandman 0
5355888 2461918 2461918 defendant Slade Richard husbandman 625176 625176 Slade, Richard, of West Coker, husbandman 2
5459209 2492658 2492658 defendant Elyngham Richard yeoman 625176 625176 Elyngham, Richard, of West Bradman, yeoman 0
5585460 2530520 2530520 defendant Slade Richard husbandman 625176 625176 Slade, Richard, of West Coker, husbandman 6
5585461 2530520 2530520 defendant Sampford Thomas husbandman 625176 625176 Sampford, Thomas, of West Coker, husbandman 7
5585462 2530520 2530520 defendant Holwey John husbandman 625176 625176 Holwey, John, of West Coker, husbandman 8
5585463 2530520 2530520 defendant Smyth Richard husbandman 625176 625176 Smyth, Richard, of West Coker, husbandman 9
5612968 2547829 2547829 defendant Bouke William   625176 625176 Bouke, William, of West Coker 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);