List of Press advisories in California

[
  {
    "name": "JafraGris",
    "address": "39**********",
    "phone": "********7016",
    "email": "",
    "lat": 33.9946898,
    "lng": -117.4056271,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Jurupa Valley",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Press advisories"
  },
  {
    "name": "Perunews_com",
    "address": "33**********",
    "phone": "********6938",
    "email": "",
    "lat": 33.6052483,
    "lng": -117.7457638,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Laguna Woods",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "News services,Embassies,Press advisories,Observatories,Importers,Exporters"
  },
  {
    "name": "My hai mươi mấy",
    "address": "91**********",
    "phone": "********4271",
    "email": "",
    "lat": 33.7894427,
    "lng": -117.9735222,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Garden Grove",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Press advisories"
  },
  {
    "name": "Wayside Press",
    "address": "85**********",
    "phone": "",
    "email": "",
    "lat": 34.0376251,
    "lng": -118.2502248,
    "url": "",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Press advisories"
  },
  {
    "name": "Explorn",
    "address": "",
    "phone": "",
    "email": "",
    "lat": 37.878638,
    "lng": -122.4203375,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Press advisories,Service establishments,Companies"
  },
  {
    "name": "Luxury Living Fine Dining",
    "address": "20**********",
    "phone": "",
    "email": "",
    "lat": 34.0579556,
    "lng": -118.4132239,
    "url": "",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Press advisories"
  },
  {
    "name": "Jorge",
    "address": "87**********",
    "phone": "",
    "email": "",
    "lat": 34.2285622,
    "lng": -118.4519154,
    "url": "",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Press advisories"
  },
  {
    "name": "Push The Envelope PR",
    "address": "57**********",
    "phone": "********5132",
    "email": "",
    "lat": 33.9469225,
    "lng": -118.3827256,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Public relations firms,Website designers,Marketing consultants,Media houses,Business development services,Web design companies,Branding agencies,Press advisories,Web Development,Marketing agencies"
  },
  {
    "name": "None",
    "address": "",
    "phone": "********1960",
    "email": "",
    "lat": 34.020479,
    "lng": -118.4117325,
    "url": "",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Executive search firms,Natural Stone Exporters,Press advisories,Property administrators,Telemarketing services,New Years tree markets,Oxygen cocktail spots,Handyman/Handywoman/Handypeople,Construction companies,Electricians,Auction houses,Vending machine suppliers,Silk plant shops,Game stores,Video production services,Handymen,Wholesalers,Carpet cleaning services,Nail salons,Private Tutors,Chinese language schools,Delivery services,Reiki therapists,Telephone Marketing Agencies,Notary publics,Service establishments,Mines,Christmas tree farms,Novelties Wholesalers,Housing complexes,News services,Artists,Advertising agencies,Bathroom supply stores,General contractors,HVAC contractors,Software companies,Marketing consultants,Hair salons,Health food stores,Home builders,Home inspectors,Real Estate Builders & Construction Companies,Consultants,Stores,Property management companies,Real estate agents,Companies,Non-governmental organizations,Furniture stores,Jewelry designers,Dental laboratories,Transportation services,Non-profit organizations"
  },
  {
    "name": "COMMS/NATION LLC",
    "address": "",
    "phone": "********9697",
    "email": "",
    "lat": 33.163906,
    "lng": -114.687192,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Public relations firms,Design agencies,Graphic designers,Advertising agencies,Copywriting services,Branding agencies,Press advisories,Service establishments,Media Consultants,Image consultants,Marketing agencies,Companies"
  }
]