JSONPath Reference
- Brian Lee
JSONPath is a quick way to ask questions of the CDC Public Data Listing at https://data.cdc.gov/data.json
It's also useful for many repository data quality questions from the overall HHS department public data listing at https://www.hhs.gov/data.json
For any serious analysis, use Python, or R, or bash, but if you just want to ask quick questions, you can send data.json into a site like http://jsonpath.com/ and ask questions like:
- $..dataset[?(@.bureauCode=="009:20")].title (what are the titles of all the CDC data sets?)
- $..dataset[?(@.bureauCode=="009:20")] (what are all the CDC data sets?)
- $..dataset[?(@.bureauCode=="009:20")].keyword[*] (what are all the keywords used by CDC data sets?)
- $..dataset[?(@.bureauCode=="009:20",@.title=="VSRR Provisional Drug Overdose Death Counts")].title (what are the titles of all the CDC data sets titled VSRR Provisional Drug Overdose Death Counts? - there should only be one)
- $..dataset[?(@.title=="Monthly Page Views to CDC.gov")]
Related content
Disclaimer
Use of this service is limited only to non-sensitive and publicly available data. Users must not use, share, or store any kind of sensitive data like health status, provision or payment of healthcare, Personally Identifiable Information (PII) and/or Protected Health Information (PHI), etc. under ANY circumstance.
This project contains only non-sensitive, publicly available data and information. All material and community participation is covered by the Surveillance Platform Disclaimer and Code of Conduct. For more information about CDC's privacy policy, please visit http://www.cdc.gov/privacy.html.
Administrators for this service reserve the right to moderate all information used, shared, or stored with this service at any time. Any user that cannot abide by this disclaimer and Code of Conduct may be subject to action, up to and including revoking access to services.