names

146 rows where place_id = 602132

✎ 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
3648591 1909950 1909950 defendant Kent John husbandman 602132 602132 Kent, John, of Cawston, husbandman 1
3713507 1930536 1930536 defendant Porter John chapman 602132 602132 Porter, John, of Cawston, chapman 0
3773413 1949395 1949395 defendant Horne William smith 602132 602132 Horne, William, of Cawston, smith 0
3821887 1964736 1964736 plaintiff Skynner Robert baker 602132 602132 Skynner, Robert, of Cawston, baker 0
3821889 1964737 1964737 plaintiff Skynner Robert baker 602132 602132 Skynner, Robert, of Cawston, baker 0
3830138 1967325 1967325 defendant Ryngsted Nicholas coalmaker 602132 602132 Ryngsted, Nicholas, of Cawston, coalmaker 1
3838901 1970092 1970092 defendant Blome William husbandman 602132 602132 Blome, William, of Cawston, husbandman 1
3845646 1972182 1972182 defendant Crippe Thomas miller 602132 602132 Crippe, Thomas, of Cawston, miller 0
3845769 1972225 1972225 defendant Skryppe Thomas miller 602132 602132 Skryppe, Thomas, of Cawston, miller 0
3856452 1975642 1975642 defendant Skrype Thomas miller 602132 602132 Skrype, Thomas, of Cawston, miller 0
3871897 1980836 1980836 defendant Scryppe Thomas miller 602132 602132 Scryppe, Thomas, of Cawston, miller 2
3899640 1990098 1990098 defendant Sawyer John   602132 602132 Sawyer, John, of Cawston, worsted weaver 2
3899641 1990098 1990098 defendant Brady John shoemaker 602132 602132 Brady, John, of Cawston, shoemaker 3
3933127 2001371 2001371 plaintiff Goodman Robert yeoman 602132 602132 Goodman, Robert, of Cawston, yeoman 0
3945496 2005501 2005501 defendant Certeyn Robert clerk 602132 602132 Certeyn, Robert, of Cawston, clerk 1
3972850 2015076 2015076 defendant Lowth Nicholas husbandman 602132 602132 Lowth, Nicholas, of Cawston, husbandman 0
3983461 2018861 2018861 defendant Fuller Ralph butcher 602132 602132 Fuller, Ralph, of Cawston, butcher 0
3983462 2018861 2018861 defendant Smythe Edward husbandman 602132 602132 Smythe, Edward, of Cawston, husbandman 1
3983841 2018991 2018991 defendant Fuller Ralph butcher 602132 602132 Fuller, Ralph, of Cawston, butcher 3
4009081 2028014 2028014 plaintiff Mychell John gent 602132 602132 Mychell, John, of Cawston, gent 0
4009083 2028015 2028015 plaintiff Mychell John gent 602132 602132 Mychell, John, of Cawston, gent 0
4009085 2028016 2028016 plaintiff Mychell John gent 602132 602132 Mychell, John, of Cawston, gent 0
4014469 2029900 2029900 defendant Blome John sherman 602132 602132 Blome, John, of Cawston, sherman 0
4014471 2029901 2029901 defendant Blome John sherman 602132 602132 Blome, John, of Cawston, sherman 0
4014994 2030072 2030072 defendant Fuller Ralph butcher 602132 602132 Fuller, Ralph, of Cawston, butcher 2
4017735 2031049 2031049 defendant Peters George husbandman 602132 602132 Peters, George, of Cawston, husbandman 0
4043338 2040085 2040085 defendant Parke Henry husbandman 602132 602132 Parke, Henry, of Cawston, husbandman 2
4046658 2041256 2041256 defendant Smyth Nicholas husbandman 602132 602132 Smyth, Nicholas, of Cawston, husbandman 0
4046793 2041308 2041308 defendant Smyth Nicholas husbandman 602132 602132 Smyth, Nicholas, of Cawston, husbandman 0
4046794 2041308 2041308 defendant Smyth Simon husbandman 602132 602132 Smyth, Simon, of Cawston, husbandman 1
4052127 2043181 2043181 defendant Pryor Thomas husbandman 602132 602132 Pryor, Thomas, of Cawston, husbandman 0
4060110 2046015 2046015 defendant Parke Henry husbandman 602132 602132 Parke, Henry, of Cawston, husbandman 2
4062890 2047027 2047027 defendant Warde Miles gent 602132 602132 Warde, Miles, of Cawston, gent 1
4074141 2051048 2051048 defendant Peter George yeoman 602132 602132 Peter, George, of Cawston, yeoman 1
4074205 2051073 2051073 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 1
4076103 2051745 2051745 defendant Peters George yeoman 602132 602132 Peters, George, of Cawston, yeoman 0
4085542 2055100 2055100 defendant Wright John husbandman 602132 602132 Wright, John, of Cawston, husbandman 0
4091009 2057075 2057075 defendant Elson William husbandman 602132 602132 Elson, William, of Cawston, husbandman 0
4091011 2057075 2057075 defendant Argent Margaret widow 602132 602132 Argent, Margaret, of Cawston, widow 2
4091015 2057076 2057076 defendant Enoden James husbandman 602132 602132 Enoden, James, of Cawston, husbandman 1
4095708 2058797 2058797 defendant Metton John chapman 602132 602132 Metton, John, of Cawston, chapman 0
4098159 2059669 2059669 defendant Saver John husbandman 602132 602132 Saver, John, of Cawston, husbandman 1
4098161 2059669 2059669 defendant Bafyld William husbandman 602132 602132 Bafyld, William, of Cawston, husbandman 3
4098895 2059933 2059933 defendant Gurney William, junior gent 602132 602132 Gurney, William, junior, of Cawston, gent 0
4118351 2066853 2066853 defendant Spratt John smith 602132 602132 Spratt, John, of Cawston, smith 1
4129243 2070760 2070760 defendant Lewyn George blacksmith 602132 602132 Lewyn, George, of Cawston, blacksmith 1
4132502 2071940 2071940 defendant Younges Henry shoemaker 602132 602132 Younges, Henry, of Cawston, shoemaker 0
4135671 2073085 2073085 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 1
4135672 2073085 2073085 defendant Fayerclowe John husbandman 602132 602132 Fayerclowe, John, of Cawston, husbandman 2
4135675 2073086 2073086 defendant Gurney William, junior gent 602132 602132 Gurney, William, junior, of Cawston, gent 0
4135677 2073087 2073087 defendant Gurney William gent 602132 602132 Gurney, William, of Cawston, gent 0
4135678 2073087 2073087 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 1
4135679 2073087 2073087 defendant Fayerclerke John husbandman 602132 602132 Fayerclerke, John, of Cawston, husbandman 2
4141861 2075320 2075320 defendant Peter George yeoman 602132 602132 Peter, George, of Cawston, yeoman 0
4145656 2076633 2076633 defendant Bulman Thomas weaver 602132 602132 Bulman, Thomas, of Cawston, weaver 0
4150137 2078183 2078183 defendant Stannowe Elizabeth widow 602132 602132 Stannowe, Elizabeth, of Cawston, widow 4
4150450 2078287 2078287 defendant Hoye Stephen husbandman 602132 602132 Hoye, Stephen, of Cawston, husbandman 1
4150784 2078410 2078410 defendant Motton John yeoman 602132 602132 Motton, John, of Cawston, yeoman 3
4151191 2078541 2078541 defendant Archer Humphrey yeoman 602132 602132 Archer, Humphrey, of Cawston, yeoman 0
4159760 2081483 2081483 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 1
4159761 2081483 2081483 defendant Fayerclowe John husbandman 602132 602132 Fayerclowe, John, of Cawston, husbandman 2
4168336 2084409 2084409 defendant Tompson Robert laborer 602132 602132 Tompson, Robert, of Cawston, laborer 2
4170217 2085080 2085080 defendant Brome Clement husbandman 602132 602132 Brome, Clement, of Cawston, husbandman 2
4175451 2086885 2086885 defendant Brome Clement husbandman 602132 602132 Brome, Clement, of Cawston, husbandman 0
4182839 2089479 2089479 defendant Gurney William yeoman 602132 602132 Gurney, William, of Cawston, yeoman 0
4182840 2089479 2089479 defendant Fayrelowe John husbandman 602132 602132 Fayrelowe, John, of Cawston, husbandman 1
4192235 2092849 2092849 defendant Brane Clement husbandman 602132 602132 Brane, Clement, of Cawston, husbandman 0
4197303 2094608 2094608 defendant Brome Clement husbandman 602132 602132 Brome, Clement, of Cawston, husbandman 2
4198726 2095114 2095114 defendant Metton John mercer 602132 602132 Metton, John, of Cawston, mercer 0
4198727 2095114 2095114 defendant Wolbye alias Wolsey Martin cordwainer 602132 602132 Wolbye alias Wolsey, Martin, of Cawston, cordwainer 1
4204236 2097030 2097030 defendant Fell John husbandman 602132 602132 Fell, John, of Cawston, husbandman 3
4211020 2099411 2099411 defendant Peter George yeoman 602132 602132 Peter, George, of Cawston, yeoman 1
4214165 2100471 2100471 defendant Elison John carpenter 602132 602132 Elison, John, of Cawston, carpenter 0
4214166 2100471 2100471 defendant Porrett William husbandman 602132 602132 Porrett, William, of Cawston, husbandman 1
4214167 2100471 2100471 defendant Saman Christopher thatcher 602132 602132 Saman, Christopher, of Cawston, thatcher 2
4214768 2100671 2100671 defendant Yong or Yonges Henry cordwainer 602132 602132 Yong or Yonges, Henry, of Cawston, cordwainer 2
4224323 2103991 2103991 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 3
4225456 2104368 2104368 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 0
4226706 2104812 2104812 defendant Lightfoote John carpenter 602132 602132 Lightfoote, John, of Cawston, carpenter 1
4228151 2105328 2105328 defendant Browne William, senior yeoman 602132 602132 Browne, William, senior, of Cawston, yeoman 0
4228154 2105328 2105328 defendant Dewyn Robert, junior butcher 602132 602132 Dewyn, Robert, junior, of Cawston, butcher 3
4229321 2105736 2105736 defendant Porrett William husbandman 602132 602132 Porrett, William, of Cawston, husbandman 1
4242267 2110408 2110408 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 0
4242270 2110409 2110409 defendant Browne William yeoman 602132 602132 Browne, William, of Cawston, yeoman 0
4251290 2113407 2113407 defendant Alyson John laborer 602132 602132 Alyson, John, of Cawston, laborer 3
4251743 2113573 2113573 defendant Jerbridge Thomas yeoman 602132 602132 Jerbridge, Thomas, of Cawston, yeoman 1
4252686 2113885 2113885 defendant Walker William husbandman 602132 602132 Walker, William, of Cawston, husbandman 3
4252756 2113908 2113908 defendant Jerbridge Thomas yeoman 602132 602132 Jerbridge, Thomas, of Cawston, yeoman 0
4252759 2113908 2113908 defendant Toftewood Gramarius gent 602132 602132 Toftewood, Gramarius, of Cawston, or of Wall, gent 3
4252893 2113961 2113961 defendant Baxter Elizabeth widow 602132 602132 Baxter, Elizabeth, of Cawston, widow 3
4258585 2115836 2115836 defendant Peters William yeoman 602132 602132 Peters, William, of Cawston, yeoman 1
4258588 2115837 2115837 defendant Peters William yeoman 602132 602132 Peters, William, of Cawston, yeoman 1
4258641 2115852 2115852 defendant Cooke William yeoman 602132 602132 Cooke, William, of Cawston, yeoman 0
4258642 2115852 2115852 defendant Peters William yeoman 602132 602132 Peters, William, of Cawston, yeoman 1
4271671 2120107 2120107 defendant Jerbridge Thomas husbandman 602132 602132 Jerbridge, Thomas, of Cawston, husbandman 0
4277783 2122154 2122154 defendant Porrett William yeoman 602132 602132 Porrett, William, of Cawston, yeoman 1
4278127 2122285 2122285 defendant Porrytt William yeoman 602132 602132 Porrytt, William, of Cawston, yeoman 0
4278128 2122285 2122285 defendant Porrett Richard husbandman 602132 602132 Porrett, Richard, of Cawston, husbandman 1
4281985 2123599 2123599 defendant Boughton Darion gent 602132 602132 Boughton, Darion, of Cawston, gent 0
4284517 2124510 2124510 defendant Peter William gent 602132 602132 Peter, William, of Cawston, gent 0

Next page

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