Citywide Marketing Directory

Local Law 83 of 2021 establishes a goal for City agencies to spend at least 50% of their print, digital, radio and TV advertising budgets with Ethnic and Community Media (ECM) outlets. This is a directory of approved ethnic and community media outlets with which spend counts positively towards the 50% spend goal outlined in LL83 of 2021

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 \"cityofnewyork-us/citywide-marketing-directory-gc4z-q69i\".\"citywide_marketing_directory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.