names

15 rows where place_id = 657547

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3944745 2005264 2005264 defendant Fowler Thomas weaver 657547 657547 Fowler, Thomas, of Cawne, Wilts, weaver 0
3945263 2005428 2005428 defendant Parson alias Sygreve Walter husbandman 657547 657547 Parson alias Sygreve, Walter, of Cawne, Wilts, husbandman 1
3986661 2019969 2019969 defendant Masye Henry yeoman 657547 657547 Masye, Henry, of Cawne, Wilts, yeoman 0
4010572 2028557 2028557 defendant Chambers Edward yeoman 657547 657547 Chambers, Edward, of Cawne, Wilts, yeoman 0
4062182 2046763 2046763 defendant Galle Francis innholder 657547 657547 Galle, Francis, of Cawne, Wilts, innholder 2
4094467 2058360 2058360 defendant Masse Henry yeoman 657547 657547 Masse, Henry, of Cawne, Wilts, yeoman 0
4120179 2067502 2067502 defendant Amys Edward gent 657547 657547 Amys, Edward, of Cawne, Wilts, gent 1
4152266 2078904 2078904 defendant Butte Robert husbandman 657547 657547 Butte, Robert, of Cawne, Wilts, husbandman 0
4170815 2085282 2085282 defendant Watkyns Henry yeoman 657547 657547 Watkyns, Henry, of Cawne, Wilts, yeoman 0
4185362 2090392 2090392 defendant Brooke Thomas   657547 657547 Brooke, Thomas, of Cawne, Wilts, gent, attorney 0
4223368 2103666 2103666 defendant Syck or Secick James   657547 657547 Syck or Secick, James, of Cawne, Wilts, or of Readinge, apothecary 2
4223373 2103667 2103667 defendant Syck or Secick James   657547 657547 Syck or Secick, James, of Cawne, Wilts, or of Reading, Berks, apothecary 2
4239793 2109549 2109549 defendant Dashe John fishmonger 657547 657547 Dashe, John, of Cawne, Wilts, fishmonger 0
4312284 2134432 2134432 defendant Packer Nicholas husbandman 657547 657547 Packer, Nicholas, of Cawne, Wilts, husbandman 0
5568619 2525373 2525373 defendant Hungerford Robert esq 657547 657547 Hungerford, Robert, of Cawne, Wilts, esq 1

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