Category: DataViz Turned-In Assignments

DataViz Final: Yi Zhang

Seeing Fantasy Movie’s Global Potential from Beauty and the Beast

Beauty and the Beast is a traditional fairy tale that we all familiar with. The Disney’s 1991 animated film of the same name was part of our childhood memory and Belle was one of our favorite Disney princesses as well. A live-action remake of Disney’s 1991 animated film Beauty and the Beast was released on March 17 this year. The new movie received generally positive reviews from critics and audiences and has grossed over $1.1 billion worldwide, making it the highest-grossing film of 2017. Besides the 1991 animated film and the one coming out this year, the story has been put on screens for many times.

Been released for 7 weeks, the movie Beauty and the Beast has reached a total domestic gross of  $473,700,233 and foreign gross of $629,975,123 till April 27, 2017. Compared to other similar movies, it has achieved a great outcome. Similar movies refers those ones that have similarities in terms of audience appeal, genre, tone, timeframe and release pattern. The comparison indicates how this movie is doing in its own playing field, which is fantasy movie in this case.

Based on the chart, the total gross of fantasy movie generally tends to grow since 2011 and the foreign gross usually shares more than half of the total gross. It indicates that fantasy movie has a large global market potential. Here is a map showing how well the movie Beauty and the Beast performs at other countries’ box offices.

Beauty and the Beast Total Gross by Country
Create your own infographics

Fairy tales and their fantasy movie adaptions are easily to be accepted by people from different culture backgrounds. Film companies know that well. There will be 4 fantasy movies coming out in 2018, including the live action adaption of another famous Disney animation Mulan which story originally comes from China. It seems that Disney has grasped the great opportunity to expand Asian market more.

I also post this final project to my portfolio website. Here is the link to the page in my portfolio.

Lynda Requirement – Elena DeLuccia

This was my first time using Lynda! I chose to do the “Data Visualization Storytelling Essentials” since I really loved this course. Even though it most likely won’t play a part in my career in film and TV, I just liked being able to create different data visualizations. I find going through data and creating a story from it so interesting. So this was definitely a great thing to do.

I loved that they suggested drawing out the visualization before anything else. As a graphic designer, this is something I often do – but not something I thought of doing before creating visualized and interactive data. I thought that this was really a way to innovate and improve my skills. When I was doing my final project on women in film and TV, it was helpful to draw out what data I thought should be included to coincide with my story and improve the experience of readers. This also tied into the Lynda lesson of having your visualizations interact with your story. Maybe my readers would want to learn more if they actually saw the data – so that’s what I aimed for! Insightful tables and graphs that tell the user “Go, learn more about this!” without blatantly shouting at them – that was the goal. The lesson that stuck with me the most though was the instructor talking about making your visualizations aesthetically pleasing while also keeping everything factual and learnable – or what they called Eye Candy. I tried my best to keep everything like that, although it is a perfectionist tendency on my part for them to be that way regardless, just because that’s how my brain works being a film and television person.

Overall, this was a really interesting course, and I think it helped me for future data visualizations that I choose to do! I have one coming up in my social media course, so I’m really excited to show my new skills.


Datavia Final Project_Yuanjun Peng

Disney began to release movie in 1930s and has more than 100 movie till now. However, all its most gross generated movie are released after 1995. Since there are hundreds of Disney movie, in this story I will show the most gross generated movies in Disney’s history from 1995 to 2017, and both domestic and international performance of its top 1 movie.

To begin to have an understand what the most gross generated movies are from 1995 till now, let’s see the timeline.

Then,  I did a sortable table to have a more direct and clear understand of their performance in details. In this table, you can see rank, data, genre, total gross and other information of top 20 gross generated movie in Disney’s history.

From the table above, we can see that Star Was Ep. VII: The Force Awakenes is the top 1 gross generated movie with $936,662,225 in Disney’s history. And 2016 is the best performance year for there were 4 out of 20 top gross generated movies. What’s more, series of Toy Story, Pirates of the Caribbean and Marvel superhero draw most audience.

Let’s have a look how this movie performed in U.S. and outside.Star Was Ep. VII: The Force Awakenes  was on from 12/24/2015 to 6/2/2016, almost half year and generated most revenue from its first moth, especially first two weeks. Then its performance went down and flat.

