names

26 rows where case_id = 2470906

✎ 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
5385407 2470906 2470906 plaintiff Bysshop John     Bysshop, John, on his own account 0
5385408 2470906 2470906 defendant Boche Roger   756263 756263 Boche, Roger, of Costesseye 0
5385409 2470906 2470906 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
5385410 2470906 2470906 defendant Norwich John husbandman 596323 596323 Norwich, John, of Cromer, husbandman 2
5385411 2470906 2470906 defendant Elvered John husbandman 586471 586471 Elvered, John, of Aylesham, husbandman 3
5385412 2470906 2470906 defendant Deynes Thomas husbandman 588930 588930 Deynes, Thomas, of Honyng, husbandman 4
5385413 2470906 2470906 defendant Bam John baker 586819 586819 Bam, John, of Worsted, baker 5
5385414 2470906 2470906 defendant Bettys Richard fuller 586471 586471 Bettys, Richard, of Aylesham, fuller 6
5385415 2470906 2470906 defendant Pestell William husbandman 589647 589647 Pestell, William, of Runton, husbandman 7
5385416 2470906 2470906 defendant Bonde Nicholas beer brewer 844850 844850 Bonde, Nicholas, of Walbyrswyk, Suff, beer brewer 8
5385417 2470906 2470906 defendant Synnowe John husbandman 601348 601348 Synnowe, John, of Castelacre, husbandman 9
5385418 2470906 2470906 defendant Mayhewe Henry husbandman 604412 604412 Mayhewe, Henry, of Great Massyngham, husbandman 10
5385419 2470906 2470906 defendant Davy Geoffre husbandman 881305 881305 Davy, Geoffre, of Beston by Spronston, husbandman 11
5385420 2470906 2470906 defendant Brese Robert husbandman 597864 597864 Brese, Robert, of Felsham, husbandman 12
5385421 2470906 2470906 defendant Lamyn William clerk 843159 843159 Lamyn, William, of Thorp Moryeux, Suff, clerk 13
5385422 2470906 2470906 defendant Colyn William (legal representative) 593791 593791 Colyn, William, of Segeford, husbandman, executrix of 14
5385423 2470906 2470906 defendant Colyn Margaret widow 593791 593791 Colyn, Margaret, of Segeford, widow 15
5385424 2470906 2470906 defendant Kerre John (legal representative) 632735 632735 Kerre, John, of Crowemer, executors of 16
5385425 2470906 2470906 defendant Jerveys John husbandman 602134 602134 (Jerveys, John, of Trymyngham, husbandman 17
5385426 2470906 2470906 defendant Grenewey Richard husbandman 632735 632735 Grenewey, Richard, of Crowemer, husbandman 18
5385427 2470906 2470906 defendant Grenewey Agnes     Agnes, his wife 19
5385428 2470906 2470906 defendant Goddys Richard (legal representative) 588021 588021 Goddys, Richard, of Becclys, Suff, executors of 20
5385429 2470906 2470906 defendant Jernegan Osbert gent 599856 599856 (Jernegan, Osbert, of Beccles, Suff, gent 21
5385430 2470906 2470906 defendant Goddis William yeoman 588021 588021 Goddis, William, of Becclys, Suff, yeoman 22
5385431 2470906 2470906 defendant Orlowe William yeoman 588021 588021 Orlowe, William, of Becclys, Suff, yeoman 23
5385432 2470906 2470906 defendant Orlowe Helen     Helen, his wife 24

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