names

19 rows where place_id = 596955

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626751 1903212 1903212 defendant Tudbole John yeoman 596955 596955 Tudbole, John, of Lyme, Dorset, yeoman 0
3643615 1908433 1908433 defendant Dare William merchant 596955 596955 Dare, William, of Lyme, Dorset, merchant 1
3746283 1940747 1940747 defendant Phylyppys Robert merchant 596955 596955 Phylyppys, Robert, of Lyme, Dorset, merchant 1
3765550 1946886 1946886 defendant Pleye Richard merchant 596955 596955 Pleye, Richard, of Lyme, Dorset, merchant 0
3916232 1995813 1995813 defendant Tudbolde William merchant 596955 596955 Tudbolde, William, of Lyme, Dorset, merchant 4
3973198 2015196 2015196 defendant Whetecombe William merchant 596955 596955 Whetecombe, William, of Lyme, Dorset, merchant 1
3981080 2017992 2017992 defendant Moone Robert gent 596955 596955 Moone, Robert, of Lyme, Dorset, gent 3
4013967 2029730 2029730 defendant Hayne Silvester chapman 596955 596955 Hayne, Silvester, of Lyme, Dorset, chapman 0
4020363 2032004 2032004 defendant Hayne Silvester chapman 596955 596955 Hayne, Silvester, of Lyme, Dorset, chapman 1
4084522 2054742 2054742 defendant Garland John merchant 596955 596955 Garland, John, of Lyme, Dorset, merchant 0
4107035 2062813 2062813 defendant Garlande John merchant 596955 596955 Garlande, John, of Lyme, Dorset, merchant 0
4158727 2081126 2081126 defendant Garland John merchant 596955 596955 Garland, John, of Lyme, Dorset, merchant 0
4158729 2081127 2081127 defendant Garland John merchant 596955 596955 Garland, John, of Lyme, Dorset, merchant 0
4411973 2168599 2168599 defendant Legge William draper 596955 596955 Legge, William, of Lyme, Dorset, draper 1
4848085 2310869 2310869 defendant Stykelane Thomas merchant 596955 596955 Stykelane, Thomas, of Lyme, Dorset, merchant 0
5287332 2441317 2441317 defendant Stykland Thomas merchant 596955 596955 Stykland, Thomas, of Lyme, Dorset, merchant 1
5606237 2536844 2536844 defendant Dare William merchant 596955 596955 Dare, William, of Lyme, Dorset, merchant 0
5606239 2536845 2536845 defendant Dare William merchant 596955 596955 Dare, William, of Lyme, Dorset, merchant 0
5635127 2554964 2554964 defendant Tyneham John gent 596955 596955 Tyneham, John, of Lyme, Dorset, 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);