Special Programs

This dataset provides data from the City of Norfolk’s special programs tracking system. Special program issues originate from inspections conducted by the Department of Neighborhood Services and the Department of City Planning. The goal of pursuing compliance with special programs is to strengthen neighborhood standards and improve property health and safety. Types of special programs may include property issues such emergency demolitions, fire department red tags, vacant building registration, Virginia Natural Gas red tags, short-term rentals, new auto establishments, and others. This dataset will contain a rolling three years of data and will be updated daily.

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 \"norfolk-gov/special-programs-7fk7-nqxm\".\"special_programs\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.