names

220 rows where place_id = 593153

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590370 1864627 1864627 defendant Perpoynt Roger   593153 593153 Perpoynt, Roger, of Middelton, shepherd, 2
3595553 1866245 1866245 defendant Haukyn or Hankyn John   593153 593153 Haukyn or Hankyn, John, of Middelton, shepherd 0
3610717 1871016 1871016 defendant Shakerley Charles gent 593153 593153 Shakerley, Charles, of Middelton, gent 0
3663813 1914617 1914617 defendant Hayman Ralph yeoman 593153 593153 Hayman, Ralph, of Middelton, yeoman 0
3675500 1918375 1918375 plaintiff Haryson Thomas   593153 593153 Haryson, Thomas, of Middelton 7
3678179 1919225 1919225 defendant Dew Robert fuller 593153 593153 Dew, Robert, of Middelton, fuller 0
3682079 1920504 1920504 defendant Buttys Elizabeth gent 593153 593153 Buttys, Elizabeth, of Middelton, widow of Butte, John, of Middelton, gent 0
3694707 1924549 1924549 defendant Wylford Hugh gent 593153 593153 Wylford, Hugh, of Middelton, gent 0
3700946 1926543 1926543 defendant Hayman Ralph yeoman 593153 593153 Hayman, Ralph, of Middelton, yeoman 0
3704155 1927596 1927596 defendant Buttys Elizabeth widow 593153 593153 Buttys, Elizabeth, of Middelton, widow 0
3704546 1927717 1927717 defendant Butt Elizabeth gent 593153 593153 Butt, Elizabeth, of Middelton, widow of Buttys, John, gent 0
3713542 1930547 1930547 defendant Figge William tanner 593153 593153 Figge, William, of Middelton, tanner 0
3718579 1932087 1932087 defendant Bintys Elizabeth widow 593153 593153 Bintys, Elizabeth, of Middelton, widow 0
3718863 1932177 1932177 defendant Goddyn Lewis   593153 593153 Goddyn, Lewis, of Middelton, administrators of 0
3721044 1932878 1932878 defendant Candland Richard yeoman 593153 593153 Candland, Richard, of Middelton Prior, yeoman 0
3721045 1932878 1932878 defendant Page John yeoman 593153 593153 Page, John, of Middelton Prior, yeoman 1
3775128 1949953 1949953 defendant Barrowe James chaplain 593153 593153 Barrowe, James, of Middelton, chaplain 0
3777472 1950705 1950705 defendant Haselom William miner 593153 593153 Haselom, William, of Middelton, miner 2
3778415 1950964 1950964 defendant Fynche Henry (legal representative) 593153 593153 Fynche, Henry, of Middelton, administratrix of 0
3785320 1953196 1953196 defendant Myddylton Geoffrey esq 593153 593153 Myddylton, Geoffrey, of Middelton Hall, Werstmor, esq 0
3814400 1962419 1962419 defendant Buttys Elizabeth widow 593153 593153 Buttys, Elizabeth, of Middelton, widow 0
3820920 1964438 1964438 defendant Pynnowe John husbandman 593153 593153 Pynnowe, John, of Middelton, husbandman 3
3820921 1964438 1964438 defendant Taylour William husbandman 593153 593153 Taylour, William, of Middelton, husbandman 4
3827064 1966322 1966322 defendant Benson alias Curtes William   593153 593153 Benson alias Curtes, William, of Middelton, shepherd 0
3845644 1972181 1972181 defendant Lytefote Thomas husbandman 593153 593153 Lytefote, Thomas, of Middelton, husbandman 0
3867543 1979381 1979381 defendant Corser John butcher 593153 593153 Corser, John, of Middelton, butcher 1
3917403 1996179 1996179 plaintiff Greybroke Robert   593153 593153 Greybroke, Robert, of Middelton 0
3924743 1998592 1998592 defendant Bartlett Hugh yeoman 593153 593153 Bartlett, Hugh, of Middelton, yeoman 0
3925631 1998883 1998883 defendant Carpynter Thomas yeoman 593153 593153 Carpynter, Thomas, of Middelton, yeoman 0
3938787 2003312 2003312 defendant Atkynson James husbandman 593153 593153 Atkynson, James, of Middelton, husbandman 0
3938789 2003312 2003312 defendant Herber George husbandman 593153 593153 Herber, George, of Middelton, husbandman 2
3938790 2003312 2003312 defendant Buskell Richard husbandman 593153 593153 Buskell, Richard, of Middelton, husbandman 3
3938791 2003312 2003312 defendant Warde George husbandman 593153 593153 Warde, George, of Middelton, husbandman 4
3955718 2009073 2009073 defendant More John husbandman 593153 593153 More, John, of Middelton, husbandman 0
3959055 2010249 2010249 defendant Nowell John husbandman 593153 593153 Nowell, John, of Middelton, husbandman 0
3963399 2011802 2011802 plaintiff Wyngfeld John gent 593153 593153 Wyngfeld, John, of Middelton, gent 0
3964931 2012342 2012342 plaintiff Baker Robert yeoman 593153 593153 Baker, Robert, of Middelton, yeoman 0
3965309 2012483 2012483 plaintiff Bartlett Hugh yeoman 593153 593153 Bartlett, Hugh, of Middelton, yeoman 0
4014617 2029949 2029949 defendant Bartlett Hugh gent 593153 593153 Bartlett, Hugh, of Middelton, gent 0
4145089 2076443 2076443 defendant Bartlett Thomas yeoman 593153 593153 Bartlett, Thomas, of Middelton, yeoman 1
4158057 2080888 2080888 defendant Bartlett Thomas gent 593153 593153 Bartlett, Thomas, of Middelton, gent 0
4413993 2169279 2169279 defendant Thomkyns John   593153 593153 Thomkyns, John, of Middelton 0
4413997 2169280 2169280 defendant Drayton Roger de   593153 593153 Drayton, Roger de, of Middelton 0
4415755 2169814 2169814 defendant atte Mulle William   593153 593153 atte Mulle, William, of Middelton 0
4416858 2170143 2170143 plaintiff Persones Roger le   593153 593153 Persones, Roger le, of Middelton 0
4416921 2170163 2170163 plaintiff Podle John   593153 593153 Podle, John, of Middelton 0
4417206 2170259 2170259 defendant Barde John   593153 593153 Barde, John, of Middelton, son of Thomas 1
4422917 2172023 2172023 plaintiff Forester Roger   593153 593153 Forester, Roger, of Middelton 0
4424432 2172480 2172480 defendant atte Mulle William   593153 593153 atte Mulle, William, of Middelton 0
4428534 2173736 2173736 defendant Colfol William   593153 593153 Colfol, William, of Middelton 0
4431145 2174501 2174501 plaintiff Begelot Thomas   593153 593153 Begelot, Thomas, of Middelton 0
4431632 2174661 2174661 plaintiff Warde Thomas   593153 593153 with Warde, Thomas, of Middelton 1
4435673 2175910 2175910 defendant Gyles John   593153 593153 Gyles, John, of Middelton 1
4435679 2175910 2175910 defendant Deghere Richard   593153 593153 Deghere, Richard, of Middelton 7
4435693 2175911 2175911 defendant Gyles John   593153 593153 Gyles, John, of Middelton 1
4435699 2175911 2175911 defendant Deghere Richard   593153 593153 Deghere, Richard, of Middelton 7
4447683 2184196 2184196 defendant Cave John de   593153 593153 Cave, John de, of Middelton 0
4455357 2186683 2186683 defendant Rotom John   593153 593153 Rotom, John, of Middelton 0
4458380 2187662 2187662 plaintiff Rage John   593153 593153 Rage, John, of Middelton 0
4464333 2189512 2189512 plaintiff Warde Richard   593153 593153 Warde, Richard, of Middelton, on his own account 0
4464334 2189512 2189512 defendant Lambard William   593153 593153 Lambard, William, of Middelton Over 0
4481505 2194910 2194910 defendant Walter Roger   593153 593153 Walter, Roger, of Middelton 0
4481507 2194911 2194911 defendant Walter Roger   593153 593153 Walter, Roger, of Middelton 0
4490618 2197761 2197761 plaintiff Warde Richard de   593153 593153 Warde, Richard de, of Middelton 0
4509207 2203357 2203357 defendant Corbrugge William   593153 593153 Corbrugge, William, of Middelton 0
4510582 2203771 2203771 defendant Newentone John   593153 593153 Newentone, John, of Middelton 0
4515253 2205186 2205186 defendant Stuart Richard   593153 593153 Stuart, Richard, of Middelton 0
4528764 2209281 2209281 defendant Chapman William   593153 593153 Chapman, William, of Middelton, bailiff of the liberty & hundred 0
4534181 2210954 2210954 defendant Kyllyngworth William   593153 593153 Kyllyngworth, William, of Middelton 0
4540408 2212898 2212898 defendant Rage John   593153 593153 Rage, John, of Middelton 0
4540410 2212899 2212899 defendant Rage John   593153 593153 Rage, John, of Middelton 0
4552255 2216661 2216661 defendant Norman William   593153 593153 Norman, William, of Middelton 0
4552256 2216661 2216661 defendant Kyng Henry   593153 593153 Kyng, Henry, of Middelton 1
4552257 2216661 2216661 defendant Jacob Stephen   593153 593153 Jacob, Stephen, of Middelton 2
4552258 2216661 2216661 defendant Parrok Robert   593153 593153 Parrok, Robert, of Middelton 3
4554988 2217488 2217488 defendant Humfray Mathew   593153 593153 Humfray, Mathew, of Middelton 0
4560306 2219162 2219162 defendant Marton William   593153 593153 Marton, William, of Middelton 32
4561447 2219515 2219515 defendant Marton William   593153 593153 Marton, William, of Middelton 45
4563579 2220174 2220174 defendant Meed John   593153 593153 Meed, John, of Middelton 0
4578602 2224795 2224795 defendant Ventrer John   593153 593153 Ventrer, John, of Middelton 3
4582852 2226070 2226070 defendant Coupland John   593153 593153 Coupland, John, of Middelton 1
4612526 2234986 2234986 defendant Cros Robert   593153 593153 Cros, Robert, of Middelton 1
4612896 2235096 2235096 defendant Bery Richard   593153 593153 Bery, Richard, of Middelton 2
4632030 2240900 2240900 defendant Proute Edward   593153 593153 Proute, Edward, of Middelton, mill ward 0
4633888 2241448 2241448 defendant Henryson William   593153 593153 Henryson, William, of Middelton 0
4637005 2242378 2242378 defendant Car John   593153 593153 Car, John, of Middelton 0
4648248 2245549 2245549 defendant Bagger Richard   593153 593153 Bagger, Richard, of Middelton 6
4651184 2246375 2246375 defendant Smyth John yeoman 593153 593153 Smyth, John, of Middelton, yeoman 1
4656762 2248008 2248008 defendant Duk William chaplain 593153 593153 Duk, William, of Middelton, chaplain 0
4662545 2249754 2249754 defendant Sartry John dredger 593153 593153 Sartry, John, of Middelton, dredger 3
4667079 2255436 2255436 plaintiff Archer John   593153 593153 Archer, John, of Middelton 0
4676490 2258260 2258260 defendant More Marmaduke de gent 593153 593153 More, Marmaduke de, of Middelton, gent 0
4681039 2259695 2259695 defendant atte Mille John gent 593153 593153 atte Mille, John, of Middelton, gent 1
4684434 2260734 2260734 defendant Gryme William reaper 593153 593153 Gryme, William, of Middelton, reaper 0
4694795 2263865 2263865 defendant Baillif Robert   593153 593153 Baillif, Robert, of Middelton, bailiff 0
4694796 2263865 2263865 defendant Baillif Thomas   593153 593153 Baillif, Thomas, of Middelton, husbandman, son of Philip 1
4701972 2266025 2266025 defendant Roleghe William skinner 593153 593153 Roleghe, William, of Middelton, skinner 1
4704475 2266775 2266775 defendant Tank Richard clerk 593153 593153 Tank, Richard, of Middelton, clerk 0
4715544 2270191 2270191 defendant Fisher (illegible) husbandman 593153 593153 Fisher, _, of Middelton, husbandman 3
4717752 2270891 2270891 defendant Kybworth John tiler 593153 593153 Kybworth, John, of Middelton, tiler 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);