3 ms·
Ryan Pitts on Twitter used this to build an API for UFO sightings in Washington state and the North West: https://twitter.com/ryanpitts/status/95372865194562764
by simonw 9y ago
Ryan Pitts on Twitter used this to build an API for UFO sightings in Washington state and the North West: https://twitter.com/ryanpitts/status/953728651945627648 https://twitter.com/ryanpitts/status/953728651945627648
Here's his datasette: https://datasette-cmwqbwgnqe.now.sh/csv-data-5284def/nuforc_reports_WA https://datasette-cmwqbwgnqe.now.sh/csv-data-5284def/nuforc_...
And here's an example SQL query showing the cities with the most UFO sightings: https://datasette-roborbllfq.now.sh/csv-data-b1429ef?sql=select+%22City%22%2C+count%28%2A%29+as+%22count%22+from+convertcsv++group+by+%22City%22+order+by+%22count%22+desc+limit+100 https://datasette-roborbllfq.now.sh/csv-data-b1429ef?sql=sel...