names

660 rows where place_id = 587891

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592747 1865344 1865344 defendant Bulfynch Edward chapman 587891 587891 Bulfynch, Edward, of Redyng, chapman 1
3593373 1865560 1865560 defendant Barnaby John sherman 587891 587891 Barnaby, John, of Redyng, sherman 0
3594319 1865855 1865855 defendant Cavy Robert smith 587891 587891 Cavy, Robert, of Redyng, smith 1
3594320 1865855 1865855 defendant Rede William mercer 587891 587891 Rede, William, of Redyng, mercer 2
3596579 1866564 1866564 defendant Weston John mercer 587891 587891 Weston, John, of Redyng, mercer 0
3596649 1866587 1866587 defendant Milton William sherman 587891 587891 Milton, William, of Redyng, sherman 0
3599155 1867372 1867372 defendant Wyse Richard butcher 587891 587891 Wyse, Richard, of Redyng, butcher 1
3600713 1867877 1867877 defendant Bower alias Fleccher John butcher 587891 587891 Bower alias Fleccher, John, of Redyng, butcher 0
3600715 1867878 1867878 defendant Lewes William draper 587891 587891 Lewes, William, of Redyng, draper 0
3603403 1868737 1868737 plaintiff Dene William yeoman 587891 587891 Dene, William, of Redyng, yeoman 0
3604125 1868956 1868956 defendant Bayton Thomas tanner 587891 587891 Bayton, Thomas, of Redyng, tanner 0
3604271 1868999 1868999 defendant Schuchon William merchant 587891 587891 Schuchon, William, of Redyng, merchant 0
3604772 1869157 1869157 defendant Punchun Hugh carpenter 587891 587891 Punchun, Hugh, of Redyng, carpenter 0
3604773 1869157 1869157 defendant Abourn Thomas spicer 587891 587891 Abourn, Thomas, of Redyng, spicer 1
3607326 1869953 1869953 defendant Haselwode William   587891 587891 Haselwode, William, of Redyng, bell founder 1
3607546 1870018 1870018 defendant Baxter alias Norfolke John tanner 587891 587891 Baxter alias Norfolke, John, of Redyng, tanner 0
3608019 1870160 1870160 defendant Hall Lawrence vintner 587891 587891 Hall, Lawrence, of Redyng, vintner 5
3608645 1870365 1870365 defendant Sutton Robert tailor 587891 587891 Sutton, Robert, of Redyng, tailor 0
3608646 1870365 1870365 defendant Brynger Thomas yeoman 587891 587891 Brynger, Thomas, of Redyng, yeoman 1
3608647 1870365 1870365 defendant Puntyngton John fuller 587891 587891 Puntyngton, John, of Redyng, fuller 2
3610460 1870931 1870931 defendant Punchun Hugh carpenter 587891 587891 Punchun, Hugh, of Redyng, carpenter 0
3611769 1871345 1871345 defendant Fachell Thomas gent 587891 587891 Fachell, Thomas, of Redyng, gent 0
3612825 1871660 1871660 defendant Halyca John butcher 587891 587891 Halyca, John, of Redyng, butcher 0
3612826 1871660 1871660 defendant Sadeler Robert butcher 587891 587891 Sadeler, Robert, of Redyng, butcher 1
3612827 1871660 1871660 defendant Bolde John butcher 587891 587891 Bolde, John, of Redyng, butcher 2
3619843 1873782 1873782 plaintiff Kelsall Henry (legal representative) 587891 587891 Kelsall, Henry, of Redyng, executors of 0
3624399 1875166 1875166 defendant Redehode Thomas tanner 587891 587891 Redehode, Thomas, of Redyng, tanner 1
3626016 1902993 1902993 defendant Laurence Hugh butcher 587891 587891 Laurence, Hugh, of Redyng, butcher 0
3626017 1902993 1902993 defendant Monke William chandler 587891 587891 Monke, William, of Redyng, chandler 1
3626563 1903158 1903158 defendant Baker Walter baker 587891 587891 Baker, Walter, of Redyng, baker 0
3627969 1903603 1903603 defendant Lewsham William clothier 587891 587891 Lewsham, William, of Redyng, clothier 0
3627970 1903603 1903603 defendant Wilson Thomas weaver 587891 587891 Wilson, Thomas, of Redyng, weaver 1
3629578 1904108 1904108 defendant Maxfeld Thomas draper 587891 587891 Maxfeld, Thomas, of Redyng, draper 0
3630207 1904296 1904296 defendant Bernabe John fuller 587891 587891 Bernabe, John, of Redyng, or of Henley on Thames, fuller 0
3630868 1904474 1904474 defendant Reynold John   587891 587891 Reynold, John, of Redyng 0
3633010 1905144 1905144 defendant Maxfelde Thomas draper 587891 587891 Maxfelde, Thomas, of Redyng, draper 0
3633239 1905211 1905211 defendant Water William fuller 587891 587891 Water, William, of Redyng, fuller 1
3633654 1905336 1905336 plaintiff Lassam William   587891 587891 Lassam, William, of Redyng 0
3634438 1905571 1905571 defendant More Richard tinker 587891 587891 More, Richard, of Redyng, tinker 0
3637103 1906404 1906404 defendant Trewe William yeoman 587891 587891 Trewe, William, of Redyng, yeoman 1
3640487 1907456 1907456 defendant Alen Thomas butcher 587891 587891 Alen, Thomas, of Redyng, butcher 0
3641328 1907740 1907740 defendant Appole Peter fuller 587891 587891 Appole, Peter, of Redyng, fuller 0
3642757 1908183 1908183 defendant Clifford John butcher 587891 587891 Clifford, John, of Redyng, butcher 0
3644860 1908802 1908802 defendant Morys Walter hosteler 587891 587891 Morys, Walter, of Redyng, hosteler 0
3649565 1910252 1910252 defendant Coplay John butcher 587891 587891 Coplay, John, of Redyng, butcher 2
3652831 1911210 1911210 defendant Turnour Richard baker 587891 587891 Turnour, Richard, of Redyng, baker 2
3653144 1911316 1911316 defendant Everard Thomas grasier 587891 587891 Everard, Thomas, of Redyng, grasier 0
3655016 1911834 1911834 plaintiff Benet Robert (legal representative) 587891 587891 Benet, Robert, of Redyng, executrix of 0
3655869 1912090 1912090 plaintiff Bryll Robert   587891 587891 Bryll, Robert, of Redyng 0
3655955 1912111 1912111 defendant Brasyer Robert fuller 587891 587891 Brasyer, Robert, of Redyng, fuller 1
3665274 1915091 1915091 defendant Rychardson John butcher 587891 587891 Rychardson, John, of Redyng, butcher 0
3668512 1916108 1916108 defendant Drewe Simon husbandman 587891 587891 Drewe, Simon, of Redyng, husbandman 0
3669091 1916265 1916265 defendant Nichollys Thomas tiler 587891 587891 Nichollys, Thomas, of Redyng, tiler 2
3669094 1916266 1916266 defendant Wysseham John carpenter 587891 587891 Wysseham, John, of Redyng, carpenter 0
3670467 1916722 1916722 plaintiff Buk John   587891 587891 Buk, John, of Redyng 0
3670473 1916725 1916725 plaintiff Bukke John baker 587891 587891 Bukke, John, of Redyng, baker 0
3673381 1917694 1917694 plaintiff Everard Thomas   587891 587891 Everard, Thomas, of Redyng 0
3673859 1917856 1917856 plaintiff Frankleyn Hugh   587891 587891 Frankleyn, Hugh, of Redyng 0
3673860 1917856 1917856 defendant Rawlenson Robert dyer 587891 587891 Rawlenson, Robert, of Redyng, dyer 0
3676686 1918748 1918748 plaintiff Justice William, senior   587891 587891 Justice, William, senior, of Redyng 0
3676687 1918748 1918748 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 1
3676693 1918749 1918749 plaintiff Justice William, senior   587891 587891 Justice, William, senior, of Redyng 0
3676694 1918749 1918749 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 1
3676700 1918750 1918750 plaintiff Justice William, senior   587891 587891 Justice, William, senior, of Redyng 0
3676701 1918750 1918750 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 1
3676707 1918751 1918751 plaintiff Justice William, senior   587891 587891 Justice, William, senior, of Redyng 0
3676708 1918751 1918751 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 1
3676714 1918752 1918752 plaintiff Justice William, senior   587891 587891 Justice, William, senior, of Redyng 0
3676715 1918752 1918752 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 1
3680166 1919867 1919867 defendant Buk Richard baker 587891 587891 Buk, Richard, of Redyng, baker 0
3682077 1920503 1920503 defendant Rawlynson Robert dyer 587891 587891 Rawlynson, Robert, of Redyng, dyer 0
3682604 1920664 1920664 plaintiff Thomson William   587891 587891 Thomson, William, of Redyng 0
3682605 1920664 1920664 defendant Elmys Richard   587891 587891 Elmys, Richard, of Redyng, coverlet weaver 0
3683574 1920996 1920996 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 0
3684704 1921348 1921348 defendant Kene Nicholas butcher 587891 587891 Kene, Nicholas, of Redyng, butcher 1
3685606 1921650 1921650 defendant Napper John butcher 587891 587891 Napper, John, of Redyng, butcher 2
3686074 1921805 1921805 defendant Capper John capper 587891 587891 Capper, John, of Redyng, capper 0
3689934 1923011 1923011 defendant Nutte William sherman 587891 587891 Nutte, William, of Redyng, sherman 0
3689935 1923011 1923011 defendant Benston Richard yeoman 587891 587891 Benston, Richard, of Redyng, yeoman 1
3689942 1923013 1923013 defendant Broune Robert fuller 587891 587891 Broune, Robert, of Redyng, fuller 1
3689943 1923013 1923013 defendant Shreve John barber 587891 587891 Shreve, John, of Redyng, barber 2
3690609 1923227 1923227 defendant Myllyngton Ralph weaver 587891 587891 Myllyngton, Ralph, of Redyng, weaver 0
3690611 1923227 1923227 defendant Gostelyng John fuller 587891 587891 Gostelyng, John, of Redyng, fuller 2
3691661 1923552 1923552 defendant Byrche Richard   587891 587891 Byrche, Richard, of Redyng, surgeon 0
3691932 1923638 1923638 defendant Heyre Henry fuller 587891 587891 Heyre, Henry, of Redyng, fuller 0
3691933 1923638 1923638 defendant Leynthall Robert fuller 587891 587891 Leynthall, Robert, of Redyng, fuller 1
3692463 1923824 1923824 defendant Foyt Sigismund   587891 587891 Foyt, Sigismund, of Redyng, organ maker 0
3693332 1924127 1924127 defendant Franklyng Hugh yeoman 587891 587891 Franklyng, Hugh, of Redyng, yeoman 2
3697174 1925337 1925337 defendant Hill Robert   587891 587891 Hill, Robert, of Redyng, mason 2
3698013 1925604 1925604 plaintiff Turner Richard   587891 587891 Turner, Richard, of Redyng 0
3698014 1925604 1925604 plaintiff Barnys Richard   587891 587891 Barnys, Richard, of Redyng 1
3699919 1926205 1926205 defendant Turner Richard mercer 587891 587891 Turner, Richard, of Redyng, mercer 0
3700792 1926499 1926499 defendant Byll Robert laborer 587891 587891 Byll, Robert, of Redyng, laborer 1
3700793 1926499 1926499 defendant Pryson Nicholas tanner 587891 587891 Pryson, Nicholas, of Redyng, tanner 2
3700847 1926510 1926510 defendant Nichollys Thomas bricklayer 587891 587891 Nichollys, Thomas, of Redyng, bricklayer 2
3702383 1927005 1927005 defendant Benett William fuller 587891 587891 Benett, William, of Redyng, fuller 0
3712315 1930169 1930169 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 0
3712320 1930170 1930170 plaintiff Wattys William   587891 587891 Wattys, William, of Redyng 0
3713571 1930553 1930553 defendant Specman Christopher butcher 587891 587891 Specman, Christopher, of Redyng, butcher 0
3713588 1930560 1930560 defendant Frankelyn Hugh yeoman 587891 587891 Frankelyn, Hugh, of Redyng, 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);