names

80 rows where place_id = 594194

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615021 1872343 1872343 defendant Gatyshend William brewer 594194 594194 Gatyshend, William, of Wysbeche, Cams, brewer 2
3683914 1921103 1921103 defendant Stokysdale Robert mariner 594194 594194 Stokysdale, Robert, of Wysbeche, Cams, mariner 2
3707224 1928552 1928552 defendant Tropenett Thomas yeoman 594194 594194 Tropenett, Thomas, of Wysbeche, Cams, yeoman 0
3719328 1932333 1932333 defendant Sutton Robert gent 594194 594194 Sutton, Robert, of Wysbeche, Cams, gent 0
3720673 1932755 1932755 defendant Smyth Robert shoemaker 594194 594194 Smyth, Robert, of Wysbeche, Cams, shoemaker 0
3748608 1941496 1941496 defendant Sutton Robert husbandman 594194 594194 Sutton, Robert, of Wysbeche, Cams, husbandman 0
3768626 1947835 1947835 defendant Knyth John   594194 594194 Knyth, John, of Wysbeche, Cams, oatmeal maker 0
3849291 1973371 1973371 defendant Sutton Robert gent 594194 594194 Sutton, Robert, of Wysbeche, Cams, gent 0
3914399 1995160 1995160 defendant Byrd John waterman 594194 594194 Byrd, John, of Wysbeche, Cams, waterman 0
3920012 1997033 1997033 defendant Austen Robert yeoman 594194 594194 Austen, Robert, of Wysbeche, Cams, yeoman 0
3920017 1997034 1997034 defendant Baxster John roper 594194 594194 Baxster, John, of Wysbeche, Cams, roper 0
3920045 1997041 1997041 defendant Newdyke John husbandman 594194 594194 Newdyke, John, of Parson Drove, Wysbeche, Cams, husbandman 0
4779921 2289719 2289719 defendant Inggold Thomas yeoman 594194 594194 Inggold, Thomas, of Wysbeche, Cams, yeoman 1
4863963 2315703 2315703 defendant Broun Thomas husbandman 594194 594194 Broun, Thomas, of Wysbeche, Cams, husbandman 2
4865048 2316045 2316045 defendant Dykby Richard yeoman 594194 594194 Dykby, Richard, of Wysbeche, Cams, yeoman 0
4865538 2316184 2316184 defendant Suker Robert husbandman 594194 594194 Suker, Robert, of Wysbeche, Cams, husbandman 0
4874865 2319080 2319080 defendant Grey Geoffrey chapman 594194 594194 Grey, Geoffrey, of Wysbeche, Cams, chapman 1
4874869 2319081 2319081 defendant Grey Geoffrey chapman 594194 594194 Grey, Geoffrey, of Wysbeche, Cams, chapman 1
4890677 2323838 2323838 defendant Grey Geoffrey gent 594194 594194 Grey, Geoffrey, of Wysbeche, Cams, gent 2
4893191 2324586 2324586 defendant Mannyng John yeoman 594194 594194 Mannyng, John, of Wysbeche, Cams, yeoman 2
4893901 2324794 2324794 defendant Queneld Thomas yeoman 594194 594194 Queneld, Thomas, of Wysbeche, Cams, yeoman 0
4897257 2325800 2325800 defendant Grey Geoffrey gent 594194 594194 Grey, Geoffrey, of Wysbeche, Cams, gent 2
4897606 2325914 2325914 defendant Sukar Robert husbandman 594194 594194 Sukar, Robert, of Wysbeche, Cams, husbandman 0
4899330 2326431 2326431 defendant Mannyng John yeoman 594194 594194 Mannyng, John, of Wysbeche, Cams, yeoman 2
4904194 2327922 2327922 defendant Everard John esq 594194 594194 Everard, John, of Wysbeche, Cams, esq 2
4905797 2328416 2328416 defendant Sukar Robert husbandman 594194 594194 Sukar, Robert, of Wysbeche, Cams, husbandman 0
4941153 2339256 2339256 defendant Medwod John gent 594194 594194 Medwod, John, of Wysbeche, Cams, gent 1
4958876 2344626 2344626 defendant Wormle Elias dyer 594194 594194 Wormle, Elias, of Wysbeche, Cams, dyer 0
4958884 2344627 2344627 defendant Wormle Elias dyer 594194 594194 Wormle, Elias, of Wysbeche, Cams, dyer 0
4960177 2345017 2345017 defendant Weldon Thomas chapman 594194 594194 Weldon, Thomas, of Wysbeche, Cams, chapman 0
4963225 2345908 2345908 defendant Grene William husbandman 594194 594194 Grene, William, of Wysbeche, Cams, husbandman 0
4963228 2345909 2345909 defendant Grene William husbandman 594194 594194 Grene, William, of Wysbeche, Cams, husbandman 0
5020000 2362730 2362730 defendant Game John chapman 594194 594194 Game, John, of Wysbeche, Cams, chapman 4
5029756 2365576 2365576 defendant Bele John yeoman 594194 594194 Bele, John, of Wysbeche, Cams, yeoman 0
5029758 2365577 2365577 defendant Bele John yeoman 594194 594194 Bele, John, of Wysbeche, Cams, yeoman 0
5052443 2372327 2372327 defendant Fyssher Nicholas skinner 594194 594194 Fyssher, Nicholas, of Wysbeche, Cams, skinner 3
5052450 2372328 2372328 defendant Fyssher Nicholas skinner 594194 594194 Fyssher, Nicholas, of Wysbeche, Cams, skinner 3
5060180 2374618 2374618 defendant Dunton Richard taverner 594194 594194 Dunton, Richard, of Wysbeche, Cams, taverner 0
5076657 2379519 2379519 defendant Donton Richard vintner 594194 594194 Donton, Richard, of Wysbeche, Cams, vintner 0
5082201 2381172 2381172 defendant Sutton John husbandman 594194 594194 Sutton, John, of Wysbeche, Cams, husbandman 0
5088413 2382987 2382987 defendant Abell Ralph cooper or husbandman 594194 594194 Abell, Ralph, of Wysbeche, Cams, cooper or husbandman 1
5101277 2386782 2386782 defendant Fox John esq 594194 594194 Fox, John, of Wysbeche, Cams, esq 0
5102539 2387146 2387146 defendant Wade alias Flete Thomas brasier or yeoman 594194 594194 Wade alias Flete, Thomas, of Wysbeche, Cams, brasier or yeoman 0
5103760 2387521 2387521 defendant Fox John gent 594194 594194 Fox, John, of Wysbeche, Cams, gent 3
5106066 2388213 2388213 defendant Godfrey Margaret   594194 594194 Godfrey, Margaret, of Wysbeche, Cams, servant 0
5108157 2388822 2388822 defendant Fyssh Bartholomew pardoner 594194 594194 Fyssh, Bartholomew, of Wysbeche, Cams, pardoner 3
5116342 2391210 2391210 defendant White William gent 594194 594194 White, William, of Wysbeche, Cams, gent 3
5213252 2419609 2419609 defendant Buk John draper 594194 594194 (Buk, John, of Wysbeche, Cams, draper 1
5213256 2419611 2419611 defendant Hunt John gent 594194 594194 Hunt, John, of Wysbeche, Cams, gent 0
5217116 2420746 2420746 defendant Fooke John yeoman 594194 594194 Fooke, John, of Wysbeche, Cams, yeoman 1
5225175 2423033 2423033 defendant Everard John husbandman 594194 594194 Everard, John, of Wysbeche, Cams, husbandman 1
5231416 2424774 2424774 defendant Everard Lawrence gent 594194 594194 Everard, Lawrence, of Wysbeche, Cams, gent 3
5235601 2425995 2425995 defendant Dygby Robert tanner 594194 594194 Dygby, Robert, of Wysbeche, Cams, tanner 1
5240942 2427554 2427554 defendant Radyk William chaplain 594194 594194 Radyk, William, of Wysbeche, Cams, chaplain 1
5256893 2432285 2432285 defendant Foke John, senior yeoman 594194 594194 Foke, John, senior, of Wysbeche, Cams, yeoman 0
5257371 2432429 2432429 defendant Game or Gaine John raffman 594194 594194 Game or Gaine, John, of Wysbeche, Cams, raffman 0
5258445 2432757 2432757 defendant Souter Thomas yeoman 594194 594194 Souter, Thomas, of Wysbeche, Cams, yeoman 0
5282685 2440000 2440000 defendant Elys Thomas husbandman 594194 594194 Elys, Thomas, of Wysbeche, Cams, husbandman 0
5284064 2440360 2440360 defendant Mey Thomas husbandman 594194 594194 Mey, Thomas, of Wysbeche, Cams, husbandman 0
5294665 2443421 2443421 defendant Sowter John yeoman 594194 594194 Sowter, John, of Wysbeche, Cams, yeoman 0
5294674 2443423 2443423 defendant Calowe William gent 594194 594194 Calowe, William, of Wysbeche, Cams, gent 0
5294678 2443424 2443424 defendant Calowe William gent 594194 594194 Calowe, William, of Wysbeche, Cams, gent 0
5294686 2443426 2443426 defendant Game John yeoman 594194 594194 Game, John, of Wysbeche, Cams, yeoman 0
5294690 2443427 2443427 defendant Sowter John yeoman 594194 594194 Sowter, John, of Wysbeche, Cams, yeoman 0
5315497 2449700 2449700 defendant Lister Thomas yeoman 594194 594194 Lister, Thomas, of Wysbeche, Cams, yeoman 1
5315931 2449839 2449839 defendant Fyssher John yeoman 594194 594194 Fyssher, John, of Wysbeche, Cams, yeoman 1
5316699 2450081 2450081 defendant Fyssher John waterman 594194 594194 Fyssher, John, of Wysbeche, Cams, waterman 2
5320777 2451304 2451304 defendant Rassh Edmund husbandman 594194 594194 Rassh, Edmund, of Wysbeche, Cams, husbandman 1
5333854 2455197 2455197 defendant Foke John (legal representative) 594194 594194 Foke, John, of Wysbeche, Cams, yeoman, executors of 0
5340936 2457362 2457362 defendant Thorndon John yeoman 594194 594194 Thorndon, John, of Wysbeche, Cams, yeoman 0
5358564 2462738 2462738 defendant Bulwere Joan widow 594194 594194 Bulwere, Joan, of Wysbeche, Cams, widow 2
5359437 2462988 2462988 defendant Game John yeoman 594194 594194 Game, John, of Wysbeche, Cams, yeoman 2
5360142 2463213 2463213 defendant Fissher John yeoman 594194 594194 Fissher, John, of Wysbeche, Cams, yeoman 0
5490764 2502129 2502129 defendant Rudhale Thomas gent 594194 594194 Rudhale, Thomas, of Wysbeche, Cams, gent 0
5567921 2525191 2525191 defendant Smyth Nicholas merchant 594194 594194 Smyth, Nicholas, of Wysbeche, Cams, merchant 1
5569595 2525674 2525674 defendant Orell Isabel widow 594194 594194 Orell, Isabel, of Wysbeche, Cams, widow 1
5570156 2525845 2525845 defendant Orell Elizabeth widow 594194 594194 Orell, Elizabeth, of Wysbeche, Cams, widow 0
5585361 2530488 2530488 defendant Smyth Robert butcher 594194 594194 Smyth, Robert, of Wysbeche, Cams, butcher 2
5628646 2552929 2552929 defendant Goldsmyth John taverner 594194 594194 Goldsmyth, John, of Wysbeche, Cams, taverner 0
5635380 2555031 2555031 defendant Freman John waterman 594194 594194 Freman, John, of Wysbeche, Cams, waterman 1

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