names

27 rows where case_id = 2265347

✎ 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
4699663 2265347 2265347 plaintiff Dynham John knight   Dynham, John, knight 0
4699664 2265347 2265347 defendant Litelton Robert gent 781811 781811 Litelton, Robert, of Compton Pole, gent 0
4699665 2265347 2265347 defendant Kyrkham Walter gent 593607 593607 Kyrkham, Walter, of Peynton, gent 1
4699666 2265347 2265347 defendant Hurne William jouter 593607 593607 Hurne, William, of Peynton, jouter 2
4699667 2265347 2265347 defendant Higham Robert husbandman 908376 908376 Higham Robert, of Ippel Penne, husbandman 3
4699668 2265347 2265347 defendant Rider John, sen weaver 781813 781813 Rider, John, sen, of Combe Fysshacre, weaver 4
4699669 2265347 2265347 defendant Lytelton Robert husbandman 781813 781813 Lytelton, Robert, of Combe Fysshacre, husbandman 5
4699670 2265347 2265347 defendant Lancastell John   781812 781812 Lancastell, John, of Ippelpenne, mason 6
4699671 2265347 2265347 defendant Yonge John butcher 781813 781813 Yonge, John, of Combe Fysshacre, butcher 7
4699672 2265347 2265347 defendant Bon John laborer 786869 786869 Bon, John, of Ippelppenne, laborer 8
4699673 2265347 2265347 defendant Howelys John tailor 786870 786870 Howelys, John, of Totenys or Totnes, tailor 9
4699674 2265347 2265347 defendant Lucas William   593607 593607 Lucas, William, of Peynton, "scosser" 10
4699675 2265347 2265347 defendant Taillour John, sen tailor 786872 786872 Taillour, John, sen, of Wyckeburgh, tailor 11
4699676 2265347 2265347 defendant Coule John laborer 781813 781813 Coule, John, of Combe Fysshacre, laborer 12
4699677 2265347 2265347 defendant Lucy John laborer 609408 609408 Lucy, John, of Bowe, laborer 13
4699678 2265347 2265347 defendant Cole Roger   786873 786873 Cole, Roger, of Ippelpene, millward 14
4699679 2265347 2265347 defendant Rider Robert jun, of Combe Fyssacre, weaver   Rider, Robert, jun, of Combe Fyssacre, weaver 15
4699680 2265347 2265347 defendant Jane Walter husbandman 781813 781813 Jane, Walter, of Combe Fysshacre, husbandman 16
4699681 2265347 2265347 defendant More Thomas   781812 781812 More, Thomas, of Ippelpenne, holy water clerk 17
4699682 2265347 2265347 defendant More John   781812 781812 More, John, of Ippelpenne, holy water clerk 18
4699683 2265347 2265347 defendant Lucas John laborer 781812 781812 Lucas, John, of Ippelpenne, laborer 19
4699684 2265347 2265347 defendant Yorle John husbandman 593607 593607 Yorle, John, of Peynton, husbandman 20
4699685 2265347 2265347 defendant Dollyng John   781812 781812 Dollyng, John, of Ippelpenne, mason 21
4699686 2265347 2265347 defendant Paynyswike Stephen laborer 778751 778751 Paynyswike, Stephen, of Nyweton Busshell, laborer 22
4699687 2265347 2265347 defendant Stokes William yeoman 786874 786874 Stokes, William, of Pruston, yeoman 23
4699688 2265347 2265347 defendant Harry John yeoman 598050 598050 Harry, John, of Bury Pomeray, yeoman 24
4699689 2265347 2265347 defendant Cornyssh John husbandman 786875 786875 Cornyssh, John, of Coleton Kirkam, 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);