Motor Vehicle Registrations, 1900 - 2023 (MV-1, wide format)

Motor Vehicle Registrations, 1900 - 2023 (MV-1, wide format) discovered from datahub.transportation.gov.

Update frequency
adhoc
Next scan
Tue, 29 Sep 2026 02:00:00 GMT
Quality
100/100
Latest revision
20260926191848-cb6ad2c9dc64
Last successful scan
2026-09-26T19:18:48+00:00
Source published
Mon, 12 May 2025 20:20:59 GMT
Parser status
Parsed cleanly

Source

datahub.transportation.gov

Quality score: 100/100.

Initial recorded revision.

Dataset refresh metadata

Current Source Files

Contract Versions

Current Open Data Contract YAML

Open raw YAML

dataset_id: dot-motor-vehicle-registrations-1900-2023-mv-1-wide-format
title: Motor Vehicle Registrations, 1900 - 2023 (MV-1, wide format)
description: Motor Vehicle Registrations, 1900 - 2023 (MV-1, wide format) discovered
  from datahub.transportation.gov.
source_name: datahub.transportation.gov
source_url: https://datahub.transportation.gov/api/views/hwtm-7xmz/rows.csv?accessType=DOWNLOAD
update_frequency: adhoc
next_scan_at: '2026-09-29T02:00:00+00:00'
license:
  name: Public Domain U.S. Government
  url: https://datahub.transportation.gov/Roadways-and-Bridges/Motor-Vehicle-Registrations-1900-2023-MV-1-wide-fo/hwtm-7xmz
tags:
- datahub.transportation.gov
- transportation
geography:
- United States
revisions:
- revision_id: 20260926191848-cb6ad2c9dc64
  detected_at: '2026-09-26T19:18:48+00:00'
  source_updated_at: Mon, 12 May 2025 20:20:59 GMT
  context: Motor_Vehicle_Registrations__1900_-_2023__MV-1__wide_format_.csv detected
    from rows.csv.
  assets:
  - asset_id: asset-9510b5c73c27d8c8
    name: Motor_Vehicle_Registrations__1900_-_2023__MV-1__wide_format_.csv
    source_url: https://datahub.transportation.gov/api/views/hwtm-7xmz/rows.csv?accessType=DOWNLOAD
    media_type: text/csv; charset=utf-8
    content_hash: 9510b5c73c27d8c862f565ce348f880210bada3796a3a4465a64823a60e750e8
    size_bytes: 237179
    parent_archive_id: null
  row_count: 6324
  headers:
  - year
  - state
  - Auto
  - Bus
  - Truck
  - Motorcycle
  sample_rows:
  - year: '1900'
    state: Alabama
    Auto: '40'
    Bus: '0'
    Truck: '0'
    Motorcycle: '0'
  - year: '1900'
    state: Alaska
    Auto: '0'
    Bus: '0'
    Truck: '0'
    Motorcycle: '0'
  - year: '1900'
    state: Arizona
    Auto: '20'
    Bus: '0'
    Truck: '0'
    Motorcycle: '0'
  - year: '1900'
    state: Arkansas
    Auto: '20'
    Bus: '0'
    Truck: '0'
    Motorcycle: '0'
  - year: '1900'
    state: California
    Auto: '780'
    Bus: '0'
    Truck: '0'
    Motorcycle: '0'
  parser_errors: []
  logical_asset_id: d27917412646dc9fbab3fde6
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: '2026-09-26T19:18:48+00:00'

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: dot_motor_vehicle_registrations_1900_2023_mv_1_wide_format
  description: Motor Vehicle Registrations, 1900 - 2023 (MV-1, wide format) discovered
    from datahub.transportation.gov.
  meta:
    opendataodc:
      dataset_id: dot-motor-vehicle-registrations-1900-2023-mv-1-wide-format
      revision_id: 20260926191848-cb6ad2c9dc64
      detected_at: '2026-09-26T19:18:48+00:00'
      source_url: https://datahub.transportation.gov/api/views/hwtm-7xmz/rows.csv?accessType=DOWNLOAD
  tables:
  - name: motor_vehicle_registrations_1900_2023_mv_1_wide_format_csv
    description: Source asset Motor_Vehicle_Registrations__1900_-_2023__MV-1__wide_format_.csv.
    meta:
      opendataodc:
        source_url: https://datahub.transportation.gov/api/views/hwtm-7xmz/rows.csv?accessType=DOWNLOAD
        content_hash: 9510b5c73c27d8c862f565ce348f880210bada3796a3a4465a64823a60e750e8
        row_count: 6324
        parser_errors: []
    columns:
    - name: year
    - name: state
    - name: Auto
    - name: Bus
    - name: Truck
    - name: Motorcycle

Sample Rows

Motor_Vehicle_Registrations__1900_-_2023__MV-1__wide_format_.csv

6324 parsed rows. 20260926191848-cb6ad2c9dc64

Sample rows shown: 5; 6324 parsed rows.
year
state
Auto
Bus
Truck
Motorcycle
1900
Alabama
40
0
0
0
1900
Alaska
0
0
0
0
1900
Arizona
20
0
0
0
1900
Arkansas
20
0
0
0
1900
California
780
0
0
0