Local Law 83 - City Agency Advertising Spend

Per Local Law 83 of 2021, the Mayor's Office of Ethnic and Community Media is required to report annually on each agency's full advertising spend across all media categories, including ethnic and community (ECM), mainstream, out-of-home, social media, etc. This dataset reflects the raw data that MOECM received from City Agencies on their annual advertising spend.

For more information, please visit the <a href="https://www.nyc.gov/site/ethnicmedia/index.page">MOECM website</a>.

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/local-law-83-city-agency-advertising-spend-n56u-3hzv\".\"local_law_83_city_agency_advertising_spend\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.