From a 500-row sample across 11 columns.
line_numberyear_4_estimateyear_3_estimate+8agency_namepublication_dateagency_nameagency_number| publication_date | agency_number | report_sort | agency_name | line_number | line_number_description | fiscal_year_1 | year_1_forecast | year_2_estimate | year_3_estimate | year_4_estimate |
|---|---|---|---|---|---|---|---|---|---|---|
| 20161117 | 002 | 2704 | Mayoralty | 704 | 704 Total Department | 2017 | 136644 | 138424 | 136603 | 132522 |
| 20161117 | 002 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
publication_date | categorical | — | 0% | 202511172023111620241120of 10 |
agency_number | text | — | 0% | 132992126 |
report_sort | integer | — | 0% | 3872690671195710 |
agency_name | text | — | 0% | Citywide Pension Contrib…Public Administrator - B…City Council |
GET /api/datasets/sqmu-2ixd GET /api/datasets/sqmu-2ixd/quality GET /api/datasets/sqmu-2ixd/related GET /api/columns?dataset=sqmu-2ixd
agency_name| 2705 |
| Mayoralty |
| 705 |
| 705 Salaries and Wages |
| 2017 |
| 104380 |
| 101670 |
| 101126 |
| 100130 |
| 20161117 | 002 | 2706 | Mayoralty | 706 | 706 Fringe Benefits | 2017 | 272 | 176 | 176 | 176 |
| 20161117 | 002 | 2707 | Mayoralty | 707 | 707 Total Personal Service | 2017 | 104652 | 101846 | 101302 | 100306 |
| 20161117 | 002 | 2708 | Mayoralty | 708 | 708 City Funds | 2017 | 75925 | 78279 | 78449 | 77453 |
| 20161117 | 002 | 2709 | Mayoralty | 709 | 709 Other Categorical | 2017 | 4746 | 4462 | 4436 | 4436 |
| 20161117 | 002 | 2710 | Mayoralty | 710 | 710 Capital Funds-I.F.A. | 2017 | 11993 | 12131 | 12131 | 12131 |
| 20161117 | 002 | 2711 | Mayoralty | 711 | 711 State | 2017 | 279 | 273 | 273 | 273 |
| 20161117 | 002 | 2713 | Mayoralty | 713 | 713 Federal - C.D. | 2017 | 6268 | 3321 | 3328 | 3328 |
| 20161117 | 002 | 2714 | Mayoralty | 714 | 714 Federal - Other | 2017 | 3185 | 1114 | 419 | 419 |
line_number| integer |
| — |
| 0% |
707727726 |
line_number_description | text | — | 0% | Intra-City OtherStateOther Categorical |
fiscal_year_1 | categorical | — | 0% | 202120182025of 8 |
year_1_forecast | integer | — | 0% | 03176 |
year_2_estimate | integer | — | 0% | 0355519 |
year_3_estimate | integer | — | 0% | 01110381000000 |
year_4_estimate | integer | — | 0% | 01665571000000 |