Aggregate Socrata Data By Month

(no tags)

    Algorithmia Platform License · Internet Access · Calls Other Algorithms

    Run an Example

    [
      [
        "2011-01-01 00:00:00",
        "2011-02-01 00:00:00",
        "2011-03-01 00:00:00",
        "2011-04-01 00:00:00",
        "2011-05-01 00:00:00",
        "2011-06-01 00:00:00",
        "2011-07-01 00:00:00",
        "2011-08-01 00:00:00",
        "2011-09-01 00:00:00",
        "2011-10-01 00:00:00",
        "2011-11-01 00:00:00",
        "2011-12-01 00:00:00",
        "2012-01-01 00:00:00",
        "2012-02-01 00:00:00",
        "2012-03-01 00:00:00",
        "2012-04-01 00:00:00",
        "2012-05-01 00:00:00",
        "2012-06-01 00:00:00",
        "2012-07-01 00:00:00",
        "2012-08-01 00:00:00",
        "2012-09-01 00:00:00",
        "2012-10-01 00:00:00",
        "2012-11-01 00:00:00",
        "2012-12-01 00:00:00",
        "2013-01-01 00:00:00",
        "2013-02-01 00:00:00",
        "2013-03-01 00:00:00",
        "2013-04-01 00:00:00",
        "2013-05-01 00:00:00",
        "2013-06-01 00:00:00",
        "2013-07-01 00:00:00",
        "2013-08-01 00:00:00",
        "2013-09-01 00:00:00",
        "2013-10-01 00:00:00",
        "2013-11-01 00:00:00",
        "2013-12-01 00:00:00",
        "2014-01-01 00:00:00",
        "2014-02-01 00:00:00",
        "2014-03-01 00:00:00",
        "2014-04-01 00:00:00",
        "2014-05-01 00:00:00",
        "2014-06-01 00:00:00",
        "2014-07-01 00:00:00",
        "2014-08-01 00:00:00",
        "2014-09-01 00:00:00",
        "2014-10-01 00:00:00",
        "2014-11-01 00:00:00",
        "2014-12-01 00:00:00",
        "2015-02-01 00:00:00",
        "2015-03-01 00:00:00",
        "2015-04-01 00:00:00",
        "2015-05-01 00:00:00",
        "2015-06-01 00:00:00",
        "2015-07-01 00:00:00",
        "2015-08-01 00:00:00",
        "2015-09-01 00:00:00",
        "2015-10-01 00:00:00",
        "2015-11-01 00:00:00"
      ],
      [
        773,
        585,
        648,
        481,
        480,
        712,
        2280,
        733,
        622,
        682,
        555,
        755,
        583,
        633,
        734,
        521,
        918,
        665,
        615,
        532,
        705,
        682,
        578,
        774,
        648,
        637,
        803,
        835,
        758,
        704,
        851,
        584,
        687,
        694,
        683,
        716,
        557,
        809,
        896,
        793,
        702,
        850,
        648,
        778,
        901,
        889,
        817,
        687,
        117,
        106,
        142,
        185,
        123,
        136,
        158,
        134,
        87,
        84
      ]
    ]

    Install & Use

    Use
    
    curl -X POST -d '{"url":"data://etl/socrata/Building_Permits_LasVegas.csv","colName": "PROJECT_ISSDTTM", "dateFormat": "%d/%m/%Y %I:%M:%S %p"}' -H 'Content-Type: application/json' -H 'Authorization: Simple YOUR_API_KEY' https://api.algorithmia.com/v1/algo/etl/AggregateSocrataDataByMonth/0.3.25