From a 500-row sample across 12 columns.
agency_nameagency_name| pub_date | agency_cd | rpt_sort | agency_name | lineno | lineno_dsc | yr1_fy | year1_frcst | year2_amt | year3_amt | year4_amt | year5_amt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20260630 | 011 | 11704 | President,Borough of the Bronx | 704 | Total Department | 2026 | 7286 | 7215 | 6547 | 6547 | 6547 |
| 20260630 | 014 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_date | integer | When data is made available for public review as legally required. | 0% | 201802012017012420200630 |
agency_cd | text | 3-digit code which identifies an agency (e.g. 056 is the Police Department). | 0% | 846126850 |
rpt_sort | integer | Sequence of report | 0% | 10272282072613704 |
agency_name | text | Descriptive name associated with the 3-digit code (e.g. "Mayoralty, Board of Elections, Law Department"). | 0% | City CouncilPublic Administrator - B… |
GET /api/datasets/e4p3-6ecr GET /api/datasets/e4p3-6ecr/quality GET /api/datasets/e4p3-6ecr/related GET /api/columns?dataset=e4p3-6ecr
agency_namepub_date| 14704 |
| President,Borough of S.I. |
| 704 |
| Total Department |
| 2026 |
| 5545 |
| 5248 |
| 4957 |
| 4957 |
| 4957 |
| 20260630 | 004 | 4704 | Campaign Finance Board | 704 | Total Department | 2026 | 102381 | 104409 | 14082 | 14099 | 14116 |
| 20260630 | 010 | 10704 | President,Borough of Manhattan | 704 | Total Department | 2026 | 6324 | 6079 | 5650 | 5650 | 5650 |
| 20260630 | 012 | 12704 | President,Borough of Brooklyn | 704 | Total Department | 2026 | 8121 | 7885 | 7009 | 7009 | 7009 |
| 20260630 | 013 | 13704 | President,Borough of Queens | 704 | Total Department | 2026 | 8159 | 6774 | 5922 | 5922 | 5922 |
| 20260630 | 002 | 2704 | Mayoralty | 704 | Total Department | 2026 | 187148 | 198938 | 194816 | 192240 | 192241 |
| 20260630 | 003 | 3704 | Board of Elections | 704 | Total Department | 2026 | 273814 | 212331 | 149873 | 149873 | 149873 |
| 20260630 | 008 | 8704 | Office of the Actuary | 704 | Total Department | 2026 | 7432 | 8484 | 8484 | 8484 | 8484 |
| 20260630 | 015 | 15704 | Office of the Comptroller | 704 | Total Department | 2026 | 130930 | 135705 | 136191 | 135997 | 136038 |
Citywide Pension Contrib…lineno | integer | — | 0% | 710727726 |
lineno_dsc | text | — | 0% | Federal - OtherOther CategoricalIntra-City Other |
yr1_fy | categorical | — | 0% | 202620202018of 11 |
year1_frcst | integer | — | 0% | 03-400000 |
year2_amt | integer | — | 0% | 03176 |
year3_amt | integer | — | 0% | 0555193 |
year4_amt | integer | — | 0% | 01110383 |
year5_amt | integer | — | 0% | 01665573 |