names

8 rows where case_id = 1911584

✎ 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
3654231 1911584 1911584 plaintiff Aragon Katherine of Queen of England   Aragon, Katherine of, Queen of England 0
3654232 1911584 1911584 defendant Mile Edward esq 603339 603339 Mile, Edward, of Harscombe, esq 0
3654233 1911584 1911584 defendant Gardener Thomas husbandman 603339 603339 Gardener, Thomas, of Harscombe, husbandman 1
3654234 1911584 1911584 defendant Bruge George yeoman 603339 603339 Bruge, George, of Harscombe, yeoman 2
3654235 1911584 1911584 defendant Jenns Thomas yeoman 603340 603340 Jenns, Thomas, of Harffeld, yeoman 3
3654236 1911584 1911584 defendant Newyngton Hugh   603341 603341 Newyngton, Hugh, of Brokehorn, minstrell 4
3654237 1911584 1911584 defendant Lews Richard   603342 603342 Lews, Richard, of Payneswike, shoe maker 5
3654238 1911584 1911584 defendant Barde Thomas yeoman 603340 603340 Barde, Thomas, of Harffeld, yeoman 6

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