names

28 rows where place_id = 636425

✎ 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
3830678 1967477 1967477 defendant Freer Robert husbandman 636425 636425 Freer, Robert, of Snytall, husbandman 0
3888474 1986406 1986406 defendant Lethom John yeoman 636425 636425 Lethom, John, of Snytall, yeoman 0
3888475 1986406 1986406 defendant Elyott George (legal representative) 636425 636425 Elyott, George, of Snytall, husbandman, executrix of 1
3888476 1986406 1986406 defendant Elyott Katherine widow 636425 636425 Elyott, Katherine, of Snytall, widow 2
3888478 1986406 1986406 defendant Coldcoyle Agnes widow 636425 636425 Coldcoyle, Agnes, of Snytall, widow 4
3902555 1991089 1991089 plaintiff Elyott Margaret widow 636425 636425 Elyott, Margaret, of Snytall, widow 0
3902556 1991089 1991089 defendant Lethom John yeoman 636425 636425 Lethom, John, of Snytall, yeoman 0
3902559 1991090 1991090 defendant Coldcoyle Joan widow 636425 636425 Coldcoyle, Joan, of Snytall, widow 1
3902561 1991091 1991091 defendant Ellyott George (legal representative) 636425 636425 Ellyott, George, of Snytall, husbandman, executrix of 0
3902562 1991091 1991091 defendant Ellyott Katherine widow 636425 636425 Ellyott, Katherine, of Snytall, widow 1
4099835 2060266 2060266 defendant Woodocke Thomas husbandman 636425 636425 Woodocke, Thomas, of Snytall, husbandman 0
4099836 2060266 2060266 defendant Woodocke John husbandman 636425 636425 Woodocke, John, of Snytall, husbandman 1
4104309 2061820 2061820 defendant Woodcocke Thomas husbandman 636425 636425 Woodcocke, Thomas, of Snytall, husbandman 0
4104310 2061820 2061820 defendant Woodcocke John husbandman 636425 636425 Woodcocke, John, of Snytall, husbandman 1
4137320 2073697 2073697 defendant Lee John yeoman 636425 636425 Lee, John, of Snytall, yeoman 0
4137321 2073697 2073697 defendant Lee James yeoman 636425 636425 Lee, James, of Snytall, yeoman 1
4166174 2083674 2083674 defendant Barghe Richard husbandman 636425 636425 Barghe, Richard, of Snytall, husbandman 0
4181465 2088996 2088996 defendant Lee Roger yeoman 636425 636425 Lee, Roger, of Snytall, yeoman 0
4181466 2088996 2088996 defendant Woodcocke John yeoman 636425 636425 Woodcocke, John, of Snytall, yeoman 1
4443410 2182900 2182900 plaintiff Castelford William de   636425 636425 Castelford, William de, of Snytall 0
4530339 2209775 2209775 defendant Warde Richard   636425 636425 Warde, Richard, of Snytall 4
4568915 2221864 2221864 plaintiff Ward Richard   636425 636425 Ward, Richard, of Snytall 0
4679585 2259232 2259232 defendant Yong Ralph husbandman 636425 636425 Yong, Ralph, of Snytall, husbandman 0
4708556 2268045 2268045 defendant Burley John   636425 636425 Burley, John, of Snytall, wright 0
4866361 2316447 2316447 defendant Ward Thomas yeoman 636425 636425 Ward, Thomas, of Snytall, yeoman 0
4959954 2344939 2344939 defendant Jakes John laborer 636425 636425 Jakes, John, of Snytall, laborer 1
5143461 2399220 2399220 defendant Warde William husbandman 636425 636425 Warde, William, of Snytall, husbandman 1
5507226 2507164 2507164 defendant Shagh Gilbert clerk 636425 636425 Shagh, Gilbert, of Snytall, clerk 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);