names

21 rows where case_id = 2449734

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5315606 2449734 2449734 plaintiff Copuldyk David (legal representative)   Copuldyk, David, executors of 0
5315607 2449734 2449734 plaintiff Copuldyk Joan widow   (Copuldyk, Joan, widow 1
5315608 2449734 2449734 plaintiff Cok Richard     Cok, Richard 2
5315609 2449734 2449734 defendant Aleyn John merchant 586286 586286 Aleyn, John, of Boston, merchant 0
5315610 2449734 2449734 defendant Laund Robert gent 586846 586846 Laund, Robert, of Lincoln, gent 1
5315611 2449734 2449734 defendant Wolmer Richard gent 589593 589593 Wolmer, Richard, of Swyneshed, gent 2
5315612 2449734 2449734 defendant Bank John yeoman 594868 594868 Bank, John, of Kyrketon in Holand, yeoman 3
5315613 2449734 2449734 defendant Austyn Henry husbandman 586750 586750 Austyn, Henry, of Surflete, husbandman 4
5315614 2449734 2449734 defendant Carter William mercer 872477 872477 Carter, William, of Cunsby [Coningsby], mercer 5
5315615 2449734 2449734 defendant Rote Richard yeoman 603490 603490 Rote, Richard, of Wyberton, yeoman 6
5315616 2449734 2449734 defendant Holand John husbandman 593335 593335 Holand, John, of Toft, husbandman 7
5315617 2449734 2449734 defendant Leke John mariner 586286 586286 Leke, John, of Boston, mariner 8
5315618 2449734 2449734 defendant Hamond John butcher 607914 607914 Hamond, John, of Wrangle, butcher 9
5315619 2449734 2449734 defendant Galand Robert boatman 586286 586286 Galand, Robert, of Boston, boatman 10
5315620 2449734 2449734 defendant Parker John husbandman 596437 596437 Parker, John, of Soterton, husbandman 11
5315621 2449734 2449734 defendant Bonham Thomas smith 586286 586286 Bonham, Thomas, of Boston, smith 12
5315622 2449734 2449734 defendant Sylam Thomas husbandman 860199 860199 Sylam, Thomas, of Benyngton in Holand, husbandman 13
5315623 2449734 2449734 defendant Claymond William husbandman 791333 791333 Claymond, William, of Kyrkton in Holand, husbandman 14
5315624 2449734 2449734 defendant Whitefote Richard laborer 586286 586286 Whitefote, Richard, of Boston, laborer 15
5315625 2449734 2449734 defendant Oliffe William yeoman 586286 586286 Oliffe, William, of Boston, yeoman 16
5315626 2449734 2449734 defendant Monke William yeoman 597328 597328 Monke, William, of Leke, yeoman 17

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