names

53 rows where place_id = 766402

✎ 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
4527829 2208979 2208979 defendant Blebury Thomas   766402 766402 Blebury, Thomas, of Yeovil 1
4539638 2212658 2212658 defendant Bodeman John   766402 766402 Bodeman, John, of Yeovil 0
4648074 2245504 2245504 defendant Sele William   766402 766402 Sele, William, of Yeovil 0
4694646 2263823 2263823 defendant Blakford John   766402 766402 Blakford, John, of Yeovil, shoe maker 0
4694647 2263823 2263823 defendant Jamys John dyer 766402 766402 together with Jamys, John, of Yeovil, dyer 1
4694649 2263824 2263824 defendant Jamys John dyer 766402 766402 Jamys, John, of Yeovil, dyer 0
4695377 2264034 2264034 defendant Dyer James dyer 766402 766402 Dyer, James, of Yeovil, dyer 0
4698030 2264873 2264873 plaintiff Couke John   766402 766402 Couke, John, of Yeovil, shoe maker 0
4699253 2265233 2265233 plaintiff Dougge or Dongge Robert   766402 766402 Dougge or Dongge, Robert, of Yeovil 0
4704122 2266668 2266668 plaintiff Houper Stephen weaver 766402 766402 Houper, Stephen, of Yeovil, weaver 0
4704123 2266668 2266668 defendant Cole William ostler 766402 766402 Cole, William, of Yeovil, ostler 0
4704124 2266668 2266668 defendant Jakys Robert ostler 766402 766402 Jakys, Robert, of Yeovil, ostler 1
4706765 2267500 2267500 defendant Graunger William, sen   766402 766402 Graunger, William, sen, of Yeovil, franklin 0
4711179 2268848 2268848 defendant Pary John chapman 766402 766402 Pary, John, of Yeovil, chapman 1
4714723 2269934 2269934 defendant Lane John weaver 766402 766402 Lane, John, of Yeovil, weaver 0
4715643 2270222 2270222 defendant Blakeford Thomas leather worker 766402 766402 Blakeford, Thomas, of Yeovil, leather worker 0
4715663 2270226 2270226 defendant Lumbard William gent 766402 766402 Lumbard, William, of Yeovil, gent 1
4715664 2270226 2270226 defendant Melton William yeoman 766402 766402 Melton, William, of Yeovil, yeoman 2
4715665 2270226 2270226 defendant Manston Ralph husbandman 766402 766402 Manston, Ralph, of Yeovil, husbandman 3
4718753 2271205 2271205 defendant Dey John husbandman 766402 766402 Dey, John, of Yeovil, smith, Marchall, William, of Stoke Lynche, husbandman 2
4723664 2272707 2272707 plaintiff Dongge Robert   766402 766402 Dongge, Robert, of Yeovil 0
4757388 2282682 2282682 defendant Baker Peter baker 766402 766402 Baker, Peter, of Yeovil, baker 0
4757389 2282682 2282682 defendant Baker Edward baker 766402 766402 Baker, Edward, of Yeovil, baker 1
4760014 2283470 2283470 defendant C_ John ostler 766402 766402 C_, John, of Yeovil, ostler 0
4760015 2283470 2283470 defendant Buttanllour John chapman 766402 766402 Buttanllour, John, of Yeovil, chapman 1
4763412 2284544 2284544 defendant St_ Edward   766402 766402 St_, Edward, of Yeovil, brass worker 0
4767573 2285839 2285839 plaintiff Martyn William   766402 766402 Martyn, William, of Yeovil 0
4768052 2285975 2285975 defendant Barbour Richard barber 766402 766402 Barbour, Richard, of Yeovil, barber 0
4768053 2285975 2285975 defendant Barbour Henry   766402 766402 Barbour, Henry, of Yeovil, groom 1
4770319 2286687 2286687 defendant Cloke Felicia spinster 766402 766402 Cloke, Felicia, of Yeovil, spinster 2
4775455 2288320 2288320 defendant Wyseman Geoffrey chapman 766402 766402 Wyseman, Geoffrey, of Yeovil, chapman 1
4830267 2305503 2305503 plaintiff Beskean Thomas chapman 766402 766402 Beskean, Thomas, of Yeovil, chapman 0
4840716 2308635 2308635 plaintiff Houchyn John weaver 766402 766402 Houchyn, John, of Yeovil, weaver 0
4840717 2308635 2308635 defendant Kynge Robert weaver 766402 766402 Kynge, Robert, of Yeovil, weaver 0
4840732 2308638 2308638 plaintiff Houper_ Stephen chapman 766402 766402 Houper_, Stephen, of Yeovil, chapman 0
4842748 2309270 2309270 plaintiff Lotton William   766402 766402 Lotton, William, of Yeovil 0
4843265 2309410 2309410 defendant Ware William husbandman 766402 766402 Ware, William, of Yeovil, husbandman 2
4847708 2310777 2310777 plaintiff Rustesale Peter   766402 766402 Rustesale, Peter, of Yeovil 0
4847747 2310788 2310788 defendant Molton William   766402 766402 Molton, William, of Yeovil, administrators of 3
5000792 2357107 2357107 defendant Brian John merchant 766402 766402 Brian, John, of Yeovil, merchant 1
5125367 2393902 2393902 defendant Rooke Henry carrier 766402 766402 Rooke, Henry, of Yeovil, carrier 0
5127744 2394595 2394595 defendant Wode Robert dyer 766402 766402 Wode, Robert, of Yeovil, dyer 0
5146256 2400035 2400035 plaintiff Buyssh William   766402 766402 Buyssh, William, of Yeovil, cloth maker 0
5147157 2400305 2400305 defendant Bocher Thomas butcher 766402 766402 Bocher, Thomas, of Yeovil, butcher 1
5193365 2413787 2413787 defendant Spenser John gent 766402 766402 Spenser, John, of Yeovil, gent 0
5196873 2414835 2414835 defendant Aysshecombe Robert yeoman 766402 766402 Aysshecombe, Robert, of Yeovil, yeoman 0
5201066 2416073 2416073 defendant Goolde John yeoman 766402 766402 Goolde, John, of Yeovil, yeoman 1
5203468 2416768 2416768 defendant Axtill Willim tailor 766402 766402 Axtill, Willim, of Yeovil, tailor 0
5386923 2471323 2471323 defendant Boure Richard   766402 766402 Boure, Richard, of Yeovil 0
5407257 2477138 2477138 defendant Forte Thomas clerk 766402 766402 Forte, Thomas, of Yeovil, clerk 0
5470281 2496030 2496030 defendant Knyght Richard butcher 766402 766402 Knyght, Richard, of Yeovil, butcher 3
5473267 2496968 2496968 defendant Meryot Thomas   766402 766402 Meryot, Thomas, of Yeovil 0
5473269 2496968 2496968 defendant Scarlet Robert   766402 766402 Scarlet, Robert, of Yeovil 2

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