Public data

US Census Bureau — data contract (compatible with US Census Bureau’s documented schema; not affiliated with US Census Bureau)

Name: US Census Bureau data contract
Creator: DataContractGate
License: https://opensource.org/licenses/MIT

Compatible with the US Census Bureau American Community Survey 5-year API; not affiliated with the U.S. Census Bureau. County-level 2023 population and median household income in 2023 inflation-adjusted dollars. A raw Census API pull is strings, including numeric estimates and placeholder codes such as -666666666; B19013_001M is the margin of error and B19013_001MA is its text annotation.

Validate a client's US Census Bureau export at ingest into your warehouse, or with POST /egress before sending the same shape to a partner, reverse ETL, or an AI agent.

Download YAML

Also available: ODCS v3.1.0 YAML. “Use this contract” forks it into your org, then opens the validation playground so you can upload the client file.

Fields

Name	Type	Required	Rule	Description
NAME	string	required	—	County and state name (for example Autauga County, Alabama).
B01003_001E	string	required	pattern /^-?[0-9]+$/	Total population estimate. The Census API returns this as a numeric string, not a JSON integer.
B19013_001E	string	optional	pattern /^-?[0-9]+$/	Median household income in the past 12 months, in 2023 inflation-adjusted dollars. Returned as a numeric string. -666666666 means the estimate could not be computed (insufficient sample, or a median in an open-ended interval). -888888888 means not applicable. -999999999 means too few sample cases.
B19013_001M	string	optional	pattern /^-?[0-9]+$/	Margin of error for median household income (B19013_001E), in 2023 inflation-adjusted dollars. This is the numeric margin of error. Returned as a numeric string. -222222222 means the margin of error could not be computed; -333333333 means the median is in an open-ended interval; -555555555 means a margin of error is not appropriate because the estimate is controlled.
B19013_001MA	string	optional	—	Annotation of the margin of error (attribute of B19013_001M). A short text code such as -, , , ****, (X), or N — not a dollar amount. JSON null when the Census API has no annotation. The dollar margin of error is B19013_001M.
state	string	required	pattern /^[0-9]{2}$/	State FIPS code (2-digit string, for example 01 for Alabama).
county	string	required	pattern /^[0-9]{3}$/	County FIPS code (3-digit string, for example 001).

Sample rows

Three synthetic rows we wrote. They validate against this contract with zero violations. No real customer data.

[
  {
    "B01003_001E": "55200",
    "B19013_001E": "62000",
    "B19013_001M": "2500",
    "B19013_001MA": null,
    "NAME": "Example County, Teststate",
    "county": "001",
    "state": "99"
  },
  {
    "B01003_001E": "12840",
    "B19013_001E": "48750",
    "B19013_001M": "3100",
    "B19013_001MA": null,
    "NAME": "Sample County, Teststate",
    "county": "002",
    "state": "99"
  },
  {
    "B01003_001E": "304100",
    "B19013_001E": "-666666666",
    "B19013_001M": "-222222222",
    "B19013_001MA": "-",
    "NAME": "Suppressed County, Teststate",
    "county": "003",
    "state": "99"
  }
]

Provenance

Verified against: https://www.census.gov/data/developers/data-sets/acs-5year.html
Checked: 2026-11-06
Version: v1.0
Author: DataContractGate
License: MIT

Spotted a mismatch with the vendor’s current schema? Report an issue.

Stripe, Shopify, QuickBooks, Xero, HubSpot, Salesforce, Google Analytics and Square are trademarks of their respective owners. DataContractGate is not affiliated with or endorsed by them. These contracts describe data shaped like these vendors’ documented schemas; they are not official and are not certified by any vendor.