Skip to content

Instantly share code, notes, and snippets.

View hydrosquall's full-sized avatar

Cameron Yick hydrosquall

View GitHub Profile
@hydrosquall
hydrosquall / data.csv
Created August 8, 2015 17:55
data! from editdata.org!
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 9 columns, instead of 6. in line 8.
Org Code,Dept,Object,Object Description,FY 2013 Actual,FY 2014 Budget,FY 2014 Actual�?,Variance,Unique ID
1801,ELEMENTARY CLASSROOM TEACHERS,51000,FULL TIME EARNED PAY,"24,215,442.88","25,038,797.51","25,038,797.51",0,d1e47421
1251,PATROL,51000,FULL TIME EARNED PAY,"16,977,781.37","17,139,587.00","16,711,260.46","428,326.54",d1e13684
1940,BOE DEBT SERVICE,53200,PRINCIPAL & INTEREST DEBT SERV,"14,777,193.00","16,233,038.00","16,233,038.00",0,d1e64592
1250,POLICE ADMINISTRATION,53201,PRIN / INTEREST PENSION A,"15,436,972.00","15,437,567.00","15,437,567.00",0,d1e12281
1260,FIRE DEPARTMENT ADMINISTRATION,53201,PRIN / INTEREST PENSION A,"14,831,601.00","14,832,173.00","14,832,173.00",0,d1e18328
1827,SPECIAL EDUCATION,51000,FULL TIME EARNED PAY,"13,020,558.28","13,632,952.87","13,632,952.87",0,d1e51083
1300,PUBLIC FACILITIES ADMINISTRATI,53200,PRINCIPAL & INTEREST DEBT SERV,"8,614,910.00","13,363,925.00","10,359,988.95","3,003,936.05",d1e26203
1827,SPECIAL EDUCATION,55540,BOE TUITION,"10,016,661.41","10,355,373.79"
@hydrosquall
hydrosquall / CT-IT-Portfolio.md
Last active August 31, 2015 01:25
Connecticut IT Projects Portfolio

This dataset includes Information Technology projects reported to the Office of Policy and Management by each state agency. The dataset is updated on a quarterly basis minimally and includes active projects as well as completed projects (Post-Implementation).

It is maintained by John Vittner. The Socrata API endpoint is here: https://data.ct.gov/Government/Information-Technology-Project-Portfolio/i7h5-rx65

@hydrosquall
hydrosquall / ctitportfolio.csv
Last active September 7, 2015 21:53
connecticut information tech bar chart
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 11 columns, instead of 8. in line 1.
Level,AgencyName,DateInfoProvided,ProjectName,ProjectDescription,ProjectStartDate,PlannedProjectEndDate,TotalBudget,ProjectPhase,ProjectHealth,ITCapitalInvestmentFund
1,Board Of Pardons and Paroles,6/23/2015,SCORES - Statewide Collaborative Offender Risk Evaluation System,Over the past decade, the national focus on reentry in correctional practice has been embraced by the criminal justice system in Connecticut. The Department of Correction and Board of Pardons and Paroles, in particular, have invested significant and continuing effort to improve practices around reentry.
Pursuant to Public Act 08-01, both agencies partnered with Judicial’s Court Support Services Division to create both the state’s first Reentry Strategy and the first Assessment Strategy in an attempt to define a shared policy for recidivism reduction.
As we continued to improve on our reentry model, it became apparent that effective reentry was only accomplished when solid assessment of offender risk and need was completed and then follow
@hydrosquall
hydrosquall / ctitportfolio.csv
Last active December 7, 2017 01:51
ct_portfolio axis labeled
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
Level,AgencyName,DateInfoProvided,ProjectName,ProjectDescription,ProjectStartDate,PlannedProjectEndDate,TotalBudget,ProjectPhase,ProjectHealth,ITCapitalInvestmentFund
1,Board Of Pardons and Paroles,6/23/2015,SCORES - Statewide Collaborative Offender Risk Evaluation System,"Over the past decade, the national focus on reentry in correctional practice has been embraced by the criminal justice system in Connecticut. The Department of Correction and Board of Pardons and Paroles, in particular, have invested significant and continuing effort to improve practices around reentry.
Pursuant to Public Act 08-01, both agencies partnered with Judicial’s Court Support Services Division to create both the state’s first Reentry Strategy and the first Assessment Strategy in an attempt to define a shared policy for recidivism reduction.
As we continued to improve on our reentry model, it became apparent that effective reentry was only accomplished when solid assessment of offender risk and need was completed and then follo
@hydrosquall
hydrosquall / index.md
Last active September 18, 2015 18:30 — forked from stuartlynn/index.md
CartoDB Internet of Things and Big Data

CartoDB, Big Data and the Internet of Things

Creating an account

Set you up with accounts here. This will give you a free upgrade with double the storage space and some neat features!

Creating your first map

Making maps that explore data

To get used to work with CartoDB we are first going to make a map that will help us explore crime data in Boston.

@hydrosquall
hydrosquall / ctitportfolio.csv
Last active September 22, 2015 05:02
CT IT Portfolio Budget
We can make this file beautiful and searchable if this error is corrected: Any value after quoted field isn't allowed in line 2.
Level,AgencyName,DateInfoProvided,ProjectName,ProjectDescription,ProjectStartDate,PlannedProjectEndDate,TotalBudget,ProjectPhase,ProjectHealth,ITCapitalInvestmentFund
1,Board Of Pardons and Paroles,6/23/2015,SCORES - Statewide Collaborative Offender Risk Evaluation System,"Over the past decade, the national focus on reentry in correctional practice has been embraced by the criminal justice system in Connecticut. The Department of Correction and Board of Pardons and Paroles, in particular, have invested significant and continuing effort to improve practices around reentry."
Pursuant to Public Act 08-01, both agencies partnered with Judicial’s Court Support Services Division to create both the state’s first Reentry Strategy and the first Assessment Strategy in an attempt to define a shared policy for recidivism reduction.
As we continued to improve on our reentry model, it became apparent that effective reentry was only accomplished when solid assessment of offender risk and need was completed and then foll
@hydrosquall
hydrosquall / index.html
Created September 27, 2015 05:47
CT town municipal data points
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Line Chart with Multiple Lines</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
<style type="text/css">
body {
background-color: white;
@hydrosquall
hydrosquall / index.html
Last active October 28, 2015 06:05
A chart of yale's dormitory building energy usage
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Yale College Dorm Energy Usage</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
<style type="text/css">
body {
margin: 0;
@hydrosquall
hydrosquall / index.html
Last active November 8, 2015 06:30
d3 journalism course week 2 - stacked per sqft area chart
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Dormitory Energy Usage</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
<style type="text/css">
body {
@hydrosquall
hydrosquall / README.md
Created November 13, 2015 05:28
geojson example