names

36 rows where place_id = 624256

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3757005 1944169 1944169 defendant Stafford William esq 624256 624256 Stafford, William, of Bradfeld, Berks, esq 0
3777885 1950794 1950794 defendant Stafford William esq 624256 624256 Stafford, William, of Bradfeld, Berks, esq 2
3828906 1966921 1966921 defendant Stafford William esq 624256 624256 Stafford, William, of Bradfeld, Berks, esq 0
3926774 1999287 1999287 defendant Fortescure Henry gent 624256 624256 Fortescure, Henry, of Bradfeld, Berks, gent 0
3940522 2003841 2003841 defendant Barton George clerk & rector 624256 624256 Barton, George, of Bradfeld, Berks, clerk & rector 0
3972060 2014786 2014786 defendant Stafford Thomas esq 624256 624256 Stafford, Thomas, of Bradfeld, Berks, esq 0
3994147 2022657 2022657 defendant Stafforde Rede esq 624256 624256 Stafforde, Rede, of Bradfeld, Berks, esq 0
4120048 2067458 2067458 defendant Stafford Read esq 624256 624256 Stafford, Read, of Bradfeld, Berks, esq 1
4202835 2096536 2096536 defendant Stafford Read esq 624256 624256 Stafford, Read, of Bradfeld, Berks, esq 0
4970882 2348235 2348235 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
4970901 2348240 2348240 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5042888 2369482 2369482 defendant Mylys John tanner 624256 624256 Mylys, John, of Bradfeld, Berks, tanner 0
5088901 2383130 2383130 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5139304 2397985 2397985 defendant Langford Thomas esq 624256 624256 Langford, Thomas, of Bradfeld, Berks, esq 0
5160262 2404096 2404096 defendant Langford Thomas esq 624256 624256 Langford, Thomas, of Bradfeld, Berks, esq 0
5175114 2408417 2408417 defendant Langford Thomas esq 624256 624256 Langford, Thomas, of Bradfeld, Berks, esq 0
5184150 2411103 2411103 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5196170 2414626 2414626 defendant Langford Thomas esq 624256 624256 Langford, Thomas, of Bradfeld, Berks, esq 0
5204187 2416979 2416979 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5204190 2416980 2416980 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5209546 2418531 2418531 defendant Langford Thomas esq 624256 624256 Langford, Thomas, of Bradfeld, Berks, esq 0
5216800 2420654 2420654 defendant Mylys John tanner 624256 624256 Mylys, John, of Bradfeld, Berks, tanner 0
5219149 2421328 2421328 defendant Langeford Edward esq 624256 624256 Langeford, Edward, of Bradfeld, Berks, esq 0
5219157 2421329 2421329 defendant Langford Edward esq 624256 624256 together with Langford, Edward, of Bradfeld, Berks, esq 1
5244560 2428590 2428590 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 1
5246886 2429253 2429253 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 2
5252051 2430747 2430747 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5275252 2437836 2437836 defendant Langford Edward esq 624256 624256 Langford, Edward, of Bradfeld, Berks, esq 0
5403434 2476056 2476056 defendant Smallebone Henry husbandman 624256 624256 Smallebone, Henry, of Bradfeld, Berks, husbandman 1
5416511 2479856 2479856 defendant Smallebone Henry husbandman 624256 624256 Smallebone, Henry, of Bradfeld, Berks, husbandman 1
5433385 2484943 2484943 defendant Smallebone Henry husbandman 624256 624256 Smallebone, Henry, of Bradfeld, Berks, husbandman 1
5433388 2484944 2484944 defendant Smallebone Henry husbandman 624256 624256 Smallebone, Henry, of Bradfeld, Berks, husbandman 1
5508769 2507597 2507597 defendant Smalebone Henry husbandman 624256 624256 Smalebone, Henry, of Bradfeld, Berks, husbandman 0
5535288 2515563 2515563 defendant Stepneth John, junior gent 624256 624256 Stepneth, John, junior, of Bradfeld, Berks, gent 0
5547582 2519311 2519311 defendant Cowdrey Edward gent 624256 624256 Cowdrey, Edward, of Bradfeld, Berks, gent 3
5547591 2519312 2519312 defendant Cowedrey Edward gent 624256 624256 Cowedrey, Edward, of Bradfeld, Berks, gent 3

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);