Agritourism

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.ct.gov
Id q79s-2vp7
Name Agritourism
Attribution Department of Agriculture
Category Environment and Natural Resources
Tags agriculture, tourism, farms
Created 2014-09-05T16:00:20Z
Publication Date 2014-09-08T13:59:02Z

Description

A listing of various agritourism activities in Connecticut

Columns

| Included | Schema Type    | Field Name              | Name                    | Data Type | Render Type |
| ======== | ============== | ======================= | ======================= | ========= | =========== |
| Yes      | numeric metric | farmer                  | Farmer                  | number    | number      |
| Yes      | series tag     | location_id             | Location ID             | text      | number      |
| Yes      | series tag     | business_name           | Business Name           | text      | text        |
| Yes      | series tag     | business_street_address | Business Street Address | text      | text        |
| Yes      | series tag     | business_name_line_2    | Business Name line 2    | text      | text        |
| Yes      | series tag     | town                    | Town                    | text      | text        |
| Yes      | series tag     | county                  | County                  | text      | text        |
| Yes      | series tag     | phone                   | Phone                   | text      | text        |
| Yes      | series tag     | fax                     | Fax                     | text      | text        |
| Yes      | series tag     | email                   | Email                   | text      | text        |
| No       |                | mailingaddress          | MailingAddress          | text      | text        |
| No       |                | mailingaddress2         | MailingAddress2         | text      | text        |
| Yes      | series tag     | mailingtown             | MailingTown             | text      | text        |
| Yes      | series tag     | mailingstate            | MailingState            | text      | text        |
| Yes      | series tag     | mailingzip              | MailingZip              | text      | number      |
| Yes      | series tag     | web                     | Web                     | url       | url         |
| Yes      | time           | programyear             | ProgramYear             | number    | number      |
| Yes      | series tag     | status                  | Status                  | text      | text        |
| Yes      | series tag     | description             | Description             | text      | text        |
| Yes      | series tag     | corn_maze               | Corn Maze               | text      | text        |
| Yes      | series tag     | pumpkins                | Pumpkins                | text      | text        |
| Yes      | series tag     | hay_rides               | Hay Rides               | text      | text        |
| Yes      | series tag     | large_fruit             | Large Fruit             | text      | text        |
| Yes      | series tag     | fall_festival           | Fall Festival           | text      | text        |
| Yes      | series tag     | mums                    | Mums                    | text      | text        |
| Yes      | series tag     | other                   | Other                   | text      | text        |
| Yes      | series tag     | otherdescription        | OtherDescription        | text      | text        |
| Yes      | series tag     | comments                | Comments                | text      | text        |
| Yes      | series tag     | recnumber               | RecNumber               | text      | number      |
| Yes      | series tag     | farm_dinners            | Farm Dinners            | text      | text        |
| Yes      | series tag     | winerys                 | Winerys                 | text      | text        |
| Yes      | series tag     | farmtours               | FarmTours               | text      | text        |
| Yes      | series tag     | pyo                     | PYO                     | text      | text        |

Time Field

Value = programyear
Format & Zone = yyyy

Series Fields

Excluded Fields = mailingaddress,mailingaddress2

Data Commands

series e:q79s-2vp7 d:2014-01-01T00:00:00.000Z t:otherdescription="Bakery, farm stand, winery, Mums" t:hay_rides=HR t:phone=860-464-7305 t:other=O t:pyo=PO t:fax=860-464-2250 t:status=ACTIVE t:web=http://www.holmbergorchards.com t:mailingtown="Gales Ferry" t:location_id=14846 t:business_name="Holmberg Orchards and Winery" t:fall_festival=FF t:email=amy@holmbergorchards.com t:county="New London County" t:business_street_address="12 Orchard Drive" t:recnumber=354 t:town="Gales Ferry" t:mailingstate=CT t:mailingzip=6335 m:farmer=7096

series e:q79s-2vp7 d:2014-01-01T00:00:00.000Z t:otherdescription=mums t:hay_rides=HR t:phone=860-486-1076 t:other=O t:status=ACTIVE t:mailingtown=Storrs t:location_id=14865 t:business_name="Uconn Coll. Of Agri & Natural Resources" t:fall_festival=FF t:email=sara.putnam@uconn.edu t:county="Windham County" t:business_street_address="Rte. 195" t:description="Join us at the annual Cornucopia Fest on September 21 2014.  Visit, www.cag.uconn.edu for information." t:recnumber=371 t:town=Storrs t:mailingstate=CT m:farmer=6249

