WARN

The Worker Adjustment and Retraining Notification (WARN) act requires companies with 50 or more employees to notify affected workers 60 days prior to closures and layoffs. WARN data includes the name of the employer, business location, number of affected workers, type (layoff or closure) and effective date of layoff or closure.

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 \"oregon-gov/warn-ijbz-jpx8\".\"warn\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.