The same 14 groceries, priced every Monday at Walmart, Target, and Safeway in Folsom.
FOLSOM, CA · HYPERLOCAL CPI
WEEK OF —
*** THANK YOU FOR READING ***
01 · The number
How grocery prices have moved since the first official week (= 100).
Starts Aug 24, 2026 (= 100). Earlier pilot weeks are in the CSV but not the index. See the revision log.
02 · The spread
The same basket at each store this week.
This week's gap between the priciest and cheapest cart, applied to your budget.
03 · The shelf
Average price across the three stores, and the change from last week.
04 · The method
Same products, same stores, every week.
Every Monday morning, from each store's own website.
Five food groups, weighted the way the official CPI weights them.
archive/listings/, so any price can be checked against the page it came from. The five official weeks before that (Aug 24 through Sept 21) have no captures.They cover all five food-at-home categories the index is weighted by (dairy and eggs, meat and poultry, produce, pantry, beverages) with everyday staples a typical household buys.
Every item is stocked in a comparable form at all three stores and is listed online for the Folsom store, so it can be priced the same way every week.
National brands are used where the exact product matters (Cheerios, Jif, Barilla, Tillamook, Coca-Cola, Starbucks); store brands where the commodity is the standard (milk, eggs, bread, carrots).
2026-10-01 Correction: Safeway cheddar, week of Sept 28, 2026, $4.19 → $4.99.
The Safeway row had been entered with Target’s price for the same item ($4.19), and the capture file
archive/listings/2026-09-28/safeway_cheddar.png held a copy of the Target listing instead of the Safeway one.
The Safeway capture from Sept 28 had been saved under the wrong file. It replaced the incorrect file on Oct 1 and shows $4.99,
the same price recorded in the two prior weeks. Effect: Safeway’s Sept 28 cart rises from $65.49 to $66.29, and the composite
index for that week from 102.3 to 102.7. No other price changed.
2026-10-01 Method questions answered on this page; no data or method change. Added short notes on why these 14 items, how prices are collected, limitations, the listing archive, and a comparison with NPR’s annual Walmart price check. No published price or index value changed.
2026-09-23 Archival capture of source listings adopted, effective Mon, Sept 28, 2026; item_id added to the schema.
Adopted today and taking effect with the collection of Monday, Sept 28, 2026: a dated screen capture of every price listing
is published in archive/listings/, all 42
observations, on the same day as the prices they support, so any published figure can be checked against the page it was
read from. Captures and prices are committed separately, minutes apart, and both timestamps are recorded by GitHub rather
than by the author. Five official weeks already published (Aug 24 through
Sept 21) precede the rule and have no captures; that boundary is separate from the pilot boundary below, and no published
price changed when the rule was adopted. The CSV gains an item_id column, a short key matching the capture
filenames (safeway_eggs, target_coke), appended last so existing columns are unchanged. Also
recorded: online prices can change more than once within a day, so each Monday reading is a snapshot of that morning rather
than the week’s price; and Target’s displayed price is its base price, with no Circle member offer applied.
2026-08-22 Collection protocol adopted; official series defined. A written protocol now fixes every item specification: brand tier, cut, and package size for both meat items; per-banana pricing (the only unit all three stores display); normalization of Safeway’s 22 oz loaf to a 20 oz equivalent; and the price-type rule under which Safeway prices are its free-membership (for U) prices. Ground beef is priced from the store-brand 1 lb 80/20 tray; chicken breast from each store’s value-pack tier, the only tier stocked at all three, so part of any cross-store chicken gap reflects pack size rather than store pricing. This affects cart levels, not the index. The official series begins with the first collection under this protocol, Monday, Aug 24, 2026 = 100.
2026-08-21 Jul 6 – Aug 17 designated the pilot phase; panel set at three stores.
During those seven weeks the meat items were not selected under a written specification, so those observations are not
like-for-like week to week. They remain published in the CSV, flagged pilot, and are excluded from the index;
the index previously shown here, computed from all pilot data with base week Jul 6, is superseded and not comparable to
the official series. Target banana rows were corrected from an inferred per-pound figure to the observed per-each price.
The pilot panel also included Bel Air, removed to avoid a potential conflict of interest for the author (see the README);
its 98 pilot observations remain published at archive/belair.csv.
Independent student project. Not affiliated with any store. Every price is the store's own public price for Folsom.