names

17 rows where place_id = 606288

✎ 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
3664715 1914916 1914916 defendant Wynday Christopher husbandman 606288 606288 Wynday, Christopher, of Warehorne, husbandman 4
3873678 1981411 1981411 defendant Whyte John tailor 606288 606288 Whyte, John, of Warehorne, tailor 3
3919817 1996963 1996963 defendant Benden Alice widow 606288 606288 Benden, Alice, of Warehorne, widow 2
4146894 2077065 2077065 defendant Vynteman Walter husbandman 606288 606288 Vynteman, Walter, of Warehorne, husbandman 1
4192978 2093109 2093109 defendant Holock John husbandman 606288 606288 Holock, John, of Warehorne, husbandman 2
4229858 2105927 2105927 defendant Pyper Robert yeoman 606288 606288 Pyper, Robert, of Warehorne, yeoman 0
4230280 2106081 2106081 defendant Lucas Richard yeoman 606288 606288 Lucas, Richard, of Warehorne, yeoman 0
4260217 2116381 2116381 defendant Pyper Robert yeoman 606288 606288 Pyper, Robert, of Warehorne, yeoman 0
4272232 2120281 2120281 defendant Lucas Richard yeoman 606288 606288 Lucas, Richard, of Warehorne, yeoman 0
4371890 2155007 2155007 defendant Beyman John husbandman 606288 606288 Beyman, John, of Warehorne, husbandman 1
4519545 2206472 2206472 defendant Cokeryde Thomas   606288 606288 Cokeryde, Thomas, of Warehorne 0
4932934 2336690 2336690 defendant Warwell John husbandman 606288 606288 Warwell, John, of Warehorne, husbandman 0
5236114 2426147 2426147 defendant Gille William   606288 606288 Gille, William, of Warehorne, bailiff 2
5264971 2434803 2434803 defendant Roberd John, junior yeoman 606288 606288 Roberd, John, junior, of Warehorne, yeoman 0
5451690 2490379 2490379 defendant Bokelonde Henry (legal representative) 606288 606288 Bokelonde, Henry, of Warehorne, husbandman, executrix of 3
5451691 2490379 2490379 defendant Bokelonde Joan widow 606288 606288 Bokelonde, Joan, of Warehorne, widow 4
5559972 2522873 2522873 defendant Wyndowe Henry husbandman 606288 606288 Wyndowe, Henry, of Warehorne, husbandman 3

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