names

10 rows where place_id = 704012

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4150568 2078333 2078333 defendant Chatterton Christopher butcher 704012 704012 Chatterton, Christopher, of Podmore, butcher 0
4150571 2078334 2078334 defendant Chatterton Christopher butcher 704012 704012 Chatterton, Christopher, of Podmore, butcher 0
4165708 2083505 2083505 defendant Chatterton Christopher butcher 704012 704012 Chatterton, Christopher, of Podmore, butcher 0
4165709 2083505 2083505 defendant Chatterton John laborer 704012 704012 Chatterton, John, of Podmore, laborer 1
4178421 2087927 2087927 defendant Asshele Robert, junior husbandman 704012 704012 Asshele, Robert, junior, of Podmore, husbandman 0
4198580 2095060 2095060 defendant Asheley Robert, junior husbandman 704012 704012 Asheley, Robert, junior, of Podmore, husbandman 0
4215175 2100803 2100803 defendant Asheley Robert coller 704012 704012 Asheley, Robert, of Podmore, or of Norton in the Mores, coller 2
4218406 2101938 2101938 defendant Asheley Robert   704012 704012 Asheley, Robert, of Podmore, husbandman, son of Robert 0
4220196 2102567 2102567 defendant Asheley Robert   704012 704012 Asheley, Robert, of Podmore, husbandman, the younger 0
5055398 2373198 2373198 defendant Hert Thomas yeoman 704012 704012 Hert, Thomas, of Podmore,yeoman 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);