Texasの水道会社のリスト

[
  {
    "name": "Huntsville Water Department",
    "address": "12**********",
    "phone": "********5431",
    "email": "ut**********@hu**********",
    "lat": 30.72227,
    "lng": -95.5535338,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Huntsville",
    "star_count": 2.3,
    "rating_count": 15,
    "category_name": "Water utility companies"
  },
  {
    "name": "Omi",
    "address": "11**********",
    "phone": "********7861",
    "email": "jg*******@ci**********",
    "lat": 26.1690717,
    "lng": -98.0495324,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "McAllen",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "North Texas Municipal Water District Plant IV",
    "address": "77**********",
    "phone": "********0820",
    "email": "we*******@nt*******",
    "lat": 33.0286033,
    "lng": -96.5195215,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Plano",
    "star_count": 4.3,
    "rating_count": 11,
    "category_name": "Water utility companies"
  },
  {
    "name": "Seabrook Water Utility Billing",
    "address": "17**********",
    "phone": "********5678",
    "email": "ma***@se**********",
    "lat": 29.564438,
    "lng": -95.0239833,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 2,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Quadvest",
    "address": "16**********",
    "phone": "********5347",
    "email": "su*****@qu**********",
    "lat": 30.2161571,
    "lng": -95.3338877,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": null,
    "star_count": 1,
    "rating_count": 12,
    "category_name": "Water utility companies"
  },
  {
    "name": "Kennedale Utility Billing",
    "address": "40**********",
    "phone": "********2120",
    "email": "in**@ci**********",
    "lat": 32.6474866,
    "lng": -97.2257693,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Arlington",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "North Texas Municipal Water District",
    "address": "30**********",
    "phone": "********0680",
    "email": "we*******@nt*******",
    "lat": 33.124608,
    "lng": -96.5640894,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Plano",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "North McKinney Lift Station",
    "address": "Gr**********",
    "phone": "********5405",
    "email": "we*******@nt*******",
    "lat": 33.1966342,
    "lng": -96.5974201,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Celina",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "City of Waco Water Department",
    "address": "42**********",
    "phone": "********2489",
    "email": "wa*******@wa********",
    "lat": 31.5563373,
    "lng": -97.1308277,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Waco",
    "star_count": 2.1,
    "rating_count": 57,
    "category_name": "Water utility companies"
  },
  {
    "name": "WHCRWA",
    "address": "Ph**********",
    "phone": "********6400",
    "email": "wh****@tx**********",
    "lat": 29.7307894,
    "lng": -95.4289191,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  }
]