names

30 rows where place_id = 611726

✎ 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
3689814 1922971 1922971 defendant Rychard Walter gent 611726 611726 Rychard, Walter, of Milverton, Soms, gent 0
3854549 1975065 1975065 defendant Paret John, junior husbandman 611726 611726 Paret, John, junior, of Milverton, Soms, husbandman 0
4060907 2046308 2046308 defendant Moore Richard husbandman 611726 611726 Moore, Richard, of Milverton, Soms, husbandman 0
4183744 2089802 2089802 defendant Lancaster Justinian   611726 611726 Lancaster, Justinian, of Milverton, Soms, clerk, Archdeacon of Taunton 0
4201596 2096102 2096102 defendant Bennet Richard weaver 611726 611726 Bennet, Richard, of Milverton, Soms, weaver 0
4207419 2098147 2098147 defendant Lancaster Justinian   611726 611726 Lancaster, Justinian, of Milverton, Soms, clerk, Archdeacon of Taunton 0
4220921 2102812 2102812 defendant Hawkyns John   611726 611726 Hawkyns, John, of Milverton, Soms, linen draper 0
4398419 2164052 2164052 defendant Gredy John tanner 611726 611726 Gredy, John, of Milverton, Soms, tanner 0
4736822 2276645 2276645 defendant Sanford Hugh   611726 611726 Sanford, Hugh, of Milverton, Soms, administrators of 0
4795829 2294846 2294846 defendant Bowedon William butcher 611726 611726 Bowedon, William, of Milverton, Soms, butcher 2
4897647 2325928 2325928 defendant Rowe John husbandman 611726 611726 Rowe, John, of Milverton, Soms, husbandman 2
4919874 2332724 2332724 defendant Reche John butcher 611726 611726 Reche, John, of Milverton, Soms, butcher 1
4965302 2346544 2346544 defendant Bray William gent 611726 611726 Bray, William, of Milverton, Soms, gent 0
5037021 2367696 2367696 defendant Sanford William gent 611726 611726 Sanford, William, of Milverton, Soms, gent 0
5096808 2385497 2385497 defendant Sampford Baldwin gent 611726 611726 Sampford, Baldwin, of Milverton, Soms, gent 0
5096849 2385509 2385509 defendant Coldyche William chapman 611726 611726 Coldyche, William, of Milverton, Soms, chapman 2
5199237 2415530 2415530 defendant Broghton John gent 611726 611726 Broghton, John, of Milverton, Soms, gent 1
5211029 2418958 2418958 defendant Broghton John gent 611726 611726 Broghton, John, of Milverton, Soms, gent 1
5211033 2418959 2418959 defendant Broghton John gent 611726 611726 Broghton, John, of Milverton, Soms, gent 1
5260650 2433458 2433458 defendant Ayleway John yeoman 611726 611726 Ayleway, John, of Milverton, Soms, yeoman 1
5306469 2446924 2446924 defendant Neweham James esq 611726 611726 Neweham, James, of Milverton, Soms, esq 0
5306732 2447006 2447006 defendant Neweham James esq 611726 611726 Neweham, James, of Milverton, Soms, esq 0
5315438 2449679 2449679 defendant Neuham James esq 611726 611726 Neuham, James, of Milverton, Soms, esq 0
5342180 2457746 2457746 defendant Domet William dyer 611726 611726 Domet, William, of Milverton, Soms, dyer 0
5357255 2462333 2462333 defendant Benwyk Thomas dyer 611726 611726 Benwyk, Thomas, of Milverton, Soms, dyer 0
5361597 2463649 2463649 defendant Neuham James esq 611726 611726 Neuham, James, of Milverton, Soms, esq 0
5383844 2470466 2470466 defendant Clode William mercer 611726 611726 Clode, William, of Milverton, Soms, mercer 1
5545609 2518700 2518700 defendant Benet John yeoman 611726 611726 Benet, John, of Milverton, Soms, yeoman 0
5558650 2522481 2522481 defendant Rychardys Edward gent 611726 611726 Rychardys, Edward, of Milverton, Soms, gent 1
5604277 2536201 2536201 defendant Tydesworthy Robert clerk 611726 611726 Tydesworthy, Robert, of Milverton, Soms, clerk 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);