Name: MTA Procurements: Beginning 2018
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

MTA Procurements: Beginning 2018

The dataset consists of annual procurement contracts data reported by the Metropolitan Transportation Authority to the Authorities Budget Office via the Public Authorities Reporting Information System (PARIS).
Organization: State of New York
Last updated: 2023-10-20T10:02:33.513674
Tags: contracts, procurements, vendors

Tables

Table 1

@usgov.state_of_new_york_mta_procurements_beginning_2018.table_1

6.11 MB
94,027 rows
32 columns

CREATE TABLE table_1 (
  "fiscal_year_end_date" TIMESTAMP,
  "vendor_name" VARCHAR,
  "transaction_number" VARCHAR,
  "procurement_description" VARCHAR,
  "status" VARCHAR,
  "type_of_procurement" VARCHAR,
  "award_process" VARCHAR,
  "award_date" VARCHAR,
  "begin_date" VARCHAR,
  "renewal_date" TIMESTAMP,
  "end_date" VARCHAR,
  "contract_amount" DOUBLE,
  "amount_expended_for_fiscal_year" DOUBLE,
  "amount_expended_to_date" DOUBLE,
  "current_or_outstanding_balance" DOUBLE,
  "number_of_bids_or_proposals_received" DOUBLE,
  "vendor_is_nys_or_fbe" VARCHAR,
  "vendor_is_a_mwbe" VARCHAR,
  "solicited_mwbe" VARCHAR,
  "number_of_mwbe_proposals" DOUBLE,
  "exempt_from_article_4c" VARCHAR,
  "basis_for_exemption" VARCHAR,
  "fair_market_value" DOUBLE,
  "fair_market_value_explanation" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" VARCHAR,
  "zip_code_plus_4" VARCHAR,
  "region" VARCHAR,
  "country" VARCHAR
);