names

102 rows where place_id = 588791

✎ 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
3595608 1866254 1866254 plaintiff Milette William gent 588791 588791 Milette, William, of Derteford, gent 0
4443710 2183001 2183001 defendant Denys Geoffrey   588791 588791 Denys, Geoffrey, of Derteford 0
4449399 2184756 2184756 defendant Sony Richard   588791 588791 Sony, Richard, of Derteford 0
4466641 2190242 2190242 plaintiff Appelton Elizabeth   588791 588791 Appelton, Elizabeth, of Derteford, formerly wife of John 0
4468452 2190798 2190798 defendant Neuport John   588791 588791 Neuport, John, of Derteford 0
4472392 2192037 2192037 plaintiff Coke Thomas   588791 588791 Coke, Thomas, of Derteford 0
4472394 2192037 2192037 defendant Arnald William   588791 588791 Arnald, William, of Derteford 0
4482066 2195103 2195103 plaintiff Martyn Richard   588791 588791 Martyn, Richard, of Derteford 0
4495727 2199346 2199346 defendant Lesgrene Thomas   588791 588791 Lesgrene, Thomas, of Derteford 0
4547108 2215028 2215028 defendant Park Margery   588791 588791 Park, Margery, of Derteford 0
4558296 2218537 2218537 defendant Haukere Richard   588791 588791 Haukere, Richard, of Derteford 0
4558300 2218537 2218537 defendant Douse William   588791 588791 Douse, William, of Derteford 4
4568390 2221684 2221684 defendant Clement Richard   588791 588791 Clement, Richard, of Derteford 0
4592828 2229091 2229091 defendant Saundres Richard   588791 588791 Saundres, Richard, of Derteford 0
4592830 2229092 2229092 defendant Saundres Richard   588791 588791 Saundres, Richard, of Derteford 0
4627671 2239587 2239587 plaintiff Rothell William   588791 588791 Rothell, William, of Derteford 0
4646974 2245176 2245176 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4657364 2248194 2248194 defendant Rokisle Richard husbandman 588791 588791 Rokisle, Richard, of Derteford, husbandman 3
4681274 2259768 2259768 defendant Alkynbery John tailor 588791 588791 Alkynbery, John, of Derteford, tailor 0
4689629 2262316 2262316 defendant Bost John yeoman 588791 588791 Bost, John, of Derteford, yeoman 0
4750746 2280701 2280701 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford, on his own account 0
4776917 2288767 2288767 defendant Blythe John smith 588791 588791 Blythe, John, of Derteford, smith 0
4782672 2290595 2290595 plaintiff Coupere Richard   588791 588791 Coupere, Richard, of Derteford 0
4782673 2290595 2290595 defendant Boston John husbandman 588791 588791 Boston, John, of Derteford, or of Stanes, Middx, husbandman 0
4782729 2290614 2290614 defendant Dancastre William chapman 588791 588791 Dancastre, William, of Derteford, chapman 0
4791917 2293576 2293576 defendant Blythe John smith 588791 588791 Blythe, John, of Derteford, smith 0
4801008 2296505 2296505 defendant Haukere Thomas carpenter 588791 588791 Haukere, Thomas, of Derteford, carpenter 0
4801013 2296506 2296506 defendant Haukere Thomas carpenter 588791 588791 Haukere, Thomas, of Derteford, carpenter 0
4811606 2299738 2299738 defendant Tayllour John (legal representative) 588791 588791 Tayllour, John, of Derteford, executors of 0
4811607 2299738 2299738 defendant Burre Robert shoemaker 588791 588791 (Burre, Robert, of Derteford, shoemaker 1
4821337 2302754 2302754 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4867394 2316768 2316768 defendant Wappes Richard husbandman 588791 588791 Wappes, Richard, of Derteford, husbandman 0
4874800 2319061 2319061 defendant Rodle William yeoman 588791 588791 Rodle, William, of Derteford, yeoman 2
4875192 2319195 2319195 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4887413 2322902 2322902 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4897426 2325853 2325853 defendant Rotheley William yeoman 588791 588791 Rotheley, William, of Derteford, yeoman 0
4897436 2325858 2325858 defendant Rotheley Roger yeoman 588791 588791 Rotheley, Roger, of Derteford, yeoman 0
4900245 2326707 2326707 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4905681 2328377 2328377 defendant Holdewey John laborer 588791 588791 Holdewey, John, of Derteford, laborer 3
4911767 2330180 2330180 defendant Bryd Mary   588791 588791 Bryd, Mary, of Derteford, widow, formerly wife of John Bryd 1
4916213 2331575 2331575 defendant Revet Thomas husbandman 588791 588791 Revet, Thomas, of Derteford, husbandman 0
4916214 2331575 2331575 defendant Dene John husbandman 588791 588791 Dene, John, of Derteford, husbandman 1
4916215 2331575 2331575 defendant Potet Henry miller 588791 588791 Potet, Henry, of Derteford, miller 2
4927227 2334952 2334952 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4927228 2334952 2334952 defendant Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4935742 2337570 2337570 plaintiff Best John   588791 588791 Best, John, of Derteford 0
4937849 2338219 2338219 defendant Chapman John butcher 588791 588791 Chapman, John, of Derteford, butcher 1
4938706 2338491 2338491 defendant Boltham Peter taverner 588791 588791 Boltham, Peter, of Derteford, taverner 0
4952475 2342698 2342698 plaintiff Rotheley Roger   588791 588791 Rotheley, Roger, of Derteford 0
4952477 2342699 2342699 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4966570 2346934 2346934 defendant Kyrkeby John husbandman 588791 588791 Kyrkeby, John, of Derteford, husbandman 1
4969686 2347880 2347880 defendant Frankeleyn Robert butcher 588791 588791 Frankeleyn, Robert, of Derteford, butcher 1
4969688 2347880 2347880 defendant Tremer James tiler 588791 588791 Tremer, James, of Derteford, tiler 3
4969689 2347880 2347880 defendant Aleyn Richard dyer 588791 588791 Aleyn, Richard, of Derteford, dyer 4
4973621 2349062 2349062 defendant Rotheley William   588791 588791 Rotheley, William, of Derteford 0
4978132 2350425 2350425 plaintiff Reve William   588791 588791 Reve, William, of Derteford 0
4985937 2352712 2352712 defendant Bakere William hosteller 588791 588791 Bakere, William, of Derteford, hosteller 1
5005402 2358480 2358480 defendant Stonhylde William husbandman 588791 588791 Stonhylde, William, of Derteford, husbandman 0
5005636 2358547 2358547 defendant Stonehild William victualler 588791 588791 Stonehild, William, of Derteford, victualler 3
5018636 2362337 2362337 defendant Bedenassh John carpenter 588791 588791 Bedenassh, John, of Derteford, carpenter 0
5027523 2364928 2364928 defendant Kyrkeby John   588791 588791 Kyrkeby, John, of Derteford, bailiff 2
5032024 2366240 2366240 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5032026 2366241 2366241 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5032030 2366242 2366242 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5035429 2367219 2367219 defendant Coke Richard yeoman 588791 588791 Coke, Richard, of Derteford, yeoman 4
5036287 2367464 2367464 defendant Chapman William butcher 588791 588791 Chapman, William, of Derteford, butcher 0
5048651 2371235 2371235 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5065529 2376223 2376223 defendant Trewer alias Sherman Henry sherman 588791 588791 Trewer alias Sherman, Henry, of Derteford, sherman 0
5068056 2376950 2376950 defendant Kirkeby John yeoman 588791 588791 Kirkeby, John, of Derteford, yeoman 1
5069799 2377461 2377461 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5069804 2377461 2377461 defendant Comyn Robert smith 588791 588791 (Comyn, Robert, of Derteford, smith 4
5069805 2377462 2377462 plaintiff Rotheley William gent 588791 588791 Rotheley, William, of Derteford, gent 0
5079377 2380327 2380327 defendant Sewyn Richard miller 588791 588791 Sewyn, Richard, of Derteford, miller 2
5094370 2384758 2384758 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5106891 2388444 2388444 plaintiff de Chymbeham Edmund   588791 588791 de Chymbeham, Edmund, of Derteford 0
5129993 2395259 2395259 defendant Kirkeby John yeoman 588791 588791 Kirkeby, John, of Derteford, yeoman 1
5138579 2397781 2397781 plaintiff Rothele William   588791 588791 Rothele, William, of Derteford 0
5138584 2397782 2397782 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5138590 2397783 2397783 plaintiff Rotheley William   588791 588791 Rotheley, William, of Derteford 0
5217252 2420780 2420780 defendant Grenewode Thomas skinner 588791 588791 Grenewode, Thomas, of Derteford, skinner 1
5231236 2424735 2424735 defendant Pratte John skinner 588791 588791 Pratte, John, of Derteford, skinner 0
5253447 2431181 2431181 defendant Barker Thomas scrivener 588791 588791 Barker, Thomas, of Derteford, scrivener 0
5333743 2455166 2455166 defendant Tydyman Thomas laborer 588791 588791 Tydyman, Thomas, of Derteford, laborer 2
5333744 2455166 2455166 defendant Sturgeon John laborer 588791 588791 Sturgeon, John, of Derteford, laborer 3
5333745 2455166 2455166 defendant Banbury John barber 588791 588791 Banbury, John, of Derteford, barber 4
5357413 2462387 2462387 plaintiff Mylet William   588791 588791 Mylet, William, of Derteford 0
5357414 2462387 2462387 defendant Wyltshyre Thomas ironmonger 588791 588791 Wyltshyre, Thomas, of Derteford, ironmonger 0
5401416 2475470 2475470 defendant Short John yeoman 588791 588791 Short, John, of Derteford, yeoman 0
5401418 2475470 2475470 defendant Baynton Richard   588791 588791 Baynton, Richard, of Derteford, inn holder 2
5414400 2479245 2479245 defendant Short John yeoman 588791 588791 Short, John, of Derteford, yeoman 0
5414402 2479245 2479245 defendant Baynton Richard   588791 588791 Baynton, Richard, of Derteford, inn holder 2
5430195 2483969 2483969 defendant Short John yeoman 588791 588791 Short, John, of Derteford, yeoman 0
5430197 2483969 2483969 defendant Baynton Richard innholder 588791 588791 Baynton, Richard, of Derteford, innholder 2
5467109 2495109 2495109 plaintiff Blaknall William   588791 588791 Blaknall, William, of Derteford 0
5472589 2496768 2496768 defendant Mayk_ Stephen glover 588791 588791 Mayk_, Stephen, of Derteford, glover 2
5485034 2500443 2500443 defendant Todde Christopher mercer 588791 588791 Todde, Christopher, of Derteford, mercer 0
5547373 2519243 2519243 plaintiff Weymer alias Eweymer Thomas yeoman 588791 588791 Weymer alias Eweymer, Thomas, of Derteford, yeoman 0
5547376 2519244 2519244 plaintiff Weymer alias Eweymer Thomas yeoman 588791 588791 Weymer alias Eweymer, Thomas, of Derteford, yeoman 0
5547379 2519245 2519245 plaintiff Weymer Thomas yeoman 588791 588791 Weymer, Thomas, of Derteford, yeoman 0
5620565 2550293 2550293 plaintiff Scrynton Robert   588791 588791 Scrynton, Robert, of Derteford 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);