names

294 rows where place_id = 586392

✎ 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
3588608 1864081 1864081 defendant Scotte William husbandman 586392 586392 Scotte, William, of Leomynster, husbandman 2
3595684 1866277 1866277 defendant Barbour Thomas mercer 586392 586392 Barbour, Thomas, of Leomynster, mercer 1
3613419 1871845 1871845 plaintiff Banyes John baker 586392 586392 Banyes, John, of Leomynster, baker 0
3625892 1902952 1902952 defendant Chapman Philip mercer 586392 586392 Chapman, Philip, of Leomynster, mercer 0
3625893 1902952 1902952 defendant Haloward Hugh husbandman 586392 586392 Haloward, Hugh, of Leomynster, husbandman 1
3625894 1902952 1902952 defendant Sadeler Robert saddler 586392 586392 Sadeler, Robert, of Leomynster, saddler 2
3625895 1902952 1902952 defendant Bradwell John hosier 586392 586392 Bradwell, John, of Leomynster, hosier 3
3628135 1903656 1903656 defendant Dyer John walker 586392 586392 Dyer, John, of Leomynster, walker 0
3628136 1903656 1903656 defendant Luyde or Lynde John walker 586392 586392 Luyde or Lynde, John, of Leomynster, walker 1
3628137 1903656 1903656 defendant Massy David walker 586392 586392 Massy, David, of Leomynster, walker 2
3628138 1903656 1903656 defendant Belle John pardoner 586392 586392 Belle, John, of Leomynster, pardoner 3
3633477 1905283 1905283 defendant Smyth Thomas smith 586392 586392 Smyth, Thomas, of Leomynster, smith 0
3641202 1907699 1907699 defendant Colyns John yeoman 586392 586392 Colyns, John, of Leomynster, yeoman 2
3642444 1908081 1908081 defendant Brontley James draper 586392 586392 Brontley, James, of Leomynster, draper 0
3643271 1908320 1908320 defendant Werrell Henry chapman 586392 586392 Werrell, Henry, of Leomynster, chapman 0
3643273 1908320 1908320 defendant Harrys Robert chapman 586392 586392 Harrys, Robert, of Leomynster, chapman 2
3644163 1908609 1908609 plaintiff Eliette Henry mercer 586392 586392 Eliette, Henry, of Leomynster, mercer 0
3644165 1908609 1908609 defendant Lyde John dyer 586392 586392 Lyde, John, of Leomynster, dyer 1
3651736 1910897 1910897 plaintiff Tayllour William (legal representative) 586392 586392 Tayllour, William, of Leomynster, executors of 0
3651739 1910897 1910897 defendant Peryn Richard tailor 586392 586392 Peryn, Richard, of Leomynster, tailor 0
3651819 1910927 1910927 defendant Baker William baker 586392 586392 Baker, William, of Leomynster, baker 0
3651820 1910927 1910927 defendant Hukkesley Robert baker 586392 586392 Hukkesley, Robert, of Leomynster, baker 1
3651839 1910929 1910929 defendant Hall Richard clerk 586392 586392 Hall, Richard, of Leomynster, clerk 0
3656305 1912217 1912217 defendant Skerlett Richard chapman 586392 586392 Skerlett, Richard, of Leomynster, chapman 0
3659122 1913112 1913112 defendant Lyde John dyer 586392 586392 Lyde, John, of Leomynster, dyer 1
3659562 1913251 1913251 defendant Llodye Wallter husbandman 586392 586392 Llodye, Wallter, of Leomynster, husbandman 0
3659563 1913251 1913251 defendant Spenser Robert sadler 586392 586392 Spenser, Robert, of Leomynster, sadler 1
3659564 1913251 1913251 defendant ap Owen Owen carrier 586392 586392 ap Owen, Owen, of Leomynster, carrier 2
3659565 1913251 1913251 defendant ap Richard Thomas goldsmith 586392 586392 ap Richard, Thomas, of Leomynster, goldsmith 3
3661777 1913964 1913964 plaintiff Lln Christopher   586392 586392 Lln, Christopher, of Leomynster 0
3661778 1913964 1913964 defendant Baret John yeoman 586392 586392 Baret, John, of Leomynster, yeoman 0
3661779 1913964 1913964 defendant Baret Thomas baker 586392 586392 Baret, Thomas, of Leomynster, baker 1
3661780 1913964 1913964 defendant Llodye Walter yeoman 586392 586392 Llodye, Walter, of Leomynster, yeoman 2
3664502 1914846 1914846 defendant Parteryche Thomas laborer 586392 586392 Parteryche, Thomas, of Leomynster, laborer 2
3672930 1917546 1917546 defendant Lluwellin Hugh butcher 586392 586392 Lluwellin, Hugh, of Leomynster, butcher 0
3674610 1918110 1918110 defendant Lyde John dyer 586392 586392 Lyde, John, of Leomynster, dyer 0
3674612 1918110 1918110 defendant Dyer alias Fyssher William carrier 586392 586392 Dyer alias Fyssher, William, of Leomynster, carrier 2
3677592 1919031 1919031 defendant Skarlett Richard mercer 586392 586392 Skarlett, Richard, of Leomynster, mercer 0
3677594 1919032 1919032 defendant Vaughan John gent 586392 586392 Vaughan, John, of Leomynster, gent 0
3677596 1919032 1919032 defendant Carpenter John butcher 586392 586392 Carpenter, John, of Leomynster, butcher 2
3680838 1920088 1920088 defendant Blanche Henry pointmaker 586392 586392 Blanche, Henry, of Leomynster, pointmaker 0
3680840 1920088 1920088 defendant Sampson Thomas glover 586392 586392 Sampson, Thomas, of Leomynster, glover 2
3682574 1920655 1920655 defendant Pryket John goldsmith 586392 586392 Pryket, John, of Leomynster, goldsmith 0
3682575 1920655 1920655 defendant Blanche Henry whitawer 586392 586392 Blanche, Henry, of Leomynster, whitawer 1
3683655 1921018 1921018 defendant Worell Henry glover 586392 586392 Worell, Henry, of Leomynster, glover 2
3686020 1921787 1921787 defendant Flody Walter husbandman 586392 586392 Flody, Walter, of Leomynster, husbandman 1
3686504 1921930 1921930 defendant Polle Richard baker 586392 586392 Polle, Richard, of Leomynster, baker 0
3686505 1921930 1921930 defendant Gruffyth Hugh walker 586392 586392 Gruffyth, Hugh, of Leomynster, walker 1
3686995 1922101 1922101 defendant Nicholas John cordwainer 586392 586392 Nicholas, John, of Leomynster, cordwainer 0
3686996 1922101 1922101 defendant Tailler William mercer 586392 586392 Tailler, William, of Leomynster, mercer 1
3687897 1922377 1922377 defendant Halle alias Benett Richard dyer 586392 586392 Halle alias Benett, Richard, of Leomynster, dyer 0
3690458 1923183 1923183 defendant Galvard William tanner 586392 586392 Galvard, William, of Leomynster, tanner 1
3690459 1923183 1923183 defendant Baret John baker 586392 586392 Baret, John, of Leomynster, baker 2
3690640 1923238 1923238 defendant Dyer John chaplain 586392 586392 Dyer, John, of Leomynster, chaplain 1
3690641 1923238 1923238 defendant Hoby William tailor 586392 586392 Hoby, William, of Leomynster, tailor 2
3690642 1923238 1923238 defendant Martyn William sherman 586392 586392 Martyn, William, of Leomynster, sherman 3
3692205 1923729 1923729 defendant Stedard William butcher 586392 586392 Stedard, William, of Leomynster, butcher 0
3692206 1923729 1923729 defendant Howells Alice widow 586392 586392 Howells, Alice, of Leomynster, widow 1
3692207 1923729 1923729 defendant Helthe Eleanor widow 586392 586392 Helthe, Eleanor, of Leomynster, widow 2
3692208 1923729 1923729 defendant Dyer William carrier 586392 586392 Dyer, William, of Leomynster, carrier 3
3692209 1923729 1923729 defendant Fletcher David fletcher 586392 586392 Fletcher, David, of Leomynster, fletcher 4
3696691 1925190 1925190 defendant Atforton John mercer 586392 586392 Atforton, John, of Leomynster, mercer 0
3701563 1926737 1926737 defendant Gruffyth Hugh walker 586392 586392 Gruffyth, Hugh, of Leomynster, walker 0
3702073 1926904 1926904 defendant Halle Richard dyer 586392 586392 Halle, Richard, of Leomynster, dyer 0
3702075 1926905 1926905 defendant Nicholas John cordwainer 586392 586392 Nicholas, John, of Leomynster, cordwainer 0
3702077 1926906 1926906 defendant Nicholas John cordwainer 586392 586392 Nicholas, John, of Leomynster, cordwainer 0
3702079 1926907 1926907 defendant Tailler William mercer 586392 586392 Tailler, William, of Leomynster, mercer 0
3707423 1928615 1928615 defendant Grene alias Skynner Richard skinner 586392 586392 Grene alias Skynner, Richard, of Leomynster, skinner 0
3707424 1928615 1928615 defendant Stodard William butcher 586392 586392 Stodard, William, of Leomynster, butcher 1
3714400 1930800 1930800 defendant Ludlowe John butcher 586392 586392 Ludlowe, John, of Leomynster, butcher 1
3714401 1930800 1930800 defendant Lewelyn Hugh yeoman 586392 586392 Lewelyn, Hugh, of Leomynster, yeoman 2
3714402 1930800 1930800 defendant Hethe Philip butcher 586392 586392 Hethe, Philip, of Leomynster, butcher 3
3714599 1930862 1930862 defendant Birchar William walker 586392 586392 Birchar, William, of Leomynster, walker 0
3714600 1930862 1930862 defendant Noven Thomas walker 586392 586392 Noven, Thomas, of Leomynster, walker 1
3714601 1930862 1930862 defendant Whyte Anthony walker 586392 586392 Whyte, Anthony, of Leomynster, walker 2
3720574 1932715 1932715 defendant Gryme John   586392 586392 Gryme, John, of Leomynster 3
3722666 1933352 1933352 plaintiff Morys John, junior   586392 586392 Morys, John, junior, of Leomynster 0
3730476 1935764 1935764 defendant Capper Roger draper 586392 586392 Capper, Roger, of Leomynster, draper 0
3730477 1935764 1935764 defendant Ludlowe John laborer 586392 586392 Ludlowe, John, of Leomynster, laborer 1
3731103 1935954 1935954 defendant Heriottes Ralph yeoman 586392 586392 Heriottes, Ralph, of Leomynster, yeoman 0
3731104 1935954 1935954 defendant Hall Richard dyer 586392 586392 Hall, Richard, of Leomynster, dyer 1
3731105 1935954 1935954 defendant Hall William yeoman 586392 586392 Hall, William, of Leomynster, yeoman 2
3731106 1935954 1935954 defendant Corser James yeoman 586392 586392 Corser, James, of Leomynster, yeoman 3
3733479 1936714 1936714 defendant Passe Walter tailor 586392 586392 Passe, Walter, of Leomynster, tailor 0
3733480 1936714 1936714 defendant Passe John tailor 586392 586392 Passe, John, of Leomynster, tailor 1
3734409 1937004 1937004 defendant Hethe Philip butcher 586392 586392 Hethe, Philip, of Leomynster, butcher 0
3735110 1937223 1937223 defendant Stevyns John butcher 586392 586392 Stevyns, John, of Leomynster, butcher 0
3736828 1937771 1937771 defendant Halle Richard dyer 586392 586392 Halle, Richard, of Leomynster, dyer 1
3736996 1937817 1937817 defendant Byrley Richard barber 586392 586392 Byrley, Richard, of Leomynster, barber 0
3738019 1938104 1938104 defendant Stevyn John butcher 586392 586392 Stevyn, John, of Leomynster, butcher 1
3738022 1938105 1938105 defendant Vaghan Thomas gent 586392 586392 Vaghan, Thomas, of Leomynster, gent 0
3738024 1938105 1938105 defendant Lyndall Humphrey yeoman 586392 586392 Lyndall, Humphrey, of Leomynster, yeoman 2
3739257 1938499 1938499 defendant Akynton John innholder 586392 586392 Akynton, John, of Leomynster, innholder 0
3742030 1939375 1939375 defendant Peytewyn Walter laborer 586392 586392 Peytewyn, Walter, of Leomynster, laborer 1
3742262 1939451 1939451 defendant Carpynter Richard yeoman 586392 586392 Carpynter, Richard, of Leomynster, yeoman 0
3742263 1939451 1939451 defendant Stevyns John tanner 586392 586392 Stevyns, John, of Leomynster, tanner 1
3744645 1940218 1940218 defendant Hethe Philip butcher 586392 586392 Hethe, Philip, of Leomynster, butcher 0
3744807 1940275 1940275 defendant Mories Richard yeoman 586392 586392 Mories, Richard, of Leomynster, yeoman 1
3744808 1940275 1940275 defendant Davyes Oliver weaver 586392 586392 Davyes, Oliver, of Leomynster, weaver 2
3745893 1940621 1940621 defendant Phyppis John laborer 586392 586392 Phyppis, John, of Leomynster, laborer 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);