names

70 rows where place_id = 611336

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3687917 1922380 1922380 defendant Bekwith Matilda widow 611336 611336 Bekwith, Matilda, of Clynt, widow 0
3687918 1922380 1922380 defendant Bekwith Achant gent 611336 611336 Bekwith, Achant, of Clynt, gent 1
3687919 1922380 1922380 defendant Bekwith Ambrose gent 611336 611336 Bekwith, Ambrose, of Clynt, gent 2
3700808 1926504 1926504 plaintiff Bekwith Thomas (legal representative) 611336 611336 Bekwith, Thomas, of Clynt, executors of 0
3700816 1926505 1926505 plaintiff Bekwith Thomas (legal representative) 611336 611336 Bekwith, Thomas, of Clynt, executors of 0
3700824 1926506 1926506 plaintiff Bekwith Thomas (legal representative) 611336 611336 Bekwith, Thomas, of Clynt, executors of 0
3708228 1928867 1928867 defendant Atkynson John yeoman 611336 611336 Atkynson, John, of Clynt, yeoman 0
3722040 1933157 1933157 defendant Bekwyth Thomas (legal representative) 611336 611336 Bekwyth, Thomas, of Clynt, executors of 0
3722042 1933157 1933157 defendant Bekwyth Agapitus gent 611336 611336 Bekwyth, Agapitus, of Clynt, gent 2
3722043 1933157 1933157 defendant Bekwyth William gent 611336 611336 Bekwyth, William, of Clynt, gent 3
3722044 1933157 1933157 defendant Snawsell John esq 611336 611336 Snawsell, John, of Clynt, esq 4
3729726 1935553 1935553 plaintiff Bekwith Thomas (legal representative) 611336 611336 Bekwith, Thomas, of Clynt, esq, executors of 0
3729736 1935556 1935556 plaintiff Bekwyth Thomas (legal representative) 611336 611336 Bekwyth, Thomas, of Clynt, esq, executors of 0
3737808 1938047 1938047 defendant Bekwith Thomas (legal representative) 611336 611336 Bekwith, Thomas, of Clynt, executors of 0
3737810 1938047 1938047 defendant Bekwith Lambert gent 611336 611336 Bekwith, Lambert, of Clynt, gent 2
3737811 1938047 1938047 defendant Bekwith Ambrose gent 611336 611336 Bekwith, Ambrose, of Clynt, gent 3
3737812 1938047 1938047 defendant Snawsell John esq 611336 611336 Snawsell, John, of Clynt, esq 4
3737814 1938048 1938048 defendant Bekwyth Thomas (legal representative) 611336 611336 Bekwyth, Thomas, of Clynt, executors of 0
3737816 1938048 1938048 defendant Bekwyth Lambert gent 611336 611336 Bekwyth, Lambert, of Clynt, gent 2
3737817 1938048 1938048 defendant Bekwyth Ambrose gent 611336 611336 Bekwyth, Ambrose, of Clynt, gent 3
3737818 1938048 1938048 defendant Snawsell John esq 611336 611336 Snawsell, John, of Clynt, esq 4
3741264 1939127 1939127 plaintiff Snawsell John esq 611336 611336 Snawsell, John, of Clynt, esq 0
3741266 1939128 1939128 plaintiff Snawsell John esq 611336 611336 Snawsell, John, of Clynt, esq 0
3783900 1952738 1952738 defendant Bokwyth Thomas esq 611336 611336 Bokwyth, Thomas, of Clynt, esq 0
3833169 1968304 1968304 defendant Beyn John barker 611336 611336 Beyn, John, of Clynt, barker 1
4078825 2052724 2052724 defendant Beckwith Thomas (legal representative) 611336 611336 Beckwith, Thomas, of Clynt, esq, executrix of 0
4078826 2052724 2052724 defendant Beckwith Katherine widow 611336 611336 Beckwith, Katherine, of Clynt, widow 1
4254625 2114535 2114535 defendant Beckwith William esq 611336 611336 Beckwith, William, of Clynt, esq 0
4254627 2114536 2114536 defendant Beckwith William esq 611336 611336 Beckwith, William, of Clynt, esq 0
4527453 2208864 2208864 defendant Bekwyth Richard de   611336 611336 together with Bekwyth, Richard de, of Clynt 2
4664790 2250463 2250463 defendant Mallom John laborer 611336 611336 Mallom, John, of Clynt, laborer 1
4841011 2308724 2308724 plaintiff Hylton John   611336 611336 Hylton, John, of Clynt 0
4841080 2308747 2308747 defendant Bayoke Robert yeoman 611336 611336 Bayoke, Robert, of Clynt, yeoman 0
4841081 2308747 2308747 defendant Whelhous William   611336 611336 Whelhous, William, of Clynt, wheel wright 1
4841082 2308747 2308747 defendant Robynson John husbandman 611336 611336 Robynson, John, of Clynt, husbandman 2
4841083 2308747 2308747 defendant Hogeson William husbandman 611336 611336 Hogeson, William, of Clynt, husbandman 3
4916513 2331670 2331670 defendant Robynson Willam yeoman 611336 611336 Robynson, Willam, of Clynt, yeoman 0
5001398 2357295 2357295 defendant Bekwyth Thomas esq 611336 611336 Bekwyth, Thomas, of Clynt, esq 0
5029995 2365647 2365647 defendant Shut Stephen yeoman 611336 611336 Shut, Stephen, of Clynt, yeoman 6
5030008 2365648 2365648 defendant Shut Stephen yeoman 611336 611336 Shut, Stephen, of Clynt, yeoman 7
5039264 2368386 2368386 plaintiff Bekewyth Thomas esq 611336 611336 Bekewyth, Thomas, of Clynt, son of William Bekwyth, esq 0
5076778 2379555 2379555 defendant Atkynson John yeoman 611336 611336 Atkynson, John, of Clynt, yeoman 0
5076797 2379556 2379556 defendant Bekwyth Thomas esq 611336 611336 Bekwyth, Thomas, of Clynt, esq 0
5079194 2380268 2380268 defendant Bekwyth Thomas esq 611336 611336 Bekwyth, Thomas, of Clynt, esq 0
5099735 2386358 2386358 defendant Bekwyth Thomas esq 611336 611336 Bekwyth, Thomas, of Clynt, esq 0
5234218 2425596 2425596 defendant Baeyok William husbandman 611336 611336 Baeyok, William, of Clynt, husbandman 2
5234220 2425596 2425596 defendant Farebarn John husbandman 611336 611336 Farebarn, John, of Clynt, husbandman 4
5234221 2425596 2425596 defendant Sympson Thomas husbandman 611336 611336 Sympson, Thomas, of Clynt, husbandman 5
5347334 2459329 2459329 defendant Bekwyth Thomas gent 611336 611336 Bekwyth, Thomas, of Clynt, gent 4
5358701 2462783 2462783 defendant Beston Robert husbandman 611336 611336 Beston, Robert, of Clynt, husbandman 1
5358702 2462783 2462783 defendant Aleyn John laborer 611336 611336 Aleyn, John, of Clynt, laborer 2
5368526 2465768 2465768 defendant Farebarn Robert yeoman 611336 611336 Farebarn, Robert, of Clynt, yeoman 5
5368556 2465769 2465769 defendant Farebarn Robert yeoman 611336 611336 Farebarn, Robert, of Clynt, yeoman 5
5370505 2466358 2466358 defendant Johnson Robert yeoman 611336 611336 Johnson, Robert, of Clynt, yeoman 2
5375848 2468039 2468039 defendant Wykeley John husbandman 611336 611336 Wykeley, John, of Clynt, husbandman 0
5375849 2468039 2468039 defendant Wykeley William husbandman 611336 611336 Wykeley, William, of Clynt, husbandman 1
5375854 2468039 2468039 defendant Ingilsant Thomas husbandman 611336 611336 Ingilsant, Thomas, of Clynt, husbandman 6
5375855 2468039 2468039 defendant Riche John husbandman 611336 611336 Riche, John, of Clynt, husbandman 7
5379205 2469092 2469092 defendant Wikeley John   611336 611336 Wikeley, John, of Clynt 0
5379206 2469092 2469092 defendant Wikeley William   611336 611336 Wikeley, William, of Clynt 1
5379211 2469092 2469092 defendant Ingilsant Thomas   611336 611336 Ingilsant, Thomas, of Clynt 6
5379212 2469092 2469092 defendant Riche John   611336 611336 Riche, John, of Clynt 7
5381949 2469894 2469894 defendant Walworth John yeoman 611336 611336 Walworth, John, of Clynt, yeoman 0
5381950 2469894 2469894 defendant Dene John yeoman 611336 611336 Dene, John, of Clynt, yeoman 1
5381951 2469894 2469894 defendant Stanfeld Henry yeoman 611336 611336 Stanfeld, Henry, of Clynt, yeoman 2
5391717 2472703 2472703 defendant Parker Thomas yeoman 611336 611336 Parker, Thomas, of Clynt, yeoman 3
5391718 2472703 2472703 defendant Parker John laborer 611336 611336 Parker, John, of Clynt, laborer 4
5391719 2472703 2472703 defendant Mall Robert laborer 611336 611336 Mall, Robert, of Clynt, laborer 5
5391720 2472703 2472703 defendant Mallom Thomas laborer 611336 611336 Mallom, Thomas, of Clynt, laborer 6
5391721 2472703 2472703 defendant Mallom George laborer 611336 611336 Mallom, George, of Clynt, laborer 7

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