names

10 rows where place_id = 609679

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679696 1919717 1919717 plaintiff Bannar Nicholas   609679 609679 Bannar, Nicholas, of Magna Malvern 1
3732149 1936290 1936290 defendant Pyrry John   609679 609679 Pyrry, John, of Magna Malvern, board hewer 4
3829299 1967046 1967046 defendant Yong Hugh yeoman 609679 609679 Yong, Hugh, of Magna Malvern, yeoman 2
3961520 2011129 2011129 defendant Dawnce Richard butcher 609679 609679 Dawnce, Richard, of Magna Malvern, butcher 0
4067081 2048525 2048525 defendant Bromeley Robert yeoman 609679 609679 Bromeley, Robert, of Magna Malvern, yeoman 0
4356774 2149599 2149599 defendant Agotkyn Richard yeoman 609679 609679 Agotkyn, Richard, of Magna Malvern, yeoman 0
4411422 2168410 2168410 defendant Agotkin Richard yeoman 609679 609679 Agotkin, Richard, of Magna Malvern, yeoman 0
4957260 2344135 2344135 defendant Hamsty John husbandman 609679 609679 Hamsty, John, of Magna Malvern, husbandman 0
5558291 2522375 2522375 defendant Coweley Roger (legal representative) 609679 609679 Coweley, Roger, of Magna Malvern, gent, executors of 2
5596801 2533918 2533918 defendant Mosmere Thomas tailor 609679 609679 Mosmere, Thomas, of Magna Malvern, tailor 3

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