About this Dataset

Official And Unofficial Bid Items

The Official and Unofficial Bid Items dataset displays advertisement and bidding information for the State and Local Lettings from the official sources of The Electronic State Business Daily (ESBD), the Electronic Bidding System, and the project proposal. Bidders should bid the project using the information found therein, including any addenda. These sources take precedence over information from other sources, including TxDOT webpages, which are unofficial and intended for informational purposes only.
Official and Unofficial Bid Items dataset includes data in 42 forward days bid items.
Organization: City of Austin
Last updated: 2025-01-25T12:33:12.857081
Tags: bid, bid-code, bid-item, bid-type, ccsj, contract, csj, highway, letting, official, project, unofficial

Tables

Table 1

@usgov.city_of_austin_r8_official_and_unofficial_bid_items.table_1

667.02 kB
18,176 rows
65 columns

CREATE TABLE table_1 (
  "a_b_max_days" VARCHAR,
  "a_b_message" VARCHAR,
  "a_b_milestone" VARCHAR,
  "a_b_road_user_cost" VARCHAR,
  "alternative_bid_code" VARCHAR,
  "bid_code" VARCHAR,
  "bid_item_code" DOUBLE,
  "bid_item_description" VARCHAR,
  "bid_item_quantity" DOUBLE,
  "bid_item_sequence_number" DOUBLE,
  "bid_recieved_until_date_and_time" VARCHAR,
  "bid_type_description" VARCHAR,
  "bidder_prequalification_waiver_flag" BOOLEAN,
  "bids_will_be_opened_date_and_time" VARCHAR,
  "contact_combined_address" VARCHAR,
  "contact_full_name" VARCHAR,
  "contact_phone_number" VARCHAR,
  "control_section_job_csj" VARCHAR  -- CONTROL SECTION JOB (CSJ),
  "controlling_project_id_ccsj" VARCHAR  -- CONTROLLING PROJECT ID (CCSJ),
  "county" VARCHAR,
  "design_standard" VARCHAR,
  "district_division" VARCHAR  -- DISTRICT / DIVISION,
  "force_account_amount" DOUBLE,
  "force_account_code" DOUBLE,
  "force_account_description" VARCHAR,
  "highway" VARCHAR,
  "let_schedule_fiscal_year" DOUBLE,
  "let_type" VARCHAR,
  "mandatory_pre_bidders_conference_attendence" BOOLEAN,
  "maximum_number_of_working_days" BIGINT,
  "measurement_unit" VARCHAR,
  "measurement_unit_description" VARCHAR,
  "mpo" VARCHAR,
  "pre_bidders_conference_address" VARCHAR,
  "pre_bidders_conference_city" VARCHAR,
  "pre_bidders_conference_date_time" VARCHAR  -- PRE-BIDDERS CONFERENCE DATE & TIME,
  "pre_bidders_conference_location_name" VARCHAR,
  "pre_bidders_conference_room_number" VARCHAR,
  "pre_bidders_conference_state" VARCHAR,
  "pre_bidders_conference_street_address_1" VARCHAR,
  "pre_bidders_conference_street_address_2" VARCHAR,
  "pre_bidders_conference_zip_code" VARCHAR,
  "project_actual_let_date" VARCHAR,
  "project_approved_let_date" VARCHAR,
  "project_classification" VARCHAR,
  "project_estimated_let_date" VARCHAR,
  "project_id" VARCHAR,
  "project_number" VARCHAR,
  "project_sysid" BIGINT,
  "project_type" VARCHAR,
  "proposal_address_1" VARCHAR,
  "proposal_address_2" VARCHAR,
  "proposal_attn" VARCHAR,
  "proposal_city" VARCHAR,
  "proposal_guarantee_amount" BIGINT,
  "proposal_mail_to" VARCHAR,
  "proposal_phone_number" BIGINT,
  "proposal_published_date" VARCHAR,
  "proposal_status" VARCHAR,
  "proposal_zip_code" VARCHAR,
  "sealed_engineer_s_estimate_contract" DOUBLE,
  "sealed_engineer_s_estimate_project" DOUBLE,
  "spec_code" DOUBLE,
  "special_notification_txt_flag" BOOLEAN,
  "specification_description" VARCHAR
);