names

17 rows where place_id = 599312

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636215 1906117 1906117 defendant Pate Robert husbandman 599312 599312 Pate, Robert, of Wansworth, husbandman 0
3636216 1906117 1906117 defendant Rydyn Robert courser 599312 599312 Rydyn, Robert, of Wansworth, courser 1
3782681 1952325 1952325 plaintiff Hyllys John gent 599312 599312 Hyllys, John, of Wansworth, gent 0
3795786 1956549 1956549 defendant Burton Thomas laborer 599312 599312 Burton, Thomas, of Wansworth, laborer 1
3798686 1957501 1957501 plaintiff Hillys John gent 599312 599312 Hillys, John, of Wansworth, gent 0
3873487 1981349 1981349 defendant Kene John husbandman 599312 599312 Kene, John, of Wansworth, husbandman 0
3873488 1981349 1981349 defendant Hale John husbandman 599312 599312 Hale, John, of Wansworth, husbandman 1
3873489 1981349 1981349 defendant Holmes George husbandman 599312 599312 Holmes, George, of Wansworth, husbandman 2
3873491 1981349 1981349 defendant Long Nicholas butcher 599312 599312 Long, Nicholas, of Wansworth, butcher 4
3906820 1992570 1992570 defendant Browne Elizabeth widow 599312 599312 Browne, Elizabeth, of Wansworth, widow 3
3943779 2004936 2004936 defendant Ryppett alias Horslay Robert gent 599312 599312 Ryppett alias Horslay, Robert, of Wansworth, gent 0
3943780 2004936 2004936 defendant Ryppett alias Horslay William gent 599312 599312 Ryppett alias Horslay, William, of Wansworth, gent 1
4048356 2041859 2041859 defendant Mathewe Bartholomew yeoman 599312 599312 Mathewe, Bartholomew, of Wansworth, yeoman 2
4048361 2041860 2041860 defendant Mathewe Bartholomew yeoman 599312 599312 Mathewe, Bartholomew, of Wansworth, yeoman 2
4405854 2166519 2166519 defendant Causten William yeoman 599312 599312 Causten, William, of Wansworth, yeoman 3
5322011 2451652 2451652 defendant Warner John yeoman 599312 599312 Warner, John, of Wansworth, yeoman 1
5322012 2451652 2451652 defendant Lyncoln John yeoman 599312 599312 Lyncoln, John, of Wansworth, yeoman 2

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