Skip to content

Instantly share code, notes, and snippets.

@nsabharwal

nsabharwal/Phoenix Blog

Created October 28, 2015 00:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nsabharwal/bf1ddc912a7202a590e9 to your computer and use it in GitHub Desktop.
Save nsabharwal/bf1ddc912a7202a590e9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Phoenix Blog
drop table if exists crime;
create table crime (
caseid varchar,
Date varchar,
block varchar,
description varchar,
sdesc varchar,
ldesc varchar,
arrest char(2),
domestic char(2),
lat float,
long float
constraint PK PRIMARY KEY (caseid)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment