From a 432-row sample across 7 columns.
borough_idgeo_area_nametime_period+2| geo_type | geo_area_id | geo_area_name | borough_id | time_period | children_tested_for_lead | children_tested_for_lead_2 |
|---|---|---|---|---|---|---|
| Borough | 1 | Bronx | 1 | 2008 | 17500 | 86 |
| Borough | 1 | Bronx | 1 | 2009 | 18000 | 87 |
| Borough | 1 | Bronx | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
geo_type | categorical | The type of geographic aggregation for the data; this could range from Citywide to Neighborhood Tabulation Areas in NYC. | 0% | Neighborhood (UHF 42)BoroughCitywideof 3 |
geo_area_id | integer | An ID for the geographic neighborhood of a given geography type | 0% | 13074 |
geo_area_name | text | The neighborhood name for the geographic division | 0% | Bayside - Little NeckDowntown - Heights - Slo…East New York |
borough_id | categorical | An ID for the NYC borough that the neighborhood falls within | 0% |
GET /api/datasets/fzh2-sxib GET /api/datasets/fzh2-sxib/quality GET /api/datasets/fzh2-sxib/related GET /api/columns?dataset=fzh2-sxib
| 2010 |
| 17700 |
| 87 |
| Borough | 1 | Bronx | 1 | 2011 | 19400 | 88 |
| Borough | 1 | Bronx | 1 | 2012 | 19000 | 87 |
| Borough | 1 | Bronx | 1 | 2013 | 18500 | 87 |
| Borough | 1 | Bronx | 1 | 2014 | 17800 | 87 |
| Borough | 1 | Bronx | 1 | 2015 | 17300 | 86 |
| Borough | 1 | Bronx | 1 | 2016 | 17100 | 86 |
| Borough | 2 | Brooklyn | 2 | 2008 | 29700 | 78 |
243of 6time_period | categorical | The time period for which the data is aggregated; value could be a year, quarter, seasonal or multi-year | 0% | 201220132014of 9 |
children_tested_for_lead | integer | Number of children born in New York City to New York City resident mothers tested for lead poisoning before the age of three years. To identify children tested for lead poisoning, birth records for all children born in a given year in New York City to New York City resident mothers were matched to children tested for lead poisoning in the New York City Childhood Lead Registry. <a href="http://a816-dohbesp.nyc.gov/IndicatorPublic/EPHTPDF/Childhood_Lead_Exposure_Definitions_June_2016.pdf" target=" | 0% | 200020403190 |
children_tested_for_lead_1 | text | Additional notes that apply to field to the left | 100% | — |
children_tested_for_lead_2 | integer | Number of children born in New York City to New York City resident mothers who were tested for lead poisoning before the age of three years, divided by the number of children born in New York City to New York City resident mothers turning three years old; expressed as percent. | 0% | 838584 |
children_tested_for_lead_3 | text | Additional notes that apply to field to the left | 100% | — |