series e:q79s-2vp7 d:2014-01-01T00:00:00.000Z t:hay_rides=HR t:phone=203-288-0700 t:fax=203-288-3265 t:status=ACTIVE t:web=http://www.hindingersfarm.com t:mailingtown=Hamden t:location_id=14843 t:business_name="Hindinger Farm" t:county="New Haven County" t:email=info@hindingersfarm.com t:business_street_address="835 Dunbar Hill Road" t:description="Strawberry festival held on the Saturday of Father?s Day weekend.  We have hayrides, strawberry ice cream, and strawberry shortcake, and Glenwood Drive-In cooks up hamburgers and hot dogs.  There are lots of activities for the children." t:recnumber=352 t:town=Hamden t:mailingstate=CT t:mailingzip=6514 m:farmer=7063

Meta Commands

metric m:farmer p:integer l:Farmer t:dataTypeName=number

entity e:q79s-2vp7 l:Agritourism t:attribution="Department of Agriculture" t:url=https://data.ct.gov/api/views/q79s-2vp7

property e:q79s-2vp7 t:meta.view v:id=q79s-2vp7 v:category="Environment and Natural Resources" v:attributionLink="http://www.ct.gov/doag/cwp/view.asp?a=3260&q=412796" v:averageRating=0 v:name=Agritourism v:attribution="Department of Agriculture"

property e:q79s-2vp7 t:meta.view.license v:name="Public Domain"

property e:q79s-2vp7 t:meta.view.owner v:id=cvy9-n6sb v:screenName="Tyler Kleykamp" v:lastNotificationSeenAt=1492608796 v:displayName="Tyler Kleykamp"

property e:q79s-2vp7 t:meta.view.tableauthor v:id=cvy9-n6sb v:screenName="Tyler Kleykamp" v:roleName=administrator v:lastNotificationSeenAt=1492608796 v:displayName="Tyler Kleykamp"

Top Records

