ドイツの広告代理店のリスト

[
  {
    "name": "Marcin Siwicki",
    "address": "",
    "phone": "********9745",
    "email": "ma**@ma**********",
    "lat": 52.2586618,
    "lng": 10.2583193,
    "url": "ht**********",
    "country": "Germany",
    "state": "Lower Saxony",
    "city": "Ilsede",
    "star_count": 5,
    "rating_count": 36,
    "category_name": "Media Consultants,Telemarketing services,Coachings,Web design companies,Web Development,Service establishments,Internet marketing services,Design agencies,Website designers,Graphic designers,Advertising agencies,Companies,Marketing consultants,Marketing agencies,Coaching Centers,Telephone Marketing Agencies"
  },
  {
    "name": "wio. Agentur",
    "address": "Ha**********",
    "phone": "********7545",
    "email": "in**@wi**********",
    "lat": 50.0163949,
    "lng": 8.232934,
    "url": "ht**********",
    "country": "Germany",
    "state": "Rhineland-Palatinate",
    "city": "Mainz",
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Advertising agencies"
  },
  {
    "name": "dreihundertsechs - agentur für kreative kommunikation",
    "address": "Ro**********",
    "phone": "********8720",
    "email": "in**@dr**********",
    "lat": 48.7698431,
    "lng": 9.1559407,
    "url": "ht**********",
    "country": "Germany",
    "state": "Baden-Württemberg",
    "city": "Stuttgart",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Marketing consultants,Marketing agencies,Advertising agencies"
  },
  {
    "name": "Flyernotruf",
    "address": "Sc**********",
    "phone": "********3063",
    "email": "in**@fl**********",
    "lat": 53.1201374,
    "lng": 8.2185127,
    "url": "ht**********",
    "country": "Germany",
    "state": "Lower Saxony",
    "city": "Oldenburg",
    "star_count": 4.8,
    "rating_count": 82,
    "category_name": "Advertising agencies,Design agencies,Clothes and fabric manufacturers"
  },
  {
    "name": "Astronomical",
    "address": "",
    "phone": "********6134",
    "email": "en*******@as**********",
    "lat": 47.73855,
    "lng": 12.5088275,
    "url": "ht**********",
    "country": "Germany",
    "state": "Bavaria",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Companies,Media companies,Service establishments,Website designers,Advertising agencies,Web Development,Web design companies"
  },
  {
    "name": "Irish Voice over Liam Quigley",
    "address": "",
    "phone": "********9100",
    "email": "in**@li**********",
    "lat": 47.73855,
    "lng": 11.5749774,
    "url": "ht**********",
    "country": "Germany",
    "state": "Bavaria",
    "city": "Gaißach",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Companies,Advertising agencies,Radio broadcasters,Service establishments"
  },
  {
    "name": "Bersaldi-creative office",
    "address": "Am**********",
    "phone": "********2387",
    "email": "in**@be*********",
    "lat": 51.2160427,
    "lng": 6.4517416,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Advertising agencies"
  },
  {
    "name": "ORÖ GmbH",
    "address": "Fe**********",
    "phone": "********7444",
    "email": "ne*******@or*****",
    "lat": 51.0452697,
    "lng": 13.770872,
    "url": "ht**********",
    "country": "Germany",
    "state": "Saxony",
    "city": "Dresden",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Advertising agencies"
  },
  {
    "name": "werbediscount",
    "address": "Cr**********",
    "phone": "********5513",
    "email": "in**@we**********",
    "lat": 51.4455,
    "lng": 7.3357,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Witten",
    "star_count": 4.4,
    "rating_count": 13,
    "category_name": "Advertising agencies"
  },
  {
    "name": "ORÖ GmbH",
    "address": "Gu**********",
    "phone": "********7444",
    "email": "ne*******@or*****",
    "lat": 51.5079782,
    "lng": 7.4651644,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Dortmund",
    "star_count": 5,
    "rating_count": 8,
    "category_name": "Software companies,Design agencies,Marketing consultants,Web design companies,Web Development,Website designers,Advertising agencies"
  }
]