names

28 rows where place_id = 604233

✎ 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
3657300 1912543 1912543 defendant Hycson John laborer 604233 604233 Hycson, John, of Badyngton, laborer 0
4421665 2171667 2171667 plaintiff Croyland John de   604233 604233 Croyland, John de, of Badyngton 0
4496949 2199713 2199713 defendant Betheby John   604233 604233 Betheby, John, of Badyngton 1
4496952 2199714 2199714 defendant Betheby John   604233 604233 Betheby, John, of Badyngton 1
4510128 2203653 2203653 defendant Reedham John   604233 604233 Reedham, John, of Badyngton, parson 1
4555936 2217794 2217794 defendant Walssh John   604233 604233 Walssh, John, of Badyngton 0
4568744 2221808 2221808 plaintiff Walssh John   604233 604233 Walssh, John, of Badyngton 0
4631352 2240697 2240697 plaintiff Templer Nicholas   604233 604233 Templer, Nicholas, of Badyngton 0
4639173 2242975 2242975 plaintiff Cobtoo John   604233 604233 Cobtoo, John, of Badyngton 0
4639174 2242975 2242975 plaintiff Gerard John   604233 604233 Gerard, John, of Badyngton 1
4645959 2244891 2244891 defendant atte Style Richard   604233 604233 atte Style, Richard, of Badyngton 1
4671213 2256653 2256653 defendant Draper Thomas husbandman 604233 604233 Draper, Thomas, of Badyngton, husbandman 0
4732442 2275320 2275320 defendant Wermeton Thomas husbandman 604233 604233 Wermeton, Thomas, of Badyngton, husbandman 0
4732443 2275320 2275320 defendant Ofthehill John husbandman 604233 604233 Ofthehill, John, of Badyngton, husbandman 1
4794100 2294288 2294288 defendant atte the Syke Richard husbandman 604233 604233 atte the Syke, Richard, of Badyngton, husbandman 2
4823977 2303573 2303573 defendant Oudeby John gent 604233 604233 Oudeby, John, of Badyngton, gent 0
5057234 2373735 2373735 defendant Damport Nicholas esq 604233 604233 Damport, Nicholas, of Badyngton, esq 3
5131243 2395625 2395625 defendant Barard Roger husbandman 604233 604233 Barard, Roger, of Badyngton, husbandman 0
5135418 2396869 2396869 defendant Joy Henry spicer 604233 604233 Joy, Henry, of Badyngton, spicer 0
5244448 2428559 2428559 defendant Chesham John husbandman 604233 604233 Chesham, John, of Badyngton, husbandman 3
5327787 2453381 2453381 defendant Walgot Robert husbandman 604233 604233 Walgot, Robert, of Badyngton, husbandman 0
5327788 2453381 2453381 defendant Walgot Thomas husbandman 604233 604233 Walgot, Thomas, of Badyngton, husbandman 1
5397954 2474491 2474491 plaintiff Chesham John   604233 604233 Chesham, John, of Badyngton 0
5425255 2482525 2482525 plaintiff Chessham William   604233 604233 Chessham, William, of Badyngton 0
5440053 2486928 2486928 defendant Walsshe Thomas gent 604233 604233 Walsshe, Thomas, of Badyngton, gent 0
5440054 2486928 2486928 defendant Upex Thomas yeoman 604233 604233 Upex, Thomas, of Badyngton, yeoman 1
5440055 2486928 2486928 defendant Castell John laborer 604233 604233 Castell, John, of Badyngton, laborer 2
5603988 2536115 2536115 defendant Style Hugh husbandman 604233 604233 Style, Hugh, of Badyngton, 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);