names

17 rows where case_id = 2324908

✎ 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
4894319 2324908 2324908 plaintiff Mulle Thomas esq   Mulle, Thomas, esq 0
4894320 2324908 2324908 defendant Longeford Philip yeoman 818453 818453 Longeford, Philip, of Topesley, yeoman 0
4894321 2324908 2324908 defendant Barbour David   586208 586208 Barbour, David, of Hereford, wax maker 1
4894322 2324908 2324908 defendant Gerard William tailor 586208 586208 Gerard, William, of Hereford, tailor 2
4894323 2324908 2324908 defendant Appurley Richard, senior yeoman 818454 818454 Appurley, Richard, senior, of Magna Markele, yeoman 3
4894324 2324908 2324908 defendant Appurley Richard, junior yeoman 818454 818454 Appurley, Richard, junior, of Magna Markele, yeoman 4
4894325 2324908 2324908 defendant Shelwyk Ralph yeoman 592030 592030 Shelwyk, Ralph, of Kynges Pewyn, yeoman 5
4894326 2324908 2324908 defendant Harryes Richard ironmonger 590574 590574 Harryes, Richard, of Webbeley, ironmonger 6
4894327 2324908 2324908 defendant Tyler Hugh yeoman 592030 592030 Tyler, Hugh, of Kynges Pewyn, yeoman 7
4894328 2324908 2324908 defendant Gardener Richard yeoman 818455 818455 Gardener, Richard, of Canon Pewyn, yeoman 8
4894329 2324908 2324908 defendant Wolrych John yeoman 818456 818456 Wolrych, John, of Folkenhope, yeoman 9
4894330 2324908 2324908 defendant Hopton John yeoman 818457 818457 Hopton, John, of Haymon Frome, yeoman 10
4894331 2324908 2324908 defendant Kynge Simon yeoman 593353 593353 Kynge, Simon, of Bishops Frome, yeoman 11
4894332 2324908 2324908 defendant Hayward Thomas husbandman 594529 594529 Hayward, Thomas, of Bodenham, husbandman 12
4894333 2324908 2324908 defendant Brokehampton John husbandman 594529 594529 Brokehampton, John, of Bodenham, husbandman 13
4894334 2324908 2324908 defendant Brokehampton Philip yeoman 594529 594529 Brokehampton, Philip, of Bodenham, yeoman 14
4894335 2324908 2324908 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);