BigQuery dataset | HackerShow

Skip to content

Data

public dataset

SHOW HN2017

BigQuery dataset

22M FCC comments on net neutrality

bigquery.cloud.google.com

#fcc comments #net neutrality #bigquery dataset #public comments analysis

How HN reacted

BigQuery dataset

Curious

points: 119
comments: 18
in 2017: Top 17%

Mostly questions and neutral comments

The thread, comment by comment

1 positive, 12 neutral or mixed, 1 critical. Score -0.04

In their words

LikedCommenters found the duplicate-comment analysis useful for spotting astroturfing

ObjectedRequires a Google account to access BigQuery

Summaries made by AI from the thread.

After the post

Loading

Shown by sajacy on Sep 6, 2017. Click the card to turn it over.

119points

18comments

#361of 2,242 in 2017

Top 17%of 2017 by points

How HN took it

CuriousMostly questions and neutral comments

1 positive, 12 neutral or asking, 0 mixed, 1 critical, out of 14 comments about the project. Thread score -0.04.

Idea: 1 for, 0 againstExecution: 0 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

Commenters found the duplicate-comment analysis useful for spotting astroturfing
From 4 comments
- Looks like there are about 255,640-460,552 truly unique (i.e. hand-written) comments roughly (1-2%). SELECT count(1) as cnt, substr(comment, 0,30) as abbrev_comment FROM…
  alexandercrohde on HN
- 1,525,564 records (6.8%) seemingly generated from https://www.battleforthenet.com/ > SELECT COUNT(*) FROM [jyang:fcc_ecfs.17108_comments] WHERE comment LIKE "The FCC's Open…
  ImJasonH on HN
- Most popular comment openings: > SELECT COUNT(*) c, SUBSTR(comment, 0, 100) pre FROM [jyang:fcc_ecfs.17108_comments] GROUP BY pre ORDER BY c DESC LIMIT 10;
  ImJasonH on HN
- Indeed, that small change brings it up to the top of the ranking! 1 | [7568642] | am in favor of strong net neutrality under Title II of the Telecommunications Act. Sincerely, 2…
  nicolas-siplis on HN

Objections

Requires a Google account to access BigQuery
From 3 comments
- I dont have a google account, can anyone re-post any of this?
  gggggggg on HN
- Here's the preview offered of the table "17108_comments", in JSON format: http://sprunge.us/CeWh There's also a table of throwaway email addresses and a view called…
  striking on HN
- All I get when opening this link is a "Welcome to BigQuery!" panel and a "Create a Project" button.
  nulagrithom on HN
Many comments are form letters, so uniqueness counts are weak evidence
From 2 comments
- Often, when members of the public are encouraged to petition for something, those doing the encouraging also provide form letters to which the petitioner just has to add their…
  willvarfar on HN
- I think they meant "hand written" as "unique", rather than "written by hand on paper and posted"? The query they show is just counting the unique first 30 chars (and would count…
  willvarfar on HN

Requests

Repost the data or a preview without needing a Google account
From 1 comment
- I dont have a google account, can anyone re-post any of this?
  gggggggg on HN

Questions

Where did the copy-pasted anti-net-neutrality comments come from
From 2 comments
- Huh, I wonder why the top negative copy+paste responses are not tied to any organization or grass-roots effort.
  losteric on HN
- Presumably they must have come from somewhere, anyone know where?
  Vintila on HN