names

19 rows where case_id = 1959862

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3806181 1959862 1959862 plaintiff Vyllers William gent 632360 632360 Vyllers, William, of Bevy, gent 0
3806182 1959862 1959862 plaintiff Villers William gent 629722 629722 Villers, William, of Brokesby, gent 1
3806183 1959862 1959862 plaintiff Nobyll William gent   Nobyll, William, gent 2
3806184 1959862 1959862 plaintiff Letherland John chaplain   Letherland, John, chaplain 3
3806185 1959862 1959862 plaintiff Holme Richard     Holme, Richard 4
3806186 1959862 1959862 defendant Hynde George yeoman 632361 632361 Hynde, George, of Bradegate, yeoman 0
3806187 1959862 1959862 defendant Browne Robert laborer 623680 623680 Browne, Robert, of Whitwyke, laborer 1
3806188 1959862 1959862 defendant Evem John laborer 623680 623680 Evem John, of Whitwyke, laborer 2
3806189 1959862 1959862 defendant Dawes William laborer 623680 623680 Dawes, William, of Whitwyke, laborer 3
3806190 1959862 1959862 defendant Hakytt John laborer 616005 616005 Hakytt, John, of Rotheley, laborer 4
3806191 1959862 1959862 defendant Parker John laborer 611406 611406 Parker, John, of Bredon, laborer 5
3806192 1959862 1959862 defendant Middelton Robert yeoman 629723 629723 Middelton, Robert, of Bradgate, yeoman 6
3806193 1959862 1959862 defendant Walley Richard laborer 632362 632362 Walley, Richard, of Whitwyk, laborer 7
3806194 1959862 1959862 defendant Stevyn John laborer 629725 629725 Stevyn, John, of Osgorthorp, laborer 8
3806195 1959862 1959862 defendant Kydder John laborer 632362 632362 Kydder, John, of Whitwyk, laborer 9
3806196 1959862 1959862 defendant Gryffen John laborer 629726 629726 Gryffen, John, of Darlaston, Staffs, laborer 10
3806197 1959862 1959862 defendant Wirisdale John laborer 587078 587078 Wirisdale, John, of Weddesbury, Staffs, laborer 11
3806198 1959862 1959862 defendant Heycok John laborer 628103 628103 Heycok, John, of Wylnall, Staffs, laborer 12
3806199 1959862 1959862 defendant Thomson Edward laborer 629728 629728 Thomson, Edward, of Darlaston, laborer 13

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