names

18 rows where case_id = 2169853

✎ 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
4415879 2169853 2169853 plaintiff Ketelbergh Edmund de clerk   Ketelbergh, Edmund de, clerk 0
4415880 2169853 2169853 defendant del Halle John   589127 589127 del Halle, John, of Walton, bailiff of the commune 0
4415881 2169853 2169853 defendant None Edmund   753804 753804 None, Edmund, of Tilneye 1
4415882 2169853 2169853 defendant Talmach William   596822 596822 Talmach, William, of Walsoken 2
4415883 2169853 2169853 defendant Multon John de     Multon, John de 3
4415884 2169853 2169853 defendant Robert son of Adam son of Margaret   Robert, son of Adam, son of Margaret 4
4415885 2169853 2169853 defendant Palfreyman William   753802 753802 Palfreyman, William, of Gosberchirch 5
4415886 2169853 2169853 defendant Colyn Thomas     together with Colyn, Thomas 6
4415887 2169853 2169853 defendant Shouldham Simon de   753805 753805 Shouldham, Simon de, of Tuyngton 7
4415888 2169853 2169853 defendant (not given) John his son   John, his son 8
4415889 2169853 2169853 defendant Aldo Roger     Aldo, Roger 9
4415890 2169853 2169853 defendant John son of the said Thomas Colyn     John, son of the said Thomas Colyn 10
4415891 2169853 2169853 defendant Chapman Robert son of Reginald   Chapman, Robert, son of Reginald 11
4415892 2169853 2169853 defendant Taillour Edmund   586312 586312 Taillour, Edmund, of Walden 12
4415893 2169853 2169853 defendant Walton Peter de son of John, son of Thomas   Walton, Peter de, son of John, son of Thomas 13
4415894 2169853 2169853 defendant (not given) Reginald his brother   Reginald, his brother 14
4415895 2169853 2169853 defendant Hurlyna John     Hurlyna, John 15
4415896 2169853 2169853 defendant Palfreyman Edward     Palfreyman, Edward 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);