names

149 rows where place_id = 596420

✎ 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
3624688 1875260 1875260 defendant Baten Robert clothman 596420 596420 Baten, Robert, of Somerset, clothman 0
3709416 1929245 1929245 plaintiff Pycher William   596420 596420 Pycher, William, of Somerset 0
3725377 1934229 1934229 plaintiff Sorigge Henry yeoman 596420 596420 Sorigge, Henry, of Somerset, yeoman 0
3725378 1934229 1934229 plaintiff Watterson Thomas yeoman 596420 596420 Watterson, Thomas, of Somerset, yeoman 1
3845681 1972195 1972195 defendant Vycary Robert husbandman 596420 596420 Vycary, Robert, of Somerset, husbandman 0
3853795 1974819 1974819 plaintiff Staynyng Walter esq 596420 596420 Staynyng, Walter, of Somerset, esq 0
3938390 2003182 2003182 plaintiff Pyard George cothman 596420 596420 Pyard, George, of Somerset, cothman 0
3966459 2012903 2012903 defendant Blackborowe William clothier 596420 596420 Blackborowe, William, of Somerset, clothier 1
3968656 2013677 2013677 plaintiff Cleves James clothier 596420 596420 Cleves, James, of Somerset, clothier 0
3968860 2013737 2013737 plaintiff Cogan Thomas clothier 596420 596420 Cogan, Thomas, of Somerset, clothier 0
3974658 2015704 2015704 defendant Foster James yeoman 596420 596420 Foster, James, of Somerset, yeoman 1
4005184 2026632 2026632 plaintiff Kenne John   596420 596420 Kenne, John, of Somerset 0
4034723 2037100 2037100 plaintiff Hatton William (legal representative) 596420 596420 Hatton, William, of Somerset, clerk, executrix of 0
4036552 2037757 2037757 plaintiff Hutten William (legal representative) 596420 596420 Hutten, William, of Somerset, clerk, executrix of 0
4097989 2059609 2059609 defendant Bonnam Robert gent 596420 596420 Bonnam, Robert, of Somerset, gent 0
4158069 2080891 2080891 defendant Buller John esq 596420 596420 Buller, John, of Somerset, esq 0
4240691 2109868 2109868 defendant Baker Richard gent 596420 596420 Baker, Richard, of Somerset, gent 3
4263707 2117520 2117520 defendant Baker Richard gent 596420 596420 Baker, Richard, of Somerset, gent 3
4332449 2141143 2141143 plaintiff Serchfyld Nicholas yeoman 596420 596420 Serchfyld, Nicholas, of Somerset, yeoman 0
4401384 2165060 2165060 defendant Overton Thomas grocer 596420 596420 Overton, Thomas, of Somerset, grocer 1
4440054 2181815 2181815 defendant Durburgh Ralph   596420 596420 Durburgh, Ralph, of Somerset 0
4440060 2181817 2181817 defendant Durburgh Ralph   596420 596420 Durburgh, Ralph, of Somerset 0
4441322 2182222 2182222 defendant Bokerell John   596420 596420 Bokerell, John, of Somerset 0
4441326 2182223 2182223 defendant Bokerell Henry   596420 596420 Bokerell, Henry, of Somerset 1
4448244 2184369 2184369 defendant Cherde John   596420 596420 Cherde, John, of Somerset 2
4449917 2184930 2184930 defendant Bokerell John   596420 596420 Bokerell, John, of Somerset 1
4449923 2184931 2184931 defendant Bokerell John   596420 596420 Bokerell, John, of Somerset 1
4460954 2188495 2188495 defendant Welyngton Thomas   596420 596420 Welyngton, Thomas, of Somerset 0
4465810 2189977 2189977 defendant Chippelegh Thomas   596420 596420 Chippelegh, Thomas, of Somerset 0
4479397 2194209 2194209 defendant Pap John   596420 596420 Pap, John, of Somerset 0
4481550 2194927 2194927 defendant Homere Andrew (legal representative) 596420 596420 Homere, Andrew, of Somerset, executors of 0
4481565 2194932 2194932 defendant Homere Andrew (legal representative) 596420 596420 Homere, Andrew, of Somerset, executors of 0
4482566 2195250 2195250 defendant Govudenham John esq 596420 596420 Govudenham, John, of Somerset, esq 0
4485878 2196290 2196290 defendant Inglyssh Henry esq 596420 596420 Inglyssh, Henry, of Somerset, esq 0
4489481 2197431 2197431 defendant Raley John   596420 596420 (Raley, John, of Somerset 1
4489485 2197432 2197432 defendant Raley John   596420 596420 (Raley, John, of Somerset 1
4492935 2198494 2198494 defendant Jurdon John (legal representative) 596420 596420 Jurdon, John, of Somerset, executor of 0
4500689 2200832 2200832 defendant Murywether John   596420 596420 Murywether, John, of Somerset 0
4506655 2202560 2202560 defendant Haukyn John   596420 596420 Haukyn, John, of Somerset 4
4506985 2202654 2202654 defendant Saltford Thomas   596420 596420 Saltford, Thomas, of Somerset 0
4511309 2203983 2203983 defendant Bowyere Walter   596420 596420 Bowyere, Walter, of Somerset 1
4511313 2203983 2203983 defendant Meriet John (legal representative) 596420 596420 Meriet, John, of Somerset, knight, executrix of 5
4513575 2204669 2204669 defendant Boys John   596420 596420 Boys, John, of Somerset 0
4513960 2204788 2204788 defendant Brewere John   596420 596420 Brewere, John, of Somerset 1
4516853 2205675 2205675 defendant Stocwode Thomas   596420 596420 Stocwode, Thomas, of Somerset 0
4518606 2206191 2206191 plaintiff Dole Richard   596420 596420 Dole, Richard, of Somerset 0
4533433 2210726 2210726 defendant Herde William   596420 596420 Herde, William, of Somerset 0
4534675 2211118 2211118 defendant Bryd Thomas   596420 596420 Bryd, Thomas, of Somerset 1
4535388 2211339 2211339 defendant Bryd Thomas   596420 596420 Bryd, Thomas, of Somerset 1
4535969 2211528 2211528 defendant Royere Roger   596420 596420 Royere, Roger, of Somerset 0
4535973 2211529 2211529 defendant Royere Roger   596420 596420 Royere, Roger, of Somerset 0
4536921 2211817 2211817 defendant Bolour Thomas   596420 596420 Bolour, Thomas, of Somerset 0
4537451 2211981 2211981 plaintiff Sydenham Henry   596420 596420 Sydenham, Henry, of Somerset 0
4542225 2213458 2213458 defendant atte Croft Alexander   596420 596420 atte Croft, Alexander, of Somerset 2
4545904 2214652 2214652 defendant Boche John   596420 596420 Boche, John, of Somerset 0
4547374 2215110 2215110 defendant Benet Richard   596420 596420 Benet, Richard, of Somerset 0
4549013 2215624 2215624 plaintiff Cokyr John   596420 596420 Cokyr, John, of Somerset 0
4549924 2215909 2215909 defendant Helston Philip   596420 596420 Helston, Philip, of Somerset 0
4551351 2216361 2216361 defendant Phipayn Elias   596420 596420 Phipayn, Elias, of Somerset 0
4551372 2216366 2216366 defendant Carlton William   596420 596420 Carlton, William, of Somerset 0
4552694 2216794 2216794 defendant Brooke John   596420 596420 Brooke, John, of Somerset 4
4562142 2219725 2219725 defendant Hone or Hove John   596420 596420 Hone or Hove, John, of Somerset 0
4563147 2220041 2220041 defendant Monk alias Mertok John   596420 596420 Monk alias Mertok, John, of Somerset 0
4563149 2220042 2220042 defendant Monk alias Mertok John   596420 596420 Monk alias Mertok, John, of Somerset 0
4570193 2222246 2222246 defendant Henton John merchant 596420 596420 Henton, John, of Somerset, merchant 0
4570853 2222451 2222451 defendant Jewe Edward   596420 596420 Jewe, Edward, of Somerset 0
4576584 2224187 2224187 plaintiff Bryt William   596420 596420 Bryt, William, of Somerset 0
4578854 2224866 2224866 defendant Wade John   596420 596420 Wade, John, of Somerset 0
4579360 2225024 2225024 defendant Malet Baldwin   596420 596420 Malet, Baldwin, of Somerset, knight 1
4579367 2225025 2225025 defendant Malet Baldewin   596420 596420 Malet, Baldewin, of Somerset, knight 1
4579832 2225177 2225177 defendant Stokes John   596420 596420 Stokes, John, of Somerset 3
4581650 2225709 2225709 defendant Mavyle William   596420 596420 Mavyle, William, of Somerset 2
4581658 2225710 2225710 defendant Mavyle William   596420 596420 Mavyle, William, of Somerset 2
4582675 2226022 2226022 defendant Wyke William   596420 596420 Wyke, William, of Somerset 0
4582676 2226022 2226022 defendant Grene Richard   596420 596420 Grene, Richard, of Somerset 1
4582678 2226022 2226022 defendant Denebaud John   596420 596420 Denebaud, John, of Somerset 3
4590690 2228444 2228444 defendant Haukyn William   596420 596420 Haukyn, William, of Somerset 1
4597301 2230396 2230396 defendant Arour John esq 596420 596420 Arour, John, of Somerset, esq 5
4597310 2230397 2230397 defendant Artour John esq 596420 596420 Artour, John, of Somerset, esq 5
4599214 2230967 2230967 plaintiff Stokes John   596420 596420 Stokes, John, of Somerset 0
4599780 2231153 2231153 defendant Clyvedon Alexander   596420 596420 Clyvedon, Alexander, of Somerset 0
4600217 2231297 2231297 defendant Carent William   596420 596420 Carent, William, of Somerset 0
4600219 2231298 2231298 defendant Carnet William   596420 596420 Carnet, William, of Somerset 0
4603324 2232236 2232236 defendant Chideok Richard (legal representative) 596420 596420 Chideok, Richard, of Somerset, executors of 6
4610430 2234338 2234338 defendant Wodeward John   596420 596420 Wodeward, John, of Somerset 0
4611255 2234583 2234583 defendant Chokke John   596420 596420 Chokke, John, of Somerset 2
4611259 2234584 2234584 defendant Shokke John   596420 596420 Shokke, John, of Somerset 2
4612115 2234857 2234857 plaintiff Cookys John   596420 596420 Cookys, John, of Somerset 0
4612121 2234857 2234857 defendant Caus John   596420 596420 Caus, John, of Somerset, administrators of 5
4613545 2235253 2235253 defendant Artur John esq 596420 596420 Artur, John, of Somerset, esq 3
4613551 2235254 2235254 defendant Artur John esq 596420 596420 Artur, John, of Somerset, esq 3
4614225 2235461 2235461 defendant Sutton John   596420 596420 Sutton, John, of Somerset 1
4615520 2235857 2235857 defendant Penseford Margaret   596420 596420 Penseford, Margaret, of Somerset 3
4615528 2235858 2235858 defendant Penseford Margaret   596420 596420 Penseford, Margaret, of Somerset 3
4616306 2236093 2236093 defendant Gorges Thomas (legal representative) 596420 596420 Gorges, Thomas, of Somerset, esq, executors of 0
4616314 2236094 2236094 defendant Gorges Thomas (legal representative) 596420 596420 Gorges, Thomas, of Somerset, executors of 0
4616878 2236281 2236281 defendant Horsey John esq 596420 596420 Horsey, John, of Somerset, esq 0
4616880 2236282 2236282 defendant Horsey John esq 596420 596420 Horsey, John, of Somerset, esq 0
4617366 2236446 2236446 defendant Olyver Robert esq 596420 596420 Olyver, Robert, of Somerset, esq 0
4620470 2237383 2237383 defendant Brid John   596420 596420 Brid, John, of Somerset 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);