names

57 rows where place_id = 648475

✎ 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
3901775 1990817 1990817 defendant Golde John yeoman 648475 648475 Golde, John, of Martocke, yeoman 0
3920819 1997309 1997309 defendant Wylcockys William husbandman 648475 648475 Wylcockys, William, of of Martocke, husbandman 1
3930141 2000426 2000426 defendant Smeton Robert chapman 648475 648475 Smeton, Robert, of Martocke, chapman 0
3953877 2008427 2008427 defendant Arnolde Edward baker 648475 648475 Arnolde, Edward, of Martocke, baker 0
3959269 2010320 2010320 defendant Ryse Thomas husbandman 648475 648475 Ryse, Thomas, of Martocke, husbandman 0
3974747 2015735 2015735 defendant Templer Robert butcher 648475 648475 Templer, Robert, of Martocke, butcher 0
3976031 2016183 2016183 defendant Moore William shoemaker 648475 648475 Moore, William, of Martocke, shoemaker 0
3976032 2016183 2016183 defendant Master William shoemaker 648475 648475 together with Master, William, of Martocke, shoemaker 1
3995472 2023124 2023124 defendant Moore John husbandman 648475 648475 Moore, John, of Martocke, husbandman 2
3999890 2024729 2024729 defendant Napper Roger husbandman 648475 648475 Napper, Roger, of Martocke, husbandman 1
4013532 2029576 2029576 defendant Napper Thomas husbandman 648475 648475 Napper, Thomas, of Martocke, husbandman 0
4056474 2044700 2044700 plaintiff Bremell Thomas   648475 648475 Bremell, Thomas, of Martocke 0
4095125 2058586 2058586 defendant Awdley Edward shoemaker 648475 648475 Awdley, Edward, of Martocke, yeoman, or of Frome Selwood, shoemaker 0
4100548 2060521 2060521 defendant Ellesden Lawrence merchant 648475 648475 Ellesden, Lawrence, of Martocke, yeoman, or of Lyme Regis, Dorset, merchant 0
4105458 2062229 2062229 defendant Pounde Henry yeoman 648475 648475 Pounde, Henry, of Martocke, yeoman 3
4129035 2070686 2070686 defendant Jeanes or Jeaves Thomas husbandman 648475 648475 Jeanes or Jeaves, Thomas, of Martocke, husbandman 0
4129036 2070686 2070686 defendant Pounde Alexander husbandman 648475 648475 Pounde, Alexander, of Martocke, husbandman 1
4129511 2070859 2070859 defendant Pownde Alexander husbandman 648475 648475 Pownde, Alexander, of Martocke, husbandman 1
4129512 2070859 2070859 defendant Jeames Thomas husbandman 648475 648475 Jeames, Thomas, of Martocke, husbandman 2
4131141 2071455 2071455 defendant Pounde Henry yeoman 648475 648475 Pounde, Henry, of Martocke, yeoman 0
4143145 2075773 2075773 defendant Ryce John, senior husbandman 648475 648475 Ryce, John, senior, of Martocke, husbandman 0
4147360 2077215 2077215 defendant Master John husbandman 648475 648475 Master, John, of Martocke, husbandman 2
4147361 2077215 2077215 defendant Pounde Alexander husbandman 648475 648475 Pounde, Alexander, of Martocke, husbandman 3
4177403 2087569 2087569 defendant Jenes or Jeves Thomas husbandman 648475 648475 Jenes or Jeves, Thomas, of Martocke, husbandman 2
4181100 2088864 2088864 defendant More John singleman 648475 648475 More, John, of Martocke, husbandman, singleman 0
4188311 2091416 2091416 defendant Cannon John, senior husbandman 648475 648475 Cannon, John, senior, of Martocke, husbandman 0
4188312 2091416 2091416 defendant Cannon Stephen victualer 648475 648475 Cannon, Stephen, of Martocke, victualer 1
4188313 2091416 2091416 defendant Pownde Alexander husbandman 648475 648475 Pownde, Alexander, of Martocke, husbandman 2
4189860 2091952 2091952 defendant Jeanes or Geanes Thomas husbandman 648475 648475 Jeanes or Geanes, Thomas, of Martocke, husbandman 0
4189861 2091952 2091952 defendant Pownde alias Sugar Alexander husbandman 648475 648475 Pownde alias Sugar, Alexander, of Martocke, husbandman 1
4197034 2094516 2094516 defendant Rice John, senior husbandman 648475 648475 Rice, John, senior, of Martocke, husbandman 0
4200593 2095768 2095768 defendant Jeves Thomas husbandman 648475 648475 Jeves, Thomas, of Martocke, husbandman 2
4218032 2101803 2101803 defendant Laver George husbandman 648475 648475 Laver, George, of Martocke, husbandman 0
4223679 2103768 2103768 defendant Androwes alias Frye Edward yeoman 648475 648475 Androwes alias Frye, Edward, of Martocke, yeoman 0
4223681 2103769 2103769 defendant Androwes alias Frye Edward yeoman 648475 648475 Androwes alias Frye, Edward, of Martocke, yeoman 0
4223962 2103866 2103866 defendant Wythie Nicholas husbandman 648475 648475 Wythie, Nicholas, of Martocke, husbandman 0
4223963 2103866 2103866 defendant Wythie Thomas husbandman 648475 648475 Wythie, Thomas, of Martocke, husbandman 1
4226205 2104637 2104637 defendant Frye alias Androwes Thomas yeoman 648475 648475 Frye alias Androwes, Thomas, of Martocke, yeoman 0
4227689 2105166 2105166 defendant Cribbe William husbandman 648475 648475 Cribbe, William, of Martocke, husbandman 0
4237756 2108804 2108804 defendant Hillarye Thomas husbandman 648475 648475 Hillarye, Thomas, of Martocke, husbandman 0
4243370 2110774 2110774 defendant Preist Fouceus yeoman 648475 648475 Preist, Fouceus, of Martocke, yeoman 0
4249077 2112675 2112675 defendant Androwes alias Frye Edward yeoman 648475 648475 Androwes alias Frye, Edward, of Martocke, yeoman 0
4257101 2115350 2115350 defendant Lavor William yeoman 648475 648475 Lavor, William, of Martocke, yeoman 0
4289977 2126478 2126478 defendant Pulman John yeoman 648475 648475 Pulman, John, of Martocke, yeoman 0
4298600 2129605 2129605 defendant Pulman John yeoman 648475 648475 Pulman, John, of Martocke, yeoman 0
4318158 2136459 2136459 defendant Olyver John yeoman 648475 648475 Olyver, John, of Martocke, yeoman 2
4322688 2138001 2138001 defendant Wythy Thomas husbandman 648475 648475 Wythy, Thomas, of Martocke, husbandman 0
4322689 2138001 2138001 defendant Cannynge John husbandman 648475 648475 Cannynge, John, of Martocke, husbandman 1
4337191 2142734 2142734 defendant Goolde John, senior husbandman 648475 648475 Goolde, John, senior, of Martocke, husbandman 0
4359682 2150624 2150624 defendant Burnard John husbandman 648475 648475 Burnard, John, of Martocke, husbandman 0
4360626 2150969 2150969 defendant Pryste Richard yeoman 648475 648475 Pryste, Richard, of Martocke, yeoman 2
4363056 2151850 2151850 defendant Pitterd John, senior husbandman 648475 648475 Pitterd, John, senior, of Martocke, husbandman 0
4365907 2152845 2152845 defendant Burrowe Milesius yeoman 648475 648475 Burrowe, Milesius, of Martocke, yeoman 0
4376283 2156588 2156588 defendant Sansom John, senior husbandman 648475 648475 Sansom, John, senior, of Martocke, husbandman 0
4388186 2160677 2160677 defendant Balch Henry butcher 648475 648475 Balch, Henry, of Martocke, butcher 0
4400111 2164626 2164626 defendant Sansome John husbandman 648475 648475 Sansome, John, of Martocke, husbandman 0
4412792 2168873 2168873 defendant Elyver or Glyver John   648475 648475 Elyver or Glyver, John, of Martocke, "apparyter" or apparitor 0

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