names

16 rows where case_id = 2230881

✎ 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
4598898 2230881 2230881 plaintiff Staneley Ralph de knight   Staneley, Ralph de, knight 0
4598899 2230881 2230881 defendant Bagshawe William, sen     Bagshawe, William, sen 0
4598900 2230881 2230881 defendant del Kyrk Hugh     del Kyrk, Hugh 1
4598901 2230881 2230881 defendant del Kyrk Walter     del Kyrk, Walter 2
4598902 2230881 2230881 defendant Molt Thomas     Molt, Thomas 3
4598903 2230881 2230881 defendant Hally John   770852 770852 Hally, John, of Milveton 4
4598904 2230881 2230881 defendant Cladhurst John de     Cladhurst, John de 5
4598905 2230881 2230881 defendant Hally Thomas   773288 773288 Hally, Thomas, of Shireokne 6
4598906 2230881 2230881 defendant Wylson John   605693 605693 Wylson, John, of Chapell 7
4598907 2230881 2230881 defendant Symkynson Thomas   773289 773289 Symkynson, Thomas, of Mellour 8
4598908 2230881 2230881 defendant Seriaunt Robert     Seriaunt, Robert 9
4598909 2230881 2230881 defendant Raulynson William     Raulynson, William 10
4598910 2230881 2230881 defendant Bagshawe Thomas de son of William   Bagshawe, Thomas de, son of William 11
4598911 2230881 2230881 defendant Grove Thomas smith 773290 773290 Grove, Thomas,of Malcam, smith 12
4598912 2230881 2230881 defendant Grensmyth Hugh     Grensmyth, Hugh 13
4598913 2230881 2230881 defendant Kyrk Hugh de   773291 773291 Kyrk, Hugh de, of Consye 14

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