names

56 rows where place_id = 610564

✎ 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
3684162 1921181 1921181 defendant Johnson Thomas smith 610564 610564 Johnson, Thomas, of Newark on Trent, smith 0
3766033 1947042 1947042 plaintiff Lucas Richard gent 610564 610564 Lucas, Richard, of Newark on trent, gent 0
3772771 1949177 1949177 defendant Lucas Richard gent 610564 610564 Lucas, Richard, of Newark on Trent, gent 0
3813035 1961983 1961983 defendant Owen Hugh chaplain 610564 610564 Owen, Hugh, of Newark on Trent, chaplain 1
3875356 1982003 1982003 defendant Coke Richard butcher 610564 610564 Coke, Richard, of Newark on Trent, butcher 0
3875553 1982060 1982060 defendant Cooke Robert husbandman 610564 610564 Cooke, Robert, of Newark on Trent, husbandman 0
3875557 1982062 1982062 defendant Coke Robert husbandman 610564 610564 Coke, Robert, of Newark on Trent, husbandman 0
3875558 1982062 1982062 defendant Davyes William yeoman 610564 610564 Davyes, William, of Newark on Trent, yeoman 1
3901196 1990624 1990624 defendant Stafford Roger laborer 610564 610564 (Stafford, Roger, of Newark on Trent, laborer 4
3948064 2006390 2006390 plaintiff Cowton Thomas mercer 610564 610564 Cowton, Thomas, of Newark on Trent, mercer 0
3954779 2008739 2008739 defendant Key William glover 610564 610564 Key, William, of Newark on Trent, glover 0
3968690 2013685 2013685 defendant Spurre William baker 610564 610564 Spurre, William, of Newark on Trent, baker 5
3983673 2018930 2018930 defendant Symson Robert glover 610564 610564 Symson, Robert, of Newark on Trent, glover 0
3985490 2019574 2019574 defendant Leverton John yeoman 610564 610564 Leverton, John, of Newark on Trent, yeoman 1
4025053 2033621 2033621 defendant Lymyng Gavin laborer 610564 610564 Lymyng, Gavin, of Newark on Trent, laborer 0
4025055 2033622 2033622 defendant Lymyng Gawin laborer 610564 610564 Lymyng, Gawin, of Newark on Trent, laborer 0
4039705 2038812 2038812 defendant Foster Giles esq 610564 610564 Foster, Giles, of Newark on Trent, esq 0
4052385 2043275 2043275 defendant Parke William yeoman 610564 610564 Parke, William, of Newark on Trent, yeoman 0
4054880 2044136 2044136 plaintiff Bate Thomas dyer 610564 610564 Bate, Thomas, of Newark on Trent, dyer 0
4054882 2044137 2044137 plaintiff Bate Thomas dyer 610564 610564 Bate, Thomas, of Newark on Trent, dyer 0
4069140 2049255 2049255 defendant Harryson William vintner 610564 610564 Harryson, William, of Newark on Trent, vintner 0
4180814 2088767 2088767 defendant Noble William gent 610564 610564 Noble, William, of Newark on Trent, gent 0
4180815 2088767 2088767 defendant Ecoppe or Gooppe George yeoman 610564 610564 Ecoppe or Gooppe, George, of Newark on Trent, yeoman 1
4180817 2088768 2088768 defendant Ryall Thomas shoemaker 610564 610564 Ryall, Thomas, of Newark on Trent, shoemaker 0
4181700 2089081 2089081 defendant Lemynge Joan widow 610564 610564 Lemynge, Joan, of Newark on Trent, widow 1
4219748 2102411 2102411 defendant Ridearde Richard yeoman 610564 610564 Ridearde, Richard, of Newark on Trent, yeoman 1
4219749 2102411 2102411 defendant Leadman John yeoman 610564 610564 Leadman, John, of Newark on Trent, yeoman 2
4221819 2103128 2103128 defendant Wilson Brian tailor 610564 610564 Wilson, Brian, of Newark on Trent, tailor 0
4221820 2103128 2103128 defendant Ryall Thomas cordwainer 610564 610564 Ryall, Thomas, of Newark on Trent, cordwainer 1
4228240 2105359 2105359 defendant Hopton Reginald yeoman 610564 610564 Hopton, Reginald, of Newark on Trent, yeoman 0
4236728 2108419 2108419 defendant Hatchett Andrew yeoman 610564 610564 Hatchett, Andrew, of Newark on Trent, yeoman 1
4268025 2118923 2118923 defendant Bratherycke or Braderycke Edward yeoman 610564 610564 Bratherycke or Braderycke, Edward, of Newark on Trent, yeoman 2
4276938 2121865 2121865 defendant Lucas Brian esq 610564 610564 Lucas, Brian, of Newark on Trent, esq 0
4280235 2122992 2122992 defendant Ratcliff Edmund gent 610564 610564 Ratcliff, Edmund, of Newark on Trent, gent 0
4282185 2123670 2123670 defendant Lucas Brian esq 610564 610564 Lucas, Brian, of Newark on Trent, esq 0
4289171 2126183 2126183 plaintiff Newcombe Augustine yeoman 610564 610564 Newcombe, Augustine, of Newark on Trent, yeoman 0
4289172 2126183 2126183 plaintiff Leadman John yeoman 610564 610564 Leadman, John, of Newark on trent, yeoman 1
4295451 2128460 2128460 defendant Pye Stephen yeoman 610564 610564 Pye, Stephen, of Newark on Trent, yeoman 1
4299578 2129938 2129938 defendant Redeat or Reydeart Richard yeoman 610564 610564 Redeat or Reydeart, Richard, of Newark on Trent, yeoman 0
4299579 2129938 2129938 defendant Parishe William baker 610564 610564 Parishe, William, of Newark on Trent, baker 1
4299580 2129938 2129938 defendant Lednam John yeoman 610564 610564 Lednam, John, of Newark on Trent, yeoman 2
4302379 2130952 2130952 defendant Newcombe Augustine yeoman 610564 610564 Newcombe, Augustine, of Newark on Trent, yeoman 0
4313782 2134928 2134928 defendant Cook Anne widow 610564 610564 Cook, Anne, of Newark on Trent, widow 1
4315007 2135361 2135361 defendant Thwinge Marmaduke gent 610564 610564 Thwinge, Marmaduke, of Newark on Trent, or of Rottsey, yeoman,gent 0
4317198 2136127 2136127 defendant Houlston William innholder 610564 610564 Houlston, William, of Newark on Trent, innholder 0
4317203 2136129 2136129 defendant Houlston William innholder 610564 610564 Houlston, William, of Newark on Trent, innholder 0
4349365 2147041 2147041 defendant Hunton Robert tailor 610564 610564 Hunton, Robert, of Newark on Trent, tailor 0
4349368 2147042 2147042 defendant Wayte William yeoman 610564 610564 Wayte, William, of Newark on Trent, yeoman 0
4351904 2147905 2147905 defendant Noble John innholder 610564 610564 Noble, John, of Newark on Trent, innholder 0
4351905 2147905 2147905 defendant Keye Peter yeoman 610564 610564 Keye, Peter, of Newark on Trent, yeoman 1
4354029 2148636 2148636 defendant Rigeart Richard yeoman 610564 610564 Rigeart, Richard, of Newark on Trent, yeoman 0
4360381 2150878 2150878 defendant Haslam Anthony gent 610564 610564 Haslam, Anthony, of Newark on trent, gent 3
4371345 2154817 2154817 defendant Harrison William mercer 610564 610564 Harrison, William, of Newark on Trent, mercer 1
4379038 2157585 2157585 defendant Kydd George tailor 610564 610564 Kydd, George, of Newark on Trent, tailor 0
4382394 2158811 2158811 defendant Key Peter yeoman 610564 610564 Key, Peter, of Newark on Trent, yeoman 1
4396304 2163339 2163339 defendant Platt John shoemaker 610564 610564 Platt, John, of Newark on Trent, shoemaker 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);