McNown Chiropractic Clinic

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310616,
      "site_id": 35,
      "cat_id": 8,
      "priority": 0,
      "url": "http://www.foundationclinic.com",
      "title": "McNown Chiropractic Clinic",
      "description": "Chiropractic Physicians West Linn: Dr. Emmert’s focus is on providing quality care and equipping his patients in West Linn with the tools they need for life-long health.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61851,
      "approve_dt": "2015-10-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-10-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1648,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18740,
      "ltop": "",
      "facebook": "http://www.foundationclinic.com",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/u/0/104667067457651059114/posts",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 2018,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954e58a0-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 05, 2015",
      "subcategory": "Fitness",
      "request_types": "",
      "visitcount": 1967
   },
   "visits": {
      "storefront": 1967,
      "articles": 0,
      "videos": 0,
      "reviews": 23,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Dr. Emmert's first experience with chiropractic care came after he sustained injuries playing high school baseball and football. From the interactions with his chiropractor and the treatments he received came a growing interest in chiropractic medicine as a profession. Realizing the power that chiropractic medicine has to improve people's lives, this course of study seemed the perfect fit.Dr. Emmert received his Bachelor of Science Degree in Human Biology as well as his Doctor of Chiropractic degree from the University of Western States in 2012. He has continued his education with certifications in Selective Functional Movement Assessment (SFMA) and from the Motion Palpation Institute (MPI).\n",
      "service1": "Spinal adjustments",
      "service2": " Headaches",
      "service3": " Automobile injuries",
      "service4": " Sports injuries",
      "service5": " Neck injuries",
      "service6": " Massage therapy",
      "service7": " Corrective exercises",
      "submit_dt": "2015-10-05 08:10:37"
   },
   "location": {
      "uuid": "954e58a0-56da-11ed-b77c-b66e99367f32",
      "link_id": 310616,
      "account_id": 61851,
      "company": "McNown Chiropractic Clinic",
      "sid": 35,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18740",
      "zip": "97068",
      "address": "1830 Blankenship, Suite 210",
      "phone": "503-342-7600",
      "fax": "",
      "email": "tyleremmert@ekwa.com",
      "name": "McNown Chiropractic Clini",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.3508719",
      "lon": "-122.655038",
      "cityname": "West Linn",
      "statename": "Oregon"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}