names

103 rows where place_id = 596482

✎ 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
3624958 1875339 1875339 defendant Hervy Stephen yeoman 596482 596482 Hervy, Stephen, of Legh, yeoman 2
3640785 1907564 1907564 defendant Smyth alias Ambros Thomas husbandman 596482 596482 Smyth alias Ambros, Thomas, of Legh, husbandman 0
3702413 1927013 1927013 defendant Willard William yeoman 596482 596482 Willard, William, of Legh, yeoman 0
3774533 1949764 1949764 defendant Garrett John husbandman 596482 596482 Garrett, John, of Legh, husbandman 0
3774534 1949764 1949764 defendant Webbe Richard laborer 596482 596482 Webbe, Richard, of Legh, laborer 1
3774535 1949764 1949764 defendant Higgott William laborer 596482 596482 Higgott, William, of Legh, laborer 2
3774536 1949764 1949764 defendant Meycok John laborer 596482 596482 Meycok, John, of Legh, laborer 3
3789271 1954462 1954462 plaintiff Tayllour John (legal representative) 596482 596482 Tayllour, John, of Legh, executor of 0
3791565 1955202 1955202 defendant Lowe Thomas husbandman 596482 596482 Lowe, Thomas, of Legh, husbandman 0
3835950 1969157 1969157 defendant Brystowe Christopher husbandman 596482 596482 Brystowe, Christopher, of Legh, husbandman 1
3838257 1969884 1969884 plaintiff Corbet Thomas esq 596482 596482 Corbet, Thomas, of Legh, esq 1
3841237 1970840 1970840 defendant Bristowe John yeoman 596482 596482 Bristowe, John, of Legh, yeoman 0
3883900 1984886 1984886 defendant Pope John yeoman 596482 596482 Pope, John, of Legh, yeoman 0
3883901 1984886 1984886 defendant Boner William mariner 596482 596482 Boner, William, of Legh, mariner 1
3883902 1984886 1984886 defendant Admere Thomas clerk 596482 596482 Admere, Thomas, of Legh, clerk 2
3884264 1985002 1985002 defendant Admer alias Rande Thomas clerk 596482 596482 Admer alias Rande, Thomas, of Legh, clerk 0
3884265 1985002 1985002 defendant Pope John yeoman 596482 596482 Pope, John, of Legh, yeoman 1
3884266 1985002 1985002 defendant Boner William mariner 596482 596482 Boner, William, of Legh, mariner 2
3884272 1985004 1985004 defendant Admer alias Rande Thomas clerk 596482 596482 Admer alias Rande, Thomas, of Legh, clerk 0
3884273 1985004 1985004 defendant Pope John yeoman 596482 596482 Pope, John, of Legh, yeoman 1
3884274 1985004 1985004 defendant Boner William mariner 596482 596482 Boner, William, of Legh, mariner 2
3888058 1986260 1986260 defendant Davys John yeoman 596482 596482 Davys, John, of Legh, yeoman 1
3969286 2013863 2013863 defendant Bonnar William, senior mariner 596482 596482 Bonnar, William, senior, of Legh, mariner 3
3969291 2013863 2013863 defendant Blake Thomas yeoman 596482 596482 Blake, Thomas, of Legh, yeoman 8
3981710 2018216 2018216 plaintiff Richard alias Legh Richard   596482 596482 Richard alias Legh, Richard, of Legh 0
3987367 2020230 2020230 defendant Davyson Thomas mariner 596482 596482 Davyson, Thomas, of Legh, or of Estwood, mariner 0
4438934 2181468 2181468 defendant Gattes William   596482 596482 Gattes, William, of Legh, son of Roger 1
4438936 2181468 2181468 defendant Cocel John   596482 596482 Cocel, John, of Legh 3
4468744 2190900 2190900 defendant Hugh Thomas   596482 596482 Hugh, Thomas, of Legh 0
4474007 2192522 2192522 defendant Haddok William   596482 596482 Haddok, William, of Legh 1
4481803 2195012 2195012 defendant Wykherst John   596482 596482 Wykherst, John, of Legh 0
4488328 2197067 2197067 plaintiff Stephen Thomas   596482 596482 Stephen, Thomas, of Legh 0
4493883 2198780 2198780 defendant Hugh Thomas   596482 596482 Hugh, Thomas, of Legh 2
4494681 2199030 2199030 defendant Claydon Thomas   596482 596482 Claydon, Thomas, of Legh 0
4505058 2202114 2202114 defendant Wykherst William, junior   596482 596482 Wykherst, William, junior, of Legh 1
4518710 2206226 2206226 defendant Rogger William   596482 596482 Rogger, William, of Legh 0
4518711 2206227 2206227 plaintiff Dorkynghole John   596482 596482 Dorkynghole, John, of Legh 0
4550740 2216173 2216173 defendant Sonnyng John   596482 596482 Sonnyng, John, of Legh 0
4602230 2231916 2231916 defendant Upton John   596482 596482 Upton, John, of Legh 0
4611609 2234695 2234695 defendant Wykherst John   596482 596482 Wykherst, John, of Legh 0
4611611 2234695 2234695 defendant Wykherst William   596482 596482 Wykherst, William, of Legh 2
4612621 2235015 2235015 defendant Orchard Robert   596482 596482 Orchard, Robert, of Legh 0
4657841 2248339 2248339 defendant Cole John, senior   596482 596482 Cole, John, senior, of Legh 2
4658156 2248430 2248430 plaintiff Corbet Thomas, junior   596482 596482 Corbet, Thomas, junior, of Legh 0
4658157 2248430 2248430 plaintiff Corbet Roger   596482 596482 Corbet, Roger, of Legh 1
4658162 2248431 2248431 plaintiff Corbet Thomas, senior   596482 596482 Corbet, Thomas, senior, of Legh 0
4755655 2282152 2282152 plaintiff Dale John   596482 596482 (Dale, John, of Legh, prior 1
4756216 2282319 2282319 defendant Derehede David husbandman 596482 596482 Derehede, David, of Legh, husbandman 0
4756511 2282402 2282402 defendant Hurn John butcher 596482 596482 Hurn, John, of Legh, butcher 1
4759850 2283415 2283415 defendant Morden Thomas gent 596482 596482 Morden, Thomas, of Legh, gent 0
4773466 2287671 2287671 plaintiff Taillour John   596482 596482 Taillour, John, of Legh 0
4778696 2289318 2289318 defendant Horn John butcher 596482 596482 Horn, John, of Legh, butcher 1
4782090 2290398 2290398 defendant Morden Thomas gent 596482 596482 Morden, Thomas, of Legh, gent 0
4782092 2290399 2290399 defendant Morden Thomas gent 596482 596482 Morden, Thomas, of Legh, gent 0
4797060 2295247 2295247 defendant Jenyn Henry butcher 596482 596482 Jenyn, Henry, of Legh, butcher 0
4800880 2296462 2296462 defendant Carter Walter laborer 596482 596482 Carter, Walter, of Legh, laborer 3
4964011 2346149 2346149 defendant Rolleston William yeoman 596482 596482 Rolleston, William, of Legh, yeoman 0
5019509 2362588 2362588 defendant Rolleston John gent 596482 596482 Rolleston, John, of Legh, gent 1
5174671 2408292 2408292 defendant Ferthyng Thomas yeoman 596482 596482 Ferthyng, Thomas, of Legh, yeoman 0
5185045 2411367 2411367 defendant Juyeler Thomas husbandman 596482 596482 Juyeler, Thomas, of Legh, husbandman 0
5185046 2411367 2411367 defendant Balle John husbandman 596482 596482 Balle, John, of Legh, husbandman 1
5204639 2417101 2417101 defendant Juyeler John husbandman 596482 596482 Juyeler, John, of Legh, husbandman 0
5204640 2417101 2417101 defendant Balle John husbandman 596482 596482 Balle, John, of Legh, husbandman 1
5209271 2418443 2418443 defendant Ferthyng Thomas yeoman 596482 596482 Ferthyng, Thomas, of Legh, yeoman 0
5221011 2421844 2421844 defendant Hatherygge John laborer 596482 596482 Hatherygge, John, of Legh, laborer 0
5240768 2427508 2427508 defendant Hatherygge John laborer 596482 596482 Hatherygge, John, of Legh, laborer 0
5250784 2430355 2430355 defendant Haslum John husbandman 596482 596482 Haslum, John, of Legh, husbandman 0
5250785 2430355 2430355 defendant Haslum William husbandman 596482 596482 Haslum, William, of Legh, husbandman 1
5250786 2430355 2430355 defendant Wagstaff Thomas husbandman 596482 596482 Wagstaff, Thomas, of Legh, husbandman 2
5250787 2430355 2430355 defendant Goodenogh Henry husbandman 596482 596482 Goodenogh, Henry, of Legh, husbandman 3
5250790 2430356 2430356 defendant Haslum John husbandman 596482 596482 Haslum, John, of Legh, husbandman 0
5250791 2430356 2430356 defendant Haslum William husbandman 596482 596482 Haslum, William, of Legh, husbandman 1
5250792 2430356 2430356 defendant Wagstaff Thomas husbandman 596482 596482 Wagstaff, Thomas, of Legh, husbandman 2
5250793 2430356 2430356 defendant Goodenogh Henry husbandman 596482 596482 Goodenogh, Henry, of Legh, husbandman 3
5280835 2439466 2439466 defendant Helot William husbandman 596482 596482 Helot, William, of Legh, husbandman 1
5307835 2447359 2447359 defendant Agecombe Peter husbandman 596482 596482 Agecombe, Peter, of Legh, husbandman 1
5330038 2454060 2454060 defendant Gybbe William husbandman 596482 596482 Gybbe, William, of Legh, husbandman 1
5330039 2454060 2454060 defendant Saunderson Thomas yeoman 596482 596482 Saunderson, Thomas, of Legh, yeoman 2
5339008 2456770 2456770 defendant Romshet Nicholas butcher 596482 596482 Romshet, Nicholas, of Legh, butcher 3
5343508 2458161 2458161 defendant Mutlowe Thomas gent 596482 596482 Mutlowe, Thomas, of Legh, gent 1
5343514 2458162 2458162 defendant Mutlowe Thomas gent 596482 596482 Mutlowe, Thomas, of Legh, gent 1
5356013 2461964 2461964 defendant Lane Thomas beer brewer 596482 596482 Lane, Thomas, of Legh, beer brewer 0
5356014 2461964 2461964 defendant Sayer Thomas waterman 596482 596482 Sayer, Thomas, of Legh, waterman 1
5372378 2466957 2466957 defendant Leukenore Walter gent 596482 596482 Leukenore, Walter, of Legh, gent 0
5372380 2466958 2466958 defendant Leukenore Walter gent 596482 596482 Leukenore, Walter, of Legh, gent 0
5389736 2472129 2472129 defendant Botell William water man 596482 596482 Botell, William, of Legh, water man 3
5425162 2482490 2482490 defendant Estdowen William husbandman 596482 596482 Estdowen, William, of Legh, husbandman 2
5491392 2502314 2502314 defendant Denham John yeoman 596482 596482 Denham, John, of Legh, yeoman 0
5495060 2503423 2503423 defendant Kynward Simon husbandman 596482 596482 Kynward, Simon, of Legh, husbandman 0
5497060 2504059 2504059 defendant Dowle Oliver yeoman 596482 596482 Dowle, Oliver, of Legh, yeoman 0
5497061 2504059 2504059 defendant Bourneham Roger laborer 596482 596482 Bourneham, Roger, of Legh, laborer 1
5512906 2508893 2508893 defendant Burstowe Robert husbandman 596482 596482 Burstowe, Robert, of Legh, husbandman 0
5519038 2510800 2510800 defendant Filkes John butcher 596482 596482 Filkes, John, of Legh, butcher 1
5519039 2510800 2510800 defendant Okeman William butcher 596482 596482 Okeman, William, of Legh, butcher 2
5522404 2511829 2511829 defendant Hervy Stephen husbandman 596482 596482 Hervy, Stephen, of Legh, husbandman 0
5525696 2512628 2512628 defendant Smyth John butcher 596482 596482 Smyth, John, of Legh, butcher 2
5575832 2527529 2527529 defendant Kynaston Thomas esq 596482 596482 Kynaston, Thomas, of Legh, esq 0
5581321 2529229 2529229 defendant Tailour John butcher 596482 596482 Tailour, John, of Legh, butcher 0
5594446 2533242 2533242 plaintiff Baysford Lawrence gent 596482 596482 Baysford, Lawrence, of Legh, gent 1
5606479 2536915 2536915 defendant Lewkenour Richard gent 596482 596482 Lewkenour, Richard, of Legh, gent 0

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