names

9 rows where place_id = 613301

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3697623 1925480 1925480 defendant Wylkys Robert shoemaker 613301 613301 Wylkys, Robert, of Kedermynster, Worcs, shoemaker 1
3697853 1925549 1925549 defendant Walle Robert draper 613301 613301 Walle, Robert, of Kedermynster, Worcs, draper 2
3700897 1926526 1926526 defendant Chaunce Humphrey husbandman 613301 613301 Chaunce, Humphrey, of Kedermynster, Worcs, husbandman 0
3812129 1961705 1961705 defendant Jenens Edward mercer 613301 613301 Jenens, Edward, of Kedermynster, Worcs, mercer 0
3812133 1961707 1961707 defendant Jenens Edward mercer 613301 613301 Jenens, Edward, of Kedermynster, Worcs, mercer 0
5073789 2378648 2378648 defendant Harpecote John yeoman 613301 613301 Harpecote, John, of Kedermynster, Worcs, yeoman 0
5212740 2419472 2419472 defendant Fornbones Hugh fletcher 613301 613301 Fornbones, Hugh, of Kedermynster, Worcs, fletcher 1
5281640 2439697 2439697 defendant Chatwell Richard mercer 613301 613301 Chatwell, Richard, of Kedermynster, Worcs, mercer 0
5436274 2485785 2485785 defendant Bowyer William mercer 613301 613301 Bowyer, William, of Kedermynster, Worcs, mercer 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);