{"gallery_project_data":{"gallery_project":{"featured":false,"gallery_project_category":{"id":1,"name":"General","slug":"general","created_at":"2017-03-14T16:56:43.926-04:00","updated_at":"2017-03-24T11:30:10.745-04:00","description":"There are no limits to the type of content generated with Wordsmith. See examples from many verticals, and find one that fits your content needs. Don't see a project that matches your needs? Contact us and we'll help get you started. "},"id":55,"image_url":"https://dj65vgnq591pm.cloudfront.net/projects/city-guide/images/image.png?1749744961","project_name":"City Guide","project_id":24995,"project_slug":"city-guide","project_description":"Highlight hidden gems and local favorites that are unique to each town with the City Guide Project.","template_image_url":"https://dj65vgnq591pm.cloudfront.net/projects/city-guide/images/template_image.png?1749744961","metadata":{"featuredColumns":[1,2,3,4,5],"scenarios":[{"name":"Seattle","row":6},{"name":"NOLA","row":8},{"name":"NYC","row":10}],"segmentTotals":{"synonym":400,"branch":77,"datavar":87}}},"project":{"id":24995,"name":"City Guide","organization_id":4439,"created_at":"2017-10-31T09:00:26.664-04:00","updated_at":"2019-03-04T08:19:30.625-05:00","deleted_at":null,"slug":"city-guide","archived":false,"raw_csv_filename":"city-guide.csv","description":"Highlight hidden gems and local favorites that are unique to each town with the City Guide Project.","creator_id":1565,"editor_id":6456,"project_type":"gallery","source_id":null,"encrypted_csv_id":"25e8a067d7430cec7c854dc4af80b1fd755cf22a65cb22a41a2b98535806","api_project_id":null,"encrypted_data_id":"35e7f0d62e9b186a6cc5e7ec55d7132efda7dc0c4045d8ae676370b8c98b","integration_type":null,"reference_id":"73e549f0035a6ec6ac4aabdbfabb7ab0","external_tool":null,"visualization_url":null,"wordsmith_integration":false,"ds_integration_id":null},"dataset":{"columns":[{"name":"msa","type":"String","example":["Houston","Denver","Charlotte"],"index":0,"value":"msa"},{"name":"state","type":"String","example":["Texas","Colorado","North Carolina"],"index":1,"value":"state"},{"name":"state_capital","type":"Boolean","example":["FALSE","TRUE","FALSE"],"index":2,"value":"state_capital"},{"name":"nickname","type":"String","example":["Space City","the Mile High City","the Queen City"],"index":3,"value":"nickname"},{"max":46.0,"min":1.0,"sum":236.0,"name":"national_pop_rank","type":"Number","average":16.85714285714286,"example":["5","19","22"],"index":4,"value":"national_pop_rank"},{"max":2.0,"min":1.0,"sum":17.0,"name":"state_pop_rank","type":"Number","average":1.214285714285714,"example":["2","1","1"],"index":5,"value":"state_pop_rank"},{"max":14.4,"min":-0.6,"sum":93.7,"name":"7_yr_growth","type":"Number","average":6.692857142857143,"example":["14.4","12.2","11.6"],"index":6,"value":"7_yr_growth"},{"name":"major_museums","type":"List","example":["the Museum of Fine Arts, Houston Museum of Natural Science, Holocaust Museum","the Denver Museum of Nature and Science, Denver Art Museum, History Colorado Center","the Mint Museum, NASCAR Hall of Fame, Bechtler Museum of Modern Art"],"subType":"String","index":7,"value":"major_museums"},{"name":"addl_museums","type":"List","example":["the Health Museum, Buffalo Soldier National Museum, Space Center Houston, ArtCar Museum, Museum of Fine Arts, Houston Museum of Natural Science","Molly Brown House, Children's Museum of Denver, Fomey Transportation Museum, Clyfford Still Museum","the Levine Museum of the New South, Discovery Place, Carolinas Aviation Museums"],"subType":"String","index":8,"value":"addl_museums"},{"name":"major_outdoors","type":"List","example":["Hermann Park, Buffalo Bayou Park, Memorial Park","Denver Botanic Gardens, Mount Evans, Washington Park","Freedom Park, Lake Norman, Little Sugar Creek Greenway"],"subType":"String","index":9,"value":"major_outdoors"},{"name":"addl_outdoors","type":"List","example":["Discovery Green, Bayou Bend, Cullen Sculpture Garden, East End Park, Smither Park","Denver Mountain Parks, Cherry Creek Trail, Civic Center Park, Denver City Park, South Platte River Trail, Cheesman Park","McDowell Nature Center, Fourth Ward Park, Romare Bearden Park, the Booty Loop"],"subType":"String","index":10,"value":"addl_outdoors"},{"max":97.0,"min":3.0,"sum":564.0,"name":"park_score_17","type":"Number","average":40.28571428571428,"example":["81","20","97"],"index":11,"value":"park_score_17"},{"max":95.0,"min":5.0,"sum":561.0,"name":"park_score_16","type":"Number","average":40.07142857142857,"example":["78","20","95"],"index":12,"value":"park_score_16"},{"name":"addl_attractions","type":"List","example":["NASA Space Center, Cockrell Butterfly Center, Waterwall, Theatre Under the Stars, Rodeo Houston, Glenwood Cemetery, Rothko Chapel, Beercan House","Larimer Square, United States Mint, Mayan Theatre, Downtown Aquarium, Ogden Theatre, Bluebird Theater","Blumenthal Performing Arts Center, Carowinds, U.S. National Whitewater Center, Hall Family Farm, Metalmorphosis, Historic Rosedale Plantation, the Fillmore"],"subType":"String","index":13,"value":"addl_attractions"},{"name":"major_sports","type":"List","example":["Astros, Texans, Rockets","Broncos, Rockies, Nuggets, Avalanche","Panthers, Hornets"],"subType":"String","index":14,"value":"major_sports"},{"name":"addl_sports","type":"List","example":["Dynamo, Aeros","Rapids","Knights, Checkers, Hounds, Independence"],"subType":"String","index":15,"value":"addl_sports"}],"data":[{"msa":"Houston","state":"Texas","state_capital":"FALSE","nickname":"Space City","national_pop_rank":"5","state_pop_rank":"2","7_yr_growth":"14.4","major_museums":"the Museum of Fine Arts, Houston Museum of Natural Science, Holocaust Museum","addl_museums":"the Health Museum, Buffalo Soldier National Museum, Space Center Houston, ArtCar Museum, Museum of Fine Arts, Houston Museum of Natural Science","major_outdoors":"Hermann Park, Buffalo Bayou Park, Memorial Park","addl_outdoors":"Discovery Green, Bayou Bend, Cullen Sculpture Garden, East End Park, Smither Park","park_score_17":"81","park_score_16":"78","addl_attractions":"NASA Space Center, Cockrell Butterfly Center, Waterwall, Theatre Under the Stars, Rodeo Houston, Glenwood Cemetery, Rothko Chapel, Beercan House","major_sports":"Astros, Texans, Rockets","addl_sports":"Dynamo, Aeros"},{"msa":"Denver","state":"Colorado","state_capital":"TRUE","nickname":"the Mile High City","national_pop_rank":"19","state_pop_rank":"1","7_yr_growth":"12.2","major_museums":"the Denver Museum of Nature and Science, Denver Art Museum, History Colorado Center","addl_museums":"Molly Brown House, Children's Museum of Denver, Fomey Transportation Museum, Clyfford Still Museum","major_outdoors":"Denver Botanic Gardens, Mount Evans, Washington Park","addl_outdoors":"Denver Mountain Parks, Cherry Creek Trail, Civic Center Park, Denver City Park, South Platte River Trail, Cheesman Park","park_score_17":"20","park_score_16":"20","addl_attractions":"Larimer Square, United States Mint, Mayan Theatre, Downtown Aquarium, Ogden Theatre, Bluebird Theater","major_sports":"Broncos, Rockies, Nuggets, Avalanche","addl_sports":"Rapids"},{"msa":"Charlotte","state":"North Carolina","state_capital":"FALSE","nickname":"the Queen City","national_pop_rank":"22","state_pop_rank":"1","7_yr_growth":"11.6","major_museums":"the Mint Museum, NASCAR Hall of Fame, Bechtler Museum of Modern Art","addl_museums":"the Levine Museum of the New South, Discovery Place, Carolinas Aviation Museums","major_outdoors":"Freedom Park, Lake Norman, Little Sugar Creek Greenway","addl_outdoors":"McDowell Nature Center, Fourth Ward Park, Romare Bearden Park, the Booty Loop","park_score_17":"97","park_score_16":"95","addl_attractions":"Blumenthal Performing Arts Center, Carowinds, U.S. National Whitewater Center, Hall Family Farm, Metalmorphosis, Historic Rosedale Plantation, the Fillmore","major_sports":"Panthers, Hornets","addl_sports":"Knights, Checkers, Hounds, Independence"},{"msa":"Nashville","state":"Tennessee","state_capital":"TRUE","nickname":"Music City","national_pop_rank":"36","state_pop_rank":"1","7_yr_growth":"11.6","major_museums":"the Country Music Hall of Fame, Parthenon, Johnny Cash Museum","addl_museums":"the Lane Motor Museum, Tennessee State Museum, George Jones Museum, Frist Center for the Visual Arts","major_outdoors":"Radnor Lake State Park, Bicentennial Capitol Mall, Centennial Park","addl_outdoors":"Riverfront Park, Lockeland Springs Park, Fort Negley, Shelby Bottoms Greenway","park_score_17":"53","park_score_16":"55","addl_attractions":"Ryman Auditorium, Opryland, Belmont Mansion, Cheekwood Botanical Gardens, Fontanel Mansion, Marathon Village, Belle Meade Plantation","major_sports":"Titans, Predators","addl_sports":"Sounds"},{"msa":"Las Vegas","state":"California","state_capital":"FALSE","nickname":"Sin City","national_pop_rank":"29","state_pop_rank":"1","7_yr_growth":"10.5","major_museums":"the Neon Museum, Mob Museum, Pinball Hall of Fame","addl_museums":"the National Atomic Testing Museum, Discovery Children's Museum, the Natural History Museum","major_outdoors":"Red Rock Canyon, Hoover Dam, Mount Charleston","addl_outdoors":"Clark County Wetlands, Sloan Canyon, Springs Preserve","park_score_17":"24","park_score_16":"31","addl_attractions":"the Strip, Bellagio Conservatory, Bellagio Fountains, the High Roller","major_sports":"Golden Knights","addl_sports":"51s"},{"msa":"Seattle","state":"Washington","state_capital":"FALSE","nickname":"the Emerald City","national_pop_rank":"15","state_pop_rank":"1","7_yr_growth":"10.4","major_museums":"the Seattle Art Museum, Museum of Pop Culture, Frye Art Museum","addl_museums":"the Museum of Flight, Museum of History \u0026 Industry, Living Computers Museum, Pacific Science Center, the Seattle Asian Art Museum","major_outdoors":"Green Lake Park, Discovery Park, Alki Beach, Kerry Park","addl_outdoors":"Washington Park Arboretum, Chittenden Locks, Olympic Sculpture Park","park_score_17":"11","park_score_16":"13","addl_attractions":"Pike Place Market, the Space Needle, Chihuly Garden and Glass, the Gum Wall, the Seattle Great Wheel","major_sports":"Seahawks, Mariners","addl_sports":"Storm, Sounders FC, Reign FC"},{"msa":"San Francisco","state":"California","state_capital":"FALSE","nickname":"Frisco","national_pop_rank":"11","state_pop_rank":"2","7_yr_growth":"7.9","major_museums":"the San Francisco Museum of Modern Art, Exploratorium, De Young","addl_museums":"the Asian Art Museum of San Francisco, San Francisco Cable Car Museum, Children's Creativity Museum, Contemporary Jewish Museum, Walt Disney Family Museum","major_outdoors":"Muir Woods, Golden Gate Park, Baker Beach","addl_outdoors":"Crissy Field, Angel Island State Park, Mission Delores Park, Presidio of San Francisco, Twin Peaks, Lands End","park_score_17":"3","park_score_16":"5","addl_attractions":"the Golden Gate Bridge, Alcatraz Island, Chinatown, Lombard Street, Napa wine, Pier 39","major_sports":"Giants, Athletics, 49ers, Raiders, Sharks","addl_sports":"Earthquakes"},{"msa":"New Orleans","state":"Louisiana","state_capital":"FALSE","nickname":"the Big Easy","national_pop_rank":"46","state_pop_rank":"1","7_yr_growth":"6.6","major_museums":"the National WWII Museum, the Historic New Orleans Collection, the New Orleans Historic Voodoo Museum","addl_museums":"the Cabildo, Ogden Museum of Southern Art, New Orleans Pharmacy Museum","major_outdoors":"Audubon Park, New Orleans City Park, New Orleans Music Legends Park","addl_outdoors":"Louis Armstrong Park, Jean Lafitte National Historical Park and Preserve","park_score_17":"37","park_score_16":"41","addl_attractions":"Bourbon Street, Preservation Hall, Jackson Square, St. Louis Cathedral, Lake Pontchartrain","major_sports":"Saints, Pelicans","addl_sports":"Baby Cakes"},{"msa":"Los Angeles","state":"California","state_capital":"FALSE","nickname":"the City of Angels","national_pop_rank":"2","state_pop_rank":"1","7_yr_growth":"3.7","major_museums":"the Los Angeles County Museum of Art, California Science Center, L.A. Museum of the Holocaust","addl_museums":"the Broad, Hammer Museum, J. Paul Getty Museum, Griffith Observatory, Natural History Museum of Los Angeles County","major_outdoors":"Griffith Park, Venice Beach, Santa Monica Bay","addl_outdoors":"Topanga State Park, Runyon Canyon Park, Los Angeles Zoo \u0026 Botanical Gardens","park_score_17":"74","park_score_16":"65","addl_attractions":"Universal Studios Hollywood, La Brea Tar Pits, Venice Skate Park, Microsoft Theater, the Greek Theatre, Sunset Ranch Hollywood","major_sports":"Dodgers, Angels, Chargers, Rams, Lakers, Clippers, Ducks, Kings","addl_sports":"Sparks, Galaxy"},{"msa":"New York","state":"New York","state_capital":"FALSE","nickname":"the Big Apple","national_pop_rank":"1","state_pop_rank":"1","7_yr_growth":"3","major_museums":"the Metropolitan Museum of Art, the Museum of Modern Art, Guggenheim Museum","addl_museums":"the Frick Collection, New-York Historical Society, National September 11 Memorial","major_outdoors":"Central Park, Union Square, Battery Park, Roosevelt Island","addl_outdoors":"Washington Square Park, the High Line, Bryant Park","park_score_17":"7","park_score_16":"7","addl_attractions":"30 Rock, the Statue of Liberty, Broadway, the Empire State Building","major_sports":"Yankees, Mets, Giants, Jets, Knicks, Nets, Rangers, Islanders","addl_sports":"Liberty, Red Bulls, New York City FC"},{"msa":"Philadelphia","state":"Pennsylvania","state_capital":"FALSE","nickname":"the City of Brotherly Love","national_pop_rank":"7","state_pop_rank":"1","7_yr_growth":"1.8","major_museums":"Independence Hall, Philadelphia Museum of Art","addl_museums":"Please Touch Museum, Mütter Musum, Franklin Institute, Rodin Museum","major_outdoors":"Morris Arboretum, Wissahickon Valley Park, Spruce Street Harbor Park","addl_outdoors":"Love Park, Shofuso Japanese House and Garden","park_score_17":"32","park_score_16":"22","addl_attractions":"the Magic Gardens, One Liberty Observation Deck, United States Mint, Rocky Statue, Benjamin Franklin's Grave","major_sports":"Phillies, Eagles, 76ers, Flyers","addl_sports":"Union"},{"msa":"Chicago","state":"Illinois","state_capital":"FALSE","nickname":"the Windy City","national_pop_rank":"3","state_pop_rank":"1","7_yr_growth":"0.6","major_museums":"the Art Institute of Chicago, Field Museum of Natural History","addl_museums":"Adler Planetarium, Museum of Science and Industry, Museum of Contemporary Art","major_outdoors":"Millenium Park, Lakefront Trail, Lincoln Park","addl_outdoors":"Maggie Daley Park, Grant Park, Oak Street Beach, Lurie Garden","park_score_17":"11","park_score_16":"15","addl_attractions":"Cloud Gate, the Magnificient Mile, Lincoln Park Zoo, Garfield Park Conservatory, Chicago River, Shedd Aquarium","major_sports":"Cubs, White Sox, Bears, Bulls, Blackhawks","addl_sports":"Fire, Sky, Red Stars"},{"msa":"Detroit","state":"Michigan","state_capital":"FALSE","nickname":"the Motor City","national_pop_rank":"14","state_pop_rank":"1","7_yr_growth":"0","major_museums":"Detroit Institute of Arts, Hitsville U.S.A., Detroit Historical Museum","addl_museums":"the Henry Ford, African Bead Museum, Charles A. Wright Museum of African American History, Michigan Science Center","major_outdoors":"Belle Isle Park, Anna Scripps Whitcomb Conservatory","addl_outdoors":"William G. Milliken State Park, West Riverfront Park, Grand Circus Park","park_score_17":"75","park_score_16":"75","addl_attractions":"Fox Theatre, Detroit Opera House, Detroit Urban Exploration, Corktown, Sea Life Michigan Aquarium, Historic Fort Wayne, Campus Martius Park","major_sports":"Tigers, Lions, Pistons, Red Wings","addl_sports":""},{"msa":"Pittsburgh","state":"Pennsylvania","state_capital":"FALSE","nickname":"the Steel City","national_pop_rank":"26","state_pop_rank":"2","7_yr_growth":"-0.6","major_museums":"the Andy Warhol Museum, Heinz History Center, Carnegie Museum of Natural History","addl_museums":"Bicycle Heaven, Children's Museum of Pittsburgh, Carnegie Museum of Art","major_outdoors":"Phipps Conservatory, Mount Washington, Frick Park","addl_outdoors":"Point State Park, Three Rivers Heritage Trail, Schenley Park","park_score_17":"39","park_score_16":"39","addl_attractions":"the Duquesne Incline, National Aviary, Pittsburgh Water Steps, Sri Venkateswara Temple, Andy Warhol Bridge","major_sports":"Pirates, Steelers, Penguins","addl_sports":"Riverhounds, Sledgehammers"}],"total":14,"formulas":[{"name":"addl_sports_ct","type":"Number","example":[2,1,4],"formula_id":101790,"ancestor_ids":[101790],"has_error":false},{"name":"major_sports_ct","type":"Number","example":[3,4,2],"formula_id":101791,"ancestor_ids":[101791],"has_error":false},{"name":"addl_attractions_ct","type":"Number","example":[8,6,7],"formula_id":101792,"ancestor_ids":[101792],"has_error":false},{"name":"park_score_delta","type":"Number","example":[-3,0,-2],"formula_id":101793,"ancestor_ids":[101793],"has_error":false},{"name":"addl_outdoors_ct","type":"Number","example":[5,6,4],"formula_id":101794,"ancestor_ids":[101794],"has_error":false},{"name":"major_outdoors_ct","type":"Number","example":[3,3,3],"formula_id":101795,"ancestor_ids":[101795],"has_error":false},{"name":"addl_museum_ct","type":"Number","example":[6,4,3],"formula_id":101796,"ancestor_ids":[101796],"has_error":false},{"name":"major_museum_ct","type":"Number","example":[3,3,3],"formula_id":101797,"ancestor_ids":[101797],"has_error":false}]},"row_count":14,"col_count":16}}