Local Law 83 – FY 2020-2022 Historical Ethnic and Community Media Agency Ad Spend by Agency

<b>NOTE</b>: For annually updated, granular ad spend data, please visit <a href="https://data.cityofnewyork.us/City-Government/Local-Law-83-City-Agency-Advertising-Spend/n56u-3hzv">Local Law 83 - City Agency Advertising Spend dataset</a>.

Fiscal Year 2022 spans over two administrations. The first half of the fiscal year (FY22, Q1 and Q2) was per Executive Order 47. The second half of the fiscal year (FY22, Q3 and Q4) was per Local Law 83.

To learn more about the differentiation and review the FY2022 annual report click <a href="https://www.nyc.gov/assets/ethnicmedia/downloads/pdf/MOECM_FY22_Report.pdf">here</a>

To see the agency spend for FY22 broken down by administration click

<a href="https://www.nyc.gov/assets/ethnicmedia/downloads/pdf/MOECM_FY2022_Dashboard.pdf">here</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-fy-20202022-historical-ethnic-and-9tn4-3mgm\".\"local_law_83_fy_20202022_historical_ethnic_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.