names

14 rows where case_id = 2536936

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5606551 2536936 2536936 plaintiff Tredenek Robert     Tredenek, Robert 0
5606552 2536936 2536936 defendant Laa John yeoman 905240 905240 Laa, John, of Lalyverey, yeoman 0
5606553 2536936 2536936 defendant Walshe John yeoman 905241 905241 Walshe, John, of Luxelyen, yeoman 1
5606554 2536936 2536936 defendant Penhale John yeoman 905242 905242 Penhale, John, of Luxelyan, yeoman 2
5606555 2536936 2536936 defendant Avryan Thomas yeoman 905242 905242 Avryan, Thomas, of Luxelyan, yeoman 3
5606556 2536936 2536936 defendant Roche John yeoman 824539 824539 Roche, John, of Tregenetha, yeoman 4
5606557 2536936 2536936 defendant Hyll John yeoman 905243 905243 Hyll, John, of Luxelian, yeoman 5
5606558 2536936 2536936 defendant Trebylcok Odo yeoman 598344 598344 Trebylcok, Odo, of Roche, yeoman 6
5606559 2536936 2536936 defendant Carne or Carve John yeoman 606712 606712 Carne or Carve, John, of Luxulyan, yeoman 7
5606560 2536936 2536936 defendant Goly John yeoman 840888 840888 Goly, John, of Lanevet, yeoman 8
5606561 2536936 2536936 defendant July or Inly John yeoman 606712 606712 July or Inly, John, of Luxulyan, yeoman 9
5606562 2536936 2536936 defendant Vean Richard yeoman 599163 599163 Vean, Richard, of St Austell, yeoman 10
5606563 2536936 2536936 defendant Crerowe Michael yeoman 606712 606712 Crerowe, Michael, of Luxulyan, yeoman 11
5606564 2536936 2536936 defendant Staby Benedict yeoman 774818 774818 Staby, Benedict, of Melsa, yeoman 12

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