names

16 rows where case_id = 2208373

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4525814 2208373 2208373 plaintiff Kaynes John formerly sheriff of Devon   Kaynes, John, formerly sheriff of Devon 0
4525815 2208373 2208373 defendant Mountesdon Richard     Mountesdon, Richard 0
4525816 2208373 2208373 defendant Herston Richard     Herston, Richard 1
4525817 2208373 2208373 defendant Tydeby Thomas     Tydeby, Thomas 2
4525818 2208373 2208373 defendant Helyer Walter   599723 599723 Helyer, Walter, of Plympton 3
4525819 2208373 2208373 defendant Porton William     Porton, William 4
4525820 2208373 2208373 defendant Burnard Richard     Burnard, Richard 5
4525821 2208373 2208373 defendant Velecote David     Velecote, David 6
4525822 2208373 2208373 defendant More John     More, John 7
4525823 2208373 2208373 defendant Batecombe John     Batecombe, John 8
4525824 2208373 2208373 defendant Mounte John     Mounte, John 9
4525825 2208373 2208373 defendant Folsflo John     Folsflo, John 10
4525826 2208373 2208373 defendant Halewille John     Halewille, John 11
4525827 2208373 2208373 defendant Lucy John     Lucy, John 12
4525828 2208373 2208373 defendant Cruys John     Cruys, John 13
4525829 2208373 2208373 defendant Godechyld John     Godechyld, John 14

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