I need the indeces in analyzable format, i.e.
xls, from the year 2005 to 2015. The results are in HTML table/PDF format on the TI website. Can anyone link a source or write a script to scrape the data?
In the Github link there is a file acquire_data.r. It has the exact URLs for datafiles from 2010 to 2015.
Inside those zip files are XLS files. I looked at one.
You can now copy and paste and assemble the data yourself. There are earlier years here. That will get you part of what you need.
For the earlier years I went to the 2009 webpage (http://www.transparency.org/research/cpi/cpi_2009/), I selected the table in my browser, and pasted the content into a text editor. From there it should be easy to save the text editor file to a .txt file, then import to Excel as comma-delimited. In the text editor data I pasted there are actually tabs between the columns, so it shouldn't be hard.