names

19 rows where case_id = 2174955

✎ 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
4432606 2174955 2174955 plaintiff de la Pole Richard   753937 753937 de la Pole, Richard, of Hertyngdon 0
4432607 2174955 2174955 defendant Hervy John   624160 624160 Hervy, John, of Asshebourne, son of Richard 0
4432608 2174955 2174955 defendant de le Slak Thomas son of Robert   de le Slak, Thomas, son of Robert 1
4432609 2174955 2174955 defendant Foleiaumbe Thomas   755922 755922 Foleiaumbe, Thomas, of Berde 2
4432610 2174955 2174955 defendant Coterel John     Coterel, John 3
4432611 2174955 2174955 defendant Talyour Hugh le son of Ralph   Talyour, Hugh le, son of Ralph 4
4432612 2174955 2174955 defendant de la Forde Nicholas     de la Forde, Nicholas 5
4432613 2174955 2174955 defendant Robyn Nicholas   641477 641477 Robyn, Nicholas, of Bradbourne 6
4432614 2174955 2174955 defendant Balydene Henry de son of John   Balydene, Henry de, son of John 7
4432615 2174955 2174955 defendant Balydene John son of John   Balydene, John, son of John 8
4432616 2174955 2174955 defendant Trouleigh Thomas de   755923 755923 Trouleigh, Thomas de, of Balydene 9
4432617 2174955 2174955 defendant Kechemon John   755923 755923 Kechemon, John, of Balydene 10
4432618 2174955 2174955 defendant Kechemon William   755923 755923 Kechemon, William, of Balydene 11
4432619 2174955 2174955 defendant Alstonfeld Roger de     Alstonfeld, Roger de 12
4432620 2174955 2174955 defendant Parker John   755924 755924 Parker, John, of Dounebrugg 13
4432621 2174955 2174955 defendant Alsop Ralh   755925 755925 Alsop, Ralh, of Penerewich 14
4432622 2174955 2174955 defendant Lee John de   755926 755926 Lee, John de, of Somersale 15
4432623 2174955 2174955 defendant Trouleigh Henry de   755923 755923 Trouleigh, Henry de, of Balydene 16
4432624 2174955 2174955 defendant Talyour Ralph le     Talyour, Ralph le 17

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