names

27 rows where case_id = 2340028

✎ 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
4943802 2340028 2340028 plaintiff Grevyll John     Grevyll, John 0
4943803 2340028 2340028 defendant Berde Thomas, junior gent 593073 593073 Berde, Thomas, junior, of Burnham, gent 0
4943804 2340028 2340028 defendant Troite John merchant 585925 585925 Troite, John, of Bristol, merchant 1
4943805 2340028 2340028 defendant Harryes William vintner 585925 585925 Harryes, William, of Bristol, vintner 2
4943806 2340028 2340028 defendant Yevan John tailor 585925 585925 Yevan, John, of Bristol, tailor 3
4943807 2340028 2340028 defendant Hurne William yeoman 661089 661089 Hurne, William, of Clyvedon, Soms, yeoman 4
4943808 2340028 2340028 defendant Hurne Richard husbandman 595691 595691 Hurne, Richard, of Clyvedon, husbandman 5
4943809 2340028 2340028 defendant Whitebred John summoner 628386 628386 Whitebred, John, of Walton in Gordano, summoner 6
4943810 2340028 2340028 defendant Frank John husbandman 628386 628386 Frank, John, of Walton in Gordano, husbandman 7
4943811 2340028 2340028 defendant Quyk William yeoman 593073 593073 Quyk, William, of Burnham, yeoman 8
4943812 2340028 2340028 defendant Lake Thomas laborer 755996 755996 Lake, Thomas, of Wroxhale, laborer 9
4943813 2340028 2340028 defendant Innewode Robert husbandman 600320 600320 Innewode, Robert, of Tykenham, husbandman 10
4943814 2340028 2340028 defendant Walsheman John husbandman 601977 601977 Walsheman, John, of Westwyke, husbandman 11
4943815 2340028 2340028 defendant Harryes John weaver 595691 595691 Harryes, John, of Clyvedon, weaver 12
4943816 2340028 2340028 defendant Underwode William laborer 595691 595691 Underwode, William, of Clyvedon, laborer 13
4943817 2340028 2340028 defendant Underwode John tailor 595691 595691 Underwode, John, of Clyvedon, tailor 14
4943818 2340028 2340028 defendant Dewedon Thomas laborer 595691 595691 Dewedon, Thomas, of CLyvedon, laborer 15
4943819 2340028 2340028 defendant Barry John, junior husbandman 825518 825518 Barry, John, junior, of Weston in Gordano, husbandman 16
4943820 2340028 2340028 defendant Toky John laborer 589055 589055 Toky, John, of Porteshede, laborer 17
4943821 2340028 2340028 defendant Sylly William husbandman 595691 595691 Sylly, William, of Clyvedon, husbandman 18
4943822 2340028 2340028 defendant Brether Thomas husbandman 595691 595691 Brether, Thomas, of Clyvedon, husbandman 19
4943823 2340028 2340028 defendant Rumney John husbandman 824442 824442 Rumney, John, of Congeresbury, husbandman 20
4943824 2340028 2340028 defendant Everard Robert husbandman 628386 628386 Everard, Robert, of Walton in Gordano, husbandman 21
4943825 2340028 2340028 defendant Beest William husbandman 825519 825519 Beest, William, of Poerteshede, husbandman 22
4943826 2340028 2340028 defendant Gybbys John husbandman 600320 600320 Gybbys, John, of Tykenham, husbandman 23
4943827 2340028 2340028 defendant Underwode Henry laborer 595691 595691 Underwode, Henry, of Clyvedon, laborer 24
4943828 2340028 2340028 defendant Kyng John husbandman 595691 595691 Kyng, John, of Clyvedon, husbandman 25

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