States

Introduction

This dataset contains data for states and equivalent entities in United States of America. States and equivalent entities are the primary governmental divisions of the United States. In addition to the fifty States, the Census Bureau treats the District of Columbia, Puerto Rico, and each of the Island Areas (American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, and the U.S. Virgin Islands) as the statistical equivalents of States for the purpose of data presentation.

Data Source Characteristics

  • Data file: us-state-boundaries.csv

  • Format: csv

  • Size: about 2 MB

  • Update frequency: annual

  • URLs:

Data Target Characteristics

  • Database management system: PostgreSQL

  • Database name: io_avstats_db

  • Database table: io_states

Data Processing

  • Repository: io-avstats

  • Script: run_io_avstats_dev

  • Task: l_c_s (Load country and state data into PostgreSQL)

Processing Steps:

  1. The US State Boundaries csv file is downloaded from here.

  2. The database table io_states is updated from the downloaded data file us-state-boundaries.csv.

For detailed processing steps, refer to the external repository: io-avstats

Configuration Parameter:

opendatasoft_us_state_boundaries_file = "us-state-boundaries.csv"
opendatasoft_us_state_boundaries_file_url = "https://public.opendatasoft.com/explore/dataset/us-state-boundaries/export/"
opendatasoft_us_state_boundaries_url = "https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/us-state-boundaries/exports/csv?lang=en&timezone=Europe%2FBerlin&use_labels=true&delimiter=%3B"
opendatasoft_timeout = 10
opendatasoft_transaction_size = 500
opendatasoft_workdir = "data/opendatasoft"

Contact Information