names

15 rows where case_id = 1944066

✎ 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
3756671 1944066 1944066 plaintiff Babyngton Roland     Babyngton, Roland 0
3756672 1944066 1944066 defendant Eyton Fulk gent 601858 601858 Eyton, Fulk, of Ilkeston, gent 0
3756673 1944066 1944066 defendant Stanley George yeoman 601858 601858 Stanley, George, of Ilkeston, yeoman 1
3756674 1944066 1944066 defendant Savage George gent 601858 601858 Savage, George, of Ilkeston, gent 2
3756675 1944066 1944066 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 3
3756676 1944066 1944066 defendant Wode Robert yeoman 590448 590448 Wode, Robert, of Alton, yeoman 4
3756677 1944066 1944066 defendant Gylbard John (legal representative)   Gylbard, John, administrator of 5
3756678 1944066 1944066 defendant Gylbard William butcher 587136 587136 Gylbard, William, of Derby, butcher 6
3756679 1944066 1944066 defendant Chapman Edward husbandman 610254 610254 Chapman, Edward, of Newhall, husbandman 7
3756680 1944066 1944066 defendant Joly William yeoman 587136 587136 Joly, William, of Derby, yeoman 8
3756681 1944066 1944066 defendant Netham Philip yeoman 587136 587136 Netham, Philip, of Derby, yeoman 9
3756682 1944066 1944066 defendant Wheteley Richard gent 624205 624205 Wheteley, Richard, of Okebroke, gent 10
3756683 1944066 1944066 defendant Bagshawe Henry yeoman 588688 588688 Bagshawe, Henry, of Darley, yeoman 11
3756684 1944066 1944066 defendant Rogotte Ralph husbandman 587631 587631 Rogotte, Ralph, of Chesterfeld, husbandman 12
3756685 1944066 1944066 defendant Eyre Katherine widow 624206 624206 Eyre, Katherine, of Highlowe, widow 13

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