names

65 rows where place_id = 593021

✎ 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
3610082 1870821 1870821 defendant Esmond William gent 593021 593021 Esmond, William, of Cossey, gent 0
3610083 1870821 1870821 defendant Esmond Margaret gentlewoman 593021 593021 Esmond, Margaret, of Cossey, gentlewoman 1
3610084 1870821 1870821 defendant Wastell Anne spinster 593021 593021 Wastell, Anne, of Cossey, spinster 2
3610086 1870822 1870822 defendant Esmond William gent 593021 593021 Esmond, William, of Cossey, gent 0
3610087 1870822 1870822 defendant Esmond Margaret gentlewoman 593021 593021 Esmond, Margaret, of Cossey, gentlewoman 1
3610088 1870822 1870822 defendant Wastell Anne spinster 593021 593021 Wastell, Anne, of Cossey, spinster 2
3620487 1873984 1873984 defendant Gunton Nicholas tailor 593021 593021 Gunton, Nicholas, of Cossey, tailor 2
3623840 1874985 1874985 defendant Whyte William yeoman 593021 593021 Whyte, William, of Cossey, yeoman 3
3660251 1913469 1913469 defendant Coche John yeoman 593021 593021 Coche, John, of Cossey, yeoman 0
3660252 1913469 1913469 defendant Smythe Reginald yeoman 593021 593021 Smythe, Reginald, of Cossey, yeoman 1
3660257 1913470 1913470 defendant Coche John yeoman 593021 593021 Coche, John, of Cossey, yeoman 0
3660258 1913470 1913470 defendant Smythe Reginald yeoman 593021 593021 Smythe, Reginald, of Cossey, yeoman 1
3719044 1932233 1932233 defendant Barne Nicholas hardwareman 593021 593021 Barne, Nicholas, of Cossey, hardwareman 0
3719047 1932234 1932234 defendant Barne Nicholas hardwareman 593021 593021 Barne, Nicholas, of Cossey, hardwareman 0
3750944 1942219 1942219 defendant Wyggys John   593021 593021 Wyggys, John, of Cossey, shepherd 0
3821066 1964482 1964482 defendant Wyggys John   593021 593021 Wyggys, John, of Cossey, shepherd 3
3825002 1965693 1965693 defendant Ampulforth William dyer 593021 593021 Ampulforth, William, of Cossey, dyer 1
3825858 1965937 1965937 defendant Collet Thomas husbandman 593021 593021 Collet, Thomas, of Cossey, husbandman 0
3831196 1967645 1967645 defendant Yarham John   593021 593021 Yarham, John, of Cossey, "heyerman" 3
3847831 1972897 1972897 defendant Lowe John husbandman 593021 593021 Lowe, John, of Cossey, husbandman 1
3862194 1977539 1977539 plaintiff Grey Robert yeoman 593021 593021 Grey, Robert, of Cossey, yeoman 0
3924641 1998555 1998555 defendant Baldwell Robert   593021 593021 Baldwell, Robert, of Cossey, shepherd 0
3924644 1998556 1998556 defendant Bladwell Robert   593021 593021 Bladwell, Robert, of Cossey, shepherd 0
3967908 2013403 2013403 defendant Claiborne Thomas clerk 593021 593021 Claiborne, Thomas, of Cossey, clerk 0
4016940 2030760 2030760 plaintiff Sylver John yeoman 593021 593021 Sylver, John, of Cossey, yeoman 0
4016942 2030761 2030761 plaintiff Sylver John yeoman 593021 593021 Sylver, John, of Cossey, yeoman 0
4063850 2047355 2047355 defendant Dawes John husbandman 593021 593021 Dawes, John, of Cossey, husbandman 0
4095882 2058860 2058860 defendant Jenkynson Oeter husbandman 593021 593021 Jenkynson, Oeter, of Cossey, husbandman 2
4105477 2062235 2062235 defendant Howse John husbandman 593021 593021 Howse, John, of Cossey, husbandman 2
4105478 2062235 2062235 defendant Pickeringe John shoemaker 593021 593021 Pickeringe, John, of Cossey, shoemaker 3
4115454 2065814 2065814 defendant Shelles Robert yeoman 593021 593021 Shelles, Robert, of Cossey, yeoman 0
4129253 2070762 2070762 defendant Fyssher Henry husbandman 593021 593021 Fyssher, Henry, of Cossey, husbandman 1
4141164 2075069 2075069 defendant Blacklocke Randolph singleman 593021 593021 Blacklocke, Randolph, of Cossey, yeoman, singleman 1
4172512 2085850 2085850 defendant Gooddey James yeoman 593021 593021 Gooddey, James, of Cossey, yeoman 1
4195731 2094063 2094063 defendant Goodd James yeoman 593021 593021 Goodd, James, of Cossey, yeoman 1
4227592 2105137 2105137 defendant Cotte Mary William, yeoman 593021 593021 Mary his wife;Jacobb, William, of Cossey, yeoman 2
4251027 2113322 2113322 defendant Andrewes Thomas husbandman 593021 593021 Andrewes, Thomas, of Cossey, husbandman 0
4256160 2115041 2115041 defendant Cooke Henry yeoman 593021 593021 Cooke, Henry, of Cossey, yeoman 0
4256161 2115041 2115041 defendant Bradfeld William tailor 593021 593021 Bradfeld, William, of Cossey, tailor 1
4256162 2115041 2115041 defendant Beades George miller 593021 593021 Beades, George, of Cossey, miller 2
4408742 2167520 2167520 defendant Fysher Henry yeoman 593021 593021 Fysher, Henry, of Cossey, yeoman 1
4631949 2240876 2240876 defendant Burgeys John   593021 593021 Burgeys, John, of Cossey 0
4643957 2244332 2244332 defendant Dyre John   593021 593021 Dyre, John, of Cossey 3
4645546 2244765 2244765 defendant Millere Richard   593021 593021 Millere, Richard, of Cossey 0
4659330 2248781 2248781 defendant Joweler John yeoman 593021 593021 Joweler, John, of Cossey, yeoman 5
4897861 2325992 2325992 defendant Esse John chapman 593021 593021 Esse, John, of Cossey, chapman 2
4935660 2337540 2337540 defendant Baxter Thomas husbandman 593021 593021 Baxter, Thomas, of Cossey, husbandman 0
5080486 2380655 2380655 plaintiff Coche Roger   593021 593021 Coche, Roger, of Cossey 0
5093044 2384355 2384355 defendant Newegate John yeoman 593021 593021 Newegate, John, of Cossey, yeoman 2
5151218 2401499 2401499 defendant Palmer William husbandman 593021 593021 Palmer, William, of Cossey, husbandman 0
5193193 2413739 2413739 plaintiff Palmer John   593021 593021 Palmer, John, of Cossey 0
5193228 2413749 2413749 plaintiff Palmere John   593021 593021 Palmere, John, of Cossey 0
5198445 2415302 2415302 defendant Wastell William husbandman 593021 593021 Wastell, William, of Cossey, husbandman 0
5273540 2437336 2437336 defendant Whyte William yeoman 593021 593021 Whyte, William, of Cossey, yeoman 0
5305974 2446774 2446774 plaintiff Palmer John   593021 593021 Palmer, John, of Cossey, bailiff 2
5332764 2454867 2454867 defendant Gunton Nicholas tailor 593021 593021 Gunton, Nicholas, of Cossey, tailor 1
5340721 2457298 2457298 plaintiff Paumer John   593021 593021 Paumer, John, of Cossey 0
5345032 2458606 2458606 plaintiff Palmer John   593021 593021 Palmer, John, of Cossey 2
5354910 2461610 2461610 defendant Coche Roger yeoman 593021 593021 Coche, Roger, of Cossey, yeoman 1
5354918 2461612 2461612 defendant Coche Roger yeoman 593021 593021 Coche, Roger, of Cossey, yeoman 1
5479167 2498791 2498791 defendant Whyte William yeoman 593021 593021 Whyte, William, of Cossey, yeoman 5
5495980 2503692 2503692 defendant Esmondys William gent 593021 593021 Esmondys, William, of Cossey, gent 0
5535114 2515511 2515511 defendant Pescode Robert   593021 593021 Pescode, Robert, of Cossey, hair maker, or of Norwich, holy water clerk 0
5536588 2515930 2515930 defendant Doket alias Cossey Robert tailor 593021 593021 Doket alias Cossey, Robert, of Cossey, tailor 1
5593668 2533005 2533005 defendant Wade John hyrmaker 593021 593021 Wade, John, of Cossey, hyrmaker 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);