names

21 rows where case_id = 2358339

✎ 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
5004918 2358339 2358339 plaintiff Raynward William     Raynward, William 0
5004919 2358339 2358339 defendant Morys William     Morys, William 0
5004920 2358339 2358339 defendant Bussell John     Bussell, John 1
5004921 2358339 2358339 defendant Taillour Lawrence     Taillour, Lawrence 2
5004922 2358339 2358339 defendant Godyn Thomas     Godyn, Thomas 3
5004923 2358339 2358339 defendant Makwell Stephen     Makwell, Stephen 4
5004924 2358339 2358339 defendant Smyth Nicholas     Smyth, Nicholas 5
5004925 2358339 2358339 defendant Kent William     Kent, William 6
5004926 2358339 2358339 defendant Janyn John     Janyn, John 7
5004927 2358339 2358339 defendant Jolyf Odo     Jolyf, Odo 8
5004928 2358339 2358339 defendant Dey Richard     Dey, Richard 9
5004929 2358339 2358339 defendant Carowe John     Carowe, John 10
5004930 2358339 2358339 defendant Cren John     Cren, John 11
5004931 2358339 2358339 defendant Gelet Edward     Gelet, Edward 12
5004932 2358339 2358339 defendant Denys Thomas     Denys, Thomas 13
5004933 2358339 2358339 defendant Whitchurch John     Whitchurch, John 14
5004934 2358339 2358339 defendant all of Padstow   husbandman   all of Padstow, husbandman 15
5004935 2358339 2358339 defendant Trevethen Ralph husbandman 616741 616741 Trevethen, Ralph, of Trevethen, husbandman 16
5004936 2358339 2358339 defendant Anda Walter husbandman 655935 655935 Anda, Walter, of Padstow, husbandman 17
5004937 2358339 2358339 defendant Trethelowe John husbandman 833782 833782 Trethelowe, John, of Trethelowe, husbandman 18
5004938 2358339 2358339 defendant Goof John husbandman 833782 833782 Goof, John, of Trethelowe, husbandman 19

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