names

79 rows where place_id = 586127

✎ 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
3587990 1863896 1863896 plaintiff Champyn Arnulph   586127 586127 Champyn, Arnulph, of Godalmyng 2
3587994 1863897 1863897 plaintiff Champyn Arnulph   586127 586127 Champyn, Arnulph, of Godalmyng 2
3604482 1869068 1869068 defendant Shampion Arnold yeoman 586127 586127 Shampion, Arnold, of Godalmyng, yeoman 0
3616847 1872899 1872899 defendant Crofter Robert weaver 586127 586127 Crofter, Robert, of Godalmyng, weaver 2
3616849 1872900 1872900 defendant Hamond Henry tanner 586127 586127 Hamond, Henry, of Godalmyng, tanner 0
3630267 1904315 1904315 defendant Melerssh Anne widow 586127 586127 Melerssh, Anne, of Godalmyng, widow 0
3710728 1929676 1929676 plaintiff Elyot John   586127 586127 Elyot, John, of Godalmyng 1
3750603 1942108 1942108 defendant Brigger Richard weaver 586127 586127 Brigger, Richard, of Godalmyng, weaver 0
3750604 1942108 1942108 defendant Godyer Robert weaver 586127 586127 Godyer, Robert, of Godalmyng, weaver 1
3759134 1944844 1944844 defendant Grover Richard weaver 586127 586127 Grover, Richard, of Godalmyng, weaver 0
3763504 1946219 1946219 defendant Grover Richard weaver 586127 586127 Grover, Richard, of Godalmyng, weaver 1
3766719 1947252 1947252 defendant Brygger Richard weaver 586127 586127 Brygger, Richard, of Godalmyng, weaver 0
3766720 1947252 1947252 defendant Godyer Robert weaver 586127 586127 Godyer, Robert, of Godalmyng, weaver 1
3777087 1950583 1950583 defendant Champyon Richard baker 586127 586127 Champyon, Richard, of Godalmyng, baker 0
3777088 1950583 1950583 defendant Chety Thomas husbandman 586127 586127 Chety, Thomas, of Godalmyng, husbandman 1
3777091 1950584 1950584 defendant Bussebrigge Robert husbandman 586127 586127 Bussebrigge, Robert, of Godalmyng, husbandman 1
3784209 1952848 1952848 defendant Adler John fuller 586127 586127 Adler, John, of Godalmyng, fuller 0
3793833 1955937 1955937 defendant Grover Richard weaver 586127 586127 Grover, Richard, of Godalmyng, weaver 0
3794505 1956159 1956159 defendant Glover alias Parson Thomas glover 586127 586127 Glover alias Parson, Thomas, of Godalmyng, glover 0
3794561 1956179 1956179 defendant Symon Robert laborer 586127 586127 Symon, Robert, of Godalmyng, laborer 0
3801099 1958262 1958262 defendant Glover John fuller 586127 586127 Glover, John, of Godalmyng, fuller 0
3804651 1959394 1959394 defendant Godale William dyer 586127 586127 Godale, William, of Godalmyng, dyer 0
3804652 1959394 1959394 defendant Stone Lawrence dyer 586127 586127 Stone, Lawrence, of Godalmyng, dyer 1
3807976 1960385 1960385 defendant Champyon Arnold clothier 586127 586127 Champyon, Arnold, of Godalmyng, clothier 0
3809432 1960831 1960831 defendant Westbroke William gent 586127 586127 Westbroke, William, of Godalmyng, gent 0
3811576 1961516 1961516 defendant Busbryge Robert husbandman 586127 586127 Busbryge, Robert, of Godalmyng, husbandman 0
3811577 1961516 1961516 defendant Dyms John fuller 586127 586127 Dyms, John, of Godalmyng, fuller 1
3811578 1961516 1961516 defendant Parson Thomas glover 586127 586127 Parson, Thomas, of Godalmyng, glover 2
3813542 1962153 1962153 defendant Godyer Robert yeoman 586127 586127 Godyer, Robert, of Godalmyng, yeoman 0
3821187 1964520 1964520 defendant Palmer Edmund laborer 586127 586127 Palmer, Edmund, of Godalmyng, laborer 0
3837231 1969548 1969548 defendant Punter Thomas weaver 586127 586127 Punter, Thomas, of Godalmyng, weaver 0
3837232 1969548 1969548 defendant Punter John laborer 586127 586127 Punter, John, of Godalmyng, laborer 1
3837233 1969548 1969548 defendant Maters William laborer 586127 586127 Maters, William, of Godalmyng, laborer 2
3843292 1971435 1971435 defendant Frenche Robert fuller 586127 586127 Frenche, Robert, of Godalmyng, fuller 2
3843300 1971436 1971436 defendant Frenche Richard fuller 586127 586127 Frenche, Richard, of Godalmyng, fuller 3
3867757 1979447 1979447 defendant Edwardys John butcher 586127 586127 Edwardys, John, of Godalmyng, butcher 1
3872834 1981126 1981126 defendant Person alias Glover John fuller 586127 586127 Person alias Glover, John, of Godalmyng, fuller 0
3887065 1985938 1985938 defendant Thorne alias Randall William clothier 586127 586127 Thorne alias Randall, William, of Godalmyng, clothier 5
3887072 1985939 1985939 defendant Thorne alias Randall William clothier 586127 586127 Thorne alias Randall, William, of Godalmyng, clothier 5
3899486 1990043 1990043 defendant Bocher alias Chette John clothier 586127 586127 Bocher alias Chette, John, of Godalmyng, clothier 0
3899487 1990043 1990043 defendant Knollys John clothier 586127 586127 Knollys, John, of Godalmyng, clothier 1
3899488 1990043 1990043 defendant Hudson James dyer 586127 586127 Hudson, James, of Godalmyng, dyer 2
3900183 1990286 1990286 plaintiff Bryger Richard, junior clothman 586127 586127 Bryger, Richard, junior, of Godalmyng, clothman 0
3900184 1990286 1990286 defendant Busbrydge Robert husbandman 586127 586127 Busbrydge, Robert, of Godalmyng, husbandman 0
4122844 2068463 2068463 defendant Ellyott Lawrence gent 586127 586127 Ellyott, Lawrence, of Godalmyng, gent 0
4193131 2093165 2093165 defendant Athowe John yeoman 586127 586127 Athowe, John, of Godalmyng, yeoman 0
4325895 2139035 2139035 defendant Plonker or Plouker Robert yeoman 586127 586127 Plonker or Plouker, Robert, of Godalmyng, yeoman 0
4441580 2182301 2182301 plaintiff Bovelyth Ralph   586127 586127 Bovelyth, Ralph, of Godalmyng 0
4505935 2202366 2202366 defendant Mason John   586127 586127 Mason, John, of Godalmyng 0
4505937 2202367 2202367 defendant Mason John   586127 586127 Mason, John, of Godalmyng 0
4537095 2211872 2211872 defendant Mason John   586127 586127 Mason, John, of Godalmyng 0
4690893 2262683 2262683 defendant Chitey John husbandman 586127 586127 Chitey, John, of Godalmyng, husbandman 2
4690897 2262684 2262684 defendant atte Nasch John husbandman 586127 586127 atte Nasch, John, of Godalmyng, husbandman 1
4690898 2262684 2262684 defendant Chitey John husbandman 586127 586127 Chitey, John, of Godalmyng, husbandman 2
4788549 2292479 2292479 defendant Cokkill Stephen husbandman 586127 586127 Cokkill, Stephen, of Godalmyng, husbandman 2
4904878 2328126 2328126 defendant Costret Alice widow 586127 586127 Costret, Alice, of Godalmyng, widow 1
5050144 2371667 2371667 plaintiff Tailard John (legal representative) 586127 586127 Tailard, John, of Godalmyng, esq, executrix of 0
5095541 2385116 2385116 defendant Gorewey William yeoman 586127 586127 Gorewey, William, of Godalmyng, yeoman 0
5132832 2396095 2396095 defendant Wyittok Henry   586127 586127 Wyittok, Henry, of Godalmyng, shoe maker 2
5132833 2396095 2396095 defendant Bargeman Simon yeoman 586127 586127 Bargeman, Simon, of Godalmyng, yeoman 3
5132838 2396096 2396096 defendant Whittok Henry shoemaker 586127 586127 Whittok, Henry, of Godalmyng, shoemaker 2
5132839 2396096 2396096 defendant Bargeman Simon yeoman 586127 586127 Bargeman, Simon, of Godalmyng, yeoman 3
5152649 2401914 2401914 defendant Whittok Henry shoemaker 586127 586127 Whittok, Henry, of Godalmyng, shoemaker 2
5152650 2401914 2401914 defendant Bargeman Simon yeoman 586127 586127 Bargeman, Simon, of Godalmyng, yeoman 3
5220009 2421564 2421564 defendant Champyon John husbandman 586127 586127 Champyon, John, of Godalmyng, husbandman 1
5234281 2425612 2425612 defendant Stafford Richard clerk 586127 586127 Stafford, Richard, of Godalmyng, clerk 0
5234283 2425613 2425613 defendant Stafford Richard clerk 586127 586127 Stafford, Richard, of Godalmyng, clerk 0
5269132 2436075 2436075 defendant Bocher John butcher 586127 586127 Bocher, John, of Godalmyng, butcher 1
5271904 2436866 2436866 defendant Westbroke Thomas gent 586127 586127 Westbroke, Thomas, of Godalmyng, gent 1
5271906 2436867 2436867 defendant Westbroke Thomas gent 586127 586127 Westbroke, Thomas, of Godalmyng, gent 0
5458292 2492381 2492381 defendant Wyntreshill Robert gent 586127 586127 Wyntreshill, Robert, of Godalmyng, gent 1
5477929 2498423 2498423 defendant Wyntershyll Thomas (legal representative) 586127 586127 Wyntershyll, Thomas, of Godalmyng, esq, executrix of 3
5489713 2501806 2501806 plaintiff Champyn Arnold   586127 586127 Champyn, Arnold, of Godalmyng 2
5489717 2501807 2501807 plaintiff Champyn Arnulph   586127 586127 Champyn, Arnulph, of Godalmyng 2
5556051 2521765 2521765 defendant Cheswike William yeoman 586127 586127 Cheswike, William, of Godalmyng, yeoman 2
5610146 2546882 2546882 defendant Taillour Henry   586127 586127 Taillour, Henry, of Godalmyng 0
5630409 2553521 2553521 defendant Neel John husbandman 586127 586127 Neel, John, of Godalmyng, husbandman 0
5635634 2555105 2555105 plaintiff Westbrook William   586127 586127 Westbrook, William, of Godalmyng 1
5635635 2555105 2555105 defendant Crostrete Henry cooper 586127 586127 Crostrete, Henry, of Godalmyng, cooper 0

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