Posts for Tag: data

Number of Electoral Votes by State in the 59 US Presidential Elections

Posted In: Elections
Facebooktwittergoogle_plusredditpinterestlinkedinmail

How many electoral votes did each state have across two centuries of elections?

This animation shows the number of electoral votes each state had during each of the 59 presidential elections in US history between 1788 and 2020. It’s interesting to see the number of US states and their relative population sizes (in terms of electoral votes) over many different presidential elections. The population is counted every 10 years in the census so if a presidential election occurs between a census, it likely will not see any difference in numbers of electoral votes, unless something else happens (such as addition of a new state to the country).

Instructions
You can use the slider to control the election year to focus on a specific election and toggle the animation by hitting the Start/Stop button. Hovering over each state will tell you the number of electoral votes and the percentage of the total number of electoral votes in that election.

In the elections during and immediately after the US Civil War, we also see some states whose electoral votes for president are not counted (shown in purple). Wyoming, the state with the lowest population in the US, has the highest number of electoral votes per person in the state, while the three most populous states, California, Florida and Texas have the least number of electoral votes per person. Wyoming has four times the number of electors per capita than these 3 states have (i.e. accounting for their population sizes). That will be the subject of another map dataviz.

Here is another map that resizes the US states (i.e. shrink or grow) based on the number of electoral vote so that their electoral power is reflected in its size.

Sources and Tools:

Data on number of electoral votes by state for each election is from Wikipedia. And the visualization was created using javascript and the open source leaflet javascript mapping library.

state borders

Bay Area Coronavirus Cases

Posted In: Health
coronavirus bay area
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Compare the Bay Area coronavirus cases with Los Angeles and the rest of California

I wanted to better understand the coronavirus situation in my home region, the Bay Area, and I hadn’t seen any good resources that compared what was happening here to other regions in California. So I decided to make this graph. This page will be updated daily so you can come back regularly to see how the situation is changing (and hopefully improving sometime soon).

The coronavirus lockdowns began in mid-March 2020 and things have been opening up in late May, which corresponded to an uptick in coronavirus cases in the Bay Area and throughout California. While the cases in the Bay Area are increasing, it’s clear that there’s a big difference between the Bay Area and much of the rest of California. Los Angeles is currently leading the state with a large increase in the number of new cases in June as the economy tries to reopen restaurants, bars, gyms and other businesses.

You can toggle between coronavirus cases and deaths and look at the absolute numbers or on a per capita basis (per one million inhabitants). California has 39.5 million residents, while greater LA has 18.7 million residents and the Bay Area has 7.7 million residents. The daily data is shown as well as a five day moving average so you can get a better sense of the trends.

The San Francisco Bay Area was among the first regions to impose restrictions on gatherings and encourage people to stay home to fight the virus. In late February, the city of San Francisco declared an emergency in preparation for the upcoming pandemic and by early March, things became clear that life would not continue on as before.

The Bay Area is defined as the nine-county region consisting of Alameda, Contra Costa, Marin, Napa, San Francisco, San Mateo, Santa Clara, Solano and Sonoma counties.

Greater Los Angeles is defined as the 5 county region consisting of Los Angeles, Orange, Ventura, San Bernardino and Riverside counties.

Data and Tools:
County level data on coronavirus cases and deaths is from the New York Times github. Data is processed in python and javascript and graphed using the plotly open source graphing library.
bay area coronavirus cases

Which State Borders the Most Other States?

Posted In: Maps
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Interactive Choropleth of the Number of States That Border Each State

This is a fun little map that shows the number of states that border each state. I’m working on improving the interactivity of maps and this was a good project to try this with. The base map is a choropleth map which color codes each state by the number of states it shares a border with. If you hover over (or touch on mobile) a state, it will highlight the state and show you (and list) the bordering states.

It’s important to note that officially New York and Rhode Island share a water border (between Rhode Island and Long Island, NY) and that Michigan and Minnesota also share a border (in Lake Superior).

Sources and Tools:

Data on state borders was downloaded from state.1keydata.com. And the visualization was created using javascript and the open source leaflet javascript mapping library.

state borders

Videoconferencing popularity before and during coronavirus lockdown

Posted In: Technology
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Zoom has become the primary video conferencing app over the last few months as schools and workplaces increasingly turned to remote learning and meetings.

Since the shelter-in-place orders across the United States due to the coronavirus in early to mid-March, many things have changed about our daily lives. One of the main ones is that schooling and work is being done remotely through video conferencing apps on our computers, tablets and smartphones. Our kids have zoom meetings with their teachers, parents have zoom meetings with our work colleagues and we all have facetime and google hangouts chats with our friends and family.

I remembered just a few year ago Skype was a very popular app to use for video chats, so I wanted to see how Zoom came to be the most popular app. The animated graph above shows the relative search volumes for 5 popular video conferencing apps from January 1 to May 15th (before and during the coronavirus restrictions on travel and gatherings).

This article implies that the reason Zoom had taken over so much is because it is free and easy to use for consumers. Even my tech-challenged mother is doing zoom calls for friends and classes.

Data and Tools:
Data is from google trends analysis of videoconferencing apps. Data is processed in javascript and graphed using the plotly open source graphing library.
zoom popularity

200 Most Popular Ukulele Songs To Learn To Play

Posted In: Music
Facebooktwittergoogle_plusredditpinterestlinkedinmail

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

Since sheltering-in-place for the last few months, I’ve been playing guitar and ukulele 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 200 most viewed ukulele 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

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