names

108 rows where place_id = 622943

✎ 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
3749833 1941860 1941860 defendant Kendall Richard yeoman 622943 622943 Kendall, Richard, of Hayton, yeoman 0
3761044 1945456 1945456 defendant Cowdale Thomas husbandman 622943 622943 Cowdale, Thomas, of Hayton, husbandman 1
3834031 1968584 1968584 defendant Shaye Thomas yeoman 622943 622943 Shaye, Thomas, of Hayton, yeoman 1
3919394 1996816 1996816 defendant Westmerlande Ralph yeoman 622943 622943 Westmerlande, Ralph, of Hayton, yeoman 0
3938646 2003267 2003267 defendant Hede Edward clerk 622943 622943 Hede, Edward, of Hayton, clerk 0
4042956 2039956 2039956 defendant Musgrave Thomas gent 622943 622943 Musgrave, Thomas, of Hayton, Cumber, gent 0
4042957 2039956 2039956 defendant Musgrave Michael yeoman 622943 622943 Musgrave, Michael, of Hayton, yeoman 1
4042958 2039956 2039956 defendant Bowman Richard yeoman 622943 622943 Bowman, Richard, of Hayton, yeoman 2
4042961 2039957 2039957 defendant Musgrave Thomas gent 622943 622943 Musgrave, Thomas, of Hayton, Cumber, gent 0
4042962 2039957 2039957 defendant Musgrave Michael yeoman 622943 622943 Musgrave, Michael, of Hayton, yeoman 1
4042963 2039957 2039957 defendant Bowman Richard yeoman 622943 622943 Bowman, Richard, of Hayton, yeoman 2
4044555 2040504 2040504 defendant Webbe Robert yeoman 622943 622943 Webbe, Robert, of Hayton, yeoman 0
4296608 2128887 2128887 defendant Nevell Ruth widow 622943 622943 Ruth his wife, formerly Ruth Jessoppe, of Hayton, widow 1
4329228 2140088 2140088 defendant Nevell Rith widow 622943 622943 Rith his wife, formerly Ruth Jesoppe, of Hayton, widow 1
4420873 2171423 2171423 defendant Rudstan John de   622943 622943 Rudstan, John de, of Hayton 2
4421337 2171575 2171575 defendant Eddessone Robert   622943 622943 Eddessone, Robert, of Hayton 0
4426084 2172968 2172968 defendant Belle John   622943 622943 Belle, John, of Hayton 0
4427266 2173359 2173359 defendant Jakeson Robert   622943 622943 Jakeson, Robert, of Hayton 0
4436161 2176049 2176049 defendant Gunvays John   622943 622943 Gunvays, John, of Hayton 5
4445684 2183607 2183607 plaintiff Cunnays John   622943 622943 Cunnays, John, of Hayton 0
4479839 2194357 2194357 defendant Hayton Richard de   622943 622943 Hayton, Richard de, of Hayton 0
4486697 2196550 2196550 defendant (illegible) Robert   622943 622943 ----, Robert, of Hayton 2
4501741 2201142 2201142 defendant Byddes John   622943 622943 Byddes, John, of Hayton 9
4538200 2212234 2212234 defendant Thurstanfeld John de   622943 622943 Thurstanfeld, John de, of Hayton 0
4564974 2220612 2220612 defendant Credlyng Adam   622943 622943 Credlyng, Adam, of Hayton 2
4600439 2231363 2231363 defendant Wilson Thomas   622943 622943 Wilson, Thomas, of Hayton 4
4612761 2235057 2235057 defendant Cridlyng Adam   622943 622943 Cridlyng, Adam, of Hayton 0
4619609 2237123 2237123 plaintiff Holthorp William   622943 622943 Holthorp, William, of Hayton 0
4623764 2238409 2238409 defendant Calfhird William   622943 622943 Calfhird, William, of Hayton 0
4633286 2241277 2241277 defendant Thomlynson John   622943 622943 Thomlynson, John, of Hayton 2
4648880 2245731 2245731 defendant Wilson Thomas   622943 622943 Wilson, Thomas, of Hayton 2
4648920 2245739 2245739 defendant Hudson Wiilliam   622943 622943 Hudson, Wiilliam, of Hayton 2
4689291 2262211 2262211 defendant Forster Thomas yeoman 622943 622943 Forster, Thomas, of Hayton, yeoman 1
4693200 2263374 2263374 defendant Ughtbrig alias Potager Robert husbandman 622943 622943 Ughtbrig alias Potager, Robert, of Hayton, husbandman 0
4696483 2264376 2264376 defendant Forster Thomas husbandman 622943 622943 Forster, Thomas, of Hayton, husbandman 0
4698225 2264929 2264929 defendant Gateles John   622943 622943 Gateles, John, of Hayton, vicar 0
4698226 2264929 2264929 defendant Stapulton Thomas laborer 622943 622943 Stapulton, Thomas, of Hayton, laborer 1
4698511 2265010 2265010 defendant Jonson Walter husbandman 622943 622943 Jonson, Walter, of Hayton, husbandman 0
4699145 2265197 2265197 plaintiff Dobynson Roboert   622943 622943 Dobynson, Roboert, of Hayton 0
4701368 2265829 2265829 plaintiff Gammays John   622943 622943 Gammays, John, of Hayton 0
4701369 2265829 2265829 defendant Colson Robert husbandman 622943 622943 Colson, Robert, of Hayton, husbandman 0
4710025 2268493 2268493 defendant Potiger Robert husbandman 622943 622943 Potiger, Robert, of Hayton, husbandman 1
4710656 2268689 2268689 defendant Hayton Richard gent 622943 622943 Hayton, Richard, of Hayton, gent 0
4712267 2269152 2269152 defendant Crydelyng Adam husbandman 622943 622943 Crydelyng, Adam, of Hayton, husbandman 1
4714275 2269793 2269793 defendant Hudson William yeoman 622943 622943 Hudson, William, of Hayton, yeoman 1
4714276 2269793 2269793 defendant Semer Thomas yeoman 622943 622943 Semer, Thomas, of Hayton, yeoman 2
4714284 2269796 2269796 defendant Hudson William yeoman 622943 622943 Hudson, William, of Hayton, yeoman 1
4714286 2269797 2269797 defendant Robynson John yeoman 622943 622943 Robynson, John, of Hayton, yeoman 0
4714287 2269797 2269797 defendant Thurstandfeld William yeoman 622943 622943 Thurstandfeld, William, of Hayton, yeoman 1
4714292 2269799 2269799 defendant Sawll William yeoman 622943 622943 Sawll, William, of Hayton, yeoman 0
4714293 2269799 2269799 defendant Pantyng John yeoman 622943 622943 Pantyng, John, of Hayton, yeoman 1
4714295 2269800 2269800 defendant Hudson William yeoman 622943 622943 Hudson, William, of Hayton, yeoman 0
4714297 2269801 2269801 defendant Chaloner John yeoman 622943 622943 Chaloner, John, of Hayton, yeoman 0
4714301 2269802 2269802 defendant Jonson Robert husbandman 622943 622943 Jonson, Robert, of Hayton, husbandman 1
4714302 2269802 2269802 defendant Hudson William husbandman 622943 622943 Hudson, William, of Hayton, husbandman 2
4724193 2272860 2272860 defendant Crosseby John husbandman 622943 622943 Crosseby, John, of Hayton, husbandman 3
4732982 2275494 2275494 defendant Hudson William yeoman 622943 622943 Hudson, William, of Hayton, yeoman 1
4764418 2284859 2284859 defendant Neweton Robert yeoman 622943 622943 Neweton, Robert, of Hayton, yeoman 0
4765619 2285237 2285237 defendant Neweton Robert   622943 622943 Neweton, Robert, of Hayton, franklin 0
4774454 2287994 2287994 defendant Lynsay John husbandman 622943 622943 Lynsay, John, of Hayton, husbandman 2
4782588 2290567 2290567 defendant Giltoft John husbandman 622943 622943 Giltoft, John, of Hayton, husbandman 2
4796286 2294985 2294985 defendant Potager Robeert husbandman 622943 622943 Potager, Robeert, of Hayton, husbandman 1
4821844 2302906 2302906 defendant Wilton Thomas gent 622943 622943 Wilton, Thomas, of Hayton, gent 0
4833277 2306419 2306419 defendant Doweson Thomas   622943 622943 Doweson, Thomas, of Hayton 0
4842252 2309110 2309110 defendant Crosby John yeoman 622943 622943 Crosby, John, of Hayton, yeoman 1
4848719 2311067 2311067 defendant Jakson Richard husbandman 622943 622943 Jakson, Richard, of Hayton, husbandman 0
4875118 2319172 2319172 defendant Nicholson William husbandman 622943 622943 Nicholson, William, of Hayton, husbandman 0
4875294 2319227 2319227 plaintiff Rudstan Robert   622943 622943 Rudstan, Robert, of Hayton 0
4886756 2322710 2322710 defendant Hudson William yeoman 622943 622943 Hudson, William, of Hayton, yeoman 6
4905359 2328267 2328267 defendant Lee John, senior yeoman 622943 622943 Lee, John, senior, of Hayton, yeoman 0
4905360 2328267 2328267 defendant Lee John, junior yeoman 622943 622943 Lee, John, junior, of Hayton, yeoman 1
4906883 2328738 2328738 defendant Spencer William husbandman 622943 622943 Spencer, William, of Hayton, husbandman 0
4911228 2330019 2330019 defendant del Forge Thomas husbandman 622943 622943 del Forge, Thomas, of Hayton, husbandman 7
4947680 2341261 2341261 defendant Horne William husbandman 622943 622943 Horne, William, of Hayton, husbandman 3
4993962 2355067 2355067 defendant Hope John husbandman 622943 622943 Hope, John, of Hayton, husbandman 0
5011078 2360094 2360094 defendant Robard William husbandman 622943 622943 Robard, William, of Hayton, husbandman 1
5019456 2362572 2362572 defendant Martindall William, junior esq 622943 622943 Martindall, William, junior, of Hayton, Cumber, esq 2
5045155 2370180 2370180 defendant Scardeburgh Richard yeoman 622943 622943 Scardeburgh, Richard, of Hayton, yeoman 0
5119089 2392021 2392021 defendant Smyth John chaplain 622943 622943 Smyth, John, of Hayton, chaplain 6
5152301 2401806 2401806 defendant Botte William   622943 622943 Botte, William, of Hayton, parish clerk 0
5170137 2406997 2406997 defendant Botte William   622943 622943 Botte, William, of Hayton, parish clerk 0
5187556 2412080 2412080 defendant Botte William   622943 622943 Botte, William, of Hayton, parish clerk 0
5213197 2419589 2419589 defendant Catton Robert yeoman 622943 622943 Catton, Robert, of Hayton, yeoman 0
5213198 2419589 2419589 defendant Bedale John sawyer 622943 622943 Bedale, John, of Hayton, sawyer 1
5229382 2424203 2424203 defendant Hayton Robert butcher 622943 622943 Hayton, Robert, of Hayton, butcher 8
5236287 2426201 2426201 defendant Colnell Robert gent 622943 622943 Colnell, Robert, of Hayton, gent 0
5236288 2426201 2426201 defendant Floyter John husbandman 622943 622943 Floyter, John, of Hayton, husbandman 1
5239094 2427026 2427026 defendant Doyle John husbandman 622943 622943 Doyle, John, of Hayton, husbandman 3
5286619 2441097 2441097 defendant Wyddyr William weaver 622943 622943 Wyddyr, William, of Hayton, weaver 0
5286620 2441097 2441097 defendant Prestman John weaver 622943 622943 Prestman, John, of Hayton, weaver 1
5292499 2442803 2442803 defendant Hayton Robert gent 622943 622943 Hayton, Robert, of Hayton, gent 0
5292500 2442803 2442803 defendant Bynkes Robert laborer 622943 622943 Bynkes, Robert, of Hayton, laborer 1
5292501 2442803 2442803 defendant Turner Richard chaplain 622943 622943 Turner, Richard, of Hayton, chaplain 2
5292502 2442803 2442803 defendant Wylkynson John laborer 622943 622943 Wylkynson, John, of Hayton, laborer 3
5323500 2452108 2452108 defendant Draper Nicholas yeoman 622943 622943 Draper, Nicholas, of Hayton, yeoman 0
5326601 2453027 2453027 defendant Doly John husbandman 622943 622943 Doly, John, of Hayton, husbandman 37
5326602 2453027 2453027 defendant Lylly Robert husbandman 622943 622943 Lylly, Robert, of Hayton, husbandman 38
5326603 2453027 2453027 defendant Lylly William husbandman 622943 622943 Lylly, William, of Hayton, husbandman 39
5326604 2453027 2453027 defendant Wilson Thomas husbandman 622943 622943 Wilson, Thomas, of Hayton, husbandman 40
5326605 2453027 2453027 defendant Walker John husbandman 622943 622943 Walker, John, of Hayton, husbandman 41

Next page

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