Skip to content

Instantly share code, notes, and snippets.

Avatar

Jeff Sternberg jeff-sternberg

View GitHub Profile
@jeff-sternberg
jeff-sternberg / print_to_web.scpt
Last active May 23, 2020
Demo AppleScript for making web versions of print images
View print_to_web.scpt
-- 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 Mar 31, 2020
COVID19 - BigQuery Public Datasets - Which countries with the highest number of cases have the most per capita?
View covid_cases_per_capita.sql
/*
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,