names

21 rows where place_id = 605929

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663420 1914485 1914485 defendant Sheppard Henry dyer 605929 605929 Sheppard, Henry, of Basingstoke, Hants, dyer 1
3974997 2015817 2015817 defendant Massam James gent 605929 605929 Massam, James, of Basingstoke, Hants, gent 1
4058447 2045408 2045408 defendant Hole William dyer 605929 605929 Hole, William, of Basingstoke, hants, dyer 1
4079554 2052985 2052985 defendant Napper William, junior yeoman 605929 605929 Napper, William, junior, of Basingstoke, Hants, yeoman 1
4088126 2056047 2056047 defendant Peryman Gilbert gent 605929 605929 Peryman, Gilbert, of Basingstoke, Hants, gent 0
4099149 2060022 2060022 defendant Crosse William, junior chapman 605929 605929 Crosse, William, junior, of Basingstoke, Hants, chapman 0
4103098 2061397 2061397 defendant Puckenge Agnes widow 605929 605929 Puckenge, Agnes, of Basingstoke, Hants, widow 1
4111934 2064518 2064518 defendant Napper William, junior gent 605929 605929 Napper, William, junior, of Basingstoke, Hants, gent 1
4136415 2073365 2073365 defendant Banes Michael yeoman 605929 605929 Banes, Michael, of Basingstoke, Hants, yeoman 0
4145786 2076678 2076678 defendant Baynes Michael yeoman 605929 605929 Baynes, Michael, of Basingstoke, Hants, yeoman 0
4152766 2079076 2079076 defendant Co- John chapman 605929 605929 Co-, John, of Basingstoke, Hants, chapman 1
4166242 2083690 2083690 defendant Byrchewood William yeoman 605929 605929 Byrchewood, William, of Basingstoke, Hants, yeoman 2
4195238 2093882 2093882 defendant Parteridge Anne widow 605929 605929 Parteridge, Anne, of Basingstoke, Hants, widow 2
4200800 2095839 2095839 defendant Conysbye Thomas gent 605929 605929 Conysbye, Thomas, of Basingstoke, Hants, gent 0
4211780 2099674 2099674 defendant Morrell John tailor 605929 605929 Morrell, John, of Basingstoke, Hants, tailor 2
4330178 2140394 2140394 defendant Yate George glover 605929 605929 Yate, George, of Basingstoke, Hants, glover 0
4718657 2271175 2271175 defendant Fenyngle Richard husbandman 605929 605929 (Fenyngle, Richard, of Basingstoke, Hants, husbandman 1
4850690 2311672 2311672 defendant Role Thomas gent 605929 605929 Role, Thomas, of Basingstoke, Hants, gent 0
4932759 2336631 2336631 defendant Blyflete Thomas esq 605929 605929 Blyflete, Thomas, of Basingstoke, Hants, esq 0
5004199 2358118 2358118 defendant Bollys Margery widow 605929 605929 Bollys, Margery, of Basingstoke, Hants, widow 0
5170555 2407109 2407109 defendant Byker Robert gent 605929 605929 Byker, Robert, of Basingstoke, Hants, gent 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);