Average rents for areas with a population of 10,000 and over Average rents for areas with a population of 10,000 and over 2012-12-13 2016-12-01 Canada Mortgage and Housing Corporation open-ouvert@tbs-sct.gc.ca Economics and IndustryCMHCrent DatasetCSV http://www20.statcan.gc.ca/tables-tableaux/cansim/csv/00270040-eng.zip DatasetCSV http://www20.statcan.gc.ca/tables-tableaux/cansim/csv/00270040-fra.zip DatasetXML http://www20.statcan.gc.ca/tables-tableaux/cansim/sdmx/00270040.zip Supporting DocumentHTML http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&id=00270040&p2=33 Supporting DocumentHTML http://www5.statcan.gc.ca/cansim/pick-choisir?lang=fra&id=00270040&p2=33

Average rents for areas with a population of 10,000 and over

Average rents for areas with a population of 10,000 and over


Resource Name Resource Type Format Language Links
Dataset Dataset CSV English Access
Dataset Dataset CSV French Access
Dataset Dataset XML English
Supporting Document Guide HTML English Access
Supporting Document Guide HTML French Access

Comments (6)

Hi, Is there a way to join this to a table provided by open.canada that will provide the coordinate location of the cities?

Hi Frederick, we passed that comment on to the dataset owner. If you're looking for a technological solution, the Geolocation Service API can handle that: http://www.registry.data.gc.ca/dataset/31c77624-498d-4716-837d-c26bfc22445a.

It's not clear what the "Vector" and "Coordinate" columns imply. Sample data: Vector Coordinate v42135513 192.3.1 v42135513 192.3.1 v42135513 192.3.1 v42135513 192.3.1 v42135513 192.3.1 Is this somehow related to location?

Hi Vaughn, A vector number is a unique identifier that has been assigned by the database to a time series of data. Vectors are applied for each time series so if you have 10 different time periods the vector will include 10 data points. Vectors do not change and are unique within the database so they can be used to call data. A coordinate is a unique numerical representation of the combinations of members from the table’s dimensions. It consists of a string of local IDs (also known as member IDs) separated by periods. (for example 1.2.1, 3.1.10), entered in the same order as the dimensions are loaded in a table. The coordinate is a unique number within a table but not within the database. They are used mostly for data loading purposes.

Why are there negative values for some rows? I see in the legend that "F" means unreliable data, and ".." means unavailable, that's fine. But I'm also seeing lots of entries like "-99", "-97", "-95". Those are clearly incorrect for rent values, are they some sort of internal code that should be explained in the legend?

Thank you for your comment. The following response has been posted on behalf of Canada Mortgage and Housing Corporation : "The codes with negative values essentially mean that data is not available. Specific values can indicate that the data is suppressed either to protect the confidentiality of respondents or for reasons of data reliability. They can also indicate that there is no universe or sample. The actual codes used have changed over time; however, historical revisions were not made to existing data points to replace the older codes. Users of our data will encounter the following codes: -99 = data suppressed, -98 = no universe, -97 = No sample, -96 = Not applicable, -95 = data suppressed, -94 = data suppressed, -93 = Change in rent is not statistically different than zero (0) When the CMHC Time Series system was originally developed it was done in conjunction with Statistics Canada and the system only allowed for one value to be associated with each date in the time series. More recently, Statistics Canada has changed their database to allow for individual data points to have a code to be associated with them to give further information about the individual data point. For example, a letter could be associated with the estimate to give information on the quality of the estimate. Because Statistics Canada is not our only secondary distributor of Time Series, this change was not implemented in our system because it would only apply to one distributor. Thus, we don't make use of this second code in CANSIM, which is the process we use to load data to the Open Data site. In order to make the data more transparent to our users, all time series will be reviewed to ensure that the codes are explained in the notes associated with each of our series group. It is anticipated that this will be available later 2014". Thank you.