names

12 rows where place_id = 802812

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4686162 2261266 2261266 defendant Gernet Thomas   802812 802812 Gernet, Thomas, of Old Sarum, mason 0
4791363 2293393 2293393 defendant Dynton Ralph butcher 802812 802812 Dynton, Ralph, of Old Sarum, butcher 0
4923311 2333716 2333716 defendant Bailly William husbandman 802812 802812 Bailly, William, of Old Sarum, husbandman 0
4963765 2346075 2346075 defendant Tymple Roger husbandman 802812 802812 Tymple, Roger, of Old Sarum, husbandman 0
4978530 2350529 2350529 defendant Tymple Roger   802812 802812 Tymple, Roger, of Old Sarum, bailiff 0
4981641 2351424 2351424 defendant Mason Edward   802812 802812 Mason, Edward, of Old Sarum, mason 0
4981643 2351425 2351425 defendant Symond William husbandman 802812 802812 Symond, William, of Old Sarum, husbandman 0
5239629 2427177 2427177 defendant Power Nicholas weaver 802812 802812 Power, Nicholas, of Old Sarum, weaver 1
5277464 2438488 2438488 defendant Palmer John pardoner 802812 802812 Palmer, John, of Old Sarum, pardoner 0
5312062 2448638 2448638 defendant Were John laborer 802812 802812 Were, John, of Old Sarum, laborer 0
5312063 2448638 2448638 defendant Cotys Anne spinster 802812 802812 Cotys, Anne, of Old Sarum, spinster 1
5312064 2448638 2448638 defendant Cobbe John husbandman 802812 802812 Cobbe, John, of Old Sarum, husbandman 2

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