names

155 rows where place_id = 591850

✎ 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
3605782 1869475 1869475 defendant Dalman Hugh yeoman 591850 591850 Dalman, Hugh, of Bradley, yeoman 0
3613797 1871971 1871971 defendant Calvart John laborer 591850 591850 Calvart, John, of Bradley, laborer 1
3614409 1872157 1872157 defendant Postell John clerk 591850 591850 Postell, John, of Bradley, clerk 0
3614422 1872160 1872160 defendant Laycok John husbandman 591850 591850 Laycok, John, of Bradley, husbandman 3
3616795 1872882 1872882 defendant Joynour John yeoman 591850 591850 Joynour, John, of Bradley, yeoman 1
3616796 1872882 1872882 defendant Joynour Robert yeoman 591850 591850 Joynour, Robert, of Bradley, yeoman 2
3629069 1903969 1903969 defendant Cooke Edmund husbandman 591850 591850 Cooke, Edmund, of Bradley, husbandman 3
3634836 1905695 1905695 defendant Wytton Ralph yeoman 591850 591850 Wytton, Ralph, of Bradley, yeoman 2
3635250 1905814 1905814 defendant Tonmer or Toumer John yeoman 591850 591850 Tonmer or Toumer, John, of Bradley, yeoman 0
3690756 1923273 1923273 defendant Jenour Robert husbandman 591850 591850 Jenour, Robert, of Bradley, husbandman 1
3690759 1923274 1923274 defendant Jenour Robert husbandman 591850 591850 Jenour, Robert, of Bradley, husbandman 1
3696235 1925043 1925043 defendant Riders Richard (legal representative) 591850 591850 Riders, Richard, of Bradley, yeoman, executors of 0
3697908 1925568 1925568 defendant Knyveton Richard esq 591850 591850 Knyveton, Richard, of Bradley, esq 0
3697909 1925568 1925568 defendant Asshton Robert yeoman 591850 591850 Asshton, Robert, of Bradley, yeoman 1
3697910 1925568 1925568 defendant Thacher William yeoman 591850 591850 Thacher, William, of Bradley, yeoman 2
3697912 1925569 1925569 defendant Knyveton Richard esq 591850 591850 Knyveton, Richard, of Bradley, esq 0
3697913 1925569 1925569 defendant Asshton Robert yeoman 591850 591850 Asshton, Robert, of Bradley, yeoman 1
3697914 1925569 1925569 defendant Thacher William yeoman 591850 591850 Thacher, William, of Bradley, yeoman 2
3708306 1928891 1928891 defendant Pilkyngton Arthur esq 591850 591850 Pilkyngton, Arthur, of Bradley, esq 0
3708310 1928893 1928893 defendant Pylkyngton Arthur esq 591850 591850 Pylkyngton, Arthur, of Bradley, esq 0
3731894 1936206 1936206 defendant Turnour John husbandman 591850 591850 Turnour, John, of Bradley, husbandman 1
3732957 1936530 1936530 defendant Bugden John tucker 591850 591850 Bugden, John, of Bradley, tucker 2
3740574 1938909 1938909 defendant Lome John husbandman 591850 591850 Lome, John, of Bradley, husbandman 0
3747893 1941264 1941264 defendant Flemyng William husbandman 591850 591850 Flemyng, William, of Bradley, husbandman 4
3767956 1947614 1947614 defendant Beresford John gent 591850 591850 Beresford, John, of Bradley, gent 0
3782320 1952224 1952224 defendant Flemyng William husbandman 591850 591850 Flemyng, William, of Bradley, husbandman 0
3793073 1955692 1955692 defendant Dallowe Humphrey husbandman 591850 591850 Dallowe, Humphrey, of Bradley, husbandman 0
3793076 1955693 1955693 defendant Dallowe Humphrey husbandman 591850 591850 Dallowe, Humphrey, of Bradley, husbandman 0
3831964 1967895 1967895 defendant Hoo Richard yeoman 591850 591850 Hoo, Richard, of Bradley, yeoman 1
3864657 1978378 1978378 defendant Brygges William husbandman 591850 591850 Brygges, William, of Bradley, husbandman 0
3887691 1986136 1986136 defendant Ryppleley John husbandman 591850 591850 Ryppleley, John, of Bradley, husbandman 0
3895708 1988771 1988771 defendant Pynke Peter husbandman 591850 591850 Pynke, Peter, of Bradley, husbandman 0
3909961 1993638 1993638 defendant Pynke Peter husbandman 591850 591850 Pynke, Peter, of Bradley, husbandman 0
3920722 1997277 1997277 defendant Harcott William husbandman 591850 591850 Harcott, William, of Bradley, husbandman 4
3948858 2006666 2006666 defendant Ellys Agnes widow 591850 591850 Ellys, Agnes, of Bradley, widow 0
3976644 2016407 2016407 defendant Pegge Edward yeoman 591850 591850 Pegge, Edward, of Bradley, yeoman 0
3976645 2016407 2016407 defendant Johnson Elizabeth widow 591850 591850 Johnson, Elizabeth, of Bradley, widow 1
3984124 2019087 2019087 plaintiff Sture Philip esq 591850 591850 Sture, Philip, of Bradley, esq 0
4000441 2024926 2024926 defendant Browne Hugh husbandman 591850 591850 Browne, Hugh, of Bradley, or of Staynton, husbandman 0
4084464 2054719 2054719 defendant Doughtie Richard gent 591850 591850 Doughtie, Richard, of Bradley, gent 0
4124076 2068910 2068910 defendant Hodges James tailor 591850 591850 Hodges, James, of Bradley, tailor 2
4147812 2077376 2077376 defendant Ellys Thomas husbandman 591850 591850 Ellys, Thomas, of Bradley, husbandman 0
4147813 2077376 2077376 defendant Ellys Agnes widow 591850 591850 Ellys, Agnes, of Bradley, widow 1
4157032 2080539 2080539 defendant Wright James gent 591850 591850 Wright, James, of Bradley, gent 0
4157033 2080539 2080539 defendant Atkyn John laborer 591850 591850 Atkyn, John, of Bradley, laborer 1
4157034 2080539 2080539 defendant Claperson Richard laborer 591850 591850 Claperson, Richard, of Bradley, laborer 2
4157035 2080539 2080539 defendant Davyd Clement laborer 591850 591850 Davyd, Clement, of Bradley, laborer 3
4185076 2090285 2090285 defendant Johnson Isabel widow 591850 591850 Johnson, Isabel, of Bradley, widow 3
4195998 2094154 2094154 defendant Ellys Thomas husbandman 591850 591850 Ellys, Thomas, of Bradley, husbandman 0
4195999 2094154 2094154 defendant Ellys Agnes widow 591850 591850 Ellys, Agnes, of Bradley, widow 1
4202653 2096472 2096472 defendant Jobson John   591850 591850 Jobson, John, of Bradley, coal burner 0
4204403 2097088 2097088 defendant Wryght James gent 591850 591850 Wryght, James, of Bradley, gent 0
4204405 2097088 2097088 defendant Clapson or Claperson Richard laborer 591850 591850 Clapson or Claperson, Richard, of Bradley, laborer 2
4204406 2097088 2097088 defendant Davys Clement laborer 591850 591850 Davys, Clement, of Bradley, laborer 3
4214235 2100497 2100497 defendant Nurse Robert yeoman 591850 591850 Nurse, Robert, of Bradley, yeoman 0
4233094 2107082 2107082 defendant Cartwrighte alias Carteryte Robert yeoman 591850 591850 Cartwrighte alias Carteryte, Robert, of Bradley, yeoman 0
4239452 2109421 2109421 defendant Lusky Francis husbandman 591850 591850 Lusky, Francis, of Bradley, husbandman 1
4240454 2109786 2109786 defendant Macklesfeild or Maxfeild Humphrey gent 591850 591850 Macklesfeild or Maxfeild, Humphrey, of Bradley, gent 0
4241704 2110212 2110212 defendant Cartwrighte Robert yeoman 591850 591850 Cartwrighte, Robert, of Bradley, yeoman 0
4272341 2120322 2120322 defendant Wright James gent 591850 591850 Wright, James, of Bradley, gent 2
4277724 2122133 2122133 defendant Wrighte James gent 591850 591850 Wrighte, James, of Bradley, gent 0
4299015 2129742 2129742 defendant Finche William laborer 591850 591850 Finche, William, of Bradley, laborer 1
4299016 2129742 2129742 defendant Squier Richard laborer 591850 591850 Squier, Richard, of Bradley, laborer 2
4305979 2132230 2132230 defendant Gardner Richard wheeler 591850 591850 Gardner, Richard, of Bradley, wheeler 0
4317994 2136405 2136405 defendant Ripley John yeoman 591850 591850 Ripley, John, of Bradley, or of Coverdayll, yeoman 0
4317995 2136405 2136405 defendant Ripley George yeoman 591850 591850 Ripley, George, of Bradley, yeoman 1
4388421 2160763 2160763 defendant Shurley Robert husbandman 591850 591850 Shurley, Robert, of Bradley, husbandman 0
4396405 2163372 2163372 defendant Aston Robert yeoman 591850 591850 Aston, Robert, of Bradley, yeoman 1
4472170 2191961 2191961 defendant Williamson Robert   591850 591850 Williamson, Robert, of Bradley 0
4480249 2194484 2194484 defendant Shepherd William   591850 591850 Shepherd, William, of Bradley 0
4547845 2215263 2215263 defendant Typpere John smith 591850 591850 Typpere, John, of Bradley, smith 0
4559737 2218999 2218999 defendant Wenge William   591850 591850 Wenge, William, of Bradley, prior 0
4591413 2228671 2228671 defendant Milner John   591850 591850 Milner, John, of Bradley 1
4660362 2249069 2249069 defendant Roggers Thomas chapman 591850 591850 Roggers, Thomas, of Bradley, chapman 4
4665765 2250768 2250768 defendant Bradley Thomas husbandman 591850 591850 Bradley, Thomas, of Bradley, husbandman 2
4707641 2267753 2267753 plaintiff Milner John chapman 591850 591850 Milner, John, of Bradley, chapman 0
4715316 2270123 2270123 defendant Rede Richard de husbandman 591850 591850 Rede, Richard de, of Bradley, husbandman 0
4732973 2275490 2275490 defendant Holme William husbandman 591850 591850 Holme, William, of Bradley, husbandman 2
4750727 2280697 2280697 defendant Amy rihcard   591850 591850 Amy, rihcard, of Bradley, bailiff 1
4775034 2288188 2288188 plaintiff West John (legal representative) 591850 591850 West, John, of Bradley, parson, executors of 0
4834782 2306880 2306880 defendant Stinte John   591850 591850 Stinte, John, of Bradley, parson 0
4843014 2309354 2309354 defendant Aleynson Thomas yeoman 591850 591850 Aleynson, Thomas, of Bradley, yeoman 5
4843046 2309359 2309359 defendant Knyneton Henry gent 591850 591850 (Knyneton, Henry, of Bradley, gent 3
4891251 2323996 2323996 defendant Kneveton Henry esq 591850 591850 Kneveton, Henry, of Bradley, esq 0
4891267 2323997 2323997 defendant Alenson Thomas yeoman 591850 591850 Alenson, Thomas, of Bradley, yeoman 5
4898920 2326304 2326304 defendant Nowell Robert walker 591850 591850 Nowell, Robert, of Bradley, walker 0
4902686 2327460 2327460 defendant Arnald Thomas yeoman 591850 591850 Arnald, Thomas, of Bradley, yeoman 6
4902687 2327460 2327460 defendant Jacson John yeoman 591850 591850 Jacson, John, of Bradley, yeoman 7
4902689 2327460 2327460 defendant Chaumbre John yeoman 591850 591850 Chaumbre, John, of Bradley, yeoman 9
4906674 2328673 2328673 defendant Daweney William gent 591850 591850 Daweney, William, of Bradley, gent 0
4911710 2330163 2330163 defendant Skynner Richard   591850 591850 Skynner, Richard, of Bradley, parson 3
4915031 2331207 2331207 plaintiff de Radclyff Margaret   591850 591850 de Radclyff, Margaret, of Bradley, formerly wife of William de Radclyff 0
4924243 2334026 2334026 defendant Geldhird Thomas husbandman 591850 591850 Geldhird, Thomas, of Bradley, husbandman 0
4924244 2334026 2334026 defendant Brathwayt William husbandman 591850 591850 Brathwayt, William, of Bradley, husbandman 1
4924248 2334026 2334026 defendant del Loge Amery widow 591850 591850 del Loge, Amery, of Bradley, widow 5
4924251 2334026 2334026 defendant del Loge Richard husbandman 591850 591850 del Loge, Richard, of Bradley, husbandman 8
4946318 2340838 2340838 defendant Argram Richard husbandman 591850 591850 Argram, Richard, of Bradley, husbandman 0
4952907 2342829 2342829 defendant Laweson Henry husbandman 591850 591850 Laweson, Henry, of Bradley, husbandman 1
4966165 2346812 2346812 defendant Wadelofe William husbandman 591850 591850 Wadelofe, William, of Bradley, husbandman 3
4967805 2347314 2347314 defendant Tomson William husbandman 591850 591850 Tomson, William, of Bradley, husbandman 2

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