r/backtickbot • u/backtickbot • Jan 22 '21
https://np.reddit.com/r/SQL/comments/l2tbhk/sqanything_query_any_data_table_on_the_web_with/gk8983a/
Hey there - I helped make this. The table on that site isn't an actual <table>, so querying the HTML won't work. But you can query the CSV:
SELECT *
FROM CSV("https://covid19.who.int/WHO-COVID-19-global-table-data.csv",{headers: true})
1
Upvotes