names
5 rows where case_id = 2034592
This data as json, CSV (advanced)
Suggested facets: role, surname, place_id, seq
| id ▼ | case_id | role | surname | forename | occupation | place_id | raw_segment | seq |
|---|---|---|---|---|---|---|---|---|
| 4027798 | 2034592 2034592 | plaintiff | Cock or Coxe | Charles | gent | Cock or Coxe, Charles, gent | 0 | |
| 4027799 | 2034592 2034592 | defendant | Barry | Thomas | gent | 672157 672157 | Barry, Thomas, of Skenfreth, gent | 0 |
| 4027800 | 2034592 2034592 | defendant | Barry | John | gent | 677606 677606 | Barry, John, of Cledock, Herefs, gent | 1 |
| 4027801 | 2034592 2034592 | defendant | Barry | Hugh | gent | 672157 672157 | Barry, Hugh, of Skenfreth, gent | 2 |
| 4027802 | 2034592 2034592 | defendant | Lewys | Thomas Richard | gent | 672157 672157 | Lewys, Thomas Richard, of Skenfreth, gent | 3 |
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);