names

46 rows where place_id = 588114

✎ 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
3593424 1865576 1865576 defendant ap Hygyn Richard gent 588114 588114 ap Hygyn, Richard, of Walterston, gent 1
3675554 1918391 1918391 plaintiff Hergest Roger   588114 588114 Hergest, Roger, of Walterston 0
3807254 1960166 1960166 defendant Water Philip husbandman 588114 588114 Water, Philip, of Walterston, husbandman 1
3893581 1988078 1988078 defendant Hergerst Roger gent 588114 588114 Hergerst, Roger, of Walterston, gent 0
3964196 2012085 2012085 defendant ap Rosser Howell husbandman 588114 588114 ap Rosser, Howell, of Walterston, husbandman 0
3964949 2012347 2012347 defendant Dee John Thomas husbandman 588114 588114 Dee, John Thomas, of Walterston, husbandman 2
3972803 2015060 2015060 defendant William John Thomas tailor 588114 588114 William, John Thomas, of Walterston, tailor 1
4000989 2025124 2025124 defendant Seycyll William gent 588114 588114 Seycyll, William, of Walterston, gent 1
4026818 2034239 2034239 defendant Hurde Christopher yeoman 588114 588114 Hurde, Christopher, of Walterston, yeoman 0
4058570 2045455 2045455 defendant Harbyn Henry yeoman 588114 588114 Harbyn, Henry, of Walterston, yeoman 0
4078247 2052522 2052522 defendant Hurde Thomas brother of John 588114 588114 Hurde, Thomas, of Walterston, yeoman, brother of John 2
4083068 2054238 2054238 defendant Grief Philip David Thomas yeoman 588114 588114 Grief, Philip David Thomas, of Walterston, yeoman 1
4100249 2060424 2060424 defendant Harbert William gent 588114 588114 Harbert, William, of Walterston, gent 0
4150389 2078266 2078266 defendant Baskervile John gent 588114 588114 Baskervile, John, of Walterston, gent 1
4150399 2078269 2078269 defendant Baskervile John gent 588114 588114 Baskervile, John, of Walterston, gent 1
4186507 2090766 2090766 defendant Hurde Christopher yeoman 588114 588114 Hurde, Christopher, of Walterston, yeoman 1
4210198 2099128 2099128 defendant Hurde Christopher yeoman 588114 588114 Hurde, Christopher, of Walterston, yeoman 1
4230415 2106131 2106131 defendant Knowles Morgan yeoman 588114 588114 Knowles, Morgan, of Walterston, yeoman 1
4236223 2108239 2108239 defendant Taylor Francis yeoman 588114 588114 Taylor, Francis, of Walterston, yeoman 0
4237859 2108845 2108845 defendant William Simon Harry husbandman 588114 588114 William, Simon Harry, of Walterston, husbandman 0
4237860 2108845 2108845 defendant Symond John husbandman 588114 588114 Symond, John, of Walterston, husbandman 1
4240761 2109891 2109891 defendant Nicolls Philip yeoman 588114 588114 Nicolls, Philip, of Walterston, yeoman 1
4319194 2136828 2136828 defendant Watkyn Richard John yeoman 588114 588114 Watkyn, Richard John, of Walterston, yeoman 0
4343664 2145063 2145063 defendant Davies William gent 588114 588114 Davies, William, of Walterston, gent 0
4358322 2150145 2150145 defendant Prowes Andrew gent 588114 588114 Prowes, Andrew, of Walterston, gent 3
4358738 2150292 2150292 defendant Cicill William esq 588114 588114 Cicill, William, of Walterston, esq 2
4383149 2159081 2159081 defendant Symond William husbandman 588114 588114 Symond, William, of Walterston, husbandman 0
4383150 2159081 2159081 defendant Howell Richard husbandman 588114 588114 Howell, Richard, of Walterston, husbandman 1
4383189 2159096 2159096 defendant Vaughan Watkin gent 588114 588114 Vaughan, Watkin, of Walterston, gent 0
4390582 2161469 2161469 defendant Watkyn Richard John yeoman 588114 588114 Watkyn, Richard John, of Walterston, yeoman 0
4390583 2161469 2161469 defendant Philip Thomas David yeoman 588114 588114 Philip, Thomas David, of Walterston, yeoman 1
4390584 2161469 2161469 defendant Symond David yeoman 588114 588114 Symond, David, of Walterston, yeoman 2
4408798 2167539 2167539 defendant Vaughan Watkin gent 588114 588114 Vaughan, Watkin, of Walterston, gent 0
4408799 2167539 2167539 defendant Vaughan William Watkin gent 588114 588114 Vaughan, William Watkin, of Walterston, gent 1
4408800 2167539 2167539 defendant Vaughan Alice spinster 588114 588114 Vaughan, Alice, of Walterston, spinster 2
4410939 2168250 2168250 defendant verch John Alice spinster 588114 588114 verch John, Alice, of Walterston, spinster 0
4410940 2168250 2168250 defendant Symond David yeoman 588114 588114 Symond, David, of Walterston, yeoman 1
4828452 2304943 2304943 defendant Hergest Hugh esq 588114 588114 Hergest, Hugh, of Walterston, esq 0
4828460 2304943 2304943 defendant Coly Philip laborer 588114 588114 Coly, Philip, of Walterston, laborer 8
4828461 2304943 2304943 defendant Goghyeyr Geoffrey laborer 588114 588114 Goghyeyr, Geoffrey, of Walterston, laborer 9
4828462 2304943 2304943 defendant Eva Jenan laborer 588114 588114 Eva, Jenan, of Walterston, laborer 10
4828463 2304943 2304943 defendant ap Jenan ap Howell Howell laborer 588114 588114 ap Jenan ap Howell, Howell, of Walterston, laborer 11
4850985 2311757 2311757 defendant Hergaste Hugh gent 588114 588114 Hergaste, Hugh, of Walterston, gent 0
4902845 2327506 2327506 defendant Hergaste Hugh gent 588114 588114 Hergaste, Hugh, of Walterston, gent 0
4957040 2344059 2344059 defendant Govitz Henry (legal representative) 588114 588114 Govitz, Henry, of Walterston, esq, executors of 0
5518714 2510689 2510689 defendant Hargest Richard gent 588114 588114 Hargest, Richard, of Walterston, gent 0

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