names

159 rows where place_id = 586167

✎ 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
3588069 1863918 1863918 defendant Cage Roger husbandman 586167 586167 Cage, Roger, of Est Bradenham, husbandman 0
3588070 1863918 1863918 defendant Haughe Henry husbandman 586167 586167 Haughe, Henry, of Est Bradenham, husbandman 1
3593773 1865689 1865689 defendant Gardener John butcher 586167 586167 Gardener, John, of Est Bradenham, butcher 1
3601557 1868142 1868142 defendant Cage Roger husbandman 586167 586167 Cage, Roger, of Est Bradenham, husbandman 0
3604641 1869113 1869113 defendant Hypgame Thomas husbandman 586167 586167 Hypgame, Thomas, of Est Bradenham, husbandman 5
3635849 1906011 1906011 defendant Russhemer Richard husbandman 586167 586167 Russhemer, Richard, of Est Bradenham, husbandman 0
3642218 1908013 1908013 defendant Fysshe Peter husbandman 586167 586167 Fysshe, Peter, of Est Bradenham, husbandman 1
3644613 1908726 1908726 defendant Potter Edmund clerk 586167 586167 Potter, Edmund, of Est Bradenham, clerk 0
3649380 1910195 1910195 defendant Potter Edmund clerk 586167 586167 Potter, Edmund, of Est Bradenham, clerk 0
3667341 1915722 1915722 defendant Potter Edmund   586167 586167 Potter, Edmund, of East Bradenham, rector 0
3673592 1917770 1917770 defendant Potter Edmund clerk 586167 586167 Potter, Edmund, of Est Bradenham, clerk 0
3682720 1920697 1920697 defendant More Richard husbandman 586167 586167 More, Richard, of Est Bradenham, husbandman 0
3682776 1920714 1920714 defendant Potter Edmund clerk 586167 586167 Potter, Edmund, of Est Bradenham, clerk 0
3695744 1924899 1924899 defendant Potter Edmund clerk 586167 586167 Potter, Edmund, of Est Bradenham, clerk 0
3698329 1925697 1925697 plaintiff Wake John   586167 586167 Wake, John, of Est Bradenham 0
3711986 1930067 1930067 plaintiff Wake John   586167 586167 Wake, John, of Est Bradenham 0
3711989 1930068 1930068 plaintiff Wake John   586167 586167 Wake, John, of Est Bradenham 0
3711993 1930069 1930069 plaintiff Wake John yeoman 586167 586167 Wake, John, of Est Bradenham, yeoman 0
3711994 1930069 1930069 defendant Fleg James husbandman 586167 586167 Fleg, James, of Est Bradenham, husbandman 0
3715716 1931206 1931206 plaintiff Cage Roger (legal representative) 586167 586167 Cage, Roger, of Est Bradenham, executrix of 0
3735908 1937471 1937471 defendant Snowe John   586167 586167 Snowe, John, of Est Bradenham, tile maker 0
3742830 1939611 1939611 plaintiff Wake John (legal representative) 586167 586167 Wake, John, of Est Bradenham, yeoman, executors of 0
3744292 1940113 1940113 defendant Alpe William yeoman 586167 586167 Alpe, William, of Est Bradenham, yeoman 0
3750488 1942066 1942066 defendant Pratt John husbandman 586167 586167 Pratt, John, of Est Bradenham, husbandman 1
3750489 1942066 1942066 defendant Wendelok William butcher 586167 586167 Wendelok, William, of Est Bradenham, butcher 2
3750492 1942067 1942067 defendant Langeden John husbandman 586167 586167 Langeden, John, of Est Bradenham, husbandman 0
3750493 1942067 1942067 defendant Snowe John   586167 586167 Snowe, John, of Est Bradenham, "brekeborner" 1
3771588 1948813 1948813 plaintiff Fulbourn Thomas   586167 586167 Fulbourn, Thomas, of Est Bradenham 1
3774085 1949608 1949608 defendant Potter Edmund clerk 586167 586167 Potter, Edmund, of Est Bradenham, clerk 1
3779634 1951360 1951360 defendant Wyseman John husbandman 586167 586167 Wyseman, John, of Est Bradenham, husbandman 1
3780378 1951597 1951597 defendant Broun Thomas carpenter 586167 586167 Broun, Thomas, of Est Bradenham, carpenter 0
3780379 1951597 1951597 defendant Snowe John brickmaker 586167 586167 Snowe, John, of Est Bradenham, brickmaker 1
3790158 1954741 1954741 plaintiff Wake John (legal representative) 586167 586167 Wake, John, of Est Bradenham, executors of 0
3797080 1956967 1956967 defendant Thomson John   586167 586167 Thomson, John, of Est Bradenham, brick maker 0
3797081 1956967 1956967 defendant Wyseman John   586167 586167 Wyseman, John, of Est Bradenham, brick maker 1
3797088 1956971 1956971 plaintiff Fulborne Thomas husbandman 586167 586167 Fulborne, Thomas, of Est Bradenham, husbandman 0
3805768 1959749 1959749 defendant Bayly William butcher 586167 586167 Bayly, William, of Est Bradenham, butcher 0
3814439 1962430 1962430 defendant Wyseman John   586167 586167 Wyseman, John, of Est bradenham, tile burner 0
3829205 1967017 1967017 defendant Gascoign Thomas tailor 586167 586167 Gascoign, Thomas, of Est Bradenham, tailor 2
3844111 1971706 1971706 defendant Gascon Thomas yeoman 586167 586167 Gascon, Thomas, of Est Bradenham, yeoman 4
3855235 1975271 1975271 plaintiff Wale John (legal representative) 586167 586167 Wale, John, of Est Bradenham, executor of 0
3861615 1977345 1977345 defendant Henlowe Thomas husbandman 586167 586167 Henlowe, Thomas, of Est Bradenham, husbandman 0
3866148 1978906 1978906 defendant Gascoyn Thomas tailor 586167 586167 Gascoyn, Thomas, of Est Bradenham, tailor 2
3874328 1981639 1981639 defendant Gasken Thomas tailor 586167 586167 Gasken, Thomas, of Est Bradenham, tailor 2
3885245 1985319 1985319 defendant Henloughe Thomas husbandman 586167 586167 Henloughe, Thomas, of Est Bradenham, husbandman 0
3888281 1986341 1986341 defendant Henlawe Thomas husbandman 586167 586167 Henlawe, Thomas, of Est Bradenham, husbandman 0
3902363 1991023 1991023 defendant Henlawe Thomas husbandman 586167 586167 Henlawe, Thomas, of Est Bradenham, husbandman 0
3918287 1996452 1996452 plaintiff Hogan Robert esq 586167 586167 Hogan, Robert, of Est Bradenham, esq 0
3925006 1998679 1998679 defendant Henlowe Thomas husbandman 586167 586167 Henlowe, Thomas, of Est Bradenham, husbandman 2
3932914 2001297 2001297 defendant Huggan William gent 586167 586167 Huggan, William, of East Bradenham, gent 1
3949359 2006848 2006848 defendant Hogan Anthony gent 586167 586167 Hogan, Anthony, of Est Bradenham, gent 0
3949360 2006848 2006848 defendant Nycholl Thomas laborer 586167 586167 Nycholl, Thomas, of Est Bradenham, laborer 1
3949361 2006848 2006848 defendant Wace alias Collender Thomas husbandman 586167 586167 Wace alias Collender, Thomas, of Est Bradenham, husbandman 2
3952730 2008026 2008026 defendant Hogan John gent 586167 586167 Hogan, John, of Est Bradenham, gent 0
3952731 2008026 2008026 defendant Dethicke Christopher yeoman 586167 586167 Dethicke, Christopher, of Est Bradenham, yeoman 1
3955188 2008879 2008879 defendant Waynforth Thomas husbandman 586167 586167 Waynforth, Thomas, of Est Bradenham, husbandman 1
3960061 2010617 2010617 plaintiff Stanberey John   586167 586167 Stanberey, John, of Est Downe, senior 0
3974890 2015782 2015782 plaintiff Hoggon Anthony gent 586167 586167 Hoggon, Anthony, of Est Bradenham, gent 0
3975793 2016095 2016095 plaintiff Hyngan or Hooggan Anthony gent 586167 586167 Hyngan or Hooggan, Anthony, of Est Bradenham, gent 0
4015205 2030130 2030130 plaintiff Smeth John tanner 586167 586167 Smeth, John, of East Bradenham, tanner 0
4052805 2043438 2043438 plaintiff Addison John   586167 586167 Addison, John, of Est Halton, bachelor 0
4249457 2112802 2112802 defendant Henlowe Thomas yeoman 586167 586167 Henlowe, Thomas, of Est Bradenham, yeoman 2
4396453 2163389 2163389 defendant Usher John   586167 586167 Usher, John, of East Barmyne, laboror 1
4398603 2164112 2164112 defendant Chaplyn Thomas grocer 586167 586167 Chaplyn, Thomas, of East Bradenham, grocer 2
4448800 2184564 2184564 defendant Fynnmer Simon   586167 586167 Fynnmer, Simon, of East Bradenham, parson 0
4475070 2192873 2192873 defendant Camplyon Simon   586167 586167 Camplyon, Simon, of East Bradenham 0
4507290 2202748 2202748 defendant Gardener Simon   586167 586167 Gardener, Simon, of East Bradenham 0
4567134 2221279 2221279 defendant Willesson Thomas   586167 586167 Willesson, Thomas, of East Bradenham, son of Richard 0
4576531 2224171 2224171 defendant atte Chirche Simon   586167 586167 atte Chirche, Simon, of East Bradenham 0
4581746 2225731 2225731 defendant Deye William   586167 586167 Deye, William, of East Bradenham 1
4581862 2225772 2225772 defendant Deye William   586167 586167 Deye, William, of East Bradenham 1
4605960 2232979 2232979 defendant Bole William   586167 586167 Bole, William, of East Bradenham 0
4674087 2257504 2257504 defendant Colyn John butcher 586167 586167 Colyn, John, of East Bradenham, butcher 2
4677308 2258522 2258522 defendant Hamond Geoffrey clerk 586167 586167 Hamond, Geoffrey, of East Bradenham, clerk 0
4677309 2258522 2258522 defendant Fullere Thomas clerk 586167 586167 Fullere, Thomas, of East Bradenham, clerk 1
4677310 2258522 2258522 defendant Dyckesson William husbandman 586167 586167 Dyckesson, William, of East Bradenham, husbandman 2
4685012 2260909 2260909 defendant Spyndeler John bedmaker 586167 586167 Spyndeler, John, of East Bradenham, bedmaker 0
4685014 2260909 2260909 defendant Decham John husbandman 586167 586167 Decham, John, of East Bradenham, husbandman 2
4709118 2268216 2268216 defendant Odyman John laborer 586167 586167 Odyman, John, of East Bradenham, laborer 0
4726756 2273638 2273638 defendant Byrd Thomas thatcher 586167 586167 Byrd, Thomas, of East Bradenham, thatcher 0
4726757 2273638 2273638 defendant Dykesson John sponer or roofer 586167 586167 Dykesson, John, of East Bradenham, sponer or roofer 1
4726759 2273639 2273639 defendant Byrd Thomas thatcher 586167 586167 Byrd, Thomas, of East Bradenham, thatcher 0
4726760 2273639 2273639 defendant Dykesson John sponer or roofer 586167 586167 Dykesson, John, of East Bradenham, sponer or roofer 1
4799941 2296164 2296164 defendant Arnold John butcher 586167 586167 Arnold, John, of Est Bradenham, butcher 0
4799942 2296164 2296164 defendant Starlyng Edmund husbandman 586167 586167 Starlyng, Edmund, of Est Bradenham, husbandman 1
4810567 2299453 2299453 defendant Neweman Thomas (legal representative) 586167 586167 Neweman, Thomas, of East Bradenham, husbandman, executrix of 0
4810568 2299453 2299453 defendant Newman Alice widow 586167 586167 Newman, Alice, of East Bradenham, widow 1
4812599 2300058 2300058 plaintiff Hamond John   586167 586167 Hamond, John, of East Bradenham 0
4824030 2303591 2303591 defendant Homerston Edmund   586167 586167 Homerston, Edmund, of East Bradenham, franklin 2
4832957 2306326 2306326 defendant Hamund John gent 586167 586167 Hamund, John, of East Bradenham, gent 1
4839301 2308219 2308219 plaintiff Hamond John   586167 586167 Hamond, John, of East Bradenham 0
4853557 2312527 2312527 defendant Totte John husbandman 586167 586167 Totte, John, of East Bradenham, husbandman 0
4866578 2316509 2316509 plaintiff Hamond John   586167 586167 Hamond, John, of Est Bradenham 0
4866584 2316510 2316510 plaintiff Hamond John   586167 586167 Hamond, John, of Est Bradenham 0
4873280 2318596 2318596 defendant Colyn Walter husbandman 586167 586167 Colyn, Walter, of Est Bradenham, husbandman 0
4877890 2320039 2320039 defendant Saunde- Thomas yeoman 586167 586167 Saunde-, Thomas, of Est Bradenham, yeoman 1
4892198 2324305 2324305 defendant Hamond John gent 586167 586167 Hamond, John, of Est Bradenham, gent 0
4895742 2325344 2325344 defendant Hamond John gent 586167 586167 Hamond, John, of Est Bradenham, gent 0
4897854 2325991 2325991 defendant Baker John butcher 586167 586167 Baker, John, of Est Bradenham, butcher 1
4911682 2330155 2330155 defendant Kempe Ralph   586167 586167 Kempe, Ralph, of East Bradenham, parson 1

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