names

392 rows where place_id = 586035

✎ 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
3587747 1863813 1863813 defendant Fowler Thomas esq 586035 586035 Fowler, Thomas, of Buckingham, esq 3
3591411 1864939 1864939 defendant Terry John chapman 586035 586035 Terry, John, of Buckingham, chapman 1
3592694 1865329 1865329 defendant Dayson alias Deysy William yeoman 586035 586035 Dayson alias Deysy, William, of Buckingham, yeoman 0
3606043 1869556 1869556 defendant Ormeston Thomas saddler 586035 586035 Ormeston, Thomas, of Buckingham, saddler 0
3607612 1870038 1870038 defendant Crane William butcher 586035 586035 Crane, William, of Buckingham, butcher 0
3608885 1870435 1870435 defendant Foweler Thomas esq 586035 586035 Foweler, Thomas, of Buckingham, esq 0
3614658 1872237 1872237 defendant Vaus or Vans Edmund tailor 586035 586035 Vaus or Vans, Edmund, of Buckingham, tailor 0
3614981 1872329 1872329 defendant Gomerey William stringer 586035 586035 Gomerey, William, of Buckingham, stringer 3
3614986 1872330 1872330 defendant Gomerey William stringer 586035 586035 Gomerey, William, of Buckingham, stringer 3
3616615 1872827 1872827 defendant Baston William cordwainer 586035 586035 Baston, William, of Buckingham, cordwainer 0
3620875 1874091 1874091 defendant Fowler Thomas esq 586035 586035 Fowler, Thomas, of Buckingham, esq 0
3636754 1906289 1906289 defendant Kenssember John smith 586035 586035 Kenssember, John, of Buckingham, smith 0
3637830 1906650 1906650 defendant Attilbury Thomas dyer 586035 586035 Attilbury, Thomas, of Buckingham, dyer 0
3637950 1906689 1906689 defendant Baxster John carver 586035 586035 Baxster, John, of Buckingham, carver 0
3666966 1915612 1915612 defendant Touer Henry baker 586035 586035 Touer, Henry, of Buckingham, baker 1
3669708 1916468 1916468 defendant Luke Thomas carpenter 586035 586035 Luke, Thomas, of Buckingham, carpenter 0
3689065 1922741 1922741 defendant Baxter John carver 586035 586035 Baxter, John, of Buckingham, carver 4
3689071 1922742 1922742 defendant Baxter John carver 586035 586035 Baxter, John, of Buckingham, carver 4
3692203 1923728 1923728 defendant Hancok William weaver 586035 586035 Hancok, William, of Buckingham, weaver 0
3692777 1923932 1923932 defendant Smyth William clerk 586035 586035 Smyth, William, of Buckingham, clerk 0
3694395 1924452 1924452 defendant Atkyns Thomas fishmonger 586035 586035 Atkyns, Thomas, of Buckingham, fishmonger 0
3701007 1926562 1926562 defendant Grenewyll Edward gent 586035 586035 Grenewyll, Edward, of Buckingham, or of Middle Temple, gent 9
3701487 1926711 1926711 defendant Wight William hosier 586035 586035 Wight, William, of Buckingham, hosier 3
3705467 1928000 1928000 defendant Stothe William chapman 586035 586035 Stothe, William, of Buckingham, chapman 1
3707051 1928492 1928492 defendant Smyth William clerk 586035 586035 Smyth, William, of Buckingham, clerk 0
3707053 1928493 1928493 defendant Smyth William clerk 586035 586035 Smyth, William, of Buckingham, clerk 0
3710227 1929514 1929514 defendant Ellys William clerk 586035 586035 Ellys, William, of Buckingham, clerk 0
3710228 1929514 1929514 defendant Ellys Henry butcher 586035 586035 Ellys, Henry, of Buckingham, butcher 1
3710657 1929653 1929653 defendant Galley Robert yeoman 586035 586035 (Galley, Robert, of Buckingham, yeoman 1
3719012 1932221 1932221 defendant Rand Richard mercer 586035 586035 Rand, Richard, of Buckingham, mercer 3
3733529 1936731 1936731 defendant Tod Henry baker 586035 586035 Tod, Henry, of Buckingham, baker 1
3757991 1944482 1944482 defendant Wright Nicholas hosier 586035 586035 Wright, Nicholas, of Buckingham, hosier 0
3758050 1944503 1944503 defendant Coke James laborer 586035 586035 Coke, James, of Buckingham, laborer 1
3778159 1950875 1950875 defendant Grace Robert mercer 586035 586035 Grace, Robert, of Buckingham, mercer 7
3782720 1952339 1952339 defendant Brystowe William butcher 586035 586035 Brystowe, William, of Buckingham, butcher 0
3783735 1952676 1952676 defendant Here William saddler 586035 586035 Here, William, of Buckingham, saddler 1
3790950 1955003 1955003 defendant Nurse Richard butcher 586035 586035 Nurse, Richard, of Buckingham, butcher 0
3791263 1955101 1955101 defendant Grace Robert mercer 586035 586035 Grace, Robert, of Buckingham, mercer 0
3791264 1955101 1955101 defendant Bettys John butcher 586035 586035 Bettys, John, of Buckingham, butcher 1
3794278 1956083 1956083 defendant Grase Robert mercer 586035 586035 Grase, Robert, of Buckingham, mercer 1
3796637 1956825 1956825 defendant Bury Henry gent 586035 586035 Bury, Henry, of Buckingham, gent 0
3796639 1956826 1956826 defendant Bury Henry gent 586035 586035 Bury, Henry, of Buckingham, gent 0
3798126 1957309 1957309 defendant Whyte Thomas yeoman 586035 586035 Whyte, Thomas, of Buckingham, yeoman 3
3800809 1958167 1958167 defendant Illyng William tanner 586035 586035 Illyng, William, of Buckingham, tanner 1
3801378 1958359 1958359 defendant Bettys John butcher 586035 586035 Bettys, John, of Buckingham, butcher 1
3801379 1958359 1958359 defendant Bristo or Brisco Thomas butcher 586035 586035 Bristo or Brisco, Thomas, of Buckingham, butcher 2
3806846 1960048 1960048 defendant Stele Thomas butcher 586035 586035 Stele, Thomas, of Buckingham, butcher 0
3810087 1961045 1961045 defendant Bury Henry gent 586035 586035 Bury, Henry, of Buckingham, gent 0
3813821 1962236 1962236 defendant Bull John mercer 586035 586035 Bull, John, of Buckingham, mercer 0
3813939 1962269 1962269 defendant Feldyng Thomas armorer 586035 586035 Feldyng, Thomas, of Buckingham, armorer 0
3815223 1962677 1962677 defendant Atkyns alias Blokeley Thomas husbandman 586035 586035 Atkyns alias Blokeley, Thomas, of Buckingham, husbandman 0
3842360 1971145 1971145 defendant Stanbryge Richard clothier 586035 586035 Stanbryge, Richard, of Buckingham, clothier 0
3845360 1972108 1972108 defendant Grace Robert mercer 586035 586035 Grace, Robert, of Buckingham, mercer 0
3847174 1972671 1972671 defendant Wryght Alexander gent 586035 586035 Wryght, Alexander, of Buckingham, gent 0
3850611 1973779 1973779 defendant Atkyns alias Blokley Thomas yeoman 586035 586035 Atkyns alias Blokley, Thomas, of Buckingham, yeoman 0
3850612 1973779 1973779 defendant Heth William yeoman 586035 586035 Heth, William, of Buckingham, yeoman 1
3885156 1985287 1985287 defendant Lambard William grazier 586035 586035 Lambard, William, of Buckingham, grazier 2
3898010 1989540 1989540 defendant Garne William mercer 586035 586035 Garne, William, of Buckingham, mercer 0
3899081 1989901 1989901 defendant Hoode Thomas baker 586035 586035 Hoode, Thomas, of Buckingham, baker 2
3912990 1994678 1994678 defendant Lambard William grasier 586035 586035 Lambard, William, of Buckingham, grasier 2
3913149 1994732 1994732 defendant Slye John mercer 586035 586035 Slye, John, of Buckingham, mercer 0
3925795 1998945 1998945 defendant Pates John gent 586035 586035 Pates, John, of Buckingham, gent 0
3925797 1998946 1998946 defendant Pates John gent 586035 586035 Pates, John, of Buckingham, gent 0
3926507 1999197 1999197 defendant Slye John yeoman 586035 586035 Slye, John, of Buckingham, yeoman 0
3931800 2000940 2000940 defendant Smyth Richard   586035 586035 Smyth, Richard, of Buckingham, inn holder 2
3932447 2001140 2001140 defendant Josselyn John gent 586035 586035 Josselyn, John, of Buckingham, gent 0
3936209 2002436 2002436 plaintiff Lylly Thomas mercer 586035 586035 Lylly, Thomas, of Buckingham, mercer 0
3939937 2003658 2003658 defendant Phyllyps William gent 586035 586035 Phyllyps, William, of Buckingham, gent 0
3943274 2004771 2004771 defendant Cates John mercer 586035 586035 Cates, John, of Buckingham, mercer 0
3987559 2020301 2020301 defendant Pates John gent 586035 586035 Pates, John, of Buckingham, gent 0
4038120 2038274 2038274 defendant Oglethorpe Owen gent 586035 586035 Oglethorpe, Owen, of Buckingham, gent 0
4097664 2059493 2059493 defendant Bennett Richard draper 586035 586035 Bennett, Richard, of Buckingham, draper 2
4100628 2060550 2060550 defendant Appowell John (legal representative) 586035 586035 Appowell, John, of Buckingham, bellfounder, executors of 0
4100629 2060550 2060550 defendant Lambert John yeoman 586035 586035 (Lambert, John, of Buckingham, yeoman 1
4152473 2078977 2078977 defendant Kylgrove Henry gent 586035 586035 Kylgrove, Henry, of Buckingham, gent 2
4203553 2096795 2096795 defendant Garrett William brasier 586035 586035 Garrett, William, of Buckingham, brasier 0
4208164 2098410 2098410 defendant Braye Richard gent 586035 586035 Braye, Richard, of Buckingham, gent 0
4216889 2101403 2101403 defendant Carpenter Henry   586035 586035 Carpenter, Henry, of Buckingham, parchment maker 0
4216890 2101403 2101403 defendant Aburrowe John maltster 586035 586035 Aburrowe, John, of Buckingham, maltster 1
4218344 2101913 2101913 defendant Slye John sherman 586035 586035 Slye, John, of Buckingham, sherman 0
4227111 2104957 2104957 defendant Foukes John yeoman 586035 586035 Foukes, John, of Buckingham, yeoman 2
4268922 2119201 2119201 defendant Illyng John chapman 586035 586035 Illyng, John, of Buckingham, chapman 4
4288403 2125901 2125901 defendant Wyer Robert yeoman 586035 586035 Wyer, Robert, of Buckingham, yeoman 1
4304291 2131639 2131639 defendant Elynge Walter vintner 586035 586035 Elynge, Walter, of Buckingham, vintner 1
4304292 2131639 2131639 defendant Boughton Robert glover 586035 586035 Boughton, Robert, of Buckingham, glover 2
4305420 2132038 2132038 defendant Carpenter Henry   586035 586035 Carpenter, Henry, of Buckingham, parchment maker 1
4305421 2132038 2132038 defendant Addington George yeoman 586035 586035 Addington, George, of Buckingham, yeoman 2
4306622 2132455 2132455 defendant Illynge John (legal representative) 586035 586035 Illynge, John, of Buckingham, mercer, administratrix of 0
4306623 2132455 2132455 defendant Illynge Joan widow 586035 586035 Illynge, Joan, of Buckingham, widow 1
4307168 2132642 2132642 defendant Marefeild William husbandman 586035 586035 Marefeild, William, of Buckingham, husbandman 1
4312454 2134493 2134493 defendant Sheyne Richard baker 586035 586035 Sheyne, Richard, of Buckingham, baker 0
4312457 2134494 2134494 defendant Sheyne Robert baker 586035 586035 Sheyne, Robert, of Buckingham, baker 0
4327135 2139406 2139406 defendant Thyne Robert baker 586035 586035 Thyne, Robert, of Buckingham, baker 1
4327137 2139406 2139406 defendant Sadler Edward butcher 586035 586035 Sadler, Edward, of Buckingham, butcher 3
4327166 2139413 2139413 defendant Bonam Anthony butcher 586035 586035 Bonam, Anthony, of Buckingham, butcher 1
4327167 2139413 2139413 defendant Northe Thomas butcher 586035 586035 Northe, Thomas, of Buckingham, butcher 2
4337092 2142696 2142696 defendant Lucas Thomas husbandman 586035 586035 Lucas, Thomas, of Buckingham, husbandman 0
4339928 2143738 2143738 defendant Garrett William brasier 586035 586035 Garrett, William, of Buckingham, brasier 0
4354481 2148802 2148802 defendant Bull Richard joiner 586035 586035 Bull, Richard, of Buckingham, joiner 0
4357482 2149847 2149847 defendant Okeley William mercer 586035 586035 Okeley, William, of Buckingham, mercer 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);