Skip to content

Instantly share code, notes, and snippets.

@fhoffa

fhoffa/reddit.bigrams.ipynb

Last active December 22, 2015 18:29
Show Gist options
  • Save fhoffa/6512989 to your computer and use it in GitHub Desktop.
Save fhoffa/6512989 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
reddit.bigrams.ipynb
{
"metadata": {
"name": "reddit most popular bigrams"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "heading",
"level": 1,
"metadata": {},
"source": "The most popular reddit bigrams."
},
{
"cell_type": "markdown",
"metadata": {},
"source": "I wrote this query to answer a [StackOverflow question](http://stackoverflow.com/questions/18709547/find-all-two-word-phrases-that-appear-in-more-than-one-row-in-a-dataset), and wanted to share results with the reddit community :).\n\nUsing https://github.com/umbrae/reddit-top-2.5-million data in BigQuery, we'll look into each title bigram (set of 2 consecutive words in the title). We'll average how each title ranked (from 1-1000, as that's what we got in the dataset) on its own subreddit. We'll display here the top 1000 bigrams, according to how much they \"contributed\" to the ranking of the title they belong.\n\n"
},
{
"cell_type": "code",
"collapsed": false,
"input": "#bigquery imports\nimport bq\nimport datetime\nimport pandas as pd\nimport tabulate\nclient = bq.Client.Get()",
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "code",
"collapsed": false,
"input": "# The query looks only into the first 10 pairs, of sentences with more than 2 words.\n# To be able to qualify for the ranking, the bigram has to be found at least 9 times.\n\nquery = r\"\"\"SELECT pairs, COUNT(*) c, AVG(ranked)\nFROM (\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){0}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){1}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){2}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){3}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){4}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){5}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){6}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){7}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){8}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n),\n(\nSELECT REGEXP_REPLACE(lower(title), '([^\\\\s]+ ){9}([^\\\\s]* [^\\\\s]+).*', '\\\\2') pairs, title, ranked, subr\nFROM [bigquery-samples:reddit.full]\n)\nWHERE pairs != lower(title)\nAND NOT subr CONTAINS 'circlej' -- Keeping it clean, sorry.\nGROUP EACH BY pairs\nHAVING c > 8\nORDER BY 3\nLIMIT 1000\"\"\"\nfields, data = client.ReadSchemaAndRows(client.Query(query)['configuration']['query']['destinationTable'], max_rows = 1000)\nfor i, row in enumerate(data):\n data[i] = [i+1] + row\n",
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": "\rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (0s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (1s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (2s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (3s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (5s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (6s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (7s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (8s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (10s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (11s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (12s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (13s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (14s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (15s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (16s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (17s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (18s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (19s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (20s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (21s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (22s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (23s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (24s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (25s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (26s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (27s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (28s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (29s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (30s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (31s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (32s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (33s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (34s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (35s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (36s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (37s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (38s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (39s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (40s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (41s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (42s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (43s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (44s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (45s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (46s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (47s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (48s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (49s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (50s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (51s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (52s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (53s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (54s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (55s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (56s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (57s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (58s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (59s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (60s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (61s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (62s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (63s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (64s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (65s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (66s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (67s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (68s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (69s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (70s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (71s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (72s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (73s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (74s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (75s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (76s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (77s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (78s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (79s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (80s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (81s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (82s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (83s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (84s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (85s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (86s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (88s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (89s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (90s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (91s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (92s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (93s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (94s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (95s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (96s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (97s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (98s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (99s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (100s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (101s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (102s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (103s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (104s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (105s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (106s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (107s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (108s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (109s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (110s) Current status: RUNNING"
},
{
"output_type": "stream",
"stream": "stdout",
"text": " \rWaiting on bqjob_rb2bf99112496bba_00000141090aec5b_12 ... (110s) Current status: DONE "
},
{
"output_type": "stream",
"stream": "stdout",
"text": "\n"
}
],
"prompt_number": 33
},
{
"cell_type": "code",
"collapsed": false,
"input": "print tabulate.tabulate(data[0:100], headers=['bigram', 'times seen', 'average rank (0-1000)'], tablefmt='pipe')",
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": "| | bigram | times seen | average rank (0-1000) |\n|----:|:-------------------------|-------------:|------------------------:|\n| 1 | s3 lcs | 14 | 11.2857 |\n| 2 | bad trader | 9 | 15.5556 |\n| 3 | ops weapon | 11 | 26.2727 |\n| 4 | b**** manager | 24 | 30.8333 |\n| 5 | the b**** | 24 | 30.8333 |\n| 6 | weapon guides: | 36 | 35.9722 |\n| 7 | mw2 weapon | 37 | 37.3243 |\n| 8 | deadlift @ | 9 | 42.1111 |\n| 9 | [streamline edit] | 43 | 42.5349 |\n| 10 | [offer][steam] summer | 9 | 42.6667 |\n| 11 | getaway sale: | 9 | 42.6667 |\n| 12 | tonight's cheap | 12 | 53.5833 |\n| 13 | day! congratulations! | 13 | 57.5385 |\n| 14 | unfolding crisis | 20 | 61.85 |\n| 15 | updates] the | 20 | 69.25 |\n| 16 | [completed event] | 30 | 71.0333 |\n| 17 | marathon explosion | 18 | 71.2778 |\n| 18 | plus different | 14 | 71.5 |\n| 19 | ccna video | 10 | 71.9 |\n| 20 | training series, | 10 | 74.8 |\n| 21 | ian sleeping | 124 | 77.4597 |\n| 22 | infinite summer | 13 | 77.6923 |\n| 23 | weapon parts | 12 | 78 |\n| 24 | parts infographic | 12 | 78 |\n| 25 | cheap meal: | 14 | 79.2143 |\n| 26 | hawthorne, ca | 9 | 79.7778 |\n| 27 | dreamhack open: | 12 | 80.9167 |\n| 28 | j episode | 9 | 81.1111 |\n| 29 | income, and | 9 | 81.7778 |\n| 30 | hawthorne police | 11 | 83.2727 |\n| 31 | you're subreddit | 30 | 84.1333 |\n| 32 | [pv] perfume | 14 | 84.7143 |\n| 33 | [ongoing event] | 20 | 84.75 |\n| 34 | [live updates] | 31 | 88.0645 |\n| 35 | reverse climate | 10 | 89.5 |\n| 36 | won - | 10 | 91.8 |\n| 37 | (last words) | 9 | 92 |\n| 38 | from /r/gentlemanboners/ | 9 | 92.2222 |\n| 39 | are subreddit | 85 | 93.3294 |\n| 40 | [release] journey | 71 | 98.7324 |\n| 41 | gtai to | 12 | 99.0833 |\n| 42 | series j | 15 | 99.1333 |\n| 43 | some link | 11 | 99.5455 |\n| 44 | allan savory: | 9 | 100.111 |\n| 45 | the unfolding | 22 | 102 |\n| 46 | inside (please | 10 | 102.4 |\n| 47 | miss chuck | 9 | 103.111 |\n| 48 | to gtav: | 11 | 103.182 |\n| 49 | this powerful | 10 | 104.3 |\n| 50 | update thread | 40 | 105.5 |\n| 51 | head massager | 9 | 106.778 |\n| 52 | micrograph of | 9 | 107.556 |\n| 53 | : introducing | 28 | 109.071 |\n| 54 | of ian | 135 | 109.607 |\n| 55 | algorithm of | 9 | 111.333 |\n| 56 | javascript properly | 12 | 111.75 |\n| 57 | challenge accepted: | 45 | 112.467 |\n| 58 | congratulations, you | 16 | 112.75 |\n| 59 | bento for | 28 | 112.857 |\n| 60 | hayden in | 16 | 113.688 |\n| 61 | different game | 24 | 116.25 |\n| 62 | things serve | 11 | 117.545 |\n| 63 | go 1.1 | 10 | 117.8 |\n| 64 | manager from | 30 | 118.233 |\n| 65 | qi xl | 12 | 118.75 |\n| 66 | questions thread. | 15 | 119.333 |\n| 67 | seth meyers | 9 | 119.556 |\n| 68 | thread. please | 13 | 120.077 |\n| 69 | esteban winsmore | 18 | 120.111 |\n| 70 | [skyrim] the | 11 | 120.818 |\n| 71 | kde 4.10 | 10 | 121.4 |\n| 72 | asian parent | 12 | 121.583 |\n| 73 | power washing | 14 | 123.429 |\n| 74 | firefly: the | 9 | 125.222 |\n| 75 | day! congrats! | 55 | 126.018 |\n| 76 | from r/birdswitharms] | 9 | 126.778 |\n| 77 | summed up. | 9 | 127 |\n| 78 | pointers part | 11 | 127.364 |\n| 79 | artful dodger | 24 | 127.792 |\n| 80 | my fb, | 9 | 129.111 |\n| 81 | [dailygoal][to-do] day | 9 | 130.556 |\n| 82 | first bento | 13 | 131.385 |\n| 83 | bottled my | 17 | 131.706 |\n| 84 | my freckles | 23 | 132.087 |\n| 85 | [cypher] vol | 28 | 133.393 |\n| 86 | imgur user | 9 | 135.889 |\n| 87 | my homelab | 9 | 136.778 |\n| 88 | 22 rules | 12 | 136.917 |\n| 89 | finished sewing | 10 | 137.1 |\n| 90 | snl discussion | 16 | 137.312 |\n| 91 | has denounced | 15 | 138.067 |\n| 92 | free courses | 9 | 138.667 |\n| 93 | happens tomorrow | 9 | 139.222 |\n| 94 | chinese family | 9 | 139.333 |\n| 95 | bubba watson | 9 | 139.333 |\n| 96 | article claims | 17 | 140.529 |\n| 97 | [gv request] | 130 | 141.1 |\n| 98 | official playstation | 9 | 141.222 |\n| 99 | yvonne in | 10 | 141.6 |\n| 100 | russian family | 11 | 142.273 |\n"
}
],
"prompt_number": 34
},
{
"cell_type": "code",
"collapsed": false,
"input": "print tabulate.tabulate(data[100:], headers=['bigram', 'times seen', 'average rank (0-1000)'], tablefmt='pipe')",
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": "| | bigram | times seen | average rank (0-1000) |\n|-----:|:------------------------------|-------------:|------------------------:|\n| 101 | personal cupid | 9 | 142.778 |\n| 102 | started war? | 13 | 143.077 |\n| 103 | simpsons did | 32 | 143.219 |\n| 104 | gratulerer med | 12 | 143.417 |\n| 105 | beauty that | 11 | 143.455 |\n| 106 | 8, and | 11 | 143.455 |\n| 107 | properly - | 20 | 144.3 |\n| 108 | deserts and | 9 | 144.778 |\n| 109 | sucking on | 67 | 144.851 |\n| 110 | monthly reddit | 23 | 144.913 |\n| 111 | noticed our | 10 | 145 |\n| 112 | favorite foreign | 9 | 145 |\n| 113 | police who | 10 | 145.4 |\n| 114 | godspeed you | 9 | 145.444 |\n| 115 | of pointers | 13 | 145.769 |\n| 116 | : about | 9 | 145.889 |\n| 117 | the artful | 26 | 146.192 |\n| 118 | courses from | 13 | 146.769 |\n| 119 | on r/aww. | 10 | 147.6 |\n| 120 | toes on | 10 | 148.1 |\n| 121 | budgets, one | 9 | 148.333 |\n| 122 | rude removal | 9 | 148.667 |\n| 123 | citadel of | 9 | 149.556 |\n| 124 | js properly | 17 | 149.882 |\n| 125 | success story! | 13 | 149.923 |\n| 126 | yvonne and | 12 | 150.167 |\n| 127 | not cocktail | 33 | 150.242 |\n| 128 | [feedback friday] | 9 | 151 |\n| 129 | you're our | 31 | 151.065 |\n| 130 | car driving | 11 | 151.818 |\n| 131 | for noobs: | 15 | 152.333 |\n| 132 | [skyrim] a | 11 | 153.182 |\n| 133 | extra extra | 10 | 154 |\n| 134 | tree sucking | 44 | 154.25 |\n| 135 | of laughter | 11 | 154.273 |\n| 136 | pocket sand | 69 | 154.406 |\n| 137 | survivor zero | 26 | 154.769 |\n| 138 | fulfilled my | 9 | 154.778 |\n| 139 | kill dog | 10 | 155.2 |\n| 140 | show] the | 20 | 155.7 |\n| 141 | yvonne at | 9 | 155.778 |\n| 142 | archive file | 28 | 156.464 |\n| 143 | batsu game | 15 | 156.467 |\n| 144 | die die | 11 | 157.091 |\n| 145 | mads mikkelsen | 12 | 157.333 |\n| 146 | enthusiastic teachers | 10 | 157.8 |\n| 147 | of survival: | 10 | 158.2 |\n| 148 | survival: week | 10 | 158.2 |\n| 149 | emcees welcome | 34 | 158.206 |\n| 150 | all emcees | 34 | 158.206 |\n| 151 | of free, | 10 | 158.5 |\n| 152 | cards total) | 16 | 159.375 |\n| 153 | total) week | 16 | 159.375 |\n| 154 | rp codes! | 16 | 159.375 |\n| 155 | (3 cards | 16 | 159.375 |\n| 156 | codes! (3 | 16 | 159.375 |\n| 157 | tsukai - | 21 | 159.952 |\n| 158 | sale lightning | 11 | 160.273 |\n| 159 | [giveaway] summer | 11 | 160.273 |\n| 160 | lightning giveaway | 11 | 160.273 |\n| 161 | originally built | 12 | 160.5 |\n| 162 | by brenoch | 11 | 161.091 |\n| 163 | brenoch adams | 11 | 161.091 |\n| 164 | wilfred episode | 21 | 161.333 |\n| 165 | qi - | 26 | 161.346 |\n| 166 | courses (moocs) | 11 | 161.455 |\n| 167 | of hawkthorne | 96 | 161.521 |\n| 168 | ago today! | 9 | 162 |\n| 169 | ray mears | 11 | 162 |\n| 170 | we raise | 11 | 162.182 |\n| 171 | at waffle | 9 | 162.444 |\n| 172 | arrays of | 9 | 163.667 |\n| 173 | [don't upvote] | 10 | 164.4 |\n| 174 | father on | 9 | 164.556 |\n| 175 | passed icnd2 | 10 | 164.6 |\n| 176 | 3rd season | 9 | 165.444 |\n| 177 | 1000 subscribers! | 11 | 166.091 |\n| 178 | at tomorrowland | 11 | 166.182 |\n| 179 | blocking tor | 9 | 166.667 |\n| 180 | legalize marijuana. | 9 | 166.778 |\n| 181 | touches is | 11 | 167 |\n| 182 | gv request: | 9 | 167 |\n| 183 | : understanding | 9 | 167.778 |\n| 184 | requires roughly | 9 | 167.889 |\n| 185 | (ask me | 11 | 168.182 |\n| 186 | vile rat | 9 | 168.222 |\n| 187 | and mat | 9 | 168.444 |\n| 188 | live update | 28 | 168.571 |\n| 189 | commander chris | 10 | 169.2 |\n| 190 | of lessons | 26 | 169.462 |\n| 191 | swim meet | 9 | 169.778 |\n| 192 | somebody tells | 9 | 170.111 |\n| 193 | video training | 15 | 170.133 |\n| 194 | summer getaway | 14 | 170.214 |\n| 195 | men (1957) | 9 | 170.222 |\n| 196 | pamyu - | 9 | 170.889 |\n| 197 | this useful | 12 | 171.583 |\n| 198 | google chromecast | 10 | 172.4 |\n| 199 | gabe newell: | 17 | 172.471 |\n| 200 | joke my | 9 | 172.667 |\n| 201 | from amy's | 9 | 172.778 |\n| 202 | ghc head | 9 | 172.889 |\n| 203 | lcs north | 9 | 173.556 |\n| 204 | slowdive - | 22 | 174.682 |\n| 205 | empire episode | 16 | 174.812 |\n| 206 | passed ccna | 10 | 175 |\n| 207 | - tarantula | 9 | 175.111 |\n| 208 | really is... | 12 | 175.25 |\n| 209 | today's subreddit | 49 | 175.816 |\n| 210 | coursera course | 9 | 175.889 |\n| 211 | this gigantic | 12 | 176.833 |\n| 212 | reminder: monthly | 9 | 177 |\n| 213 | samples pack | 9 | 177 |\n| 214 | hecker - | 17 | 177.235 |\n| 215 | president obama. | 9 | 177.333 |\n| 216 | kitchen nightmares | 9 | 177.333 |\n| 217 | a sign. | 11 | 177.636 |\n| 218 | weapon guide: | 14 | 178 |\n| 219 | florida man's | 12 | 178 |\n| 220 | [season 1 | 13 | 178.308 |\n| 221 | tacos al | 14 | 178.643 |\n| 222 | sees this | 10 | 179 |\n| 223 | 4.6 stars | 16 | 179.188 |\n| 224 | fox news. | 10 | 179.2 |\n| 225 | member spotlight | 42 | 179.333 |\n| 226 | [arch] [xmonad] | 9 | 179.444 |\n| 227 | lena dunham's | 9 | 179.667 |\n| 228 | from r/gentlemanboners | 9 | 179.778 |\n| 229 | the beam | 13 | 180 |\n| 230 | reddit ceo | 14 | 180.214 |\n| 231 | of cards' | 10 | 180.3 |\n| 232 | sunlight in | 9 | 180.556 |\n| 233 | django 1.3 | 12 | 180.75 |\n| 234 | race was | 27 | 180.926 |\n| 235 | 4: official | 9 | 181 |\n| 236 | moronic monday | 19 | 181.053 |\n| 237 | indoor garden | 14 | 181.143 |\n| 238 | cuoco - | 32 | 181.312 |\n| 239 | bento boxes | 14 | 181.357 |\n| 240 | at fuji | 9 | 181.444 |\n| 241 | the car... | 11 | 181.545 |\n| 242 | jc penny | 11 | 182.091 |\n| 243 | that voted | 10 | 182.1 |\n| 244 | alley oop | 10 | 182.1 |\n| 245 | in turkey. | 16 | 182.188 |\n| 246 | with age. | 11 | 182.455 |\n| 247 | courses (just | 10 | 182.9 |\n| 248 | you. this | 10 | 182.9 |\n| 249 | i-5 bridge | 11 | 183.364 |\n| 250 | habits you | 18 | 183.667 |\n| 251 | snowden a | 11 | 183.727 |\n| 252 | knew nothing | 11 | 183.727 |\n| 253 | your asian | 9 | 183.889 |\n| 254 | works, but | 10 | 183.9 |\n| 255 | [contest submission] | 9 | 184.111 |\n| 256 | me had | 9 | 184.333 |\n| 257 | (left) vs. | 10 | 184.4 |\n| 258 | class we | 9 | 184.667 |\n| 259 | shameless season | 25 | 184.68 |\n| 260 | graphic i | 10 | 184.7 |\n| 261 | | raspberry | 11 | 184.727 |\n| 262 | tiy's twitter | 9 | 185.333 |\n| 263 | first built | 13 | 185.538 |\n| 264 | beats out | 10 | 185.6 |\n| 265 | punk | | 14 | 185.643 |\n| 266 | jennette in | 10 | 185.7 |\n| 267 | ebooks in | 12 | 185.75 |\n| 268 | bring google | 12 | 185.917 |\n| 269 | care, but | 14 | 186.214 |\n| 270 | mistress maxxters: | 22 | 186.318 |\n| 271 | ask mistress | 22 | 186.318 |\n| 272 | die happy | 9 | 186.444 |\n| 273 | op's favorite | 19 | 186.526 |\n| 274 | eyes out | 9 | 186.778 |\n| 275 | computer forensics | 17 | 186.824 |\n| 276 | 2013 writing | 11 | 186.909 |\n| 277 | been chosen! | 22 | 187.136 |\n| 278 | on matthew | 11 | 187.273 |\n| 279 | then shoot | 13 | 187.308 |\n| 280 | cheat sheet. | 14 | 187.571 |\n| 281 | critical theory | 17 | 187.706 |\n| 282 | climbed a | 11 | 187.909 |\n| 283 | i've saved | 12 | 187.917 |\n| 284 | trade list | 14 | 188.143 |\n| 285 | ask /r/spikes | 17 | 188.176 |\n| 286 | /r/spikes anything! | 17 | 188.176 |\n| 287 | karen and | 13 | 189.231 |\n| 288 | us anything. | 13 | 189.538 |\n| 289 | (eng subs, | 10 | 190 |\n| 290 | months hrt | 55 | 190.2 |\n| 291 | hp microserver | 10 | 190.3 |\n| 292 | some nsfw | 11 | 190.818 |\n| 293 | s01 e01 | 32 | 190.875 |\n| 294 | - cirrus | 9 | 191 |\n| 295 | to plasma | 10 | 191.1 |\n| 296 | built one | 9 | 191.111 |\n| 297 | selling game | 9 | 191.222 |\n| 298 | afc defensive | 10 | 191.4 |\n| 299 | got 15 | 11 | 191.818 |\n| 300 | mulle meck | 9 | 192.556 |\n| 301 | - qi | 11 | 192.636 |\n| 302 | my les | 11 | 192.636 |\n| 303 | elon musk: | 12 | 192.75 |\n| 304 | hacking with | 9 | 193 |\n| 305 | critiquecast call | 10 | 193.1 |\n| 306 | invitational #1 | 9 | 193.222 |\n| 307 | no tsukai | 48 | 193.229 |\n| 308 | personal message | 9 | 193.556 |\n| 309 | morning fog | 14 | 193.643 |\n| 310 | amazing mysterybox | 9 | 193.667 |\n| 311 | ma ma | 11 | 193.818 |\n| 312 | pokemon melanite | 33 | 193.818 |\n| 313 | my lesbian | 12 | 193.917 |\n| 314 | jesus on | 357 | 193.978 |\n| 315 | debate thread: | 9 | 194 |\n| 316 | seinfeld on | 9 | 194 |\n| 317 | behavioral economics | 25 | 194.12 |\n| 318 | you hurt | 10 | 194.3 |\n| 319 | lovage - | 9 | 194.333 |\n| 320 | memories | | 12 | 194.333 |\n| 321 | golden tate | 12 | 194.5 |\n| 322 | micro center | 9 | 194.889 |\n| 323 | 40 of | 9 | 194.889 |\n| 324 | yo-yo ma, | 11 | 194.909 |\n| 325 | for louis | 11 | 194.909 |\n| 326 | night's storm | 9 | 195.222 |\n| 327 | from /r/4chan) | 33 | 195.424 |\n| 328 | multnomah falls | 10 | 195.8 |\n| 329 | 4.2 stars | 12 | 196 |\n| 330 | gaki no | 50 | 196.08 |\n| 331 | 1 (eng | 9 | 196.333 |\n| 332 | python\" is | 10 | 196.7 |\n| 333 | (full series) | 15 | 196.8 |\n| 334 | as subreddit | 27 | 197.111 |\n| 335 | my 4yr | 9 | 197.222 |\n| 336 | snowden: 'i | 10 | 197.3 |\n| 337 | female soldier | 9 | 197.444 |\n| 338 | my 65 | 9 | 197.444 |\n| 339 | chef at | 12 | 197.583 |\n| 340 | kevin shields | 12 | 197.583 |\n| 341 | tl;dr my | 11 | 198 |\n| 342 | udemy about | 15 | 198.333 |\n| 343 | the ruling | 9 | 198.333 |\n| 344 | isaac asimov's | 9 | 198.556 |\n| 345 | jessica as | 19 | 198.632 |\n| 346 | privilege in | 9 | 198.778 |\n| 347 | head (x-post | 13 | 199 |\n| 348 | diary number | 45 | 199.311 |\n| 349 | iain banks | 29 | 199.379 |\n| 350 | domain in | 9 | 199.556 |\n| 351 | with python\" | 16 | 199.688 |\n| 352 | true power | 14 | 199.786 |\n| 353 | from visiting | 12 | 199.917 |\n| 354 | :o :o | 9 | 200 |\n| 355 | mudmen are | 21 | 200 |\n| 356 | cache i | 10 | 200 |\n| 357 | been chosen | 17 | 200 |\n| 358 | buy him | 9 | 200.333 |\n| 359 | high fat | 11 | 200.364 |\n| 360 | explosion - | 28 | 200.607 |\n| 361 | i'm 12 | 9 | 200.667 |\n| 362 | surely the | 9 | 200.778 |\n| 363 | it's sort | 10 | 200.8 |\n| 364 | 4.0 enhancement | 9 | 200.889 |\n| 365 | the uncluded | 11 | 201 |\n| 366 | go backwards | 11 | 201.091 |\n| 367 | finally said | 10 | 201.1 |\n| 368 | php 5.5 | 10 | 201.1 |\n| 369 | lying for | 9 | 201.222 |\n| 370 | ii: hd | 12 | 201.5 |\n| 371 | giant list | 12 | 201.583 |\n| 372 | bill nye: | 10 | 201.8 |\n| 373 | maggie smith | 11 | 201.818 |\n| 374 | rand is | 11 | 201.818 |\n| 375 | the photo. | 9 | 201.889 |\n| 376 | won \u2013 | 10 | 202 |\n| 377 | virginia to | 9 | 202.333 |\n| 378 | science gone | 9 | 202.333 |\n| 379 | [cypher] vol. | 21 | 202.381 |\n| 380 | facebook of | 10 | 202.4 |\n| 381 | shoyu ramen | 9 | 202.667 |\n| 382 | more scared | 9 | 202.778 |\n| 383 | feels sometimes | 12 | 202.917 |\n| 384 | plot points | 19 | 203.053 |\n| 385 | \"i'm an | 9 | 203.111 |\n| 386 | mfwtk the | 22 | 203.136 |\n| 387 | his famous | 9 | 203.333 |\n| 388 | 2 billion | 15 | 203.333 |\n| 389 | bill gates, | 9 | 203.444 |\n| 390 | in epub | 9 | 203.556 |\n| 391 | michelle bachmann | 13 | 203.615 |\n| 392 | thanking the | 10 | 203.7 |\n| 393 | the subway, | 10 | 203.9 |\n| 394 | roughly 2 | 12 | 203.917 |\n| 395 | interactive gaming | 12 | 204.167 |\n| 396 | and faq | 12 | 204.167 |\n| 397 | [eve online] | 16 | 204.188 |\n| 398 | shining ebony | 10 | 204.2 |\n| 399 | (x-post advice | 10 | 204.3 |\n| 400 | [movie] the | 15 | 204.333 |\n| 401 | threads for | 12 | 204.417 |\n| 402 | - 4.6 | 23 | 204.478 |\n| 403 | /r/funny didn't | 11 | 204.545 |\n| 404 | great dictator | 10 | 205 |\n| 405 | on earth- | 10 | 205.5 |\n| 406 | grocery shopping. | 9 | 205.667 |\n| 407 | mfwtk why | 33 | 205.727 |\n| 408 | pokemmo changelog: | 19 | 205.737 |\n| 409 | golden hour | 9 | 205.889 |\n| 410 | mila at | 9 | 205.889 |\n| 411 | [5th] happy | 9 | 206 |\n| 412 | force against | 10 | 206 |\n| 413 | theme pack | 13 | 206 |\n| 414 | 4.1 stars | 9 | 206 |\n| 415 | - 4.2 | 11 | 206.273 |\n| 416 | the beatport | 9 | 206.444 |\n| 417 | bill watterson | 17 | 206.471 |\n| 418 | go board | 12 | 206.583 |\n| 419 | are today's | 59 | 206.593 |\n| 420 | ebony - | 9 | 206.667 |\n| 421 | sushi lunch | 9 | 206.667 |\n| 422 | shuts down. | 9 | 206.667 |\n| 423 | labor camps | 10 | 206.7 |\n| 424 | flew out | 10 | 206.7 |\n| 425 | stopped on | 9 | 206.778 |\n| 426 | zooey in | 11 | 206.909 |\n| 427 | of hrt | 14 | 206.929 |\n| 428 | 'nearly everything | 19 | 207.158 |\n| 429 | green the | 12 | 207.167 |\n| 430 | my pedalboard | 13 | 207.231 |\n| 431 | weekly sale: | 25 | 207.56 |\n| 432 | great career | 12 | 207.667 |\n| 433 | sub, here | 9 | 207.778 |\n| 434 | new lens | 9 | 207.778 |\n| 435 | plasma workspaces, | 16 | 207.875 |\n| 436 | workspaces, applications | 16 | 207.875 |\n| 437 | rich hickey | 16 | 208.375 |\n| 438 | in edmonton, | 11 | 208.455 |\n| 439 | & hues | 10 | 208.5 |\n| 440 | brian may | 9 | 208.667 |\n| 441 | miss it. | 9 | 209 |\n| 442 | in movies, | 9 | 209 |\n| 443 | list / | 10 | 209 |\n| 444 | on udemy | 19 | 209.105 |\n| 445 | pocket sand? | 12 | 209.167 |\n| 446 | ck is | 23 | 209.261 |\n| 447 | thank this | 12 | 209.333 |\n| 448 | ice for | 11 | 209.455 |\n| 449 | [tv series] | 9 | 209.889 |\n| 450 | petition: make | 9 | 210 |\n| 451 | bryan cranston, | 9 | 210.111 |\n| 452 | reddit moderator | 9 | 210.222 |\n| 453 | traffic cam | 10 | 210.3 |\n| 454 | the train... | 9 | 210.333 |\n| 455 | homemade ramen | 13 | 210.692 |\n| 456 | forged a | 10 | 210.8 |\n| 457 | many feels | 13 | 210.846 |\n| 458 | chuckle out | 12 | 211.083 |\n| 459 | season 1) | 11 | 211.091 |\n| 460 | best gifts | 11 | 211.182 |\n| 461 | belt with | 9 | 211.222 |\n| 462 | the my | 10 | 211.3 |\n| 463 | (29% off) | 9 | 211.333 |\n| 464 | the mudmen's | 18 | 211.389 |\n| 465 | dexter's rude | 13 | 211.615 |\n| 466 | a screencap | 11 | 211.727 |\n| 467 | filthy mudmen | 9 | 211.778 |\n| 468 | new whose | 9 | 211.778 |\n| 469 | may progress | 14 | 211.786 |\n| 470 | so classy | 11 | 211.818 |\n| 471 | jessica nigri's | 11 | 212.182 |\n| 472 | 100 hours | 17 | 212.235 |\n| 473 | just crossed | 13 | 212.385 |\n| 474 | for dyrus | 10 | 212.5 |\n| 475 | and 18 | 9 | 212.556 |\n| 476 | project update: | 9 | 212.556 |\n| 477 | johnny galecki | 9 | 212.667 |\n| 478 | chi cheng | 9 | 212.667 |\n| 479 | walter white, | 9 | 212.667 |\n| 480 | this. is. | 14 | 212.714 |\n| 481 | for $25. | 12 | 212.833 |\n| 482 | imac setup | 9 | 212.889 |\n| 483 | like batman | 9 | 212.889 |\n| 484 | at 23 | 14 | 212.929 |\n| 485 | field report: | 9 | 213.111 |\n| 486 | bobby moynihan | 9 | 213.111 |\n| 487 | nothing else. | 11 | 213.182 |\n| 488 | just fine. | 10 | 213.3 |\n| 489 | from /r/curiousplaces | 9 | 213.333 |\n| 490 | mila in | 33 | 213.485 |\n| 491 | netflix signs | 12 | 213.5 |\n| 492 | feet - | 10 | 213.5 |\n| 493 | feel, as | 11 | 213.545 |\n| 494 | summer week | 12 | 213.75 |\n| 495 | proficient with | 9 | 213.778 |\n| 496 | not guilty. | 9 | 213.778 |\n| 497 | [tv show] | 39 | 214.026 |\n| 498 | asleep, post | 21 | 214.238 |\n| 499 | online will | 9 | 214.333 |\n| 500 | subliminal messages | 10 | 214.4 |\n| 501 | top mod | 13 | 214.462 |\n| 502 | man defends | 11 | 214.636 |\n| 503 | photo recipe | 19 | 214.895 |\n| 504 | write critiquecast | 11 | 215 |\n| 505 | nick frost | 10 | 215 |\n| 506 | time (xpost | 10 | 215.1 |\n| 507 | wimbledon 2013) | 10 | 215.1 |\n| 508 | in 4.5 | 11 | 215.182 |\n| 509 | old days... | 9 | 215.222 |\n| 510 | the swat | 9 | 215.333 |\n| 511 | the exit | 17 | 215.353 |\n| 512 | mother gets | 9 | 215.444 |\n| 513 | destroys a | 15 | 215.467 |\n| 514 | cute i | 12 | 215.5 |\n| 515 | jennette and | 11 | 215.636 |\n| 516 | lane with | 9 | 215.667 |\n| 517 | weeks working | 9 | 215.778 |\n| 518 | start posting | 9 | 215.778 |\n| 519 | on mont | 9 | 215.889 |\n| 520 | midnight on | 11 | 215.909 |\n| 521 | aral sea | 9 | 216 |\n| 522 | girl shoots | 9 | 216.111 |\n| 523 | people working | 9 | 216.222 |\n| 524 | in glorious | 9 | 216.222 |\n| 525 | changes everything. | 12 | 216.25 |\n| 526 | aubrey and | 19 | 216.316 |\n| 527 | - free, | 9 | 216.444 |\n| 528 | there's your | 9 | 216.444 |\n| 529 | (tv series | 9 | 216.556 |\n| 530 | rounds in | 12 | 216.583 |\n| 531 | mr. bean | 12 | 216.583 |\n| 532 | sift through | 10 | 216.6 |\n| 533 | long jumper | 11 | 216.636 |\n| 534 | amazon free | 17 | 216.706 |\n| 535 | night, had | 9 | 216.778 |\n| 536 | reminder: do | 9 | 216.778 |\n| 537 | my dress! | 11 | 216.818 |\n| 538 | spent four | 12 | 216.833 |\n| 539 | skip leg | 11 | 216.909 |\n| 540 | to forage | 11 | 216.909 |\n| 541 | who leaked | 9 | 217 |\n| 542 | grew in | 14 | 217.071 |\n| 543 | private messages | 10 | 217.1 |\n| 544 | - tropes | 10 | 217.3 |\n| 545 | 76% of | 12 | 217.333 |\n| 546 | new arrested | 17 | 217.412 |\n| 547 | learn javascript | 21 | 217.524 |\n| 548 | green onion | 11 | 217.545 |\n| 549 | resident, this | 9 | 217.556 |\n| 550 | of yvonne | 9 | 217.556 |\n| 551 | word war | 16 | 217.562 |\n| 552 | crowd reaction | 9 | 217.667 |\n| 553 | his dad's | 11 | 217.727 |\n| 554 | of paleo | 10 | 217.8 |\n| 555 | emilia clarke | 90 | 217.811 |\n| 556 | 46 years | 11 | 217.818 |\n| 557 | drug of | 10 | 217.9 |\n| 558 | keep going! | 9 | 218 |\n| 559 | dare i | 9 | 218.444 |\n| 560 | peter sagan | 11 | 218.545 |\n| 561 | correspondents' dinner | 11 | 218.545 |\n| 562 | anti-piracy scheme | 9 | 218.556 |\n| 563 | nsa program | 15 | 218.6 |\n| 564 | an ask | 9 | 218.778 |\n| 565 | year. the | 10 | 218.8 |\n| 566 | at university, | 9 | 218.889 |\n| 567 | lawn and | 9 | 218.889 |\n| 568 | month hrt | 11 | 219 |\n| 569 | in 1971 | 9 | 219.111 |\n| 570 | - kde | 15 | 219.333 |\n| 571 | floor safe | 15 | 219.533 |\n| 572 | asian guy | 16 | 219.75 |\n| 573 | immortality, part | 9 | 219.889 |\n| 574 | (x-post /r/mildlyinteresting) | 10 | 219.9 |\n| 575 | louis c.k | 10 | 220.1 |\n| 576 | brain project | 13 | 220.308 |\n| 577 | on animals | 12 | 220.417 |\n| 578 | no functioning | 9 | 220.444 |\n| 579 | different games | 12 | 220.5 |\n| 580 | [raffle] weekly | 11 | 220.636 |\n| 581 | highway to | 9 | 220.667 |\n| 582 | toronto mayor | 16 | 220.688 |\n| 583 | fuck - | 10 | 220.7 |\n| 584 | apps of | 10 | 220.9 |\n| 585 | man thinks | 10 | 221 |\n| 586 | hugh dancy | 9 | 221.111 |\n| 587 | my position | 10 | 221.2 |\n| 588 | the day! | 337 | 221.22 |\n| 589 | papers, please | 9 | 221.333 |\n| 590 | panda at | 16 | 221.375 |\n| 591 | mfwtk if | 72 | 221.417 |\n| 592 | you're new | 14 | 221.5 |\n| 593 | late 20s | 9 | 221.556 |\n| 594 | holding her | 10 | 221.6 |\n| 595 | internet, this | 9 | 222 |\n| 596 | for weed | 13 | 222.077 |\n| 597 | years my | 19 | 222.105 |\n| 598 | medical school, | 9 | 222.222 |\n| 599 | a hang | 13 | 222.231 |\n| 600 | monday, i | 9 | 222.333 |\n| 601 | buried a | 9 | 222.333 |\n| 602 | mfwtk how | 146 | 222.432 |\n| 603 | warning: this | 13 | 222.462 |\n| 604 | to 80 | 10 | 222.6 |\n| 605 | months, my | 10 | 222.7 |\n| 606 | to burst | 9 | 222.778 |\n| 607 | of shutting | 12 | 223 |\n| 608 | irc client | 10 | 223 |\n| 609 | [offer] if | 11 | 223.091 |\n| 610 | faces life | 11 | 223.182 |\n| 611 | critiquecast episode | 10 | 223.2 |\n| 612 | progress report: | 9 | 223.333 |\n| 613 | david duchovny | 11 | 223.364 |\n| 614 | a father, | 11 | 223.364 |\n| 615 | this dirty | 9 | 223.444 |\n| 616 | of cards\" | 11 | 223.545 |\n| 617 | tattoos for | 9 | 223.667 |\n| 618 | whirr - | 14 | 223.786 |\n| 619 | see something, | 10 | 223.8 |\n| 620 | please upvote | 129 | 224.132 |\n| 621 | substances act | 11 | 224.364 |\n| 622 | the hitler | 10 | 224.4 |\n| 623 | golf r | 9 | 224.444 |\n| 624 | promised you | 10 | 224.5 |\n| 625 | sexy ladies: | 17 | 224.529 |\n| 626 | seen your | 9 | 224.667 |\n| 627 | vpn services | 9 | 224.778 |\n| 628 | mudmen have | 27 | 224.889 |\n| 629 | to doctors | 10 | 224.9 |\n| 630 | my ham | 10 | 224.9 |\n| 631 | home theater. | 13 | 224.923 |\n| 632 | dead: episode | 13 | 225 |\n| 633 | with this: | 10 | 225 |\n| 634 | tutorial series: | 9 | 225 |\n| 635 | google, i | 11 | 225.182 |\n| 636 | have short | 14 | 225.214 |\n| 637 | subreddit of | 485 | 225.216 |\n| 638 | simon posford | 12 | 225.25 |\n| 639 | fancy dress | 10 | 225.3 |\n| 640 | cocktail of | 47 | 225.319 |\n| 641 | century, this | 9 | 225.333 |\n| 642 | troll on | 12 | 225.417 |\n| 643 | comic con, | 14 | 225.5 |\n| 644 | than fiction | 9 | 225.556 |\n| 645 | shit together | 24 | 225.625 |\n| 646 | winning wednesdays | 12 | 225.667 |\n| 647 | wednesdays (week | 12 | 225.667 |\n| 648 | and krist | 11 | 225.727 |\n| 649 | elizabeth smart: | 9 | 225.778 |\n| 650 | guys. this | 11 | 225.818 |\n| 651 | mcdonald's in | 12 | 225.833 |\n| 652 | [giveaway][na] $30 | 22 | 225.864 |\n| 653 | minnesota is | 10 | 225.9 |\n| 654 | yesterday's game | 10 | 225.9 |\n| 655 | liam mcintyre | 10 | 226 |\n| 656 | prime members | 11 | 226 |\n| 657 | (eng subs) | 59 | 226.22 |\n| 658 | you black | 11 | 226.273 |\n| 659 | mfwtk - | 12 | 226.333 |\n| 660 | xpost r/pics | 9 | 226.333 |\n| 661 | not trust | 21 | 226.333 |\n| 662 | of spartacus | 9 | 226.333 |\n| 663 | day! :d | 14 | 226.643 |\n| 664 | texts with | 9 | 226.667 |\n| 665 | red dress. | 10 | 226.7 |\n| 666 | dave grohl's | 15 | 226.733 |\n| 667 | concept that | 9 | 226.778 |\n| 668 | louis c.k.'s | 23 | 226.783 |\n| 669 | of pokemon: | 9 | 226.889 |\n| 670 | 'i have | 12 | 226.917 |\n| 671 | favorite shirt. | 14 | 226.929 |\n| 672 | of wolverine | 9 | 227.111 |\n| 673 | stove - | 18 | 227.111 |\n| 674 | was changed | 9 | 227.111 |\n| 675 | - failed | 9 | 227.222 |\n| 676 | finnish babies | 9 | 227.333 |\n| 677 | his 3 | 9 | 227.556 |\n| 678 | kde ships | 21 | 227.571 |\n| 679 | castle was | 21 | 227.571 |\n| 680 | pure css | 14 | 227.643 |\n| 681 | walking dead... | 9 | 227.667 |\n| 682 | guy wanted | 12 | 227.667 |\n| 683 | \"the nsa | 11 | 227.909 |\n| 684 | oslo, norway | 10 | 228 |\n| 685 | tailor - | 12 | 228 |\n| 686 | lohan in | 9 | 228.111 |\n| 687 | dan ariely | 14 | 228.214 |\n| 688 | a mineral | 9 | 228.222 |\n| 689 | but damn, | 11 | 228.273 |\n| 690 | divided into | 10 | 228.3 |\n| 691 | yes and | 10 | 228.4 |\n| 692 | karen in | 17 | 228.588 |\n| 693 | teacher faces | 10 | 228.6 |\n| 694 | of storytelling | 13 | 228.615 |\n| 695 | now banned | 17 | 228.647 |\n| 696 | first guy | 9 | 228.778 |\n| 697 | code, and | 10 | 228.8 |\n| 698 | the collaborators: | 13 | 228.846 |\n| 699 | these maps | 9 | 228.889 |\n| 700 | bring these | 10 | 228.9 |\n| 701 | film which | 9 | 229 |\n| 702 | [progress] i | 10 | 229.1 |\n| 703 | me fight | 9 | 229.111 |\n| 704 | than not | 11 | 229.182 |\n| 705 | beacon theater | 10 | 229.2 |\n| 706 | schedule 1 | 9 | 229.222 |\n| 707 | - mid | 9 | 229.222 |\n| 708 | eating is | 9 | 229.333 |\n| 709 | free shipping] | 60 | 229.433 |\n| 710 | body has | 9 | 229.444 |\n| 711 | my 1965 | 9 | 229.444 |\n| 712 | (thought you | 9 | 229.444 |\n| 713 | ammonium dichromate | 9 | 229.556 |\n| 714 | the rooftop | 14 | 229.643 |\n| 715 | provide that | 14 | 229.714 |\n| 716 | burzum - | 13 | 229.769 |\n| 717 | [paperback] - | 9 | 229.778 |\n| 718 | ghost adventures | 10 | 229.8 |\n| 719 | un visits | 19 | 229.842 |\n| 720 | puts them | 9 | 230 |\n| 721 | space colony | 10 | 230.3 |\n| 722 | of plagues | 10 | 230.4 |\n| 723 | [steam] the | 38 | 230.632 |\n| 724 | the nsa: | 17 | 230.765 |\n| 725 | r/funny. thought | 9 | 230.778 |\n| 726 | scala ide | 9 | 230.889 |\n| 727 | dicks and | 9 | 230.889 |\n| 728 | cs:go is | 9 | 230.889 |\n| 729 | the leopard | 14 | 231 |\n| 730 | my projects | 9 | 231 |\n| 731 | a marker | 10 | 231 |\n| 732 | snowden in | 14 | 231 |\n| 733 | best record | 9 | 231.111 |\n| 734 | bookclub discussion: | 14 | 231.214 |\n| 735 | disney character | 9 | 231.444 |\n| 736 | decriminalized in | 9 | 231.444 |\n| 737 | 65% of | 9 | 231.444 |\n| 738 | am right | 13 | 231.462 |\n| 739 | the buzzcocks | 9 | 231.556 |\n| 740 | took 6 | 13 | 231.615 |\n| 741 | dale vs | 9 | 231.667 |\n| 742 | debian is | 9 | 231.667 |\n| 743 | on eight | 9 | 231.778 |\n| 744 | for relationship | 10 | 231.8 |\n| 745 | [send] free | 57 | 231.807 |\n| 746 | the goon | 9 | 232 |\n| 747 | are asleep, | 23 | 232.13 |\n| 748 | with abs | 9 | 232.333 |\n| 749 | guy vs | 10 | 232.4 |\n| 750 | my stay | 9 | 232.444 |\n| 751 | artificial neural | 12 | 232.5 |\n| 752 | boat lift | 10 | 232.8 |\n| 753 | r/atheism has | 10 | 232.9 |\n| 754 | apple's iphone | 9 | 233 |\n| 755 | shpongle - | 64 | 233 |\n| 756 | nice plot | 10 | 233 |\n| 757 | apartment that | 10 | 233.1 |\n| 758 | royal tenenbaums | 9 | 233.222 |\n| 759 | introduction thread | 18 | 233.333 |\n| 760 | perfume - | 30 | 233.433 |\n| 761 | twitter that | 10 | 233.5 |\n| 762 | from google. | 11 | 233.545 |\n| 763 | uses her | 9 | 233.556 |\n| 764 | karen at | 14 | 233.571 |\n| 765 | dockers men's | 14 | 233.571 |\n| 766 | got today! | 13 | 233.692 |\n| 767 | in distress: | 11 | 233.727 |\n| 768 | distress: part | 11 | 233.727 |\n| 769 | mila and | 22 | 233.727 |\n| 770 | lena dunham | 38 | 233.789 |\n| 771 | show over | 12 | 233.833 |\n| 772 | all: a | 9 | 233.889 |\n| 773 | 200 uprons, | 13 | 233.923 |\n| 774 | jamie hyneman | 19 | 233.947 |\n| 775 | electric swing | 21 | 233.952 |\n| 776 | the hannibal | 10 | 234 |\n| 777 | of power, | 12 | 234 |\n| 778 | cap of | 10 | 234 |\n| 779 | a fuckin' | 9 | 234 |\n| 780 | tl;dr: i | 22 | 234 |\n| 781 | ran up | 12 | 234.083 |\n| 782 | hadfield on | 12 | 234.083 |\n| 783 | true and | 21 | 234.143 |\n| 784 | i met! | 11 | 234.182 |\n| 785 | toilet roll | 11 | 234.182 |\n| 786 | my morning. | 10 | 234.2 |\n| 787 | so nice. | 12 | 234.25 |\n| 788 | teaching creationism | 9 | 234.333 |\n| 789 | [discussion] general | 21 | 234.476 |\n| 790 | room mix | 10 | 234.7 |\n| 791 | [community choice] | 10 | 234.7 |\n| 792 | named afc | 12 | 234.75 |\n| 793 | the fairly | 12 | 234.75 |\n| 794 | of mythbusters | 14 | 235.071 |\n| 795 | by mario | 10 | 235.2 |\n| 796 | a surgery | 9 | 235.222 |\n| 797 | get down. | 9 | 235.222 |\n| 798 | scope and | 11 | 235.273 |\n| 799 | of joan | 9 | 235.333 |\n| 800 | digest: monday, | 84 | 235.393 |\n| 801 | akira kurosawa | 10 | 235.5 |\n| 802 | package signing | 9 | 235.556 |\n| 803 | from spring | 10 | 235.6 |\n| 804 | with ar-15 | 9 | 235.667 |\n| 805 | professional studio | 11 | 235.727 |\n| 806 | hall meeting | 9 | 235.778 |\n| 807 | national institute | 9 | 236 |\n| 808 | favorite sign | 12 | 236 |\n| 809 | #1 thing | 9 | 236 |\n| 810 | altar of | 18 | 236.056 |\n| 811 | my bottle | 14 | 236.071 |\n| 812 | enemy to | 12 | 236.083 |\n| 813 | after growing | 11 | 236.091 |\n| 814 | your highlights | 10 | 236.1 |\n| 815 | nbc renews | 9 | 236.111 |\n| 816 | this summer's | 9 | 236.111 |\n| 817 | weeks pregnant | 11 | 236.182 |\n| 818 | police arrested | 12 | 236.333 |\n| 819 | kendrick lamar, | 12 | 236.417 |\n| 820 | and platform | 9 | 236.444 |\n| 821 | manti te'o's | 11 | 236.455 |\n| 822 | be disappointed | 11 | 236.455 |\n| 823 | concepts in | 12 | 236.5 |\n| 824 | happy 30th | 14 | 236.5 |\n| 825 | rebecca watson | 13 | 236.538 |\n| 826 | details like | 12 | 236.667 |\n| 827 | lot lately, | 9 | 236.667 |\n| 828 | of colin | 11 | 236.727 |\n| 829 | new septum | 11 | 236.818 |\n| 830 | my mystery | 17 | 236.824 |\n| 831 | newsroom season | 14 | 236.857 |\n| 832 | lot better. | 9 | 236.889 |\n| 833 | is here!! | 9 | 236.889 |\n| 834 | n th | 10 | 236.9 |\n| 835 | eeconomics - | 12 | 236.917 |\n| 836 | sale. i | 9 | 237 |\n| 837 | i messaged | 12 | 237 |\n| 838 | (prey series) | 11 | 237.091 |\n| 839 | panda cubs | 10 | 237.1 |\n| 840 | on ... | 9 | 237.111 |\n| 841 | a bicycle. | 12 | 237.167 |\n| 842 | imagine most | 16 | 237.312 |\n| 843 | lucky (daft | 9 | 237.444 |\n| 844 | off) [free | 23 | 237.478 |\n| 845 | - 4th | 14 | 237.5 |\n| 846 | better use | 11 | 237.545 |\n| 847 | this mountain | 10 | 237.6 |\n| 848 | civ ii | 20 | 237.7 |\n| 849 | might all | 9 | 237.778 |\n| 850 | 2 review | 9 | 237.778 |\n| 851 | & webb | 14 | 237.786 |\n| 852 | johnson polls | 9 | 237.889 |\n| 853 | banks has | 10 | 237.9 |\n| 854 | my anxiety. | 10 | 237.9 |\n| 855 | - weedist | 12 | 237.917 |\n| 856 | res 4.0 | 12 | 238.083 |\n| 857 | as predicted | 10 | 238.1 |\n| 858 | on /r/politics | 10 | 238.2 |\n| 859 | dad needs | 9 | 238.222 |\n| 860 | thread: ufc | 16 | 238.312 |\n| 861 | jk rowling | 14 | 238.357 |\n| 862 | than enough | 9 | 238.556 |\n| 863 | your beard | 12 | 238.583 |\n| 864 | act for | 12 | 238.667 |\n| 865 | new mug | 12 | 238.75 |\n| 866 | this hotel | 9 | 239 |\n| 867 | (a tale | 11 | 239 |\n| 868 | guitar string | 9 | 239 |\n| 869 | digital forensics | 12 | 239.083 |\n| 870 | chris hadfield, | 10 | 239.1 |\n| 871 | a flowchart | 19 | 239.105 |\n| 872 | digest: tuesday, | 88 | 239.114 |\n| 873 | oot any% | 9 | 239.222 |\n| 874 | vi hart | 10 | 239.3 |\n| 875 | swing circus | 19 | 239.316 |\n| 876 | in school... | 9 | 239.333 |\n| 877 | tl;dr i | 24 | 239.375 |\n| 878 | submit and | 43 | 239.465 |\n| 879 | in r/pics. | 15 | 239.467 |\n| 880 | boyfriend decided | 12 | 239.583 |\n| 881 | bungle - | 13 | 239.615 |\n| 882 | language shapes | 12 | 239.667 |\n| 883 | wedding invitations. | 9 | 239.667 |\n| 884 | downvoting a | 12 | 239.667 |\n| 885 | but over | 11 | 239.909 |\n| 886 | ucla beats | 9 | 240 |\n| 887 | [3fm] the | 66 | 240.045 |\n| 888 | self confidence | 19 | 240.105 |\n| 889 | emsk: the | 17 | 240.176 |\n| 890 | baptist church. | 10 | 240.2 |\n| 891 | table mountain | 9 | 240.222 |\n| 892 | digest: thursday, | 84 | 240.417 |\n| 893 | (62% off) | 11 | 240.455 |\n| 894 | rip | 10 | 240.5 |\n| 895 | this alot | 9 | 240.556 |\n| 896 | traffic from | 10 | 240.6 |\n| 897 | so. much. | 10 | 240.7 |\n| 898 | merges with | 9 | 240.778 |\n| 899 | war have | 13 | 240.846 |\n| 900 | my spouse | 9 | 240.889 |\n| 901 | a biker | 12 | 240.917 |\n| 902 | the cw | 14 | 240.929 |\n| 903 | through walls | 9 | 241 |\n| 904 | caravan palace | 80 | 241.05 |\n| 905 | asian parents | 27 | 241.111 |\n| 906 | son came | 9 | 241.111 |\n| 907 | goal weight! | 10 | 241.3 |\n| 908 | anthony and | 13 | 241.308 |\n| 909 | in cardiff | 9 | 241.333 |\n| 910 | project phoenix | 9 | 241.333 |\n| 911 | - wow! | 9 | 241.444 |\n| 912 | 3 kids | 9 | 241.444 |\n| 913 | drive past | 9 | 241.444 |\n| 914 | leaves his | 17 | 241.588 |\n| 915 | bush v. | 10 | 241.6 |\n| 916 | dickies men's | 11 | 241.636 |\n| 917 | at 4:00 | 9 | 241.667 |\n| 918 | sauropod studio | 19 | 241.737 |\n| 919 | 24 y/o | 9 | 241.889 |\n| 920 | pocket for | 9 | 241.889 |\n| 921 | in madrid, | 10 | 241.9 |\n| 922 | ban plastic | 12 | 241.917 |\n| 923 | you're today's | 13 | 241.923 |\n| 924 | folder of | 14 | 241.929 |\n| 925 | dear lord, | 48 | 241.938 |\n| 926 | movie theater. | 9 | 242 |\n| 927 | your move | 18 | 242.056 |\n| 928 | trees sucking | 26 | 242.077 |\n| 929 | a bakery | 10 | 242.2 |\n| 930 | giving her | 12 | 242.25 |\n| 931 | r/aww, but | 11 | 242.273 |\n| 932 | the thug | 14 | 242.286 |\n| 933 | from /r/cityporn] | 10 | 242.3 |\n| 934 | snowden: the | 16 | 242.312 |\n| 935 | eulberg - | 9 | 242.333 |\n| 936 | natural environment | 11 | 242.364 |\n| 937 | weekend. the | 9 | 242.444 |\n| 938 | and gain | 11 | 242.455 |\n| 939 | wilfred is | 11 | 242.455 |\n| 940 | a lefty | 22 | 242.5 |\n| 941 | rainbow boa | 9 | 242.556 |\n| 942 | built our | 10 | 242.6 |\n| 943 | called that | 10 | 242.6 |\n| 944 | ugly (1966) | 10 | 242.6 |\n| 945 | drudkh - | 13 | 242.615 |\n| 946 | fashion general | 25 | 242.64 |\n| 947 | sometimes, when | 9 | 242.778 |\n| 948 | i freaked | 10 | 242.8 |\n| 949 | feed, thought | 11 | 242.909 |\n| 950 | sausage with | 9 | 243 |\n| 951 | the cows | 9 | 243.111 |\n| 952 | user does | 18 | 243.222 |\n| 953 | had several | 10 | 243.3 |\n| 954 | largest ship | 9 | 243.333 |\n| 955 | work. i'm | 9 | 243.333 |\n| 956 | weekly mix | 10 | 243.4 |\n| 957 | most polite | 12 | 243.417 |\n| 958 | pet the | 9 | 243.444 |\n| 959 | black corset | 10 | 243.5 |\n| 960 | peter norvig | 11 | 243.545 |\n| 961 | hidden treasure | 9 | 243.556 |\n| 962 | this advice | 12 | 243.583 |\n| 963 | never win | 12 | 243.583 |\n| 964 | within my | 13 | 243.615 |\n| 965 | for tweeting | 11 | 243.636 |\n| 966 | old wwii | 9 | 243.667 |\n| 967 | car maintenance | 9 | 243.778 |\n| 968 | worth repeating: | 9 | 243.778 |\n| 969 | true gentleman | 9 | 243.778 |\n| 970 | litecoin is | 10 | 243.8 |\n| 971 | feeling ever | 11 | 243.818 |\n| 972 | delivers the | 14 | 243.857 |\n| 973 | full priced | 9 | 243.889 |\n| 974 | 100% free | 9 | 243.889 |\n| 975 | nap with | 10 | 243.9 |\n| 976 | school. here | 9 | 244 |\n| 977 | 25 years. | 13 | 244 |\n| 978 | i've gained | 9 | 244 |\n| 979 | i episode | 23 | 244.087 |\n| 980 | defund the | 20 | 244.1 |\n| 981 | grant from | 9 | 244.111 |\n| 982 | fan watching | 11 | 244.182 |\n| 983 | being beaten | 10 | 244.2 |\n| 984 | always laugh | 14 | 244.214 |\n| 985 | iyama yuta | 9 | 244.222 |\n| 986 | i forged | 16 | 244.25 |\n| 987 | for hours... | 10 | 244.3 |\n| 988 | [psa] i | 19 | 244.316 |\n| 989 | releases free | 11 | 244.545 |\n| 990 | a stick. | 9 | 244.556 |\n| 991 | plagues - | 9 | 244.556 |\n| 992 | reddit digest: | 444 | 244.579 |\n| 993 | can definitely | 10 | 244.6 |\n| 994 | about best | 10 | 244.6 |\n| 995 | artwork at | 11 | 244.636 |\n| 996 | of electro | 10 | 244.7 |\n| 997 | in empire | 10 | 244.7 |\n| 998 | gets what's | 14 | 244.714 |\n| 999 | most precious | 10 | 244.8 |\n| 1000 | java to | 20 | 244.85 |\n"
}
],
"prompt_number": 35
},
{
"cell_type": "markdown",
"metadata": {},
"source": "Follow the most interesting BigQuery news at [http://www.reddit.com/r/bigquery](http://www.reddit.com/r/bigquery). Ask your technical questions using the [google-bigquery] tag on [Stack Overflow](http://stackoverflow.com/questions/tagged/google-bigquery)."
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment