Post by ECMPost by Richard KellyPost by tommyruffCan anybody supply a link please
Greypages has been nobbled.
I have a database circa November 2005. 477 meg for the CSV file. I
downloaded it a year ago from Mininova or similar. Torrent might still be
around somewhere. Or if you email me, I might post it online and send you
a link (not going to post it here though). Or tell me what you want to
look up and I will give you the results.
Could you let us know a little more detail on the db or torrent Please?
I don't have the .torrent file any more. I am certain it was linked to on
this very newsgroup (maybe a year ago - can't remember).
Files are called residential.csv (477 meg) and business.csv (110 meg) plus a
readme.txt file, which contains this:
Australian Phone Directory November 2005.
Released January/February 2006.
The fields are in this order:
- Record ID*
- Name
- Shop or Unit Number
- House Number
- End House Number, in the case of shops (eg: "13","-15","South Terrace")
- Street Name
- Town, City or Suburb
- Post Code
- Phone number
- Fax number
- Mobile number
- Type of entry (B = Buisness; I = Individual)
Record ID:
- First character is the first letter of the state (NT is D)
- Second character is the type of entry (B = Business; R = Residential)
- Third character is what area it is in (C = City [metro]; O = Other
[regional])
This database is dated November 2005. The fields are separated by tabs.
There are two files, one has all business entries, the other has all
residential entries. If you want to search the database, I suggest you
import the database into SQLite, MySQL or similar. It will take up a *lot*
of space, and it will take some time to import all the data. Do not use a
traditional spreadsheet program (like Microsoft Excel or OpenOffice.org
Calc) to import the data - it will not fit.
The indexes have been removed to save space. They tripled the size of this
archive. Seeing as most people will be importing this into another database
solution to use, this shouldn't be a problem.
Private (silent) phone numbers may not be listed, but Telstra and Sensis are
hopeless, so this may not be the case!
In the residential entries, entry NRO0580940 is corrupt. The letter "J" has
been replaced with a new line character. Look for "OHNSTON: H", if you've
already imported it into a database - this contains the rest of the record.
This is due to errors in the source files.
Remember to play nice. Long live DtMS. Anyone who adds their name to this
archive, or takes credit for this file's release is a little fucktard kiddy.
They should go and do their own fucking research, go and get their own copy
of the data source, and then work on cracking the original software
themselves. If you feel the need to take the credit where it's not
deserved, then you really need to go kill yourself right now, because
honestly, it should take someone no more than a week to break. Same applies
if you feel the need to sell this.