names

10 rows where case_id = 1905634

✎ 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
3634638 1905634 1905634 plaintiff More John sergeant at law   More, John, sergeant at law 0
3634639 1905634 1905634 plaintiff Fermoure William     Fermoure, William 1
3634640 1905634 1905634 plaintiff Trevethen John     Trevethen, John 2
3634641 1905634 1905634 plaintiff Goef Odo     Goef, Odo 3
3634642 1905634 1905634 plaintiff Wolvedon John clerk   Wolvedon, John, clerk 4
3634643 1905634 1905634 plaintiff Gayr Stephen     Gayr, Stephen 5
3634644 1905634 1905634 defendant Tredenek Christopher gent 598946 598946 Tredenek, Christopher, of Tredenek, gent 0
3634645 1905634 1905634 defendant Gylle William yeoman 598946 598946 Gylle, William, of Tredenek, yeoman 1
3634646 1905634 1905634 defendant Chauntrell Richard yeoman 598947 598947 Chauntrell, Richard, of Slade, Devon, yeoman 2
3634647 1905634 1905634 defendant Ralegh John yeoman 598948 598948 Ralegh, John, of Monsottrey, Devon, yeoman 3

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