names

12 rows where place_id = 760104

✎ 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
4467113 2190382 2190382 defendant Bocher Adam   760104 760104 Bocher, Adam, of the Isle of Thanet 0
4467114 2190382 2190382 defendant Beaumond Henry   760104 760104 Beaumond, Henry, of the Isle of Thanet 1
4467115 2190382 2190382 defendant Abraham John   760104 760104 Abraham, John, of the Isle of Thanet 2
4557261 2218206 2218206 defendant Hontyng John   760104 760104 Hontyng, John, of the Isle of Thanet 0
4557262 2218206 2218206 defendant Hontyng Thomas   760104 760104 Hontyng, Thomas, of the Isle of Thanet 1
4591750 2228775 2228775 defendant Coby Richard   760104 760104 Coby, Richard, of the Isle of Thanet 0
4644099 2244371 2244371 defendant Graunt Adam   760104 760104 Graunt, Adam, of the Isle of Thanet 4
4696732 2264455 2264455 plaintiff Charlys John   760104 760104 Charlys, John, of the Isle of Thanet 0
4808300 2298775 2298775 defendant Treweman Thomas saltmaker 760104 760104 Treweman, Thomas, of the Isle of Thanet, saltmaker 0
5008492 2359380 2359380 defendant Gelot Robert laborer 760104 760104 Gelot, Robert, of the Isle of Thanet, laborer 0
5008493 2359380 2359380 defendant Ravon Richard laborer 760104 760104 Ravon, Richard, of the Isle of Thanet, laborer 1
5612344 2547607 2547607 defendant atte Stone Thomas   760104 760104 atte Stone, Thomas, of the Isle of Thanet 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);