names

17 rows where case_id = 2198219

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4492094 2198219 2198219 plaintiff Wylughby Robert de knight   Wylughby, Robert de, knight 0
4492095 2198219 2198219 defendant Midelton John de     Midelton, John de 0
4492096 2198219 2198219 defendant Beke John     Beke, John 1
4492097 2198219 2198219 defendant Beauchampe John   597185 597185 Beauchampe, John, of Freston 2
4492098 2198219 2198219 defendant Claxby John de     Claxby, John de 3
4492099 2198219 2198219 defendant Kent John de butcher 597185 597185 Kent, John de, of Freston, butcher 4
4492100 2198219 2198219 defendant Uttyng William     Uttyng, William 5
4492101 2198219 2198219 defendant Gillegson John     Gillegson, John 6
4492102 2198219 2198219 defendant Romfare John son of Adam   Romfare, John, son of Adam 7
4492103 2198219 2198219 defendant Watre William de     Watre, William de 8
4492104 2198219 2198219 defendant Smyth Richard     Smyth, Richard 9
4492105 2198219 2198219 defendant Fissher Thomasl     Fissher, Thomasl 10
4492106 2198219 2198219 defendant Benne William     Benne, William 11
4492107 2198219 2198219 defendant Worme John, junior   597185 597185 Worme, John, junior, of Freston 12
4492108 2198219 2198219 defendant Smyth Alan     Smyth, Alan 13
4492109 2198219 2198219 defendant Gye John     Gye, John 14
4492110 2198219 2198219 defendant Lyppe Robert   762876 762876 Lyppe, Robert, of Freston, on their own account 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);