version: 2
sources:
- name: dot_nhcci
  description: NHCCI discovered from datahub.transportation.gov.
  meta:
    opendataodc:
      dataset_id: dot-nhcci
      revision_id: 20260926191900-ec97282872d2
      detected_at: '2026-09-26T19:19:00+00:00'
      source_url: https://datahub.transportation.gov/api/views/r94d-n4f9/rows.csv?accessType=DOWNLOAD
  tables:
  - name: nhcci_csv
    description: Source asset NHCCI.csv.
    meta:
      opendataodc:
        source_url: https://datahub.transportation.gov/api/views/r94d-n4f9/rows.csv?accessType=DOWNLOAD
        content_hash: fbacf8302ffdac2d54e73d1afaa0426723b18a0ba2bb30966007eed4410d1007
        row_count: 93
        parser_errors: []
    columns:
    - name: quarter
    - name: NHCCI
    - name: NHCCI-Seasonally-Adjusted
    - name: grp9-pct-change-Grading-Excavation
    - name: grp9-pct-change-Bridge
    - name: grp9-pct-change-Asphalt
    - name: grp9-pct-change-Concrete
    - name: grp9-pct-change-Base-Stone
    - name: grp9-pct-change-Drainage
    - name: grp9-pct-change-Traffic-Control
    - name: grp9-pct-change-Electrical
    - name: grp9-pct-change-Utilities-erosion-control-clearing-painting-and-equipment
    - name: grp13-pct-change-Grading-Excavation
    - name: grp13-pct-change-Bridge
    - name: grp13-pct-change-Asphalt
    - name: grp13-pct-change-Concrete
    - name: grp13-pct-change-Base-Stone
    - name: grp13-pct-change-Drainage
    - name: grp13-pct-change-Traffic-Control
    - name: grp13-pct-change-Erosion-Control
    - name: grp13-pct-change-Clearing
    - name: grp13-pct-change-Electrical
    - name: grp13-pct-change-Structures
    - name: grp13-pct-change-Utility
    - name: grp13-pct-change-Equipment
    - name: grp25-pct-change-Grading-Excavation
    - name: grp25-pct-change-Bridge
    - name: grp25-pct-change-Asphalt
    - name: grp25-pct-change-Concrete_Pavement
    - name: grp25-pct-change-Concrete-Misc
    - name: grp25-pct-change-Concrete-Culvers
    - name: grp25-pct-change-Base-Stone
    - name: grp25-pct-change-Drainage-Pipe
    - name: grp25-pct-change-Drainage-Inlets-Catch-Basins
    - name: grp25-pct-change-Underdrain
    - name: grp25-pct-change-Traffic-Control
    - name: grp25-pct-change-Guard-Rail
    - name: grp25-pct-change-Fencing
    - name: grp25-pct-change-Signs-Permanent
    - name: grp25-pct-change-Striping-Pavement-Marking
    - name: grp25-pct-change-Clearing
    - name: grp25-pct-change-Equipment-Labor
    - name: grp25-pct-change-Grassing
    - name: grp25-pct-change-Erosion-Control
    - name: grp25-pct-change-Retaining-Wall
    - name: grp25-pct-change-Misc-Stone-Riprap
    - name: grp25-pct-change-Painting-Structures
    - name: grp25-pct-change-Buildings-Misc-Structures
    - name: grp25-pct-change-Electrical
    - name: grp25-pct-change-Utility