names

13 rows where place_id = 778218

✎ 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
4652648 2246781 2246781 defendant Baylly William husbandman 778218 778218 Baylly, William, of Aldyngbourne, husbandman 13
4652649 2246781 2246781 defendant Dobbe Nicholas husbandman 778218 778218 Dobbe, Nicholas, of Aldyngbourne, husbandman 14
4652650 2246781 2246781 defendant Wake William husbandman 778218 778218 Wake, William, of Aldyngbourne, husbandman 15
4652651 2246781 2246781 defendant Halle Stephen husbandman 778218 778218 Halle, Stephen, of Aldyngbourne, husbandman 16
4652652 2246781 2246781 defendant Bastard John husbandman 778218 778218 Bastard, John, of Aldyngbourne, husbandman 17
4652673 2246782 2246782 defendant Baylly William husbandman 778218 778218 Baylly, William, of Aldyngbourne, husbandman 13
4652674 2246782 2246782 defendant Do- Nicholas husbandman 778218 778218 Do-, Nicholas, of Aldyngbourne, husbandman 14
4652675 2246782 2246782 defendant Wake William husbandman 778218 778218 Wake, William, of Aldyngbourne, husbandman 15
4652676 2246782 2246782 defendant Halle Stephen husbandman 778218 778218 Halle, Stephen, of Aldyngbourne, husbandman 16
4652677 2246782 2246782 defendant Bastard John husbandman 778218 778218 Bastard, John, of Aldyngbourne, husbandman 17
4747263 2279705 2279705 defendant Pote William husbandman 778218 778218 Pote, William, of Aldyngbourne, husbandman 0
4747290 2279710 2279710 defendant Peche Robert husbandman 778218 778218 Peche, Robert, of aldyngbourne, husbandman 4
5345050 2458613 2458613 defendant Hunte John husbandman 778218 778218 Hunte, John, of Aldyngbourne, 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);