names

13 rows where place_id = 712180

✎ 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
4192408 2092899 2092899 defendant Byshope Julian yeoman 712180 712180 Byshope, Julian, of Cranborne, yeoman 0
4289981 2126480 2126480 defendant Currye Francis widow 712180 712180 Currye, Francis, of Cranborne, widow 0
4711038 2268808 2268808 defendant Knele John laborer 712180 712180 Knele, John, of Cranborne, laborer 7
4711041 2268808 2268808 defendant Grastynbury Richard   712180 712180 together with Grastynbury, Richard, of Cranborne, prior 10
4711050 2268809 2268809 defendant Knele John laborer 712180 712180 Knele, John, of Cranborne, laborer 7
4733393 2275622 2275622 plaintiff Randolf John merchant 712180 712180 Randolf, John, of Cranborne, merchant 0
4791346 2293387 2293387 defendant Spilman William tucker 712180 712180 Spilman, William, of Cranborne, tucker 0
4791347 2293387 2293387 defendant Spilman John tucker 712180 712180 Spilman, John, of Cranborne, tucker 1
5023368 2363742 2363742 defendant Walsheman John shoemaker 712180 712180 Walsheman, John, of Cranborne, shoemaker 0
5262609 2434049 2434049 plaintiff Parker John   712180 712180 Parker, John, of Cranborne 0
5319893 2451036 2451036 plaintiff Horne William   712180 712180 Horne, William, of Cranborne 0
5319896 2451037 2451037 plaintiff Horne William   712180 712180 Horne, William, of Cranborne 0
5346812 2459161 2459161 defendant Parker John yeoman 712180 712180 Parker, John, of Cranborne, yeoman 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);