This movie was on in more than 50 countries and regions outside U.S. From Storymap beneath, you can have a more detailed look of its performance in each country. It had best revenue in U.K, China and Germany. The reason is obvious: U.K is an English speaking country and has similar culture with U.S. ; Germany is the largest economy entity in Europe Continent; Same case for China and it has most potential audience as well.

You also can see this story at:

Groh: Dataviz Final

The salary for public officials is often at the center of debate. Citizens complain that state employees are paid too high.  State employees say they aren’t compensated enough. Often the conversation ends up revolving around taxes. If state officials want higher salaries they need to find it somewhere in the budget or raise taxes. Regular citizens are normally pretty open to reducing their own taxes, but that reflects negatively in another persons’ check.


To begin to understand how much and why certain state officials are paid their given salary, a state’s tax revenue and overall budget need to be analyzed.

As shown by the table, California and New York have by far the biggest budgets and tax revenues. This is directly proportional, for the most part, with the average salary of each state’s public employees. So the larger the tax revenue and budget the higher the salary.


A state’s budget and revenue are fairly indicative of an employee’s potential salary. However, there are few exceptions as seen in the graph. Also, these numbers do not differentiate between part-time and full-time employees, which would denote a salary difference.

When the numbers are broken down by job type, there is a shocking result. The highest paid state employees in the United States are division I basketball and football coaches.

American sports are a huge profit generator. Nowhere else in the world are college sports taken so seriously, either.

The head coach of the University of Alabama football team, Nick Saban, makes $7 million a year. Since 2009, the Crimson Tide have won four national championships, were runners-up twice, produced 2 Heisman trophy winners, and haven’t lost more than 2 games in one season.

However, there is a caveat with this number that applies to all the other coaches. These schools and athletic departments make the majority of there money from other avenues other than taxes. Large T.V. commercial deals, sponsorships, rights to broadcast a game, ticket sales, merchandise sales, and concessions all contribute to Nick Saban’s salary. What amplifies the situation is that the better the team does, the more money the school gets for high profile playoff games, increased merchandise sales, and inflated ticket prices. So to say that these coaches are state employees may be a stretch. However, they are still employed by a public university which is apart of the state. Therefore, coaches are still considered state employees/

What has some people complaining, is the compensation the coaches get for the level of importance of their job. Employees who work in the state capital are crucial to the functioning of the state but don’t see the same level of compensation. This simply boils down to the industry. Some industries are more lucrative than others just as reporters are not paid as much as bankers.

What’s most interesting is that no state governors make the list of being the state’s highest paid employee. The majority of the people who are the highest paid employees are doctors, coaches, and university administrative personnel. Governors make around $100,000 a year.

The role of the governor may be more important in the management and functioning of the state, but that nature of the job doesn’t illicit a high wage. Even the highest office in the U.S only gets paid $400,000. To put this in perspective, Donald Trump would only be the highest paid public employee in three states: Maine, New Hampshire, and Montana.


Lynda Requirement- Edwards

I watched the Lynda tutorial “Data Visualization Storytelling Essentials” because I felt like it fit well into my goal of becoming a TV news journalist. I wanted to know how I could best display data for stories I will work on in the future.

I learned several things through the course. The first, most influential idea was to work with my hands and sketch out my visualization. Because I wanted to do my final project on Trump, this was essential for me to do. There were so many facets of his campaign and his time in office that I could tackle, so I was overwhelmed with the data I had access to. I sat down and thought through a range of topics.

At first, I had a few completely different ideas than what I ended up with. I was thinking about things that would not be the best to visualize and ideas that weren’t related to each other enough. After I wrote down topic ideas, however, I circled the ones that were best related to each other and the ones I thought would be best for data. This pre-planning was the best time I spent on this project. Afterwards, I knew exactly what I wanted to do and it was full steam ahead!

