names

111 rows where place_id = 604163

✎ 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
3657045 1912464 1912464 defendant Fyssher Richard husbandman 604163 604163 Fyssher, Richard, of Ekyngton, husbandman 6
3657048 1912464 1912464 defendant Junyns John husbandman 604163 604163 Junyns, John, of Ekyngton, husbandman 9
3659244 1913148 1913148 defendant Fyssher Richard husbandman 604163 604163 Fyssher, Richard, of Ekyngton, husbandman 0
3664465 1914832 1914832 defendant George Robert yeoman 604163 604163 George, Robert, of Ekyngton, yeoman 1
3672278 1917329 1917329 defendant George Robert yeoman 604163 604163 George, Robert, of Ekyngton, yeoman 0
3680656 1920028 1920028 defendant George John yeoman 604163 604163 George, John, of Ekyngton, yeoman 0
3680658 1920029 1920029 defendant George John yeoman 604163 604163 George, John, of Ekyngton, yeoman 0
3680660 1920030 1920030 defendant George John yeoman 604163 604163 George, John, of Ekyngton, yeoman 0
3683085 1920826 1920826 defendant George John yeoman 604163 604163 George, John, of Ekyngton, yeoman 0
3688550 1922577 1922577 defendant George John yeoman 604163 604163 George, John, of Ekyngton, yeoman 2
3703161 1927261 1927261 defendant George Robert husbandman 604163 604163 George, Robert, of Ekyngton, husbandman 0
3703162 1927261 1927261 defendant George John husbandman 604163 604163 George, John, of Ekyngton, husbandman 1
3710668 1929657 1929657 defendant George Robert husbandman 604163 604163 George, Robert, of Ekyngton, husbandman 0
3710669 1929657 1929657 defendant Fyssher Richard husbandman 604163 604163 Fyssher, Richard, of Ekyngton, husbandman 1
3710670 1929657 1929657 defendant Jenyns Richard husbandman 604163 604163 Jenyns, Richard, of Ekyngton, husbandman 2
3710671 1929657 1929657 defendant Rogers Thomas husbandman 604163 604163 Rogers, Thomas, of Ekyngton, husbandman 3
3716027 1931300 1931300 defendant George John, senior yeoman 604163 604163 George, John, senior, of Ekyngton, yeoman 0
3716028 1931300 1931300 defendant George John, junior laborer 604163 604163 George, John, junior, of Ekyngton, laborer 1
3716029 1931300 1931300 defendant George Richard laborer 604163 604163 George, Richard, of Ekyngton, laborer 2
3722618 1933333 1933333 plaintiff More Robert yeoman 604163 604163 More, Robert, of Ekyngton, yeoman 0
3723274 1933551 1933551 defendant Palmer Thomas husbandman 604163 604163 Palmer, Thomas, of Ekyngton, husbandman 0
3770628 1948498 1948498 defendant Chamfloure Richard husbandman 604163 604163 Chamfloure, Richard, of Ekyngton, husbandman 1
3770629 1948498 1948498 defendant Roberdys Richard husbandman 604163 604163 Roberdys, Richard, of Ekyngton, husbandman 2
3791441 1955160 1955160 defendant George Robert yeoman 604163 604163 George, Robert, of Ekyngton, yeoman 0
3791461 1955165 1955165 defendant George Robert husbandman 604163 604163 George, Robert, of Ekyngton, husbandman 2
3793133 1955712 1955712 defendant Bolessover Agnes widow 604163 604163 Bolessover, Agnes, of Ekyngton, widow 1
3810057 1961036 1961036 defendant Jelott John yeoman 604163 604163 Jelott, John, of Ekyngton, yeoman 0
3845648 1972183 1972183 defendant Chambers Nicholas yeoman 604163 604163 Chambers, Nicholas, of Ekyngton, yeoman 0
3922996 1997997 1997997 defendant Turneley Agnes widow 604163 604163 Turneley, Agnes, of Ekyngton, widow 2
3939945 2003660 2003660 defendant Wordesworth John   604163 604163 Wordesworth, John, of Ekyngton, girdle maker 0
3939946 2003660 2003660 defendant Wordesworth Henry   604163 604163 Wordesworth, Henry, of Ekyngton, girdle maker 1
3972389 2014915 2014915 defendant Thornebery Thomas husbandman 604163 604163 Thornebery, Thomas, of Ekyngton, husbandman 0
3972390 2014915 2014915 defendant Chawndeler John husbandman 604163 604163 Chawndeler, John, of Ekyngton, husbandman 1
4024539 2033451 2033451 plaintiff Blount Robert gent 604163 604163 Blount, Robert, of Ekyngton, gent 0
4048246 2041813 2041813 defendant Hallam Francis yeoman 604163 604163 Hallam, Francis, of Ekyngton, or of High Melton, Yorks, yeoman 0
4048248 2041814 2041814 defendant Hallam Francis yeoman 604163 604163 Hallam, Francis, of Ekyngton, or of High Mylton, Yorks, yeoman 0
4439712 2181693 2181693 defendant Carder William chaplain 604163 604163 Carder, William, of Ekyngton, chaplain 0
4439713 2181693 2181693 defendant Carder John chaplain 604163 604163 Carder, John, of Ekyngton, chaplain 1
4439714 2181693 2181693 defendant Bostok William   604163 604163 Bostok, William, of Ekyngton 2
4491852 2198130 2198130 plaintiff Wright John   604163 604163 Wright, John, of Ekyngton 0
4491853 2198130 2198130 defendant Felawe Robert   604163 604163 Felawe, Robert, of Ekyngton 0
4491856 2198130 2198130 defendant Nicholisson John   604163 604163 Nicholisson, John, of Ekyngton 3
4613861 2235351 2235351 defendant Nelesthorp Richard   604163 604163 Nelesthorp, Richard, of Ekyngton 0
4616354 2236108 2236108 defendant Cade John   604163 604163 Cade, John, of Ekyngton 0
4624579 2238669 2238669 defendant Marchall William   604163 604163 Marchall, William, of Ekyngton 3
4624581 2238669 2238669 defendant Nelesthorp Richard   604163 604163 Nelesthorp, Richard, of Ekyngton 5
4681338 2259787 2259787 defendant Puspan Richard   604163 604163 Puspan, Richard, of Ekyngton, cartwright 2
4681339 2259787 2259787 defendant Hardy John laborer 604163 604163 Hardy, John, of Ekyngton, laborer 3
4682361 2260105 2260105 defendant Preston Roger husbandman 604163 604163 Preston, Roger, of Ekyngton, husbandman 0
4704486 2266778 2266778 defendant Marschall William   604163 604163 Marschall, William, of Ekyngton, franklin 0
4706895 2267537 2267537 defendant Ingelby John   604163 604163 Ingelby, John, of Ekyngton, parson of half the church 0
4743706 2278689 2278689 plaintiff Darcy William chaplain 604163 604163 Darcy, William, of Ekyngton, chaplain 0
4743708 2278689 2278689 defendant Ilkynston William de   604163 604163 Ilkynston, William de, of Ekyngton, parson of half the church 0
4750942 2280759 2280759 defendant Horskane Richard collier 604163 604163 Horskane, Richard, of Ekyngton, collier 0
4763525 2284573 2284573 defendant Doyt John husbandman 604163 604163 Doyt, John, of Ekyngton, husbandman 3
4820888 2302621 2302621 defendant Lynacre John yeoman 604163 604163 Lynacre, John, of Ekyngton, yeoman 0
4835698 2307161 2307161 plaintiff Smyth William   604163 604163 Smyth, William, of Ekyngton 1
4899447 2326468 2326468 defendant Shefeld Robert summoner 604163 604163 Shefeld, Robert, of Ekyngton, summoner 0
4954873 2343412 2343412 defendant Heleby Richard husbandman 604163 604163 Heleby, Richard, of Ekyngton, husbandman 0
4965014 2346453 2346453 defendant Smyth William gent 604163 604163 Smyth, William, of Ekyngton, gent 0
4968091 2347403 2347403 defendant Sykeston Robert   604163 604163 Sykeston, Robert, of Ekyngton, "sonyour" 0
4990872 2354161 2354161 defendant Smyth William   604163 604163 Smyth, William, of Ekyngton, franklin 0
5120478 2392417 2392417 defendant Hughes Lawrence yeoman 604163 604163 Hughes, Lawrence, of Ekyngton, yeoman 0
5131100 2395586 2395586 defendant Balsover John tanner 604163 604163 Balsover, John, of Ekyngton, tanner 0
5141386 2398601 2398601 defendant Haukyns Thomas clerk 604163 604163 Haukyns, Thomas, of Ekyngton, clerk 8
5141392 2398601 2398601 defendant Tonne Ralph husbandman 604163 604163 Tonne, Ralph, of ekyngton, husbandman 14
5150549 2401301 2401301 defendant Bolsover John tanner 604163 604163 Bolsover, John, of Ekyngton, tanner 0
5162543 2404770 2404770 defendant Haukyns Thomas clerk 604163 604163 Haukyns, Thomas, of Ekyngton, clerk 9
5162549 2404770 2404770 defendant Toune Ralph husbandman 604163 604163 Toune, Ralph, of Ekyngton, husbandman 15
5169051 2406681 2406681 defendant Bolsover John tanner 604163 604163 Bolsover, John, of Ekyngton, tanner 0
5174564 2408262 2408262 defendant Hewys Lawrence yeoman 604163 604163 Hewys, Lawrence, of Ekyngton, yeoman 0
5176534 2408824 2408824 defendant Haukyns Thomas clerk 604163 604163 Haukyns, Thomas, of Ekyngton, clerk 8
5176540 2408824 2408824 defendant Tonne Ralph husbandman 604163 604163 Tonne, Ralph, of Ekyngton, husbandman 14
5185501 2411509 2411509 defendant Bolsover John tanner 604163 604163 Bolsover, John, of Ekyngton, tanner 0
5243016 2428161 2428161 plaintiff Nelesthorp John   604163 604163 Nelesthorp, John, of Ekyngton 0
5243642 2428334 2428334 defendant Melton John butcher 604163 604163 Melton, John, of Ekyngton, butcher 0
5243643 2428334 2428334 defendant Elys William husbandman 604163 604163 Elys, William, of Ekyngton, husbandman 1
5244528 2428584 2428584 defendant Stafforth Henry sawyer 604163 604163 Stafforth, Henry, of Ekyngton, sawyer 0
5244529 2428584 2428584 defendant Lawe Henry sawyer 604163 604163 Lawe, Henry, of Ekyngton, sawyer 1
5244530 2428584 2428584 defendant Lawe Henry yeoman 604163 604163 Lawe, Henry, of Ekyngton, yeoman 2
5244531 2428584 2428584 defendant Pynder Hugh husbandman 604163 604163 Pynder, Hugh, of Ekyngton, husbandman 3
5244532 2428584 2428584 defendant Dodyngton Thomas smith 604163 604163 Dodyngton, Thomas, of Ekyngton, smith 4
5244533 2428584 2428584 defendant Selioke Christopher yeoman 604163 604163 Selioke, Christopher, of Ekyngton, yeoman 5
5244534 2428584 2428584 defendant Burye Jordan tailor 604163 604163 Burye, Jordan, of Ekyngton, tailor 6
5244535 2428584 2428584 defendant Burye John souter 604163 604163 Burye, John, of Ekyngton, souter 7
5244536 2428584 2428584 defendant Bollesover Ralph barker 604163 604163 Bollesover, Ralph, of Ekyngton, barker 8
5244537 2428584 2428584 defendant Grenesmyth Thomas webster 604163 604163 Grenesmyth, Thomas, of Ekyngton, webster 9
5244538 2428584 2428584 defendant Bollesour John   604163 604163 Bollesour, John, of Ekyngton, "ygilner" 10
5248751 2429757 2429757 defendant Bellesover John husbandman 604163 604163 Bellesover, John, of Ekyngton, husbandman 2
5248765 2429761 2429761 defendant Smyth Robert, senior husbandman 604163 604163 Smyth, Robert, senior, of Ekyngton, husbandman 6
5248766 2429761 2429761 defendant Smyth Robert, junior husbandman 604163 604163 Smyth, Robert, junior, of Ekyngton, husbandman 7
5248767 2429761 2429761 defendant Dodyngton John husbandman 604163 604163 Dodyngton, John, of Ekyngton, husbandman 8
5248768 2429761 2429761 defendant Stafforth Henry smith 604163 604163 Stafforth, Henry, of Ekyngton, smith 9
5265549 2434985 2434985 defendant Bollesover John husbandman 604163 604163 Bollesover, John, of Ekyngton, husbandman 2
5265565 2434987 2434987 defendant Smyth Robert, senior husbandman 604163 604163 Smyth, Robert, senior, of Ekyngton, husbandman 1
5265566 2434987 2434987 defendant Smyth Robert, junior husbandman 604163 604163 Smyth, Robert, junior, of Ekyngton, husbandman 2
5265567 2434987 2434987 defendant Dodyngton John husbandman 604163 604163 Dodyngton, John, of Ekyngton, husbandman 3
5265568 2434987 2434987 defendant Stafforth Henry smithman 604163 604163 Stafforth, Henry, of Ekyngton, smithman 4
5309495 2447878 2447878 defendant Smyth William yeoman 604163 604163 Smyth, William, of Ekyngton, yeoman 0
5335589 2455717 2455717 defendant Cade John, junior   604163 604163 Cade, John, junior, of Ekyngton, yeoman, son of Cade, John, senior 0

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