names

807 rows where place_id = 587205

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590100 1864542 1864542 defendant Lane John (legal representative) 587205 587205 Lane, John, of Grantham, executrix of 5
3590746 1864746 1864746 defendant Blak William barker 587205 587205 Blak, William, of Grantham, barker 0
3593624 1865640 1865640 defendant Wiresdale Robert mercer 587205 587205 Wiresdale, Robert, of Grantham, mercer 1
3593628 1865641 1865641 defendant Wiresdale Robert mercer 587205 587205 Wiresdale, Robert, of Grantham, mercer 1
3593919 1865737 1865737 defendant Dagges Thomas gent 587205 587205 Dagges, Thomas, of Grantham, gent 0
3593921 1865738 1865738 defendant Nycoll Henry yeoman 587205 587205 Nycoll, Henry, of Grantham, yeoman 0
3593923 1865739 1865739 defendant Page Thomas husbandman 587205 587205 Page, Thomas, of Grantham, husbandman 0
3593924 1865739 1865739 defendant Pounder John husbandman 587205 587205 Pounder, John, of Grantham, husbandman 1
3612552 1871560 1871560 plaintiff Hodson William   587205 587205 Hodson, William, of Grantham 2
3626871 1903255 1903255 defendant Thorp John butcher 587205 587205 Thorp, John, of Grantham, butcher 0
3627709 1903528 1903528 defendant Ford or Forth Richard mercer 587205 587205 Ford or Forth, Richard, of Grantham, mercer 0
3627710 1903528 1903528 defendant Leveret Henry mercer 587205 587205 Leveret, Henry, of Grantham, mercer 1
3633186 1905193 1905193 defendant Conell William dyer 587205 587205 Conell, William, of Grantham, dyer 0
3633821 1905391 1905391 defendant Ford Richard mercer 587205 587205 Ford, Richard, of Grantham, mercer 0
3633822 1905391 1905391 defendant Ford Robert chaplain 587205 587205 Ford, Robert, of Grantham, chaplain 1
3633823 1905391 1905391 defendant Baynbrig Robert innholder 587205 587205 Baynbrig, Robert, of Grantham, innholder 2
3637764 1906626 1906626 defendant Man Thomas baker 587205 587205 Man, Thomas, of Grantham, baker 1
3642402 1908068 1908068 defendant Doubleday William yeoman 587205 587205 Doubleday, William, of Grantham, yeoman 0
3646758 1909391 1909391 defendant Hall Francis merchant 587205 587205 Hall, Francis, of Grantham, merchant 0
3646760 1909392 1909392 defendant Hall Francis merchant 587205 587205 Hall, Francis, of Grantham, merchant 0
3659548 1913247 1913247 defendant Harbart Richard mercer 587205 587205 Harbart, Richard, of Grantham, mercer 0
3660836 1913655 1913655 defendant Doubleday Henry baker 587205 587205 Doubleday, Henry, of Grantham, baker 0
3660838 1913656 1913656 defendant Doubleday Henry baker 587205 587205 Doubleday, Henry, of Grantham, baker 0
3672408 1917372 1917372 defendant Woderose or Woderofe John baker 587205 587205 Woderose or Woderofe, John, of Grantham, baker 1
3673835 1917848 1917848 defendant Sleford John yeoman 587205 587205 Sleford, John, of Grantham, yeoman 0
3673836 1917848 1917848 defendant Haskard John baker 587205 587205 Haskard, John, of Grantham, baker 1
3673838 1917849 1917849 defendant Sleford John yeoman 587205 587205 Sleford, John, of Grantham, yeoman 0
3673839 1917849 1917849 defendant Haskard John baker 587205 587205 Haskard, John, of Grantham, baker 1
3676739 1918759 1918759 defendant Amers John haberdasher 587205 587205 Amers, John, of Grantham, haberdasher 0
3676741 1918760 1918760 defendant Mers John haberdasher 587205 587205 Mers, John, of Grantham, haberdasher 0
3677187 1918907 1918907 defendant Wylkynson John clerk 587205 587205 Wylkynson, John, of Grantham, clerk 1
3685510 1921620 1921620 defendant Bregys Henry miller 587205 587205 Bregys, Henry, of Grantham, miller 0
3686724 1922002 1922002 defendant Sleford alias Slee John gent 587205 587205 Sleford alias Slee, John, of Grantham, gent 0
3692958 1923998 1923998 defendant Balson Robert yeoman 587205 587205 Balson, Robert, of Grantham, yeoman 0
3692959 1923998 1923998 defendant Woodward John yeoman 587205 587205 Woodward, John, of Grantham, yeoman 1
3720376 1932652 1932652 defendant Smalley John yeoman 587205 587205 Smalley, John, of Grantham, yeoman 1
3724809 1934044 1934044 defendant Randall William yeoman 587205 587205 Randall, William, of Grantham, yeoman 0
3726191 1934456 1934456 defendant Pyke Robert baker 587205 587205 Pyke, Robert, of Grantham, baker 0
3727804 1934964 1934964 defendant Dobleday William husbandman 587205 587205 (Dobleday, William, of Grantham, husbandman 1
3729934 1935617 1935617 defendant Bryan Robert walker 587205 587205 Bryan, Robert, of Grantham, walker 0
3730456 1935756 1935756 defendant Herbert Richard husbandman 587205 587205 Herbert, Richard, of Grantham, husbandman 0
3731388 1936038 1936038 defendant Toller Leonard cordwainer 587205 587205 Toller, Leonard, of Grantham, cordwainer 0
3737205 1937868 1937868 defendant Shepard Richard clerk 587205 587205 Shepard, Richard, of Grantham, clerk 0
3737206 1937868 1937868 defendant Wylkynson John clerk 587205 587205 Wylkynson, John, of Grantham, clerk 1
3739055 1938422 1938422 plaintiff Padley Simon (legal representative) 587205 587205 Padley, Simon, of Grantham, butcher, executor of 0
3739993 1938730 1938730 defendant Nodyll Richard laborer 587205 587205 Nodyll, Richard, of Grantham, laborer 0
3740860 1939000 1939000 defendant Lees Thomas dyer 587205 587205 Lees, Thomas, of Grantham, dyer 0
3740861 1939000 1939000 defendant Hasker John baker 587205 587205 Hasker, John, of Grantham, baker 1
3741792 1939296 1939296 defendant Towler Leonard   587205 587205 Towler, Leonard, of Grantham, tallow chandler 0
3742278 1939456 1939456 defendant Merys William mercer 587205 587205 Merys, William, of Grantham, mercer 0
3742428 1939502 1939502 defendant Toller Leonard chandler 587205 587205 Toller, Leonard, of Grantham, chandler 0
3742429 1939502 1939502 defendant Bracebrig Edmund gent 587205 587205 Bracebrig, Edmund, of Grantham, gent 1
3742430 1939502 1939502 defendant Man John husbandman 587205 587205 Man, John, of Grantham, husbandman 2
3744019 1940022 1940022 defendant Meres William mercer 587205 587205 Meres, William, of Grantham, mercer 0
3750004 1941918 1941918 defendant Bracebrig Edward gent 587205 587205 (Bracebrig, Edward, of Grantham, gent 1
3751765 1942471 1942471 defendant Hall Francis merchant of the staple 587205 587205 Hall, Francis, of Grantham, esq, merchant of the staple 0
3754418 1943339 1943339 defendant Merys William mercer 587205 587205 Merys, William, of Grantham, mercer 0
3756346 1943952 1943952 defendant Steffon Robert fishmonger 587205 587205 Steffon, Robert, of Grantham, fishmonger 0
3761833 1945709 1945709 defendant Alen Richard mercer 587205 587205 Alen, Richard, of Grantham, mercer 3
3770187 1948343 1948343 defendant Slye alias Slefford John (legal representative) 587205 587205 Slye alias Slefford, John, of Grantham, gent, executors of 0
3770188 1948343 1948343 defendant Slye Ralph gent 587205 587205 (Slye, Ralph, of Grantham, gent 1
3770189 1948343 1948343 defendant Alyn Thomas innholder 587205 587205 Alyn, Thomas, of Grantham, innholder 2
3771058 1948636 1948636 defendant Hall John gent 587205 587205 Hall, John, of Grantham, gent 0
3781263 1951880 1951880 defendant Murre John sherman 587205 587205 Murre, John, of Grantham, sherman 0
3783006 1952436 1952436 defendant Hall Francis esq 587205 587205 Hall, Francis, of Grantham, esq 0
3783230 1952508 1952508 defendant Forde Richard mercer 587205 587205 Forde, Richard, of Grantham, mercer 0
3786443 1953550 1953550 defendant Hasker Elizabeth widow 587205 587205 Hasker, Elizabeth, of Grantham, widow 1
3786444 1953550 1953550 defendant Skynner William mercer 587205 587205 Skynner, William, of Grantham, mercer 2
3786445 1953550 1953550 defendant Patynson William butcher 587205 587205 Patynson, William, of Grantham, butcher 3
3787998 1954037 1954037 defendant Slye alias Sleford John   587205 587205 Slye alias Sleford, John, of Grantham, gent, administrators of 0
3787999 1954037 1954037 defendant Slye Ralph gent 587205 587205 (Slye, Ralph, of Grantham, gent 1
3788000 1954037 1954037 defendant Alyn Thomas innholder 587205 587205 Alyn, Thomas, of Grantham, innholder 2
3789275 1954463 1954463 defendant Stevyns Robert fisher 587205 587205 Stevyns, Robert, of Grantham, fisher 0
3794074 1956010 1956010 defendant Forde Richard mercer 587205 587205 Forde, Richard, of Grantham, mercer 0
3800330 1958020 1958020 defendant Smalley John yeoman 587205 587205 Smalley, John, of Grantham, yeoman 0
3809772 1960944 1960944 defendant Franklyn Richard butcher 587205 587205 Franklyn, Richard, of Grantham, butcher 0
3817860 1963501 1963501 defendant Smalley John yeoman 587205 587205 Smalley, John, of Grantham, yeoman 0
3818560 1963708 1963708 plaintiff Rawlynson William   587205 587205 Rawlynson, William, of Grantham 2
3833455 1968393 1968393 defendant Massyngberd Agnes widow 587205 587205 Massyngberd, Agnes, of Grantham, widow 0
3834182 1968632 1968632 defendant Chamber Thomas barber 587205 587205 Chamber, Thomas, of Grantham, barber 0
3834183 1968632 1968632 defendant Rawlyns William   587205 587205 Rawlyns, William, of Grantham, tallow chandler 1
3840224 1970509 1970509 defendant Tomlyn John miller 587205 587205 Tomlyn, John, of Grantham, miller 0
3840720 1970664 1970664 defendant Tayllour Robert yeoman 587205 587205 Tayllour, Robert, of Grantham, yeoman 0
3840721 1970664 1970664 defendant Kyrke Thomas fuller 587205 587205 Kyrke, Thomas, of Grantham, fuller 1
3840723 1970665 1970665 defendant Porter Thomas glasier 587205 587205 Porter, Thomas, of Grantham, glasier 0
3848301 1973040 1973040 defendant Meres William mercer 587205 587205 Meres, William, of Grantham, mercer 0
3849914 1973559 1973559 defendant Johnson Richard husbandman 587205 587205 Johnson, Richard, of Grantham, husbandman 0
3861385 1977276 1977276 defendant Kyrkeby Thomas yeoman 587205 587205 Kyrkeby, Thomas, of Grantham, yeoman 0
3861652 1977355 1977355 defendant Crymshawe Thomas yeoman 587205 587205 Crymshawe, Thomas, of Grantham, yeoman 0
3863489 1977985 1977985 defendant Meres William mercer 587205 587205 Meres, William, of Grantham, mercer 0
3863490 1977985 1977985 defendant Forde Richard mercer 587205 587205 Forde, Richard, of Grantham, mercer 1
3869561 1980060 1980060 defendant Halle Edward gent 587205 587205 Halle, Edward, of Grantham, gent 2
3873922 1981497 1981497 defendant Thompson James yeoman 587205 587205 Thompson, James, of Grantham, yeoman 0
3875747 1982138 1982138 defendant Crymshawe Thomas yeoman 587205 587205 Crymshawe, Thomas, of Grantham, yeoman 0
3876685 1982447 1982447 plaintiff Hall Francis, senior   587205 587205 Hall, Francis, senior, of Grantham, esq, administrators of 0
3877654 1982768 1982768 defendant Meres William mercer 587205 587205 Meres, William, of Grantham, mercer 0
3881964 1984226 1984226 defendant Rawlenson William weaver 587205 587205 Rawlenson, William, of Grantham, weaver 0
3881988 1984235 1984235 defendant Kyrkeby Thomas yeoman 587205 587205 Kyrkeby, Thomas, of Grantham, yeoman 0
3882508 1984414 1984414 defendant Patman William yeoman 587205 587205 Patman, William, of Grantham, yeoman 1
3882510 1984415 1984415 defendant Atkynson Hugh yeoman 587205 587205 Atkynson, Hugh, of Grantham, yeoman 0

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