Skip to content

Instantly share code, notes, and snippets.

View jspeis's full-sized avatar

Jonathan Speiser jspeis

View GitHub Profile
@wavded
wavded / fipsToState.json
Created September 29, 2011 15:27
State FIPS JSON
{
"01": "Alabama",
"02": "Alaska",
"04": "Arizona",
"05": "Arkansas",
"06": "California",
"08": "Colorado",
"09": "Connecticut",
"10": "Delaware",
"11": "District of Columbia",
create extension if not exists "unaccent";
create or replace function slugify(name text)
returns text as $$
begin
return trim(
regexp_replace(
unaccent(lower(name)),
'[^0-9a-z]+',