names

14 rows where place_id = 588435

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594507 1865912 1865912 defendant Benlley or Beulley Gitton husbandman 588435 588435 Benlley or Beulley, Gitton, of Tyllyngton, husbandman 2
3604956 1869213 1869213 defendant Medulmore John husbandman 588435 588435 Medulmore, John, of Tyllyngton, husbandman 0
3690866 1923308 1923308 defendant Smyth James chaplain 588435 588435 Smyth, James, of Tyllyngton, chaplain 3
3937171 2002763 2002763 defendant Potter Thomas dyer 588435 588435 Potter, Thomas, of Tyllyngton, dyer 0
3941908 2004305 2004305 defendant Warde Francis gent 588435 588435 Warde, Francis, of Tyllyngton, gent 0
4017941 2031131 2031131 defendant Heathe John yeoman 588435 588435 Heathe, John, of Tyllyngton, yeoman 0
4062073 2046721 2046721 defendant Exon Roger husbandman 588435 588435 Exon, Roger, of Tyllyngton, husbandman 0
4062075 2046721 2046721 defendant Exon John husbandman 588435 588435 Exon, John, of Tyllyngton, husbandman 2
4062078 2046722 2046722 defendant Exton John husbandman 588435 588435 Exton, John, of Tyllyngton, husbandman 0
4062079 2046722 2046722 defendant Powell Thomas laborer 588435 588435 together with Powell, Thomas, of Tyllyngton, laborer 1
4062082 2046723 2046723 defendant Powell Thomas laborer 588435 588435 Powell, Thomas, of Tyllyngton, laborer 0
4371315 2154806 2154806 defendant Lamberd alias Freligate Anthony collier 588435 588435 Lamberd alias Freligate, Anthony, of Tyllyngton, collier 1
5177366 2409073 2409073 defendant Wodsall Thomas yeoman 588435 588435 Wodsall, Thomas, of Tyllyngton, yeoman 0
5527378 2513142 2513142 defendant Warde John gent 588435 588435 Warde, John, of Tyllyngton, gent 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);