Список Подрядчики в Connecticut

[
  {
    "name": "The Home Improvement Company",
    "address": "",
    "phone": "********1897",
    "email": "91*********@gm*******",
    "lat": 41.317135,
    "lng": -73.511667,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Ridgefield",
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Handyman/Handywoman/Handypeople,Electricians,Service establishments,Contractors,Deck builders,Carpenters,Companies,Home builders,Handymen,General contractors"
  },
  {
    "name": "Eco Home Improvement & Remodeling LLC",
    "address": "21**********",
    "phone": "********4250",
    "email": "in**@wa**********",
    "lat": 41.7575843,
    "lng": -72.7243421,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hartford",
    "star_count": 4.8,
    "rating_count": 16,
    "category_name": "Carpenters,Contractors,Tile contractors,Flooring contractors,Painters,Wood floor installation services,Insulation contractors"
  },
  {
    "name": "Ads are blocked",
    "address": "14**********",
    "phone": "********2258",
    "email": "in**@do**********",
    "lat": 41.9880787,
    "lng": -72.5817586,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Enfield",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Contractors"
  },
  {
    "name": "D2 Interieurs",
    "address": "17**********",
    "phone": "********7048",
    "email": "de****@d2**********",
    "lat": 41.215391,
    "lng": -73.3825433,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Contractors"
  },
  {
    "name": "Generator Repair",
    "address": "25**********",
    "phone": "********8819",
    "email": "sa***@ge**********",
    "lat": 41.3886453,
    "lng": -72.9005203,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hamden",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Contractors"
  },
  {
    "name": "Terra Energy Consultants",
    "address": "51**********",
    "phone": "********6192",
    "email": "Su*****@Ti**********",
    "lat": 41.5916005,
    "lng": -72.711715,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Middletown",
    "star_count": 5,
    "rating_count": 21,
    "category_name": "Solar energy contractors,Contractors,Solar energy system services,Solar Energy Companies"
  },
  {
    "name": "General Contracting Services",
    "address": "",
    "phone": "********1551",
    "email": "pa**********@ho**********",
    "lat": 41.210457,
    "lng": -73.0533434,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Milford",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Service establishments,Contractors"
  },
  {
    "name": "Fournier Irrigation, LLC",
    "address": "33**********",
    "phone": "********9397",
    "email": "se*****@fo**********",
    "lat": 41.7767408,
    "lng": -72.6404224,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hartford",
    "star_count": 4.7,
    "rating_count": 64,
    "category_name": "Contractors"
  },
  {
    "name": "MPires Construction",
    "address": "24**********",
    "phone": "********1606",
    "email": "in**@mp**********",
    "lat": 41.184812,
    "lng": -73.25558,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Fairfield",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Contractors"
  },
  {
    "name": "Eco Home Improvement & Remodeling - Construction Company",
    "address": "21**********",
    "phone": "********4250",
    "email": "in**@wa**********",
    "lat": 41.7575843,
    "lng": -72.7243421,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hartford",
    "star_count": 4.8,
    "rating_count": 22,
    "category_name": "Painters,Wood floor installation services,Insulation contractors,Flooring contractors,Carpenters,Contractors,Tile contractors"
  }
]