Another important lesson from the course was that my project should have elements of storytelling and interactivity. First, I started thinking about storytelling with my list of topics I wanted to pursue. Do they tell one, cohesive story? Well, no. Not at first. After thinking it through, I realized that the story I could tell was his first 100 days in office. It’s an important milestone that’s constantly mentioned in the media, and Trump himself, so I picked that as my focus. Next, I thought about interactivity. They related the idea to ‘progressive depth’. Essentially, allowing a viewer to go deeper if they want to learn more. Keeping this in mind, I decided to go with a searchable, sortable table. This way, viewers can see the first 25 listings, but if they want to search for a certain item, they could go deeper.

I also learned that the way to attract an audience best is by using data that lends itself to personalization. By choosing Donald Trump as a topic, I thought that this would be of interest to many people! His policy proposals affect so many Americans, so data about him will be of interest (I hope!)

Lastly, the lesson about ‘eye candy’ was my favorite! It talked about making your data pretty without straying from fact or purpose– a tenant of TV news, too. This helped cement the fact that I wanted to do the Knight Lab timeline. I loved it when we were first introduced to it in class, and I felt that was a great tool to visualize the data I was looking at. Since it is the most visually appealing, I put it first to reel in a viewer.

This course really helped me think through the tools I would want to use and how to use them for my final project. With this course in mind, my final project ended up looking like this:

Lynda Requirement – Zhiyan Zhong

Instead of writing a blog post about what I learned on, I decided to write about my experience at the Computer-Assisted Reporting (CAR) Conference held by the IRE and NICAR in March, which was an amazing learning experience.

At the CAR conference, I learned a variety of topics, from the basics on using spreadsheets, databases and online mapping to filing FOIA requests and data visualization. My biggest takeaways from the conference was learning how to build my first news app.

During the seven-hour-long training session, the instructor walked us through the process of building an interactive data visualization from a structured dataset. We got to learn every stage of the development process writing HTML, JavaScript and Python. At the end of the class, we published an interactive map with a table about people who died during the Los Angeles riot in 1992. Here is the project I made.

The process was complicated, so I will just highlight the major steps of the project. With all prerequisites installed on the computer, we started the project with creating a new development environment with virtualenv. Then we created a new Git repository and connected our local directory to GitHub. The second major step was to use pip on the command line on Terminal to install Flask, the Python “micro-framework” we used to put together our website, and then configured Flask to make a page at our site’s root URL. The third step was to build the HTML document. At the meanwhile, we also used Python’s csv module to access the data we wanted to put on the website. After that, we used Jinja to sculpt the data in index.html to create an HTML table that lists all the names of the victims. In step 4, we made use of the Leaflet JavaScript library to create a map on each detail page showing where the victim died. In the final act, we published our application to the internet using Frozen Flask, a Python library that saves every page we had made with Flask as a flat file that can be uploaded to the web.

The concept of building a news application was totally new to me and I still haven’t totally understood each stage of the process. But the course has definitely cleared up some confusions I had about news apps before and taught me the logic of building such an app, which I think is more important than being able to code everything on my own. Understanding the logic will allow me to apply the concept to other projects and dig deeper later. I can make unique interactive data visualization with the knowledge I learned from the class. This is also helpful for our dataviz class. Especially for my final project about farmers markets, it would be useful to make an interactive map listing every market in the state by creating a news app. I didn’t end up making it because I didn’t know how to put the news app to our class website and there are other good mapping tools available, but I will definitely look into it when I have time.

All in all, it was a very helpful training and I was inspired to explore more possibilities with the knowledge I learned.

Final Project – Zhiyan Zhong

In the old days, people went to farmers markets out of necessity. Farmers markets offered a variety of fresh food at a lower price, while grocery stores were usually small and poorly stocked by comparison. With the development of big box retailers and the growth of online grocery shopping in recent years, many people tend to think that farmers markets are losing their customers. However, according to the latest data from the United States Department of Agriculture (USDA), farmers markets have been on the rise and the United States has seen new farmers markets springing up around the country over the past decade.

Currently, there are 8,674 farmers markets listed in the USDA’s National Farmers Market Directory. A majority of these markets are located in California and New York. In contrast, Virginia Islands, Delaware and Alaska have the least farmers markets, with the number lower than 40 currently.

U.S. Farmers Market by State
Create your own infographics

