names

263 rows where place_id = 586963

✎ 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
3590101 1864542 1864542 defendant Lane Joan widow 586963 586963 Lane, Joan, of Grantham, Lincs, widow 6
3591429 1864946 1864946 defendant Horner John yeoman 586963 586963 Horner, John, of Grantham, Lincs, yeoman 0
3593623 1865640 1865640 defendant Catley Ralph barber 586963 586963 Catley, Ralph, of Grantham, Lincs, barber 0
3593627 1865641 1865641 defendant Catley Ralph barber 586963 586963 Catley, Ralph, of Grantham, Lincs, barber 0
3600235 1867720 1867720 defendant Claxton John chapman 586963 586963 Claxton, John, of Grantham, Lincs, chapman 4
3601282 1868066 1868066 defendant Barnby Richard esq 586963 586963 Barnby, Richard, of Grantham, Lincs, esq 0
3605344 1869338 1869338 defendant Barnby Richard gent 586963 586963 Barnby, Richard, of Grantham, Lincs, gent 0
3613187 1871779 1871779 defendant Dages Thomas gent 586963 586963 Dages, Thomas, of Grantham, Lincs, gent 0
3631542 1904681 1904681 defendant Hall Francis merchant of the staple 586963 586963 Hall, Francis, of Grantham, Lincs, gent, merchant of the staple 0
3639561 1907182 1907182 defendant Thomlynson Richard mercer 586963 586963 Thomlynson, Richard, of Grantham, Lincs, mercer 0
3639656 1907213 1907213 defendant Dent Mathew butcher 586963 586963 Dent, Mathew, of Grantham, Lincs, butcher 0
3644781 1908773 1908773 defendant Gerrard Thomas beker 586963 586963 Gerrard, Thomas, of Grantham, Lincs, beker 3
3646413 1909274 1909274 defendant Becher Mathew butcher 586963 586963 Becher, Mathew, of Grantham, Lincs, butcher 1
3673003 1917565 1917565 defendant Herbert Richard chapman 586963 586963 Herbert, Richard, of Grantham, Lincs, chapman 1
3677186 1918907 1918907 defendant Sheperd Richard clerk 586963 586963 Sheperd, Richard, of Grantham, Lincs, clerk 0
3678188 1919228 1919228 defendant Pyttys John tanner 586963 586963 Pyttys, John, of Grantham, Lincs, tanner 1
3682306 1920565 1920565 defendant Alyn Richard mercer 586963 586963 Alyn, Richard, of Grantham, Lincs, mercer 0
3685330 1921564 1921564 defendant Halle Francis gent 586963 586963 Halle, Francis, of Grantham, Lincs, gent 0
3690621 1923232 1923232 defendant Alyn Richard mercer 586963 586963 Alyn, Richard, of Grantham, Lincs, mercer 0
3698373 1925710 1925710 defendant Ford Richard yeoman 586963 586963 Ford, Richard, of Grantham, Lincs, yeoman 0
3698375 1925711 1925711 defendant Ford Richard yeoman 586963 586963 Ford, Richard, of Grantham, Lincs, yeoman 0
3699570 1926097 1926097 defendant Halle Francis merchant of the staple 586963 586963 Halle, Francis, of Grantham, Lincs, gent, merchant of the staple 0
3700382 1926357 1926357 defendant Halle Francis gent 586963 586963 Halle, Francis, of Grantham, Lincs, gent 0
3701856 1926831 1926831 defendant Sleforthe John gent 586963 586963 Sleforthe, John, of Grantham, Lincs, gent 0
3703495 1927367 1927367 defendant Halle Francis merchant 586963 586963 Halle, Francis, of Grantham, Lincs, merchant 0
3706625 1928357 1928357 defendant Halle Francis gent 586963 586963 Halle, Francis, of Grantham, Lincs, gent 0
3712285 1930157 1930157 defendant Chamber Thomas barber 586963 586963 Chamber, Thomas, of Grantham, Lincs, barber 0
3712649 1930271 1930271 defendant Sleforthe John   586963 586963 Sleforthe, John, of Grantham, Lincs, gent, bailiff 0
3715178 1931040 1931040 defendant Hall Francis gent 586963 586963 Hall, Francis, of Grantham, Lincs, gent 1
3722142 1933187 1933187 defendant Meres William mercer 586963 586963 Meres, William, of Grantham, Lincs, mercer 3
3738175 1938154 1938154 defendant Braycebrig Edmund gent 586963 586963 Braycebrig, Edmund, of Grantham, Lincs, gent 1
3742079 1939391 1939391 defendant Pownder William   586963 586963 Pownder, William, of Grantham, Lincs, knight 1
3748734 1941535 1941535 defendant Toller Leonard   586963 586963 Toller, Leonard, of Grantham, Lincs, tallow chandler 2
3756344 1943951 1943951 defendant Wylkynson Thomas mercer 586963 586963 Wylkynson, Thomas, of Grantham, Lincs, mercer 2
3760997 1945442 1945442 defendant Wylkynson John clerk 586963 586963 Wylkynson, John, of Grantham, Lincs, clerk 0
3761831 1945709 1945709 defendant Forde Richard mercer 586963 586963 Forde, Richard, of Grantham, Lincs, mercer 1
3771348 1948730 1948730 defendant Toller Leonard   586963 586963 Toller, Leonard, of Grantham, Lincs, tallow chandler 1
3773203 1949327 1949327 defendant Wilkynson John clerk 586963 586963 Wilkynson, John, of Grantham, Lincs, clerk 0
3773747 1949504 1949504 defendant Hall Francis merchant of the staple 586963 586963 Hall, Francis, of Grantham, Lincs, esq, merchant of the staple 0
3773752 1949505 1949505 defendant Hall Francis merchant of the staple 586963 586963 Hall, Francis, of Grantham, Lincs, esq, merchant of the staple 0
3784587 1952967 1952967 defendant Walcot Richard mercer 586963 586963 Walcot, Richard, of Grantham, Lincs, mercer 0
3784593 1952968 1952968 defendant Walcote Richard mercer 586963 586963 Walcote, Richard, of Grantham, Lincs, mercer 0
3786442 1953550 1953550 defendant Stephyn Robert husbandman 586963 586963 Stephyn, Robert, of Grantham, Lincs, husbandman 0
3788532 1954210 1954210 defendant Walker Richard mercer 586963 586963 Walker, Richard, of Grantham, Lincs, mercer 1
3788536 1954211 1954211 defendant Walker Richard mercer 586963 586963 Walker, Richard, of Grantham, Lincs, mercer 1
3818626 1963729 1963729 defendant Pyttys Thomas chaplain 586963 586963 Pyttys, Thomas, of Grantham, Lincs, chaplain 0
3825297 1965767 1965767 defendant Hall Francis esq 586963 586963 Hall, Francis, of Grantham, Lincs, esq 1
3838405 1969933 1969933 defendant Forth Richard mercer 586963 586963 Forth, Richard, of Grantham, Lincs, mercer 0
3839158 1970171 1970171 defendant Smyth William tailor 586963 586963 Smyth, William, of Grantham, Lincs, tailor 0
3869560 1980060 1980060 defendant Halle Elizabeth widow 586963 586963 (Halle, Elizabeth, of Grantham, Lincs, widow 1
3889138 1986603 1986603 defendant Leveret Henry mercer 586963 586963 Leveret, Henry, of Grantham, Lincs, mercer 1
3891665 1987467 1987467 defendant Rowland alias Rowlandson William chaplain 586963 586963 Rowland alias Rowlandson, William, of Grantham, Lincs, chaplain 0
3900814 1990502 1990502 defendant Fencott Hugh chapman 586963 586963 Fencott, Hugh, of Grantham, Lincs, chapman 1
3900818 1990503 1990503 defendant Fencott Hugh chapman 586963 586963 Fencott, Hugh, of Grantham, Lincs, chapman 1
3905608 1992145 1992145 defendant Tornes Francis mercer 586963 586963 Tornes, Francis, of Grantham, Lincs, mercer 0
3906134 1992342 1992342 defendant Rowland alias Rowlandson William chaplain 586963 586963 Rowland alias Rowlandson, William, of Grantham, Lincs, chaplain 0
3912534 1994522 1994522 defendant Thorneyff Francis mercer 586963 586963 Thorneyff, Francis, of Grantham, Lincs, mercer 0
3914220 1995102 1995102 defendant Leveret Henry mercer 586963 586963 Leveret, Henry, of Grantham, Lincs, mercer 0
3914225 1995103 1995103 defendant Leveret Henry mercer 586963 586963 Leveret, Henry, of Grantham, Lincs, mercer 0
3918786 1996610 1996610 defendant Allen John chapman 586963 586963 Allen, John, of Grantham, Lincs, chapman 0
3918804 1996614 1996614 defendant Leverett Henry chapman 586963 586963 Leverett, Henry, of Grantham, Lincs, chapman 0
3925417 1998814 1998814 defendant Leverett Henry mercer 586963 586963 Leverett, Henry, of Grantham, Lincs, mercer 4
3931913 2000975 2000975 defendant Wynge Thomas husbandman 586963 586963 Wynge, Thomas, of Grantham, Lincs, husbandman 4
3931948 2000984 2000984 defendant Oxley Thomas butcher 586963 586963 Oxley, Thomas, of Grantham, Lincs, butcher 0
3931950 2000984 2000984 defendant More William chapman 586963 586963 More, William, of Grantham, Lincs, chapman 2
3932111 2001044 2001044 defendant Marlowe Richard   586963 586963 Marlowe, Richard, of Grantham, Lincs, inn holder 1
3938778 2003309 2003309 plaintiff Rede William (legal representative) 586963 586963 Rede, William, of Grantham, Lincs, vicar, executors of 0
3939486 2003512 2003512 defendant Thorneff Francis gent 586963 586963 Thorneff, Francis, of Grantham, Lincs, gent 0
3944341 2005119 2005119 defendant Porter Augustine ironmonger 586963 586963 Porter, Augustine, of Grantham, Lincs, ironmonger 2
3945116 2005385 2005385 defendant Gentyll Robert chapman 586963 586963 Gentyll, Robert, of Grantham, Lincs, chapman 0
3945914 2005649 2005649 defendant Pecke William chapman 586963 586963 Pecke, William, of Grantham, Lincs, chapman 0
3951899 2007726 2007726 defendant Hope Hugh yeoman 586963 586963 Hope, Hugh, of Grantham, Lincs, yeoman 1
3951985 2007757 2007757 defendant Ryder Christopher yeoman 586963 586963 Ryder, Christopher, of Grantham, Lincs, yeoman 1
3951988 2007758 2007758 defendant Hall Robert yeoman 586963 586963 Hall, Robert, of Grantham, Lincs, or of Retforthe, yeoman 0
3956796 2009446 2009446 defendant Pecke William yeoman 586963 586963 Pecke, William, of Grantham, Lincs, yeoman 0
3956798 2009447 2009447 defendant Pecke William yeoman 586963 586963 Pecke, William, of Grantham, Lincs, yeoman 0
3973950 2015460 2015460 defendant Osland Richard innholder 586963 586963 Osland, Richard, of Grantham, Lincs, innholder 0
3975149 2015872 2015872 defendant More William   586963 586963 More, William, of Grantham, Lincs, tallow chandler 1
3977269 2016620 2016620 defendant Hope Henry innkeeper 586963 586963 Hope, Henry, of Grantham, Lincs, yeoman, innkeeper 0
3981803 2018249 2018249 defendant Porter William esq 586963 586963 Porter, William, of Grantham, Lincs, esq 0
4001221 2025215 2025215 defendant Porter William esq 586963 586963 Porter, William, of Grantham, Lincs, esq 0
4001222 2025216 2025216 plaintiff Hall Arthur esq 586963 586963 Hall, Arthur, of Grantham, Lincs, esq 0
4003538 2026028 2026028 defendant Porter William esq 586963 586963 Porter, William, of Grantham, Lincs, esq 0
4009129 2028031 2028031 defendant Kell Thomas baker 586963 586963 Kell, Thomas, of Grantham, Lincs, baker 0
4013204 2029454 2029454 defendant Porter William esq 586963 586963 Porter, William, of Grantham, Lincs, esq 0
4019432 2031682 2031682 defendant Porter William esq 586963 586963 Porter, William, of Grantham, Lincs, esq 1
4030791 2035677 2035677 defendant Porter William gent or esq 586963 586963 Porter, William, of Grantham, Lincs, gent or esq 0
4034129 2036868 2036868 defendant Hope Hugh innholder 586963 586963 Hope, Hugh, of Grantham, Lincs, innholder 0
4034216 2036905 2036905 defendant Hope Hugh innholder 586963 586963 Hope, Hugh, of Grantham, Lincs, innholder 0
4044972 2040658 2040658 defendant Bend Mathew chapman 586963 586963 Bend, Mathew, of Grantham, Lincs, chapman 0
4049398 2042229 2042229 defendant Hope Hugh innholder 586963 586963 Hope, Hugh, of Grantham, Lincs, innholder 0
4049400 2042230 2042230 defendant Jackson Gilbert butcher 586963 586963 Jackson, Gilbert, of Grantham, Lincs, butcher 0
4056724 2044790 2044790 defendant Hall Arthur esq 586963 586963 Hall, Arthur, of Grantham, Lincs, esq 0
4069152 2049260 2049260 defendant Oslande Richard innholder 586963 586963 Oslande, Richard, of Grantham, Lincs, innholder 0
4081705 2053759 2053759 defendant Oslande Richard innkeeper 586963 586963 Oslande, Richard, of Grantham, Lincs, innkeeper 0
4083656 2054428 2054428 defendant Allen John gent 586963 586963 Allen, John, of Grantham, Lincs, gent 0
4088796 2056294 2056294 defendant Camocke William cutler 586963 586963 Camocke, William, of Grantham, Lincs, cutler 3
4099030 2059979 2059979 defendant Abbott Richard glover 586963 586963 Abbott, Richard, of Grantham, Lincs, glover 0
4100739 2060583 2060583 defendant Cannocke William chapman 586963 586963 Cannocke, William, of Grantham, Lincs, chapman 6
4102031 2061035 2061035 defendant Porter William, senior gent 586963 586963 Porter, William, senior, of Grantham, Lincs, 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);