names

18 rows where case_id = 2176100

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4436308 2176100 2176100 plaintiff Sansemer John   756077 756077 Sansemer, John, of Maneweden 0
4436309 2176100 2176100 defendant Sansemer Thomas     Sansemer, Thomas 0
4436310 2176100 2176100 defendant Burgeys Richard   756286 756286 Burgeys, Richard, of Breggeford 1
4436311 2176100 2176100 defendant Raas Agnes     Raas, Agnes 2
4436312 2176100 2176100 defendant Byngham Hugh de son of Robert   Byngham, Hugh de, son of Robert 3
4436313 2176100 2176100 defendant Averyl Simon     Averyl, Simon 4
4436314 2176100 2176100 defendant Audeby Thomas clerk   Audeby, Thomas, clerk 5
4436315 2176100 2176100 defendant Forster Hugh clerk   Forster, Hugh, clerk 6
4436316 2176100 2176100 defendant Burre Thomas   586778 586778 Burre, Thomas, of Byngham 7
4436317 2176100 2176100 defendant Grys Geoffrey     Grys, Geoffrey 8
4436318 2176100 2176100 defendant Cotel Henry     Cotel, Henry 9
4436319 2176100 2176100 defendant Chapman Robert     Chapman, Robert 10
4436320 2176100 2176100 defendant Waget Ellis     Waget, Ellis 11
4436321 2176100 2176100 defendant Laurence Thomas     Laurence, Thomas 12
4436322 2176100 2176100 defendant atte Hyll Thomas     atte Hyll, Thomas 13
4436323 2176100 2176100 defendant Buntyng Maud     Buntyng, Maud 14
4436324 2176100 2176100 defendant Yonge William     Yonge, William 15
4436325 2176100 2176100 defendant Yonge Henry     Yonge, Henry 16

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