names

44 rows where place_id = 660628

✎ 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
3957283 2009611 2009611 defendant Lyte Thomas gent 660628 660628 Lyte, Thomas, of Meryet, gent 0
4089803 2056646 2056646 defendant Mudford Elizabeth widow 660628 660628 Mudford, Elizabeth, of Meryet, widow 0
4291982 2127208 2127208 defendant Becke John husbandman 660628 660628 Becke, John, of Meryet, husbandman 1
4516359 2205525 2205525 defendant Geffray John   660628 660628 Geffray, John, of Meryet 2
4527522 2208884 2208884 defendant Pury Thomas   660628 660628 Pury, Thomas, of Meryet 0
4537087 2211870 2211870 plaintiff Stylard Hugh   660628 660628 Stylard, Hugh, of Meryet 0
4549269 2215709 2215709 defendant Golde John   660628 660628 Golde, John, of Meryet 0
4552317 2216678 2216678 defendant Sawyere William   660628 660628 Sawyere, William, of Meryet 0
4553184 2216931 2216931 defendant Pynt Adam   660628 660628 Pynt, Adam, of Meryet 0
4596535 2230153 2230153 defendant Roke John   660628 660628 Roke, John, of Meryet 7
4622273 2237947 2237947 defendant Shepherd Robert   660628 660628 Shepherd, Robert, of Meryet 0
4622473 2238010 2238010 defendant Colman John   660628 660628 Colman, John, of Meryet 3
4653437 2247006 2247006 defendant Snell or Suell William ploughman 660628 660628 Snell or Suell, William, of Meryet, ploughman 0
4668585 2255883 2255883 defendant Harry Thomas husbandman 660628 660628 Harry, Thomas, of Meryet, husbandman 4
4682221 2260061 2260061 defendant Whyvyn or Whybyn Richard clerk 660628 660628 Whyvyn or Whybyn, Richard, of Meryet, clerk 0
4682222 2260061 2260061 defendant Whyvyn Thomas husbandman 660628 660628 Whyvyn, Thomas, of Meryet, husbandman 1
4683094 2260327 2260327 plaintiff Palle Roger   660628 660628 Palle, Roger, of Meryet 0
4686650 2261436 2261436 defendant Snell Joan widow 660628 660628 Snell, Joan, of Meryet, widow 0
4686653 2261436 2261436 defendant Sawyer William draper 660628 660628 with Sawyer, William, of Meryet, draper 3
4688768 2262043 2262043 defendant Slade Matilda widow 660628 660628 Slade, Matilda, of Meryet, widow 5
4702047 2266051 2266051 defendant Beef John gent 660628 660628 Beef, John, of Meryet, gent 0
4708938 2268164 2268164 plaintiff Palle Roger   660628 660628 Palle, Roger, of Meryet 0
4734382 2275923 2275923 defendant Sokerell John, sen butcher 660628 660628 Sokerell, John, sen, of Meryet, butcher 1
4736561 2276567 2276567 defendant Hykkes Celia widow & formerly wife of John 660628 660628 Hykkes, Celia, of Meryet, widow & formerly wife of John 0
4746718 2279535 2279535 defendant Sokerell Walter husbandman 660628 660628 Sokerell, Walter, of Meryet, husbandman 1
4746719 2279535 2279535 defendant Godefray John yeoman 660628 660628 Godefray, John, of Meryet, yeoman 2
4746720 2279535 2279535 defendant Eustes Richard husbandman 660628 660628 Eustes, Richard, of Meryet, husbandman 3
4748424 2280044 2280044 defendant Pal John husbandman 660628 660628 Pal, John, of Meryet, husbandman 2
4766792 2285608 2285608 defendant Baker John husbandman 660628 660628 Baker, John, of Meryet, husbandman 0
4769145 2286326 2286326 defendant Snell Adam weaver 660628 660628 Snell, Adam, of Meryet, weaver 0
4769146 2286326 2286326 defendant Cock Humphrey weaver 660628 660628 Cock, Humphrey, of Meryet, weaver 1
4769147 2286326 2286326 defendant Polard John husbandman 660628 660628 Polard, John, of Meryet, husbandman 2
4769511 2286444 2286444 defendant Sokerell John husbandman 660628 660628 Sokerell, John, of Meryet, husbandman 1
4884861 2322163 2322163 defendant Sawyer William chapman 660628 660628 Sawyer, William, of Meryet, chapman 1
4884973 2322200 2322200 plaintiff Broom John   660628 660628 Broom, John, of Meryet 0
4933182 2336770 2336770 defendant Bele John husbandman 660628 660628 Bele, John, of Meryet, husbandman 0
5138371 2397731 2397731 defendant Daystat Richard   660628 660628 Daystat, Richard, of Meryet, shoe worker 1
5159154 2403793 2403793 defendant Daystat Richard shoemaker 660628 660628 Daystat, Richard, of Meryet, shoemaker 1
5208898 2418326 2418326 defendant Sherer Andrew   660628 660628 Sherer, Andrew, of Meryet, shoe maker 0
5289472 2441920 2441920 defendant Hastyng Henry husbandman 660628 660628 Hastyng, Henry, of Meryet, husbandman 1
5369999 2466206 2466206 defendant Paynter Thomas butcher 660628 660628 Paynter, Thomas, of Meryet, butcher 0
5467942 2495356 2495356 defendant Garland Roger husbandman 660628 660628 Garland, Roger, of Meryet, husbandman 0
5473635 2497078 2497078 defendant Garland Roger husbandman 660628 660628 Garland, Roger, of Meryet, husbandman 0
5527966 2513312 2513312 defendant Haydon Nicholas carrier 660628 660628 Haydon, Nicholas, of Meryet, carrier 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);