names

81 rows where place_id = 592611

✎ 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
3608241 1870233 1870233 defendant Bonde John yeoman 592611 592611 Bonde, John, of Fekenham, yeoman 1
3608243 1870233 1870233 defendant Jones Richard yeoman 592611 592611 Jones, Richard, of Fekenham, yeoman 3
3620139 1873874 1873874 defendant Holyok Richard laborer 592611 592611 Holyok, Richard, of Fekenham, laborer 0
3629079 1903972 1903972 defendant Steward Thomas husbandman 592611 592611 Steward, Thomas, of Fekenham, husbandman 2
3629083 1903972 1903972 defendant Jenettys Humphrey gent 592611 592611 Jenettys, Humphrey, of Fekenham, gent 6
3656613 1912322 1912322 defendant Lyghtfote John husbandman 592611 592611 Lyghtfote, John, of Fekenham, husbandman 0
3657716 1912664 1912664 defendant Haryson John yeoman 592611 592611 Haryson, John, of Fekenham, yeoman 0
3658350 1912861 1912861 defendant Reve John yeoman 592611 592611 Reve, John, of Fekenham, yeoman 1
3659899 1913354 1913354 defendant Hay Thomas husbandman 592611 592611 Hay, Thomas, of Fekenham, husbandman 0
3659901 1913354 1913354 defendant Shepey John husbandman 592611 592611 Shepey, John, of Fekenham, husbandman 2
3675339 1918325 1918325 defendant Laugher Humphrey laborer 592611 592611 Laugher, Humphrey, of Fekenham, laborer 2
3681153 1920188 1920188 defendant Cawdrey John yeoman 592611 592611 Cawdrey, John, of Fekenham, yeoman 0
3681154 1920188 1920188 defendant Cartwryght Robert yeoman 592611 592611 Cartwryght, Robert, of Fekenham, yeoman 1
3681169 1920194 1920194 defendant Hay Thomas husbandman 592611 592611 Hay, Thomas, of Fekenham, husbandman 1
3684663 1921336 1921336 defendant Hodbache Humphrey husbandman 592611 592611 Hodbache, Humphrey, of Fekenham, husbandman 0
3684664 1921336 1921336 defendant Suter Robert, senior husbandman 592611 592611 Suter, Robert, senior, of Fekenham, husbandman 1
3692423 1923807 1923807 defendant Asteley Thomas husbandman 592611 592611 Asteley, Thomas, of Fekenham, husbandman 2
3710944 1929740 1929740 defendant Johnson William smith 592611 592611 Johnson, William, of Fekenham, smith 0
3710945 1929740 1929740 defendant Yerdeley Humphrey chaplain 592611 592611 Yerdeley, Humphrey, of Fekenham, chaplain 1
3710946 1929740 1929740 defendant Johnson Thomas smith 592611 592611 Johnson, Thomas, of Fekenham, smith 2
3710947 1929740 1929740 defendant Holyok Thomas laborer 592611 592611 Holyok, Thomas, of Fekenham, laborer 3
3710948 1929740 1929740 defendant Gremyll Robert laborer 592611 592611 Gremyll, Robert, of Fekenham, laborer 4
3710949 1929740 1929740 defendant Grete John laborer 592611 592611 Grete, John, of Fekenham, laborer 5
3710950 1929740 1929740 defendant Reve Robert laborer 592611 592611 Reve, Robert, of Fekenham, laborer 6
3710951 1929740 1929740 defendant Reve Baldwin laborer 592611 592611 Reve, Baldwin, of Fekenham, laborer 7
3710952 1929740 1929740 defendant Asten Robert laborer 592611 592611 Asten, Robert, of Fekenham, laborer 8
3710953 1929740 1929740 defendant Johnson Edward smith 592611 592611 Johnson, Edward, of Fekenham, smith 9
3710954 1929740 1929740 defendant Pores John tailor 592611 592611 Pores, John, of Fekenham, tailor 10
3711616 1929944 1929944 defendant Adams Thomas clerk 592611 592611 Adams, Thomas, of Fekenham, clerk 0
3712043 1930087 1930087 defendant Chapman Robert butcher 592611 592611 Chapman, Robert, of Fekenham, butcher 0
3716467 1931444 1931444 defendant Heywode Richard husbandman 592611 592611 Heywode, Richard, of Fekenham, husbandman 2
3719725 1932437 1932437 defendant Freman Thomas yeoman 592611 592611 Freman, Thomas, of Fekenham, yeoman 0
3719727 1932437 1932437 defendant Rondell Thomas laborer 592611 592611 Rondell, Thomas, of Fekenham, laborer 2
3719728 1932437 1932437 defendant Reve John laborer 592611 592611 Reve, John, of Fekenham, laborer 3
3719729 1932437 1932437 defendant Reve John husbandman 592611 592611 Reve, John, of Fekenham, husbandman 4
3740876 1939006 1939006 defendant Jenettys Humphrey gent 592611 592611 Jenettys, Humphrey, of Fekenham, gent 0
3740878 1939007 1939007 defendant Jenettys Humphrey gent 592611 592611 Jenettys, Humphrey, of Fekenham, gent 0
3751400 1942354 1942354 defendant Cawdrey John husbandman 592611 592611 Cawdrey, John, of Fekenham, husbandman 0
3751401 1942354 1942354 defendant Cawdrey Humphrey husbandman 592611 592611 Cawdrey, Humphrey, of Fekenham, husbandman 1
3759031 1944812 1944812 defendant Yate Thomas husbandman 592611 592611 Yate, Thomas, of Fekenham, husbandman 0
3759032 1944812 1944812 defendant Yate William laborer 592611 592611 Yate, William, of Fekenham, laborer 1
3767050 1947355 1947355 defendant Wodward John husbandman 592611 592611 Wodward, John, of Fekenham, husbandman 1
3767051 1947355 1947355 defendant Bolton John husbandman 592611 592611 Bolton, John, of Fekenham, husbandman 2
3774129 1949620 1949620 defendant Rutter James yeoman 592611 592611 Rutter, James, of Fekenham, yeoman 4
3782855 1952387 1952387 defendant Skargyll Lewis husbandman 592611 592611 Skargyll, Lewis, of Fekenham, husbandman 0
3791062 1955035 1955035 defendant Freman John husbandman 592611 592611 Freman, John, of Fekenham, husbandman 1
3794846 1956258 1956258 defendant Cawdrey John husbandman 592611 592611 Cawdrey, John, of Fekenham, husbandman 0
3798486 1957428 1957428 defendant Jenettys Humphrey gent 592611 592611 Jenettys, Humphrey, of Fekenham, gent 0
3812251 1961734 1961734 defendant Staunton John husbandman 592611 592611 Staunton, John, of Fekenham, husbandman 0
3816314 1963010 1963010 plaintiff Homan Humphrey husbandman 592611 592611 Homan, Humphrey, of Fekenham, husbandman 0
3821749 1964690 1964690 defendant Jenettys Humphrey gent 592611 592611 Jenettys, Humphrey, of Fekenham, gent 0
3821761 1964693 1964693 defendant Aston Robert yeoman 592611 592611 Aston, Robert, of Fekenham, yeoman 3
3837148 1969520 1969520 defendant Cawdrey John yeoman 592611 592611 Cawdrey, John, of Fekenham, yeoman 1
3846716 1972528 1972528 defendant Smyth Richard husbandman 592611 592611 Smyth, Richard, of Fekenham, husbandman 1
3856904 1975791 1975791 defendant Yede Humphrey miller 592611 592611 Yede, Humphrey, of Fekenham, miller 1
3892681 1987800 1987800 defendant Harcote William husbandman 592611 592611 Harcote, William, of Fekenham, husbandman 3
4025734 2033857 2033857 plaintiff Browne William haberdasher 592611 592611 Browne, William, of Fekenham, haberdasher 0
4573156 2223138 2223138 defendant Aleyn John chaplain & formerly parson 592611 592611 Aleyn, John, of Fekenham, chaplain & formerly parson 0
4582109 2225839 2225839 defendant Waysshopaille William   592611 592611 Waysshopaille, William, of Fekenham 7
4630358 2240402 2240402 defendant Danyell Thomas   592611 592611 Danyell, Thomas, of Fekenham 3
4754271 2281714 2281714 defendant atte Yate Thomas yeoman 592611 592611 atte Yate, Thomas, of Fekenham, yeoman 1
4993145 2354831 2354831 defendant Brent William husbandman 592611 592611 Brent, William, of Fekenham, husbandman 0
5035559 2367260 2367260 defendant Alcokkes William husbandman 592611 592611 Alcokkes, William, of Fekenham, husbandman 0
5226081 2423296 2423296 defendant Bonde John husbandman 592611 592611 Bonde, John, of Fekenham, husbandman 7
5226082 2423296 2423296 defendant Reve Thomas husbandman 592611 592611 Reve, Thomas, of Fekenham, husbandman 8
5226083 2423296 2423296 defendant Rawelyn Richard husbandman 592611 592611 Rawelyn, Richard, of Fekenham, husbandman 9
5226084 2423296 2423296 defendant Homan Thomas husbandman 592611 592611 Homan, Thomas, of Fekenham, husbandman 10
5226085 2423296 2423296 defendant CLerk John husbandman 592611 592611 CLerk, John, of Fekenham, husbandman 11
5492048 2502529 2502529 defendant Barnet Richard husbandman 592611 592611 Barnet, Richard, of Fekenham, husbandman 1
5492050 2502529 2502529 defendant Mores Ralph butcher 592611 592611 Mores, Ralph, of Fekenham, butcher 3
5515406 2509663 2509663 defendant Moreys Ralph husbandman 592611 592611 Moreys, Ralph, of Fekenham, husbandman 2
5549451 2519892 2519892 defendant Taillour John yeoman 592611 592611 Taillour, John, of Fekenham, yeoman 0
5555638 2521641 2521641 defendant Lane Thomas yeoman 592611 592611 Lane, Thomas, of Fekenham, yeoman 0
5566642 2524837 2524837 defendant Cawderey John husbandman 592611 592611 Cawderey, John, of Fekenham, husbandman 3
5573286 2526742 2526742 defendant Steward Henry husbandman 592611 592611 Steward, Henry, of Fekenham, husbandman 0
5574583 2527126 2527126 defendant Gybbons Richard husbandman 592611 592611 Gybbons, Richard, of Fekenham, husbandman 1
5574584 2527126 2527126 defendant Peret Richard husbandman 592611 592611 Peret, Richard, of Fekenham, husbandman 2
5574585 2527126 2527126 defendant Bonde William husbandman 592611 592611 Bonde, William, of Fekenham, husbandman 3
5581346 2529235 2529235 defendant Ede Richard carpenter 592611 592611 Ede, Richard, of Fekenham, carpenter 3
5589909 2531829 2531829 defendant Bounde William yeoman 592611 592611 Bounde, William, of Fekenham, yeoman 0
5589910 2531829 2531829 defendant Taillour Thomas yeoman 592611 592611 Taillour, Thomas, of Fekenham, 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);