names

28 rows where place_id = 639101

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3846840 1972563 1972563 defendant Fakrell Thomas husbandman 639101 639101 Fakrell, Thomas, of Leng, husbandman 0
3846841 1972563 1972563 defendant Colens William butcher 639101 639101 Colens, William, of Leng, butcher 1
3846842 1972563 1972563 defendant Tomson William smith 639101 639101 Tomson, William, of Leng, smith 2
3846843 1972563 1972563 defendant Farkerell John husbandman 639101 639101 Farkerell, John, of Leng, husbandman 3
3846844 1972563 1972563 defendant Saunders Thomas husbandman 639101 639101 Saunders, Thomas, of Leng, husbandman 4
3846845 1972563 1972563 defendant Hoper William husbandman 639101 639101 Hoper, William, of Leng, husbandman 5
3846846 1972563 1972563 defendant Lovyn John tailor 639101 639101 Lovyn, John, of Leng, tailor 6
3846847 1972563 1972563 defendant Uriam Richard carpenter 639101 639101 Uriam, Richard, of Leng, carpenter 7
3846848 1972563 1972563 defendant Andro Richard   639101 639101 Andro, Richard, of Leng 8
3846849 1972563 1972563 defendant Walford John husbandman 639101 639101 Walford, John, of Leng, husbandman 9
3846861 1972564 1972564 defendant Dakman Richard husbandman 639101 639101 Dakman, Richard, of Leng, husbandman 0
3846862 1972564 1972564 defendant Stansbery Thomas husbandman 639101 639101 Stansbery, Thomas, of Leng, husbandman 1
3846863 1972564 1972564 defendant Cade Henry husbandman 639101 639101 Cade, Henry, of Leng, husbandman 2
3846864 1972564 1972564 defendant Keyberd John husbandman 639101 639101 Keyberd, John, of Leng, husbandman 3
3846865 1972564 1972564 defendant Millys William, junior husbandman 639101 639101 Millys, William, junior, of Leng, husbandman 4
3846866 1972564 1972564 defendant Captem John husbandman 639101 639101 Captem, John, of Leng, husbandman 5
3846867 1972564 1972564 defendant Hoggys Henry tailor 639101 639101 Hoggys, Henry, of Leng, tailor 6
3846868 1972564 1972564 defendant Seryll Richard husbandman 639101 639101 Seryll, Richard, of Leng, husbandman 7
3846869 1972564 1972564 defendant Fakerell Richard husbandman 639101 639101 Fakerell, Richard, of Leng, husbandman 8
3846870 1972564 1972564 defendant Fakerell Thomas, senior husbandman 639101 639101 Fakerell, Thomas, senior, of Leng, husbandman 9
3846871 1972564 1972564 defendant Dyty William husbandman 639101 639101 Dyty, William, of Leng, husbandman 10
3846872 1972564 1972564 defendant Symond John husbandman 639101 639101 Symond, John, of Leng, husbandman 11
3846873 1972564 1972564 defendant Benet William husbandman 639101 639101 Benet, William, of Leng, husbandman 12
3846874 1972564 1972564 defendant Cosen William husbandman 639101 639101 Cosen, William, of Leng, husbandman 13
3846875 1972564 1972564 defendant Gade William husbandman 639101 639101 Gade, William, of Leng, husbandman 14
3846876 1972564 1972564 defendant Cade William husbandman 639101 639101 Cade, William, of Leng, husbandman 15
3846877 1972564 1972564 defendant Mylys William, senior husbandman 639101 639101 Mylys, William, senior, of Leng, husbandman 16
3846878 1972564 1972564 defendant Gebynes John carpenter 639101 639101 Gebynes, John, of Leng, carpenter 17

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