names

124 rows where place_id = 588089

✎ 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
3593333 1865547 1865547 defendant Hall John chaplain 588089 588089 Hall, John, of Bakewell, chaplain 1
3632538 1904993 1904993 defendant Dale John laborer 588089 588089 Dale, John, of Bakewell, laborer 4
3638213 1906771 1906771 defendant Say Henry smith 588089 588089 Say, Henry, of Bakewell, smith 0
3638215 1906772 1906772 defendant Sey Henry smith 588089 588089 Sey, Henry, of Bakewell, smith 0
3652580 1911141 1911141 defendant Rodney John   588089 588089 Rodney, John, of Bakewell, knight 0
3658470 1912901 1912901 defendant Sey Richard smith 588089 588089 Sey, Richard, of Bakewell, smith 0
3658471 1912901 1912901 defendant Bowne Richard husbandman 588089 588089 Bowne, Richard, of Bakewell, husbandman 1
3691732 1923574 1923574 defendant Dykken William laborer 588089 588089 Dykken, William, of Bakewell, laborer 3
3728049 1935033 1935033 defendant Eyre Martin yeoman 588089 588089 Eyre, Martin, of Bakewell, yeoman 0
3728050 1935033 1935033 defendant Eyre John yeoman 588089 588089 Eyre, John, of Bakewell, yeoman 1
3728051 1935033 1935033 defendant Eyre Richard yeoman 588089 588089 Eyre, Richard, of Bakewell, yeoman 2
3728052 1935033 1935033 defendant Burton John laborer 588089 588089 Burton, John, of Bakewell, laborer 3
3728053 1935033 1935033 defendant Broxoppe Thomas laborer 588089 588089 Broxoppe, Thomas, of Bakewell, laborer 4
3729299 1935416 1935416 defendant Ulsyngctofte Robert yeoman 588089 588089 Ulsyngctofte, Robert, of Bakewell, yeoman 0
3734256 1936954 1936954 defendant Deyne Ralph husbandman 588089 588089 Deyne, Ralph, of Bakewell, husbandman 0
3743527 1939851 1939851 defendant Drabull Christopher husbandman 588089 588089 Drabull, Christopher, of Bakewell, husbandman 3
3745147 1940388 1940388 defendant Marple Richard husbandman 588089 588089 Marple, Richard, of Bakewell, husbandman 3
3745148 1940388 1940388 defendant Herryson Thomas husbandman 588089 588089 Herryson, Thomas, of Bakewell, husbandman 4
3761768 1945691 1945691 defendant Deyne Ralph husbandman 588089 588089 Deyne, Ralph, of Bakewell, husbandman 0
3778767 1951074 1951074 defendant Halle John husbandman 588089 588089 Halle, John, of Bakewell, husbandman 2
3780761 1951719 1951719 defendant Game Thomas husbandman 588089 588089 Game, Thomas, of Bakewell, husbandman 0
3780762 1951719 1951719 defendant Nayler Thomas husbandman 588089 588089 Nayler, Thomas, of Bakewell, husbandman 1
3793912 1955963 1955963 defendant Whitton John gent 588089 588089 Whitton, John, of Bakewell, gent 0
3811653 1961544 1961544 defendant More John yeoman 588089 588089 More, John, of Bakewell, yeoman 0
3811654 1961544 1961544 defendant Stapurchild Philip husbandman 588089 588089 Stapurchild, Philip, of Bakewell, husbandman 1
3811655 1961544 1961544 defendant Game Thomas husbandman 588089 588089 Game, Thomas, of Bakewell, husbandman 2
3811656 1961544 1961544 defendant Pasey William husbandman 588089 588089 Pasey, William, of Bakewell, husbandman 3
3811657 1961544 1961544 defendant Wilmot Roger husbandman 588089 588089 Wilmot, Roger, of Bakewell, husbandman 4
3811658 1961544 1961544 defendant Browne John husbandman 588089 588089 Browne, John, of Bakewell, husbandman 5
3811659 1961544 1961544 defendant Coke Richard husbandman 588089 588089 Coke, Richard, of Bakewell, husbandman 6
3811660 1961544 1961544 defendant Coke John husbandman 588089 588089 Coke, John, of Bakewell, husbandman 7
3811661 1961544 1961544 defendant Bassett John husbandman 588089 588089 Bassett, John, of Bakewell, husbandman 8
3842062 1971071 1971071 defendant Gawdy John husbandman 588089 588089 Gawdy, John, of Bakewell, husbandman 0
3895856 1988822 1988822 defendant Deyne William yeoman 588089 588089 Deyne, William, of Bakewell, yeoman 0
3909212 1993376 1993376 defendant Ferne George yeoman 588089 588089 Ferne, George, of Bakewell, yeoman 0
3909214 1993376 1993376 defendant of Fowke William laborer 588089 588089 of Fowke, William, of Bakewell, laborer 2
4027581 2034512 2034512 plaintiff Clayton Ralph clerk 588089 588089 Clayton, Ralph, of Bakewell, clerk 0
4027583 2034513 2034513 plaintiff Clayton Ralph clerk 588089 588089 Clayton, Ralph, of Bakewell, clerk 0
4032602 2036309 2036309 defendant Wryght Thomas husbandman 588089 588089 Wryght, Thomas, of Bakewell, husbandman 1
4032603 2036309 2036309 defendant Bromall Peter husbandman 588089 588089 Bromall, Peter, of Bakewell, husbandman 2
4148399 2077570 2077570 defendant Robothom John shoemaker 588089 588089 Robothom, John, of Bakewell, shoemaker 1
4168885 2084608 2084608 defendant Cleaton Ralph clerk 588089 588089 Cleaton, Ralph, of Bakewell, clerk 2
4170416 2085146 2085146 defendant Mye William butcher 588089 588089 Mye, William, of Bakewell, butcher 0
4170417 2085146 2085146 defendant Northe Arthur laborer 588089 588089 Northe, Arthur, of Bakewell, laborer 1
4189159 2091701 2091701 defendant Wolstenholme Thomas laborer 588089 588089 Wolstenholme, Thomas, of Bakewell, laborer 0
4189160 2091701 2091701 defendant Mylnes Richard laborer 588089 588089 Mylnes, Richard, of Bakewell, laborer 1
4214129 2100459 2100459 defendant Bretner Thomas yeoman 588089 588089 Bretner Thomas, of Bakewell, yeoman 1
4215282 2100840 2100840 defendant Lytton William, junior yeoman 588089 588089 Lytton, William, junior, of Bakewell, yeoman 0
4215433 2100892 2100892 defendant White Edward shoemaker 588089 588089 White, Edward, of Bakewell, shoemaker 2
4215936 2101069 2101069 defendant Lyndopp Philip yeoman 588089 588089 Lyndopp, Philip, of Bakewell, yeoman 3
4215941 2101070 2101070 defendant Lyndopp Philip yeoman 588089 588089 Lyndopp, Philip, of Bakewell, yeoman 3
4216119 2101128 2101128 defendant Waddington alias Foliambe Robert miner 588089 588089 Waddington alias Foliambe, Robert, of Bakewell, or of Magna Longsdon, miner 0
4216123 2101129 2101129 defendant Mornsall William yeoman 588089 588089 Mornsall, William, of Bakewell, yeoman 2
4216124 2101129 2101129 defendant Fynnye Robert miner 588089 588089 Fynnye, Robert, of Bakewell, miner 3
4217350 2101563 2101563 defendant Kertchiver John gent 588089 588089 Kertchiver, John, of Bakewell, or of Orston, Notts, gent 0
4222010 2103190 2103190 defendant Nedeham Edward yeoman 588089 588089 Nedeham, Edward, of Bakewell, yeoman 1
4222014 2103191 2103191 defendant Nedeham Edward yeoman 588089 588089 Nedeham, Edward, of Bakewell, yeoman 1
4224703 2104113 2104113 defendant William junior yeoman 588089 588089 William, junior, of Bakewell, yeoman 0
4224844 2104156 2104156 defendant Hodgekinson William miner 588089 588089 Hodgekinson, William, of Bakewell, miner 0
4274386 2120986 2120986 defendant Notton Arthur husbandman 588089 588089 Notton, Arthur, of Bakewell, husbandman 1
4292819 2127496 2127496 defendant North Ralph miner 588089 588089 North, Ralph, of Bakewell, miner 0
4292820 2127496 2127496 defendant Besidye James miner 588089 588089 Besidye, James, of Bakewell, miner 1
4292821 2127496 2127496 defendant Harison Elias miner 588089 588089 Harison, Elias, of Bakewell, miner 2
4293264 2127653 2127653 defendant Clayton Ralph clerk 588089 588089 Clayton, Ralph, of Bakewell, clerk 0
4293265 2127653 2127653 defendant Wolsencrafte Stephen husbandman 588089 588089 Wolsencrafte, Stephen, of Bakewell, husbandman 1
4297130 2129074 2129074 defendant More John husbandman 588089 588089 More, John, of Bakewell, husbandman 1
4297405 2129176 2129176 defendant Raworth James yeoman 588089 588089 Raworth, James, of Bakewell, yeoman 0
4298909 2129706 2129706 defendant Drable Mathew husbandman 588089 588089 Drable, Mathew, of Bakewell, husbandman 1
4298910 2129706 2129706 defendant Webster John laborer 588089 588089 Webster, John, of Bakewell, laborer 2
4299694 2129980 2129980 defendant Newton Arthur husbandman 588089 588089 Newton, Arthur, of Bakewell, husbandman 0
4299695 2129980 2129980 defendant Drabell or Drable Mathew husbandman 588089 588089 Drabell or Drable, Mathew, of Bakewell, husbandman 1
4360774 2151024 2151024 defendant Woodhall William victualer 588089 588089 Woodhall, William, of Bakewell, husbandman, victualer 3
4377522 2157036 2157036 defendant Sydall Humphrey tailor 588089 588089 Sydall, Humphrey, of Bakewell, tailor 2
4377541 2157044 2157044 defendant Sydall Humphrey tailor 588089 588089 Sydall, Humphrey, of Bakewell, tailor 2
4378422 2157356 2157356 defendant Mylners Richard yeoman 588089 588089 Mylners, Richard, of Bakewell, yeoman 1
4378423 2157356 2157356 defendant Hollam Edward miner 588089 588089 Hollam, Edward, of Bakewell, yeoman, miner 2
4385242 2159753 2159753 defendant Hibberd Geoffrey carpenter 588089 588089 Hibberd, Geoffrey, of Bakewell, carpenter 3
4385495 2159836 2159836 defendant Higgenbotham Stephen miner 588089 588089 Higgenbotham, Stephen, of Bakewell, miner 0
4385497 2159836 2159836 defendant Frythe John miner 588089 588089 Frythe, John, of Bakewell, miner 2
4406492 2166734 2166734 defendant Lyndop Philip husbandman 588089 588089 Lyndop, Philip, of Bakewell, husbandman 0
4407135 2166950 2166950 defendant Bretnore Thomas yeoman 588089 588089 Bretnore, Thomas, of Bakewell, yeoman 0
4407142 2166952 2166952 defendant Gilbert William gent 588089 588089 Gilbert, William, of Bakewell, gent 0
4407143 2166952 2166952 defendant Johnson Thomas blacksmith 588089 588089 Johnson, Thomas, of Bakewell, blacksmith 1
4407144 2166952 2166952 defendant Sheldon Leonard husbandman 588089 588089 Sheldon, Leonard, of Bakewell, husbandman 2
4407146 2166953 2166953 defendant Blounte John husbandman 588089 588089 Blounte, John, of Bakewell, husbandman 0
4407151 2166954 2166954 defendant Johnson George husbandman 588089 588089 Johnson, George, of Bakewell, husbandman 0
4407152 2166954 2166954 defendant Haighe Thomas husbandman 588089 588089 Haighe, Thomas, of Bakewell, husbandman 1
4408236 2167325 2167325 defendant Lyndopp Philip husbandman 588089 588089 Lyndopp, Philip, of Bakewell, husbandman 0
4408237 2167325 2167325 defendant Woddall William miner 588089 588089 Woddall, William, of Bakewell, husbandman, miner 1
4408238 2167325 2167325 defendant Foliamb Hugh husbandman 588089 588089 Foliamb, Hugh, of Bakewell, or of Stanton, husbandman 2
4408239 2167325 2167325 defendant Morewodde William yeoman 588089 588089 Morewodde, William, of Bakewell, or of Great Longesdon, yeoman 3
4408273 2167337 2167337 defendant Nawton Arthur husbandman 588089 588089 Nawton, Arthur, of Bakewell, husbandman 0
4408274 2167337 2167337 defendant Drable Mathew husbandman 588089 588089 Drable, Mathew, of Bakewell, husbandman 1
4408275 2167337 2167337 defendant Bisidut James husbandman 588089 588089 Bisidut, James, of Bakewell, husbandman 2
4409539 2167786 2167786 defendant Shakerley Thomas gent 588089 588089 Shakerley, Thomas, of Bakewell, gent 0
4490244 2197649 2197649 defendant Penyston John   588089 588089 Penyston, John, of Bakewell 0
4505834 2202329 2202329 defendant Milner John mercer 588089 588089 Milner, John, of Bakewell, mercer 3
4590553 2228403 2228403 defendant Shawe John   588089 588089 Shawe, John, of Bakewell 0
4604532 2232583 2232583 defendant Furbur William   588089 588089 Furbur, William, of Bakewell 4
4605431 2232838 2232838 defendant Smythesson Richard   588089 588089 Smythesson, Richard, of Bakewell 24

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