Data Planet Statistical Datasets: Exporting Data, Data Visualizations, Links to Data, and Citations

There are many ways to deliver data from Data Planet Statistical Datasets using the Export button located on the menu bar:

The options allow you to export data for manipulation in other programs, infographics for use in work products, and pdfs of data views, and more. 

Export Data

If you want to export the underlying data, use Excel, Delimited Text, SAS, or XML options. All of these options allow users to download the data into different programs (spreadsheets and a statistical software package) and manipulate it there. If you have used the Calculator feature to create formulas for additional data points, these data points are downloaded, as well.

The option to download to a Shapefile (only available for map views) allows users to export the map information to software that displays maps to ESRI requirements.

If you need to export data for importing into statistical software program(s), consult the documentation provided for that program. Available export formats for Data Planet Statistical Datasets include Delimited Text, Excel, and SAS, which can be imported into these common software programs, as below:

SPSS (Delimited Text and Excel)
SAS (SAS) 
STAT (Excel)

Please let us know if there are other programs you use that it would be helpful for us to export. Contact us here

 Images

There are four options for exporting the charts you create and the accompanying descriptions:

• PDF - from the Export menu
• DataSheets - by creating a DOI link that resolves to a view that can be printed (using browser or keyboard options, eg, Ctrl P) 
• Embeds - generate an embed code that can be entered in your own web applications (eg, a website, LibGuide, WordPress blog, etc.). See below for more detail.

Data Planet users can create interactive embeds of Data Planet content that can be added to your web applications – a website, a LibGuide, a WordPress blog - to enrich and enliven your own content!  Embeddable data visualizations, available via the export menu in the Data Planet data viewer, are available for all chart types in Data Planet, which include trends, rankings, pie charts, and maps. The embed feature is available for all non-rights restricted content (for any restricted content, the embed option will not appear in the Export drop-down menu). 

The Data Planet embed provides many interactive elements, including:

• Data at a glance: Users are able to hover-over the data visualization to quickly and easily see specific data points within the embed.
• Timeline updates: To see different timeframes, users can simply click and drag their mouse over the data visualization to refine or expand their dates. Additionally, users can change the timeframe of the embed by clicking the “Timeframe” option in the upper right corner of the window. From here, users will either see a drop down menu of choices or have the ability to enter specific dates using the date range widget.
• Delving into the data: Clicking “Table” will give users access to the raw data that underlies the embed visualization.
• Take the infographic and/or the data and run!: A full menu of export options is available to users, including the ability to download the data in Excel, PDF, Delimited Text, SAS, XML and PowerPoint formats.
• Citation, Citation, Citation: All citation format export options that are available on the Data Planet platform are also available within the data embeds: DataCite, APA, Chicago, MLA, RefWorks, Endnote Web, Endnote Local, and Zotero.

The embeds contain the full source information for the underlying data, including a direct link back to the data source, as well as an expandable menu detailing the source, dataset, and citation information. Clicking on the “Data Planet” logo within an embed will take authorized (and authenticated) Data Planet users directly back to the dataset within the Data Planet interface, allowing them to further investigate and manipulate the data as they choose.

We have also added a capability for embed creators to choose “static” or “dynamic” embeds, both of which offer the ineractive elements described above.

→ Selecting Static embeds ensures that all data within the embed remains the same as at the time the embed was created.

→ Dynamic embeds will update with new data as it is added to Data Planet – meaning your web application stays current with newly available or recast data.

Creating an Embed:

Log into Data Planet, select the Embed option to the right in the center tool bar (see image above). A dialog box appears:

Copy the HTML code that is generated and insert into the page source of your web application, and voila! An embed!

Export options include permanent URL links to views and/or associated data. These links differ from the Create DOI URLs in that the latest available data will be returned via the URL links if the more current date is selected whereas DOI links return to the exact view of the data at the time it was created. To explore options, open the Export icon on the center tool bar: 

Four URL link options are provided:

• Data Planet" provides a link back into the dataset selected.
• JSON, XML and Excel links return the data populating the chart you've created, allowing you to import results into your own applications.

The “Cite This” icon, circled in red below, in the center tool bar of the Data Planet interface, provides options for direct export of citations formatted for several popular style guides, as well as options for export to citation management programs.

Available options include:

• DataCite (Data Planet default format)
• APA (7^th edition)
• Chicago (17^th edition)
• MLA (8^th edition)

Click on the Quotation Marks and select your preferred format. A dialog box will open with the formatted citation. “Copy to Clipboard” and then paste into your own document.

As with all electronic reference management tools, do note that the final responsibility for the citation is yours - as the author of the paper - so be sure to review the citation created against the source style guide and/or consult faculty. For more on Data Citation formats and exports in Data Planet, click here . Note that exports for reference manager software will require manual intervention to properly format for the style manual you are using.