names

48 rows where place_id = 595049

✎ 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
3618670 1873466 1873466 defendant Wagstafe Nicholas tailor 595049 595049 Wagstafe, Nicholas, of Bemyster, tailor 1
3736012 1937504 1937504 defendant Hytte Thomas tailor 595049 595049 Hytte, Thomas, of Bemyster, tailor 1
3736294 1937591 1937591 defendant Danyell John husbandman 595049 595049 Danyell, John, of Bemyster, husbandman 0
3754654 1943412 1943412 defendant Strode William gent 595049 595049 Strode, William, of Bemyster, gent 0
3772049 1948947 1948947 defendant Strode William gent 595049 595049 Strode, William, of Bemyster, gent 0
3908889 1993267 1993267 defendant Mynterne Richard husbandman 595049 595049 Mynterne, Richard, of Bemyster, husbandman 0
3923774 1998256 1998256 defendant Morgan Alexander husbandman 595049 595049 Morgan, Alexander, of Bemyster, husbandman 0
3994379 2022743 2022743 defendant Grave or Grove Henry chapman 595049 595049 Grave or Grove, Henry, of Bemyster, chapman 0
4035054 2037220 2037220 defendant Cheke Richard mercer 595049 595049 Cheke, Richard, of Bemyster, mercer 1
4035058 2037221 2037221 defendant Cheke Richard mercer 595049 595049 Cheke, Richard, of Bemyster, mercer 1
4041026 2039282 2039282 defendant Cheke Richard merchant 595049 595049 Cheke, Richard, of Bemyster, merchant 1
4041031 2039283 2039283 defendant Cheke Richard   595049 595049 Cheke, Richard, of Bemyster 1
4061362 2046466 2046466 defendant Gyllett John husbandman 595049 595049 Gyllett, John, of Bemyster, husbandman 1
4068821 2049138 2049138 defendant Gyllett John husbandman 595049 595049 Gyllett, John, of Bemyster, husbandman 0
4095046 2058556 2058556 defendant Colborne Joan widow 595049 595049 Colborne, Joan, of Bemyster, widow 0
4095047 2058556 2058556 defendant Stowell John shoemaker 595049 595049 Stowell, John, of Bemyster, shoemaker 1
4124015 2068889 2068889 defendant Wynterhay Lawrence gent 595049 595049 Wynterhay, Lawrence, of Bemyster, gent 0
4148731 2077681 2077681 defendant Radbarde leonard husbandman 595049 595049 Radbarde, leonard, of Bemyster, husbandman 0
4156706 2080424 2080424 defendant Garrett John roper 595049 595049 Garrett, John, of Bemyster, roper 0
4792843 2293851 2293851 defendant Smyth Robert smith 595049 595049 Smyth, Robert, of Bemyster, smith 2
4792845 2293851 2293851 defendant Stampe Nicholas husbandman 595049 595049 Stampe, Nicholas, of Bemyster, husbandman 4
4853750 2312586 2312586 defendant Forde William husbandman 595049 595049 Forde, William, of Bemyster, husbandman 0
4853751 2312586 2312586 defendant Meryman John husbandman 595049 595049 Meryman, John, of Bemyster, husbandman 1
4859007 2314196 2314196 defendant Smyth Robert smith 595049 595049 Smyth, Robert, of Bemyster, smith 3
4918250 2332228 2332228 defendant Carswille William   595049 595049 Carswille, William, of Bemyster, rope maker 0
5139512 2398042 2398042 defendant Bargh William gent 595049 595049 Bargh, William, of Bemyster, gent 0
5175279 2408462 2408462 defendant Bargh William gent 595049 595049 Bargh, William, of Bemyster, gent 0
5196364 2414688 2414688 defendant Bargh William gent 595049 595049 Bargh, William, of Bemyster, gent 0
5209639 2418558 2418558 defendant Bargh William gent 595049 595049 Bargh, William, of Bemyster, gent 0
5231085 2424689 2424689 defendant Dounton John husbandman 595049 595049 Dounton, John, of Bemyster, husbandman 0
5231086 2424689 2424689 defendant Dounton Richard husbandman 595049 595049 Dounton, Richard, of Bemyster, husbandman 1
5231087 2424689 2424689 defendant Lucy Thomas yeoman 595049 595049 Lucy, Thomas, of Bemyster, yeoman 2
5231088 2424689 2424689 defendant Dounton William husbandman 595049 595049 Dounton, William, of Bemyster, husbandman 3
5231089 2424689 2424689 defendant Purchache Peter husbandman 595049 595049 Purchache, Peter, of Bemyster, husbandman 4
5233835 2425481 2425481 defendant Dounton John yeoman 595049 595049 Dounton, John, of Bemyster, yeoman 1
5281264 2439596 2439596 defendant Dounton William butcher 595049 595049 Dounton, William, of Bemyster, butcher 0
5281265 2439596 2439596 defendant Draper John butcher 595049 595049 Draper, John, of Bemyster, butcher 1
5281266 2439596 2439596 defendant Dounton John butcher 595049 595049 Dounton, John, of Bemyster, butcher 2
5310155 2448069 2448069 defendant Hille John yeoman 595049 595049 Hille, John, of Bemyster, yeoman 0
5335874 2455797 2455797 defendant (not given) John vicar of Fryngon 595049 595049 Fryngon, John, of Bemyster, clerk, vicar of Haytor, Devon 0
5368903 2465863 2465863 defendant Fryton John clerk 595049 595049 Fryton, John, of Bemyster, clerk 0
5368906 2465864 2465864 defendant Fryton John clerk 595049 595049 Fryton, John, of Bemyster, clerk 0
5421001 2481210 2481210 defendant Chylde Thomas yeoman 595049 595049 Chylde, Thomas, of Bemyster, yeoman 2
5484510 2500287 2500287 defendant Chalmer William chapman 595049 595049 Chalmer, William, of Bemyster, chapman 0
5541295 2517393 2517393 defendant Byllyng John fisher 595049 595049 Byllyng, John, of Bemyster, fisher 0
5541296 2517393 2517393 defendant Benet Hames baker 595049 595049 Benet, Hames, of Bemyster, baker 1
5567194 2524983 2524983 defendant Danyell John butcher 595049 595049 Danyell, John, of Bemyster, butcher 2
5567200 2524984 2524984 defendant Norfolke John mercer 595049 595049 Norfolke, John, of Bemyster, mercer 2

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