names

12 rows where place_id = 673709

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3951931 2007738 2007738 defendant Traske John yeoman 673709 673709 Traske, John, of Hale, Hants, or of Brodewynsore, Dorset, yeoman 0
4011009 2028713 2028713 plaintiff Penruddocke John esq 673709 673709 Penruddocke, John, of Hale, Hants, esq 0
4024975 2033596 2033596 plaintiff Bowman Roland gent 673709 673709 Bowman, Roland, of Hale, Hants, gent 0
4024983 2033599 2033599 plaintiff Bowman Rowland gent 673709 673709 Bowman, Rowland, of Hale, Hants, gent 0
4090628 2056934 2056934 defendant Penrodocke Robert esq 673709 673709 Penrodocke, Robert, of Hale, Hants, esq 1
4979552 2350841 2350841 defendant Wylkys Henry husbandman 673709 673709 Wylkys, Henry, of Hale, Hants, husbandman 1
4989086 2353673 2353673 defendant Wilkyns Robert husbandman 673709 673709 Wilkyns, Robert, of Hale, Hants, husbandman 0
5004270 2358142 2358142 defendant Rode Robert husbandman 673709 673709 Rode, Robert, of Hale, Hants, husbandman 1
5033142 2366578 2366578 defendant Strode Thomas husbandman 673709 673709 Strode, Thomas, of Hale, Hants, husbandman 2
5141253 2398564 2398564 defendant Auntours Robert husbandman 673709 673709 Auntours, Robert, of Hale, Hants, husbandman 3
5299669 2444871 2444871 defendant Culmer John yeoman 673709 673709 Culmer, John, of Hale, Hants, yeoman 3
5314354 2449313 2449313 defendant Sclatter John husbandman 673709 673709 Sclatter, John, of Hale, Hants, husbandman 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);