From a 65-row sample across 4 columns.
| year | new_york_city_population | nyc_consumption_million_gallons_per_day | per_capita_gallons_per_person_per_day |
|---|---|---|---|
| 2024 | 8478000 | 1002.0 | 118.19 |
| 2023 | 8391000 | 997.0 | 118.82 |
| 2022 | 8356000 | 999 | 119.55 |
| 2021 | 8454000 | 979.0 | 115.80 |
| 2020 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
year | text | — | 0% | 197819712024 |
new_york_city_population | integer | — | 0% | 734247673356507861489 |
nyc_consumption_million_gallons_per_day | float | — | 0% | 1423.81002.01189.2 |
per_capita_gallons_per_person_per_day | float | — | 15% | 212.95177.35182.26 |
GET /api/datasets/ia2d-e54m GET /api/datasets/ia2d-e54m/quality GET /api/datasets/ia2d-e54m/related GET /api/columns?dataset=ia2d-e54m
| 8804190 |
| 981.0 |
| 111.42 |
| 2019 | 8824751 | 987.4 | 111.89 |
| 2018 | 8826377 | 1008.0 | 114.20 |
| 2017 | 8815395 | 990.2 | 112.33 |
| 2016 | 8794592 | 1002.0 | 113.93 |
| 2015 | 8736590 | 1009.0 | 115.49 |