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 43 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| Project ID | project_id | text | Unique numerical identifier of a permitting project |
| Action ID | action_id | text | Unique numerical identifier of a permitting action |
| Milestone ID | milestone_id | text | Unique numerical identifier of a permitting action milestone |
| 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 Canonical | project_canonical | checkbox | Single record to identify distinct project records |
| 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 Location Latlong | project_latlong | point | Primary location latitude and longtitude |
| Project Location Latitude | project_lat | text | Primary location latitude |
| Project Location Longitude | project_lon | text | Primary location longitude |
| 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 Canonical | action_canonical | checkbox | Single record to identify distinct project action records |
| 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 | |
| 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 |
| Milestone Complete | action_milestone_complete | checkbox | |
| Last Data Fetched | last_data_fetched | calendar_date | |
| Action Conditional Target Date | milestone_conditional_target_date | calendar_date | |
| Major Project | major_project | checkbox | |
| Project Large, Complex, or Significant | project_large_complex_or_significant | checkbox |