Given that tax day has just passed, I thought it would be good to check out some data on taxes. The IRS provides a great resource on tax data that I’ve only just gotten into. I think I’ll be able to do more with this in the future. This one looks at how taxes paid varies by state and presents it as a choropleth map (coloring states based on certain categories of tax data).
I may add more categories in the future, so if you have ideas of tax data you want to see visualized let me know and I’ll see what I can do.
For other tax-related tools and visualizations see my tax bracket calculator and visualization of marginal tax rates.
Data and Tools:
Data on tax returns by state is from the IRS website in an excel format. The map was made using the leaflet open source mapping library. Data was compiled in excel and calculations made using javascript.
Electric vehicles are any vehicle that can be plugged in to recharge a battery that provides power to move the vehicle. Two broad classes are battery electric vehicles (BEVs) which only have batteries as their power source and plug-in hybrid electric vehicles (PHEVs) which have an alternative or parallel power source, typically a gasoline engine. PHEVs are built so that when the battery is depleted, the car can still run on gasoline and operate like a hybrid vehicle similar to a regular Toyota Prius (which is not plugged in at all).
Electric vehicles (EVs) have been sold in the US since 2011 (a few commercial models were sold previous to that but not in any significant numbers) and some conversions were also available. Since then, the number of EVs sold has increased pretty significantly. I wanted to look at the distribution of where those vehicles were located. What is interesting is that California accounts for around 50% of the electric vehicles sold in the United States. Other states have lower rates of EV adoption (in some cases much, much lower). There are many reasons for this, including beneficial policies, public awareness, a large number of potential early adopters and a mild climate. Even so, the EV heatmap of California done early shows that sales are mostly limited to the Bay Area, and LA areas.
The map shows data for total electric vehicle sales by state for years 2016, 2017 or 2018 and also the number of EV sales per 1000 licensed drivers (this is all people in the state with a drivers license, not drivers of EVs). If you hover over a state, you can see both data points for that state.
It will be interesting to see how the next generation of electric vehicles continues to improve, lower in price and become more popular with drivers outside of early adopters.
Data and Tools:
Data on electric vehicle sales is from the Auto Alliance website. Licensed driver data was downloaded from the US Department of Transportation’s Bureau of Transportation Statistics website. The map was made using the leaflet open source mapping library. Data was compiled and calculated using javascript.
Choropleth maps are a pretty useful kind of map that colors distinct areas of the map (e.g. states, counties or countries) to reflect different numerical or categorical values. It is useful to show differences across geographic regions. I’ve been making a bunch of these recently (stressed states, bitcoin electricity consumption, college admissions). One of the issues that can be problematic with these maps is that some regions can be very large but only have very few people. If the choropleth map is tracking a intensity value (like CO2 emissions per capita), a large area with a high color value might visually indicate that total emissions (emissions per capita x # of people) is also high. In the US this is reflected in states like Alaska, Montana and Wyoming, which are large but have very few people.
I decided to make a modified choropleth map (updated after learning that it’s called a cartogram) that scales the size of the states to be the proportional to the state’s population. States with larger populations show up as larger. This is equivalent to making each state have the same population density. Since New Jersey has the highest population density of any state in the US (1200 people/square mile), it stays the same size in this map and all the other states shrink, to reflect their lower population density. For example, California has a larger population than NJ (4.4x), but its physical size is about 20x larger. So California is shrunk to about 20% its original size to make its physical size 4.4x the size of NJ.
The states are also colored to show population as well (darker redder colors reflect larger population while yellow/beige reflects small populations).
Living in California, I decided to make another animation, this time with scaled to the density of California, so some states that are less dense will shrink, while others that are denser will grow. New Jersey grows quite a bit. Because many of the dense Northeast states grow a bit, I had to space them out (manually) so you could still see them otherwise they’d overlap too much.
Data Sources and Tools:
2015 population and population density data comes from Wikipedia and leaflet.js open source mapping library was used to create the maps. State outlines in geoJSON format come from leaflet. Javascript code was used to scale the coordinates of the geoJSON polygons to the appropriate size and animate the map.
Fires are once again raging in California and air quality in one of the most populated metropolitan areas in the country (the San Francisco Bay Area) is quite poor. This map show current air quality in the Bay Area. For more information see the EPA’s Air Quality website.
EPA has assigned a specific color to each AQI category to make it easier for people to understand quickly whether air pollution is reaching unhealthy levels in their communities. For example, the color orange means that conditions are "unhealthy for sensitive groups," while red means that conditions may be "unhealthy for everyone," and so on.
For more information and additional maps see the EPA’s Air Quality website.
This visualization looks at the staggeringly high energy use of Bitcoin and puts it into context: comparing it to electricity usage of US states. Unfortunately for Bitcoin, high energy usage is an intended feature of the system, rather than an unintended consequence. This is because mining is an increasingly energy intensive process, based upon increasingly computationally intensive calculations that are performed on high powered computers and graphical processing units.
Currently, 28 out of 50 states plus the District of Columbia all have lower electricity consumption than estimated annual bitcoin electricity consumption (~73 TWh per year). These states are highlighted in variations of yellow. This is approximately equal to the average annual electricity usage across all US States. States with higher electricity consumption than bitcoin are highlighted in shades of red.
When dividing the total energy use (73 TWh) by the current number of transactions (93 million), we get an average energy consumption of 783 kWh per transaction. Click on the “Energy per Transaction” button to see this visualization. What’s crazy is that a transaction is simply a transfer of bitcoin between “wallets”, recording the transaction, and a validation of the process. There’s no good reason why verifying digital transactions should take this much energy, except that it was built into the fundamental process of validating and mining bitcoin. 783 kWh is larger than the monthly per capita electricity consumption in 10 US states. It could also drive you and your family over 2000 miles in an electric car (e.g. Tesla Model S).
I’m not expert enough in this area to know how much more energy consumption will rise into the future, but if crypto advocates’ predictions come true and bitcoin is used extensively, millions of transactions will occur per hour instead of per year and the price of bitcoin may rise much higher than it currently is. If the price rises, then miners will be willing to expend more energy to “mine” the more valuable bitcoin. Needless to say, this sounds like a very bad idea from an energy consumption and sustainability standpoint.
Data and Tools:
State energy data comes from the US Department of Energy. Estimates of Bitcoin energy use come from Digiconomist’s Bitcoin Energy Consumption Index. The choropleth map is visualized using javascript and the Leaflet.js library with Open Street Map tiles.
Recent Comments