names

7 rows where place_id = 766003

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4523273 2207603 2207603 defendant Holmedon Stephen   766003 766003 Holmedon, Stephen, of Hertilpole 2
4574714 2223617 2223617 defendant Goldsmith John   766003 766003 Goldsmith, John, of Hertilpole 10
4574716 2223617 2223617 defendant Elmedene Thomas   766003 766003 Elmedene, Thomas, of Hertilpole 12
4576672 2224213 2224213 defendant Seton Thomas   766003 766003 Seton, Thomas, of Hertilpole 0
4635217 2241855 2241855 defendant Walker William   766003 766003 Walker, William, of Hertilpole 0
4650604 2246195 2246195 defendant Williamson John   766003 766003 Williamson, John, of Hertilpole 8
4775368 2288291 2288291 defendant Wade John butcher 766003 766003 Wade, John, of Hertilpole, butcher 1

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);