About this Dataset

Active Business Licenses In Providence

ATTENTION: This dataset is no longer being updated.

List of active business licenses in the City of Providence as issued by the Board of Licenses. This dataset lists the primary license issued as well as all other licenses held under the primary. Entertainment licenses are listed separately.
Organization: City of Providence
Last updated: 2020-11-12T12:32:07.726656
Tags: licensing, neighborhood

Tables

Table 1

@usgov.city_of_providence_active_business_licenses_in_providence.table_1

41.22 kB
1 row
55 columns

CREATE TABLE table_1 (
  "bus_lic_id" BIGINT,
  "lic_number" VARCHAR,
  "dba" VARCHAR,
  "expiration_date" TIMESTAMP,
  "permit_date" TIMESTAMP,
  "last_fee" BIGINT,
  "primary_license" VARCHAR,
  "primary_lic_desc" VARCHAR,
  "primary_lic_legal" VARCHAR,
  "primary_lic_purpose" VARCHAR,
  "city_state" VARCHAR,
  "amusement_center" BIGINT,
  "bingo" BIGINT,
  "employment_agency" BIGINT,
  "entertainment" BIGINT,
  "expansion_of_premises" BIGINT,
  "n_1_4_extended_hours" BIGINT  -- 1-4 Extended Hours,
  "food_dispenser" BIGINT,
  "frozen_desserts" BIGINT,
  "junk_shop" BIGINT,
  "laundry_dry_cleaning" BIGINT,
  "class_a_liquor" BIGINT,
  "class_b_limited_liquor" BIGINT,
  "class_b_tavern" BIGINT,
  "class_bv_food_and_liquor" BIGINT,
  "class_c_neighborhood_bar" BIGINT,
  "class_d_social_club" BIGINT,
  "class_e_pharmacy" BIGINT,
  "class_ed_restaurant_in_certain_areas_of_the_city" BIGINT,
  "class_f_one_day_beer_and_wine" BIGINT,
  "class_j_convention_center" BIGINT,
  "class_rbh_hotel_room" BIGINT,
  "bx_rider_2am_closing" BIGINT,
  "edx_rider_2am_closing" BIGINT,
  "class_n_night_club" BIGINT,
  "class_t_theatre" BIGINT,
  "mechanical_device" BIGINT,
  "motor_vehicle_repair" BIGINT,
  "parking" BIGINT,
  "pawnbroker" BIGINT,
  "revolsale" BIGINT,
  "second_hand_auto_sales" BIGINT,
  "second_hand_store" BIGINT,
  "petroleum_storage" BIGINT,
  "sunday_holiday_sales" BIGINT,
  "tavern1" BIGINT,
  "tavern3" BIGINT,
  "tobacco" BIGINT,
  "valet" BIGINT,
  "yard_sale" BIGINT,
  "location" VARCHAR,
  "address" VARCHAR,
  "zipcode" VARCHAR,
  "notes" VARCHAR,
  "geolocation" VARCHAR
);