names

105 rows where place_id = 596960

✎ 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
3626757 1903215 1903215 defendant Joyce William husbandman 596960 596960 Joyce, William, of Staundon, or of Hertford, husbandman 0
3626759 1903216 1903216 defendant Kyrkby John tanner 596960 596960 Kyrkby, John, of Staundon, tanner 0
3634503 1905592 1905592 defendant Vyes John yeoman 596960 596960 Vyes, John, of Staundon, yeoman 0
3642384 1908063 1908063 defendant ap Hoell Philip yeoman 596960 596960 ap Hoell, Philip, of Staundon, yeoman 2
3650978 1910675 1910675 defendant Harold Robert yeoman 596960 596960 Harold, Robert, of Staundon, yeoman 2
3668973 1916228 1916228 defendant Kyrkeby John yeoman 596960 596960 Kyrkeby, John, of Staundon, yeoman 1
3668974 1916228 1916228 defendant Skyngyll John husbandman 596960 596960 Skyngyll, John, of Staundon, husbandman 2
3679527 1919667 1919667 defendant Bedall William husbandman 596960 596960 Bedall, William, of Staundon, husbandman 0
3809139 1960742 1960742 defendant Broke William innholder 596960 596960 Broke, William, of Staundon, innholder 0
3868904 1979840 1979840 defendant Sabaker Richard husbandman 596960 596960 Sabaker, Richard, of Staundon, husbandman 1
3881412 1984045 1984045 defendant Gytto John husbandman 596960 596960 Gytto, John, of Staundon, husbandman 2
3897098 1989248 1989248 defendant Badland Roger husbandman 596960 596960 Badland, Roger, of Staundon, husbandman 3
3897103 1989250 1989250 defendant Robertys Ralph laborer 596960 596960 Robertys, Ralph, of Staundon, laborer 0
3917653 1996261 1996261 defendant Vise Humphrey yeoman 596960 596960 Vise, Humphrey, of Staundon, yeoman 0
3960978 2010936 2010936 defendant Rowland Roger weaver 596960 596960 Rowland, Roger, of Staundon, weaver 0
3965363 2012501 2012501 defendant Kerver John weaver 596960 596960 Kerver, John, of Staundon, weaver 2
4073808 2050924 2050924 defendant Gytto John yeoman 596960 596960 Gytto, John, of Staundon, yeoman 0
4073809 2050924 2050924 defendant Jefreys Roger yeoman 596960 596960 Jefreys, Roger, of Staundon, yeoman 1
4101256 2060755 2060755 defendant Nokes William yeoman 596960 596960 Nokes, William, of Staundon, yeoman 0
4153777 2079421 2079421 defendant Vyes Wlliam gent 596960 596960 Vyes, Wlliam, of Staundon, gent 0
4153778 2079421 2079421 defendant Walker Hugh husbandman 596960 596960 Walker, Hugh, of Staundon, husbandman 1
4185377 2090398 2090398 defendant Amyson Thomas husbandman 596960 596960 Amyson, Thomas, of Staundon, husbandman 0
4185378 2090398 2090398 defendant Kenricke John husbandman 596960 596960 Kenricke, John, of Staundon, husbandman 1
4222622 2103404 2103404 defendant Hill Walter yeoman 596960 596960 Hill, Walter, of Staundon, yeoman 0
4353467 2148436 2148436 defendant Caldwall Henry blacksmith 596960 596960 Caldwall, Henry, of Staundon, blacksmith 0
4413216 2169006 2169006 plaintiff atte Watere Agnes   596960 596960 atte Watere, Agnes, of Staundon, formerly wife of John 0
4414755 2169517 2169517 defendant Sone or Sove John   596960 596960 Sone or Sove, John, of Staundon, son of Robert 0
4422302 2171842 2171842 defendant Canoun Augustine   596960 596960 Canoun, Augustine, of Staundon 0
4427648 2173484 2173484 plaintiff Seriaunt John le   596960 596960 Seriaunt, John le, of Staundon 0
4427650 2173485 2173485 plaintiff Seriaunt John le   596960 596960 Seriaunt, John le, of Staundon 0
4434541 2175560 2175560 defendant Regewyne John   596960 596960 Regewyne, John, of Staundon 0
4498700 2200229 2200229 defendant Bryan John   596960 596960 Bryan, John, of Staundon 0
4499016 2200334 2200334 plaintiff Goudlok Robert   596960 596960 Goudlok, Robert, of Staundon 0
4499017 2200334 2200334 defendant Osebern Richard   596960 596960 Osebern, Richard, of Staundon 0
4546703 2214893 2214893 plaintiff Brugge John   596960 596960 Brugge, John, of Staundon 2
4552506 2216739 2216739 defendant atte Mere William   596960 596960 atte Mere, William, of Staundon 0
4554121 2217211 2217211 defendant Bocok Thomas   596960 596960 Bocok, Thomas, of Staundon 0
4554123 2217212 2217212 defendant Bocok Thomas   596960 596960 Bocok, Thomas, of Staundon 0
4554125 2217213 2217213 defendant Bocok Thomas   596960 596960 Bocok, Thomas, of Staundon 0
4563627 2220189 2220189 defendant Bette Adam (legal representative) 596960 596960 Bette, Adam, of Staundon, executors of 0
4563630 2220190 2220190 plaintiff Rogewyne John   596960 596960 Rogewyne, John, of Staundon 0
4563633 2220191 2220191 plaintiff Rogewyne John   596960 596960 Rogewyne, John, of Staundon 0
4572397 2222906 2222906 defendant Prys William   596960 596960 Prys, William, of Staundon 0
4585005 2226738 2226738 defendant Grynne William   596960 596960 Grynne, William, of Staundon 0
4593821 2229343 2229343 defendant Baron Robert   596960 596960 Baron, Robert, of Staundon 0
4637993 2242646 2242646 defendant Boydell Geoffrey   596960 596960 Boydell, Geoffrey, of Staundon 0
4642555 2243943 2243943 defendant Brugge John esq 596960 596960 Brugge, John, of Staundon, esq 1
4655533 2247625 2247625 plaintiff Brugge John   596960 596960 Brugge, John, of Staundon 0
4666082 2250858 2250858 defendant Basset Roger clerk 596960 596960 (Basset, Roger, of Staundon, clerk 1
4666083 2250858 2250858 defendant Rugewyn Margery gentlewoman 596960 596960 Rugewyn, Margery, of Staundon, widow, gentlewoman 2
4666086 2250859 2250859 defendant Basset Roger clerk 596960 596960 (Basset, Roger, of Staundon, clerk 1
4666087 2250859 2250859 defendant Rugewyn Margery gentlewoman 596960 596960 Rugewyn, Margery, of Staundon, widow, gentlewoman 2
4681475 2259821 2259821 plaintiff Mayll John   596960 596960 Mayll, John, of Staundon, 0
4681476 2259821 2259821 defendant Prys William husbandman 596960 596960 Prys, William, of Staundon, husbandman 0
4681477 2259821 2259821 defendant Prys Richard husbandman 596960 596960 Prys, Richard, of Staundon, husbandman 1
4685669 2261109 2261109 defendant Cokhowe John yeoman 596960 596960 Cokhowe, John, of Staundon, yeoman 1
4702453 2266177 2266177 defendant Bawede Thomas esq 596960 596960 Bawede, Thomas, of Staundon, esq 0
4717923 2270946 2270946 defendant Boton John husbandman 596960 596960 Boton, John, of Staundon, husbandman 0
4717927 2270946 2270946 defendant Hunt John yeoman 596960 596960 (Hunt, John, of Staundon, yeoman 4
4722726 2272425 2272425 defendant Hert Thomas husbandman 596960 596960 Hert, Thomas, of Staundon, husbandman 1
4729185 2274349 2274349 defendant Edward John carpenter 596960 596960 Edward, John, of Staundon, carpenter 0
4740054 2277607 2277607 plaintiff Astilley Ralph   596960 596960 Astilley, Ralph, of Staundon 0
4748068 2279946 2279946 defendant atte Wode John husbandman 596960 596960 atte Wode, John, of Staundon, husbandman 2
4751310 2280861 2280861 defendant fuller Walter husbandman 596960 596960 fuller, Walter, of Staundon, husbandman 1
4755824 2282204 2282204 defendant Deresale Thomas laborer 596960 596960 Deresale, Thomas, of Staundon, laborer 1
4766251 2285436 2285436 defendant Tebawede Robert husbandman 596960 596960 Tebawede, Robert, of Staundon, husbandman 0
4766252 2285436 2285436 defendant Fuller Walter husbandman 596960 596960 Fuller, Walter, of Staundon, husbandman 1
4827517 2304654 2304654 defendant Prys William husbandman 596960 596960 Prys, William, of Staundon, husbandman 0
4828762 2305036 2305036 defendant Halle John husbandman 596960 596960 Halle, John, of Staundon, husbandman 2
4829340 2305216 2305216 defendant White Richard butcher 596960 596960 White, Richard, of Staundon, butcher 0
4830700 2305628 2305628 defendant White Richard butcher 596960 596960 White, Richard, of Staundon, butcher 0
4843862 2309599 2309599 defendant Curre John, sen husbandman 596960 596960 Curre, John, sen, of Staundon, husbandman 0
4861654 2315019 2315019 defendant Caleys Thomas gent 596960 596960 Caleys, Thomas, of Staundon, gent 0
4861655 2315019 2315019 defendant Bryt John husbandman 596960 596960 Bryt, John, of Staundon, husbandman 1
4890339 2323746 2323746 defendant atte Water Walter gent 596960 596960 atte Water, Walter, of Staundon, gent 0
4927081 2334900 2334900 defendant Caleys Thomas (legal representative) 596960 596960 Caleys, Thomas, of Staundon, gent, executor of 3
4928741 2335416 2335416 plaintiff Sparowe John   596960 596960 Sparowe, John, of Staundon 0
4953664 2343059 2343059 defendant White Thomas butcher 596960 596960 White, Thomas, of Staundon, butcher 2
4985950 2352714 2352714 defendant Chabbenore John gent 596960 596960 Chabbenore, John, of Staundon, gent 0
4994868 2355317 2355317 defendant Turnour Thomas husbandman 596960 596960 Turnour, Thomas, of Staundon, husbandman 2
5054091 2372818 2372818 plaintiff Berley Richard   596960 596960 Berley, Richard, of Staundon 0
5092933 2384318 2384318 defendant Ledys Thomas chapman 596960 596960 Ledys, Thomas, of Staundon, chapman 0
5092935 2384319 2384319 defendant Purye Thomas husbandman 596960 596960 Purye, Thomas, of Staundon, husbandman 0
5111289 2389691 2389691 defendant North Henry butcher 596960 596960 North, Henry, of Staundon, butcher 4
5118742 2391912 2391912 defendant Benet Richard husbandman 596960 596960 Benet, Richard, of Staundon, husbandman 0
5174686 2408297 2408297 defendant Chabbenore John (legal representative) 596960 596960 Chabbenore, John, of Staundon, executrix of 0
5174687 2408297 2408297 defendant Chabbenore Joan widow 596960 596960 Chabbenore, Joan, of Staundon, widow 1
5179433 2409719 2409719 defendant Sterlyng John butcher 596960 596960 Sterlyng, John, of Staundon, butcher 0
5201911 2416323 2416323 defendant Sterlyng John butcher 596960 596960 Sterlyng, John, of Staundon, butcher 0
5308908 2447707 2447707 defendant Asteley Philip esq 596960 596960 Asteley, Philip, of Staundon, esq 0
5308910 2447708 2447708 defendant Asteley Philip esq 596960 596960 Asteley, Philip, of Staundon, esq 0
5308925 2447714 2447714 defendant Danyell John husbandman 596960 596960 Danyell, John, of Staundon, husbandman 0
5308927 2447715 2447715 defendant Danyell John husbandman 596960 596960 Danyell, John, of Staundon, husbandman 0
5325922 2452840 2452840 defendant Asteley Philip esq 596960 596960 Asteley, Philip, of Staundon, esq 0
5325936 2452846 2452846 defendant Danyell John husbandman 596960 596960 Danyell, John, of Staundon, husbandman 0
5496498 2503861 2503861 defendant Birde John yeoman 596960 596960 Birde, John, of Staundon, yeoman 0
5511451 2508426 2508426 defendant Birde John yeoman 596960 596960 Birde, John, of Staundon, yeoman 0
5511453 2508427 2508427 defendant Birde John yeoman 596960 596960 Birde, John, of Staundon, yeoman 0
5518518 2510622 2510622 defendant Noke William husbandman 596960 596960 Noke, William, of Staundon, husbandman 0
5525299 2512505 2512505 defendant Turnour Thomas husbandman 596960 596960 Turnour, Thomas, of Staundon, husbandman 1

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