[openspending-dev] Raw fact/dimension download

Stefan Urbanek stefan.urbanek at gmail.com
Sun Mar 24 13:16:43 UTC 2013


Hi Friedrich,

On 24.3.2013, at 13:53, Friedrich Lindenberg <friedrich.lindenberg at okfn.org> wrote:

> For what its worth, you can probably make the aggregator API spit out the fact tables by drilling down over "id" and all the dimension names with _id attached - not sure how well that works. As for the dimensions, there's an endpoint at http://openspending.org/de-bund/funktion.distinct.json (no CSV, sorry). 
> 

Thanks. Json is fine. Is that distinct of all dimension values or only values that are relevant to the facts within the cube?

s.

> - Friedrich 
> 
> 
> On Sun, Mar 24, 2013 at 1:34 PM, Tryggvi Björgvinsson <tryggvi.bjorgvinsson at okfn.org> wrote:
> On fös 22.mar 2013 09:51, Stefan Urbanek wrote:
> > Is there a way how can I get raw fact/dimension tables in CSV from openspending.org, not just denormalized dataset?
> 
> Hi Stefan :-)
> 
> I don't think we have that option available, sorry. We're focused on
> understanding the data so it doesn't make sense to expose our OLAP cube.
> 
> I don't think exposing the tables is going to be on our agenda. Is this
> a feature you require?
> 
> /Tryggvi
> 
> 
> 
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending-dev
> 
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending-dev

Stefan Urbanek
data analyst and data brewmaster

Twitter: @Stiivi
Home: http://stiivi.com
Brewery: http://databrewery.org
Github: https://github.com/Stiivi





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20130324/56fbf9a2/attachment.html>


More information about the openspending-dev mailing list