names

74 rows where place_id = 588098

✎ 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
3593360 1865557 1865557 defendant Shawe John yeoman 588098 588098 Shawe, John, of Newark, Notts, yeoman 1
3593366 1865558 1865558 defendant Shawe John yeoman 588098 588098 Shawe, John, of Newark, Notts, yeoman 1
3603666 1868815 1868815 defendant Ballyngar Thomas roper 588098 588098 Ballyngar, Thomas, of Newark, Notts, roper 0
3608140 1870198 1870198 defendant Calcrofte Ralph gent 588098 588098 Calcrofte, Ralph, of Newark, Notts, gent 0
3613731 1871945 1871945 defendant Lewys David yeoman 588098 588098 Lewys, David, of Newark, Notts, yeoman 0
3624979 1875343 1875343 defendant Scotte John barker 588098 588098 Scotte, John, of Newark, Notts, barker 0
3697194 1925343 1925343 defendant Jakson Andrew mercer 588098 588098 Jakson, Andrew, of Newark, Notts, mercer 0
3708341 1928904 1928904 defendant Lucas Richard gent 588098 588098 Lucas, Richard, of Newark, Notts, gent 0
3719416 1932349 1932349 defendant Sampson John (legal representative) 588098 588098 Sampson, John, of Newark, Notts, draper, executor of 0
3722916 1933432 1933432 defendant Lucas Richard gent 588098 588098 Lucas, Richard, of Newark, Notts, gent 0
3731270 1936006 1936006 defendant Uthwyt William butcher 588098 588098 Uthwyt, William, of Newark, Notts, butcher 0
3747729 1941210 1941210 defendant Freesbe Thomas yeoman 588098 588098 Freesbe, Thomas, of Newark, Notts, yeoman 0
3754417 1943339 1943339 plaintiff Thompson Nicholas fishmonger 588098 588098 Thompson, Nicholas, of Newark, Notts, fishmonger 0
3771917 1948909 1948909 defendant Lucas Richard gent 588098 588098 Lucas, Richard, of Newark, Notts, gent 0
3774433 1949728 1949728 defendant Kechyn Richard glover 588098 588098 Kechyn, Richard, of Newark, Notts, glover 0
3818054 1963559 1963559 plaintiff Lucas Richard gent 588098 588098 Lucas, Richard, of Newark, Notts, gent 0
3888374 1986373 1986373 defendant Bellamy Thomas chapman 588098 588098 Bellamy, Thomas, of Newark, Notts, chapman 0
3889053 1986578 1986578 plaintiff Freysby Thomas   588098 588098 Freysby, Thomas, of Newark, Notts, sherman, administrators of 0
3948662 2006593 2006593 defendant Herynge William yeoman 588098 588098 Herynge, William, of Newark, Notts, yeoman 0
3974951 2015805 2015805 defendant Leverton John chapman 588098 588098 Leverton, John, of Newark, Notts, chapman 0
4387424 2160438 2160438 defendant Howson William vintner 588098 588098 Howson, William, of Newark, Notts, gent, vintner 0
4399966 2164577 2164577 defendant Hunston Henry gent 588098 588098 Hunston, Henry, of Newark, Notts, gent 0
4658625 2248573 2248573 defendant Holm Robert woolman 588098 588098 Holm, Robert, of Newark, Notts, woolman 3
4674969 2257780 2257780 defendant Trussebutte John gent 588098 588098 Trussebutte, John, of Newark, Notts, gent 0
4703775 2266560 2266560 defendant Baunebury John clerk 588098 588098 Baunebury, John, of Newark, Notts, clerk 4
4710683 2268699 2268699 defendant Padley John chapman 588098 588098 Padley, John, of Newark, Notts, chapman 2
4717198 2270709 2270709 defendant Lake John taverner 588098 588098 Lake, John, of Newark, Notts, taverner 1
4740277 2277667 2277667 defendant Tukkeksworth John dyer 588098 588098 Tukkeksworth, John, of Newark, Notts, dyer 1
4766289 2285449 2285449 defendant Barbour William   588098 588098 Barbour, William, of Newark, Notts, leach 1
4792138 2293640 2293640 defendant Roby Roger laborer 588098 588098 Roby, Roger, of Newark, Notts, laborer 1
4811916 2299842 2299842 defendant Lytster Richard dyer 588098 588098 Lytster, Richard, of Newark, Notts, dyer 0
4815944 2301078 2301078 defendant Bolton Richard merchant 588098 588098 Bolton, Richard, of Newark, Notts, merchant 0
4828859 2305062 2305062 defendant Bawdewyn John walker 588098 588098 Bawdewyn, John, of Newark, Notts, walker 2
4831021 2305730 2305730 defendant Marston John gent 588098 588098 Marston, John, of Newark, Notts, gent 0
4832171 2306091 2306091 defendant Bawdewyn John walker 588098 588098 Bawdewyn, John, of Newark, Notts, walker 2
4848241 2310923 2310923 defendant Brandon John chapman 588098 588098 Brandon, John, of Newark, Notts, chapman 0
4881960 2321256 2321256 defendant Topclyf Walter merchant 588098 588098 Topclyf, Walter, of Newark, Notts, merchant 0
4914536 2331068 2331068 defendant Ramsey John yeoman 588098 588098 Ramsey, John, of Newark, Notts, yeoman 0
4936168 2337712 2337712 plaintiff Boney or Bouey Walter ostler 588098 588098 Boney or Bouey, Walter, of Newark, Notts, ostler 0
4961879 2345505 2345505 defendant Rigge Oliver slater 588098 588098 Rigge, Oliver, of Newark, Notts, slater 0
4961881 2345506 2345506 defendant Rygge Oliver slater 588098 588098 Rygge, Oliver, of Newark, Notts, slater 0
4973651 2349071 2349071 defendant Ferrour or Smith William smith 588098 588098 Ferrour or Smith, William, of Newark, Notts, smith 0
5040693 2368828 2368828 defendant Rynghale John chapman 588098 588098 Rynghale, John, of Newark, Notts, chapman 2
5082835 2381372 2381372 defendant Beynbryngge John chaplain 588098 588098 Beynbryngge, John, of Newark, Notts, chaplain 1
5084870 2381980 2381980 defendant Faldyngton alias Wryght John laborer 588098 588098 Faldyngton alias Wryght, John, of Newark, Notts, laborer 1
5121027 2392579 2392579 defendant Yates Thomas   588098 588098 Yates, Thomas, of Newark, Notts 0
5122405 2392981 2392981 defendant Esyngwold John gent 588098 588098 Esyngwold, John, of Newark, Notts, gent 1
5122408 2392982 2392982 defendant Esyngwold John gent 588098 588098 Esyngwold, John, of Newark, Notts, gent 1
5216375 2420527 2420527 defendant Atkynson John hapman 588098 588098 Atkynson, John, of Newark, Notts, hapman 1
5241498 2427712 2427712 defendant Sutheby John smith 588098 588098 Sutheby, John, of Newark, Notts, smith 0
5242040 2427877 2427877 defendant Benet John mercer or court holder 588098 588098 Benet, John, of Newark, Notts, mercer or court holder 1
5243017 2428161 2428161 defendant Marneham Walter shipmaker 588098 588098 Marneham, Walter, of Newark, Notts, shipmaker 0
5244249 2428506 2428506 defendant Brown William tailor 588098 588098 Brown, William, of Newark, Notts, tailor 0
5276620 2438241 2438241 defendant Denyas Thomas gent 588098 588098 Denyas, Thomas, of Newark, Notts, gent 0
5295706 2443739 2443739 defendant Wakefeld Thomas esq 588098 588098 Wakefeld, Thomas, of Newark, Notts, esq 0
5372643 2467041 2467041 defendant Kaysar Nicholas yeoman 588098 588098 Kaysar, Nicholas, of Newark, Notts, yeoman 1
5379066 2469047 2469047 defendant Dunham William merchant 588098 588098 Dunham, William, of Newark, Notts, merchant 0
5428855 2483545 2483545 defendant Denyas John gent 588098 588098 Denyas, John, of Newark, Notts, gent 0
5483996 2500147 2500147 defendant Wythes Thomas butcher 588098 588098 Wythes, Thomas, of Newark, Notts, butcher 0
5497028 2504045 2504045 defendant Meryng Thomas esq 588098 588098 Meryng, Thomas, of Newark, Notts, esq 1
5508055 2507413 2507413 defendant Meryng Thomas esq 588098 588098 (Meryng, Thomas, of Newark, Notts, esq 3
5520865 2511346 2511346 defendant Car Henry yeoman 588098 588098 Car, Henry, of Newark, Notts, yeoman 0
5521414 2511512 2511512 defendant Walren William innholder 588098 588098 Walren, William, of Newark, Notts, innholder 2
5521422 2511515 2511515 defendant Walren William innholder 588098 588098 Walren, William, of Newark, Notts, innholder 0
5553293 2521000 2521000 defendant Wolhouse alias Lytster John dyer 588098 588098 Wolhouse alias Lytster, John, of Newark, Notts, dyer 0
5558088 2522319 2522319 defendant Phillipot John merchant 588098 588098 Phillipot, John, of Newark, Notts, merchant 3
5558093 2522320 2522320 defendant Phillipot John merchant 588098 588098 Phillipot, John, of Newark, Notts, merchant 3
5596243 2533740 2533740 defendant Turton William chaplain 588098 588098 Turton, William, of Newark, Notts, chaplain 3
5596259 2533744 2533744 defendant Grenegate John yeoman 588098 588098 Grenegate, John,of Newark, Notts, yeoman 0
5597918 2534252 2534252 defendant Slater Robert yeoman 588098 588098 Slater, Robert, of Newark, Notts, yeoman 0
5598698 2534468 2534468 defendant Dawes John draper 588098 588098 Dawes, John, of Newark, Notts, draper 0
5630147 2553430 2553430 defendant Webster William dyer 588098 588098 Webster, William, of Newark, Notts, dyer 0
5632900 2554296 2554296 defendant Cokyrham John spicer 588098 588098 Cokyrham, John, of Newark, Notts, spicer 3
5636025 2555224 2555224 defendant Laake John taverner 588098 588098 Laake, John, of Newark, Notts, taverner 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);