ThomasThoren

height: 550

ThomasThoren

Track and send reminders about public records requests using Google Sheets

Setup

Use this example spreadsheet for a starting point. Under the "File" tab, select "Make a copy".

https://docs.google.com/spreadsheets/d/1jbkGnok85Q9qT0O4hRAn0uVDA9deWW10kMwreoBpzKg/.

Spreadsheet

ThomasThoren

height: 725

ThomasThoren

height: 1000

ThomasThoren

The code that powers the text animations shown here: http://projects.fivethirtyeight.com/.

ThomasThoren

height: 700
border: no

ThomasThoren

# Default Makefile

# Save as ~/.Makefile or similar and use as starting point for new Makefiles.

PROJECT_DIR=`pwd`

# Keep intermediate files
.SECONDARY:

.PHONY: help

ThomasThoren

Web browsers

Force downloads to open in the same tab

This makes it easier to copy the cURL request.

Source: http://stackoverflow.com/a/16344250/2574244

[].forEach.call(document.querySelectorAll('a'),

ThomasThoren

jq

Docs: https://stedolan.github.io/jq/

Download sample JSON data from the City of Austin. This contains traffic light data.

$ curl -o data.json https://data.austintexas.gov/resource/fs3c-45ge.json

ThomasThoren

Intro to SQL

This guide was made for the hands-on SQL workshop at IRE 2016 in New Orleans. It uses bridge inspection data from the Federal Highway Administration's Bridge Inventory Database. You can download the Louisiana data here, courtesy of IRE.

The rest of the hands-on SQL class material is located here: http://bit.ly/hands_on_sql_ire2016

Selecting your data

SELECT and FROM