City Of Vancouver | Business Licence Statistics
This dataset includes business licence records from 2013 to current year.
@kaggle.kyoungguyeo_city_of_vancouver_business_licence_statistics
This dataset includes business licence records from 2013 to current year.
@kaggle.kyoungguyeo_city_of_vancouver_business_licence_statistics
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.
This dataset includes business licence records from 2013 to current year.
The City of Vancouver publishes open data under the terms of the Open Government Licence – Vancouver.
My hope is that we will continue to work together to make our community a better place.
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
);Anyone who has the link will be able to view this.