Sandy DOT Master Data | Last Updated 28 Nov 2018

This is a report for all the relevant columns of DOT - The Amount Allocated, Obligated and Paid broken down by federal agency, program, site, rouite, location, county, and municipality. It also includes Description of repair being done.

Tags: dot, sandy, sandy-master

This dataset has the following 29 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
As Of Dateas_of_datecalendar_dateAgency data is up to date as of this date
Federal Agencyfederal_agencytextFederal Agency corresponding to the State Agency. Valid value: US DOT
Funding Sourcefunding_sourcetextFederal Agency that is the funding source for the state Agency, DOT Valid value: FHWA
Program Descriptionprogram_descriptiontextShort Description of the Emergency Relief program or any new program
Project Site #project_nametextThe site # of a DOT project related to Superstorm Sandy.
Project Descriptionproject_descriptiontextA textual description of a DOT project related to Superstorm Sandy. For example: 5 = Major sinkhole repair including curb repair and repair/reconstruction of Type-B inlet storm sewer structure.
Project Typeproject_typetextThe type of project that the funds are being used for. Example: FHWA-Emergency Repairs of Roads, Traffic Lights and Bridges.
CountycountytextThis is the name of a county where a Superstorm Sandy related project was worked on. This column may have a single name of a county, a value of 'Statewide' for projects being worked on at a State level, or it will contain the value 'Multi County' for those projects that cross more than on County. A comma separated list of multiple counties relating to one project detail is in the column.
MunicipalitymunicipalitytextThis is the Municipality name or names that pertain to a particular project detail. This column may contain either one Municipality Name, multiple Municipality Names separated by commas, 'statewide', etc.
VendorvendortextVendor Name. The name of a vendor who is doing work for DOT on Superstorm Sandy-related projects(s). NPO, direct vendors
Applicantapplicant_nametextApplicant/recipient of the funds. Example: NJ DOT
RouteroutetextThe roadway generally affected by the storm.
DirectiondirectiontextThe direction of the roadway where work is occurring.
Mile Post Startmp_starttextThe mile post marker where the work begins.
Mile Post Endmp_endtextThe mile post marker where the work ends.
LocationlocationtextGeneral description of the location of the work.
Damage Descriptiondescription_of_damagetextBrief Description of the proper work done at the particular site to return damaged area to Pre-Sandy conditions.
Structure #structure_numbertextParticular Structure being worked on.
Completion Dateproject_completion_datecalendar_dateThe date when the work was completed.
FHWA Obligated Amountfhwa_oblgtd_amtnumberAmount of money the Federal Highway Administration (FHWA) has set-aside for a particular project. This amount may not include total cost, but rather reflects the amount that FHWA will reimburse for a particular project. FHWA will reimburse 80, 90 or 100% of the project costs depending upon the type of project.
Labor Amountactual_labornumberThe cost of labor for the project.
Equipment Amountactual_equipmentnumberThe cost of equipment needed for the project.
Material Amountactual_materialnumberThe cost of material needed for the project.
Total Costtotal_costnumberThe total cost of the project, including both FHWA reimbursed amounts and other costs.
Awaiting FHWA Amountawaiting_fhwa_approvalnumberMoney paid out by the New Jersey Department of Transportation in advance of the expected reimbursement from FHWA.
FHWA Reimbursement Amountfhwa_rmbrsmnt_amtnumberThe amount of money actually reimbursed by FHWA.
Actual Costagency_actual_costnumberThe amount of money actually expended by the agency administering the project. This may reflect an amount more or less than the FHWA reimbursed amount depending upon timing and the FHWA reimbursement rate.
Obligated Amountobligated_amountnumberFunds committed to this project but not yet spent
Disbursed Amountdisbursed_amountnumberMeasureable quantity for which the funds were disbursed