Data Update Numero Dos

The Northwest Territories has the highest rate per 100,000 population of homicide in Canada. My slice of data shows homicide rates per 100,000 population for each province and territory and the total rate per 100,000 in Canada.

My Excel Workbook contains my raw data and sample slice.

In 2016, the Yellowknife Now reported the Northwest Territories as having the highest rate of homicide in Canada. This is evident in the original dataset I have chosen.

The CBC reported that "nearly one quarter of homicide victims across Canada [are] aboriginal." I believe this adds context and depth to my assignment because there is a higher population of Indigenous nations in the Northwest Territories, Nunavut and the Yukon.

Data Update Numero Uno

http://data.vancouver.ca/datacatalogue/foodVendors.htm

ftp://webftp.vancouver.ca/OpenData/csv/street_food_vendors.csv

     For my final report, I will be using the Vancouver Food Vendors dataset. This data consists of information pertaining to the open, licensed, food trucks in the city of Vancouver. The column headings include: key, latitude, longitude, vendor type, status, business name, location and description. The "key" column heading I was immediately confused by. My original guess was that it might be the business license number. I was not sure how to go about finding the correct answer, as I did not see any clues or patterns in the data itself. It is strange because the data in this column contains both letters, numbers, that are between 2-4 digits. I proceeded to contact one of the food trucks, who also had no idea what "key" meant. I even turned to Google but did not come to a conclusion. From what I gather, it most likely has nothing to do with location, since there is already a column for latitude, longitude and location. My next step, will be to ask my peers and instructor, if that does not work, I plan on contacting the city of Vancouver. In terms of questions, I hope to answer the mysterious column category, first and foremost. I am further interested in what percentage of food trucks apply but do not receive a business license? What is the maximum number of food trucks authorized by the city? How long do these vendors on average stay in business? Why do the first 18 vendors not have a business name in this dataset? Lastly, how much has the percentage of food trucks increased over the last five years?