names

85 rows where place_id = 592998

✎ 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
3609878 1870760 1870760 plaintiff Felder Thomas husbandman 592998 592998 Felder, Thomas, of Basyng, husbandman 0
3611696 1871320 1871320 defendant Dummer Henry gent 592998 592998 Dummer, Henry, of Basyng, gent 0
3611697 1871320 1871320 defendant Frankelyn John yeoman 592998 592998 Frankelyn, John, of Basyng, yeoman 1
3611699 1871321 1871321 defendant Frankeleyn John yeoman 592998 592998 Frankeleyn, John, of Basyng, yeoman 0
3618163 1873306 1873306 defendant Goodyere John husbandman 592998 592998 Goodyere, John, of Basyng, husbandman 0
3618164 1873306 1873306 defendant Goodyere Thomas husbandman 592998 592998 Goodyere, Thomas, of Basyng, husbandman 1
3636108 1906085 1906085 defendant Cowfold John gent 592998 592998 Cowfold, John, of Basyng, gent 0
3670031 1916573 1916573 defendant Bayly Thomas miller 592998 592998 Bayly, Thomas, of Basyng, miller 0
3670032 1916573 1916573 defendant Sympson John miller 592998 592998 Sympson, John, of Basyng, miller 1
3695129 1924695 1924695 defendant Paumer John clothier 592998 592998 Paumer, John, of Basyng, clothier 0
3719502 1932366 1932366 defendant Tanner John husbandman 592998 592998 Tanner, John, of Basyng, husbandman 0
4451224 2185341 2185341 defendant Uggel Roger sawyer 592998 592998 Uggel, Roger, of Basyng, sawyer 0
4459345 2187975 2187975 plaintiff Russel Robert   592998 592998 Russel, Robert, of Basyng 0
4459346 2187976 2187976 plaintiff Russel Robert   592998 592998 Russel, Robert, of Basyng 0
4459348 2187977 2187977 plaintiff Russel Robert   592998 592998 Russel, Robert, of Basyng 0
4502058 2201240 2201240 defendant Heyne John   592998 592998 Heyne, John, of Basyng 0
4651994 2246559 2246559 defendant Meserlyn John, junior husbandman 592998 592998 Meserlyn, John, junior, of Basyng, husbandman 0
4656347 2247879 2247879 defendant Ocle William, junior laborer 592998 592998 Ocle, William, junior, of Basyng, laborer 0
4681505 2259829 2259829 defendant Helier William haulier 592998 592998 Helier, William, of Basyng, haulier 1
4689034 2262128 2262128 defendant Whitley John, senior husbandman 592998 592998 Whitley, John, senior, of Basyng, husbandman 0
4689035 2262128 2262128 defendant Whitley William, junior yeoman 592998 592998 Whitley, William, junior, of Basyng, yeoman 1
4705033 2266945 2266945 plaintiff Kent Roger   592998 592998 Kent, Roger, of Basyng 0
4738607 2277163 2277163 defendant Broun Isabel   592998 592998 Broun, Isabel, of Basyng, servant 2
4743783 2278710 2278710 defendant Penston William husbandman 592998 592998 Penston, William, of Basyng, husbandman 0
4780036 2289760 2289760 plaintiff Broun William   592998 592998 Broun, William, of Basyng 0
4794482 2294412 2294412 defendant Anevyll Edward husbandman 592998 592998 Anevyll, Edward, of Basyng, husbandman 0
4943708 2339997 2339997 defendant Broun William   592998 592998 Broun, William, of Basyng, parchment maker 0
4999933 2356856 2356856 defendant Penstone William husbandman 592998 592998 Penstone, William, of Basyng, husbandman 0
5007756 2359161 2359161 defendant Leche John husbandman 592998 592998 Leche, John, of Basyng, husbandman 0
5007757 2359161 2359161 defendant Lavender Robert husbandman 592998 592998 Lavender, Robert, of Basyng, husbandman 1
5007758 2359161 2359161 defendant Termeyn Nicholas laborer 592998 592998 Termeyn, Nicholas, of Basyng, laborer 2
5007759 2359161 2359161 defendant Lyde William husbandman 592998 592998 Lyde, William, of Basyng, husbandman 3
5007760 2359161 2359161 defendant Presshawe Roger husbandman 592998 592998 Presshawe, Roger, of Basyng, husbandman 4
5007761 2359161 2359161 defendant Meferlyn John husbandman 592998 592998 Meferlyn, John, of Basyng, husbandman 5
5007762 2359161 2359161 defendant Ivery Simon husbandman 592998 592998 Ivery, Simon, of Basyng, husbandman 6
5023409 2363752 2363752 defendant Norewell Richard cordwainer 592998 592998 Norewell, Richard, of Basyng, cordwainer 0
5023410 2363752 2363752 defendant Doget William cordwainer 592998 592998 Doget, William, of Basyng, cordwainer 1
5038748 2368235 2368235 defendant Jonesservant Leche Edward laborer 592998 592998 Jonesservant Leche, Edward, of Basyng, laborer 2
5038758 2368237 2368237 defendant Jonesservant leche Edward laborer 592998 592998 Jonesservant leche, Edward, of Basyng, laborer 3
5053343 2372603 2372603 defendant Lokar Wlliam, senior husbndman 592998 592998 Lokar, Wlliam, senior, of Basyng, husbndman 2
5111559 2389777 2389777 defendant Cowefold John husbandman 592998 592998 Cowefold, John, of Basyng, husbandman 6
5111564 2389778 2389778 defendant Cowefold John husbandman 592998 592998 Cowefold, John, of Basyng, husbandman 3
5115537 2390970 2390970 defendant Wardelham John yeoman 592998 592998 Wardelham, John, of Basyng, yeoman 2
5248906 2429803 2429803 defendant Tournour John husbandman 592998 592998 Tournour, John, of Basyng, husbandman 0
5255067 2431699 2431699 defendant Milford John yeoman 592998 592998 Milford, John,of Basyng, yeoman 0
5260419 2433388 2433388 defendant Waterende William husbandman 592998 592998 Waterende, William, of Basyng, husbandman 0
5266567 2435295 2435295 defendant Poulet John esq 592998 592998 Poulet, John, of Basyng, esq 0
5266569 2435296 2435296 defendant Poulet John   592998 592998 Poulet, John, of Basyng, esq, once sheriff 0
5274400 2437590 2437590 defendant Birley (illegible) yeoman 592998 592998 Birley, ----, of Basyng, yeoman 0
5274402 2437591 2437591 defendant burley William yeoman 592998 592998 burley, William, of Basyng, yeoman 0
5310323 2448118 2448118 defendant Clerk James   592998 592998 Clerk, James, of Basyng, holy water clerk 2
5312787 2448855 2448855 defendant Serle William smith 592998 592998 Serle, William, of Basyng, smith 2
5316584 2450045 2450045 defendant Turnour Katherine widow 592998 592998 Turnour, Katherine, of Basyng, widow 2
5316589 2450046 2450046 defendant Turnour Katherine widow 592998 592998 Turnour, Katherine, of Basyng, widow 1
5326487 2453006 2453006 defendant Godeyere Thomas husbandman 592998 592998 Godeyere, Thomas, of Basyng, husbandman 0
5326488 2453006 2453006 defendant Torner William husbandman 592998 592998 Torner, William, of Basyng, husbandman 1
5331978 2454638 2454638 defendant Coton Robert husbandman 592998 592998 Coton, Robert, of Basyng, husbandman 2
5335578 2455713 2455713 defendant Smyth Nicholas mercer 592998 592998 Smyth, Nicholas, of Basyng, mercer 0
5343208 2458069 2458069 defendant Turnour William husbandman 592998 592998 Turnour, William,of Basyng, husbandman 1
5343209 2458069 2458069 defendant Sall John yeoman 592998 592998 Sall, John, of Basyng, yeoman 2
5361041 2463478 2463478 defendant Turnour William husbandman 592998 592998 Turnour, William, of Basyng, husbandman 0
5363462 2464222 2464222 defendant Mulford Richard yeoman 592998 592998 Mulford, Richard, of Basyng, yeoman 2
5363463 2464222 2464222 defendant Colner or Colver John yeoman 592998 592998 Colner or Colver, John, of Basyng, yeoman 3
5363464 2464222 2464222 defendant Frankeleyn John yeoman 592998 592998 Frankeleyn, John, of Basyng, yeoman 4
5395232 2473710 2473710 defendant Godere Thomas butcher 592998 592998 Godere, Thomas, of Basyng, butcher 2
5395233 2473710 2473710 defendant More Thomas husbandman 592998 592998 More, Thomas, of Basyng, husbandman 3
5395234 2473710 2473710 defendant Frankeleyn John yeoman 592998 592998 Frankeleyn, John, of Basyng, yeoman 4
5408482 2477506 2477506 defendant Gowere Thomas butcher 592998 592998 Gowere, Thomas, of Basyng, butcher 2
5408483 2477506 2477506 defendant More Thomas husbandman 592998 592998 More, Thomas, of Basyng, husbandman 3
5408484 2477506 2477506 defendant Frankeleyn John yeoman 592998 592998 Frankeleyn, John, of Basyng, yeoman 4
5408490 2477507 2477507 defendant Gowere Thomas butcher 592998 592998 Gowere, Thomas, of Basyng, butcher 2
5408491 2477507 2477507 defendant More Thomas husbandman 592998 592998 More, Thomas, of Basyng, husbandman 3
5408492 2477507 2477507 defendant Frankeleyn John yeoman 592998 592998 Frankeleyn, John, of Basyng, yeoman 4
5447996 2489284 2489284 defendant Merfaunt Edward tiler 592998 592998 Merfaunt, Edward, of Basyng, tiler 1
5485505 2500576 2500576 defendant Isaake John husbandman 592998 592998 Isaake, John, of Basyng, husbandman 4
5485516 2500578 2500578 defendant Isaake John husbandman 592998 592998 Isaake, John, of Basyng, husbandman 4
5501467 2505392 2505392 defendant Wydoweson John husbandman 592998 592998 Wydoweson, John, of Basyng, husbandman 4
5507550 2507255 2507255 defendant Mulford Richard yeoman 592998 592998 Mulford, Richard, of Basyng, yeoman 3
5508770 2507597 2507597 defendant Tanner Andrew husbandman 592998 592998 Tanner, Andrew, of Basyng, husbandman 1
5515936 2509832 2509832 defendant Wydowson John husbandman 592998 592998 Wydowson, John, of Basyng, husbandman 4
5607551 2537254 2537254 defendant Bryanger William laborer 592998 592998 Bryanger, William, of Basyng, laborer 10
5607552 2537254 2537254 defendant Poulet James gent 592998 592998 Poulet, James, of Basyng, gent 11
5607553 2537254 2537254 defendant Poulet William, senior gent 592998 592998 Poulet, William, senior, of Basyng, gent 12
5627371 2552529 2552529 defendant Captayn Nicholas   592998 592998 Captayn, Nicholas, of Basyng, millward 0
5636168 2555266 2555266 defendant Thorp John weaver 592998 592998 Thorp, John, of Basyng, weaver 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);