From a gentleman named Simon Willison, and this looks delicious: Datasette Publish: a web app for publishing CSV files as an online database. “I’ve just released Datasette Publish, a web tool for turning one or more CSV files into an online database with a JSON API. Here’s a demo application I built using Datasette Publish, showing Californian campaign finance data using CSV files released by the California Civic Data Coalition. And here’s an animated screencast showing exactly how I built it…” Are there are enough hours in the day? Find out in our next episode, THERE ARE NOT ENOUGH HOURS IN THE DAY.
Phys.org: Breaking data records bit by bit. “This year CERN’s data centre broke its own record, when it collected more data than ever before. During October 2017, the data centre stored the colossal amount of 12.3 petabytes of data. To put this in context, one petabyte is equivalent to the storage capacity of around 15,000 64GB smartphones. Most of this data come from the Large Hadron Collider’s experiments, so this record is a direct result of the outstanding LHC performance, the rest is made up of data from other experiments and backups.”
OpenDataSoft: OpenDataSoft Launches Open Data America: A Free Data Portal For Over 500 U.S. Cities. “Today, OpenDataSoft launched Open Data America, a first-of-its-kind initiative to release data portals for over 500 cities across the Unites States. OpenDataSoft’s core mission is to help governments use data to be more efficient, innovative, transparent and accountable. Open Data America was developed to give municipal officials a cutting-edge tool to help open their data, expand their community of data users and co-create innovative civic solutions.” Only cities with between 65,000 and 375,000 residents are included, so the city I’m in is too big. But this is interesting.
Library of Congress: Announcing the Library of Congress Congressional Data Challenge. “Today we launch a Congressional Data Challenge, a competition asking participants to leverage legislative data sets on congress.gov and other platforms to develop digital projects that analyze, interpret or share congressional data in user-friendly ways. ‘There is so much information now available online about our legislative process, and that is a great thing,’ said Librarian of Congress Carla Hayden. ‘But it can also be overwhelming and sometimes intimidating. We are asking citizen coders to explore ways to analyze, interpret or share this information in user-friendly ways. I hope this challenge will spark an interest in the legislative process and also a spirit of information sharing by the tech-savvy and digital humanities pioneers who answer the call. I can’t wait to see what you come up with.’ “
Digital Arts Online: Be inspired on how to present data with this brilliant online archive . “DataVizProject is a free website (currently in beta), so you can easily find an infographic that suits your data and figure out how to create one yourself – while learning the family, function, shape and input of each visualisation. For example, the Sociogram is in the ‘diagram’ family, and its function is to visualise ‘correlation’.”
Google Blog: Analyze your business data with Explore in Google Sheets, use BigQuery too. “A few months back, we announced a new way for you to analyze data in Google Sheets using machine learning. Instead of relying on lengthy formulas to crunch your numbers, now you can use Explore in Sheets to ask questions and quickly gather insights. Check it out.”
The Met: Celebrating Six Months of Open Access, plus The Met on Google BigQuery. “It’s been six months since The Met launched its Open Access initiative, which made available all 375,000+ images of public-domain works in The Met collection under Creative Commons Zero (CC0). During what is just the dawn of this new initiative, the responses so far have been incredible.” Don’t miss the bit on BigQuery!