Commercial Aviation Departures and TSA Screenings (simplified)

The number of Persons Screened by TSA, US Domestic Flight Departures, and US International Flight Departures by day from January 1, 2019 forward. Bonus columns for filtering include Week Number and Year.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bts-gov/commercial-aviation-departures-and-tsa-screenings-hvq3-38u5\".\"commercial_aviation_departures_and_tsa_screenings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.