CKAN Data Explorer - base component that allows you to pull in & explore data from any (DataStored) dataset in a CKAN instance

[rufuspollock]

CKAN Extension to create a Data Explorer dashboard.

Live at: /explorer

• Query select to pull in resources stored in the data store (or selected CSVs that were not via dataproxy??)
• Graph editor
• Then save to views system

[rufuspollock]

In progress at https://github.com/rgrp/ckan-explorer

[rufuspollock]

OK, now have sql querying support :-)

Key code is very simple: https://github.com/rgrp/ckan-explorer/blob/master/js/app.js#L88-L121

Here's a nice screenshot where i'm doing a group by to see the largest expenditure in the Adur District spending on demo.ckan.org ...

 SELECT "Supplier", SUM("Amount") FROM "04127ad5-77e5-4a08-9f40-12d3c383e460" GROUP BY ("Supplier") ORDER BY SUM("Amount") DESC;

[adamamyl]

does this support JOINs? (I've not seen a deviation from @yesthatjwz's "regexp quip" wrt JOINs, not regexp)

[rufuspollock]

@adamamyl I believe it does - i'll need to get some example data up to show it though ...

[davidread]

Great stuff!

[rufuspollock]

@adamamyl I have examples with JOINs - https://gist.github.com/rgrp/0b24589bd3293234917b