powered by
Get total pills for each pharmacy in a state
total_pharmacies_state(state = "WV", key = "WaPo")
Filter the data to county within this state (e.g. 'WV')
Key needed to make query successful
https://www.washingtonpost.com/graphics/2019/investigations/dea-pain-pill-database/#download-resources
Other summarized: buyer_details, combined_buyer_annual, combined_buyer_monthly, summarized_county_annual, summarized_county_monthly, total_distributors_county, total_distributors_state, total_manufacturers_county, total_manufacturers_state, total_pharmacies_county
buyer_details
combined_buyer_annual
combined_buyer_monthly
summarized_county_annual
summarized_county_monthly
total_distributors_county
total_distributors_state
total_manufacturers_county
total_manufacturers_state
total_pharmacies_county
# NOT RUN { library(arcos) wv <- total_pharmacies_state(state="WV", key="WaPo") head(wv) # }
Run the code above in your browser using DataLab