From a 500-row sample across 18 columns.
borough_idgeo_area_idtime_period+2| geo_type | geo_area_id | geo_area_name | borough_id | time_period | children_under_6_years_with | children_under_6_years_with_2 | children_under_6_years_with_4 | children_under_6_years_with_6 | children_under_6_years_with_8 | children_under_6_years_with_10 | children_under_6_years_with_12 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Borough | 1 | Bronx | 1 | 2005 | 8245 | 595 | 167 | 64500 | 127.7 | 9.2 | 2.6 |
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% | QueensWest QueensGreenpoint |
borough_id | categorical | An ID for the NYC borough that the neighborhood falls within | 2% |
GET /api/datasets/tnry-kwh5 GET /api/datasets/tnry-kwh5/quality GET /api/datasets/tnry-kwh5/related GET /api/columns?dataset=tnry-kwh5
| Borough | 1 | Bronx | 1 | 2006 | 7272 | 474 | 144 | 67200 | 108.2 | 7.1 | 2.1 |
| Borough | 1 | Bronx | 1 | 2007 | 6174 | 438 | 135 | 68300 | 90.4 | 6.4 | 2 |
| Borough | 1 | Bronx | 1 | 2008 | 4254 | 292 | 105 | 69800 | 60.9 | 4.2 | 1.5 |
| Borough | 1 | Bronx | 1 | 2009 | 2742 | 278 | 103 | 70000 | 39.2 | 4 | 1.5 |
| Borough | 1 | Bronx | 1 | 2010 | 2625 | 290 | 101 | 70100 | 37.5 | 4.1 | 1.4 |
| Borough | 1 | Bronx | 1 | 2011 | 1996 | 231 | 75 | 70100 | 28.5 | 3.3 | 1.1 |
| Borough | 1 | Bronx | 1 | 2012 | 1396 | 184 | 81 | 66800 | 20.9 | 2.8 | 1.2 |
| Borough | 1 | Bronx | 1 | 2013 | 1312 | 193 | 74 | 65300 | 20.1 | 3 | 1.1 |
| Borough | 1 | Bronx | 1 | 2014 | 1186 | 177 | 68 | 63400 | 18.7 | 2.8 | 1.1 |
234time_period | categorical | The time period for which the data is aggregated; value could be a year, quarter, seasonal or multi-year | 0% | 201020132015of 12 |
children_under_6_years_with | integer | Number of children less than 6 years old tested in a given year with blood lead levels of 5 mcg/dL or greater. The numbers in this table include all children tested within a given calendar year, regardless of whether they were tested in previous years with the same or different blood lead levels. While children can receive more than one test during the calendar year, children are only counted once using the highest confirmed blood lead level during the calendar year. If the child does not have a | 0% | 2837129 |
children_under_6_years_with_1 | text | Additional notes that apply to field above | 98% | *Estimate is based on sm…of 1 |
children_under_6_years_with_2 | integer | Number of children less than 6 years old tested in a given year with blood lead levels of 10 mcg/dL or greater. The numbers in this table include all children tested within a given calendar year, regardless of whether they were tested in previous years with the same or different blood lead levels. While children can receive more than one test during the calendar year, children are only counted once using the highest confirmed blood lead level during the calendar year. If the child does not have | 0% | 741 |
children_under_6_years_with_3 | text | Additional notes that apply to field above | 76% | *Estimate is based on sm…of 1 |
children_under_6_years_with_4 | integer | Number of children less than 6 years old tested in a given year with blood lead levels of 15 mcg/dL or greater. The numbers in this table include all children tested within a given calendar year, regardless of whether they were tested in previous years with the same or different blood lead levels. While children can receive more than one test during the calendar year, children are only counted once using the highest confirmed blood lead level during the calendar year. If the child does not have | 0% | 124 |
children_under_6_years_with_5 | text | Additional notes that apply to field above | 49% | *Estimate is based on sm…of 1 |
children_under_6_years_with_6 | integer | Children under 6 years of age tested for lead poisoning in a given year. Children may be tested multiple times in a given year but are only counted once. All children are counted regardless of blood specimen type (confirmed or unconfirmed); the number is rounded to the nearest 100. <a href="http://a816-dohbesp.nyc.gov/IndicatorPublic/EPHTPDF/Childhood_Lead_Exposure_Definitions_June_2016.pdf" target="_blank">Read more </a>about different measures used by the Health Department for surveillance of | 0% | 220050004800 |
children_under_6_years_with_7 | text | Additional notes that apply to field above | 100% | — |
children_under_6_years_with_8 | float | Number of children less than 6 years old tested in a given year with blood lead levels of 5 mcg/dL or greater, divided by the total number of children less than 6 years old who were tested for lead poisoning in a given year; expressed as cases per 1,000 tested. The numbers in this table include all children tested within a given calendar year, regardless of whether they were tested in previous years with the same or different blood lead levels. While children can receive more than one test durin | 0% | 15.120.9108.2 |
children_under_6_years_with_9 | text | Additional notes that apply to field above | 98% | *Estimate is based on sm…of 1 |
children_under_6_years_with_10 | float | Number of children less than 6 years old tested in a given year with blood lead levels of 10 mcg/dL or greater, divided by the number of children less than 6 years old who were tested for lead poisoning in a given year; expressed as cases per 1,000 tested. The numbers in this table include all children tested within a given calendar year, regardless of whether they were tested in previous years with the same or different blood lead levels. While children can receive more than one test during the | 0% | 2.92.43 |
children_under_6_years_with_11 | text | Additional notes that apply to field above | 76% | *Estimate is based on sm…of 1 |
children_under_6_years_with_12 | float | Number of children less than 6 years old tested in a given year with blood lead levels of 15 mcg/dL or greater, divided by the number of children less than 6 years old who were tested for lead poisoning in a given year; expressed as cases per 1,000 tested. The numbers in this table include all children tested within a given calendar year, regardless of whether they were tested in previous years with the same or different blood lead levels. While children can receive more than one test during the | 0% | 0.61.20 |
children_under_6_years_with_13 | text | Additional notes that apply to field above | 49% | *Estimate is based on sm…of 1 |