names

129 rows where place_id = 586572

✎ 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
3589074 1864229 1864229 defendant Swertbrygge Thomas yeoman 586572 586572 Swertbrygge, Thomas, of Berford, yeoman 0
3591187 1864866 1864866 defendant Clerk Robert clerk 586572 586572 Clerk, Robert, of Berford, clerk 0
3703080 1927238 1927238 defendant Norman John husbandman 586572 586572 Norman, John, of Berford, husbandman 1
3703083 1927239 1927239 defendant Norman John husbandman 586572 586572 Norman, John, of Berford, husbandman 1
3742411 1939498 1939498 defendant Sherborne Richard gent 586572 586572 Sherborne, Richard, of Berford, gent 2
4438362 2181294 2181294 defendant Benet Robert   586572 586572 Benet, Robert, of Berford 2
4445763 2183615 2183615 defendant Butte John   586572 586572 Butte, John, of Berford 0
4458888 2187828 2187828 defendant Blok Agne   586572 586572 Blok, Agne, of Berford 0
4469193 2191033 2191033 defendant Shawe Thomas   586572 586572 Shawe, Thomas, of Berford 0
4509770 2203539 2203539 defendant Seman John   586572 586572 Seman, John, of Berford 1
4512182 2204255 2204255 defendant Shawe Thomas   586572 586572 Shawe, Thomas, of Berford 1
4534868 2211187 2211187 defendant Shepherd Richard   586572 586572 Shepherd, Richard, of Berford 1
4535413 2211347 2211347 defendant Juster or Inster Thomas   586572 586572 Juster or Inster, Thomas, of Berford 0
4545491 2214514 2214514 defendant Shepherd Edmund   586572 586572 Shepherd, Edmund, of Berford 0
4545493 2214514 2214514 defendant Munk Peter   586572 586572 Munk, Peter, of Berford 2
4578175 2224671 2224671 defendant Bailly John   586572 586572 Bailly, John, of Berford 6
4578662 2224815 2224815 defendant Longe Richard   586572 586572 Longe, Richard, of Berford 0
4580270 2225312 2225312 defendant Seman John   586572 586572 Seman, John, of Berford 6
4593825 2229344 2229344 defendant Shepherd Edmund   586572 586572 Shepherd, Edmund, of Berford 0
4618827 2236884 2236884 defendant Asphone Thomas   586572 586572 Asphone, Thomas, of Berford 0
4626996 2239392 2239392 defendant Carlyngton William merchant 586572 586572 Carlyngton, William, of Berford, merchant 0
4632474 2241047 2241047 defendant Bery Walter   586572 586572 Bery, Walter, of Berford 0
4672462 2257038 2257038 defendant Hervy William carpenter 586572 586572 Hervy, William, of Berford, carpenter 0
4673262 2257279 2257279 defendant Stowe Robert fisher 586572 586572 Stowe, Robert, of Berford, fisher 0
4679515 2259209 2259209 defendant Kempe Robert tailor 586572 586572 Kempe, Robert, of Berford, tailor 0
4688077 2261841 2261841 defendant Hoke Katherine widow 586572 586572 Hoke, Katherine, of Berford, widow 0
4690481 2262583 2262583 defendant Perbroun John husbandman 586572 586572 Perbroun, John, of Berford, husbandman 1
4690581 2262606 2262606 defendant Burgh James husandman 586572 586572 Burgh, James, of Berford, husandman 9
4690582 2262606 2262606 defendant Skeppere Edmund husbandman 586572 586572 Skeppere, Edmund, of Berford, husbandman 10
4690583 2262606 2262606 defendant Ted Thomas husbandman 586572 586572 Ted, Thomas, of Berford, husbandman 11
4694342 2263731 2263731 defendant Monke John husbandman 586572 586572 Monke, John, of Berford, husbandman 4
4696566 2264401 2264401 defendant Mandolf Henry husbandman 586572 586572 Mandolf, Henry, of Berford, husbandman 0
4703253 2266395 2266395 defendant Kempe Robert tailor 586572 586572 Kempe, Robert, of Berford, tailor 3
4711854 2269038 2269038 defendant More John maltman 586572 586572 More, John, of Berford, maltman 0
4735327 2276196 2276196 defendant More Robert husbandman 586572 586572 More, Robert, of Berford, husbandman 0
4741110 2277905 2277905 plaintiff Bery Katherine   586572 586572 Bery, Katherine, of Berford, formerly wife of Walter Bery 0
4741575 2278032 2278032 defendant Shepherd Edmund   586572 586572 Shepherd, Edmund, of Berford, shepherd 0
4741576 2278032 2278032 defendant Seman Thomas husbandman 586572 586572 Seman, Thomas, of Berford, husbandman 1
4741577 2278032 2278032 defendant Howys Peter husbandman 586572 586572 Howys, Peter, of Berford, husbandman 2
4742383 2278265 2278265 defendant Monk John yeoman 586572 586572 Monk, John, of Berford, yeoman 4
4746432 2279450 2279450 defendant Veysy John husbandman 586572 586572 Veysy, John, of Berford, husbandman 2
4748819 2280141 2280141 defendant Veysy John husbandman 586572 586572 Veysy, John, of Berford, husbandman 0
4754704 2281854 2281854 defendant Burn_n Thomas yeoman 586572 586572 Burn_n, Thomas, of Berford, yeoman 0
4758351 2282985 2282985 plaintiff Bury Walter (legal representative) 586572 586572 Bury, Walter, of Berford, executrix of 0
4758353 2282985 2282985 defendant Waryn William smith 586572 586572 Waryn, William, of Berford, smith 0
4761182 2283848 2283848 defendant Kebyll William husbandman 586572 586572 Kebyll, William, of Berford, husbandman 0
4764518 2284888 2284888 defendant Beaufo John gent 586572 586572 Beaufo, John, of Berford, gent 1
4766758 2285594 2285594 defendant Shawe Thomas   586572 586572 Shawe, Thomas, of Berford 0
4769951 2286575 2286575 defendant Sale Roger   586572 586572 Sale, Roger, of Berford, bailiff 0
4788429 2292443 2292443 defendant Beaufo John gent 586572 586572 Beaufo, John, of Berford, gent 0
4788433 2292445 2292445 defendant Beaufo John gent 586572 586572 Beaufo, John, of Berford, gent 0
4790657 2293165 2293165 defendant Boreman Thomas husbandman 586572 586572 Boreman, Thomas, of Berford, husbandman 0
4791195 2293347 2293347 defendant Shawe Thomas tucker 586572 586572 Shawe, Thomas, of Berford, tucker 0
4805857 2298041 2298041 plaintiff Bury Walter   586572 586572 Bury, Walter, of Berford 0
4806174 2298136 2298136 defendant Grove Thomas husbandman 586572 586572 Grove, Thomas, of Berford, husbandman 3
4806181 2298137 2298137 defendant Grove Thomas husbandman 586572 586572 Grove, Thomas, of Berford, husbandman 3
4810757 2299487 2299487 defendant Puddessey John   586572 586572 Puddessey, John, of Berford, knight 0
4814720 2300720 2300720 plaintiff Kay or Key John yeoman 586572 586572 Kay or Key, John, of Berford, yeoman 0
4817503 2301566 2301566 defendant Pycot John husbandman 586572 586572 Pycot, John, of Berford, husbandman 0
4817504 2301566 2301566 defendant Bury Katherine widow 586572 586572 Bury, Katherine, of Berford, widow 1
4826144 2304210 2304210 defendant Justere Roger husbandman 586572 586572 Justere, Roger, of Berford, husbandman 1
4863283 2315481 2315481 defendant Podesay William esq 586572 586572 Podesay, William, of Berford, esq 2
4870401 2317720 2317720 plaintiff Lynde William   586572 586572 Lynde, William, of Berford 0
4889694 2323569 2323569 defendant Dynne Robert husbandman 586572 586572 Dynne, Robert, of Berford, husbandman 1
4911299 2330038 2330038 defendant Lynde William smith 586572 586572 Lynde, William, of Berford, smith 6
4944888 2340392 2340392 defendant Brytvyle William gent 586572 586572 Brytvyle, William, of Berford, gent 0
4946403 2340867 2340867 defendant Blokk alias Laurence William gent 586572 586572 Blokk alias Laurence, William, of Berford, gent 0
4955429 2343585 2343585 defendant Umfreston John yeoman 586572 586572 Umfreston, John, of Berford, yeoman 1
4959317 2344753 2344753 defendant Beyrne Aspilon yeoman 586572 586572 Beyrne, Aspilon, of Berford, yeoman 2
4962127 2345577 2345577 defendant Tyler Simon husbandman 586572 586572 Tyler, Simon, of Berford, husbandman 5
4962179 2345592 2345592 defendant Fuller John husbandman 586572 586572 Fuller, John, of Berford, husbandman 0
4962180 2345592 2345592 defendant Sotyll John husbandman 586572 586572 Sotyll, John, of Berford, husbandman 1
4962181 2345592 2345592 defendant Waryn Robert husbandman 586572 586572 Waryn, Robert, of Berford, husbandman 2
4962182 2345592 2345592 defendant Tryket William husbandman 586572 586572 Tryket, William, of Berford, husbandman 3
4979038 2350688 2350688 defendant Kyrke William yeoman 586572 586572 Kyrke, William, of Berford, yeoman 2
4979954 2350961 2350961 defendant Beron Aspilon husbandman 586572 586572 Beron, Aspilon, of Berford, husbandman 1
4979955 2350961 2350961 defendant Whithed Richard husbandman 586572 586572 Whithed, Richard, of Berford, husbandman 2
5007963 2359218 2359218 defendant Mandolf John laborer 586572 586572 Mandolf, John, of Berford, laborer 3
5015700 2361478 2361478 defendant Manfeld Thomas husbandman 586572 586572 Manfeld, Thomas, of Berford, husbandman 0
5021291 2363130 2363130 defendant Creweker Stephen esq 586572 586572 Creweker, Stephen, of Berford, esq 0
5040253 2368684 2368684 defendant Manfeld Thomas husbandman 586572 586572 Manfeld, Thomas, of Berford, husbandman 2
5083682 2381620 2381620 defendant Laurence William husbandman 586572 586572 Laurence, William, of Berford, husbandman 2
5083683 2381620 2381620 defendant Broy Thomas husbandman 586572 586572 Broy, Thomas, of Berford, husbandman 3
5099627 2386326 2386326 defendant Bocher John husbandman 586572 586572 Bocher, John, of Berford, husbandman 3
5120180 2392341 2392341 defendant Bull John husbandman 586572 586572 Bull, John, of Berford, husbandman 0
5124225 2393540 2393540 defendant Alford Thomas clerk 586572 586572 Alford, Thomas, of Berford, clerk 8
5130195 2395316 2395316 defendant Avenaunt Robert husbandman 586572 586572 Avenaunt, Robert, of Berford, husbandman 0
5149521 2400990 2400990 defendant Avennaunt Robert husbandman 586572 586572 Avennaunt, Robert, of Berford, husbandman 0
5201976 2416345 2416345 defendant Stacheden John husbandman 586572 586572 Stacheden, John, of Berford, husbandman 3
5228257 2423873 2423873 defendant Grene Richard husbandman or yeoman 586572 586572 Grene, Richard, of Berford, husbandman or yeoman 0
5243984 2428430 2428430 defendant Grene Richard husbandman 586572 586572 Grene, Richard, of Berford, husbandman 0
5243985 2428430 2428430 defendant Derby William husbandman 586572 586572 Derby, William, of Berford, husbandman 1
5243986 2428430 2428430 defendant Grene John husbandman 586572 586572 Grene, John, of Berford, husbandman 2
5255260 2431761 2431761 defendant London Thomas husbandman 586572 586572 London, Thomas, of Berford, husbandman 2
5287529 2441378 2441378 plaintiff Kenell John, senior   586572 586572 Kenell, John, senior, of Berford 0
5289689 2441987 2441987 defendant Hynche John husbandman 586572 586572 Hynche, John, of Berford, husbandman 1
5289690 2441987 2441987 defendant Hynche Thomas husbandman 586572 586572 Hynche, Thomas, of Berford, husbandman 2
5289693 2441988 2441988 defendant Hynche John husbandman 586572 586572 Hynche, John, of Berford, husbandman 1
5289694 2441988 2441988 defendant Hynche Thomas husbandman 586572 586572 Hynche, Thomas, of Berford, husbandman 2
5308893 2447701 2447701 defendant Blok William (legal representative) 586572 586572 Blok, William, of Berford, husbandman, executrix of 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);