About this Dataset

Weights, Measures, And Other Tests

This dataset features inspections of devices such as gasoline pumps, fuel oil meters, scales, petroleum octane ratings, and other weights and measures devices conducted by DCWP. DCWP inspects businesses to ensure compliance with the NYS Department of Agriculture's weights and measures laws.
Organization: City of New York
Last updated: 2020-11-10T17:01:20.115718
Tags: business, consumer, fuel-oil, gas-station, individual, industry, inspection, license, measurement, petroleum, scales, test

Tables

Table 1

@usgov.city_of_new_york_weights_measures_and_other_tests.table_1

850.11 kB
12,755 rows
31 columns

CREATE TABLE table_1 (
  "certificate_of_inspection" VARCHAR,
  "inspection_number" VARCHAR,
  "date_of_occurance" TIMESTAMP,
  "business_unique_id" VARCHAR,
  "business_name" VARCHAR,
  "dba_trade_name" VARCHAR,
  "business_category" VARCHAR,
  "inspection_type" VARCHAR,
  "device_category" VARCHAR,
  "device_class" VARCHAR,
  "device_type" VARCHAR,
  "devices_inspected" BIGINT,
  "devices_approved" BIGINT,
  "devices_condemned_confiscated" BIGINT,
  "address_type" VARCHAR,
  "building_number" VARCHAR,
  "street_name" VARCHAR,
  "street_name_2" VARCHAR,
  "unit_type" VARCHAR,
  "unit" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" BIGINT,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);