names

105 rows where place_id = 609498

✎ 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
3678674 1919394 1919394 defendant Adynbroke John yeoman 609498 609498 Adynbroke, John, of Rowley, yeoman 2
3688717 1922632 1922632 defendant Jenyns Roger chaplain 609498 609498 Jenyns, Roger, of Rowley, chaplain 0
3711259 1929825 1929825 plaintiff Saunder John   609498 609498 Saunder, John, of Rowley 1
3713379 1930499 1930499 plaintiff Addenbroke John nailer 609498 609498 Addenbroke, John, of Rowley, nailer 0
3740669 1938944 1938944 defendant Orme William yeoman 609498 609498 Orme, William, of Rowley, yeoman 0
3740670 1938944 1938944 defendant Hypkys John nailer 609498 609498 Hypkys, John, of Rowley, nailer 1
3740671 1938944 1938944 defendant Hypkys William laborer 609498 609498 Hypkys, William, of Rowley, laborer 2
3740672 1938944 1938944 defendant White John nailer 609498 609498 White, John, of Rowley, nailer 3
3748492 1941462 1941462 defendant Adynbroke John nailer 609498 609498 Adynbroke, John, of Rowley, nailer 0
3754154 1943247 1943247 defendant Hareson William laborer 609498 609498 Hareson, William, of Rowley, laborer 1
3756049 1943847 1943847 plaintiff Addenbroke John nailer 609498 609498 Addenbroke, John, of Rowley, nailer 0
3767508 1947473 1947473 defendant Russell John smith 609498 609498 Russell, John, of Rowley, smith 4
3771008 1948620 1948620 plaintiff Staunford Thomas gent 609498 609498 Staunford, Thomas, of Rowley, gent 0
3771011 1948621 1948621 plaintiff Staunford Thomas gent 609498 609498 Staunford, Thomas, of Rowley, gent 0
3785604 1953288 1953288 defendant Hungate Robert husbandman 609498 609498 Hungate, Robert, of Rowley, husbandman 2
3788687 1954263 1954263 plaintiff Staresmore William (legal representative) 609498 609498 Staresmore, William, of Rowley, gent, executor of 0
3788690 1954264 1954264 plaintiff Staresmore William (legal representative) 609498 609498 Staresmore, William, of Rowley, gent, executor of 0
3788693 1954265 1954265 plaintiff Staresmore William (legal representative) 609498 609498 Staresmore, William, of Rowley, gent, executor of 0
3809381 1960816 1960816 defendant Crawsha Robert husbandman 609498 609498 Crawsha, Robert, of Rowley, husbandman 0
3809399 1960822 1960822 defendant Crawfhay Robert husbandman 609498 609498 Crawfhay, Robert, of Rowley, husbandman 0
3812120 1961702 1961702 defendant Derby Thomas husbandman 609498 609498 Derby, Thomas, of Rowley, husbandman 0
3812121 1961702 1961702 defendant Derby John smith 609498 609498 Derby, John, of Rowley, smith 1
3818513 1963691 1963691 defendant Crawshay Robert yeoman 609498 609498 Crawshay, Robert, of Rowley, yeoman 0
3822426 1964912 1964912 plaintiff Staunford Thomas esq 609498 609498 Staunford, Thomas, of Rowley, esq 0
3853800 1974821 1974821 defendant Cattell Henry yeoman 609498 609498 Cattell, Henry, of Rowley, yeoman 0
3860620 1977045 1977045 defendant Stopford Richard nailer 609498 609498 Stopford, Richard, of Rowley, nailer 0
3860621 1977045 1977045 defendant Hawkys William nailer 609498 609498 Hawkys, William, of Rowley, nailer 1
3860623 1977045 1977045 defendant Derby Ralph nailer 609498 609498 Derby, Ralph, of Rowley, nailer 3
3863507 1977991 1977991 defendant Corne Hugh husbandman 609498 609498 Corne, Hugh, of Rowley, husbandman 0
3863508 1977991 1977991 defendant Corne John laborer 609498 609498 Corne, John, of Rowley, laborer 1
3863509 1977991 1977991 defendant Hempston Thomas husbandman 609498 609498 Hempston, Thomas, of Rowley, husbandman 2
3863510 1977991 1977991 defendant Donne William husbandman 609498 609498 Donne, William, of Rowley, husbandman 3
3891374 1987379 1987379 defendant Adenbroke John yeoman 609498 609498 Adenbroke, John, of Rowley, yeoman 4
3899504 1990049 1990049 plaintiff Staunford William esq 609498 609498 Staunford, William, of Rowley, esq 1
3909816 1993593 1993593 plaintiff Stannford William esq 609498 609498 Stannford, William, of Rowley, esq 0
3912650 1994565 1994565 defendant Tyrle John husbandman 609498 609498 Tyrle, John, of Rowley, husbandman 0
3912651 1994565 1994565 defendant Hawton Thomas laborer 609498 609498 Hawton, Thomas, of Rowley, laborer 1
3949857 2007027 2007027 defendant Staunford Edward gent 609498 609498 Staunford, Edward, of Rowley, gent 0
3955425 2008964 2008964 defendant Chamber alias Ireland John husbandman 609498 609498 Chamber alias Ireland, John, of Rowley, husbandman 1
3955436 2008967 2008967 defendant Chamber alias Ireland John husbandman 609498 609498 Chamber alias Ireland, John, of Rowley, husbandman 1
3968905 2013751 2013751 defendant Bodenham John yeoman 609498 609498 Bodenham, John, of Rowley, yeoman 2
3968922 2013753 2013753 defendant Bodenham John yeoman 609498 609498 Bodenham, John, of Rowley, yeoman 2
3969126 2013812 2013812 defendant Russell Thomas nailer 609498 609498 Russell, Thomas, of Rowley, nailer 1
3969127 2013812 2013812 defendant Marten William yeoman 609498 609498 Marten, William, of Rowley, yeoman 2
3970265 2014195 2014195 defendant Hopkys Lawrence driver 609498 609498 Hopkys, Lawrence, of Rowley, driver 0
3970266 2014195 2014195 defendant Jones alias Marton John nailer 609498 609498 Jones alias Marton, John, of Rowley, nailer 1
4002076 2025524 2025524 defendant Martyn William yeoman 609498 609498 Martyn, William, of Rowley, yeoman 0
4033034 2036464 2036464 defendant Eastwood John, senior yeoman or chapman 609498 609498 Eastwood, John, senior, of Rowley, yeoman or chapman 0
4041883 2039581 2039581 defendant Russhen Thomas yeoman or nailer 609498 609498 Russhen, Thomas, of Rowley, yeoman or nailer 0
4058142 2045293 2045293 defendant Bodnam William chapman 609498 609498 Bodnam, William, of Rowley, chapman 0
4058143 2045293 2045293 defendant Bodnam John yeoman 609498 609498 Bodnam, John, of Rowley, yeoman 1
4099921 2060299 2060299 defendant Horton William yeoman 609498 609498 Horton, William, of Rowley, yeoman 2
4117776 2066650 2066650 defendant Gest John nailer 609498 609498 Gest, John, of Rowley, nailer 0
4117777 2066650 2066650 defendant Hanson John smith 609498 609498 Hanson, John, of Rowley, smith 1
4131099 2071441 2071441 defendant Grove Philip smith 609498 609498 Grove, Philip, of Rowley, smith 0
4131102 2071442 2071442 defendant Grove Philip smith 609498 609498 Grove, Philip, of Rowley, smith 1
4144368 2076190 2076190 defendant Marten John nailer 609498 609498 Marten, John, of Rowley, nailer 0
4144369 2076190 2076190 defendant Parkes John nailer 609498 609498 Parkes, John, of Rowley, nailer 1
4144371 2076191 2076191 defendant Marten John nailer 609498 609498 Marten, John, of Rowley, nailer 0
4144372 2076191 2076191 defendant Parkes John nailer 609498 609498 Parkes, John, of Rowley, nailer 1
4152042 2078826 2078826 defendant Hodgett Nicholas nailer 609498 609498 Hodgett, Nicholas, of Rowley, nailer 1
4157523 2080706 2080706 defendant Wastwoode John yeoman 609498 609498 Wastwoode, John, of Rowley, yeoman 0
4160700 2081818 2081818 defendant Astley John nailer 609498 609498 Astley, John, of Rowley, nailer 1
4169280 2084759 2084759 defendant Colbarne Roger gent 609498 609498 Colbarne, Roger, of Rowley, or of Northfeld, Worcs, gent 0
4185393 2090403 2090403 defendant Grove Philip blacksmith 609498 609498 Grove, Philip, of Rowley, blacksmith 1
4194405 2093595 2093595 defendant Grove William yeoman 609498 609498 Grove, William, of Rowley, or of Wordsley, Kyng Swynford, yeoman 0
4204997 2097290 2097290 defendant Eastwood John husbandman 609498 609498 Eastwood, John, of Rowley, husbandman 2
4207645 2098232 2098232 defendant Meanlye William nailer 609498 609498 Meanlye, William, of Rowley, or of Oldbury, Salop, nailer 0
4248375 2112446 2112446 defendant Wood Walter   609498 609498 Wood, Walter, of Rowley, Staffs gent 0
4291972 2127205 2127205 defendant Chambers alias Ireland William nailer 609498 609498 Chambers alias Ireland, William, of Rowley, nailer 1
4291973 2127205 2127205 defendant Detheridge Francis nailer 609498 609498 Detheridge, Francis, of Rowley, nailer 2
4291974 2127205 2127205 defendant Harrys aias Harryson William nailer 609498 609498 together with Harrys aias Harryson, William, of Rowley, nailer 3
4299988 2130092 2130092 defendant Grove William yeoman 609498 609498 Grove, William, of Rowley, yeoman 0
4299991 2130093 2130093 defendant Grove William yeoman 609498 609498 Grove, William, of Rowley, yeoman 0
4306104 2132275 2132275 defendant Grove Philip   609498 609498 Grove, Philip, of Rowley, crossbow smith 0
4322756 2138027 2138027 defendant Chambers alias Ireland William nailer 609498 609498 Chambers alias Ireland, William, of Rowley, nailer 1
4333423 2141459 2141459 defendant Russell William yeoman 609498 609498 Russell, William, of Rowley, yeoman 0
4333424 2141459 2141459 defendant Ryder Thomas yeoman 609498 609498 Ryder, Thomas, of Rowley, yeoman 1
4334331 2141760 2141760 defendant Hadone Thomas nailer 609498 609498 Hadone, Thomas, of Rowley, nailer 1
4334332 2141760 2141760 defendant Russell John nailer 609498 609498 Russell, John, of Rowley, nailer 2
4334333 2141760 2141760 defendant White Lawrence nailer 609498 609498 White, Lawrence, of Rowley, nailer 3
4334334 2141760 2141760 defendant Whyte William nailer 609498 609498 Whyte, William, of Rowley, nailer 4
4334335 2141760 2141760 defendant Wynsere or Wynsore William nailer 609498 609498 Wynsere or Wynsore, William, of Rowley, nailer 5
4340740 2144036 2144036 defendant Grove William, senior yeoman 609498 609498 Grove, William, senior, of Rowley, yeoman 0
4340741 2144036 2144036 defendant Grove William, junior yeoman 609498 609498 Grove, William, junior, of Rowley, yeoman 1
4350151 2147311 2147311 defendant Greve William, junior yeoman 609498 609498 Greve, William, junior, of Rowley, yeoman 0
4350152 2147311 2147311 defendant Grove Philip   609498 609498 Grove, Philip, of Rowley, crossbow smith 1
4357112 2149714 2149714 defendant Grove William, senior yeoman 609498 609498 Grove, William, senior, of Rowley, yeoman 0
4357117 2149715 2149715 defendant Hadon Richard yeoman 609498 609498 Hadon, Richard, of Rowley, yeoman 2
4357118 2149716 2149716 plaintiff Willett Robert (legal representative) 609498 609498 Willett, Robert, of Rowley, nailer, executrix of 0
4357120 2149716 2149716 defendant Grove William, senior yeoman 609498 609498 Grove, William, senior, of Rowley, yeoman 0
4357121 2149716 2149716 defendant Grove William, junior yeoman 609498 609498 Grove, William, junior, of Rowley, yeoman 1
4391006 2161611 2161611 defendant Grove William, senior yeoman 609498 609498 Grove, William, senior, of Rowley, yeoman 0
4391007 2161611 2161611 defendant Grove Philip yeoman 609498 609498 Grove, Philip, of Rowley, yeoman 1
4391008 2161611 2161611 defendant Grove William yeoman 609498 609498 Grove, William, of Rowley, yeoman 2
4409871 2167904 2167904 defendant White Humphrey nailer 609498 609498 White, Humphrey, of Rowley, nailer 2
4411836 2168551 2168551 defendant Hadon Richard husbandman 609498 609498 Hadon, Richard, of Rowley, husbandman 2
4411839 2168552 2168552 defendant Grove William, senior yeoman 609498 609498 Grove, William, senior, of Rowley, yeoman 0
4411840 2168553 2168553 plaintiff Willett Robert (legal representative) 609498 609498 Willett, Robert, of Rowley, nailer, executrix of 0
4411842 2168553 2168553 defendant Grove William, senior yeoman 609498 609498 Grove, William, senior, of Rowley, yeoman 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);