names

272 rows where place_id = 586060

✎ 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
3587829 1863839 1863839 defendant Grene Thomas, junior maltman 586060 586060 Grene, Thomas, junior, of Enfeld, maltman 2
3587830 1863839 1863839 defendant Hunnesdon William, junior maltman 586060 586060 Hunnesdon, William, junior, of Enfeld, maltman 3
3604534 1869083 1869083 defendant Gonstone Richard husbandman 586060 586060 Gonstone, Richard, of Enfeld, husbandman 1
3611895 1871381 1871381 defendant Hyggys Stephen chaplain 586060 586060 Hyggys, Stephen, of Enfeld, chaplain 0
3611901 1871384 1871384 defendant Hyggys Stephen chaplain 586060 586060 Hyggys, Stephen, of Enfeld, chaplain 0
3612176 1871453 1871453 defendant Bodefeld William maltman 586060 586060 Bodefeld, William, of Enfeld, maltman 0
3612177 1871453 1871453 defendant Alford William maltman 586060 586060 Alford, William, of Enfeld, maltman 1
3612178 1871453 1871453 defendant Cutte Richard tailor 586060 586060 Cutte, Richard, of Enfeld, tailor 2
3612179 1871453 1871453 defendant Barley John, junior laborer 586060 586060 Barley, John, junior, of Enfeld, laborer 3
3612180 1871453 1871453 defendant Alcok John smith 586060 586060 Alcok, John, of Enfeld, smith 4
3612181 1871453 1871453 defendant Aloft William maltman 586060 586060 Aloft, William, of Enfeld, maltman 5
3612182 1871453 1871453 defendant Curtes Thomas laborer 586060 586060 Curtes, Thomas, of Enfeld, laborer 6
3612184 1871453 1871453 defendant Thomson Alexander maltman 586060 586060 Thomson, Alexander, of Enfeld, maltman 8
3618248 1873331 1873331 defendant Hamond William husbandman 586060 586060 Hamond, William, of Enfeld, husbandman 1
3623244 1874798 1874798 defendant Monke John husbandman 586060 586060 Monke, John, of Enfeld, husbandman 1
3623245 1874798 1874798 defendant Kyng John husbandman 586060 586060 Kyng, John, of Enfeld, husbandman 2
3629161 1903991 1903991 plaintiff Cordell Richard, senior maltman 586060 586060 Cordell, Richard, senior, of Enfeld, maltman 0
3629878 1904198 1904198 defendant Borne John maltman 586060 586060 Borne, John, of Enfeld, maltman 2
3657140 1912497 1912497 defendant Marche Richard gent 586060 586060 Marche, Richard, of Enfeld, gent 1
3660783 1913638 1913638 plaintiff Hundesdone John, junior maltman 586060 586060 Hundesdone, John, junior, of Enfeld, maltman 0
3680168 1919868 1919868 defendant Alford William yeoman 586060 586060 Alford, William, of Enfeld, yeoman 0
3708147 1928847 1928847 defendant Lee Bevice husbandman 586060 586060 Lee, Bevice, of Enfeld, husbandman 0
3718292 1932006 1932006 defendant Forde Humphrey husbandman 586060 586060 Forde, Humphrey, of Enfeld, husbandman 0
3736537 1937677 1937677 defendant Carleton John gent 586060 586060 Carleton, John, of Enfeld, gent 3
3766052 1947049 1947049 plaintiff Luffe Thomas (legal representative) 586060 586060 Luffe, Thomas, of Enfeld, executor of 0
3770792 1948554 1948554 defendant Derby John maltman 586060 586060 Derby, John, of Enfeld, maltman 0
3770793 1948554 1948554 defendant Browne Anthony maltman 586060 586060 Browne, Anthony, of Enfeld, maltman 1
3776688 1950456 1950456 defendant Wales Robert gent 586060 586060 Wales, Robert, of Enfeld, gent 0
3776690 1950457 1950457 defendant Wales Robert gent 586060 586060 Wales, Robert, of Enfeld, gent 0
3776692 1950458 1950458 defendant Walet Robert gent 586060 586060 Walet, Robert, of Enfeld, gent 0
3780023 1951477 1951477 defendant Cordell Richard maltman 586060 586060 Cordell, Richard, of Enfeld, maltman 1
3794143 1956036 1956036 defendant Wales Robert gent 586060 586060 Wales, Robert, of Enfeld, gent 0
3795324 1956406 1956406 defendant Cokkys John yeoman 586060 586060 Cokkys, John, of Enfeld, yeoman 0
3795638 1956518 1956518 defendant Manners Thomas Middx, Earl of Rutland 586060 586060 Manners Thomas, of Enfeld, Middx, Earl of Rutland 2
3798807 1957541 1957541 defendant Welles Robert gent 586060 586060 Welles, Robert, of Enfeld, gent 0
3812481 1961791 1961791 defendant Cokkys John yeoman 586060 586060 Cokkys, John, of Enfeld, yeoman 3
3842308 1971139 1971139 defendant Spyttull Humphrey yeoman 586060 586060 Spyttull, Humphrey, of Enfeld, yeoman 0
3842309 1971139 1971139 defendant Spyttull John husbandman 586060 586060 Spyttull, John, of Enfeld, husbandman 1
3842310 1971139 1971139 defendant Spyttull William chaplain 586060 586060 Spyttull, William, of Enfeld, chaplain 2
3842311 1971139 1971139 defendant Spyttull Richard   586060 586060 Spyttull, Richard, of Enfeld, "sewgar" 3
3842312 1971139 1971139 defendant Spyttull Thomas laborer 586060 586060 Spyttull, Thomas, of Enfeld, laborer 4
3842313 1971139 1971139 defendant Tayler alias Wylkockys Humphrey husbandman 586060 586060 Tayler alias Wylkockys, Humphrey, of Enfeld, husbandman 5
3842314 1971139 1971139 defendant Tayler alias Wylkockys John husbandman 586060 586060 Tayler alias Wylkockys, John, of Enfeld, husbandman 6
3842317 1971139 1971139 defendant Kyrkam Thomas laborer 586060 586060 Kyrkam, Thomas, of Enfeld, laborer 9
3842318 1971139 1971139 defendant Terry William laborer 586060 586060 Terry, William, of Enfeld, laborer 10
3842320 1971140 1971140 defendant Spyttull Humphrey yeoman 586060 586060 Spyttull, Humphrey, of Enfeld, yeoman 0
3842321 1971140 1971140 defendant Spyttull John husbandman 586060 586060 Spyttull, John, of Enfeld, husbandman 1
3842322 1971140 1971140 defendant Spyttull William chaplain 586060 586060 Spyttull, William, of Enfeld, chaplain 2
3842323 1971140 1971140 defendant Spyttull Richard   586060 586060 Spyttull, Richard, of Enfeld, "sewgar" 3
3842324 1971140 1971140 defendant Spyttull Thomas laborer 586060 586060 Spyttull, Thomas, of Enfeld, laborer 4
3842325 1971140 1971140 defendant Tayler alias Wylkockys Humphrey husbandman 586060 586060 Tayler alias Wylkockys, Humphrey, of Enfeld, husbandman 5
3842326 1971140 1971140 defendant Tayler alias Wylkockys John husbandman 586060 586060 Tayler alias Wylkockys, John, of Enfeld, husbandman 6
3842329 1971140 1971140 defendant Kyrkam Thomas laborer 586060 586060 Kyrkam, Thomas, of Enfeld, laborer 9
3842330 1971140 1971140 defendant Tyrry William laborer 586060 586060 Tyrry, William, of Enfeld, laborer 10
3842332 1971141 1971141 defendant Spyttull William chaplain 586060 586060 Spyttull, William, of Enfeld, chaplain 0
3842333 1971141 1971141 defendant Spyttull Richard   586060 586060 Spyttull, Richard, of Enfeld, "sugar" 1
3842334 1971141 1971141 defendant Spyttull Thomas laborer 586060 586060 Spyttull, Thomas, of Enfeld, laborer 2
3842335 1971141 1971141 defendant Tayler alias Wylkocke Humphrey husbandman 586060 586060 Tayler alias Wylkocke, Humphrey, of Enfeld, husbandman 3
3842336 1971141 1971141 defendant Tayler alias Wylkocke John husbandman 586060 586060 Tayler alias Wylkocke, John, of Enfeld, husbandman 4
3842339 1971141 1971141 defendant Kyrkham Thomas laborer 586060 586060 Kyrkham, Thomas, of Enfeld, laborer 7
3842340 1971141 1971141 defendant Tyrry William laborer 586060 586060 Tyrry, William, of Enfeld, laborer 8
3842350 1971144 1971144 defendant Spyttull William chaplain 586060 586060 Spyttull, William, of Enfeld, chaplain 0
3842351 1971144 1971144 defendant Spyttull Richard   586060 586060 Spyttull, Richard, of Enfeld, "sugar" 1
3842352 1971144 1971144 defendant Spyttull Thomas laborer 586060 586060 Spyttull, Thomas, of Enfeld, laborer 2
3842353 1971144 1971144 defendant Tayler alias Wylkocke Humphrey husbandman 586060 586060 Tayler alias Wylkocke, Humphrey, of Enfeld, husbandman 3
3842354 1971144 1971144 defendant Tayler alias Wylkocke John husbandman 586060 586060 Tayler alias Wylkocke, John, of Enfeld, husbandman 4
3842357 1971144 1971144 defendant Kyrkham Thomas laborer 586060 586060 Kyrkham, Thomas, of Enfeld, laborer 7
3842358 1971144 1971144 defendant Tyrry William laborer 586060 586060 Tyrry, William, of Enfeld, laborer 8
3849284 1973368 1973368 defendant Wylkokkys alias Tayllour Henry husbandman 586060 586060 Wylkokkys alias Tayllour, Henry, of Enfeld, husbandman 0
3853120 1974595 1974595 plaintiff Sharpe Richard   586060 586060 Sharpe, Richard, of Enfeld 0
3854437 1975026 1975026 defendant Mondy John husbandman 586060 586060 Mondy, John, of Enfeld, husbandman 0
3862013 1977480 1977480 defendant Lee Thomas gent 586060 586060 Lee, Thomas, of Enfeld, gent 0
3862014 1977480 1977480 defendant Lee John gent 586060 586060 Lee, John, of Enfeld, gent 1
3869837 1980159 1980159 defendant Hegges William maltman 586060 586060 Hegges, William, of Enfeld, maltman 0
3879208 1983300 1983300 defendant Burne Robert laborer 586060 586060 Burne, Robert, of Enfeld, laborer 1
3879209 1983300 1983300 defendant Garret John, senior laborer 586060 586060 Garret, John, senior, of Enfeld, laborer 2
3879210 1983300 1983300 defendant Hawte William laborer 586060 586060 Hawte, William, of Enfeld, laborer 3
3879211 1983300 1983300 defendant Hamlett John laborer 586060 586060 Hamlett, John, of Enfeld, laborer 4
3879212 1983300 1983300 defendant Garret John, junior laborer 586060 586060 Garret, John, junior, of Enfeld, laborer 5
3879213 1983300 1983300 defendant Kebyll Nicholas laborer 586060 586060 Kebyll, Nicholas, of Enfeld, laborer 6
3879214 1983300 1983300 defendant Farrer John yeoman 586060 586060 Farrer, John, of Enfeld, yeoman 7
3898590 1989736 1989736 plaintiff Aston Robert husbandman 586060 586060 Aston, Robert, of Enfeld, husbandman 0
3916792 1995982 1995982 defendant Jorden John maltman 586060 586060 Jorden, John, of Enfeld, maltman 0
3922294 1997768 1997768 defendant Spencer John yeoman 586060 586060 Spencer, John, of Enfeld, yeoman 0
3930634 2000591 2000591 defendant Spytle Richard yeoman 586060 586060 Spytle, Richard, of Enfeld, yeoman 0
3963236 2011746 2011746 plaintiff Wylkynson Thomas (legal representative) 586060 586060 Wylkynson, Thomas, of Enfeld, executrix of 0
3973393 2015266 2015266 defendant Cave Mathew gent 586060 586060 Cave, Mathew, of Enfeld, gent 0
3973394 2015266 2015266 defendant Ley Richard gent 586060 586060 Ley, Richard, of Enfeld, gent 1
3977165 2016582 2016582 defendant Crabbe John yeoman 586060 586060 Crabbe, John, of Enfeld, yeoman 3
3985257 2019485 2019485 defendant Hodge John, junior yeoman 586060 586060 Hodge, John, junior, of Enfeld, yeoman 0
3999051 2024419 2024419 defendant Hodge Thomas maltman 586060 586060 Hodge, Thomas, of Enfeld, maltman 1
3999052 2024419 2024419 defendant Paxton John maltman 586060 586060 Paxton, John, of Enfeld, maltman 2
4044836 2040603 2040603 defendant Hodge John   586060 586060 Hodge, John, of Enfeld, malt carrier 2
4044842 2040605 2040605 defendant Hodge John   586060 586060 Hodge, John, of Enfeld, malt carrier 2
4082543 2054062 2054062 defendant Ley Richard gent 586060 586060 Ley, Richard, of Enfeld, gent 0
4087891 2055961 2055961 defendant Brente John mealman 586060 586060 Brente, John, of Enfeld, mealman 0
4134281 2072586 2072586 defendant Lee Richard gent 586060 586060 Lee, Richard, of Enfeld, gent 0
4173455 2086172 2086172 defendant Hunsdon Joan maltman 586060 586060 Hunsdon, Joan, of Enfeld, widow of John Hunsdon, of Beddelliscrosse or Bell Crosse, Enfelde, Middx, maltman 0
4443088 2182799 2182799 defendant Dane John   586060 586060 Dane, John, of Enfeld 3
4444426 2183237 2183237 plaintiff Cok Richard   586060 586060 Cok, Richard, of Enfeld 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);