names

40 rows where place_id = 769035

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4554696 2217394 2217394 defendant Lynne John de   769035 769035 Lynne, John de, of Petirburgh 0
4583870 2226371 2226371 defendant Malteby Margaret   769035 769035 Malteby, Margaret, of Petirburgh 1
4732782 2275428 2275428 defendant Wyteryng Richard husbandman 769035 769035 Wyteryng, Richard, of Petirburgh, husbandman 0
4732783 2275428 2275428 defendant Trampill John husbandman 769035 769035 Trampill, John, of Petirburgh, husbandman 1
4771362 2287026 2287026 defendant Marche John tailor 769035 769035 Marche, John, of Petirburgh, tailor 0
4784138 2291037 2291037 defendant Cleypole John butcher 769035 769035 Cleypole, John, of Petirburgh, butcher 0
4839059 2308145 2308145 defendant Tyler Richard husbandman 769035 769035 Tyler, Richard, of Petirburgh, husbandman 0
4848399 2310972 2310972 plaintiff Seymour Richard   769035 769035 Seymour, Richard, of Petirburgh 0
4853619 2312548 2312548 defendant Est John butcher 769035 769035 Est, John, of Petirburgh, butcher 0
4940808 2339153 2339153 defendant Joly Thomas yeoman 769035 769035 Joly, Thomas, of Petirburgh, yeoman 1
4940809 2339153 2339153 defendant Dautre or Dantre William yeoman 769035 769035 Dautre or Dantre, William, of Petirburgh, yeoman 2
4940856 2339168 2339168 plaintiff Draper Stephen   769035 769035 Draper, Stephen, of Petirburgh 0
4950912 2342252 2342252 defendant Belde John butcher 769035 769035 Belde, John, of Petirburgh, butcher 0
4950913 2342252 2342252 defendant Belamy John husbandman 769035 769035 Belamy, John, of Petirburgh, husbandman 1
4950918 2342252 2342252 defendant Sprotburgh John fisher 769035 769035 Sprotburgh, John, of Petirburgh, fisher 6
4950926 2342255 2342255 defendant Porter William skinner 769035 769035 Porter, William, of Petirburgh, skinner 0
4950927 2342255 2342255 defendant Barker Richard husbandman 769035 769035 Barker, Richard, of Petirburgh, husbandman 1
4950928 2342255 2342255 defendant Wode William clerk 769035 769035 Wode, William, of Petirburgh, clerk 2
4955414 2343579 2343579 defendant Daventre William husbandman 769035 769035 Daventre, William, of Petirburgh, husbandman 0
4965279 2346541 2346541 defendant Chaloner William husbandman 769035 769035 Chaloner, William, of Petirburgh, husbandman 0
4986134 2352776 2352776 defendant Warrewyk John yeoman 769035 769035 Warrewyk, John, of Petirburgh, yeoman 0
4986943 2353037 2353037 defendant Belde John butcher 769035 769035 Belde, John, of Petirburgh, butcher 0
5007054 2358958 2358958 defendant Brandon William shoemaker 769035 769035 Brandon, William, of Petirburgh, shoemaker 4
5014927 2361243 2361243 defendant Beylee William butcher 769035 769035 Beylee, William, of Petirburgh, butcher 0
5020752 2362968 2362968 defendant Smyth Nicholas merchant 769035 769035 Smyth, Nicholas, of Petirburgh, merchant 0
5030145 2365686 2365686 defendant Chaloner John merchant 769035 769035 Chaloner, John, of Petirburgh, merchant 0
5030147 2365686 2365686 defendant Naferton John skinner 769035 769035 Naferton, John, of Petirburgh, skinner 2
5030148 2365686 2365686 defendant Stanfeld John laborer 769035 769035 Stanfeld, John, of Petirburgh, laborer 3
5030149 2365686 2365686 defendant Hoghok William glasier 769035 769035 Hoghok, William, of Petirburgh, glasier 4
5030387 2365760 2365760 defendant Dalle William husbandman 769035 769035 Dalle, William, of Petirburgh, husbandman 0
5030388 2365760 2365760 defendant Smyth John cordwainer 769035 769035 Smyth, John, of Petirburgh, cordwainer 1
5030389 2365760 2365760 defendant Crosse William yeoman 769035 769035 Crosse, William, of Petirburgh, yeoman 2
5030392 2365761 2365761 defendant Est John butcher 769035 769035 Est, John, of Petirburgh, butcher 0
5030396 2365761 2365761 defendant Wentbrigg John weaver 769035 769035 Wentbrigg, John, of Petirburgh, weaver 4
5030397 2365761 2365761 defendant Derneford Richard laborer 769035 769035 Derneford, Richard, of Petirburgh, laborer 5
5030398 2365761 2365761 defendant Smyth Thomas smith 769035 769035 Smyth, Thomas, of Petirburgh, smith 6
5030836 2365889 2365889 defendant Kyng William husbandman 769035 769035 Kyng, William, of Petirburgh, husbandman 0
5048055 2371042 2371042 plaintiff Per John   769035 769035 Per, John, of Petirburgh 1
5068313 2377026 2377026 defendant Sowele Richard dyer 769035 769035 Sowele, Richard, of Petirburgh, dyer 1
5069336 2377319 2377319 defendant Hopkyn John husbandman 769035 769035 Hopkyn, John, of Petirburgh, husbandman 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);