names

94 rows where place_id = 757947

✎ 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
4449982 2184949 2184949 defendant Keche William   757947 757947 Keche, William, of Wodebregge 2
4486890 2196614 2196614 defendant Kyng William butcher 757947 757947 Kyng, William, of Wodebregge, butcher 3
4544849 2214309 2214309 plaintiff Bele William   757947 757947 Bele, William, of Wodebregge 0
4550602 2216133 2216133 defendant Hubbe John   757947 757947 Hubbe, John, of Wodebregge 1
4577263 2224409 2224409 plaintiff Cantel Gilbert (legal representative) 757947 757947 Cantel, Gilbert, of Wodebregge, executrix of 0
4577267 2224410 2224410 plaintiff Cantel Gilbert (legal representative) 757947 757947 Cantel, Gilbert, of Wodebregge, executrix of 0
4577270 2224411 2224411 plaintiff Cantell Gilbert (legal representative) 757947 757947 Cantell, Gilbert, of Wodebregge, executrix of 0
4592590 2229033 2229033 defendant Peyntour John   757947 757947 Peyntour, John, of Wodebregge 5
4594738 2229611 2229611 plaintiff Prestmere John   757947 757947 Prestmere, John, of Wodebregge 0
4610192 2234270 2234270 plaintiff Cantell Alice   757947 757947 Cantell, Alice, of Wodebregge, formerly wife of Gilbert 0
4662568 2249762 2249762 plaintiff Freberne John   757947 757947 Freberne, John, of Wodebregge 0
4735902 2276381 2276381 plaintiff Stub John   757947 757947 Stub, John, of Wodebregge 0
4747913 2279897 2279897 defendant Ropere Thomas roper 757947 757947 Ropere, Thomas, of Wodebregge, roper 0
4751969 2281069 2281069 defendant Stub John yeoman 757947 757947 Stub, John, of Wodebregge, yeoman 2
4777563 2288977 2288977 defendant Grene Robert yeoman 757947 757947 Grene, Robert, of Wodebregge, yeoman 0
4835808 2307192 2307192 defendant Plomer John yeoman 757947 757947 Plomer, John, of Wodebregge, yeoman 9
4863198 2315467 2315467 defendant Plomer John yeoman 757947 757947 Plomer, John, of Wodebregge, yeoman 1
4893656 2324713 2324713 defendant Berard William husbandman 757947 757947 Berard, William, of Wodebregge, husbandman 1
4932633 2336599 2336599 defendant Dool John chandler 757947 757947 Dool, John, of Wodebregge, chandler 0
4965755 2346685 2346685 defendant Dool John chandler 757947 757947 Dool, John, of Wodebregge, chandler 1
4976255 2349850 2349850 defendant Dool John chandler 757947 757947 Dool, John, of Wodebregge, chandler 1
4977935 2350362 2350362 defendant Miller John miller 757947 757947 Miller, John, of Wodebregge, miller 1
4978228 2350439 2350439 defendant Dool John chandler 757947 757947 Dool, John, of Wodebregge, chandler 0
4989583 2353816 2353816 defendant Dool John caudeler 757947 757947 Dool, John, of Wodebregge, caudeler 0
4992725 2354706 2354706 defendant Wode Henry carver 757947 757947 Wode, Henry, of Wodebregge, carver 0
4992726 2354706 2354706 defendant Plomer John chapman 757947 757947 Plomer, John, of Wodebregge, chapman 1
5012834 2360586 2360586 defendant Raas Thomas merchant 757947 757947 Raas, Thomas, of Wodebregge, merchant 1
5020375 2362842 2362842 defendant Plomer John husbandman 757947 757947 Plomer, John, of Wodebregge, husbandman 1
5041056 2368951 2368951 defendant Lauerens John drover 757947 757947 Lauerens, John, of Wodebregge, drover 2
5045283 2370216 2370216 plaintiff Kempe John   757947 757947 Kempe, John, of Wodebregge 0
5045284 2370216 2370216 plaintiff Raas Thomas   757947 757947 Raas, Thomas, of Wodebregge 1
5053879 2372755 2372755 defendant Candeler Robert yeoman 757947 757947 Candeler, Robert, of Wodebregge, yeoman 0
5053883 2372755 2372755 defendant Dooll John chandler 757947 757947 Dooll, John, of Wodebregge, chandler 4
5053884 2372755 2372755 defendant Muspet John chandler 757947 757947 Muspet, John, of Wodebregge, chandler 5
5055361 2373189 2373189 defendant Rase or Rafe Thomas merchant 757947 757947 Rase or Rafe, Thomas, of Wodebregge, merchant 1
5074957 2379017 2379017 defendant Fre Robert carpenter 757947 757947 Fre, Robert, of Wodebregge, carpenter 0
5074958 2379017 2379017 defendant Parnell Robert tailor 757947 757947 Parnell, Robert, of Wodebregge, tailor 1
5077194 2379681 2379681 defendant Dooll John   757947 757947 Dooll, John, of Wodebregge, tallow chandler 0
5080251 2380582 2380582 defendant Dole John   757947 757947 Dole, John, of Wodebregge, tallow chandler 2
5086063 2382315 2382315 defendant Prentys John yeoman 757947 757947 Prentys, John, of Wodebregge, yeoman 1
5102026 2387019 2387019 plaintiff Beale William   757947 757947 Beale, William, of Wodebregge 0
5113026 2390202 2390202 defendant Smyth Edmund laborer 757947 757947 Smyth, Edmund, of Wodebregge, laborer 0
5117123 2391433 2391433 defendant Bosy Robert tailor 757947 757947 Bosy, Robert, of Wodebregge, tailor 0
5117124 2391433 2391433 defendant Free Robert yeoman 757947 757947 Free, Robert, of Wodebregge, yeoman 1
5141622 2398661 2398661 defendant Love John   757947 757947 Love, John, of Wodebregge, twill weaver 0
5162721 2404817 2404817 defendant Love John   757947 757947 Love, John, of Wodebregge, twill weaver 0
5164245 2405279 2405279 defendant Byrd Robert skalder 757947 757947 Byrd, Robert, of Wodebregge, skalder 2
5176649 2408856 2408856 defendant Love John   757947 757947 Love, John, of Wodebregge, twill weaver 0
5216176 2420463 2420463 defendant Kempe John (legal representative) 757947 757947 Kempe, John, of Wodebregge, executors of 0
5216177 2420463 2420463 defendant Kempe Margaret widow 757947 757947 (Kempe, Margaret, of Wodebregge, widow 1
5216178 2420463 2420463 defendant Kempe Thomas merchant 757947 757947 Kempe, Thomas, of Wodebregge, merchant 2
5216179 2420463 2420463 defendant Alvard Thomas merchant 757947 757947 Alvard, Thomas, of Wodebregge, merchant 3
5220868 2421796 2421796 plaintiff Kempe John (legal representative) 757947 757947 Kempe, John, of Wodebregge, executors of 0
5220870 2421796 2421796 plaintiff Alvard Thomas   757947 757947 Alvard, Thomas, of Wodebregge 2
5229310 2424183 2424183 defendant Cogman Richard dyer 757947 757947 Cogman, Richard, of Wodebregge, dyer 2
5231555 2424811 2424811 defendant Forgon John barker 757947 757947 Forgon, John, of Wodebregge, barker 4
5245812 2428941 2428941 defendant Dun John cordwainer 757947 757947 Dun, John, of Wodebregge, cordwainer 1
5251510 2430579 2430579 defendant Pertrych John yeoman 757947 757947 Pertrych, John, of Wodebregge, yeoman 0
5258070 2432642 2432642 defendant Purdy Margaret widow 757947 757947 Purdy, Margaret, of Wodebregge, widow 2
5278480 2438812 2438812 defendant Poose William husbandman 757947 757947 Poose, William, of Wodebregge, husbandman 0
5281120 2439551 2439551 defendant Cuttyng William husbandman 757947 757947 Cuttyng, William, of Wodebregge, husbandman 1
5288999 2441790 2441790 defendant Prentyse John yeoman 757947 757947 Prentyse, John, of Wodebregge, yeoman 0
5292170 2442705 2442705 defendant Hykelyngham alias Mows Thomas   757947 757947 Hykelyngham alias Mows, Thomas, of Wodebregge, mason 0
5297498 2444273 2444273 defendant (illegible) Richard   757947 757947 _, Richard, of Wodebregge 0
5318128 2450513 2450513 defendant Hall William chapman 757947 757947 Hall, William, of Wodebregge, chapman 0
5324468 2452404 2452404 defendant Joye John barber 757947 757947 Joye, John, of Wodebregge, barber 0
5333980 2455234 2455234 defendant Water William yeoman 757947 757947 Water, William, of Wodebregge, yeoman 2
5350876 2460386 2460386 defendant Alvard Benedict yeoman 757947 757947 Alvard, Benedict, of Wodebregge, yeoman 0
5354850 2461595 2461595 defendant Alvard Benedict yeoman 757947 757947 Alvard, Benedict, of Wodebregge, yeoman 0
5373296 2467247 2467247 defendant Tolkelose William fuller 757947 757947 Tolkelose, William, of Wodebregge, fuller 4
5397470 2474357 2474357 defendant Lopham Robert   757947 757947 Lopham, Robert, of Wodebregge, pedlar 11
5397500 2474358 2474358 defendant Linit Robert yeoman 757947 757947 Linit, Robert, of Wodebregge, yeoman 19
5416702 2479914 2479914 defendant Waryn William   757947 757947 Waryn, William, of Wodebregge, arrow maker 0
5423299 2481929 2481929 defendant Pertrych William butcher 757947 757947 Pertrych, William, of Wodebregge, butcher 0
5424643 2482336 2482336 defendant Lopham Robert   757947 757947 Lopham, Robert, of Wodebregge, pedlar 11
5424673 2482337 2482337 defendant Lunt Robert yeoman 757947 757947 Lunt, Robert, of Wodebregge, yeoman 19
5433521 2484988 2484988 defendant Waryn William   757947 757947 Waryn, William, of Wodebregge, arrow maker 0
5438180 2486352 2486352 defendant Lunt Robert clothmaker 757947 757947 Lunt, Robert, of Wodebregge, clothmaker 1
5442674 2487722 2487722 defendant Pertrych William butcher 757947 757947 Pertrych, William, of Wodebregge, butcher 0
5452288 2490559 2490559 defendant Lunt Robert clothmaker 757947 757947 Lunt, Robert, of Wodebregge, clothmaker 1
5454130 2491133 2491133 defendant Lopham Robert   757947 757947 Lopham, Robert, of Wodebregge 11
5461055 2493255 2493255 defendant Lunt Robert merchant 757947 757947 Lunt, Robert, of Wodebregge, merchant 1
5472638 2496782 2496782 defendant Lunt Robert merchant 757947 757947 Lunt, Robert, of Wodebregge, merchant 1
5488888 2501550 2501550 defendant Shepherd Simon yeoman 757947 757947 Shepherd, Simon, of Wodebregge, yeoman 3
5491423 2502319 2502319 defendant Pertryche William butcher 757947 757947 Pertryche, William, of Wodebregge, butcher 12
5506177 2506850 2506850 defendant Pertriche William butcher 757947 757947 Pertriche, William, of Wodebregge, butcher 2
5509053 2507685 2507685 defendant Godyng Robert merchant 757947 757947 Godyng, Robert, of Wodebregge, merchant 2
5520394 2511200 2511200 defendant Laderhed Richard smith 757947 757947 Laderhed, Richard, of Wodebregge, smith 0
5538349 2516481 2516481 plaintiff Edward Thomas (legal representative) 757947 757947 Edward, Thomas, of Wodebregge, executor of Free, John, of Wodebregge, executors of 0
5538353 2516481 2516481 defendant Cantell Robert weaver 757947 757947 Cantell, Robert, of Wodebregge, weaver 2
5540406 2517130 2517130 defendant Wytton Robert weaver 757947 757947 Wytton, Robert, of Wodebregge, weaver 0
5623771 2551374 2551374 defendant Prestune John cordwainer 757947 757947 Prestune, John, of Wodebregge, cordwainer 0
5624990 2551749 2551749 defendant Frebern William shipman 757947 757947 Frebern, William, of Wodebregge, shipman 1
5631445 2553840 2553840 defendant Hell William ploughman 757947 757947 Hell, William, of Wodebregge, ploughman 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);