Department of Agriculture
Enterprise Data Inventory - Volume and composition over time
Milestone 21 - November 30th 2018
OMB Review Has Not Begun: OMB has not begun reviewing the agency for this milestone. The review will begin after the milestone date.
Leading Indicators
These indicators are reviewed by the Office of Management and Budget
| Review Status | |
|---|---|
| Reviewer | |
| Last Updated |
Assessment Summary
| Status | Indicator | Automated Metrics |
|---|---|---|
| Overall Progress this Milestone | ||
| Inventory Updated this Quarter | ||
| Number of Datasets | ||
| Number of APIs | ||
| Bureaus represented | ||
| Percentage of bureaus represented | ||
| Programs represented | ||
| Percentage of programs represented | ||
| Number of public datasets | ||
| Number of restricted public datasets | ||
| Number of non-public datasets | ||
| Percentage growth in records since last quarter | ||
| To what extent is your agency’s Enterprise Data Inventory (EDI) complete? | ||
| What steps have you taken to ensure your Enterprise Data Inventory is complete | ||
| Agency provides a public Enterprise Data Inventory on Data.gov | ||
| Agency provided updated Enterprise Data Inventory to OMB | ||
| License specified | Crawl details | |
| Number of datasets with redactions | ||
| Percent of datasets with redactions |
| Status | Indicator | Automated Metrics |
|---|---|---|
| Overall Progress this Milestone | ||
| Number of Datasets | Crawl details | |
| Number of Collections | Crawl details | |
| Number of datasets not contained in a collection | Crawl details | |
| Number of Public Datasets with File Downloads | Crawl details | |
| Number of APIs | Crawl details | |
| Number of public APIs | Crawl details | |
| Number of restricted public APIs | Crawl details | |
| Number of non-public APIs | Crawl details | |
| Total number of access and download links | Crawl details | |
| Quality Check: Links are sufficiently working | Crawl details | |
| Quality Check: Accessible links | Crawl details | |
| Quality Check: Redirected links | Crawl details | |
| Quality Check: Error links | Crawl details | |
| Quality Check: Broken links | Crawl details | |
| Quality Check: Percentage of download links in correct format as specified in metadata | Crawl details | |
| Quality Check: Percentage of download links in HTML | Crawl details | |
| Quality Check: Percentage of download links in PDF | Crawl details | |
| Percentage growth in records since last quarter | ||
| Valid Metadata | Crawl details | |
| /data exists | Crawl details | |
| Provides datasets in human-readable form on /data | ||
| /data.json | Crawl details | |
| Harvested by data.gov | ||
| Number of public datasets | Crawl details | |
| Number of restricted public datasets | Crawl details | |
| Number of non-public datasets | Crawl details | |
| Percent growth of public datasets | ||
| Percent growth of restricted public datasets | ||
| Percent growth of non-public datasets | ||
| Percent datasets licensed as U.S. Public Domain | ||
| Percent datasets licensed as Creative Commons Zero | ||
| Percent datasets with other licenses | ||
| Percent datasets with no license |
| Status | Indicator | Automated Metrics |
|---|---|---|
| Overall Progress this Milestone | ||
| Description of feedback mechanism delivered | Crawl details | |
| Data release is prioritized through public engagement | ||
| Provided narrative evidence of data improvements based on public feedback this quarter | ||
| Feedback loop is closed, 2 way communication | ||
| Link to or description of Feedback Mechanism | ||
| Provides valid contact point information for all datasets |
| Status | Indicator | Automated Metrics |
|---|---|---|
| Overall Progress this Milestone | ||
| Data Publication Process Delivered | Crawl details | |
| Information that should not to be made public is documented with agency's OGC | ||
| Describe the agency's data publication process |
| Status | Indicator | Automated Metrics |
|---|---|---|
| Overall Progress this Milestone | ||
| Open Data Primary Point of Contact | ||
| POCs identified for required responsibilities | ||
| Chief Data Officer (if applicable) |
Automated Metrics
These metrics are generated by an automated analysis that runs every 24 hours until the end of the quarter at which point they become a historical snapshot
data.json
| Expected Data.json URL | http://www.usda.gov/data.json (From USA.gov Directory) |
|---|---|
| Resolved Data.json URL | https://www.usda.gov/data.json |
| Number of Redirects | 1 redirects |
| HTTP Status | 200 |
| Content Type | application/json |
| Valid JSON | Valid |
| Detected Data.json Schema | federal-v1.1 |
| Datasets with Valid Metadata | 100%(1504 of 1504) |
| Valid Schema | Valid |
| Datasets | 1504 |
| Number of Collections | 1 |
| Number of datasets not in a collection | 1482 |
| Datasets with Distribution URLs | 91.5% (1376 of 1504) |
| Datasets with Download URLs | 77.6% (1167 of 1504) |
| Total Distribution URLs | 3234 (but only 455 accessible) |
| Total Download URLs | 2426 |
| Total APIs | 16 |
| Public APIs | 16 |
| Restricted Public APIs | 0 |
| Non-public APIs | 0 |
| Public Datasets | 1306 |
| Restricted Public Datasets | 3 |
| Non-public Datasets | 195 |
|
The fields below serve as quality assurance to verify that the download links included within the metadata are functioning properly |
|
| Server Not Found | 41.9% (1354 of 3234) |
| Working links (HTTP 2xx) | 14.1% (455 of 3234) |
| Broken links (HTTP 4xx) | 13.0% (421 of 3234) |
| Error Links (HTTP 5xx) | 0.1% (3 of 3234) |
| Redirected Links (HTTP 3xx) | 31.0% (1001 of 3234) |
| Correct format | 73.8% (336 of 455) |
| PDF for raw data | 1.3% (6 of 455) |
| HTML for raw data | 70.5% (321 of 455) |
| Bureaus Represented | 17 |
| Programs Represented | 31 |
| License Specified | 87.0% (1309 of 1504) |
| Datasets with Redactions | 0.0% (0 of 1504) |
| Redactions without explanation (rights field) | 0.0% (0 of 1504) |
| File Size | 4.38MB |
| Last modified | Friday, 16-Nov-2018 10:41:14 EST |
| Last crawl | Thursday, 29-Nov-2018 06:50:45 EST |
| Analyze archive copies | Analyze archive from 2018-11-30 |
| Nearby Daily Crawls | |
| Expected /data URL | http://www.usda.gov/data (From USA.gov Directory) |
|---|---|
| Resolved /data URL | https://www.usda.gov/topics/data |
| Redirects | 2 redirects |
| HTTP Status | 200 |
| Content Type | text/html; charset=UTF-8 |
| Last modified | Thursday, 29-Nov-2018 01:00:36 EST |
| Last crawl | Thursday, 29-Nov-2018 04:01:53 EST |
| Expected /digitalstrategy.json URL | http://www.usda.gov/digitalstrategy.json (From USA.gov Directory) |
|---|---|
| Resolved /digitalstrategy.json URL | https://www.usda.gov/digitalstrategy.json |
| Redirects | 1 redirects |
| HTTP Status | 200 |
| Content Type | application/json |
| Valid JSON | Valid |
| Last modified | Friday, 16-Nov-2018 10:41:27 EST |
| Last crawl | Thursday, 29-Nov-2018 04:01:53 EST |
Date specified: Wednesday, 11-Dec-2013 06:42:19 EST
Date of digitalstrategy.json file: Friday, 16-Nov-2018 10:41:27 EST1.2.4 Develop Data Inventory Schedule - Summary
Summarize the Inventory Schedule
Over the past several months, the USDA has focused its Open Data efforts on establishing a framework to enhance, enrich, and open, to the extent practicable, its Enterprise Data Inventory (EDI) and to ensure the Department and its component Agencies are prepared to identify, correctly document, and submit to the Office of Management and Budget (OMB) on November 30, 2014 a comprehensive EDI. In so doing, the USDA has already achieved several internal milestones that lay the groundwork for the Department's future Open Data efforts and position the USDA to meet OMB's Open Data requirements. The following milestones are among the Department's recent Open Data achievements:
1.2.5 Develop Data Inventory Schedule - Milestones
| Title | Milestone 1 - Expand and Open EDI |
|---|---|
| Description | |
| Milestone Date | February 28, 2014 |
| Description of how this milestone expands the Inventory | The USDA will initially focus on expanding and opening its Enterprise Data Inventory. To this end, the Open Data Council, in collaboration with Agency CIOs, Data Stewards, and the Open Data Working Group (ODWG), will continue to work with the USDA's Privacy Officers to identify, prioritize and submit additional public, non-public, and restricted-public datasets to the Department. In addition, the ODC and ODWG will continue the development of an Open Data process and guidance that expedite the publication of its datasets in the future. At the end of Q1, the USDA will submit an updated EDI to OMB. |
| Description of how this milestone enriches the Inventory | |
| Description of how this milestone opens the Inventory |
| Title | Milestone 2 - Enrich EDI and Public Datasets |
|---|---|
| Description | |
| Milestone Date | May 31, 2014 |
| Description of how this milestone expands the Inventory | Over the second quarter, from February 28 to May 31, the USDA and its component agencies will continue to input into its EDI additional datasets. The Department will also continue to collaborate with its Data Stewards to update its customer feedback and outreach efforts. At the end of Q2, the USDA will submit an updated EDI to OMB. |
| Description of how this milestone enriches the Inventory | |
| Description of how this milestone opens the Inventory |
| Title | Milestone 3 - Expand, Enrich, and Open EDI |
|---|---|
| Description | |
| Milestone Date | August 30, 2014 |
| Description of how this milestone expands the Inventory | In the third quarter of the Open Data effort, the USDA will review and analyze its current dataset inventory, publication process, and customer feedback mechanisms. The results of the analysis will inform whether the Department needs to adjust its Open Data strategy and will help the Department prioritize the submission and release of its datasets in Q4. At the end of Q3, the USDA will submit an updated EDI to OMB. |
| Description of how this milestone enriches the Inventory | |
| Description of how this milestone opens the Inventory |
| Title | Milestone 4 - Perform Quality Assurance and Submit Complete EDI to OMB |
|---|---|
| Description | |
| Milestone Date | November 1, 2014 |
| Description of how this milestone expands the Inventory | Customer Feedback |
| Description of how this milestone enriches the Inventory | |
| Description of how this milestone opens the Inventory |
1.2.6 Develop Customer Feedback Process
Describe the agency's process to engage with customers
1.2.7 Develop Data Publication Process
Describe the agency's data publication process
The Department of Agriculture (USDA) implemented a four step data publication process.* This multi-step dataset review process involves multiple internal stakeholders such as Data Stewards, Chief Information Officers, Privacy Officers, agency legal staff, and Information Security System Program Managers, Records Managers, and Controlled Unclassified Information managers. The purpose of this multi-perspective approach is to ensure that datasets are adequately reviewed and approved prior to release.