names

19 rows where case_id = 1959863

✎ 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
3806200 1959863 1959863 plaintiff Vyllers William gent 632360 632360 Vyllers, William, of Bevy, gent 0
3806201 1959863 1959863 plaintiff Villers William gent 629722 629722 Villers, William, of Brokesby, gent 1
3806202 1959863 1959863 plaintiff Nobyll William gent   Nobyll, William, gent 2
3806203 1959863 1959863 plaintiff Letherland John chaplain   Letherland, John, chaplain 3
3806204 1959863 1959863 plaintiff Holme Richard     Holme, Richard 4
3806205 1959863 1959863 defendant Hynde George yeoman 632361 632361 Hynde, George, of Bradegate, yeoman 0
3806206 1959863 1959863 defendant Browne Robert laborer 623680 623680 Browne, Robert, of Whitwyke, laborer 1
3806207 1959863 1959863 defendant Evem John laborer 623680 623680 Evem John, of Whitwyke, laborer 2
3806208 1959863 1959863 defendant Dawes William laborer 623680 623680 Dawes, William, of Whitwyke, laborer 3
3806209 1959863 1959863 defendant Hakytt John laborer 616005 616005 Hakytt, John, of Rotheley, laborer 4
3806210 1959863 1959863 defendant Parker John laborer 611406 611406 Parker, John, of Bredon, laborer 5
3806211 1959863 1959863 defendant Middelton Robert yeoman 629723 629723 Middelton, Robert, of Bradgate, yeoman 6
3806212 1959863 1959863 defendant Walley Richard laborer 632362 632362 Walley, Richard, of Whitwyk, laborer 7
3806213 1959863 1959863 defendant Stevyn John laborer 629725 629725 Stevyn, John, of Osgorthorp, laborer 8
3806214 1959863 1959863 defendant Kydder John laborer 632362 632362 Kydder, John, of Whitwyk, laborer 9
3806215 1959863 1959863 defendant Gryffen John laborer 629726 629726 Gryffen, John, of Darlaston, Staffs, laborer 10
3806216 1959863 1959863 defendant Wirisdale John laborer 587078 587078 Wirisdale, John, of Weddesbury, Staffs, laborer 11
3806217 1959863 1959863 defendant Heycok John laborer 628103 628103 Heycok, John, of Wylnall, Staffs, laborer 12
3806218 1959863 1959863 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);