From a 500-row sample across 14 columns.
| data_as_of_date | change_order_project_sca_contract_identifier | change_order_boro_identifier | change_order_project_district_identifier | change_order_project_identifier | change_management_number | change_order_document_date | change_order_project_ball_in_court_code | change_order_project_title | change_order_document_type | change_order_project_stage_date | change_order_number |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021-11-01T10:30:57.7988774-04 | C000013537 | K | 15 | PS333K02 | 00062 | 2021-02-10 | NORTHEAS | 516 Sunset Park School(K) Int Reno |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
data_as_of_date | datetime | — | 0% | 2021-11-01T10:30:57.7988…of 1 |
change_order_project_sca_contract_identifier | text | Contract Number | 0% | C000013980C000013501C000012869 |
change_order_boro_identifier | categorical | Borough: Bronx = X; Brooklyn = K; Queens = Q; Manhattan = M; Staten Island = R; and Multi Borough = V | 0% | QKXof 6 |
change_order_project_district_identifier | text | SCA District Code | 0% | 31 |
GET /api/datasets/gzvm-na49 GET /api/datasets/gzvm-na49/quality GET /api/datasets/gzvm-na49/related GET /api/columns?dataset=gzvm-na49
| CO |
| 2021-07-22 |
| 00062 |
| 2021-11-01T10:30:57.7988774-04 | C000013537 | K | 15 | PS333K02 | 00062 | 2021-02-10 | NORTHEAS | 516 Sunset Park School(K) Int Reno | EST | 2021-02-10 | 00062 |
| 2021-11-01T10:30:57.7988774-04 | C000013537 | K | 15 | PS333K02 | 00062 | 2021-02-10 | NORTHEAS | 516 Sunset Park School(K) Int Reno | FRE | 2021-04-02 | 00062 |
| 2021-11-01T10:30:57.7988774-04 | C000013537 | K | 15 | PS333K02 | 00062 | 2021-02-10 | NORTHEAS | 516 Sunset Park School(K) Int Reno | PCO | 2021-04-02 | 00062 |
| 2021-11-01T10:30:57.7988774-04 | C000014875 | K | 32 | HSBUSK09 | 00009 | 2018-12-12 | OUDAZ | Acad for Env LS(K) @ BW Science Lab | EST | 2018-12-12 | 00009 |
| 2021-11-01T10:30:57.7988774-04 | C000015067 | K | 13 | HS743K01 | 00014 | 2019-08-30 | RICI | Adult&Cont Ed @K743 Ext Mas,Vent | EST | 2019-08-30 | 00014 |
| 2021-11-01T10:30:57.7988774-04 | C000015067 | K | 13 | HS743K01 | 00036 | 2021-05-03 | RICI | Adult&Cont Ed @K743 Ext Mas,Vent | EST | 2021-05-03 | 00036 |
| 2021-11-01T10:30:57.7988774-04 | C000015067 | K | 13 | HS743K01 | 00043 | 2021-06-23 | RICI | Adult&Cont Ed @K743 Ext Mas,Vent | EST | 2021-06-23 | 00043 |
| 2021-11-01T10:30:57.7988774-04 | C000015067 | K | 13 | HS743K01 | 00015 | 2019-09-03 | RICI | Adult&Cont Ed @K743 Ext Mas,Vent | PCO | 2021-10-20 | 00015 |
| 2021-11-01T10:30:57.7988774-04 | C000015067 | K | 13 | HS743K01 | 00038 | 2021-05-03 | RICI | Adult&Cont Ed @K743 Ext Mas,Vent | EST | 2021-05-03 | 00038 |
Showing 12 of 14 columns. All of them are listed below.
0227change_order_project_identifier | text | Project Name | 0% | HSCURR10PS050Q09PS343M02 |
change_management_number | text | — | 0% | 000010000500002 |
change_order_document_date | date | Document Date | 0% | 2020-04-062020-04-072021-08-31 |
change_order_project_ball_in_court_code | text | Responsible Party | 0% | LDDAMCCARNELL |
change_order_project_title | text | Project Title | 0% | Curtis HS (R) New 3 Stor…PS050Q New Add/Exist Bld…PS343M Reno & Three Stor… |
change_order_document_type | categorical | Stage of Change Process (Estimate, Proposal, Fair and Reasonable Estimate, and Change Order) | 0% | ESTPCOFREof 7 |
change_order_project_stage_date | date | Change Order Date | 0% | 2020-04-062021-10-272021-10-28 |
change_order_number | text | Change Order Number | 0% | 000010000500006 |
change_order_project_to_status_name | categorical | Change Order Status | 0% | CLONEWAPPof 10 |
change_order_project_to_vendor_ | text | Contracting Party | 0% | SCA-PMAMCCLDD |