names

13 rows where case_id = 2244131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4643231 2244131 2244131 plaintiff Huse Hugh knight   Huse, Hugh, knight 0
4643232 2244131 2244131 defendant atte Dam John   777273 777273 atte Dam, John, of Plumptre 0
4643233 2244131 2244131 defendant Wryght of Normanton     Wryght, of Normanton 1
4643234 2244131 2244131 defendant Pope William   590873 590873 Pope, William, of Normanton 2
4643235 2244131 2244131 defendant Habard John   590873 590873 Habard, John, of Normanton 3
4643236 2244131 2244131 defendant Normanton Benedict de     Normanton, Benedict de 4
4643237 2244131 2244131 defendant Chaloner William   777273 777273 Chaloner, William, of Plumptre 5
4643238 2244131 2244131 defendant Elys William   777273 777273 Elys, William, of Plumptre 6
4643239 2244131 2244131 defendant atte Hall William   777273 777273 atte Hall, William, of Plumptre 7
4643240 2244131 2244131 defendant Barkley John de   777274 777274 Barkley, John de, of Pluymptre 8
4643241 2244131 2244131 defendant del Grene William   777273 777273 del Grene, William, of Plumptre 9
4643242 2244131 2244131 defendant Plumtre John parson of the church, in   together with Plumtre, John, parson of the church, in 10
4643243 2244131 2244131 defendant Melton William   590873 590873 Melton, William, of Normanton 11

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