Skip to main content

Advertisement

Table 7 Store and restaurant counts before and after processing, overall and by store type, 2007–2014

From: A step-by-step approach to improve data quality when using commercial business lists to characterize retail food environments

  Supermarkets and grocery stores Convenience stores Pharmacies Liquor stores General merchandise stores Limited service restaurants
Provisionally classified by SIC code 712,033 1,152,453 461,555 306,881 57,323 2,079,985
Reclassified by name 707,724 1,154,429 448,388 306,856 73,566 2,064,742
After cleaning for locational accuracy 643,306 1,038,993 424,842 286,261 69,592 2,023,032
After deduplication by name 624,845 977,178 408,979 280,473 N/A N/A
After deduplication by address 624,700 977,165 408,935 280,473 N/A N/A
Final count after cleaning and deduplication (excluding AK, HI) 621,343 972,735 407,270 278,895 60,787 2,023,032
  1. General merchandise stores were deduplicated using geographic deduplication. Count changes in the final step are due to exclusion of records in Alaska and Hawaii