names

18 rows where case_id = 2344738

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4959255 2344738 2344738 plaintiff Antron William     Antron, William 0
4959256 2344738 2344738 defendant Carpenter Philip carpenter 593036 593036 Carpenter, Philip, of Helstonburgh, carpenter 0
4959257 2344738 2344738 defendant Toure John weaver 593036 593036 Toure, John, of Helstonburgh, weaver 1
4959258 2344738 2344738 defendant Belek John laborer 593036 593036 Belek, John, of Helstonburgh, laborer 2
4959259 2344738 2344738 defendant Trokyer James tailor 593036 593036 Trokyer, James, of Helstonburgh, tailor 3
4959260 2344738 2344738 defendant Troute John dyer 593036 593036 Troute, John, of Helstonburgh, dyer 4
4959261 2344738 2344738 defendant Gunne Stephen cordwainer 593036 593036 Gunne, Stephen, of Helstonburgh, cordwainer 5
4959262 2344738 2344738 defendant Seys John glover 593036 593036 Seys, John, of Helstonburgh, glover 6
4959263 2344738 2344738 defendant Cok John tucker 593036 593036 Cok, John, of Helstonburgh, tucker 7
4959264 2344738 2344738 defendant Cok Thomas tucker 593036 593036 Cok, Thomas, of Helstonburgh, tucker 8
4959265 2344738 2344738 defendant atte Ware James cordwainer 593036 593036 atte Ware, James, of Helstonburgh, cordwainer 9
4959266 2344738 2344738 defendant Talscose Richard tailor 728495 728495 Talscose, Richard, of Deverell, tailor 10
4959267 2344738 2344738 defendant Kestell Thomas tucker 593036 593036 Kestell, Thomas, of Helstonburgh, tucker 11
4959268 2344738 2344738 defendant Jeffrey John husbandman 593036 593036 Jeffrey, John, of Helstonburgh, husbandman 12
4959269 2344738 2344738 defendant Nansege William smith 593036 593036 Nansege, William, of Helstonburgh, smith 13
4959270 2344738 2344738 defendant Nansege Thomas smith 593036 593036 Nansege, Thomas, of Helstonburgh, smith 14
4959271 2344738 2344738 defendant Kyrnyk John carpenter 593036 593036 Kyrnyk, John, of Helstonburgh, carpenter 15
4959272 2344738 2344738 defendant Melender Roger miller 593036 593036 Melender, Roger, of Helstonburgh, miller 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);