Vacant Positions Long

Human Resources provides daily reports of all vacant positions within the county. This dataset takes those daily reports, and appends (full joins) them to each other. The 'Report Date' column shows which days' report that record came from.

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 \"sharefulton-fultoncountyga-gov/vacant-positions-long-2b7m-4w5n\".\"vacant_positions_long\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.