Elenco di Aziende mediatiche in Texas

[
  {
    "name": "ClicksClips.Studio",
    "address": "64**********",
    "phone": "********1531",
    "email": "in**@cl**********",
    "lat": 29.7833165,
    "lng": -95.4665328,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Audiovisual equipment rental services,Media companies,Audio visual equipment rental services"
  },
  {
    "name": "Clear Channel Outdoor",
    "address": "12**********",
    "phone": "********4200",
    "email": "Ja********@cl**********",
    "lat": 29.7366313,
    "lng": -95.6130218,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 4,
    "rating_count": 10,
    "category_name": "Media companies"
  },
  {
    "name": "CReed Global Media & CGM TV",
    "address": "",
    "phone": "********5717",
    "email": "in**@cr**********",
    "lat": 29.817178,
    "lng": -95.4012914,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 5,
    "rating_count": 8,
    "category_name": "Media companies,Television studios,Companies,Marketing agencies,Service establishments"
  },
  {
    "name": "Lamar Advertising of Midland-Odessa",
    "address": "29**********",
    "phone": "********8571",
    "email": "AL*****@LA*******",
    "lat": 31.9429861,
    "lng": -102.1722639,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Midland",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Media companies"
  },
  {
    "name": "Rio Grande Gazette",
    "address": "42**********",
    "phone": "********6000",
    "email": "ed****@ri**********",
    "lat": 31.9970692,
    "lng": -106.6055764,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "El Paso",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Real estate rental agencies,Real estate agencies,News services,Media companies,Newsstands,Newspaper publishers"
  },
  {
    "name": "See Music Live",
    "address": "",
    "phone": "********3631",
    "email": "in**@se**********",
    "lat": 33.3133095,
    "lng": -96.184224,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media companies,Service establishments,Companies"
  },
  {
    "name": "Live from the Southside",
    "address": "",
    "phone": "********4445",
    "email": "li**********@gm*******",
    "lat": 29.4585735,
    "lng": -98.5143764,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "San Antonio",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Advertising agencies,Public relations firms,Media companies,Service establishments,News services,Companies"
  },
  {
    "name": "TexAgs",
    "address": "30**********",
    "phone": "********0560",
    "email": "st***@te********",
    "lat": 30.6053399,
    "lng": -96.3377407,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Bryan",
    "star_count": 4.4,
    "rating_count": 17,
    "category_name": "Media companies"
  },
  {
    "name": "Ranch & Rural Living Magazine",
    "address": "17**********",
    "phone": "********4434",
    "email": "in**@ra**********",
    "lat": 31.4630035,
    "lng": -100.4372542,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "San Angelo",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Media companies,Web hosting companies"
  },
  {
    "name": "Upgraded Points LLC",
    "address": "11**********",
    "phone": "********8866",
    "email": "ma**@up**********",
    "lat": 30.2602574,
    "lng": -97.7563563,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Austin",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Media companies"
  }
]