names

17 rows where case_id = 1867671

✎ 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
3600056 1867671 1867671 plaintiff Wexman Thomas     Wexman, Thomas 0
3600057 1867671 1867671 defendant Lavender John tucker 588432 588432 Lavender, John, of Strodwater, tucker 0
3600058 1867671 1867671 defendant Badam William husbandman 590141 590141 Badam, William, of Dursley, husbandman 1
3600059 1867671 1867671 defendant Dobyns John yeoman 590142 590142 Dobyns, John, of Nether Sudyngton, yeoman 2
3600060 1867671 1867671 defendant Shere Thomas smith 590143 590143 Shere, Thomas, of Parva Dene, smith 3
3600061 1867671 1867671 defendant Paynyswyk John yeoman 586842 586842 Paynyswyk, John, of Cirencester, yeoman 4
3600062 1867671 1867671 defendant Jonys Thomas husbandman 590144 590144 Jonys, Thomas, of Over Sydyngton, husbandman 5
3600063 1867671 1867671 defendant Taillour William tailor 586842 586842 Taillour, William, of Cirencester, tailor 6
3600064 1867671 1867671 defendant Solas Richard husbandman 586842 586842 Solas, Richard, of Cirencester, husbandman 7
3600065 1867671 1867671 defendant Feyrantre Thomas husbandman 590145 590145 Feyrantre, Thomas, of Brymsfeld, husbandman 8
3600066 1867671 1867671 defendant Curteys James husbandman 590146 590146 Curteys, James, of Wynston, husbandman 9
3600067 1867671 1867671 defendant Tyler John tiler 585925 585925 Tyler, John, of Bristol, tiler 10
3600068 1867671 1867671 defendant Pryk Robert husbandman 590147 590147 Pryk, Robert, of Eggeworth, husbandman 11
3600069 1867671 1867671 defendant Frampton John husbandman 590148 590148 Frampton, John, of Paynyswyk, husbandman 12
3600070 1867671 1867671 defendant Mose Thomas weaver 586842 586842 Mose, Thomas, of Cirencester, weaver 13
3600071 1867671 1867671 defendant Bedyll Matilda widow 586842 586842 Bedyll, Matilda, of Cirencester, widow 14
3600072 1867671 1867671 defendant Mason John yeoman 586842 586842 Mason, John, of Cirencester, yeoman 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);