Experiment with different data environments
HeavyIQ Demos
Tweets
Explore United States tweets from January 2020 through April 2021. Notable events from this time period include the US Elections, Hurricane Laura, Ruth Bader Ginsburg’s death, Covid, Meme stocks and the Crypto Craze.
Example Prompts
Top 10 states for the number of tweets per capita excluding District of Columbia
Percentage of tweets mentioning "y'all" or "yall" per state
Number of mentions of bitcoin per day on Twitter and the daily high price of bitcoin
6 Tables
395M Rows
166 Columns
Federal Aviation Administration Flights
Demo includes 35 years of United States Federal Aviation Administration flight data from 1987-2023. Some areas you can explore include changes in air traffic, delays, cancellations, routes, airports, aircraft, flight distance, and flight times.
Example Prompts
Percentage of flights canceled for weather related reasons by month of year and hour of day
Number of seats on departing flights per capita per state in 2023
Distinct routes flown by Virgin America in 2016 which were NOT flown by Alaska Airlines in 2023
4 Tables
217M Rows
131 Columns
Flights - Automatic Dependent Surveillance - Broadcast (ADS-B) Data
Demo includes over 1B flight records from February 19 - March 1, 2022. These are the days just before and into the Ukraine - Russia conflict. You can explore flight paths of aircraft with a prompt which starts with “Show the location of . . .” along with exploring other data like aircraft altitude and speed.
Example Prompts
Show a histogram of number of records by altitude (bins of 1,000 feet between 0 and 60,000 feet) and speed (bins of 10 knots between 0 and 700 knots)
Show the location of all Ryanair flights over Ireland, France, United Kingdom, and Spain on February 22, 2022
Return the average speed of aircraft by their decade of manufacture, in order of decade, from 1930 through 2023
3 Tables
1B Rows
172 Columns
