Well, it has been an interesting couple of hours. I’ve been pretty quiet on the NBN front in the last couple of weeks as work has been rather busy, but this deserves a special post.
For those that follow my twitter account @Monsta_AU, you may have noticed a small post earlier tonight.
Massive leak of data from
#NBNco today. Gearing up to release it later tonight after cleanup. Comes from public document published by NBNco.
Well, this is the post announcing what I have found.
Today, NBNco published an update to its DCD plan on its website in both PDF and XLS (as ZIP) formats. The DCD plan is a listing of when the Fibre Serving Area Module (FSAM, or each separate area on the NBNco Rollout Map) is completed and the timer starts on the 18 months for the disconnection of the copper phone services in that area. The PDF is fairly boring, but the ZIP file containing an XLS spreadsheet is available from http://www.nbnco.com.au/content/dam/nbnco/documents/rollout-info-irrr-dcd-09-August2013.zip, while due to the data contained within and the fact that I fully expect this data to be pulled offline around 8am Monday, I am mirroring at http://blog.themonsta.id.au/wp-content/uploads/2013/08/rollout-info-irrr-dcd-09-August2013.zip.
Upon noting this data had change via an automated checker, I downloaded the file and opened in Excel to that it contains links to a master data source. Knowing that this means there will be some cached data within the file, I started doing some massaging, and with some help from another source I was able to pull out a heap of data from the original spreadsheet. Data I am sure that management at NBNco will want to make sure is not in the public domain. Well, you guys published it in your own website.
While I have cleaned up the data, and killed a heap of columns that don’t help anybody, there’s some really interesting data in the XLSX. Like how much delay has occurred on a particular FSAM in just 5 months. But bes of all, there is a listing of a large number of FSAMs. There’s 1107 records. NBNco announced a while ago that they have designed the rollout for a million premises around the nation. It’s my educated guess that this spreadsheet is the FSAMs that contain that one million premises. The entire NBN rollout will pass around 11 million homes, so this is about 10% of the entire rollout.
There is some data in here that will upset some people, especially where some dates now being shown have commencement dates in 2018 and 2019. You will have to ask NBNco why that is. I will be sending a complete extraction of the data to various local technology journalists that I respect and trust so they can do the full analysis of the information we have then ask NBNco what is going on.
As an NBN supporter, I have mixed emotions about releasing this just weeks from a federal election that could indeed see the project scuttled by radical conservatives that seem to be driven to implement a pamphlet rather than properly costed policies. If Malcolm and Tony want to use this against the NBN, I will be here posing the inadequacies of their Fraudband policy. However by releasing this I believe the data being available in the tech community will enable debate and keep everybody honest.