Database programming

This entry is part 3 of 4 in the series Exploring data with SQL

In the last section, we populated our us_counties table and used it for some queries. Now it’s time to create some views of the data. With views we’ll be able to do more interesting things without retyping huge queries. We can use views as a foundation for more analysis. The first view we need is … Read more

Getting started with the data

This entry is part 2 of 4 in the series Exploring data with SQL

The Times’s data is here. https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv If you’re using a browser, open the context menu (right-click) on that link and use the Save Link As … operation to put it into a file on your system. We’ll use it later to load the database. Use your database interface program to log in to your database … Read more

Donald J. T***** will you please go now!

With credit to Dr. Seuss and newspaper columnist Art Buchwald: The time has come. The time has come. The time is now. Just go. Go. GO! I don’t care how. You can go by foot. You can go by cow. Donald J. T****, will you please go now! You can go on skates. You can … Read more

Choropleths: color-coded maps showing data by state or other geography

A Choropleth is a colored map, typically showing information gathered by some kind of census. A well-known example is the New York Times’s COVID-19 map. Let’s say you have some data that’s coded by geographic area. For example, you might have a table showing the number of COVID cases per 100,000 people county by county in … Read more

From around the ‘toobz: articles marking the 50th anniversary of Friedman’s article

Milton Friedman wrote an article called “The Social Responsibility of Business is to Increase Its Profits” fifty years ago. It is here. Here are some articles marking that anniversary, for reference. Some of them challenge the status quo Friedman established back then. Andrew Ross Sorkin, New York Times Tom Poldre, B Lab UK Article about … Read more

Half a century of this is enough: Friedman’s piece saying business must be irresponsible

Fifty years ago come this Sunday, on September 13, 1970, Milton Friedman (a professor of economics at The University of Chicago) published a piece in the New York Times called “The Social Responsibility of Business is to Increase Its Profits.” Invoking the socialist bogeyman, he argues that businesses should focus only on increasing their profits. … Read more

Conceived in bigotry and dedicated to the proposition that my tribe is holier than thine

“Conceived in bigotry and dedicated to the proposition that my tribe is holier than thine”. With deep apologies to President Lincoln, I fear this describes the practice of Christianity among White americans in the twenty-first century. It’s really painful to admit this. What is going on? Recently I visited a man wearing a T-shirt that … Read more

getDisplayMedia vs. getUserMedia

I’ve been messing around with the browser API navigator.mediaDevices.getDisplayMedia(). The question I hoped to answer: can I capture the content in some computer display surface and push it through the same sorts of process that I use with .getUserMedia()? I tested on Google Chrome 84. Answer: yes. It has some quirks. It doesn’t need, and … Read more