7b4ebff7d1507b4a…

Created Nov 13, 202614 fields1 collection using this schema

Labels

No labels yet.

Fields

NameTypeInfo
ciLowernumber
ciTextstring
ciUppernumber
displayValuestring
flagstring
geoTypestring
geographyIdstring
→ Geography
indicatorIdstring
→ Indicator
measureIdstring
→ Measure
notestring
reliabilitystring
sourceConflictboolean
timePeriodIdstring
→ TimePeriod
valuenumber

JSON Schema

{
  "description": "One value: a measure for one geography and one time period. Id '<MeasureID>:<GeoType>:<GeoID>:<TimePeriodID>', with '#2' appended to the second of two conflicting source rows.",
  "properties": {
    "ciLower": {
      "description": "Lower bound of the 95% confidence interval, where the source gives one",
      "type": "number"
    },
    "ciText": {
      "description": "The source CI text when it is present but not two numbers, e.g. '(., .)'",
      "type": "string"
    },
    "ciUpper": {
      "description": "Upper bound of the 95% confidence interval, where the source gives one",
      "type": "number"
    },
    "displayValue": {
      "description": "The value as the portal shows it: rounded, with thousands separators and annotation symbols, or a symbol alone when suppressed",
      "type": "string"
    },
    "flag": {
      "description": "Annotation symbol from the display value: '*' small numbers, '**' or '***' suppressed, '^^' high relative error, '^' outliers excluded, '†' not shown, or a placeholder like '-' or 'N/A'",
      "type": "string"
    },
    "geoType": {
      "description": "The geography's GeoType (denormalized for filtering)",
      "type": "string"
    },
    "geographyId": {
      "description": "The geography, '<GeoType>:<GeoID>'",
      "type": "string",
      "x-ref-type": "Geography"
    },
    "indicatorId": {
      "description": "The measure's indicator (denormalized for filtering)",
      "type": "string",
      "x-ref-type": "Indicator"
    },
    "measureId": {
      "description": "The measure",
      "type": "string",
      "x-ref-type": "Measure"
    },
    "note": {
      "description": "The source's note on this value (explains the flag, or a caveat such as COVID-19 effects)",
      "type": "string"
    },
    "reliability": {
      "description": "suppressed: no value; caution: a value flagged '*' or '^^' (small numbers or high relative error); ok: otherwise",
      "enum": [
        "ok",
        "caution",
        "suppressed"
      ],
      "type": "string"
    },
    "sourceConflict": {
      "description": "True when the source has more than one row for this measure, geography, and time period with different values; both are kept",
      "type": "boolean"
    },
    "timePeriodId": {
      "description": "The time period",
      "type": "string",
      "x-ref-type": "TimePeriod"
    },
    "value": {
      "description": "The value, unrounded. Missing when the source suppresses it.",
      "type": "number"
    }
  },
  "required": [
    "measureId",
    "indicatorId",
    "geographyId",
    "timePeriodId",
    "displayValue",
    "reliability"
  ],
  "title": "Observation",
  "type": "object"
}

Used by 1 collection

nyc/environment-healthas Observation · 1 version

Full hash:7b4ebff7d1507b4a66dca8978e5fbb54f97093d8f4d2e08834c1a8f83a35fe4e

ID:7b4ebff7d1507b4a66dca8978e5fbb54f97093d8f4d2e08834c1a8f83a35fe4e