names

35 rows where place_id = 602670

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651224 1910751 1910751 defendant Myddylton Leonard clerk 602670 602670 Myddylton, Leonard, of Balsham, Cams, clerk 0
3652250 1911043 1911043 defendant Nayllour William husbandman 602670 602670 Nayllour, William, of Balsham, Cams, husbandman 1
3738869 1938362 1938362 plaintiff Orme Ralph shoemaker 602670 602670 Orme, Ralph, of Balsham, Cams, shoemaker 1
3738874 1938363 1938363 plaintiff Orme Ralph shoemaker 602670 602670 Orme, Ralph, of Balsham, Cams, shoemaker 1
3750806 1942175 1942175 defendant Horne Ralph yeoman 602670 602670 Horne, Ralph, of Balsham, Cams, yeoman 2
3784550 1952954 1952954 defendant Horne Ralph yeoman 602670 602670 Horne, Ralph, of Balsham, Cams, yeoman 0
3796691 1956849 1956849 defendant Horne Ralph shoemaker 602670 602670 Horne, Ralph, of Balsham, Cams, shoemaker 0
3847454 1972766 1972766 defendant Myn Henry clerk 602670 602670 Myn, Henry, of Balsham, Cams, clerk 2
3847628 1972828 1972828 defendant Myn or Myner Henry clerk 602670 602670 Myn or Myner, Henry, of Balsham, Cams, clerk 2
3918486 1996513 1996513 defendant Lawranse William yeoman 602670 602670 Lawranse, William, of Balsham, Cams, yeoman 1
3918488 1996514 1996514 defendant Lawrens William yeoman 602670 602670 Lawrens, William, of Balsham, Cams, yeoman 0
3960999 2010942 2010942 defendant Cokerton William butcher 602670 602670 Cokerton, William, of Balsham, Cams, butcher 0
3992235 2021987 2021987 defendant Perne John yeoman 602670 602670 Perne, John, of Balsham, Cams, yeoman 0
4021982 2032589 2032589 defendant Page Henry yeoman 602670 602670 Page, Henry, of Balsham, Cams, yeoman 0
4028760 2034934 2034934 plaintiff Cowle John husbandman 602670 602670 Cowle, John, of Balsham, Cams, husbandman 0
4037874 2038197 2038197 defendant Haylock Edmund yeoman 602670 602670 Haylock, Edmund, of Balsham, Cams, yeoman 1
4037879 2038198 2038198 defendant Haylock Edmund   602670 602670 Haylock, Edmund, of Balsham, Cams, yeoman, shepherd 1
4068325 2048971 2048971 defendant Tayler William husbandman 602670 602670 Tayler, William, of Balsham, Cams, husbandman 2
4124399 2069020 2069020 defendant Wybroughe Thomas yeoman 602670 602670 Wybroughe, Thomas, of Balsham, Cams, yeoman 0
4187822 2091242 2091242 defendant Simond John husbandman 602670 602670 Simond, John, of Balsham, Cams, husbandman 2
4213866 2100370 2100370 defendant Wyborowe Thomas yeoman 602670 602670 Wyborowe, Thomas, of Balsham, Cams, yeoman 0
4334910 2141938 2141938 defendant Tassell Richard yeoman 602670 602670 Tassell, Richard, of Balsham, Cams, yeoman 0
4358222 2150108 2150108 defendant Tassell Richard yeoman 602670 602670 Tassell, Richard, of Balsham, Cams, yeoman 0
4411082 2168292 2168292 defendant Laurence Thomas yeoman 602670 602670 Laurence, Thomas, of Balsham, Cams, yeoman 0
4933641 2336900 2336900 defendant Blodewell John clerk 602670 602670 Blodewell, John, of Balsham, Cams, clerk 2
4958831 2344614 2344614 defendant Blodewell John clerk 602670 602670 Blodewell, John, of Balsham, Cams, clerk 2
5090194 2383503 2383503 defendant Caldebek Henry esq 602670 602670 Caldebek, Henry, of Balsham, Cams, esq 0
5258968 2432920 2432920 defendant Norton John, junior smith 602670 602670 Norton, John, junior, of Balsham, Cams, smith 0
5258970 2432921 2432921 defendant Norton John, junior smith 602670 602670 Norton, John, junior, of Balsham, Cams, smith 0
5352278 2460812 2460812 defendant Hacforth Richard chaplain 602670 602670 Hacforth, Richard, of Balsham, Cams, chaplain 0
5553557 2521073 2521073 defendant Webbe Thomas tailor 602670 602670 Webbe, Thomas, of Balsham, Cams, tailor 0
5557682 2522203 2522203 defendant Rowse John clerk 602670 602670 Rowse, John, of Balsham, Cams, clerk 1
5563811 2524023 2524023 defendant Middelton Leonard clerk 602670 602670 Middelton, Leonard, of Balsham, Cams, clerk 2
5563818 2524024 2524024 defendant Middelton Leonard clerk 602670 602670 Middelton, Leonard, of Balsham, Cams, clerk 2
5584861 2530343 2530343 defendant Fryer John chapman 602670 602670 Fryer, John, of Balsham, Cams, chapman 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);