"Cash for Clunkers" – Clunker by Country Vizualization

I’m currently working on a chapter for the upcoming O’Reilly book “Beautiful Visualization” (a new book in the “Beautiful” series) and one of the things that I do is walk readers step by step through gathering data and sifting through it in order to create a visualization from the Cash for Clunkers data.

As I was looking through the Cash for Clunkers data, I was fascinated by the extent to which it seemed that the clunkers being turned in were disproportionally from companies based in the US. So I dug into the data and found out that it didn’t just seem that way… 85% of the cars “clunked” came from US based manufacturers.

So I decided to create a visualization to identify which countries gained market share due to the Cash for Clunkers program. So… here it is. Click for a larger view. (caveats below).

You can access the raw data here.

Caveats:

  1. Yes, nearly all Toyota and Honda and Hyundai vehicles are built in the US. I used the “where is the parent company headquartered” as my way of determining country size. That made for a more compelling image.
  2. It makes a certain kind of sense that people would dump a lot of old US-made vehicles because US manufacturers were at the forefront of the SUV boom in the early-mid 2000’s (aughts? oughts? naughts? This next decade will be so much easier), so it seems to make sense that people who bought SUV’s would be most eligible for a Cash for Clunkers rebate. If you bought a fuel efficient Toyota Camry in 2002, you’re not going to be eligible to trade your vehicle in, so it seem unlikely that you would do so.

With all that being said, I think it’s obvious that US manufacturers have lost market share on these transactions. I’d need to do a shade more research, but my understanding is that Ford (which didn’t take any bailout cash) didn’t do too badly while Chrysler and GM saw a large number of their vehicles turned in and comparatively very little purchasing.

What does this mean for the future? I don’t know. This was more for fun and for my book chapter than for anything else. And if you want to learn how to do something like this, just buy “Beautiful Visualization” when it comes out.

15 comments

  1. Al says:

    Haven’t even read this new entry yet and I’m already excited. Just sayin’.

  2. Al says:

    I wasn’t disappointed. And yes, I’ll buy a book or three when it comes out.

    I’m not surprised by what your visualisation shows, but I am not sure what to make of it, either. Having foreign-owned companies build their cars here is far preferable to having them made overseas, but it is troubling to see our own manufacturing base shrivel.

    One thing I do know: Having all of those SUVs crushed out of the used-car market has certainly increased the value of my two not-turned-in SUVs.

  3. KingShamus says:

    One more indication that when it comes to big government economic programs, the right hand doesn’t know who the left foot is tripping.

  4. Heavens, I love this site. Keeeewl.

    Though to be sure on the whole CFC thing, government defends the programs (and for some reason I ran into an ACORN activist who to this moment would cry foul at the graph by claiming that it misrepresents the goals of CFC to merely move old inventory, and get consumers into more fuel efficient cars–NOT as a handout to Detroit as some claim, etc).

  5. Also, and giving full attribution first (I’ll run you a rough draft copy if you like) I would certainly like to borrow and post that handy graphic regarding CFC.

    Very compelling.

    Let me know when you can. No hurries, as more such government programs are likely to come our way on a variety of products as yet more enviro-friendly glop on behalf of mother earth and the poor consumer.

  6. politicalmath says:

    Yes, feel free to use this image. Just let me know when you do so I can keep track (for bragging purposes).

  7. KB says:

    Hey Political Math,

    I have written books for O’Reilly (and Wiley, and Pearson, etc), thought you might want to touch base outside of this public venue. I assume you can track me down via the email you should see on this post.

    Are you working as a for hire to one of the authors? Are you one of the authors? Who’s the editor? Simon? Brian?

    KB

  8. […] This post was mentioned on Twitter by Candice, Steven Cox. Steven Cox said: RT @Candice_Jo: "Cash for Clunkers" – Clunker by Country Vizualization From: @politicalmath http://bit.ly/4oM3SV #tcot […]

  9. Justin Hyde says:

    I appreciate the work that goes into these graphics, so I’d like to make a friendly point: The database contains the info necessary to determine the country of origin of the vehicles sold & crushed under cash for clunkers. When you run that analysis, Japanese-built vehicles accounted for 115,400 vehicles sold under C4C. (There’s a couple of records that seem a little garbled.)

  10. politicalmath says:

    Where are you finding that? It’s definitely not in the Excel file (I had to do some scraping and sorting through the data to get the numbers I got). I see that there is a new report called “MFG Origin”, but that seems to be a phantom report at the moment (goes to a 404 page).

    I did a quick check and Toyota alone sold 130,000+ new vehicles. If you grab the big Japanese 3 (Toyota, Honda, Nissan), you get about 280,000 new cars sold. (source).

  11. […] discovered this visualization on Political Math Blog, which shows which countries supplied the most clunkers, and which ones picked up some extra sales […]

  12. OK. Took me longer than I wanted to swat at 10,000 other things going on, but here you are!

    http://wakepedia.blogspot.com/2010/02/winners-clunkers-cash-for-flunkers-ii.html

  13. Hello. impressive job. I did not anticipate this. This is a splendid story. Thanks!

  14. Arrive once again quickly and tell us all much more, it is son nice to finally have discovered a website with some sort of high quality rather than all the crappy websites on the internet, please update frequently, we’re a great deal sitting in peaceful and enjoying your thoughts!

  15. Tilbud says:

    When I would be a young boy as well as did not know how the internet proved helpful, or even were built with a computer, all of us played in outside fields coupled with fun with each other, today everything happen online, its technology and in a way a good thing, however nowadays it have grown to be the life of many, sitting on your own in front of the display screen feeling you have friends on the net, its kind of sad, but we simply need to live with this, its the so-called potential…