names

73 rows where place_id = 603829

✎ 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
3655913 1912102 1912102 defendant Spycer James writer & guardian as above 603829 603829 Spycer, James, of Basingstoke, writer & guardian as above 4
3974995 2015817 2015817 plaintiff Hollowey Roland mercer 603829 603829 Hollowey, Roland, of Basingstoke, mercer 0
3975097 2015852 2015852 plaintiff Hopkyns John innholder 603829 603829 Hopkyns, John, of Basingstoke, innholder 0
4064906 2047733 2047733 plaintiff Hannyngton Henry husbandman 603829 603829 Hannyngton, Henry, of Basingstoke, husbandman 0
4073237 2050720 2050720 plaintiff Petty John clothier 603829 603829 Petty, John, of Basingstoke, clothier 0
4092776 2057725 2057725 defendant Puckerydge Richard (legal representative) 603829 603829 Puckerydge, Richard, of Basingstoke, mercer, administratrix of 0
4092777 2057725 2057725 defendant Puckerydge Agnes widow 603829 603829 Puckerydge, Agnes, of Basingstoke, widow 1
4096348 2059025 2059025 defendant Lypscome John (legal representative) 603829 603829 Lypscome, John, of Basingstoke, husbandman, executors of 0
4107328 2062911 2062911 defendant Southe Clement clothier 603829 603829 Southe, Clement, of Basingstoke, clothier 0
4113628 2065156 2065156 defendant Cowslade Jane widow 603829 603829 Cowslade, Jane, of Basingstoke, widow 0
4113630 2065157 2065157 defendant Cowslade Jane widow 603829 603829 Cowslade, Jane, of Basingstoke, widow 0
4113632 2065158 2065158 defendant Cowslade Jane widow 603829 603829 Cowslade, Jane, of Basingstoke, widow 0
4120568 2067633 2067633 defendant Puckeridge Agnes widow 603829 603829 Puckeridge, Agnes, of Basingstoke, widow 1
4120572 2067634 2067634 defendant Puckeridge Agnes widow 603829 603829 Puckeridge, Agnes, of Basingstoke, widow 1
4187932 2091279 2091279 defendant Potecary Thomas clothier 603829 603829 Potecary, Thomas, of Basingstoke, or of Wilton, Wilts, clothier 0
4209014 2098705 2098705 defendant Turner Walter   603829 603829 Turner, Walter, of Basingstoke, yeoman, servant of Lord Bartlett 0
4212781 2100008 2100008 defendant Smyth Garrett merchant 603829 603829 Smyth, Garrett, of Basingstoke, merchant 0
4212782 2100008 2100008 defendant Purchis Thomas dyer 603829 603829 Purchis, Thomas, of Basingstoke, dyer 1
4212783 2100008 2100008 defendant Wyn alias Hyll John merchant 603829 603829 Wyn alias Hyll, John, of Basingstoke, merchant 2
4279672 2122809 2122809 defendant Baker Thomas innholder 603829 603829 Baker, Thomas, of Basingstoke, yeoman, or of Bagshott, Surrey, innholder 0
4311591 2134195 2134195 defendant West William   603829 603829 West, William, of Basingstoke, woollen draper 0
4319304 2136861 2136861 defendant Walwynne William gent 603829 603829 Walwynne, William, of Basingstoke, or of Readinge, Berks, gent 0
4351316 2147710 2147710 defendant Dowce John yeoman 603829 603829 Dowce, John, of Basingstoke, or of Overton, yeoman 0
4351318 2147711 2147711 defendant Wadlowe Rumbold yeoman 603829 603829 Wadlowe, Rumbold, of Basingstoke, or of Overton, yeoman 0
4375498 2156291 2156291 defendant Shackleford Robert husbandman 603829 603829 Shackleford, Robert, of Basingstoke, or of Bramshill, Heckefeild, husbandman 0
4375499 2156291 2156291 defendant Nasshe Thomas yeoman 603829 603829 Nasshe, Thomas, of Basingstoke, or of Mattingley, Heckefeild, yeoman 1
4375501 2156291 2156291 defendant Wyckyns John husbandman 603829 603829 Wyckyns, John, of Basingstoke, or of West Sherborne, husbandman 3
4375503 2156292 2156292 defendant Walwyn Richard sherman 603829 603829 Walwyn, Richard, of Basingstoke, or of Eversley, sherman 0
4375504 2156292 2156292 defendant Wyck or Wykes John husbandman 603829 603829 Wyck or Wykes, John, of Basingstoke, or of Eversley, husbandman 1
4375511 2156295 2156295 defendant Style John yeoman 603829 603829 Style, John, of Basingstoke, or of West Sherborne, yeoman 0
4375513 2156296 2156296 defendant Payne Richard clothier 603829 603829 Payne, Richard, of Basingstoke, or of Eversley, clothier 0
4375514 2156296 2156296 defendant Payne Guy clothier 603829 603829 Payne, Guy, of Basingstoke, or of Eversley, clothier 1
4375516 2156297 2156297 defendant Downe John yeoman 603829 603829 Downe, John, of Basingstoke, or of Overton, yeoman 0
4375517 2156297 2156297 defendant Wadlowe Rumbold yeoman 603829 603829 Wadlowe, Rumbold, of Basingstoke, or of Overton, yeoman 1
4464024 2189418 2189418 defendant Rede Roger   603829 603829 Rede, Roger, of Basingstoke 1
4541080 2213119 2213119 plaintiff Surman John   603829 603829 Surman, John, of Basingstoke 1
4606524 2233153 2233153 plaintiff Baldok John   603829 603829 Baldok, John, of Basingstoke 0
4641173 2243509 2243509 defendant Langcrofte Thomas   603829 603829 Langcrofte, Thomas, of Basingstoke 3
4647381 2245292 2245292 defendant Clerk John   603829 603829 Clerk, John, of Basingstoke 0
4647567 2245346 2245346 defendant Tawke William   603829 603829 Tawke, William, of Basingstoke 1
4696898 2264510 2264510 defendant Milbourne Thomas ostler 603829 603829 Milbourne, Thomas, of Basingstoke, ostler 0
4713949 2269691 2269691 defendant Grete Richard butcher 603829 603829 Grete, Richard, of Basingstoke, butcher 0
4713970 2269698 2269698 defendant Fyge John ostler 603829 603829 Fyge, John, of Basingstoke, ostler 0
4714240 2269784 2269784 defendant Fugge John hosteller 603829 603829 Fugge, John, of Basingstoke, hosteller 0
4715584 2270202 2270202 defendant Fyges John ostler 603829 603829 Fyges, John, of Basingstoke, ostler 0
4715685 2270234 2270234 defendant Wook Richard   603829 603829 Wook, Richard, of Basingstoke, shepherd 0
4715687 2270235 2270235 defendant Wyther Richard husbandman 603829 603829 Wyther, Richard, of Basingstoke, husbandman 0
4715689 2270236 2270236 defendant Cateklyne Thomas   603829 603829 Cateklyne, Thomas, of Basingstoke, shepherd 0
4716468 2270469 2270469 defendant Heelde John   603829 603829 Heelde, John, of Basingstoke, sutor or cobbler 0
4717182 2270704 2270704 defendant Bourde John baker 603829 603829 Bourde, John, of Basingstoke, baker 0
4753562 2281487 2281487 defendant Wyke Smyth Edmund husbandman 603829 603829 (Wyke Smyth, Edmund, of Basingstoke, husbandman 1
4755859 2282214 2282214 defendant Molyns Henry   603829 603829 Molyns, Henry, of Basingstoke, shepherd 0
4756421 2282371 2282371 defendant Talbot William husbandman 603829 603829 Talbot, William, of Basingstoke, husbandman 0
4757786 2282811 2282811 defendant Tanke or Tauke William gent 603829 603829 Tanke or Tauke, William, of Basingstoke, gent 0
4759465 2283302 2283302 defendant Tauk William esq 603829 603829 Tauk, William, of Basingstoke, esq 0
4770667 2286807 2286807 defendant Talbot William husbandman 603829 603829 Talbot, William, of Basingstoke, husbandman 0
4823719 2303508 2303508 defendant Taweke Edmund gent 603829 603829 Taweke, Edmund, of Basingstoke, gent 0
4850691 2311672 2311672 defendant Role John yeoman 603829 603829 Role, John, of Basingstoke, yeoman 1
5001779 2357418 2357418 defendant Somer Thomas smith 603829 603829 Somer, Thomas, of Basingstoke, smith 0
5010360 2359899 2359899 defendant White John laborer 603829 603829 White, John, of Basingstoke, laborer 0
5010362 2359899 2359899 defendant Carter William laborer 603829 603829 Carter, William, of Basingstoke, laborer 2
5170554 2407109 2407109 plaintiff Hore William merchant 603829 603829 Hore, William, of Basingstoke, merchant 0
5180643 2410082 2410082 defendant Whyte William husbandman 603829 603829 Whyte, William, of Basingstoke, husbandman 3
5184768 2411295 2411295 defendant Elwyke Henry clerk 603829 603829 Elwyke, Henry, of Basingstoke, clerk 0
5204501 2417070 2417070 defendant Elwyke Henry clerk 603829 603829 Elwyke, Henry, of Basingstoke, clerk 0
5207530 2417943 2417943 defendant Nicholas William ostler 603829 603829 Nicholas, William, of Basingstoke, ostler 4
5211106 2418974 2418974 defendant Croucher William husbandman 603829 603829 Croucher, William, of Basingstoke, husbandman 4
5297468 2444262 2444262 defendant Grene John butcher 603829 603829 Grene, John, of Basingstoke, butcher 0
5310482 2448172 2448172 defendant Talbot John yeoman 603829 603829 Talbot, John, of Basingstoke, yeoman 0
5310485 2448172 2448172 defendant Drewe Simon laborer 603829 603829 Drewe, Simon, of Basingstoke, laborer 3
5407684 2477269 2477269 defendant Yong Richard   603829 603829 Yong, Richard, of Basingstoke 0
5450617 2490065 2490065 defendant Drewe Simon mercer 603829 603829 Drewe, Simon, of Basingstoke, mercer 1
5621220 2550521 2550521 defendant Anne Robert de   603829 603829 Anne, Robert de, of Basingstoke 2

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