names

17 rows where case_id = 2245509

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4648084 2245509 2245509 plaintiff Stanhop Richard knight   Stanhop, Richard, knight 0
4648085 2245509 2245509 defendant Smyth Roger   591977 591977 Smyth, Roger, of Laxton 0
4648086 2245509 2245509 defendant Prentys John     Prentys, John 1
4648087 2245509 2245509 defendant Hill John de     Hill, John de 2
4648088 2245509 2245509 defendant Deye John     Deye, John 3
4648089 2245509 2245509 defendant Alchon Richard     Alchon, Richard 4
4648090 2245509 2245509 defendant Clerk William   591977 591977 Clerk, William, of Laxton 5
4648091 2245509 2245509 defendant Chapell Robert, sen     Chapell, Robert, sen 6
4648092 2245509 2245509 defendant Kelsterne Richard de     Kelsterne, Richard de 7
4648093 2245509 2245509 defendant Burtonson John de     Burtonson, John de 8
4648094 2245509 2245509 defendant Caldewell John     Caldewell, John 9
4648095 2245509 2245509 defendant Caldewell Simon de     Caldewell, Simon de 10
4648096 2245509 2245509 defendant Myrye John     Myrye, John 11
4648097 2245509 2245509 defendant Tomson John     Tomson, John 12
4648098 2245509 2245509 defendant Nottingham William de     Nottingham, William de 13
4648099 2245509 2245509 defendant Symson William     Symson, William 14
4648100 2245509 2245509 defendant Chapell Robert jun   Chapell, Robert, jun 15

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