From a 63-row sample across 38 columns.
| agency_capital_expenditures_by_purpose | fy_2020 | fy_2019 | fy_2018 | fy_2017 | fy_2016 | fy_2015 | fy_2014 | fy_2013 | fy_2012 | fy_2011 | fy_2010 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Environmental Protection and Sanitation | 1845932787 | 1991755815 | 1,687,882,725 | 1,453,949,135 | 1,378,234,234 | 1,373,488,401 | 1,577,802,893 | 1843947453 | 2405599562 | 2824135363 | 2625317710 |
| Environmental Protection and Sanitation |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
agency_capital_expenditures_by_purpose | text | — | 0% | Dept. of Citywide Admini…Department of Transporta…Environmental Protection… |
category | text | — | 65% | EquipmentWNYCFerries and Airports |
fy_2020 | integer | — | 3% | 041176652503459491 |
fy_2019 | integer | — | 3% | 0144378843198679306 |
GET /api/datasets/hukm-snmq GET /api/datasets/hukm-snmq/quality GET /api/datasets/hukm-snmq/related GET /api/columns?dataset=hukm-snmq
| 1066265296 |
| 1034894687 |
| 844,046,079 |
| 831,878,907 |
| 767,563,124 |
| 687,002,478 |
| 803,228,494 |
| 953371696 |
| 1195170589 |
| 1303130966 |
| 1041023183 |
| Environmental Protection and Sanitation | 726443381 | 891027669 | 778,809,329 | 554,826,868 | 554,822,821 | 605,262,585 | 708,042,689 | 798383306 | 1041481264 | 1280909413 | 1414683775 |
| Environmental Protection and Sanitation | 53224110 | 65833459 | 65,027,317 | 67,243,360 | 55,848,289 | 81,223,338 | 66,531,710 | 92192451 | 168947709 | 240094984 | 169610752 |
| Department of Sanitation | 202387874 | 242846124 | 289,520,243 | 323,733,327 | 323,648,936 | 246,353,554 | 264,052,262 | 352634675 | 322431663 | 233743208 | 346829234 |
| Department of Sanitation | 131518334 | 170257950 | 151,393,589 | 150,146,378 | 155,926,759 | 109,332,035 | 77,706,888 | 128573756 | 108907654 | 60584167 | 147609184 |
| Department of Sanitation | 41176652 | 41167181 | 42,131,402 | 22,723,297 | 35,616,488 | 62,270,948 | 86,658,121 | 101736739 | 89711756 | 66610153 | 157578759 |
| Department of Sanitation | 29692888 | 31420993 | 95,995,252 | 150,863,652 | 132,105,689 | 74,750,571 | 99,687,253 | 122324180 | 123812253 | 106548888 | 41641291 |
| TOTAL ENVIRONMENTAL PROTECTION AND SANITATION | 2048320661 | 2234601939 | 1,977,402,968 | 1,777,682,462 | 1,701,883,170 | 1,619,841,955 | 1,841,855,155 | 2196582128 | 2728031225 | 3057878571 | 2972146944 |
| Education | — | — | — | — | — | — | — | — | — | — | — |
Showing 12 of 38 columns. All of them are listed below.
fy_2018 |
| text |
| — |
| 3% |
- 0532,215,025743,173 |
fy_2017 | text | — | 3% | - 0242,795,314543,281,116 |
fy_2016 | text | — | 3% | - 03,167,2811,262,684,609 |
fy_2015 | text | — | 3% | - 056,370,138167,744,256 |
fy_2014 | text | — | 3% | - 0219,807,99032,131,674 |
fy_2013 | integer | — | 3% | 0479681286065610 |
fy_2012 | integer | — | 3% | 077596151348759824 |
fy_2011 | integer | — | 3% | 01602080347158830 |
fy_2010 | integer | — | 3% | 0115550373412398115 |
fy_2009 | integer | — | 3% | 0717366434105516888 |
fy_2008 | integer | — | 3% | 012510396541953552 |
fy_2007 | integer | — | 3% | 070368216206533030 |
fy_2006 | integer | — | 3% | 0782904022246351350 |
fy_2005 | integer | — | 3% | 065236348158826056 |
fy_2004 | integer | — | 3% | 06188147711361954 |
fy_2003 | integer | — | 3% | 0115049047146624946 |
fy_2002 | integer | — | 3% | 0396594496110271244 |
fy_2001 | integer | — | 3% | 0290092707206587313 |
fy_2000 | integer | — | 3% | 0122195459634768910 |
fy_1999 | integer | — | 3% | 0528759053798819 |
fy_1998 | integer | — | 3% | 0526146716342323 |
fy_1997 | integer | — | 3% | 01601066368059711 |
fy_1996 | integer | — | 3% | 013122105627507476 |
fy_1995 | integer | — | 3% | 0289034113874741000 |
fy_1994 | integer | — | 3% | 0129613655218879227 |
fy_1993 | integer | — | 3% | 022896666549581431 |
fy_1992 | integer | — | 3% | 052401947189704888 |
fy_1991 | integer | — | 3% | 062296694290142489 |
fy_1990 | integer | — | 3% | 026899619289731016 |
fy_1989 | integer | — | 3% | 019252765166490796 |
fy_1988 | integer | — | 3% | 03142889972049724 |
fy_1987 | integer | — | 3% | 011172626014788328 |
fy_1986 | integer | — | 3% | 07680036105927866 |
fy_1985 | integer | — | 3% | 0647222891951484 |