names

18 rows where case_id = 2319066

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4874812 2319066 2319066 plaintiff Ricardson William     Ricardson, William 0
4874813 2319066 2319066 defendant Assheton Thomas gent 614372 614372 Assheton, Thomas, of Crofton, Lancs, gent 0
4874814 2319066 2319066 defendant Sclater Richard yeoman 815863 815863 Sclater, Richard, of Gryndilton, yeoman 1
4874815 2319066 2319066 defendant de Donum John yeoman 815863 815863 de Donum, John, of Gryndilton, yeoman 2
4874816 2319066 2319066 defendant Whyte John yeoman 815863 815863 Whyte, John, of Gryndilton, yeoman 3
4874817 2319066 2319066 defendant Foule William, junior yeoman 815863 815863 Foule, William, junior, of Gryndilton, yeoman 4
4874818 2319066 2319066 defendant Sclater William   815863 815863 Sclater, William, of Gryndilton, yeoman, son of Sclater, Richard 5
4874819 2319066 2319066 defendant del Wode Richard yeoman 815863 815863 del Wode, Richard, of Gryndilton, yeoman 6
4874820 2319066 2319066 defendant del Wode John Roger 815863 815863 del Wode, John, of Gryndilton, yeoman, son of del Wode, Roger 7
4874821 2319066 2319066 defendant del Altham Lawrence yeoman 815863 815863 del Altham, Lawrence, of Gryndilton, yeoman 8
4874822 2319066 2319066 defendant Wodward Henry yeoman 815863 815863 Wodward, Henry, of Gryndilton, yeoman 9
4874823 2319066 2319066 defendant Plesyngton Lawrence yeoman 614372 614372 Plesyngton, Lawrence, of Crofton, Lancs, yeoman 10
4874824 2319066 2319066 defendant Brouneberd John yeoman 586349 586349 Brouneberd, John, of Bradford, yeoman 11
4874825 2319066 2319066 defendant Wadyngton Robert   586349 586349 Wadyngton, Robert, of Bradford, yeoman, son of Wadyngton, William 12
4874826 2319066 2319066 defendant Wadyngton John   586349 586349 Wadyngton, John, of Bradford, yeoman, son of Wadyngton, John 13
4874827 2319066 2319066 defendant Crummoke Richard yeoman 815863 815863 Crummoke, Richard, of Gryndilton, yeoman 14
4874828 2319066 2319066 defendant de Ellall Elias yeoman 815868 815868 de Ellall, Elias, of Ctofton, yeoman 15
4874829 2319066 2319066 defendant Greydall John yeoman 815869 815869 Greydall, John, of Boweland, Lancs, yeoman 16

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