names

27 rows where place_id = 586432

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588714 1864113 1864113 defendant Sprye William chapman 586432 586432 Sprye, William, of Camden, Glos, chapman 1
3603318 1868711 1868711 defendant Bayle John clothier 586432 586432 Bayle, John, of Camden, Glos, clothier 0
3618301 1873353 1873353 defendant Bailly John weaver 586432 586432 Bailly, John, of Camden, Glos, weaver 0
3651898 1910943 1910943 defendant Boner Thomas yeoman 586432 586432 Boner, Thomas, of Camden, Glos, yeoman 0
3714732 1930908 1930908 defendant Porter Richard (legal representative) 586432 586432 Porter, Richard, of Camden, Glos, gent, administratrix of 0
3743781 1939939 1939939 defendant Samuell John gent 586432 586432 Samuell, John, of Camden, Glos, gent 0
3809890 1960978 1960978 plaintiff Blower William yeoman 586432 586432 Blower, William, of Camden, Glos, yeoman 0
3866711 1979099 1979099 defendant Freman Thomas yeoman 586432 586432 Freman, Thomas, of Camden, Glos, yeoman 3
3881583 1984103 1984103 defendant Bonnour Thomas yeoman 586432 586432 Bonnour, Thomas, of Camden, Glos, yeoman 0
3913442 1994834 1994834 defendant Haryson Henry weaver 586432 586432 Haryson, Henry, of Camden, Glos, weaver 1
3966347 2012857 2012857 defendant Hyggyns William yeoman 586432 586432 Hyggyns, William, of Camden, Glos, yeoman 2
3978274 2016982 2016982 defendant Jarrett John yeoman 586432 586432 Jarrett, John, of Camden, Glos, yeoman 0
4059317 2045726 2045726 defendant Hering William chapman 586432 586432 Hering, William, of Camden, Glos, chapman 1
4065834 2048077 2048077 defendant Boner or Bouer Richard yeoman 586432 586432 Boner or Bouer, Richard, of Camden, Glos, yeoman 0
4065836 2048078 2048078 defendant Boner or Bouer Richard yeoman 586432 586432 Boner or Bouer, Richard, of Camden, Glos, yeoman 0
4073651 2050868 2050868 defendant Noble Roger carrier 586432 586432 Noble, Roger, of Camden, Glos, yeoman, carrier 0
4112549 2064744 2064744 defendant Massam Richard vintner 586432 586432 Massam, Richard, of Camden, Glos, vintner 0
4199518 2095382 2095382 defendant James Ciprian fishmonger 586432 586432 James, Ciprian, of Camden, Glos, fishmonger 1
4351097 2147637 2147637 defendant Smythe Richard gent 586432 586432 Smythe, Richard, of Camden, Glos, gent 1
5233695 2425442 2425442 defendant Harper William osteler or chapman 586432 586432 Harper, William, of Camden, Glos, osteler or chapman 1
5345723 2458808 2458808 defendant Reynold Robert chapman 586432 586432 Reynold, Robert, of Camden, Glos, chapman 0
5345746 2458811 2458811 defendant Reynold Robert chapman 586432 586432 together with Reynold, Robert, of Camden, Glos, chapman 5
5508461 2507516 2507516 defendant Long Hugh chapman 586432 586432 Long, Hugh, of Camden, Glos, chapman 0
5514131 2509265 2509265 defendant Bonour John draper 586432 586432 (Bonour, John, of Camden, Glos, draper 2
5539987 2516989 2516989 defendant Snowe Ralph yeoman 586432 586432 Snowe, Ralph, of Camden, Glos, yeoman 0
5605037 2536445 2536445 defendant Porter Richard gent 586432 586432 Porter, Richard, of Camden, Glos, gent 0
5605039 2536446 2536446 defendant Porter Richard gent 586432 586432 Porter, Richard, of Camden, Glos, 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);