Key Insight

From 2002 to 2021, there's a consistent upward trend in the number of properties and property tax collections across all property types in Singapore. HDB properties consistently account for the largest number of cases, indicating a significant portion of the overall property market. While property tax collections generally increase with the number of cases, variations between property types and years suggest different tax rates or valuation methods.

Small Interesting Points of Note

The number of cases for 'Others' category shows significant year to year variation. There are missing values in some columns, which might affect the analysis.

Methodology

• Data was extracted from the provided JSON response from data.gov.sg API.
• Numerical data (number of cases and property tax collection) were converted to numerical type for analysis and calculation of summary statistics.
• Trends were observed by reviewing the year-over-year changes in number of cases and property tax collection for each property type.
• Summary statistics (though limited by missing data) were calculated using available data.

Footnotes

¹Some financial year headers contained superscript values (e.g., 2011²). The superscript was removed during preprocessing. ² Several 'annual_value' and 'median_annual_value' fields contained 'na' values. These values were ignored in the analysis, potentially influencing the results.