names

128 rows where place_id = 598669

✎ 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
3633498 1905291 1905291 defendant Hyll John yeoman 598669 598669 Hyll, John, of Newenham, yeoman 0
3637192 1906432 1906432 defendant Butteler William collier 598669 598669 Butteler, William, of Newenham, collier 3
3643698 1908454 1908454 defendant Strode William esq 598669 598669 Strode, William, of Newenham, esq 0
3645773 1909080 1909080 defendant Feldyng William esq 598669 598669 Feldyng, William, of Newenham, esq 0
3656039 1912141 1912141 defendant Burgeys John husbandman 598669 598669 Burgeys, John, of Newenham, husbandman 3
3762458 1945901 1945901 defendant Burges alias Hechyn John husbandman 598669 598669 Burges alias Hechyn, John, of Newenham, husbandman 2
3766316 1947118 1947118 defendant Fyllypp John husbandman 598669 598669 Fyllypp, John, of Newenham, husbandman 0
3833252 1968330 1968330 defendant Shepard Richard husbandman 598669 598669 Shepard, Richard, of Newenham, husbandman 1
3838625 1970007 1970007 defendant Smyth Thomas husbandman 598669 598669 Smyth, Thomas, of Newenham, husbandman 1
3946162 2005734 2005734 defendant Spark John mariner 598669 598669 Spark, John, of Newenham, mariner 0
3989920 2021151 2021151 defendant Byrdley Richard weaver 598669 598669 Byrdley, Richard, of Newenham, weaver 1
4033485 2036637 2036637 defendant Somerfielde Nicholas husbandman 598669 598669 Somerfielde, Nicholas, of Newenham, husbandman 0
4125394 2069366 2069366 defendant Whissen Edmund husbandman 598669 598669 Whissen, Edmund, of Newenham, husbandman 0
4173316 2086130 2086130 defendant Spencer John esq 598669 598669 Spencer, John, of Newenham, esq 0
4287422 2125553 2125553 defendant Chynner Walter   598669 598669 Chynner, Walter, of Newenham myeoman 0
4289823 2126423 2126423 defendant Withers Walter husbandman 598669 598669 Withers, Walter, of Newenham, husbandman 0
4328475 2139838 2139838 defendant Chynn Walter yeoman 598669 598669 Chynn, Walter, of Newenham, yeoman 1
4345172 2145587 2145587 defendant Gould Thomas mariner 598669 598669 Gould, Thomas, of Newenham, mariner 0
4395695 2163146 2163146 defendant White James weaver 598669 598669 White, James, of Newenham, weaver 0
4395696 2163146 2163146 defendant Morse John butcher 598669 598669 Morse, John, of Newenham, butcher 1
4420209 2171221 2171221 defendant Saltford John   598669 598669 Saltford, John, of Newenham 0
4433114 2175110 2175110 plaintiff Falun Adam (legal representative) 598669 598669 Falun, Adam, of Newenham, chaplain, executors of 0
4433247 2175151 2175151 plaintiff Flann of Flaun Adam (legal representative) 598669 598669 Flann of Flaun, Adam, of Newenham, chaplain, executors of 0
4439439 2181599 2181599 plaintiff Baillif Robert   598669 598669 Baillif, Robert, of Newenham, on his own account 0
4439442 2181599 2181599 defendant But John   598669 598669 But, John, of Newenham 2
4444868 2183370 2183370 plaintiff Cook William   598669 598669 Cook, William, of Newenham 0
4448541 2184474 2184474 plaintiff Freman William   598669 598669 Freman, William, of Newenham 0
4448546 2184475 2184475 plaintiff Freman William   598669 598669 Freman, William, of Newenham 0
4467919 2190645 2190645 defendant Osemond Thomas   598669 598669 Osemond, Thomas, of Newenham 0
4468012 2190666 2190666 defendant Brayn Richard   598669 598669 Brayn, Richard, of Newenham 2
4488475 2197114 2197114 plaintiff Stowe Thomas   598669 598669 Stowe, Thomas, of Newenham 0
4492376 2198296 2198296 plaintiff Wythot William   598669 598669 Wythot, William, of Newenham, parson 0
4494620 2199009 2199009 defendant Amkus Richard   598669 598669 Amkus, Richard, of Newenham 0
4518751 2206239 2206239 defendant Edmere John   598669 598669 Edmere, John, of Newenham 0
4521907 2207190 2207190 defendant Bayly Walter   598669 598669 Bayly, Walter, of Newenham 0
4525257 2208238 2208238 defendant Baidy Walter   598669 598669 Baidy, Walter, of Newenham 1
4526814 2208664 2208664 plaintiff Wythot William   598669 598669 (Wythot, William, of Newenham, parson 1
4530228 2209746 2209746 defendant Preston John   598669 598669 Preston, John, of Newenham 0
4534279 2210988 2210988 defendant Belford Thomas   598669 598669 Belford, Thomas, of Newenham, vicar 0
4543719 2213931 2213931 defendant Brayme Richard   598669 598669 Brayme, Richard, of Newenham 2
4551650 2216462 2216462 plaintiff Edlyng John   598669 598669 Edlyng, John, of Newenham 0
4560632 2219270 2219270 defendant Clerk Nicholas   598669 598669 Clerk, Nicholas, of Newenham 0
4578462 2224752 2224752 defendant Elcok Henry   598669 598669 Elcok, Henry, of Newenham 0
4580199 2225296 2225296 defendant Nicol Thomas   598669 598669 Nicol, Thomas, of Newenham 1
4580201 2225296 2225296 defendant Nicol John   598669 598669 Nicol, John, of Newenham 3
4633129 2241228 2241228 defendant Pirye John   598669 598669 Pirye, John, of Newenham 2
4638630 2242835 2242835 plaintiff Cellam John   598669 598669 Cellam, John, of Newenham 0
4638631 2242835 2242835 defendant Hunte John   598669 598669 Hunte, John, of Newenham 0
4666896 2255376 2255376 defendant Chynne Robert laborer 598669 598669 Chynne, Robert, of Newenham, laborer 0
4674333 2257578 2257578 plaintiff Drovere John   598669 598669 Drovere, John, of Newenham 0
4678767 2258963 2258963 defendant Pulter John   598669 598669 Pulter, John, of Newenham, milward 0
4686042 2261223 2261223 plaintiff Selman John   598669 598669 Selman, John, of Newenham, on his own account 0
4686044 2261224 2261224 plaintiff Selman John   598669 598669 Selman, John, of Newenham, on his own account 0
4693927 2263606 2263606 plaintiff Bereleys William   598669 598669 Bereleys, William, of Newenham 0
4695551 2264092 2264092 defendant Blanket Walter   598669 598669 Blanket, Walter, of Newenham, parson 0
4724396 2272926 2272926 defendant Drover Joan   598669 598669 Drover, Joan, of Newenham, widow, formerly wife of John 1
4741959 2278145 2278145 defendant Hunte John husbandman 598669 598669 Hunte, John, of Newenham, husbandman 0
4754255 2281709 2281709 defendant Piers William husbandman 598669 598669 Piers, William, of Newenham, husbandman 0
4754256 2281709 2281709 defendant Wekyn Margery spinster 598669 598669 Wekyn, Margery, of Newenham, spinster 1
4771565 2287083 2287083 plaintiff Selman John   598669 598669 Selman, John, of Newenham 0
4778816 2289348 2289348 defendant Staure Thomas yeoman 598669 598669 Staure, Thomas, of Newenham, yeoman 1
4781234 2290144 2290144 defendant Pery Richard yeoman 598669 598669 Pery, Richard, of Newenham, yeoman 0
4796632 2295097 2295097 plaintiff Selman John   598669 598669 Selman, John, of Newenham 0
4842513 2309194 2309194 defendant Bonham Nicholas gent 598669 598669 Bonham, Nicholas, of Newenham, gent 0
4844948 2309939 2309939 defendant Quyntyn William yeoman 598669 598669 Quyntyn, William, of Newenham, yeoman 0
4853475 2312496 2312496 defendant Clyff John husbandman 598669 598669 Clyff, John, of Newenham, husbandman 0
4853477 2312497 2312497 defendant Clyff John husbandman 598669 598669 Clyff, John, of Newenham, husbandman 0
4869919 2317565 2317565 defendant Bonham Nicholas gent 598669 598669 Bonham, Nicholas, of Newenham, gent 0
4870771 2317838 2317838 defendant Chepman William clerk 598669 598669 Chepman, William, of Newenham, clerk 0
4876962 2319764 2319764 defendant Brasyer John husbandman 598669 598669 Brasyer, John, of Newenham, husbandman 0
4886930 2322764 2322764 defendant Brasyer John yeoman 598669 598669 Brasyer, John, of Newenham, yeoman 1
4887427 2322907 2322907 defendant Edmere John husbandman 598669 598669 Edmere, John, of Newenham, husbandman 0
4892157 2324290 2324290 defendant Stucley Thomas gent 598669 598669 Stucley, Thomas, of Newenham, gent 0
4906259 2328548 2328548 plaintiff Rotur John   598669 598669 Rotur, John, of Newenham 1
4907166 2328805 2328805 defendant Sandford Robert esq 598669 598669 Sandford, Robert, of Newenham, esq 0
4914375 2331011 2331011 defendant Wyntyll William baker 598669 598669 Wyntyll, William, of Newenham, baker 1
4925717 2334476 2334476 defendant Freman Henry   598669 598669 Freman, Henry, of Newenham, franklin 3
4935710 2337558 2337558 defendant Boyssheley Nicholas shoemaker 598669 598669 Boyssheley, Nicholas, of Newenham, shoemaker 3
4961143 2345295 2345295 defendant Taillour John laborer 598669 598669 Taillour, John, of Newenham, laborer 1
4961575 2345427 2345427 defendant Boold Richard husbandman 598669 598669 Boold, Richard, of Newenham, husbandman 0
4961576 2345427 2345427 defendant Chynne Richard husbandman 598669 598669 Chynne, Richard, of Newenham, husbandman 1
4961577 2345427 2345427 defendant Danyell William husbandman 598669 598669 Danyell, William, of Newenham, husbandman 2
4961578 2345427 2345427 defendant Brayn William husbandman 598669 598669 Brayn, William, of Newenham, husbandman 3
4961579 2345427 2345427 defendant Brayn Richard husbandman 598669 598669 Brayn, Richard, of Newenham, husbandman 4
4961580 2345427 2345427 defendant Bosseley Nicholas husbandman 598669 598669 Bosseley, Nicholas, of Newenham, husbandman 5
4961581 2345427 2345427 defendant Haron John husbandman 598669 598669 Haron, John, of Newenham, husbandman 6
4961582 2345427 2345427 defendant Hille Nicholas husbandman 598669 598669 Hille, Nicholas, of Newenham, husbandman 7
4961583 2345427 2345427 defendant Wilkyns William husbandman 598669 598669 Wilkyns, William, of Newenham, husbandman 8
4961584 2345427 2345427 defendant Tyler John husbandman 598669 598669 Tyler, John, of Newenham, husbandman 9
4961585 2345427 2345427 defendant Brasyer John husbandman 598669 598669 Brasyer, John, of Newenham, husbandman 10
4972218 2348634 2348634 defendant Neweman alias Edward John laborer 598669 598669 Neweman alias Edward, John, of Newenham, laborer 0
4990302 2354008 2354008 plaintiff Catesby Robert   598669 598669 Catesby, Robert, of Newenham 0
4990667 2354118 2354118 defendant Haitfelde Stephen esq 598669 598669 Haitfelde, Stephen, of Newenham, esq 0
5038747 2368235 2368235 defendant Lude Thomas husbandman 598669 598669 Lude, Thomas, of Newenham, husbandman 1
5038757 2368237 2368237 defendant Luyde Thomas husbandman 598669 598669 Luyde, Thomas, of Newenham, husbandman 2
5061624 2375068 2375068 defendant Trevys John (legal representative) 598669 598669 Trevys, John, of Newenham, executors of 0
5072878 2378374 2378374 defendant Arham Richard yeoman 598669 598669 Arham, Richard, of Newenham, yeoman 0
5083245 2381488 2381488 defendant Somervyle Nicholas husbandman 598669 598669 Somervyle, Nicholas, of Newenham, husbandman 0
5089061 2383176 2383176 defendant Stucle John gent 598669 598669 Stucle, John, of Newenham, gent 0
5097839 2385795 2385795 defendant Arham Richard yeoman 598669 598669 Arham, Richard, of Newenham, yeoman 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);