names

170 rows where place_id = 601694

✎ 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
3646575 1909331 1909331 defendant Chapell William husbandman 601694 601694 Chapell, William, of Northam, husbandman 0
3648016 1909781 1909781 defendant Borowe Stephen husbandman 601694 601694 Borowe, Stephen, of Northam, husbandman 0
3680797 1920075 1920075 defendant Bisshopp William husbandman 601694 601694 Bisshopp, William, of Northam, husbandman 0
3687211 1922177 1922177 defendant Bysshopp William husbandman 601694 601694 Bysshopp, William, of Northam, husbandman 0
3708256 1928877 1928877 defendant Vetery John merchant 601694 601694 Vetery, John, of Northam, merchant 0
3710621 1929644 1929644 defendant Keynecote John mariner 601694 601694 Keynecote, John, of Northam, mariner 0
3710622 1929644 1929644 defendant Lane Thomas mariner 601694 601694 Lane, Thomas, of Northam, mariner 1
3710623 1929644 1929644 defendant Symon Edward mariner 601694 601694 Symon, Edward, of Northam, mariner 2
3720002 1932527 1932527 defendant Kenycott John mariner 601694 601694 Kenycott, John, of Northam, mariner 1
3747009 1940983 1940983 defendant Herde or Here John husbandman 601694 601694 (Herde or Here, John, of Northam, husbandman 1
3768571 1947815 1947815 defendant Beryman Roger husbandman 601694 601694 Beryman, Roger, of Northam, husbandman 0
3777414 1950683 1950683 defendant Vettere John merchant 601694 601694 Vettere, John, of Northam, merchant 0
3777566 1950735 1950735 defendant Edmond Thomas husbandman 601694 601694 Edmond, Thomas, of Northam, husbandman 0
3797126 1956983 1956983 defendant Veterey John merchant 601694 601694 Veterey, John, of Northam, merchant 2
3813519 1962146 1962146 defendant Whytston Robert mariner 601694 601694 Whytston, Robert, of Northam, mariner 0
3833148 1968296 1968296 defendant Cornysshe Thomas yeoman 601694 601694 Cornysshe, Thomas, of Northam, yeoman 0
3837616 1969672 1969672 defendant Cornysshe Thomas yeoman 601694 601694 Cornysshe, Thomas, of Northam, yeoman 0
3847470 1972771 1972771 defendant Vettre John merchant 601694 601694 Vettre, John, of Northam, merchant 0
3848921 1973255 1973255 defendant Cornysche Thomas yeoman 601694 601694 Cornysche, Thomas, of Northam, yeoman 0
3858654 1976377 1976377 defendant Veterye John merchant 601694 601694 Veterye, John, of Northam, merchant 0
3861400 1977283 1977283 defendant Smyth John clerk 601694 601694 Smyth, John, of Northam, clerk 0
3864142 1978193 1978193 defendant Cornyshe Thomas mariner 601694 601694 Cornyshe, Thomas, of Northam, mariner 0
3875508 1982051 1982051 defendant Smyth John clerk 601694 601694 Smyth, John, of Northam, clerk 0
3875740 1982136 1982136 defendant Vettre John merchant 601694 601694 Vettre, John, of Northam, merchant 0
3878231 1982967 1982967 defendant Cornysshe Thomas mariner 601694 601694 Cornysshe, Thomas, of Northam, mariner 0
3898528 1989719 1989719 defendant Hillyng William merchant 601694 601694 Hillyng, William, of Northam, merchant 0
3898529 1989719 1989719 defendant Bery Christopher merchant 601694 601694 Bery, Christopher, of Northam, merchant 1
3898530 1989719 1989719 defendant Colamore Philip yeoman 601694 601694 Colamore, Philip, of Northam, yeoman 2
3904649 1991811 1991811 defendant Hawarde Thomas husbandman 601694 601694 Hawarde, Thomas, of Northam, husbandman 0
3934208 2001735 2001735 defendant Paslowe David merchant 601694 601694 Paslowe, David, of Northam, merchant 2
3934209 2001735 2001735 defendant Paslowe William merchant 601694 601694 Paslowe, William, of Northam, merchant 3
3934824 2001947 2001947 defendant Bery Christopher gent 601694 601694 Bery, Christopher, of Northam, gent 0
3962442 2011453 2011453 defendant Rowlande John husbandman 601694 601694 Rowlande, John, of Northam, husbandman 0
3978858 2017188 2017188 defendant Bury Christopher yeoman 601694 601694 Bury, Christopher, of Northam, yeoman 0
3981516 2018149 2018149 defendant Bourghe John yeoman 601694 601694 Bourghe, John, of Northam, yeoman 0
3990275 2021277 2021277 defendant Bowdon Peter   601694 601694 Bowdon, Peter, of Northam, mason 0
3990356 2021306 2021306 plaintiff Bett James gent 601694 601694 Bett, James, of Northam, or of Southampton, gent 0
3990358 2021307 2021307 plaintiff Bett James gent 601694 601694 Bett, James, of Northam, or of Southampton, gent 0
4011599 2028897 2028897 defendant Blackemore John husbandman 601694 601694 Blackemore, John, of Northam, husbandman 4
4020409 2032022 2032022 plaintiff Willet Richard mariner 601694 601694 Willet, Richard, of Northam, mariner 0
4039619 2038781 2038781 defendant Bonde John shoemaker 601694 601694 Bonde, John, of Northam, shoemaker 12
4088853 2056313 2056313 defendant Whiston Elizabeth widow 601694 601694 Whiston, Elizabeth, of Northam, widow 2
4088857 2056314 2056314 defendant Whyston Elizabeth widow 601694 601694 Whyston, Elizabeth, of Northam, widow 2
4122213 2068249 2068249 defendant Burgh David (legal representative) 601694 601694 Burgh, David, of Northam, gent, executrix of 0
4176695 2087319 2087319 defendant Frenche William (legal representative) 601694 601694 Frenche, William, of Northam, shipmaster, administratrix of 0
4176696 2087319 2087319 defendant Frenche Elizabeth widow 601694 601694 Frenche, Elizabeth, of Northam, widow 1
4189319 2091760 2091760 defendant Frenche Elizabeth widow 601694 601694 Frenche, Elizabeth, of Northam, widow 1
4202040 2096257 2096257 defendant Frenche William (legal representative) 601694 601694 Frenche, William, of Northam, sailor, administratrix of 0
4202041 2096257 2096257 defendant Frenche Elizabeth widow 601694 601694 Frenche, Elizabeth, of Northam, widow 1
4215476 2100907 2100907 defendant Ellott James   601694 601694 Ellott, James, of Northam, ship master 0
4291193 2126917 2126917 defendant Herneman Thomasine widow 601694 601694 Herneman, Thomasine, of Northam, widow 0
4304576 2131738 2131738 defendant Hernaman Thomas   601694 601694 Hernaman, Thomas, of Northam, Devon, sailor 0
4304577 2131738 2131738 defendant Hernaman William (legal representative) 601694 601694 Hernaman, William, of Northam, sailor, administratrix of 1
4304578 2131738 2131738 defendant Hernaman Jane widow 601694 601694 Hernaman, Jane, of Northam, widow 2
4383030 2159038 2159038 defendant Toppe John husbandman 601694 601694 Toppe, John, of Northam, husbandman 0
4390699 2161499 2161499 defendant Whitston John yeoman 601694 601694 Whitston, John, of Northam, yeoman 3
4452738 2185868 2185868 defendant Ke-yng William   601694 601694 Ke-yng, William, of Northam 0
4662470 2249734 2249734 defendant Reydon John tailor 601694 601694 Reydon, John, of Northam, tailor 0
4662471 2249734 2249734 defendant Whitehede William husbandman 601694 601694 Whitehede, William, of Northam, husbandman 1
4662472 2249734 2249734 defendant Tadeworthy John husbandman 601694 601694 Tadeworthy, John, of Northam, husbandman 2
4731427 2275029 2275029 defendant Roydon William husbandman 601694 601694 Roydon, William, of Northam, husbandman 0
4743152 2278521 2278521 defendant Taweton John merchant 601694 601694 Taweton, John, of Northam, merchant 0
4743153 2278521 2278521 defendant Smyth John merchant 601694 601694 Smyth, John, of Northam, merchant 1
4749446 2280318 2280318 defendant Sumter John mariner 601694 601694 Sumter, John, of Northam, mariner 0
4766348 2285467 2285467 defendant Hywelet William mariner 601694 601694 Hywelet, William, of Northam, mariner 0
4766350 2285467 2285467 defendant Syllysford John husbandman 601694 601694 Syllysford, John, of Northam, husbandman 2
4767729 2285886 2285886 defendant Craddok Richard merchant 601694 601694 Craddok, Richard, of Northam, merchant 6
4771059 2286927 2286927 defendant Tadypyt Robert husbandman 601694 601694 Tadypyt, Robert, of Northam, husbandman 0
4775781 2288425 2288425 defendant Colewyll John mariner 601694 601694 Colewyll, John, of Northam, mariner 0
4775782 2288425 2288425 defendant atte Yeo John mariner 601694 601694 atte Yeo, John, of Northam, mariner 1
4775784 2288425 2288425 defendant Hancokkes Robert mariner 601694 601694 Hancokkes, Robert, of Northam, mariner 3
4775791 2288425 2288425 defendant Bussh William tailor 601694 601694 Bussh, William, of Northam, tailor 10
4790765 2293199 2293199 defendant Hywelet William mariner 601694 601694 Hywelet, William, of Northam, mariner 0
4790767 2293199 2293199 defendant Syllysford John husbandman 601694 601694 Syllysford, John, of Northam, husbandman 2
4792202 2293649 2293649 defendant Craddok Richard merchant 601694 601694 Craddok, Richard, of Northam, merchant 2
4804369 2297551 2297551 defendant Dytemay Richard merchant 601694 601694 Dytemay, Richard, of Northam, merchant 0
4831672 2305935 2305935 defendant Poddisham William chapman 601694 601694 Poddisham, William, of Northam, chapman 0
4831673 2305935 2305935 defendant Raydon Simon mariner 601694 601694 Raydon, Simon, of Northam, mariner 1
4831674 2305935 2305935 defendant Poddyng Robert husbandman 601694 601694 Poddyng, Robert, of Northam, husbandman 2
4831675 2305935 2305935 defendant Estrigge Richard mariner 601694 601694 Estrigge, Richard, of Northam, mariner 3
4831676 2305935 2305935 defendant Dyra Richard husbandman 601694 601694 Dyra, Richard, of Northam, husbandman 4
4831681 2305936 2305936 defendant Valet John merchant 601694 601694 Valet, John, of Northam, merchant 0
4833636 2306527 2306527 defendant Wyston Walter husbandman 601694 601694 Wyston, Walter, of Northam, husbandman 0
4833640 2306527 2306527 defendant Shilleford John husbandman 601694 601694 Shilleford, John, of Northam, husbandman 4
4833641 2306527 2306527 defendant Puddyng Robert husbandman 601694 601694 Puddyng, Robert, of Northam, husbandman 5
4836568 2307408 2307408 defendant Pokeslegh Thomas husbandman 601694 601694 Pokeslegh, Thomas, of Northam, husbandman 1
4844275 2309717 2309717 defendant Toker William toker or fuller of cloth 601694 601694 Toker, William, of Northam, toker or fuller of cloth 0
4849164 2311214 2311214 defendant Cradok Thomas merchant 601694 601694 Cradok, Thomas, of Northam, merchant 1
4850888 2311724 2311724 defendant Sompter William husbandman 601694 601694 Sompter, William, of Northam, husbandman 1
4857300 2313671 2313671 defendant Dytemay Richard merchant 601694 601694 Dytemay, Richard, of Northam, merchant 3
4857305 2313672 2313672 defendant Byten- Richard merchant 601694 601694 Byten- Richard, of Northam, merchant 3
4862117 2315161 2315161 defendant Poddyng Robert merchant 601694 601694 Poddyng, Robert, of Northam, merchant 0
4868659 2317171 2317171 defendant Whitston Walter husbandman 601694 601694 Whitston, Walter, of Northam, husbandman 0
4868663 2317171 2317171 defendant Shillesford John husbandman 601694 601694 Shillesford, John, of Northam, husbandman 4
4868664 2317171 2317171 defendant Puddyng Robert husbandman 601694 601694 Puddyng, Robert, of Northam, husbandman 5
4875315 2319234 2319234 defendant Puddyng Robert mariner 601694 601694 Puddyng, Robert, of Northam, mariner 0
4875316 2319234 2319234 defendant Puttesham William chapman 601694 601694 Puttesham, William, of Northam, chapman 1
4876769 2319708 2319708 defendant Bysshope John, senior merchant 601694 601694 Bysshope, John, senior, of Northam, merchant 0
4876772 2319709 2319709 defendant Bysshoppe John, senior merchant 601694 601694 Bysshoppe, John, senior, of Northam, merchant 0
4876773 2319709 2319709 defendant Byschop John, junior merchant 601694 601694 Byschop, John, junior, of Northam, merchant 1

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