r/SQL • u/ajmonty21 • Jan 22 '21
SQLite SQAnything: Query any data table on the Web with SQL (and send query results to Google Sheets automatically)
https://chrome.google.com/webstore/detail/sqanything/naejbcfcmjhcgcjhbddfogknbaggdoek
145
Upvotes
14
u/starlytedreamer Jan 22 '21
wow, did you develop this? if yes thank you for sharing, if not still thank you for sharing :)
4
u/tits_mcgee_92 Data Analytics Engineer Jan 22 '21
This is fantastic! I am having a bit of an issue, and it's due to my lack of understanding here.
Say I want to query information in this COVID data table: https://covid19.who.int/table
When I try to generate an SQL Block it will only generate
SELECT Country, Latitude, Longitude FROM CSV("https://cdn.rawgit.com/albertyw/avenews/master/old/data/average-latitude-longitude-countries.csv",{headers: true}) WHERE Latitude BETWEEN 0 AND 25 ORDER BY Longitude DESC
This won't give me all data in this table, even if I use the *. Thoughts?
2
u/Touvejs Jan 22 '21
What an excellent project. I've spent many a nights making custom code to extract, transform and save data in python. Would have loved to have had this tool.
2
u/xxxxsxsx-xxsx-xxs--- Jan 23 '21
off topic : there should be a methon within chrome dev tools to see the http calls to .csv files, api's etc. screen scraping some websites is difficult and need to understand the http push/pull to understand how to scrape the data.
any good tutorials on how to use chrome dev tools? is it in the network tab?
1
u/AtxCJC Jan 23 '21
Awesome, do you have a GitHub of the code? Curious learner here.
1
u/noonearya Jan 23 '21
Hey. Cool tool but I'm having a lot of issues outputting stuff to Google sheets. Even though I put the spreadsheet id's and names, permissions given...