names

30 rows where case_id = 2535711

✎ 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
5602644 2535711 2535711 plaintiff Mordaunt William     Mordaunt, William 0
5602645 2535711 2535711 defendant Vaghan John Lloid esq 904828 904828 Vaghan, John Lloid, of Mayner Burye, Penbroch, esq 0
5602646 2535711 2535711 defendant Perrot Owen esq 904829 904829 Perrot, Owen, of Haraldeston, Penbroch, esq 1
5602647 2535711 2535711 defendant ap Phylypp Thomas esq 904830 904830 ap Phylypp, Thomas, of Pylton, Penbroch, esq 2
5602648 2535711 2535711 defendant Walter John esq 904831 904831 Walter, John, of Tembia, Penbroch, esq 3
5602649 2535711 2535711 defendant Nycholas John tailor 585869 585869 Nycholas, John, of London, tailor 4
5602650 2535711 2535711 defendant Lamprey Andrew grocer 585869 585869 Lamprey, Andrew, of London, grocer 5
5602651 2535711 2535711 defendant Nevyle William merchant tailor 585869 585869 Nevyle, William, of London, merchant tailor 6
5602652 2535711 2535711 defendant Tremere Henry   590280 590280 Tremere, Henry, of Hertfeld, Sussex, gun maker 7
5602653 2535711 2535711 defendant Sasse Nicholas   616267 616267 Sasse, Nicholas, of Herfeld, gun maker 8
5602654 2535711 2535711 defendant Scargyll William   904834 904834 Scargyll, William, of Thorp under Rothewell Hay, Yorks, knight 9
5602655 2535711 2535711 defendant Chaloner John gent 670695 670695 Chaloner, John, of Stanley, Yorks, gent 10
5602656 2535711 2535711 defendant Alburgh Richard   619981 619981 Alburgh, Richard, of Alburgh, Yorks, knight 11
5602657 2535711 2535711 defendant Stapulton Brian   630792 630792 Stapulton, Brian, of Carleton, Yorks, knight 12
5602658 2535711 2535711 defendant Evers Ralph   682965 682965 Evers, Ralph, of Brompton, Yorks, knight 13
5602659 2535711 2535711 defendant Sanford Ralph gent 825400 825400 Sanford, Ralph, of Thorp Salveyn, Yorks, gent 14
5602660 2535711 2535711 defendant Kemp John gent 604789 604789 Kemp, John, of Pykeryng, Yorks, gent 15
5602661 2535711 2535711 defendant Saltumstall Gilbert gent 904837 904837 Saltumstall, Gilbert, of Northowrum, Yorks, gent 16
5602662 2535711 2535711 defendant Otes Robert mercer 588150 588150 Otes, Robert, of Halyfax, Yorks, mercer 17
5602663 2535711 2535711 defendant Elys Thomas gent 619188 619188 Elys, Thomas, of Berwyk, Yorks, gent 18
5602664 2535711 2535711 defendant Meryfeld William esq 904838 904838 Meryfeld, William, of Holeyfeld, Yorks, esq 19
5602665 2535711 2535711 defendant Calverley Richard gent 608158 608158 Calverley, Richard, of Calverley, Yorks, gent 20
5602666 2535711 2535711 defendant Symart Pouncelet   590277 590277 Symart, Pouncelet, of Hertfeld, iron founder 21
5602667 2535711 2535711 defendant Robyn Calixtus   590277 590277 Robyn, Calixtus, of Hertfeld, iron finer 22
5602668 2535711 2535711 defendant Mershe Thomas yeoman 586528 586528 Mershe, Thomas, of Ware, Herts, yeoman 23
5602669 2535711 2535711 defendant Matson Simon brewer 586059 586059 Matson, Simon, of Ware, brewer 24
5602670 2535711 2535711 defendant Whyte Thomas couper 586059 586059 Whyte, Thomas, of Ware, couper 25
5602671 2535711 2535711 defendant Skarlet John yeoman 904841 904841 Skarlet, John, of Huddeston, Herts, yeoman 26
5602672 2535711 2535711 defendant Massy John yeoman 586033 586033 Massy, John, of Westminster, yeoman 27
5602673 2535711 2535711 defendant Parker Richard yeoman 904842 904842 Parker, Richard, of Huddeston, yeoman 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);