names

21 rows where place_id = 612717

✎ 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
3694703 1924548 1924548 defendant Gombulton John husbandman 612717 612717 Gombulton, John, of Porton, Wilts, husbandman 0
3937368 2002835 2002835 defendant Walron William yeoman 612717 612717 Walron, William, of Porton, Wilts, yeoman 0
4093740 2058084 2058084 defendant Gumbleton William gent 612717 612717 Gumbleton, William, of Porton, Wilts, gent 0
4219342 2102261 2102261 defendant Fitzwilliams Henry gent 612717 612717 Fitzwilliams, Henry, of Porton, Wilts, or of Bensted, Hants, gent 0
4219344 2102262 2102262 defendant Roles Anthony gent 612717 612717 Roles, Anthony, of Porton, Wilts, or of Bentley, Hants, gent 0
4237972 2108884 2108884 defendant Gomeldon William gent 612717 612717 Gomeldon, William, of Porton, Wilts, gent 0
4238367 2109032 2109032 defendant Gomeldon William gent 612717 612717 Gomeldon, William, of Porton, Wilts, gent 0
4251462 2113469 2113469 defendant Erington Nicholas gent 612717 612717 Erington, Nicholas, of Porton, Wilts, gent 2
4251466 2113470 2113470 defendant Erington Nicholas gent 612717 612717 Erington, Nicholas, of Porton, Wilts, gent 2
4271010 2119878 2119878 defendant Gomeldon William gent 612717 612717 Gomeldon, William, of Porton, Wilts, gent 0
4298569 2129594 2129594 defendant Gomeldon William gent 612717 612717 Gomeldon, William, of Porton, Wilts, gent 0
4323548 2138293 2138293 defendant Henwood Thomas yeoman 612717 612717 Henwood, Thomas, of Porton, Wilts, yeoman 3
4351173 2147660 2147660 defendant Gombledon William gent 612717 612717 Gombledon, William, of Porton, Wilts, gent 1
4396672 2163452 2163452 defendant Gomeldon William gent 612717 612717 Gomeldon, William, of Porton, Wilts, or of London, gent 0
4850714 2311675 2311675 defendant Horneman John husbandman 612717 612717 Horneman, John, of Porton, Wilts, husbandman 8
5011427 2360207 2360207 defendant atte Mille William (legal representative) 612717 612717 atte Mille, William, of Porton, Wilts, husbandman, executors of 1
5011428 2360207 2360207 defendant Thacheham Thomas husbandman 612717 612717 (Thacheham, Thomas, of Porton, Wilts, husbandman 2
5266274 2435204 2435204 defendant Chancy John   612717 612717 Chancy, John, of Porton, Wilts, or of Stratford under old Salisbury Castle, gent, son of Chancy, Nicholas, of Porton 0
5308221 2447491 2447491 defendant Burgeys Thomas husbandman 612717 612717 Burgeys, Thomas, of Porton, Wilts, husbandman 0
5426713 2482934 2482934 defendant Longe John husbandman 612717 612717 Longe, John, of Porton, Wilts, husbandman 0
5457452 2492127 2492127 defendant Longe John husbandman 612717 612717 Longe, John, of Porton, Wilts, husbandman 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);