Skip to content

Instantly share code, notes, and snippets.

@pswg

pswg/sample.json

Created April 4, 2018 16:54
Show Gist options
  • Save pswg/787e227080ce8494f67ef4f90efaec8f to your computer and use it in GitHub Desktop.
Save pswg/787e227080ce8494f67ef4f90efaec8f to your computer and use it in GitHub Desktop.
Download ZIP
Sample output from Wicked Web Scraper
Raw
sample.json
{"ldc":"PECO","accountNumber":"0004005127","serviceZipCode":"19056","meterBillGroupNumber":6,"currentPlc":{"value":2.02,"startDate":"2017-06-01T05:00:00.000Z","endDate":"2018-05-31T05:00:00.000Z"},"nspl":{"value":2.64,"startDate":"2018-01-01T06:00:00.000Z","endDate":"2018-12-31T06:00:00.000Z"},"futurePlc":{"value":2.57,"startDate":"2018-06-01T05:00:00.000Z","endDate":"2019-05-31T05:00:00.000Z"},"historicalUsage":[{"startDate":"2010-07-07T05:00:00.000Z","endDate":"2010-08-05T05:00:00.000Z","rateCode":"ECM","rateClass":"GS","strata":"004","usage":0,"demand":0},{"startDate":"2010-06-07T05:00:00.000Z","endDate":"2010-07-07T05:00:00.000Z","rateCode":"ECM","rateClass":"GS","strata":"004","usage":0,"demand":0},{"startDate":"2010-05-06T05:00:00.000Z","endDate":"2010-06-07T05:00:00.000Z","rateCode":"ECM","rateClass":"GS","strata":"004","usage":0,"demand":0},{"startDate":"2010-04-07T05:00:00.000Z","endDate":"2010-05-06T05:00:00.000Z","rateCode":"ECM","rateClass":"GS","strata":"004","usage":0,"demand":0},{"startDate":"2010-03-09T06:00:00.000Z","endDate":"2010-04-07T05:00:00.000Z","rateCode":"ECM","rateClass":"GS","strata":"004","usage":0,"demand":0},{"startDate":"2010-03-02T06:00:00.000Z","endDate":"2010-03-09T06:00:00.000Z","rateCode":"ECM","rateClass":"GS","strata":"004","usage":0,"demand":0},{"startDate":"2018-01-05T06:00:00.000Z","endDate":"2018-02-06T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2392,"demand":6.35},{"startDate":"2017-12-04T06:00:00.000Z","endDate":"2018-01-05T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2475,"demand":6.16},{"startDate":"2017-11-01T05:00:00.000Z","endDate":"2017-12-04T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1596,"demand":4.84},{"startDate":"2017-10-03T05:00:00.000Z","endDate":"2017-11-01T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1042,"demand":2.28},{"startDate":"2017-09-02T05:00:00.000Z","endDate":"2017-10-03T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1108,"demand":2.48},{"startDate":"2017-08-04T05:00:00.000Z","endDate":"2017-09-02T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1042,"demand":2.26},{"startDate":"2017-07-06T05:00:00.000Z","endDate":"2017-08-04T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1075,"demand":2.75},{"startDate":"2017-06-06T05:00:00.000Z","endDate":"2017-07-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1201,"demand":2.77},{"startDate":"2017-05-05T05:00:00.000Z","endDate":"2017-06-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1285,"demand":2.75},{"startDate":"2017-04-06T05:00:00.000Z","endDate":"2017-05-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1063,"demand":3.88},{"startDate":"2017-03-09T06:00:00.000Z","endDate":"2017-04-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1635,"demand":5.31},{"startDate":"2017-02-07T06:00:00.000Z","endDate":"2017-03-09T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1774,"demand":5.6},{"startDate":"2017-01-06T06:00:00.000Z","endDate":"2017-02-07T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2170,"demand":6.43},{"startDate":"2016-12-05T06:00:00.000Z","endDate":"2017-01-06T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2255,"demand":5.37},{"startDate":"2016-11-02T05:00:00.000Z","endDate":"2016-12-05T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1613,"demand":4.35},{"startDate":"2016-10-04T05:00:00.000Z","endDate":"2016-11-02T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1102,"demand":4.15},{"startDate":"2016-09-02T05:00:00.000Z","endDate":"2016-10-04T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1147,"demand":2.47},{"startDate":"2016-08-04T05:00:00.000Z","endDate":"2016-09-02T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1080,"demand":2.39},{"startDate":"2016-07-06T05:00:00.000Z","endDate":"2016-08-04T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1073,"demand":2.36},{"startDate":"2016-06-06T05:00:00.000Z","endDate":"2016-07-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1099,"demand":2.21},{"startDate":"2016-05-05T05:00:00.000Z","endDate":"2016-06-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1149,"demand":2.16},{"startDate":"2016-04-06T05:00:00.000Z","endDate":"2016-05-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1162,"demand":4.8},{"startDate":"2016-03-08T06:00:00.000Z","endDate":"2016-04-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1251,"demand":4.89},{"startDate":"2016-02-08T06:00:00.000Z","endDate":"2016-03-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2159,"demand":6.72},{"startDate":"2016-01-11T06:00:00.000Z","endDate":"2016-02-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2353,"demand":6.29},{"startDate":"2015-12-04T06:00:00.000Z","endDate":"2016-01-11T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1999,"demand":6.4},{"startDate":"2015-11-03T06:00:00.000Z","endDate":"2015-12-04T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1363,"demand":4.71},{"startDate":"2015-10-05T05:00:00.000Z","endDate":"2015-11-03T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1140,"demand":4.74},{"startDate":"2015-09-03T05:00:00.000Z","endDate":"2015-10-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1185,"demand":2.39},{"startDate":"2015-08-05T05:00:00.000Z","endDate":"2015-09-03T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1093,"demand":2.33},{"startDate":"2015-07-07T05:00:00.000Z","endDate":"2015-08-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1099,"demand":2.24},{"startDate":"2015-06-05T05:00:00.000Z","endDate":"2015-07-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1191,"demand":2.25},{"startDate":"2015-05-08T05:00:00.000Z","endDate":"2015-06-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1029,"demand":2.08},{"startDate":"2015-04-07T05:00:00.000Z","endDate":"2015-05-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1230,"demand":4.62},{"startDate":"2015-03-09T05:00:00.000Z","endDate":"2015-04-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1769,"demand":5.83},{"startDate":"2015-02-06T06:00:00.000Z","endDate":"2015-03-09T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":3366,"demand":7.28},{"startDate":"2015-01-10T06:00:00.000Z","endDate":"2015-02-06T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2688,"demand":6.87},{"startDate":"2014-12-08T06:00:00.000Z","endDate":"2015-01-10T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2846,"demand":8.69},{"startDate":"2014-11-03T06:00:00.000Z","endDate":"2014-12-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1856,"demand":5.53},{"startDate":"2014-10-05T05:00:00.000Z","endDate":"2014-11-03T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1132,"demand":4.76},{"startDate":"2014-09-04T05:00:00.000Z","endDate":"2014-10-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1142,"demand":2.3},{"startDate":"2014-08-05T05:00:00.000Z","endDate":"2014-09-04T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1119,"demand":2.26},{"startDate":"2014-07-07T05:00:00.000Z","endDate":"2014-08-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1084,"demand":2.17},{"startDate":"2014-06-08T05:00:00.000Z","endDate":"2014-07-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1190,"demand":2.59},{"startDate":"2014-05-07T05:00:00.000Z","endDate":"2014-06-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1695,"demand":3},{"startDate":"2014-04-08T05:00:00.000Z","endDate":"2014-05-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1823,"demand":6.52},{"startDate":"2014-03-10T05:00:00.000Z","endDate":"2014-04-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2518,"demand":6.68},{"startDate":"2014-02-09T06:00:00.000Z","endDate":"2014-03-10T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":3379,"demand":7.23},{"startDate":"2014-01-08T06:00:00.000Z","endDate":"2014-02-09T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":3618,"demand":7.42},{"startDate":"2013-12-05T06:00:00.000Z","endDate":"2014-01-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":3016,"demand":6.47},{"startDate":"2013-11-04T06:00:00.000Z","endDate":"2013-12-05T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1883,"demand":5.23},{"startDate":"2013-10-06T05:00:00.000Z","endDate":"2013-11-04T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1129,"demand":4.8},{"startDate":"2013-09-05T05:00:00.000Z","endDate":"2013-10-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1120,"demand":2.15},{"startDate":"2013-08-06T05:00:00.000Z","endDate":"2013-09-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1058,"demand":2.16},{"startDate":"2013-07-08T05:00:00.000Z","endDate":"2013-08-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":987,"demand":2.17},{"startDate":"2013-06-06T05:00:00.000Z","endDate":"2013-07-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1103,"demand":2.16},{"startDate":"2013-05-08T05:00:00.000Z","endDate":"2013-06-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1023,"demand":3.17},{"startDate":"2013-04-08T05:00:00.000Z","endDate":"2013-05-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1098,"demand":4.75},{"startDate":"2013-03-10T06:00:00.000Z","endDate":"2013-04-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1726,"demand":5.04},{"startDate":"2013-02-07T06:00:00.000Z","endDate":"2013-03-10T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2367,"demand":5.34},{"startDate":"2013-01-08T06:00:00.000Z","endDate":"2013-02-07T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2391,"demand":5.76},{"startDate":"2012-12-05T06:00:00.000Z","endDate":"2013-01-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2371,"demand":5.33},{"startDate":"2012-11-04T05:00:00.000Z","endDate":"2012-12-05T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1784,"demand":5.27},{"startDate":"2012-10-04T05:00:00.000Z","endDate":"2012-11-04T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1148,"demand":4.92},{"startDate":"2012-09-05T05:00:00.000Z","endDate":"2012-10-04T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1010,"demand":2.06},{"startDate":"2012-08-06T05:00:00.000Z","endDate":"2012-09-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1034,"demand":2.2},{"startDate":"2012-07-08T05:00:00.000Z","endDate":"2012-08-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1004,"demand":2.22},{"startDate":"2012-06-06T05:00:00.000Z","endDate":"2012-07-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1121,"demand":2.2},{"startDate":"2012-05-08T05:00:00.000Z","endDate":"2012-06-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1017,"demand":1.99},{"startDate":"2012-04-08T05:00:00.000Z","endDate":"2012-05-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1162,"demand":4.88},{"startDate":"2012-03-08T06:00:00.000Z","endDate":"2012-04-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1332,"demand":5.04},{"startDate":"2012-02-08T06:00:00.000Z","endDate":"2012-03-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1744,"demand":5.59},{"startDate":"2012-01-09T06:00:00.000Z","endDate":"2012-02-08T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2074,"demand":6.26},{"startDate":"2011-12-06T06:00:00.000Z","endDate":"2012-01-09T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":2173,"demand":6.26},{"startDate":"2011-11-03T05:00:00.000Z","endDate":"2011-12-06T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1493,"demand":4.82},{"startDate":"2011-10-05T05:00:00.000Z","endDate":"2011-11-03T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1178,"demand":4.88},{"startDate":"2011-09-06T05:00:00.000Z","endDate":"2011-10-05T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":998,"demand":1.92},{"startDate":"2011-08-07T05:00:00.000Z","endDate":"2011-09-06T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":951,"demand":1.83},{"startDate":"2011-07-07T05:00:00.000Z","endDate":"2011-08-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":967,"demand":2.1},{"startDate":"2011-06-07T05:00:00.000Z","endDate":"2011-07-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":939,"demand":2.12},{"startDate":"2011-05-08T05:00:00.000Z","endDate":"2011-06-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":921,"demand":1.73},{"startDate":"2011-04-07T05:00:00.000Z","endDate":"2011-05-08T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":926,"demand":1.53},{"startDate":"2011-03-09T06:00:00.000Z","endDate":"2011-04-07T05:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1292,"demand":4.74},{"startDate":"2011-02-08T06:00:00.000Z","endDate":"2011-03-09T06:00:00.000Z","rateCode":"EM2","rateClass":"GS","strata":"101","usage":1781,"demand":5.4}]}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment