Identify reason for state aid difference

codeisland / ribudget_treemap

RI State Expenditure Data: Fiscal Year2009-2014

3 stars 2 forks source link

Identify reason for state aid difference #5

Open theryankelly opened 10 years ago

theryankelly commented 10 years ago

From Issue #3 @nelsonri72

There seems to be a difference of 11,503,084.66 between the tableau visual and balance dataset for category_code: 70 'Aid to Local Units of Government'.

1,131,689,158.99 (sum of balance dataset) 1,120,186,074.33 (tableau)

=11,503,084.66 DIFF

https://www.google.com/fusiontables/DataSource?snapid=S1428703movB http://www.ri.gov/opengovernment/

joealba commented 10 years ago

These two apps/visualizations share the same data source, but they are not updated at exactly the same time. There will definitely be some discrepancies.

nelsonri72 commented 10 years ago

If historical data has changed, I would think the Transparency portal should get in sync as well.

joealba commented 10 years ago

I have pushed updated json files with current data as of October 5.

nelsonri72 commented 10 years ago

JSON files match online to tableau. Again, why a difference between the original dataset and the json files?