names

14 rows where case_id = 1932173

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3718840 1932173 1932173 plaintiff Goddard Thomas     Goddard, Thomas 0
3718841 1932173 1932173 defendant Everell William husbandman 598644 598644 Everell, William, of Rokynge, husbandman 0
3718842 1932173 1932173 defendant Gilberde William husbandman 598904 598904 Gilberde, William, of Newcherche, husbandman 1
3718843 1932173 1932173 defendant Tole Henry husbandman 598904 598904 Tole, Henry, of Newcherche, husbandman 2
3718844 1932173 1932173 defendant Gaycot Henry husbandman 598904 598904 Gaycot, Henry, of Newcherche, husbandman 3
3718845 1932173 1932173 defendant Rowse William husbandman 598904 598904 Rowse, William, of Newcherche, husbandman 4
3718846 1932173 1932173 defendant Watte William husbandman 598904 598904 Watte, William, of Newcherche, husbandman 5
3718847 1932173 1932173 defendant Hony William husbandman 617310 617310 Hony, William, of Snargate, husbandman 6
3718848 1932173 1932173 defendant Moyse Nicholas husbandman 598644 598644 Moyse, Nicholas, of Rokynge, husbandman 7
3718849 1932173 1932173 defendant Sharpe John husbandman 598644 598644 Sharpe, John, of Rokynge, husbandman 8
3718850 1932173 1932173 defendant Adryan John husbandman 598644 598644 Adryan, John, of Rokynge, husbandman 9
3718851 1932173 1932173 defendant Rose John husbandman 598644 598644 Rose, John, of Rokynge, husbandman 10
3718852 1932173 1932173 defendant Shalner John husbandman 598644 598644 Shalner, John, of Rokynge, husbandmanM Shalner, Stephen, of Rokynge, husbandman 11
3718853 1932173 1932173 defendant Mychell Thomas husbandman 598644 598644 Mychell, Thomas, of Rokynge, husbandman 12

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