Question: Where is Sheet Harbour in the state having Great Village?

full_context: Document 1: Woodlawn, Nova Scotia: Woodlawn is an area of eastern Dartmouth, Nova Scotia in the Halifax Regional Municipality, Nova Scotia that is mainly residential and retail. It is situated within an area with Highway 111 on the west, Portland Street (Route 207) on the east and Main Street (Trunk 7) on the North side. The first three digits of the postal code are B2W.
Document 2: Morris Lake (Nova Scotia): Morris Lake is a long shallow lake in Nova Scotia's Halifax Regional Municipality bordering the communities of Dartmouth, Shearwater and Cole Harbour.
Document 3: Dean, Nova Scotia: Dean is a small farming & forestry community in the North Branch Musquodoboit in the Musquodoboit Valley along the Halifax Regional Municipality/Colchester County county line, in the Canadian province of Nova Scotia, along Route 336. Other communities in the North Branch include Elmsvale, Greenwood, Upper Musquodoboit, and Moose River Gold Mines, among others.
Document 4: Village Island: Village Island is an island in the Johnstone Strait region of the Central Coast region of British Columbia, Canada, located on the northwest side of Turnour Island.
Document 5: Mineville, Nova Scotia: Mineville, Nova Scotia is a suburban community within the Eastern Halifax Regional Municipality, Nova Scotia, Canada, between Lake Echo on Trunk 7, Highway 107 and Upper Lawrencetown on Route 207. The main road is called the Mineville Rd. The other road is called Candy Mountain Road. The community has two lakes: Lawrencetown Lake and Lake Echo.
Document 6: Pinehurst, Nova Scotia: Pinehurst (population around 500) is a small village along the LaHave River between New Germany and Wentzell's Lake in Nova Scotia from 44°31'58.21"N lat, 64°41'56.87"W long - 44°29'5.74"N lat, 64°37'53.69"W long. It is a stopping place on Trunk 10, which runs from Bridgewater to Middleton.
Document 7: St. John's, Newfoundland and Labrador: St. John's is the eastern terminus of the Trans-Canada Highway, one of the longest national highways in the world. The divided highway, also known as "Outer Ring Road" in the city, runs just outside the main part of the city, with exits to Pitts Memorial Drive, Topsail Road, Team Gushue Highway, Thorburn Road, Allandale Road, Portugal Cove Road and Torbay Road, providing relatively easy access to neighbourhoods served by those streets. Pitts Memorial Drive runs from Conception Bay South, through the city of Mount Pearl and into downtown St. John's, with interchanges for Goulds, Water Street and Hamilton Avenue-New Gower Street.
Document 8: Woodville, Nova Scotia: Woodville is a community in Kings County of about 200 people located in the Annapolis Valley of Nova Scotia. The community is situated north of Cambridge and Waterville at the foot of the North Mountain. Centred along Route 221, Woodville has a volunteer fire department, a Baptist church, two auto body shops, a home run automotive mechanic business, and many family-run farms. It is administratively part of the village of Cornwallis Square. A community centre is located in the former school, built in 1942. The former Wesley Knox United Church, built in 1921, was sold in 2006 is now a residence and artist's workshop.
Document 9: Bridgewater, Nova Scotia: Bridgewater is a town in Lunenburg County, Nova Scotia, Canada, at the navigable limit of the LaHave River. With a population of 8,532 as of 2016, Bridgewater is the largest town in the South Shore region.
Document 10: Upper Lakeville: Upper Lakeville is a small cottage community on the Eastern Shore of the Halifax Regional Municipality, in the Musquodoboit/Sheet Harbour region of the Marine Drive, in Nova Scotia. Upper Lakeville road is located on the junction of Trunk 7, 55.3 km from Dartmouth, and 58.9 km from Halifax.
Document 11: Pengorffwysfa: The village lies on the crossroad between Penysarn and Porth Eilian and Point Lynas Lighthouse, with turnings down towards Amlwch Port and Amlwch town, and the ascent for Llaneilian Mountain and heading towards Dulas Bay. This road forms part of the National Cycle Network Route 566, known as the Copper Trail, taking in the north coast of Anglesey that is designated an Area of Outstanding Natural Beauty, and the nearby remains of the historical copper mines at Parys Mountain.
Document 12: Marine Drive (Nova Scotia): The Marine Drive is a designated scenic route along Nova Scotia's Eastern Shore. It closely follows the coast of the Atlantic Ocean and the Strait of Canso from the Canso Causeway to the junction of Route 322 and Highway 111 in Dartmouth.
Document 13: Ril Lake (Ontario): Ril Lake is a lake of Ontario, Canada. This lake is in the Township of Lake of Bays. Nearest Towns are Baysville, Ontario and Dorset, Ontario. It includes both year round and seasonal residents. Two main access roads, North and South Ril Lake Road. Both branch into smaller roads further in including but not limited to Watson Road, James Point Road, Ril Cove Road, McArthur Point Road and Muskoka Bob Road. There is a Ril Lake Road Association. It is forested with mixed deciduous and coniferous trees.
Document 14: East Bay Hills (Nova Scotia): The East Bay Hills refer to a 'fault ridge' of ancient rock on the south side of the East Bay of the Bras d'Or Lake, located on Cape Breton Island, Canada, and are an extension of the Appalachian mountain chain. The East Bay Hills lie in Cape Breton County.
Document 15: Great Village: Great Village is a rural community of approximately 500 people located along Trunk 2 and the north shore of Cobequid Bay in Colchester County, Nova Scotia. It is considered locally to incorporate the areas of Highland Village to the west and Scrabble Hill to the north northwest.
ground_truth: Halifax Regional Municipality
sub_queries: In which state is Great Village located? Answer: Nova Scotia
Sheet Harbour, Nova Scotia >> located in the administrative territorial entity Answer: Halifax Regional Municipality