names

17 rows where case_id = 2405555

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5165152 2405555 2405555 plaintiff Bate John clerk 591261 591261 Bate, John, of Tamworth, Staffs, clerk 0
5165153 2405555 2405555 defendant Pole Henry esq 855211 855211 Pole, Henry, of Radburn, Derbs, esq 0
5165154 2405555 2405555 defendant Punt Henry   590576 590576 Punt, Henry, of Assheburn, Derbs, attorney 1
5165155 2405555 2405555 defendant Hylton Robert yeoman 593362 593362 Hylton, Robert, of Radburn, yeoman 2
5165156 2405555 2405555 defendant Hasard Richard   855213 855213 Hasard, Richard, of Stretton in the Feld, Derbs, parson 3
5165157 2405555 2405555 defendant Longford Edward esq 697995 697995 Longford, Edward, of Snareston, Leics, esq 4
5165158 2405555 2405555 defendant Tempull Nicholas esq 654978 654978 Tempull, Nicholas, of Leicester, Leics, esq 5
5165159 2405555 2405555 defendant Charnels William esq 697995 697995 Charnels, William, of Snareston, Leics, esq 6
5165160 2405555 2405555 defendant Hunt John yeoman 855214 855214 Hunt, John, of Whapston, Leics, yeoman 7
5165161 2405555 2405555 defendant Burgolen John yeoman 855215 855215 Burgolen, John, of Neweton Burgolen, Leics, yeoman 8
5165162 2405555 2405555 defendant Gylot John yeoman 855216 855216 Gylot, John, of Nethers Hayle, yeoman 9
5165163 2405555 2405555 defendant Broun John yeoman 783487 783487 Broun, John, of Norburgh, Leics, yeoman 10
5165164 2405555 2405555 defendant Swynfeld William gent 824631 824631 Swynfeld, William, of Sutton, Leics, gent 11
5165165 2405555 2405555 defendant Sutton William gent 586543 586543 Sutton, William, of Osbaston, Leics, gent 12
5165166 2405555 2405555 defendant Balle Robert yeoman 630389 630389 Balle, Robert, of Osbaston, yeoman 13
5165167 2405555 2405555 defendant Langham Richard gent 855217 855217 Langham, Richard, of Kelby, Leics, gent 14
5165168 2405555 2405555 defendant Brette John husbandman 855218 855218 Brette, John, of Rotherby, Leics, husbandman 15

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