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

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

	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

General merchandise stores were deduplicated using geographic deduplication. Count changes in the final step are due to exclusion of records in Alaska and Hawaii

ISSN: 1756-0500