names

54 rows where place_id = 590077

✎ 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
3599805 1867584 1867584 defendant Bradney Stephen husbandman 590077 590077 Bradney, Stephen, of Hylton, husbandman 0
3608180 1870215 1870215 defendant Swynnerton Humphrey esq 590077 590077 Swynnerton, Humphrey, of Hylton, esq 0
3608727 1870392 1870392 defendant Preston Christopher esq 590077 590077 Preston, Christopher, of Hylton, esq 1
3618115 1873289 1873289 defendant Micche alias barard William husbandman 590077 590077 Micche alias barard, William, of Hylton, husbandman 0
3618117 1873289 1873289 defendant Doraunt John husbandman 590077 590077 Doraunt, John, of Hylton, husbandman 2
3626270 1903072 1903072 defendant Wetton Thomas yeoman 590077 590077 Wetton, Thomas, of Hylton, yeoman 0
3706098 1928200 1928200 defendant Egynton William husbandman 590077 590077 Egynton, William, of Hylton, husbandman 0
3737436 1937948 1937948 defendant Peler John husbandman 590077 590077 Peler, John, of Hylton, husbandman 2
3766714 1947250 1947250 defendant Bell Thomas husbandman 590077 590077 Bell, Thomas, of Hylton, husbandman 1
3810114 1961051 1961051 defendant Swynnerton Thomas esq 590077 590077 Swynnerton, Thomas, of Hylton, esq 0
3898585 1989734 1989734 defendant Hyll Roger yeoman 590077 590077 Hyll, Roger, of Hylton, yeoman 2
3917364 1996165 1996165 defendant Hollestar John husbandman 590077 590077 Hollestar, John, of Hylton, husbandman 1
3928145 1999750 1999750 defendant Mosse Thomas yeoman 590077 590077 Mosse, Thomas, of Hylton, yeoman 3
3928146 1999750 1999750 defendant Johnson John yeoman 590077 590077 Johnson, John, of Hylton, yeoman 4
3928147 1999750 1999750 defendant Herryson Lawrence yeoman 590077 590077 Herryson, Lawrence, of Hylton, yeoman 5
3928152 1999751 1999751 defendant Mosse Thomas yeoman 590077 590077 Mosse, Thomas, of Hylton, yeoman 3
3928153 1999751 1999751 defendant Johnson John yeoman 590077 590077 Johnson, John, of Hylton, yeoman 4
3959527 2010425 2010425 defendant Rampton Thomas gent 590077 590077 Rampton, Thomas, of Hylton, or of Eynesburye, gent 0
3973278 2015226 2015226 defendant Lynell Anthony yeoman 590077 590077 Lynell, Anthony, of Hylton, yeoman 3
3994454 2022770 2022770 defendant Bagott Stephen esq 590077 590077 Bagott, Stephen, of Hylton, esq 1
4012540 2029209 2029209 plaintiff Randes Thomas gent 590077 590077 Randes, Thomas, of Hylton, gent 0
4038415 2038380 2038380 defendant Sherley Thomas yeoman 590077 590077 Sherley, Thomas, of Hylton, yeoman 0
4092637 2057675 2057675 defendant Scales John husbandman 590077 590077 Scales, John, of Hylton, husbandman 0
4093020 2057817 2057817 defendant Salkeld Michael gent 590077 590077 Salkeld, Michael, of Hylton, gent 1
4095775 2058823 2058823 defendant Scales John husbandman 590077 590077 Scales, John, of Hylton, husbandman 0
4119218 2067166 2067166 defendant Duffyld Humphrey husbandman 590077 590077 Duffyld, Humphrey, of Hylton, husbandman 0
4507916 2202940 2202940 defendant Lesset John   590077 590077 Lesset, John, of Hylton 0
4566847 2221192 2221192 defendant Colet John   590077 590077 Colet, John, of Hylton 0
4837629 2307701 2307701 defendant Shirley Henry husbandman 590077 590077 Shirley, Henry, of Hylton, husbandman 1
4861221 2314876 2314876 defendant Punt John husbandman 590077 590077 Punt, John, of Hylton, husbandman 0
4894932 2325077 2325077 defendant Boteler Robert husbandman 590077 590077 Boteler, Robert, of Hylton, husbandman 5
4927137 2334922 2334922 defendant Tomlynson William husbandman 590077 590077 Tomlynson, William, of Hylton, husbandman 0
4958367 2344469 2344469 defendant Holt Nicholas husbandman 590077 590077 Holt, Nicholas, of Hylton, husbandman 1
4958961 2344648 2344648 defendant Unwyn John   590077 590077 Unwyn, John, of Hylton, wright 1
4964148 2346187 2346187 plaintiff Webbe John   590077 590077 Webbe, John, of Hylton 1
5009811 2359746 2359746 defendant Catill Thomas husbandman 590077 590077 Catill, Thomas, of Hylton, husbandman 1
5152236 2401785 2401785 defendant Mayson Richard yeoman 590077 590077 Mayson, Richard, of Hylton, yeoman 0
5292809 2442891 2442891 defendant Smyth William husbandman 590077 590077 Smyth, William, of Hylton, husbandman 0
5292810 2442891 2442891 defendant Richardson William husbandman 590077 590077 Richardson, William, of Hylton, husbandman 1
5292811 2442891 2442891 defendant Presthyk John husbandman 590077 590077 Presthyk, John, of Hylton, husbandman 2
5342134 2457737 2457737 defendant Gardyner John husbandman 590077 590077 Gardyner, John, of Hylton, husbandman 0
5342135 2457737 2457737 defendant Campyon William weaver 590077 590077 Campyon, William, of Hylton, weaver 1
5342136 2457737 2457737 defendant Inglyssh Mathew tailor 590077 590077 Inglyssh, Mathew, of Hylton, tailor 2
5342137 2457737 2457737 defendant Anfeld John husbandman 590077 590077 Anfeld, John, of Hylton, husbandman 3
5342144 2457738 2457738 defendant Gardyner John husbandman 590077 590077 Gardyner, John, of Hylton, husbandman 0
5342145 2457738 2457738 defendant Campyon William weaver 590077 590077 Campyon, William, of Hylton, weaver 1
5342146 2457738 2457738 defendant Inglyssh Mathew tailor 590077 590077 Inglyssh, Mathew, of Hylton, tailor 2
5342147 2457738 2457738 defendant Anfeld John husbandman 590077 590077 Anfeld, John, of Hylton, husbandman 3
5491465 2502329 2502329 defendant Hill Roger husbandman 590077 590077 Hill, Roger, of Hylton, husbandman 0
5581888 2529415 2529415 defendant Wetton Thomas husbandman 590077 590077 Wetton, Thomas, of Hylton, husbandman 0
5586366 2530779 2530779 defendant Burgh Robert husbandman 590077 590077 Burgh, Robert, of Hylton, husbandman 0
5592597 2532676 2532676 defendant Wetton Thomas husbandman 590077 590077 Wetton, Thomas, of Hylton, husbandman 0
5634206 2554681 2554681 defendant Ive Thomas husbandman 590077 590077 Ive, Thomas, of Hylton, husbandman 0
5634207 2554681 2554681 defendant Lucas John husbandman 590077 590077 Lucas, John, of Hylton, husbandman 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);