powered by
Get total pills for each distributor in a county
total_distributors_county(county = "Mingo", state = "WV", key = "WaPo")
Filter the data to only this county (e.g. 'Mingo')
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_state, total_manufacturers_county, total_manufacturers_state, total_pharmacies_county, total_pharmacies_state
buyer_details
combined_buyer_annual
combined_buyer_monthly
summarized_county_annual
summarized_county_monthly
total_distributors_state
total_manufacturers_county
total_manufacturers_state
total_pharmacies_county
total_pharmacies_state
# NOT RUN { library(arcos) mingo_wv <- total_distributors_county(county = "Mingo", state="WV", key="WaPo") head(mingo_wv) # }
Run the code above in your browser using DataLab