names

87 rows where place_id = 594868

✎ 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
3617905 1873223 1873223 defendant Godeson Thomas husbandman 594868 594868 Godeson, Thomas, of Kyrketon in Holand, husbandman 0
3618332 1873363 1873363 defendant Wheler William husbandman 594868 594868 Wheler, William, of Kyrketon in Holand, husbandman 0
4444145 2183146 2183146 defendant Estwod Robert   594868 594868 Estwod, Robert, of Kyrketon in Holand 0
4530419 2209806 2209806 defendant Staleworth William   594868 594868 Staleworth, William, of Kyrketon in Holand 0
4559192 2218829 2218829 defendant Rogerson Thomas   594868 594868 Rogerson, Thomas, of Kyrketon in Holand 0
4559207 2218833 2218833 defendant Rogerson Thomas   594868 594868 Rogerson, Thomas, of Kyrketon in Holand 0
4570494 2222345 2222345 defendant Kene John   594868 594868 Kene, John, of Kyrketon in Holand 0
4600940 2231520 2231520 defendant Bytham Thomas   594868 594868 Bytham, Thomas, of Kyrketon in Holand 0
4602149 2231893 2231893 defendant Wale Joan   594868 594868 Wale, Joan, of Kyrketon in Holand 3
4604437 2232555 2232555 defendant Hunte Reginald   594868 594868 Hunte, Reginald, of Kyrketon in Holand 0
4606589 2233170 2233170 plaintiff Baly John   594868 594868 Baly, John, of Kyrketon in Holand 0
4617898 2236599 2236599 defendant Hervy Peter   594868 594868 Hervy, Peter, of Kyrketon in Holand 0
4638227 2242725 2242725 defendant Arnold John   594868 594868 Arnold, John, of Kyrketon in Holand, son of Roger 1
4708627 2268073 2268073 plaintiff Olton David   594868 594868 Olton, David, of Kyrketon in Holand 0
4715871 2270278 2270278 defendant Warner John husbandman 594868 594868 Warner, John, of Kyrketon in Holand, husbandman 1
4717200 2270710 2270710 defendant Coke Robert husbandman 594868 594868 Coke, Robert, of Kyrketon in Holand, husbandman 0
4838145 2307853 2307853 defendant Steveneson Thomas husbandman 594868 594868 Steveneson, Thomas, of Kyrketon in Holand, husbandman 1
4839988 2308418 2308418 plaintiff Hervy Peter   594868 594868 Hervy, Peter, of Kyrketon in Holand 0
4846542 2310426 2310426 defendant Bryghty Thomas husbandman 594868 594868 Bryghty, Thomas, of Kyrketon in Holand, son of Alexander, husbandman 0
4854876 2312879 2312879 defendant Bonyn of Bovyn John   594868 594868 Bonyn of Bovyn, John, of Kyrketon in Holand 0
4867309 2316739 2316739 defendant Gery William husbandman 594868 594868 Gery, William, of Kyrketon in Holand, husbandman 0
4867310 2316739 2316739 defendant Rothewell John husbandman 594868 594868 Rothewell, John, of Kyrketon in Holand, husbandman 1
4872598 2318386 2318386 defendant Garner William husbandman 594868 594868 Garner, William, of Kyrketon in Holand, husbandman 0
4888263 2323135 2323135 defendant Maie John husbandman 594868 594868 Maie, John, of Kyrketon in Holand, husbandman 0
4892097 2324270 2324270 defendant Jakson John husbandman 594868 594868 Jakson, John, of Kyrketon in Holand, husbandman 1
4895577 2325286 2325286 defendant Aleyn John husbandman 594868 594868 Aleyn, John, of Kyrketon in Holand, husbandman 0
4895583 2325288 2325288 defendant Garner William husbandman 594868 594868 Garner, William, of Kyrketon in Holand, husbandman 0
4898970 2326323 2326323 defendant Hervy Peter husbandman 594868 594868 Hervy, Peter, of Kyrketon in Holand, husbandman 0
4901036 2326949 2326949 defendant Aleyn John husbandman 594868 594868 Aleyn, John, of Kyrketon in Holand, husbandman 0
4904192 2327922 2327922 defendant Lytilbury Humphrey   594868 594868 Lytilbury, Humphrey, of Kyrketon in Holand, esq, administrators of 0
4904193 2327922 2327922 defendant Lytilbury Anne widow 594868 594868 (Lytilbury, Anne, of Kyrketon in Holand, widow 1
4904196 2327922 2327922 defendant Garner William husbandman 594868 594868 Garner, William, of Kyrketon in Holand, husbandman 4
4929051 2335508 2335508 defendant Hervy Peter husbandman 594868 594868 Hervy, Peter, of Kyrketon in Holand, husbandman 0
4929054 2335509 2335509 defendant Hervy Peter husbandman 594868 594868 Hervy, Peter, of Kyrketon in Holand, husbandman 0
4942205 2339550 2339550 defendant Gybson William (legal representative) 594868 594868 Gybson, William, of Kyrketon in Holand, executrix of 0
4942206 2339550 2339550 defendant Gybson Elizabeth widow 594868 594868 Gybson, Elizabeth, of Kyrketon in Holand, widow 1
4950892 2342246 2342246 defendant Jowetson Richard husbandman 594868 594868 Jowetson, Richard, of Kyrketon in Holand, husbandman 0
4954472 2343304 2343304 defendant Warner John, senior husbandman 594868 594868 Warner, John, senior, of Kyrketon in Holand, husbandman 0
4959091 2344687 2344687 defendant Smyth John husbandman 594868 594868 Smyth, John, of Kyrketon in Holand, husbandman 1
4967838 2347326 2347326 plaintiff Flete Thomas   594868 594868 Flete, Thomas, of Kyrketon in Holand 0
4986742 2352972 2352972 defendant Lyttelbery Robert esq 594868 594868 Lyttelbery, Robert, of Kyrketon in Holand, esq 0
4986744 2352973 2352973 defendant Lyttelbery Robert esq 594868 594868 Lyttelbery, Robert, of Kyrketon in Holand, esq 0
4986894 2353022 2353022 defendant Tathe William chaplain 594868 594868 Tathe, William, of Kyrketon in Holand, chaplain 2
4993930 2355055 2355055 defendant Copuldyk Joan widow 594868 594868 Copuldyk, Joan, of Kyrketon in Holand, widow 0
5002688 2357698 2357698 plaintiff Olton David   594868 594868 Olton, David, of Kyrketon in Holand, vicar 0
5003193 2357835 2357835 defendant Loke Roger husbandman 594868 594868 Loke, Roger, of Kyrketon in Holand, husbandman 0
5015361 2361373 2361373 defendant Jakson John, senior husbandman 594868 594868 Jakson, John, senior, of Kyrketon in Holand, husbandman 0
5018673 2362349 2362349 defendant Smyth Thomas husbandman 594868 594868 Smyth, Thomas, of Kyrketon in Holand, husbandman 7
5021829 2363278 2363278 defendant May John yeoman 594868 594868 May, John, of Kyrketon in Holand, yeoman 0
5021830 2363278 2363278 defendant Wattes William husbandman 594868 594868 Wattes, William, of Kyrketon in Holand, husbandman 1
5021831 2363278 2363278 defendant Wyotte Simon   594868 594868 Wyotte, Simon, of Kyrketon in Holand, shepherd 2
5024447 2364061 2364061 defendant May John husbandman 594868 594868 May, John, of Kyrketon in Holand, husbandman 0
5024448 2364061 2364061 defendant Maltmaker John husbandman 594868 594868 Maltmaker, John, of Kyrketon in Holand, husbandman 1
5027825 2365018 2365018 defendant Jakson John   594868 594868 Jakson, John, of Kyrketon in Holand, husbandman, son of John, son of Alan, of Kyrketon 1
5028256 2365141 2365141 defendant Aleyn John yeoman 594868 594868 Aleyn, John, of Kyrketon in Holand, yeoman 1
5033482 2366676 2366676 defendant Robertson John husbandman 594868 594868 Robertson, John, of Kyrketon in Holand, husbandman 0
5034094 2366837 2366837 defendant Warner John husbandman 594868 594868 Warner, John, of Kyrketon in Holand, husbandman 0
5047224 2370791 2370791 plaintiff Okton David   594868 594868 Okton, David, of Kyrketon in Holand, vicar 0
5047225 2370791 2370791 defendant May John husbandman 594868 594868 May, John, of Kyrketon in Holand, husbandman 0
5047227 2370791 2370791 defendant Arkyll Alan husbandman 594868 594868 Arkyll, Alan, of Kyrketon in Holand, husbandman 2
5047228 2370791 2370791 defendant Hopkynson William husbandman 594868 594868 Hopkynson, William, of Kyrketon in Holand, husbandman 3
5051166 2371963 2371963 defendant Hervy Alan husbandman 594868 594868 Hervy, Alan, of Kyrketon in Holand, husbandman 2
5120114 2392321 2392321 defendant Leweman Thomas husbandman 594868 594868 Leweman, Thomas, of Kyrketon in Holand, husbandman 0
5120115 2392321 2392321 defendant Ayleward Henry husbandman 594868 594868 Ayleward, Henry, of Kyrketon in Holand, husbandman 1
5123592 2393357 2393357 defendant Gery Richard husbandman 594868 594868 Gery, Richard, of Kyrketon in Holand, husbandman 0
5135473 2396887 2396887 defendant Lock Joan widow 594868 594868 Lock, Joan, of Kyrketon in Holand, widow 1
5136776 2397276 2397276 defendant Littelbury Robert   594868 594868 Littelbury, Robert, of Kyrketon in Holand, knight 0
5136924 2397317 2397317 defendant Hobert Richard husbandman 594868 594868 Hobert, Richard, of Kyrketon in Holand, husbandman 0
5136925 2397317 2397317 defendant Warner John husbandman 594868 594868 Warner, John, of Kyrketon in Holand, husbandman 1
5136926 2397317 2397317 defendant Warner William husbandman 594868 594868 Warner, William, of Kyrketon in Holand, husbandman 2
5139826 2398123 2398123 defendant (illegible) Richard smith 594868 594868 --, Richard, of Kyrketon in Holand, smith 3
5152743 2401945 2401945 defendant Fowele Richard yeoman 594868 594868 Fowele, Richard, of Kyrketon in Holand, yeoman 0
5155613 2402797 2402797 defendant Look Henry   594868 594868 Look, Henry, of Kyrketon in Holand 0
5157335 2403284 2403284 defendant Hoberd Richard husbandman 594868 594868 Hoberd, Richard, of Kyrketon in Holand, husbandman 0
5157336 2403284 2403284 defendant Warner John husbandman 594868 594868 Warner, John, of Kyrketon in Holand, husbandman 1
5157337 2403284 2403284 defendant Warner William husbandman 594868 594868 Warner, William, of Kyrketon in Holand, husbandman 2
5157338 2403284 2403284 defendant Pery John husbandman 594868 594868 Pery, John, of Kyrketon in Holand, husbandman 3
5157339 2403284 2403284 defendant Tomson Alan husbandman 594868 594868 Tomson, Alan, of Kyrketon in Holand, husbandman 4
5176285 2408754 2408754 plaintiff Tony Alan merchant 594868 594868 Tony, Alan, of Kyrketon in Holand, merchant 0
5222084 2422162 2422162 defendant Wardon William butcher 594868 594868 Wardon, William, of Kyrketon in Holand, butcher 0
5283914 2440328 2440328 defendant Spendlofe Thomas yeoman 594868 594868 Spendlofe, Thomas, of Kyrketon in Holand, yeoman 3
5315612 2449734 2449734 defendant Bank John yeoman 594868 594868 Bank, John, of Kyrketon in Holand, yeoman 3
5410074 2477973 2477973 defendant Colson John husbandman 594868 594868 Colson, John, of Kyrketon in Holand, husbandman 0
5410075 2477973 2477973 defendant Hopkynson Richard husbandman 594868 594868 Hopkynson, Richard, of Kyrketon in Holand, husbandman 1
5423744 2482066 2482066 defendant Colson John husbandman 594868 594868 Colson, John, of Kyrketon in Holand, husbandman 0
5423745 2482066 2482066 defendant Hopkynson Richard husbandman 594868 594868 Hopkynson, Richard, of Kyrketon in Holand, husbandman 1
5427354 2483126 2483126 defendant Goodson Thomas yeoman 594868 594868 Goodson, Thomas, of Kyrketon in Holand, yeoman 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);