names

8 rows where place_id = 638329

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3841936 1971044 1971044 defendant Hoskyns Henry eyoman 638329 638329 Hoskyns, Henry, of Bemyster, Dorset, eyoman 0
3841938 1971045 1971045 defendant Hoskyns Henry yeoman 638329 638329 Hoskyns, Henry, of Bemyster, Dorset, yeoman 0
3962756 2011560 2011560 defendant Chycke Richard chapman 638329 638329 Chycke, Richard, of Bemyster, Dorset, chapman 0
4011653 2028906 2028906 defendant Hoskyns William gent 638329 638329 Hoskyns, William, of Bemyster, Dorset, gent 1
5249978 2430105 2430105 defendant Fountell John yeoman 638329 638329 Fountell, John, of Bemyster, Dorset, yeoman 0
5491374 2502309 2502309 defendant Colyn Stephen husbandman 638329 638329 Colyn, Stephen, of Bemyster, Dorset, husbandman 0
5529899 2513856 2513856 defendant Sylok John fisher 638329 638329 Sylok, John, of Bemyster, Dorset, fisher 0
5560227 2522953 2522953 defendant Strode Thomas gent 638329 638329 Strode, Thomas, of Bemyster, Dorset, gent 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);