Name: JTA Project Status
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

JTA Project Status

The Oregon Legislature passed the Jobs & Transportation Act in 2009, allocating funds to build transportation projects around Oregon. This data gives an update on the status of these projects.
Organization: State of Oregon
Last updated: 2020-11-10T17:22:07.383944
Tags: jta, odot, transportation-projects

Tables

Table 1

@usgov.state_of_oregon_jta_project_status.table_1

79.25 kB
144 rows
19 columns

CREATE TABLE table_1 (
  "overall_project_name" VARCHAR,
  "key_number" BIGINT,
  "overall_description" VARCHAR,
  "overall_benefits" VARCHAR,
  "project_phase" VARCHAR,
  "child_project_name" VARCHAR,
  "child_project_key_number" DOUBLE,
  "previous_project_cost" DOUBLE,
  "current_project_cost" DOUBLE,
  "previous_bid_opening_date" TIMESTAMP,
  "current_bid_opening_date" TIMESTAMP,
  "previous_completion_date" TIMESTAMP,
  "current_completion_date" TIMESTAMP,
  "create_date" TIMESTAMP,
  "region" DOUBLE,
  "opt" VARCHAR,
  "congressional_district" VARCHAR,
  "state_senate_district" VARCHAR,
  "state_representative_district" VARCHAR
);