List of Electrical substations in United States

[
  {
    "name": "Genesis Energy Systems",
    "address": "43**********",
    "phone": "********8561",
    "email": "in**@XO**********",
    "lat": 40.9729119,
    "lng": -73.8362153,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "Yonkers",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Electrical substations"
  },
  {
    "name": "Smithville Electric Systems",
    "address": "61**********",
    "phone": "********4735",
    "email": "sm**********@gm*******",
    "lat": 35.9576112,
    "lng": -85.7974113,
    "url": "ht**********",
    "country": "United States",
    "state": "Tennessee",
    "city": "Smithville",
    "star_count": 2.6,
    "rating_count": 5,
    "category_name": "Electrical substations"
  },
  {
    "name": "Endure Energy LLC",
    "address": "74**********",
    "phone": "********4500",
    "email": "Me***@En**********",
    "lat": 38.8960908,
    "lng": -94.6722013,
    "url": "ht**********",
    "country": "United States",
    "state": "Kansas",
    "city": "Overland Park",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electric Consultants,Electric utility companies,Electrical substations"
  },
  {
    "name": "Tri-Point Substation Services",
    "address": "12**********",
    "phone": "********1511",
    "email": "Tr*******@tr**********",
    "lat": 33.4848038,
    "lng": -101.8360728,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Lubbock",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Electrical substations"
  },
  {
    "name": "National Circuit Breaker",
    "address": "13**********",
    "phone": "********0065",
    "email": "SA***@NA**********",
    "lat": 33.935725,
    "lng": -118.053956,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 2.3,
    "rating_count": 3,
    "category_name": "Electrical substations,Electrical wholesalers,Electrical supply stores"
  },
  {
    "name": "Electrical Technologies",
    "address": "16**********",
    "phone": "********0317",
    "email": "pr*****@el**********",
    "lat": 39.7856326,
    "lng": -105.1790231,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Golden",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical installation services,Electrical substations,Electrical equipment suppliers"
  },
  {
    "name": "Research Office Complex Support Building (ROS) PRC198 (0782)",
    "address": "10**********",
    "phone": "********9411",
    "email": "in**@ta**********",
    "lat": 30.3897275,
    "lng": -97.7255208,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Austin",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "PG&E Metcalf Transmission Substation",
    "address": "15**********",
    "phone": "********5000",
    "email": "bu**********@pg*****",
    "lat": 37.2247385,
    "lng": -121.7462152,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Jose",
    "star_count": 2.3,
    "rating_count": 12,
    "category_name": "Electrical substations"
  },
  {
    "name": "CTA 6320 Loomis Blvd Substation",
    "address": "63**********",
    "phone": "********0918",
    "email": "fe******@tr**********",
    "lat": 41.7787268,
    "lng": -87.6595418,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "Plan B Solutions",
    "address": "92**********",
    "phone": "********0349",
    "email": "SU*****@pl**********",
    "lat": 27.9995757,
    "lng": -82.6972992,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Clearwater",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Electrical substations"
  },
  {
    "name": "Southern Power Systems, Inc.",
    "address": "85**********",
    "phone": "********7807",
    "email": "in**@so*********",
    "lat": 30.5254882,
    "lng": -91.0652782,
    "url": "ht**********",
    "country": "United States",
    "state": "Louisiana",
    "city": "Central",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Electrical substations"
  },
  {
    "name": "No Outage Electrical Testing",
    "address": "20**********",
    "phone": "********0864",
    "email": "ze*@no**********",
    "lat": 27.9993247,
    "lng": -81.6730827,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Lake Wales",
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Electrical substations,Power stations"
  },
  {
    "name": "Hecla Substation",
    "address": "40**********",
    "phone": "********0310",
    "email": "in**@no**********",
    "lat": 45.7923467,
    "lng": -98.104132,
    "url": "ht**********",
    "country": "United States",
    "state": "South Dakota",
    "city": null,
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Electrical substations"
  },
  {
    "name": "Powertech Services Inc",
    "address": "",
    "phone": "********2280",
    "email": "co*****@po**********",
    "lat": 43.010809,
    "lng": -83.7410789,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Flint",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Service establishments,Companies,Electrical substations"
  },
  {
    "name": "E. Willardsville Substation",
    "address": "64**********",
    "phone": "********3107",
    "email": "in**@pe*******",
    "lat": 36.1313844,
    "lng": -78.854124,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "Public Counsel Office",
    "address": "20**********",
    "phone": "********4857",
    "email": "mo***@op********",
    "lat": 38.5758591,
    "lng": -92.1711393,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Jefferson City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "Switchgear Resources, inc.",
    "address": "12**********",
    "phone": "********5455",
    "email": "in**@sw**********",
    "lat": 32.65573,
    "lng": -97.1331248,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Arlington",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "Edison",
    "address": "63**********",
    "phone": "********4555",
    "email": "el******@sc*****",
    "lat": 34.08225,
    "lng": -117.9259049,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 2.3,
    "rating_count": 7,
    "category_name": "Electrical substations"
  },
  {
    "name": "MEMS Sub-station",
    "address": "30**********",
    "phone": "********1400",
    "email": "aa**********@me**********",
    "lat": 34.7565458,
    "lng": -92.2703707,
    "url": "ht**********",
    "country": "United States",
    "state": "Arkansas",
    "city": "North Little Rock",
    "star_count": 3.5,
    "rating_count": 2,
    "category_name": "Electrical substations"
  },
  {
    "name": "United Power Reunion Electrical Substation",
    "address": "To**********",
    "phone": "********8809",
    "email": "un**********@un**********",
    "lat": 39.8825037,
    "lng": -104.7679553,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Brighton",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Electrical substations,Governments,Electricians"
  },
  {
    "name": "Substation Reliability Experts",
    "address": "21**********",
    "phone": "********2991",
    "email": "Go****@sr**********",
    "lat": 35.207976,
    "lng": -80.865485,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Charlotte",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "VELCO Highgate Substation",
    "address": "26**********",
    "phone": "********9161",
    "email": "td***@ve*******",
    "lat": 44.9381804,
    "lng": -73.0533211,
    "url": "ht**********",
    "country": "United States",
    "state": "Vermont",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "High Voltage Equipment Diagnostics",
    "address": "Fo**********",
    "phone": "********4453",
    "email": "cr******@hv******",
    "lat": 43.77,
    "lng": -88.45,
    "url": "ht**********",
    "country": "United States",
    "state": "Wisconsin",
    "city": "Fond du Lac County",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "MP Predictive Technologies inc.",
    "address": "91**********",
    "phone": "********2581",
    "email": "sa***@mp**********",
    "lat": 28.4328651,
    "lng": -81.349176,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Orlando",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Instrumentation engineers,Industrial equipment suppliers,Electrical equipment suppliers,Electrical substations,Electrical repair shops"
  },
  {
    "name": "US Bonneville Power Administration",
    "address": "86**********",
    "phone": "********7000",
    "email": "cr***@bp*****",
    "lat": 43.9994861,
    "lng": -123.0156071,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "AVO Training Institute | Electrical Safety & Maintenance",
    "address": "45**********",
    "phone": "********3156",
    "email": "in**@av**********",
    "lat": 32.7506624,
    "lng": -96.8954481,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Dallas",
    "star_count": 4.7,
    "rating_count": 81,
    "category_name": "Electricians,Solar energy system services,Construction and maintenance offices,Certification agencies,Electrical substations,Utility contractors,Training schools,Electrical engineers"
  },
  {
    "name": "Wyoming Station Road",
    "address": "Cl**********",
    "phone": "",
    "email": "tj*****@ae*****",
    "lat": 37.6507339,
    "lng": -81.6702804,
    "url": "ht**********",
    "country": "United States",
    "state": "West Virginia",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "APS",
    "address": "W **********",
    "phone": "",
    "email": "St******@ap******",
    "lat": 33.4795061,
    "lng": -112.7076002,
    "url": "ht**********",
    "country": "United States",
    "state": "Arizona",
    "city": "Buckeye",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Electric utility companies,Electrical substations,Electric Consultants"
  },
  {
    "name": "PSEG",
    "address": "We**********",
    "phone": "",
    "email": "cl**********@ps******",
    "lat": 40.6277232,
    "lng": -74.322952,
    "url": "ht**********",
    "country": "United States",
    "state": "New Jersey",
    "city": "Scotch Plains",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Electrical substations"
  },
  {
    "name": "Mendota Hills Wind Farm",
    "address": "Co**********",
    "phone": "",
    "email": "in**@le**********",
    "lat": 41.7038061,
    "lng": -89.0390396,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": null,
    "star_count": 4.5,
    "rating_count": 4,
    "category_name": "Electrical substations"
  }
]