Question: What is the county where Lone Hickory is located in the state Mayberry can be found in the Andy Griffith show named after?

full_context: Document 1: Richmond Hill, North Carolina: Richmond Hill is an unincorporated community in northern Yadkin County, North Carolina, United States, along the Yadkin River. The community is on the Yadkin County side of the river between the Surry County communities of Rockford and Siloam. It is located in the Boonville ZIP code area (27011).
Document 2: West Hickory Bridge: The West Hickory Bridge is a girder bridge that carries Pennsylvania Route 127 across the Allegheny River in rural Forest County, Pennsylvania. Spanning the river between Harmony Township and Hickory Township, it is named for the village of West Hickory.
Document 3: Wildwood, North Carolina: Wildwood, North Carolina is a small unincorporated community centered on the Wildwood Road, just west of the Morehead City, North Carolina town limits along US Highway 70, in Carteret County, North Carolina. Newport, North Carolina is the next closest town.
Document 4: Mayberry: Mayberry, North Carolina is a fictitious community that was the setting for two popular American television sitcoms, The Andy Griffith Show and Mayberry R.F.D. Mayberry was also the setting for a 1986 reunion television movie titled Return to Mayberry. Mayberry is said to be based on Andy Griffith's hometown of Mount Airy, North Carolina. Mount Airy is also known as Mayberry and this town is known by both names to the people who reside there.
Document 5: Yadkinville, North Carolina: Yadkinville is a town in Yadkin County, North Carolina, United States. The population was 2,818 at the 2000 census. Located in the Piedmont Triad, it is the county seat and largest city of Yadkin County.
Document 6: Bringle Ferry Bridge: The Bringle Ferry Bridge is a crossing of the Yadkin River Channel and the Tuckertown Reservoir in Rowan County, North Carolina and Davidson County, North Carolina. The bridge is on Bringle Ferry Road between Salisbury, North Carolina and Denton, North Carolina. It is the only crossing of the Yadkin River between the Interstate 85 bridge at Spencer, North Carolina and the NC Hwy 49 bridge near Richfield, North Carolina. The Bringle Ferry Bridge has views of the High Rock Dam to the north, which separates Tuckertown Reservoir from High Rock Lake.
Document 7: The Ghost and Mr. Chicken: This film was produced by Universal Studios, which produced countless classic horror films. Knotts was best known at the time of the film's production for his Emmy Award-winning five seasons on the sitcom "The Andy Griffith Show" as small town deputy sheriff Barney Fife. Andy Griffith, Knotts' co-star on "The Andy Griffith Show", suggested expanding on an episode from the television series involving a deserted house (the old Rimshaw house in the episode "Haunted House" aired October 1963) in which Barney, Gomer, and Andy retrieve a baseball of Opie and his friend from the house. Another "Andy Griffith Show" connection is a small role played by Hal Smith, who had a recurring role on the show. Knotts left the television series at the end of the 1964–65 season in order to pursue a film career. He had already starred in "The Incredible Mr. Limpet" (1964). Knotts' popularity prompted a multiple-movie deal with Universal, starting with this movie, and followed by "The Reluctant Astronaut" (1967), "The Shakiest Gun in the West" (1968), "The Love God?" (1969), and "How to Frame a Figg" (1971). "The Ghost and Mr. Chicken" was directed by Alan Rafkin with a screenplay by Jim Fritzell and Everett Greenbaum; all three men had been associated with the success of "The Andy Griffith Show". Several players from the television series also appear in the film including Lurene Tuttle, Burt Mustin, Hal Smith and Hope Summers. Viewers will also recognize several actors and actresses who had appeared or were then appearing on other sitcoms of the time. The movie boasts one of the largest collection of character actors/actresses assembled in a single movie.
Document 8: Barney Fife: Bernard ``Barney ''P. Milton Oliver Fife is a fictional character in the American television program The Andy Griffith Show, portrayed by comic actor Don Knotts. Barney Fife is a deputy sheriff in the slow - paced, sleepy southern community of Mayberry, North Carolina. He appeared in the first five seasons (1960 -- 65) as a main character, and, after leaving the show at the end of season five, made a few guest appearances in the following three color seasons (1965 -- 68). He also appeared in the first episode of the spin - off series Mayberry R.F.D. (1968 -- 1971), and in the 1986 reunion telemovie Return to Mayberry. Additionally, Barney appeared in the Joey Bishop Show episode,`` Joey's Hideaway Cabin'' and, unnamed, in the first episode of The New Andy Griffith Show.
Document 9: Hickory Grove, South Carolina: Hickory Grove is a town in York County, South Carolina, United States. The population was 440 at the 2010 census.
Document 10: Lone Hickory, North Carolina: Lone Hickory is an unincorporated community in southern Yadkin County, North Carolina west of Courtney. It is located on Lone Hickory road, about a mile southeast of the road's west end at U.S. Route 21.
Document 11: The Andy Griffith Show: The Andy Griffith Show Play media Opening sequence including ``The Fishin 'Hole ''Genre Sitcom Created by Sheldon Leonard Starring Andy Griffith Ronny Howard Don Knotts Frances Bavier Narrated by Colin Male (1960 -- 64) Theme music composer Earle Hagen and Herbert W. Spencer Opening theme`` The Fishin' Hole'' Country of origin United States Original language (s) English No. of seasons 8 No. of episodes 249 (list of episodes) Production Executive producer (s) Sheldon Leonard Danny Thomas Production location (s) Desilu Culver (1960 -- 67) Paramount Studios (1967 -- 68) Camera setup Single - camera Running time 25 -- 26 minutes Production company (s) Danny Thomas Enterprises Mayberry Enterprises Distributor Viacom Enterprises (1971 -- 1994) Paramount Domestic Television (1994 -- 2006) CBS Paramount Domestic Television (2006 -- 2007) CBS Television Distribution (2007 -- present) Release Original network CBS Picture format Black - and - white (1960 -- 65) Color (1965 -- 68) 35 mm film Original broadcast: 4: 3 480i (SDTV) Remastered: 4: 3 1080i (HDTV) Audio format Monaural Original release October 3, 1960 (1960 - 10 - 03) -- April 1, 1968 (1968 - 04 - 01) Chronology Followed by Mayberry R.F.D. Related shows The Danny Thomas Show Gomer Pyle, U.S.M.C.
Document 12: Rock Hill, South Carolina: Rock Hill is the largest city in York County, South Carolina, United States and the fifth-largest city in the state. It is also the fourth-largest city of the Charlotte metropolitan area, behind Charlotte, Concord, and Gastonia (all located in North Carolina, unlike Rock Hill). As of the 2010 Census, the population was 66,154. In 2016, the population had increased to 72,937.
Document 13: The Andy Griffith Show: The Andy Griffith Show is an American situation comedy which aired on CBS from October 3, 1960, to April 1, 1968, with a total of 249 half - hour episodes spanning over eight seasons -- 159 in black and white and 90 in color. The series partially originated from an episode of The Danny Thomas Show.
Document 14: Hickory, Maryland: Hickory is an unincorporated community in Harford County, Maryland, United States. Hickory is located at the junction of Maryland Route 543 and U.S. Route 1 Business north of Bel Air.
Document 15: Gold Hill Township, Rowan County, North Carolina: Gold Hill Township is one of fourteen townships in Rowan County, North Carolina, United States. The township had a population of 10,015 according to the 2000 census.
ground_truth: Yadkin River
sub_queries: where is mayberry located on the andy griffith show Answer: North Carolina
Lone Hickory, North Carolina >> located in the administrative territorial entity Answer: Yadkin County
Yadkin County >> named after Answer: Yadkin River