The current number of farmers markets in the U.S. is nearly twice the number ten years ago. Chef and author Alice Waters even predicted in an article on The Wall Street Journal that there would be “at least one farmers market in every town in the country,” but some latest numbers may be telling a different story. The growth of farmers markets has been slowing down during the past few years. After a jump of 17% in markets between 2010 and 2011, the growth rate in 2016 was only 2.3 percent from the prior year.

“That says that something that grows really rapidly can’t continue to do that forever,” said Larry Lev, a professor and extension economist at Oregon State University, in an interview with U.S. News & World Report.

Also, even though there has been a growth of farmers markets in the nation, there are not many people who actually shop at those markets. Americans spent $7 billion on locally sourced food purchases in 2011, compared to the nearly $700 billion they spent on groceries in that same year, according to the USDA’s data. A study conducted by King Retail Solutions also points out that the millennial generation is already comfortable shopping at c-stores, pharmacies, and other non-traditional venues for groceries. Whether or not farmers markets will still be able to attract customers in the future would be a question.

(The Tableau map may have problem opening in Chrome and Safari. If the map doesn’t load, please use other browsers like Firefox.)

In New York State, the number of farmers markets in the past decade has also grown at a rapid rate, according to the New York State Department of Agriculture and Markets. According to the U.S. News & World Report, the rapid growth in farmers markets in recent years has been a result of several factors — the local food movement, the desire to support local businesses and farmers, and community-building all have contributed. As the map above indicates, most farmers markets in the state are located in the larger city areas, such as New York City and Albany.

Farmers markets provide a variety of benefits to local communities. One is that they are also easy to find. As a result of their flexible locations, some community farmers markets provide fresh, healthy foods when other sources aren’t as easily accessed. Besides this, farmers markets serve not only as a way for people to purchase locally grown products but also as an opportunity for them to get involved in the community. Purchasing local food has become a social experience that offers a sense of place and a sense of belonging within the community.

Nevertheless, with summer harvests reaching their peak, it’s a great time to visit farmers markets. To find a market near you, the map above and the following table could be helpful.

Final Project – Carla Caban

On April 24, 2017 Jack Jones became the 1,452nd person to be executed in the United States since 1977. Jones was convicted and sentenced to death for the rape and murder of Mary Philips back in 1996. Jones among the other 1,451 people that have been executed exemplify the act of capital punishment that has been in effect in the United States for essentially all of the country’s existence. The death penalty in the Unites States for many years has been a topic of vast public dispute. Ever since the death penalty was abolished and later reinstated back in 1976, public opinion has shifted back and forth on whether to favor or oppose such sentence. For this piece, I wanted to gather more information about the death penalty and contrast both opposing and favoring views on it. I wanted to take a closer look into which states still have in effect the death penalty, which states have carried out the most executions, and ultimately what are other factors contribute to this debate. First, let’s consider the history of the death penalty in the United States.

As the timeline showed, with data taken from CNN, with the introduction of the lethal injection as a form of execution, there have been many concerns regarding whether or not this falls under “cruel or unusual punishment.” In order to be able to comprehend and examine the death penalty and its pros and cons, Hugo Adam Bedau, in a work published by the American Civil Liberties Union entitled “The Case Against the Death Penalty,” presents eight angles by which the death penalty may be analyzed. These are: the costs of the death penalty relative to incarceration, the barbarity of the practice, its public support, its increasing rejection by the global community, whether it is unfair, whether it punishes the innocent, whether it is a deterrent, and whether it is unjust retribution. By putting these into perspective one can construct a more rounded opinion on which side to stand.

Why in Favor?
So why be in favor of the death penalty? By taking into consideration these eight angles, the death penalty can guarantee that a person that has committed a heinous crime pays for what he or she did. Additionally, it removes that person from further committing additional harm to society or to himself. Some may add that it provides some level of justice to the victims of those affected by their heinous crimes. Ultimately, it could also serve as a deterrent for other criminals to commit similar heinous acts. However, there is no definite evidence that the death penalty has indeed acted as a deterrent or whether it provides a fair reason for the government to take the life of another. Most of the population are still in favor of the death penalty with 49% support compared to 42% that are opposed, however, the number continues to decline. According to Pew Research Center, Democrats account for much of the decline in support over the past two decades. In 2016, just 34% of Democrats favored the death penalty, compared with 72% of Republicans. With public support steadily declining over the past few years the nation’s attention has become focused on the possible risk of substantive error in the process of sentencing someone to death, which is why some are against it.

