names

30 rows where case_id = 1972564

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3846860 1972564 1972564 plaintiff Gylbert George esq   Gylbert, George, esq 0
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
3846879 1972564 1972564 defendant Shepard Walter   598270 598270 Shepard, Walter, of Bokelond, cook 18
3846880 1972564 1972564 defendant Barstabull James husbandman 614917 614917 Barstabull, James, of Petherton, husbandman 19
3846881 1972564 1972564 defendant Howlege Jenken husbandman 614917 614917 Howlege, Jenken, of Petherton, husbandman 20
3846882 1972564 1972564 defendant Emerley John husbandman 614917 614917 Emerley, John, of Petherton, husbandman 21
3846883 1972564 1972564 defendant Classe John husbandman 614917 614917 Classe, John, of Petherton, husbandman 22
3846884 1972564 1972564 defendant Batt Stephen husbandman 614917 614917 Batt, Stephen, of Petherton, husbandman 23
3846885 1972564 1972564 defendant Raff Richard, junior husbandman 614917 614917 Raff, Richard, junior, of Petherton, husbandman 24
3846886 1972564 1972564 defendant Potter Marmaduke husbandman 614917 614917 Potter, Marmaduke, of Petherton, husbandman 25
3846887 1972564 1972564 defendant Spaniell John husbandman 614917 614917 Spaniell, John, of Petherton, husbandman 26
3846888 1972564 1972564 defendant Coke Henry husbandman 614917 614917 Coke, Henry, of Petherton, husbandman 27
3846889 1972564 1972564 defendant Weyffer John husbandman 614917 614917 Weyffer, John, of Petherton, husbandman 28

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