names
7 rows where case_id = 2235685
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 |
|---|---|---|---|---|---|---|---|---|
| 4614940 | 2235685 2235685 | plaintiff | Erl | William | (legal representative) | 755389 755389 | Erl, William, of Bishop's Lenn, burgess, executors of | 0 |
| 4614941 | 2235685 2235685 | plaintiff | Erl | Katherine | formerly wife of William | (Erl, Katherine, formerly wife of William | 1 | |
| 4614942 | 2235685 2235685 | plaintiff | Chaumpeneys | William | 774698 774698 | Chaumpeneys, William, of Scharyngburne | 2 | |
| 4614943 | 2235685 2235685 | plaintiff | (not given) | Nicholas | prior of Lovell | 755389 755389 | Lovell, Nicholas, of Bishop's Lenn, prior of the fraternity of St Augustine | 3 |
| 4614944 | 2235685 2235685 | plaintiff | Schuldam | John | another brother in the same fraternity | Schuldam, John, another brother in the same fraternity | 4 | |
| 4614945 | 2235685 2235685 | defendant | Spicer | John | 600289 600289 | Spicer, John, of Lenne | 0 | |
| 4614946 | 2235685 2235685 | defendant | Rochefort | Henry | Rochefort, Henry | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);