names

293 rows where place_id = 586878

✎ 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
3589875 1864474 1864474 defendant Comyn Henry husbandman 586878 586878 Comyn, Henry, of Teukesbury, husbandman 0
3593092 1865467 1865467 defendant Comyn Henry yeoman 586878 586878 Comyn, Henry, of Teukesbury, yeoman 0
3600167 1867704 1867704 plaintiff Willies William baker 586878 586878 Willies, William, of Teukesbury, baker 0
3600168 1867704 1867704 defendant Comyn Henry yeoman 586878 586878 Comyn, Henry, of Teukesbury, yeoman 0
3610390 1870907 1870907 defendant Sympur Nicholas clerk 586878 586878 Sympur, Nicholas, of Teukesbury, clerk 0
3611466 1871259 1871259 defendant Rogers John yeoman 586878 586878 Rogers, John, of Teukesbury, yeoman 1
3625181 1875411 1875411 defendant Baker Richard baker 586878 586878 Baker, Richard, of Teukesbury, baker 0
3632889 1905104 1905104 defendant Compton Thomas husbandman 586878 586878 Compton, Thomas, of Teukesbury, husbandman 1
3686036 1921792 1921792 defendant Broke Richard shoemaker 586878 586878 Broke, Richard, of Teukesbury, shoemaker 0
3701943 1926861 1926861 plaintiff Bydfeld Robert   586878 586878 Bydfeld, Robert, of Teukesbury 0
3701944 1926861 1926861 defendant Alake Thomas merchant 586878 586878 Alake, Thomas, of Teukesbury, merchant 0
3777506 1950716 1950716 defendant Frebarne alias Walker William tanner 586878 586878 Frebarne alias Walker, William, of Teukesbury, tanner 0
3789259 1954457 1954457 defendant Talentyre Robert laborer 586878 586878 Talentyre, Robert, of Teukesbury, laborer 0
3800673 1958123 1958123 defendant Broke William mariner 586878 586878 Broke, William, of Teukesbury, mariner 0
3800674 1958123 1958123 defendant Montypase John waterman 586878 586878 Montypase, John, of Teukesbury, waterman 1
3800675 1958123 1958123 defendant Wakeman Richard yeoman 586878 586878 Wakeman, Richard, of Teukesbury, yeoman 2
3800676 1958123 1958123 defendant Feld Robert waterman 586878 586878 Feld, Robert, of Teukesbury, waterman 3
3800682 1958125 1958125 defendant Cowper John cooper 586878 586878 Cowper, John, of Teukesbury, cooper 0
3805475 1959651 1959651 defendant Kenard John yeoman 586878 586878 Kenard, John, of Teukesbury, yeoman 0
3868706 1979776 1979776 defendant Geffereys John brewer 586878 586878 Geffereys, John, of Teukesbury, brewer 0
3868707 1979776 1979776 defendant Strache John laborer 586878 586878 Strache, John, of Teukesbury, laborer 1
3868709 1979776 1979776 defendant Chesshere Alexander chandler 586878 586878 Chesshere, Alexander, of Teukesbury, chandler 3
3869369 1979995 1979995 defendant Becke Henry butcher 586878 586878 Becke, Henry, of Teukesbury, butcher 0
3869371 1979995 1979995 defendant Lokyar John husbandman 586878 586878 Lokyar, John, of Teukesbury, husbandman 2
3869372 1979995 1979995 defendant Talentyres Robert yeoman 586878 586878 Talentyres, Robert, of Teukesbury, yeoman 3
3893498 1988052 1988052 defendant Grene Henry tailor 586878 586878 Grene, Henry, of Teukesbury, tailor 0
4414547 2169453 2169453 defendant Chaumberleyn Margery daughter of John 586878 586878 Chaumberleyn, Margery, of Teukesbury, daughter of John 0
4452286 2185703 2185703 defendant Lardynere Hugh   586878 586878 Lardynere, Hugh, of Teukesbury 3
4455730 2186803 2186803 defendant Drapere Richard   586878 586878 Drapere, Richard, of Teukesbury 0
4470592 2191449 2191449 defendant Coppeshod John   586878 586878 Coppeshod, John, of Teukesbury 0
4512666 2204391 2204391 defendant Sperman William   586878 586878 Sperman, William, of Teukesbury 0
4519169 2206348 2206348 defendant Dyer Roger   586878 586878 Dyer, Roger, of Teukesbury 0
4519171 2206349 2206349 plaintiff Dyere Hugh   586878 586878 Dyere, Hugh, of Teukesbury 0
4529349 2209463 2209463 defendant Stacy Robert dyer 586878 586878 Stacy, Robert, of Teukesbury, dyer 0
4529357 2209466 2209466 defendant Stacy Robert dyer 586878 586878 Stacy, Robert, of Teukesbury, dyer 1
4537008 2211842 2211842 defendant Bartelot Reginald   586878 586878 Bartelot, Reginald, of Teukesbury 0
4546852 2214944 2214944 plaintiff Brugge Thomas de   586878 586878 Brugge, Thomas de, of Teukesbury 0
4550827 2216195 2216195 defendant Alford John   586878 586878 Alford, John, of Teukesbury 0
4550829 2216195 2216195 defendant Wyther John   586878 586878 Wyther, John, of Teukesbury 2
4550832 2216195 2216195 defendant Bailly Thomas   586878 586878 Bailly, Thomas, of Teukesbury 5
4575949 2223969 2223969 defendant Taverner John   586878 586878 Taverner, John, of Teukesbury 0
4580840 2225490 2225490 plaintiff Dier Roger   586878 586878 Dier, Roger, of Teukesbury 0
4589800 2228175 2228175 defendant Stoughton John (legal representative) 586878 586878 Stoughton, John, of Teukesbury, executors of 0
4594111 2229419 2229419 defendant Streynesham Thomas   586878 586878 Streynesham, Thomas, of Teukesbury 0
4594709 2229599 2229599 defendant Tommes Richard   586878 586878 Tommes, Richard, of Teukesbury 0
4643920 2244320 2244320 defendant Stacy Robert   586878 586878 Stacy, Robert, of Teukesbury 0
4656600 2247956 2247956 defendant Lynam Thomas fisher 586878 586878 Lynam, Thomas, of Teukesbury, fisher 0
4661479 2249418 2249418 defendant Streynsham Thomas husbandman 586878 586878 Streynsham, Thomas, of Teukesbury, husbandman 0
4670942 2256583 2256583 defendant Hosier Rober hosier 586878 586878 Hosier, Rober, of Teukesbury, hosier 3
4672776 2257126 2257126 defendant Aleyn alias Conyng Thomas chapman 586878 586878 Aleyn alias Conyng, Thomas, of Teukesbury, chapman 1
4672780 2257127 2257127 defendant Aleyn alias Conyng Thomas chapman 586878 586878 Aleyn alias Conyng, Thomas, of Teukesbury, chapman 1
4682047 2260003 2260003 defendant Stonghton William   586878 586878 Stonghton, William, of Teukesbury 0
4683887 2260569 2260569 defendant Twenyng Richard   586878 586878 Twenyng, Richard, of Teukesbury 0
4684053 2260619 2260619 defendant Twenyng Richard chapman 586878 586878 Twenyng, Richard, of Teukesbury, chapman 1
4689511 2262276 2262276 defendant Twynyng Richard yeoman 586878 586878 Twynyng, Richard, of Teukesbury, yeoman 0
4690236 2262503 2262503 defendant Bette John   586878 586878 Bette, John, of Teukesbury 1
4691183 2262764 2262764 plaintiff Wye Richard   586878 586878 Wye, Richard, of Teukesbury 0
4720056 2271621 2271621 defendant Wynteworth John chapman 586878 586878 (Wynteworth, John, of Teukesbury, chapman 1
4741674 2278057 2278057 defendant Lyneham Thomas yeoman 586878 586878 Lyneham, Thomas, of Teukesbury, yeoman 0
4742400 2278270 2278270 defendant Barell Walter yeoman 586878 586878 Barell, Walter, of Teukesbury, yeoman 0
4742401 2278270 2278270 defendant Sclatter Walter slater 586878 586878 Sclatter, Walter, of Teukesbury, slater 1
4742496 2278305 2278305 defendant Forster John tailor 586878 586878 Forster, John, of Teukesbury, tailor 2
4742614 2278344 2278344 defendant Streynsham John butcher 586878 586878 Streynsham, John, of Teukesbury, butcher 0
4742615 2278344 2278344 defendant Strynger Hugh shoemaker 586878 586878 Strynger, Hugh, of Teukesbury, shoemaker 1
4742616 2278344 2278344 defendant Sadeler Alan sadler 586878 586878 Sadeler, Alan, of Teukesbury, sadler 2
4742617 2278344 2278344 defendant Godale Roger cobbler or shoemaker 586878 586878 Godale, Roger, of Teukesbury, cobbler or shoemaker 3
4742620 2278345 2278345 defendant Strynger Hugh shoemaker 586878 586878 Strynger, Hugh, of Teukesbury, shoemaker 1
4742621 2278345 2278345 defendant Sadeler Alan sadler 586878 586878 Sadeler, Alan, of Teukesbury, sadler 2
4742622 2278345 2278345 defendant Godale Roger cobbler 586878 586878 Godale, Roger, of Teukesbury, cobbler 3
4744015 2278776 2278776 defendant Ferrour Thomas laborer 586878 586878 Ferrour, Thomas, of Teukesbury, laborer 1
4769244 2286360 2286360 defendant Kedwelly Henry   586878 586878 Kedwelly, Henry, of Teukesbury, mill ward 0
4769390 2286400 2286400 plaintiff Pavy William   586878 586878 Pavy, William, of Teukesbury 0
4777699 2289020 2289020 defendant Skynner Ellen   586878 586878 Skynner, Ellen, of Teukesbury, servant 0
4779571 2289596 2289596 defendant Walker David tucker 586878 586878 Walker, David, of Teukesbury, tucker 0
4779572 2289596 2289596 defendant Berman Agnes widow 586878 586878 Berman, Agnes, of Teukesbury, widow 1
4780317 2289844 2289844 plaintiff Stacy Robert, junior   586878 586878 Stacy, Robert, junior, of Teukesbury 1
4780318 2289844 2289844 defendant Dyere John dyer 586878 586878 Dyere, John, of Teukesbury, dyer 0
4781180 2290125 2290125 defendant Streynsham John butcher 586878 586878 Streynsham, John, of Teukesbury, butcher 0
4781181 2290125 2290125 defendant Strynger Hugh cordwainer 586878 586878 Strynger, Hugh, of Teukesbury, cordwainer 1
4781182 2290125 2290125 defendant Sadeler Alan saddler 586878 586878 Sadeler, Alan, of Teukesbury, saddler 2
4781183 2290125 2290125 defendant Godale Roger cobbler 586878 586878 Godale, Roger, of Teukesbury, cobbler 3
4797839 2295501 2295501 defendant Baa William husbandman 586878 586878 Baa, William, of Teukesbury, husbandman 0
4802456 2296959 2296959 defendant Waxman Thomas yeoman 586878 586878 Waxman, Thomas, of Teukesbury, yeoman 0
4804885 2297731 2297731 defendant Wode Henry tanner 586878 586878 Wode, Henry, of Teukesbury, tanner 0
4804941 2297750 2297750 plaintiff Brasier alias Belleyeter Richard   586878 586878 Brasier alias Belleyeter, Richard, of Teukesbury 0
4804947 2297752 2297752 plaintiff Brasyer alias Belleyeter Richard   586878 586878 Brasyer alias Belleyeter, Richard, of Teukesbury 0
4804949 2297753 2297753 plaintiff Brasyer alias Belleyeter Richard   586878 586878 Brasyer alias Belleyeter, Richard, of Teukesbury 0
4810275 2299358 2299358 defendant Stoughton William gent 586878 586878 Stoughton, William, of Teukesbury, gent 0
4811295 2299642 2299642 plaintiff Frygge Thomas merchant 586878 586878 Frygge, Thomas, of Teukesbury, merchant 0
4814556 2300662 2300662 defendant Clerk John husbandman 586878 586878 Clerk, John, of Teukesbury, husbandman 0
4819741 2302248 2302248 plaintiff Pole Philip merchant 586878 586878 Pole, Philip, of Teukesbury, merchant 0
4830160 2305475 2305475 defendant Arkyll Thomas chapman 586878 586878 Arkyll, Thomas, of Teukesbury, chapman 2
4839568 2308296 2308296 plaintiff Hasard John merchant 586878 586878 Hasard, John, of Teukesbury, merchant 0
4844298 2309724 2309724 defendant Bray Thomas merchant 586878 586878 Bray, Thomas, of Teukesbury, merchant 0
4858060 2313891 2313891 plaintiff Brasier alias Wye Richard (legal representative) 586878 586878 Brasier alias Wye, Richard, of Teukesbury, executors of 0
4858064 2313892 2313892 plaintiff Brasier alias Wye Richard (legal representative) 586878 586878 Brasier alias Wye, Richard, of Teukesbury, executors of 0
4862387 2315244 2315244 defendant Pope William butcher 586878 586878 Pope, William, of Teukesbury, butcher 0
4862401 2315248 2315248 defendant Lemstur John carrier 586878 586878 Lemstur, John, of Teukesbury, carrier 2
4863298 2315488 2315488 defendant Draper Richard draper 586878 586878 Draper, Richard, of Teukesbury, draper 0
4866367 2316449 2316449 defendant Wodeward Roger yeoman 586878 586878 Wodeward, Roger, of Teukesbury, yeoman 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);