About this Dataset

Allegheny County Supermarkets & Convenience Stores

Location information for all Supermarkets and Convenience Stores in Allegheny County was produced using the Allegheny County Fee and Permit Data for 2016.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:08:52.584879
Tags: achd-dash, convenience-store, food, grocery, social-determinants-of-health, supermarket

Tables

Supermarkets And Convenience Stores 2016 Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_superm_b9323c35.supermarkets_and_convenience_stores_2016_data

54.94 kB
672 rows
12 columns

CREATE TABLE supermarkets_and_convenience_stores_2016_data (
  "client_id" VARCHAR,
  "name" VARCHAR,
  "legal_name" VARCHAR,
  "start_date" TIMESTAMP,
  "street" VARCHAR  -- Street #,
  "street_name" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "accuracy" DOUBLE,
  "category" VARCHAR
);