names

33 rows where place_id = 622971

✎ 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
3596656 1866590 1866590 defendant Scrogges William yeoman of the crown 622971 622971 Scrogges, William, of Brygstoke, yeoman of the crown 0
3749982 1941913 1941913 defendant Hoggekynson George eyoman 622971 622971 Hoggekynson, George, of Brygstoke, eyoman 1
3799866 1957876 1957876 plaintiff Kyng John   622971 622971 Kyng, John, of Brygstoke 0
3799867 1957876 1957876 plaintiff Bull Thomas   622971 622971 Bull, Thomas, of Brygstoke 1
3850868 1973865 1973865 defendant Kyng John yeoman 622971 622971 Kyng, John, of Brygstoke, yeoman 1
3850871 1973865 1973865 defendant Hogekunson Dorothy widow 622971 622971 Hogekunson, Dorothy, of Brygstoke, widow 4
3851205 1973972 1973972 defendant Alen Thomas, senior butcher 622971 622971 Alen, Thomas, senior, of Brygstoke, butcher 0
3859948 1976830 1976830 defendant Alen Thomas butcher 622971 622971 Alen, Thomas, of Brygstoke, butcher 0
3865584 1978707 1978707 defendant Hogekynson Dorothy widow 622971 622971 Hogekynson, Dorothy, of Brygstoke, widow 4
3865587 1978708 1978708 defendant Kyng John yeoman 622971 622971 Kyng, John, of Brygstoke, yeoman 1
3865589 1978708 1978708 defendant Hogekynson Dorothy widow 622971 622971 Hogekynson, Dorothy, of Brygstoke, widow 3
4471661 2191800 2191800 defendant Draper Thomas   622971 622971 Draper, Thomas, of Brygstoke 0
4585241 2226807 2226807 defendant Tukk William   622971 622971 Tukk, William, of Brygstoke 2
4691035 2262721 2262721 plaintiff Wotton John   622971 622971 Wotton, John, of Brygstoke 0
4708631 2268074 2268074 defendant Comfort Richard drover 622971 622971 Comfort, Richard, of Brygstoke, drover 0
4754865 2281900 2281900 defendant Fox Walter husbandman 622971 622971 Fox, Walter, of Brygstoke, husbandman 0
4865472 2316166 2316166 defendant Rokeby Thomas yeoman 622971 622971 Rokeby, Thomas, of Brygstoke, yeoman 0
4902743 2327477 2327477 defendant Wotton William husbandman 622971 622971 Wotton, William, of Brygstoke, husbandman 0
4925016 2334255 2334255 defendant Fox John drover 622971 622971 Fox, John, of Brygstoke, drover 0
4932000 2336398 2336398 defendant Warton Henry   622971 622971 Warton, Henry, of Brygstoke, mason 0
4985989 2352728 2352728 defendant Warner William yeoman 622971 622971 Warner, William, of Brygstoke, yeoman 0
5007965 2359219 2359219 defendant Potter William yeoman 622971 622971 Potter, William, of Brygstoke, yeoman 0
5029774 2365582 2365582 defendant Pakyngton John yeoman 622971 622971 Pakyngton, John, of Brygstoke, yeoman 0
5029775 2365582 2365582 defendant Fox John yeoman 622971 622971 Fox, John, of Brygstoke, yeoman 1
5075294 2379104 2379104 defendant Wotton William gent 622971 622971 Wotton, William, of Brygstoke, gent 0
5075296 2379105 2379105 defendant Wotton William yeoman 622971 622971 Wotton, William, of Brygstoke, yeoman 0
5109550 2389223 2389223 defendant Fox John husbandman 622971 622971 Fox, John, of Brygstoke, husbandman 0
5179779 2409824 2409824 defendant Humby Richard   622971 622971 Humby, Richard, of Brygstoke, park man 0
5202053 2416367 2416367 defendant Humby Richard   622971 622971 Humby, Richard, of Brygstoke, park man 0
5220585 2421715 2421715 defendant Fermory Stephen husbandman 622971 622971 Fermory, Stephen, of Brygstoke, husbandman 1
5439640 2486798 2486798 defendant Bosworth Thomas yeoman 622971 622971 Bosworth, Thomas, of Brygstoke, yeoman 0
5506107 2506828 2506828 defendant Parker Richard butcher 622971 622971 Parker, Richard, of Brygstoke, butcher 4
5514283 2509317 2509317 defendant Armeston Richard gent 622971 622971 Armeston, Richard, of Brygstoke, gent 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);