Canada launches spending database without transactional spending data?

[Michael Mulley]

(Hi Anders -- am forwarding this to CivicAccess, a Canadian open-data list)

On Thu, Apr 25, 2013 at 5:28 PM, Anders Pedersen <[hidden email]> wrote:

Hi all, 

(sorry for crossposting)

The Canadian Treasury board this week launched a database on expenditure [1], which received quite a bit of coverage [2]. 

As far as I can tell, the database does not include any transactional spending data [3], but only expenditure data across programmes, sub-programmes etc.

I'd be interested to hear if anyone can help shed some light on this and possibly share the reactions from the Canadian open data community? 

Thanks, 

Anders

[1] http://www.tbs-sct.gc.ca/ems-sgd/aegc-adgc-eng.asp

[2] http://globalnews.ca/news/502224/new-database-will-allow-canadians-to-track-government-spending-data/

[3] As for instance released in the UK at http://data.gov.uk/openspending and US at usaspending.gov

-- 

Anders Pedersen
Community Coordinator
OpenSpending
Open Knowledge Foundation
Twitter: @anpe
Skype: anpehej

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Ted Strauss]

Hi all,

I set up a data browser for the recently released expenditure database.

Access it here -- http://spenditures.ca

This is high level budget data. It doesn't include transactions, to answer Anders' question.
Some budget items are in the 10s of billions, so you could say it's lacking in detail.

Nonetheless, if you want a big picture of what the government is spending money on, this page can help.

Ted

On Thu, Apr 25, 2013 at 5:58 PM, Michael Mulley <[hidden email]> wrote:

(Hi Anders -- am forwarding this to CivicAccess, a Canadian open-data list)

On Thu, Apr 25, 2013 at 5:28 PM, Anders Pedersen <[hidden email]> wrote:

Hi all, 

(sorry for crossposting)

The Canadian Treasury board this week launched a database on expenditure [1], which received quite a bit of coverage [2]. 

As far as I can tell, the database does not include any transactional spending data [3], but only expenditure data across programmes, sub-programmes etc.

I'd be interested to hear if anyone can help shed some light on this and possibly share the reactions from the Canadian open data community? 

Thanks, 

Anders

[1] http://www.tbs-sct.gc.ca/ems-sgd/aegc-adgc-eng.asp

[2] http://globalnews.ca/news/502224/new-database-will-allow-canadians-to-track-government-spending-data/

[3] As for instance released in the UK at http://data.gov.uk/openspending and US at usaspending.gov

-- 

Anders Pedersen
Community Coordinator
OpenSpending
Open Knowledge Foundation
Twitter: @anpe
Skype: anpehej

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[James McKinney-2]

Cool, Ted! Would it be possible to add the data to OpenSpending? http://openspending.org/help/data-loading.html It should be straight-forward, and then you immediately benefit from all their visualizations, etc.

I'm curious to know which budgets didn't spend as much as allocated. It seems like in most cases, those values are equal.

James

On 2013-05-30, at 10:56 AM, Ted Strauss wrote:

Hi all,

I set up a data browser for the recently released expenditure database.

Access it here -- http://spenditures.ca

This is high level budget data. It doesn't include transactions, to answer Anders' question.
Some budget items are in the 10s of billions, so you could say it's lacking in detail.

Nonetheless, if you want a big picture of what the government is spending money on, this page can help.

Ted

On Thu, Apr 25, 2013 at 5:58 PM, Michael Mulley <[hidden email]> wrote:

(Hi Anders -- am forwarding this to CivicAccess, a Canadian open-data list)

On Thu, Apr 25, 2013 at 5:28 PM, Anders Pedersen <[hidden email]> wrote:

Hi all, 

(sorry for crossposting)

The Canadian Treasury board this week launched a database on expenditure [1], which received quite a bit of coverage [2]. 

As far as I can tell, the database does not include any transactional spending data [3], but only expenditure data across programmes, sub-programmes etc.

I'd be interested to hear if anyone can help shed some light on this and possibly share the reactions from the Canadian open data community? 

Thanks, 

Anders

[1] http://www.tbs-sct.gc.ca/ems-sgd/aegc-adgc-eng.asp

[2] http://globalnews.ca/news/502224/new-database-will-allow-canadians-to-track-government-spending-data/

[3] As for instance released in the UK at http://data.gov.uk/openspending and US at usaspending.gov

-- 

Anders Pedersen
Community Coordinator
OpenSpending
Open Knowledge Foundation
Twitter: @anpe
Skype: anpehej

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Ted Strauss]

On Thu, May 30, 2013 at 1:21 PM, James McKinney <[hidden email]> wrote:

Cool, Ted! Would it be possible to add the data to OpenSpending? http://openspending.org/help/data-loading.html It should be straight-forward, and then you immediately benefit from all their visualizations, etc.

Yes that should be pretty easy. I've converted 1 of 3 excel files to csv, so I can import that one and see how it goes.

 

I'm curious to know which budgets didn't spend as much as allocated. It seems like in most cases, those values are equal.

There are many exceptions to that rule you can find. Adding a feature that treats the difference between allocation and spending as a filterable quantity would be a good. Let me know of any other ideas or questions that come to mind.

 

James

On 2013-05-30, at 10:56 AM, Ted Strauss wrote:

Hi all,

I set up a data browser for the recently released expenditure database.

Access it here -- http://spenditures.ca

This is high level budget data. It doesn't include transactions, to answer Anders' question.
Some budget items are in the 10s of billions, so you could say it's lacking in detail.

Nonetheless, if you want a big picture of what the government is spending money on, this page can help.

Ted

On Thu, Apr 25, 2013 at 5:58 PM, Michael Mulley <[hidden email]> wrote:

(Hi Anders -- am forwarding this to CivicAccess, a Canadian open-data list)

On Thu, Apr 25, 2013 at 5:28 PM, Anders Pedersen <[hidden email]> wrote:

Hi all, 

(sorry for crossposting)

The Canadian Treasury board this week launched a database on expenditure [1], which received quite a bit of coverage [2]. 

As far as I can tell, the database does not include any transactional spending data [3], but only expenditure data across programmes, sub-programmes etc.

I'd be interested to hear if anyone can help shed some light on this and possibly share the reactions from the Canadian open data community? 

Thanks, 

Anders

[1] http://www.tbs-sct.gc.ca/ems-sgd/aegc-adgc-eng.asp

[2] http://globalnews.ca/news/502224/new-database-will-allow-canadians-to-track-government-spending-data/

[3] As for instance released in the UK at http://data.gov.uk/openspending and US at usaspending.gov

-- 

Anders Pedersen
Community Coordinator
OpenSpending
Open Knowledge Foundation
Twitter: @anpe
Skype: anpehej

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss