Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I'm not sure if WaPo just made their paywall more aggressive, but I can't seem to read this URL now w/o logging in. They do provide a direct URL from Cloudflare to the raw data, which is about 7GB compressed and uncompresses to a single tab-delimited text file with 180M rows at 80GB:

    https://d2ty8gaf6rmowa.cloudfront.net/dea-pain-pill-database/bulk/arcos_all_washpost.tsv.gz
There is also individual state level data with the following format (replace `il` – i.e. IL for Illinois – with the state postal code of your choice):

    https://www.washingtonpost.com/wp-stat/dea-pain-pill-database/summary/arcos-il-statewide-itemized.tsv.gz
That said, the data is fairly hard to understand without reading the article so it's likely much more efficient to login to read it and download. Here's a tweet thread with context from the WaPo's data editor:

https://twitter.com/dataeditor/status/1151904218095194112

And here's a 10K row random sample to preview in Google Sheets:

https://docs.google.com/spreadsheets/d/19NZtjOEPxNdNfZS9l-yZ...



I was able to read it by disabling Javascript.


I am able to read the site without trouble. I have all cookies from washingtonpost.com blocked though, so I don't know if that's what lets me get through.


I really wish the WaPo app opened urls from their site. I use Firefox focus so I'm never logged in, but I am logged in the app.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: