Skip to content

Instantly share code, notes, and snippets.

View jamesrom's full-sized avatar

James Romeril jamesrom

18 followers · 13 following
View GitHub Profile
@jamesrom
jamesrom / abs-households-edhi-per-week.csv
Last active August 11, 2018 02:18
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 8.
Bracket,1994–95,1995–96,1996–97,1997–98,1999–2000,2000–01,2002–03,2003–04,2005–06,2007–08,2009–10,2011–12,2013–14,2015–16
No income,"170,700","129,600","138,600","169,600","159,500","157,800","175,400","87,300","73,700","72,600","89,000","87,400","86,400","69,700"
$1–49,"113,700","82,000","77,600","88,300","110,900","99,500","101,000","91,300","88,900","78,800","94,200","80,400","95,300","122,400"
$50–99,"84,800","82,900","53,700","72,000","63,300","63,300","76,000","52,500","62,300","42,300","53,700","86,500","75,200","62,300"
$100–149,"70,000","159,000","128,300","107,800","136,100","136,200","129,700","90,900","64,700","49,800","90,600","86,800","51,000","60,600"
$150–199,"278,800","298,500","196,600","233,100","236,900","231,900","178,200","108,000","93,900","104,800","112,900","102,700","111,700","108,600"
$200–249,"442,100","471,100","421,700","412,400","400,100","360,100","340,000","233,500","183,400","168,700","152,000","165,600","156,200","180,300"
$250–299,"1,307,600","1,299,300","1,100,600","1,015,
@jamesrom
jamesrom / abs-lci-quarterly-series-descriptions.csv
Last active August 11, 2018 02:45
Series ID Description
A4116572J Index Numbers ; Pensioner and beneficiary households ; All groups ;
A4083524T Index Numbers ; Employee households ; All groups ;
A4105748W Index Numbers ; Age pensioner households ; All groups ;
A4114808F Index Numbers ; Other government transfer recipient households ; All groups ;
A4116128L Index Numbers ; Self-funded retiree households ; All groups ;
@jamesrom
jamesrom / abs-wpi-quarter-series-descriptions.csv
Last active July 27, 2018 04:05
Series ID Description
A2603039T Quarterly Index ; Total hourly rates of pay excluding bonuses ; Australia ; Private ; All industries ;
A2603989W Quarterly Index ; Total hourly rates of pay excluding bonuses ; Australia ; Public ; All industries ;
A2603609J Quarterly Index ; Total hourly rates of pay excluding bonuses ; Australia ; Private and Public ; All industries ;
A2599619A Quarterly Index ; Total hourly rates of pay excluding bonuses ; New South Wales ; Private and Public ; All industries ;
A2608929K Quarterly Index ; Total hourly rates of pay excluding bonuses ; Victoria ; Private and Public ; All industries ;
A2600949X Quarterly Index ; Total hourly rates of pay excluding bonuses ; Queensland ; Private and Public ; All industries ;
A2610259A Quarterly Index ; Total hourly rates of pay excluding bonuses ; South Australia ; Private and Public ; All industries ;
A2607599L Quarterly Index ; Total hourly rates of pay excluding bonuses ; Western Australia ; Private and Public ;
@jamesrom
jamesrom / Blog SQL
Last active August 29, 2015 14:06
--http://thinkspatial.com.au/xml/2012-05-02.gpx
declare
v_kml clob;
begin
WITH DATA AS (
SELECT x1,
y1,
d,
DECODE(d1,'0',TO_CHAR(d,'YYYY-MM-DD"T"HH24:MI:SS"Z"'),d1) d1,
DECODE(d2,'0',TO_CHAR(d,'YYYY-MM-DD"T"HH24:MI:SS"Z"'),d2) d2,
@jamesrom
jamesrom / www_fdw_server_gpx.sql
Created August 25, 2014 06:12
DROP EXTENSION IF EXISTS www_fdw CASCADE;
CREATE EXTENSION www_fdw;
CREATE SERVER www_fdw_server_gpx
FOREIGN DATA WRAPPER www_fdw
OPTIONS ( uri 'http://thinkspatial.com.au/xml/2012-05-02.gpx',
response_type 'xml',
response_deserialize_callback 'gpx_deserialize_callback');
CREATE USER MAPPING FOR current_user SERVER www_fdw_server_gpx;
CREATE FOREIGN TABLE www_fdw_server_gpx (