names

98 rows where place_id = 595571

✎ 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
3621045 1874138 1874138 defendant Beddesham John husbandman 595571 595571 Beddesham, John, of Westram, husbandman 6
3676915 1918818 1918818 defendant Quytyngton Richard butcher 595571 595571 Quytyngton, Richard, of Westram, butcher 2
3679632 1919696 1919696 defendant Hartong John carpenter 595571 595571 Hartong, John, of Westram, carpenter 0
3682308 1920566 1920566 defendant Herde John butcher 595571 595571 Herde, John, of Westram, butcher 0
3682310 1920567 1920567 defendant Herde John butcher 595571 595571 Herde, John, of Westram, butcher 0
3702309 1926981 1926981 defendant Hertystong John carpenter 595571 595571 Hertystong, John, of Westram, carpenter 0
3709842 1929392 1929392 defendant Mumford William gent 595571 595571 Mumford, William, of Westram, gent 0
3759776 1945051 1945051 defendant Atwell John husbandman 595571 595571 Atwell, John, of Westram, husbandman 0
3784224 1952854 1952854 plaintiff Man John yeoman 595571 595571 Man, John, of Westram, yeoman 0
3784226 1952855 1952855 plaintiff Man John yeoman 595571 595571 Man, John, of Westram, yeoman 0
3785103 1953128 1953128 defendant Holmden John husbandman 595571 595571 Holmden, John, of Westram, husbandman 2
4015878 2030367 2030367 defendant Lutman Thomas yeoman 595571 595571 Lutman, Thomas, of Westram, yeoman 0
4129026 2070683 2070683 defendant Elfficke Thomas husbandman 595571 595571 Elfficke, Thomas, of Westram, husbandman 0
4129027 2070683 2070683 defendant Bakome Christopher husbandman 595571 595571 Bakome, Christopher, of Westram, husbandman 1
4129310 2070785 2070785 defendant Cokar John husbandman 595571 595571 Cokar, John, of Westram, husbandman 0
4129312 2070786 2070786 defendant Coker John husbandman 595571 595571 Coker, John, of Westram, husbandman 0
4466566 2190220 2190220 defendant Shilley Nicholas   595571 595571 Shilley, Nicholas, of Westram 0
4477202 2193538 2193538 defendant Gardyner John, senior   595571 595571 Gardyner, John, senior, of Westram 0
4477203 2193538 2193538 defendant Gardyner John, junior   595571 595571 Gardyner, John, junior, of Westram 1
4655302 2247546 2247546 defendant Aleyn William husbandman 595571 595571 Aleyn, William, of Westram, husbandman 0
4673314 2257291 2257291 defendant Honyter or Houyter John chaplain 595571 595571 Honyter or Houyter, John, of Westram, chaplain 0
4741483 2278005 2278005 defendant Kenvylle Robert butcher 595571 595571 Kenvylle, Robert, of Westram, butcher 2
4786576 2291853 2291853 plaintiff Garland John   595571 595571 Garland, John, of Westram 0
4884242 2321980 2321980 defendant Twyford William tanner 595571 595571 Twyford, William, of Westram, tanner 3
4907883 2329025 2329025 defendant Lynder William husbandman 595571 595571 Lynder, William, of Westram, husbandman 0
4907885 2329026 2329026 defendant Lynder William husbandman 595571 595571 Lynder, William, of Westram, husbandman 0
4946310 2340835 2340835 defendant Lyndere William husbandman 595571 595571 Lyndere, William, of Westram, husbandman 0
4958727 2344577 2344577 defendant Goldsyng Thomas miller 595571 595571 Goldsyng, Thomas, of Westram, miller 0
5061036 2374875 2374875 defendant Lynder William husbandman 595571 595571 Lynder, William, of Westram, husbandman 0
5122886 2393128 2393128 defendant Colman William husbandman 595571 595571 Colman, William, of Westram, husbandman 0
5223478 2422558 2422558 defendant Gabyll John husbandman 595571 595571 Gabyll, John, of Westram, husbandman 2
5235290 2425900 2425900 defendant Colman William tanner 595571 595571 Colman, William, of Westram, tanner 0
5281960 2439797 2439797 defendant Norwych William yeoman 595571 595571 Norwych, William, of Westram, yeoman 9
5281961 2439797 2439797 defendant Lambe John yeoman 595571 595571 Lambe, John, of Westram, yeoman 10
5281972 2439799 2439799 defendant Norwich William yeoman 595571 595571 Norwich, William, of Westram, yeoman 7
5281973 2439799 2439799 defendant Lambe John yeoman 595571 595571 Lambe, John, of Westram, yeoman 8
5281982 2439800 2439800 defendant Norwich William yeoman 595571 595571 Norwich, William, of Westram, yeoman 7
5281983 2439800 2439800 defendant Lambe John yeoman 595571 595571 Lambe, John, of Westram, yeoman 8
5315949 2449844 2449844 defendant atte Welle Richard husbandman 595571 595571 atte Welle, Richard, of Westram, husbandman 0
5325665 2452755 2452755 defendant Gilnot Thomas laborer 595571 595571 Gilnot, Thomas, of Westram, laborer 0
5326844 2453103 2453103 defendant Aleyn Thomas tanner 595571 595571 Aleyn, Thomas, of Westram, tanner 1
5326849 2453104 2453104 defendant Aleyn Thomas tanner 595571 595571 Aleyn, Thomas, of Westram, tanner 1
5352702 2460934 2460934 defendant Rodes Thomas tanner 595571 595571 Rodes, Thomas, of Westram, tanner 0
5360222 2463238 2463238 defendant Ganell or Gavell John husbandman 595571 595571 Ganell or Gavell, John, of Westram, husbandman 0
5360226 2463239 2463239 defendant Ganell or Gavell John husbandman 595571 595571 Ganell or Gavell, John, of Westram, husbandman 0
5360227 2463239 2463239 defendant Harry Thomas yeoman 595571 595571 Harry, Thomas, of Westram, yeoman 1
5360228 2463239 2463239 defendant Obberd William yeoman 595571 595571 Obberd, William, of Westram, yeoman 2
5360487 2463308 2463308 defendant Hunter John husbandman 595571 595571 Hunter, John, of Westram, husbandman 1
5371350 2466618 2466618 defendant Grey Thomas (legal representative) 595571 595571 Grey, Thomas, of Westram, baker, executors of 0
5388099 2471655 2471655 defendant Byrd John husbandman 595571 595571 Byrd, John, of Westram, husbandman 4
5389237 2471967 2471967 defendant a Dore Thomas chapman 595571 595571 (a Dore, Thomas, of Westram, chapman 1
5389238 2471967 2471967 defendant Herd John husbandman 595571 595571 Herd, John, of Westram, husbandman 2
5399543 2474950 2474950 defendant Colman William tanner 595571 595571 Colman, William, of Westram, tanner 0
5401880 2475601 2475601 defendant Grey Thomas (legal representative) 595571 595571 Grey, Thomas, of Westram, baker, executors of 1
5401881 2475601 2475601 defendant Herde John husbandman 595571 595571 (Herde, John, of Westram, husbandman 2
5401905 2475608 2475608 defendant Grey Thomas (legal representative) 595571 595571 Grey, Thomas, of Westram, baker, executors of 1
5401906 2475608 2475608 defendant Herde John husbandman 595571 595571 (Herde, John, of Westram, husbandman 2
5410823 2478186 2478186 defendant Lambe John butcher 595571 595571 Lambe, John, of Westram, husbandman, son of John Lambe, butcher 0
5410824 2478186 2478186 defendant Lambe John, sen brother of John 595571 595571 Lambe, John, sen, of Westram, yeoman, brother of John 1
5410825 2478186 2478186 defendant Petle John husbandman 595571 595571 Petle, John, of Westram, husbandman 2
5446212 2488753 2488753 defendant Lambe John   595571 595571 Lambe, John, of Westram 0
5456265 2491789 2491789 defendant Chapman Thomas husbandman 595571 595571 Chapman, Thomas, of Westram, husbandman 0
5459649 2492801 2492801 defendant Colman William husbandman 595571 595571 Colman, William, of Westram, husbandman 1
5487018 2501014 2501014 defendant Herman John, senior tanner 595571 595571 Herman, John, senior, of Westram, tanner 0
5487019 2501014 2501014 defendant Horn John husbandman 595571 595571 Horn, John, of Westram, husbandman 1
5488353 2501409 2501409 defendant Bekyn John cooper 595571 595571 Bekyn, John, of Westram, cooper 4
5488788 2501522 2501522 defendant Decon John cooper 595571 595571 Decon, John, of Westram, cooper 0
5494721 2503309 2503309 defendant Fynche John husbandman 595571 595571 Fynche, John, of Westram, husbandman 4
5504063 2506187 2506187 defendant atte Well Richard (legal representative) 595571 595571 atte Well, Richard, of Westram, husbandman, executors of 0
5504064 2506187 2506187 defendant atte Well John husbandman 595571 595571 (atte Well, John, of Westram, husbandman 1
5504065 2506187 2506187 defendant atte Well Agnes widow 595571 595571 atte Well, Agnes, of Westram, widow 2
5505315 2506572 2506572 defendant Lambe John husbandman 595571 595571 (Lambe, John, of Westram, husbandman 4
5506673 2507003 2507003 defendant Kent John husbandman 595571 595571 Kent, John, of Westram, husbandman 2
5510380 2508087 2508087 defendant Potter John, senior butcher 595571 595571 Potter, John, senior, of Westram, butcher 0
5510381 2508087 2508087 defendant Potter John, junior butcher 595571 595571 Potter, John, junior, of Westram, butcher 1
5512750 2508844 2508844 defendant Harry John husbandman 595571 595571 Harry, John, of Westram, husbandman 0
5512751 2508844 2508844 defendant Godenough William cooper 595571 595571 Godenough, William, of Westram, cooper 1
5515717 2509761 2509761 defendant Canell or Cavell Richard husbandman 595571 595571 Canell or Cavell, Richard, of Westram, husbandman 1
5515718 2509761 2509761 defendant Stacy Thomas husbandman 595571 595571 Stacy, Thomas, of Westram, husbandman 2
5515719 2509761 2509761 defendant Herry John laborer 595571 595571 Herry, John, of Westram, laborer 3
5542326 2517723 2517723 defendant Lambe John butcher 595571 595571 Lambe, John, of Westram, butcher 0
5542327 2517723 2517723 defendant Cristemas Richard miller 595571 595571 Cristemas, Richard, of Westram, miller 1
5550655 2520217 2520217 plaintiff Cavell Richard   595571 595571 Cavell, Richard, of Westram 0
5552604 2520816 2520816 defendant Faders William yeoman 595571 595571 Faders, William, of Westram, yeoman 0
5573366 2526765 2526765 defendant Marteyn John miller 595571 595571 Marteyn, John, of Westram, miller 0
5583866 2530035 2530035 defendant Maister John husbandman 595571 595571 Maister, John, of Westram, husbandman 0
5583867 2530035 2530035 defendant Gavell William yeoman 595571 595571 Gavell, William, of Westram, yeoman 1
5583868 2530035 2530035 defendant Gyllot William   595571 595571 Gyllot, William, of Westram, wax chandler 2
5590907 2532133 2532133 defendant Gavell Richard yeoman 595571 595571 Gavell, Richard, of Westram, yeoman 1
5590908 2532133 2532133 defendant Gavell William, junior yeoman 595571 595571 Gavell, William, junior, of Westram, yeoman 2
5590909 2532133 2532133 defendant Basset Nicholas sherman 595571 595571 Basset, Nicholas, of Westram, sherman 3
5590910 2532133 2532133 defendant Decon Richard tailor 595571 595571 Decon, Richard, of Westram, tailor 4
5590911 2532133 2532133 defendant Graunger John laborer 595571 595571 Graunger, John, of Westram, laborer 5
5599353 2534681 2534681 defendant Gavell Richard yeoman 595571 595571 Gavell, Richard, of Westram, yeoman 0
5599354 2534681 2534681 defendant Gavell William yeoman 595571 595571 Gavell, William, of Westram, yeoman 1
5599356 2534681 2534681 defendant Mayster Thomas yeoman 595571 595571 Mayster, Thomas, of Westram, yeoman 3
5603936 2536099 2536099 defendant Chapman William husbandman 595571 595571 Chapman, William, of Westram, husbandman 0
5635625 2555101 2555101 defendant Bright William miller 595571 595571 Bright, William, of Westram, miller 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);