2 ms·
If you want to run GraphQL queries against this kind of data I have a roundabout way of doing it: 1. Set up a repo that uses actions to scrape data into a CSV
by simonw 6y ago
If you want to run GraphQL queries against this kind of data I have a roundabout way of doing it:
1. Set up a repo that uses actions to scrape data into a CSV
2. Set up another action that converts that CSV to SQLite (using my sqlite-utils tool) and then...
3. Publishes that database to Cloud Run or Vercel with Datasette and with the datasette-graphql plugin
Here's an example repo that does exactly that: https://github.com/simonw/cdc-vaccination-history https://github.com/simonw/cdc-vaccination-history
It scrapes vaccination data from the CDC, complies that into a SQLite database and publishes it using Datasette on Vercel at https://cdc-vaccination-history.datasette.io/ https://cdc-vaccination-history.datasette.io/
Then you can run GraphQL queries at https://cdc-vaccination-history.datasette.io/graphql https://cdc-vaccination-history.datasette.io/graphql
(Here's the plugin: https://datasette.io/plugins/datasette-graphql https://datasette.io/plugins/datasette-graphql)
Another demo: https://covid-19.datasettes.com/graphql https://covid-19.datasettes.com/graphql runs from this repo: https://github.com/simonw/covid-19-datasette https://github.com/simonw/covid-19-datasette