This dataset is second in a series I am doing which is aimed at translating data originating from the Thai government OpenData portal into English so that it can be utilized by the wider international audience.
Thai average monthly household income by province compiled with data obtained from the National Statistical Office through the Thai Government OpenData portal. The raw value in Thai Baht (THB) was converted into USD using historical exchange rate for each year sourced from OANDA. The original dataset contained the average monthly household income by province and regions (THB) in 2-year intervals from 1998 to 2015, with back to back data for 2006 and 2007. The raw dataset was scrubbed, removing regional averages and redundant Thai language fields. Growth/decline rates were calculated for each year pair and for between 2000 and 2015. The processed data was then joined to the geometric polygon shapefile of provincial boundaries sourced from the Geo-Informatics and Space Technology Development Agency (GISTDA).
The values for Bueng Kan Province is zero for entries before 2011, having previously been part of Nong Khai Province until its establishment in 2011. Alternatively, the pre-partition value for Nong Khai province could be used to represent both provinces in lieu of separate provincial shapefiles for pre and post-partition.
The map below shows the growth rate between 2000 and 2015, with values for each province shown in pop-up dialogs. The symbology of the map itself was limited by CARTO’s symbology options (i.e. display of decimal data as percentages).
The complete dataset including values and rate for each entry year can be found on CARTO and can be exported in multiple formats: Joined statistical data with geometry