Sign up: cartodb.com
tinyurl.com/ecarto
Data visualisation
(CartoDB)
lat & long (for geocoding)name (string - good for labels)ob_death (numeric - good for choropleths)case_type (fixed vocab - good for categories)
...are easy
Hint: Only some visualisation types support labels.
One visualisation has 1+ datasets.
One dataset has 1 map view, 0+ visualisations
1 visualisation = 1+ layers
1 layer: 1 map
1, 2 = switch layers
https://www.mapbox.com/carto/api/2.3.0/
https://github.com/mapbox/geo-googledocs
Add row
Then lat/long
CartoDB supports:
AURIN, data.gov.au, CartoDB "common data", Google...
SELECT * FROM ebola
WHERE name ILIKE '%Hospital%'
Not basic SQL