names

16 rows where place_id = 722622

✎ 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
4134470 2072659 2072659 defendant Ellyott Thomas Devon, gent 722622 722622 Ellyott Thomas, of Farringdon, Devon, gent 0
4246336 2111751 2111751 defendant Ellyott Thomas gent 722622 722622 Ellyott, Thomas, of Farringdon, gent 0
4289560 2126331 2126331 defendant Ellyott Thomas yeoman 722622 722622 Ellyott, Thomas, of Farringdon, yeoman 0
4312708 2134577 2134577 defendant Knighte John yeoman 722622 722622 Knighte, John, of Farringdon, yeoman 0
4370722 2154582 2154582 defendant Knighte John yeoman 722622 722622 Knighte, John, of Farringdon, yeoman 0
4384947 2159656 2159656 defendant Slyfield Ralph gent 722622 722622 Slyfield, Ralph, of Farringdon, or of Boulston on the Hill, Malmesburye, Wilts, gent 0
4384949 2159657 2159657 defendant Smythe Edward yeoman 722622 722622 Smythe, Edward, of Farringdon, or of Malmesburye, Wilts, yeoman 0
4408524 2167436 2167436 defendant Straunge Henry yeoman 722622 722622 Straunge, Henry, of Farringdon, or of Meadeborne, Ludington, Wilts, yeoman 0
4617169 2236380 2236380 plaintiff Glover Richard   722622 722622 Glover, Richard, of Farringdon 0
4631197 2240657 2240657 defendant Walssham Hugh   722622 722622 Walssham, Hugh, of Farringdon 4
4831326 2305829 2305829 defendant Carter John husbandman 722622 722622 Carter, John, of Farringdon, husbandman 0
4831327 2305829 2305829 defendant Hyde John husbandman 722622 722622 Hyde, John, of Farringdon, husbandman 1
4831329 2305829 2305829 defendant Carter Simon husbandman 722622 722622 Carter, Simon, of Farringdon, husbandman 3
4831331 2305830 2305830 defendant Hyde John husbandman 722622 722622 Hyde, John, of Farringdon, husbandman 0
4831332 2305830 2305830 defendant Carter John husbandman 722622 722622 Carter, John, of Farringdon, husbandman 1
4836141 2307283 2307283 defendant Feld Walter husbandman 722622 722622 Feld, Walter, of Farringdon, 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);