names

14 rows where place_id = 598196

✎ 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
3631515 1904672 1904672 plaintiff Gowldyng John clothman 598196 598196 Gowldyng, John, of Glemesford, Suff, clothman 0
3770920 1948591 1948591 defendant Wellys James weaver 598196 598196 Wellys, James, of Glemesford, Suff, weaver 1
4832594 2306220 2306220 plaintiff Jakes John gent 598196 598196 Jakes, John, of Glemesford, Suff, gent 1
4868451 2317106 2317106 plaintiff Jakes John gent 598196 598196 Jakes, John, of Glemesford, Suff, gent 0
4868455 2317107 2317107 plaintiff Jakes John gent 598196 598196 Jakes, John, of Glemesford, Suff, gent 0
4950222 2342033 2342033 defendant Letton Ralph smith 598196 598196 Letton, Ralph, of Glemesford, Suff, smith 4
5138572 2397779 2397779 defendant Cros John husbandman 598196 598196 Cros, John, of Glemesford, Suff, husbandman 0
5138576 2397780 2397780 defendant Cros John husbandman 598196 598196 Cros, John, of Glemesford, Suff, husbandman 0
5159325 2403843 2403843 defendant Cros John husbandman 598196 598196 Cros, John, of Glemesford, Suff, husbandman 0
5227857 2423762 2423762 defendant Gonce or Gouce Thomas yeoman 598196 598196 Gonce or Gouce, Thomas, of Glemesford, Suff, yeoman 0
5227860 2423763 2423763 defendant Gonce Thomas yeoman 598196 598196 Gonce, Thomas, of Glemesford, Suff, yeoman 0
5271418 2436732 2436732 defendant Panell John yeoman 598196 598196 (Panell, John, of Glemesford, Suff, yeoman 10
5347605 2459406 2459406 defendant Crosse William husbandman 598196 598196 Crosse, William, of Glemesford, Suff, husbandman 1
5457774 2492221 2492221 defendant Hegeman William fuller 598196 598196 Hegeman, William, of Glemesford, Suff, fuller 1

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