names

53 rows where place_id = 597725

✎ 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
3629611 1904115 1904115 defendant Reynold John merchant 597725 597725 Reynold, John, of Waymouth, merchant 0
3780867 1951749 1951749 defendant Kynge John shoemaker 597725 597725 Kynge, John, of Waymouth, shoemaker 0
3780869 1951750 1951750 defendant Kyng John shoemaker 597725 597725 Kyng, John, of Waymouth, shoemaker 0
3802494 1958677 1958677 defendant Pytt Richard husbandman 597725 597725 Pytt, Richard, of Waymouth, husbandman 0
3862810 1977754 1977754 defendant Gregory John yeoman 597725 597725 Gregory, John, of Waymouth, yeoman 1
3935270 2002107 2002107 defendant Rendall William yeoman 597725 597725 Rendall, William, of Waymouth, yeoman 0
3963382 2011797 2011797 defendant Tomlynson Richard gent 597725 597725 Tomlynson, Richard, of Waymouth, gent 0
3990888 2021501 2021501 plaintiff Bonde Philip yeoman 597725 597725 Bonde, Philip, of Waymouth, yeoman 0
3990894 2021504 2021504 plaintiff Bonde William merchant 597725 597725 Bonde, William, of Waymouth, merchant 0
3990902 2021508 2021508 plaintiff Bonde William merchant 597725 597725 Bonde, William, of Waymouth, yeoman, merchant 0
3990903 2021508 2021508 defendant Harvest Henry tailor 597725 597725 Harvest, Henry, of Waymouth, tailor 0
3990904 2021509 2021509 plaintiff Bonde William merchant or gent 597725 597725 Bonde, William, of Waymouth, yeoman, merchant or gent 0
4012523 2029201 2029201 plaintiff Randall Hugh merchant 597725 597725 Randall, Hugh, of Waymouth, merchant 0
4012524 2029201 2029201 defendant James alias Ledore William baker 597725 597725 James alias Ledore, William, of Waymouth, baker 0
4068299 2048963 2048963 defendant James alias Randall Robert merchant 597725 597725 James alias Randall, Robert, of Waymouth, merchant 0
4124267 2068970 2068970 defendant Huddey William gent 597725 597725 Huddey, William, of Waymouth, gent 0
4124268 2068970 2068970 defendant Samwayes Thomas yeoman 597725 597725 Samwayes, Thomas, of Waymouth, yeoman 1
4126062 2069607 2069607 defendant Garthe William clerk 597725 597725 Garthe, William, of Waymouth, or of Wike Regis, Dorset, clerk 0
4330788 2140596 2140596 defendant Deacon Edmund   597725 597725 Deacon, Edmund, of Waymouth, surgeon 2
4360212 2150818 2150818 defendant Pytt Joan   597725 597725 Pytt, Joan, of Waymouth 1
4438670 2181383 2181383 defendant atte See John merchant 597725 597725 atte See, John, of Waymouth, merchant 0
4438671 2181383 2181383 defendant Palmer Philip   597725 597725 Palmer, Philip, of Waymouth 1
4480479 2194557 2194557 defendant London Richard   597725 597725 London, Richard, of Waymouth 1
4494218 2198882 2198882 defendant Baker John chapman 597725 597725 Baker, John, of Waymouth, chapman 1
4494219 2198882 2198882 defendant Corf William merchant 597725 597725 Corf, William, of Waymouth, merchant 2
4498349 2200142 2200142 defendant Wyght William   597725 597725 Wyght, William, of Waymouth, formerly in Lincoln 0
4506197 2202445 2202445 defendant Tylye William   597725 597725 Tylye, William, of Waymouth 2
4517760 2205946 2205946 defendant Gascoigne Stephen   597725 597725 Gascoigne, Stephen, of Waymouth 0
4523943 2207823 2207823 defendant Felawe Walter   597725 597725 Felawe, Walter, of Waymouth 1
4533759 2210825 2210825 plaintiff Rose William   597725 597725 Rose, William, of Waymouth 0
4535268 2211299 2211299 defendant Collard John   597725 597725 Collard, John, of Waymouth 1
4545487 2214512 2214512 defendant Corf William merchant 597725 597725 Corf, William, of Waymouth, merchant 0
4556137 2217862 2217862 defendant Wyet Wilia   597725 597725 Wyet, Wilia, of Waymouth 0
4567945 2221543 2221543 defendant Wyot William   597725 597725 Wyot, William, of Waymouth 2
4580959 2225519 2225519 defendant Bassyngbourne John   597725 597725 Bassyngbourne, John, of Waymouth 2
4623431 2238302 2238302 defendant Cole Thomas   597725 597725 Cole, Thomas, of Waymouth, son of John 0
4635089 2241822 2241822 plaintiff Wyot William   597725 597725 Wyot, William, of Waymouth 0
4635096 2241823 2241823 plaintiff Wyot William   597725 597725 Wyot, William, of Waymouth 0
4770871 2286870 2286870 defendant Penne John (legal representative) 597725 597725 Penne, John, of Waymouth, executors of 0
4869938 2317572 2317572 defendant Bedill Thomas brewer 597725 597725 Bedill, Thomas, of Waymouth, brewer 0
4907491 2328904 2328904 defendant Sirla John gent 597725 597725 Sirla, John, of Waymouth, gent 0
4972065 2348581 2348581 defendant Stake John shoemaker 597725 597725 Stake, John, of Waymouth, shoemaker 0
4992826 2354735 2354735 defendant Stroughe John husbandman 597725 597725 Stroughe, John, of Waymouth, husbandman 0
5126148 2394127 2394127 defendant Martyn John yeoman 597725 597725 Martyn, John, of Waymouth, yeoman 1
5133708 2396354 2396354 defendant Woulle Henry merchant 597725 597725 Woulle, Henry, of Waymouth, merchant 0
5226161 2423317 2423317 defendant Abbot Nicholas merchant 597725 597725 Abbot, Nicholas, of Waymouth, merchant 0
5280666 2439419 2439419 defendant Durneford Nicholas merchant 597725 597725 (Durneford, Nicholas, of Waymouth, merchant 1
5283329 2440182 2440182 defendant Abbot Nicholas merchant 597725 597725 Abbot, Nicholas, of Waymouth, merchant 0
5318378 2450592 2450592 defendant Waymouth Thomas yeoman 597725 597725 Waymouth, Thomas, of Waymouth, yeoman 1
5503800 2506105 2506105 defendant Abbot Robert gent 597725 597725 Abbot, Robert, of Waymouth, gent 0
5615724 2548709 2548709 defendant Fisshere Richard   597725 597725 Fisshere, Richard, of Waymouth 0
5621683 2550688 2550688 defendant atte See John merchant 597725 597725 atte See, John, of Waymouth, merchant 0
5629632 2553258 2553258 defendant Terry Roger seaman 597725 597725 Terry, Roger, of Waymouth, seaman 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);