names

27 rows where place_id = 591158

✎ 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
3603528 1868771 1868771 defendant Hastyng Thomas yeoman 591158 591158 Hastyng, Thomas, of Henton St George, yeoman 0
3612649 1871595 1871595 defendant Hastyng Thomas yeoman 591158 591158 Hastyng, Thomas, of Henton St George, yeoman 0
3802462 1958668 1958668 defendant Bayly James husbandman 591158 591158 Bayly, James, of Henton St George, husbandman 0
3908913 1993273 1993273 defendant Berde William husbandman 591158 591158 Berde, William, of Henton St George, husbandman 0
4512975 2204493 2204493 plaintiff Bremel Thomas   591158 591158 Bremel, Thomas, of Henton St George 0
4624256 2238573 2238573 defendant Penyfader Richard   591158 591158 Penyfader, Richard, of Henton St George, parson 0
4664009 2250230 2250230 plaintiff Gybelet John   591158 591158 Gybelet, John, of Henton St George 0
4729870 2274547 2274547 defendant Alford William husbandman 591158 591158 Alford, William, of Henton St George, husbandman 2
4831474 2305875 2305875 defendant Danbaude Florence widow 591158 591158 Danbaude, Florence, of Henton St George, widow 1
4831475 2305875 2305875 defendant Kirton Robert yeoman 591158 591158 Kirton, Robert, of Henton St George, yeoman 2
4845383 2310068 2310068 defendant Denebaude Florence   591158 591158 Denebaude, Florence, of Henton St George, widow, formerly wife of John 0
4858368 2313988 2313988 defendant Denbaude Florence widow 591158 591158 Denbaude, Florence, of Henton St George, widow 1
4858369 2313988 2313988 defendant Kyrton Robert yeoman 591158 591158 Kyrton, Robert, of Henton St George, yeoman 2
5067950 2376913 2376913 defendant Mason alias Shakell John yeoman 591158 591158 Mason alias Shakell, John, of Henton St George, yeoman 0
5068738 2377146 2377146 defendant Mason alias Shakell John yeoman 591158 591158 Mason alias Shakell, John, of Henton St George, yeoman 0
5068739 2377147 2377147 plaintiff Poulet William   591158 591158 Poulet, William, of Henton St George, knight 0
5078821 2380154 2380154 defendant Poulet William   591158 591158 Poulet, William, of Henton St George, knight 0
5107799 2388713 2388713 defendant Poulet William   591158 591158 Poulet, William, of Henton St George, knight 0
5158244 2403533 2403533 defendant Mason John (legal representative) 591158 591158 Mason, John, of Henton St George, yeoman, executrix of 0
5158245 2403533 2403533 defendant Mason Joan widow 591158 591158 Mason, Joan, of Henton St George, widow 1
5194113 2414010 2414010 defendant Mason John (legal representative) 591158 591158 Mason, John, of Henton St George, yeoman, executrix of 0
5194114 2414010 2414010 defendant Mason Joan widow 591158 591158 Mason, Joan, of Henton St George, widow 1
5196880 2414837 2414837 defendant Sampford John   591158 591158 Sampford, John, of Henton St George, mill ward 0
5208559 2418231 2418231 defendant Mason John (legal representative) 591158 591158 Mason, John, of Henton St George, yeoman, executrix of 0
5208560 2418231 2418231 defendant Mason Joan widow 591158 591158 Mason, Joan, of Henton St George, widow 1
5209870 2418618 2418618 defendant Sampford John   591158 591158 Sampford, John, of Henton St George, mill ward 0
5375206 2467833 2467833 defendant Cole William   591158 591158 Cole, William, of Henton St George, milward 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);