Data Model

Table	Rows	Columns	Period	Description
dbo.paid_occupancy	282478061	13	2012	Historic 2012 paid occupancy
dbo.paid_occupancy	280016069	13	2013	Historic 2013 paid occupancy
dbo.paid_occupancy	273862692	13	2014	Historic 2014 paid occupancy
dbo.paid_occupancy	277337742	13	2015	Historic 2015 paid occupancy
dbo.paid_occupancy	277337742	13	2016	Historic 2016 paid occupancy
dbo.paid_occupancy	277337742	13	2017	Historic 2017 paid occupancy
dbo.paid_occupancy	289433487	13	2018	Historic 2018 paid occupancy
dbo.paid_occupancy	289433487	13	2019	Historic 2019 data
dbo.paid_occupancy	277337742	13	2020	Historic 2020 data
dbo.paid_occupancy	41973487	13	2021	Delta 2021 data
dbo.date_dim	218880	3	2012	Historic 2012 date dimension
dbo.date_dim	218880	3	2013	Historic 2013 date dimension
dbo.date_dim	218880	3	2014	Historic 2014 date dimension
dbo.date_dim	218880	3	2015	Historic 2015 date dimension
dbo.date_dim	219600	3	2016	Historic 2016 date dimension
dbo.date_dim	222960	3	2017	Historic 2017 date dimension
dbo.date_dim	255437	3	2018	Historic 2018 date dimension
dbo.date_dim	254522	3	2019	Historic 2019 date dimension
dbo.date_dim	164848	3	2020	Historic 2020 date dimension
dbo.date_dim	26640	3	2021	Delta 2021 date dimension
dbo.blockface	47699	25	2021	Blockface dimension