Dataset: City Of Vancouver | Business Licence Statistics

About this Dataset

City Of Vancouver | Business Licence Statistics

Context

City of Vancouver issues about 50,000 business licenses and 100,000 permits every year. These cover everything from busking to home-based businesses to large multinational organizations, and industries ranging from entertainment to high-tech to tourism to finance. Learn more about the business licences and permits in the city of Vancouver.

Content

This dataset includes business licence records from 2013 to current year.

Acknowledgements

The City of Vancouver publishes open data under the terms of the Open Government Licence – Vancouver.

Inspiration

My hope is that we will continue to work together to make our community a better place.

Tables

Business Licences

@kaggle.kyoungguyeo_city_of_vancouver_business_licence_statistics.business_licences

29.8 MB
578197 rows
24 columns


CREATE TABLE business_licences (
  "folderyear" BIGINT,
  "licencersn" BIGINT,
  "licencenumber" VARCHAR,
  "licencerevisionnumber" BIGINT,
  "businessname" VARCHAR,
  "businesstradename" VARCHAR,
  "status" VARCHAR,
  "issueddate" VARCHAR,
  "expireddate" TIMESTAMP,
  "businesstype" VARCHAR,
  "businesssubtype" VARCHAR,
  "unit" VARCHAR,
  "unittype" VARCHAR,
  "house" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "province" VARCHAR,
  "country" VARCHAR,
  "postalcode" VARCHAR,
  "localarea" VARCHAR,
  "numberofemployees" DOUBLE,
  "feepaid" DOUBLE,
  "extractdate" VARCHAR,
  "geom" VARCHAR
);