Official Dataset
This dataset has the following 86 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| FedID | fedid | text | Federal ID assigned to each project | 0901004 1500099 SB12002 0991012 9001010 view top 100 |
| SM_Rep | sm_rep | text | Person in HWY-SM responsible for project (obligations, final closeout, etc) | scot urada kam kin sin christine yamasaki view top 100 |
| PE1_EndDate | pe1_enddate | calendar_date | Preliminary Engineering 1 (Planning) period of performance end date. Date by which the planning phase must be done to continue to receive Federal participation. | 2024-12-31T00:00:00.000 2024-09-30T00:00:00.000 2024-06-30T00:00:00.000 2017-12-11T00:00:00.000 2025-01-31T00:00:00.000 view top 100 |
| PE2_EndDate | pe2_enddate | calendar_date | Preliminary Engineering 2 (Design) period of performance end date. Date by which the design phase must be done (ROW or construction has been obligated) to continue to receive Federal participation. | 2020-10-30T00:00:00.000 2024-08-30T00:00:00.000 2019-12-31T00:00:00.000 2017-06-30T00:00:00.000 2017-09-15T00:00:00.000 view top 100 |
| ROW_EndDate | row_enddate | calendar_date | Right of Way period of performance end date. Date by which the ROW phase must be done to continue to receive Federal participation. | 2021-06-30T00:00:00.000 2020-10-30T00:00:00.000 2017-10-25T00:00:00.000 2018-09-04T00:00:00.000 2018-09-30T00:00:00.000 view top 100 |
| CON_EndDate | con_enddate | calendar_date | Construction period of performance end date. Date by which the project must be closed to continue to receive Federal participation. | 2021-06-30T00:00:00.000 2017-11-15T00:00:00.000 2020-12-31T00:00:00.000 2021-11-01T00:00:00.000 2017-10-11T00:00:00.000 view top 100 |
| SM_Status | sm_status | text | A field created to sort projects for particular reports (inactive, closeout, billing, etc). Currently not being utilized. | view top 100 |
| PODI | podi | text | Project has been chosen by FHWA Division office as a PODI (project of division initerest) project | FALSE TRUE view top 100 |
| FIN_No | fin_no | text | Financial Ineligibility Number. These are numbers assigned to projects that are non-participating due to Period of Peformance end dates expiring | fy20-014 fy18-010 fy19-019 fy17-005 fy17-006 view top 100 |
| Start_Ineligible | start_ineligible | calendar_date | The date when the ineligible period (federal non-participating period) starts for the project | 2018-07-01T00:00:00.000 2019-01-01T00:00:00.000 2020-01-01T00:00:00.000 2020-08-07T00:00:00.000 2020-02-16T00:00:00.000 view top 100 |
| End_Ineligible | end_ineligible | calendar_date | The date when the ineligible period (federal non-participating period) starts for the project | 2017-03-09T00:00:00.000 2019-01-15T00:00:00.000 2016-10-20T00:00:00.000 2017-11-12T00:00:00.000 2018-03-13T00:00:00.000 view top 100 |
| FV_Request | fv_request | text | The state has requested that the Federal division office grant final voucher | FALSE TRUE view top 100 |
| FV_Request_Date | fv_request_date | calendar_date | The date the state requested that the Federal division office grant final voucher | 2005-10-14T00:00:00.000 2004-10-20T00:00:00.000 2001-11-07T00:00:00.000 2000-11-20T00:00:00.000 1998-09-15T00:00:00.000 view top 100 |
| IslandFed | islandfed | text | The Island the project is on. This field is ONLY filled in if there is not a corresponding project in PSS | oahu hawaii maui kauai statewide view top 100 |
| County | county | text | County project? True or False. This field is only filled in if there is not a corresponding project in PSS | FALSE TRUE view top 100 |
| ContactPerson | contactperson | text | Name of contact person. This field is only filled in if there is not a corresponding record in PSS | masatomo murata ken tatsuguchi mung fa chung harry takiue melanie martin view top 100 |
| ContactOffice | contactoffice | text | Name of contact office. This field is only filled in if there is not a corresponding record in PSS | hwy-o hwy-p hwy-h hwy-l hwy-t view top 100 |
| PE1_EndDate_orig | pe1_enddate_orig | calendar_date | Original period of performance end date for PE1. If a renewal to the PE1 end date is made, this field is filled in with the date that was originally granted for PE1. | 2023-09-30T00:00:00.000 2023-06-30T00:00:00.000 2023-12-29T00:00:00.000 2023-12-31T00:00:00.000 2018-09-30T00:00:00.000 view top 100 |
| PE2_EndDate_orig | pe2_enddate_orig | calendar_date | Original period of performance end date for PE2. If a renewal to the PE2 end date is made, this field is filled in with the date that was originally granted for PE2. | 2018-03-18T00:00:00.000 2017-12-22T00:00:00.000 2019-08-13T00:00:00.000 2019-08-20T00:00:00.000 2020-06-01T00:00:00.000 view top 100 |
| ROW_EndDate_orig | row_enddate_orig | calendar_date | Original period of performance end date for ROW. If a renewal to the ROW end date is made, this field is filled in with the date that was originally granted for ROW. | 2018-03-18T00:00:00.000 2018-11-13T00:00:00.000 2020-07-17T00:00:00.000 2020-08-11T00:00:00.000 2021-11-03T00:00:00.000 view top 100 |
| CON_EndDate_orig | con_enddate_orig | calendar_date | Original period of performance end date for Construction. If a renewal to the Construction end date is made, this field is filled in with the date that was originally granted for Construction. | 2020-02-16T00:00:00.000 2020-09-23T00:00:00.000 2023-11-01T00:00:00.000 2021-06-02T00:00:00.000 2018-04-30T00:00:00.000 view top 100 |
| Recipient.Project.Number | recipient_project_number | text | Recipient project number. This is the "Project Number" as recorded in FMIS. | nh-019-1(38) stp-0100(077) br-0700(60) stp-072-1(45) ibr-083-1(59) view top 100 |
| Project.Title | project_title | text | Federal project title. This is the project Title as recorded in FMIS | various locations on oahu; con for pedestrian facilities and ada compliance statewide, planning&economic studies hi state - queen kaahumanu highway widening, phase 2, kealakehe parkway to keahole airport road (design-build) various locations, oahu, con for highway restoration various county bridges, maui, pe for br inspection & appraisal view top 100 |
| FederalProjectStatus | project_status | text | A number corresponding to the status of the project: 10=active, 11=closed, 13=withdrawn | 11 10 13 view top 100 |
| Project.Status.Description | project_status_description | text | Federal project status description. Active, Closed, or Withdrawn' | closed active withdrawn view top 100 |
| DemoID | demoid | text | The Federal Demonstration project ID. | hi003 hi001 hi021 hi010 hi014 view top 100 |
| Est.Con.Date | est_con_date | calendar_date | A date filled in by FHWA | 2012-03-01T00:00:00.000 2010-04-01T00:00:00.000 2013-01-01T00:00:00.000 2012-01-01T00:00:00.000 2010-11-01T00:00:00.000 view top 100 |
| Latest.Payment.Date | latest_payment_date | calendar_date | Date the project was most recently reimbursed for | 2024-05-28T00:00:00.000 2024-05-14T00:00:00.000 1988-04-30T00:00:00.000 1988-02-29T00:00:00.000 1981-12-31T00:00:00.000 view top 100 |
| PE.Date | pe_date | calendar_date | The date Preliminary Engineering funds were first obligated. This could refer to Planning, Design, or both. | 1983-09-01T00:00:00.000 1985-03-01T00:00:00.000 1996-09-01T00:00:00.000 1996-08-01T00:00:00.000 1952-10-01T00:00:00.000 view top 100 |
| Right.of.Way.Date | right_of_way_date | calendar_date | The date ROW funds were initially obligated, and could be ROW or pre-ROW funds. | 1952-10-01T00:00:00.000 1967-10-01T00:00:00.000 1967-06-01T00:00:00.000 1962-01-01T00:00:00.000 1963-08-01T00:00:00.000 view top 100 |
| Construction.Date | construction_date | calendar_date | The date construction funds were first obligated. | 1998-04-01T00:00:00.000 1997-09-01T00:00:00.000 1985-09-01T00:00:00.000 1992-09-01T00:00:00.000 1996-09-01T00:00:00.000 view top 100 |
| SPR.Date | spr_date | calendar_date | The date SPR funds were first obligated. | 1972-06-01T00:00:00.000 2001-02-01T00:00:00.000 1979-03-01T00:00:00.000 1993-02-01T00:00:00.000 2022-05-04T00:00:00.000 view top 100 |
| Other.Date | other_date | calendar_date | The date of obligation for any fund types not already accounted for under PE, ROW, Construction, or SPR. | 1993-09-01T00:00:00.000 2020-07-10T00:00:00.000 2008-09-22T00:00:00.000 2015-03-16T00:00:00.000 2016-09-20T00:00:00.000 view top 100 |
| Earliest.Auth.Date | earliest_auth_date | calendar_date | The first date any funds were obligated for this Federal ID | 1998-04-01T00:00:00.000 1996-09-01T00:00:00.000 1997-09-01T00:00:00.000 1983-09-01T00:00:00.000 1994-09-01T00:00:00.000 view top 100 |
| Final.Voucher.Paid.Date | final_voucher_paid_date | calendar_date | Date final voucher was granted for the project by FHWA | 1988-04-01T00:00:00.000 1988-02-01T00:00:00.000 1981-12-01T00:00:00.000 1976-02-01T00:00:00.000 1976-01-01T00:00:00.000 view top 100 |
| Obligations.Amount | obligations_amount | number | The amount of money obligated for this Federal ID | 0 200000 100000 76788 1059983.31 view top 100 |
| Expenditure.Amount | expenditure_amount | number | The total amount of money expended for this Federal ID | 0 200000 76788 80000 170000 view top 100 |
| FYExpenditure.Amount | fyexpenditure_amount | number | The amount of money expended for this Federal ID this fiscal year | 0 1130975.27 652659.97 8079.93 160799.21 view top 100 |
| Adv.Con | adv_con | number | Amount of money set aside for advance construction | 0 20900928.56 29500670.79 12422627.23 2025538.21 view top 100 |
| STIP.Ref | stip_ref | text | Filled in by FHWA. I supposed to reference STIP number, but not always clear which STIP the reference is to | fy2011 s14 fy2009 os10 fy23 os1 fy2021 os1 fy23 s19 view top 100 |
| RemarksFHWA | remarksfhwa | text | FHWA remarks in FMIS | final voucher received and processed; project closed. final voucher received and processed. project closed. 12/31/2002: e-mail received from fhwa finance office to close this project. final voucher received 6/15/2004; processed 7/12/2004. project closed. 10/26/04: final voucher received and processed; close project. view top 100 |
| RemarksState | remarksstate | text | State remarks in FMIS | 06/26/07: update estimate as a result of inactive projects review. update to release excess funds. 01/20/06: update estimate to deobligate excess funds. 06/08/07: update estimate as a result of inactive projects review. 07/09/12: project detail lines are updated to reflect the estimated project final costs. view top 100 |
| Project.End.Date | project_end_date | calendar_date | Period of performance end date as recorded in FMIS. Should match 1240. Only recorded for projects which were given an end date as of 2017 or later. | 2021-06-30T00:00:00.000 2020-12-31T00:00:00.000 2017-11-15T00:00:00.000 2024-12-31T00:00:00.000 2025-09-30T00:00:00.000 view top 100 |
| SumOfFedMoneyRemaining | sumoffedmoneyremaining | number | Sum of federal money remaining | 0 1059983.31 1717672.8 160000 1251697.54 view top 100 |
| FinalDispositionLogDate | finaldispositionlogdate | calendar_date | The date the final disposition log was completed | 2007-11-09T00:00:00.000 2015-08-20T00:00:00.000 2021-09-30T00:00:00.000 2013-03-28T00:00:00.000 2020-11-23T00:00:00.000 view top 100 |
| ProjectTitle | projecttitle | text | Calculated title of project | STATEWIDE, PLANNING&ECONOMIC STUDIES VARIOUS COUNTY BRIDGES, MAUI, PE FOR BR INSPECTION & APPRAISAL VARIOUS LOCATIONS, OAHU, CON FOR HIGHWAY RESTORATION VARIOUS COUNTY OF HAWAII BRIDGES, BRIDGE INSPECTION & APPRAISALS RTE H-1 MIDDLE ST.TO PELE ST., INSTALL MEDIAN BARRIER view top 100 |
| MaterialCertStatus | materialcertstatus | text | Material certification status. Words describing where the letter of material certs is in the closeout status. Based on information entered in the lab module of the database | District hasn't requested Issued 3/23/2013 Issued 12/17/2007 Issued 12/24/2007 Issued 3/25/2008 view top 100 |
| ResponsiblePerson | responsibleperson | text | Responsible person associated with project | randall haraguchi mung fa chung clifford corpuz dts-ty fukumitsu albert chung view top 100 |
| UAStatus | uastatus | text | Utility agreement status. Words describing where the utility agreement is in the closeout process. Based on dates entered in the disposition log by construction | Not Applicable All Agreements Complete Incomplete Agreements view top 100 |
| ROWInfo | rowinfo | text | Right of Way info | Not Applicable Not Available ROW Complete ROW pending w/ est. completion of Unknown ROW pending w/ est. completion of 12/31/2024 view top 100 |
| Final_Con_Acceptance_Date | final_con_acceptance_date | calendar_date | Date final construction acceptance was issued for state and county projects | 2014-05-09T00:00:00.000 2019-09-09T00:00:00.000 2015-12-16T00:00:00.000 2014-11-28T00:00:00.000 2020-07-08T00:00:00.000 view top 100 |
| As_Built_Date_Filled_District | as_built_date_filled_district | calendar_date | As built date filed to distrit | 2007-11-09T00:00:00.000 2015-11-24T00:00:00.000 2010-08-30T00:00:00.000 2014-12-16T00:00:00.000 2015-10-09T00:00:00.000 view top 100 |
| Office | office | text | Office associated with project | hawaii ccoh kauai maui com view top 100 |
| PercentComplete | percentcomplete | text | Percentage of work complete | 100 0 99 98 90 view top 100 |
| NTPDate | ntpdate | calendar_date | Notice to proceed date for both State and County Projects. For contracts bid on prior to October 1, 2018 the NTP date and Start Date were synonomous and indicate the start of the contract time. After October 1, 2018 the NTP date does not indicate | 2014-06-23T00:00:00.000 2005-03-07T00:00:00.000 2000-07-17T00:00:00.000 2013-01-07T00:00:00.000 2009-08-26T00:00:00.000 view top 100 |
| ProjectNumber | projectnumber | text | Calculated project number | br-0700(60) nh-019-1(38) er-19(005) stp-072-1(45) ibr-083-1(59) view top 100 |
| ProjectID | projectid | text | Unique ID assigned to each project. Assigned by HWY-SM based on JAs processed by HWY-SM. All projects beginning with charge codes 1, 2 or 6 are included. Others are included by request. | 0011-1001-D1C1 0011-1002-D1C1 0011-1005-D1C1 0011-1015-D1C1 0011-1020-P1 view top 100 |
| CurrentPhase | currentphase | text | Current Phase of Project (Planning, Design, Construction, ROW or County) | Construction Design County Planning Right of Way view top 100 |
| ProjectStatus | projectstatus | text | Project Status. For Construction: 1 is active, 2 is closeout, 3 is archived. For Design, Planning, and ROW, 1 is programmed, 2 is active, 3 is archived, and 4 is cancelled. For County projects, 1 is programmed, 2 is design, 3 is active construction, 4 is construction closeout, 5 is archived, and 6 is cancelled | 3 2 5 1 4 view top 100 |
| FiscalCloseoutPending | fiscalcloseoutpending | text | If this is true, the project is still in fiscal closeout. If this is false and the project is archived, this project is completely closed out. | FALSE TRUE view top 100 |
| DESIGN_project_status | design_project_status | text | 1 = Programmed, 2 = Active, 3 = Archived (went to construction) , 4 = Cancelled or indefinately deferred | 3 2 4 view top 100 |
| CONSTRUCTION_project_status | construction_project_status | text | Construction project status: 1: Active, 2: Closeout, 3: Archived (Done at district, fiscal closeout may still be pending) | 3 1 2 view top 100 |
| ROW_project_status | row_project_status | text | Project status for Right of Way project. 1 is programmed, 2 is active, 3 is archived (ROW complete), and 4 is cancelled or indefinitely deferred | 3 2 4 view top 100 |
| Branch | branch | text | Branch that completed work | #N/A# hwy-o hwy-h hwy-m hwy-k view top 100 |
| County Project? | iscountyproject | text | Is the project a county project? True or False | FALSE TRUE view top 100 |
| CalculatedSubstantialComplete | substantialcomplete | calendar_date | Calculated Substantial completion date. If Substantial Completion date is entered in PSS, it uses that one. Otherwise, it checks other fields to predict whether a project is complete even if a substantial completion date is not entered. | 2024-12-31T00:00:00.000 2021-06-30T00:00:00.000 2024-06-30T00:00:00.000 2022-12-31T00:00:00.000 2014-10-13T00:00:00.000 view top 100 |
| MatchFed | matchfed | text | This field is used for determining which PSS project is used for Federal listings if there is more than 1 PSS project with the same Federal ID. If it is true, this PSS project will be used for the Federal Listing. If it is false, it will not. | TRUE FALSE view top 100 |
| POPDate | popdate | calendar_date | Period of performance date (latest of all the period of performance dates set) | 2021-06-30T00:00:00.000 2020-12-31T00:00:00.000 2017-11-15T00:00:00.000 2024-12-31T00:00:00.000 2025-09-30T00:00:00.000 view top 100 |
| POPPhase | popphase | text | Period of performance phase. | CON PE1 ROW PE2 view top 100 |
| POPEstimatedCompletionDate | popestimatedcompletiondate | calendar_date | Period of performance estimated completion date | 2024-06-07T00:00:00.000 2022-06-30T00:00:00.000 2020-05-01T00:00:00.000 2023-12-31T00:00:00.000 2017-05-27T00:00:00.000 view top 100 |
| POPVariance | popvariance | number | Period of performance variance. The difference (in days) between the POPEstimatedCompletionDate and the POPDate. | 365 -207 245 2418 2461 view top 100 |
| POPCurrentDateVariance | popcurrentdatevariance | number | Period of performance current variance date | -1073 -1254 -2396 207 480 view top 100 |
| POPStatus | popstatus | text | Period of performance status: Needs attention, Critical, Good | Critical Good Needs Action view top 100 |
| InactiveDays | inactivedays | number | Days of inactivity | 10 24 13187 13248 15499 view top 100 |
| PriorityDate | prioritydate | calendar_date | Priority date for SHPD list. This date order is used for ordering shpd projects and is based on they type of projects and dates entered into the anticipated NEPA and the anticipated RTA in PSS. | view top 100 |
| ExtendedPhase | extendedphase | text | Extended Phase | Closed Project Closed Design Construction Active Construction Closeout view top 100 |
| CurrentStatus | currentstatus | text | Current project status | Closed Project Closed Design Construction Active Construction Closeout with the following milestones left to complete: District90Day LetMatCert FinalAcceptance FinalPayment AsBuilts ConsultContract view top 100 |
| POPVarianceRank | popvariancerank | text | Period of performance variance rank | 395 246 275 522 376 view top 100 |
| text | Email for users within Highways | ian.crittenden@honolulu.gov randall.tn.haraguchi@hawaii.gov mungfa.chung@hawaii.gov clifford.a.corpuz@hawaii.gov chico.rabara@co.maui.hi.us view top 100 | ||
| NotPursuePopExt | notpursuepopext | text | True or False field for whether we are pursuing a period of performance extension for a project | FALSE TRUE view top 100 |
| PE10 | pe10 | text | Is this a PE10 project? True or False | false true view top 100 |
| OriginalPOPThisPhase | originalpopthisphase | calendar_date | Original POP date for project in current phase | 2023-09-30T00:00:00.000 2022-12-31T00:00:00.000 2020-02-16T00:00:00.000 2020-09-23T00:00:00.000 2023-12-31T00:00:00.000 view top 100 |
| PE10ReqMet | pe10reqmet | calendar_date | The date the PE10 requirement set by FHWA division office was met. The date the project was removed from the PE10 list. | 2019-08-21T00:00:00.000 2019-11-22T00:00:00.000 2018-05-02T00:00:00.000 2020-04-29T00:00:00.000 2020-05-01T00:00:00.000 view top 100 |
| PE10RepayBy | pe10repayby | calendar_date | Deadline to repay funds | 2020-02-11T00:00:00.000 2019-04-07T00:00:00.000 2019-11-14T00:00:00.000 2020-01-07T00:00:00.000 2020-01-14T00:00:00.000 view top 100 |
| PE10RepayDate | pe10repaydate | calendar_date | Date that funds were repaid | 2019-11-20T00:00:00.000 view top 100 |
| UUID | uuid | text | fbbb5fd9-1d02-49ea-a39b-69a0774a73e1 949182c0-3924-4723-ad37-1f89ba5405d8 a146b234-8af4-4780-9331-3b238de1a56d 641f806e-1550-4a64-bb9e-49d5465a0233 67300003-56ae-440e-ad03-b6f1383e686e view top 100 |