names

219 rows where place_id = 587259

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590933 1864790 1864790 defendant Tounesend Edward miller 587259 587259 Tounesend, Edward, of Thornton, miller 0
3624295 1875133 1875133 defendant Lovell Stephen husbandman 587259 587259 Lovell, Stephen, of Thornton, husbandman 2
3648026 1909784 1909784 defendant Walles Richard esq 587259 587259 Walles, Richard, of Thornton, esq 1
3648027 1909784 1909784 defendant Cleypam Thomas gent 587259 587259 Cleypam, Thomas, of Thornton, gent 2
3648037 1909785 1909785 defendant Walles Richard esq 587259 587259 Walles, Richard, of Thornton, esq 1
3648038 1909785 1909785 defendant Cleypam Thomas gent 587259 587259 Cleypam, Thomas, of Thornton, gent 2
3675176 1918268 1918268 defendant Warwyke Robert weaver 587259 587259 Warwyke, Robert, of Thornton, weaver 1
3683740 1921048 1921048 defendant Storme John yeoman 587259 587259 Storme, John, of Thornton, yeoman 2
3688838 1922668 1922668 defendant Walker Thomas laborer 587259 587259 Walker, Thomas, of Thornton, laborer 3
3715496 1931134 1931134 defendant Robynson William husbandman 587259 587259 Robynson, William, of Thornton, husbandman 0
3752094 1942577 1942577 defendant Chapman Robert husbandman 587259 587259 Chapman, Robert, of Thornton, husbandman 4
3794520 1956165 1956165 plaintiff Chapman Robert   587259 587259 Chapman, Robert, of Thornton 0
3806848 1960048 1960048 defendant Wodcroft Thomas clerk 587259 587259 Wodcroft, Thomas, of Thornton, clerk 2
3827774 1966553 1966553 defendant Lancastre James husbandman 587259 587259 Lancastre, James, of Thornton, husbandman 0
3838763 1970052 1970052 defendant Northway William husbandman 587259 587259 Northway, William, of Thornton, husbandman 0
3844419 1971805 1971805 defendant Marton Stephen husbandman 587259 587259 Marton, Stephen, of Thornton, husbandman 3
3913474 1994843 1994843 defendant Thompson James (legal representative) 587259 587259 Thompson, James, of Thornton, executors of 0
3919532 1996865 1996865 defendant Taler William husbandman 587259 587259 Taler, William, of Thornton, husbandman 0
3919533 1996865 1996865 defendant Dowrham John husbandman 587259 587259 Dowrham, John, of Thornton, husbandman 1
3919534 1996865 1996865 defendant Mawmonde William husbandman 587259 587259 Mawmonde, William, of Thornton, husbandman 2
3928242 1999781 1999781 defendant Donne John yeoman 587259 587259 Donne, John, of Thornton, yeoman 0
3938750 2003300 2003300 defendant Gooding Robert husbandman 587259 587259 Gooding, Robert, of Thornton, husbandman 2
3938751 2003300 2003300 defendant Tomson Robert husbandman 587259 587259 Tomson, Robert, of Thornton, husbandman 3
3953725 2008378 2008378 plaintiff Johnson Ralph yeoman 587259 587259 Johnson, Ralph, of Thornton, yeoman 0
3958045 2009881 2009881 defendant Fursse John yeoman 587259 587259 Fursse, John, of Thornton, yeoman 1
3960832 2010893 2010893 defendant Hopkynson John husbandman 587259 587259 Hopkynson, John, of Thornton, husbandman 0
3960833 2010893 2010893 defendant Michell Thomas husbandman 587259 587259 Michell, Thomas, of Thornton, husbandman 1
3960834 2010893 2010893 defendant Michell John husbandman 587259 587259 Michell, John, of Thornton, husbandman 2
3960835 2010893 2010893 defendant Barslowe William husbandman 587259 587259 Barslowe, William, of Thornton, husbandman 3
3960836 2010893 2010893 defendant Jewett William husbandman 587259 587259 Jewett, William, of Thornton, husbandman 4
3960837 2010893 2010893 defendant Wright Richard husbandman 587259 587259 Wright, Richard, of Thornton, husbandman 5
3960838 2010893 2010893 defendant Brokesbank Edward husbandman 587259 587259 Brokesbank, Edward, of Thornton, husbandman 6
3960839 2010893 2010893 defendant Browne Robert husbandman 587259 587259 Browne, Robert,of Thornton, husbandman 7
3960840 2010893 2010893 defendant Awmeler Thomas husbandman 587259 587259 Awmeler, Thomas, of Thornton, husbandman 8
3960841 2010893 2010893 defendant Pyhell William husbandman 587259 587259 Pyhell, William, of Thornton, husbandman 9
3960842 2010893 2010893 defendant Shorte James husbandman 587259 587259 Shorte, James, of Thornton, husbandman 10
3960843 2010893 2010893 defendant Fletcher John husbandman 587259 587259 Fletcher, John, of Thornton, husbandman 11
4012805 2029300 2029300 defendant Otelaye William yeoman 587259 587259 Otelaye, William, of Thornton, yeoman 3
4012829 2029312 2029312 plaintiff Rede Richard gent 587259 587259 Rede, Richard, of Thornton, gent 0
4026925 2034279 2034279 defendant Tempest Richard esq 587259 587259 Tempest, Richard, of Thornton, esq 0
4034102 2036859 2036859 defendant Dryver Henry husbandman 587259 587259 Dryver, Henry, of Thornton, husbandman 0
4095811 2058835 2058835 defendant Morley Augustine yeoman 587259 587259 Morley, Augustine, of Thornton, yeoman 3
4116174 2066076 2066076 defendant Pynder Thomas yeoman 587259 587259 Pynder, Thomas, of Thornton, yeoman 0
4126794 2069873 2069873 defendant Eglesfeild Anthony yeoman 587259 587259 Eglesfeild, Anthony, of Thornton, yeoman 0
4128046 2070320 2070320 defendant Dunne Cuthbert husbandman 587259 587259 Dunne, Cuthbert, of Thornton, husbandman 0
4135855 2073154 2073154 defendant Hodgeson William yeoman 587259 587259 Hodgeson, William, of Thornton, yeoman 0
4136936 2073558 2073558 defendant Hodgson Robert husbandman 587259 587259 Hodgson, Robert, of Thornton, husbandman 0
4141550 2075209 2075209 defendant Wright Edward husbandman 587259 587259 Wright, Edward, of Thornton, husbandman 0
4161247 2082015 2082015 defendant Hodgson Robert husbandman 587259 587259 Hodgson, Robert, of Thornton, husbandman 0
4162351 2082389 2082389 defendant Pynder Thomas husbandman 587259 587259 Pynder, Thomas, of Thornton, husbandman 3
4162353 2082390 2082390 defendant Watson Edward husbandman 587259 587259 Watson, Edward, of Thornton, husbandman 0
4166014 2083616 2083616 defendant Hodgeson William yeoman 587259 587259 Hodgeson, William, of Thornton, yeoman 0
4175674 2086962 2086962 defendant Bell John laborer 587259 587259 Bell, John, of Thornton, laborer 0
4175699 2086971 2086971 defendant Sergyant Benedict yeoman 587259 587259 Sergyant, Benedict, of Thornton, yeoman 0
4175700 2086971 2086971 defendant Fenton William yeoman 587259 587259 Fenton, William, of Thornton, yeoman 1
4176943 2087409 2087409 defendant Lyster Lawrence esq 587259 587259 Lyster, Lawrence, of Thornton, esq 0
4179560 2088327 2088327 defendant Sargiant Benedict husbandman 587259 587259 Sargiant, Benedict, of Thornton, or of Wotton, husbandman 0
4181537 2089022 2089022 defendant Sergean Benedict yeoman 587259 587259 Sergean, Benedict, of Thornton, yeoman 0
4181540 2089023 2089023 defendant Sergeant Benedict yeoman 587259 587259 Sergeant, Benedict, of Thornton, yeoman 0
4183659 2089771 2089771 defendant Hodgson William yeoman 587259 587259 Hodgson, William, of Thornton, yeoman 0
4185907 2090563 2090563 defendant Watson Edmund husbandman 587259 587259 Watson, Edmund, of Thornton, husbandman 1
4185916 2090564 2090564 defendant Watson Edmund husbandman 587259 587259 Watson, Edmund, of Thornton, husbandman 1
4189542 2091841 2091841 defendant Hodgeson William yeoman 587259 587259 Hodgeson, William, of Thornton, yeoman 0
4189604 2091864 2091864 defendant Hammelton Thomas husbandman 587259 587259 Hammelton, Thomas, of Thornton, husbandman 1
4213089 2100102 2100102 defendant Hodgson William husbandman 587259 587259 Hodgson, William, of Thornton, husbandman 2
4224457 2104036 2104036 defendant Scott William yeoman 587259 587259 Scott, William, of Thornton, yeoman 1
4226235 2104646 2104646 defendant Eglesfeild Anthony   587259 587259 Eglesfeild, Anthony, of Thornton 0
4232586 2106900 2106900 defendant Martyndale William yeoman 587259 587259 Martyndale, William, of Thornton, yeoman 0
4232637 2106919 2106919 defendant Scott William yeoman 587259 587259 Scott, William, of Thornton, yeoman 1
4252913 2113968 2113968 defendant Burton Thomas yeoman 587259 587259 Burton, Thomas, of Thornton, yeoman 3
4252918 2113969 2113969 defendant Burton Thomas yeoman 587259 587259 Burton, Thomas, of Thornton, yeoman 3
4275140 2121253 2121253 defendant Pennell Henry yeoman 587259 587259 (Pennell, Henry, of Thornton, yeoman 1
4280506 2123089 2123089 defendant Pickeringe William husbandman 587259 587259 Pickeringe, William, of Thornton, husbandman 3
4284371 2124459 2124459 defendant Shipton John husbandman 587259 587259 Shipton, John, of Thornton, husbandman 1
4286966 2125392 2125392 defendant Boyes Christopher butcher 587259 587259 Boyes, Christopher, of Thornton, butcher 0
4286968 2125393 2125393 defendant Boyes William butcher 587259 587259 Boyes, William, of Thornton, butcher 0
4293583 2127768 2127768 defendant Scott Robert yeoman 587259 587259 Scott, Robert, of Thornton, yeoman 0
4293833 2127863 2127863 defendant Wallys William husbandman 587259 587259 Wallys, William, of Thornton, husbandman 0
4299551 2129928 2129928 defendant Scott William yeoman 587259 587259 Scott, William, of Thornton, yeoman 0
4318622 2136625 2136625 defendant Pickering William husbandman 587259 587259 Pickering, William, of Thornton, husbandman 3
4320973 2137431 2137431 defendant Redmaine Marmaduke esq 587259 587259 Redmaine, Marmaduke, of Thornton, esq 0
4321004 2137441 2137441 defendant Millinkin Simon husbandman 587259 587259 Millinkin, Simon, of Thornton, husbandman 0
4321010 2137442 2137442 defendant Plummer Francis husbandman 587259 587259 Plummer, Francis, of Thornton, husbandman 0
4321951 2137764 2137764 defendant Hallidaye Richard husbandman 587259 587259 Hallidaye, Richard, of Thornton, husbandman 1
4335640 2142196 2142196 defendant Barwicke James gent 587259 587259 Barwicke, James, of Thornton, gent 0
4359531 2150567 2150567 defendant Tompson John husbandman 587259 587259 Tompson, John, of Thornton, husbandman 0
4367974 2153595 2153595 defendant Hudson James husbandman 587259 587259 Hudson, James, of Thornton, husbandman 0
4369929 2154298 2154298 defendant Jaques Henry husbandman 587259 587259 Jaques, Henry, of Thornton, husbandman 0
4369931 2154298 2154298 defendant Grundye William husbandman 587259 587259 Grundye, William, of Thornton, husbandman 2
4370223 2154410 2154410 defendant Hudson James yeoman 587259 587259 Hudson, James, of Thornton, yeoman 0
4387846 2160568 2160568 defendant Foxcroft William husbandman 587259 587259 Foxcroft, William, of Thornton, husbandman 0
4416551 2170039 2170039 defendant Burth John de   587259 587259 Burth, John de, of Thornton 4
4423678 2172249 2172249 defendant Hastyngs William   587259 587259 Hastyngs, William, of Thornton 0
4435262 2175786 2175786 defendant Burgh John de   587259 587259 Burgh, John de, of Thornton 4
4435758 2175927 2175927 defendant Campion Alan   587259 587259 Campion, Alan, of Thornton 2
4435759 2175927 2175927 defendant Campion Thomas   587259 587259 Campion, Thomas, of Thornton 3
4443775 2183024 2183024 plaintiff Chastelon John (legal representative) 587259 587259 Chastelon, John, of Thornton, parson, executor of 0
4443779 2183025 2183025 plaintiff Chastilon John (legal representative) 587259 587259 Chastilon, John, of Thornton, parson, executor of, 1
4450012 2184962 2184962 defendant Gayte Henry   587259 587259 Gayte, Henry, of Thornton 0
4478339 2193903 2193903 defendant Wrygh Henry   587259 587259 Wrygh, Henry, of Thornton 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);