From a 500-row sample across 19 columns.
zip_codezip_codeHas zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.
| awarding_agency | contract_identification_number | mwbe_status | purpose | vendor_name | zip_code | original_start_date | original_end_date | start_date | end_date | registration_date | last_modified_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201400562 | Non-MWBE | Nursing Services & COVID-19 emergency related services | GOTHAM PER DIEM INC | 10038-4810 | 2019-08-01T00:00:00.000 | 2022-07-31T00:00:00.000 | 2019-08-01T00:00:00.000 | 2022-07-31T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
awarding_agency | text | AGENCY NAME | 0% | DEPARTMENT OF HEALTH AND…DEPARTMENT OF EDUCATIONDEPARTMENT OF CITYWIDE A… |
contract_identification_number | text | CONTRACT ID, A CONCATENATION OF THE DOC_CD, DOC_DEPT_CD AND DOC_ID | 0% | CT181620211405092CT126020201421016POD81620202027946 |
mwbe_status | categorical | THE MWBE STATUS IN FMS | 0% | Non-MWBEMWBEof 2 |
purpose | text | THE DESCRIPTION ASSOCIATED WITH THE DOCUMENT. | 2% |
GET /api/datasets/5w2t-dbac GET /api/datasets/5w2t-dbac/quality GET /api/datasets/5w2t-dbac/related GET /api/columns?dataset=5w2t-dbac
| 2019-08-16T00:00:00.000 |
| 2022-09-13T00:00:00.000 |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201414602 | MWBE | TODDLER & EMERG. MEAL SVCS FOR ACS CHILDREN'S CENTER | Red Rabbit, LLC | 10035 | 2019-11-01T00:00:00.000 | 2022-10-31T00:00:00.000 | 2019-11-01T00:00:00.000 | 2023-10-31T23:59:00.000 | 2020-01-10T00:00:00.000 | 2022-09-02T00:00:00.000 |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201421948 | MWBE | EMERG. PURCHASE FOR PPE ITEMS DUE TO COVID-19 | SUN INTERNATIONAL TRADING LLC | 11378 | 2020-03-25T00:00:00.000 | 2020-06-30T00:00:00.000 | 2020-03-25T00:00:00.000 | 2020-06-30T00:00:00.000 | 2020-03-26T00:00:00.000 | 2020-05-20T00:00:00.000 |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201422280 | Non-MWBE | Personal Protective Equipment | Step Solutions, LLC | 49684-6203 | 2020-03-29T00:00:00.000 | 2030-04-29T00:00:00.000 | 2020-03-29T00:00:00.000 | 2030-04-29T00:00:00.000 | 2020-04-03T00:00:00.000 | 2020-05-01T00:00:00.000 |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201424121 | MWBE | Recreational Activities-Detention CTR-Horizon & Crossroads | APRIL ROBBINS-BOBYN CONSULTING | 11210 | 2020-04-01T00:00:00.000 | 2021-03-31T00:00:00.000 | 2020-04-01T00:00:00.000 | 2022-03-31T00:00:00.000 | 2020-04-22T00:00:00.000 | 2021-06-21T00:00:00.000 |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201424316 | Non-MWBE | COVID-19 N95 Masks | MERCER TOOL CORP | 11779-7321 | 2020-04-23T00:00:00.000 | 2020-06-30T00:00:00.000 | 2020-04-23T00:00:00.000 | 2020-06-30T00:00:00.000 | 2020-04-24T00:00:00.000 | — |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820201424677 | MWBE | EMERGENCY COVID-19 PURCHASE ITEMS-DYFJ | INTIVITY INC | 14445 | 2020-03-05T00:00:00.000 | 2020-06-30T00:00:00.000 | 2020-03-05T00:00:00.000 | 2020-06-30T00:00:00.000 | 2020-05-04T00:00:00.000 | — |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820211414431 | Non-MWBE | DIRAD ANNUAL SUPPORT MAINTENANCE | DELL MARKETING LP | 78682 | 2020-11-01T00:00:00.000 | 2021-10-31T00:00:00.000 | 2020-11-01T00:00:00.000 | 2021-10-31T00:00:00.000 | 2021-01-26T00:00:00.000 | — |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820221408917 | Non-MWBE | ART START PROGRAM FOR YOUTH | ART START INC | 10001 | 2021-07-01T00:00:00.000 | 2022-06-30T00:00:00.000 | 2021-07-01T00:00:00.000 | 2022-06-30T00:00:00.000 | 2021-11-12T00:00:00.000 | 2022-09-13T00:00:00.000 |
| ADMINISTRATION FOR CHILDREN'S SERVICES | CT106820228802347 | MWBE | Educational Support Services | NYC TIER INC | 11731-3408 | 2021-02-01T00:00:00.000 | 2023-06-30T23:59:00.000 | 2021-02-01T00:00:00.000 | 2022-01-31T00:00:00.000 | 2021-09-24T00:00:00.000 | 2022-06-03T00:00:00.000 |
Showing 12 of 18 columns. All of them are listed below.
UPK-HSTMEDICAL EQUIPMENTCOVID-19 Older Adult Foo…vendor_name | text | THE LEGALLY DEFINED NAME OF THE COMPANY OR INDIVIDUAL REPRESENTED BY THIS RECORD. | 0% | NEW YORK CITY ECONOMIC D…GARIC INCNEW YORK STATE INDUSTRIE… |
zip_code | text | — | 0% | 100181000110006-1419 |
original_start_date | datetime | THE CONTRACT START DATE ENTERED ON VERSION 1 OF THE AGREEMENT. | 0% | 2019-07-01T00:00:00.0002021-07-01T00:00:00.0002018-07-01T00:00:00.000 |
original_end_date | datetime | THE CONTRACT END DATE ENTERED ON VERSION 1 OF THE AGREEMENT. | 4% | 2020-06-30T00:00:00.0002021-06-30T00:00:00.0002022-06-30T00:00:00.000 |
start_date | datetime | THE START DATE OF THE CONTRACT. | 0% | 2019-07-01T00:00:00.0002021-07-01T00:00:00.0002018-07-01T00:00:00.000 |
end_date | datetime | THE END DATE OF THE CONTRACT. | 0% | 2020-06-30T00:00:00.0002021-06-30T00:00:00.0002022-06-30T00:00:00.000 |
registration_date | datetime | REGISTRATION DATE OF THE CONTRACT OR DELIVERY ORDER | 0% | 2020-04-21T00:00:00.0002020-04-07T00:00:00.0002020-04-23T00:00:00.000 |
last_modified_date | datetime | DATE OF MOST RECENT MODIFICATION TO THE CONTRACT. | 53% | 2022-08-15T00:00:00.0002022-09-29T00:00:00.0002022-08-25T00:00:00.000 |
original_contract_amount | float | ORIGINAL CONTRACT AMOUNT. | 0% | 0.0020000.00100000.00 |
covid_encumbered_amount | float | ENCUMBRANCE AMOUNT AGAINST THE CV* BUDGET CODE. | 0% | 0.0020000.00100000.00 |
covid_spend_to_date | float | THE TOTAL LIQUIDATED AMOUNT OF THE CONTRACT | 16% | 20000.0018051.4019094.70 |
funding_type | categorical | FUNDING SOURCE | 60% | N/ACity Non ExemptFederalof 12 |
award_method | text | INDICATES HOW VENDORS ARE TO BE AWARDED BASED ON THE INFORMATION ENTERED IN THE TABLE. | 9% | EMERGENCYMICROPURCHASE - NOT EXCE…RENEWAL OF CONTRACT |
contract_type | text | INDICATES THE AGREEMENT TYPE. MUST BE A VALID VALUE ON THE AWARD TYPE REFERENCE TABLE. | 18% | SUPPLIES/MATERIALS/EQUIP…PROGRAMSWORK/LABOR |
subcontractor_s | text | NAMES OF SUBCONTRACTORS ON THE CONTRACTOR IF APPLICABLE. SUBCONTRACTOR MWBE STATUS (MWBE, NON-MWBE) AND TOTAL SUBCONTRACTOR PAYMENT AMOUNT ARE PROVIDED IN PARENTHESES. | 94% | 1) PMY CONSTRUCTION CORP…1) Universal Protection …1) PMY CONSTRUCTION CORP… |