names

67 rows where place_id = 674509

✎ 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
4014333 2029849 2029849 defendant Edward William yeoman 674509 674509 Edward, William, of Stradbrook, yeoman 9
4248254 2112407 2112407 defendant Goddarde William yeoman 674509 674509 Goddarde, William, of Stradbrook, yeoman 0
4499752 2200554 2200554 defendant Hokere John   674509 674509 Hokere, John, of Stradbrook 4
4581292 2225614 2225614 defendant Thacchere John   674509 674509 Thacchere, John, of Stradbrook 0
4604187 2232479 2232479 defendant Aldhous William clerk 674509 674509 Aldhous, William, of Stradbrook, son of John, clerk 0
4635036 2241805 2241805 defendant Nene John   674509 674509 Nene, John, of Stradbrook 5
4635727 2242017 2242017 defendant Thakkere John   674509 674509 Thakkere, John, of Stradbrook 3
4717734 2270883 2270883 defendant Thakkere John yeoman 674509 674509 Thakkere, John, of Stradbrook, yeoman 0
4735602 2276286 2276286 defendant Lenemere Robert esq 674509 674509 Lenemere, Robert, of Stradbrook, esq 0
4818004 2301713 2301713 plaintiff Neve John   674509 674509 Neve, John, of Stradbrook 0
4822057 2302974 2302974 defendant Scrok Thomas yeoman 674509 674509 Scrok, Thomas, of Stradbrook, yeoman 3
4826240 2304242 2304242 defendant Nene John yeoman 674509 674509 Nene, John, of Stradbrook, yeoman 0
4881813 2321211 2321211 defendant Fygge John husbandman 674509 674509 Fygge, John, of Stradbrook, husbandman 1
4919228 2332524 2332524 plaintiff Hervy Thomas butcher 674509 674509 Hervy, Thomas, of Stradbrook, butcher 0
5005707 2358565 2358565 defendant Seman John yeoman 674509 674509 Seman, John, of Stradbrook, yeoman 0
5015379 2361378 2361378 defendant Seman John, senior husbandman 674509 674509 Seman, John, senior, of Stradbrook, husbandman 0
5015381 2361378 2361378 defendant Hervy Thomas yeoman 674509 674509 Hervy, Thomas, of Stradbrook, yeoman 2
5023951 2363918 2363918 plaintiff Hervy Nicholas   674509 674509 Hervy, Nicholas, of Stradbrook, "greser" 0
5024572 2364100 2364100 defendant Burghassh Robert yeoman 674509 674509 Burghassh, Robert, of Stradbrook, yeoman 2
5048215 2371097 2371097 defendant Chittyng William   674509 674509 Chittyng, William, of Stradbrook, mason 0
5061366 2374983 2374983 defendant Hamond John carpenter 674509 674509 Hamond, John, of Stradbrook, carpenter 1
5062412 2375324 2375324 plaintiff Goldewyn Roger mercer 674509 674509 Goldewyn, Roger, of Stradbrook, mercer 2
5080255 2380583 2380583 defendant Furmage John, junior butcher 674509 674509 Furmage, John, junior, of Stradbrook, butcher 2
5084634 2381919 2381919 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5084635 2381919 2381919 defendant Gerlyng William yeoman 674509 674509 Gerlyng, William, of Stradbrook, yeoman 0
5084639 2381920 2381920 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5084640 2381920 2381920 defendant Gerlyng William yeoman 674509 674509 Gerlyng, William, of Stradbrook, yeoman 0
5091494 2383902 2383902 defendant Hervy Nicholas yeoman 674509 674509 Hervy, Nicholas, of Stradbrook, yeoman 0
5104267 2387669 2387669 defendant Fedyon John skinner 674509 674509 Fedyon, John, of Stradbrook, skinner 7
5118669 2391889 2391889 defendant Furmage John yeoman 674509 674509 Furmage, John, of Stradbrook, yeoman 2
5131421 2395678 2395678 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5131422 2395678 2395678 defendant Gerlyng William yeoman 674509 674509 Gerlyng, William, of Stradbrook, yeoman 0
5150929 2401409 2401409 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5150930 2401409 2401409 defendant Gerlyng William yeoman 674509 674509 Gerlyng, William, of Stradbrook, yeoman 0
5169233 2406740 2406740 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5169234 2406740 2406740 defendant Gerlyng William yeoman 674509 674509 Gerlyng, William, of Stradbrook, yeoman 0
5185861 2411612 2411612 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5204963 2417198 2417198 plaintiff Heryng Thomas   674509 674509 Heryng, Thomas, of Stradbrook 3
5204964 2417198 2417198 defendant Gerlyng William yeoman 674509 674509 Gerlyng, William, of Stradbrook, yeoman 0
5220805 2421777 2421777 defendant Hervy Edmund yeoman 674509 674509 Hervy, Edmund, of Stradbrook, yeoman 0
5220806 2421777 2421777 defendant Berte William husbandman 674509 674509 Berte, William, of Stradbrook, husbandman 1
5220807 2421777 2421777 defendant Jurdon Thomas husbandman 674509 674509 Jurdon, Thomas, of Stradbrook, husbandman 2
5220808 2421777 2421777 defendant Seman Edmund husbandman 674509 674509 Seman, Edmund, of Stradbrook, husbandman 3
5248723 2429746 2429746 defendant Furmage Stephen   674509 674509 Furmage, Stephen, of Stradbrook, yeoman, et al 0
5268614 2435940 2435940 defendant Seman John chapman 674509 674509 Seman, John, of Stradbrook, chapman 0
5397491 2474358 2474358 defendant Furnage Henry yeoman 674509 674509 Furnage, Henry, of Stradbrook, yeoman 10
5424664 2482337 2482337 defendant Furmage Henry yeoman 674509 674509 Furmage, Henry, of Stradbrook, yeoman 10
5428385 2483415 2483415 defendant Hollond William yeoman 674509 674509 Hollond, William, of Stradbrook, yeoman 2
5428386 2483415 2483415 defendant Banok William yeoman 674509 674509 Banok, William, of Stradbrook, yeoman 3
5428390 2483416 2483416 defendant Hollond William yeoman 674509 674509 Hollond, William, of Stradbrook, yeoman 2
5428391 2483416 2483416 defendant Banok William yeoman 674509 674509 Banok, William, of Stradbrook, yeoman 3
5443391 2487938 2487938 defendant Furmage Henry   674509 674509 Furmage, Henry, of Stradbrook 8
5445750 2488616 2488616 defendant Hollond William yeoman 674509 674509 Hollond, William, of Stradbrook, yeoman 1
5445751 2488616 2488616 defendant Banok William yeoman 674509 674509 Banok, William, of Stradbrook, yeoman 2
5445755 2488617 2488617 defendant Hollond William yeoman 674509 674509 Hollond, William, of Stradbrook, yeoman 2
5445756 2488617 2488617 defendant Banck William yeoman 674509 674509 Banck, William, of Stradbrook, yeoman 3
5452045 2490492 2490492 plaintiff Cloutyng William   674509 674509 Cloutyng, William, of Stradbrook 1
5463983 2494145 2494145 plaintiff Cloutyng William   674509 674509 Cloutyng, William, of Stradbrook 1
5500748 2505165 2505165 defendant Seman John (legal representative) 674509 674509 Seman, John, of Stradbrook, chandler, executors of 0
5500749 2505165 2505165 defendant Smyth William tanner 674509 674509 (Smyth, William, of Stradbrook, tanner 1
5500750 2505165 2505165 defendant Cloutyng or Clontyng Thomas pedder 674509 674509 Cloutyng or Clontyng, Thomas, of Stradbrook, pedder 2
5509113 2507704 2507704 defendant Holland William yeoman 674509 674509 Holland, William, of Stradbrook, yeoman 1
5509114 2507704 2507704 defendant Banok William yeoman 674509 674509 Banok, William, of Stradbrook, yeoman 2
5515249 2509616 2509616 defendant Seman John   674509 674509 Seman, John, of Stradbrook, chandler, administrators of 0
5515250 2509616 2509616 defendant Cloutyng Thomas pedder 674509 674509 (Cloutyng, Thomas, of Stradbrook, pedder 1
5515251 2509616 2509616 defendant Smyth William tanner 674509 674509 Smyth, William, of Stradbrook, tanner 2
5554449 2521337 2521337 plaintiff Hervy Nicholas   674509 674509 Hervy, Nicholas, of Stradbrook 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);