names

277 rows where place_id = 604966

✎ 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
3659893 1913351 1913351 defendant W-- Hugh butcher 604966 604966 W--, Hugh, of Leominster, butcher 0
3666926 1915599 1915599 defendant Parteriche Thomas butcher 604966 604966 Parteriche, Thomas, of Leominster, butcher 0
3791202 1955081 1955081 defendant Wilson alias Dyer John dyer 604966 604966 Wilson alias Dyer, John, of Leominster, dyer 1
3927989 1999697 1999697 defendant Byrche Margery widow 604966 604966 Byrche, Margery, of Leominster, widow 1
3931815 2000945 2000945 plaintiff Edwardes John (legal representative) 604966 604966 Edwardes, John, of Leominster, draper, executors of 0
3936186 2002426 2002426 defendant Bell Henry yeoman 604966 604966 Bell, Henry, of Leominster, yeoman 0
3936935 2002685 2002685 defendant Avye or Abye Richard yeoman 604966 604966 Avye or Abye, Richard, of Leominster, yeoman 5
3980145 2017665 2017665 plaintiff Passye David mercer 604966 604966 Passye, David, of Leominster, mercer 0
4004488 2026380 2026380 defendant Sheward Thomas yeoman 604966 604966 Sheward, Thomas, of Leominster, yeoman 0
4004489 2026380 2026380 defendant Sheward William yeoman 604966 604966 Sheward, William, of Leominster, yeoman 1
4013550 2029585 2029585 plaintiff Rowley William (legal representative) 604966 604966 Rowley, William, of Leominster, yeoman, executors of 0
4028782 2034943 2034943 defendant Morys Philip mercer 604966 604966 Morys, Philip, of Leominster, mercer 0
4028783 2034943 2034943 defendant Hodges Thomas yeoman 604966 604966 Hodges, Thomas, of Leominster, yeoman 1
4028785 2034944 2034944 defendant Morys Philip mercer 604966 604966 Morys, Philip, of Leominster, mercer 0
4028786 2034944 2034944 defendant Hodges Thomas yeoman 604966 604966 Hodges, Thomas, of Leominster, yeoman 1
4032429 2036252 2036252 defendant Corren Richard yeoman 604966 604966 Corren, Richard, of Leominster, yeoman 5
4032448 2036253 2036253 defendant Corren Richard yeoman 604966 604966 Corren, Richard, of Leominster, yeoman 6
4041185 2039336 2039336 defendant Foxall Richard smith 604966 604966 Foxall, Richard, of Leominster, smith 2
4041189 2039337 2039337 defendant Foxall Richard smith 604966 604966 Foxall, Richard, of Leominster, smith 2
4046365 2041146 2041146 defendant Cartwryght William yeoman 604966 604966 Cartwryght, William, of Leominster, yeoman 0
4052804 2043437 2043437 defendant Hartrey Maud widow 604966 604966 Hartrey, Maud, of Leominster, widow 3
4054047 2043830 2043830 plaintiff Awsten alias Skarlett John butcher 604966 604966 Awsten alias Skarlett, John, of Leominster, butcher 0
4054049 2043831 2043831 plaintiff Awsten alias Skarlett John butcher 604966 604966 Awsten alias Skarlett, John, of Leominster, butcher 0
4054163 2043877 2043877 plaintiff Baker alias Jenyns Griffin shoemaker 604966 604966 Baker alias Jenyns, Griffin, of Leominster, shoemaker 0
4054164 2043877 2043877 defendant Beysy William cordwainer 604966 604966 Beysy, William, of Leominster, cordwainer 0
4056040 2044544 2044544 defendant Beyssey William yeoman 604966 604966 Beyssey, William, of Leominster, yeoman 0
4061534 2046523 2046523 plaintiff Dyner or Dyver John turner 604966 604966 Dyner or Dyver, John, of Leominster, turner 0
4061535 2046523 2046523 defendant Beyssy William cordwainer 604966 604966 Beyssy, William, of Leominster, cordwainer 0
4068060 2048882 2048882 defendant Wauclen William yeoman 604966 604966 Wauclen, William, of Leominster, yeoman 1
4068061 2048882 2048882 defendant Grene John, junior yeoman 604966 604966 Grene, John, junior, of Leominster, yeoman 2
4072133 2050332 2050332 defendant Jones Owen husbandman 604966 604966 Jones, Owen, of Leominster, husbandman 2
4081430 2053668 2053668 defendant Luggar Thomas tanner 604966 604966 together with Luggar, Thomas, of Leominster, tanner 1
4081432 2053669 2053669 defendant Luggar Thomas tanner 604966 604966 Luggar, Thomas, of Leominster, tanner 0
4085029 2054925 2054925 defendant Mathewes John husbandman 604966 604966 Mathewes, John, of Leominster, husbandman 1
4107843 2063081 2063081 defendant Poull Richard (legal representative) 604966 604966 Poull, Richard, of Leominster, yeoman, executrix of 0
4107844 2063081 2063081 defendant Poull Joan widow 604966 604966 Poull, Joan, of Leominster, widow 1
4107846 2063082 2063082 defendant Mason alias Salter John yeoman 604966 604966 Mason alias Salter, John, of Leominster, yeoman 0
4112478 2064719 2064719 defendant Lane Richard mercer 604966 604966 Lane, Richard, of Leominster, mercer 1
4113227 2064996 2064996 defendant ap Morgan John gent 604966 604966 ap Morgan, John, of Leominster, gent 1
4116272 2066108 2066108 defendant Caswald John yeoman 604966 604966 Caswald, John, of Leominster, yeoman 0
4135317 2072952 2072952 defendant Morrys Philip yeoman 604966 604966 Morrys, Philip, of Leominster, yeoman 0
4135318 2072952 2072952 defendant Badnedge William mercer 604966 604966 Badnedge, William, of Leominster, mercer 1
4135322 2072953 2072953 defendant Badnedge Richard yeoman 604966 604966 Badnedge, Richard, of Leominster, yeoman 2
4142093 2075410 2075410 defendant Creswell John gent 604966 604966 Creswell, John, of Leominster, gent 0
4143050 2075737 2075737 defendant ap Owen Evam Howell yeoman 604966 604966 ap Owen, Evam Howell, of Leominster, yeoman 0
4143052 2075737 2075737 defendant Harris alias Adams Thomas yeoman 604966 604966 Harris alias Adams, Thomas, of Leominster, yeoman 2
4143053 2075737 2075737 defendant ap Thomas John tailor 604966 604966 ap Thomas, John, of Leominster, tailor 3
4150583 2078337 2078337 defendant Dalowe Thomas gent 604966 604966 Dalowe, Thomas, of Leominster, gent 3
4151816 2078749 2078749 defendant Morrys Thomas yeoman 604966 604966 Morrys, Thomas, of Leominster, yeoman 0
4151817 2078749 2078749 defendant Davys John baker 604966 604966 Davys, John, of Leominster, baker 1
4151819 2078749 2078749 defendant Jackson Anne widow 604966 604966 Jackson, Anne, of Leominster, widow 3
4151820 2078749 2078749 defendant Baylye John husbandman 604966 604966 Baylye, John, of Leominster, husbandman 4
4151821 2078749 2078749 defendant ap David David husbandman 604966 604966 ap David, David, of Leominster, husbandman 5
4151822 2078749 2078749 defendant Morrys Philip gent 604966 604966 Morrys, Philip, of Leominster, gent 6
4154454 2079651 2079651 defendant Caswall John, junior yeoman 604966 604966 Caswall, John, junior, of Leominster, yeoman 0
4158673 2081105 2081105 defendant Wall Humphrey mercer 604966 604966 Wall, Humphrey, of Leominster, mercer 3
4159377 2081348 2081348 defendant Lewes Henry yeoman 604966 604966 Lewes, Henry, of Leominster, yeoman 0
4159378 2081348 2081348 defendant Dewce Abraham clerk 604966 604966 Dewce, Abraham, of Leominster, clerk 1
4165377 2083397 2083397 defendant Stephens Thomas gent 604966 604966 Stephens, Thomas, of Leominster, gent 0
4165378 2083397 2083397 defendant Lane Richard mercer 604966 604966 Lane, Richard, of Leominster, mercer 1
4165379 2083397 2083397 defendant Apprice Lewis sawyer 604966 604966 Apprice, Lewis, of Leominster, sawyer 2
4169214 2084736 2084736 defendant Shoter Thomas gent 604966 604966 Shoter, Thomas, of Leominster, gent 0
4169215 2084736 2084736 defendant Shoter Miles mercer 604966 604966 Shoter, Miles, of Leominster, mercer 1
4178681 2088024 2088024 defendant Monox Richard tanner 604966 604966 Monox, Richard, of Leominster, tanner 0
4191753 2092673 2092673 defendant Hereford John smith 604966 604966 Hereford, John, of Leominster, smith 0
4201653 2096121 2096121 defendant Dyto David yeoman 604966 604966 Dyto, David, of Leominster, yeoman 0
4206773 2097911 2097911 defendant Badnedge William mercer 604966 604966 Badnedge, William, of Leominster, mercer 0
4206775 2097912 2097912 defendant Morrys Philip gent or yeoman 604966 604966 Morrys, Philip, of Leominster, gent or yeoman 0
4212440 2099899 2099899 defendant Hackluytt Miles gent 604966 604966 Hackluytt, Miles, of Leominster, gent 0
4212442 2099900 2099900 defendant Stephens Thomas gent 604966 604966 Stephens, Thomas, of Leominster, gent 0
4212443 2099900 2099900 defendant Lane Richard mercer 604966 604966 Lane, Richard, of Leominster, mercer 1
4212444 2099900 2099900 defendant Apprice Lewis   604966 604966 Apprice, Lewis, of Leominster, "sayer" 2
4217567 2101637 2101637 defendant Harford John smith 604966 604966 Harford, John, of Leominster, smith 0
4219813 2102434 2102434 defendant Davys John yeoman 604966 604966 Davys, John, of Leominster, yeoman 1
4228126 2105317 2105317 defendant Addams Philip miller 604966 604966 Addams, Philip, of Leominster, miller 0
4235124 2107843 2107843 defendant Badnedge Thomas glover 604966 604966 Badnedge, Thomas, of Leominster, glover 0
4236984 2108515 2108515 defendant Dallowe Thomas gent 604966 604966 Dallowe, Thomas, of Leominster, gent 0
4238188 2108966 2108966 defendant Hunte alias Towne John tanner 604966 604966 Hunte alias Towne, John, of Leominster, tanner 0
4238192 2108968 2108968 defendant Whitehed Henry, junior tanner 604966 604966 Whitehed, Henry, junior, of Leominster, tanner 0
4239652 2109499 2109499 defendant Caswald Thomas yeoman 604966 604966 Caswald, Thomas, of Leominster, yeoman 1
4241490 2110136 2110136 defendant Shewter Thomas gent 604966 604966 Shewter, Thomas, of Leominster, gent 0
4242385 2110453 2110453 defendant Monnox Richard yeoman 604966 604966 Monnox, Richard, of Leominster, yeoman 0
4242387 2110453 2110453 defendant Towne John yeoman 604966 604966 Towne, John, of Leominster, yeoman 2
4243828 2110917 2110917 defendant Harford John smith 604966 604966 Harford, John, of Leominster, smith 0
4247890 2112277 2112277 defendant Perkes Hugh shoemaker 604966 604966 Perkes, Hugh, of Leominster, shoemaker 0
4247891 2112277 2112277 defendant Perkes Katherine widow 604966 604966 Katherine his wife, formerly Katherine Trumper, of Leominster, widow 1
4259063 2116002 2116002 defendant Davys William joiner 604966 604966 Davys, William, of Leominster, joiner 3
4270852 2119824 2119824 defendant Davis William joiner 604966 604966 Davis, William, of Leominster, joiner 3
4270930 2119851 2119851 defendant Waucklen William gent 604966 604966 Waucklen, William, of Leominster, gent 1
4291661 2127094 2127094 defendant Hyett Thomas gent 604966 604966 Hyett, Thomas, of Leominster, gent 1
4292536 2127392 2127392 defendant Monox Richard yeoman 604966 604966 Monox, Richard, of Leominster, yeoman 2
4292537 2127392 2127392 defendant Steade John butcher 604966 604966 Steade, John, of Leominster, butcher 3
4293059 2127580 2127580 defendant Bradford Richard weaver 604966 604966 Bradford, Richard, of Leominster, weaver 0
4293686 2127806 2127806 defendant Steade John butcher 604966 604966 Steade, John, of Leominster, butcher 0
4294695 2128189 2128189 defendant Powle Henry yeoman 604966 604966 Powle, Henry, of Leominster, yeoman 0
4301778 2130746 2130746 defendant Bradforde Richard weaver 604966 604966 Bradforde, Richard, of Leominster, weaver 0
4301864 2130776 2130776 defendant Waucklen John yeoman 604966 604966 Waucklen, John, of Leominster, yeoman 0
4302728 2131071 2131071 defendant Cassald or Caswald John yeoman 604966 604966 Cassald or Caswald, John, of Leominster, yeoman 1
4302730 2131071 2131071 defendant Badnedge John yeoman 604966 604966 Badnedge, John, of Leominster, yeoman 3
4304863 2131837 2131837 defendant Whiteheade Henry, junior tanner 604966 604966 Whiteheade, Henry, junior, of Leominster, tanner 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);