palewire

7 ms·

1.
by palewire 4mo ago
The site includes a CSV of everything I found. You could hand that to Claude Code and ask it to pull down the WARCs
2.
by palewire 4mo ago
Please give archive.org all the credit
3.
by palewire 4mo ago
I fixed that: https://fivethirtyeightindex.com/graphics/ https://fivethirtyeightindex.com/illustrations/
4.
by palewire 4mo ago
FWIW, the site now indexes 13,000 graphics and 3,000 illustrations, which I clawed out of the Wayback Machine's HTML and preserved separately in an archive.org collection. https://fivethirtyeightindex.com/graphics/
5.
by palewire 9mo ago
Thanks. I'm glad you found it interesting!
6.
First Basemap: How to create a fast and virtually free map(palewi.re)
3 points by palewire 9mo ago|2 comments
7.
by palewire 9mo ago
Today I'm happy to release "First Basemap," a free tutorial that shares one of our most valuable recent innovations at Reuters. It's at https://palewi.re/docs/first-basemap/ Follow the step-by-
8.
Poll: How popular are the 10 richest Americans?(old.reddit.com)
2 points by palewire 2y ago|6 comments
9.
by palewire 2y ago
I edited this poll for Reuters, which was released today with this story. https://www.reuters.com/world/us/americans-worry-musks-campa... If you have any questions or critique, let's hear it.
10.
1 in 3 news sites block OpenAI via robots.txt(palewi.re)
2 points by palewire 3y ago|2 comments
11.
by palewire 3y ago
The 392 news organizations listed at this URL have instructed OpenAI’s GPTBot to not scan their sites, according to a continual survey of 1,119 online publishers conducted by the homepages.news archive. That amounts to 35.0% of the total. T
12.
There are more women than ever in ‘Star Wars.’ Men still do most of the talking(latimes.com)
2 points by palewire 7y ago|0 comments
13.
by palewire 9y ago
There's a state database compiled by CHP called SWITRS that tracks traffic accidents. You can find it here. http://iswitrs.chp.ca.gov/Reports/jsp/userLogin.jsp We don't call it out by name in the story,
14.
by palewire 9y ago
Thanks! If you're a Python person, I'd love to hear what you think of how I structured the notebook. There isn't a set style for writing these and I've been experimenting with different forms lately. In this case, I push
15.
by palewire 9y ago
I appreciate your effort to bring some context to the analysis. However, as we unpack in the story, our total is likely an undercount due to the problems in tracking street racing related crashes.
16.
by palewire 9y ago
I worked on the data analysis for this story, which was published at a Jupyter Notebook of Python code. https://github.com/datadesk/street-racing-analysis/blob/mast... If you have any questions, shoot.
17.
Boosting the performance of PostgreSQL’s COPY command by dropping indexes(californiacivicdata.org)
37 points by palewire 9y ago|46 comments
18.
by palewire 9y ago
I'm the author of this post. Glad to see it's been submitted here. If you have any questions, please fire away.
19.
by palewire 9y ago
Thanks for the tip. This is something I was unaware of.
20.
by palewire 9y ago
I hadn't considered that. It only accepts CSVs, not Excel files, right now. If you can provide an example of a dangerous file we can try testing against it.
21.
How to export Django data faster than ever before(californiacivicdata.org)
2 points by palewire 9y ago|4 comments
22.
The L.A. Times editor in chief is on GitHub and made an open-source patch(californiacivicdata.org)
1 points by palewire 9y ago|0 comments
23.
by palewire 9y ago
I'm one of the organizers of the California Civic Data Coalition and this event. If you have any questions about our work, or the state of California's crippled database tracking money in state politics we're aiming to improv
24.
Join the California Code Rush. Patch Open Data Project. Win a Prize(californiacivicdata.org)
1 points by palewire 9y ago|1 comments
25.
Make First open source patch, help open public data, win a prize. In ~10 minutes(californiacivicdata.org)
2 points by palewire 9y ago|0 comments
26.
Gavin Newsom dominates donations as pot money pours into Calif. governor's race(latimes.com)
1 points by palewire 9y ago|0 comments
27.
Lessons learned teaching data analysis with Python(californiacivicdata.org)
134 points by palewire 9y ago|9 comments
28.
by palewire 9y ago
I work at The Times on the team behind these stories and FYI we did a whole previous investigation focused on just that http://www.latimes.com/projects/la-fi-electricity-capacity/
29.
Teaching Pandas and Jupyter to Northwestern journalism students(californiacivicdata.org)
86 points by palewire 9y ago|45 comments
30.
by palewire 10y ago
Thanks for passing this along. It's very interesting. I just gave it a go with a hefty SQL import to test its power. My database connection string to Amazon RDS, which works locally on my computer, failed. Any idea why?

More ›