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": "Observatories,Embassies,Press advisories,News services,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": "Web design companies,Press advisories,Branding agencies,Web Development,Marketing consultants,Business development services,Public relations firms,Website designers,Media houses,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,Oxygen cocktail spots,New Years tree markets,Telemarketing services,Electricians,Construction companies,Handyman/Handywoman/Handypeople,Vending machine suppliers,News services,Video production services,Game stores,Handymen,Wholesalers,Carpet cleaning services,Nail salons,Private Tutors,Chinese language schools,Reiki therapists,Delivery services,Telephone Marketing Agencies,Notary publics,Mines,Christmas tree farms,Novelties Wholesalers,Housing complexes,Service establishments,Artists,Bathroom supply stores,General contractors,Software companies,Advertising agencies,HVAC contractors,Marketing consultants,Hair salons,Health food stores,Home builders,Home inspectors,Real Estate Builders & Construction Companies,Consultants,Stores,Real estate agents,Dental laboratories,Transportation services,Non-profit organizations,Companies,Jewelry designers,Non-governmental organizations,Furniture stores"
  },
  {
    "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,Media Consultants,Copywriting services,Branding agencies,Service establishments,Press advisories,Marketing agencies,Companies,Image consultants"
  }
]