names

46 rows where case_id = 1873643

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619309 1873643 1873643 plaintiff Howard Elizabeth Duchess of Norfolk   Howard, Elizabeth, Duchess of Norfolk 0
3619310 1873643 1873643 defendant Topclyff John gent 595190 595190 Topclyff, John, of Gaynysburgh, gent 0
3619311 1873643 1873643 defendant Portyngton Edward gent 595190 595190 Portyngton, Edward, of Gaynysburgh, gent 1
3619312 1873643 1873643 defendant Cropper John gent 595190 595190 Cropper, John, of Gaynysburgh, gent 2
3619313 1873643 1873643 defendant Denman William gent 595191 595191 Denman, William, of Wynysburgh, gent 3
3619314 1873643 1873643 defendant Draper John, senior yeoman 595190 595190 Draper, John, senior, of Gaynysburgh, yeoman 4
3619315 1873643 1873643 defendant Browene John yeoman 595190 595190 Browene, John, of Gaynysburgh, yeoman 5
3619316 1873643 1873643 defendant Stode John yeoman 595190 595190 Stode, John, of Gaynysburgh, yeoman 6
3619317 1873643 1873643 defendant Sandes Christopher yeoman 595190 595190 Sandes, Christopher, of Gaynysburgh, yeoman 7
3619318 1873643 1873643 defendant Cuttill Richard yeoman 595190 595190 Cuttill, Richard, of Gaynysburgh, yeoman 8
3619319 1873643 1873643 defendant Cutberd John yeoman 595190 595190 Cutberd, John, of Gaynysburgh, yeoman 9
3619320 1873643 1873643 defendant Staysley Robert draper 595190 595190 Staysley, Robert, of Gaynysburgh, draper 10
3619321 1873643 1873643 defendant Twysaday John mercer 595190 595190 Twysaday, John, of Gaynysburgh, mercer 11
3619322 1873643 1873643 defendant Hanworth Thomas gent 595190 595190 Hanworth, Thomas, of Gaynysburgh, gent 12
3619323 1873643 1873643 defendant Draper John, junior yeoman 595190 595190 Draper, John, junior, of Gaynysburgh, yeoman 13
3619324 1873643 1873643 defendant Topclyff Richard esq 593077 593077 Topclyff, Richard, of Somerby, esq 14
3619325 1873643 1873643 defendant Nayller John yeoman 593077 593077 Nayller, John, of Somerby, yeoman 15
3619326 1873643 1873643 defendant Spenser John yeoman 595192 595192 Spenser, John, of Lee, yeoman 16
3619327 1873643 1873643 defendant Clayton Robert, senior yeoman 595192 595192 Clayton, Robert, senior, of Lee, yeoman 17
3619328 1873643 1873643 defendant Mercer Thomas yeoman 595193 595193 Mercer, Thomas, of Torkyssey, yeoman 18
3619329 1873643 1873643 defendant Brande William butcher 595193 595193 Brande, William, of Torkyssey, butcher 19
3619330 1873643 1873643 defendant Fenys William yeoman 595190 595190 Fenys, William, of Gaynysburgh, "catour", Swan, Robert, of Kenardsfery, yeoman 20
3619331 1873643 1873643 defendant Taillour John laborer 586397 586397 Taillour, John, of Morton, laborer 21
3619332 1873643 1873643 defendant Clayton Richard yeoman 586992 586992 Clayton, Richard, of Ingham, yeoman 22
3619333 1873643 1873643 defendant Hall Thomas yeoman 586992 586992 Hall, Thomas, of Ingham, yeoman 23
3619334 1873643 1873643 defendant Clayton Robert, junior yeoman 595192 595192 Clayton, Robert, junior, of Lee, yeoman 24
3619335 1873643 1873643 defendant Grenefeld John yeoman 595195 595195 Grenefeld, John, of Est Stokwith, yeoman 25
3619336 1873643 1873643 defendant Tippyng Elias yeoman 595190 595190 Tippyng, Elias, of Gaynysburgh, yeoman 26
3619337 1873643 1873643 defendant Waymysley Elias clerk 595190 595190 Waymysley, Elias, of Gaynysburgh, clerk 27
3619338 1873643 1873643 defendant Swan Leo tailor 595190 595190 Swan, Leo, of Gaynysburgh, tailor 28
3619339 1873643 1873643 defendant Richardson Robert tailor 595190 595190 Richardson, Robert, of Gaynysburgh, tailor 29
3619340 1873643 1873643 defendant Dobson John glover 595190 595190 Dobson, John, of Gaynysburgh, glover 30
3619341 1873643 1873643 defendant Hordesey John gent 595196 595196 Hordesey, John, of Lenerton, Notts, gent 31
3619342 1873643 1873643 defendant Herdesey William gent 588482 588482 Herdesey, William, of Lenerton, gent 32
3619343 1873643 1873643 defendant Laysell Richard gent 595197 595197 Laysell, Richard, of Sturton, Notts, gent 33
3619344 1873643 1873643 defendant Raynard Robert gent 595198 595198 Raynard, Robert, of Douneham, Notts, gent 34
3619345 1873643 1873643 defendant Smyth John yeoman 588482 588482 Smyth, John, of Lenerton, yeoman 35
3619346 1873643 1873643 defendant Gryngley Hugh husbandman 595199 595199 Gryngley, Hugh, of Gryngley, Notts, husbandman 36
3619347 1873643 1873643 defendant Thuresby John husbandman 595200 595200 Thuresby, John, of Sturton, husbandman 37
3619348 1873643 1873643 defendant Warderoppe Robert yeoman 595200 595200 Warderoppe, Robert, of Sturton, yeoman 38
3619349 1873643 1873643 defendant Sturton Thomas yeoman 595200 595200 Sturton, Thomas, of Sturton, yeoman 39
3619350 1873643 1873643 defendant Larsyll Richard gent 595201 595201 Larsyll, Richard, of Leneton, gent 40
3619351 1873643 1873643 defendant Morlond Thomas yeoman 595202 595202 Morlond, Thomas, of Swanby, Notts, yeoman 41
3619352 1873643 1873643 defendant Chapman John yeoman 595203 595203 Chapman, John, of Dawetre, Yorks, yeoman 42
3619353 1873643 1873643 defendant Makalyn Thomas yeoman 595204 595204 Makalyn, Thomas, of Skaftworth, Notts, yeoman 43
3619354 1873643 1873643 defendant Hardysshe Thomas gent 595205 595205 Hardysshe, Thomas, of Claworth, Notts, gent 44

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