W3C home > Mailing lists > Public > public-lod@w3.org > March 2020

Re: COVID-19 Open Research Dataset

From: Juan Sequeda <juanfederico@gmail.com>
Date: Fri, 27 Mar 2020 09:45:19 -0500
Message-ID: <CAMVTWDxbGMGjB0_HNW4R3vDgJXgd7az_LsYqd7mYVZwg_qstGA@mail.gmail.com>
To: Kingsley Idehen <kidehen@openlinksw.com>
Cc: public-lod public <public-lod@w3.org>
On Fri, Mar 27, 2020 at 8:20 AM Kingsley Idehen <kidehen@openlinksw.com>
wrote:

> On 3/26/20 7:07 PM, Juan Sequeda wrote:
>
> All,
>
> Tableau has published COVID-19 data [1] which is being hosted on
> data.world [2]. This data can be queried directly in SQL... and also in
> SPARQL! The CSV data is represented in CSVW.
>
> There are plenty of other datasets on data.world too.
>
>
>
>
> [1] https://data.world/covid-19-data-resource-hub/covid-19-case-counts
> [2] https://data.world/covid-19-data-resource-hub/covid-19-case-counts
>
> Hi Juan,
>
> Great!
>
> BTW -- What's the change-sensitivity level of this data?
>

The Tableau folks are maintaining this.

> Can SQL happen over HTTP, just like it does re Google Spreadsheets?
>
Here's an example using cURL re a Google Spreadsheet URL that returns CSV
> and also includes an encoded SQL Query Text parameter:
>
> curl -I
> "https://docs.google.com/spreadsheets/d/1Z0csxYkWFuvNpfaGQDKnhqdREHcwYbvd3s7vHsWsT5Q/gviz/tq?tqx=out:csv&sheet=US_State_Tracker_To_Date&tq=select%20A%2C%20B%2CC%2CL%2CM%2CN"
> <https://docs.google.com/spreadsheets/d/1Z0csxYkWFuvNpfaGQDKnhqdREHcwYbvd3s7vHsWsT5Q/gviz/tq?tqx=out:csv&sheet=US_State_Tracker_To_Date&tq=select%20A%2C%20B%2CC%2CL%2CM%2CN>
>

yes. See:
https://apidocs.data.world/toolkit/api/api-endpoints/queries/sqlget

> Likewise, is there a URL-pattern for SPARQL?
>

Yes. See:
https://apidocs.data.world/toolkit/api/api-endpoints/queries/sparqlget

>
> --
> Regards,
>
> Kingsley Idehen	
> Founder & CEO
> OpenLink Software
> Home Page: http://www.openlinksw.com
> Community Support: https://community.openlinksw.com
> Weblogs (Blogs):
> Company Blog: https://medium.com/openlink-software-blog
> Virtuoso Blog: https://medium.com/virtuoso-blog
> Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers
>
> Personal Weblogs (Blogs):
> Medium Blog: https://medium.com/@kidehen
> Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/
>               http://kidehen.blogspot.com
>
> Profile Pages:
> Pinterest: https://www.pinterest.com/kidehen/
> Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
> Twitter: https://twitter.com/kidehen
> Google+: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn: http://www.linkedin.com/in/kidehen
>
> Web Identities (WebID):
> Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
>         : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
>
>
Received on Friday, 27 March 2020 14:45:46 UTC

This archive was generated by hypermail 2.4.0 : Friday, 27 March 2020 14:45:48 UTC