names

21 rows where case_id = 1941706

✎ View and edit SQL

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
3749282 1941706 1941706 plaintiff (not given) Robert abbot of Holmecaltrone Abbey   Holmecaltrone Abbey, Robert, abbot of 0
3749283 1941706 1941706 defendant Pereson William husbandman 613865 613865 Pereson, William, of Seton, husbandman 0
3749284 1941706 1941706 defendant Whelewright William husbandman 620903 620903 Whelewright, William, of Derham, husbandman 1
3749285 1941706 1941706 defendant Martyndale Simon husbandman 620903 620903 Martyndale, Simon, of Derham, husbandman 2
3749286 1941706 1941706 defendant Falshed Henry husbandman 620903 620903 Falshed, Henry, of Derham, husbandman 3
3749287 1941706 1941706 defendant Parke John husbandman 620903 620903 Parke, John, of Derham, husbandman 4
3749288 1941706 1941706 defendant Tempe John husbandman 620903 620903 Tempe, John, of Derham, husbandman 5
3749289 1941706 1941706 defendant Bell William husbandman   Bell, William, husbandman 6
3749290 1941706 1941706 defendant Watson John husbandman   Watson, John, husbandman 7
3749291 1941706 1941706 defendant Wilson John husbandman   Wilson, John, husbandman 8
3749292 1941706 1941706 defendant Drape William husbandman   Drape, William, husbandman 9
3749293 1941706 1941706 defendant Halle Robert husbandman   Halle, Robert, husbandman 10
3749294 1941706 1941706 defendant Lyster John husbandman   Lyster, John, husbandman 11
3749295 1941706 1941706 defendant Thursby John husbandman   Thursby, John, husbandman 12
3749296 1941706 1941706 defendant Clerke Thomas husbandman 622860 622860 Clerke, Thomas, of Vurigge, husbandman 13
3749297 1941706 1941706 defendant Robynson John husbandman   Robynson, John, husbandman 14
3749298 1941706 1941706 defendant Browne Thomas husbandman 622861 622861 Browne, Thomas, of Alneburgh, husbandman 15
3749299 1941706 1941706 defendant Man John husbandman   Man, John, husbandman 16
3749300 1941706 1941706 defendant Bell Thomas husbandman   Bell, Thomas, husbandman 17
3749301 1941706 1941706 defendant Pereson John husbandman   Pereson, John, husbandman 18
3749302 1941706 1941706 defendant Pereson Simon husbandman   Pereson, Simon, husbandman 19

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