names

11 rows where place_id = 597668

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629398 1904050 1904050 defendant Southall William merchant 597668 597668 Southall, William, of Beaudeley, merchant 1
3788445 1954187 1954187 plaintiff Southall Roger merchant 597668 597668 Southall, Roger, of Beaudeley, merchant 0
3911419 1994134 1994134 defendant Stone Simon yeoman 597668 597668 Stone, Simon, of Beaudeley, yeoman 1
3915087 1995403 1995403 plaintiff Constantyne Richard (legal representative) 597668 597668 Constantyne, Richard, of Beaudeley, mercer, executors of 0
3915091 1995404 1995404 plaintiff Constantyne Richard (legal representative) 597668 597668 Constantyne, Richard, of Beaudeley, mercer, executors of 0
4656468 2247919 2247919 defendant Brikhill John yeoman 597668 597668 Brikhill, John, of Beaudeley, yeoman 0
4656924 2248059 2248059 defendant Rodes William yeoman 597668 597668 Rodes, William, of Beaudeley, yeoman 0
4663370 2250015 2250015 defendant Brikhill John yeoman 597668 597668 Brikhill, John, of Beaudeley, yeoman 0
5151210 2401497 2401497 plaintiff Goode John   597668 597668 Goode, John, of Beaudeley 0
5186226 2411721 2411721 plaintiff Goode John   597668 597668 Goode, John, of Beaudeley 0
5347748 2459449 2459449 defendant Edlyn John butcher 597668 597668 Edlyn, John, of Beaudeley, butcher 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);