names

76 rows where place_id = 642361

✎ 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
3867498 1979363 1979363 defendant Crosse Robert fuller 642361 642361 Crosse, Robert, of Tiverton, fuller 0
3934207 2001735 2001735 defendant Toker Thomas husbandman 642361 642361 Toker, Thomas, of Tiverton, husbandman 1
3982865 2018647 2018647 plaintiff Shere William gent 642361 642361 Shere, William, of Tiverton, gent 0
4028109 2034705 2034705 plaintiff Colman Roger merchant 642361 642361 Colman, Roger, of Tiverton, merchant 0
4041930 2039601 2039601 defendant Lewsemore Robert gent 642361 642361 Lewsemore, Robert, of Tiverton, gent 1
4051251 2042887 2042887 defendant Fulforde Henry yeoman 642361 642361 Fulforde, Henry, of Tiverton, yeoman 0
4108190 2063195 2063195 defendant Crosse Hugh husbandman 642361 642361 Crosse, Hugh, of Tiverton, husbandman 1
4190633 2092286 2092286 defendant Kaylewaye Nicholas   642361 642361 Kaylewaye, Nicholas, of Tiverton, surgeon 3
4422201 2171815 2171815 defendant Feytz William   642361 642361 Feytz, William, of Tiverton 0
4432799 2175015 2175015 defendant Feytz William   642361 642361 Feytz, William, of Tiverton 0
4441346 2182229 2182229 defendant Cleye John   642361 642361 Cleye, John, of Tiverton 0
4445038 2183422 2183422 defendant Bakere John   642361 642361 Bakere, John, of Tiverton 0
4472769 2192152 2192152 defendant Goosse Richard   642361 642361 Goosse, Richard, of Tiverton 0
4473835 2192466 2192466 plaintiff Davell or Danell Nicholas   642361 642361 Davell or Danell, Nicholas, of Tiverton, warden of the chapel the the BM 0
4525803 2208372 2208372 defendant Helyer Walter   642361 642361 Helyer, Walter, of Tiverton 4
4563640 2220193 2220193 defendant Kyngman Richard   642361 642361 Kyngman, Richard, of Tiverton 1
4664082 2250253 2250253 defendant Webber John husbandman 642361 642361 Webber, John, of Tiverton, husbandman 5
4695319 2264017 2264017 defendant Gosse Richard husbandman 642361 642361 Gosse, Richard, of Tiverton, husbandman 1
4699045 2265171 2265171 defendant Child Adam   642361 642361 Child, Adam, of Tiverton, bailiff 1
4702404 2266163 2266163 defendant Allerford Henry   642361 642361 Allerford, Henry, of Tiverton, swine heler 3
4702406 2266163 2266163 defendant Allerford John chapman 642361 642361 Allerford, John, of Tiverton, chapman 5
4710386 2268603 2268603 defendant Rooke Walter   642361 642361 Rooke, Walter, of Tiverton, groom 1
4710387 2268603 2268603 defendant Squyer Hugh yeoman 642361 642361 Squyer, Hugh, of Tiverton, yeoman 2
4726457 2273555 2273555 defendant Notyng William tanner 642361 642361 Notyng, William, of Tiverton, tanner 2
4757124 2282600 2282600 defendant Mathon William   642361 642361 Mathon, William, of Tiverton 4
4757125 2282600 2282600 defendant Spirway William   642361 642361 Spirway, William, of Tiverton 5
4759032 2283177 2283177 defendant Symond William   642361 642361 Symond, William, of Tiverton 2
4775021 2288183 2288183 defendant Rowe Thomas fuller 642361 642361 Rowe, Thomas, of Tiverton, fuller 3
4811134 2299591 2299591 defendant Style John husbandman 642361 642361 Style, John, of Tiverton, husbandman 6
4811135 2299591 2299591 defendant Spyrway Robert   642361 642361 Spyrway, Robert, of Tiverton 7
4811136 2299591 2299591 defendant Spyreway William husbandman 642361 642361 Spyreway, William, of Tiverton, husbandman 8
4811137 2299591 2299591 defendant Clerk Richard husbandman 642361 642361 Clerk, Richard, of Tiverton, husbandman 9
4825136 2303903 2303903 defendant Sedburgh Robert husbandman 642361 642361 (Sedburgh, Robert, of Tiverton, husbandman 1
4829249 2305188 2305188 defendant Nottyng William tanner 642361 642361 Nottyng, William, of Tiverton, tanner 0
4841733 2308952 2308952 defendant Burnel Thomas husbandman 642361 642361 Burnel, Thomas, of Tiverton, husbandman 2
4843609 2309523 2309523 defendant Benet Thomas skinner 642361 642361 Benet, Thomas, of Tiverton, skinner 2
4843889 2309606 2309606 defendant Benet Thomas skinner 642361 642361 Benet, Thomas, of Tiverton, skinner 3
4908778 2329296 2329296 defendant (illegible) John baker 642361 642361 ----, John, of Tiverton, baker 2
4923589 2333812 2333812 defendant Spereweye William baker 642361 642361 Spereweye, William, of Tiverton, baker 2
4998118 2356300 2356300 defendant Nicoll William clerk 642361 642361 Nicoll, William, of Tiverton, clerk 0
5009215 2359580 2359580 defendant Tayllour William tailor 642361 642361 Tayllour, William, of Tiverton, tailor 0
5129348 2395072 2395072 plaintiff Curham John   642361 642361 Curham, John, of Tiverton 0
5142402 2398901 2398901 defendant Hempston Robert husbandman 642361 642361 Hempston, Robert, of Tiverton, husbandman 0
5148133 2400601 2400601 defendant Bayle John yeoman 642361 642361 Bayle, John, of Tiverton, yeoman 0
5148134 2400601 2400601 defendant Rowe Robert yeoman 642361 642361 Rowe, Robert, of Tiverton, yeoman 1
5148136 2400601 2400601 defendant Thorner John yeoman 642361 642361 Thorner, John, of Tiverton, yeoman 3
5148140 2400603 2400603 defendant Sampford Thomas gent 642361 642361 Sampford, Thomas, of Tiverton, gent 0
5148141 2400603 2400603 defendant Hobbes John gent 642361 642361 Hobbes, John, of Tiverton, gent 1
5148142 2400603 2400603 defendant Hillyng Richard tanner 642361 642361 Hillyng, Richard, of Tiverton, tanner 2
5148143 2400603 2400603 defendant Hengscote John gent 642361 642361 Hengscote, John, of Tiverton, gent 3
5148609 2400719 2400719 plaintiff Curham John   642361 642361 Curham, John, of Tiverton 0
5167570 2406242 2406242 defendant Hobbes John gent 642361 642361 Hobbes, John, of Tiverton, gent 0
5167571 2406242 2406242 defendant Hengscote John gent 642361 642361 Hengscote, John, of Tiverton, gent 1
5167572 2406242 2406242 defendant Sampford Thomas gent 642361 642361 together with Sampford, Thomas, of Tiverton, gent 2
5167573 2406242 2406242 defendant Hillyng Richard tanner 642361 642361 Hillyng, Richard, of Tiverton, tanner 3
5167854 2406311 2406311 plaintiff Curham John   642361 642361 Curham, John, of Tiverton 0
5181498 2410330 2410330 defendant Seylake William chaplain 642361 642361 Seylake, William, of Tiverton, chaplain 0
5182684 2410691 2410691 defendant Sele Thomas yeoman 642361 642361 Sele, Thomas, of Tiverton, yeoman 0
5183487 2410908 2410908 plaintiff Curham John baker 642361 642361 Curham, John, of Tiverton, baker 0
5187013 2411939 2411939 defendant Werthe Robert gent 642361 642361 Werthe, Robert, of Tiverton, gent 0
5203524 2416782 2416782 defendant Sele Thomas yeoman 642361 642361 Sele, Thomas, of Tiverton, yeoman 0
5203757 2416849 2416849 defendant Hobbes John gent 642361 642361 Hobbes, John, of Tiverton, gent 0
5203758 2416849 2416849 defendant Hengscote John gent 642361 642361 Hengscote, John, of Tiverton, gent 1
5203759 2416849 2416849 defendant Sampford Thomas gent 642361 642361 together with Sampford, Thomas, of Tiverton, gent 2
5203760 2416849 2416849 defendant Hillyng Richard tanner 642361 642361 Hillyng, Richard, of Tiverton, tanner 3
5205454 2417348 2417348 defendant Werthe Roger gent 642361 642361 Werthe, Roger, of Tiverton, gent 0
5207686 2417987 2417987 defendant Holme Thomas yeoman 642361 642361 Holme, Thomas, of Tiverton, yeoman 4
5210327 2418748 2418748 defendant Hygonson John yeoman 642361 642361 Hygonson, John, of Tiverton, yeoman 1
5270002 2436333 2436333 defendant Parker John yeoman 642361 642361 Parker, John, of Tiverton, yeoman 0
5428840 2483541 2483541 defendant Halsmyth Thomas chapman 642361 642361 Halsmyth, Thomas, of Tiverton, chapman 0
5469182 2495712 2495712 defendant Jauncelyn Robert merchant 642361 642361 Jauncelyn, Robert, of Tiverton, merchant 2
5474288 2497289 2497289 defendant Rede John tailor 642361 642361 Rede, John, of Tiverton, tailor 2
5474289 2497289 2497289 defendant Prous Hugh laborer 642361 642361 Prous, Hugh, of Tiverton, laborer 3
5474291 2497289 2497289 defendant Cordener David yeoman 642361 642361 Cordener, David, of Tiverton, yeoman 5
5474588 2497379 2497379 defendant Water John yeoman 642361 642361 Water, John, of Tiverton, yeoman 0
5475211 2497572 2497572 defendant Roper Henry merchant 642361 642361 Roper, Henry, of Tiverton, merchant 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);