names

146 rows where place_id = 598270

✎ 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
3593917 1865736 1865736 defendant Wydeslade Mary widow 598270 598270 Wydeslade, Mary, of Bokelond Bruer, widow 0
3605107 1869262 1869262 defendant Stoweford John husbandman 598270 598270 Stoweford, John, of Bokelond Bruer, husbandman 2
3631801 1904753 1904753 plaintiff Gylle Thomas   598270 598270 Gylle, Thomas, of Bokelond 0
3646247 1909216 1909216 defendant Hodge John yeoman 598270 598270 Hodge, John, of Bokelond Bruer, yeoman 0
3646248 1909216 1909216 defendant Combe John yeoman 598270 598270 Combe, John, of Bokelond Bruer, yeoman 1
3664945 1914981 1914981 defendant Denys Henry   598270 598270 Denys, Henry, of Bokelond, Frankelyn 0
3697985 1925595 1925595 defendant Thorne Edward husbandman 598270 598270 Thorne, Edward, of Bokelond Bruer, husbandman 0
3697986 1925595 1925595 defendant Knyght Richard husbandman 598270 598270 Knyght, Richard, of Bokelond Bruer, husbandman 1
3711754 1929990 1929990 defendant Thorne Baldwin husbandman 598270 598270 Thorne, Baldwin, of Bokelond Bruer, husbandman 0
3711755 1929990 1929990 defendant Knyght Richard husbandman 598270 598270 Knyght, Richard, of Bokelond Bruer, husbandman 1
3789406 1954511 1954511 plaintiff Thornton Henry esq 598270 598270 Thornton, Henry, of Bokelond, esq 0
3794963 1956288 1956288 defendant Fote John fuller 598270 598270 Fote, John, of Bokelond, fuller 3
3846879 1972564 1972564 defendant Shepard Walter   598270 598270 Shepard, Walter, of Bokelond, cook 18
4433243 2175150 2175150 defendant Claworth Thomas de   598270 598270 Claworth, Thomas de, of Bokelond, parson 0
4466918 2190327 2190327 plaintiff Asshelokke Thomas   598270 598270 Asshelokke, Thomas, of Bokelond 0
4509601 2203478 2203478 defendant Muleward William   598270 598270 Muleward, William, of Bokelond 0
4531121 2210012 2210012 defendant Clerk John   598270 598270 Clerk, John, of Bokelond 0
4534826 2211175 2211175 defendant atte Water Andrew   598270 598270 atte Water, Andrew, of Bokelond 0
4535664 2211430 2211430 plaintiff Smyth Roger   598270 598270 Smyth, Roger, of Bokelond 0
4553437 2217004 2217004 plaintiff Wallere John   598270 598270 Wallere, John, of Bokelond, parson 1
4565481 2220775 2220775 plaintiff Smyth Roger   598270 598270 Smyth, Roger, of Bokelond 0
4584364 2226523 2226523 defendant Milleward Thomas   598270 598270 Milleward, Thomas, of Bokelond 0
4602038 2231859 2231859 plaintiff Warner Robert   598270 598270 Warner, Robert, of Bokelond 0
4602039 2231859 2231859 defendant Buset Henry   598270 598270 Buset, Henry, of Bokelond, formerly vicar 0
4641383 2243574 2243574 defendant Warner Robert   598270 598270 Warner, Robert, of Bokelond 0
4647523 2245335 2245335 plaintiff Shepherde John   598270 598270 Shepherde, John, of Bokelond 0
4671152 2256641 2256641 defendant Skynnere William shoemaker 598270 598270 Skynnere, William, of Bokelond, shoemaker 1
4678438 2258863 2258863 defendant Thorn John husbandman 598270 598270 Thorn, John, of Bokelond, husbandman 0
4698853 2265123 2265123 defendant Trota Nicholas chaplain 598270 598270 Trota, Nicholas, of Bokelond, chaplain 0
4700808 2265651 2265651 defendant Wodward John   598270 598270 Wodward, John, of Bokelond 3
4701767 2265952 2265952 plaintiff Godet Robert   598270 598270 Godet, Robert, of Bokelond 0
4702326 2266137 2266137 plaintiff Gylle Richard   598270 598270 Gylle, Richard, of Bokelond 0
4727863 2273956 2273956 defendant Thorn John husbandman 598270 598270 Thorn, John, of Bokelond, husbandman 0
4738723 2277199 2277199 plaintiff Wodeward John   598270 598270 Wodeward, John, of Bokelond 1
4739249 2277365 2277365 defendant Kempe Richard laborer 598270 598270 Kempe, Richard, of Bokelond, laborer 3
4740122 2277627 2277627 defendant Aylewyn John husbandman 598270 598270 Aylewyn, John, of Bokelond, husbandman 1
4760649 2283675 2283675 defendant Odam John   598270 598270 Odam, John, of Bokelond, mason 0
4777464 2288947 2288947 defendant Edam John   598270 598270 Edam, John, of Bokelond, mason 0
4780629 2289940 2289940 defendant Bycombe Richard husbandman 598270 598270 Bycombe, Richard, of Bokelond, husbandman 0
4784206 2291058 2291058 defendant Shourterygge John husbandman 598270 598270 Shourterygge, John, of Bokelond Bruer, husbandman 0
4785770 2291586 2291586 plaintiff Warner Robert   598270 598270 Warner, Robert, of Bokelond 3
4789069 2292637 2292637 defendant Elys Henry tailor 598270 598270 Elys, Henry, of Bokelond Brewer, tailor 0
4796696 2295119 2295119 defendant Brutte John (legal representative) 598270 598270 Brutte, John, of Bokelond, executor of 0
4796697 2295119 2295119 defendant Brutte Andrew husbandman 598270 598270 Brutte, Andrew, of Bokelond, husbandman 1
4796699 2295120 2295120 defendant Brutte Andrew husbandman 598270 598270 Brutte, Andrew, of Bokelond, husbandman 0
4822086 2302984 2302984 defendant Redeclyf William chapman 598270 598270 Redeclyf, William, of Bokelond, in the Moor, chapman 0
4871062 2317923 2317923 defendant Harry Richard butcher 598270 598270 (Harry, Richard, of Bokelond Brewer, butcher 4
4875183 2319191 2319191 defendant Birt Andrew husbandman 598270 598270 Birt, Andrew, of Bokelond, husbandman 1
4875186 2319192 2319192 defendant Birt Andrew husbandman 598270 598270 Birt, Andrew, of Bokelond, husbandman 1
4876516 2319620 2319620 defendant Grene John husbandman 598270 598270 Grene, John, of Bokelond, husbandman 2
4879547 2320530 2320530 defendant Hawekyns Thomas husbandman 598270 598270 Hawekyns, Thomas, of Bokelond, husbandman 0
4881985 2321264 2321264 defendant Doge William husbandman 598270 598270 Doge, William, of Bokelond Bruer, husbandman 0
4890163 2323695 2323695 plaintiff Bayly Robert   598270 598270 Bayly, Robert, of Bokelond 1
4961192 2345312 2345312 plaintiff Bicomb Richard   598270 598270 Bicomb, Richard, of Bokelond 0
4996130 2355700 2355700 defendant Squyer Henry husbandman 598270 598270 Squyer, Henry, of Bokelond Bruer, husbandman 1
5025449 2364340 2364340 defendant Gallyssore Benedict husbandman 598270 598270 Gallyssore, Benedict, of Bokelond Bruer, husbandman 0
5031656 2366122 2366122 defendant Buryman John yeoman 598270 598270 Buryman, John, of Bokelond Bruer, yeoman 0
5031657 2366122 2366122 defendant Stapilton Richard yeoman 598270 598270 Stapilton, Richard, of Bokelond Bruer, yeoman 1
5031658 2366122 2366122 defendant Kiche Henry yeoman 598270 598270 Kiche, Henry, of Bokelond Bruer, yeoman 2
5033272 2366612 2366612 defendant Fetyplace Thomas (legal representative) 598270 598270 Fetyplace, Thomas, of Bokelond, esq, executrix of 0
5035009 2367098 2367098 defendant Gybbe John husbandman 598270 598270 Gybbe, John, of Bokelond, husbandman 4
5049569 2371500 2371500 defendant Cook John clerk 598270 598270 Cook, John, of Bokelond, clerk 0
5051891 2372179 2372179 defendant Bryt John butcher 598270 598270 Bryt, John, of Bokelond, butcher 0
5059311 2374351 2374351 defendant Brugge John   598270 598270 Brugge, John, of Bokelond, groom 1
5059312 2374351 2374351 defendant Wydeslade Richard gent 598270 598270 together with Wydeslade, Richard, of Bokelond, gent 2
5059753 2374479 2374479 plaintiff Aleyn Henry   598270 598270 Aleyn, Henry, of Bokelond 4
5070503 2377670 2377670 defendant Pedder Walter husbandman 598270 598270 Pedder, Walter, of Bokelond, husbandman 0
5083781 2381652 2381652 defendant Beverle William husbandman 598270 598270 Beverle, William, of Bokelond, husbandman 2
5087022 2382583 2382583 defendant Denys Henry husbandman 598270 598270 Denys, Henry, of Bokelond Bruer, husbandman 3
5092031 2384046 2384046 defendant Denys Henry husbandman 598270 598270 Denys, Henry, of Bokelond Bruer, husbandman 1
5110421 2389450 2389450 defendant Bokemayster John husbandman 598270 598270 Bokemayster, John, of Bokelond, husbandman 1
5111544 2389773 2389773 defendant Oxenham Henry   598270 598270 Oxenham, Henry, of Bokelond Abbot, bailiff 0
5117418 2391526 2391526 defendant Don Robert husbandman 598270 598270 Don, Robert, of Bokelond Bruer, husbandman 2
5127187 2394429 2394429 defendant Lytelton John husbandman 598270 598270 Lytelton, John, of Bokelond Brewer, husbandman 0
5127188 2394429 2394429 defendant Cadde William husbandman 598270 598270 Cadde, William, of Bokelond Brewer, husbandman 1
5131565 2395714 2395714 defendant Toker Roger husbandman 598270 598270 Toker, Roger, of Bokelond, husbandman 1
5131566 2395714 2395714 defendant Prydyus John husbandman 598270 598270 Prydyus, John, of Bokelond, husbandman 2
5132763 2396077 2396077 defendant Bocher John butcher 598270 598270 Bocher, John, of Bokelond, butcher 1
5137178 2397387 2397387 plaintiff Perhale Margaret   598270 598270 Perhale, Margaret, of Bokelond 0
5142655 2398979 2398979 defendant Estecombe John husbandman 598270 598270 Estecombe, John, of Bokelond brewer, husbandman 7
5142659 2398979 2398979 defendant Michell John gent 598270 598270 Michell, John, of Bokelond bruer, gent 11
5146023 2399959 2399959 defendant Cadde William husbandman 598270 598270 Cadde, William, of Bokelond Bruer, husbandman 1
5151033 2401442 2401442 defendant Toker Roger husbandman 598270 598270 Toker, Roger, of Bokelond, husbandman 1
5151034 2401442 2401442 defendant Prydyus John husbandman 598270 598270 Prydyus, John, of Bokelond, husbandman 2
5151037 2401443 2401443 defendant Toker Roger husbandman 598270 598270 Toker, Roger, of Bokelond, husbandman 1
5151038 2401443 2401443 defendant Prydyus John husbandman 598270 598270 Prydyus, John, of Bokelond, husbandman 2
5157857 2403424 2403424 plaintiff Peshale Margaret   598270 598270 Peshale, Margaret, of Bokelond 0
5165661 2405697 2405697 defendant Clerke John   598270 598270 Clerke, John, of Bokelond, holy water clerk 5
5166282 2405860 2405860 defendant Lytelion John husbandman 598270 598270 Lytelion, John, of Bokelond Brewer, husbandman 0
5166283 2405860 2405860 defendant Cadde William   598270 598270 Cadde, William, of Bokelond Brewer 1
5169330 2406764 2406764 defendant Toker Roger husbandman 598270 598270 Toker, Roger, of Bokelond, husbandman 1
5169331 2406764 2406764 defendant Prydyus John husbandman 598270 598270 Prydyus, John, of Bokelond, husbandman 2
5172859 2407795 2407795 defendant Dunne Robert merchant 598270 598270 Dunne, Robert, of Bokelond Bruer, merchant 0
5177443 2409098 2409098 defendant Estecombe John husbandman 598270 598270 Estecombe, John, of Bokelond Bruer, husbandman 1
5177447 2409098 2409098 defendant Michell John gent 598270 598270 Michell, John, of Bokelond Bruer, gent 5
5192688 2413598 2413598 defendant Dunne Robert merchant 598270 598270 Dunne, Robert, of Bokelond Bruer, merchant 0
5205338 2417316 2417316 defendant Hauthorn Richard husbandman 598270 598270 Hauthorn, Richard, of Bokelond, husbandman 1
5205341 2417316 2417316 defendant Chalfont John husbandman 598270 598270 Chalfont, John, of Bokelond, husbandman 4
5205664 2417401 2417401 defendant Andrewes Richard husbandman 598270 598270 Andrewes, Richard, of Bokelond, husbandman 1
5212424 2419378 2419378 defendant Hichecok Robert husbandman 598270 598270 Hichecok, Robert, of Bokelond, 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);