Retail Foodstores--Number and Sales, by Type: 1995 to 2005 (Statistical Abstract 2008 Table 1028)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. A few files had extraneous characters in the title. These were
   corrected to be consistent. A few files have a sheet of crufty
   gibberish in the first slot. The sheet order was shuffled but no
   data were changed.

1. The first four files have been restructured to allow full
   comprehension of the table. If you’d like to help clean up the data
   follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Notes (pg 2)

1. Estimated.
2. Includes nonfood items.
3. A grocery store, primarily self-service in operation, providing
   a full range of departments, and having at least $2.5 million in
   annual sales in 1985 dollars.
4. Contains greater variety of products than conventional
   supermarkets, including specialty and service departments, and
   considerable nonfood (general merchandise) products.
5. Contains limited product variety and fewer services provided,
   incorporating case lot stocking and shelving practices.
6. Contains a pharmacy, a nonprescription drug department, and a
   greater variety of health and beauty aids than that carried by
   conventional supermarkets.
7. A larger warehouse store that offers expanded product variety
   and often service meat, deli, or seafood departments.
8. A very large store offering a greater variety of general
   merchandise—like clothes, hardware, and seasonal goods—and
   personal care products than other grocery stores.
9. A small grocery store selling a limited variety of food and
   nonfood products, typically open extended hours.
10. A grocery store, primarily self-service in operation, selling a
    wide variety of food and nonfood products with annual sales below
    $2.5 million (1985 dollars).
11. Primarily engaged in the retail sale of a single food category
    such as meat and seafood stores and retail bakeries.

[133.6 represents 133,600. Beginning 2000 data based on North American
Industry Classification System (NAICS), 2002. All other years based on Standard
Industrial Classification (SIC) codes. See text, Section 15]

table: [20, 24]

Notes (pg 2)

• (NA) not available
• (Z) Less than 0.05 percent.

1028

2008