Introduction to Open Data 2015

collaborative hackpad for workshop notes

Eric Mill’s Notes: (

JSON to CSV converter:

On Windows/Linux, you need to open the ’raw’ JSON view (Chrome) or click ’view source’ in the upper-right-hand corner (Firefox) before copying in order to use the converter.

Some example URLs used:,roll_id,,voted_at,chamber,question,bill.short_title

Same thing as above with a different Congress,roll_id,,voted_at,chamber,question,bill,congress114

World Bank API:

Making @congressbdaybot from Nicko:

Helpful links / resources:

Why is it called Zulu Time?

The time zone using UTC is sometimes denoted UTC±00:00 or by the letter Z — a reference to the equivalent nautical time zone (GMT), which has been denoted by a Z since about 1950. The letter also refers to the "zone description" of zero hours, which has been used since 1920 (see time zone history). Since the NATO phonetic alphabet word for Z is "Zulu", UTC is sometimes known as Zulu time. This is especially true in aviation, where Zulu is the universal standard.[22] This ensures all pilots regardless of location are using the same 24-hour clock, thus avoiding confusion when flying between time zones.[23] See the list of military time zones for letters used in addition to Z in qualifying time zones other than Greenwich. (from:

Story about twitter bot