names

30 rows where case_id = 1908315

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643225 1908315 1908315 plaintiff Cotterell John     Cotterell, John 0
3643226 1908315 1908315 defendant Myatte James yeoman 600935 600935 Myatte, James, of Wursburgdale, Yorks, yeoman 0
3643227 1908315 1908315 defendant Grene Thomas yeoman 600936 600936 Grene, Thomas, of Kysburgh, Yorks, yeoman 1
3643228 1908315 1908315 defendant Rysheton John gent 600937 600937 Rysheton, John, of Byrtwythall, Yorks, gent 2
3643229 1908315 1908315 defendant Burdett Richard gent 600938 600938 Burdett, Richard, of Denby Hall, Yorks, gent 3
3643230 1908315 1908315 defendant Wodcok Henry yeoman 600939 600939 Wodcok, Henry, of Denbe, yeoman 4
3643231 1908315 1908315 defendant Swyft Richard yeoman 586016 586016 Swyft, Richard, of Denby, yeoman 5
3643232 1908315 1908315 defendant Sparke Robert yeoman 600940 600940 Sparke, Robert, of Darton, Yorks, yeoman 6
3643233 1908315 1908315 defendant Parkyn John yeoman 600941 600941 Parkyn, John, of Barnsley, yeoman 7
3643234 1908315 1908315 defendant Marsden James yeoman 600942 600942 Marsden, James, of Carlecotes, Yorks, yeoman 8
3643235 1908315 1908315 defendant Lowe Ralph     Lowe, Ralph 9
3643236 1908315 1908315 defendant Hurst Ralph     Hurst, Ralph 10
3643237 1908315 1908315 defendant Berde Thomas     Berde, Thomas 11
3643238 1908315 1908315 defendant Robert Thomas     Robert, Thomas 12
3643239 1908315 1908315 defendant Stanyford Richard     Stanyford, Richard 13
3643240 1908315 1908315 defendant Grene William     Grene, William 14
3643241 1908315 1908315 defendant Denby Robert     Denby, Robert 15
3643242 1908315 1908315 defendant Sonyar Richard     Sonyar, Richard 16
3643243 1908315 1908315 defendant Adde Richard     Adde, Richard 17
3643244 1908315 1908315 defendant Yssotte Richard     Yssotte, Richard 18
3643245 1908315 1908315 defendant Webster Richard     Webster, Richard 19
3643246 1908315 1908315 defendant Shepard Richard     Shepard, Richard 20
3643247 1908315 1908315 defendant Hagh James     Hagh, James 21
3643248 1908315 1908315 defendant Byngley Christopher     Byngley, Christopher 22
3643249 1908315 1908315 defendant Jekynson John     Jekynson, John 23
3643250 1908315 1908315 defendant Preest William     Preest, William 24
3643251 1908315 1908315 defendant Hyll Thomas     Hyll, Thomas 25
3643252 1908315 1908315 defendant Lee Thomas     Lee, Thomas 26
3643253 1908315 1908315 defendant Smavent John     Smavent, John 27
3643254 1908315 1908315 defendant Marshall Richard     Marshall, Richard 28

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