names

111 rows where place_id = 592848

✎ 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
3609154 1870522 1870522 defendant Hogge William yeoman 592848 592848 Hogge, William, of Hotoft, yeoman 0
3631158 1904569 1904569 defendant Sergeant Robert husbandman 592848 592848 Sergeant, Robert, of Hotoft, husbandman 0
3702520 1927055 1927055 defendant Mekylbarowe William husbandman 592848 592848 Mekylbarowe, William, of Hotoft, husbandman 0
3764050 1946402 1946402 defendant Crake Thomas husbandman 592848 592848 Crake, Thomas, of Hotoft, husbandman 2
3810832 1961290 1961290 defendant Shirwod Richard clerk 592848 592848 Shirwod, Richard, of Hotoft, clerk 2
3836199 1969235 1969235 defendant Meres Vincent gent 592848 592848 Meres, Vincent, of Hotoft, gent 1
3873263 1981274 1981274 defendant Swyne William husbandman 592848 592848 Swyne, William, of Hotoft, husbandman 0
3873264 1981274 1981274 defendant Crake Thomas husbandman 592848 592848 Crake, Thomas, of Hotoft, husbandman 1
3901989 1990894 1990894 defendant Samball Barbara widow 592848 592848 Samball, Barbara, of Hotoft, widow 0
3917649 1996260 1996260 defendant Goodwyn Thomas shoemaker 592848 592848 Goodwyn, Thomas, of Hotoft, shoemaker 0
3951977 2007755 2007755 defendant Awkenson George husbandman 592848 592848 Awkenson, George, of Hotoft, husbandman 0
4001015 2025137 2025137 defendant Temple Roger   592848 592848 Temple, Roger, of Hotoft yeoman 0
4464528 2189574 2189574 defendant atte Date Robert   592848 592848 atte Date, Robert, of Hotoft 0
4489606 2197467 2197467 defendant atte Marre William   592848 592848 atte Marre, William, of Hotoft 1
4547325 2215095 2215095 defendant Carter Richard   592848 592848 Carter, Richard, of Hotoft 0
4548514 2215478 2215478 defendant atte Brigge William   592848 592848 atte Brigge, William, of Hotoft 0
4553545 2217038 2217038 defendant Waplod Thomas de merchant 592848 592848 Waplod, Thomas de, of Hotoft, merchant 2
4571015 2222501 2222501 defendant Cokkesson John   592848 592848 Cokkesson, John, of Hotoft 0
4602390 2231962 2231962 defendant Freres William   592848 592848 Freres, William, of Hotoft 0
4610475 2234347 2234347 defendant Grawne William miller 592848 592848 Grawne, William, of Hotoft, miller 0
4706954 2267554 2267554 defendant Freres William husbandman 592848 592848 Freres, William, of Hotoft, husbandman 0
4723612 2272689 2272689 defendant Snett William husbandman 592848 592848 Snett, William, of Hotoft, husbandman 0
4740174 2277641 2277641 defendant Marre Thomas husbandman 592848 592848 Marre, Thomas, of Hotoft, husbandman 3
4744447 2278898 2278898 defendant Malberthorp John husbandman 592848 592848 Malberthorp, John, of Hotoft, husbandman 0
4744448 2278898 2278898 defendant atte Marre Thomas husbandman 592848 592848 atte Marre, Thomas, of Hotoft, husbandman 1
4744449 2278898 2278898 defendant Profyn William (legal representative) 592848 592848 Profyn, William, of Hotoft, executors of 2
4744450 2278898 2278898 defendant Fyssher Robert husbandman 592848 592848 (Fyssher, Robert, of Hotoft, husbandman 3
4744451 2278898 2278898 defendant Dyer Walter husbandman 592848 592848 Dyer, Walter, of Hotoft, husbandman 4
4744452 2278898 2278898 defendant Arnolwe John husbandman 592848 592848 Arnolwe, John, of Hotoft, husbandman 5
4750599 2280661 2280661 defendant Snette William husbandman 592848 592848 Snette, William, of Hotoft, husbandman 1
4779074 2289432 2289432 defendant Fyscher Robert fisher 592848 592848 Fyscher, Robert, of Hotoft, fisher 1
4779075 2289432 2289432 defendant Watson Robert husbandman 592848 592848 Watson, Robert, of Hotoft, husbandman 2
4779076 2289432 2289432 defendant Snete William husbandman 592848 592848 Snete, William, of Hotoft, husbandman 3
4787908 2292285 2292285 defendant Botell Maud   592848 592848 Botell, Maud, of Hotoft, widow of Botell, William 2
4801028 2296510 2296510 defendant Marre Thomas husbandman 592848 592848 Marre, Thomas, of Hotoft, husbandman 3
4801253 2296578 2296578 defendant Tetney John shipman 592848 592848 Tetney, John, of Hotoft, shipman 0
4838112 2307843 2307843 defendant Cok William husbandman 592848 592848 Cok, William, of Hotoft, husbandman 0
4838118 2307844 2307844 defendant Cok William husbandman 592848 592848 Cok, William, of Hotoft, husbandman 0
4841815 2308972 2308972 defendant Leke William shipman 592848 592848 Leke, William, of Hotoft, shipman 2
4850026 2311475 2311475 defendant Cokke William husbandman 592848 592848 Cokke, William, of Hotoft, husbandman 1
4850032 2311476 2311476 defendant Sergeaunt John husbandman 592848 592848 Sergeaunt, John, of Hotoft, husbandman 0
4851261 2311844 2311844 plaintiff Turnour John butcher 592848 592848 Turnour, John, of Hotoft, butcher 0
4851262 2311844 2311844 defendant Warde Richard gent 592848 592848 Warde, Richard, of Hotoft, gent 0
4851263 2311844 2311844 defendant Cok William husbandman 592848 592848 Cok, William, of Hotoft, husbandman 1
4851264 2311844 2311844 defendant atte Marre Thomas husbandman 592848 592848 atte Marre, Thomas, of Hotoft, husbandman 2
4851265 2311844 2311844 defendant Tomlynson Robert husbandman 592848 592848 Tomlynson, Robert, of Hotoft, husbandman 3
4853631 2312552 2312552 defendant Gudknap William mercer 592848 592848 Gudknap, William, of Hotoft, mercer 2
4862987 2315402 2315402 defendant Keet Thomas fisher 592848 592848 Keet, Thomas, of Hotoft, fisher 0
4865056 2316047 2316047 defendant Pynkes Robert yeoman 592848 592848 Pynkes, Robert, of Hotoft, yeoman 0
4866357 2316445 2316445 defendant Chapell Richard husbandman 592848 592848 Chapell, Richard, of Hotoft, husbandman 0
4867935 2316940 2316940 defendant Gote John husbandman 592848 592848 Gote, John, of Hotoft, husbandman 0
4904954 2328152 2328152 defendant Carter William husbandman 592848 592848 Carter, William, of Hotoft, husbandman 2
4904955 2328152 2328152 defendant Brigg Robert husbandman 592848 592848 Brigg, Robert, of Hotoft, husbandman 3
4931586 2336265 2336265 defendant atte Marre Thomas husbandman 592848 592848 atte Marre, Thomas, of Hotoft, husbandman 0
4948028 2341364 2341364 defendant Sergeant John   592848 592848 Sergeant, John, of Hotoft, bailiff 4
4948048 2341367 2341367 defendant Sergeant John   592848 592848 Sergeant, John, of Hotoft, bailiff 4
4952597 2342737 2342737 defendant Cokson William husbandman 592848 592848 Cokson, William, of Hotoft, husbandman 0
4961281 2345341 2345341 defendant Sergeaunt John   592848 592848 Sergeaunt, John, of Hotoft, bailiff 1
4965693 2346663 2346663 defendant Anx or Aux Alan husbandman 592848 592848 Anx or Aux, Alan, of Hotoft, husbandman 3
4966209 2346826 2346826 defendant Sergeant John husbandman 592848 592848 Sergeant, John, of Hotoft, husbandman 1
4986510 2352894 2352894 defendant Goote John husbandman 592848 592848 Goote, John, of Hotoft, husbandman 0
5001607 2357363 2357363 defendant Sargeaunt John   592848 592848 Sargeaunt, John, of Hotoft, bailiff 1
5018080 2362171 2362171 defendant Whytehals Robert laborer 592848 592848 Whytehals, Robert, of Hotoft, laborer 0
5027892 2365038 2365038 defendant Sergeant John   592848 592848 Sergeant, John, of Hotoft, bailiff 0
5052675 2372394 2372394 defendant Chapell Robert husbandman 592848 592848 Chapell, Robert, of Hotoft, husbandman 1
5082890 2381386 2381386 defendant Oka William husbandman 592848 592848 Oka, William, of Hotoft, husbandman 0
5084061 2381736 2381736 defendant Bust William chapman 592848 592848 Bust, William, of Hotoft, chapman 0
5114437 2390620 2390620 defendant Brigge William husbandman 592848 592848 Brigge, William, of Hotoft, husbandman 0
5128227 2394731 2394731 defendant Goote John husbandman 592848 592848 Goote, John, of Hotoft, husbandman 0
5130243 2395332 2395332 defendant Carter Robert husbandman 592848 592848 Carter, Robert, of Hotoft, husbandman 0
5130244 2395332 2395332 defendant Carter Matilda widow 592848 592848 Carter, Matilda, of Hotoft, widow 1
5137762 2397555 2397555 defendant Chapell Richard husbandman 592848 592848 Chapell, Richard, of Hotoft, husbandman 0
5140103 2398204 2398204 defendant Code William tailor 592848 592848 Code, William, of Hotoft, tailor 0
5161137 2404356 2404356 defendant Cade William tailor 592848 592848 Cade, William, of Hotoft, tailor 0
5215254 2420191 2420191 defendant Route John husbandman 592848 592848 Route, John, of Hotoft, husbandman 0
5216812 2420657 2420657 plaintiff Drax John   592848 592848 Drax, John, of Hotoft 0
5221045 2421858 2421858 defendant Morfote Alan husbandman 592848 592848 Morfote, Alan, of Hotoft, husbandman 0
5227066 2423572 2423572 defendant Route John husbandman 592848 592848 Route, John, of Hotoft, husbandman 0
5230761 2424605 2424605 defendant Pety John husbandman 592848 592848 Pety, John, of Hotoft, husbandman 0
5230762 2424605 2424605 defendant Gote John, junior husbandman 592848 592848 Gote, John, junior, of Hotoft, husbandman 1
5242848 2428113 2428113 defendant Hankeson Alan yeoman 592848 592848 Hankeson, Alan, of Hotoft, yeoman 1
5261757 2433785 2433785 defendant Hankeson or Haukeson Alan yeoman 592848 592848 Hankeson or Haukeson, Alan, of Hotoft, yeoman 1
5281775 2439743 2439743 defendant Carter Robert husbandman 592848 592848 Carter, Robert, of Hotoft, husbandman 0
5281776 2439743 2439743 defendant Wade William butcher 592848 592848 Wade, William, of Hotoft, butcher 1
5281778 2439743 2439743 defendant Saunderson John husbandman 592848 592848 Saunderson, John, of Hotoft, husbandman 3
5281943 2439794 2439794 defendant Saunderson John husbandman 592848 592848 Saunderson, John, of Hotoft, husbandman 0
5281944 2439794 2439794 defendant Wade William butcher 592848 592848 Wade, William, of Hotoft, butcher 1
5289243 2441856 2441856 defendant Freshmare John husbandman 592848 592848 Freshmare, John, of Hotoft, husbandman 6
5303332 2445994 2445994 plaintiff Gote John, sen   592848 592848 Gote, John, sen, of Hotoft 0
5334603 2455418 2455418 defendant Swyn Christopher merchant 592848 592848 Swyn, Christopher, of Hotoft, merchant 0
5334616 2455421 2455421 defendant Swyn Christopher merchant 592848 592848 Swyn, Christopher, of Hotoft, merchant 0
5365784 2464954 2464954 defendant Fresshemer John husbandman 592848 592848 Fresshemer, John, of Hotoft, husbandman 0
5365785 2464954 2464954 defendant Byan John husbandman 592848 592848 Byan, John, of Hotoft, husbandman 1
5365786 2464954 2464954 defendant Godard John husandman 592848 592848 Godard, John, of Hotoft, husandman 2
5372513 2467001 2467001 defendant Markby alias Swyne Christopher merchant 592848 592848 Markby alias Swyne, Christopher, of Hotoft, merchant 0
5372516 2467002 2467002 defendant Markeby alias Swyne Christopher merchant 592848 592848 Markeby alias Swyne, Christopher, of Hotoft, merchant 0
5389459 2472034 2472034 defendant Gote William yeoman 592848 592848 Gote, William, of Hotoft, yeoman 2
5402610 2475820 2475820 defendant Markeby alias Swyne Christopher merchant 592848 592848 Markeby alias Swyne, Christopher, of Hotoft, merchant 0
5415506 2479579 2479579 defendant Markeby Christopher merchant 592848 592848 Markeby, Christopher, of Hotoft, merchant 0
5431842 2484491 2484491 defendant Markeby Christopher merchant 592848 592848 Markeby, Christopher, of Hotoft, merchant 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);