names

13 rows where case_id = 2185562

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4451860 2185562 2185562 plaintiff Hugeford William     Hugeford, William 0
4451861 2185562 2185562 defendant Bicke Richard   758164 758164 Bicke, Richard, of Pikkeshull 0
4451862 2185562 2185562 defendant Crisp William   588385 588385 Crisp, William, of Steventon 1
4451863 2185562 2185562 defendant Crisp Richard   588385 588385 Crisp, Richard, of Steventon 2
4451864 2185562 2185562 defendant Tayllour Richard   588385 588385 Tayllour, Richard, of Steventon 3
4451865 2185562 2185562 defendant Taillour Robert   758165 758165 Taillour, Robert, of Steveneton 4
4451866 2185562 2185562 defendant Smyth Robert   623985 623985 Smyth, Robert, of Felmersham 5
4451867 2185562 2185562 defendant Smyth John   770542 770542 Smyth, John, of Felmesham, son of Robert 6
4451868 2185562 2185562 defendant Fysshere William   589856 589856 Fysshere, William, of Pakenham 7
4451869 2185562 2185562 defendant Fysshere Richard   589856 589856 Fysshere, Richard, of Pakenham, son of William 8
4451870 2185562 2185562 defendant Dalot John   588385 588385 Dalot, John, of Steventon 9
4451871 2185562 2185562 defendant Ballard William   589856 589856 Ballard, William, of Pakenham 10
4451872 2185562 2185562 defendant atte Hull William   588385 588385 atte Hull, William, of Steventon 11

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