names

32 rows where place_id = 607987

✎ 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
3671752 1917153 1917153 defendant Badworthy Thomas yeoman 607987 607987 Badworthy, Thomas, of Shebbeare, yeoman 0
3674835 1918158 1918158 defendant Davy John husbandman 607987 607987 Davy, John, of Shebbeare, husbandman 0
3682783 1920717 1920717 defendant Tammelyn Richard clerk 607987 607987 Tammelyn, Richard, of Shebbeare, clerk 0
3683213 1920868 1920868 defendant Badworthy Nicholas gent 607987 607987 Badworthy, Nicholas, of Shebbeare, gent 0
3697882 1925559 1925559 defendant Tammelyn Richard clerk 607987 607987 Tammelyn, Richard, of Shebbeare, clerk 0
3709636 1929322 1929322 defendant Thomleyn Richard clerk 607987 607987 Thomleyn, Richard, of Shebbeare, clerk 0
3990289 2021281 2021281 defendant Hutchan Lewis yeoman 607987 607987 Hutchan, Lewis, of Shebbeare, yeoman 0
3990290 2021281 2021281 defendant Hoppar Simon husbandman 607987 607987 Hoppar, Simon, of Shebbeare, husbandman 1
4031652 2035984 2035984 defendant Huchyn Lewis yeoman 607987 607987 Huchyn, Lewis, of Shebbeare, yeoman 0
4037207 2037970 2037970 defendant Jefferye Nicholas husbandman 607987 607987 Jefferye, Nicholas, of Shebbeare, husbandman 0
4037208 2037970 2037970 defendant Borrewe Richard husbandman 607987 607987 Borrewe, Richard, of Shebbeare, husbandman 1
4037209 2037971 2037971 plaintiff Jolliffe Digory gent 607987 607987 Jolliffe, Digory, of Shebbeare, gent 0
4037210 2037971 2037971 defendant Jeffrye Nicholas husbandman 607987 607987 Jeffrye, Nicholas, of Shebbeare, husbandman 0
4037211 2037971 2037971 defendant Borrowe Richard husbandman 607987 607987 Borrowe, Richard, of Shebbeare, husbandman 1
4046389 2041157 2041157 defendant Swete Thomas husbandman 607987 607987 Swete, Thomas, of Shebbeare, husbandman 0
4140519 2074852 2074852 defendant Hutchens Lewis husbandman 607987 607987 Hutchens, Lewis, of Shebbeare, husbandman 0
4196834 2094441 2094441 defendant Beale David husbandman 607987 607987 Beale, David, of Shebbeare, husbandman 0
4245611 2111510 2111510 defendant Davye Richard yeoman 607987 607987 Davye, Richard, of Shebbeare, yeoman 0
4257692 2115547 2115547 defendant Davye Richard yeoman 607987 607987 Davye, Richard, of Shebbeare, yeoman 0
4278324 2122358 2122358 defendant James William husbandman 607987 607987 James, William, of Shebbeare, husbandman 0
4278325 2122358 2122358 defendant Kynge Abraham husbandman 607987 607987 Kynge, Abraham, of Shebbeare, husbandman 1
4371832 2154988 2154988 defendant Parson William husbandman 607987 607987 Parson, William, of Shebbeare, husbandman 1
4390682 2161496 2161496 defendant Pope Leonard yeoman 607987 607987 Pope, Leonard, of Shebbeare, yeoman 1
4829159 2305159 2305159 defendant Nycoll John husbandman 607987 607987 Nycoll, John, of Shebbeare, husbandman 0
4982659 2351727 2351727 defendant Nicoll John husbandman 607987 607987 Nicoll, John, of Shebbeare, husbandman 0
5398215 2474559 2474559 defendant Trace William husbandman 607987 607987 Trace, William, of Shebbeare, husbandman 0
5480289 2499087 2499087 defendant Souche Richard gent 607987 607987 Souche, Richard, of Shebbeare, gent 0
5535514 2515635 2515635 defendant Geffrey Robert husbandman 607987 607987 Geffrey, Robert, of Shebbeare, husbandman 0
5564072 2524107 2524107 defendant Geffrey John husbandman 607987 607987 Geffrey, John, of Shebbeare, husbandman 0
5564073 2524107 2524107 defendant Geffrey Robert husbandman 607987 607987 Geffrey, Robert, of Shebbeare, husbandman 1
5603870 2536077 2536077 defendant Geffray John husbandman 607987 607987 Geffray, John, of Shebbeare, husbandman 0
5603873 2536078 2536078 defendant Godyng William, senior husbandman 607987 607987 Godyng, William, senior, of Shebbeare, husbandman 0

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