names

95 rows where place_id = 597868

✎ 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
3630166 1904284 1904284 defendant Symmys John yeoman 597868 597868 Symmys, John, of Chard, yeoman 0
3630168 1904285 1904285 defendant Symmys John yeoman 597868 597868 Symmys, John, of Chard, yeoman 0
3643681 1908451 1908451 defendant Sheperd John mercer 597868 597868 Sheperd, John, of Chard, mercer 0
3674893 1918178 1918178 defendant Whitehorne William dyer 597868 597868 Whitehorne, William, of Chard, dyer 0
3698665 1925799 1925799 defendant Percy Robert husbandman 597868 597868 Percy, Robert, of Chard, husbandman 2
3704299 1927644 1927644 defendant Lumbard Thomas husbandman 597868 597868 Lumbard, Thomas, of Chard, husbandman 1
3711112 1929788 1929788 defendant Whythorn William yeoman 597868 597868 Whythorn, William, of Chard, yeoman 1
3711713 1929976 1929976 defendant Ivery John baker 597868 597868 Ivery, John, of Chard, baker 0
3717758 1931855 1931855 defendant Ivery John baker 597868 597868 Ivery, John, of Chard, baker 2
3720530 1932702 1932702 defendant Cogan Nicholas mercer 597868 597868 Cogan, Nicholas, of Chard, mercer 2
3768612 1947832 1947832 defendant Whithorne William dyer 597868 597868 Whithorne, William, of Chard, dyer 1
3768613 1947832 1947832 defendant Ivery John baker 597868 597868 Ivery, John, of Chard, baker 2
3884164 1984970 1984970 defendant Peter Robert merchant 597868 597868 Peter, Robert, of Chard, merchant 0
3893554 1988071 1988071 defendant Peter Robert merchant 597868 597868 Peter, Robert, of Chard, merchant 0
3893555 1988071 1988071 defendant Brewer John merchant 597868 597868 Brewer, John, of Chard, merchant 1
3902183 1990965 1990965 defendant Boysse George (legal representative) 597868 597868 Boysse, George, of Chard, executors of 1
3902184 1990965 1990965 defendant Waldren Humphrey gent 597868 597868 (Waldren, Humphrey, of Chard, gent 2
3907531 1992814 1992814 defendant Peter Robert merchant 597868 597868 Peter, Robert, of Chard, merchant 0
3957447 2009667 2009667 defendant Ley John   597868 597868 Ley, John, of Chard 1
4000067 2024790 2024790 defendant Clapp Nicholas tucker 597868 597868 Clapp, Nicholas, of Chard, tucker 0
4002130 2025544 2025544 defendant Pullman William merchant 597868 597868 Pullman, William, of Chard, merchant 1
4059017 2045621 2045621 plaintiff Cogan Thomas merchant 597868 597868 Cogan, Thomas, of Chard, merchant 0
4061860 2046638 2046638 plaintiff Ellesdon Joan widow 597868 597868 Joan his wife, formerly Joan Long, of Chard, widow 1
4074940 2051337 2051337 defendant Parker William sherman 597868 597868 Parker, William, of Chard, sherman 2
4098178 2059675 2059675 defendant Reade John   597868 597868 Reade, John, of Chard, or of Sherborne, Dorset, woollen draper 0
4112044 2064561 2064561 defendant Sprake John clothier 597868 597868 Sprake, John, of Chard, clothier 2
4123526 2068716 2068716 defendant Wyett John miller 597868 597868 Wyett, John, of Chard, or of Knitmill, Soms, miller 3
4131532 2071596 2071596 defendant Lumbarde George yeoman 597868 597868 Lumbarde, George, of Chard, or of Thorncome, Devon, yeoman 0
4131536 2071597 2071597 defendant Violet William draper 597868 597868 Violet, William, of Chard, yeoman, or of Charmouth, Dorset, draper 2
4131549 2071601 2071601 defendant Palmer Philip mariner 597868 597868 Palmer, Philip, of Chard, yeoman, or of Barnestaple, Devon, mariner 0
4138671 2074197 2074197 defendant Sydenham Richard esq 597868 597868 Sydenham, Richard, of Chard, or of Wynford Eagle, Dorset, esq 0
4138673 2074198 2074198 defendant Sydenham Thomas gent 597868 597868 Sydenham, Thomas, of Chard, gent 0
4155232 2079923 2079923 defendant Mudge Nicholas yeoman 597868 597868 Mudge, Nicholas, of Chard, yeoman 0
4168668 2084528 2084528 defendant Cleves John tucker 597868 597868 Cleves, John, of Chard, tucker 1
4173154 2086067 2086067 defendant Englishe Simon husbandman 597868 597868 Englishe, Simon, of Chard, or of North Petherton, husbandman 0
4173155 2086067 2086067 defendant Batt Robert husbandman 597868 597868 Batt, Robert, of Chard, or of North Petherton, husbandman 1
4173156 2086067 2086067 defendant Englishe John husbandman 597868 597868 Englishe, John, of Chard, or of North Petherton, husbandman 2
4173158 2086068 2086068 defendant Englishe Simon husbandman 597868 597868 Englishe, Simon, of Chard, or of North Petherton, husbandman 0
4173160 2086068 2086068 defendant Englishe John husbandman 597868 597868 Englishe, John, of Chard, or of North Petherton, husbandman 2
4176820 2087362 2087362 defendant Sprake Thomas clothier 597868 597868 Sprake, Thomas, of Chard, clothier 1
4179448 2088287 2088287 defendant Palmer Philip mariner 597868 597868 Palmer, Philip, of Chard, yeoman, or of Barnestaple, Devon, mariner 0
4180578 2088690 2088690 defendant Bort John draper 597868 597868 Bort, John, of Chard, yeoman, or of Montigewe, draper 0
4183562 2089734 2089734 defendant Wynterhaye Philip gent 597868 597868 Wynterhaye, Philip, of Chard, or of Lamporte, gent 0
4183565 2089735 2089735 defendant Master Copstan fletcher 597868 597868 Master, Copstan, of Chard, yeoman, or of Lamporte, fletcher 0
4184552 2090104 2090104 defendant Dowrishe Walter esq 597868 597868 Dowrishe, Walter, of Chard, esq 0
4185934 2090569 2090569 defendant Burston Clement tailor 597868 597868 Burston, Clement, of Chard, or of Pytminster, tailor 0
4185935 2090569 2090569 defendant Trenchard Thomas tailor 597868 597868 Trenchard, Thomas, of Chard, tailor 1
4185936 2090569 2090569 defendant Sennocke William yeoman 597868 597868 Sennocke, William, of Chard, yeoman 2
4185937 2090569 2090569 defendant Burston William husbandman 597868 597868 Burston, William, of Chard, or of Lawrence Liddier, husbandman 3
4194707 2093705 2093705 defendant Veysey Robert yeoman 597868 597868 Veysey, Robert, of Chard, or of Cardiff, yeoman 2
4202829 2096533 2096533 defendant Samford Richard merchant 597868 597868 Samford, Richard, of Chard, merchant 0
4230064 2106007 2106007 defendant Cogan Thomas clothier 597868 597868 Cogan, Thomas, of Chard, clothier 0
4243982 2110967 2110967 defendant Webber alias Osborne Thomas sherman 597868 597868 Webber alias Osborne, Thomas, of Chard, sherman 0
4251075 2113338 2113338 defendant Dossell Thomas yeoman 597868 597868 (Dossell, Thomas, of Chard, yeoman 1
4275414 2121336 2121336 defendant Sprake Richard merchant 597868 597868 Sprake, Richard, of Chard, merchant 0
4284860 2124632 2124632 defendant Sprake Richard merchant 597868 597868 Sprake, Richard, of Chard, merchant 0
4289543 2126324 2126324 defendant Sprate John clothier 597868 597868 Sprate, John, of Chard, clothier 1
4291367 2126986 2126986 defendant Cuttyver John husbandman 597868 597868 Cuttyver, John, of Chard, husbandman 2
4306555 2132429 2132429 defendant Upphall John (legal representative) 597868 597868 Upphall, John, of Chard, innkeeper, executrix of 0
4307545 2132776 2132776 defendant Bull Thomas husbandman 597868 597868 Bull, Thomas, of Chard, husbandman 0
4308245 2133035 2133035 defendant Syms William merchant 597868 597868 Syms, William, of Chard, merchant 0
4320379 2137228 2137228 defendant (not given) Edward vicar of Doughtie 597868 597868 Doughtie, Edward, of Chard, clerk, vicar of Banwell 0
4344210 2145254 2145254 defendant Parrys John merchant 597868 597868 Parrys, John, of Chard, merchant 0
4359105 2150419 2150419 defendant Court alias Parrys William gent 597868 597868 Court alias Parrys, William, of Chard, gent 0
4361595 2151310 2151310 defendant Pitterd Thomas haberdasher 597868 597868 Pitterd, Thomas, of Chard, haberdasher 0
4365378 2152681 2152681 defendant Cogan Philbert gent 597868 597868 Cogan, Philbert, of Chard, gent 0
4371294 2154798 2154798 defendant Dewnell Mellena victualer 597868 597868 Dewnell, Mellena, of Chard, victualer 0
4372830 2155361 2155361 defendant Barton John innholder 597868 597868 Barton, John, of Chard, innholder 0
4377589 2157062 2157062 defendant Cogan Philibert gent 597868 597868 Cogan, Philibert, of Chard, gent 0
4390857 2161555 2161555 defendant Wuett John husbandman 597868 597868 Wuett, John, of Chard, husbandman 3
4407914 2167211 2167211 defendant Upshawe John yeoman 597868 597868 Upshawe, John, of Chard, yeoman 0
4407915 2167211 2167211 defendant Furser or Vourser William carrier 597868 597868 Furser or Vourser, William, of Chard, carrier 1
4488256 2197044 2197044 plaintiff Janet John   597868 597868 Janet, John, of Chard 2
4532289 2210366 2210366 defendant Tanner Simon   597868 597868 Tanner, Simon, of Chard 3
4558190 2218503 2218503 defendant Deyman Richard   597868 597868 Deyman, Richard, of Chard 1
4597775 2230557 2230557 defendant Kervere John   597868 597868 Kervere, John, of Chard 0
4614512 2235545 2235545 defendant Baker William   597868 597868 Baker, William, of Chard 2
4644489 2244474 2244474 defendant Baker Thomas   597868 597868 Baker, Thomas, of Chard 0
4644491 2244474 2244474 defendant Fyssher Roger   597868 597868 Fyssher, Roger, of Chard 2
4693527 2263476 2263476 defendant Foxdych Nicholas dyer 597868 597868 Foxdych, Nicholas, of Chard, dyer 4
4706629 2267454 2267454 defendant Webber Walter husbandman 597868 597868 Webber, Walter, of Chard, husbandman 0
4706630 2267454 2267454 defendant Sadeler Walter husbandman 597868 597868 Sadeler, Walter, of Chard, husbandman 1
4720388 2271711 2271711 defendant Stronge Robert glasier 597868 597868 Stronge, Robert, of Chard, glasier 0
4725508 2273270 2273270 defendant Clouer Thomas   597868 597868 Clouer, Thomas, of Chard, glove maker 0
4730230 2274657 2274657 defendant Webber Walter husbandman 597868 597868 Webber, Walter, of Chard, husbandman 1
4755968 2282250 2282250 plaintiff Basset Richard   597868 597868 Basset, Richard, of Chard 0
4768872 2286245 2286245 defendant Codryngton Geoffrey chaplain 597868 597868 Codryngton, Geoffrey, of Chard, chaplain 0
5012297 2360450 2360450 defendant Harryes John husbandman 597868 597868 Harryes, John, of Chard, husbandman 0
5136833 2397295 2397295 defendant Covyte John clerk 597868 597868 Covyte, John, of Chard, clerk 5
5173335 2407910 2407910 defendant Govyce John clerk 597868 597868 Govyce, John, of Chard, clerk 5
5200844 2416008 2416008 defendant Parys William husbandman 597868 597868 Parys, William, of Chard, husbandman 0
5364888 2464687 2464687 defendant Sadeler William   597868 597868 Sadeler, William, of Chard, inn holder 1
5365857 2464975 2464975 defendant Crokker John (legal representative) 597868 597868 Crokker, John, of Chard, yeoman, executrix of 0
5384926 2470763 2470763 defendant Newport John yeoman 597868 597868 Newport, John, of Chard, yeoman 2
5392592 2472950 2472950 plaintiff Selw_ Nicholas   597868 597868 Selw_, Nicholas, of Chard 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);