names

389 rows where place_id = 588978

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596161 1866429 1866429 plaintiff Ormont William   588978 588978 Ormont, William, of Banbury 0
3597663 1866895 1866895 plaintiff Saunders William   588978 588978 Saunders, William, of Banbury 0
3609762 1870721 1870721 defendant Churchill William   588978 588978 Churchill, William, of Banbury 5
3614651 1872234 1872234 plaintiff Bukys William yeoman 588978 588978 Bukys, William, of Banbury, yeoman 0
3634698 1905646 1905646 defendant Smyth William yeoman 588978 588978 Smyth, William, of Banbury, yeoman 2
3643588 1908427 1908427 plaintiff Danners Anne widow 588978 588978 Danners, Anne, of Banbury, widow 0
3660526 1913553 1913553 plaintiff Holden Bernard clerk 588978 588978 Holden, Bernard, of Banbury, clerk 0
3664417 1914819 1914819 defendant Daners William gent 588978 588978 Daners, William, of Banbury, gent 1
3666672 1915522 1915522 defendant Vynars Robert husbandman 588978 588978 Vynars, Robert, of Banbury, husbandman 0
3674019 1917914 1917914 defendant Bysshopp William butcher 588978 588978 Bysshopp, William, of Banbury, butcher 1
3688441 1922540 1922540 defendant Sparke Thomas clerk 588978 588978 Sparke, Thomas, of Banbury, clerk 3
3688442 1922540 1922540 defendant Collys John clerk 588978 588978 Collys, John, of Banbury, clerk 4
3710399 1929572 1929572 defendant Nele William woolman 588978 588978 Nele, William, of Banbury, woolman 1
3710484 1929599 1929599 defendant Nele William woolman 588978 588978 Nele, William, of Banbury, woolman 1
3723345 1933571 1933571 defendant Boxe Robert shoemaker 588978 588978 Boxe, Robert, of Banbury, shoemaker 0
3723346 1933571 1933571 defendant Byrkynshawe John shoemaker 588978 588978 Byrkynshawe, John, of Banbury, shoemaker 1
3723347 1933571 1933571 defendant Boxe John shoemaker 588978 588978 Boxe, John, of Banbury, shoemaker 2
3726125 1934435 1934435 defendant Neell William   588978 588978 Neell, William, of Banbury, wool buyer 2
3727568 1934902 1934902 defendant Nele William gent 588978 588978 Nele, William, of Banbury, gent 1
3734363 1936985 1936985 defendant Alyn Robert (legal representative) 588978 588978 Alyn, Robert, of Banbury, yeoman, executors of 0
3734364 1936985 1936985 defendant Hawode William yeoman 588978 588978 (Hawode, William, of Banbury, yeoman 1
3734978 1937176 1937176 defendant Thorp alias Spicer John mercer 588978 588978 Thorp alias Spicer, John, of Banbury, mercer 1
3762686 1945967 1945967 defendant Stele Robert draper 588978 588978 Stele, Robert, of Banbury, draper 0
3763325 1946161 1946161 defendant Busby William hosier 588978 588978 Busby, William, of Banbury, hosier 0
3763326 1946161 1946161 defendant Pereson William draper 588978 588978 Pereson, William, of Banbury, draper 1
3763327 1946161 1946161 defendant Tayllour Thomas tailor 588978 588978 Tayllour, Thomas, of Banbury, tailor 2
3763328 1946161 1946161 defendant Gyles Nicholas tanner 588978 588978 Gyles, Nicholas, of Banbury, tanner 3
3763329 1946161 1946161 defendant Box John chaplain 588978 588978 Box, John, of Banbury, chaplain 4
3763331 1946162 1946162 defendant Busby William hosier 588978 588978 Busby, William, of Banbury, hosier 0
3763332 1946162 1946162 defendant Pereson William draper 588978 588978 Pereson, William, of Banbury, draper 1
3763333 1946162 1946162 defendant Tayloure Thomas draper 588978 588978 Tayloure, Thomas, of Banbury, draper 2
3763334 1946162 1946162 defendant Gyles Nicholas tanner 588978 588978 Gyles, Nicholas, of Banbury, tanner 3
3763335 1946162 1946162 defendant Box John chaplain 588978 588978 Box, John, of Banbury, chaplain 4
3775097 1949943 1949943 defendant Browne Henry (legal representative) 588978 588978 Browne, Henry, of Banbury, executors of 0
3781690 1952016 1952016 defendant Halhedde William yeoman 588978 588978 Halhedde, William, of Banbury, yeoman 0
3806362 1959902 1959902 defendant Spycer John yeoman 588978 588978 Spycer, John, of Banbury, yeoman 4
3807803 1960324 1960324 defendant Shelwyn Alice widow 588978 588978 Shelwyn, Alice, of Banbury, widow 1
3809128 1960739 1960739 plaintiff Barnysley Roger butcher 588978 588978 Barnysley, Roger, of Banbury, butcher 0
3809129 1960739 1960739 defendant Byngham William mercer 588978 588978 Byngham, William, of Banbury, mercer 0
3813422 1962115 1962115 defendant Butler Thomas shoemaker 588978 588978 Butler, Thomas, of Banbury, shoemaker 0
3828074 1966649 1966649 defendant Rowland Thomas draper 588978 588978 Rowland, Thomas, of Banbury, draper 0
3831293 1967673 1967673 defendant Abell Thomas   588978 588978 Abell, Thomas, of Banbury, mason 0
3831295 1967674 1967674 defendant Tuskett John smith 588978 588978 Tuskett, John, of Banbury, smith 0
3831680 1967806 1967806 defendant Bysshop alias Bocher Richard bucher 588978 588978 Bysshop alias Bocher, Richard, of Banbury, bucher 0
3854442 1975028 1975028 defendant Wolsall John butcher 588978 588978 Wolsall, John, of Banbury, butcher 0
3865167 1978555 1978555 defendant Hopkyns Barnard butcher 588978 588978 Hopkyns, Barnard, of Banbury, butcher 0
3867120 1979243 1979243 defendant Parkyns William   588978 588978 Parkyns, William, of Banbury, wool winder 0
3870609 1980413 1980413 plaintiff Wyse John mercer 588978 588978 Wyse, John, of Banbury, mercer 0
3881853 1984184 1984184 defendant Byngham William merchant of Calis 588978 588978 Byngham, William, of Banbury, merchant of Calis 0
3881854 1984184 1984184 defendant Halhed William yeoman 588978 588978 Halhed, William, of Banbury, yeoman 1
3890707 1987158 1987158 defendant Bartlett Mary widow 588978 588978 Bartlett, Mary, of Banbury, widow 1
3907872 1992922 1992922 plaintiff Plommer alias Bayle William   588978 588978 Plommer alias Bayle, William, of Banbury 0
3907882 1992925 1992925 defendant Brotherton John dyer 588978 588978 Brotherton, John, of Banbury, dyer 0
3907884 1992925 1992925 defendant Boldy William grazier 588978 588978 Boldy, William, of Banbury, grazier 2
3912248 1994425 1994425 plaintiff Wyse John mercer 588978 588978 Wyse, John, of Banbury, mercer 0
3912260 1994430 1994430 defendant Ocford Thomas clothier 588978 588978 Ocford, Thomas, of Banbury, clothier 0
3913334 1994793 1994793 defendant Banner William glover 588978 588978 Banner, William, of Banbury, glover 0
3915127 1995418 1995418 defendant Bysshop Richard butcher 588978 588978 Bysshop, Richard, of Banbury, butcher 0
3915590 1995582 1995582 defendant Graunte Thomas husbandman 588978 588978 Graunte, Thomas, of Banbury, husbandman 0
3919330 1996794 1996794 defendant Chester Peter yeoman 588978 588978 Chester, Peter, of Banbury, yeoman 4
3924084 1998366 1998366 defendant Thornton Christopher butcher 588978 588978 Thornton, Christopher, of Banbury, butcher 0
3925895 1998976 1998976 plaintiff Wyse John   588978 588978 Wyse, John, of Banbury 0
3925896 1998976 1998976 defendant Byngham William yeoman or tanner 588978 588978 Byngham, William, of Banbury, yeoman or tanner 0
3928746 1999952 1999952 defendant Vikars Robert mercer 588978 588978 Vikars, Robert, of Banbury, mercer 0
3929867 2000330 2000330 defendant Lutar John   588978 588978 Lutar, John, of Banbury, cloth maker 0
3947060 2006036 2006036 defendant Weston William (legal representative) 588978 588978 Weston, William, of Banbury, mercer, executrix of 0
3947061 2006036 2006036 defendant Weston Elizabeth widow 588978 588978 Weston, Elizabeth, of Banbury, widow 1
3947063 2006037 2006037 defendant Weston William (legal representative) 588978 588978 Weston, William, of Banbury, mercer, executrix of 0
3947064 2006037 2006037 defendant Weston Elizabeth widow 588978 588978 Weston, Elizabeth, of Banbury, widow 1
3954097 2008506 2008506 plaintiff Knight William baker 588978 588978 Knight, William, of Banbury, baker 0
3954112 2008512 2008512 plaintiff Knyght William baker 588978 588978 Knyght, William, of Banbury, baker 0
3962487 2011473 2011473 defendant FytzRychard Otwell gent 588978 588978 FytzRychard, Otwell, of Banbury, gent 0
3962489 2011474 2011474 defendant FitzRichard Otwell gent 588978 588978 FitzRichard, Otwell, of Banbury, gent 0
3962491 2011475 2011475 defendant Wyse William yeoman 588978 588978 Wyse, William, of Banbury, yeoman 0
3979850 2017549 2017549 plaintiff Palmer Edward yeoman 588978 588978 Palmer, Edward, of Banbury, yeoman 0
3981242 2018054 2018054 defendant Pawley or Paley Roger butcher 588978 588978 Pawley or Paley, Roger, of Banbury, butcher 0
3982833 2018633 2018633 defendant Long John mercer 588978 588978 Long, John, of Banbury, mercer 0
3995364 2023085 2023085 defendant Heywode Robert yeoman 588978 588978 Heywode, Robert, of Banbury, yeoman 0
3999015 2024406 2024406 defendant Luter John glover 588978 588978 Luter, John, of Banbury, glover 0
4023932 2033264 2033264 defendant Bentley Edward shoemaker 588978 588978 Bentley, Edward, of Banbury, shoemaker 0
4032268 2036210 2036210 defendant Danvers John gent 588978 588978 Danvers, John, of Banbury, gent 6
4116417 2066161 2066161 defendant Luter Thomas glover 588978 588978 Luter, Thomas, of Banbury, glover 1
4130367 2071173 2071173 defendant Newall Robert weaver 588978 588978 Newall, Robert, of Banbury, weaver 0
4139854 2074618 2074618 defendant Longe Thomas mercer 588978 588978 Longe, Thomas, of Banbury, mercer 0
4143655 2075937 2075937 defendant Bysshopp John glover 588978 588978 Bysshopp, John, of Banbury, glover 1
4197141 2094552 2094552 defendant Compton William tailor 588978 588978 Compton, William, of Banbury, tailor 1
4211693 2099644 2099644 defendant Longe Thomas mercer 588978 588978 Longe, Thomas, of Banbury, mercer 0
4296066 2128690 2128690 defendant Secoll Robert draper 588978 588978 Secoll, Robert, of Banbury, draper 0
4302455 2130979 2130979 defendant Robyns William victualer 588978 588978 Robyns, William, of Banbury, victualer 0
4307741 2132847 2132847 defendant Churchill Richard carpenter 588978 588978 Churchill, Richard, of Banbury, carpenter 0
4307744 2132848 2132848 defendant Churchill Richard carpenter 588978 588978 Churchill, Richard, of Banbury, carpenter 0
4308673 2133184 2133184 defendant Churchill Richard carpenter 588978 588978 Churchill, Richard, of Banbury, carpenter 1
4308676 2133185 2133185 defendant Churchill Richard carpenter 588978 588978 Churchill, Richard, of Banbury, carpenter 1
4309230 2133381 2133381 defendant Basse Michael maltman 588978 588978 Basse, Michael, of Banbury, victualer, maltman 0
4434931 2175685 2175685 defendant Wylat John   588978 588978 Wylat, John, of Banbury 0
4446757 2183901 2183901 plaintiff Dister Adam   588978 588978 Dister, Adam, of Banbury, on his own account 0
4446758 2183901 2183901 defendant Derset Sarah   588978 588978 Derset, Sarah, of Banbury 0
4467522 2190523 2190523 plaintiff Averey Thomas   588978 588978 Averey, Thomas, of Banbury 0
4478832 2194051 2194051 defendant Radclyf Robert   588978 588978 Radclyf, Robert, of Banbury 0
4510162 2203663 2203663 plaintiff Barbour Edward   588978 588978 Barbour, Edward, of Banbury 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);