names

213 rows where place_id = 596408

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624638 1875241 1875241 plaintiff Turnour John   596408 596408 Turnour, John, of Dadyngton 0
3635945 1906037 1906037 plaintiff Pope William   596408 596408 Pope, William, of Dadyngton 0
3670759 1916815 1916815 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3685967 1921769 1921769 plaintiff Billyng William   596408 596408 Billyng, William, of Dadyngton 0
3686852 1922049 1922049 plaintiff Byllyng William   596408 596408 Byllyng, William, of Dadyngton 0
3686855 1922050 1922050 plaintiff Byllyng William   596408 596408 Byllyng, William, of Dadyngton 0
3701026 1926569 1926569 plaintiff Billyng William merchant 596408 596408 Billyng, William, of Dadyngton, merchant 0
3701969 1926869 1926869 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3715628 1931176 1931176 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3745675 1940556 1940556 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3758594 1944685 1944685 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3758597 1944686 1944686 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3758599 1944687 1944687 plaintiff Byllyng William merchant of the staple 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple 0
3773642 1949474 1949474 defendant Chawndeler John shoemaker 596408 596408 Chawndeler, John, of Dadyngton, shoemaker 0
3773643 1949474 1949474 defendant Dusterfeld Thomas shoemaker 596408 596408 Dusterfeld, Thomas, of Dadyngton, shoemaker 1
3776667 1950449 1950449 plaintiff Byllyng William gent 596408 596408 Byllyng, William, of Dadyngton, gent 0
3793775 1955917 1955917 defendant Stylys or Stylgo John husbandman 596408 596408 Stylys or Stylgo, John, of Dadyngton, husbandman 1
3793776 1955917 1955917 defendant Stylys or Stylgo Richard cordwainer 596408 596408 Stylys or Stylgo, Richard, of Dadyngton, cordwainer 2
3810910 1961313 1961313 defendant Rales John husbandman 596408 596408 Rales, John, of Dadyngton, husbandman 0
3828666 1966844 1966844 plaintiff Cleyford Robert yeoman 596408 596408 Cleyford, Robert, of Dadyngton, yeoman 0
3848804 1973211 1973211 defendant Apyltre John husbandman 596408 596408 Apyltre, John, of Dadyngton, husbandman 0
3854292 1974977 1974977 defendant Frenche William husbandman 596408 596408 Frenche, William, of Dadyngton, husbandman 0
3859105 1976536 1976536 plaintiff Byllyng William (legal representative) 596408 596408 Byllyng, William, of Dadyngton, merchant of the staple, executors of 0
3873856 1981475 1981475 plaintiff Cleyford Robert yeoman 596408 596408 Cleyford, Robert, of Dadyngton, yeoman 0
3880391 1983697 1983697 plaintiff Pole William   596408 596408 Pole, William, of Dadyngton 0
3897486 1989372 1989372 defendant Long Richard mercer 596408 596408 Long, Richard, of Dadyngton, mercer 0
3943098 2004707 2004707 defendant Clyfford John tailor 596408 596408 Clyfford, John, of Dadyngton, tailor 0
4438874 2181452 2181452 defendant Yareman John   596408 596408 Yareman, John, of Dadyngton 0
4457980 2187518 2187518 defendant Haye William   596408 596408 Haye, William, of Dadyngton 0
4468540 2190828 2190828 defendant Brasyer Richard   596408 596408 Brasyer, Richard, of Dadyngton 1
4469914 2191255 2191255 defendant Draper William   596408 596408 Draper, William, of Dadyngton 3
4483160 2195429 2195429 defendant Draper John   596408 596408 Draper, John, of Dadyngton 1
4486150 2196369 2196369 defendant Clerk Richard   596408 596408 Clerk, Richard, of Dadyngton 0
4486151 2196369 2196369 defendant Clerk Thomas   596408 596408 Clerk,Thomas, of Dadyngton 1
4495274 2199197 2199197 defendant Skynner Thomas   596408 596408 Skynner, Thomas, of Dadyngton 0
4495339 2199222 2199222 defendant Waodeward William   596408 596408 Waodeward, William, of Dadyngton 0
4495340 2199222 2199222 defendant Corvyser William   596408 596408 Corvyser, William, of Dadyngton 1
4496111 2199462 2199462 defendant Somenour John   596408 596408 Somenour, John, of Dadyngton 1
4496112 2199462 2199462 defendant Janyns William butcher 596408 596408 Janyns, William, of Dadyngton, butcher 2
4497524 2199870 2199870 plaintiff Draper John   596408 596408 Draper, John, of Dadyngton, son of Roger, on his own account 0
4497528 2199871 2199871 plaintiff Draper Roger   596408 596408 Draper, Roger, of Dadyngton, on his own account 0
4497529 2199871 2199871 defendant Brasyer Richard   596408 596408 Brasyer, Richard, of Dadyngton 0
4497530 2199872 2199872 plaintiff Draper Thomas   596408 596408 Draper, Thomas, of Dadyngton, on his own account 0
4497534 2199873 2199873 plaintiff Draper William   596408 596408 Draper, William, of Dadyngton, on his own account 0
4497659 2199915 2199915 defendant Makerell John   596408 596408 Makerell, John, of Dadyngton 0
4502243 2201300 2201300 defendant Draper William   596408 596408 Draper, William, of Dadyngton 0
4502461 2201352 2201352 plaintiff Milward Thomas   596408 596408 Milward, Thomas, of Dadyngton, on his own account 0
4503120 2201545 2201545 plaintiff Ostyller John   596408 596408 Ostyller, John, of Dadyngton, son of William Ostyller, on his own account 0
4503121 2201545 2201545 defendant Kirkeby Thomas   596408 596408 Kirkeby, Thomas, of Dadyngton 0
4506091 2202419 2202419 defendant Skynner Thomas   596408 596408 Skynner, Thomas, of Dadyngton 2
4507570 2202829 2202829 plaintiff Wheler John   596408 596408 Wheler, John, of Dadyngton, on his own account 0
4507571 2202829 2202829 defendant Sampson Clement   596408 596408 Sampson, Clement, of Dadyngton 0
4507646 2202853 2202853 defendant Smyth John   596408 596408 Smyth, John, of Dadyngton 0
4512938 2204480 2204480 defendant Brakkele Richard   596408 596408 Brakkele, Richard, of Dadyngton 0
4512939 2204480 2204480 defendant Yerman John   596408 596408 Yerman, John, of Dadyngton 1
4516542 2205582 2205582 defendant Stretford John   596408 596408 Stretford, John, of Dadyngton, administrators of 0
4518847 2206260 2206260 defendant Brasier Richard   596408 596408 Brasier, Richard, of Dadyngton 0
4518864 2206266 2206266 plaintiff Draper Roger   596408 596408 Draper, Roger, of Dadyngton 0
4518865 2206266 2206266 defendant Brasyer Richard   596408 596408 Brasyer, Richard, of Dadyngton 0
4527835 2208981 2208981 defendant Brakkeley Richard   596408 596408 Brakkeley, Richard, of Dadyngton 0
4527836 2208981 2208981 defendant Crosste John   596408 596408 Crosste, John, of Dadyngton 1
4529960 2209663 2209663 defendant Croft John   596408 596408 Croft, John, of Dadyngton 0
4535412 2211347 2211347 plaintiff Skynner Thomas   596408 596408 Skynner, Thomas, of Dadyngton 0
4535427 2211353 2211353 plaintiff Skynnere Thomas   596408 596408 Skynnere, Thomas, of Dadyngton 0
4540429 2212905 2212905 defendant Solatte William   596408 596408 Solatte, William, of Dadyngton 0
4545062 2214378 2214378 plaintiff Berford Richard (legal representative) 596408 596408 Berford, Richard, of Dadyngton, executor of 0
4545063 2214378 2214378 plaintiff Berford Thomas   596408 596408 Berford, Thomas, of Dadyngton, draper, son of Richard 1
4548888 2215586 2215586 defendant Stretford John   596408 596408 Stretford, John, of Dadyngton, administrators of 0
4556666 2218017 2218017 defendant Mulver Thomas   596408 596408 Mulver, Thomas, of Dadyngton 0
4560489 2219221 2219221 defendant Croft William   596408 596408 Croft, William, of Dadyngton 0
4563919 2220287 2220287 plaintiff Rugheved Richard   596408 596408 Rugheved, Richard, of Dadyngton 0
4563920 2220287 2220287 defendant Smyth Adam   596408 596408 Smyth, Adam, of Dadyngton 0
4565202 2220690 2220690 plaintiff Skynner Thomas   596408 596408 Skynner, Thomas, of Dadyngton 0
4573981 2223383 2223383 defendant Draper Thomas   596408 596408 Draper, Thomas, of Dadyngton 0
4575034 2223714 2223714 defendant Aston Robert   596408 596408 Aston, Robert, of Dadyngton 0
4587343 2227448 2227448 defendant Hosyer John   596408 596408 Hosyer, John, of Dadyngton 0
4587704 2227561 2227561 defendant Bocher John   596408 596408 Bocher, John, of Dadyngton 1
4594723 2229605 2229605 plaintiff Prest Thomas (legal representative) 596408 596408 Prest, Thomas, of Dadyngton, executors of 0
4594726 2229605 2229605 defendant Drapere Thomas   596408 596408 Drapere, Thomas, of Dadyngton 0
4604752 2232654 2232654 defendant Sclatter John   596408 596408 Sclatter, John, of Dadyngton 0
4605742 2232913 2232913 defendant Sherman John   596408 596408 Sherman, John, of Dadyngton 0
4606408 2233120 2233120 defendant Draper Henry   596408 596408 Draper, Henry, of Dadyngton 0
4628792 2239933 2239933 defendant Somnour John   596408 596408 Somnour, John, of Dadyngton 1
4631123 2240632 2240632 plaintiff Horncastell William   596408 596408 Horncastell, William, of Dadyngton 1
4633979 2241480 2241480 defendant Wygynton John   596408 596408 Wygynton, John, of Dadyngton 0
4639226 2242991 2242991 defendant Draper William   596408 596408 Draper, William, of Dadyngton 0
4639227 2242991 2242991 defendant Brasier Richard   596408 596408 Brasier, Richard, of Dadyngton 1
4639228 2242991 2242991 defendant Skynner Thomas   596408 596408 Skynner, Thomas, of Dadyngton 2
4645328 2244706 2244706 defendant Skynner Thomas   596408 596408 Skynner, Thomas, of Dadyngton 0
4664131 2250268 2250268 defendant Smyth John laborer 596408 596408 Smyth, John, of Dadyngton, laborer 0
4674614 2257668 2257668 defendant Edmond John, junior   596408 596408 Edmond, John, junior, of Dadyngton, bell founder 0
4703100 2266345 2266345 defendant Walysche Thomas carrier 596408 596408 Walysche, Thomas, of Dadyngton, carrier 0
4703112 2266350 2266350 defendant Walysche Thomas carpenter 596408 596408 Walysche, Thomas, of Dadyngton, carpenter 0
4715441 2270165 2270165 defendant Danyell John   596408 596408 Danyell, John, of Dadyngton, rope maker 0
4726341 2273522 2273522 defendant Hocard William (legal representative) 596408 596408 Hocard, William, of Dadyngton, butcher, executor of 0
4726342 2273522 2273522 defendant Harlyngrugge Thomas husbandman 596408 596408 (Harlyngrugge, Thomas, of Dadyngton, husbandman 1
4726343 2273522 2273522 defendant Best John husbandman 596408 596408 together wirth Best, John, of Dadyngton, husbandman 2
4748822 2280142 2280142 defendant Byfeld Elizabeth   596408 596408 Byfeld, Elizabeth, of Dadyngton, servant 1
4761283 2283876 2283876 defendant Horncastell Walter husbandman 596408 596408 Horncastell, Walter, of Dadyngton, husbandman 0
4761285 2283876 2283876 defendant Draper Henry   596408 596408 Draper, Henry, of Dadyngton 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);