names

101 rows where place_id = 689836

✎ 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
4082148 2053923 2053923 defendant Stanlock John yeoman 689836 689836 Stanlock, John, of Warminster, yeoman 0
4147330 2077204 2077204 defendant Townsend John baker 689836 689836 Townsend, John, of Warminster, baker 0
4177918 2087750 2087750 defendant Burgeman John tailor 689836 689836 Burgeman, John, of Warminster, tailor 1
4179809 2088414 2088414 defendant Carpenter John yeoman 689836 689836 Carpenter, John, of Warminster, yeoman 0
4219164 2102198 2102198 defendant Mathewe Lawrence chapman 689836 689836 Mathewe, Lawrence, of Warminster, chapman 3
4232554 2106890 2106890 defendant Wick William gent 689836 689836 Wick, William, of Warminster, gent 0
4250859 2113266 2113266 defendant Burge alias Hillesden William butcher 689836 689836 Burge alias Hillesden, William, of Warminster, butcher 0
4252039 2113672 2113672 defendant Howse Robert clothier 689836 689836 Howse, Robert, of Warminster, clothier 0
4290063 2126511 2126511 defendant Garratt William yeoman 689836 689836 Garratt, William, of Warminster, yeoman 0
4290064 2126511 2126511 defendant Doorn William yeoman 689836 689836 Doorn, William, of Warminster, yeoman 1
4455513 2186729 2186729 defendant Robetbemond Roger   689836 689836 Robetbemond, Roger, of Warminster 0
4470308 2191361 2191361 defendant Page John   689836 689836 Page, John, of Warminster 0
4478995 2194093 2194093 plaintiff Hopere John   689836 689836 Hopere, John, of Warminster 0
4480636 2194608 2194608 defendant Prentys John   689836 689836 Prentys, John, of Warminster 4
4480641 2194610 2194610 defendant Thorn William   689836 689836 Thorn, William, of Warminster 0
4584909 2226712 2226712 defendant Carpenter John   689836 689836 Carpenter, John, of Warminster 0
4598485 2230762 2230762 defendant Gardyner Philip   689836 689836 Gardyner, Philip, of Warminster 5
4636002 2242093 2242093 defendant Goldsmyth Nicholas   689836 689836 Goldsmyth, Nicholas, of Warminster 0
4707697 2267772 2267772 defendant Bryt Edward husbandman 689836 689836 Bryt, Edward, of Warminster, husbandman 0
4712281 2269155 2269155 plaintiff Shirwyn Roger   689836 689836 Shirwyn, Roger, of Warminster 0
4722910 2272483 2272483 defendant Bonebroke Thomas laborer 689836 689836 Bonebroke, Thomas, of Warminster, laborer 0
4727373 2273811 2273811 defendant Squyer John dyer 689836 689836 Squyer, John, of Warminster, dyer 0
4731176 2274951 2274951 defendant Brit Edward husbandman 689836 689836 Brit, Edward, of Warminster, husbandman 0
4733920 2275794 2275794 defendant Whistley Richard   689836 689836 Whistley, Richard, of Warminster, bailiff 1
4763570 2284591 2284591 defendant Boteler John yeoman 689836 689836 Boteler, John, of Warminster, yeoman 0
4765264 2285118 2285118 defendant Horner Thomas gent 689836 689836 Horner, Thomas, of Warminster, gent 0
4773493 2287680 2287680 defendant Gylys Stephen   689836 689836 Gylys, Stephen, of Warminster, shoe maker 2
4773731 2287757 2287757 defendant Mortymer John yeoman 689836 689836 Mortymer, John, of Warminster, yeoman 1
4774981 2288171 2288171 defendant Eston Robert fuller 689836 689836 Eston, Robert, of Warminster, fuller 0
4774982 2288171 2288171 defendant Parys John weaver 689836 689836 Parys, John, of Warminster, weaver 1
4775519 2288335 2288335 defendant Wormeslowe Thomas tailor 689836 689836 Wormeslowe, Thomas, of Warminster, tailor 1
4807475 2298532 2298532 plaintiff Cokeman Roger draper 689836 689836 Cokeman, Roger, of Warminster, draper, on his own account 0
4807477 2298532 2298532 defendant Hobbes John laborer 689836 689836 Hobbes, John, of Warminster, laborer 1
4807496 2298538 2298538 defendant Forthward William husbandman 689836 689836 Forthward, William, of Warminster, husbandman 1
4808635 2298864 2298864 defendant Hyguns Edward fuller 689836 689836 Hyguns, Edward, of Warminster, fuller 0
4814240 2300557 2300557 defendant Hornere John husbandman 689836 689836 Hornere, John, of Warminster, husbandman 0
4817011 2301420 2301420 defendant Prentys William tanner 689836 689836 Prentys, William, of Warminster, tanner 2
4820967 2302644 2302644 defendant Bovebroke or Bonebroke Thomas laborer 689836 689836 Bovebroke or Bonebroke, Thomas, of Warminster, laborer 0
4821386 2302772 2302772 defendant Horner John husbandman 689836 689836 Horner, John, of Warminster, husbandman 0
4823612 2303477 2303477 defendant Squyer John husbandman 689836 689836 Squyer, John, of Warminster, husbandman 2
4842855 2309306 2309306 defendant Dyer John dyer 689836 689836 Dyer, John, of Warminster, dyer 0
4846812 2310510 2310510 defendant Wormeslowe Richard tanner 689836 689836 Wormeslowe, Richard, of Warminster, tanner 4
4847682 2310768 2310768 defendant Dyer John husbandman 689836 689836 Dyer, John, of Warminster, husbandman 0
4852353 2312158 2312158 defendant Boucher John husbandman 689836 689836 Boucher, John, of Warminster, husbandman 2
4852359 2312159 2312159 defendant Boucher John husbandman 689836 689836 Boucher, John, of Warminster, husbandman 4
4918103 2332180 2332180 defendant Horner John husbandman 689836 689836 Horner, John, of Warminster, husbandman 0
4918104 2332180 2332180 defendant Strotele John lalborer 689836 689836 Strotele, John, of Warminster, lalborer 1
4922362 2333404 2333404 defendant Bedford Richard   689836 689836 Bedford, Richard, of Warminster, mason 1
4987021 2353060 2353060 defendant Dyer John dyer 689836 689836 Dyer, John, of Warminster, dyer 2
4990959 2354185 2354185 defendant Feltham William (legal representative) 689836 689836 Feltham, William, of Warminster, executors of 0
4993134 2354828 2354828 defendant Page Richard yeoman 689836 689836 Page, Richard, of Warminster, yeoman 0
4993135 2354828 2354828 defendant Wodehouse Andrew husbandman 689836 689836 Wodehouse, Andrew, of Warminster, husbandman 1
4993136 2354828 2354828 defendant Thriske Richard clerk 689836 689836 Thriske, Richard, of Warminster, clerk 2
4993137 2354828 2354828 defendant Curteys Thomas yeoman 689836 689836 Curteys, Thomas, of Warminster, yeoman 3
4993624 2354966 2354966 defendant Wyr John hoper 689836 689836 Wyr, John, of Warminster, hoper 0
4995557 2355511 2355511 plaintiff Gillewhite William   689836 689836 Gillewhite, William, of Warminster 0
4995964 2355642 2355642 defendant Horner Thomas gent 689836 689836 Horner, Thomas, of Warminster, gent 0
4998069 2356284 2356284 defendant Blaunchard Thomas gent 689836 689836 Blaunchard, Thomas, of Warminster, gent 0
4998088 2356292 2356292 defendant Horner Thomas gent 689836 689836 Horner, Thomas, of Warminster, gent 0
5000522 2357023 2357023 defendant Brynte Thomas gent 689836 689836 Brynte, Thomas, of Warminster, gent 0
5001501 2357330 2357330 defendant Page Richard yeoman 689836 689836 Page, Richard, of Warminster, yeoman 0
5001503 2357331 2357331 defendant Byngley George clothier 689836 689836 Byngley, George, of Warminster, clothier 0
5003544 2357932 2357932 defendant Horner Thomas gent 689836 689836 Horner, Thomas, of Warminster, gent 0
5004471 2358206 2358206 defendant Byngeley George dyer 689836 689836 Byngeley, George, of Warminster, dyer 0
5006438 2358781 2358781 defendant Skute John chapman 689836 689836 Skute, John, of Warminster, chapman 1
5010777 2360005 2360005 defendant Wodehous Andrew husbandman 689836 689836 Wodehous, Andrew, of Warminster, husbandman 0
5010778 2360005 2360005 defendant Benet John   689836 689836 Benet, John, of Warminster, mill ward 1
5045446 2370268 2370268 defendant Chafyn Thomas mercer 689836 689836 Chafyn, Thomas, of Warminster, mercer 1
5045448 2370268 2370268 defendant Vicary Margery husbandman 689836 689836 Vicary, Margery, of Warminster, formerly wife of John Vicary, husbandman 3
5050740 2371846 2371846 defendant Beche Nicholas husbandman 689836 689836 with Beche, Nicholas, of Warminster, husbandman 1
5050745 2371847 2371847 defendant Beche Nicholas husbandman 689836 689836 Beche, Nicholas, of Warminster, husbandman 0
5151506 2401589 2401589 defendant Hemmyng Walter weaver 689836 689836 Hemmyng, Walter, of Warminster, weaver 4
5169626 2406852 2406852 defendant Hemyng Walter weaver 689836 689836 Hemyng, Walter, of Warminster, weaver 4
5210550 2418824 2418824 defendant Page Richard gent 689836 689836 Page, Richard, of Warminster, gent 0
5210714 2418866 2418866 defendant Byngley George weaver 689836 689836 Byngley, George, of Warminster, weaver 3
5267976 2435747 2435747 defendant Baker John chapman 689836 689836 Baker, John, of Warminster, chapman 4
5377732 2468619 2468619 defendant Felond John yeoman 689836 689836 Felond, John, of Warminster, yeoman 2
5398363 2474596 2474596 defendant Braye Robert chapman 689836 689836 Braye, Robert, of Warminster, chapman 2
5398376 2474598 2474598 defendant Brace Robert chapman 689836 689836 Brace, Robert, of Warminster, chapman 2
5403371 2476038 2476038 defendant D--n John mercer 689836 689836 D--n, John, of Warminster, mercer 3
5407779 2477304 2477304 defendant Bray Robert merchant 689836 689836 Bray, Robert, of Warminster, merchant 0
5411516 2478401 2478401 defendant Bray Robert chapman 689836 689836 Bray, Robert, of Warminster, chapman 1
5412503 2478686 2478686 defendant Brent William gent 689836 689836 Brent, William, of Warminster, gent 0
5412504 2478686 2478686 defendant Dyngley (illegible) yeoman 689836 689836 Dyngley, _, of Warminster, yeoman 1
5416421 2479829 2479829 defendant Braye Robert mercer 689836 689836 Braye, Robert, of Warminster, mercer 0
5417737 2480230 2480230 defendant Brent William gent 689836 689836 Brent, William, of Warminster, gent 0
5417738 2480230 2480230 defendant Tytte Thomas weaver 689836 689836 Tytte, Thomas, of Warminster, weaver 1
5417739 2480230 2480230 defendant Bregge Henry laborer 689836 689836 Bregge, Henry, of Warminster, laborer 2
5420999 2481210 2481210 defendant Bray Robert merchant 689836 689836 Bray, Robert, of Warminster, merchant 0
5423148 2481882 2481882 defendant Ora_ William butcher 689836 689836 Ora_, William, of Warminster, butcher 2
5435201 2485456 2485456 defendant Brent William gent 689836 689836 Brent, William, of Warminster, gent 0
5435202 2485456 2485456 defendant Tytte Thomas weaver 689836 689836 Tytte, Thomas, of Warminster, weaver 1
5435203 2485456 2485456 defendant Bregge Henry laborer 689836 689836 Bregge, Henry, of Warminster, laborer 2
5442580 2487696 2487696 defendant Oram William   689836 689836 Oram, William, of Warminster 2
5447596 2489153 2489153 defendant Chasyn Thomas yeoman 689836 689836 Chasyn, Thomas, of Warminster, yeoman 0
5455296 2491501 2491501 defendant Oram William   689836 689836 Oram, William, of Warminster 2
5456431 2491844 2491844 plaintiff Chafyn George mercer 689836 689836 Chafyn, George, of Warminster, mercer 0
5460015 2492927 2492927 defendant Chafyn Thomas yeoman 689836 689836 Chafyn, Thomas, of Warminster, yeoman 0
5460026 2492930 2492930 defendant Chafyn Thomas yeoman 689836 689836 Chafyn, Thomas, of Warminster, yeoman 0
5467106 2495108 2495108 defendant Oram William butcher 689836 689836 Oram, William, of Warminster, butcher 2

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