Skip to content

Instantly share code, notes, and snippets.

View paulsmith's full-sized avatar
Hi, friends

Paul Smith paulsmith

Hi, friends
View GitHub Profile
paulsmith /
Created March 7, 2014 01:52
keybase proof

Keybase proof

I hereby claim:

  • I am paulsmith on github.
  • I am paulsmith ( on keybase.
  • I have a public key whose fingerprint is ADE0 B338 6493 A843 A705 6F90 3632 F0EE 0AF0 D06B

To claim this, I am signing this object:

paulsmith /
Created April 9, 2014 00:30
Pizza dough recipe

Adapted from "Roberta's," by Carlo Mirarchi, Brandon Hoy, Chris Parachini and Katherine Wheelock.



This recipe, adapted from Roberta’s, the pizza and hipster haute-cuisine utopia in Bushwick, Brooklyn, provides a delicate, extraordinarily flavorful dough that will last in the refrigerator for up to a week. It rewards close attention to weight rather than volume in the matter of the ingredients, and asks for a mixture of finely ground Italian pizza flour (designated “00” on the bags and available in some supermarkets, many specialty groceries and always online) and regular all-purpose flour. As ever with breads, rise time will depend on the temperature and humidity of your kitchen and refrigerator.

paulsmith /
Last active August 29, 2015 13:58
Medicare provider payment data SQL

The Centers for Medicare and Medicaid Services (CMS) today released a 9m row dataset detailing payment data about doctors and other providers who get paid by Medicare. [Read more about the release.][2]

The data, along with a description PDF, is [here][1], and it's roughly 400MB zipped, 1.3GB unzipped, tab-delimited.

I stashed the tab-delimited [data file itself on S3][3], it's public, you can grab it.

It's not a huge file, so you could load it with the schema I made into a local pgsql instance on your laptop, but it's fun to play around with it on AWS Redshift. To load it in Redshift, start up a cluster, connect to it with psql, execute the schema SQL, and run the following commands:

dev=# copy medicare_physician from 's3://paulsmith/medicare/medicare.txt.gz' credentials 'aws_access_key_id=<YOUR ACCESS KEY>;aws_secret_access_key=<YOUR SECRET KEY>' delimiter '\t' gzip ignoreheader 1;
paulsmith / webserver
Last active August 29, 2015 14:02
start a file-serving web server in a directory on an OS-assigned port and opens browser to the root
# Copyright 2014 Paul Smith
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
diff --git a/funcs.h b/funcs.h
index 5780af7..d99a5da 100644
--- a/funcs.h
+++ b/funcs.h
@@ -18,7 +18,7 @@ namespace funcs {
#include "funcs/if.h"
#include "funcs/array.h"
#include "funcs/sort.h"
-#include "funcs/reverse.h"
+//#include "funcs/reverse.h"
paulsmith / chicago-2015-mayoral-election-results-by-precinct.csv
Created February 25, 2015 18:14
Chicago 2015 mayoral election (2015-02-24) results by precinct
ward precinct candidate votes
1 1 Rahm Emanuel 61
1 1 Willie Wilson 5
1 1 Robert W. Fioretti 11
1 1 Jesus "Chuy" Garcia 115
1 1 William Walls, III 2
1 2 Rahm Emanuel 55
1 2 Willie Wilson 10
1 2 Robert W. Fioretti 12
1 2 Jesus "Chuy" Garcia 107
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
package drum
import (
paulsmith /
Last active August 29, 2015 14:18
scrape april 7 2015 chicago mayoral runoff election results
from __future__ import print_function
from collections import namedtuple
import csv
import sys
import time
from urllib import urlopen
from bs4 import BeautifulSoup