CSV files are great, but every now and then you have to edit them for errors or format them for the next step. You could use Excel. I’ve been using Google Sheets. However, these applications are designed for general purposes to fulfill a lot of use cases. Comma Chameleon on the other hand is made specifically to get you in and out fast, so that you can use your CSV file elsewhere.

Next CSV I get is going in here.

In most areas in the United States, lower FM frequencies are reserved for non-commercial educational broadcasting, and the rest is for commercial broadcasting. (And suddenly, radio music availability during long drives makes sense to me.) Upon this trivia nugget, Bob Baxley wondered what the distribution of frequencies looked like across various genres. With a quick scrape and a plot, here’s what he got. [Thanks, Bob]

Water levels are rising, and naturally, the coasts are feeling it. Jonathan Corum for the New York Times shows the rise in tidal flooding along the Atlantic and Gulf Coasts. Scientists think it’s going to get a lot worse fast.

The time series charts are an interesting use of dual axes. The background is mean sea level rise, and the bars are days of flooding. Most of the time, mixed units don’t work so well, but I think it works here, with labeling and varying color gradient to differentiate the two chart types placed one on top of the other.

Though far away, there’s still a lot you can see, as the NASA Earth Observatory notes:

On August 17, 2016, the Operational Land Imager (OLI) on Landsat 8 acquired an image (above) of dense smoke plumes roughly 50 kilometers (30 miles) south of Mosul. There appear to be multiple sources of fire, most likely oil wells from the Qayyarah oil field. The images in the grid below show the plumes changing direction and thickness since they were first spotted by Landsat 8 on June 14.

For a year, Stefanie Posavec and Giorgia Lupi drew data postcards and sent them to each other once a week between New York and London. Each postcard was based on data each collected during the week about their daily lives. The project is called Dear Data. Now it’s a book.

Amazon link. Get the paperback version.

R.I.P.

Last week, Facebook announced that it was making the Trending Topics section more automated. More algorithm-based. Less person-based. On Monday, the section showed a fake news story at the top of the list for several hours.

Nick Statt for the Verge on the human element:

The changes instituted on Friday didn’t throw all of that away; Facebook has been slowly stripping away the human element of Trending Topics for months now. Rather, it marked the moment Facebook decided its algorithmic approach was more favorable, or perhaps more cost-effective and less damaging. But in shifting the reins to engineers, the company has minimized the kind of news judgment typically exercised by journalists and editors. Now, just a few days later, we’re realizing just how important that human element was.

Data. Always open for interpretation.

Nick Strayer for the New York Times shows the flow of college freshman to other states for public education:

Students have long traveled across state lines to go to selective private colleges. But at public colleges, which have historically served local residents, the number of out-of-state freshmen has nearly doubled since 1986, according to data from the Department of Education.

See the full piece for in- and out-of-state numbers for your own state.

D3 is the most commonly used JavaScript library for visualization on the web, but there’s a bit of learning curve, especially for those new to programming. Peter Cook hopes to make this beginning step easier with his newly started online resource D3 in Depth.

Pair this with many, many examples and you’re set.

Hamilton is unique in its use of complex rhyming lyrics. Joel Eastwood and Erik Hinton for the Wall Street Journal algorithmically break down the lyrics into sounds and then clusters into rhyme families. I haven’t seen the musical, but this makes me want to.

The Migrations in Motion map, by Dan Majka from the The Nature Conservancy, shows modeled animal migrations in North and South America.

Researchers from University of Washington and The Nature Conservancy modeled potential habitat for 2954 species using climate change projections and the climatic needs of each species.

Using flow models from electronic circuit theory, they plotted movement routes for each species, connecting current habitats with their projected locations under climate change.

See also Fernanda Viegas and Martin Wattenberg’s wind map and Cameron Beccario’s globe, which were the inspiration for this one.

One more Olympics-related piece for the road. The New York Times used photo compositing to show a handful of critical moments for individual athletes. The above is the Laurie Hernandez’ dismount during the team event.

And, I can’t go without mentioning the Nike human chain commercial from six years years ago, which is the video version of this.

Sometimes you need a color scheme quick, and ColorBrewer is typically the de facto, but it has some limitations. You can’t just choose any color you want as a starting point, and there is a set number of color schemes. Colorgorical by Connor Gramazio on the other hand lets you set parameters and color ranges, and it spits out a scheme with perceptual differences.

The interface is a bit rough, but usable enough to get some nice colors.

Crime is up? Crime is down? It depends on who you ask and where. The Marshall Project analyzed violent crime trends over the past 40 years to show how things are moving across the country.

In the process, we were struck by the wide variation from community to community. To paraphrase an aphorism about politics, all crime is local. Each city has its own trends that depend on the characteristics of the city itself, the time frame, and the type of crime. In fact, the trends vary from neighborhood to neighborhood within cities; a recent study posited that 5 percent of city blocks account for 50 percent of the crime. That is why most Americans believe crime is worse, while significantly fewer believe it is worse where they live.

They eventually narrowed down trends to four main categories, across 68 cities.

Don’t see what you’re looking for. The data is available for download.

Missed this one from last month. Stamen announced the release of a whole lot of new terrain map tiles for around the world. Four billion of them.

The original Terrain style only covered the United States. As part of a new Knight Foundation grant, we expanded Terrain to cover the entire world. The Knight grant also funded prototyping for some totally-different new terrain styles, so to avoid confusion we are calling the this reboot of the old style “Terrain Classic.”

I don’t know if I’ll get the chance to use these any time soon, but they sure are pretty to look at.