names

57 rows where place_id = 588837

✎ 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
3595745 1866300 1866300 plaintiff Moston John scrivener 588837 588837 Moston, John, of Newarke, Notts, scrivener 1
3682980 1920790 1920790 defendant Fresby John chapman 588837 588837 Fresby, John, of Newarke, Notts, chapman 0
3698363 1925707 1925707 defendant Thomson Nicholas chandler 588837 588837 Thomson, Nicholas, of Newarke, Notts, chandler 0
3710987 1929750 1929750 defendant Halle John mercer 588837 588837 Halle, John, of Newarke, Notts, mercer 3
3710995 1929751 1929751 defendant Halle John mercer 588837 588837 Halle, John, of Newarke, Notts, mercer 3
3722137 1933186 1933186 defendant Clerke Thomas chapman 588837 588837 Clerke, Thomas, of Newarke, Notts, chapman 0
3740062 1938746 1938746 defendant Clarke Thomas mercer 588837 588837 Clarke, Thomas, of Newarke, Notts, mercer 1
3748028 1941304 1941304 plaintiff Frysby Thomas sherman 588837 588837 Frysby, Thomas, of Newarke, Notts, sherman 0
3774333 1949694 1949694 defendant Lucas Richard gent 588837 588837 Lucas, Richard, of Newarke, Notts, gent 0
3780402 1951605 1951605 plaintiff Garland George draper 588837 588837 Garland, George, of Newarke, Notts, draper 0
3802079 1958546 1958546 defendant Kneyfsmythe John yeoman 588837 588837 Kneyfsmythe, John, of Newarke, Notts, yeoman 0
3823046 1965116 1965116 defendant Crofton Thomas mercer 588837 588837 Crofton, Thomas, of Newarke, Notts, mercer 0
3837705 1969706 1969706 defendant Johnson William yeoman 588837 588837 Johnson, William, of Newarke, Notts, yeoman 0
3841404 1970893 1970893 defendant Thomson Nicholas ironmonger 588837 588837 Thomson, Nicholas, of Newarke, Notts, ironmonger 1
3841411 1970894 1970894 defendant Thomson Nicholas ironmonger 588837 588837 Thomson, Nicholas, of Newarke, Notts, ironmonger 1
3845839 1972253 1972253 plaintiff Fressbe Thomas   588837 588837 Fressbe, Thomas, of Newarke, Notts, sherman, administrators of 0
3865763 1978775 1978775 defendant Clark Thomas vintner 588837 588837 Clark, Thomas, of Newarke, Notts, vintner 1
3893927 1988192 1988192 defendant Proctour Nicholas gent 588837 588837 Proctour, Nicholas, of Newarke, Notts, gent 0
3896460 1989021 1989021 defendant Lucas Richard gent 588837 588837 Lucas, Richard, of Newarke, Notts, gent 0
3927952 1999686 1999686 defendant Hopkynson Henry gent 588837 588837 Hopkynson, Henry, of Newarke, Notts, gent 0
3942953 2004649 2004649 defendant Burkett Hugh   588837 588837 Burkett, Hugh, of Newarke, Notts, cord wainer 0
3949212 2006793 2006793 defendant Cowton Thomas chapman 588837 588837 Cowton, Thomas, of Newarke, Notts, chapman 0
3953891 2008431 2008431 defendant Garnet Miles butcher 588837 588837 Garnet, Miles, of Newarke, Notts, butcher 1
3959549 2010431 2010431 defendant Stanley William yeoman 588837 588837 (Stanley, William, of Newarke, Notts, yeoman 1
3964606 2012225 2012225 defendant Foster Giles gent 588837 588837 Foster, Giles, of Newarke, Notts, gent 0
3976263 2016265 2016265 defendant Waytte Henry draper 588837 588837 Waytte, Henry, of Newarke, Notts, draper 0
3976532 2016367 2016367 plaintiff Key John yeoman 588837 588837 Key, John, of Newarke, Notts, yeoman 0
4006809 2027214 2027214 defendant Crokes John yeoman or innholder 588837 588837 Crokes, John, of Newarke, Notts, yeoman or innholder 0
4006811 2027215 2027215 defendant Crokes John yeoman or innholder 588837 588837 Crokes, John, of Newarke, Notts, yeoman or innholder 0
4006813 2027216 2027216 defendant Crokes John innholder 588837 588837 Crokes, John, of Newarke, Notts, yeoman, innholder 0
4015307 2030169 2030169 defendant Kelsterne John merchant of the staple 588837 588837 Kelsterne, John, of Newarke, Notts, merchant of the staple 0
4069949 2049535 2049535 defendant Bachelay Henry glover 588837 588837 Bachelay, Henry, of Newarke, Notts, glover 0
4072342 2050410 2050410 plaintiff Osell John   588837 588837 Osell, John, of Newarke, Notts 0
4097518 2059440 2059440 defendant Pyndar Thomas chapman 588837 588837 Pyndar, Thomas, of Newarke, Notts, chapman 0
4124403 2069021 2069021 defendant Tomlunson Richard chapman 588837 588837 Tomlunson, Richard, of Newarke, Notts, chapman 1
4202900 2096559 2096559 defendant Forgam Thomas chapman 588837 588837 Forgam, Thomas, of Newarke, Notts, chapman 0
4216543 2101279 2101279 defendant Slynheade Henry sherman 588837 588837 Slynheade, Henry, of Newarke, Notts, sherman 0
4218838 2102083 2102083 defendant Thwinge Marmaduke gent 588837 588837 Thwinge, Marmaduke, of Newarke, Notts, or of Rotsey, Huton Cranswicke, Yorks, gent 1
4233054 2107069 2107069 defendant Leadnam John yeoman 588837 588837 Leadnam, John, of Newarke, Notts, yeoman 0
4252777 2113917 2113917 defendant Slynheade Henry sherman 588837 588837 Slynheade, Henry, of Newarke, Notts, sherman 0
4256652 2115195 2115195 defendant Thwinge Marmaduke gent 588837 588837 Thwinge, Marmaduke, of Newarke, Notts, or of Rottesey, Huton Cranswicke, Yorks, gent 1
4269830 2119500 2119500 defendant Doughtie Thomas gent 588837 588837 Doughtie, Thomas, of Newarke, Notts, gent 0
4277389 2122013 2122013 defendant Kelsterne Hugh innkeeper 588837 588837 Kelsterne, Hugh, of Newarke, Notts, innkeeper 0
4277392 2122014 2122014 defendant Howson William vintner 588837 588837 Howson, William, of Newarke, Notts, vintner 0
4292100 2127248 2127248 defendant Feildesend Charles yeoman 588837 588837 Feildesend, Charles, of Newarke, Notts, yeoman 2
4350746 2147513 2147513 defendant Harrison William mercer 588837 588837 Harrison, William, of Newarke, Notts, mercer 3
4371997 2155047 2155047 defendant Parke George vintner 588837 588837 Parke, George, of Newarke, Notts, vintner 1
5016553 2361736 2361736 defendant Clapull John fissher 588837 588837 Clapull, John, of Newarke, Notts, fissher 0
5018965 2362438 2362438 defendant Oversall or Overfall Richard yeoman 588837 588837 Oversall or Overfall, Richard, of Newarke, Notts, yeoman 2
5019050 2362463 2362463 defendant Oversall or Overfall Richard yeoman 588837 588837 Oversall or Overfall, Richard, of Newarke, Notts, yeoman 2
5043144 2369567 2369567 defendant Heseham Katherine widow 588837 588837 Heseham, Katherine, of Newarke, Notts, widow 0
5213272 2419615 2419615 defendant Baynbrygge Thomas chaplain 588837 588837 Baynbrygge, Thomas, of Newarke, Notts, chaplain 4
5352807 2460964 2460964 defendant Faukener Henry draper or innholder 588837 588837 Faukener, Henry, of Newarke, Notts, draper or innholder 0
5408523 2477514 2477514 defendant Hund Andrew innholder 588837 588837 Hund, Andrew, of Newarke, Notts, innholder 1
5501560 2505419 2505419 defendant Calcrofte Ralph merchant 588837 588837 Calcrofte, Ralph, of Newarke, Notts, merchant 1
5563406 2523896 2523896 defendant Kyrkby William panier maker 588837 588837 Kyrkby, William, of Newarke, Notts, panier maker 3
5597856 2534228 2534228 defendant Broune Robert merchant 588837 588837 Broune, Robert, of Newarke, Notts, gent, merchant 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);