names

31 rows where place_id = 617555

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3720112 1932567 1932567 defendant Graynfyld Roger (legal representative) 617555 617555 Graynfyld, Roger, of Kylkehampton, esq, executor of Graynfyld, Thomas, of Kylkehampton, knight, executor of 0
3720113 1932567 1932567 defendant Graynfyld Richard esq 617555 617555 Graynfyld, Richard, of Kylkehampton, esq 1
3750521 1942077 1942077 defendant Thurdon Roger husbandman 617555 617555 Thurdon, Roger, of Kylkehampton, husbandman 0
3772649 1949137 1949137 defendant Shepard Martin husbandman 617555 617555 Shepard, Martin, of Kylkehampton, husbandman 1
3891866 1987532 1987532 defendant Thurdon Roger yeoman 617555 617555 Thurdon, Roger, of Kylkehampton, yeoman 0
3891867 1987532 1987532 defendant Thurdon John yeoman 617555 617555 Thurdon, John, of Kylkehampton, yeoman 1
3919876 1996981 1996981 defendant Paynter Joan widow 617555 617555 Paynter, Joan, of Kylkehampton, widow 0
3959380 2010362 2010362 defendant Otes John gent 617555 617555 Otes, John, of Kylkehampton, gent 0
3959381 2010362 2010362 defendant Gesse George smith 617555 617555 Gesse, George, of Kylkehampton, smith 1
4022917 2032920 2032920 defendant Gyst Thomas husbandman 617555 617555 Gyst, Thomas, of Kylkehampton, husbandman 4
4022928 2032921 2032921 defendant Gyst Thomas husbandman 617555 617555 Gyst, Thomas, of Kylkehampton, husbandman 4
4048924 2042058 2042058 defendant Allen John yeoman 617555 617555 Allen, John, of Kylkehampton, yeoman 5
4050790 2042719 2042719 defendant Nyle Lewis husbandman 617555 617555 Nyle, Lewis, of Kylkehampton, husbandman 1
4054020 2043819 2043819 defendant Edward Philip husbandman 617555 617555 Edward, Philip, of Kylkehampton, husbandman 1
4054021 2043819 2043819 defendant Rowe John weaver 617555 617555 Rowe, John, of Kylkehampton, weaver 2
4054190 2043885 2043885 defendant Gyste Thomas yeoman 617555 617555 Gyste, Thomas, of Kylkehampton, yeoman 0
4068290 2048959 2048959 defendant Heade John yeoman 617555 617555 Heade, John, of Kylkehampton, yeoman 0
4069952 2049537 2049537 plaintiff Lyppyncott Richard gent 617555 617555 Lyppyncott, Richard, of Kylkehampton, gent 0
4107314 2062906 2062906 defendant Rawe John, senior weaver 617555 617555 Rawe, John, senior, of Kylkehampton, weaver 0
4107315 2062906 2062906 defendant Rawe John, junior weaver 617555 617555 Rawe, John, junior, of Kylkehampton, weaver 1
4131073 2071432 2071432 defendant Benson Thomas saddler 617555 617555 Benson, Thomas, of Kylkehampton, saddler 0
4186927 2090915 2090915 defendant Bowman Thomas yeoman 617555 617555 Bowman, Thomas, of Kylkehampton, yeoman 0
4906402 2328589 2328589 defendant Gogh John gent 617555 617555 Gogh, John, of Kylkehampton, gent 0
4906403 2328589 2328589 defendant Gogh Walter gent 617555 617555 Gogh, Walter, of Kylkehampton, gent 1
5229243 2424161 2424161 defendant Jule William husbandman 617555 617555 Jule, William, of Kylkehampton, husbandman 1
5229246 2424162 2424162 defendant Jule William husbandman 617555 617555 Jule, William, of Kylkehampton, husbandman 1
5258080 2432645 2432645 defendant Hoggekyn or Hoskyn John chaplain 617555 617555 Hoggekyn or Hoskyn, John, of Kylkehampton, chaplain 1
5429010 2483598 2483598 defendant Hore Roger   617555 617555 Hore, Roger, of Kylkehampton, mason 0
5451006 2490192 2490192 defendant Dygon John fuller 617555 617555 Dygon, John, of Kylkehampton, fuller 1
5490216 2501959 2501959 plaintiff Benet John (legal representative) 617555 617555 Benet, John, of Kylkehampton, gent, executors of 0
5546711 2519038 2519038 defendant Wellys Richard butcher 617555 617555 Wellys, Richard, of Kylkehampton, butcher 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);