names

8 rows where place_id = 616095

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3712496 1930225 1930225 defendant Champneys Joan widow 616095 616095 Champneys, Joan, of Frome Selwoode, widow 0
3883820 1984855 1984855 defendant Coke John merchant 616095 616095 Coke, John, of Frome Selwoode, merchant 0
4110650 2064066 2064066 defendant Newman Edmund yeoman 616095 616095 Newman. Edmund, of Frome Selwoode, yeoman 0
4181095 2088862 2088862 defendant Whytmor Ralph blacksmith 616095 616095 Whytmor, Ralph, of Frome Selwoode, blacksmith 1
4303282 2131277 2131277 defendant Chepman William clothier 616095 616095 Chepman, William, of Frome Selwoode, clothier 0
4386998 2160307 2160307 defendant Frowde Richard yeoman 616095 616095 Frowde, Richard, of Frome Selwoode, yeoman 0
5385842 2471021 2471021 defendant _ase Thomas gent 616095 616095 _ase, Thomas, of Frome Selwoode, gent 0
5398153 2474540 2474540 defendant Webbe John husbandman 616095 616095 Webbe, John, of Frome Selwoode, husbandman 1

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