List of Offices in Northern America

[
  {
    "name": "Rodney Scout Reservation Headquarters",
    "address": "No**********",
    "phone": "********5888",
    "email": "ca*****@dm******",
    "lat": 39.5104974,
    "lng": -75.981621,
    "url": "ht**********",
    "country": "United States",
    "state": "Maryland",
    "city": "North East",
    "star_count": 4.8,
    "rating_count": 13,
    "category_name": "Offices"
  },
  {
    "name": "Information Services",
    "address": "66**********",
    "phone": "********7000",
    "email": "he**@up****",
    "lat": 45.5761497,
    "lng": -122.7309241,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Portland",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Offices"
  },
  {
    "name": "Northeast Regional Outreach Office",
    "address": "60**********",
    "phone": "********0825",
    "email": "no**********@us*******",
    "lat": 40.7521234,
    "lng": -73.9787369,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "New York City",
    "star_count": 2,
    "rating_count": 1,
    "category_name": "Offices"
  },
  {
    "name": "Suzlon",
    "address": "87**********",
    "phone": "********5077",
    "email": "et**********@su********",
    "lat": 41.9830362,
    "lng": -87.8444019,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 4,
    "rating_count": 1,
    "category_name": "Governments,Electric utility companies,Electric Consultants,Offices"
  },
  {
    "name": "SunPower Corporation",
    "address": "15**********",
    "phone": "********5300",
    "email": "prpr@su**********",
    "lat": 38.7502607,
    "lng": -121.2505821,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Sacramento",
    "star_count": 1.6,
    "rating_count": 13,
    "category_name": "Offices"
  },
  {
    "name": "Smithfield Dept of Public Utilities",
    "address": "23**********",
    "phone": "********2798",
    "email": "ne**@sm**********",
    "lat": 35.5182947,
    "lng": -78.341226,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Smithfield",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Constructions,Offices,Water utility companies"
  },
  {
    "name": "Serve Colorado",
    "address": "17**********",
    "phone": "********2524",
    "email": "se**********@st*********",
    "lat": 39.7445721,
    "lng": -104.985762,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Denver",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Offices"
  },
  {
    "name": "Emerald Hill Mansion",
    "address": "75**********",
    "phone": "********7979",
    "email": "gr**********@ap******",
    "lat": 36.5394253,
    "lng": -87.3613517,
    "url": "ht**********",
    "country": "United States",
    "state": "Tennessee",
    "city": "Clarksville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Offices"
  },
  {
    "name": "Co-operative Education & Career Services",
    "address": "Un**********",
    "phone": "********2323",
    "email": "re*****@uo*********",
    "lat": 43.532987,
    "lng": -80.226182,
    "url": "ht**********",
    "country": "Canada",
    "state": "Ontario",
    "city": "Guelph",
    "star_count": 4.1,
    "rating_count": 9,
    "category_name": "Offices"
  },
  {
    "name": "ERCO Lighting",
    "address": "16**********",
    "phone": "********8856",
    "email": "in*****@er******",
    "lat": 40.5164536,
    "lng": -74.3373156,
    "url": "ht**********",
    "country": "United States",
    "state": "New Jersey",
    "city": "Edison",
    "star_count": 1,
    "rating_count": 2,
    "category_name": "Offices"
  }
]