About this Dataset

Allegheny County Weights And Measures Inspections

Inspections conducted by the Allegheny County Bureau of Weights and Measures. The Bureau inspects weighing and timing devices such as gas pumps, laundromat timers, parking meters, and produce scales. The Bureau also conducts price scan verifications on a regular basis to ensure consumers are being charged fairly.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:54.622744
Tags: _etl, food, gas, gas-station, government, grocery, laundromat, meters, parking, pump, retail, scale, store, supermarket, weights-and-measures

Tables

Stores

@usgov.allegheny_county_city_of_pitts_allegheny_county_weight_d6a179f9.stores

221.96 kB
3,662 rows
23 columns

CREATE TABLE stores (
  "n__id" BIGINT  -- Id,
  "store_id" BIGINT,
  "store_name" VARCHAR,
  "address" VARCHAR,
  "mailing_city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "municipality" VARCHAR,
  "corp_id" DOUBLE,
  "neighborhood" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "business_phone" VARCHAR,
  "alternate_phone" VARCHAR,
  "price_verification" BOOLEAN,
  "fuel_dispenser" BOOLEAN,
  "scale" BOOLEAN,
  "timing" BOOLEAN,
  "misc_inspection" BOOLEAN,
  "oob" BOOLEAN,
  "unit" VARCHAR,
  "shopping_center" VARCHAR,
  "new_municipality" VARCHAR
);