SELECT count(1) as cnt, substr(comment, 0,30) as abbrev_comment FROM [jyang:fcc_ecfs.17108_comments] GROUP BY abbrev_comment order by cnt DESC LIMIT 1000000
That the contents are identical doesn't mean that real different people didn't send them.
It is OK to think that US citizens should have a more direct, democratic say in the power structures that control the internet. But FCC comments can never be a good vehicle for this. To those currently upset at the FCC over the rollback of an Obama era rule, I would invite you to critically consider what parts of the communications acts are actually constitutional and whether photons superimposed across state lines should fall under the scope of the interstate commerce clause or the bill of rights.
> SELECT COUNT(*) FROM [jyang:fcc_ecfs.17108_comments] WHERE comment LIKE "The FCC's Open Internet Rules (net neutrality rules) are extremely important to me.%"
> SELECT COUNT(*) c, SUBSTR(comment, 0, 100) pre FROM [jyang:fcc_ecfs.17108_comments] GROUP BY pre ORDER BY c DESC LIMIT 10;
2 1,359,677 In 2015, Chairman Tom Wheelers Federal Communications Commission (FCC) imposed restrictive Title II
3 1,283,663 Before leaving office, the Obama Administration rammed through a massive scheme that gave the federa
4 958,487 The current FCC regulatory scheme known as "Title II" represents an unprecedented increase in govern
5 818,815 The unprecedented regulatory power the Obama Administration imposed on the internet is smothering in
6 657,153 As a concerned taxpayer and consumer, I am writing to urge the FCC to set the internet free and remo
7 531,981 The Obama-era FCC regulations known as "Title II" enable the federal government to exert an extraord
8 452,764 I am in favor of strong net neutrality under Title II of the Telecommunications Act. Sincerely, Ma
9 450,914 The Open Internet rules (net neutrality) are extremely important to me. I don't want the ISP to have
10 380,872 I am in favor of strong net neutrality under Title II of the Telecommunications Act. Sincerely, Jo
There's also a table of throwaway email addresses and a view called "frequency_and_unique_comment_by_domain".
Consider getting a throwaway Google account, BigQuery's basically unusable without one.
