names

17 rows where place_id = 595039

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618605 1873443 1873443 defendant Streytley John butcher or gent 595039 595039 Streytley, John, of Yevyll, butcher or gent 0
3622883 1874685 1874685 defendant Carpynter Thomas yeoman 595039 595039 Carpynter, Thomas, of Yevyll, yeoman 1
3623766 1874968 1874968 defendant Dyrdo John yeoman 595039 595039 Dyrdo, John, of Yevyll, yeoman 0
3634227 1905504 1905504 defendant Durdo John mercer 595039 595039 Durdo, John, of Yevyll, mercer 0
3634228 1905504 1905504 defendant Wyche John clothier 595039 595039 Wyche, John, of Yevyll, clothier 1
3648913 1910048 1910048 defendant Hopkyns John cordwainer 595039 595039 Hopkyns, John, of Yevyll, cordwainer 0
3733069 1936567 1936567 defendant Marchant William merchant 595039 595039 Marchant, William, of Yevyll, merchant 1
3749622 1941794 1941794 defendant Parker John yeoman 595039 595039 Parker, John, of Yevyll, yeoman 0
3880331 1983676 1983676 defendant Parker John yeoman 595039 595039 Parker, John, of Yevyll, yeoman 2
4021526 2032427 2032427 defendant Whytby John (legal representative) 595039 595039 Whytby, John, of Yevyll, yeoman, executrix of 0
4083847 2054496 2054496 defendant Thomas Thomas glasier 595039 595039 Thomas, Thomas, of Yevyll, glasier 0
5103775 2387526 2387526 defendant Penvond or Pensond or Pennond John merchant 595039 595039 Penvond or Pensond or Pennond, John, of Yevyll, merchant 2
5297113 2444153 2444153 defendant Bittyscombe or Bescombe John yeoman 595039 595039 Bittyscombe or Bescombe, John, of Yevyll, yeoman 0
5540155 2517045 2517045 defendant Hymmerford William   595039 595039 Hymmerford, William, of Yevyll, gent, son of Hymmerford, John, senior 0
5541676 2517506 2517506 defendant Jenkyns John innholder 595039 595039 Jenkyns, John, of Yevyll, innholder 0
5547732 2519353 2519353 defendant Tracy John gent 595039 595039 Tracy, John, of Yevyll, gent 1
5583698 2529973 2529973 defendant Dowrygg William smith 595039 595039 Dowrygg, William, of Yevyll, smith 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);