Dataset: Asheville NC Construction And Repair Contracts

About this Dataset

Asheville NC Construction And Repair Contracts

This is data from the City of Asheville regarding Construction and Repair contracts from as early as Jan 4, 2010, up to February 24, 2022. Last updated 2/27/2022.

"This open data set includes all Construction and Repair contracts, all Professional Services contracts, and General Services contracts $5,000 and greater which are entered into the Contract module of the City's financial management system. This data is provided by the City of Asheville Open Data project.

This open data set includes all Construction and Repair contracts, all Professional Services contracts, and General Services contract $5,000 and greater which are entered into the Contract module of the City's financial management system. Per City of Asheville Purchasing and Contracting policy, Small Procurement Transactions (which includes General Services up to $5,000) may be paid via procurement card or by submitting an invoice for direct payment. These transactions are not entered into the Contracting module, but are tracked in Accounts Payable module of the City's financial management system."

Source: Munis Contracts Asheville

It might be interesting to merge this dataset with another dataset containing Vendor ID's. We then might explore which companies/vendors are receiving what size contracts.

Tables

Munis Contracts Asheville

@kaggle.trobacker_asheville_nc_construction_and_repair_contracts.munis_contracts_asheville

292.09 KB
4254 rows
12 columns


CREATE TABLE munis_contracts_asheville (
  "objectid" BIGINT,
  "contract_number" BIGINT,
  "contract_description" VARCHAR,
  "contract_status" VARCHAR,
  "contract_type" VARCHAR,
  "contract_subtype" VARCHAR,
  "last_modified" TIMESTAMP,
  "original_amount" DOUBLE,
  "revised_amount" DOUBLE,
  "vendor_id" BIGINT,
  "vendor_name" VARCHAR,
  "objectid_1" BIGINT
);