names

21 rows where place_id = 597277

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627952 1903598 1903598 defendant Throkmarton Robert   597277 597277 Throkmarton, Robert, of Coughton, Warks, knight 0
3628915 1903921 1903921 defendant Kytteley Eustace yeoman 597277 597277 Kytteley, Eustace, of Coughton, Warks, yeoman 2
3675997 1918530 1918530 defendant Russell John esq 597277 597277 Russell, John, of Coughton, Warks, esq 0
3678225 1919243 1919243 defendant Magott William yeoman 597277 597277 Magott, William, of Coughton, Warks, yeoman 1
3699281 1925991 1925991 defendant Wagstaffe George yeoman 597277 597277 Wagstaffe, George, of Coughton, Warks, yeoman 0
3736552 1937684 1937684 defendant Throgmorton George esq 597277 597277 Throgmorton, George, of Coughton, Warks, esq 0
3738314 1938200 1938200 defendant Throkmerton George esq 597277 597277 Throkmerton, George, of Coughton, Warks, esq 0
3738317 1938201 1938201 defendant Throkmerton George esq 597277 597277 Throkmerton, George, of Coughton, Warks, esq 0
3807672 1960295 1960295 defendant Throkmorton George   597277 597277 Throkmorton, George, of Coughton, Warks, knight 1
3807681 1960296 1960296 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight 0
3823366 1965222 1965222 defendant Throkmorton George   597277 597277 Throkmorton, George, of Coughton, Warks, knight 0
3823369 1965223 1965223 defendant Throkmorton George   597277 597277 Throkmorton, George, of Coughton, Warks, knight 0
3823372 1965224 1965224 defendant Throkmorton George   597277 597277 Throkmorton, George, of Coughton, Warks, knight 0
3856082 1975525 1975525 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight 0
3856380 1975617 1975617 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight, son of Throkmarton, Robert, of Coughton, knight 0
3856801 1975751 1975751 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight 0
3856806 1975752 1975752 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight 0
3870647 1980424 1980424 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight 0
4018818 2031462 2031462 defendant Bethyll Humphrey yeoman 597277 597277 Bethyll, Humphrey, of Coughton, Warks, yeoman 0
4333181 2141384 2141384 defendant Palmer Edward yeoman 597277 597277 Palmer, Edward, of Coughton, Warks, yeoman 0
5571707 2526274 2526274 defendant Throgmarton Robert   597277 597277 Throgmarton, Robert, of Coughton, Warks, knight 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);