names

17 rows where place_id = 612959

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3695825 1924928 1924928 defendant Kesten William slater 612959 612959 Kesten, William, of Colyweston, slater 0
3709707 1929347 1929347 defendant Beston William slater 612959 612959 Beston, William, of Colyweston, slater 0
3754510 1943366 1943366 defendant Kestene William salter 612959 612959 Kestene, William, of Colyweston, salter 0
3754511 1943366 1943366 defendant Wolryche Henry salter 612959 612959 Wolryche, Henry, of Colyweston, salter 1
3761525 1945615 1945615 defendant Freman John husbandman 612959 612959 Freman, John, of Colyweston, husbandman 0
3779680 1951380 1951380 defendant Wulriche Henry slater 612959 612959 Wulriche, Henry, of Colyweston, slater 0
3779681 1951380 1951380 defendant Kesten William slater 612959 612959 Kesten, William, of Colyweston, slater 1
3795953 1956596 1956596 defendant Wulryche Henry slater 612959 612959 Wulryche, Henry, of Colyweston, slater 1
3817382 1963348 1963348 defendant Wolman Henry slater 612959 612959 Wolman, Henry, of Colyweston, slater 1
3823149 1965151 1965151 defendant Wolman Henry slater 612959 612959 Wolman, Henry, of Colyweston, slater 1
3832864 1968203 1968203 defendant Kesteven William slater 612959 612959 Kesteven, William, of Colyweston, slater 2
3833165 1968303 1968303 defendant Wolman William husbandman 612959 612959 Wolman, William, of Colyweston, husbandman 1
3833166 1968303 1968303 defendant Keston William slater 612959 612959 Keston, William, of Colyweston, slater 2
4662072 2249615 2249615 plaintiff Fissher William (legal representative) 612959 612959 Fissher, William, of Colyweston, executors of 0
4662074 2249615 2249615 plaintiff Morys Nicholas   612959 612959 Morys, Nicholas, of Colyweston 2
5059331 2374358 2374358 defendant Thurleby Thomas yeoman 612959 612959 Thurleby, Thomas, of Colyweston, yeoman 3
5601288 2535295 2535295 defendant Cook Walter yeoman 612959 612959 Cook, Walter, of Colyweston, 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);