cityofnewyork-us/local-law-83-city-agency-advertising-spend-n56u-3hzv
Icon for Socrata external plugin
Open repository in Console
 
Readme
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="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.

 
Preview
  • local_law_83_city_agency_advertising_spend
     
     
     
     
     
Upstream Metadata