names

32 rows where case_id = 2028315

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4009892 2028315 2028315 plaintiff Nycoll George esq, treasure of Middle Temple   Nycoll, George, esq, treasure of Middle Temple 0
4009893 2028315 2028315 defendant Alleyn John gent 673413 673413 Alleyn, John, of London, Davis Inn, gent, son of Thomas Alleyn, of Ipswich, gent 0
4009894 2028315 2028315 defendant Asheburneham John gent 669812 669812 Asheburneham, John, of London, Staple Inn, gent 1
4009895 2028315 2028315 defendant Braye Reginald   585869 585869 Braye, Reginald, of London, gent, son of Reginald Braye, of Barington, Glos 2
4009896 2028315 2028315 defendant Burbage Numan gent 673415 673415 Burbage, Numan, of Clement, Clements Inn, gent 3
4009897 2028315 2028315 defendant Bowland Richard esq 685185 685185 Bowland, Richard, of London, Lyons Inn, gent, son of Edward Howland, of Margetinge, Essex, esq 4
4009898 2028315 2028315 defendant Brame or Braine Elias gent 585869 585869 Brame or Braine, Elias, of London, or of Stocke Asshe, Suff, gent 5
4009899 2028315 2028315 defendant Cresseye Gervase gent 673418 673418 Cresseye, Gervase, of London, Davies Inn, gent 6
4009900 2028315 2028315 defendant Cresseye James gent 670115 670115 Cresseye, James, of London, Clements Inn, gent 7
4009901 2028315 2028315 defendant Cotton Thomas esq 585869 585869 Cotton, Thomas, of London, gent, son of Thomas Cotton, of Cunnington, Hynts, esq 8
4009902 2028315 2028315 defendant Clarke Thomas gent 673421 673421 Clarke, Thomas, of London, Clifford Inn, son of Edmund Clarke, of Michedevord, Hants, gent 9
4009903 2028315 2028315 defendant Crofte Edward   585869 585869 Crofte, Edward, of London, son of James Crofte, of Crofte, Herefs, knight 10
4009904 2028315 2028315 defendant Catlyn Robert gent 585869 585869 Catlyn, Robert, of London, gent, son of Thomas Catlyn, of Raundon, Nhants, gent 11
4009905 2028315 2028315 defendant Causfeild Thomas gent 671840 671840 Causfeild, Thomas, of London, of New Inn, gent 12
4009906 2028315 2028315 defendant Denton Alexander gent 670115 670115 Denton, Alexander, of London, Clements Inn, gent 13
4009907 2028315 2028315 defendant Denton Thomas esq 585869 585869 Denton, Thomas, of London, son of John Denton, of Ammonsdon, Oxon, esq 14
4009908 2028315 2028315 defendant Freman William gent 585869 585869 Freman, William, of London, gent, son of Thomas Freman, of Blockeley, Worcs, gent 15
4009909 2028315 2028315 defendant Fortescue Thomas gent 677122 677122 Fortescue, Thomas, of London, Cliffords Inn, gent 16
4009910 2028315 2028315 defendant Gifford Edward   671840 671840 Gifford, Edward, of London, New Inn, gent, son of Thomas Gifford, of Chillington, Staffs, knight 17
4009911 2028315 2028315 defendant Hopton William gent 585869 585869 Hopton, William, of London, or of Rockhill, Salop, gent 18
4009912 2028315 2028315 defendant Haber William gent 673430 673430 Haber, William, of London, Fornevales Inn, gent 19
4009913 2028315 2028315 defendant Hopkyns Richard gent 671840 671840 Hopkyns, Richard, of London, New Inn, gent, son of Richard Hopkyns, of Walsall, Staffs, gent 20
4009914 2028315 2028315 defendant Jermyne James   585869 585869 Jermyne, James, of London, gent, son of Ambrose Jermyne, of Rushbrooke, Suff, knight 21
4009915 2028315 2028315 defendant Joynour Andrew gent 677122 677122 Joynour, Andrew, of London, Cliffords Inn, gent 22
4009916 2028315 2028315 defendant Jefferys James gent 585869 585869 Jefferys, James, of London, son of William Jefferys, of Southampton, gent 23
4009917 2028315 2028315 defendant Kenton Edward gent 585869 585869 Kenton, Edward, of London, gent, son of William Kenton, of Radcliffe, Lancs, gent 24
4009918 2028315 2028315 defendant Knyvette Thomas esq 677122 677122 Knyvette, Thomas, of London, Cliffords Inn, gent, son of John Knyvette, of Buckenham, Norf, esq 25
4009919 2028315 2028315 defendant Mockett Timothy gent 585869 585869 Mockett, Timothy, of London, or of Challeek, jent, gent 26
4009920 2028315 2028315 defendant Moreton George   673418 673418 Moreton, George, of London, Davies Inn, gent, son of Thomas Moreton, of Mylbor St Andrews, Dorset 27
4009921 2028315 2028315 defendant Mannock Thomas esq 671840 671840 Mannock, Thomas, of London, New Inn, gent, son of Henry Mannock, of Hemingford, Hunts, esq 28
4009922 2028315 2028315 defendant Nycoll John gent 671840 671840 Nycoll, John, of London, New Inn, gent 29
4009923 2028315 2028315 defendant Poole Thomas gent 585869 585869 Poole, Thomas, of London, gent 30

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