CMS Hospital Compare API Limit

[rsmiddy]

I'm trying to pull data from CMS Hospital Compare API, but it appears the data is being limited to 1000 records. 

The website for the API and documentation for the timely and effective care data,https://data.medicare.gov/Hospital-Compare/Timely-and-Effective-Care-Hospital/yv7e-xc69 and for the hcahps data, https://data.medicare.gov/Hospital-Compare/Patient-survey-HCAHPS-Hospital/dgck-syfz. 

I've also included the workflow. 

[LordNeilLord · Accepted solution]

Hey @rsmiddy 

You need to read this page: https://dev.socrata.com/docs/paging.html

[rsmiddy]

Thank you for the quick response! 

[robertbrussell1]

Hi -- I am having the same issue where the data is limited to 500 rows.  Can you post the Alteryx logic used to resolve your issue?