From a 500-row sample across 12 columns.
:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+1:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+1Mappable — Socrata point column `latitude_longitude`.
Open on the map →| datasourceid | startofperiod | endofperiod | locationlatitude | locationlongitude | latitude_longitude | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q | :@computed_region_sbqj_enih | :@computed_region_92fq_4b7q | pm2_5concmass1hourmean_value | pm2_5concmassnowcastusepaaqi_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DIEKK1968 | 2024-06-07T15:00:00.000 | 2024-06-07T16:00:00.000 | 40.7183372 | -73.9129452 | 40.71834, -73.91295 | 54 | 3 | 62 | 34 | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
datasourceid | categorical | Unique ID for each sensor | 0% | DIHWV8825DPMQV6353DQMQL2197of 11 |
startofperiod | datetime | Start date of data collection | 0% | 2024-06-27T15:00:00.0002024-06-27T16:00:00.0002024-11-14T03:00:00.000 |
endofperiod | datetime | End date of data collection | 0% | 2024-06-27T17:00:00.0002024-06-27T16:00:00.0002024-11-14T03:00:00.000 |
locationlatitude | categorical | Latitude information for each sensor | 0% |
GET /api/datasets/2juy-aj8e GET /api/datasets/2juy-aj8e/quality GET /api/datasets/2juy-aj8e/related GET /api/columns?dataset=2juy-aj8e
:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+1:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+1| — |
| DQKFP7639 | 2024-03-06T22:00:00.000 | 2024-03-06T23:00:00.000 | 40.7180035 | -73.9127685 | 40.71800, -73.91277 | 54 | 3 | 62 | 34 | 7.28 | 53 |
| DQKFP7639 | 2024-06-24T09:00:00.000 | 2024-06-24T10:00:00.000 | 40.7180035 | -73.9127685 | 40.71800, -73.91277 | 54 | 3 | 62 | 34 | 7.68 | 48 |
| DQKFP7639 | 2024-05-22T11:00:00.000 | 2024-05-22T12:00:00.000 | 40.7180035 | -73.9127685 | 40.71800, -73.91277 | 54 | 3 | 62 | 34 | 13.41 | 56 |
| DIEKK1968 | 2024-04-17T09:00:00.000 | 2024-04-17T10:00:00.000 | 40.7183372 | -73.9129452 | 40.71834, -73.91295 | 54 | 3 | 62 | 34 | 10.12 | 52 |
| DPMQV6353 | 2024-04-24T17:00:00.000 | 2024-04-24T18:00:00.000 | 40.7183372 | -73.9129452 | 40.71834, -73.91295 | 54 | 3 | 62 | 34 | 5.93 | 44 |
| DJMXN5907 | 2024-07-13T19:00:00.000 | 2024-07-13T20:00:00.000 | 40.7178635 | -73.9136875 | 40.71786, -73.91369 | 54 | 3 | 62 | 34 | 6.35 | 34 |
| DQMQL2197 | 2024-04-10T15:00:00.000 | 2024-04-10T16:00:00.000 | 40.71825 | -73.9126263 | 40.71825, -73.91263 | 54 | 3 | 62 | 34 | 11.71 | 54 |
| DVYII6440 | 2024-06-04T18:00:00.000 | 2024-06-04T19:00:00.000 | 40.7172084 | -73.9133307 | 40.71721, -73.91333 | 54 | 3 | 62 | 34 | 13.29 | 63 |
| DQKFP7639 | 2024-06-24T23:00:00.000 | 2024-06-25T00:00:00.000 | 40.7180035 | -73.9127685 | 40.71800, -73.91277 | 54 | 3 | 62 | 34 | 11.5 | 52 |
40.718337240.7182540.7182022of 11locationlongitude | categorical | Longitude information for each sensor | 0% | -73.9129452-73.9127712-73.9126263of 12 |
pm2_5concmass1hourmean_value | float | The hourly average measurements of PM 2.5 for the indicated sensor | 1% | 4.745.55.4 |
pm2_5concmassnowcastusepaaqi_1 | integer | The Environmental Protection Agency (EPA) NowCast calculated Air Quality Index(AQI) calculation, processed from PM 2.5 data, for the indicated sensor | 1% | 523132 |
latitude_longitude | coordinate | The latitutude and longitude of each sensor | 0% | {'coordinates': [-73.912…{'coordinates': [-73.912…{'coordinates': [-73.912…of 12 |