Skip to content

Instantly share code, notes, and snippets.

View jeff-sternberg's full-sized avatar

Jeff Sternberg jeff-sternberg

View GitHub Profile
@jeff-sternberg
jeff-sternberg / print_to_web.scpt
Last active May 23, 2020 15:57
Demo AppleScript for making web versions of print images
-- examples, replace with yours
set print_images to ¬
{"/Users/jeffsternberg/Desktop/catalog/image_1.psd", ¬
"/Users/jeffsternberg/Desktop/catalog/image_2.psd"}
-- main loop
repeat with print_image in print_images
process_image(print_image)
end repeat
@jeff-sternberg
jeff-sternberg / covid_cases_per_capita.sql
Last active March 31, 2020 17:56
COVID19 - BigQuery Public Datasets - Which countries with the highest number of cases have the most per capita?
/*
Which countries with the highest number of cases have the most per capita?
This query joins the Johns Hopkins dataset with the World Bank's global population data
to determine which countries among those with the highest total number of cases have the most cases per capita.
See https://console.cloud.google.com/marketplace/details/johnshopkins/covid19_jhu_global_cases
*/
SELECT
cases.country_region AS country_region,
SUM(_3_30_20) AS total_cases,