names

19 rows where case_id = 2440886

✎ 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
5285851 2440886 2440886 plaintiff Hastynges William knight   Hastynges, William, knight 0
5285852 2440886 2440886 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight 0
5285853 2440886 2440886 defendant Coke Thomas carpenter 641318 641318 Coke, Thomas, of Norburgh, carpenter 1
5285854 2440886 2440886 defendant Berell Henry yeoman 589630 589630 Berell, Henry, of Nuneton, Warks, yeoman 2
5285855 2440886 2440886 defendant Leylond Robert yeoman 592003 592003 Leylond, Robert, of Groby, yeoman 3
5285856 2440886 2440886 defendant Typper John yeoman 868721 868721 Typper, John, of Neuton Lynforth, yeoman 4
5285857 2440886 2440886 defendant Persons Thomas yeoman 592003 592003 Persons, Thomas, of Groby, yeoman 5
5285858 2440886 2440886 defendant Austyn John miller 592003 592003 Austyn, John, of Groby, miller 6
5285859 2440886 2440886 defendant Alney John yeoman 629723 629723 Alney, John, of Bradgate, yeoman 7
5285860 2440886 2440886 defendant Colet John yeoman 713628 713628 Colet, John, of Wolston, Warks, yeoman 8
5285861 2440886 2440886 defendant Lorymer John yeoman 586435 586435 Lorymer, John, of Leicester, yeoman 9
5285862 2440886 2440886 defendant Sharpuls Roger eoman 636199 636199 Sharpuls, Roger, of Swythland, eoman 10
5285863 2440886 2440886 defendant Asshton Robert yeoman 636199 636199 Asshton, Robert, of Swythland, yeoman 11
5285864 2440886 2440886 defendant Laurence John yeoman 636199 636199 Laurence, John, of Swythland, yeoman 12
5285865 2440886 2440886 defendant Awens John yeoman 636199 636199 Awens, John, of Swythland, yeoman 13
5285866 2440886 2440886 defendant Martyn Ralph yeoman 738854 738854 Martyn, Ralph, of Shepeshede, yeoman 14
5285867 2440886 2440886 defendant Flynte Robrt husbandman 610645 610645 Flynte, Robrt, of Osgathorp, husbandman 15
5285868 2440886 2440886 defendant Carter John husbandman 868722 868722 Carter, John, of Thorp, Broughton Asteley, husbandman 16
5285869 2440886 2440886 defendant Ratclyff Thomas yeoman 863883 863883 Ratclyff, Thomas, of Bulkyngton, Warks, yeoman 17

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