Scraped through first 1mil user IDs, end result was roughly 900K rows of users.
End result was so much smaller than IDs because my scrapper throws an exception if "Last active: Never" ('Never' isn't correct date format for a database).
End result was so much smaller than IDs because my scrapper throws an exception if "Last active: Never" ('Never' isn't correct date format for a database).
This is interesting but are you intending on completing it and scraping the remaining 1m accounts?
303K users last active this year (202K Brand new) this looks suspicious 
There's a lot of spambots out there and if a moderator catches them while they are still Newbie they can 'nuke' the account. This bans them and deletes all their posts which returns them to Brand New status.