Posts for Tag: visualization

500 Most Popular Guitar Songs To Learn To Play

Posted In: Music
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Here are the most popular songs on ultimate-guitar.com, a site dedicated to helping guitar players learn to play guitar songs.

Since sheltering-in-place for the last few months, I’ve been playing guitar more often than I used to. ultimate-guitar.com is a website I visit frequently in order to learn the chords and lyrics to new songs and also keep a “notebook” of songs that I like to play. I thought I’d check to see what songs are most popular on the website.

These songs are mostly user submitted and voted on. Many popular songs may have many different user submitted versions. I downloaded the most popular songs and aggregated across the different versions of the same song to get this list of the 500 most viewed songs on the website.

Sources and Tools:

Data was downloaded from the ultimate-guitar.com website. And the visualization was created using javascript and the open source plotly graphic library.

US city names

Renewable Electricity Generation in US is Now Greater Than Coal

Posted In: Energy | Environment
Facebooktwittergoogle_plusredditpinterestlinkedinmail

A remarkable thing is happening in the United States and in other places around the world. Partly due to the coronavirus pandemic and partly due to changes in natural gas and renewable energy prices, renewable electricity is now a larger fraction of the US electricity grid than coal. As of early May 2020, the fraction of coal generation of US electricity is about 18% while renewables (hydroelectric, wind, solar and geothermal) account for nearly 20%.

For the entire year of 2019, coal accounted for about 24.2% of US electricity generation, while renewables accounted for 17%.4. And in 2018, coal was 28.4% and renewables were 16.8%. When you include nuclear (not technically a renewable resource, but zero emissions of greenhouse gases), about 42% of US electricity generation in 2020 comes from zero carbon sources, while fossil fuels make up the remaining 68%.

This is good news because renewables produce little to no pollution that contributes to urban air quality, health issues and climate change. Coal is by far the worst electricity generation source when it comes to air pollution that impacts human health and climate change. So this shift away from coal and towards renewables is very good news.

Here’s the same graph but showing instead the fraction of electricity from each source (you can hover over the graph to get daily values).

Source and Tools

Data is downloaded from the US Department of Energy’s Energy Information Agency (EIA).. The graph is made using the open source, javascript Plot.ly graphing library.

coronavirus deaths

US Coronavirus Deaths

Posted In: Health
Facebooktwittergoogle_plusredditpinterestlinkedinmail

This visualization is meant to demonstrate the exponential growth of coronavirus deaths in the United States starting in early March when the first confirmed deaths took place. Some reports indicate that the first deaths may have been as early as early February, though that is not shown in this data.

In the animation, each day is about 1 second long so on days with fewer deaths, the figures show up more slowly, while on days with greater deaths, the figures come very, very quickly.

Deaths stop growing exponentially in early April and start to level off and plateau. However, they haven’t yet started to decline significantly so we are still seeing thousands of deaths each day (as of late April).

The data and visualization will be updated daily with data from Covidtracking.com.

For more information about the virus and the disease and data collection, you can find good information on the CDC website.

Sources and Tools:

Coronavirus cases are obtained from covidtracking.com. And the visualization was created using javascript and the font with people figures is called Wee People and was created by Albert Cairo and Propublica.

coronavirus deaths

Visualizing the scale of unemployment due to COVID-19 pandemic

Posted In: Unemployment
Facebooktwittergoogle_plusredditpinterestlinkedinmail

The number of Americans who have recently filed for unemployment due to the coronavirus pandemic is equal to the entire labor force of several states put together.

click on the button below to see a new set of states.

A record 16 million Americans just filed for unemployment due to the coronavirus pandemic at the end of March and early April 2020. This is an amazingly large number of people and I wanted to visualize how many people this actually is. For context, the US Department of Labor statistics states that in February 2020 (before the pandemic hit the United State) there were 164.2 million workers in the Civilian Labor Force.

The Bureau of Labor Statistics (BLS) site defines “Civilian Labor Force” as such:

    “The labor force includes all people age 16 and older who are classified as either employed and unemployed, as defined below. Conceptually, the labor force level is the number of people who are either working or actively looking for work.”

