names

18 rows where place_id = 594800

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617658 1873147 1873147 defendant Olyver Robert gent 594800 594800 Olyver, Robert, of Asteley, Warks, gent 0
4275452 2121351 2121351 defendant Stoneherst Edward yeoman 594800 594800 Stoneherst, Edward, of Asteley, Warks, yeoman 2
4793892 2294214 2294214 defendant Sutton John chaplain 594800 594800 Sutton, John, of Asteley, Warks, chaplain 1
5285259 2440711 2440711 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight 1
5285265 2440712 2440712 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight 1
5285852 2440886 2440886 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight 0
5285871 2440887 2440887 defendant Langton William gent 594800 594800 Langton, William, of Asteley, Warks, gent 0
5291588 2442543 2442543 defendant Symkyns Thomas yeoman 594800 594800 Symkyns, Thomas, of Asteley, Warks, yeoman 0
5318654 2450671 2450671 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight 0
5318656 2450672 2450672 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight 0
5318662 2450675 2450675 defendant Gey or Grey Edward   594800 594800 Gey or Grey, Edward, of Asteley, Warks, knight 0
5329600 2453921 2453921 defendant Bourghchier John   594800 594800 Bourghchier, John, of Asteley, Warks, knight 0
5336104 2455878 2455878 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight, Lord Lisle 0
5338320 2456560 2456560 defendant Bate Richard clerk 594800 594800 Bate, Richard, of Asteley, Warks, clerk 0
5342644 2457902 2457902 defendant Brachet John gent 594800 594800 Brachet, John, of Asteley, Warks, gent 0
5342649 2457903 2457903 defendant Brachet John gent 594800 594800 Brachet, John, of Asteley, Warks, gent 0
5354067 2461335 2461335 defendant Grey Edward   594800 594800 Grey, Edward, of Asteley, Warks, knight, Lord Lisle 0
5575600 2527457 2527457 defendant Pierson alias Coke Thomas yeoman 594800 594800 Pierson alias Coke, Thomas, of Asteley, Warks, yeoman 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);