Free US Population Density And Unemployment Rate By Zip Code

US Census Population Density By Zip Code
Take a peek: the population, land area, and population density of every zip-code / ZCTA in the USA.
  • 2010 US Population Density, By Zip Code, in XLS and CSV
  • 2007-2011 US Unemployment Rate By Zip Code, also in XLS or CSV

Unemployment and population density are probably two of the most important local statistics you might hear quoted about a city or town. Our US Population by Zip Code post from September has gotten rather popular, and a polite commenter requested population density and unemployment rate. So here they are, totally free and in the public domain, in two different formats (see above).

How did I get this data?  Two different Census APIs (the Decennial Census 2010 and the ACS 5-year 2007-2011), combined with the square-footage by ZCTA listings from the 2013 U.S. Gazetteer Files.

I was planning to use this post to document my methods and send everyone on their own journey through the data, but it got too long and I realized that I wanted to talk a more systematic approach. In a follow up post, I will explain how to pull Census data yourself for different variables at different geographical resolution. But if you need a jump start now, my first and most helpful guide was the National Civic Day Of Hacking support slides.

Splitwise for Android v3: New Design, New Love

Splitwise Android v3 Home Screen
The new home screen! The top row lets you filter by either debts, credits, or all friends.

The whole Splitwise team is proud and thrilled to announce the release of the most wonderful Android app we’ve ever designed – Splitwise Android v3. It’s a whole new look and the result of many months of toil by Marshall, with help in the last couple months from Ryan and Caleb. Testing was carried out by the whole team as well as volunteer testers from our user base, to whom we are very grateful.

To my thumbs and eyes, our Android app has gone from a source of embarrassment to one of the most polished productivity apps in the Play Store. Some highlights from the new build:

  • Unified logo and color scheme and a look that embodies the Android style
  • Pay friends via PayPal (for US users only)
  • Simplified and streamlined “Add Bill” dialog
  • Push notifications for new expenses and edits
  • Sidebar menu to easily find balances with groups or people
  • New friend view, including both group balances and private IOUs

Continue reading Splitwise for Android v3: New Design, New Love

Google trying to patent bill splitting while lobbying Splitwise for patent reform

Google bill splitting patent authors using Splitwise
The Google patent authors hypothetically using Splitwise

Last week, we learned from GeekWire that Google has applied for a patent on our bread and butter technology: tracking groups of bills split with friends. The patent application describes a system of shared balances and payments between friends in a group – exactly what Splitwise and some of our competitors have been doing publicly for years. Google currently has no group-splitting product, and one can only assume they are considering adding a splitting service to Google Wallet. (Google, if you want to integrate Splitwise with Wallet, reach out to us).

A thorough search for prior art
The equally ironic prior art search

Obviously, it’s “not a joke” to have a tech giant submit a patent application for exactly what your business has been doing for years. But we couldn’t help but laugh when, within the same week, a lobbyist paid by Google approached us to ask if we would publicly support a patent reform bill. We are literally being lobbied for patent reform and patent-trolled by Google at the same time. Continue reading Google trying to patent bill splitting while lobbying Splitwise for patent reform

The 2010 US Census Population By Zip Code (Totally Free)

US Population By Zipcode / ZCTA
Population by ZIP code / ZCTA from US Census 2010. Why was this so freaking hard to find?

I’m going to kick off a multi-part series on US Census data by offering a totally free download, in XLS or CSV format, of something strangely hard-to-Google: the 2010 US Census population by Zip code (technically, by ZCTA). Splitwise is offering these files free of charge and in the public domain, and I can’t believe how many other sites are charging for them!

But the difficulty I had in creating this data set and using the US Census website has inspired me to write a bit more about how to use one of the world’s most interesting open data sources.

Continue reading The 2010 US Census Population By Zip Code (Totally Free)

The Splitwise API Is Here

Splitwise API clipart
“Building on Splitwise is fun,” says Clay Clipart, a fake developer at Google Image Search.

We’ve always hoped to give people the power to build new experiences on top of Splitwise, and we’re proud to announce today that we are releasing our first public API.

This will allow developers, Splitwise-lovers, and other companies to integrate with Splitwise. We’ve created an open-source API example, and published the instructions and documentation that we use internally. Check it out! Continue reading The Splitwise API Is Here

Presenting Splitwise v3: Fat Rabbit

fat rabbit watching fat rabbit 1
Nosey is excited he is a launch mascot!

It’s my great pleasure to announce version 3  of Splitwise for iPhone and web, which Marshall has memorably code-named “Fat Rabbit.” This is a major new relaunch, which changes our look and feel and adds popularly requested features like expense search, offline mode, bill editing, and push notifications. Perhaps most notably, we’ve entered the world of “mobile payments” with iPhone payments via PayPal.

We have decided to relaunch Splitwise today, in spite of yesterday’s bombing of the Boston Marathon. We are deeply upset by the attack, and many dear friends of Splitwise were near the scene of the bombing or experienced a near miss. Our thoughts are out to anyone affected by the tragedy. In light of everything, we believe that the most ethical thing for Splitwise to do is to go ahead with business as usual.

If you care to, join us for a tour of the new app. Continue reading Presenting Splitwise v3: Fat Rabbit

Splitwise Pivots To A New Business Model

Coming soon to a t-shirt near you
Coming soon to a t-shirt near you

After two long years of trying to figure out how to make money, Splitwise has finally settled on a sustainable business model that will enhance the user experience of our website and keep ourselves profitable into the future.

Charging money for payments? Lame. Advertisements? Meh. Premium features? What premium features?

The only logical path, as I’m sure you will agree, is to become a web-comic. Continue reading Splitwise Pivots To A New Business Model