October 2019 Data Snapshot

Friday, November 1, 2019

In the October 2019 data snapshot, you will find news, updates, tips and other relevant information to Iowa's data program including:

  • What is Data Sharing?
  • The Powerful Case Statement
  • Getting Data
  • Scheduling Data Updates
  • Story Templates
  • Data Asset Summary
  • Data Resources Available
  • State Data Plan

News, Updates & Tips

What is Data Sharing?

Data sharing is the act of preparing your agency data for use by someone else (i.e., another agency, citizen, researcher), and transmitting those data. Reuse happens when someone else uses the data collected and prepared by your agency.

Benefits of data sharing:

  • New explorations of data can support wider conversations, provide new insights and generate new conclusions.
  • Allows others to replicate and confirm existing findings - builds trust.
  • Reduces data collection costs, and minimizes duplication of effort.

Constraints of data sharing:

  • Privacy and confidentiality - deidentification or anonymization is not fool proof, and data use agreements can be time consuming.
  • Cultural - data sharing can feel like giving your work away, and give rise to concerns regarding misuse.

We have the infrastructure in place to make data discoverable and accessible, which are key to data sharing. However, do your data assets support reuse? More on that next month.

The Powerful Case Statement

Many times, datasets contain values that are not very meaningful to individuals outside of government and the agency publishing the data needs it changed to something more friendly to users accessing the data. Other times, you may want to derive a new column based on values in an existing column within your dataset. Having the ability to run data transforms on a dataset gives you the tools you need, but where to start? Enter the case statement. A case statement evaluates a series of values and will return a new value if it is true (e.g, if 9, return Ninth Grade). Got it? If not, don't worry - we have you covered. We have a tool that will create a case statement for you. You only need to supply the values. You can access this tool via the link below, or among our other playbooks.

Open the Case Statement Tool (DOM)

Getting Data

Ever wanted to add text or numeric data published in another dataset or filtered view into your own dataset? Is there another asset that provides reference information you need, or are you using the assest to help support datat integrity? To get started, just add a column in your dataset, and use this tool to create a transform that will search the data asset for records containing matching values and will return the data value you are interested in. You can access this tool via link below, or among our other playbooks.

Open the Get Data Tool (DOM)

Scheduling Data Updates

The Socrata Data Management Experience provides the ability to schedule data updates for datasets that were created by importing from a URL and datasets that are connected through Socrata Gateway. With recent improvements, users can now manually run schedules that have been created via the UI rather than waiting until the next scheduled run time. Read the following help article to learn more.

Read Scheduling Data in Socrata (support.socrata.com)

Story Templates

It is now possible to create new Stories based on new templates designed to meet your needs for Dashboards, Reporting, and more! Templates pre-populate your new Story page with organized content blocks and headers, helping you ensure consistent and professional presentation as you create new Story pages for your domain. Once you choose a template, its content can be interacted with just as flexibly as a normal custom Story layout. Read the following support article to learn more.

Read Story Templates (support.socrata.com)

Data Assets

The table below reports the number data assets published on the state data portal by asset type and pulic status for the portal as a whole.

Data Asset Type Public Assets Private Assets Total
Datasets 287 74 361
External References 156   156
Documents 259   259
Filtered Views 257 117 374
Charts 124 49 173
Maps 109 23 132
Measures 31 23 54
Stories 4 17 21
DataLens Pages 16 3 19
Total Assets 1,243 306 1,549

Data Resources

Access data assets available to you.

View Public Catalog

Portal Users

Total User Accounts: 136
Active Users: 24 (17.6% of total)

Note: Active Users have logged in the data portal at least once in the past month.

Data Plan

Access State Data Plan

Questions or Issues?

Please complete the Data Portal Question & Issue Form

How do you like this Month's Snapshot?

love it meh hate it

Follow Us on Twitter


Program Area
Fiscal Year
Data Snapshot

Printed from the website on January 27, 2023 at 1:58am.