Texasの水道会社のリスト

[
  {
    "name": "Seminole Water Department",
    "address": "30**********",
    "phone": "********3621",
    "email": "WS**********@se**********",
    "lat": 32.716367,
    "lng": -102.6454549,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Seminole",
    "star_count": 2,
    "rating_count": 11,
    "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": "Woodlands Water Agency",
    "address": "24**********",
    "phone": "********1271",
    "email": "bi**********@wo**********",
    "lat": 30.1635861,
    "lng": -95.4696502,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "The Woodlands",
    "star_count": 2.6,
    "rating_count": 26,
    "category_name": "Water utility companies"
  },
  {
    "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": "New Braunfels Utilities",
    "address": "Cu**********",
    "phone": "********8400",
    "email": "cu**********@nb**********",
    "lat": 29.6878181,
    "lng": -98.1093669,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "San Antonio",
    "star_count": 3.1,
    "rating_count": 393,
    "category_name": "Water utility companies,Electric utility companies,Electric Consultants"
  },
  {
    "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": 1.5,
    "rating_count": 4,
    "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": "Quadvest",
    "address": "26**********",
    "phone": "********5347",
    "email": "su*****@qu**********",
    "lat": 30.1507568,
    "lng": -95.5966186,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": null,
    "star_count": 1.4,
    "rating_count": 149,
    "category_name": "Water utility companies"
  },
  {
    "name": "Bedford Water Billing Office",
    "address": "18**********",
    "phone": "********2112",
    "email": "cu**********@be**********",
    "lat": 32.8423485,
    "lng": -97.1405659,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Bedford",
    "star_count": 2.1,
    "rating_count": 15,
    "category_name": "Water utility companies,Drainage services"
  }
]