names

93 rows where place_id = 587117

✎ 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
3590514 1864676 1864676 defendant Austyn William husbandman 587117 587117 Austyn, William, of Topsham, husbandman 4
3636114 1906088 1906088 defendant Tayllour Peter merchant 587117 587117 Tayllour, Peter, of Topsham, merchant 0
3636320 1906150 1906150 defendant Squyer John merchant 587117 587117 Squyer, John, of Topsham, merchant 0
3646513 1909309 1909309 defendant Coyle Thomas merchant 587117 587117 Coyle, Thomas, of Topsham, merchant 0
3707911 1928772 1928772 plaintiff Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3722485 1933292 1933292 plaintiff Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3753391 1942998 1942998 defendant Langemede Nicholas merchant 587117 587117 Langemede, Nicholas, of Topsham, merchant 0
3755178 1943570 1943570 defendant Trerewe Thomas   587117 587117 Trerewe, Thomas, of Topsham, groom 0
3755180 1943571 1943571 defendant Trerewe Thomas   587117 587117 Trerewe, Thomas, of Topsham, groom 0
3771908 1948905 1948905 defendant Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3771909 1948905 1948905 defendant Peter Thomas chaplain 587117 587117 Peter, Thomas, of Topsham, chaplain 1
3775833 1950191 1950191 defendant Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3775839 1950194 1950194 defendant Tayler Peter (legal representative) 587117 587117 Tayler, Peter, of Topsham, merchant, administratrix of 0
3775840 1950194 1950194 defendant Tayler Alice widow 587117 587117 Tayler, Alice, of Topsham, widow 1
3777410 1950681 1950681 defendant Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3784723 1953011 1953011 plaintiff Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3789704 1954610 1954610 defendant Wagotte William yeoman 587117 587117 Wagotte, William, of Topsham, yeoman 0
3791537 1955192 1955192 defendant Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3824828 1965643 1965643 defendant Michell Roger merchant 587117 587117 Michell, Roger, of Topsham, merchant 0
3884952 1985233 1985233 plaintiff Avery John (legal representative) 587117 587117 Avery, John, of Topsham, merchant, executors of 0
3933863 2001621 2001621 defendant Holfort Robert merchant 587117 587117 Holfort, Robert, of Topsham, merchant 2
3934809 2001942 2001942 defendant Holland William esq 587117 587117 Holland, William, of Topsham, esq 0
3950268 2007180 2007180 plaintiff Frye alias Howper William (legal representative) 587117 587117 Frye alias Howper, William, of Topsham, administratrix of 0
3950269 2007180 2007180 plaintiff Frye alias Howper Joan widow 587117 587117 Frye alias Howper, Joan, of Topsham, widow 1
3957708 2009754 2009754 defendant Thomas John merchant 587117 587117 Thomas, John, of Topsham, merchant 0
4052911 2043475 2043475 defendant Holland Andrew   587117 587117 Holland, Andrew, of Topsham, gent, his son 1
4206339 2097762 2097762 defendant Byrche Evilina or Emlina widow 587117 587117 Byrche, Evilina or Emlina, of Topsham, widow 1
4215841 2101038 2101038 defendant Rowe Thomas yeoman 587117 587117 Rowe, Thomas, of Topsham, yeoman 0
4229806 2105909 2105909 defendant Paidge alias Saunder John husbandman 587117 587117 Paidge alias Saunder, John, of Topsham, husbandman 0
4260135 2116353 2116353 defendant Paidge alias Saunder John husbandman 587117 587117 Paidge alias Saunder, John, of Topsham, husbandman 0
4304984 2131883 2131883 defendant Drake Philip gent 587117 587117 Drake, Philip, of Topsham, gent 0
4326702 2139286 2139286 defendant White Thomas mariner 587117 587117 White, Thomas, of Topsham, mariner 0
4364571 2152386 2152386 defendant Pepputt Gilbert merchant 587117 587117 Pepputt, Gilbert, of Topsham, merchant 0
4389788 2161208 2161208 defendant Dowrishe Richard yeoman 587117 587117 Dowrishe, Richard, of Topsham, yeoman 0
4391414 2161745 2161745 defendant Peppyt Gilbert merchant 587117 587117 Peppyt, Gilbert, of Topsham, merchant 0
4544445 2214174 2214174 defendant Neel Richard   587117 587117 Neel, Richard, of Topsham 1
4588711 2227850 2227850 defendant Neel Richard   587117 587117 Neel, Richard, of Topsham 0
4600801 2231475 2231475 defendant Coil Raymond   587117 587117 Coil, Raymond, of Topsham 0
4689109 2262154 2262154 defendant Neell Richard, junior   587117 587117 Neell, Richard, junior, of Topsham 0
4725341 2273217 2273217 defendant Elyot Edward mariner 587117 587117 Elyot, Edward, of Topsham, mariner 0
4760326 2283581 2283581 defendant Smalhill William yeoman 587117 587117 Smalhill, William, of Topsham, yeoman 1
4761553 2283958 2283958 defendant Poyer Robert husbandman 587117 587117 Poyer, Robert, of Topsham, husbandman 0
4769905 2286558 2286558 defendant Forton Richard yeoman 587117 587117 Forton, Richard, of Topsham, yeoman 0
4771986 2287213 2287213 defendant Furton Richard chapman 587117 587117 Furton, Richard, of Topsham, chapman 0
4784919 2291293 2291293 defendant Poyer Robert husbandman 587117 587117 Poyer, Robert, of Topsham, husbandman 0
4785399 2291451 2291451 defendant Coyle John chapman 587117 587117 Coyle, John, of Topsham, chapman 0
4788886 2292577 2292577 defendant Poyer Robert husbandman 587117 587117 Poyer, Robert, of Topsham, husbandman 0
4865390 2316143 2316143 defendant Power Rober yeoman 587117 587117 Power, Rober, of Topsham, yeoman 2
4871913 2318192 2318192 defendant Ludlowe William husbandman 587117 587117 Ludlowe, William, of Topsham, husbandman 3
4881563 2321134 2321134 defendant Crook John merchant 587117 587117 Crook, John, of Topsham, merchant 0
4884729 2322127 2322127 defendant Power Robert yeoman 587117 587117 Power, Robert, of Topsham, yeoman 2
4917478 2331981 2331981 defendant Jolyf Edward merchant 587117 587117 Jolyf, Edward, of Topsham, merchant 0
4917588 2332016 2332016 defendant Jolyff Edward merchant 587117 587117 Jolyff, Edward, of Topsham, merchant 1
4944111 2340127 2340127 defendant Hampton Edward merchant 587117 587117 Hampton, Edward, of Topsham, merchant 0
4960295 2345052 2345052 defendant Coyll Agnes widow 587117 587117 (Coyll, Agnes, of Topsham, widow 4
4960296 2345052 2345052 defendant Coyll Thomas   587117 587117 Coyll, Thomas, of Topsham, groom 5
4971061 2348284 2348284 defendant Bate William chaplain 587117 587117 Bate, William, of Topsham, chaplain 0
5114096 2390518 2390518 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5117990 2391692 2391692 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5121845 2392821 2392821 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5121847 2392822 2392822 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5131059 2395570 2395570 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5137571 2397503 2397503 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5143058 2399095 2399095 defendant Daly John merchant 587117 587117 Daly, John, of Topsham, merchant 0
5150566 2401307 2401307 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5158223 2403526 2403526 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5169036 2406675 2406675 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5173873 2408056 2408056 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5183488 2410908 2410908 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5185455 2411491 2411491 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 0
5198046 2415171 2415171 defendant Colwyll Nicholas yeoman 587117 587117 Colwyll, Nicholas, of Topsham, yeoman 2
5219385 2421395 2421395 defendant Taillour Richard merchant 587117 587117 Taillour, Richard, of Topsham, merchant 1
5252106 2430769 2430769 defendant Cardell John merchant 587117 587117 Cardell, John, of Topsham, merchant 0
5252292 2430827 2430827 defendant Davy John husbandman 587117 587117 Davy, John, of Topsham, husbandman 1
5256507 2432158 2432158 defendant Taylour Richard merchant 587117 587117 Taylour, Richard, of Topsham, merchant 7
5290351 2442183 2442183 defendant Davy John merchant 587117 587117 Davy, John, of Topsham, merchant 1
5333177 2454990 2454990 defendant Monyoye Thomas yeoman 587117 587117 Monyoye, Thomas, of Topsham, yeoman 0
5333894 2455211 2455211 defendant Bury Nicholas merchant 587117 587117 Bury, Nicholas, of Topsham, merchant 0
5369134 2465946 2465946 defendant Elys William roper 587117 587117 Elys, William, of Topsham, roper 0
5369310 2466003 2466003 defendant Elys William roper 587117 587117 Elys, William, of Topsham, roper 0
5378400 2468824 2468824 defendant Joan his wifel daughter & heir of Nicholas Colewyll   587117 587117 Joan, his wifel daughter & heir of Nicholas Colewyll, of Topsham 1
5426694 2482930 2482930 defendant Benet Thomas merchant 587117 587117 Benet, Thomas, of Topsham, merchant 0
5504638 2506369 2506369 defendant Taylor Denise widow 587117 587117 Taylor, Denise, of Topsham, widow 4
5505432 2506614 2506614 defendant Lewer William yeoman 587117 587117 Lewer, William, of Topsham, yeoman 0
5520121 2511117 2511117 defendant Long Nicholas tailor 587117 587117 Long, Nicholas, of Topsham, tailor 1
5532917 2514836 2514836 plaintiff Wagot John   587117 587117 Wagot, John, of Topsham 0
5532919 2514837 2514837 plaintiff Wagot William   587117 587117 Wagot, William, of Topsham 0
5548307 2519535 2519535 defendant Gryspyn Robert weaver 587117 587117 Gryspyn, Robert, of Topsham, weaver 0
5578057 2528206 2528206 defendant Moyne Robert merchant 587117 587117 Moyne, Robert, of Topsham, merchant 0
5585041 2530392 2530392 defendant Coke William husbandman 587117 587117 Coke, William, of Topsham, husbandman 1
5593345 2532897 2532897 defendant Moyne Robert merchant 587117 587117 Moyne, Robert, of Topsham, merchant 0
5631042 2553716 2553716 defendant Power Robert fisher 587117 587117 Power, Robert, of Topsham, fisher 1
5631046 2553717 2553717 defendant Power Robert fisher 587117 587117 Power, Robert, of Topsham, fisher 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);