names

11 rows where place_id = 613172

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3696980 1925281 1925281 defendant Trent William miller 613172 613172 Trent, William, of North Over, miller 0
3719251 1932307 1932307 defendant Swan Henry butcher 613172 613172 Swan, Henry, of North Elman, butcher 0
3902288 1990999 1990999 defendant Martyn Isabel widow 613172 613172 Martyn, Isabel, of North Over, widow 2
4110823 2064127 2064127 defendant Lackford Richard butcher 613172 613172 Lackford, Richard, of North Elman, butcher 0
4520687 2206819 2206819 defendant Taillour Roger   613172 613172 Taillour, Roger, of North 0
4637831 2242602 2242602 defendant Russell John   613172 613172 Russell, John, of North Over 0
4637832 2242602 2242602 defendant Smyth John   613172 613172 Smyth, John, of North Over 1
4637833 2242602 2242602 defendant Crukern John   613172 613172 Crukern, John, of North Over 2
4827060 2304506 2304506 defendant Bernard Hugh butcher 613172 613172 Bernard, Hugh, of North Coker, butcher 0
5162160 2404667 2404667 defendant Gybbys Richard chaplain 613172 613172 Gybbys, Richard, of North Over, by Yevelchester, chaplain 0
5559242 2522668 2522668 defendant Grevall John yeoman 613172 613172 Grevall, John, of North Cover, yeoman 0

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