to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
How much has it cost to buy a typical can of Campbell's Condensed Tomato Soup since it was first produced sometime in 1897?
For the latest in our coverage of Campbell's Tomato Soup prices, follow this link!
Our latest project, in which we've documented the actual prices at which American consumers could buy a Number 1 can of the iconic product in each month since 1897 at discounted sale prices from their local grocers as documented in their ads in local newspapers, is incomplete, but we have enough data to provide the overall picture of the price history of a product that has been a top seller among all grocery items sold in the United States almost from its very introduction to the U.S. market.
The chart below reveals the data that we do have spanning the period from January 1898 through June 2015 and its trailing twelve month moving average, while also explaining just what we mean by a "typical" can!
Bonus Update: We've updated the price data through January 2021 in a new article, which includes filling in many of the missing months of data detailed below!
Here's the same information again, but this time, with the vertical axis changed to be in logarithmic scale and without the can trivia.
Although we suspect that some of our readers might like us to produce a chart showing this data after it has been adjusted for inflation, we would point out that those readers have missed the entire point of why anyone would document the actual prices that consumers paid for a single consumer product over 117+ years of its history - especially a product with the price history we've revealed....
We're just rolling out the visualization of the data we have available today - we're not finished building the dataset yet! When we do finish however, we'll have solid data spanning the entire 20th century and the 21st century to date that can provide some really intriguing insights into the economic history of the U.S. Not to mention a database that can be tapped to explore the price history of other grocery items, which we'll make available after we've filled in as much missing data as we can.
Our primary focus has been to identify the discounted sale price of Campbell's Condensed Tomato Soup - the price that Americans who might be casual or frequent shoppers at their local grocers or supermarkets would pay, without any manufacturer's coupons, reward programs, or other special requirements, such as a discounted price that would apply only if the consumer's bill reached a particular threshold or if the purchase of other items was required.
We also focused on the "regular", "Number 1" or "picnic"-size can of Campbell's Condensed Tomato Soup that has been continuously produced since J.T. Dorrance first formulated Campbell's condensed soup in 1897. Campbell's had been producing non-condensed tomato soup that it sold in a quart-size can for a number of years before its condensed soup version was brought to the market, which was also advertised in late 19th and early 20th centuries, and which was ultimately replaced by the condensed version, which would feed the same number of people (after water and heat was added, of course!)
Other than the size of the can, almost nothing about Campbell's Condensed Tomato Soup has been a constant over the food's history. Everything about it has changed incrementally over time: the tomatoes, the recipe, the can, the label, where its made - everything about it has been tweaked or adjusted in some way in an extraordinarily competitive and challenging business and economic environment.
And yet, it is as much of a constant as we suppose anything made by and for people can be, because of all that!
We would like to request your assistance to help fill in the missing months where we don't yet have a documented source to reference the price of the regular/typical/picnic/10 oz./10.5 oz. or 10.75 oz. tin/can of Campbell's Condensed Tomato Soup. Here is the list of months we're missing, starting with those in the 19th century:
During our project, we believe we found the first advertisement that ever appeared for Campbell's Condensed Tomato Soup, which appeared in a local newspaper as the product was first being introduced to what would prove to be a key growth market. Curiously, the grocer's ad omits the name of the famous soupmaker, but provides enough information to identify the product, while subsequent advertisements for the grocer would appear to confirm the mysterious condensed soupmaker's identity as the Campbell company!
We have data spanning each month of the next 95 or so years before we began running into blanks in the available archive data we were accessing:
While we could easily interpolate the missing data, we would very much rather be able to directly cite actual sources for the information we don't yet have - particularly where we have consecutive months of missing data during periods of significant changes in prices.
Nearly all of the missing data occurs during the last 20 years, with the biggest gaps concentrated in the period from 2000 through 2009. As it happens, this period coincides with the decline of the newspaper industry in the United States, which might partially account for the disappearance of many of the newspapers where grocers had previously advertised their product sales.
Beginning in mid-2009 however, we're grateful for the rise of "extreme couponing" as a pastime for a number of American consumers that, along with blogging, has proven invaluable for documenting in real time the kind of discounted price data we were seeking as part of this project.
Our primary sources comprise a number of library archives of microfilmed newspapers that have been digitized and, thanks to automated optical character reading technology, are also searchable - including the Library of Congress' Chronicling America, Newspapers.com, NYS Historic Newspapers, and the Town Crier of Tewksbury-Wilmington, North Carolina.
Beyond that, we extracted discounted price data from a number of coupon bloggers and discussion forums, including Springs Bargains, Hot Coupon World, Common Sense with Money, Hip2Save, Wild for Wags, and the Krazy Coupon Lady!
Image Source: Pacific Northwest National Laboratory.
Labels: data visualization, food, inflation, soup
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.