names

17 rows where place_id = 629728

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3790056 1954706 1954706 defendant Thomson Edward laborer 629728 629728 Thomson, Edward, of Darlaston, laborer 14
3806199 1959862 1959862 defendant Thomson Edward laborer 629728 629728 Thomson, Edward, of Darlaston, laborer 13
3806218 1959863 1959863 defendant Thomson Edward laborer 629728 629728 Thomson, Edward, of Darlaston, laborer 13
4151725 2078716 2078716 defendant Nashe John yeoman 629728 629728 Nashe, John, of Darlaston, yeoman 2
4173849 2086308 2086308 defendant Caderocke John yeoman 629728 629728 Caderocke, John, of Darlaston, yeoman 0
4189962 2091992 2091992 defendant Moore John yeoman 629728 629728 Moore, John, of Darlaston, yeoman 2
4219961 2102484 2102484 defendant Baggeley Edward blacksmith 629728 629728 Baggeley, Edward, of Darlaston, blacksmith 1
4219963 2102484 2102484 defendant Baggeley John blacksmith 629728 629728 Baggeley, John, of Darlaston, blacksmith 3
4222374 2103316 2103316 defendant Sutton James carpenter 629728 629728 Sutton, James, of Darlaston, carpenter 0
4312459 2134495 2134495 defendant Clowse William yeoman 629728 629728 Clowse, William, of Darlaston, yeoman 0
4323775 2138365 2138365 defendant Bill Geoffrey yeoman 629728 629728 Bill, Geoffrey, of Darlaston, yeoman 1
4325836 2139014 2139014 defendant Blowse William yeoman 629728 629728 Blowse, William, of Darlaston, yeoman 0
4340081 2143797 2143797 defendant Goodwyn Henry blacksmith 629728 629728 Goodwyn, Henry, of Darlaston, blacksmith 2
4349827 2147197 2147197 defendant Colier James esq 629728 629728 Colier, James, of Darlaston, esq 0
4350567 2147461 2147461 defendant Clowes William yeoman 629728 629728 Clowes, William, of Darlaston, yeoman 3
5566808 2524886 2524886 defendant Gere Thomas yeoman 629728 629728 Gere, Thomas, of Darlaston, yeoman 1
5566812 2524887 2524887 defendant Gere Thomas yeoman 629728 629728 Gere, Thomas, of Darlaston, yeoman 1

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