names

152 rows where place_id = 689060

✎ 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
4078643 2052659 2052659 defendant Taynton Richard yeoman 689060 689060 Taynton, Richard, of Lincolnshire, yeoman 3
4123755 2068795 2068795 defendant Barnard Archibald gent 689060 689060 Barnard, Archibald, of Lincolnshire, gent 2
4200613 2095774 2095774 defendant Hennedge George   689060 689060 Hennedge, George, of Lincolnshire, knight 0
4440690 2182000 2182000 defendant Welton Robert de   689060 689060 Welton, Robert de, of Lincolnshire, son of Anabel 0
4442880 2182732 2182732 defendant Hamsterlay Ivo   689060 689060 Hamsterlay, Ivo, of Lincolnshire 0
4449919 2184930 2184930 defendant Walsh William   689060 689060 Walsh, William, of Lincolnshire 3
4449925 2184931 2184931 defendant Walssh William   689060 689060 Walssh, William, of Lincolnshire 3
4451605 2185473 2185473 defendant Naveby John de (legal representative) 689060 689060 Naveby, John de, of Lincolnshire, executrix of 0
4462831 2189071 2189071 defendant atte Halle Robert   689060 689060 atte Halle, Robert, of Lincolnshire 0
4466422 2190165 2190165 defendant Thorp John   689060 689060 Thorp, John, of Lincolnshire 0
4470103 2191300 2191300 defendant Littilbury John   689060 689060 Littilbury, John, of Lincolnshire, knight 0
4478853 2194057 2194057 defendant Kernere Geoffrey clerk 689060 689060 Kernere, Geoffrey, of Lincolnshire, clerk 0
4478855 2194057 2194057 defendant Gamsoun John esq 689060 689060 Gamsoun, John, of Lincolnshire, esq 2
4485986 2196322 2196322 defendant Toup Thomas   689060 689060 Toup, Thomas, of Lincolnshire 1
4492256 2198258 2198258 defendant Gamesson John   689060 689060 Gamesson, John, of Lincolnshire 5
4492628 2198396 2198396 defendant Ham-- William esq & marshal 689060 689060 Ham--, William, of Lincolnshire, esq & marshal 4
4494921 2199097 2199097 defendant Ledes William   689060 689060 Ledes, William, of Lincolnshire 0
4495767 2199361 2199361 defendant Harecroft John   689060 689060 Harecroft, John, of Lincolnshire 0
4496075 2199448 2199448 defendant Holand John   689060 689060 Holand, John, of Lincolnshire 0
4500490 2200774 2200774 defendant Haweberkes John   689060 689060 Haweberkes, John, of Lincolnshire 2
4504506 2201967 2201967 defendant Ormesby Richard   689060 689060 Ormesby, Richard, of Lincolnshire 0
4510608 2203777 2203777 defendant Hotoft Robert chapman 689060 689060 Hotoft, Robert, of Lincolnshire, chapman 3
4510615 2203778 2203778 defendant Hotoft Robert chapman 689060 689060 Hotoft, Robert, of Lincolnshire, chapman 3
4515835 2205373 2205373 defendant Wykes William   689060 689060 Wykes, William, of Lincolnshire, knight 3
4517490 2205866 2205866 defendant Welford John   689060 689060 Welford, John, of Lincolnshire 0
4523302 2207611 2207611 defendant Stafford Thomas   689060 689060 Stafford, Thomas, of Lincolnshire 0
4523306 2207612 2207612 defendant Stafford Thomas   689060 689060 Stafford, Thomas, of Lincolnshire 0
4523307 2207612 2207612 defendant Stafford John   689060 689060 Stafford, John, of Lincolnshire 1
4523310 2207613 2207613 defendant Stafford Thomas   689060 689060 Stafford, Thomas, of Lincolnshire 0
4523311 2207613 2207613 defendant Stafford John   689060 689060 Stafford, John, of Lincolnshire 1
4524365 2207957 2207957 defendant Harecroft John   689060 689060 Harecroft, John, of Lincolnshire 0
4530367 2209784 2209784 defendant Archer Thomas   689060 689060 Archer, Thomas, of Lincolnshire 2
4531045 2209997 2209997 defendant Ormesby Richard   689060 689060 Ormesby, Richard, of Lincolnshire 0
4531095 2210004 2210004 defendant Ormesby Richard   689060 689060 Ormesby, Richard, of Lincolnshire 0
4537136 2211886 2211886 defendant Lyttelbury John   689060 689060 Lyttelbury, John, of Lincolnshire, knight 0
4540842 2213040 2213040 plaintiff White Richard   689060 689060 White, Richard, of Lincolnshire 0
4541158 2213133 2213133 defendant Eland Thomas   689060 689060 Eland, Thomas, of Lincolnshire 3
4541165 2213134 2213134 defendant Eland Thomas   689060 689060 Eland, Thomas, of Lincolnshire 3
4544339 2214139 2214139 defendant Sykylbrys Thomas   689060 689060 Sykylbrys, Thomas, of Lincolnshire 2
4544424 2214165 2214165 defendant Drax John tailor 689060 689060 Drax, John, of Lincolnshire, tailor 0
4549241 2215702 2215702 defendant Wyke William   689060 689060 Wyke, William, of Lincolnshire, knight 2
4549947 2215915 2215915 defendant Swynford Thomas   689060 689060 Swynford, Thomas, of Lincolnshire, knight 1
4549950 2215915 2215915 defendant Mounteney John   689060 689060 Mounteney, John, of Lincolnshire, knight 4
4550509 2216103 2216103 defendant Owrysby William   689060 689060 Owrysby, William, of Lincolnshire 4
4550517 2216104 2216104 defendant Feryby John   689060 689060 Feryby, John, of Lincolnshire 2
4550518 2216104 2216104 defendant Kedale John   689060 689060 Kedale, John, of Lincolnshire 3
4550519 2216104 2216104 defendant Byngham John   689060 689060 Byngham, John, of Lincolnshire 4
4550524 2216105 2216105 defendant Feryby John   689060 689060 Feryby, John, of Lincolnshire 2
4550525 2216105 2216105 defendant Keddale John   689060 689060 Keddale, John, of Lincolnshire 3
4550526 2216105 2216105 defendant Byngham John   689060 689060 Byngham, John, of Lincolnshire 4
4551561 2216427 2216427 defendant Claypole Robert clerk 689060 689060 Claypole, Robert, of Lincolnshire, clerk 0
4557492 2218279 2218279 defendant Worsoop William   689060 689060 Worsoop, William, of Lincolnshire 1
4566348 2221046 2221046 defendant Toupe John   689060 689060 Toupe, John, of Lincolnshire 0
4566483 2221085 2221085 plaintiff Stokes Walter   689060 689060 Stokes, Walter, of Lincolnshire 0
4567262 2221318 2221318 defendant Northburgh Hugh   689060 689060 Northburgh, Hugh, of Lincolnshire 1
4567270 2221319 2221319 defendant Kyng John   689060 689060 Kyng, John, of Lincolnshire 1
4572414 2222912 2222912 defendant Gybbeman Alan   689060 689060 Gybbeman, Alan, of Lincolnshire 0
4572415 2222912 2222912 defendant Cartere Robert   689060 689060 Cartere, Robert, of Lincolnshire 1
4572416 2222912 2222912 defendant Wylkynson Robert   689060 689060 Wylkynson, Robert, of Lincolnshire 2
4572549 2222949 2222949 defendant Virle Baldewyn   689060 689060 Virle, Baldewyn, of Lincolnshire 0
4572551 2222950 2222950 defendant Virle Baldwin   689060 689060 Virle, Baldwin, of Lincolnshire 0
4574401 2223525 2223525 defendant Symond John   689060 689060 Symond, John, of Lincolnshire 0
4574599 2223585 2223585 defendant Kyng John   689060 689060 Kyng, John, of Lincolnshire 3
4574605 2223586 2223586 defendant Kyng John   689060 689060 Kyng, John, of Lincolnshire 3
4575407 2223822 2223822 defendant Pope John   689060 689060 Pope, John, of Lincolnshire 1
4575408 2223822 2223822 defendant Mannyng William   689060 689060 Mannyng, William, of Lincolnshire 2
4576961 2224302 2224302 defendant Serieaunt Robert   689060 689060 Serieaunt, Robert, of Lincolnshire 1
4578200 2224677 2224677 defendant Mitford Richard   689060 689060 Mitford, Richard, of Lincolnshire 2
4578509 2224769 2224769 defendant Appulby John dealer 689060 689060 Appulby, John, of Lincolnshire, dealer 0
4579190 2224974 2224974 defendant Dencourt Robert esq 689060 689060 Dencourt, Robert, of Lincolnshire, esq 0
4579829 2225177 2225177 defendant Littilbury John   689060 689060 Littilbury, John, of Lincolnshire, knight 0
4581331 2225627 2225627 plaintiff Dryby William   689060 689060 Dryby, William, of Lincolnshire 0
4582670 2226020 2226020 defendant Olney John   689060 689060 Olney, John, of Lincolnshire 2
4582673 2226021 2226021 defendant Olney John   689060 689060 Olney, John, of Lincolnshire 1
4582947 2226092 2226092 defendant Wayn William   689060 689060 Wayn, William, of Lincolnshire 7
4590271 2228327 2228327 defendant Moreton Robert clerk 689060 689060 Moreton, Robert, of Lincolnshire, clerk 0
4590274 2228328 2228328 defendant Moreton Robert clerk 689060 689060 Moreton, Robert, of Lincolnshire, clerk 0
4593996 2229394 2229394 defendant Nichol John   689060 689060 Nichol, John, of Lincolnshire 6
4593998 2229394 2229394 defendant Mariot William   689060 689060 Mariot, William, of Lincolnshire 8
4593999 2229394 2229394 defendant Clerk William   689060 689060 Clerk, William, of Lincolnshire 9
4594002 2229394 2229394 defendant Russell John   689060 689060 Russell, John, of Lincolnshire 12
4594012 2229394 2229394 defendant Bacon John   689060 689060 Bacon, John, of Lincolnshire 22
4594652 2229582 2229582 defendant Malen Richard   689060 689060 Malen, Richard, of Lincolnshire 2
4597179 2230358 2230358 defendant Whitlambe John   689060 689060 (Whitlambe, John, of Lincolnshire 1
4597183 2230359 2230359 defendant Whitlambe John   689060 689060 (Whitlambe, John, of Lincolnshire 1
4600386 2231347 2231347 defendant atte Welle William   689060 689060 atte Welle, William, of Lincolnshire 0
4604487 2232573 2232573 plaintiff Frysney Walter   689060 689060 Frysney, Walter, of Lincolnshire 1
4605715 2232905 2232905 defendant Bradley John   689060 689060 Bradley, John, of Lincolnshire 1
4605720 2232906 2232906 defendant Bradley John   689060 689060 Bradley, John, of Lincolnshire 1
4611183 2234560 2234560 defendant Braytoft John esq 689060 689060 Braytoft, John, of Lincolnshire, son of John, esq 1
4618025 2236647 2236647 defendant Wathe Robert esq 689060 689060 Wathe, Robert, of Lincolnshire, esq 0
4621953 2237843 2237843 defendant Combe John carpenter 689060 689060 Combe, John, of Lincolnshire, carpenter 0
4624961 2238774 2238774 plaintiff Ormesby Aaron   689060 689060 Ormesby, Aaron, of Lincolnshire 0
4626253 2239171 2239171 defendant Fylingham Roger   689060 689060 Fylingham, Roger, of Lincolnshire, administrators of 0
4626254 2239171 2239171 defendant Humbreston Alan clerk 689060 689060 (Humbreston, Alan, of Lincolnshire, clerk 1
4628023 2239687 2239687 defendant Pygot Thomas   689060 689060 Pygot, Thomas, of Lincolnshire 0
4630081 2240322 2240322 defendant Retforthe Thomas   689060 689060 Retforthe, Thomas, of Lincolnshire 2
4633780 2241418 2241418 defendant Hawe Edmund   689060 689060 Hawe, Edmund, of Lincolnshire 0
4640046 2243214 2243214 defendant Sutton John esq 689060 689060 Sutton, John, of Lincolnshire, esq 1
4640049 2243214 2243214 defendant Skipwith Patrick   689060 689060 Skipwith, Patrick, of Lincolnshire 4

Next page

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