names

17 rows where case_id = 2325599

✎ 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
4896579 2325599 2325599 plaintiff Mulle Thomas esq   Mulle, Thomas, esq 0
4896580 2325599 2325599 defendant Longeford Philip yeoman 818453 818453 Longeford, Philip, of Topesley, yeoman 0
4896581 2325599 2325599 defendant Barbour David   586208 586208 Barbour, David, of Hereford, wax maker 1
4896582 2325599 2325599 defendant Gerald William tailor 586208 586208 Gerald, William, of Hereford, tailor 2
4896583 2325599 2325599 defendant Appurley Richard, junior yeoman 818454 818454 Appurley, Richard, junior, of Magna Markele, yeoman 3
4896584 2325599 2325599 defendant Shelwyke Ralph husbandman 818731 818731 Shelwyke, Ralph, of Wolnethope, husbandman 4
4896585 2325599 2325599 defendant ap Thomas John yeoman 592030 592030 ap Thomas, John, of Kynges Pewyn, yeoman 5
4896586 2325599 2325599 defendant Harryes Richard ironmonger 590574 590574 Harryes, Richard, of Webbeley, ironmonger 6
4896587 2325599 2325599 defendant Tyler Hugh yeoman 818732 818732 Tyler, Hugh, of Kyngges Pewyn, yeoman 7
4896588 2325599 2325599 defendant Gardener Richard yeoman 818455 818455 Gardener, Richard, of Canon Pewyn, yeoman 8
4896589 2325599 2325599 defendant Wolrych John yeoman 602093 602093 Wolrych, John, of Fowenhope, yeoman 9
4896590 2325599 2325599 defendant Hopton John yeoman 818733 818733 Hopton, John, of Haymons Frome, yeoman 10
4896591 2325599 2325599 defendant Kynge Simon yeoman 593353 593353 Kynge, Simon, of Bishops Frome, yeoman 11
4896592 2325599 2325599 defendant Hayward Thomas husbandman 594529 594529 Hayward, Thomas, of Bodenham, husbandman 12
4896593 2325599 2325599 defendant Brokehampton John husbandman 594529 594529 Brokehampton, John, of Bodenham, husbandman 13
4896594 2325599 2325599 defendant Brokehampton Philip yeoman 594529 594529 Brokehampton, Philip, of Bodenham, yeoman 14
4896595 2325599 2325599 defendant Fourches John husbandman 594529 594529 Fourches, John, of Bodenham, husbandman 15

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