names

7 rows where place_id = 672756

✎ 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
4006889 2027240 2027240 defendant Johnson Patrick yeoman 672756 672756 Johnson, Patrick, of Est Brompton, yeoman 0
4657983 2248379 2248379 defendant del Kechyn Thomas husbandman 672756 672756 del Kechyn, Thomas, of Est Brompton, husbandman 13
4657984 2248379 2248379 defendant Hardy Thomas husbandman 672756 672756 Hardy, Thomas, of Est Brompton, husbandman 14
4657985 2248379 2248379 defendant Wynspere John husbandman 672756 672756 Wynspere, John, of Est Brompton, husbandman 15
4700707 2265622 2265622 defendant Haukeswell Robert   672756 672756 Haukeswell, Robert, of East Brompton, wright 0
5223010 2422448 2422448 defendant Appilton William yeoman 672756 672756 Appilton, William, of Est Brompton, yeoman 0
5223014 2422449 2422449 defendant Appilton William yeoman 672756 672756 Appilton, William, of Est Brompton, 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);