6 ms·
Looking at the leak others have pointed to, there are a surprising number of people working in a particular imaginary company: sqlite> select company, coun
by banana_giraffe 6y ago
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
- kaminar 6y agoHow 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.
- edoceo 6y agoCouldadone w/o the name calling. Generally frowned upon, site guidelines and all
- CRConrad 6y agoProbably used more as an honorific.
- 2bitencryption 6y ago> 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-billion-users.html https://www.nytimes.com/2017/10/03/technology/yahoo-hack-3-b...
- uyt 6y agoCan you link me to where you found the data?
- banana_giraffe 6y agohttps://news.ycombinator.com/item?id=26682774 https://news.ycombinator.com/item?id=26682774
- dr_kiszonka 6y agoIn the US, are there any legal repercussions for accessing such data? I wouldn't want to get into any trouble.
- flycaliguy 6y agoYou won’t get in trouble but trust your gut if you’re just curious.
- bredren 6y agoMay be test users. Iirc, the Flinstones were common test users.
- dunham 6y agoWhat's the count of people who elected not to enter their company?
- banana_giraffe 6y agosqlite> select count(*) from usa where length(company) = 0; 22209703 sqlite> select count(*) from usa; 32315270
- b212 6y agoCould 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!
- banana_giraffe 6y agoSuper hacky python script I used to turn the text files into a sqlite database: https://pastebin.com/gBWhCVGz https://pastebin.com/gBWhCVGz
- kuyan 6y agoThanks, this worked for me! Here's my contribution; I tweaked your script a little for memory usage. https://pastebin.com/4hA8VACe https://pastebin.com/4hA8VACe
- shazzdeeds 6y agoThanks. 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 https://pastebin.com/AxY5PeDQ
- datavirtue 6y agoTry Ultra Edit, free trial. It can read and search massive text files without crashing. Quite responsive.on 10GB files.
- knolan 6y agoFirstly 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.
- bobbylarrybobby 6y agoI 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.
- 6y ago
- gbear605 6y agoI 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.
- znpy 6y agoFake name, of course. I deleted my account when Facebook started asking for is verification of my name, that was absolutely unacceptable.
- devenblake 6y agoTeens 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.
- userbinator 6y agohttps://en.wikipedia.org/wiki/Krusty_Krab https://en.wikipedia.org/wiki/Krusty_Krab Probably SpongeBob fans.
- devenblake 6y agoI 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.
- yaml-ops-guy 6y agoI wouldn't call any of them SpongeBob "fans". There’s over 70k of them, how can you be so certain?
- cable2600 6y agoSpongeBob 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.
- techmagus 6y agoI 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.
- dhosek 6y agoBefore I deleted my Facebook account, it said I was chief sciolist at the Theodore J. Kaczynski Institute of Technology.
- itronitron 6y agoThere 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 https://www.youtube.com/watch?v=q7Ufkf0YVAk&t=290s