names

67 rows where place_id = 589114

✎ 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
3596592 1866568 1866568 defendant Hyerd William husbandman 589114 589114 Hyerd, William, of Theydon Garnon, husbandman 0
3596593 1866568 1866568 defendant Wylcok Robert husbandman 589114 589114 Wylcok, Robert, of Theydon Garnon, husbandman 1
3630683 1904425 1904425 defendant Hampden Francis esq 589114 589114 Hampden, Francis, of Theydon Garnon, esq 0
3633890 1905408 1905408 defendant Archer John, senior yeoman 589114 589114 Archer, John, senior, of Theydon Garnon, yeoman 1
3667451 1915759 1915759 defendant Garold Richard collier 589114 589114 Garold, Richard, of Theydon Garnon, collier 0
3710913 1929732 1929732 defendant Parker Richard yeoman 589114 589114 Parker, Richard, of Theydon Garnon, yeoman 0
3710918 1929733 1929733 defendant Parker Richard yeoman 589114 589114 Parker, Richard, of Theydon Garnon, yeoman 0
3710923 1929734 1929734 defendant Parker Richard yeoman 589114 589114 Parker, Richard, of Theydon Garnon, yeoman 0
3726862 1934671 1934671 defendant Herde Thomas yeoman 589114 589114 Herde, Thomas, of Theydon Garnon, yeoman 0
3745660 1940550 1940550 defendant Carre John smith 589114 589114 Carre, John, of Theydon Garnon, smith 0
3758818 1944746 1944746 defendant Parker Richard yeoman 589114 589114 Parker, Richard, of Theydon Garnon, yeoman 0
3763321 1946160 1946160 defendant Parker Richard yeoman 589114 589114 Parker, Richard, of Theydon Garnon, yeoman 1
3857554 1975998 1975998 plaintiff Ayrson William chaplain 589114 589114 Ayrson, William, of Theydon Garnon, chaplain 0
3873387 1981314 1981314 defendant Parker Richard yeoman 589114 589114 Parker, Richard, of Theydon Garnon, yeoman 1
3909275 1993393 1993393 defendant Lynnett John husbandman 589114 589114 Lynnett, John, of Theydon Garnon, husbandman 3
4191073 2092442 2092442 defendant Archer Henry singleman 589114 589114 Archer, Henry, of Theydon Garnon, glover, singleman 0
4530903 2209958 2209958 defendant Wasselyn William   589114 589114 Wasselyn, William, of Theydon Garnon, parson 0
4799833 2296129 2296129 defendant Robert John parker 589114 589114 Robert, John, of Theydon Garnon, parker 4
4835022 2306955 2306955 defendant Parker Stephen carrier 589114 589114 Parker, Stephen, of Theydon Garnon, carrier 0
4883286 2321699 2321699 defendant Pake William laborer 589114 589114 Pake, William, of Theydon Garnon, laborer 2
4883287 2321699 2321699 defendant Danyell Robert husbandman 589114 589114 Danyell, Robert, of Theydon Garnon, husbandman 3
4883288 2321699 2321699 defendant Baker Walter husbandman 589114 589114 Baker, Walter, of Theydon Garnon, husbandman 4
4883289 2321699 2321699 defendant atte Rey John husbandman 589114 589114 atte Rey, John, of Theydon Garnon, husbandman 5
4897308 2325816 2325816 defendant Pecok William maltman 589114 589114 Pecok, William, of Theydon Garnon, maltman 0
4897309 2325816 2325816 defendant Pake John husbandman 589114 589114 Pake, John, of Theydon Garnon, husbandman 1
4903767 2327798 2327798 defendant Pake John husbandman 589114 589114 Pake, John, of Theydon Garnon, husbandman 0
4920606 2332959 2332959 defendant Pake John husbandman 589114 589114 Pake, John, of Theydon Garnon, husbandman 1
4937421 2338076 2338076 defendant Blisse John husbandman 589114 589114 Blisse, John, of Theydon Garnon, husbandman 2
4938883 2338553 2338553 defendant Forster William husbandman 589114 589114 Forster, William, of Theydon Garnon, husbandman 0
4938884 2338553 2338553 defendant Felde John gent 589114 589114 Felde, John, of Theydon Garnon, gent 1
4938886 2338554 2338554 defendant Forster William yeoman 589114 589114 Forster, William, of Theydon Garnon, yeoman 0
4938887 2338554 2338554 defendant Felde John yeoman 589114 589114 Felde, John, of Theydon Garnon, yeoman 1
4946208 2340799 2340799 defendant Pake John husbandman 589114 589114 Pake, John, of Theydon Garnon, husbandman 1
4997123 2355994 2355994 defendant Pecok William yeoman 589114 589114 Pecok, William, of Theydon Garnon, yeoman 0
5127867 2394629 2394629 defendant Forster William, senior maltman 589114 589114 Forster, William, senior, of Theydon Garnon, maltman 2
5143295 2399175 2399175 defendant Parker William husbandman 589114 589114 Parker, William, of Theydon Garnon, husbandman 0
5162717 2404815 2404815 defendant Parker William yeoman 589114 589114 Parker, William, of Theydon Garnon, yeoman 2
5164597 2405378 2405378 defendant Parker William husbandman 589114 589114 Parker, William, of Theydon Garnon, husbandman 0
5164601 2405379 2405379 defendant Parker William husbandman 589114 589114 Parker, William, of Theydon Garnon, husbandman 0
5187682 2412115 2412115 defendant Parker Richard husbandman 589114 589114 Parker, Richard, of Theydon Garnon, husbandman 2
5205669 2417402 2417402 defendant Parker Richard husbandman 589114 589114 Parker, Richard, of Theydon Garnon, husbandman 2
5228353 2423903 2423903 defendant Mapyll John husbandman 589114 589114 Mapyll, John, of Theydon Garnon, husbandman 2
5228355 2423904 2423904 defendant Roger John maltman 589114 589114 Roger, John, of Theydon Garnon, maltman 0
5305616 2446686 2446686 defendant Drury William yeoman 589114 589114 Drury, William, of Theydon Garnon, yeoman 1
5319488 2450921 2450921 defendant Parker William husbandman 589114 589114 Parker, William, of Theydon Garnon, husbandman 0
5319489 2450921 2450921 defendant Duke John husbandman 589114 589114 Duke, John, of Theydon Garnon, husbandman 1
5392108 2472826 2472826 defendant Evermond William husbandman 589114 589114 Evermond, William, of Theydon Garnon, husbandman 3
5464492 2494301 2494301 defendant Crosse John husbandman 589114 589114 Crosse, John, of Theydon Garnon, husbandman 1
5467456 2495204 2495204 defendant Prynce John gent 589114 589114 Prynce, John, of Theydon Garnon, gent 0
5470680 2496151 2496151 defendant Prynce John gent 589114 589114 Prynce, John, of Theydon Garnon, gent 0
5479003 2498740 2498740 defendant Pecok Margaret widow 589114 589114 Pecok, Margaret, of Theydon Garnon, widow 0
5479004 2498740 2498740 defendant Pecok John, junior laborer 589114 589114 Pecok, John, junior, of Theydon Garnon, laborer 1
5520069 2511107 2511107 defendant Wylkynson John husbandman 589114 589114 Wylkynson, John, of Theydon Garnon, husbandman 0
5520070 2511107 2511107 defendant Trappys Henry husbandman 589114 589114 Trappys, Henry, of Theydon Garnon, husbandman 1
5520071 2511107 2511107 defendant Sparowe William gent 589114 589114 Sparowe, William, of Theydon Garnon, gent 2
5520076 2511108 2511108 defendant Sparowe William gent 589114 589114 Sparowe, William, of Theydon Garnon, gent 0
5520077 2511108 2511108 defendant Wylkynson John husbandman 589114 589114 Wylkynson, John, of Theydon Garnon, husbandman 1
5520078 2511108 2511108 defendant Trappys Henry husbandman 589114 589114 Trappys, Henry, of Theydon Garnon, husbandman 2
5520083 2511109 2511109 defendant Sparowe William gent 589114 589114 Sparowe, William, of Theydon Garnon, gent 0
5520084 2511109 2511109 defendant Wylkynson John husbandman 589114 589114 Wylkynson, John, of Theydon Garnon, husbandman 1
5520085 2511109 2511109 defendant Trappys Henry husbandman 589114 589114 Trappys, Henry, of Theydon Garnon, husbandman 2
5521752 2511615 2511615 defendant Sparowe William gent 589114 589114 Sparowe, William, of Theydon Garnon, gent 0
5537273 2516145 2516145 defendant Sparowe Elizabeth widow 589114 589114 Sparowe, Elizabeth, of Theydon Garnon, widow 0
5546445 2518960 2518960 defendant Wynchecombe Margaret widow 589114 589114 Wynchecombe, Margaret, of Theydon Garnon, widow 2
5546564 2518996 2518996 defendant Skegge Robert husbandman 589114 589114 Skegge, Robert, of Theydon Garnon, husbandman 0
5602372 2535639 2535639 defendant Baker Edward laborer 589114 589114 Baker, Edward, of Theydon Garnon, laborer 1
5635076 2554953 2554953 defendant Roger Hugh maltman 589114 589114 Roger, Hugh, of Theydon Garnon, maltman 4

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