Andrew Ba Tran
@abtran.bsky.social
📤 2260
📥 670
📝 198
Washington Post Investigative Data Reporter
Nearly 93 percent of all border wall spending over the past decade happened in this year and last, according to our analysis. The spike in border wall spending goes mostly to 2 firms with GOP, White House ties.
wapo.st/3PMfxqi
12 days ago
1
5
6
reposted by
Andrew Ba Tran
Drew Harwell
26 days ago
Ok I'm sensing some momentum here, let's all start saying ai;dr when you see AI writing in a post or story or email, it's a great way to signal you're ignoring them until they use their actual brains
www.tiktok.com/@drewharwell...
loading . . .
I'm over it!!
TikTok video by Drew Harwell
https://www.tiktok.com/@drewharwell/video/7641961901777292558?is_from_webapp=1&sender_device=pc&web_id=7609010269826680333
4
88
25
Wish there was a way to automatically filter out any columns with entire premises based on "I asked AI to do XX research for me and and now I will react to what it gave me without fact checking first"
about 1 month ago
0
2
0
reposted by
Andrew Ba Tran
Aaron Mendelson
about 1 month ago
New one: Between 2022-24, California cops traced nearly 8,000 crime guns — those used in a crime, suspected to have been used in a crime, or illegally possessed — back to a single chain: Turner's Outdoorsman. The retailer also sold a shotgun to the WHCD attacker.
www.thetrace.org/2026/05/turn...
0
6
7
reposted by
Andrew Ba Tran
Doug MacMillan
about 1 month ago
We obtained a trove of internal ICE records showing detention center guards have increasingly used physical force and chemical agents on detainees. Gift link:
wapo.st/4tdgBRA
story w/
@abtran.bsky.social
& team
loading . . .
6
124
100
reposted by
Andrew Ba Tran
Caitlin Gilbert
about 1 month ago
huge congrats to my data team bud Emmanuel Martinez on being a Pulitzer finalist for this reporting!!!
www.washingtonpost.com/immigration/...
loading . . .
ICE increasingly targets undocumented migrants with no criminal record
ICE officers are ramping up arrests. But the share of detained migrants with a criminal conviction has been declining.
https://www.washingtonpost.com/immigration/2025/07/03/ice-arrests-migrants-criminal-record-numbers/
1
32
13
reposted by
Andrew Ba Tran
The Washington Post
about 1 month ago
The Washington Post won a Pulitzer Prize for public service for coverage of DOGE and the federal workforce. It’s the second time The Post has won the prestigious award in five years. Read more about our winning coverage here:
https://wapo.st/3OX3l5A
31
116
42
reposted by
Andrew Ba Tran
Emily Guskin
about 1 month ago
Jahi Chikwendiu just won a Pulitzer for his photos that told this incredible story. The Post laid off all its staff photographers in February 2026 (Chikwendiu left in 2025).
www.washingtonpost.com/health/inter...
loading . . .
He’s dying. She’s pregnant.
Tanner and Shay found themselves facing an unbearable duality: Preparing for their daughter’s arrival and bracing for her father’s death.
https://www.washingtonpost.com/health/interactive/2025/tanner-shay-martin-baby-colon-cancer-end-of-life-planning/?itid=ap_arianaeunjungcha_1
1
116
53
We got our hands on internal ICE records that show how widespread use of force, like punches, kicks, takedown maneuvers, restraint holds, and less-lethal weapons such as Tasers and pepper spray in detention centers has grown
wapo.st/4tdgBRA
(1/)
about 1 month ago
3
104
69
The Army is investigating why an Apache attack helicopter conducting a training flight hovered outside the Tennessee home of musician Kid Rock and near protesters at No Kings rallies in the state, officials said Monday. with
@alexhorton.bsky.social
www.washingtonpost.com/national-sec...
3 months ago
0
0
0
Once again done in by my own hubris of adding the suffix "_FINAL" to a file. THE HUBRIS!
3 months ago
2
8
1
Uploaded a Census handout in Grammarly to see who’d pop up in their Expert Reviews and looks like
@shcohen.bsky.social
and
@albertocairo.com
are among their AI experts. I have a feeling that’s news to them!
www.platformer.news/grammarly-ex...
3 months ago
4
11
6
reposted by
Andrew Ba Tran
Caitlin Gilbert
4 months ago
Emily is the best sports data journalist working right now, and I have no doubt she will continue to do incredible things in whichever newsroom is lucky enough to hire her. I’ll deeply miss getting to work with such an amazing colleague (and fellow FPL fan!!!)
add a skeleton here at some point
0
8
7
reposted by
Andrew Ba Tran
Carl Quintanilla
5 months ago
Page One.
@washingtonpost.com
18
459
216
The
@washingtonpost.com
still sharing our data and how we did the work while other newsrooms pull back. Check out the gathered data on Github
#opendata
#reproducibility
#transparency
bsky.app/profile/cait...
add a skeleton here at some point
6 months ago
0
10
2
reposted by
Andrew Ba Tran
Moriarty Maps
6 months ago
As vaccination has become a political hot potato, the already patchwork of counties & schools meeting herd immunity standards has fallen further. Maps + an interactive to lookup your local schools in this blockbuster w/
@laurenweberhp.bsky.social
&
@caitlingilbert.bsky.social
wapo.st/49zDc43
loading . . .
1
36
16
reposted by
Andrew Ba Tran
Caitlin Gilbert
6 months ago
EXCLUSIVE:
@laurenweberhp.bsky.social
& I have spent the last year collecting school+county-level vaccination data from across the US and found that only about 28% of counties now have herd immunity for kindergartners from measles—that leaves about 5.2mn kids unprotected. Gift link:
wapo.st/49zDc43
loading . . .
U.S. vaccination rates are plunging. Look up where your school stands.
Take a look to see what the kindergarten measles vaccination rates are in your area.
https://wapo.st/49zDc43
37
921
732
reposted by
Andrew Ba Tran
Imogen Piper
6 months ago
For our new visual investigation into how night vision and city lights may have played a part in the DCA crash we flew a drone along the helicopters route, filmed incoming planes through night vision goggles, and analyzed it all within a 3D model of Washington, D.C. Watch here
wapo.st/4atdTBI
loading . . .
In deadly D.C. plane crash, city lights may have played a role. See how.
The Post examined the bright skyline around Reagan National Airport and whether it may have been a factor in the January accident, which killed 67 people.
https://wapo.st/4atdTBI
2
44
13
reposted by
Andrew Ba Tran
Brent Scales
6 months ago
Excellent breakdown of potential contributing factors to the tragic air collision over the Potomac. Class B information overload + lights & NVGs potential contributors via
@imogenpiper.bsky.social
@jb1prod.bsky.social
@abtran.bsky.social
@alexhorton.bsky.social
Brian Perlman
wapo.st/4atdTBI
loading . . .
In deadly D.C. plane crash, city lights may have played a role. See how.
The Post examined the bright skyline around Reagan National Airport and whether it may have been a factor in the January accident, which killed 67 people.
https://wapo.st/4atdTBI
0
5
2
Love the methodology box behind this College Football Happiness Rankings story
wapo.st/49iK71p
6 months ago
1
3
2
reposted by
Andrew Ba Tran
Todd Wallack
7 months ago
This email.
#FOIA
.
www.bostonglobe.com/2025/11/20/m...
5
52
20
reposted by
Andrew Ba Tran
Meghan Hoyer
7 months ago
Wide roads and fast-moving vehicles — especially when combined with signs of poverty, homelessness, drug & alcohol abuse, plus a lack of pedestrian-focused roadway improvements — has produced a pattern of death-by-vehicle that is uniquely American. Investigation by Ian Duncan & Emmanuel Martinez:
loading . . .
The deadliest roads in America
The number of pedestrians killed by vehicles has increased in the U.S., with road infrastructure and inadequate safety measures among key contributing factors.
https://www.washingtonpost.com/business/interactive/2025/pedestrian-deaths-surge-road-safety/?itid=hp-top-table-main_p001_f006
1
3
1
reposted by
Andrew Ba Tran
Will Oremus
7 months ago
You can oversee the bloody dismemberment of a Washington Post journalist with a bone saw, and the president of the United States will smile, shake your hand and threaten to pull the license of a news outlet whose reporter asks you a question about it.
www.washingtonpost.com/world/2025/1...
loading . . .
Trump defends Saudi crown prince over Khashoggi killing
The de facto Saudi ruler was branded a pariah in 2018 after the killing of Washington Post columnist Jamal Khashoggi. Now, U.S.-Saudi relations are approaching a high point.
https://www.washingtonpost.com/world/2025/11/18/saudi-prince-trump-visit-white-house/
33
961
394
Tracking the spread of bird flu using genetic markers, satellite imagery, property records, and more reminds me of John Snow’s Cholera investigation/map. Howe’s Hens is the modern day Broad Street Pump. Amazing work from
@natlash.bsky.social
&
@chrisalcantara.com
.
www.propublica.org/article/meth...
7 months ago
0
48
26
reposted by
Andrew Ba Tran
Scott Clement
7 months ago
As costs rise again, most Americans fault Trump, Post-ABC-Ipsos poll finds. Story by
@abha-b.bsky.social
@abtran.bsky.social
www.washingtonpost.com/business/202...
2
5
2
reposted by
Andrew Ba Tran
Dan Diamond
8 months ago
Trump’s demolition of the East Wing + construction of his ballroom is broadly unpopular. 56% of Americans oppose the project, compared to 28% who support it, per new Post-ABC-Ipsos poll. with
@abtran.bsky.social
@jonathanreports.bsky.social
@sfcpoll.bsky.social
loading . . .
Most Americans oppose East Wing demolition for Trump ballroom, poll finds
Fifty-six percent say they oppose President Donald Trump’s decision to tear down part of the White House to build a 90,000-square-foot ballroom building.
https://www.washingtonpost.com/politics/2025/10/30/trump-east-wing-demolition-poll/
9
81
34
reposted by
Andrew Ba Tran
Scott Clement
8 months ago
New Post-ABC-Ipsos poll: Americans oppose President Donald Trump’s demolition of the White House’s East Wing to make way for a 90,000-square-foot ballroom building by a 2-to-1 margin. By
@ddiamond.bsky.social
@abtran.bsky.social
@jonathanreports.bsky.social
www.washingtonpost.com/politics/202...
loading . . .
Most Americans oppose East Wing demolition for Trump ballroom, poll finds
Fifty-six percent say they oppose President Donald Trump’s decision to tear down part of the White House to build a 90,000-square-foot ballroom building.
https://www.washingtonpost.com/politics/2025/10/30/trump-east-wing-demolition-poll/
0
2
3
The mysterious rise of cancer among young adults in the Corn Belt. This story has both bivariate maps AND a color-coded scatterplot with explainers!
#dataviz
8 months ago
1
5
1
reposted by
Andrew Ba Tran
Emily Giambalvo
8 months ago
How America’s favorite sports bet is fueling sportsbook profits Parlays are becoming more popular, accounting for an increasing share of the money wagered on sports, according to a Post analysis of betting data. Bettors lose billions a year on these bets.
www.washingtonpost.com/sports/inter...
loading . . .
Americans can’t stop betting parlays. Sportbooks are cashing in.
As betting booms, parlays are accounting for an increasing share of the money wagered on sports, according to a Washington Post analysis of state data.
https://www.washingtonpost.com/sports/interactive/2025/parlay-popularity-odds-sportsbooks/
3
43
39
reposted by
Andrew Ba Tran
Meghan Hoyer
8 months ago
Parlays have become incredibly popular, with many betting apps encouraging these high-stakes multi-leg bets. But as legs are added, the chance of winning drops faster than the growth of the potential payout - which means sportsbooks have the advantage. Explore the math and and try your own bets:
loading . . .
Americans can’t stop betting parlays. Sportbooks are cashing in.
As betting booms, parlays are accounting for an increasing share of the money wagered on sports, according to a Washington Post analysis of state data.
https://www.washingtonpost.com/sports/interactive/2025/parlay-popularity-odds-sportsbooks
2
7
10
reposted by
Andrew Ba Tran
Gillian Brockell
9 months ago
NEW: Air Force jets are doing ICE flights to Africa with transponders turned off, making them nearly un-trackable. This includes the third-country removal to Ghana and another secret flight. We figured out where it landed. From me for
@rollingstone.com
:
www.rollingstone.com/politics/pol...
loading . . .
ICE Is Deporting People to Africa on Nearly Un-Trackable Military Flights
Immigration and Customs Enforcement (ICE) is deporting people to African countries like Ghana on military flights that are nearly un-trackable.
https://www.rollingstone.com/politics/politics-features/ice-deporting-africa-military-flights-1235431848/
410
10753
6985
During Trump's federal law enforcement surge in DC, Park Police helicopters spent nearly 20 hours hovering over city neighborhoods, up from 3 hours this same time last year -- and flew hundreds of feet lower than other helicopters. With
@imogenpiper.bsky.social
www.washingtonpost.com/investigatio...
loading . . .
In Trump’s D.C. surge, helicopters hovered and surveilled day and night
Park Police helicopters circled more often than they did in the same time period last year and at lower altitudes than other law enforcement helicopters in D.C. this August.
https://www.washingtonpost.com/investigations/interactive/2025/trump-dc-surge-helicopters/
9 months ago
1
13
3
Washington’s Metropolitan Police Department’s officer count alone already puts D.C. ahead of any other large city in the United States per capita. Including the additional federal officials means there’s currently one officer for every 100 residents in D.C.
www.washingtonpost.com/dc-md-va/202...
10 months ago
0
3
1
Adding another example to my college class folder of "wtf dataviz"
11 months ago
1
11
2
When you get a government data set and can guess the person who used to regularly publish it took the RIF because it's a totally different messier format...
11 months ago
1
4
0
Some day I will be able to recognize which digits are latitude and which ones are longitude but it won't be today or any time soon.
11 months ago
0
1
0
reposted by
Andrew Ba Tran
Hansi Lo Wang (he/him)
12 months ago
NEW: The Census Bureau is planning to scale back its Survey of Income and Program Participation — which is used to measure use of SNAP food assistance and other government programs — and start using "non-survey data" to lower costs, according to a budget document
www.commerce.gov/sites/defaul...
4
39
29
The National Archives had a message yesterday that their College Park facility would become restricted-access. This would be a horrible. We visited often last year to research Indian Boarding schools and the cartographic staff were so helpful. I saw hundreds of citizens getting help looking up docs.
12 months ago
1
2
0
Changing the :joy: emoji to the :lolsob: one feels right
about 1 year ago
0
2
0
reposted by
Andrew Ba Tran
Karen Attiah
about 1 year ago
Latest podcast is out: Get in everyone, we are going to Resistance Summer School! Thank you to everyone who indicated they would like to take my course on Race, Media and International Affairs 101. Please fill out this quick interest form to begin to sign up!
docs.google.com/forms/d/e/1F...
loading . . .
Columbia Canceled My Course on Race and Media. I'm Going to Teach It Anyway.
This is not a time for media literacy or historical knowledge to be held hostage by institutions bending the knee to authoritarianism.
https://open.substack.com/pub/karenattiah/p/columbia-canceled-my-course-on-race?r=2bz6j&utm_campaign=post&utm_medium=web&showWelcomeOnShare=true
99
5382
1814
Most common county names across the United States: Washington (31), Franklin (26), Jefferson (26), Jackson (24), Lincoln (24), and Madison (20)
about 1 year ago
2
5
0
reposted by
Andrew Ba Tran
Washington Post Guild
about 1 year ago
Today, hundreds of our colleagues on the technology side of the company announced the formation of
@wapotechguild.bsky.social
(1)
1
180
80
reposted by
Andrew Ba Tran
Washington Post Guild
about 1 year ago
💥 HUGE news: Today, our Washington Post colleagues announced @wapotechguild. With a majority of over 300 tech workers signing cards in support, they’re seeking voluntary recognition.
1
39
13
another day, another site refactor completely breaking my scraper! fine!
about 1 year ago
0
2
0
Syncing rows of data between state names and state abbreviations are totally fine until you get to the Ms. Like, wtf is this nonsense.
about 1 year ago
2
4
0
reposted by
Andrew Ba Tran
The New York Times
over 1 year ago
Decades from now, the Covid-19 pandemic will be visible in the historical data of nearly anything measurable today. Here’s an incomplete collection of charts that capture that break — across the economy, health care, education, work, family life and more.
loading . . .
30 Charts That Show How Everything Changed in March 2020
It can be easy to forget, or look away from, the pain and disruption of the pandemic. The numbers will be there to remind us.
https://www.nytimes.com/interactive/2025/03/09/upshot/covid-lockdown-five-year-charts.html?smtyp=cur&smid=bsky-nytimes
38
1113
369
reposted by
Andrew Ba Tran
Damon Darlin 🦞 🖋️
over 1 year ago
This may be the best thing you’ll read today.
www.motherjones.com/politics/202...
loading . . .
The country’s most famous houseplant is missing. What did Trump do with it?
The Oval Office Swedish Ivy was a gift to John F. Kennedy.
https://www.motherjones.com/politics/2025/03/the-countrys-most-famous-houseplant-is-missing-what-did-trump-do-with-it/
0
29
18
Subskeeting
mcneill.bsky.social
#nicar25
www.tidyverse.org/blog/2017/12...
over 1 year ago
0
26
1
I made a tidycensus cheatsheet for my
#nicar25
class. I have a dozen left if anyone wants a hard copy.
#rstats
#nicar2025
over 1 year ago
4
48
6
Load more
feeds!
log in