Local Law 83 – FY 2020-2022 Historical Ethnic and Community Media Agency Ad Spend by Agency
NOTE: For annually updated, granular ad spend data, please visit Local Law 83 - City Agency Advertising Spend dataset. 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 here To see the agency spend for FY22 broken down by administration click here
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Feb 17, 2023
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Feb 17, 2023, 1:05 PM
- Rows in our copy
- 142
- Rows at the source
- 142
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 6 columns carry a concept; 6 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
fiscal_year | Fiscal Year | The Fiscal Year to which the agency data pertains | Not bound | Number | fiscal_year | numeric | — | |
agency_name | Agency Name | Name of the City agency or entity placing advertisements | Not bound | Text | agency_name | text | — | |
total_ad_spend | Total Ad Spend ($) | Total ad spend in dollars of both in-scope and out-of-scope media. This includes print, digital, broadcast (TV/Radio), including newspapers, magazines, journals, job boards, associations, etc. | Not bound | Number | total_ad_spend | numeric | — | |
ecm_spend_1 | ECM Spend ($) | Ad spend in dollars on Ethnic and Community Media (ECM) print, digital, tv and radio publications only, including newspapers, magazines and journals but excluding job boards, associations, broadcast, and social media | Not bound | Number | ecm_spend_1 | numeric | — | |
agency_acronym | Agency Acronym | Acronym of the City agency or entity placing advertisements | Not bound | Text | agency_acronym | text | — | |
ecm_spend | ECM Spend (%) | Ad spend on Ethnic and Community Media (ECM) print, digital, tv and radio publications as a proportion of the total ad spend on print, digital, tv and radio publications |
Download
This file was produced on Aug 25, 2026, 10:16 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/9tn4-3mgm
- Version
- Content hash:
f49672422811675892fd768c088a4b5d2ee3df64bb4d71f56c14f99279cb81a0 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Feb 17, 2023, 1:05 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 25, 2026, 2:45 PM | full_replace | success | 142 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.71 |