This dataset contains all milestone information entered by Federal agencies into the Permitting Dashboard. Rows represent single milestones within an individual environmental review or authorization (action). For a full description of all fields in the dataset, see the <a href="https://www.permits.performance.gov/documentation/permits-data-dictionary-full-dataset"><font color="#0000EE">Data Dictionary</font></a>. Questions specific to the dataset can be directed to the email listed below. For questions on specific projects, please use the contact information listed on the project page on the <a href="http://permits.performance.gov"><font color="#0000EE">The Permitting Dashboard</font></a>.
This dataset has the following 69 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| Project Canonical | project_canonical | checkbox | Single record to identify distinct project records |
| Project ID | project_id | text | Unique numerical identifier of a permitting project |
| Project | project_title | text | Name of the project |
| Project Lead Agency | project_field_project_lead_agency | text | Name of the lead agency of the project |
| Project Lead Agency Bureau | project_field_project_lead_agency_bureau | text | Name of the lead agency bureau of the project |
| Project Category | project_category | text | |
| Project Status | project_field_project_status | text | Current status of the project |
| Project Sector | project_sector | text | Sector the project belongs to |
| Project Sector Type | project_sector_type | text | Type of project within the sector |
| Project Location Full Address | project_field_location_other | text | Primary location information in a single field |
| Project Location State | project_field_location_state | text | Primary location state of the project |
| Project Location Street Address | project_location_street_address | text | |
| Project Location City | project_field_location_city | text | Primary location city of the project |
| Project Location County | project_field_location_county | text | Primary location county of the project |
| Project Location Zipcode | project_field_location_zipcode | text | Primary location zipcode of the project |
| Project Pause Start | project_pause_start | calendar_date | |
| Project Pause End | project_pause_end | calendar_date | |
| Project Location Latitude | project_lat | text | Primary location latitude |
| Project Location Latlong | project_latlong | point | Primary location latitude and longtitude |
| Project Location Longitude | project_lon | text | Primary location longitude |
| Environmental and Community Outcomes Applicable Changes | environmental_and_community_outcomes_applicable_changes | text | |
| Environmental and Community Outcomes Summary | environmental_and_community_outcomes_summary | text | |
| Environmental and Community Outcomes Explanation | environmental_and_community_outcomes_explanation | text | |
| Environmental and Community Outcomes Category | environmental_and_community_outcomes_category | text | |
| Total Estimated Project Cost | total_estimated_project_cost | text | |
| Project FIN Date | project_fin_date | text | |
| Major Project | major_project | checkbox | |
| Project Original Completion Date | project_original_completion_date | text | |
| Project Url | project_url | url | |
| Project Large, Complex, or Significant | project_large_complex_or_significant | checkbox | |
| Action Canonical | action_canonical | checkbox | Single record to identify distinct project action records |
| Action ID | action_id | text | Unique numerical identifier of a permitting action |
| Action Type | action_type | text | Indicator of the type of permitting action |
| Action Status | action_status | text | Current status of the permitting action |
| Action Responsible Agency | action_agency | text | Agency responsible for the permitting action |
| Action Description | action_description | text | Additional details on the action |
| Action Agency Status | action_agency_status | text | Current status of the permitting action |
| Action Resp Agency Declined | action_agency_declined | checkbox | Indicates whether the agency declined to participate |
| Action Justification Paused Title | action_justification_paused_title | text | |
| Action Justification Paused URL | action_justification_paused_url | text | |
| Action Pause Start | action_pause_start | calendar_date | |
| Action Pause End | action_pause_end | calendar_date | |
| Action Identifier | action_identifier | text | |
| Action Outcome | action_outcome | text | |
| Action Conditional Target Date | milestone_conditional_target_date | calendar_date | |
| Dependency Action | dependency_action | text | |
| Dependency Action ID | dependency_action_id | text | |
| Milestone ID | milestone_id | text | Unique numerical identifier of a permitting action milestone |
| Milestone Type | milestone_type | text | Type of action milestone |
| Dependencies | action_milestone_dependencies | text | Indicates any dependency that a milestone is tied to within the project |
| Milestone Group | action_milestone_group | text | |
| Milestone Short Description | action_milestone_name | text | Short description of milestone |
| Milestone Details | action_milestone_details | text | |
| Milestone NA | action_milestone_na | checkbox | Indicator of whether this milestone is not applicable |
| Milestone Target Completion Date | action_milestone_completion_target | calendar_date | Anticipated date the milestone will be completed |
| Milestone Actual Completion Date | action_milestone_completion_actual | calendar_date | Actual date the milestone was completed |
| Milestone Baseline Completion Date | action_milestone_baseline_target | calendar_date | Initial date the milestone was planned to be completed |
| Dependency Milestone ID | dependency_milestone_id | text | |
| Dependency Milestone | dependency_milestone | text | |
| Action Optional Milestone | action_optional_milestone | checkbox | |
| Action Milestone Classification | action_milestone_classification | text | |
| Action Final Milestone | action_milestone_final_milestone | checkbox | |
| Action Triggering Milestone | action_triggering_milestone | checkbox | |
| Action Triggering Milestone Weight | action_triggering_milestone_weight | text | |
| Milestone Complete | action_milestone_complete | checkbox | |
| Milestone Current Target Date Value within 31 to 60 Days | milestone_current_target_date_value_within_31_to_60_days | checkbox | |
| Milestone Alternative Completion Date | milestone_alternative_completion_date | calendar_date | |
| Milestone Nonconformace Enabled | non_conformance_milestone | checkbox | |
| Last Data Fetched | last_data_fetched | calendar_date |