blog.opensci.info

The latest version of the bulk PLoS Article Level Metrics data has been uploaded to Google Fusion Tables.

• Summary ALM Data
• Combined Download Statistics
• HTML Views
• PDF Downloads
• XML Downloads

Google Fusion Tables provides an API and web based access for complex queries of large data sets. The data can be exported in standard file formats such as CSV. For a guide to working with and visualizing this data see Visualize PLoS Article Level Metrics with Google Fusion Tables and Spreadsheets.

The source file used was “plos-alm-v4-11302010.xls”. The previous version was “PLoS ALM v3 05182010 Summary ALM Data” posted by PLoS.

• Introduction
  • Article Level Metrics
  • Google Fusion Tables
  • Web Based View
  • Data Updated
• Summary ALM Data
• Combined Download Statistics
• Google Fusion Tables API
  • Select
  • Limit
  • Google Spreadsheets
  • Columns
  • Sort
  • Special Characters
  • Column Reference
• Combined Download Statistics
  • Sort
  • Yearly Summary
  • Combined download sum history
    • Chart
  • Usage Breakdown
    • Top 50 90 Days
• Additional Materials

Introduction

Article Level Metrics

The Public Library of Science collects metrics for each article they publish and have uploaded uploaded it to Google Fusion Tables. Metrics collected include citations, downloads, web page views, and community response. Previously the the data was available only as an Excel XLS file from the PLoS Article Level Metrics site.

There are 5 tables available:

• Summary ALM Data
• Combined Download Statistics
• HTML Views
• PDF Downloads
• XML Downloads

Google Fusion Tables

Google Fusion Tables is a public data store that can be accessed through both a web browser and an API. Sorting, grouping, and other queries can be performed using an SQL-like query language. Query results can be exported and loaded by other data visualization tools such as Google Spreadsheets.

The Google Fusion Tables API uses an SQL-like query language to allow filtering, sorting, and aggregation. Unlike other online spreadsheet programs, large datasets up to 100mb are supported. Both web and API interfaces are available, including export to CSV. Importing into a Google Spreadsheet allows additional operations on the data and customized charting.

Web Based View

Each dataset can be viewed with the browser on Google Fusion Tables. For example, the Summary ALM Data table.

Data Updated

An updated version version of the ALM data is now available on Google Fusion Tables: PLoS Article Level Metrics on Google Fusion Tables Updated to V4.

Read the rest of this entry