names

13 rows where case_id = 2365187

✎ 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
5028391 2365187 2365187 plaintiff Moreton Richard gent 714689 714689 Moreton, Richard, of Moreton, Cheshire, gent 0
5028392 2365187 2365187 defendant Meer John yeoman 810589 810589 Meer, John, of Monyassh, Derbs, yeoman 0
5028393 2365187 2365187 defendant Tag Roger yeoman 835804 835804 Tag, Roger, of Tadyngton, Derbs, yeoman 1
5028394 2365187 2365187 defendant Brodehurst William yeoman 836974 836974 Brodehurst, William, of Over Haddon, Derbs, yeoman 2
5028395 2365187 2365187 defendant Gilberd Nicholas gent 608946 608946 Gilberd, Nicholas, of Yolgreve, Derbs, gent 3
5028396 2365187 2365187 defendant Wayne Richard yeoman 836975 836975 Wayne, Richard, of Staunton, Derbs, yeoman 4
5028397 2365187 2365187 defendant Mariote Thomas yeoman 593513 593513 Mariote, Thomas, of Staunton, yeoman 5
5028398 2365187 2365187 defendant Steverdale Richard yeoman 593513 593513 Steverdale, Richard, of Staunton, yeoman 6
5028399 2365187 2365187 defendant White John yeoman 836976 836976 White, John, of Longesdon, Derbs, yeoman 7
5028400 2365187 2365187 defendant Ruchardson James yeoman 836977 836977 Ruchardson, James, of Wardelowe, Derbs, yeoman 8
5028401 2365187 2365187 defendant Wilkesson Roger yeoman 836978 836978 Wilkesson, Roger, of Prestcliffe, Derbs, yeoman 9
5028402 2365187 2365187 defendant Sawer Richard yeoman 752282 752282 Sawer, Richard, of Ambaston, Derbs, yeoman 10
5028403 2365187 2365187 defendant Fawell Thomas yeoman 836979 836979 Fawell, Thomas, of Willesthorp, Derbs, yeoman 11

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