names

17 rows where case_id = 1965666

✎ 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
3824885 1965666 1965666 plaintiff Wolcote John     Wolcote, John 0
3824886 1965666 1965666 defendant Man John husbandman 597587 597587 Man, John, of Chagford, husbandman 0
3824887 1965666 1965666 defendant Cremer John husbandman 597587 597587 Cremer, John, of Chagford, husbandman 1
3824888 1965666 1965666 defendant Potter William husbandman 597587 597587 Potter, William, of Chagford, husbandman 2
3824889 1965666 1965666 defendant Serle William husbandman 597587 597587 Serle, William, of Chagford, husbandman 3
3824890 1965666 1965666 defendant Lightfott William, senior husbandman 597587 597587 Lightfott, William, senior, of Chagford, husbandman 4
3824891 1965666 1965666 defendant Lightfott William, junior husbandman 597587 597587 Lightfott, William, junior, of Chagford, husbandman 5
3824892 1965666 1965666 defendant Tummeles John husbandman 635355 635355 Tummeles, John, of Egkysburne, husbandman 6
3824893 1965666 1965666 defendant Hore Richard husbandman 635355 635355 Hore, Richard, of Egkysburne, husbandman 7
3824894 1965666 1965666 defendant Baker Walter husbandman 635356 635356 Baker, Walter, of Dawlysche, husbandman 8
3824895 1965666 1965666 defendant Drewe John husbandman 635357 635357 Drewe, John, of Daddyscomblegh, husbandman 9
3824896 1965666 1965666 defendant Forde John husbandman 593181 593181 Forde, John, of Staverton, husbandman 10
3824897 1965666 1965666 defendant Elard John husbandman 611284 611284 Elard, John, of Alphyngton, husbandman 11
3824898 1965666 1965666 defendant Bremelcombe Mathew shoemaker 635358 635358 Bremelcombe, Mathew, of Wetherugge, shoemaker 12
3824899 1965666 1965666 defendant Ulfloe William tanner 587118 587118 Ulfloe, William, of Exilond, tanner 13
3824900 1965666 1965666 defendant Lyllecropp William butcher 608333 608333 Lyllecropp, William, of Stourton, butcher 14
3824901 1965666 1965666 defendant Ruggewey Thomasine widow 586036 586036 Ruggewey, Thomasine, of Exeter, widow 15

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