names

66 rows where place_id = 630387

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3794082 1956014 1956014 defendant Marshall John gent 630387 630387 Marshall, John, of Newarke on Trent, Notts, gent 0
3794084 1956015 1956015 defendant Marshall John gent 630387 630387 Marshall, John, of Newarke on Trent, Notts, gent 0
3825745 1965902 1965902 defendant Kelstern Hugh draper 630387 630387 Kelstern, Hugh, of Newarke on Trent, Notts, draper 0
3825763 1965905 1965905 defendant Kelstern Hugh draper 630387 630387 Kelstern, Hugh, of Newarke on Trent, Notts, draper 0
3838061 1969818 1969818 defendant Lucas Richard gent 630387 630387 Lucas, Richard, of Newarke on Trent, Notts, gent 0
3840133 1970486 1970486 defendant Kelstren Hugh draper 630387 630387 Kelstren, Hugh, of Newarke on Trent, Notts, draper 0
3842938 1971325 1971325 defendant Marshall John merchant of the staple 630387 630387 Marshall, John, of Newarke on Trent, Notts, gent, merchant of the staple 2
3875492 1982045 1982045 defendant Cade Elizabeth widow 630387 630387 Cade, Elizabeth, of Newarke on Trent, Notts, widow 0
3890773 1987181 1987181 defendant Croxton Thomas upholsterer 630387 630387 Croxton, Thomas, of Newarke on Trent, Notts, upholsterer 1
3914915 1995337 1995337 defendant FitzWilliam Francis gent 630387 630387 FitzWilliam, Francis, of Newarke on trent, Notts, gent 0
3949789 2007002 2007002 defendant Foster Giles gent 630387 630387 Foster, Giles, of Newarke on Trent, Notts, gent 0
3951219 2007496 2007496 defendant (not given) Edward vicar of Rodes 630387 630387 Rodes, Edward, of Newarke on Trent, Notts, vicar of Chiltron Mary, Wilts 0
3956400 2009301 2009301 defendant Forster Giles esq 630387 630387 Forster, Giles, of Newarke on Trent, Notts, esq 0
3968285 2013536 2013536 defendant Forster Giles esq 630387 630387 Forster, Giles, of Newarke on Trent, Notts, esq 0
3968288 2013537 2013537 defendant Forster Giles esq 630387 630387 Forster, Giles, of Newarke on Trent, Notts, esq 0
3968682 2013684 2013684 defendant Chapman Mathew baker 630387 630387 Chapman, Mathew, of Newarke on Trent, Notts, baker 3
3972562 2014982 2014982 defendant Keye John ironmonger 630387 630387 Keye, John, of Newarke on Trent, Notts, ironmonger 0
3984776 2019312 2019312 defendant Deathe John chapman 630387 630387 Deathe, John, of Newarke on Trent, Notts, chapman 0
3990396 2021320 2021320 defendant Leverton John merchant 630387 630387 Leverton, John, of Newarke on Trent, Notts, merchant 0
4012658 2029250 2029250 defendant Foster Thomas gent 630387 630387 Foster, Thomas, of Newarke on Trent, Notts, gent 1
4031993 2036109 2036109 defendant Leverton John yeoman or chapman 630387 630387 Leverton, John, of Newarke on Trent, Notts, yeoman or chapman 0
4033282 2036558 2036558 defendant Stose Christopher fishmonger 630387 630387 Stose, Christopher, of Newarke on Trent, Notts, fishmonger 1
4049155 2042145 2042145 defendant Parke William gent 630387 630387 Parke, William, of Newarke on Trent, Notts, gent 0
4055171 2044242 2044242 defendant Kelsterne John merchant of the staple 630387 630387 Kelsterne, John, of Newarke on Trent, Notts, merchant of the staple 0
4072021 2050291 2050291 defendant Pynder Thomas mercer 630387 630387 Pynder, Thomas, of Newarke on Trent, Notts, mercer 0
4090517 2056890 2056890 defendant Bradshawe Bartholomew yeoman 630387 630387 Bradshawe, Bartholomew, of Newarke on Trent, Notts, yeoman 0
4119424 2067240 2067240 defendant Cunstable George gent 630387 630387 Cunstable, George, of Newarke on Trent, Notts, gent 2
4122779 2068438 2068438 defendant Molyneux Edmund gent 630387 630387 Molyneux, Edmund, of Newarke on Trent, Notts, or of London, gent 0
4133021 2072139 2072139 defendant Hapton Reginald yeoman 630387 630387 Hapton, Reginald, of Newarke on Trent, Notts, yeoman 0
4142394 2075512 2075512 defendant Custable George gent 630387 630387 Custable, George, of Newarke on Trent, Notts, gent 2
4184471 2090077 2090077 defendant Willson James mercer 630387 630387 Willson, James, of Newarke on Trent, Notts, mercer 0
4185810 2090532 2090532 defendant Wilson James chapman 630387 630387 Wilson, James, of Newarke on Trent, Notts, chapman 0
4196075 2094178 2094178 defendant Smythe John yeoman 630387 630387 Smythe, John, of Newarke on Trent, Notts, yeoman 0
4210344 2099174 2099174 defendant Kelsterne Edward   630387 630387 Kelsterne, Edward, of Newarke on Trent, Notts, woollen draper 0
4216772 2101362 2101362 defendant Brathericke Edward yeoman 630387 630387 Brathericke, Edward, of Newarke on Trent, Notts, yeoman 0
4217163 2101496 2101496 defendant Allexander George yeoman 630387 630387 Allexander, George, of Newarke on Trent, Notts, yeoman 0
4222259 2103276 2103276 defendant Fletcher Francis gent 630387 630387 Fletcher, Francis, of Newarke on Trent, Notts, gent 0
4224029 2103889 2103889 defendant Harrison William gent 630387 630387 Harrison, William, of Newarke on Trent, Notts, gent 0
4226371 2104697 2104697 defendant Gresbroke or Greysbroughe Ralph butcher 630387 630387 Gresbroke or Greysbroughe, Ralph, of Newarke on Trent, Notts, butcher 0
4230559 2106183 2106183 defendant Tubbe Robert tailor 630387 630387 Tubbe, Robert, of Newarke on Trent, Notts, tailor 0
4234357 2107553 2107553 defendant Bratherike Edward yeoman 630387 630387 Bratherike, Edward, of Newarke on Trent, Notts, yeoman 0
4239405 2109401 2109401 defendant Huttofte Richard gent 630387 630387 Huttofte, Richard, of Newarke on Trent, Notts, gent 0
4239433 2109413 2109413 defendant Fletcher Francis gent 630387 630387 Fletcher, Francis, of Newarke on Trent, Notts, gent 0
4243402 2110785 2110785 defendant Alexander George yeoman 630387 630387 Alexander, George, of Newarke on Trent, Notts, yeoman 0
4243405 2110786 2110786 defendant Burton John gent 630387 630387 Burton, John, of Newarke on Trent, Notts, gent 0
4244387 2111098 2111098 defendant Harryson William chapman 630387 630387 Harryson, William, of Newarke on Trent, Notts, chapman 0
4260925 2116616 2116616 defendant Taylor Thomas draper 630387 630387 Taylor, Thomas, of Newarke on Trent, Notts, draper 1
4269163 2119281 2119281 defendant Noble William gent 630387 630387 Noble, William, of Newarke on Trent, Notts, gent 0
4270049 2119562 2119562 defendant Harrison William gent 630387 630387 Harrison, William, of Newarke on Trent, Notts, gent 2
4285017 2124690 2124690 defendant Newcombe Augustine yeoman 630387 630387 Newcombe, Augustine, of Newarke on Trent, Notts, yeoman 0
4298591 2129603 2129603 defendant Brathericke Edward yeoman 630387 630387 Brathericke, Edward, of Newarke on Trent, Notts, yeoman 0
4305834 2132178 2132178 defendant Wylkynson John   630387 630387 Wylkynson, John, of Newarke on Trent, Notts 0
4311976 2134324 2134324 defendant Holland John vintner 630387 630387 Holland, John, of Newarke on Trent, Notts, vintner 0
4315009 2135362 2135362 defendant Thwinge Marmaduke gent 630387 630387 Thwinge, Marmaduke, of Newarke on Trent, Notts, or of Rottsey, Yorks, gent 0
4339299 2143511 2143511 defendant Newcombe Augustine yeoman 630387 630387 Newcombe, Augustine, of Newarke on Trent, Notts, yeoman 0
4343588 2145037 2145037 defendant Parke George vintner 630387 630387 Parke, George, of Newarke on Trent, Notts, vintner 0
4351471 2147764 2147764 defendant Houlson William innholder 630387 630387 Houlson, William, of Newarke on Trent, Notts, innholder 1
4358194 2150099 2150099 defendant Tonge Nicholas gent 630387 630387 Tonge, Nicholas, of Newarke on Trent, Notts, gent 2
4361350 2151221 2151221 defendant Burton John gent 630387 630387 Burton, John, of Newarke on Trent, Notts, gent 0
4367936 2153582 2153582 defendant Otes Luke gent 630387 630387 Otes, Luke, of Newarke on Trent, Notts, gent 0
4369082 2154008 2154008 defendant Stanley William draper 630387 630387 Stanley, William, of Newarke on Trent, Notts, draper 0
4372776 2155339 2155339 defendant Brigges Edward draper 630387 630387 Brigges, Edward, of Newarke on Trent, Notts, draper 0
4373796 2155695 2155695 defendant Kelsterne Hugh innholder 630387 630387 Kelsterne, Hugh, of Newarke on Trent, Notts, innholder 0
4380777 2158238 2158238 defendant Lenton Hugh yeoman 630387 630387 Lenton, Hugh, of Newarke on Trent, Notts, yeoman 0
4388305 2160718 2160718 defendant Parke George vintner 630387 630387 Parke, George, of Newarke on Trent, Notts, vintner 0
4389355 2161066 2161066 defendant Lailson Lawrence yeoman 630387 630387 Lailson, Lawrence, of Newarke on Trent, Notts, yeoman 3

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