names

21 rows where case_id = 1972563

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3846839 1972563 1972563 plaintiff Gylberd George esq   Gylberd, George, esq 0
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
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

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