names

25 rows where case_id = 2525970

✎ 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
5570592 2525970 2525970 plaintiff Ilston John prior of Lenton Priory   Ilston, John, prior of Lenton Priory 0
5570593 2525970 2525970 defendant Whitchurche Hugh laborer 609752 609752 Whitchurche, Hugh, of Beeston, laborer 0
5570594 2525970 2525970 defendant Whytchurche John yeoman 609752 609752 Whytchurche, John, of Beeston, yeoman 1
5570595 2525970 2525970 defendant Wryght William husbandman 609752 609752 Wryght, William, of Beeston, husbandman 2
5570596 2525970 2525970 defendant Wryght Thomas husbandman 609752 609752 Wryght, Thomas, of Beeston, husbandman 3
5570597 2525970 2525970 defendant Grene Thomas, senior tiler 609752 609752 Grene, Thomas, senior, of Beeston, tiler 4
5570598 2525970 2525970 defendant Whytlye Williamn husbandman 609752 609752 Whytlye, Williamn, of Beeston, husbandman 5
5570599 2525970 2525970 defendant Raven Robert husbandman 609752 609752 Raven, Robert, of Beeston, husbandman 6
5570600 2525970 2525970 defendant Gate Thomas husbandman 609752 609752 Gate, Thomas, of Beeston, husbandman 7
5570601 2525970 2525970 defendant Cleam John husbandman 609752 609752 Cleam, John, of Beeston, husbandman 8
5570602 2525970 2525970 defendant Dyngham Thomas husbandman 609752 609752 Dyngham, Thomas, of Beeston, husbandman 9
5570603 2525970 2525970 defendant Hanreson Robert husbandman 609752 609752 Hanreson, Robert, of Beeston, husbandman 10
5570604 2525970 2525970 defendant Dyall William husbandman 609752 609752 Dyall, William, of Beeston, husbandman 11
5570605 2525970 2525970 defendant Cunstable William husbandman 609752 609752 Cunstable, William, of Beeston, husbandman 12
5570606 2525970 2525970 defendant Raven Thomas husbandman 609752 609752 Raven, Thomas, of Beeston, husbandman 13
5570607 2525970 2525970 defendant Grene Thomas husbandman 609752 609752 Grene, Thomas, of Beeston, husbandman 14
5570608 2525970 2525970 defendant Johnson William husbandman 609752 609752 Johnson, William, of Beeston, husbandman 15
5570609 2525970 2525970 defendant Attunbore William husbandman 609752 609752 Attunbore, William, of Beeston, husbandman 16
5570610 2525970 2525970 defendant Hardropp John husbandman 609752 609752 Hardropp, John, of Beeston, husbandman 17
5570611 2525970 2525970 defendant Wynne Hugh husbandman 609752 609752 Wynne, Hugh, of Beeston, husbandman 18
5570612 2525970 2525970 defendant Baker William husbandman 609752 609752 Baker, William, of Beeston, husbandman 19
5570613 2525970 2525970 defendant Beker John husbandman 609752 609752 Beker, John, of Beeston, husbandman 20
5570614 2525970 2525970 defendant Chamberleyn William husbandman 609752 609752 Chamberleyn, William, of Beeston, husbandman 21
5570615 2525970 2525970 defendant Godfrey John laborer 609752 609752 Godfrey, John, of Beeston, laborer 22
5570616 2525970 2525970 defendant Tayllour Richard yeoman 601375 601375 Tayllour, Richard, of Chylwell, yeoman 23

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