names

26 rows where place_id = 601538

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645778 1909082 1909082 defendant Wylkynson alias Wylkyns Christopher husbandman 601538 601538 Wylkynson alias Wylkyns, Christopher, of Metyngham, Suff, husbandman 0
3664898 1914967 1914967 defendant Newman Walter husbandman 601538 601538 Newman, Walter, of Metyngham, Suff, husbandman 0
3675645 1918418 1918418 defendant Newman Walter yeoman 601538 601538 Newman, Walter, of Metyngham, Suff, yeoman 0
3677811 1919112 1919112 defendant Wylkynson Christopher tailor 601538 601538 Wylkynson, Christopher, of Metyngham, Suff, tailor 0
3691631 1923540 1923540 defendant Dade Nicholas clerk 601538 601538 Dade, Nicholas, of Metyngham, Suff, clerk 0
3691637 1923543 1923543 defendant Newman Walter husbandman 601538 601538 Newman, Walter, of Metyngham, Suff, husbandman 0
3691639 1923544 1923544 defendant Newman Walter husbandman 601538 601538 Newman, Walter, of Metyngham, Suff, husbandman 0
3705888 1928126 1928126 defendant Newman Walter husbandman 601538 601538 Newman, Walter, of Metyngham, Suff, husbandman 0
3742196 1939428 1939428 defendant Shelton Richard clerk 601538 601538 Shelton, Richard, of Metyngham, Suff, clerk 0
3818680 1963746 1963746 defendant Rolfe Henry   601538 601538 Rolfe, Henry, of Metyngham, Suff, worsted weaver 1
3821505 1964621 1964621 defendant Burton Thomas yeoman 601538 601538 Burton, Thomas, of Metyngham, Suff, yeoman 0
3978138 2016932 2016932 plaintiff Marten Roger husbandman 601538 601538 Marten, Roger, of Metyngham, Suff, husbandman 0
5073055 2378426 2378426 defendant Banyard John gent 601538 601538 Banyard, John, of Metyngham, Suff, gent 4
5144058 2399410 2399410 plaintiff Banyard John esq 601538 601538 Banyard, John, of Metyngham, Suff, esq 0
5276477 2438191 2438191 defendant Fraunsham William clerk & Master of the College of the BM within the Castle 601538 601538 (Fraunsham, William, of Metyngham, Suff, clerk & Master of the College of the BM within the Castle 1
5276481 2438192 2438192 defendant Fraunsham William master of the college of the BM 601538 601538 (Fraunsham, William, of Metyngham, Suff, master of the college of the BM 1
5366537 2465187 2465187 defendant Goldsmyth John merchant 601538 601538 Goldsmyth, John, of Metyngham, Suff, merchant 0
5384891 2470753 2470753 defendant Goldsmyth John merchant 601538 601538 Goldsmyth, John, of Metyngham, Suff, merchant 0
5397253 2474298 2474298 defendant Goldsmyth John merchant 601538 601538 Goldsmyth, John, of Metyngham, Suff, merchant 0
5410469 2478077 2478077 defendant Goldsmith John merchant 601538 601538 Goldsmith, John, of Metyngham, Suff, merchant 0
5551019 2520325 2520325 defendant Marday John   601538 601538 Marday, John, of Metyngham, Suff, ploughwright 0
5557690 2522205 2522205 defendant Whyte William yeoman 601538 601538 Whyte, William, of Metyngham, Suff, yeoman 2
5567388 2525041 2525041 defendant Thakker Robert yeoman 601538 601538 Thakker, Robert, of Metyngham, Suff, yeoman 1
5572440 2526482 2526482 defendant Dade Nicholas clerk 601538 601538 Dade, Nicholas, of Metyngham, Suff, clerk 1
5572443 2526483 2526483 defendant Dade Nicholas clerk 601538 601538 Dade, Nicholas, of Metyngham, Suff, clerk 1
5608233 2537475 2537475 defendant Goldsmyth William yeoman 601538 601538 Goldsmyth, William, of Metyngham, Suff, yeoman 1

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