names

15 rows where case_id = 2170447

✎ 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
4417809 2170447 2170447 plaintiff Sturmy Henry     Sturmy, Henry 0
4417810 2170447 2170447 defendant atte Halle William   640203 640203 atte Halle, William, of Yatele 0
4417811 2170447 2170447 defendant Giffard John   640203 640203 Giffard, John, of Yatele 1
4417812 2170447 2170447 defendant White John le   640203 640203 White, John le, of Yatele 2
4417813 2170447 2170447 defendant (not given) William his brother   William, his brother 3
4417814 2170447 2170447 defendant Sellane John     Sellane, John 4
4417815 2170447 2170447 defendant John son of John     John, son of John 5
4417816 2170447 2170447 defendant atte Churche Ralph   640203 640203 atte Churche, Ralph, of Yatele 6
4417817 2170447 2170447 defendant Bocher Henry   640203 640203 Bocher, Henry, of Yatele 7
4417818 2170447 2170447 defendant Giffard William, junior     Giffard, William, junior 8
4417819 2170447 2170447 defendant atte Moure Gilbert   640203 640203 atte Moure, Gilbert, of Yatele 9
4417820 2170447 2170447 defendant Skel Thomas     Skel, Thomas 10
4417821 2170447 2170447 defendant atte Fourde Philip   640203 640203 atte Fourde, Philip, of Yatele 11
4417822 2170447 2170447 defendant Kach John le   640203 640203 Kach, John le, of Yatele 12
4417823 2170447 2170447 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);