| farmer | location_id | business_name                           | business_street_address | business_name_line_2 | town           | county            | phone        | fax          | email                     | mailingaddress                | mailingaddress2 | mailingtown    | mailingstate | mailingzip | web                                     | programyear | status | description                                                                                                                                                                                                                                | corn_maze | pumpkins | hay_rides | large_fruit | fall_festival | mums | other | otherdescription                 | comments | recnumber | farm_dinners | winerys | farmtours | pyo | 
| ====== | =========== | ======================================= | ======================= | ==================== | ============== | ================= | ============ | ============ | ========================= | ============================= | =============== | ============== | ============ | ========== | ======================================= | =========== | ====== | ========================================================================================================================================================================================================================================== | ========= | ======== | ========= | =========== | ============= | ==== | ===== | ================================ | ======== | ========= | ============ | ======= | ========= | === | 
| 7096   | 14846       | Holmberg Orchards and Winery            | 12 Orchard Drive        |                      | Gales Ferry    | New London County | 860-464-7305 | 860-464-2250 | amy@holmbergorchards.com  | 12 Orchard Drive. 1990 Rte 12 |                 | Gales Ferry    | CT           | 6335       | [http://www.holmbergorchards.com, null] | 2014        | ACTIVE |                                                                                                                                                                                                                                            |           |          | HR        |             | FF            |      | O     | Bakery, farm stand, winery, Mums |          | 354       |              |         |           | PO  | 
| 6249   | 14865       | Uconn Coll. Of Agri & Natural Resources | Rte. 195                |                      | Storrs         | Windham County    | 860-486-1076 |              | sara.putnam@uconn.edu     | 1376 Storrs Road              |                 | Storrs         | CT           |            | [null, null]                            | 2014        | ACTIVE | Join us at the annual Cornucopia Fest on September 21 2014. Visit, www.cag.uconn.edu for information.                                                                                                                                      |           |          | HR        |             | FF            |      | O     | mums                             |          | 371       |              |         |           |     | 
| 7063   | 14843       | Hindinger Farm                          | 835 Dunbar Hill Road    |                      | Hamden         | New Haven County  | 203-288-0700 | 203-288-3265 | info@hindingersfarm.com   | 810 Dunbar Hill Road          |                 | Hamden         | CT           | 6514       | [http://www.hindingersfarm.com, null]   | 2014        | ACTIVE | Strawberry festival held on the Saturday of Father?s Day weekend. We have hayrides, strawberry ice cream, and strawberry shortcake, and Glenwood Drive-In cooks up hamburgers and hot dogs. There are lots of activities for the children. |           |          | HR        |             |               |      |       |                                  |          | 352       |              |         |           |     | 
| 6453   | 14835       | Double D Living History Farm            | 102 Painter Hill Road   |                      | Roxbury        | Litchfield County | 860-354-0649 | 860-354-1096 | ddlivinghistory@aol.com   | 102 Painter Hill Road         |                 | Roxbury        | CT           | 6783       | [null, null]                            | 2014        | ACTIVE |                                                                                                                                                                                                                                            |           |          |           |             |               |      |       |                                  |          | 344       |              |         | FT        |     | 
| 8227   | 14837       | ROSE ORCHARDS                           | 33 Branford Road        |                      | North Branford | New Haven County  | 203-488-7996 | 203-488-1068 | info@roseorchardsfarm.com | 33 Branford Road              |                 | North Branford | CT           | 6471       | [null, null]                            | 2014        | ACTIVE |                                                                                                                                                                                                                                            |           |          | HR        |             |               |      |       |                                  |          | 346       |              |         |           | PO  | 
| 6031   | 14838       | Brown's Harvest                         | 1911 Poquonock Ave.     |                      | Windsor        | Hartford County   | 860-683-0266 | 860-683-0267 | brownsharvest@yahoo.com   | 60 Rainbow Road               |                 | Windsor        | CT           | 6095       | [http://www.brownsharvest.com, null]    | 2014        | ACTIVE |                                                                                                                                                                                                                                            | CM        |          | HR        |             | FF            |      |       |                                  |          | 347       |              |         | FT        |     | 
| 8178   | 14828       | Roberts Orchard                         | 125 Hill Street         |                      | Bristol        | Hartford County   | 860-582-5314 |              | plarbs@yahoo.com          | 125 Hill Street               |                 | Bristol        | CT           | 6010       | [null, null]                            | 2014        | ACTIVE | The host orchard for the 2007 Bristol Mum Festival, we have pumpkins and large fruits.                                                                                                                                                     |           |          |           |             |               |      | O     | Pumpkins, Large Fruit            |          | 337       |              |         |           |     | 
| 7549   | 14851       | March Farm                              | 160 Munger Lane         |                      | Bethlehem      | Litchfield County | 203-266-7721 | 203-266-6076 | marchfarms@marchfarms.com | 160 Munger Lane               |                 | Bethlehem      | CT           | 6751       | [http://www.marchfarms.com, null]       | 2014        | ACTIVE |                                                                                                                                                                                                                                            | CM        |          | HR        |             | FF            |      | O     | Pumpkins, Large Fruit, Mums      |          | 358       |              |         |           | PO  | 
| 10060  | 14840       | Devon Point Farm & Cattle Company       | 54 Joy Road             |                      | Woodstock      | Windham County    | 860-974-9004 | 860-974-9004 | devonpointfarm@gmail.com  | 93 Pulpit Rock Road           |                 | Woodstock      | CT           | 6281       | [http://www.DevonPointFarm.com, null]   | 2014        | ACTIVE | Fall Harvest and Halloween Festival-weekends from September 15 to October 31, visit www.devonpointfarm.com for dates and details. Pumpkins, winter squash, gourds, kids? activities, harvest and Halloween fun!                            |           |          | HR        |             | FF            |      | O     | Pumpkins                         |          | 349       |              |         |           | PO  | 
| 7243   | 14847       | Karabin Farms                           | 894 Andrews Street      |                      | Southington    | Hartford County   | 860-620-0194 | 860-621-2058 | farmingct@cox.net         | 894 Andrews Street            |                 | Southington    | CT           | 6489       | [http://www.karabinfarms.com, null]     | 2014        | ACTIVE | A working family farm and country store with green.                                                                                                                                                                                        |           |          | HR        |             |               |      | O     | Pumpkins, Large Fruit            |          | 355       |              |         |           | PO  |