September 2017 Data Snapshot

Date: 
Monday, October 2, 2017

This is e-news about data.iowa.gov - the portal where citizens can access public data. It provides relevant news from past month, highlights data published by others, gives you stats about the portal, and provides information on content published as of September 30, 2017.

News and Events

The following table highlights news from the past month, and upcoming events.

Date News/Event
09/07/2017 Revisit: What is metadata and what elements should you use? (DOM)
09/07/2017 Update: What is a Data Dictionary? (DOM)
09/07/2017 Update: What is a Glossary? (DOM)
09/08/2017 100% Stacked Bar and Column Charts and Accessibility Updates (Socrata)
09/12/2017 What data is popular? A review of 21K datasets. (Sunlight Foundation)
09/14/2017 New: What Could a Dataset for Licenses, Permits or Credentials Look Like? (DOM)

Data Highlight

Need ideas on what to publish? Below is an example of what others are publishing. A new dataset will be highlighted each month.

Jurisdiction State of Conneticut
Agency Office of the Chief Medical Examiner
Dataset Name Accidental Drug Related Deaths
Description The dataset lists accidental death associated with drug overdose in Connecticut starting in 2012.
Granularity Individual death
Information Provided Date of death, sex, gender and age of individual, city the individual resided, city of death, location of death (e.g., residenence, hospital), immediate cause, and drug associated with death.
Update Frequency Not specified

Open Data Portal Statistics

Statistics provided are from the beginning of the reported fiscal year (starting on July 1) through the date listed.

Statistic FY 2017 as of 9/30/2016 FY 2018 as of 9/30/2017 % Change Definitions
Users 7,225 16,193 124.12% Number of individuals for the fiscal year who have had one or more sessions from the preceeding July 1 to date listed.
Sessions 9,345 20,938 124.06% Number of times a user was actively engaged with the website during the fiscal year from the preceeding July 1 to date listed.
Returning Sessions 2,378 5,841 145.63% Number of sessions associated with a user who returned to the website during the fiscal year from the preceeding July 1 to date listed.
Sessions > 60 sec 2,356 5,255 123.05% Number of sessions for the fiscal year from the preceeding July 1 to date listed where the duration exceeded 60 seconds.
Sessions > 2 Pages 2,615 8,547 226.85% Number of sessions for fiscal year from the preceeding July 1 to date listed where the user visited more than two pages.
Pageviews 31,720 87,273 175.14% The total number of pages viewed for the fiscal year from the preceding July 1 to date listed. Repeated views of a single page are counted.

Monthly Top Five

The following table ranks the content that have been viewed and downloaded the most this past month across all of data.iowa.gov. It also ranks terms that have been searched the most.

Rank Viewed Downloaded Searched
1 Insurance Producers Licensed in Iowa State of Iowa Salary Book Insurance
2 Licensed Insurance Companies Iowa Liquor Sales Salary
3 Iowa Liquor Sales Insurance Producers Licensed in Iowa Iowa Liquor Sales
4 State of Iowa Salary Book Insurance Producer Business Entities Crime
5 Insurance Producer Business Entities Active Committee Address Report Crash Data

Portal Public Content

The content (e.g. datasets, maps, charts, etc.) provide resources users are looking for when they visit data.iowa.gov. The greater quantity and wider variety content we publish on the site, the greater the site's usefulness becomes. The portal totals provided below represent those owned by all state staff with a user role on the site.

Content Type Portal Total Definitions
Datasets 180 Datasets are collections of related data presented in tabular format.
Geospatial Datasets 337 Geospatial datasets are connections to GIS web service endpoints, or shapefiles that have been imported. Geospatial datasets will have corresponding map views on the portal.
External References 211 External references are links to public databases or applications offering citizens a way to explore and understand information.
Derived Views 521 Derived views are summarized views of data based on an underlying dataset. They can be charts, maps or other filtered views to help make the data more understandable.
Total Content 1,249  

Non-elected Executive Branch Agencies without public published data (i.e. datasets and geospatial datasets):

  • Iowa Civil Rights Commission
  • Banking, Division of (Commerce)
  • Drug Control Policy, Office of
  • State Public Defender, Office of
  • Public Defense, Department of
  • Homeland Security and Emergency Management
  • Public Employment Relations Board
  • Public Information Board
  • Veterans Affairs, Department of

Public Catalog on data.iowa.gov

New Public Content

The following lists new public content created in last 30 days.

