names

14 rows where case_id = 2475536

✎ 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
5401654 2475536 2475536 plaintiff Hert William gent 585869 585869 Hert, William, of London, gent 0
5401655 2475536 2475536 defendant Desale Richard husbandman 586425 586425 Desale, Richard, of Braughyng, husbandman 0
5401656 2475536 2475536 defendant Carter John tailor 586059 586059 Carter, John, of Ware, tailor 1
5401657 2475536 2475536 defendant Walcote Roger tailor 585869 585869 Walcote, Roger, of London, tailor 2
5401658 2475536 2475536 defendant Adam Edmund husbandman 587629 587629 Adam, Edmund, of Chesthunt, husbandman 3
5401659 2475536 2475536 defendant Pyke John husbandman 587629 587629 Pyke, John, of Chesthunt, husbandman 4
5401660 2475536 2475536 defendant Marchall Simon yeoman 586059 586059 Marchall, Simon, of Ware, yeoman 5
5401661 2475536 2475536 defendant Kyng James husbandman 883567 883567 Kyng, James, of Hygh Crosse in Stondon, husbandman 6
5401662 2475536 2475536 defendant Chaunceys Henry butcher 586935 586935 Chaunceys, Henry, of Royston, butcher 7
5401663 2475536 2475536 defendant Sewester William, junior yeoman 587532 587532 Sewester, William, junior, of Asshewell, yeoman 8
5401664 2475536 2475536 defendant Plumme William   782469 782469 Plumme, William, of Little Monden, tile maker 9
5401665 2475536 2475536 defendant Syvyer William Fletcher 883569 883569 Syvyer, William, of Buntygnford, Fletcher 10
5401666 2475536 2475536 defendant Lorde John husbandman 883570 883570 Lorde, John, of Great Monden, husbandman 11
5401667 2475536 2475536 defendant Chylde Peter husbandman 587925 587925 Chylde, Peter, of North Mymes, 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);