names

7 rows where place_id = 596592

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625401 1875483 1875483 defendant Lynton John yeoman 596592 596592 Lynton, John, of Non Monkton, yeoman 10
3625402 1875483 1875483 defendant Courtney Edward   596592 596592 Courtney, Edward, of Non Monkton 11
5015916 2361544 2361544 defendant Symson John laborer 596592 596592 Symson, John, of Non Monkton, laborer 5
5122175 2392905 2392905 defendant Calverd Richard yeoman 596592 596592 Calverd, Richard, of Non Monkton, yeoman 0
5370135 2466243 2466243 defendant Lupton Thomas yeoman 596592 596592 Lupton, Thomas, of Non Monkton, yeoman 0
5370137 2466243 2466243 defendant Boland John yeoman 596592 596592 Boland, John, of Non Monkton, yeoman 2
5370138 2466243 2466243 defendant Stokdale Nicholas laborer 596592 596592 Stokdale, Nicholas, of Non Monkton, laborer 3

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