The datamap applies to the Contracts download in the CheckbookNYC Contracts dataset. It is worth noting that the Website has a number of additional fields including "Number of Solicitations per Contract" & "Number of Responses per Solicitation."
| Standardized Fieldname | Concept | Type | Language | Title | Description | Allowable Values |
|---|---|---|---|---|---|---|
| agency | BUYER | Text | U.S. English | Agency | government departments | |
| apt_pin | TENDER TRACKING | Number, Letter | U.S. English | APT PIN | Procurement Identification Number created by the Automated Procurement Tracking (APT) application. | |
| award_method | TENDER FEATURES | SingleSelect | U.S. English | Award Method | e.g., small purchase, renewal of contract | |
| contract_id | CONTRACT TRACKING | Letter, Number | U.S. English | Contract ID | A unique number that the City assigns to track a specific contract. | |
| contract_industry | GOODS / SERVICES | SingleSelect | U.S. English | Contract Industry | Construction Services, Goods, Not Cla... | |
| contract_type | GOODS / SERVICES | SingleSelect | U.S. English | Contract Type | e.g., work/labor, programs, requirements-services | |
| current_amount | AMOUNT | Currency | U.S. English | Current Amount | ||
| document_code | DOCUMENTS | SingleSelect | U.S. English | Document Code | CT1, CTA1, MA1, MMA1 | |
| end_date | CONTRACT FEATURES | DateTime | U.S. English | End Date | ||
| expense_category | GOODS / SERVICES | SingleSelect | U.S. English | Expense Category | a category description assigned by NYC for the purposes of organizing expenses. | |
| original_amount | AMOUNT | Currency | U.S. English | Original Amount | ||
| parent_contract_id | CONTRACT TRACKING | Letter, Number | U.S. English | Parent Contract ID | ||
| pin | TENDER TRACKING | Number, Letter | U.S. English | PIN | Procurement Identification Number given by the City. | |
| purpose | GOODS / SERVICES | Number, Text | U.S. English | Purpose | contract title/description | |
| registration_date | CONTRACT TRACKING | DateTime | U.S. English | Registration Date | ||
| spent_to_date | AMOUNT | Currency | U.S. English | Spent to date | ||
| start_date | CONTRACT FEATURES | DateTime | U.S. English | Start Date | ||
| vendor | SUPPLIER | Text | U.S. English | Vendor | ||
| version | ADD ON | Number | U.S. English | Version | 1-6, 8, 10-12, 17 | |
| year | TENDER FEATURES | DateTime | U.S. English | Year |
