names

22 rows where place_id = 663805

✎ 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
3970296 2014207 2014207 defendant More Tibet dyer 663805 663805 More, Tibet, of Torryngton Magna, dyer 0
3971015 2014420 2014420 plaintiff Dromant William merchant 663805 663805 Dromant, William, of Torryngton Magna, merchant 0
3977476 2016694 2016694 plaintiff Ley Henry merchant 663805 663805 Ley, Henry, of Torryngton Magna, merchant 0
3981928 2018297 2018297 defendant Budde Richard tanner 663805 663805 Budde, Richard, of Torryngton Magna, tanner 0
3986343 2019855 2019855 defendant Gaye John husbandman 663805 663805 Gaye, John, of Torryngton Magna, husbandman 1
3994376 2022742 2022742 defendant Ellys Richard mercer 663805 663805 Ellys, Richard, of Torryngton Magna, mercer 0
3994825 2022901 2022901 defendant Poole John, senior yeoman 663805 663805 Poole, John, senior, of Torryngton Magna, yeoman 0
4018391 2031311 2031311 plaintiff Udey Richard, junior merchant 663805 663805 Udey, Richard, junior, of Torryngton Magna, merchant 0
4034906 2037159 2037159 defendant Hylle George yeoman 663805 663805 Hylle, George, of Torryngton Magna, yeoman 2
4036666 2037797 2037797 plaintiff Hylle John tailor 663805 663805 Hylle, John, of Torryngton Magna, tailor 0
4036667 2037797 2037797 defendant Cantell John carpenter 663805 663805 Cantell, John, of Torryngton Magna, carpenter 0
4039029 2038581 2038581 plaintiff Lorymer John weaver 663805 663805 Lorymer, John, of Torryngton Magna, weaver 0
4050772 2042714 2042714 defendant Androwes Roger merchant 663805 663805 Androwes, Roger, of Torryngton Magna, merchant 0
4053941 2043786 2043786 defendant Huddell John weaver 663805 663805 Huddell, John, of Torryngton Magna, weaver 1
4138176 2074022 2074022 defendant Bysshopp Richard merchant 663805 663805 Bysshopp, Richard, of Torryngton Magna, merchant 0
4161079 2081950 2081950 defendant Poole Christian widow 663805 663805 Poole, Christian, of Torryngton Magna, widow 0
4161081 2081951 2081951 defendant Poole John (legal representative) 663805 663805 Poole, John, of Torryngton Magna, merchant, administratrix of 0
4161082 2081951 2081951 defendant Poole Christian widow 663805 663805 Poole, Christian, of Torryngton Magna, widow 1
4161098 2081957 2081957 defendant Poole Christian widow 663805 663805 Poole, Christian, of Torryngton Magna, widow 0
4161100 2081958 2081958 defendant Poole John (legal representative) 663805 663805 Poole, John, of Torryngton Magna, merchant, administratrix of 0
4161101 2081958 2081958 defendant Poole Christian widow 663805 663805 Poole, Christian, of Torryngton Magna, widow 1
4191373 2092550 2092550 defendant Tyther or Tytherlye John draper 663805 663805 Tyther or Tytherlye, John, of Torryngton Magna, draper 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);