names

18 rows where case_id = 2169852

✎ 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
4415861 2169852 2169852 plaintiff Ketelbergh Edmund de clerk   Ketelbergh, Edmund de, clerk 0
4415862 2169852 2169852 defendant Colyn Thomas     Colyn, Thomas 0
4415863 2169852 2169852 defendant Aldus Roger     Aldus, Roger 1
4415864 2169852 2169852 defendant John son of the same Thomas     John, son of the same Thomas 2
4415865 2169852 2169852 defendant Shouldham Simon de   753799 753799 Shouldham, Simon de, of Tuyngdon 3
4415866 2169852 2169852 defendant (not given) John his son   John, his son 4
4415867 2169852 2169852 defendant Chapman Robert son of Reginald   Chapman, Robert, son of Reginald 5
4415868 2169852 2169852 defendant Tailour Edmund   619299 619299 Tailour, Edmund, of Waldon 6
4415869 2169852 2169852 defendant Waldon Peter de son of John, son of Thomas   Waldon, Peter de, son of John, son of Thomas 7
4415870 2169852 2169852 defendant (not given) Reginald his brother   Reginald, his brother 8
4415871 2169852 2169852 defendant Hurlyna John     Hurlyna, John 9
4415872 2169852 2169852 defendant Palfreyman Edmund     Palfreyman, Edmund 10
4415873 2169852 2169852 defendant del Halle John   619299 619299 together with del Halle, John, of Waldon, bailiff 11
4415874 2169852 2169852 defendant None Edmund   753801 753801 None, Edmund, of Tylneye 12
4415875 2169852 2169852 defendant Talmach William   596822 596822 Talmach, William, of Walsoken 13
4415876 2169852 2169852 defendant Multon John de     Multon, John de 14
4415877 2169852 2169852 defendant Maigar Robert son of Adam, son of   Maigar, Robert, son of Adam, son of 15
4415878 2169852 2169852 defendant Palfreyman William   753802 753802 Palfreyman, William, of Gosberchirch 16

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