names

15 rows where case_id = 2173727

✎ 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
4428494 2173727 2173727 plaintiff Sturmy Henry     Sturmy, Henry 0
4428495 2173727 2173727 defendant atte Halle William   640203 640203 atte Halle, William, of Yatele 0
4428496 2173727 2173727 defendant Giffard John   640203 640203 Giffard, John, of Yatele 1
4428497 2173727 2173727 defendant Whyte John le   640203 640203 Whyte, John le, of Yatele 2
4428498 2173727 2173727 defendant (not given) William his brother   William, his brother 3
4428499 2173727 2173727 defendant Sellane John     Sellane, John 4
4428500 2173727 2173727 defendant (not given) John his son   John, his son 5
4428501 2173727 2173727 defendant atte Churche Ralph   640203 640203 atte Churche, Ralph, of Yatele 6
4428502 2173727 2173727 defendant Bocher Henry   602481 602481 Bocher, Henry, of Yateley 7
4428503 2173727 2173727 defendant Giffard William, junior     Giffard, William, junior 8
4428504 2173727 2173727 defendant atte Moure William   640203 640203 atte Moure, William, of Yatele 9
4428505 2173727 2173727 defendant Skel Thomas     Skel, Thomas 10
4428506 2173727 2173727 defendant atte Fourde John   640203 640203 atte Fourde, John, of Yatele 11
4428507 2173727 2173727 defendant Kach John   640203 640203 Kach, John, of Yatele 12
4428508 2173727 2173727 defendant Stedman Robert   754082 754082 Stedman, Robert, of Croundale 13

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