names

144 rows where place_id = 588821

✎ 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
3595706 1866285 1866285 defendant Norwyche George husbandman 588821 588821 Norwyche, George, of Buxton, husbandman 0
3596921 1866670 1866670 plaintiff Pyktoo John clerk 588821 588821 Pyktoo, John, of Buxton, clerk 0
3630582 1904394 1904394 defendant Thomlynson Thomas husbandman 588821 588821 Thomlynson, Thomas, of Buxton, husbandman 2
3665653 1915207 1915207 defendant Wryght John yeoman 588821 588821 Wryght, John, of Buxton, yeoman 0
3684606 1921318 1921318 plaintiff Abbys Thomas, senior   588821 588821 Abbys, Thomas, senior, of Buxton 0
3685932 1921757 1921757 defendant Dewyn John husbandman 588821 588821 Dewyn, John, of Buxton, husbandman 0
3697590 1925469 1925469 defendant Roo William carpenter 588821 588821 Roo, William, of Buxton, carpenter 0
3699728 1926142 1926142 defendant Funhale John raffman 588821 588821 Funhale, John, of Buxton, raffman 1
3794405 1956126 1956126 defendant Thurkill James smith 588821 588821 Thurkill, James, of Buxton, smith 2
3819530 1963986 1963986 defendant Bronde Nicholas   588821 588821 Bronde, Nicholas, of Buxton, worsted weaver 0
3831342 1967691 1967691 defendant Abbys Thomas gent 588821 588821 (Abbys, Thomas, of Buxton, gent 1
3835516 1969047 1969047 defendant Stubbe Walter (legal representative) 588821 588821 Stubbe, Walter, of Buxton, gent, executrix of 4
3836990 1969480 1969480 plaintiff Scottowe John   588821 588821 Scottowe, John, of Buxton, worsted weaver 0
3916352 1995853 1995853 defendant Clerke Robert gent 588821 588821 Clerke, Robert, of Buxton, gent 1
3940824 2003936 2003936 defendant Sturges John gent 588821 588821 Sturges, John, of Buxton, gent 0
3940825 2003936 2003936 defendant Abbys Thomas   588821 588821 Abbys, Thomas, of Buxton, raffe man 1
3940826 2003936 2003936 defendant Funhall James   588821 588821 Funhall, James, of Buxton, worsted weaver 2
3940827 2003936 2003936 defendant Goodwyns Thomas   588821 588821 Goodwyns, Thomas, of Buxton, worsted weaver 3
3961966 2011282 2011282 defendant Abbys Walter tailor 588821 588821 Abbys, Walter, of Buxton, tailor 1
3961970 2011283 2011283 defendant Abbys of Walter tailor 588821 588821 Abbys, of Walter, of Buxton, tailor 1
3992700 2022139 2022139 defendant Marham Robert husbandman 588821 588821 Marham, Robert, of Buxton, husbandman 0
4012971 2029371 2029371 defendant Kenne Thomas husbandman 588821 588821 Kenne, Thomas, of Buxton, husbandman 1
4015233 2030140 2030140 defendant Godwyn Thomas butcher 588821 588821 Godwyn, Thomas, of Buxton, butcher 0
4015234 2030140 2030140 defendant Halle Robert tailor 588821 588821 Halle, Robert, of Buxton, tailor 1
4019955 2031867 2031867 defendant Guneld or Gunnell Thomas grocer 588821 588821 Guneld or Gunnell, Thomas, of Buxton, husbandman, or of Norwich, grocer 0
4019958 2031867 2031867 defendant Fale John (legal representative) 588821 588821 Fale, John, of Buxton, executrix of 3
4019959 2031867 2031867 defendant Fale Maud widow 588821 588821 Fale, Maud, of Buxton, widow 4
4019961 2031868 2031868 defendant Gunnell Thomas grocer 588821 588821 Gunnell, Thomas, of Buxton, husbandman, or of Norwich, grocer 0
4019964 2031868 2031868 defendant Fale John (legal representative) 588821 588821 Fale, John, of Buxton, yeoman, executrix of 3
4019965 2031868 2031868 defendant Fale Maud widow 588821 588821 Fale, Maud, of Buxton, widow 4
4021310 2032347 2032347 defendant Davye John blacksmith 588821 588821 Davye, John, of Buxton, blacksmith 3
4026359 2034069 2034069 defendant Marham Robert husbandman 588821 588821 Marham, Robert, of Buxton, husbandman 3
4042995 2039970 2039970 defendant Ponyett John husbandman 588821 588821 Ponyett, John, of Buxton, husbandman 0
4042996 2039970 2039970 defendant Crane William husbandman 588821 588821 Crane, William, of Buxton, husbandman 1
4048515 2041921 2041921 defendant Goodwyns Thomas husbandman 588821 588821 Goodwyns, Thomas, of Buxton, husbandman 1
4094778 2058468 2058468 defendant Garland Nicholas husbandman 588821 588821 Garland, Nicholas, of Buxton, husbandman 0
4101404 2060806 2060806 defendant Archer Thomas yeoman 588821 588821 Archer, Thomas, of Buxton, yeoman 0
4105471 2062234 2062234 defendant Collyer Edmund yeoman 588821 588821 Collyer, Edmund, of Buxton, yeoman 0
4111872 2064496 2064496 defendant Gonnell Thomas grocer 588821 588821 Gonnell, Thomas, of Buxton, grocer 1
4137360 2073712 2073712 defendant Gase Richard husbandman 588821 588821 Gase, Richard, of Buxton, husbandman 1
4138901 2074286 2074286 defendant Goodwyn Ralph butcher 588821 588821 Goodwyn, Ralph, of Buxton, butcher 2
4145953 2076739 2076739 defendant Marham Ralph clerk 588821 588821 Marham, Ralph, of Buxton, clerk 0
4159769 2081485 2081485 defendant Gunnell Thomas grocer 588821 588821 Gunnell, Thomas, of Buxton, grocer 1
4161775 2082186 2082186 defendant Godard William husbandman 588821 588821 Godard, William, of Buxton, husbandman 0
4166841 2083899 2083899 defendant Bennette Nicholas husbandman 588821 588821 Bennette, Nicholas, of Buxton, husbandman 1
4166842 2083899 2083899 defendant Bennette Edward husbandman 588821 588821 Bennette, Edward, of Buxton, husbandman 2
4177159 2087484 2087484 defendant Brese William husbandman 588821 588821 Brese, William, of Buxton, husbandman 1
4183048 2089553 2089553 defendant Marham Ralph clerk 588821 588821 Marham, Ralph, of Buxton, clerk 1
4200316 2095665 2095665 defendant Brese William husbandman 588821 588821 Brese, William, of Buxton, husbandman 1
4206473 2097808 2097808 defendant Goodwyns Ralph butcher 588821 588821 Goodwyns, Ralph, of Buxton, butcher 1
4208266 2098441 2098441 defendant Taylor Nicholas   588821 588821 Taylor, Nicholas, of Buxton, worsted weaver 2
4217389 2101578 2101578 defendant Jackson Roger husbandman 588821 588821 Jackson, Roger, of Buxton, husbandman 0
4217390 2101578 2101578 defendant Outfeld George husbandman 588821 588821 Outfeld, George, of Buxton, husbandman 1
4217391 2101578 2101578 defendant Downes Thomas (legal representative) 588821 588821 Downes, Thomas, of Buxton, husbandman, administratrix of 2
4217392 2101578 2101578 defendant Downes Elizabeth widow 588821 588821 Downes, Elizabeth, of Buxton, widow 3
4226586 2104775 2104775 defendant Bowlton James husbandman 588821 588821 Bowlton, James, of Buxton, husbandman 2
4243629 2110855 2110855 defendant Jackson Roger husbandman 588821 588821 Jackson, Roger, of Buxton, husbandman 0
4243630 2110855 2110855 defendant Outfeld George husbandman 588821 588821 Outfeld, George, of Buxton, husbandman 1
4243631 2110855 2110855 defendant Downes Thomas (legal representative) 588821 588821 Downes, Thomas, of Buxton, husbandman, administratrix of 2
4243632 2110855 2110855 defendant Downes Elizabeth widow 588821 588821 Downes, Elizabeth, of Buxton, widow 3
4246028 2111649 2111649 defendant Lawes Thomas singleman 588821 588821 Lawes, Thomas, of Buxton, husbandman, singleman 0
4246031 2111650 2111650 defendant Lawes Thomas singleman 588821 588821 Lawes, Thomas, of Buxton, singleman 0
4246032 2111650 2111650 defendant Kempe Robert   588821 588821 Kempe, Robert, of Buxton, wheelwright 1
4276850 2121831 2121831 defendant Fayle John husbandman 588821 588821 Fayle, John, of Buxton, husbandman 1
4294764 2128213 2128213 defendant Dakyn George husbandman 588821 588821 Dakyn, George, of Buxton, husbandman 0
4295303 2128405 2128405 defendant Bennett Richard husbandman 588821 588821 Bennett, Richard, of Buxton, husbandman 0
4299312 2129849 2129849 defendant Fearne Ralph husbandman 588821 588821 Fearne, Ralph, of Buxton, husbandman 1
4300996 2130461 2130461 defendant Heathcott William husbandman 588821 588821 Heathcott, William, of Buxton, husbandman 0
4300998 2130461 2130461 defendant Cotterell Anthony husbandman 588821 588821 Cotterell, Anthony, of Buxton, husbandman 2
4300999 2130461 2130461 defendant Cotterell Thomas husbandman 588821 588821 Cotterell, Thomas, of Buxton, husbandman 3
4311223 2134072 2134072 defendant Cornwaleys Henry, junior gent 588821 588821 Cornwaleys, Henry, junior, of Buxton, gent 1
4313456 2134814 2134814 defendant Fayle John husbandman 588821 588821 Fayle, John, of Buxton, husbandman 1
4321645 2137659 2137659 defendant Softley John beer brewer 588821 588821 Softley, John, of Buxton, beer brewer 2
4331217 2140737 2140737 defendant Goodwyn Ralph butcher 588821 588821 Goodwyn, Ralph, of Buxton, butcher 3
4333531 2141495 2141495 defendant Sostley or Softley John beer brewer 588821 588821 Sostley or Softley, John, of Buxton, beer brewer 2
4337278 2142770 2142770 defendant Heasell Hugh yeoman 588821 588821 Heasell, Hugh, of Buxton, yeoman 2
4338236 2143115 2143115 defendant Goodwyn Ralph butcher 588821 588821 Goodwyn, Ralph, of Buxton, butcher 0
4346000 2145859 2145859 defendant Topcliffe Lionel gent 588821 588821 Topcliffe, Lionel, of Buxton, gent 0
4382837 2158965 2158965 defendant Dasye William laborer 588821 588821 Dasye, William, of Buxton, laborer 2
4387385 2160426 2160426 defendant Mang or Maug William tailor 588821 588821 Mang or Maug, William, of Buxton, tailor 0
4387386 2160426 2160426 defendant Hardey Edmund   588821 588821 Hardey, Edmund, of Buxton, linen draper 1
4389328 2161058 2161058 defendant Cleaton Anthony husbandman 588821 588821 Cleaton, Anthony, of Buxton, husbandman 0
4392566 2162134 2162134 defendant Goodwyn Ralph butcher 588821 588821 Goodwyn, Ralph, of Buxton, butcher 0
4454347 2186380 2186380 defendant ryngware John   588821 588821 ryngware, John, of buxton 6
4511668 2204098 2204098 defendant Buxton John   588821 588821 Buxton, John, of Buxton 1
4574879 2223670 2223670 defendant Hobbes John   588821 588821 Hobbes, John, of Buxton 1
4581713 2225727 2225727 defendant Branston John   588821 588821 Branston, John, of Buxton 8
4586744 2227256 2227256 plaintiff Hoddys John   588821 588821 Hoddys, John, of Buxton 0
4587591 2227524 2227524 defendant Elsewich John   588821 588821 Elsewich, John, of Buxton 2
4595680 2229910 2229910 defendant Hobbys John   588821 588821 Hobbys, John, of Buxton 3
4614923 2235678 2235678 defendant Hoddys Richard   588821 588821 Hoddys, Richard, of Buxton 0
4619397 2237058 2237058 plaintiff Hoddes Richard   588821 588821 Hoddes, Richard, of Buxton 0
4624776 2238729 2238729 defendant Heddys Richard   588821 588821 Heddys, Richard, of Buxton 1
4636964 2242369 2242369 defendant Hoddys Richard   588821 588821 Hoddys, Richard, of Buxton 0
4645622 2244788 2244788 defendant Heddes Richard   588821 588821 Heddes, Richard, of Buxton 8
4661025 2249274 2249274 defendant Hoddys Richard chapman 588821 588821 Hoddys, Richard, of Buxton, chapman 0
4662927 2249868 2249868 defendant Hawes John gent 588821 588821 Hawes, John, of Buxton, gent 0
4724302 2272898 2272898 defendant Love Thomas yeoman 588821 588821 Love, Thomas, of Buxton, yeoman 0
4728000 2274003 2274003 defendant Love Thomas yeoman 588821 588821 Love, Thomas, of Buxton, yeoman 2
4742515 2278311 2278311 defendant Bolour Richard   588821 588821 Bolour, Richard, of Buxton, vicar 2

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