names

90 rows where place_id = 592677

✎ 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
3587559 1863757 1863757 plaintiff Algore Henry (legal representative) 592677 592677 Algore, Henry, of Roydon, husbandman, executors of 0
3608496 1870318 1870318 defendant Kentisshe John laborer 592677 592677 Kentisshe, John, of Roydon, laborer 0
3615465 1872479 1872479 defendant Shepey John yeoman 592677 592677 Shepey, John, of Roydon, yeoman 0
3626547 1903154 1903154 defendant Tespyn William chaplain 592677 592677 Tespyn, William, of Roydon, chaplain 0
3650728 1910593 1910593 defendant Kyng Robert yeoman 592677 592677 Kyng, Robert, of Roydon, yeoman 0
3738275 1938186 1938186 defendant Warwyk Edmund husbandman 592677 592677 Warwyk, Edmund, of Roydon, husbandman 0
3744604 1940208 1940208 defendant Wace John husbandman 592677 592677 Wace, John, of Roydon, husbandman 0
3763722 1946299 1946299 defendant Copuldyke Thomas yeoman 592677 592677 Copuldyke, Thomas, of Roydon, yeoman 1
3763723 1946299 1946299 defendant Shepy William husbandman 592677 592677 Shepy, William, of Roydon, husbandman 2
3773598 1949455 1949455 defendant Smyth Roger husbandman 592677 592677 Smyth, Roger, of Roydon, husbandman 0
3774357 1949702 1949702 defendant Abbott John husbandman 592677 592677 Abbott, John, of Roydon, husbandman 0
3775244 1949992 1949992 defendant Barker William husbandman 592677 592677 Barker, William, of Roydon, husbandman 1
3777607 1950748 1950748 defendant Blosse Thomas husbandman 592677 592677 Blosse, Thomas, of Roydon, husbandman 3
3781778 1952046 1952046 defendant Copuldyke Thomas yeoman 592677 592677 Copuldyke, Thomas, of Roydon, yeoman 1
3781779 1952046 1952046 defendant Shepy William husbandman 592677 592677 Shepy, William, of Roydon, husbandman 2
3782941 1952410 1952410 defendant Wykham John brickmaker 592677 592677 Wykham, John, of Roydon, brickmaker 0
3788329 1954149 1954149 plaintiff Smyth Roger   592677 592677 Smyth, Roger, of Roydon 0
3788330 1954149 1954149 defendant Barker William husbandman 592677 592677 Barker, William, of Roydon, husbandman 0
3788331 1954149 1954149 defendant Wace John husbandman 592677 592677 Wace, John, of Roydon, husbandman 1
3807924 1960367 1960367 defendant Aslabe Thomas   592677 592677 Aslabe, Thomas, of Roydon, cook 2
3807933 1960370 1960370 defendant Aslaby Thomas   592677 592677 Aslaby, Thomas, of Roydon, cook 2
3807992 1960391 1960391 defendant Andrewe William husbandman 592677 592677 Andrewe, William, of Roydon, husbandman 1
3828421 1966762 1966762 defendant Harman John husbandman 592677 592677 Harman, John, of Roydon, husbandman 0
3834672 1968779 1968779 defendant Scotowe John husbandman 592677 592677 Scotowe, John, of Roydon, husbandman 0
3892244 1987659 1987659 defendant Sturges Henry clerk 592677 592677 Sturges, Henry, of Roydon, clerk 0
3943339 2004789 2004789 defendant Launcetour John husbandman 592677 592677 Launcetour, John, of Roydon, husbandman 0
3943340 2004789 2004789 defendant Launcetour Robert (legal representative) 592677 592677 Launcetour, Robert, of Roydon, husbandman, executors of 1
3943341 2004789 2004789 defendant Launcetour William husbandman 592677 592677 (Launcetour, William, of Roydon, husbandman 2
3943342 2004789 2004789 defendant Dunche Joan widow 592677 592677 Dunche, Joan, of Roydon, widow 3
4095371 2058666 2058666 defendant Whitacre Henry husbandman 592677 592677 Whitacre, Henry, of Roydon, husbandman 1
4109133 2063521 2063521 defendant Snellyng William yeoman 592677 592677 Snellyng, William, of Roydon, yeoman 0
4112967 2064907 2064907 defendant Hooker Roger   592677 592677 Hooker, Roger, of Roydon, yeoman, servant to Richard Okeden 1
4139906 2074640 2074640 defendant Parker Thomas husbandman 592677 592677 Parker, Thomas, of Roydon, husbandman 0
4139907 2074640 2074640 defendant Clarke Nicholas husbandman 592677 592677 Clarke, Nicholas, of Roydon, husbandman 1
4139908 2074640 2074640 defendant Neale Henry weaver 592677 592677 Neale, Henry, of Roydon, weaver 2
4144313 2076171 2076171 defendant Cullender John clerk 592677 592677 Cullender, John, of Roydon, clerk 2
4151043 2078494 2078494 defendant Goteham John husbandman 592677 592677 Goteham, John, of Roydon, husbandman 0
4159368 2081346 2081346 defendant Day Thomas husbandman 592677 592677 Day, Thomas, of Roydon, husbandman 2
4172960 2085995 2085995 defendant Cullymer John clerk 592677 592677 Cullymer, John, of Roydon, clerk 1
4196172 2094206 2094206 defendant Cullymer John clerk 592677 592677 Cullymer, John, of Roydon, clerk 2
4200097 2095585 2095585 defendant Dyer John husbandman, his son 592677 592677 Dyer John, of Roydon, husbandman, his son 1
4208949 2098680 2098680 defendant Cullynder John clerk 592677 592677 Cullynder, John, of Roydon, clerk 0
4210628 2099273 2099273 defendant Ferror Thomas husbandman 592677 592677 Ferror, Thomas, of Roydon, husbandman 1
4244237 2111059 2111059 defendant Froste Thomas   592677 592677 Froste, Thomas, of Roydon 0
4244994 2111308 2111308 defendant Elmye Thomas husbandman 592677 592677 Elmye, Thomas, of Roydon, husbandman 2
4246611 2111841 2111841 defendant Manne Robert husbandman 592677 592677 Manne, Robert, of Roydon, husbandman 3
4281642 2123486 2123486 defendant Smyth John yeoman 592677 592677 Smyth, John, of Roydon, yeoman 0
4281746 2123519 2123519 defendant Smyth John husbandman 592677 592677 Smyth, John, of Roydon, husbandman 2
4321165 2137496 2137496 defendant Ratclif James yeoman 592677 592677 Ratclif, James, of Roydon, yeoman 0
4325261 2138828 2138828 defendant Shuckforth John husbandman 592677 592677 Shuckforth, John, of Roydon, husbandman 0
4325262 2138828 2138828 defendant Barrett William husbandman 592677 592677 Barrett, William, of Roydon, husbandman 1
4325263 2138828 2138828 defendant Awger Nicholas husbandman 592677 592677 Awger, Nicholas, of Roydon, husbandman 2
4326787 2139311 2139311 defendant Gardener Christopher husbandman 592677 592677 Gardener, Christopher, of Roydon, husbandman 1
4326788 2139311 2139311 defendant Blosse Robert husbandman 592677 592677 Blosse, Robert, of Roydon, husbandman 2
4337283 2142772 2142772 defendant Warren Robert yeoman 592677 592677 Warren, Robert, of Roydon, yeoman 0
4346003 2145859 2145859 defendant Fulcher Thomas   592677 592677 Fulcher, Thomas, of Roydon, millwright 3
4390524 2161452 2161452 defendant Fulcher George   592677 592677 Fulcher, George, of Roydon, millwright 0
4400603 2164793 2164793 defendant Harvye Thomas yeoman 592677 592677 Harvye, Thomas, of Roydon, yeoman 0
4543012 2213706 2213706 plaintiff Argent John (legal representative) 592677 592677 Argent, John, of Roydon, executors of 0
4564478 2220455 2220455 defendant Hervy John   592677 592677 Hervy, John, of Roydon 1
4933920 2336986 2336986 defendant Edwyn John husbandman 592677 592677 Edwyn, John, of Roydon, husbandman 0
4933921 2336986 2336986 defendant Pulter Thomas pulter 592677 592677 Pulter, Thomas, of Roydon, pulter 1
4933922 2336986 2336986 defendant Webbe John husbandman 592677 592677 Webbe, John, of Roydon, husbandman 2
4933923 2336986 2336986 defendant Spicer John husbandman 592677 592677 Spicer, John, of Roydon, husbandman 3
4933925 2336987 2336987 defendant Merywether John husbandman 592677 592677 Merywether, John, of Roydon, husbandman 0
4950717 2342192 2342192 defendant Brigge Henry husbandman 592677 592677 Brigge, Henry, of Roydon, husbandman 0
5135270 2396815 2396815 defendant Wyles Peter husbandman 592677 592677 Wyles, Peter, of Roydon, husbandman 0
5253108 2431076 2431076 defendant atte Lee Richard yeoman 592677 592677 atte Lee, Richard, of Roydon, yeoman 2
5256732 2432227 2432227 defendant Slye William smith 592677 592677 Slye, William, of Roydon, smith 1
5256734 2432228 2432228 defendant Symond Richard, senior pulter 592677 592677 Symond, Richard, senior, of Roydon, pulter 0
5256735 2432228 2432228 defendant Symond Richard, junior pulter 592677 592677 Symond, Richard, junior, of Roydon, pulter 1
5301589 2445429 2445429 defendant Warde Richard husbandman 592677 592677 Warde, Richard, of Roydon, husbandman 0
5366766 2465263 2465263 defendant Skaunt Robert laborer 592677 592677 Skaunt, Robert, of Roydon, laborer 1
5366776 2465266 2465266 defendant Skaunt Robert laborer 592677 592677 Skaunt, Robert, of Roydon, laborer 1
5380584 2469498 2469498 defendant Skaunt Robert laborer 592677 592677 Skaunt, Robert, of Roydon, laborer 1
5380600 2469501 2469501 defendant Skaunt Robert laborer 592677 592677 Skaunt, Robert, of Roydon, laborer 1
5384393 2470623 2470623 defendant Skaunt Robert laborer 592677 592677 Skaunt, Robert, of Roydon, laborer 1
5385375 2470894 2470894 defendant Skaunt Robert laborer 592677 592677 Skaunt, Robert, of Roydon, laborer 1
5386350 2471163 2471163 defendant Shepey John yeoman 592677 592677 Shepey, John, of Roydon, yeoman 1
5398584 2474655 2474655 defendant Shepey John yeoman 592677 592677 Shepey, John, of roydon, yeoman 1
5417294 2480092 2480092 defendant Gaskyn Nicholas butcher 592677 592677 Gaskyn, Nicholas, of Roydon, butcher 0
5429042 2483609 2483609 defendant Fyghe Richard butcher 592677 592677 Fyghe, Richard, of Roydon, butcher 0
5429043 2483609 2483609 defendant Birle Thomas husbandman 592677 592677 Birle, Thomas, of Roydon, husbandman 1
5446225 2488760 2488760 defendant Fyghe Richard butcher 592677 592677 Fyghe, Richard, of Roydon, butcher 0
5446226 2488760 2488760 defendant Byrle Thomas husbandman 592677 592677 Byrle, Thomas, of Roydon, husbandman 1
5458864 2492544 2492544 defendant Fyghe Richard butcher 592677 592677 Fyghe, Richard, of Roydon, butcher 0
5458865 2492544 2492544 defendant Byrle Thomas husbandman 592677 592677 Byrle, Thomas, of Roydon, husbandman 1
5538999 2516685 2516685 defendant Clerk Thomas courser 592677 592677 Clerk, Thomas, of Roydon, courser 0
5614631 2548372 2548372 defendant Rowe William   592677 592677 Rowe, William, of Roydon 0
5622305 2550894 2550894 defendant Fissher John   592677 592677 Fissher, John, of Roydon 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);