10 ms·
The top comment on Reddit r/netsec's corresponding coverage has mirrors on Mega.co.nz for the files [1] I couldn't find my own data in the set, and actually it
by antimatter15 13y ago
The top comment on Reddit r/netsec's corresponding coverage has mirrors on Mega.co.nz for the files [1]
I couldn't find my own data in the set, and actually it seems like lots of entire area codes are missing.
Assuming `cat schat.csv | uniq | cut -c1-4 | wc -l` is the proper command, there are only 76 of 322 [2] US area codes represented.
It appears there are two Canadian area codes represented in the database: 867 and 204. There are also 248 US area codes which are not represented in the database. Assuming a relatively uniform distribution of phone numbers in the US (which is not at all a safe assumption), the average US snapchat user has better odds of not being in the list than being in it. Sampling from the set of my snapchat friends who are not in my area code, 3 of 13 can be found in the database.
If your phone number is in any of these states, you're not in the database: Alaska
Delaware
Hawaii
Kansas
Maryland
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Mexico
North Carolina
North Dakota
Oklahoma
Oregon
Rhode Island
Utah
Vermont
West Virginia
Wyoming
[1] http://www.reddit.com/r/netsec/comments/1u4xss/snapchat_phone_number_database_leaked_46_million/ http://www.reddit.com/r/netsec/comments/1u4xss/snapchat_phon...
[2] I'm matching a regex against this list http://en.wikipedia.org/wiki/List_of_North_American_Numbering_Plan_area_codes#United_States http://en.wikipedia.org/wiki/List_of_North_American_Numberin...
- fudged71 13y agoThe only Canadian area codes are for Manitoba and the Far North. Not so bad :)
- bcj 13y agoOn the grand scale yes. For those of us in Manitoba (or presumably, the far north), there's not too much solace in that fact.
- dbarlett 13y agoI think you meant cat schat.csv | cut -c1-4 | uniq | wc -l
- antimatter15 13y agoOops. That's actually what I ran but I typed the wrong command I to the text box.
- chmars 13y agoIt had never occurred to me that cell phone operators would use area codes. In my small home country, there is basically one 'area code' per cell phone operator. First lesson learnt in 2014! :)
- jimminy 13y agoIn my experience in the US, the carriers/operators have an area code or two, but it's in the local area code rather than regional area code. 10-digit example: XXX - YYY - zzzz The leaked data area codes are represented by the regional/XXX block and the carriers are in the local/YYY block in the 10-digit example.
- techsupporter 13y agoAll phone numbers in the North American Numbering Plan (NANP) are allocated first as area codes by region and then by prefix for smaller locations. Some states, like Wyoming, have a single area code (307) while metro areas, like Houston, can have multiple area codes (713, 281, 832, 346) all covering the same physical place. This is a holdover of calling party pays so that a caller will know where a given phone number "lives." This distinction has become less visible with the advent of local number portability and nationwide mobile roaming. (The NANP covers Canada, the Northern Mariana Islands, the United States, and a large list of island nations in the North American area.)
- HNLogInsSuckAss 13y agoIt's even better: The U.S. is so stupid that you have to enter the area code that you're calling, even when your phone is within the same area code.
- arrrg 13y agoThat doesn’t just apply to small countries. I was also unaware that mobile phone numbers could have area codes and I’m from Germany (where each mobile operator has one three digit code – but even that is becoming meaningless with legally required number portability from operator to operator).
- 13y ago
- mgulaid 13y agoHere is a video of guy hacking SnapChat and finding out Mark Zuckberg's logging info like phone#, email. The video was posted on Dec 26th. How come they did not fix this.. https://www.youtube.com/watch?v=JEWugKX98P0 https://www.youtube.com/watch?v=JEWugKX98P0
- deleted 13y ago[deleted]
- mfreeman451 13y ago1.805.250.1351
- eli 13y agoWhat purpose does posting that serve? I think we've already pretty clearly established the flaw is real. What does intruding on the personal life of an unrelated person have to do with it? Do we really need rules saying "don't post other people's non-public personal details" like Reddit? Someone needs to tell you that?
- samstave 13y agozucks cell#? probably want to delete that.
- elwell 13y agorung for a minute then it ended on his side (no voicemail set up).
- igorgue 13y agoYou guys are huge cock suckers... You just upvoted a database leaking millions of people's phone number but when somebody posts Zuck's phone number... Oh no! You should delete that. He's not a king guys.
- eli 13y agoHN is not a monolith. You are implying hypocrisy where none necessarily exists. The leaked database: doesn't have full phone numbers and I don't think it should have been posted either -- I didn't upvote it. Nobody should have their personal contact details posted against their wishes. I do not particularly care about Mark Zuckerberg.
- frik 13y agoSnapchat devs explained how to create the database on Dez 27th: Theoretically, if someone were able to upload a huge set of phone numbers, like every number in an area code, or every possible number in the U.S., they could create a database of the results and match usernames to phone numbers that way. http://blog.snapchat.com/post/71353347590/finding-friends-with-phone-numbers http://blog.snapchat.com/post/71353347590/finding-friends-wi... omg
- cupcake-unicorn 13y agoUm..yeah..I just noticed that. That's REALLY embarrassing for them.
- wrongc0ntinent 13y agoI submitted that blog post here because it was so irritating. I wasn't daring anyone to do anything and had nothing to do with snapchatdb.
- dahlberg 13y agoIt's also worth noting that some states have partial coverage. For example, all the area codes in Massachusetts are missing from the list, with the exception of "857" and "617" (both Boston area codes) but the latter is incorrectly labeled as "Southern Michigan".
- whalesalad 13y agoBummer that Hawaii is not in the DB. For once I was actually hoping to see my data leaked somewhere aside from the Adobe incident. Dangit.