Content Type Agency Content Name Creation Date
Derived Views Cultural Affairs, Department of Historical Resource Development Dollars Awarded by Type of Applicant 09/06/2017
Derived Views Administrative Services, Department of Full-time, Part-time and Temporary State Employees by Function as of August 24, 2017. 09/07/2017
Derived Views Corrections, Dept of/Parole, Board of What percentage of offenders remain out of prison three years after admitted to probation? 09/11/2017
Derived Views Corrections, Dept of/Parole, Board of What percentage of offenders remain out of prison three years after they have been released from prison? 09/11/2017
Derived Views Iowa Vocational Rehabilitation Services What percentage of individuals with disabilities are rehabilitated each federal fiscal year? 09/11/2017
Derived Views Iowa Vocational Rehabilitation Services What percentage of individuals with disabilities are rehabilitated by type of disability? 09/11/2017
Derived Views Corrections, Dept of/Parole, Board of What are the most common offenses committed by those serving prison sentences? 09/12/2017

Dataset Updates Past Due

The following lists datasets that are more than 30 days past due for an update. The update due date was based on the date the dataset was last updated and the update frequency recorded in the data's metadata. Data that is not kept current loses value to citizens.

Agency Content Name Update Frequency Date Update was Due
Auditor of State, Office of Audit Reports Every Week 08/21/2017
Blind, Department for the Successful Employment for Blind Iowans by Federal Fiscal Year Every Year 07/18/2017
Blind, Department for the Iowa Library for the Blind and Physically Handicapped Usage and Production Stats Every Year 07/18/2017
Cultural Affairs, Department of Historical Resource Development Program Grants Every Year 04/18/2017
Education, Department of Iowa School Building Directory Every Year 01/23/2016
Education, Department of Community College Expenditures By Fund and Object Code Every Year 04/07/2016
Education, Department of Community College Revenue By Fund And Object Code Every Year 04/07/2016
Education, Department of 4-Year Graduation Rates by Cohort and Public School District Every Year 06/17/2016
Education, Department of Math And Reading Proficiency by School Year, Public School District and Grade Level Every Year 08/08/2017
Ethics & Campaign Disclosure Board Campaign Expenditures Every Week 02/10/2017
Ethics & Campaign Disclosure Board Independent Expenditures For or Against State Candidates or Ballot Issues Every Month 03/04/2017
Ethics & Campaign Disclosure Board Campaign Contributions Received Every Week 02/15/2017
Ethics & Campaign Disclosure Board Other State/Federal Political Action Committee Address Report Every Week 02/17/2017
Ethics & Campaign Disclosure Board Active Committee Address Report Every Week 02/23/2017
Iowa Economic Development Authority Economic Development Projects - Under Contract Every Year 03/29/2017
Iowa Economic Development Authority Economic Development Projects - Not Proceeding Every Year 03/29/2017
Iowa Economic Development Authority Economic Development Projects - Closed Every Year 04/21/2017
Iowa Finance Authority IFA Investments by Fiscal Year, Program and County Every Year 04/24/2016
Iowa Insurance Division (Commerce) Licensed Public Adjusters Every Month 07/05/2017
Iowa Insurance Division (Commerce) Viatical Brokers Every Month 08/07/2017
Iowa Insurance Division (Commerce) Registered Retirement Facilities Every Month 08/17/2017
Iowa Veterans Home Iowa Veterans Home - Fiscal Year Revenue Sources Every Year 06/14/2017
Iowa Veterans Home Iowa Veterans Home - Average Census Every Year 07/05/2017
Iowa Veterans Home Iowa Veterans Home Current and Past Residents Every Month 10/02/2016
Management, Department of Assessed Property Values By Tax District and Year Every Year 11/20/2015
Management, Department of Taxable Property Values By Tax District and Year Every Year 01/06/2016
Management, Department of City Budget Expenditures by Fund by Fiscal Year Every Year 08/20/2016
Management, Department of Consolidated Property Tax Rates by Tax District And Fiscal Year Every Year 08/16/2017
Revenue, Department of Tax Credit Claims Every Year 02/04/2017
State Library of Iowa Total County Population by Year Every Year 07/12/2017
State Library of Iowa Total City Population by County and Year Every Year 07/12/2017
State Library of Iowa Total City Population by Year Every Year 07/12/2017
Program Area
Transparency
Fiscal Year
2018
Topic(s)
Data Snapshot

Printed from the Iowa Department of Management website on January 18, 2018 at 9:18pm.