names

14 rows where place_id = 587168

✎ 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
3590646 1864717 1864717 defendant Kemp Stephen husbandman 587168 587168 Kemp, Stephen, of West Hanyfeld, husbandman 0
3590908 1864784 1864784 defendant Hale William husbandman 587168 587168 Hale, William, of West Hanyfeld, husbandman 0
3623004 1874721 1874721 defendant Baker Thomas husbandman 587168 587168 Baker, Thomas, of West Hanyfeld, husbandman 0
4553966 2217160 2217160 defendant Davy John butcher 587168 587168 Davy, John, of West Hanyfeld, butcher 0
4803211 2297195 2297195 defendant Mellere John   587168 587168 Mellere, John, of West Hanyfeld, nail maker 0
4803213 2297196 2297196 defendant Mellere John   587168 587168 Mellere, John, of West Hanyfeld, nail maker 0
4838209 2307871 2307871 defendant Tanner William butcher 587168 587168 Tanner, William, of West Hanyfeld, butcher 1
4871903 2318190 2318190 defendant Beauchamp Robert husbandman 587168 587168 Beauchamp, Robert, of West Hanyfeld, husbandman 0
4871915 2318193 2318193 defendant Beauchamp Robert husbandman 587168 587168 Beauchamp, Robert, of West Hanyfeld, husbandman 0
5210251 2418726 2418726 defendant Rede Robert yeoman 587168 587168 Rede, Robert, of West Hanyfeld, yeoman 0
5484796 2500375 2500375 defendant Rouche John laborer 587168 587168 Rouche, John, of West Hanyfeld, laborer 2
5522767 2511946 2511946 defendant Rycher Thomas yeoman 587168 587168 Rycher, Thomas, of West Hanyfeld, yeoman 0
5581196 2529187 2529187 defendant Clovell Henry esq 587168 587168 Clovell, Henry, of West Hanyfeld, esq 0
5631194 2553765 2553765 defendant Busshelmaker William   587168 587168 Busshelmaker, William, of West Hanyfeld, bushel maker 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);