names

7 rows where place_id = 589056

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596390 1866502 1866502 defendant Northorne John husbandman 589056 589056 Northorne, John, of Weston on Mare, husbandman 8
3596391 1866502 1866502 defendant Wynter Richard husbandman 589056 589056 Wynter, Richard, of Weston on Mare, husbandman 9
3596392 1866502 1866502 defendant Jonys William husbandman 589056 589056 Jonys, William, of Weston on Mare, husbandman 10
3624038 1875050 1875050 defendant Williams John husbandman 589056 589056 Williams, John, of Weston on Mare, husbandman 0
5518804 2510714 2510714 defendant Shoter John, senior husbandman 589056 589056 Shoter, John, senior, of Weston on Mare, husbandman 0
5518805 2510714 2510714 defendant Shoter John, junior husbandman 589056 589056 Shoter, John, junior, of Weston on Mare, husbandman 1
5550049 2520051 2520051 defendant Northorne John husbandman 589056 589056 Northorne, John, of Weston on Mare, husbandman 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);