Binny's Store-Level Availability & Pricing Dataset
Binny's is the dominant beverage retailer in Illinois, and this file captures its estate store by store — 24 columns covering price, list price, stock flag, unit inventory, pack size, city, ZIP and coordinates.
One number makes the case for store-level data: in the sample, the same product appeared at five different stores and was out of stock at every one, while its price was identical across all of them. 26 of 50 rows were unavailable at the store that listed them.
The file already exists, because this pipeline runs every day whether you buy it or not. Most vendors start collecting after you order — which is why they quote a lead time. Here the most recent file is in your account within minutes of payment, with an API key issued at the same time.
What you get, in plain terms
Four things. One chain, thirty stores, and the difference between them.
Store-level, with coordinates
Every row carries STORE_ID, STORE_ADDRESS, ZIPCODE, LATITUDE and LONGITUDE, so availability maps straight onto a trade area rather than a national average.
Unit counts, not just a flag
INVENTORY gives the number of units the store shows as available, alongside the INSTOCK flag — depth of stock, which almost no retail feed publishes.
Structured product attributes
DESCRIPTION is JSON — country, producing state, department, type, varietal, size and the retailer's item number — rather than marketing prose.
However you want it
Direct download, REST API, Amazon S3, Google Cloud, Snowflake or SFTP. The API key comes with the dataset.
Fields included in this dataset
All 24 columns, in the exact order they appear in the file — taken straight from the sample, not from a brochure. The free sample ships with a data dictionary giving an example value for each one.
Sample rows from the real file
Real rows from the sample file, not an illustration. The supplied sample has 50 store rows with all 24 columns.
Coverage
Captured every day across binnys.com. One row is one product at one store, timestamped in SCRAPED_AT.
| Metric | In the supplied sample | What it tells you |
|---|---|---|
| Rows | 50 · 35 products · 30 stores | 27 Illinois cities |
| Out of stock | 26 of 50 rows | Availability is local |
| Price consistency | Identical across stores | Chain pricing, local stock |
| Unit inventory | 0 – 41 units | 235 units across the sample |
| Price range | $3.99 – $59.99 | Median $16.99 · 5 rows unpriced |
| Producing state | IL 45 · MN 2 · NY 2 · NJ 1 | From the attributes JSON |
Only tracking a set of stores, a city or one category? Send the list and we will price a narrower file.
Historical data
The last 30 days come with the dataset. Beyond that we hold Binny's records from February 2025 onwards.
Ask about historical dataNeed more data points?
We can extend this dataset beyond the standard 24 columns — the attributes JSON flattened into columns and dose parsed from the product name are the most requested additions.
Request custom fields“Same price at every store, completely different stock. That gap is our distribution problem, and this is the first file that showed it.”
What people use this dataset for
Beverage brands and distributors
See which stores carry your SKUs, at what shelf price and with how many units left.
Category and trade marketing
Track distribution gaps store by store instead of guessing from national sell-in data.
Competitor and pricing teams
Compare dose, pack size and price against every competing line on the same shelf.
Retail analysts and investors
Follow how fast a new category builds distribution across a chain's estate.
About Binny's store-level data
Binny's Beverage Depot runs around 50 large-format stores across Illinois, from Chicago neighbourhoods to Springfield and Rockford. Its size makes it the single most important account in the state for most beverage brands.
Price is chain-wide, stock is not
Across every repeated product in the sample, the price was the same at every store while availability was not — one line was listed at five stores and out of stock at all five. Distribution gaps hide inside a chain-level average.
Attributes as JSON
DESCRIPTION carries country, producing state, department, type, varietal, size and the retailer's item number as structured JSON. The producing state alone splits Illinois-made lines from the Minnesota and New York brands sharing the shelf.
Two things to plan for
Five sampled rows had no price at all, which happens where a store lists an item it is not currently selling; INVENTORY reads 0 on the out-of-stock rows. PAGE_SAVE_ID is our internal reference to the stored copy of the page, which we strip on request.
Is collecting this data legal?
We collect only what a shopper sees on a public store page — product name, size, price, availability and the store it belongs to. No account is created, no age gate is circumvented and no personal data is touched, so the file carries no consumer records at all. These are age-restricted and, in the hemp-derived categories, state-regulated products: the data describes what retailers list, and what you may do with it depends on your own market's rules. Product names, brands and descriptions stay the property of their owners; the licence covers the compiled dataset.
