From a 142-row sample across 6 columns.
agency_nameagency_name| fiscal_year | agency_name | agency_acronym | ecm_spend_1 | total_ad_spend |
|---|---|---|---|---|
| 2022 | Department of City Planning | DCP | 4087.62 | 32322.54 |
| 2022 | Department of Environmental Protection | DEP | 391.60 | 101710.21 |
| 2022 | New York City Civilian Complaint Review Board | CCRB | 18745.95 | 242753.46 |
| 2022 | Campaign Finance Board |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
fiscal_year | categorical | The Fiscal Year to which the agency data pertains | 0% | 202020222021of 3 |
agency_name | text | Name of the City agency or entity placing advertisements | 0% | Department of CorrectionDepartment of FinanceDepartment of Education |
agency_acronym | text | Acronym of the City agency or entity placing advertisements | 0% | DOICCHRDOHMH |
ecm_spend | float | 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 | 45% |
GET /api/datasets/9tn4-3mgm GET /api/datasets/9tn4-3mgm/quality GET /api/datasets/9tn4-3mgm/related GET /api/columns?dataset=9tn4-3mgm
agency_nameagency_name| CFB |
| 103750.27 |
| 994440.52 |
| 2022 | Department of Consumer and Worker Protection | DCWP | 222528.53 | 1022941.01 |
| 2022 | Department of Design and Construction | DDC | 1602.00 | 80122.70 |
| 2022 | Administration for Children’s Services | ACS | 65377.02 | 1936089.12 |
| 2022 | New York City Commission on Human Rights | CCHR | 34082.90 | 124506.06 |
| 2022 | Civic Engagement Commission | CEC | 368842.24 | 751015.73 |
| 2022 | Department for the Aging | DFTA | 316234.70 | 768733.79 |
1.000.2680.892 |
ecm_spend_1 | float | 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 | 0% | 0.003725.64154659.31 |
total_ad_spend | float | 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. | 0% | 0.003725.6418647.96 |