Best tutorials for data journalists

I compiled a round-up of video tutorials and webinars which I found most useful during the last couple of months of my training to become a data journalist.

Data scraping

A series of webinars by Alex Gimson from import.io on:

  1. Auto table extraction
  2. Building a data crawler
  3. Getting data behind passwords
  4. Datasets

And good news – there will be more! Watch this space: http://blog.import.io/

Data visualisation

A series of webinars by Jewel Loree from Tableau on:

  1. Basic Tableau Proficiency 
  2. Actions, Filters and Parameters in Tableau Public
  3. Data Formatting, joins, blends, and table calculations

Two more to come, stay tuned on Tableau Software YouTube channel.

Mapping

A tutotial by Andrew Hill on using CartoDB for mapping:

Online mapping for beginners

Two Google Fusion Tables tutorials which will teach you how to make:

  1. a point map
  2. a polygon map

and here come two webinars you can still take part in:

Obviously, the list is not exhaustive and you would need to do some more reading around the content of the tutorials. Blogs run by the people behind the software should be very helpful in getting more insight into the particular problems you might encounter on the way.

Advertisements

Tornadoes in the US – mapped with CartoDB

tornadoes

tornadoes

As the US braces for tornadoes and downpours of torrential rain over the holiday period, we decided to take a glimpse at the last ten years of twister activity on the US territory.

The interactive map shows twisters that swept through the country between January 2002 and December 2012, often devastating entire regions.

Adverse weather conditions that hit the US on Saturday are there to stay, with heavy rainfall and floods possible in Arkansas, Louisiana and Texas, as well as the lower Great Lakes.

The stormy weather sets in at a time when many Americans hit the road for Christmas holidays. AAA estimates that 94.5 million will travel the minimum of 50 miles from home between this weekend and the New Year’s Day. Some 85.8 million (or 90% of travellers) will go by car, while another 5.5 million will pick a flight over drive.

Although twisters tend to occur more often in spring and summer, many come into being towards the end of the year, as in 2012 when as many as 75 were recorded only in December. A tornado outbreak on Christmas Day that year passed through central Alabama to northeastern Texas.

Tornadoes in December

Tornadoes in December

The first half of 2013 was an exceptionally calm period for twisters, and the year as a whole – one of the calmest on record. In August, the average preliminary count of tornadoes was almost half the average (716 as opposed to 1221), thus slipping below the historical minimum and setting the new 60-year low.

Even though the dangerous storms were infrequent this year, they killed 52 people as of November. The deadliest tornadoes were recorded in May and November. 

tornadoes toll

Motorists are encouraged to check the weather at their destination and along the route before setting off. They are also advised to make sure their cars are well-prepared for the trip; special attention should be paid to the tread, air pressure on the tires and the windshield washer fluid that won’t freeze.

Some facts

  • Over 1,000 tornadoes hit the US each year.
  • On average, tornadoes kill about 60 people per year. Most of the victims die from falling or crushing debris.
  • In 2011, tornadoes killed the record 553 people in 15 states. It was the deadliest year since 1950.
  • Oklahoma City is the city most hit by tornadoes in the US.
  • The first person believed to have hunted tornadoes was Roger Jensen, active in the upper Midwest in the late 1940s.

—————-

Tools: Datawrapper, CartoDB, MapBox

[This post has been created in December 2013]