names

99 rows where place_id = 613865

✎ 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
3700709 1926474 1926474 defendant Gerge Thomas yeoman 613865 613865 Gerge, Thomas, of Seton, yeoman 0
3743264 1939759 1939759 plaintiff Westmerland John husbandman 613865 613865 Westmerland, John, of Seton, husbandman 0
3749283 1941706 1941706 defendant Pereson William husbandman 613865 613865 Pereson, William, of Seton, husbandman 0
3757713 1944393 1944393 defendant Hanley or Hauley Robert husbandman 613865 613865 Hanley or Hauley, Robert, of Seton, husbandman 0
3812880 1961926 1961926 defendant Sheffeld John gent 613865 613865 Sheffeld, John, of Seton, gent 0
3812881 1961926 1961926 defendant Nycollys William husbandman 613865 613865 Nycollys, William, of Seton, husbandman 1
3812883 1961927 1961927 defendant Wyllyamson John tailor 613865 613865 Wyllyamson, John, of Seton, tailor 0
3834440 1968719 1968719 defendant Delavall John   613865 613865 Delavall, John, of Seton, knight 0
3849588 1973461 1973461 defendant Mall John husbandman 613865 613865 Mall, John, of Seton, husbandman 1
3899464 1990035 1990035 defendant Gurgeyn Edward clerk 613865 613865 Gurgeyn, Edward, of Seton, clerk 0
3911995 1994336 1994336 defendant Henton Thomas yeoman 613865 613865 Henton, Thomas, of Seton, yeoman 2
3940784 2003924 2003924 defendant Burgan Edward   613865 613865 Burgan, Edward, of Seton, vicar 0
3986645 2019962 2019962 defendant Garforth John yeoman 613865 613865 Garforth, John, of Seton, yeoman 0
4439764 2181712 2181712 defendant Barne Stephen   613865 613865 Barne, Stephen, of Seton 0
4467677 2190569 2190569 defendant Taverner John   613865 613865 Taverner, John, of Seton 1
4486228 2196399 2196399 defendant Nicol John   613865 613865 Nicol, John, of Seton 2
4486593 2196519 2196519 defendant Taverner John   613865 613865 Taverner, John, of Seton 5
4490483 2197717 2197717 defendant Toweton John   613865 613865 Toweton, John, of Seton 4
4495381 2199236 2199236 defendant Gibson John   613865 613865 Gibson, John, of Seton 0
4495383 2199237 2199237 defendant Gybson John   613865 613865 Gybson, John, of Seton 0
4513428 2204619 2204619 defendant Jakson Peter   613865 613865 Jakson, Peter, of Seton 3
4538280 2212263 2212263 plaintiff Tonton John   613865 613865 Tonton, John, of Seton 0
4538284 2212264 2212264 plaintiff Tonton John   613865 613865 Tonton, John, of Seton 0
4538416 2212300 2212300 plaintiff Touton John   613865 613865 Touton, John, of Seton 0
4542067 2213410 2213410 defendant Tolle Simon   613865 613865 Tolle, Simon, of Seton 3
4552269 2216665 2216665 defendant Conestable William   613865 613865 Conestable, William, of Seton 0
4554537 2217348 2217348 defendant Rede Richard   613865 613865 (Rede, Richard, of Seton 1
4567944 2221543 2221543 defendant Tolle Simon   613865 613865 Tolle, Simon, of Seton 1
4599766 2231149 2231149 defendant Atkynson William   613865 613865 Atkynson, William, of Seton 0
4600711 2231449 2231449 defendant Lawell John   613865 613865 Lawell, John, of Seton 2
4600713 2231449 2231449 defendant Iryng John   613865 613865 Iryng, John, of Seton 4
4603217 2232214 2232214 defendant Towton John   613865 613865 Towton, John, of Seton 0
4610494 2234354 2234354 plaintiff Carter Thomas   613865 613865 Carter, Thomas, of Seton 0
4620634 2237442 2237442 defendant Watson William   613865 613865 Watson, William, of Seton 0
4631937 2240872 2240872 plaintiff Toweton Richard   613865 613865 Toweton, Richard, of Seton 0
4656022 2247765 2247765 defendant Toweton Richard chapman 613865 613865 Toweton, Richard, of Seton, chapman 1
4657249 2248153 2248153 defendant Naty John husbandman 613865 613865 Naty, John, of Seton, husbandman 0
4662854 2249843 2249843 defendant Sheffe William (legal representative) 613865 613865 Sheffe, William, of Seton, executors of 1
4664352 2250333 2250333 defendant Challey John shipman 613865 613865 Challey, John, of Seton, shipman 0
4664353 2250333 2250333 defendant Carswyll John shipman 613865 613865 Carswyll, John, of Seton, shipman 1
4664354 2250333 2250333 defendant Possebury Robert shipman 613865 613865 Possebury, Robert, of Seton, shipman 2
4664355 2250333 2250333 defendant Brende John shipman 613865 613865 Brende, John, of Seton, shipman 3
4676383 2258224 2258224 defendant Annotson William laborer 613865 613865 Annotson, William, of Seton, laborer 1
4682747 2260222 2260222 defendant Frankeleyn William butcher 613865 613865 Frankeleyn, William, of Seton, butcher 0
4741698 2278065 2278065 defendant Hoker William husbandman 613865 613865 Hoker, William, of Seton, husbandman 0
4761638 2283986 2283986 defendant Stonther John   613865 613865 Stonther, John, of Seton, wright 0
4775794 2288426 2288426 defendant Bryd Richard mariner 613865 613865 Bryd, Richard, of Seton, mariner 0
4775795 2288426 2288426 defendant Thomas Peter mariner 613865 613865 Thomas, Peter, of Seton, mariner 1
4792428 2293716 2293716 defendant Prouns Ralph yeoman 613865 613865 Prouns, Ralph, of Seton, yeoman 2
4792438 2293719 2293719 defendant Provus Ralph yeoman 613865 613865 Provus, Ralph, of Seton, yeoman 2
4817391 2301525 2301525 defendant Smyth John husbandman 613865 613865 Smyth, John, of Seton, husbandman 0
4857878 2313830 2313830 defendant Foule Robert shipman 613865 613865 Foule, Robert, of Seton, shipman 4
4868143 2317011 2317011 plaintiff Hunter Henry   613865 613865 Hunter, Henry, of Seton 0
4877140 2319813 2319813 defendant Scater Robert husbandman 613865 613865 Scater, Robert, of Seton, husbandman 3
4890184 2323700 2323700 defendant Carswell John husbandman 613865 613865 Carswell, John, of Seton, husbandman 0
4897563 2325900 2325900 defendant Coke John husbandman 613865 613865 Coke, John, of Seton, husbandman 0
4942088 2339508 2339508 defendant Tomme John husbandman 613865 613865 Tomme, John, of Seton, husbandman 0
4949295 2341765 2341765 defendant Coke John husbandman 613865 613865 Coke, John, of Seton, husbandman 2
4972836 2348813 2348813 defendant Land or Laud Richard fisher 613865 613865 Land or Laud, Richard, of Seton, fisher 0
4979372 2350794 2350794 defendant Furneaux Walter husbandman 613865 613865 Furneaux, Walter, of Seton, husbandman 0
4979373 2350794 2350794 defendant Land Richard mariner 613865 613865 Land, Richard, of Seton, mariner 1
4979374 2350794 2350794 defendant Skyttyssh John husbandman 613865 613865 Skyttyssh, John, of Seton, husbandman 2
4979375 2350794 2350794 defendant Cornyssh John husbandman 613865 613865 Cornyssh, John, of Seton, husbandman 3
4979376 2350794 2350794 defendant Furse John husbandman 613865 613865 Furse, John, of Seton, husbandman 4
4979377 2350794 2350794 defendant Hethyn Richard husbandman 613865 613865 Hethyn, Richard, of Seton, husbandman 5
4995184 2355410 2355410 defendant Lok Thomas husbandman 613865 613865 Lok, Thomas, of Seton, husbandman 3
4999590 2356752 2356752 defendant Barn John husbandman 613865 613865 Barn, John, of Seton, husbandman 5
5001873 2357448 2357448 defendant Wyllyamson John husbandman 613865 613865 Wyllyamson, John, of Seton, husbandman 0
5012427 2360484 2360484 defendant Thorneton William husbandman 613865 613865 Thorneton, William, of Seton, husbandman 2
5018573 2362316 2362316 defendant Wale William mariner 613865 613865 Wale, William, of Seton, mariner 0
5041101 2368963 2368963 defendant Carswyll John husbandman 613865 613865 Carswyll, John, of Seton, husbandman 3
5058598 2374128 2374128 defendant Beverlay Thomas   613865 613865 Beverlay, Thomas, of Seton, franklin 0
5060453 2374704 2374704 defendant Yong John husbandman 613865 613865 Yong, John, of Seton, husbandman 0
5109206 2389116 2389116 defendant Londe John mariner 613865 613865 Londe, John, of Seton, mariner 0
5159681 2403934 2403934 defendant Robynson William husbandman 613865 613865 Robynson, William, of Seton, husbandman 2
5269149 2436078 2436078 defendant Beverley John husbandman 613865 613865 Beverley, John, of Seton, husbandman 1
5269150 2436078 2436078 defendant Evererd John husbandman 613865 613865 Evererd, John, of Seton, husbandman 2
5290902 2442344 2442344 defendant Lomyn John merchant 613865 613865 Lomyn, John, of Seton, merchant 0
5305530 2446658 2446658 defendant Sparkeford John merchant 613865 613865 Sparkeford, John, of Seton, merchant 1
5305531 2446658 2446658 defendant Cosyn John merchant 613865 613865 Cosyn, John, of Seton, merchant 2
5325304 2452657 2452657 defendant Edmundson William husbandman 613865 613865 Edmundson, William, of Seton, husbandman 0
5354576 2461508 2461508 defendant Godfray Henry tailor 613865 613865 Godfray, Henry, of Seton, tailor 0
5406473 2476923 2476923 defendant Frenssh John   613865 613865 Frenssh, John, of Seton, ship carpenter 0
5419555 2480771 2480771 defendant Frenssh John   613865 613865 Frenssh, John, of Seton, ship carpenter 0
5437973 2486294 2486294 defendant Frensshe John   613865 613865 Frensshe, John, of Seton, ship's carpenter 0
5513542 2509085 2509085 defendant Berweke John esq 613865 613865 Berweke, John, of Seton, esq 2
5515659 2509742 2509742 defendant Maners John gent 613865 613865 Maners, John, of Seton, gent 0
5523716 2512246 2512246 defendant Keynys John gent 613865 613865 Keynys, John, of Seton, gent 2
5523717 2512246 2512246 defendant Baron John husbandman 613865 613865 Baron, John, of Seton, husbandman 3
5539296 2516777 2516777 defendant Thomas William   613865 613865 Thomas, William, of Seton, fish hook maker 0
5539297 2516777 2516777 defendant Taillour John husbandman 613865 613865 Taillour, John, of Seton, husbandman 1
5539298 2516777 2516777 defendant Dyer Richard fisher 613865 613865 Dyer, Richard, of Seton, fisher 2
5539299 2516777 2516777 defendant Cosyn John, senior husbandman 613865 613865 Cosyn, John, senior, of Seton, husbandman 3
5539300 2516777 2516777 defendant Redehode William husbandman 613865 613865 Redehode, William, of Seton, husbandman 4
5539301 2516777 2516777 defendant Hethyn John courser 613865 613865 Hethyn, John, of Seton, courser 5
5539302 2516777 2516777 defendant Baron John, junior fisher 613865 613865 Baron, John, junior, of Seton, fisher 6
5631036 2553715 2553715 plaintiff Andrewe Richard   613865 613865 (Andrewe, Richard, of Seton 1
5631040 2553716 2553716 plaintiff Andrewe Richard   613865 613865 (Andrewe, Richard, of Seton 1
5631045 2553717 2553717 plaintiff Andrewe Richard   613865 613865 (Andrewe, Richard, of Seton 1

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