names

17 rows where case_id = 2521403

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5554783 2521403 2521403 plaintiff Hobart James knight   Hobart, James, knight 0
5554784 2521403 2521403 defendant Nobyll Thomas gent 590317 590317 Nobyll, Thomas, of Dorchester, Dorset, gent 0
5554785 2521403 2521403 defendant Knyght Thomas gent 589851 589851 Knyght, Thomas, of Dorchester, gent 1
5554786 2521403 2521403 defendant Neweman Roger yeoman 899537 899537 Neweman, Roger, of Wymborn St Giles, Sorset, yeoman 2
5554787 2521403 2521403 defendant Smyth William yeoman 595117 595117 Smyth, William, of Everley, Wilts, yeoman 3
5554788 2521403 2521403 defendant Beskeney John yeoman 633554 633554 Beskeney, John, of Everley, yeoman 4
5554789 2521403 2521403 defendant Chamber William yeoman 759727 759727 Chamber, William, of Ammesbury, Wilts, yeoman 5
5554790 2521403 2521403 defendant Pashlewe Alexander gent 899538 899538 Pashlewe, Alexander, of Riddeleston, Yorks, gent 6
5554791 2521403 2521403 defendant Cokker John yeoman 899539 899539 Cokker, John, of Berkeley, Warks, yeoman 7
5554792 2521403 2521403 defendant Warde Richard yeoman 586731 586731 Warde, Richard, of Wakefeld, Yorks, yeoman 8
5554793 2521403 2521403 defendant Johnson Simon gent 585869 585869 Johnson, Simon, of London, gent 9
5554794 2521403 2521403 defendant Boswell James gent 779749 779749 Boswell, James, of Ardesley, Yorks, gent 10
5554795 2521403 2521403 defendant Deconson William yeoman 586887 586887 Deconson William, of Wakefeld, yeoman 11
5554796 2521403 2521403 defendant Burton John clerk 899540 899540 Burton, John, of Landaff, Wales, clerk 12
5554797 2521403 2521403 defendant Jenyns Edward clerk 597943 597943 Jenyns, Edward, of Monmouth, Wales, clerk 13
5554798 2521403 2521403 defendant Marchall John Bishop of Landaff   Marchall, John, Bishop of Landaff, executor of 14
5554799 2521403 2521403 defendant Anger or Auger Thomas gent 739025 739025 Anger or Auger, Thomas, of Landaff, gent 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);