names

13 rows where case_id = 2365188

✎ 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
5028404 2365188 2365188 plaintiff Moreton Richard gent 714689 714689 Moreton, Richard, of Moreton, Cheshire, gent 0
5028405 2365188 2365188 defendant Moer or Meer John yeoman 810589 810589 Moer or Meer, John, of Monyassh, Derbs, yeoman 0
5028406 2365188 2365188 defendant Tag Roger yeoman 835804 835804 Tag, Roger, of Tadyngton, Derbs, yeoman 1
5028407 2365188 2365188 defendant Brodehurst William yeoman 836974 836974 Brodehurst, William, of Over Haddon, Derbs, yeoman 2
5028408 2365188 2365188 defendant Gilberd Nicholas gent 608946 608946 Gilberd, Nicholas, of Yolgreve, Derbs, gent 3
5028409 2365188 2365188 defendant Wayne Richard yeoman 836975 836975 Wayne, Richard, of Staunton, Derbs, yeoman 4
5028410 2365188 2365188 defendant Mariote Thomas yeoman 593513 593513 Mariote, Thomas, of Staunton, yeoman 5
5028411 2365188 2365188 defendant Steverdale Richard yeoman 593513 593513 Steverdale, Richard, of Staunton, yeoman 6
5028412 2365188 2365188 defendant White John yeoman 836976 836976 White, John, of Longesdon, Derbs, yeoman 7
5028413 2365188 2365188 defendant Richardson James yeoman 836977 836977 Richardson, James, of Wardelowe, Derbs, yeoman 8
5028414 2365188 2365188 defendant Wilkesson Roger yeoman 836980 836980 Wilkesson, Roger, of Prestclyffe, Derbs, yeoman 9
5028415 2365188 2365188 defendant Sawer Richard yeoman 752282 752282 Sawer, Richard, of Ambaston, Derbs, yeoman 10
5028416 2365188 2365188 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);