Icon for Socrata external plugin
Open repository in Console
Updated 7 months ago
Indexed 2 hours ago

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="">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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/local-law-83-city-agency-advertising-spend-n56u-3hzv\".\"local_law_83_city_agency_advertising_spend\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • local_law_83_city_agency_advertising_spend
Upstream Metadata