incomplete series
Closed this issue · 1 comments
MonkmanMH commented
Today (2019-01-30) StatCan released the latest SEPH tables, with data up to November 2018 (2018-11).
https://www150.statcan.gc.ca/n1/daily-quotidien/190130/dq190130a-cansim-eng.htm
My regular script to pull the tables does not retrieve the entire table; the most recent month is 2018-09
data_SEPH1 <- get_cansim("14-10-0201-01", refresh = TRUE)
max(data_SEPH1$REF_DATE)
data_SEPH2 <- get_cansim("14-10-0203-01", refresh = TRUE)
max(data_SEPH2$REF_DATE)
data_SEPH3 <- get_cansim("14-10-0223-01", refresh = TRUE)
max(data_SEPH3$REF_DATE)
Other CANSIM series seem to work fine; I have tested CPI and NHPI tables
# CPI
# current to December 2018
# https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000402
data_CPI <- get_cansim("18-10-0004-02", refresh = TRUE)
max(data_CPI$REF_DATE)
# New Housing Price Index
# current to November 2018
# https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810020501
data_NHPI <- get_cansim("18-10-0205-01", refresh = TRUE)
max(data_NHPI$REF_DATE)
MonkmanMH commented
The problem lies with Statistics Canada--although the webpage shows the complete series up to 2018-11, the "download table" option has the data up to 2018-09.