names

89 rows where place_id = 640873

✎ 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
3602412 1868414 1868414 defendant Spencer William tanner 640873 640873 Spencer, William, of Langport Estover, tanner 5
3602413 1868414 1868414 defendant Hyndon John dyer 640873 640873 Hyndon, John, of Langport Estover, dyer 6
3609205 1870540 1870540 defendant Bourne John butcher 640873 640873 Bourne, John, of Langport Estover, butcher 2
3613673 1871923 1871923 defendant Wydycombe John clothier 640873 640873 Wydycombe, John, of Langport Estover, clothier 0
3639697 1907225 1907225 defendant Barre William chaplain 640873 640873 Barre, William, of Langport Estover, chaplain 0
3639698 1907225 1907225 defendant Payne John waterman 640873 640873 Payne, John, of Langport Estover, waterman 1
3858036 1976163 1976163 defendant Yorke Richard husbandman 640873 640873 Yorke, Richard, of Langport, husbandman 0
3858037 1976163 1976163 defendant Yorke Elizabeth spinster 640873 640873 Yorke, Elizabeth, of Langport, spinster 1
3993879 2022560 2022560 defendant Rede Thomas tanner 640873 640873 Rede, Thomas, of Langport, tanner 0
4053783 2043728 2043728 defendant Rede Thomas tanner 640873 640873 Rede, Thomas, of Langport Eastover, tanner 0
4067369 2048634 2048634 plaintiff Isham John esq 640873 640873 Isham, John, of Langport, esq 0
4080336 2053278 2053278 defendant Bradrybbe Stephen yeoman 640873 640873 Bradrybbe, Stephen, of Langport, yeoman 1
4192971 2093107 2093107 defendant Wynterhaye Philip gent 640873 640873 Wynterhaye, Philip, of Langport, gent 1
4218599 2102002 2102002 defendant Dyer Thomas hosier 640873 640873 Dyer, Thomas, of Langport, hosier 0
4287074 2125431 2125431 defendant Reade Thomas tanner 640873 640873 Reade, Thomas, of Langport, tanner 0
4444036 2183104 2183104 defendant Deythere Adam   640873 640873 Deythere, Adam, of Langport 0
4462654 2189015 2189015 defendant Goldsmyth Edward   640873 640873 Goldsmyth, Edward, of Langport 1
4526938 2208708 2208708 defendant Milner John   640873 640873 Milner, John, of Langport 0
4553992 2217169 2217169 plaintiff Goldsmyth Edward (legal representative) 640873 640873 Goldsmyth, Edward, of Langport, administrator of 0
4554410 2217310 2217310 plaintiff Grey William   640873 640873 Grey, William, of Langport 0
4554412 2217311 2217311 plaintiff Grey William   640873 640873 Grey, William, of Langport 0
4582463 2225956 2225956 defendant Aylmerton Philip   640873 640873 Aylmerton, Philip, of Langport 0
4611138 2234548 2234548 defendant Hawekyn William   640873 640873 Hawekyn, William, of Langport 0
4619613 2237124 2237124 defendant Baker John   640873 640873 Baker, John, of Langport, son of Walter 0
4623109 2238205 2238205 defendant Glover Richard   640873 640873 Glover, Richard, of Langport 0
4631239 2240667 2240667 defendant Goldsmyth John   640873 640873 Goldsmyth, John, of Langport 0
4649334 2245856 2245856 defendant Benet John   640873 640873 Benet, John, of Langport 0
4657656 2248284 2248284 defendant Dyer John chaplain 640873 640873 Dyer, John, of Langport, chaplain 6
4661176 2249322 2249322 defendant York John husbandman 640873 640873 York, John, of Langport, husbandman 0
4661177 2249322 2249322 defendant Warde Thomas husbandman 640873 640873 Warde, Thomas, of Langport, husbandman 1
4661178 2249322 2249322 defendant Randolf Simon husbandman 640873 640873 Randolf, Simon, of Langport, husbandman 2
4661182 2249322 2249322 defendant Manton Henry husbandman 640873 640873 Manton, Henry, of Langport, husbandman 6
4668947 2255989 2255989 plaintiff Beux Walter   640873 640873 Beux, Walter, of Langport 0
4681311 2259782 2259782 defendant Aude John laborer 640873 640873 Aude, John, of Langport, laborer 1
4699646 2265340 2265340 defendant Smyth John chapman 640873 640873 Smyth, John, of Langport Estover, chapman 1
4702110 2266068 2266068 defendant Lyffot John husbandman 640873 640873 Lyffot, John, of Langport, husbandman 0
4702112 2266069 2266069 defendant Bolley John husbandman 640873 640873 Bolley, John, of Langport, husbandman 0
4702607 2266223 2266223 defendant Slo John skinner 640873 640873 Slo, John, of Langport, skinner 0
4702608 2266223 2266223 defendant Tooth Edward   640873 640873 Tooth, Edward, of Langport, rope maker 1
4702609 2266223 2266223 defendant Plomer Richard dyer 640873 640873 Plomer, Richard, of Langport, dyer 2
4702610 2266223 2266223 defendant Spark William tanner 640873 640873 Spark, William, of Langport, tanner 3
4703012 2266324 2266324 defendant Betfeld John   640873 640873 Betfeld, John, of Langport, bailiff 1
4705584 2267116 2267116 defendant Chynne William husbandman 640873 640873 Chynne, William, of Langport, husbandman 0
4711182 2268848 2268848 defendant Glover Richard   640873 640873 Glover, Richard, of Langport, glove maker 4
4711556 2268940 2268940 defendant Clek Robert tailor 640873 640873 Clek, Robert, of Langport, tailor 1
4722916 2272485 2272485 defendant Holton Richard dyer 640873 640873 Holton, Richard, of Langport, dyer 2
4726051 2273433 2273433 defendant Plomer Richard dyer 640873 640873 Plomer, Richard, of Langport, dyer 0
4728456 2274132 2274132 defendant Marys William fuller 640873 640873 together with Marys, William, of Langport, fuller 1
4732733 2275417 2275417 defendant Swyft John baker 640873 640873 Swyft, John, of Langport, baker 2
4763089 2284436 2284436 defendant Plomer Richard husbandman 640873 640873 Plomer, Richard, of Langport, husbandman 1
4769510 2286444 2286444 defendant Swyft John dyer 640873 640873 Swyft, John, of Langport, dyer 0
4776084 2288517 2288517 defendant Pynson Robert weaver 640873 640873 Pynson, Robert, of Langport, weaver 0
4805878 2298046 2298046 defendant Smyth Walter smith 640873 640873 Smyth, Walter, of Langport, smith 0
4808792 2298916 2298916 defendant Milner Richard milner 640873 640873 Milner, Richard, of Langport, milner 0
4812364 2299979 2299979 defendant Corset John husbandman 640873 640873 Corset, John, of Langport Westover, husbandman 1
4830462 2305559 2305559 defendant Baker John dyer 640873 640873 Baker, John, of Langport, dyer 0
4832203 2306105 2306105 defendant Wascombe John ostler 640873 640873 Wascombe, John, of Langport Estover, ostler 0
4832212 2306107 2306107 defendant Oascombe Richard husbandman 640873 640873 Oascombe, Richard, of Langport Estover, husbandman 0
4832214 2306107 2306107 defendant Baker John dyer 640873 640873 Baker, John, of Langport Estover, dyer 2
4846474 2310404 2310404 defendant Milner John   640873 640873 Milner, John, of Langport, bailiff 3
4869296 2317364 2317364 defendant Elys Thomas husbandman 640873 640873 Elys, Thomas, of Langport, husbandman 0
4869297 2317364 2317364 defendant Wile Thomas husbandman 640873 640873 Wile, Thomas, of Langport, husbandman 1
4906929 2328749 2328749 defendant Carter William husbandman 640873 640873 Carter, William, of Langport, husbandman 0
4906930 2328749 2328749 defendant Carter John, junior husbandman 640873 640873 Carter, John, junior, of Langport, husbandman 1
4906931 2328749 2328749 defendant Fayreman John husbandman 640873 640873 Fayreman, John, of Langport, husbandman 2
4906932 2328749 2328749 defendant Yorke Simon husbandman 640873 640873 Yorke, Simon, of Langport, husbandman 3
4912274 2330338 2330338 defendant Smyth Thomas   640873 640873 Smyth, Thomas, of Langport Estover 1
4919791 2332695 2332695 defendant Swyft John dyer 640873 640873 Swyft, John, of Langport Estover, dyer 1
4945487 2340566 2340566 defendant Persyvale John husbandman 640873 640873 Persyvale, John, of Langport, husbandman 0
4952252 2342641 2342641 defendant Westmore John yeoman 640873 640873 Westmore, John, of Langport Estover, yeoman 0
4952253 2342641 2342641 defendant Wastam Richard yeoman 640873 640873 Wastam, Richard, of Langport Estover, yeoman 1
4952254 2342641 2342641 defendant Samford John dyer 640873 640873 Samford, John, of Langport Estover, dyer 2
4952293 2342653 2342653 defendant Baker Walter yeoman 640873 640873 Baker, Walter, of Langport Estover, yeoman 0
4952354 2342661 2342661 defendant Elys Thomas butcher 640873 640873 Elys, Thomas, of Langport, butcher 1
4997975 2356254 2356254 defendant Persyvale John husbandman 640873 640873 Persyvale, John, of Langport, husbandman 1
5026936 2364746 2364746 plaintiff Love or Lone Richard (legal representative) 640873 640873 Love or Lone, Richard, of Langport, executor of 0
5026937 2364746 2364746 plaintiff Love or Lone Richard merchant 640873 640873 Love or Lone, Richard, of Langport, merchant 1
5114086 2390515 2390515 defendant Elys Richard butcher 640873 640873 Elys, Richard, of Langport Estover, butcher 0
5119106 2392023 2392023 defendant Ry Simon merchant 640873 640873 Ry, Simon, of Langport Estover, merchant 0
5157390 2403297 2403297 defendant Rye Simon ostler 640873 640873 Rye, Simon, of Langport Estover, ostler 0
5218756 2421212 2421212 defendant Elys Richard butcher 640873 640873 Elys, Richard, of Langport Estover, butcher 0
5240615 2427466 2427466 defendant Traynsham Thomas dyer 640873 640873 Traynsham, Thomas, of Langport Estover, dyer 0
5336595 2456011 2456011 defendant Gardener John, junior chapman 640873 640873 Gardener, John, junior, of Langport Estover, chapman 1
5380058 2469348 2469348 plaintiff Baker Thomas (legal representative) 640873 640873 Baker, Thomas, of Langport, baker, executors of 0
5525936 2512704 2512704 defendant Stille Richard yeoman 640873 640873 Stille, Richard, of Langport Estover, yeoman 0
5532135 2514594 2514594 defendant Borne William butcher 640873 640873 Borne, William, of Langport Estover, butcher 0
5616053 2548815 2548815 plaintiff Havene John   640873 640873 Havene, John, of Langport 0
5635445 2555052 2555052 defendant Welmeston William yeoman 640873 640873 Welmeston, William, of Langport, yeoman 0
5636143 2555256 2555256 defendant Boldhey John merchant 640873 640873 Boldhey, John, of Langport, merchant 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);