About this Dataset

Recapitulation

The Recapitulation dataset displays the data of summarized and consolidated information related to a construction contract.
This recapitulation includes information such as the unit of measurement, quantity of work completed, unit price, cost, and vendor information.

TxDOT uses this information to determine the amount work has been completed according to the contract specifications.
Recapitulation dataset includes data in previous month.
Organization: City of Austin
Last updated: 2025-01-25T12:26:33.577211
Tags: bid, cis, contract, estimate, payestimate, recapitulation, total-cost, vendor

Tables

Table 1

@usgov.city_of_austin_r8_recapitulation.table_1

1.55 MB
16,283 rows
62 columns

CREATE TABLE table_1 (
  "area_engineer" VARCHAR,
  "area_office_number" BIGINT,
  "change_order_adjustment_days" DOUBLE,
  "contract_funding" VARCHAR,
  "contract_limits_from" VARCHAR,
  "contract_limits_to" VARCHAR,
  "contract_number" BIGINT,
  "contract_oversight" VARCHAR,
  "contract_status" VARCHAR,
  "contract_type" VARCHAR,
  "contractor" VARCHAR,
  "controlling_project_id_ccsj" VARCHAR  -- CONTROLLING PROJECT ID (CCSJ),
  "county" VARCHAR,
  "date_time_begin" VARCHAR,
  "date_work_accepted" VARCHAR,
  "date_work_begin" VARCHAR,
  "days_allowed" BIGINT,
  "days_charged" BIGINT,
  "days_granted" BIGINT,
  "disincentives" DOUBLE,
  "district_engineer" VARCHAR,
  "district_number" VARCHAR,
  "district_division" VARCHAR  -- DISTRICT/ DIVISION,
  "estimate_amount" DOUBLE,
  "estimate_approval_date" VARCHAR,
  "estimate_generation_date" VARCHAR,
  "estimate_number" DOUBLE,
  "estimate_status" VARCHAR,
  "estimate_type" VARCHAR,
  "execution_date" VARCHAR,
  "highway" VARCHAR,
  "incentives" DOUBLE,
  "liquidated_damages" DOUBLE,
  "maintenance_contract_indicator" VARCHAR,
  "maximum_number_of_working_days" BIGINT,
  "net_change_order_amount" DOUBLE,
  "original_contract_bid_price" DOUBLE,
  "other_adjustments" DOUBLE,
  "percent_complete" DOUBLE  -- PERCENT COMPLETE ($),
  "percent_complete_time" DOUBLE  -- PERCENT COMPLETE (TIME),
  "percent_time_used" DOUBLE,
  "project_actual_let_date" VARCHAR,
  "project_amount" DOUBLE,
  "project_engineer" VARCHAR,
  "project_manager" VARCHAR,
  "project_number" VARCHAR,
  "report_date_time" VARCHAR  -- REPORT DATE & TIME,
  "revised_bid_price" DOUBLE,
  "spec_book_year" BIGINT,
  "state_house_district_list" VARCHAR,
  "state_senate_district_list" VARCHAR,
  "subcontractor" VARCHAR  -- SUBCONTRACTOR (%),
  "subcontractor_name" VARCHAR,
  "subcontractor_percent" VARCHAR,
  "substantial_work_completed_date" VARCHAR,
  "third_party_funding" DOUBLE,
  "time_begin_date" VARCHAR,
  "total_amount_paid_to_contractor" DOUBLE,
  "total_work_to_date" DOUBLE,
  "type_of_work" VARCHAR,
  "vendor_id" BIGINT,
  "work_begin_date" VARCHAR
);