names

26 rows where case_id = 2519950

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5549671 2519950 2519950 plaintiff Bratt Reginald (legal representative)   Bratt, Reginald, executors of 0
5549672 2519950 2519950 plaintiff Smyth William Bishop of Lincoln   (Smyth, William, Bishop of Lincoln 1
5549673 2519950 2519950 plaintiff Oldom Hugh Bishop of Exeter   Oldom, Hugh, Bishop of Exeter 2
5549674 2519950 2519950 plaintiff Ginson Richard knight   Ginson, Richard, knight 3
5549675 2519950 2519950 plaintiff Cutte John knight   Cutte, John, knight 4
5549676 2519950 2519950 plaintiff Conyngesby Humphrey     Conyngesby, Humphrey 5
5549677 2519950 2519950 plaintiff Cope William     Cope, William 6
5549678 2519950 2519950 plaintiff Dygby Simon     Dygby, Simon 7
5549679 2519950 2519950 defendant Caleys Henry   586036 586036 Caleys, Henry, of Exeter, gent, Escheator of Devon 0
5549680 2519950 2519950 defendant Spencer Richard gent 598296 598296 Spencer, Richard, of Spaldyng, Lincs, gent 1
5549681 2519950 2519950 defendant Pedyok Geoffrey gent 586487 586487 Pedyok, Geoffrey, of Suthwerk, gent 2
5549682 2519950 2519950 defendant Morys John Escheator of Herefs   Morys, John, Escheator of Herefs 3
5549683 2519950 2519950 defendant Delaber Richard   647508 647508 Delaber, Richard, of Cleongre, Herefs, knight 4
5549684 2519950 2519950 defendant A Pye John gent 898969 898969 A Pye, John, of Kylpek, Herefs, gent 5
5549685 2519950 2519950 defendant Morley Richard Escheator of Beds and Bucks   Morley, Richard, Escheator of Beds and Bucks 6
5549686 2519950 2519950 defendant Bryne David yeoman 588298 588298 Bryne, David, of Feny Stratford, Bucks, yeoman 7
5549687 2519950 2519950 defendant Rollesley John gent 877929 877929 Rollesley, John, of Stoke Hammond, Bucks, gent 8
5549688 2519950 2519950 defendant Dyneley Ralph Escheator of Devon   Dyneley, Ralph, Escheator of Devon 9
5549689 2519950 2519950 defendant Puddesey Thomas gent 898970 898970 Puddesey, Thomas, of Hoxham, Devon, gent 10
5549690 2519950 2519950 defendant Dyneley Lawrence gent 898971 898971 Dyneley, Lawrence, of Wincle, gent 11
5549691 2519950 2519950 defendant gee Arnold Excheator of Notts and Derbs   gee, Arnold, Excheator of Notts and Derbs 12
5549692 2519950 2519950 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 13
5549693 2519950 2519950 defendant Rissheton John gent 623154 623154 Rissheton, John, of Mysterton, Notts, gent 14
5549694 2519950 2519950 defendant Durson Robert knight, sheriff of Norf and Suff   Durson, Robert, knight, sheriff of Norf and Suff 15
5549695 2519950 2519950 defendant Butler Thomas   746627 746627 Butler, Thomas, of Exhall, Warks, knight 16
5549696 2519950 2519950 defendant Aston John   800935 800935 Aston, John, of Heywode, Staffs, knight 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);