Graph monthly traffic deaths for two states with Grok
- Posted
- by @TuelTaylor
- Last checked
- Method:
- How we verify
Evidence: Screenshots or logsThe source shows screenshots, a transcript or the agent's output.
Outcome
The poster says he asked Grok to graph Iowa traffic deaths per month for the last five years, then California, to check whether a roadside death counter looked low; he shared the charts.
Agent
Prompt Recreated prompt
The source didn't share its exact prompt, so we wrote this from what it describes.
Let's work this out together. I'll tell you what I'm after; help me sharpen the goal before you dive in, and check in with me before anything you can't undo. Goal: Help me see whether traffic deaths in my state are really going down, using a chart I can trust. Questions to explore first: Which states and years, and what made you curious (a sign, a news story)? What I need from you: - The states to compare ([STATE 1], [STATE 2]) - The years to cover Rules: - Start by restating my goal and suggesting 2–3 ways to approach it; recommend one. - Use official sources (state DOT or NHTSA FARS) and name them. - Plot deaths per month as a line chart per state. - Mark months where data is preliminary or missing. - Add a per-capita version so the states can be compared fairly. - Don't claim causes; just describe the trend. Output: Two charts, the data table behind them, and a 3-sentence trend summary with sources, plus 2–3 suggested next steps. If any of this is unclear, tell me what you have and I'll help fill the gaps. You'll know it worked when: the chart numbers match the cited source for a few months you spot-check.
Source
https://x.com/TuelTaylor/status/2103482706315321689
Related cases
- Merge provider price CSVs into one comparison table with Claude CodeRecreated promptEvidence: Described by poster
Claude Code read several local CSVs of model prices from different providers and produced one organized comparison table grouped by provider.
Claude Code · Data · Source date:
- Build a support data pipeline and dashboard in under an hour with DevinRecreated promptEvidence: Company case study
At Eight Sleep, a support manager who used to need the data team for dashboards built an end-to-end pipeline and dashboard herself with Devin in under an hour, according to Devin's customer story.
Poster says:Under an hour
Devin · Data · Source date:
- Fill missing industry details in a customer sheet with Zapier AgentsRecreated promptEvidence: Company case study
UK energy company egg set up a Zapier Agent that finds customers with missing industry details in a HubSpot-fed Google Sheet, searches for the information and updates the sheet; Zapier says it now takes about five minutes and egg no longer pays a contractor for it.
Poster says:About 5 minutes; contractor no longer needed
Zapier Agents · Data · Source date: