names

32 rows where place_id = 639920

✎ 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
3852008 1974217 1974217 defendant Pawne William gent 639920 639920 Pawne, William, of Blakemore, Essex, gent 0
3881240 1983994 1983994 defendant Pawne William gent 639920 639920 Pawne, William, of Blakemore, Essex, gent 1
3913640 1994902 1994902 defendant Cutterwode John yeoman 639920 639920 Cutterwode, John, of Blakemore, Essex, yeoman 1
3934662 2001887 2001887 defendant Thomson Thomas clerk 639920 639920 Thomson, Thomas, of Blakemore, Essex, clerk 2
4276383 2121685 2121685 plaintiff Daniell Henry (legal representative) 639920 639920 Daniell, Henry, of Blakemore, Essex, gent, executors of 0
4649245 2245831 2245831 defendant Reynold John   639920 639920 Reynold, John, of Blakemore, Essex 0
4943864 2340042 2340042 defendant Hooke William butcher 639920 639920 Hooke, William, of Blakemore, Essex, butcher 1
4943867 2340043 2340043 defendant Hooke William butcher 639920 639920 Hooke, William, of Blakemore, Essex, butcher 1
4945107 2340452 2340452 defendant Huchon Richard husbandman 639920 639920 Huchon, Richard, of Blakemore, Essex, husbandman 1
4945892 2340699 2340699 defendant Huchon Richard husbandman 639920 639920 Huchon, Richard, of Blakemore, Essex, husbandman 1
4965698 2346664 2346664 defendant Whitby Thomas husbandman 639920 639920 Whitby, Thomas, of Blakemore, Essex, husbandman 0
4965700 2346665 2346665 defendant Whitby Thomas husbandman 639920 639920 Whitby, Thomas, of Blakemore, Essex, husbandman 0
4981337 2351341 2351341 defendant Kyng John husbandman 639920 639920 Kyng, John, of Blakemore, Essex, husbandman 0
5016297 2361657 2361657 defendant Palmer John husbandman 639920 639920 Palmer, John, of Blakemore, Essex, husbandman 0
5039998 2368607 2368607 defendant Parker Richard gent 639920 639920 Parker, Richard, of Blakemore, Essex, gent 0
5144475 2399545 2399545 defendant Pulter John husbandman 639920 639920 Pulter, John, of Blakemore, Essex, husbandman 1
5165306 2405598 2405598 defendant Pulter John husbandman 639920 639920 Pulter, John, of Blakemore, Essex, husbandman 1
5165311 2405599 2405599 defendant Pulter John husbandman 639920 639920 Pulter, John, of Blakemore, Essex, husbandman 1
5179200 2409653 2409653 defendant Pulter John husbandman 639920 639920 Pulter, John, of Blakemore, Essex, husbandman 1
5232483 2425078 2425078 defendant Palmer Thomas chapman 639920 639920 Palmer, Thomas, of Blakemore, Essex, chapman 2
5261088 2433579 2433579 defendant Palmer alias Sponer John husbandman 639920 639920 Palmer alias Sponer, John, of Blakemore, Essex, husbandman 2
5261093 2433580 2433580 defendant Palmer alias Sponer John husbandman 639920 639920 Palmer alias Sponer, John, of Blakemore, Essex, husbandman 2
5263211 2434239 2434239 defendant Palmer alias Sponer John baker 639920 639920 Palmer alias Sponer, John, of Blakemore, Essex, baker 0
5294076 2443241 2443241 defendant Pecche Thomas butcher 639920 639920 Pecche, Thomas, of Blakemore, Essex, butcher 0
5302105 2445585 2445585 defendant Keve Thomas husbandman 639920 639920 Keve, Thomas, of Blakemore, Essex, husbandman 1
5411477 2478390 2478390 defendant Glasyer William yeoman 639920 639920 (Glasyer, William, of Blakemore, Essex, yeoman 3
5425752 2482672 2482672 defendant Glasyer William yeoman 639920 639920 (Glasyer, William, of Blakemore, Essex, yeoman 3
5425761 2482673 2482673 defendant Glasyer William yeoman 639920 639920 (Glasyer, William, of Blakemore, Essex, yeoman 3
5456880 2491963 2491963 defendant Glasyer William yeoman 639920 639920 (Glasyer, William, of Blakemore, Essex, yeoman 1
5462072 2493549 2493549 defendant Rokston William maltman 639920 639920 Rokston, William, of Blakemore, Essex, maltman 1
5473618 2497075 2497075 defendant Rokston William maltman 639920 639920 Rokston, William, of Blakemore, Essex, maltman 1
5486818 2500958 2500958 defendant Dodde William eyoman 639920 639920 Dodde, William, of Blakemore, Essex, eyoman 1

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