names

18 rows where place_id = 738854

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4332409 2141131 2141131 defendant Barton Robert husbandman 738854 738854 Barton, Robert, of Shepeshede, husbandman 0
4332410 2141131 2141131 defendant Woode John husbandman 738854 738854 Woode, John, of Shepeshede, husbandman 1
4332411 2141131 2141131 defendant Butcher James husbandman 738854 738854 Butcher, James, of Shepeshede, husbandman 2
4577826 2224570 2224570 plaintiff Chapeleyn Richard   738854 738854 Chapeleyn, Richard, of Shepeshede 0
4718592 2271153 2271153 defendant Daweson Thomas   738854 738854 Daweson, Thomas, of Shepeshede, hurdle maker 0
4719251 2271367 2271367 defendant Bradgate John   738854 738854 Bradgate, John, of Shepeshede, franklin 0
4842317 2309127 2309127 defendant Mylner Thomas miller 738854 738854 Mylner, Thomas, of Shepeshede, miller 0
4869764 2317513 2317513 defendant Chamberleyn Alice widow 738854 738854 (Chamberleyn, Alice, of Shepeshede, widow 1
4869765 2317513 2317513 defendant Chamberleyn Richard yeoman 738854 738854 Chamberleyn, Richard, of Shepeshede, yeoman 2
4909892 2329616 2329616 defendant Howes John (legal representative) 738854 738854 Howes, John, of Shepeshede, gent, executrix of 0
5218070 2421021 2421021 defendant Mylner John   738854 738854 Mylner, John, of Shepeshede 0
5238780 2426931 2426931 defendant Chapelyn Robert chaplain 738854 738854 Chapelyn, Robert, of Shepeshede, chaplain 6
5244401 2428544 2428544 defendant Mylner John   738854 738854 Mylner, John, of Shepeshede 0
5244403 2428545 2428545 defendant Milner John   738854 738854 Milner, John, of Shepeshede 0
5284752 2440557 2440557 defendant Martyn Robert yeoman 738854 738854 Martyn, Robert, of Shepeshede, yeoman 0
5285866 2440886 2440886 defendant Martyn Ralph yeoman 738854 738854 Martyn, Ralph, of Shepeshede, yeoman 14
5290849 2442331 2442331 defendant Hall Robert, junior gent 738854 738854 Hall, Robert, junior, of Shepeshede, gent 1
5290850 2442331 2442331 defendant Hall Robert, senior gent 738854 738854 Hall, Robert, senior, of Shepeshede, gent 2

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