search

mccgr / abn_lookup

Code for creating tables containing the ABN's for companies registered with the Australian Business Register on the ABN lookup website (https://abr.business.gov.au/)
5 stars 3 forks source link

Make initial download of abn_lookup dataset #10

Closed bdcallen closed 4 years ago

bdcallen commented 5 years ago

@iangow This issue is for the initial download of the abn_lookup data into the database

bdcallen commented 5 years ago

@iangow After running the program process_abn_lookup_xml.R on the transformed xml files last night, it seems the program ran successfully to completion. 

SELECT COUNT(*) FROM abn_lookup.abns

yielded 14412861 records, which is roughly what I was expecting since most of the files that I saw processed yesterday had around 720000 records each, and there are twenty initial original xml files.

bdcallen commented 4 years ago

@iangow This is similar to a previous issue I just closed. So closing now

iangow commented 4 years ago

Good that we're cleaning things up.