News for hackers. Stuff that matters.

A comment on 533M Facebook users' phone numbers and personal data have been leaked online.

Re:533M Facebook users' phone numbers and personal data have... by banana_giraffe on Saturday April 03, 2021 @04:42PM (#26684549)
Looking at the leak others have pointed to, there are a surprising number of people working in a particular imaginary company:

    sqlite> select company, count(*) as c from usa where length(company) > 0 group by company order by c desc limit 10;
    company                                   c
    ----------------------------------------  ----------
    Self-Employed                             459119
    Facebook                                  181013
    Retired                                   71210
    The Krusty Krab                           61550
    Hollister Co.                             42304
    U.S. Army                                 39682
    Stay-at-home parent                       33095
    Walmart                                   31600
    McDonald's                                30792
    Student                                   25326
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by dhosek on Saturday April 03, 2021 @07:59PM (#26685827)
Before I deleted my Facebook account, it said I was chief sciolist at the Theodore J. Kaczynski Institute of Technology.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by itronitron on Saturday April 03, 2021 @10:55PM (#26686545)
There is a particular scene in the movie America's Sweethearts that you would enjoy. I would post a link but I haven't been able to find on youtube.

edit: found it :) >> https://www.youtube.com/watch?v=q7Ufkf0YVAk&t=290s

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by devenblake on Saturday April 03, 2021 @07:26PM (#26685648)
Teens like to say they work at the Krusty Krab for some reason. No clue why but when I had Facebook I saw it a lot on peers' accounts.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by userbinator on Saturday April 03, 2021 @07:33PM (#26685685)
https://en.wikipedia.org/wiki/Krusty_Krab

Probably SpongeBob fans.

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by devenblake on Saturday April 03, 2021 @09:39PM (#26686262)
I wouldn't call any of them SpongeBob "fans". We did grow up with SpongeBob though and SpongeBob is a common subject for Internet memes, so that might be it.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by yaml-ops-guy on Saturday April 03, 2021 @11:02PM (#26686570)
I wouldn't call any of them SpongeBob "fans".

There’s over 70k of them, how can you be so certain?

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by cable2600 on Sunday April 04, 2021 @01:52AM (#26687210)
SpongeBob was originally for adults. But adults who grew up on Nickelodeon cartoons. Kids found it funny but don't always get the jokes because they are adult humor. They had to dumb it down for the kids. Before Netflix kids watched cable TV and Nickelodeon, and made a lot of memes about SpongeBob and the Krusty Crab. Every one of them wanted to work at the Krusty Crab with SpongBob and Squidward.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by techmagus on Saturday April 03, 2021 @07:35PM (#26685692)
I associate "The Krusty Krab" to fake/secondary/tertiary/spam profiles. People I know personally and those I was able to confirm as legitimate profiles doesn't use that or any other fake information (or just leave it empty most of the time). I only see such fake information in accounts used to advertise their business in someone else's threads.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by viraptor on Saturday April 03, 2021 @08:20PM (#26685928)
Culture / group related maybe? I have barely any friends on Facebook with real work details - a lot of them are made up. Especially doctors like to keep their profession (and real names) private.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by gbear605 on Saturday April 03, 2021 @06:50PM (#26685442)
I definitely know real people (especially highschoolers or college students) who put fictional jobs in their profile. Also common is using some fake name, like that of a fictional character.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by znpy on Saturday April 03, 2021 @08:28PM (#26685960)
Fake name, of course.

I deleted my account when Facebook started asking for is verification of my name, that was absolutely unacceptable.

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by uyt on Saturday April 03, 2021 @05:00PM (#26684691)
Can you link me to where you found the data?
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by banana_giraffe on Saturday April 03, 2021 @05:01PM (#26684701)
https://news.ycombinator.com/item?id=26682774
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by dr_kiszonka on Saturday April 03, 2021 @07:26PM (#26685649)
In the US, are there any legal repercussions for accessing such data? I wouldn't want to get into any trouble.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by flycaliguy on Saturday April 03, 2021 @08:04PM (#26685850)
You won’t get in trouble but trust your gut if you’re just curious.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by b212 on Saturday April 03, 2021 @06:25PM (#26685294)
Could you please tell me how did you convert it to sqlite? I've got a huge 1 GB txt file that crashes my comp every time I try to search for myself there :( Thank you!
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by banana_giraffe on Saturday April 03, 2021 @06:37PM (#26685375)
Super hacky python script I used to turn the text files into a sqlite database:

https://pastebin.com/gBWhCVGz

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by kuyan on Sunday April 04, 2021 @12:47AM (#26686960)
Thanks, this worked for me! Here's my contribution; I tweaked your script a little for memory usage. https://pastebin.com/4hA8VACe
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by shazzdeeds on Sunday April 04, 2021 @04:04PM (#26692412)
Thanks. I tweaked the script to include an incremental printout across files and also creating an index on phone num to easily search.

https://pastebin.com/AxY5PeDQ

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by bobbylarrybobby on Saturday April 03, 2021 @07:02PM (#26685516)
I suggest using a shell program like grep (or even the search feature of less), as shell programs are notoriously good at lazily seeking through files to keep memory use low.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by knolan on Saturday April 03, 2021 @06:48PM (#26685427)
Firstly don’t do something like open it in notepad. 1GB text files are not exactly difficult to work with once you use a proper text editor or parsing tools.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by throwmusic2366 on Saturday April 03, 2021 @07:19PM (#26685607)
Does it open with Geany?

https://www.geany.org/

It's FLOSS. Available on Windows, Mac and Linux.

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by cable2600 on Sunday April 04, 2021 @01:56AM (#26687229)
I used to use Borland's Brief to edit large files. But it is commercial. There is a free version in beta here https://sourceforge.net/projects/grief/ Grief. It pages the file in and out of memory to save space.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by datavirtue on Saturday April 03, 2021 @06:45PM (#26685411)
Try Ultra Edit, free trial. It can read and search massive text files without crashing. Quite responsive.on 10GB files.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by max_hammer on Sunday April 04, 2021 @02:23AM (#26687336)
You can use `awk` for any sql like operations on file.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by swiley on Saturday April 03, 2021 @11:54PM (#26686766)
sqlight can ".read" a number of formats. It's one of the more convenient ways to do joins on ugly tables.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by dunham on Saturday April 03, 2021 @05:51PM (#26685067)
What's the count of people who elected not to enter their company?
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by banana_giraffe on Saturday April 03, 2021 @05:54PM (#26685088) 

    sqlite> select count(*) from usa where length(company) = 0;
    22209703
    sqlite> select count(*) from usa;
    32315270
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by bredren on Saturday April 03, 2021 @05:24PM (#26684877)
May be test users. Iirc, the Flinstones were common test users.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by kaminar on Saturday April 03, 2021 @09:10PM (#26686139)
How is it that NOBODY mentions suing FB for this, the single largest data breach/leak in history? Are they to be let off with zero accountability? Nerds and geeks of ycombinator, pls let us know how you feel.
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by 2bitencryption on Saturday April 03, 2021 @09:56PM (#26686337)
> the single largest data breach/leak in history?

if something sounds like a hyperbole, it probably is. In this case I believe you are mistaken, and the Yahoo breach of 2013 was the largest, with data leaked from over 3 billion accounts.

[0] https://www.nytimes.com/2017/10/03/technology/yahoo-hack-3-b...

[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by edoceo on Saturday April 03, 2021 @09:28PM (#26686213)
Couldadone w/o the name calling. Generally frowned upon, site guidelines and all
[ Parent | on HN ]
Re:533M Facebook users' phone numbers and personal data have... by CRConrad on Saturday April 03, 2021 @09:41PM (#26686276)
Probably used more as an honorific.
[ Parent | on HN ]