names

13 rows where case_id = 2351854

✎ 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
4983114 2351854 2351854 plaintiff Vernon Richard     Vernon, Richard 0
4983115 2351854 2351854 defendant Bulloke Thomas esq 644722 644722 Bulloke, Thomas, of Erberfeld, Berks, esq 0
4983116 2351854 2351854 defendant Hyde John esq 830445 830445 Hyde, John, of South Denchesworth, Berks, esq 1
4983117 2351854 2351854 defendant Staverton William esq 593654 593654 Staverton, William, of Bray, Berks, esq 2
4983118 2351854 2351854 defendant Fachell William esq 830446 830446 Fachell, William, of Colle, Berks, esq 3
4983119 2351854 2351854 defendant Warneford Richard   830447 830447 Warneford, Richard, of Sevenhampton, Wilts, franklin 4
4983120 2351854 2351854 defendant Grove William   592890 592890 Grove, William, of White Waltham, Berks, franklin 5
4983121 2351854 2351854 defendant Palmere John   594598 594598 Palmere, John, of Bray, franklin 6
4983122 2351854 2351854 defendant Grove Richard yeoman 809163 809163 Grove, Richard, of Waltham St Lawrence, Berks, yeoman 7
4983123 2351854 2351854 defendant Stratton William yeoman 830450 830450 Stratton, William, of Hudleston, Berks, yeoman 8
4983124 2351854 2351854 defendant Whitlokke John gent 692112 692112 Whitlokke, John, of Warfeld, Berks, gent 9
4983125 2351854 2351854 defendant Everard Henry husbandman 585881 585881 Everard, Henry, of Wokyngham, Berks, husbandman 10
4983126 2351854 2351854 defendant Walrond William gent 586804 586804 Walrond, William, of Chelrey, Berks, gent 11

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