names

75 rows where place_id = 599031

✎ 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
3634921 1905723 1905723 defendant Catte Thomas fuller 599031 599031 Catte, Thomas, of Cranbroke, fuller 1
3634922 1905723 1905723 defendant Wardaker Edward fuller 599031 599031 Wardaker, Edward, of Cranbroke, fuller 2
3665828 1915250 1915250 defendant Parker Thomas   599031 599031 Parker, Thomas, of Cranbroke, cloth maker, administratrx of 0
3690508 1923197 1923197 defendant Savy John clothman 599031 599031 Savy, John, of Cranbroke, clothman 0
3694761 1924567 1924567 defendant Stone John clothmaker 599031 599031 Stone, John, of Cranbroke, clothmaker 0
3694994 1924646 1924646 defendant Mapysden William butcher 599031 599031 Mapysden, William, of Cranbroke, butcher 0
3695577 1924845 1924845 defendant Auncell Thomas weaver 599031 599031 Auncell, Thomas, of Cranbroke, weaver 1
3695579 1924845 1924845 defendant West William weaver 599031 599031 West, William, of Cranbroke, weaver 3
3695580 1924845 1924845 defendant Wylkynson John weaver 599031 599031 Wylkynson, John, of Cranbroke, weaver 4
3697647 1925488 1925488 defendant Gryffyn John laborer 599031 599031 Gryffyn, John, of Cranbroke, laborer 0
3709862 1929399 1929399 defendant Stone John clothier 599031 599031 Stone, John, of Cranbroke, clothier 2
3792610 1955548 1955548 defendant Fowler Thomas husbandman 599031 599031 Fowler, Thomas, of Cranbroke, husbandman 0
3842154 1971095 1971095 defendant More William (legal representative) 599031 599031 More, William, of Cranbroke, gent, executors of 0
3844635 1971864 1971864 plaintiff Davy Thomas   599031 599031 Davy, Thomas, of Cranbroke 0
3844637 1971865 1971865 plaintiff Davy Thomas   599031 599031 Davy, Thomas, of Cranbroke 0
3858558 1976345 1976345 defendant More William (legal representative) 599031 599031 More, William, of Cranbroke, gent, executors of 0
3858559 1976345 1976345 defendant Oldford Roger yeoman 599031 599031 (Oldford, Roger, of Cranbroke, yeoman 1
3894610 1988406 1988406 defendant Henley Walter clothier 599031 599031 Henley, Walter, of Cranbroke, clothier 1
3896070 1988889 1988889 defendant Cryer Matthew clothmaker 599031 599031 Cryer, Matthew, of Cranbroke, clothmaker 0
3896090 1988894 1988894 defendant Chetynden Richard clothman 599031 599031 Chetynden, Richard, of Cranbroke, clothman 4
3904654 1991812 1991812 defendant Colyour Roger yeoman 599031 599031 Colyour, Roger, of Cranbroke, yeoman 2
3910409 1993799 1993799 defendant Scranton Simon clothier 599031 599031 Scranton, Simon, of Cranbroke, clothier 0
3910411 1993799 1993799 defendant Colyer Richard clothier 599031 599031 Colyer, Richard, of Cranbroke, clothier 2
3910412 1993799 1993799 defendant Colyer Roger clothier 599031 599031 Colyer, Roger, of Cranbroke, clothier 3
3943142 2004721 2004721 defendant Manser Thomas clothier 599031 599031 Manser, Thomas, of Cranbroke, clothier 0
3953006 2008119 2008119 defendant Marten William yeoman 599031 599031 Marten, William, of Cranbroke, yeoman 0
3969516 2013947 2013947 plaintiff Courthopp Peter   599031 599031 Courthopp, Peter, of Cranbroke 0
3973301 2015235 2015235 defendant Davey Jervis mercer 599031 599031 Davey, Jervis, of Cranbroke, mercer 0
3982783 2018614 2018614 plaintiff Sharpe John clothier 599031 599031 Sharpe, John, of Cranbroke, clothier 0
3987021 2020099 2020099 defendant Davey Jervis mercer 599031 599031 Davey, Jervis, of Cranbroke, mercer 0
4002403 2025638 2025638 plaintiff Henley Walter gent 599031 599031 Henley, Walter, of Cranbroke, gent 0
4036517 2037743 2037743 defendant Collyer Dorothy widow 599031 599031 Collyer, Dorothy, of Cranbroke, widow 1
4046489 2041195 2041195 defendant Milgate William yeoman 599031 599031 Milgate, William, of Cranbroke, yeoman 0
4046492 2041196 2041196 defendant Mylgate William yeoman 599031 599031 Mylgate, William, of Cranbroke, yeoman 0
4075889 2051680 2051680 defendant Taylor Robert clothier 599031 599031 Taylor, Robert, of Cranbroke, clothier 0
4092263 2057534 2057534 defendant Holford alias Gilbert Robert butcher 599031 599031 Holford alias Gilbert, Robert, of Cranbroke, butcher 3
4156942 2080507 2080507 defendant Honys William clothier 599031 599031 Honys, William, of Cranbroke, clothier 0
4183459 2089693 2089693 defendant Russell John tailor 599031 599031 Russell, John, of Cranbroke, tailor 0
4223872 2103836 2103836 defendant Dorlye Thomas yeoman 599031 599031 Dorlye, Thomas, of Cranbroke, yeoman 0
4229808 2105910 2105910 defendant Batherst Robert clothier 599031 599031 Batherst, Robert, of Cranbroke, clothier 0
4230804 2106273 2106273 defendant Dan John shoemaker 599031 599031 Dan, John, of Cranbroke, shoemaker 2
4331601 2140867 2140867 defendant Weller John clothier 599031 599031 Weller, John, of Cranbroke, clothier 0
4493729 2198737 2198737 defendant Kytte Thomas   599031 599031 Kytte, Thomas, of Cranbroke 0
4510111 2203649 2203649 defendant Bakere John   599031 599031 Bakere, John, of Cranbroke 1
4655443 2247598 2247598 defendant atte Putte Richard fuller 599031 599031 atte Putte, Richard, of Cranbroke, fuller 0
4655444 2247598 2247598 defendant Calche John weaver 599031 599031 Calche, John, of Cranbroke, weaver 1
4655445 2247598 2247598 defendant Tily Thomas laborer 599031 599031 Tily, Thomas, of Cranbroke, laborer 2
4655447 2247599 2247599 defendant Draghnere Thomas husbandman 599031 599031 Draghnere, Thomas, of Cranbroke, husbandman 0
4657366 2248195 2248195 defendant Tylthe William husbandman 599031 599031 Tylthe, William, of Cranbroke, husbandman 0
4667660 2255596 2255596 defendant Bettenham John   599031 599031 Bettenham, John, of Cranbroke, son of Stephen, son of Richard 1
4671269 2256667 2256667 defendant Idenne John husbandman 599031 599031 Idenne, John, of Cranbroke, husbandman 0
4674933 2257770 2257770 defendant atte Pette Richard fuller 599031 599031 atte Pette, Richard, of Cranbroke, fuller 0
4674935 2257771 2257771 defendant Sayndon Richard fuller 599031 599031 Sayndon, Richard, of Cranbroke, fuller 0
4722288 2272294 2272294 defendant Tylte William husbandman 599031 599031 Tylte, William, of Cranbroke, husbandman 0
4741375 2277975 2277975 defendant Boweman Thomas tailor 599031 599031 Boweman, Thomas, of Cranbroke, tailor 0
4821748 2302878 2302878 defendant Frensheman Andrew chaplain 599031 599031 Frensheman, Andrew, of Cranbroke, chaplain 0
4821751 2302880 2302880 plaintiff Salt William   599031 599031 Salt, William, of Cranbroke 0
4955552 2343620 2343620 defendant Bokeherst William husbandman 599031 599031 Bokeherst, William, of Cranbroke, husbandman 0
5089634 2383343 2383343 defendant Bettenham Thomas laborer 599031 599031 Bettenham, Thomas, of Cranbroke, laborer 0
5122654 2393058 2393058 defendant Dravell or Dranell Thomas clothmaker 599031 599031 Dravell or Dranell, Thomas, of Cranbroke, clothmaker 0
5190831 2413068 2413068 defendant Bea_ Stephen gent 599031 599031 Bea_, Stephen, of Cranbroke, gent 0
5210902 2418921 2418921 defendant Waterman John husbandman 599031 599031 Waterman, John, of Cranbroke, husbandman 0
5246191 2429047 2429047 defendant Joly John husbandman 599031 599031 Joly, John, of Cranbroke, husbandman 0
5269863 2436291 2436291 defendant Rede Robert dyer 599031 599031 Rede, Robert, of Cranbroke, dyer 4
5294524 2443374 2443374 defendant Ponte Richard butcher 599031 599031 Ponte, Richard, of Cranbroke, butcher 0
5294526 2443374 2443374 defendant Broun Joan widow 599031 599031 Broun, Joan, of Cranbroke, widow 2
5359624 2463045 2463045 defendant Seynden John dyer 599031 599031 Seynden, John, of Cranbroke, dyer 0
5359625 2463045 2463045 defendant Seynden Thomas chaplain 599031 599031 Seynden, Thomas, of Cranbroke, chaplain 1
5359626 2463045 2463045 defendant Seynden Ralph husbandman 599031 599031 Seynden, Ralph, of Cranbroke, husbandman 2
5448015 2489291 2489291 defendant Taylor Robert clothman 599031 599031 Taylor, Robert, of Cranbroke, clothman 1
5454634 2491304 2491304 defendant Berham Henry gent 599031 599031 (Berham, Henry, of Cranbroke, gent 1
5512509 2508773 2508773 defendant Lane John yeoman 599031 599031 Lane, John, of Cranbroke, yeoman 0
5512515 2508774 2508774 defendant Lane John yeoman 599031 599031 Lane, John, of Cranbroke, yeoman 2
5579279 2528593 2528593 defendant Hepe Robert weaver 599031 599031 Hepe, Robert, of Cranbroke, weaver 0
5592464 2532629 2532629 plaintiff Weller Thomas   599031 599031 Weller, Thomas, of Cranbroke 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);