List of Media houses in Connecticut

[
  {
    "name": "CALIM Media",
    "address": "27**********",
    "phone": "********8202",
    "email": "",
    "lat": 41.0698921,
    "lng": -73.549126,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Stamford",
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Media houses"
  },
  {
    "name": "AldenteMediaGroup",
    "address": "",
    "phone": "********8415",
    "email": "",
    "lat": 41.7656874,
    "lng": -72.680087,
    "url": "",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hartford",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Service establishments,Media houses"
  },
  {
    "name": "Murray's MS Extravaganza",
    "address": "",
    "phone": "********9695",
    "email": "",
    "lat": 41.7656874,
    "lng": -72.680087,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hartford",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media houses,Service establishments,Companies"
  },
  {
    "name": "Factory Underground Studio",
    "address": "16**********",
    "phone": "********8672",
    "email": "fa**********@gm*******",
    "lat": 41.1159378,
    "lng": -73.4133921,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Norwalk",
    "star_count": 4.8,
    "rating_count": 87,
    "category_name": "Graphic designers,Media companies,Video editing services,Media houses,Music management and promotions,Marketing agencies,Video production services,Music producers,Recording studios"
  },
  {
    "name": "TradeWinds US",
    "address": "10**********",
    "phone": "********2994",
    "email": "ad*******@tr**********",
    "lat": 41.0531494,
    "lng": -73.5429864,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Stamford",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media houses,Newspaper publishers"
  },
  {
    "name": "Javier Jose | Media Designer",
    "address": "",
    "phone": "********9400",
    "email": "ja****@ja**********",
    "lat": 41.5807753,
    "lng": -72.8880679,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Graphic designers,Service establishments,Video editing services,Photo Restoration Shops,Media houses,Photo restoration services"
  },
  {
    "name": "MacMillan Films",
    "address": "65**********",
    "phone": "********0507",
    "email": "ja***@ma**********",
    "lat": 41.0517531,
    "lng": -73.5714071,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Greenwich",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Film Production Companies,Media houses"
  },
  {
    "name": "Brand Applause",
    "address": "65**********",
    "phone": "********0507",
    "email": "ja***@ma**********",
    "lat": 41.0517531,
    "lng": -73.5714071,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Greenwich",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Photographers,Video production services,Media houses,Video editing services"
  },
  {
    "name": "BrandGenes",
    "address": "91**********",
    "phone": "",
    "email": "ge*****@br**********",
    "lat": 41.5490816,
    "lng": -72.676949,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Middletown",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media houses,Marketing agencies,Film Production Companies"
  },
  {
    "name": "Longe Magazine",
    "address": "92**********",
    "phone": "********6797",
    "email": "",
    "lat": 41.2447626,
    "lng": -73.1975165,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Trumbull",
    "star_count": 4.7,
    "rating_count": 26,
    "category_name": "Marketing agencies,Clothing Accessories Stores,Media houses,Entertainment agencies,Internet marketing services,Advertising agencies,Event planners,Fashion accessories stores,Business to business services"
  }
]