names

40 rows where place_id = 589332

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597253 1866762 1866762 defendant Waldef Joyce widow 589332 589332 Waldef, Joyce, of Hurley, widow 0
3597254 1866762 1866762 defendant Lewen John husbandman 589332 589332 Lewen, John, of Hurley, husbandman 1
3635035 1905757 1905757 defendant Goldsmyth Robert husbandman 589332 589332 Goldsmyth, Robert, of Hurley, husbandman 1
3652534 1911124 1911124 defendant Wyllynhale John gent 589332 589332 Wyllynhale, John, of Hurley, gent 0
3669558 1916416 1916416 defendant Whate William carpenter 589332 589332 Whate, William, of Hurley, carpenter 1
3677410 1918986 1918986 defendant Trebyke John husbandman 589332 589332 Trebyke, John, of Hurley, husbandman 1
3691814 1923601 1923601 defendant Barbour William husbandman 589332 589332 Barbour, William, of Hurley, husbandman 1
3694658 1924534 1924534 defendant Hewster John yeoman 589332 589332 Hewster, John, of Hurley, yeoman 0
3694659 1924534 1924534 defendant Heddyngton Robert husbandman 589332 589332 Heddyngton, Robert, of Hurley, husbandman 1
3757244 1944251 1944251 defendant Norrys Robert yeoman 589332 589332 Norrys, Robert, of Hurley, yeoman 1
3762530 1945924 1945924 defendant Smyth John turner 589332 589332 Smyth, John, of Hurley, turner 0
3775546 1950095 1950095 defendant Smyth John turner 589332 589332 Smyth, John, of Hurley, turner 0
3867964 1979520 1979520 defendant Trebek John fuller 589332 589332 Trebek, John, of Hurley, fuller 0
3879875 1983528 1983528 defendant Shylton John (legal representative) 589332 589332 Shylton, John, of Hurley, husbandman, executors of 0
3881804 1984167 1984167 defendant Trebek John fuller 589332 589332 Trebek, John, of Hurley, fuller 0
3940174 2003733 2003733 plaintiff Smyth Thomas (legal representative) 589332 589332 Smyth, Thomas, of Hurley, executor of 0
3940176 2003733 2003733 defendant Smythe William husbandman 589332 589332 Smythe, William, of Hurley, husbandman 0
3974186 2015541 2015541 defendant Willington Waldive gent 589332 589332 Willington, Waldive, of Hurley, gent 0
3974187 2015541 2015541 defendant Lagow Richard laborer 589332 589332 Lagow, Richard, of Hurley, laborer 1
3974188 2015541 2015541 defendant Shilton Thomas husbandman 589332 589332 Shilton, Thomas, of Hurley, husbandman 2
3974189 2015541 2015541 defendant Goyte Thomas husbandman 589332 589332 Goyte, Thomas, of Hurley, husbandman 3
3974190 2015541 2015541 defendant Moore John husbandman 589332 589332 Moore, John, of Hurley, husbandman 4
3974191 2015541 2015541 defendant Watson John husbandman 589332 589332 Watson, John, of Hurley, husbandman 5
3974192 2015541 2015541 defendant Ireland Anthony husbandman 589332 589332 Ireland, Anthony, of Hurley, husbandman 6
3974193 2015541 2015541 defendant Taylour Thomas husbandman 589332 589332 Taylour, Thomas, of Hurley, husbandman 7
3974194 2015541 2015541 defendant Symondes Robert husbandman 589332 589332 Symondes, Robert, of Hurley, husbandman 8
3974195 2015541 2015541 defendant Croftes John husbandman 589332 589332 Croftes, John, of Hurley, husbandman 9
3974196 2015541 2015541 defendant Mylles Edmund husbandman 589332 589332 Mylles, Edmund, of Hurley, husbandman 10
3974197 2015541 2015541 defendant Oythurste John husbandman 589332 589332 Oythurste, John, of Hurley, husbandman 11
3974198 2015541 2015541 defendant Owldes John laborer 589332 589332 Owldes, John, of Hurley, laborer 12
4219236 2102223 2102223 defendant Tompson Thomas husbandman 589332 589332 Tompson, Thomas, of Hurley, husbandman 0
4219241 2102224 2102224 defendant Tompson Thomas husbandman 589332 589332 Tompson, Thomas, of Hurley, husbandman 0
4693283 2263400 2263400 defendant Moighale William husbandman 589332 589332 Moighale, William, of Hurley, husbandman 1
4940001 2338897 2338897 defendant Anketell Ralph husbandman 589332 589332 Anketell, Ralph, of Hurley, husbandman 5
5168263 2406431 2406431 plaintiff Doun Edmund   589332 589332 Doun, Edmund, of Hurley, Berks, prior 0
5208176 2418120 2418120 defendant (not given) Edmund prior of Downe 589332 589332 Downe, Edmund, of Hurley, prior of the house of the BM 0
5361941 2463760 2463760 defendant Waldyffe Nicholas gent 589332 589332 Waldyffe, Nicholas, of Hurley, gent 0
5404706 2476425 2476425 plaintiff (not given) Thomas prior of Preston 589332 589332 Preston, Thomas, of Hurley, prior of the Monastery of the BVM 0
5499658 2504840 2504840 defendant Longe John husbandman 589332 589332 Longe, John, of Hurley, husbandman 1
5577893 2528158 2528158 defendant Wyllynhale John gent 589332 589332 Wyllynhale, John, of Hurley, gent 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);