Why Against?
From my research and personal experiences and taking into consideration the eight angles again, I believe most of the people that are opposed to the death penalty is because they struggle with the morality of the act. Another is due to the possibility that an innocent person might be wrongly convicted to death. Although, there has been no conclusive evidence showing that individuals who were bound to death row that got pardoned were executed. In addition, with controversial executions like Clayton Lockett it raises concerns on the barbarity of the practice. Another aspect that comes into questions is the cost. According to the Death Penalty Information Center, cases without the death penalty can cost $740,000, while cases where the death penalty is sought can cost up to $1.26 million. Maintaining each death row prisoner can costs taxpayers $90,000 more per year than a prisoner in general population. These number need to be taken with caution since they can vary from state to state. Plus, more substantive factors should be of more value to decision makers than the cost. Furthermore, there also seems to be a global resistance towards capital punishment. According to Amnesty International, for the first time in a decade, the United States was not among the top five countries that carry out executions. The U.S. ranked seventh internationally, behind China, Iran, Saudi Arabia, Iraq, Pakistan and Egypt with the last four countries excluding Egypt accounting for 87% of total executions. For some that is not a place where they want the United States to stand.

With both views, there are its challenges and with these there is limited reliable information where the public can base their decisions on. Aspects such as geography, selection of jury, discretion and media coverage can all affect the way in which a trial is decided or interpreted by the public. Nonetheless, there are safeguards put in place to prevent substantive errors from being made such as the Appellate Court where defendants have the automatic right to appeal their verdict.

Does public opinion affect outcomes?

Does Public Opinion affect Outcomes?
Create your own infographics

This chart compares the support of the death penalty with the number of executions done by year. From this chart one can see that there is a slight correlation of these two. But are they directly proportional? It would be hard to find exact evidence on that. However, having support of capital punishment seems to justify the government’s use of it. Let’s take a look at the discrepancies of public opinion over the years as well as gender, racial and partisan gaps in views.

Public Opinion on Death Penalty Over Years
Create line charts

Of the 35 jurisdictions that still hold the death penalty some states stand out more than others. For example Texas with 542, Oklahoma with 112, Virginia with 112 and Florida with 92.

Number of Executions by State
Create your own infographics

According to Jeffrey Tobin from the New Yorker, there are many factors that have led to the decline of the death penalty in recent years. Some of them being: less crime over all, with less fear among the public as a result; exonerations based on DNA evidence have lead jurors to hesitate before imposing a death penalty sentence; reluctance of pharmaceutical companies to provide the lethal-injection drugs and thus the search for a drug protocol that passes constitutional agreement. With these factors being some of the cause for the decline in support there is a heightened emphasis on the juries to make the right legal decision. The future of the death penalty is in jeopardy if the American public believe that substantive errors occur widely in capital cases and whether the American people believe that the government does not care or that they are trying to hide the nature of the problem. I believe that although it is now legal in 35 jurisdictions the death penalty will still be practiced in the United States. It will not be until a specific case comes that raises concerns that the death penalty will go away.

Below is a list of all the people that have been executed in the United States since 1977.

Final Project: Edwards

Here is a link to my final project:

Groh: assignment 4

Drones may have a very large impact in my future. Since I want to be a reporter, I am always thinking about new ways to shoot film and how to create an interesting standup. If I am able to go to a location and use a drone to get ariel footage of something I wouldn’t normally be able to get to, it will increase my stature as a reporter. It will make me a go to person for information since I am able to get photos of things others people can’t. It will also make all my footage more dynamic. I will be able to follow rescue crews as they walk into a disaster site. What’s really exciting is that it will make me even more powerful as a one-man-band reporter. To do certain standups reporters need a cameraman. However, with a drone, I am my own camera man, and I can have it follow me where ever I go. So, I can increase the creativity of my shots.