names

19 rows where place_id = 596810

✎ 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
3626258 1903068 1903068 defendant Magor John yeoman 596810 596810 (Magor, John, of St Goran, yeoman 1
3626259 1903068 1903068 defendant Goly Joan widow 596810 596810 Goly, Joan, of St Goran, widow 2
3685940 1921760 1921760 defendant Husbond Thomas merchant 596810 596810 Husbond, Thomas, of St Goran, merchant 1
3874704 1981756 1981756 defendant Wyll Alexander fisher 596810 596810 Wyll, Alexander, of St Goran, fisher 3
3874705 1981756 1981756 defendant Perys Thomas husbandman 596810 596810 Perys, Thomas, of St Goran, husbandman 4
3907165 1992688 1992688 defendant Bunte Peter   596810 596810 Bunte, Peter, of St Goran, mason 0
3980836 2017909 2017909 defendant Geward alias Golowres Oto husbandman 596810 596810 Geward alias Golowres, Oto, of St Goran, husbandman 0
4012066 2029044 2029044 defendant Trevaltus John gent 596810 596810 Trevaltus, John, of St Goran, gent 0
4043798 2040238 2040238 defendant Trevalstus Edward gent 596810 596810 Trevalstus, Edward, of St Goran, gent 1
4133751 2072404 2072404 defendant Couche Richard husbandman 596810 596810 Couche, Richard, of St Goran, husbandman 0
4133752 2072404 2072404 defendant Couche Elizabeth spinster 596810 596810 Couche, Elizabeth, of St Goran, spinster 1
4453574 2186130 2186130 defendant Vyker John   596810 596810 Vyker, John, of St Goran 1
4754329 2281733 2281733 plaintiff Wylcok Thomas smith 596810 596810 Wylcok, Thomas, of St Goran, smith, on his own account 0
4754331 2281734 2281734 plaintiff Wylcok Thomas smith 596810 596810 Wylcok, Thomas, of St Goran, smith, on his own account 0
5082612 2381305 2381305 defendant Tommapenhesken John husbandman 596810 596810 Tommapenhesken, John, of St Goran, husbandman 0
5163306 2405002 2405002 defendant Trewale John gent 596810 596810 Trewale, John, of St Goran, gent 0
5229834 2424344 2424344 defendant Hykke Nicholas yeoman 596810 596810 Hykke, Nicholas, of St Goran, yeoman 6
5229882 2424359 2424359 defendant Hykke Nicholas yeoman 596810 596810 Hykke, Nicholas, of St Goran, yeoman 4
5231446 2424782 2424782 defendant Wyndesore William husbandman 596810 596810 Wyndesore, William, of St Goran, husbandman 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);