chriswhong/nyc_capital_project_detail_data_milestones
   1
 0
NYC Capital Project Detail Data - Milestones
Dataset published by chriswhong 

No description provided

2 commits40,849 rows2.4MBcsv
HEAD qETSV2F  add readme and column descriptions
5 months ago
Readme

NYC Capital Project Detail Data - Milestones

Capital Project milestones data for NYC capital projects, scraped from the “Capital Project Detail Data” pdfs published by the New York City Office of Management and Budget.

Milestones have a many-to-one relationship with capital projects. The capital project data associated with these milestones are located in another dataset, chriswhong/capital-project-detail-data

CSV
2.3 MB
40,849
2

CSV Configuration

This table contains a header row
This table uses different quotes to indicate strings

Schema

titletypedescription
project_id
string
the corresponding project id for this milestone (milestones have a many-to-one relationship with projects
milestone
string
the milestone name
original_start
string
the original start date for the milestone
original_end
string
the original end date for the milestone
current_start
string
the current start date for the milestone
current_end
string
the current end date for the milestone
Body Preview
qri-row-numberproject_idmilestoneoriginal_startoriginal_endcurrent_startcurrent_end
1LB20DUMBODESIGNJan 2019Dec 2019Jan 2021Dec 2021
2LB20DUMBOCONSTRUCTIONJan 2020Jun 2020Jan 2020Jun 2020
3LBC17DRBRDESIGNJul 2020Jun 2021Jul 2020Jun 2021
4LBC17DRBRCONSTRUCTIONJul 2021Dec 2021Jul 2021Dec 2021
5LBC18CTRFDESIGNJul 2019Jun 2020Jun 2022May 2023
6LBC18CTRFCONSTRUCTIONJun 2020Dec 2020Jun 2023Nov 2023
7LBC18FHSGDESIGNJul 2019Jun 2020Jun 2022May 2023
8LBC18FHSGCONSTRUCTIONJun 2020Dec 2020Jun 2023Nov 2023
9LBC18GSMRDESIGNJul 2019Jun 2020Jun 2022Jun 2023
10LBC18GSMRCONSTRUCTIONJun 2020Dec 2020Jun 2023Dec 2023
11LBC18KBFSDESIGNJul 2019Jun 2020Jun 2022Jun 2023
12LBC18KBFSCONSTRUCTIONJun 2020Dec 2020Jun 2023Dec 2023
13LBC18KBHCDESIGNJul 2019Jun 2020Jul 2021Jun 2022
14LBC18KBHCCONSTRUCTIONJun 2020Dec 2020Jul 2022Dec 2022
15LBC19CHELDESIGNSep 2019Jun 2021Sep 2023Jun 2025
16LBC19CHELCONSTRUCTIONJul 2021Jul 2022Jul 2025Jul 2026
17LBC20CTOPDESIGNJul 2020Jun 2021Jul 2022Jun 2023
18LBC20CTOPCONSTRUCTIONJul 2021Dec 2021Jul 2023Dec 2023
19LBC20MPMRDESIGNJul 2020Jun 2021Jul 2022Jun 2023
20LBC20MPMRCONSTRUCTIONJul 2021Dec 2021Jul 2023Dec 2023
21LBC20SAADDESIGNJul 2020Jun 2021Jul 2020Jun 2021
22LBC20SAADCONSTRUCTIONJul 2021Dec 2021Jul 2021Dec 2021
23LBC20SCBMDESIGNJul 2020Jun 2021Jul 2020Jun 2021
24LBC20SCBMCONSTRUCTIONJul 2021Dec 2021Jul 2021Dec 2021
25LBCENPH2DESIGNJul 2020Jun 2021Jul 2024Jun 2025
26LBCENPH2CONSTRUCTIONJul 2021Dec 2021Jul 2025Dec 2025
27LBEM05SWRDESIGNSep 2019Sep 2020Sep 2024Sep 2025
28LBEM05SWRCONSTRUCTIONSep 2020Jul 2022Sep 2025Jul 2027
29LBK16HLRFDESIGNSep 2019Sep 2020Sep 2021Sep 2022
30LBK16HLRFCONSTRUCTIONSep 2020Mar 2021Sep 2022Mar 2023
31LBK16SCRFDESIGNSep 2019Sep 2020Sep 2019Sep 2020
32LBK16SCRFCONSTRUCTIONSep 2020Jul 2022Sep 2020Jul 2022
33LBM18NLOHDESIGNJan 2020Dec 2020Jan 2020Dec 2020
34LBM18NLOHCONSTRUCTIONDec 2020Jun 2023Dec 2020Jun 2023
35LBM19BPLBDESIGNSep 2019Jun 2021Sep 2019Jun 2021
36LBM19BPLBCONSTRUCTIONJul 2021Dec 2021Jul 2021Dec 2021
37LBM19CAOHDESIGNJul 2020Jun 2021Jul 2020Jun 2021
38LBM19CAOHCONSTRUCTIONJul 2021Jul 2023Jul 2021Jul 2023
39LBP18BHBRDESIGNJul 2020Jun 2021Jul 2020Jun 2021
40LBP18BHBRCONSTRUCTIONJul 2021Jun 2021Jul 2021Jun 2021
41LBP18LDINDESIGNJul 2020Jun 2021Jul 2024Jun 2025
42LBP18LDINCONSTRUCTIONJul 2021Jun 2024Jul 2025Jun 2028
43LBP18PCADDESIGNJul 2020Jun 2021Jun 2024Jun 2025
44LBP18PCADCONSTRUCTIONJul 2021Jul 2022Jun 2025Jun 2026
45BY001-021DEVELOP SCOPEJun 2021Sep 2021Jun 2021Sep 2021
46BY001-021PRELIMINARY DESIGNSep 2021Jan 2022Sep 2021Jan 2022
47BY001-021FINAL DESIGNJan 2022Jul 2022Jan 2022Jul 2022
48BY001-021BID AWARD AND REGISTER CONTRCTJul 2022Oct 2022Jul 2022Oct 2022
49BY001-021CONSTRUCTION TO 25%Oct 2022Feb 2023Oct 2022Feb 2023
50BY001-021CONSTRUCTION TO 50%Feb 2023Jun 2023Feb 2023Jun 2023
51BY001-021CONSTRUCTION TO 75%Jun 2023Oct 2023Jun 2023Oct 2023
52BY001-021ORIGINAL EQUIP & FURNISHINGOct 2023Jan 2024Oct 2023Jan 2024
53BY001-021SUBSTANTIAL COMPLETIONJan 2024Mar 2024Jan 2024Mar 2024
54BY001-021PUNCHLIST COMPLETE, JOB CLOSEDMar 2024Apr 2024Mar 2024Apr 2024
55BY003-021DEVELOP SCOPEJun 2021Sep 2021Jun 2021Sep 2021
56BY003-021PRELIMINARY DESIGNSep 2021Jan 2022Sep 2021Jan 2022
57BY003-021FINAL DESIGNJan 2022Jul 2022Jan 2022Jul 2022
58BY003-021BID AWARD AND REGISTER CONTRCTJul 2022Oct 2022Jul 2022Oct 2022
59BY003-021CONSTRUCTION TO 25%Oct 2022Feb 2023Oct 2022Feb 2023
60BY003-021CONSTRUCTION TO 50%Feb 2023Jun 2023Feb 2023Jun 2023
61BY003-021CONSTRUCTION TO 75%Jun 2023Oct 2023Jun 2023Oct 2023
62BY003-021ORIGINAL EQUIP & FURNISHINGOct 2023Jan 2024Oct 2023Jan 2024
63BY003-021SUBSTANTIAL COMPLETIONJan 2024Mar 2024Jan 2024Mar 2024
64BY003-021PUNCHLIST COMPLETE, JOB CLOSEDMar 2024Apr 2024Mar 2024Apr 2024
65BY024-012DEVELOP SCOPEJun 2012Aug 2012Jun 2012Aug 2012
66BY024-012PRELIMINARY DESIGNAug 2012Dec 2012Aug 2012Dec 2012
67BY024-012FINAL DESIGNDec 2012Jun 2013Dec 2012Jun 2013
68BY024-012BID AWARD AND REGISTER CONTRCTJun 2013Sep 2013Jun 2013Sep 2013
69BY024-012CONSTRUCTION TO 25%Sep 2013Jan 2014Sep 2013Jan 2014
70BY024-012CONSTRUCTION TO 50%Jan 2014May 2014Jan 2014May 2014
71BY024-012CONSTRUCTION TO 75%May 2014Sep 2014May 2014Sep 2014
72BY024-012ORIGINAL EQUIP & FURNISHINGSep 2014Dec 2014Sep 2014Dec 2014
73BY024-012SUBSTANTIAL COMPLETIONDec 2014Feb 2015Dec 2014Feb 2015
74BY024-012PUNCHLIST COMPLETE, JOB CLOSEDFeb 2015Mar 2015Feb 2015Mar 2027
75BY025-012DEVELOP SCOPEJun 2012Aug 2012Jun 2012Aug 2012
76BY025-012PRELIMINARY DESIGNAug 2012Dec 2012Aug 2012Dec 2012
77BY025-012FINAL DESIGNDec 2012Jun 2013Dec 2012Jun 2013
78BY025-012BID AWARD AND REGISTER CONTRCTJun 2013Sep 2013Jun 2013Sep 2013
79BY025-012CONSTRUCTION TO 25%Sep 2013Jan 2014Sep 2013Jan 2014
80BY025-012CONSTRUCTION TO 50%Jan 2014May 2014Jan 2014May 2014
81BY025-012CONSTRUCTION TO 75%May 2014Sep 2014May 2014Sep 2014
82BY025-012ORIGINAL EQUIP & FURNISHINGSep 2014Dec 2014Sep 2014Dec 2014
83BY025-012SUBSTANTIAL COMPLETIONDec 2014Feb 2015Dec 2014Feb 2015
84BY025-012PUNCHLIST COMPLETE, JOB CLOSEDFeb 2015Mar 2015Feb 2015Mar 2027
85BY026-013DEVELOP SCOPEJun 2013Aug 2013Jun 2013Aug 2013
86BY026-013PRELIMINARY DESIGNAug 2013Dec 2013Aug 2013Dec 2013
87BY026-013FINAL DESIGNDec 2013Jun 2014Dec 2013Jun 2014
88BY026-013BID AWARD AND REGISTER CONTRCTJun 2014Sep 2014Jun 2014Sep 2014
89BY026-013CONSTRUCTION TO 25%Sep 2014Jan 2015Sep 2014Jan 2015
90BY026-013CONSTRUCTION TO 50%Jan 2015May 2015Jan 2015May 2015
91BY026-013CONSTRUCTION TO 75%May 2015Sep 2015May 2015Sep 2015
92BY026-013ORIGINAL EQUIP & FURNISHINGSep 2015Dec 2015Sep 2015Dec 2015
93BY026-013SUBSTANTIAL COMPLETIONDec 2015Feb 2016Dec 2015Feb 2016
94BY026-013PUNCHLIST COMPLETE, JOB CLOSEDFeb 2016Mar 2016Feb 2016Mar 2026
95BY031-017DEVELOP SCOPEJun 2017Aug 2017Jul 2021Oct 2021
96BY031-017PRELIMINARY DESIGNAug 2017Dec 2017Oct 2021Jan 2022
97BY031-017FINAL DESIGNDec 2017Jun 2018Jan 2022Jul 2022
98BY031-017BID AWARD AND REGISTER CONTRCTJun 2018Sep 2018Jul 2022Oct 2022
99BY031-017CONSTRUCTION TO 25%Sep 2018Jan 2019Oct 2022Feb 2023
100BY031-017CONSTRUCTION TO 50%Jan 2019May 2019Feb 2023Jun 2023
Previewing 100 of 40,849 rows