names

27 rows where place_id = 614917

✎ 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
3706249 1928242 1928242 defendant Denball William fisher 614917 614917 Denball, William, of Petherton, fisher 2
3835350 1968994 1968994 defendant Vrost William husbandman 614917 614917 Vrost, William, of Petherton, husbandman 2
3846850 1972563 1972563 defendant Howlege John   614917 614917 Howlege, John, of Petherton, groom 10
3846851 1972563 1972563 defendant Bette Robert husbandman 614917 614917 Bette, Robert, of Petherton, husbandman 11
3846852 1972563 1972563 defendant Conwey Henry husbandman 614917 614917 Conwey, Henry, of Petherton, husbandman 12
3846853 1972563 1972563 defendant Barstabull John husbandman 614917 614917 Barstabull, John, of Petherton, husbandman 13
3846854 1972563 1972563 defendant Carpenter John husbandman 614917 614917 Carpenter, John, of Petherton, husbandman 14
3846855 1972563 1972563 defendant Raulens Robert husbandman 614917 614917 Raulens, Robert, of Petherton, husbandman 15
3846856 1972563 1972563 defendant Raphe Richard husbandman 614917 614917 Raphe, Richard, of Petherton, husbandman 16
3846857 1972563 1972563 defendant Cabull Robert husbandman 614917 614917 Cabull, Robert, of Petherton, husbandman 17
3846858 1972563 1972563 defendant Templer Walter husbandman 614917 614917 Templer, Walter, of Petherton, husbandman 18
3846859 1972563 1972563 defendant Seryll John husbandman 614917 614917 Seryll, John, of Petherton, husbandman 19
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
3983666 2018927 2018927 defendant Wodhowse William yeoman 614917 614917 Wodhowse, William, of Petherton, yeoman 0
4016863 2030729 2030729 defendant Hoell William husbandman 614917 614917 Hoell, William, of Petherton, husbandman 0
4054521 2044007 2044007 defendant Worthe Thomas gent 614917 614917 Worthe, Thomas, of Petherton, gent 0
4059866 2045925 2045925 defendant Younge William butcher 614917 614917 Younge, William, of Petherton, butcher 0
5583762 2529996 2529996 defendant Case William (legal representative) 614917 614917 Case, William, of Petherton, executrix of 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);