There’s so much structured data on websites that would be useful for journalists or data enthusiasts if only they could get their hands on it, like listings on online directories, real estate sites, social networks, online shopping sites and government agency landing pages.
Google Sheets is a great free tool for working with data online. Previously known as Google Spreadsheets, users can import CSV or Excel files and access it on any computer with an internet connection. The sharing options are also very powerful as multiple users can work in the same spreadsheet at once. Plus, Google’s search is great for tracking down that obscure data file created years ago.
We’re often asked how we make our interactive maps — and the answer involves knowing some code. But maps often don’t need to be interactive. You just need them to show the data — and be aesthetically pleasing. Even that little task can be overwhelming. In this post, we show how it’s done — without any code.
Matt Zagaja was one of the first people to use Hartford’s open data portal to build a web app — and he walks through the most daunting part of learning how to build a civic tool, like his: Figuring out what to learn and how to learn it.
Every few weeks, we’ll be talking through one of our projects and showing our work. The required level of technical competence will vary from week to week. This week we’re walking through the process of how we got the data for our story about the most popular Meetup groups in Connecticut.