names

26 rows where case_id = 2474374

✎ 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
5397547 2474374 2474374 plaintiff Bysshop John     Bysshop, John 0
5397548 2474374 2474374 defendant Goche Roger yeoman 590409 590409 Goche, Roger, of Costessey, yeoman 0
5397549 2474374 2474374 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
5397550 2474374 2474374 defendant Norwich John husbandman 596744 596744 Norwich, John, of Crowmer, husbandman 2
5397551 2474374 2474374 defendant Elvered John husbandman 586471 586471 Elvered, John, of Aylesham, husbandman 3
5397552 2474374 2474374 defendant Deynes Thomas husbandman 588930 588930 Deynes, Thomas, of Honyng, husbandman 4
5397553 2474374 2474374 defendant Bain John baker 586819 586819 Bain, John, of Worsted, baker 5
5397554 2474374 2474374 defendant Bettys Richard fuller 586471 586471 Bettys, Richard, of Aylesham, fuller 6
5397555 2474374 2474374 defendant Pestell William husbandman 589647 589647 Pestell, William, of Runton, husbandman 7
5397556 2474374 2474374 defendant Bonde Nicholas beer brewer 844850 844850 Bonde, Nicholas, of Walbyrswyk, Suff, beer brewer 8
5397557 2474374 2474374 defendant Synnowe John husbandman 604697 604697 Synnowe, John, of Castle Acre, husbandman 9
5397558 2474374 2474374 defendant Mayhewe Henry husbandman 604412 604412 Mayhewe, Henry, of Great Massyngham, husbandman 10
5397559 2474374 2474374 defendant Davy Geoffrey husbandman 881305 881305 Davy, Geoffrey, of Beston by Spronston, husbandman 11
5397560 2474374 2474374 defendant Brese Robert husbandman 597864 597864 Brese, Robert, of Felsham, husbandman 12
5397561 2474374 2474374 defendant Lamyn William clerk 843159 843159 Lamyn, William, of Thorp Moryeux, Suff, clerk 13
5397562 2474374 2474374 defendant Colyn William (legal representative) 593791 593791 Colyn, William, of Segeford, husbandman, executrix of 14
5397563 2474374 2474374 defendant Colyn Margaret widow 593791 593791 Colyn, Margaret, of Segeford, widow 15
5397564 2474374 2474374 defendant Kerre John   596744 596744 Kerre, John, of Crowmer 16
5397565 2474374 2474374 defendant Jervais John husbandman 882984 882984 (Jervais, John, of Typmyngham, husbandman 17
5397566 2474374 2474374 defendant Grenewey Richard husbandman 596744 596744 Grenewey, Richard, of Crowmer, husbandman 18
5397567 2474374 2474374 defendant Grenewey Agnes     Agnes, his wife 19
5397568 2474374 2474374 defendant Goddys Richard (legal representative) 596298 596298 Goddys, Richard, of Beccles, yeoman, executors of 20
5397569 2474374 2474374 defendant Jernegan Osbert gent 599856 599856 (Jernegan, Osbert, of Beccles, Suff, gent 21
5397570 2474374 2474374 defendant Goddys William yeoman 596298 596298 Goddys, William, of Beccles, yeoman 22
5397571 2474374 2474374 defendant Orlowe William yeoman 596298 596298 Orlowe, William, of Beccles, yeoman 23
5397572 2474374 2474374 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);