names

32 rows where place_id = 604644

✎ 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
3658741 1912986 1912986 defendant Capper William mercer 604644 604644 Capper, William, of Shaftesbury, Dors, mercer 4
4668233 2255776 2255776 defendant Norsse John butcher 604644 604644 Norsse, John, of Shaftesbury, Dors, butcher 3
4670671 2256510 2256510 defendant Halywelle Arnold chapman 604644 604644 Halywelle, Arnold, of Shaftesbury, Dors, chapman 2
4672531 2257056 2257056 defendant Cokkes John butcher 604644 604644 Cokkes, John, of Shaftesbury, Dors, butcher 1
4678751 2258958 2258958 defendant Voke Richard brasier 604644 604644 Voke, Richard, of Shaftesbury, Dors, brasier 1
4681152 2259732 2259732 defendant Voke Richard brasier 604644 604644 Voke, Richard, of Shaftesbury, Dors, brasier 7
4681153 2259732 2259732 defendant Broune Thomas laborer 604644 604644 Broune, Thomas, of Shaftesbury, Dors, laborer 8
4685819 2261156 2261156 defendant Vooke Richard brasier 604644 604644 Vooke, Richard, of Shaftesbury, Dors, brasier 0
4731387 2275017 2275017 defendant Clyvedon Alexander gent 604644 604644 Clyvedon, Alexander, of Shaftesbury, Dors, gent 0
4734564 2275975 2275975 defendant Voke Richard   604644 604644 Voke, Richard, of Shaftesbury, Dors, brass worker 2
4746297 2279413 2279413 defendant Voke Richard husbandman 604644 604644 Voke, Richard, of Shaftesbury, Dors, husbandman 2
4749362 2280294 2280294 defendant Voke Richard brasier 604644 604644 Voke, Richard, of Shaftesbury, Dors, brasier 0
4751212 2280832 2280832 defendant Voke Richard   604644 604644 Voke, Richard, of Shaftesbury, Dors, brass worker 1
4807361 2298499 2298499 defendant Baudewyn John shoemaker 604644 604644 Baudewyn, John, of Shaftesbury, Dors, shoemaker 0
4813855 2300444 2300444 defendant Mamthewe William merchant 604644 604644 Mamthewe, William, of Shaftesbury, Dors, merchant 1
4818597 2301897 2301897 defendant Voke Richard   604644 604644 Voke, Richard, of Shaftesbury, Dors, brass worker 1
4825675 2304071 2304071 defendant Dyer John husbandman 604644 604644 Dyer, John, of Shaftesbury, Dors, husbandman 0
4923303 2333712 2333712 defendant Janyn Walter draper 604644 604644 Janyn, Walter, of Shaftesbury, Dors, draper 0
5003181 2357832 2357832 defendant Motcombe John mercer 604644 604644 Motcombe, John, of Shaftesbury, Dors, mercer 3
5003188 2357833 2357833 defendant Motkombe John mercer 604644 604644 Motkombe, John, of Shaftesbury, Dors, mercer 3
5045447 2370268 2370268 defendant Burlegh William chapman 604644 604644 Burlegh, William, of Shaftesbury, Dors, chapman 2
5126019 2394095 2394095 defendant Heend Ralph clerk & parson of St Peter's church 604644 604644 Heend, Ralph, of Shaftesbury, Dors, clerk & parson of St Peter's church 0
5270839 2436567 2436567 defendant Godman Philip, junior   604644 604644 Godman, Philip, junior, of Shaftesbury, Dors, wax chandler 0
5270843 2436568 2436568 defendant Godman Philip   604644 604644 Godman, Philip, of Shaftesbury, Dors, wax chandler 0
5274635 2437660 2437660 defendant Walbrond John chapman 604644 604644 Walbrond, John, of Shaftesbury, Dors, chapman 2
5365670 2464927 2464927 defendant Walrond John chapman 604644 604644 Walrond, John, of Shaftesbury, Dors, chapman 3
5373838 2467414 2467414 defendant Bardon Roger   604644 604644 Bardon, Roger, of Shaftesbury, Dors, inn holder 2
5373840 2467415 2467415 defendant Burdon Roger   604644 604644 Burdon, Roger, of Shaftesbury, Dors, inn holder 0
5378762 2468944 2468944 defendant de Barton Oliver (legal representative) 604644 604644 de Barton, Oliver, of Shaftesbury, Dors, gent, executrix of 0
5378765 2468945 2468945 defendant de Barton Oliver (legal representative) 604644 604644 de Barton, Oliver, of Shaftesbury, Dors, gent, executrix of 0
5459796 2492856 2492856 defendant Abbot John gent 604644 604644 Abbot, John, of Shaftesbury, Dors, gent 0
5471390 2496385 2496385 defendant Abbot John gent 604644 604644 Abbot, John, of Shaftesbury, Dors, gent 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);