Introduction to Open Data 2015

collaborative hackpad for workshop notes

Eric Mill’s Notes: https://gist.github.com/konklone/6c9b17d47ce44a91da6c (bit.ly/intro-to-apis)

JSON to CSV converter: http://konklone.io/json/

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:

https://congress.api.sunlightfoundation.com/legislators?apikey=opendataday&per_page=50

https://congress.api.sunlightfoundation.com/votes?apikey=opendataday

https://congress.api.sunlightfoundation.com/votes?apikey=opendataday&order=voted_at__asc

https://congress.api.sunlightfoundation.com/votes?apikey=opendataday&order=voted_at&fields=result,roll_id,breakdown.total,voted_at,chamber,question,bill.short_title

Same thing as above with a different Congress https://congress.api.sunlightfoundation.com/votes?apikey=opendataday&order=voted_at&fields=result,roll_id,breakdown.total,voted_at,chamber,question,bill,congress114

World Bank API: http://data.worldbank.org/developers

http://data.worldbank.org/node/11

Making @congressbdaybot from Nicko: http://sunlightfoundation.com/blog/2014/04/03/i-learned-basic-json-in-the-morning-and-made-a-silly-twitter-bot-with-sunlights-api-in-the-afternoon/

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: http://en.wikipedia.org/wiki/Coordinated_Universal_Time)

Story about twitter bot 

http://sunlightfoundation.com/blog/2014/04/03/i-learned-basic-json-in-the-morning-and-made-a-silly-twitter-bot-with-sunlights-api-in-the-afternoon/