names

15 rows where case_id = 2313674

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4857308 2313674 2313674 plaintiff Blenkansop Thomas   813583 813583 Blenkansop, Thomas, of Blenkansop in Tyndale 0
4857309 2313674 2313674 plaintiff Stapilton William   760698 760698 Stapilton, William, of Stapilton 1
4857310 2313674 2313674 defendant Elwalde Alexander yeoman 760887 760887 Elwalde, Alexander, of Gillesland, yeoman 0
4857311 2313674 2313674 defendant Bulman Patrick yeoman 760887 760887 Bulman, Patrick, of Gillesland, yeoman 1
4857312 2313674 2313674 defendant Whelpedale Robert yeoman 760887 760887 Whelpedale, Robert, of Gillesland, yeoman 2
4857313 2313674 2313674 defendant Derman Robert yeoman 760887 760887 Derman, Robert, of Gillesland, yeoman 3
4857314 2313674 2313674 defendant Derman Richard yeoman 760887 760887 Derman, Richard, of Gillesland, yeoman 4
4857315 2313674 2313674 defendant Karroke Robert yeoman 813584 813584 Karroke, Robert, of Trethirmane, yeoman 5
4857316 2313674 2313674 defendant Hetheryngton Thomas gent 760887 760887 Hetheryngton, Thomas, of Gillesland, gent 6
4857317 2313674 2313674 defendant Hetheryngton William gent 760887 760887 Hetheryngton, William, of Gillesland, gent 7
4857318 2313674 2313674 defendant Robenson John yeoman 760887 760887 Robenson, John, of Gillesland, yeoman 8
4857319 2313674 2313674 defendant Snawedon John yeoman 813585 813585 Snawedon, John, of Lug, yeoman 9
4857320 2313674 2313674 defendant Bulluke William yeoman 760887 760887 Bulluke, William, of Gillesland, yeoman 10
4857321 2313674 2313674 defendant Doweson Robert yeoman 760887 760887 Doweson, Robert, of Gillesland, yeoman 11
4857322 2313674 2313674 defendant Pruddu John yeoman 813586 813586 Pruddu, John, of Longlandes, yeoman 12

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