names

127 rows where place_id = 608035

✎ 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
3671919 1917213 1917213 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3675615 1918409 1918409 defendant Starkey Lawrence esq 608035 608035 Starkey, Lawrence, of Lancaster, esq 1
3698200 1925663 1925663 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 2
3698207 1925664 1925664 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 2
3698214 1925665 1925665 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 2
3698221 1925666 1925666 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 2
3706754 1928397 1928397 defendant Starky Lawrence esq 608035 608035 Starky, Lawrence, of Lancaster, esq 1
3706755 1928397 1928397 defendant Cantefeld Robert gent 608035 608035 Cantefeld, Robert, of Lancaster, gent 2
3716578 1931482 1931482 defendant Gerard Thomas (legal representative) 608035 608035 Gerard, Thomas, of Lancaster, knight, executors of 0
3720584 1932720 1932720 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3720872 1932823 1932823 defendant Starky Lawrence esq 608035 608035 Starky, Lawrence, of Lancaster, esq 0
3727011 1934714 1934714 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3727016 1934715 1934715 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3727021 1934716 1934716 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3727026 1934717 1934717 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3730613 1935809 1935809 defendant Starky Lawrence gent 608035 608035 Starky, Lawrence, of Lancaster, gent 0
3736679 1937726 1937726 defendant Starkey Lawrence esq 608035 608035 Starkey, Lawrence, of Lancaster, esq 0
3736681 1937727 1937727 defendant Starky Lawrence esq 608035 608035 Starky, Lawrence, of Lancaster, esq 0
3737515 1937973 1937973 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3742632 1939564 1939564 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3742637 1939566 1939566 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3746867 1940937 1940937 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 2
3749780 1941841 1941841 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 4
3751128 1942277 1942277 defendant Wynder William yeoman 608035 608035 Wynder, William, of Lancaster, yeoman 0
3755109 1943546 1943546 defendant Grene William   608035 608035 Grene, William, of Lancaster, doctor of theology 0
3767156 1947375 1947375 defendant Standysshe John gent 608035 608035 Standysshe, John, of Lancaster, gent 0
3767157 1947375 1947375 defendant Parker Robert gent 608035 608035 Parker, Robert, of Lancaster, gent 1
3767210 1947384 1947384 defendant Standyss John gent 608035 608035 Standyss, John, of Lancaster, gent 3
3771916 1948909 1948909 plaintiff Tomson William chapman 608035 608035 Tomson, William, of Lancaster, chapman 0
3784909 1953072 1953072 defendant Standysshe John gent 608035 608035 Standysshe, John, of Lancaster, gent 0
3784911 1953072 1953072 defendant Kendall Thomas yeoman 608035 608035 Kendall, Thomas, of Lancaster, yeoman 2
3789561 1954563 1954563 plaintiff Tomson William chapman 608035 608035 Tomson, William, of Lancaster, chapman 0
3801432 1958369 1958369 defendant Standysshe John gent 608035 608035 Standysshe, John, of Lancaster, gent 0
3801433 1958369 1958369 defendant Laton Anthony gent 608035 608035 Laton, Anthony, of Lancaster, gent 1
3801434 1958369 1958369 defendant Southworth Richard gent 608035 608035 Southworth, Richard, of Lancaster, gent 2
3801789 1958455 1958455 defendant Cansfeld Robert gent 608035 608035 Cansfeld, Robert, of Lancaster, gent 2
3803854 1959120 1959120 defendant Starkey Lawrence gent 608035 608035 Starkey, Lawrence, of Lancaster, gent 0
3805035 1959517 1959517 defendant Waywyn Robert yeoman 608035 608035 Waywyn, Robert, of Lancaster, yeoman 2
3815576 1962789 1962789 plaintiff Hargresse Christopher clothier 608035 608035 Hargresse, Christopher, of Lancaster, clothier 0
3852782 1974475 1974475 defendant Starky Lawrence gent 608035 608035 Starky, Lawrence, of Lancaster, gent 0
3862239 1977555 1977555 defendant Edmondson Lawrence gent 608035 608035 Edmondson, Lawrence, of Lancaster, gent 2
3945118 2005386 2005386 defendant Wharton William chapman 608035 608035 Wharton, William, of Lancaster, or of Donton in Furnys, chapman 0
3976329 2016295 2016295 defendant Kechyn Jane widow 608035 608035 Kechyn, Jane, of Lancaster, widow 0
4063521 2047240 2047240 defendant Syngleton Thomas yeoman 608035 608035 Syngleton, Thomas, of Lancaster, yeoman 1
4066598 2048349 2048349 defendant Browne James vintner 608035 608035 Browne, James, of Lancaster, vintner 0
4066599 2048349 2048349 defendant Gilpyn Randolph vintner 608035 608035 Gilpyn, Randolph, of Lancaster, vintner 1
4066600 2048349 2048349 defendant Noble Thomas vintner 608035 608035 Noble, Thomas, of Lancaster, vintner 2
4089257 2056443 2056443 defendant Brittan Thomas tanner 608035 608035 Brittan, Thomas, of Lancaster, tanner 1
4090656 2056946 2056946 defendant Fell Randolph   608035 608035 Fell, Randolph, of Lancaster, coverlet weaver or chandler 0
4090657 2056946 2056946 defendant Standish Thomas yeoman 608035 608035 Standish, Thomas, of Lancaster, yeoman 1
4090660 2056947 2056947 defendant Fell Randolph   608035 608035 Fell, Randolph, of Lancaster, coverlet weaver 0
4090661 2056947 2056947 defendant Standyshe Thomas yeoman 608035 608035 Standyshe, Thomas, of Lancaster, yeoman 1
4102643 2061246 2061246 defendant Grensfeld or Grenfeld Gregory chapman 608035 608035 Grensfeld or Grenfeld, Gregory, of Lancaster, chapman 0
4103031 2061374 2061374 defendant Fell Randolph   608035 608035 Fell, Randolph, of Lancaster, coverlet maker 0
4116760 2066292 2066292 defendant Westmore Thomas chapman 608035 608035 Westmore, Thomas, of Lancaster, chapman 0
4127900 2070269 2070269 defendant Newton Brian chapman 608035 608035 Newton, Brian, of Lancaster, chapman 0
4127914 2070273 2070273 defendant West Thomas chapman 608035 608035 West, Thomas, of Lancaster, chapman 2
4146526 2076937 2076937 defendant Browne James innholder 608035 608035 Browne, James, of Lancaster, innholder 0
4163343 2082706 2082706 defendant Grenefeld Gregory chapman 608035 608035 Grenefeld, Gregory, of Lancaster, chapman 0
4163344 2082706 2082706 defendant Wylson Thomas chapman 608035 608035 Wylson, Thomas, of Lancaster, chapman 1
4168672 2084530 2084530 defendant Porter Henry clerk 608035 608035 Porter, Henry, of Lancaster, clerk 0
4175602 2086935 2086935 defendant Banton James yeoman 608035 608035 Banton, James, of Lancaster, yeoman 0
4183267 2089629 2089629 defendant Porter Henry   608035 608035 Porter, Henry, of Lancaster, clerk, vicar 0
4213236 2100147 2100147 defendant Stanynoght William gent 608035 608035 Stanynoght, William, of Lancaster, gent 3
4214553 2100596 2100596 defendant Browne James gent 608035 608035 Browne, James, of Lancaster, gent 1
4218716 2102047 2102047 defendant Haworth John gent 608035 608035 Haworth, John, of Lancaster, gent 1
4244805 2111250 2111250 defendant Haworth John gent 608035 608035 Haworth, John, of Lancaster, gent 1
4338584 2143249 2143249 defendant Sowthworth Anne widow 608035 608035 Sowthworth, Anne, of Lancaster, widow 1
4347691 2146441 2146441 defendant Spademan Richard chapman 608035 608035 Spademan, Richard, of Lancaster, chapman 0
4348453 2146710 2146710 defendant Newton William draper 608035 608035 Newton, William, of Lancaster, draper 0
4360753 2151018 2151018 defendant Croskell or Crosgell Thomas yeoman 608035 608035 Croskell or Crosgell, Thomas, of Lancaster, yeoman 0
4368165 2153666 2153666 defendant Copland Francis chapman 608035 608035 Copland, Francis, of Lancaster, chapman 1
4368166 2153666 2153666 defendant Westmore Richard chapman 608035 608035 Westmore, Richard, of Lancaster, chapman 2
4421777 2171691 2171691 defendant Condera John   608035 608035 together with Condera, John, of Lancaster, prior 1
4428843 2173824 2173824 defendant Porter Adam le   608035 608035 Porter, Adam le, of Lancaster, son of Adam 0
4428844 2173824 2173824 defendant Perkynson John   608035 608035 Perkynson, John, of Lancaster 1
4435720 2175916 2175916 plaintiff Philipp John   608035 608035 Philipp, John, of Lancaster, son of William 0
4441287 2182208 2182208 defendant Strangwas John   608035 608035 Strangwas, John, of Lancaster, son of Thomas 0
4441288 2182208 2182208 defendant Hert Thomas   608035 608035 Hert, Thomas, of Lancaster 1
4442391 2182560 2182560 defendant Catour John butcher 608035 608035 Catour, John, of Lancaster, butcher 4
4479595 2194282 2194282 plaintiff Jacson John   608035 608035 Jacson, John, of Lancaster 0
4496943 2199711 2199711 defendant Hilton Roger   608035 608035 Hilton, Roger, of Lancaster 0
4500076 2200670 2200670 defendant Nowel John esq 608035 608035 Nowel, John, of Lancaster, esq 1
4502520 2201372 2201372 defendant Katton John   608035 608035 Katton, John, of Lancaster 0
4502521 2201372 2201372 defendant Sktooisson Thomas merchant 608035 608035 Sktooisson, Thomas, of Lancaster, merchant 1
4504002 2201809 2201809 plaintiff (not given) John de prior of Lancastre 608035 608035 (Lancastre, John de, of Lancaster, prior of: Pykeryng, Jacob de 1
4504023 2201811 2201811 plaintiff (not given) John de prior of Lancastre 608035 608035 (Lancastre, John de, of Lancaster, prior of the brothers 1
4621083 2237577 2237577 defendant Laweset William   608035 608035 Laweset, William, of Lancaster 1
4622005 2237860 2237860 defendant Dacre Thomas de esq 608035 608035 Dacre, Thomas de, of Lancaster, esq 0
4623910 2238457 2238457 defendant Halle Roger mercer 608035 608035 Halle, Roger, of Lancaster, mercer 0
4635502 2241964 2241964 defendant atte Hall Roger   608035 608035 atte Hall, Roger, of Lancaster 1
4640058 2243215 2243215 defendant Plomme Roger   608035 608035 Plomme, Roger, of Lancaster 5
4640067 2243216 2243216 defendant Plomme Roger   608035 608035 Plomme, Roger, of Lancaster 5
4640084 2243218 2243218 defendant Plomme Roger   608035 608035 Plomme, Roger, of Lancaster 5
4650602 2246195 2246195 defendant Lumlay Henry tanner 608035 608035 Lumlay, Henry, of Lancaster, tanner 6
4659292 2248774 2248774 defendant Gibson William chapman 608035 608035 Gibson, William, of Lancaster, chapman 0
4659294 2248774 2248774 defendant Gibson Nicholas chapman 608035 608035 Gibson, Nicholas, of Lancaster, chapman 2
4771163 2286963 2286963 defendant Ryddynges Richard gent 608035 608035 Ryddynges, Richard, of Lancaster, gent 1
4804167 2297492 2297492 defendant Gardiner William smith 608035 608035 Gardiner, William, of Lancaster, smith 1
4834555 2306815 2306815 defendant Langton Adam gent 608035 608035 Langton, Adam, of Lancaster, gent 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);