names

22 rows where case_id = 2220570

✎ 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
4564839 2220570 2220570 plaintiff Sheffeld Richard   615257 615257 Sheffeld, Richard, of Richemond 0
4564840 2220570 2220570 defendant Midelham Robert   602043 602043 Midelham, Robert, of Hoveden 0
4564841 2220570 2220570 defendant Barker Richard   586093 586093 Barker, Richard, of Selby 1
4564842 2220570 2220570 defendant Shakelok William   770131 770131 Shakelok, William, of Cateryg 2
4564843 2220570 2220570 defendant Cateryk Bartholomew de     Cateryk, Bartholomew de 3
4564844 2220570 2220570 defendant Nesame William   588864 588864 Nesame, William, of Bedale 4
4564845 2220570 2220570 defendant Walker John   600323 600323 Walker, John, of Ellerton 5
4564846 2220570 2220570 defendant Bernby John     Bernby, John 6
4564847 2220570 2220570 defendant Milner John   770132 770132 Milner, John, of Bisburgh 7
4564848 2220570 2220570 defendant Wake John   587727 587727 Wake, John, of Pykeryng 8
4564849 2220570 2220570 defendant Webster John   587727 587727 Webster, John, of Pykeryng 9
4564850 2220570 2220570 defendant Halgarth John   587727 587727 Halgarth, John, of Pykeryng 10
4564851 2220570 2220570 defendant Maresflet John   591864 591864 Maresflet, John, of Hedon 11
4564852 2220570 2220570 defendant Bolys John   590251 590251 Bolys, John, of Beverlay 12
4564853 2220570 2220570 defendant Sleford William tanner   Sleford, William, tanner 13
4564854 2220570 2220570 defendant Hagger Thomas chaplain 615257 615257 Hagger, Thomas, of Richemond, chaplain 14
4564855 2220570 2220570 defendant Maddok Thomas   602157 602157 Maddok, Thomas, of Hunmanby 15
4564856 2220570 2220570 defendant Ploman Richard   602157 602157 Ploman, Richard, of Hunmanby 16
4564857 2220570 2220570 defendant Chapman Richard   602157 602157 Chapman, Richard, of Hunmanby 17
4564858 2220570 2220570 defendant Bentlay Thomas   770133 770133 together with Bentlay, Thomas, of Howedane 18
4564859 2220570 2220570 defendant Litster Amora   770133 770133 Litster, Amora, of Howedane, formerly wife of John 19
4564860 2220570 2220570 defendant Skate of Slate Henry   586093 586093 Skate of Slate, Henry, of Selby 20

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