names

14 rows where case_id = 2471898

✎ 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
5388939 2471898 2471898 plaintiff Hert William gent   Hert, William, gent, on his own account 0
5388940 2471898 2471898 defendant Desale Richard husbandman 586425 586425 Desale, Richard, of Braughyng, husbandman 0
5388941 2471898 2471898 defendant Carter John tailor 586059 586059 Carter, John, of Ware, tailor 1
5388942 2471898 2471898 defendant Walcote Roger tailor 585869 585869 Walcote, Roger, of London, tailor 2
5388943 2471898 2471898 defendant Adam Edmund husbandman 587629 587629 Adam, Edmund, of Chesthunt, husbandman 3
5388944 2471898 2471898 defendant Pyke John husbandman 587629 587629 Pyke, John, of Chesthunt, husbandman 4
5388945 2471898 2471898 defendant Marchall Simon yeoman 586059 586059 Marchall, Simon, of Ware, yeoman 5
5388946 2471898 2471898 defendant Kyng James husbandman 881784 881784 Kyng, James, of High Crosse in Stondon, husbandman 6
5388947 2471898 2471898 defendant Chymneys Henry butcher 624055 624055 Chymneys, Henry, of Ryston, butcher 7
5388948 2471898 2471898 defendant Sewester William, junior husbandman 587532 587532 Sewester, William, junior, of Asshewell, husbandman 8
5388949 2471898 2471898 defendant Ploume William   881785 881785 Ploume, William, of Little Mundon, tile maker 9
5388950 2471898 2471898 defendant Synyer William   589206 589206 Synyer, William, of Buntyngford, arrow maker 10
5388951 2471898 2471898 defendant Lord John husbandman 604444 604444 Lord, John, of Great Munden, husbandman 11
5388952 2471898 2471898 defendant Chylde Peter husbandman 587724 587724 Chylde, Peter, of North Mymmes, husbandman 12

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