This basically means that approximately 10% of the entire workforce of people (both employed and unemployed in Feb 2020) are now out of a job. While 10% is a large, unprecedented number in our lifetimes, comparing these number to the size of the workforce in several states helps to provide more context. The visualization shows a random collection of states whose total labor force is equal to the latest unemployment numbers. If you click the button you can see a different set of states that have the same total labor force.

Predictions are that the number of unemployed will grow as the shutdowns and social distancing measures to contain the virus continue through April and into May. I will update this graph to reflect new numbers as they come out.

And we can only hope that people will be able to manage these tough economic times until we contain the virus and the economy rebounds.

Stay safe out there: stay away from people and wash your hands!

Sources and Tools:

Data on unemployment was obtained from the US Department of Labor website and labor force numbers by state are downloaded from the Bureau of Labor statistics. And the visualization was created using javascript and the open source leaflet javascript mapping library.

US city names

Tracking US Coronavirus Cases by State

Posted In: Maps

Facebooktwittergoogle_plusredditpinterestlinkedinmail

The coronavirus (SARS-CoV-2) is literally affecting the entire globe right now and changing the way we live our lives here in the US and all over the world.

There are quite a number of different coronavirus-related dataviz out there, but as we shelter-in-place I wanted to add a map that looked at a number of different metrics that tell us about the coronavirus pandemic by US states and look at those metrics on a population basis.

There are a number of data sources that I’ve found that publish data about the coronavirus and the resulting disease (Covid-19) in the United States:

This map is based on the data compiled from covidtracking.com, partly because it has a good API and also lists testing, cases and deaths. The data I’ve included on the map is:

  • Numbers of coronavirus cases – i.e. tested positive for virus
  • Numbers of coronavirus tests administered
  • Numbers of deaths due to coronavirus

Each of these is also calculated per 100,000 population in the state:

  • Numbers of coronavirus cases per 100k people- i.e. tested positive for virus
  • Numbers of coronavirus tests administered per 100k people
  • Numbers of deaths due to coronavirus per 100k people

These latter metrics are important because numbers of cases or deaths can be obscured by small or large populations but per capita data (or per 100k capita data) can point out interesting outliers.

It is important to note that the data is far from perfect. There is probably significant underreporting of tests, cases and deaths. The data is a collection for the various local and state agencies that are working hard to deal with the medical, social and political ramifications of the pandemic, while also collecting data. We don’t know how many Americans have coronavirus because of lack of testing.

Also important is that the number of positive cases is a function of how much testing is taking place so cases does not necessarily represent the exact prevalence of the virus, though there will probably be good correlation between cases and actual coronavirus infections. Luckily it sounds like tests are becoming more widely available so hopefully those numbers will go up sharply.

For more information about the virus and the disease and data collection, you can find good information on the CDC website.

Sources and Tools:

Coronavirus cases are obtained from covidtracking.com. And the visualization was created using javascript and the open source leaflet javascript mapping library.



coronavirus by state

Mapping US Cities By Name

Posted In: Geography | Maps
Facebooktwittergoogle_plusredditpinterestlinkedinmail

This map of the United States visualizes over 28,000 cities in the 50 states. The interactive visualization lets you type in a name (or part of a name) and see all of the cities that contain those string of letters. The points on the map show the geographic center of each city.

For example, if you type in “N”, you will highlight all cities that start with an N in the US. As you type in another letter (e.g. “e”, it will narrow down the cities that begin with those two letters (“Ne”). It will progressively narrow down the number of cities as you type in more letters. You can see an scrollable list of the cities (ordered by city population) that contain the string of letter that you have typed.

If you hover over a highlighted city, you can see the name of the city.

You can click on the check box to show or hide the outlines of the states.

You can “Show City List” to show the list of cities that contain the string of letters you have typed.

Sources and Tools:

City name and location data was downloaded from simplemaps.com. And the visualization was created using javascript and the open source leaflet javascript mapping library.

US city names