names

23 rows where case_id = 2257645

✎ 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
4674525 2257645 2257645 plaintiff Dynham John knight   Dynham, John, knight 0
4674526 2257645 2257645 defendant Lytelton Robert gent 781811 781811 Lytelton, Robert, of Compton Pole, gent 0
4674527 2257645 2257645 defendant Kyrkham Walter gent 593607 593607 Kyrkham, Walter, of Peynton, gent 1
4674528 2257645 2257645 defendant Hurne William jouter or hawker 593607 593607 Hurne, William, of Peynton, jouter or hawker 2
4674529 2257645 2257645 defendant Hygham Robert husbandman 781812 781812 Hygham, Robert, of Ippelpenne, husbandman 3
4674530 2257645 2257645 defendant Ryder John, senior weaver 781813 781813 Ryder, John, senior, of Combe Fysshacre, weaver 4
4674531 2257645 2257645 defendant Lytelton Robert husbandman 781813 781813 Lytelton, Robert, of Combe Fysshacre, husbandman 5
4674532 2257645 2257645 defendant Laucestall John   781812 781812 Laucestall, John, of Ippelpenne, mason 6
4674533 2257645 2257645 defendant Yonge John butcher 781813 781813 Yonge, John, of Combe Fysshacre, butcher 7
4674534 2257645 2257645 defendant Bon John stocer 593607 593607 Bon, John, of Peynton, stocer 8
4674535 2257645 2257645 defendant Taillour John, senior tailor 781815 781815 Taillour, John, senior, of Wycheburgh, tailor 9
4674536 2257645 2257645 defendant Cole Roger   781812 781812 Cole, Roger, of Ippelpenne, milward 10
4674537 2257645 2257645 defendant Ryder Robert, junior weaver 781813 781813 Ryder, Robert, junior, of Combe Fysshacre, weaver 11
4674538 2257645 2257645 defendant Jeone Walter husbandman 781813 781813 Jeone, Walter, of Combe Fysshacre, husbandman 12
4674539 2257645 2257645 defendant More John   781817 781817 More, John, of Ippelpenn, holy water clerk 13
4674540 2257645 2257645 defendant Lucas John laborer 781818 781818 Lucas, John, of Ippepenn, laborer 14
4674541 2257645 2257645 defendant More Thomas   781812 781812 More, Thomas, of Ippelpenne, holy water clerk 15
4674542 2257645 2257645 defendant Jurle John husbandman 593607 593607 Jurle, John, of Peynton, husbandman 16
4674543 2257645 2257645 defendant Dollyng John   781817 781817 Dollyng, John, of Ippelpenn, mason 17
4674544 2257645 2257645 defendant Payneswyke Stephen laborer 765536 765536 Payneswyke, Stephen, of Neweton Busshel, laborer 18
4674545 2257645 2257645 defendant Stokes William yeoman 781821 781821 Stokes, William, of Pynston, yeoman 19
4674546 2257645 2257645 defendant Harry John yeoman 598050 598050 Harry, John, of Bury Pomeray, yeoman 20
4674547 2257645 2257645 defendant Cornyssh John husbandman 781822 781822 Cornyssh, John, of Coleton Kirkham, husbandman 21

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