names

15 rows where case_id = 1874995

✎ 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
3623862 1874995 1874995 plaintiff (not given)   dean and canons of St Mary and St Stephen Chapel, Westminster Palace   St Mary and St Stephen Chapel, Westminster Palace, dean and canons of 0
3623863 1874995 1874995 defendant Toker William yeoman 596250 596250 Toker, William, of Fordyngton, yeoman 0
3623864 1874995 1874995 defendant Croweston Thomas husbandman 596250 596250 Croweston, Thomas, of Fordyngton, husbandman 1
3623865 1874995 1874995 defendant Floyd Robert yeoman 596250 596250 Floyd, Robert, of Fordyngton, yeoman 2
3623866 1874995 1874995 defendant Gybbon Roger husbandman 596250 596250 Gybbon, Roger, of Fordyngton, husbandman 3
3623867 1874995 1874995 defendant Cosyn Philip husbandman 596250 596250 Cosyn, Philip, of Fordyngton, husbandman 4
3623868 1874995 1874995 defendant Cosyn Henry husbandman 596250 596250 Cosyn, Henry, of Fordyngton, husbandman 5
3623869 1874995 1874995 defendant Baron John husbandman 596250 596250 Baron, John, of Fordyngton, husbandman 6
3623870 1874995 1874995 defendant Wyndesore Robert husbandman 596250 596250 Wyndesore, Robert, of Fordyngton, husbandman 7
3623871 1874995 1874995 defendant White Thomas husbandman 596250 596250 White, Thomas, of Fordyngton, husbandman 8
3623872 1874995 1874995 defendant Chyppe John husbandman 596250 596250 Chyppe, John, of Fordyngton, husbandman 9
3623873 1874995 1874995 defendant Chyppe Thomas husbandman 596250 596250 Chyppe, Thomas, of Fordyngton, husbandman 10
3623874 1874995 1874995 defendant Wodecok Alan husbandman 596250 596250 Wodecok, Alan, of Fordyngton, husbandman 11
3623875 1874995 1874995 defendant Clerk John husbandman 596250 596250 Clerk, John, of Fordyngton, husbandman 12
3623876 1874995 1874995 defendant Bunne Robert husbandman 596250 596250 Bunne, Robert, of Fordyngton, husbandman 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);