names

57 rows where place_id = 586619

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589230 1864275 1864275 defendant Marten Thomas yeoman 586619 586619 Marten, Thomas, of Apuldore, yeoman 0
3605153 1869275 1869275 defendant Herry John beer brewer 586619 586619 Herry, John, of Apuldore, beer brewer 0
3605155 1869276 1869276 defendant Herry John beer brewer 586619 586619 Herry, John, of Apuldore, beer brewer 0
3610137 1870834 1870834 defendant Yonge John chaplain 586619 586619 Yonge, John, of Apuldore, chaplain 1
3610139 1870835 1870835 defendant Yonge John chaplain 586619 586619 Yonge, John, of Apuldore, chaplain 0
3614563 1872204 1872204 defendant Preston Robert barber 586619 586619 Preston, Robert, of Apuldore, barber 0
3654172 1911567 1911567 plaintiff Andrewe Richard (legal representative) 586619 586619 Andrewe, Richard, of Apuldore, administrator of 0
3654175 1911567 1911567 defendant a Wood Henry brewer 586619 586619 a Wood, Henry, of Apuldore, brewer 1
3663520 1914517 1914517 defendant Hoorn William gent 586619 586619 Hoorn, William, of Apuldore, gent 0
3664709 1914915 1914915 defendant Frybody John yeoman 586619 586619 Frybody, John, of Apuldore, yeoman 1
3669688 1916460 1916460 defendant Frebody John mercer 586619 586619 Frebody, John, of Apuldore, mercer 0
3686054 1921798 1921798 defendant Topynden Robert husbandman 586619 586619 Topynden, Robert, of Apuldore, husbandman 0
3686515 1921934 1921934 plaintiff Brokhill William (legal representative) 586619 586619 Brokhill, William, of Apuldore, yeoman, executors of 0
3697093 1925310 1925310 defendant Lyndsell Robert mercer 586619 586619 Lyndsell, Robert, of Apuldore, mercer 1
3732118 1936279 1936279 defendant Hewton Thomas tailor 586619 586619 Hewton, Thomas, of Apuldore, tailor 0
3732120 1936280 1936280 defendant Hewton Thomas tailor 586619 586619 Hewton, Thomas, of Apuldore, tailor 0
3749350 1941718 1941718 defendant Hudson John husbandman 586619 586619 Hudson, John, of Apuldore, husbandman 0
3755136 1943557 1943557 defendant Knell William yeoman 586619 586619 Knell, William, of Apuldore, yeoman 0
3764257 1946479 1946479 defendant Hudson John husbandman 586619 586619 Hudson, John, of Apuldore, husbandman 0
3780561 1951649 1951649 defendant Henden Roger husbandman 586619 586619 Henden, Roger, of Apuldore, husbandman 3
3784706 1953005 1953005 defendant Godfrey Edward yeoman 586619 586619 Godfrey, Edward, of Apuldore, yeoman 0
3789134 1954411 1954411 defendant A Bourne Richard   586619 586619 A Bourne, Richard, of Apuldore, tallow chandler 0
3797065 1956962 1956962 defendant Henden Roger husbandman 586619 586619 Henden, Roger, of Apuldore, husbandman 2
3801213 1958301 1958301 defendant Godfrey Edward yeoman 586619 586619 Godfrey, Edward, of Apuldore, yeoman 0
3801215 1958302 1958302 defendant Godfrey Edward yeoman 586619 586619 Godfrey, Edward, of Apuldore, yeoman 0
3814556 1962465 1962465 defendant Henden Roger husbandman 586619 586619 Henden, Roger, of Apuldore, husbandman 0
3818695 1963750 1963750 defendant Godfrey Edward yeoman 586619 586619 Godfrey, Edward, of Apuldore, yeoman 0
3827012 1966303 1966303 defendant Broughton John draper 586619 586619 Broughton, John, of Apuldore, draper 0
3832393 1968052 1968052 defendant Parnell Edward butcher 586619 586619 Parnell, Edward, of Apuldore, butcher 0
3859673 1976733 1976733 defendant Henden John husbandman 586619 586619 Henden, John, of Apuldore, husbandman 0
3871155 1980606 1980606 plaintiff Asshewell John (legal representative) 586619 586619 Asshewell, John, of Apuldore, executors of 0
3873676 1981411 1981411 defendant Rypley John yeoman 586619 586619 Rypley, John, of Apuldore, yeoman 1
3873677 1981411 1981411 defendant Wylleyn Robert butcher 586619 586619 Wylleyn, Robert, of Apuldore, butcher 2
3882623 1984452 1984452 plaintiff Thornherst Stephen   586619 586619 Thornherst, Stephen, of Apuldore 0
3885326 1985347 1985347 plaintiff Barret James   586619 586619 Barret, James, of Apuldore 0
3899086 1989902 1989902 defendant Skayle Richard yeoman 586619 586619 Skayle, Richard, of Apuldore, yeoman 3
3913181 1994742 1994742 plaintiff Barrett James   586619 586619 Barrett, James, of Apuldore 0
3937572 2002900 2002900 defendant Garrard John yeoman 586619 586619 Garrard, John, of Apuldore, yeoman 1
3988824 2020749 2020749 defendant Chewt George esq 586619 586619 Chewt, George, of Apuldore, esq 0
3988825 2020749 2020749 defendant Chewt Thomas gent 586619 586619 Chewt, Thomas, of Apuldore, gent 1
3993284 2022340 2022340 defendant Whaetlowe John husbandman 586619 586619 (Whaetlowe, John, of Apuldore, husbandman 1
4472263 2191995 2191995 defendant Salman William   586619 586619 Salman, William, of Apuldore 0
4978260 2350445 2350445 defendant Hornebroke John butcher 586619 586619 Hornebroke, John, of Apuldore, butcher 4
5037463 2367827 2367827 defendant Parker John skinner 586619 586619 Parker, John, of Apuldore, skinner 2
5360231 2463240 2463240 defendant Hancok Lawrence husbandman 586619 586619 Hancok, Lawrence, of Apuldore, husbandman 1
5424863 2482399 2482399 defendant Broun John husbandman 586619 586619 Broun, John, of Apuldore, husbandman 0
5424883 2482404 2482404 defendant Broun John husbandman 586619 586619 Broun, John, of Apuldore, husbandman 0
5456269 2491790 2491790 defendant Ovyngham Richard husbandman 586619 586619 Ovyngham, Richard, of Apuldore, husbandman 2
5468094 2495399 2495399 defendant Hancok Lawrence husbandman 586619 586619 Hancok, Lawrence, of Apuldore, husbandman 0
5468096 2495399 2495399 defendant Onyngham Richard husbandman 586619 586619 Onyngham, Richard, of Apuldore, husbandman 2
5523889 2512296 2512296 defendant Treweman Robert yeoman 586619 586619 Treweman, Robert, of Apuldore, yeoman 0
5523890 2512296 2512296 defendant Reye John husbandman 586619 586619 Reye, John, of Apuldore, husbandman 1
5523891 2512296 2512296 defendant Phildiswell Richard husbandman 586619 586619 Phildiswell, Richard, of Apuldore, husbandman 2
5523892 2512296 2512296 defendant Andrewe Richard beer brewer 586619 586619 Andrewe, Richard, of Apuldore, beer brewer 3
5544343 2518338 2518338 defendant Dente John laborer 586619 586619 Dente, John, of Apuldore, laborer 1
5573544 2526824 2526824 defendant Scoryer John merchant 586619 586619 Scoryer, John, of Apuldore, merchant 3
5584336 2530166 2530166 defendant Broune William carpenter 586619 586619 Broune, William, of Apuldore, carpenter 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);