names

383 rows where place_id = 589042

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596363 1866496 1866496 defendant Verdon Nicholas husbandman 589042 589042 Verdon, Nicholas, of Heydon, husbandman 0
3596365 1866496 1866496 defendant Boydon Thomas husbandman 589042 589042 Boydon, Thomas, of Heydon, husbandman 2
3603630 1868805 1868805 plaintiff Dynne John (legal representative) 589042 589042 Dynne, John, of Heydon, executors of 0
3603635 1868806 1868806 plaintiff Dynne John (legal representative) 589042 589042 Dynne, John, of Heydon, executors of 0
3603650 1868810 1868810 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3603652 1868811 1868811 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3603654 1868812 1868812 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3603656 1868813 1868813 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3603660 1868813 1868813 defendant Ryche Robert husbandman 589042 589042 Ryche, Robert, of Heydon, husbandman 3
3603663 1868814 1868814 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3605261 1869312 1869312 defendant Harrys Richard husbandman 589042 589042 Harrys, Richard, of Heydon, husbandman 2
3608301 1870254 1870254 defendant Verdon John shoemaker 589042 589042 Verdon, John, of Heydon, shoemaker 0
3608302 1870254 1870254 defendant Verdon William shoemaker 589042 589042 Verdon, William, of Heydon, shoemaker 1
3615967 1872627 1872627 defendant Goole Agnes widow 589042 589042 Goole, Agnes, of Heydon, widow 2
3616654 1872840 1872840 plaintiff Dynne John (legal representative) 589042 589042 Dynne, John, of Heydon, executors of 0
3616659 1872841 1872841 plaintiff Dynne John (legal representative) 589042 589042 Dynne, John, of Heydon, executors of 0
3616663 1872842 1872842 plaintiff Dynne John (legal representative) 589042 589042 Dynne, John, of Heydon, executors of 0
3616672 1872845 1872845 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616677 1872846 1872846 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616680 1872847 1872847 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616683 1872847 1872847 defendant Styward John husbandman 589042 589042 Styward, John, of Heydon, husbandman 2
3616685 1872848 1872848 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616687 1872849 1872849 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616690 1872850 1872850 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616691 1872850 1872850 defendant Styward John husbandman 589042 589042 Styward, John, of Heydon, husbandman 0
3616693 1872851 1872851 plaintiff Dynne Robert   589042 589042 Dynne, Robert, of Heydon 0
3616695 1872852 1872852 plaintiff Dynne Robert gent 589042 589042 Dynne, Robert, of Heydon, gent 0
3616697 1872853 1872853 plaintiff Dynne Robert gent 589042 589042 Dynne, Robert, of Heydon, gent 0
3616703 1872854 1872854 plaintiff Dynne Robert gent 589042 589042 Dynne, Robert, of Heydon, gent 0
3626727 1903205 1903205 defendant Wortys Adam husbandman 589042 589042 Wortys, Adam, of Heydon, husbandman 1
3630105 1904264 1904264 defendant Blofeld John butcher 589042 589042 Blofeld, John, of Heydon, butcher 1
3630385 1904339 1904339 defendant Cosyn Nicholas yeoman 589042 589042 Cosyn, Nicholas, of Heydon, yeoman 0
3634885 1905712 1905712 defendant Gybson William husbandman 589042 589042 Gybson, William, of Heydon, husbandman 0
3635497 1905898 1905898 defendant Auncell Robert husbandman 589042 589042 Auncell, Robert, of Heydon, husbandman 4
3636824 1906309 1906309 defendant Gybson William baker 589042 589042 Gybson, William, of Heydon, baker 4
3639296 1907101 1907101 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3647649 1909651 1909651 defendant Brette Thomas husbandman 589042 589042 Brette, Thomas, of Heydon, husbandman 0
3647651 1909652 1909652 defendant Madyse Thomas husbandman 589042 589042 Madyse, Thomas, of Heydon, husbandman 0
3648607 1909952 1909952 defendant Halle John   589042 589042 Halle, John, of Heydon, worsted weaver 6
3660156 1913436 1913436 defendant Blofeld John butcher 589042 589042 Blofeld, John, of Heydon, butcher 1
3664756 1914925 1914925 plaintiff Howlyns John   589042 589042 Howlyns, John, of Heydon 1
3692274 1923753 1923753 defendant Mason William raffman 589042 589042 Mason, William, of Heydon, raffman 1
3697892 1925563 1925563 defendant Eklyngton Robert husbandman 589042 589042 Eklyngton, Robert, of Heydon, husbandman 2
3741078 1939072 1939072 defendant Cettys John gent 589042 589042 Cettys, John, of Heydon, gent 0
3743080 1939688 1939688 plaintiff Wastenes George esq 589042 589042 Wastenes, George, of Heydon, esq 0
3755183 1943573 1943573 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3755188 1943574 1943574 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3772770 1949177 1949177 plaintiff Wastness George esq 589042 589042 Wastness, George, of Heydon, esq 0
3784484 1952932 1952932 defendant Sparke Thomas tailor 589042 589042 Sparke, Thomas, of Heydon, tailor 2
3788473 1954198 1954198 defendant Garrard John husbandman 589042 589042 Garrard, John, of Heydon, husbandman 1
3790410 1954820 1954820 plaintiff Wastness George esq 589042 589042 Wastness, George, of Heydon, esq 0
3799764 1957846 1957846 defendant Tucke Richard carpenter 589042 589042 Tucke, Richard, of Heydon, carpenter 0
3806670 1959984 1959984 plaintiff Wastenes George esq 589042 589042 Wastenes, George, of Heydon, esq 0
3806679 1959988 1959988 plaintiff Wastnes George   589042 589042 Wastnes, George, of Heydon 0
3806683 1959989 1959989 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3817517 1963383 1963383 defendant Heydon John yeoman 589042 589042 Heydon, John, of Heydon, yeoman 12
3817635 1963416 1963416 defendant Heydon John yeoman 589042 589042 Heydon, John, of Heydon, yeoman 12
3824308 1965476 1965476 plaintiff Wastenes George esq 589042 589042 Wastenes, George, of Heydon, esq 0
3824313 1965477 1965477 plaintiff Wastness George esq 589042 589042 Wastness, George, of Heydon, esq 0
3826559 1966153 1966153 defendant Myg Robert carpenter 589042 589042 Myg, Robert, of Heydon, carpenter 2
3831866 1967861 1967861 defendant Bettys John gent 589042 589042 Bettys, John, of Heydon, gent 0
3847324 1972723 1972723 defendant Glaumfilde Robert   589042 589042 Glaumfilde, Robert, of Heydon, surgeon 0
3869626 1980081 1980081 defendant Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3869627 1980082 1980082 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3869629 1980083 1980083 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3884172 1984972 1984972 defendant Colwell William husbandman 589042 589042 Colwell, William, of Heydon, husbandman 1
3885310 1985340 1985340 defendant Dynne Robert gent 589042 589042 Dynne, Robert, of Heydon, gent 1
3896943 1989192 1989192 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3896945 1989193 1989193 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3896947 1989194 1989194 plaintiff Wastnes George esq 589042 589042 Wastnes, George, of Heydon, esq 0
3899055 1989892 1989892 defendant Dynne Robert esq 589042 589042 Dynne, Robert, of Heydon, esq 0
3902550 1991086 1991086 defendant Braunche Richard husbandman 589042 589042 Braunche, Richard, of Heydon, husbandman 1
3909321 1993414 1993414 defendant Heydon Leonard clerk 589042 589042 Heydon, Leonard, of Heydon, clerk 0
3909510 1993482 1993482 defendant Heydon Leonard clerk 589042 589042 Heydon, Leonard, of Heydon, clerk 0
3914895 1995331 1995331 defendant Buller Richard gent and alderman 589042 589042 Buller, Richard, of Heydon, gent and alderman 0
3914903 1995333 1995333 defendant Buller Richard alderman 589042 589042 Buller, Richard, of Heydon, gent, alderman 0
3915083 1995401 1995401 defendant Preston Nicholas yeoman 589042 589042 Preston, Nicholas, of Heydon, yeoman 0
3915084 1995401 1995401 defendant Rysom John laborer 589042 589042 Rysom, John, of Heydon, laborer 1
3925576 1998867 1998867 defendant Welpesdale Robert smith 589042 589042 Welpesdale, Robert, of Heydon, smith 0
3944242 2005092 2005092 plaintiff Barlee William gent 589042 589042 Barlee, William, of Heydon, gent 0
3947637 2006235 2006235 defendant Bettys John gent 589042 589042 Bettys, John, of Heydon, gent 0
3950307 2007192 2007192 defendant Wysdom John husbandman 589042 589042 Wysdom, John, of Heydon, husbandman 0
3965000 2012364 2012364 defendant Bat John gent 589042 589042 Bat, John, of Heydon, gent 2
3978956 2017227 2017227 defendant Elys Geoffrey yeoman 589042 589042 Elys, Geoffrey, of Heydon, yeoman 0
3978957 2017227 2017227 defendant Hancauke Avery yeoman 589042 589042 together with Hancauke, Avery, of Heydon, yeoman 1
3991472 2021702 2021702 defendant Browne Thomas husbandman 589042 589042 Browne, Thomas, of Heydon, husbandman 1
3999126 2024448 2024448 plaintiff Fraunces Robert (legal representative) 589042 589042 Fraunces, Robert, of Heydon, husbandman, executors of 0
3999129 2024448 2024448 defendant Feilde John laborer or "rafeman" 589042 589042 Feilde, John, of Heydon, laborer or "rafeman" 0
4003169 2025893 2025893 defendant Browne Thomas husbandman 589042 589042 Browne, Thomas, of Heydon, husbandman 0
4009051 2028003 2028003 defendant Bett John gent 589042 589042 Bett, John, of Heydon, gent 0
4013818 2029673 2029673 defendant Howlyng William   589042 589042 Howlyng, William, of Heydon 0
4014473 2029901 2029901 defendant Bayley Robert husbandman 589042 589042 Bayley, Robert, of Heydon, husbandman 2
4024207 2033361 2033361 plaintiff Bett John gent 589042 589042 Bett, John, of Heydon, gent 0
4024209 2033362 2033362 plaintiff Bett John gent 589042 589042 Bett, John, of Heydon, gent 0
4053806 2043738 2043738 defendant Chapman Peter husbandman 589042 589042 Chapman, Peter, of Heydon, husbandman 3
4058047 2045258 2045258 defendant Carnaby Roger gent 589042 589042 Carnaby, Roger, of Heydon, gent 0
4058049 2045259 2045259 defendant Carnaby Roger gent 589042 589042 Carnaby, Roger, of Heydon, gent 0
4062889 2047027 2047027 defendant Downyng Andrew carpenter 589042 589042 Downyng, Andrew, of Heydon, carpenter 0
4075455 2051523 2051523 defendant Wysdome John husbandman 589042 589042 Wysdome, John, of Heydon, husbandman 1
4075459 2051524 2051524 defendant Wysdome John husbandman 589042 589042 Wysdome, John, of Heydon, husbandman 1

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