names

23 rows where place_id = 699325

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4128420 2070457 2070457 defendant Huchenson John   699325 699325 Huchenson, John, of Barkeston 0
4135213 2072913 2072913 defendant Hutchenson John yeoman 699325 699325 Hutchenson, John, of Barkeston, yeoman 0
4135214 2072913 2072913 defendant Hutchenson Alice widow 699325 699325 Alice his wife, alias Alice Musgrave, of Barkeston, widow 1
4151863 2078764 2078764 defendant Hutchenson John yeoman 699325 699325 Hutchenson, John, of Barkeston, yeoman 0
4159224 2081293 2081293 defendant Gatson Peter yeoman 699325 699325 Gatson, Peter, of Barkeston, yeoman 0
4159225 2081293 2081293 defendant Brakenburie George yeoman 699325 699325 Brakenburie, George, of Barkeston, yeoman 1
4159242 2081301 2081301 defendant Hutchenson John yeoman 699325 699325 Hutchenson, John, of Barkeston, yeoman 0
4176377 2087215 2087215 defendant Plapher Thomas husbandman 699325 699325 Plapher, Thomas, of Barkeston, husbandman 0
4312236 2134417 2134417 defendant Armstronge John gent 699325 699325 Armstronge, John, of Barkeston, gent 0
4315860 2135655 2135655 defendant Powlk John yeoman 699325 699325 Powlk, John, of Barkeston, yeoman 2
4747238 2279697 2279697 defendant Rayner John husbandman 699325 699325 Rayner, John, of Barkeston, husbandman 1
4831570 2305907 2305907 defendant Dobson Walter husbandman 699325 699325 Dobson, Walter, of Barkeston, husbandman 0
4831572 2305907 2305907 defendant Gossall Kathetrine   699325 699325 Gossall, Kathetrine, of Barkeston, widow, formerly wife of Thomas 2
4877183 2319824 2319824 defendant Ledes Alexander gent 699325 699325 Ledes, Alexander, of Barkeston, gent 0
4877184 2319824 2319824 defendant Wodhous John husbandman 699325 699325 Wodhous, John, of Barkeston, husbandman 1
4877185 2319824 2319824 defendant Hoton William husbandman 699325 699325 Hoton, William, of Barkeston, husbandman 2
4943381 2339898 2339898 defendant Addyson Robert clerk 699325 699325 Addyson, Robert, of Barkeston, clerk 0
4986814 2352994 2352994 defendant Reyner Thomas husbandman 699325 699325 Reyner, Thomas, of Barkeston, husbandman 0
5074576 2378899 2378899 defendant Burgeys William   699325 699325 Burgeys, William, of Barkeston 1
5081578 2380994 2380994 defendant Galle John clerk 699325 699325 Galle, John, of Barkeston, clerk 0
5265410 2434938 2434938 defendant Mores William husbandman 699325 699325 Mores, William, of Barkeston, husbandman 0
5265412 2434939 2434939 defendant Mores William husbandman 699325 699325 Mores, William, of Barkeston, husbandman 0
5619400 2549915 2549915 defendant Elys John   699325 699325 Elys, John, of Barkeston 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);