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 70 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 | calendar_date | |
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 | |
Unique id | unique_id | number |