blocks by palewire

Python helpers for running Amazon Athena queries

Install The Tor Project's snowflake-proxy on a Raspberry Pi

numoji.py

U.S. Earthquake Risk in 3D

e0e3a3d64ed818ded354

How to deploy a Prefect agent to Google Kubernetes Engine

How to push tagged Docker releases to Google Artifact Registry with a GitHub Action

How to open Excel files in Python without pandas

A command-line interface for running Jupyter Notebooks.

65771d17072e99e0e872

67ecca4245d3fe0f616d

4de5720365ad56db50b1

6e346850e48208a03c2f

8f40c3650ebc7dbdace4

4babb0ef8cd7b0f63756

Intensity maps of the 7.1 magnitude earthquake that struck Searles Valley, Calif., on July 5, 2019.

M 7.1 - 18km W of Searles Valley, CA

1717909b31c98f80073e

5cf017f21730ebd8303f

579df0326fa268b924ba

70adac601eba7aef1c1d

Lincoln by Brady

fangraphs-starters-pitch-value-2018

The Mondesi Bet

First Observable Notebook assets

la-county.topojson

Repair and overwrite all shapefiles in the current directory using mapshaper's -clean option

1890 Georgia map

Download all members of Congress from ProPublica's Represent API

the-ichiro-bet.json

pandas-string-slice-example

@LATdatadesk's Inglewood lunch inventory

Rotating proxy scraper example

Simple COPY examples

Migrate PostgreSQL databases to Amazon RDS

Iowa net electricity generation by source

U.S. energy production by sector (1949-2017)

U.S public schools by type and year

django-heroku-important-bits

Custom `python setup.py clean` command

"First Graphics App" files

c89f678de011676e1886

Responsive d3 treemap

World Choropleth

SSL made (almost) easy, or Resistance to AWS is Futile

SHOWANDTELL.markdown

7cde7b2cb501dbfc31dd

load_postgis_1.x_in_postgis_2.x.py

Bigbuilder release notes (March 31, 2017)

Load data incrementally in d3 using a sorted value

5ce3e4eea0f19b6832ca

23765d7349fb40c6edde

How to be like The New York Times and make a psuedo GIF with CSS

Updating sample files

Here are some things you can do with Gists in GistBox.

Datadesk server name picker

Mechanize scrape with Python

df299dd964e9ef6bdab8

Accepts a GeoQuerySet and generates one or more standard deviation ellipses demonstrating the geospatial distribution of where its points occur.

How real estate will be handled in the Tribune Company spinoff of its newspaper properties, according to its SEC Form 10. http://www.sec.gov/Archives/edgar/data/1593195/000119312513466790/d635774dex991.htm

Dorling cartogram experiment with Django

5858568

Used to make a montage of faces of California's War Dead for a Facebook poster image. https://www.facebook.com/photo.php?fbid=10151492464488010&set=a.74076168009.73112.5863113009&type=1

5139096

List of big ass map templates

Excerpts about his relationship with law enforcement from Jack Nelson's memoir, "Scoop: The Evolution of a Southern Reporter"

Joseph Pulitzer's instructions on how to best edit a newspaper, as delivered to a new managing editor circa 1910, according to W.A. Swanberg's biography, "Pulitzer."

A quick Python script for archiving a user's tweets via the Twitter API. Only goes back as far as Twitter allows. Doesn't include RTs by default.

4597413

4592293

Messages to the staff of the New York World sent in 1897 by the newspaper's publisher, Joseph Pulitzer. Drawn from page 219 of W.A. Swanberg's biography, "Pulitzer."

The 133 standard Crayola crayon colors in CartosCSS and ready for use with TileMill.

deletes old Xvfb processes

Download elevation data for the state of California from the USGS's NED system

My attempt to use prefetch related to access M2M data on a massive table with a massive related table

traceroute palewire.s3.amazonaws.com

WTF.py

vacuumdb.sh

My current default Django LOGGING configuration

Locating the story: The latest in mapping.

Weird postgres errors

fab bootstrap

A quick Python script for rolling through the DcoumentCloud error attachment and setting everything live.

1553304

Strip leading and trailing whitespaces in dictionary keys and values

Rounding an integer to precision of "significant digits"

eagle.cow

Eagle

Let Ubuntu read you the latest @wmhartnett updates from Twitter

Takes a GeoDjango queryset and creates a cartogram of circles based on the Dorling algorithm.

A crosswalk that converts state names and abbreviations to A.P. style.

916655

pdf2txt ripper from EveryBlock code.

A Python CSV splitter

Generate a viewport bias from a GeoDjango model. Useful when geocoding.

114943