names

125 rows where place_id = 591432

✎ 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
3604408 1869046 1869046 defendant Pyx William (legal representative) 591432 591432 Pyx, William, of Galdyng, butcher, executor of 0
3604409 1869046 1869046 defendant Godyng Thomas yeoman 591432 591432 Godyng, Thomas, of Galdyng, yeoman 1
3605910 1869510 1869510 defendant Nasshe Stephen weaver 591432 591432 Nasshe, Stephen, of Galdyng, weaver 1
3605984 1869534 1869534 defendant at Hale Thomas husbandman 591432 591432 at Hale, Thomas, of Galdyng, husbandman 2
3606268 1869627 1869627 defendant Marchall Edmund   591432 591432 Marchall, Edmund, of Galdyng, parish clerk 0
3610425 1870920 1870920 defendant Wolcy John yeoman 591432 591432 Wolcy, John, of Galdyng, yeoman 0
3615884 1872606 1872606 defendant Jerard William laborer 591432 591432 Jerard, William, of Galdyng, laborer 2
3621040 1874138 1874138 defendant Colt William butcher 591432 591432 Colt, William, of Galdyng, butcher 1
3624577 1875223 1875223 defendant Dowene William husbandman 591432 591432 Dowene, William, of Galdyng, husbandman 0
3697529 1925449 1925449 defendant Dey Simon yeoman 591432 591432 Dey, Simon, of Galdyng, yeoman 0
3698359 1925706 1925706 plaintiff Walker George   591432 591432 Walker, George, of Galdyng 0
3698360 1925706 1925706 defendant Stace John husbandman 591432 591432 Stace, John, of Galdyng, husbandman 0
3702756 1927133 1927133 plaintiff Colt Thomas butcher 591432 591432 Colt, Thomas, of Galdyng, butcher 0
3711356 1929858 1929858 defendant Dey Simon yeoman 591432 591432 Dey, Simon, of Galdyng, yeoman 0
3712029 1930081 1930081 defendant Stace John husbandman 591432 591432 Stace, John, of Galdyng, husbandman 0
3726168 1934450 1934450 defendant Dey Simon yeoman 591432 591432 Dey, Simon, of Galdyng, yeoman 0
3764186 1946450 1946450 defendant Wolsey Nicholas laborer 591432 591432 Wolsey, Nicholas, of Galdyng, laborer 1
3764187 1946450 1946450 defendant Arblat Thomas husbandman 591432 591432 Arblat, Thomas, of Galdyng, husbandman 2
4657450 2248221 2248221 defendant Herst John laborer 591432 591432 Herst, John, of Galdyng, laborer 1
4657702 2248295 2248295 defendant Mustell Simon husbandman 591432 591432 Mustell, Simon, of Galdyng, husbandman 0
4779826 2289687 2289687 defendant atte Nasshe Thomas tailor 591432 591432 atte Nasshe, Thomas, of Galdyng, tailor 0
4779827 2289687 2289687 defendant Ongherst John tailor 591432 591432 Ongherst, John, of Galdyng, tailor 1
4779828 2289687 2289687 defendant atte Nasshe Richard weaver 591432 591432 atte Nasshe, Richard, of Galdyng, weaver 2
4779829 2289687 2289687 defendant Pende Gilbert laborer 591432 591432 Pende, Gilbert, of Galdyng, laborer 3
4787880 2292275 2292275 defendant Swythefeld John yeoman 591432 591432 Swythefeld, John, of Galdyng, yeoman 2
4792537 2293756 2293756 defendant Lettere Thomas carpenter 591432 591432 Lettere, Thomas, of Galdyng, carpenter 0
4794638 2294464 2294464 defendant Fawekes John butcher 591432 591432 Fawekes, John, of Galdyng, butcher 2
4796225 2294968 2294968 defendant Foox John butcher 591432 591432 Foox, John, of Galdyng, butcher 2
4858288 2313965 2313965 defendant Brounyngbery William husbandman 591432 591432 Brounyngbery, William, of Galdyng, husbandman 1
4861686 2315030 2315030 defendant Coveneys Thomas yeoman 591432 591432 Coveneys, Thomas, of Galdyng, yeoman 1
4871027 2317914 2317914 defendant Ruggemere John husbandman 591432 591432 Ruggemere, John, of Galdyng, husbandman 0
4884595 2322092 2322092 defendant Waps Giles husbandman 591432 591432 Waps, Giles, of Galdyng, husbandman 0
4903991 2327867 2327867 defendant Waps Giles husbandman 591432 591432 Waps, Giles, of Galdyng, husbandman 0
4938025 2338266 2338266 defendant Page Richard farmer 591432 591432 Page, Richard, of Galdyng, farmer 0
4946340 2340845 2340845 defendant Goldsmyth Simon husbandman 591432 591432 Goldsmyth, Simon, of Galdyng, husbandman 0
4951527 2342435 2342435 defendant Kene Robert smith 591432 591432 Kene, Robert, of Galdyng, smith 0
4959594 2344828 2344828 defendant Goldsmyth Simon gent 591432 591432 Goldsmyth, Simon, of Galdyng, gent 0
4964241 2346210 2346210 defendant Goldsmyth Simon husbandman 591432 591432 Goldsmyth, Simon, of Galdyng, husbandman 0
4971737 2348472 2348472 defendant Morys William laborer 591432 591432 Morys, William, of Galdyng, laborer 0
4976078 2349807 2349807 plaintiff Orgar John   591432 591432 Orgar, John, of Galdyng 0
4981129 2351286 2351286 defendant Chaloner Richard yeoman 591432 591432 (Chaloner, Richard, of Galdyng, yeoman 1
5018184 2362206 2362206 plaintiff Colte John butcher 591432 591432 Colte, John, of Galdyng, butcher 0
5027985 2365063 2365063 defendant Ryng Robert husbandman 591432 591432 Ryng, Robert, of Galdyng, husbandman 0
5027986 2365063 2365063 defendant Colyn John laborer 591432 591432 Colyn, John, of Galdyng, laborer 1
5027987 2365063 2365063 defendant Couper john weaver 591432 591432 Couper, john, of Galdyng, weaver 2
5029542 2365510 2365510 plaintiff Orgar John draper 591432 591432 Orgar, John, of Galdyng, draper 0
5029547 2365510 2365510 defendant Parlebien Henry laborer 591432 591432 Parlebien, Henry, of Galdyng, laborer 4
5031609 2366109 2366109 defendant Fygge Walter shoemaker 591432 591432 Fygge, Walter, of Galdyng, shoemaker 0
5036764 2367626 2367626 defendant atte Hale Gilbert husbandman 591432 591432 atte Hale, Gilbert, of Galdyng, husbandman 2
5054012 2372792 2372792 defendant Colt William (legal representative) 591432 591432 Colt, William, of Galdyng, executors of 0
5057205 2373731 2373731 defendant Senyng or Sevyng John yeoman 591432 591432 Senyng or Sevyng, John, of Galdyng, yeoman 0
5067440 2376763 2376763 plaintiff Orgar John   591432 591432 Orgar, John, of Galdyng 0
5067441 2376763 2376763 defendant Bouryng John laborer 591432 591432 Bouryng, John, of Galdyng, laborer 0
5067442 2376764 2376764 plaintiff Orgar John   591432 591432 Orgar, John, of Galdyng 0
5067447 2376764 2376764 defendant Pyx Richard husbandman 591432 591432 Pyx, Richard, of Galdyng, husbandman 4
5067449 2376765 2376765 defendant Kene Robert smith 591432 591432 Kene, Robert, of Galdyng, smith 0
5067451 2376765 2376765 defendant Benet Thomas weaver 591432 591432 Benet, Thomas, of Galdyng, weaver 2
5078430 2380047 2380047 defendant Wyke John husbandman 591432 591432 Wyke, John, of Galdyng, husbandman 0
5078431 2380047 2380047 defendant Churche Stephen husbandman 591432 591432 Churche, Stephen, of Galdyng, husbandman 1
5080426 2380634 2380634 plaintiff Goldsmyth Thomas   591432 591432 Goldsmyth, Thomas, of Galdyng 3
5086582 2382467 2382467 defendant Kene Robert yeoman 591432 591432 Kene, Robert, of Galdyng, yeoman 1
5098730 2386058 2386058 defendant Bygge William clothier 591432 591432 Bygge, William, of Galdyng, clothier 0
5098732 2386058 2386058 defendant Sevyng William tailor 591432 591432 Sevyng, William, of Galdyng, tailor 2
5113095 2390224 2390224 defendant Chalner Richard yeoman 591432 591432 Chalner, Richard, of Galdyng, yeoman 0
5113097 2390225 2390225 defendant Chalner Richard yeoman 591432 591432 Chalner, Richard, of Galdyng, yeoman 0
5113433 2390323 2390323 defendant Bettynham Henry gent 591432 591432 Bettynham, Henry, of Galdyng, gent 0
5116077 2391131 2391131 defendant Orgar Alice widow 591432 591432 Orgar, Alice, of Galdyng, widow 0
5122715 2393079 2393079 defendant Bettenham Henry gent 591432 591432 Bettenham, Henry, of Galdyng, gent 0
5123655 2393377 2393377 defendant Orgar Alice   591432 591432 Orgar, Alice, of Galdyng widow 1
5218400 2421113 2421113 defendant Orgar William   591432 591432 Orgar, William, of Galdyng, mason 1
5218417 2421118 2421118 defendant May Richard gent 591432 591432 May, Richard, of Galdyng, gent 0
5218419 2421118 2421118 defendant Bokelond John husbandman 591432 591432 Bokelond, John, of Galdyng, husbandman 2
5226345 2423372 2423372 defendant Orgare William   591432 591432 Orgare, William, of Galdyng, mason 2
5227701 2423720 2423720 defendant Boweryng John   591432 591432 Boweryng, John, of Galdyng, "clovyer" or clothier 1
5227704 2423721 2423721 defendant Boweryng John clothier 591432 591432 Boweryng, John, of Galdyng, clothier 1
5228275 2423878 2423878 defendant Kene Robert smith 591432 591432 Kene, Robert, of Galdyng, smith 0
5228956 2424072 2424072 defendant Thornton alias Pakke Joan widow 591432 591432 Thornton alias Pakke, Joan, of Galdyng, widow 0
5233575 2425412 2425412 defendant Mair Richard gent 591432 591432 Mair, Richard, of Galdyng, gent 0
5233577 2425413 2425413 defendant Wolcy William gent 591432 591432 Wolcy, William, of Galdyng, gent 0
5233578 2425413 2425413 defendant Bokeland John husbandman 591432 591432 Bokeland, John, of Galdyng, husbandman 1
5242571 2428034 2428034 defendant Goldsmyth John husbandman 591432 591432 Goldsmyth, John, of Galdyng, husbandman 0
5244493 2428572 2428572 defendant Downer John butcher 591432 591432 Downer, John, of Galdyng, butcher 2
5247716 2429481 2429481 defendant Bery Richard pulter 591432 591432 (Bery, Richard, of Galdyng, pulter 4
5247721 2429482 2429482 defendant Warbylton William husbandman 591432 591432 Warbylton, William, of Galdyng, husbandman 1
5262094 2433891 2433891 defendant Bolde John husbandman 591432 591432 (Bolde, John, of Galdyng, husbandman 1
5262799 2434109 2434109 defendant Bukle Richard husbandman 591432 591432 Bukle, Richard,of Galdyng, husbandman 2
5262963 2434160 2434160 defendant Broune William chaplain 591432 591432 Broune, William, of Galdyng, chaplain 0
5264602 2434682 2434682 defendant Rolf Thomas wheeler 591432 591432 Rolf, Thomas, of Galdyng, wheeler 0
5277268 2438431 2438431 defendant Charleswound John husbandman 591432 591432 Charleswound, John, of Galdyng, husbandman 0
5284139 2440381 2440381 defendant Baldewyn John yeoman 591432 591432 Baldewyn, John, of Galdyng, yeoman 2
5292971 2442936 2442936 plaintiff Senyng or Sevyng William tailor 591432 591432 Senyng or Sevyng, William, of Galdyng, tailor 0
5295747 2443751 2443751 defendant Warbelton William yeoman 591432 591432 Warbelton, William, of Galdyng, yeoman 0
5320477 2451207 2451207 defendant Turnour Simon husbandman 591432 591432 Turnour, Simon, of Galdyng, husbandman 0
5321192 2451436 2451436 defendant Pyx Richard husbandman 591432 591432 Pyx, Richard, of Galdyng, husbandman 0
5348043 2459528 2459528 defendant Knyght Robert smith 591432 591432 Knyght, Robert, of Galdyng, smith 0
5348437 2459653 2459653 defendant Dunlagh Nicholas clerk 591432 591432 Dunlagh, Nicholas, of Galdyng, clerk 2
5354447 2461461 2461461 defendant Mylle Thomas (legal representative) 591432 591432 Mylle, Thomas, of Galdyng, butcher, administratrix of 0
5359687 2463067 2463067 defendant Warbylton William yeoman 591432 591432 Warbylton, William, of Galdyng, yeoman 0
5360429 2463297 2463297 defendant Rogger William husbandman 591432 591432 Rogger, William, of Galdyng, husbandman 1
5363945 2464376 2464376 defendant Jamys Robert thatcher 591432 591432 Jamys, Robert, of Galdyng, thatcher 2

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