names

27 rows where place_id = 595190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
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
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
3619330 1873643 1873643 defendant Fenys William yeoman 595190 595190 Fenys, William, of Gaynysburgh, "catour", Swan, Robert, of Kenardsfery, yeoman 20
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
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
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

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