names

49 rows where case_id = 1873644

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619355 1873644 1873644 plaintiff Howard Elizabeth Duchess of Norfolk   Howard, Elizabeth, Duchess of Norfolk 0
3619356 1873644 1873644 defendant Topclyff John gent 595190 595190 Topclyff, John, of Gaynysburgh, gent 0
3619357 1873644 1873644 defendant Portyngton Edward gent 595190 595190 Portyngton, Edward, of Gaynysburgh, gent 1
3619358 1873644 1873644 defendant Cropper John gent 595190 595190 Cropper, John, of Gaynysburgh, gent 2
3619359 1873644 1873644 defendant Denman Williamof Gaynysburgh gent   Denman, Williamof Gaynysburgh, gent 3
3619360 1873644 1873644 defendant Draper John, senior yeoman 595190 595190 Draper, John, senior, of Gaynysburgh, yeoman 4
3619361 1873644 1873644 defendant brownn John yeoman 595190 595190 brownn, John, of Gaynysburgh, yeoman 5
3619362 1873644 1873644 defendant Stode John yeoman 595190 595190 Stode, John, of Gaynysburgh, yeoman 6
3619363 1873644 1873644 defendant Sandys Christopher yeoman 595190 595190 Sandys, Christopher, of Gaynysburgh, yeoman 7
3619364 1873644 1873644 defendant Cuttill Richard yeoman 595190 595190 Cuttill, Richard, of Gaynysburgh, yeoman 8
3619365 1873644 1873644 defendant Cutberd John     Cutberd, John 9
3619366 1873644 1873644 defendant Stasley Robert     Stasley, Robert 10
3619367 1873644 1873644 defendant Draper John, junior     Draper, John, junior 11
3619368 1873644 1873644 defendant Twysaday John     Twysaday, John 12
3619369 1873644 1873644 defendant Hanworth Thomas     Hanworth, Thomas 13
3619370 1873644 1873644 defendant Topclyff Richard     Topclyff, Richard 14
3619371 1873644 1873644 defendant Nayller John     Nayller, John 15
3619372 1873644 1873644 defendant Spenser John     Spenser, John 16
3619373 1873644 1873644 defendant Clayton Robert, senior     Clayton, Robert, senior 17
3619374 1873644 1873644 defendant Mercer Thomas     Mercer, Thomas 18
3619375 1873644 1873644 defendant Brande William     Brande, William 19
3619376 1873644 1873644 defendant Fenys William     Fenys, William 20
3619377 1873644 1873644 defendant Swan Robert     Swan, Robert 21
3619378 1873644 1873644 defendant Taillour John     Taillour, John 22
3619379 1873644 1873644 defendant Clayton Robert     Clayton, Robert 23
3619380 1873644 1873644 defendant Grenefeld John     Grenefeld, John 24
3619381 1873644 1873644 defendant Tipping Elias     Tipping, Elias 25
3619382 1873644 1873644 defendant Waymysley Elias     Waymysley, Elias 26
3619383 1873644 1873644 defendant Swan Leo     Swan, Leo 27
3619384 1873644 1873644 defendant Rechardson Robert     Rechardson, Robert 28
3619385 1873644 1873644 defendant Dobson John     Dobson, John 29
3619386 1873644 1873644 defendant Hordesey John     Hordesey, John 30
3619387 1873644 1873644 defendant Herdsay William     Herdsay, William 31
3619388 1873644 1873644 defendant Laysell Richard     Laysell, Richard 32
3619389 1873644 1873644 defendant Reynard Robert     Reynard, Robert 33
3619390 1873644 1873644 defendant Smyth John     Smyth, John 34
3619391 1873644 1873644 defendant Gryngley Hugh     Gryngley, Hugh 35
3619392 1873644 1873644 defendant Habelyn Thomas     Habelyn, Thomas 36
3619393 1873644 1873644 defendant North Richard     North, Richard 37
3619394 1873644 1873644 defendant Wyndayle William     Wyndayle, William 38
3619395 1873644 1873644 defendant Coo John     Coo, John 39
3619396 1873644 1873644 defendant Thuresby John     Thuresby, John 40
3619397 1873644 1873644 defendant Warderoppe Robert     Warderoppe, Robert 41
3619398 1873644 1873644 defendant Stirton Thomas     Stirton, Thomas 42
3619399 1873644 1873644 defendant Larsyll Richard     Larsyll, Richard 43
3619400 1873644 1873644 defendant Morland Thomas     Morland, Thomas 44
3619401 1873644 1873644 defendant Chapman John     Chapman, John 45
3619402 1873644 1873644 defendant Makelyn Thomas     Makelyn, Thomas 46
3619403 1873644 1873644 defendant Hardysse Thomas     Hardysse, Thomas 47

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