names
11 rows where case_id = 1956619
This data as json, CSV (advanced)
Suggested facets: role, surname, forename, occupation, place_id, seq
| id ▼ | case_id | role | surname | forename | occupation | place_id | raw_segment | seq |
|---|---|---|---|---|---|---|---|---|
| 3796022 | 1956619 1956619 | plaintiff | Docwra | Martin | Docwra, Martin | 0 | ||
| 3796023 | 1956619 1956619 | defendant | Porter | Henry | gent | 603002 603002 | Porter, Henry, of Clerkenwell, Middx, gent | 0 |
| 3796024 | 1956619 1956619 | defendant | Dowce | Baldwin | husbandman | 586497 586497 | Dowce, Baldwin, of Barston, husbandman | 1 |
| 3796025 | 1956619 1956619 | defendant | Ebrall | Philip | husbandman | 586579 586579 | Ebrall, Philip, of Balsall, husbandman | 2 |
| 3796026 | 1956619 1956619 | defendant | Clerk | John, junior | husbandman | 586579 586579 | Clerk, John, junior, of Balsall, husbandman | 3 |
| 3796027 | 1956619 1956619 | defendant | Ferrour | Thomas | husbandman | 586579 586579 | Ferrour, Thomas, of Balsall, husbandman | 4 |
| 3796028 | 1956619 1956619 | defendant | Ebrall | Thomas | husbandman | 586579 586579 | Ebrall, Thomas, of Balsall, husbandman | 5 |
| 3796029 | 1956619 1956619 | defendant | Marsshe | Thomas | husbandman | 586579 586579 | Marsshe, Thomas, of Balsall, husbandman | 6 |
| 3796030 | 1956619 1956619 | defendant | Berwell | John | husbandman | 586579 586579 | Berwell, John, of Balsall, husbandman | 7 |
| 3796031 | 1956619 1956619 | defendant | Nytynghall | William | husbandman | 586497 586497 | Nytynghall, William, of Barston, husbandman | 8 |
| 3796032 | 1956619 1956619 | defendant | Massy | John | husbandman | 586497 586497 | Massy, John, of Barston, husbandman | 9 |
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);