names

30 rows where place_id = 586534

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588971 1864200 1864200 defendant Talmage John esq 586534 586534 Talmage, John, of Helmyngham, Suff, esq 1
3588979 1864203 1864203 defendant Talmage John gent 586534 586534 (Talmage, John, of Helmyngham, Suff, gent 2
3617518 1873099 1873099 defendant Talmage John esq 586534 586534 Talmage, John, of Helmyngham, Suff, esq 0
3617988 1873249 1873249 defendant Bettys William carpenter 586534 586534 Bettys, William, of Helmyngham, Suff, carpenter 0
3618003 1873250 1873250 defendant Bett William carpenter 586534 586534 Bett, William, of Helmyngham, Suff, carpenter 2
3644341 1908648 1908648 defendant Talmage Robert gent 586534 586534 Talmage, Robert, of Helmyngham, Suff, gent 6
3671854 1917197 1917197 defendant Butte Henry husbandman 586534 586534 Butte, Henry, of Helmyngham, Suff, husbandman 0
3920119 1997063 1997063 defendant Wade Lionel husbandman 586534 586534 Wade, Lionel, of Helmyngham, Suff, husbandman 0
4160051 2081580 2081580 defendant Wade Henry yeoman 586534 586534 Wade, Henry, of Helmyngham, Suff, yeoman 0
4315945 2135689 2135689 defendant Telmache Lionel esq 586534 586534 Telmache, Lionel, of Helmyngham, Suff, esq 0
4978894 2350644 2350644 defendant Martyn John yeoman 586534 586534 Martyn, John, of Helmyngham, Suff, yeoman 0
5067128 2376690 2376690 defendant Joose James esq 586534 586534 Joose, James, of Helmyngham, Suff, esq 1
5067132 2376691 2376691 defendant Joose James esq 586534 586534 Joose, James, of Helmyngham, Suff, esq 1
5115160 2390856 2390856 defendant Semere John clerk 586534 586534 Semere, John, of Helmyngham, Suff, clerk 0
5161656 2404512 2404512 defendant Joce William esq 586534 586534 Joce, William, of Helmyngham, Suff, esq 0
5177697 2409171 2409171 defendant Joce William esq 586534 586534 Joce, William, of Helmyngham, Suff, esq 0
5186745 2411871 2411871 defendant Gybon William husbandman 586534 586534 Gybon, William, of Helmyngham, Suff, husbandman 4
5186747 2411872 2411872 defendant Martyn William (legal representative) 586534 586534 Martyn, William, of Helmyngham, Suff, laborer, executors of 0
5186753 2411873 2411873 defendant Martyn William (legal representative) 586534 586534 Martyn, William, of Helmyngham, Suff, laborer, executors of 0
5224783 2422917 2422917 defendant Joce William esq 586534 586534 Joce, William, of Helmyngham, Suff, esq 0
5355042 2461646 2461646 defendant Joce William gent 586534 586534 Joce, William, of Helmyngham, Suff, gent 1
5371578 2466697 2466697 defendant Joyce William esq 586534 586534 Joyce, William, of Helmyngham, Suff, esq 0
5400467 2475202 2475202 defendant Jote William esq 586534 586534 Jote, William, of Helmyngham, Suff, esq 0
5413465 2478953 2478953 defendant Martyn John yeoman 586534 586534 Martyn, John, of Helmyngham, Suff, yeoman 4
5428774 2483521 2483521 defendant Ingram William esq 586534 586534 Ingram, William, of Helmyngham, Suff, esq 0
5428778 2483521 2483521 defendant Martyn John yeoman 586534 586534 Martyn, John, of Helmyngham, Suff, yeoman 4
5428780 2483522 2483522 defendant Joo_ William esq 586534 586534 Joo_, William, of Helmyngham, Suff, esq 0
5428784 2483522 2483522 defendant Martyn John yeoman 586534 586534 Martyn, John, of Helmyngham, Suff, yeoman 4
5449298 2489679 2489679 defendant Wodward James yeoman 586534 586534 Wodward, James, of Helmyngham, Suff, yeoman 3
5601890 2535484 2535484 defendant Talmage Robert gent 586534 586534 Talmage, Robert, of Helmyngham, Suff, gent 2

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