names

9 rows where place_id = 588932

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596040 1866389 1866389 defendant Dalton Christopher clerk 588932 588932 Dalton, Christopher, of Ocolt, clerk 0
3596041 1866389 1866389 defendant Dalton Henry yeoman 588932 588932 Dalton, Henry, of Ocolt, yeoman 1
3904321 1991693 1991693 defendant Goddard John butcher 588932 588932 Goddard, John, of Ocolt, butcher 0
4842700 2309255 2309255 defendant Wauke Peter yeoman 588932 588932 Wauke, Peter, of Ocolt, yeoman 0
5354372 2461433 2461433 plaintiff Cullum John, junior   588932 588932 Cullum, John, junior, of Ocolt 1
5424642 2482336 2482336 defendant Cullom John husbandman 588932 588932 Cullom, John, of Ocolt, husbandman 10
5454129 2491133 2491133 defendant Cullom John   588932 588932 Cullom, John, of Ocolt 10
5478046 2498456 2498456 defendant Corbold William butcher 588932 588932 Corbold, William, of Ocolt, butcher 1
5525662 2512620 2512620 plaintiff Hawe John   588932 588932 Hawe, John, of Ocolt 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);