names

203 rows where place_id = 602254

✎ 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
3626835 1903244 1903244 defendant Lynley Robert tailor 602254 602254 Lynley, Robert, of Hynton, or of Maidston, tailor 0
3649158 1910123 1910123 defendant Bury Henry gent 602254 602254 Bury, Henry, of Hynton, gent 0
3650822 1910620 1910620 defendant Hawwarden John smith 602254 602254 Hawwarden, John, of Hynton, smith 1
3655116 1911861 1911861 defendant Kyllynworth John yeoman 602254 602254 Kyllynworth, John, of Hynton, yeoman 0
3655118 1911862 1911862 defendant Kyllyngworth John yeoman 602254 602254 Kyllyngworth, John, of Hynton, yeoman 0
3661355 1913826 1913826 plaintiff Kyllyngworth John yeoman 602254 602254 Kyllyngworth, John, of Hynton, yeoman 0
3661948 1914027 1914027 plaintiff Lyllyngworth John yeoman 602254 602254 Lyllyngworth, John, of Hynton, yeoman 0
3673447 1917716 1917716 defendant Kyllyngworth John husbandman 602254 602254 Kyllyngworth, John, of Hynton, husbandman 0
3680645 1920024 1920024 defendant Wymarke John husbandman 602254 602254 Wymarke, John, of Hynton, husbandman 0
3684483 1921280 1921280 defendant Ferby John husbandman 602254 602254 Ferby, John, of Hynton, husbandman 1
3689922 1923006 1923006 defendant Haywardyn John smith 602254 602254 Haywardyn, John, of Hynton, smith 0
3691267 1923426 1923426 defendant Halle William husbandman 602254 602254 Halle, William, of Hynton, husbandman 0
3691268 1923426 1923426 defendant Heywarden John smith 602254 602254 Heywarden, John, of Hynton, smith 1
3701912 1926849 1926849 defendant Humfrey William husbandman 602254 602254 Humfrey, William, of Hynton, husbandman 0
3703363 1927326 1927326 defendant Fynche John husbandman 602254 602254 Fynche, John, of Hynton, husbandman 1
3705460 1927997 1927997 defendant Umfrey William husbandman 602254 602254 Umfrey, William, of Hynton, husbandman 0
3705462 1927998 1927998 defendant Umfrey William husbandman 602254 602254 Umfrey, William, of Hynton, husbandman 0
3718502 1932064 1932064 defendant Humfrey William husbandman 602254 602254 Humfrey, William, of Hynton, husbandman 1
3722780 1933391 1933391 defendant Andrewe John husbandman 602254 602254 Andrewe, John, of Hynton, husbandman 1
3722783 1933392 1933392 defendant Andrewe John husbandman 602254 602254 Andrewe, John, of Hynton, husbandman 1
3725763 1934345 1934345 defendant Bostok Roger clerk 602254 602254 Bostok, Roger, of Hynton, clerk 0
3726883 1934676 1934676 defendant Brown Robert husbandman or tailor 602254 602254 Brown, Robert, of Hynton, husbandman or tailor 4
3731606 1936112 1936112 defendant Humfrey William husbandman 602254 602254 Humfrey, William, of Hynton, husbandman 1
3740786 1938975 1938975 defendant Kyllyngworth William husbandman 602254 602254 Kyllyngworth, William, of Hynton, husbandman 0
3741696 1939268 1939268 defendant Bostok Roger clerk 602254 602254 Bostok, Roger, of Hynton, clerk 0
3757496 1944318 1944318 defendant Waren William husbandman 602254 602254 Waren, William, of Hynton, husbandman 0
3770493 1948454 1948454 defendant Humfrey William yeoman 602254 602254 Humfrey, William, of Hynton, yeoman 1
3774921 1949888 1949888 defendant Waren William yeoman 602254 602254 Waren, William, of Hynton, yeoman 0
3775436 1950062 1950062 defendant Waren William husbabndman 602254 602254 Waren, William, of Hynton, husbabndman 0
3776358 1950356 1950356 defendant Kyllyngworth William husbandman 602254 602254 Kyllyngworth, William, of Hynton, husbandman 0
3778711 1951058 1951058 defendant Kyllyngworth William husbandman 602254 602254 Kyllyngworth, William, of Hynton, husbandman 0
3778712 1951058 1951058 defendant Pappeworth John husbandman 602254 602254 Pappeworth, John, of Hynton, husbandman 1
3786131 1953454 1953454 defendant Waren William husbandman 602254 602254 Waren, William, of Hynton, husbandman 0
3787093 1953758 1953758 defendant Hall William husbandman 602254 602254 Hall, William, of Hynton, husbandman 2
3789506 1954543 1954543 defendant Denyes William   602254 602254 Denyes, William, of Hynton, knight 0
3802509 1958679 1958679 defendant Waren William yeoman 602254 602254 Waren, William, of Hynton, yeoman 0
3817268 1963312 1963312 defendant Umfrey William husbandman 602254 602254 Umfrey, William, of Hynton, husbandman 0
3817608 1963411 1963411 defendant Stone James husbandman 602254 602254 Stone, James, of Hynton, husbandman 3
3830473 1967409 1967409 defendant Waren William husbandman 602254 602254 Waren, William, of Hynton, husbandman 0
3835348 1968994 1968994 defendant Galler John husbandman 602254 602254 Galler, John, of Hynton, husbandman 0
3835349 1968994 1968994 defendant Palmer Thomas husbandman 602254 602254 Palmer, Thomas, of Hynton, husbandman 1
3840269 1970526 1970526 defendant Horne William husbandman 602254 602254 Horne, William, of Hynton, husbandman 0
3840270 1970526 1970526 defendant Fryer John husbandman 602254 602254 Fryer, John, of Hynton, husbandman 1
3840271 1970526 1970526 defendant Clutterbuk John husbandman 602254 602254 Clutterbuk, John, of Hynton, husbandman 2
3840272 1970526 1970526 defendant Bayly John husbandman 602254 602254 Bayly, John, of Hynton, husbandman 3
3840273 1970526 1970526 defendant Horne Richard husbandman 602254 602254 Horne, Richard, of Hynton, husbandman 4
3842888 1971309 1971309 defendant Dyer John husbandman 602254 602254 Dyer, John, of Hynton, husbandman 1
3847511 1972788 1972788 defendant Mercer William husbandman 602254 602254 Mercer, William, of Hynton, husbandman 0
3853385 1974682 1974682 defendant Horne Thomas husbandman 602254 602254 Horne, Thomas, of Hynton, husbandman 0
3859074 1976525 1976525 defendant Atwoode John husbandman 602254 602254 Atwoode, John, of Hynton, husbandman 4
3859076 1976526 1976526 defendant Cloterboke John husbandman 602254 602254 Cloterboke, John, of Hynton, husbandman 0
3872415 1980997 1980997 defendant Bowde John husbandman 602254 602254 Bowde, John, of Hynton, husbandman 1
3873288 1981283 1981283 defendant Dyer John husbandman 602254 602254 Dyer, John, of Hynton, husbandman 1
3878130 1982934 1982934 defendant Norton Richard husbandman 602254 602254 Norton, Richard, of Hynton, husbandman 0
3889159 1986610 1986610 defendant Ferrys Nicholas husbandman 602254 602254 Ferrys, Nicholas, of Hynton, husbandman 0
3898338 1989655 1989655 plaintiff Andrewe Agnes (legal representative) 602254 602254 Andrewe, Agnes, of Hynton, widow, executor of 0
3898340 1989655 1989655 defendant Rydley William husbandman 602254 602254 Rydley, William, of Hynton, husbandman 0
3898341 1989655 1989655 defendant Redman John yeoman 602254 602254 Redman, John, of Hynton, yeoman 1
3912251 1994426 1994426 defendant Atkynson Robert laborer 602254 602254 Atkynson, Robert, of Hynton, laborer 0
3912253 1994427 1994427 defendant Lorkyn Robert laborer 602254 602254 Lorkyn, Robert, of Hynton, laborer 0
3912255 1994428 1994428 defendant Parneby John husbandman 602254 602254 Parneby, John, of Hynton, husbandman 0
3912256 1994428 1994428 defendant Rydley William husbandman 602254 602254 Rydley, William, of Hynton, husbandman 1
3927699 1999601 1999601 defendant Gallett John husbandman 602254 602254 Gallett, John, of Hynton, husbandman 3
3927700 1999601 1999601 defendant Whytney David laborer 602254 602254 Whytney, David, of Hynton, laborer 4
3932570 2001181 2001181 defendant Austen alais Farman John husbandman 602254 602254 Austen alais Farman, John, of Hynton, husbandman 0
3952012 2007768 2007768 defendant Kyllyngworth Thomas (legal representative) 602254 602254 Kyllyngworth, Thomas, of Hynton, husbandman, executors of 0
3952013 2007768 2007768 defendant Smythe George yeoman 602254 602254 (Smythe, George, of Hynton, yeoman 1
3965163 2012425 2012425 defendant Powell John clerk 602254 602254 Powell, John, of Hynton, clerk 0
3966173 2012798 2012798 defendant ap rees Griffin John yeoman 602254 602254 ap rees, Griffin John, of Hynton, yeoman 2
3977895 2016842 2016842 defendant Gardener John tailor 602254 602254 Gardener, John, of Hynton, tailor 0
3987726 2020359 2020359 defendant Vavasore William gent 602254 602254 Vavasore, William, of Hynton, gent 0
3988343 2020578 2020578 plaintiff ap Parry Thomas ap Rice gent 602254 602254 ap Parry, Thomas ap Rice, of Hynton, gent 0
4010617 2028568 2028568 defendant Aparry Thomas ap Reese gent 602254 602254 Aparry, Thomas ap Reese, of Hynton, gent 2
4051499 2042954 2042954 defendant Nornecott Miles   602254 602254 Nornecott, Miles, of Hynton, yeoman, administrators of 0
4055667 2044414 2044414 defendant Whattle alias Wheatley Francis yeoman 602254 602254 Whattle alias Wheatley, Francis, of Hynton, yeoman 1
4066969 2048483 2048483 plaintiff Huls John gent 602254 602254 Huls, John, of Hynton, gent 0
4073761 2050906 2050906 defendant Vaughan William gent 602254 602254 Vaughan, William, of Hynton, gent 0
4107871 2063092 2063092 defendant Vaughan William gent 602254 602254 Vaughan, William, of Hynton, gent 0
4107873 2063093 2063093 defendant Vaughan William gent 602254 602254 Vaughan, William, of Hynton, gent 0
4110106 2063876 2063876 defendant Packer James gent 602254 602254 Packer, James, of Hynton, gent 0
4115862 2065956 2065956 defendant Vaughan William gent 602254 602254 Vaughan, William, of Hynton, gent 0
4115863 2065956 2065956 defendant Mylehunte Thomas yeoman 602254 602254 Mylehunte, Thomas, of Hynton, yeoman 1
4127853 2070250 2070250 defendant Barker Roland gent 602254 602254 Barker, Roland, of Hynton, gent 2
4167403 2084099 2084099 defendant Smythe John smith 602254 602254 Smythe, John, of Hynton, smith 0
4167464 2084118 2084118 defendant Mylehunt Thomas gent 602254 602254 Mylehunt, Thomas, of Hynton, gent 0
4167466 2084119 2084119 defendant Pryce James gent 602254 602254 Pryce, James, of Hynton, gent 0
4167468 2084120 2084120 defendant Powell John yeoman 602254 602254 Powell, John, of Hynton, yeoman 0
4208165 2098410 2098410 defendant Barker Richard gent 602254 602254 Barker, Richard, of Hynton, gent 1
4233372 2107185 2107185 defendant Harris Thomas husbandman 602254 602254 Harris, Thomas, of Hynton, husbandman 2
4234936 2107769 2107769 defendant Bowles Thomas yeoman 602254 602254 Bowles, Thomas, of Hynton, yeoman 1
4284594 2124539 2124539 defendant Bradeley John gent 602254 602254 Bradeley, John, of Hynton, gent 0
4284595 2124539 2124539 defendant Bradeley Alan gent 602254 602254 Bradeley, Alan, of Hynton, gent 1
4288586 2125972 2125972 defendant Plowman John cooper 602254 602254 Plowman, John, of Hynton, cooper 0
4315568 2135554 2135554 defendant Meyricke Richard weaver 602254 602254 Meyricke, Richard, of Hynton, weaver 1
4330572 2140520 2140520 defendant Hill John husbandman 602254 602254 Hill, John, of Hynton, husbandman 0
4331612 2140872 2140872 defendant Lewes Thomas yeoman 602254 602254 Lewes, Thomas, of Hynton, yeoman 0
4338482 2143211 2143211 defendant Bradley Alan gent 602254 602254 Bradley, Alan, of Hynton, gent 1
4338483 2143211 2143211 defendant Heathe Griffin husbandman 602254 602254 Heathe, Griffin, of Hynton, husbandman 2
4350265 2147356 2147356 defendant Lloyd Jane widow 602254 602254 Lloyd, Jane, of Hynton, widow 1
4350266 2147356 2147356 defendant Powell John, junior husbandman 602254 602254 Powell, John, junior, of Hynton, husbandman 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);