names

45 rows where place_id = 586173

✎ 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
3588079 1863921 1863921 defendant Baker Thomas laborer 586173 586173 Baker, Thomas, of Bramfeld, laborer 1
3603845 1868876 1868876 plaintiff Felawe Robert   586173 586173 Felawe, Robert, of Bramfeld 0
3607482 1870000 1870000 defendant Marten John wheeler 586173 586173 Marten, John, of Bramfeld, wheeler 1
3639055 1907037 1907037 defendant Melle Robert yeoman 586173 586173 Melle, Robert, of Bramfeld, yeoman 1
3646708 1909372 1909372 defendant Dengayn Henry gent 586173 586173 Dengayn, Henry, of Bramfeld, gent 3
3654053 1911531 1911531 defendant Wuley William clerk administrators of 586173 586173 Wuley, William, of Bramfeld, clerk administrators of 0
3654055 1911531 1911531 defendant More William yeoman 586173 586173 More, William, of Bramfeld, yeoman 2
3660898 1913675 1913675 defendant Penyfather John husbandman 586173 586173 Penyfather, John, of Bramfeld, husbandman 2
3679319 1919592 1919592 defendant Wynne Thomas husbandman 586173 586173 Wynne, Thomas, of Bramfeld, husbandman 3
3729709 1935546 1935546 defendant Bonde Robert husbandman 586173 586173 Bonde, Robert, of Bramfeld, husbandman 0
3750855 1942188 1942188 defendant Pryme John baker 586173 586173 Pryme, John, of Bramfeld, baker 0
3766726 1947255 1947255 defendant Pryme John baker 586173 586173 Pryme, John, of Bramfeld, baker 0
3784585 1952966 1952966 defendant Pryme John baker 586173 586173 Pryme, John, of Bramfeld, baker 0
3799525 1957769 1957769 defendant Melle John yeoman 586173 586173 Melle, John, of Bramfeld, yeoman 0
3801121 1958269 1958269 defendant Pryme John baker 586173 586173 Pryme, John, of Bramfeld, baker 0
3806877 1960061 1960061 defendant Melle John yeoman 586173 586173 Melle, John, of Bramfeld, yeoman 0
3806878 1960061 1960061 defendant Gyd William laborer 586173 586173 Gyd, William, of Bramfeld, laborer 1
3806879 1960061 1960061 defendant Whetcrofte William laborer 586173 586173 Whetcrofte, William, of Bramfeld, laborer 2
3823597 1965278 1965278 defendant Weste Thomas husbandman 586173 586173 Weste, Thomas, of Bramfeld, husbandman 0
3824575 1965562 1965562 defendant Melle John yeoman 586173 586173 Melle, John, of Bramfeld, yeoman 0
3824576 1965562 1965562 defendant Gyle William laborer 586173 586173 Gyle, William, of Bramfeld, laborer 1
3824577 1965562 1965562 defendant Whacroft William laborer 586173 586173 Whacroft, William, of Bramfeld, laborer 2
3862202 1977541 1977541 plaintiff Mellys Robert   586173 586173 (Mellys, Robert, of Bramfeld 1
3865086 1978526 1978526 defendant Clerk Robert   586173 586173 Clerk, Robert, of Bramfeld, horse courser 0
3915346 1995498 1995498 defendant Fyske Geoffrey husbandman 586173 586173 Fyske, Geoffrey, of Bramfeld, husbandman 1
3923607 1998205 1998205 defendant Veysey Thomas husbandman 586173 586173 Veysey, Thomas, of Bramfeld, husbandman 1
3927405 1999512 1999512 defendant Hynde Henry weaver 586173 586173 Hynde, Henry, of Bramfeld, weaver 0
3953080 2008142 2008142 defendant Skete John yeoman 586173 586173 Skete, John, of Bramfeld, yeoman 0
4019331 2031648 2031648 plaintiff Watlynge Thomas yeoman 586173 586173 Watlynge, Thomas, of Bramfeld, yeoman 0
4078966 2052777 2052777 plaintiff Todd Alice (legal representative) 586173 586173 Todd, Alice, of Bramfeld, widow, executors of 0
4081085 2053547 2053547 defendant West William yeoman 586173 586173 West, William, of Bramfeld, yeoman 1
4105264 2062161 2062161 defendant Melle Roger gent 586173 586173 Melle, Roger, of Bramfeld, gent 1
4125435 2069377 2069377 defendant Jonson William husbandman 586173 586173 Jonson, William, of Bramfeld, husbandman 1
4167606 2084166 2084166 defendant Mell Roger gent 586173 586173 Mell, Roger, of Bramfeld, gent 0
4226001 2104563 2104563 defendant Beamond William (legal representative) 586173 586173 Beamond, William, of Bramfeld, yeoman, executors of 0
4584943 2226722 2226722 defendant Duston John   586173 586173 Duston, John, of Bramfeld 4
4678123 2258768 2258768 defendant Barkere John laborer 586173 586173 Barkere, John, of Bramfeld, laborer 3
4679703 2259268 2259268 defendant Skut John fuller 586173 586173 Skut, John, of Bramfeld, fuller 2
4782534 2290547 2290547 defendant Rolf John laborer 586173 586173 Rolf, John, of Bramfeld, laborer 1
4818775 2301959 2301959 defendant Smyth John ploughman 586173 586173 Smyth, John, of Bramfeld, ploughman 0
5084030 2381726 2381726 defendant Burgeys William yeoman 586173 586173 Burgeys, William, of Bramfeld, yeoman 0
5098301 2385932 2385932 defendant Emson John husbandman 586173 586173 Emson, John, of Bramfeld, husbandman 0
5310779 2448260 2448260 defendant Bacon Robert yeoman 586173 586173 Bacon, Robert, of Bramfeld, yeoman 0
5396091 2473966 2473966 defendant Shawe Thomas husbandman 586173 586173 Shawe, Thomas, of Bramfeld, husbandman 2
5619015 2549794 2549794 plaintiff Oby Thomas   586173 586173 Oby, Thomas, of Bramfeld 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);