Table of Contents¶

Part 0. - Opening Remarks and Thoughts
Part 1. - SQL
.........Data Viz 1 - Articles Posted By Day of Week
Part 2. - Python
.........Data Viz 2 - "Investigating Modern-Day Slavery in the South" Cumulative Impressions
.........Data Viz 3 - Engament Metrics
.........Data Viz 4 - Total Impressions by Veritcal

Part 0. - Opening Remarks and Thoughts¶

Overall here’s the gameplan I used for this analysis:¶

SQL
For the SQL portion, I loaded the CSV into a MySQL local database, and I ran my queries in MySQL Workbench. To conveniently display the results, I used Python to connect to the local database and display the tables as Pandas dataframes. When I thought it was especially cool, I visualized the data. Where applicable, I ran separate queries to show more than one way of getting to a given insight.

Python
For the Python portion, I first used some looping to get the filepaths for all the JSON files. Since all the JSON files were line delimited, I could use another loop to load all the JSON lines into a data structure, and then flatten the data structure using Python's JSON module’s normalize method. This got everything into a Pandas dataframe with about 3000 rows and over 500 columns. These hundreds of columns were necessary because we had to unpack all the nested cells. I used another loop to read through the columns, and selected which columns held information relevant to the questions asked. Then, I used SQLite to—within the script—take the entire Pandas dataframe and convert it into a database. Since it would be too messy to load all the columns into a database program, I just kept the entire structure within the script. Then I could internally query the data via Python, and you can see the way I got answers.

One of the most interesting mathematical situations was the cumulative nature of the data. So daily rates all depend on a max() – min() difference for a given time period. Moving forward, in a more stable ETL pipeline, I’d recommend we run a function to save daily incremental changes into a table, which will be easier for others to query.

A Few Data Visualizations...
To break up all this text and code, I wanted to show a few visualizations I thought were interesting. They are by no means exhaustive.

Here is a SQL histogram visualization. It is cool to see how articles post per day of the week. It’s clear that on the weekends there are a lot fewer articles. At the same time, it’s possible that more people are on social media on the weekends, so we may want to see if we can increase the number of posts on the weekends, and see if that drives engagement. We can set up a statistical experiment to test this, by the way.

ex-1-day-of-week

If we look at daily engagement, we can actually see the impact of a mega article. Here you can see what the "Investigating Modern-Day Slavery in the South" article/video did to daily shares/impressions. As a benchmark comparison, in my experience, a friend's post on your own personal Facebook timeline is not going to get an 8% shares-to-impressions ratio, so this is very good. Further, regarding the splash on March 4th in shares-per-impresion: my hunch is that people shared this post but didn't necessarily 'like' it, and that makes sense because it's something you'd want other people to know about it, but not for a happy, 'likable' reason.

ex-3-engagement-metrics

As alluded to above, the top post in the data set "Investigating Modern-Day Slavery in the South." This graph depicts the posts incredible reach. This is something I would like to dig deeper in in future analyses.

ex-2-modern-slavery-post-cumulative-impressions

Finally, I also looked in at total cumulative impressions in our Facebook JSON data, and I made a pie chart to summarize our sources of content. One thing that stands out to me is that VICE Video makes up less of the pie than I would’ve expected. We’ll want to do more research into to if this is so because there are fewer videos (relatively speaking), and, if so, whether we want to invest more resources into VICE’s video program.

ex-4-total-impressions-by-vertical

*And now the code…*

import os
import json
import pandas as pd
import numpy as np
from pandas.io.json import json_normalize
from matplotlib import pyplot as plt 
import sqlite3 as sql
import mysql.connector as mysql

Part 1. - SQL¶

1. Each unique article is represented by a six charater, alphanumeric ID in the URL string. Start this exercise by using a regular expression to extract the article_id from the URL.¶

For example, xwpd7w is the article_id here https://www.vice.com/en_us/article/xwpd7w/how-a-brooklyn-gang-may-have-gotten-crazy-rich-dealing-for-el-chapo ¶

#connecting to the local sql database I set up
db = mysql.connect(
    host = "localhost",
    user = "newuser",
    passwd = "data",
    auth_plugin='mysql_native_password',
    database = 'sys')

article_id_strings = pd.read_sql("""
SELECT
     REGEXP_SUBSTR(url, '......', locate('article/', url)+ length('article/')) as article_id
FROM sys.vice
""", con=db)

article_id_strings.head(10)

2. Using the published_day field, calculate the unique daily and weekly article output. How does the content output trend throughout the week?¶

I'm answering this questions in 4 parts:
A) - Unique daily article output (which I assume is the count of the articles per day)
B) - Unique weekly article output (which I assume is the count of the articles per week)
C) - A count of artils per day, in a list format (so not an average)
D) - A list and a data viz of which day per week gets how many counts of articles over the duration

#A)
unique_daily_output = pd.read_sql("""
SELECT
count( distinct date(published_day)) as days, #there are 62 days,
count( distinct url) as articles, #there are about 20k articles
round(count( distinct url) / count( distinct date(published_day)),2) as daily_rate
FROM sys.vice;
""", con=db)

unique_daily_output

#B)
unique_weekly_output = pd.read_sql("""
SELECT
count( distinct extract(week from published_day)) as weeks, #there are 10 weeks,
count( distinct url) as articles, #there are about 20k articles
round(count( distinct url) / count( distinct extract(week from published_day)),2) as weekly_rate
FROM sys.vice;
""", con=db)

unique_weekly_output

#C) 
articles_per_day_list = pd.read_sql("""
SELECT
date(published_day) as date,
count(distinct url) as articles
FROM sys.vice
group by 1
order by 1 asc;
""", con=db)

articles_per_day_list.head()

#D)
articles_by_day_of_week = pd.read_sql("""
SELECT
dayofweek(published_day) as 'day_of_week', #btw 1 = Sunday
count(distinct url) as articles
FROM sys.vice
group by 1
order by 2 asc;
""", con=db)

articles_by_day_of_week
#1 = Sunday

f, ax = plt.subplots(figsize=(6, 5))
plt.bar(articles_by_day_of_week.day_of_week,articles_by_day_of_week.articles)
plt.xlabel("Day of Week", fontsize = 13)
plt.locator_params(axis='x', nbins=12)
ax.set_xticklabels(['0','Sunday','Monday', 'Tuesday', 'Wednesday','Thursday', 'Friday',\
                   'Saturday'], style='italic')
plt.xticks(rotation=-25)
plt.ylabel("Number of Articles", fontsize = 13)
plt.suptitle("Article Frequency Throughout the Week (Aggregation)\nSeptember 1, 2018 - November 1, 2018",\
            fontsize = 13, fontweight = 'bold')
plt.savefig("ex_1_day_of_week.png", bbox_inches = "tight")
plt.show()

3. VICE's editorial department is structured into different verticals (e.g. Noisey covers music and Motherboard covers tech).¶

#this is a little trickier because there are two sql statements to be run sequentially
#we split them up in the following way

sql1="set @total_article_count = (select count(distinct url) from sys.vice);" 
sql2="""
select
vertical as veritcal, 
count( distinct url) as article_count,
round(100.0*(count( distinct url) / @total_article_count),2) as prct_of_whole
from sys.vice
group by 1
order by 3 desc;
"""
cursor=db.cursor(buffered=True)
cursor.execute(sql1)
cursor.close()

vertical_contributions = pd.read_sql(sql2, con=db)

vertical_contributions.head()

4. VICE publishes content across a range of global offices. Each unique office is identified by their locale which is represented using a locale url parameter (e.g. en_us for the United States and en_uk for the United Kingdom). However, not every vertical publishes content in every locale.¶

Which verticals are published in which locales? Write a query creating a table showing each locale, their total article output, and a concatenated list of all of the verticals publishing in each locale.¶

locale_verticals_lists_and_counts = pd.read_sql("""
SELECT
locale,
count(distinct url) as article_count,
group_concat(distinct vertical order by vertical asc) as list_locale_verticals,
count(distinct vertical) as count_locale_verticals
FROM sys.vice
group by 1
order by 2 desc
;
""", con=db)

#verticals are concatenated alphabetically
locale_verticals_lists_and_counts.head()

Part 2. - Python¶

1. Please read in all of the files into a single data structure that will be usable for further analysis (for example, a pandas DataFrame)¶

#first we need to get a list that literally has all the file names
parent_path = 'Facebook Data'
list_of_files = []
for folder in os.listdir(parent_path):
    if folder != ".DS_Store": #just need to skip over this one since it's not a proper directory
        for json_file in os.listdir(os.path.join(parent_path, folder)):
            list_of_files.append(os.path.join(parent_path, folder, json_file))

#example
list_of_files[:5]

['Facebook Data/2018-03-07/.DS_Store',
 'Facebook Data/2018-03-07/2018-03-07_VICE_asof_2018-03-09-000.json',
 'Facebook Data/2018-03-07/2018-03-07_VICE_asof_2018-03-08-000.json',
 'Facebook Data/2018-03-07/2018-03-07_VICE-Video_asof_2018-03-08-000.json',
 'Facebook Data/2018-03-07/2018-03-07_VICE-Video_asof_2018-03-09-000.json']

#next we have to go through that list of files, and make sure we only have the JSONs
all_the_presidents_jsons = [x for x in list_of_files if x.endswith('.json')]

#example 
#no more .DS_Store, etc.
all_the_presidents_jsons[:5]

['Facebook Data/2018-03-07/2018-03-07_VICE_asof_2018-03-09-000.json',
 'Facebook Data/2018-03-07/2018-03-07_VICE_asof_2018-03-08-000.json',
 'Facebook Data/2018-03-07/2018-03-07_VICE-Video_asof_2018-03-08-000.json',
 'Facebook Data/2018-03-07/2018-03-07_VICE-Video_asof_2018-03-09-000.json',
 'Facebook Data/2018-03-07/2018-03-07_MOTHERBOARD_asof_2018-03-08-000.json']

#we can see there were a lot of JSONs (155 files)
len(all_the_presidents_jsons)

155

#now we need to take each line from the JSON (they are line delimited), and combine them into one place
data = []
for i in all_the_presidents_jsons:
    with open(i) as f:
        for line in f:
            data.append(json.loads(line))

#then we need to flatten the JSONs since there are tons of nested files, and we need to get it into pandas
vice_data = json_normalize(data)

#this is to make sure I can view all the columns
pd.set_option('display.max_columns', None)
#this is to fix the spaces that came into the unnested headers
vice_data.columns = vice_data.columns.str.replace(' ', '_')
vice_data.head(4)

#We'll want to get an idea of the size of this dataframe
vice_data.shape

(3001, 553)

#We'll also want a reference place to check the columns now and again since there are so many:
#You can scroll through this or text search it to find what you may need.
for i in vice_data.columns:
    print(i)

asof_date
comments_total_count
created_time
from_id
from_name
id
link
name
post_consumptions
post_consumptions_by_type.link_clicks
post_consumptions_by_type.other_clicks
post_consumptions_by_type.photo_view
post_consumptions_by_type.video_play
post_consumptions_by_type_unique.link_clicks
post_consumptions_by_type_unique.other_clicks
post_consumptions_by_type_unique.photo_view
post_consumptions_by_type_unique.video_play
post_consumptions_unique
post_engaged_fan
post_engaged_users
post_engagements
post_fan_reach
post_impressions
post_impressions_by_paid_non_paid.paid
post_impressions_by_paid_non_paid.total
post_impressions_by_paid_non_paid.unpaid
post_impressions_by_paid_non_paid_unique.paid
post_impressions_by_paid_non_paid_unique.total
post_impressions_by_paid_non_paid_unique.unpaid
post_impressions_by_story_type.other
post_impressions_by_story_type_unique.other
post_impressions_fan
post_impressions_fan_paid
post_impressions_fan_paid_unique
post_impressions_fan_unique
post_impressions_organic
post_impressions_organic_unique
post_impressions_paid
post_impressions_paid_unique
post_impressions_unique
post_impressions_viral
post_impressions_viral_unique
post_negative_feedback
post_negative_feedback_by_type.hide_all_clicks
post_negative_feedback_by_type.hide_clicks
post_negative_feedback_by_type.report_spam_clicks
post_negative_feedback_by_type.unlike_page_clicks
post_negative_feedback_by_type_unique.hide_all_clicks
post_negative_feedback_by_type_unique.hide_clicks
post_negative_feedback_by_type_unique.report_spam_clicks
post_negative_feedback_by_type_unique.unlike_page_clicks
post_reactions_anger_total
post_reactions_by_type_total.anger
post_reactions_by_type_total.haha
post_reactions_by_type_total.like
post_reactions_by_type_total.love
post_reactions_by_type_total.sorry
post_reactions_by_type_total.wow
post_reactions_haha_total
post_reactions_like_total
post_reactions_love_total
post_reactions_sorry_total
post_reactions_wow_total
post_video_avg_time_watched
post_video_complete_views_organic
post_video_complete_views_organic_unique
post_video_complete_views_paid
post_video_complete_views_paid_unique
post_video_length
post_video_retention_graph_autoplayed.0
post_video_retention_graph_autoplayed.1
post_video_retention_graph_autoplayed.10
post_video_retention_graph_autoplayed.11
post_video_retention_graph_autoplayed.12
post_video_retention_graph_autoplayed.13
post_video_retention_graph_autoplayed.14
post_video_retention_graph_autoplayed.15
post_video_retention_graph_autoplayed.16
post_video_retention_graph_autoplayed.17
post_video_retention_graph_autoplayed.18
post_video_retention_graph_autoplayed.19
post_video_retention_graph_autoplayed.2
post_video_retention_graph_autoplayed.20
post_video_retention_graph_autoplayed.21
post_video_retention_graph_autoplayed.22
post_video_retention_graph_autoplayed.23
post_video_retention_graph_autoplayed.24
post_video_retention_graph_autoplayed.25
post_video_retention_graph_autoplayed.26
post_video_retention_graph_autoplayed.27
post_video_retention_graph_autoplayed.28
post_video_retention_graph_autoplayed.29
post_video_retention_graph_autoplayed.3
post_video_retention_graph_autoplayed.30
post_video_retention_graph_autoplayed.31
post_video_retention_graph_autoplayed.32
post_video_retention_graph_autoplayed.33
post_video_retention_graph_autoplayed.34
post_video_retention_graph_autoplayed.35
post_video_retention_graph_autoplayed.36
post_video_retention_graph_autoplayed.37
post_video_retention_graph_autoplayed.38
post_video_retention_graph_autoplayed.39
post_video_retention_graph_autoplayed.4
post_video_retention_graph_autoplayed.40
post_video_retention_graph_autoplayed.5
post_video_retention_graph_autoplayed.6
post_video_retention_graph_autoplayed.7
post_video_retention_graph_autoplayed.8
post_video_retention_graph_autoplayed.9
post_video_retention_graph_clicked_to_play.0
post_video_retention_graph_clicked_to_play.1
post_video_retention_graph_clicked_to_play.10
post_video_retention_graph_clicked_to_play.11
post_video_retention_graph_clicked_to_play.12
post_video_retention_graph_clicked_to_play.13
post_video_retention_graph_clicked_to_play.14
post_video_retention_graph_clicked_to_play.15
post_video_retention_graph_clicked_to_play.16
post_video_retention_graph_clicked_to_play.17
post_video_retention_graph_clicked_to_play.18
post_video_retention_graph_clicked_to_play.19
post_video_retention_graph_clicked_to_play.2
post_video_retention_graph_clicked_to_play.20
post_video_retention_graph_clicked_to_play.21
post_video_retention_graph_clicked_to_play.22
post_video_retention_graph_clicked_to_play.23
post_video_retention_graph_clicked_to_play.24
post_video_retention_graph_clicked_to_play.25
post_video_retention_graph_clicked_to_play.26
post_video_retention_graph_clicked_to_play.27
post_video_retention_graph_clicked_to_play.28
post_video_retention_graph_clicked_to_play.29
post_video_retention_graph_clicked_to_play.3
post_video_retention_graph_clicked_to_play.30
post_video_retention_graph_clicked_to_play.31
post_video_retention_graph_clicked_to_play.32
post_video_retention_graph_clicked_to_play.33
post_video_retention_graph_clicked_to_play.34
post_video_retention_graph_clicked_to_play.35
post_video_retention_graph_clicked_to_play.36
post_video_retention_graph_clicked_to_play.37
post_video_retention_graph_clicked_to_play.38
post_video_retention_graph_clicked_to_play.39
post_video_retention_graph_clicked_to_play.4
post_video_retention_graph_clicked_to_play.40
post_video_retention_graph_clicked_to_play.5
post_video_retention_graph_clicked_to_play.6
post_video_retention_graph_clicked_to_play.7
post_video_retention_graph_clicked_to_play.8
post_video_retention_graph_clicked_to_play.9
post_video_view_time
post_video_view_time_by_age_bucket_and_gender.F.13-17
post_video_view_time_by_age_bucket_and_gender.F.18-24
post_video_view_time_by_age_bucket_and_gender.F.25-34
post_video_view_time_by_age_bucket_and_gender.F.35-44
post_video_view_time_by_age_bucket_and_gender.F.45-54
post_video_view_time_by_age_bucket_and_gender.F.55-64
post_video_view_time_by_age_bucket_and_gender.F.65+
post_video_view_time_by_age_bucket_and_gender.M.13-17
post_video_view_time_by_age_bucket_and_gender.M.18-24
post_video_view_time_by_age_bucket_and_gender.M.25-34
post_video_view_time_by_age_bucket_and_gender.M.35-44
post_video_view_time_by_age_bucket_and_gender.M.45-54
post_video_view_time_by_age_bucket_and_gender.M.55-64
post_video_view_time_by_age_bucket_and_gender.M.65+
post_video_view_time_by_age_bucket_and_gender.U.13-17
post_video_view_time_by_age_bucket_and_gender.U.18-24
post_video_view_time_by_age_bucket_and_gender.U.25-34
post_video_view_time_by_age_bucket_and_gender.U.35-44
post_video_view_time_by_age_bucket_and_gender.U.45-54
post_video_view_time_by_age_bucket_and_gender.U.55-64
post_video_view_time_by_age_bucket_and_gender.U.65+
post_video_view_time_by_country_id.Afghanistan_(AF)
post_video_view_time_by_country_id.Albania_(AL)
post_video_view_time_by_country_id.Algeria_(DZ)
post_video_view_time_by_country_id.Argentina_(AR)
post_video_view_time_by_country_id.Aruba_(AW)
post_video_view_time_by_country_id.Australia_(AU)
post_video_view_time_by_country_id.Austria_(AT)
post_video_view_time_by_country_id.Bahrain_(BH)
post_video_view_time_by_country_id.Bangladesh_(BD)
post_video_view_time_by_country_id.Barbados_(BB)
post_video_view_time_by_country_id.Belgium_(BE)
post_video_view_time_by_country_id.Belize_(BZ)
post_video_view_time_by_country_id.Bolivia_(BO)
post_video_view_time_by_country_id.Bosnia_and_Herzegovina_(BA)
post_video_view_time_by_country_id.Brazil_(BR)
post_video_view_time_by_country_id.Brunei_(BN)
post_video_view_time_by_country_id.Bulgaria_(BG)
post_video_view_time_by_country_id.Cambodia_(KH)
post_video_view_time_by_country_id.Canada_(CA)
post_video_view_time_by_country_id.Cayman_Islands_(KY)
post_video_view_time_by_country_id.Chile_(CL)
post_video_view_time_by_country_id.China_(CN)
post_video_view_time_by_country_id.Colombia_(CO)
post_video_view_time_by_country_id.Costa_Rica_(CR)
post_video_view_time_by_country_id.Croatia_(HR)
post_video_view_time_by_country_id.Curaçao_(CW)
post_video_view_time_by_country_id.Cyprus_(CY)
post_video_view_time_by_country_id.Czech_Republic_(CZ)
post_video_view_time_by_country_id.Denmark_(DK)
post_video_view_time_by_country_id.Ecuador_(EC)
post_video_view_time_by_country_id.Egypt_(EG)
post_video_view_time_by_country_id.El_Salvador_(SV)
post_video_view_time_by_country_id.Estonia_(EE)
post_video_view_time_by_country_id.Finland_(FI)
post_video_view_time_by_country_id.France_(FR)
post_video_view_time_by_country_id.Georgia_(GE)
post_video_view_time_by_country_id.Germany_(DE)
post_video_view_time_by_country_id.Ghana_(GH)
post_video_view_time_by_country_id.Greece_(GR)
post_video_view_time_by_country_id.Grenada_(GD)
post_video_view_time_by_country_id.Guadeloupe_(GP)
post_video_view_time_by_country_id.Guam_(GU)
post_video_view_time_by_country_id.Guatemala_(GT)
post_video_view_time_by_country_id.Guernsey_(GG)
post_video_view_time_by_country_id.Guyana_(GY)
post_video_view_time_by_country_id.Hong_Kong_(HK)
post_video_view_time_by_country_id.Hungary_(HU)
post_video_view_time_by_country_id.Iceland_(IS)
post_video_view_time_by_country_id.India_(IN)
post_video_view_time_by_country_id.Indonesia_(ID)
post_video_view_time_by_country_id.Iraq_(IQ)
post_video_view_time_by_country_id.Ireland_(IE)
post_video_view_time_by_country_id.Isle_Of_Man_(IM)
post_video_view_time_by_country_id.Israel_(IL)
post_video_view_time_by_country_id.Italy_(IT)
post_video_view_time_by_country_id.Jamaica_(JM)
post_video_view_time_by_country_id.Japan_(JP)
post_video_view_time_by_country_id.Jersey_(JE)
post_video_view_time_by_country_id.Jordan_(JO)
post_video_view_time_by_country_id.Kenya_(KE)
post_video_view_time_by_country_id.Kosovo_(XK)
post_video_view_time_by_country_id.Kuwait_(KW)
post_video_view_time_by_country_id.Latvia_(LV)
post_video_view_time_by_country_id.Lebanon_(LB)
post_video_view_time_by_country_id.Liechtenstein_(LI)
post_video_view_time_by_country_id.Lithuania_(LT)
post_video_view_time_by_country_id.Luxembourg_(LU)
post_video_view_time_by_country_id.Macedonia_(MK)
post_video_view_time_by_country_id.Madagascar_(MG)
post_video_view_time_by_country_id.Malaysia_(MY)
post_video_view_time_by_country_id.Malta_(MT)
post_video_view_time_by_country_id.Mexico_(MX)
post_video_view_time_by_country_id.Moldova_(MD)
post_video_view_time_by_country_id.Mongolia_(MN)
post_video_view_time_by_country_id.Montenegro_(ME)
post_video_view_time_by_country_id.Morocco_(MA)
post_video_view_time_by_country_id.Mozambique_(MZ)
post_video_view_time_by_country_id.Myanmar_(MM)
post_video_view_time_by_country_id.Nepal_(NP)
post_video_view_time_by_country_id.Netherlands_(NL)
post_video_view_time_by_country_id.New_Caledonia_(NC)
post_video_view_time_by_country_id.New_Zealand_(NZ)
post_video_view_time_by_country_id.Nigeria_(NG)
post_video_view_time_by_country_id.Norway_(NO)
post_video_view_time_by_country_id.Pakistan_(PK)
post_video_view_time_by_country_id.Palestine_(PS)
post_video_view_time_by_country_id.Paraguay_(PY)
post_video_view_time_by_country_id.Peru_(PE)
post_video_view_time_by_country_id.Philippines_(PH)
post_video_view_time_by_country_id.Poland_(PL)
post_video_view_time_by_country_id.Portugal_(PT)
post_video_view_time_by_country_id.Puerto_Rico_(PR)
post_video_view_time_by_country_id.Qatar_(QA)
post_video_view_time_by_country_id.Romania_(RO)
post_video_view_time_by_country_id.Russia_(RU)
post_video_view_time_by_country_id.Samoa_(WS)
post_video_view_time_by_country_id.Saudi_Arabia_(SA)
post_video_view_time_by_country_id.Serbia_(RS)
post_video_view_time_by_country_id.Singapore_(SG)
post_video_view_time_by_country_id.Sint_Maarten_(SX)
post_video_view_time_by_country_id.Slovakia_(SK)
post_video_view_time_by_country_id.Slovenia_(SI)
post_video_view_time_by_country_id.South_Africa_(ZA)
post_video_view_time_by_country_id.South_Korea_(KR)
post_video_view_time_by_country_id.Spain_(ES)
post_video_view_time_by_country_id.Sri_Lanka_(LK)
post_video_view_time_by_country_id.Suriname_(SR)
post_video_view_time_by_country_id.Sweden_(SE)
post_video_view_time_by_country_id.Switzerland_(CH)
post_video_view_time_by_country_id.Taiwan_(TW)
post_video_view_time_by_country_id.Thailand_(TH)
post_video_view_time_by_country_id.The_Bahamas_(BS)
post_video_view_time_by_country_id.Trinidad_and_Tobago_(TT)
post_video_view_time_by_country_id.Tunisia_(TN)
post_video_view_time_by_country_id.Turkey_(TR)
post_video_view_time_by_country_id.US_Virgin_Islands_(VI)
post_video_view_time_by_country_id.Ukraine_(UA)
post_video_view_time_by_country_id.United_Arab_Emirates_(AE)
post_video_view_time_by_country_id.United_Kingdom_(GB)
post_video_view_time_by_country_id.United_States_(US)
post_video_view_time_by_country_id.Uruguay_(UY)
post_video_view_time_by_country_id.Venezuela_(VE)
post_video_view_time_by_country_id.Vietnam_(VN)
post_video_view_time_by_country_id.Zambia_(ZM)
post_video_view_time_by_distribution_type.page_owned
post_video_view_time_by_distribution_type.shared
post_video_view_time_by_region_id.Aargau_-_Switzerland
post_video_view_time_by_region_id.Abu_Dhabi_-_United_Arab_Emirates
post_video_view_time_by_region_id.Alabama_-_United_States
post_video_view_time_by_region_id.Alberta_-_Canada
post_video_view_time_by_region_id.Aquitaine_-_France
post_video_view_time_by_region_id.Arizona_-_United_States
post_video_view_time_by_region_id.Arkansas_-_United_States
post_video_view_time_by_region_id.Attica_(region)_-_Greece
post_video_view_time_by_region_id.Auckland_Region_-_New_Zealand
post_video_view_time_by_region_id.Baden-Württemberg_-_Germany
post_video_view_time_by_region_id.Bali_-_Indonesia
post_video_view_time_by_region_id.Bangkok_-_Thailand
post_video_view_time_by_region_id.Banten_-_Indonesia
post_video_view_time_by_region_id.Basel-City_-_Switzerland
post_video_view_time_by_region_id.Bayern_-_Germany
post_video_view_time_by_region_id.Berlin_-_Germany
post_video_view_time_by_region_id.Bern_-_Switzerland
post_video_view_time_by_region_id.Brandenburg_-_Germany
post_video_view_time_by_region_id.Bremen_-_Germany
post_video_view_time_by_region_id.British_Columbia_-_Canada
post_video_view_time_by_region_id.Bucharest_-_Romania
post_video_view_time_by_region_id.Budapest_-_Hungary
post_video_view_time_by_region_id.Burgenland_-_Austria
post_video_view_time_by_region_id.Cairo_Governorate_-_Egypt
post_video_view_time_by_region_id.Calabarzon_-_Philippines
post_video_view_time_by_region_id.California_-_United_States
post_video_view_time_by_region_id.Canton_of_St._Gallen_-_Switzerland
post_video_view_time_by_region_id.Capital_Region_-_Iceland
post_video_view_time_by_region_id.Capital_Region_of_Denmark_-_Denmark
post_video_view_time_by_region_id.Carinthia_-_Austria
post_video_view_time_by_region_id.Carlow_-_Ireland
post_video_view_time_by_region_id.Cataluña_-_Spain
post_video_view_time_by_region_id.Cavan_-_Ireland
post_video_view_time_by_region_id.Ceará_-_Brazil
post_video_view_time_by_region_id.Central_Denmark_Region_-_Denmark
post_video_view_time_by_region_id.Central_Finland_-_Finland
post_video_view_time_by_region_id.Central_Java_-_Indonesia
post_video_view_time_by_region_id.Central_Macedonia_-_Greece
post_video_view_time_by_region_id.Central_Region_-_Singapore
post_video_view_time_by_region_id.Chon_Buri_-_Thailand
post_video_view_time_by_region_id.Colorado_-_United_States
post_video_view_time_by_region_id.Connecticut_-_United_States
post_video_view_time_by_region_id.County_Clare_-_Ireland
post_video_view_time_by_region_id.County_Cork_-_Ireland
post_video_view_time_by_region_id.County_Laois_-_Ireland
post_video_view_time_by_region_id.County_Leitrim_-_Ireland
post_video_view_time_by_region_id.County_Longford_-_Ireland
post_video_view_time_by_region_id.County_Louth_-_Ireland
post_video_view_time_by_region_id.County_Mayo_-_Ireland
post_video_view_time_by_region_id.County_Meath_-_Ireland
post_video_view_time_by_region_id.County_Monaghan_-_Ireland
post_video_view_time_by_region_id.County_Offaly_-_Ireland
post_video_view_time_by_region_id.County_Tipperary_-_Ireland
post_video_view_time_by_region_id.County_Westmeath_-_Ireland
post_video_view_time_by_region_id.Dalarna_County_-_Sweden
post_video_view_time_by_region_id.Delaware_-_United_States
post_video_view_time_by_region_id.Delhi_-_India
post_video_view_time_by_region_id.Dhaka_Division_-_Bangladesh
post_video_view_time_by_region_id.District_of_Columbia_-_United_States
post_video_view_time_by_region_id.Distrito_Especial_-_Colombia
post_video_view_time_by_region_id.Distrito_Federal_-_Mexico
post_video_view_time_by_region_id.Donegal_-_Ireland
post_video_view_time_by_region_id.Dubai_-_United_Arab_Emirates
post_video_view_time_by_region_id.Dublin_-_Ireland
post_video_view_time_by_region_id.East_Java_-_Indonesia
post_video_view_time_by_region_id.East_Kalimantan_-_Indonesia
post_video_view_time_by_region_id.Emilia-Romagna_-_Italy
post_video_view_time_by_region_id.England_-_United_Kingdom
post_video_view_time_by_region_id.Flemish_Region_-_Belgium
post_video_view_time_by_region_id.Florida_-_United_States
post_video_view_time_by_region_id.Galway_-_Ireland
post_video_view_time_by_region_id.Georgia_-_United_States
post_video_view_time_by_region_id.Goa_-_India
post_video_view_time_by_region_id.Gujarat_-_India
post_video_view_time_by_region_id.Gävleborg_County_-_Sweden
post_video_view_time_by_region_id.Halland_County_-_Sweden
post_video_view_time_by_region_id.Hamburg_-_Germany
post_video_view_time_by_region_id.Hawaii_-_United_States
post_video_view_time_by_region_id.Hessen_-_Germany
post_video_view_time_by_region_id.Idaho_-_United_States
post_video_view_time_by_region_id.Illinois_-_United_States
post_video_view_time_by_region_id.Indiana_-_United_States
post_video_view_time_by_region_id.Iowa_-_United_States
post_video_view_time_by_region_id.Jakarta_-_Indonesia
post_video_view_time_by_region_id.Jönköping_County_-_Sweden
post_video_view_time_by_region_id.Kalmar_County_-_Sweden
post_video_view_time_by_region_id.Kansas_-_United_States
post_video_view_time_by_region_id.Karnataka_-_India
post_video_view_time_by_region_id.Kaunas_County_-_Lithuania
post_video_view_time_by_region_id.Kentucky_-_United_States
post_video_view_time_by_region_id.Kerala_-_India
post_video_view_time_by_region_id.Kerry_-_Ireland
post_video_view_time_by_region_id.Kiev_-_Ukraine
post_video_view_time_by_region_id.Kildare_-_Ireland
post_video_view_time_by_region_id.Kilkenny_-_Ireland
post_video_view_time_by_region_id.Kuala_Lumpur_-_Malaysia
post_video_view_time_by_region_id.Kurzeme_Region_-_Latvia
post_video_view_time_by_region_id.Lampung_-_Indonesia
post_video_view_time_by_region_id.Languedoc-Roussillon_-_France
post_video_view_time_by_region_id.Lazio_-_Italy
post_video_view_time_by_region_id.Lefkoşa_District_-_Cyprus
post_video_view_time_by_region_id.Liguria_-_Italy
post_video_view_time_by_region_id.Limburg_-_Netherlands
post_video_view_time_by_region_id.Limerick_-_Ireland
post_video_view_time_by_region_id.Lisbon_District_-_Portugal
post_video_view_time_by_region_id.Lombardia_-_Italy
post_video_view_time_by_region_id.Louisiana_-_United_States
post_video_view_time_by_region_id.Lower_Austria_-_Austria
post_video_view_time_by_region_id.Luxembourg_District_-_Luxembourg
post_video_view_time_by_region_id.Magdalena_-_Colombia
post_video_view_time_by_region_id.Maharashtra_-_India
post_video_view_time_by_region_id.Maine_-_United_States
post_video_view_time_by_region_id.Manitoba_-_Canada
post_video_view_time_by_region_id.Maryland_-_United_States
post_video_view_time_by_region_id.Masovian_Voivodeship_-_Poland
post_video_view_time_by_region_id.Massachusetts_-_United_States
post_video_view_time_by_region_id.Mecklenburg-Vorpommern_-_Germany
post_video_view_time_by_region_id.Metro_Manila_-_Philippines
post_video_view_time_by_region_id.Michigan_-_United_States
post_video_view_time_by_region_id.Minnesota_-_United_States
post_video_view_time_by_region_id.Mississippi_-_United_States
post_video_view_time_by_region_id.Missouri_-_United_States
post_video_view_time_by_region_id.Montana_-_United_States
post_video_view_time_by_region_id.Moscow_-_Russia
post_video_view_time_by_region_id.Nebraska_-_United_States
post_video_view_time_by_region_id.Nevada_-_United_States
post_video_view_time_by_region_id.New_Brunswick_-_Canada
post_video_view_time_by_region_id.New_Hampshire_-_United_States
post_video_view_time_by_region_id.New_Jersey_-_United_States
post_video_view_time_by_region_id.New_Mexico_-_United_States
post_video_view_time_by_region_id.New_South_Wales_-_Australia
post_video_view_time_by_region_id.New_York_-_United_States
post_video_view_time_by_region_id.Newfoundland_and_Labrador_-_Canada
post_video_view_time_by_region_id.Niedersachsen_-_Germany
post_video_view_time_by_region_id.Noord-Holland_-_Netherlands
post_video_view_time_by_region_id.Nordrhein-Westfalen_-_Germany
post_video_view_time_by_region_id.Norrbotten_County_-_Sweden
post_video_view_time_by_region_id.North_Carolina_-_United_States
post_video_view_time_by_region_id.North_Denmark_Region_-_Denmark
post_video_view_time_by_region_id.North_Sumatra_-_Indonesia
post_video_view_time_by_region_id.Northern_Ireland_-_United_Kingdom
post_video_view_time_by_region_id.Northern_Ostrobothnia_-_Finland
post_video_view_time_by_region_id.Nova_Scotia_-_Canada
post_video_view_time_by_region_id.Ohio_-_United_States
post_video_view_time_by_region_id.Oklahoma_-_United_States
post_video_view_time_by_region_id.Ontario_-_Canada
post_video_view_time_by_region_id.Oregon_-_United_States
post_video_view_time_by_region_id.Oslo_-_Norway
post_video_view_time_by_region_id.Ostrobothnia_(region)_-_Finland
post_video_view_time_by_region_id.Paraná_-_Brazil
post_video_view_time_by_region_id.Pennsylvania_-_United_States
post_video_view_time_by_region_id.Piedmont_-_Italy
post_video_view_time_by_region_id.Pirkanmaa_-_Finland
post_video_view_time_by_region_id.Prague_-_Czech_Republic
post_video_view_time_by_region_id.Provence-Alpes-Côte_d'Azur_-_France
post_video_view_time_by_region_id.Puducherry_-_India
post_video_view_time_by_region_id.Punjab_region_-_India
post_video_view_time_by_region_id.Quebec_-_Canada
post_video_view_time_by_region_id.Queensland_-_Australia
post_video_view_time_by_region_id.Rajasthan_-_India
post_video_view_time_by_region_id.Region_of_Southern_Denmark_-_Denmark
post_video_view_time_by_region_id.Rheinland-Pfalz_-_Germany
post_video_view_time_by_region_id.Rhode_Island_-_United_States
post_video_view_time_by_region_id.Rhône-Alpes_-_France
post_video_view_time_by_region_id.Riau_Islands_Province_-_Indonesia
post_video_view_time_by_region_id.Rogaland_-_Norway
post_video_view_time_by_region_id.Roscommon_-_Ireland
post_video_view_time_by_region_id.Saarland_-_Germany
post_video_view_time_by_region_id.Sachsen_-_Germany
post_video_view_time_by_region_id.Saint_Michael_-_Barbados
post_video_view_time_by_region_id.Salzburg_-_Austria
post_video_view_time_by_region_id.Santiago_Metropolitan_Region_-_Chile
post_video_view_time_by_region_id.Saskatchewan_-_Canada
post_video_view_time_by_region_id.Saxony-Anhalt_-_Germany
post_video_view_time_by_region_id.Schaan_-_Liechtenstein
post_video_view_time_by_region_id.Schleswig-Holstein_-_Germany
post_video_view_time_by_region_id.Scotland_-_United_Kingdom
post_video_view_time_by_region_id.Selangor_-_Malaysia
post_video_view_time_by_region_id.Skåne_County_-_Sweden
post_video_view_time_by_region_id.Sligo_-_Ireland
post_video_view_time_by_region_id.Solothurn_-_Switzerland
post_video_view_time_by_region_id.South_Australia_-_Australia
post_video_view_time_by_region_id.South_Carolina_-_United_States
post_video_view_time_by_region_id.South_Dakota_-_United_States
post_video_view_time_by_region_id.South_Sulawesi_-_Indonesia
post_video_view_time_by_region_id.South_Sumatra_-_Indonesia
post_video_view_time_by_region_id.Southwest_Finland_-_Finland
post_video_view_time_by_region_id.Special_Region_of_Yogyakarta_-_Indonesia
post_video_view_time_by_region_id.Stockholm_County_-_Sweden
post_video_view_time_by_region_id.Styria_-_Austria
post_video_view_time_by_region_id.São_Paulo_(state)_-_Brazil
post_video_view_time_by_region_id.Södermanland_County_-_Sweden
post_video_view_time_by_region_id.Tennessee_-_United_States
post_video_view_time_by_region_id.Texas_-_United_States
post_video_view_time_by_region_id.Thüringen_-_Germany
post_video_view_time_by_region_id.Tokyo_-_Japan
post_video_view_time_by_region_id.Trentino-Alto_Adige_-_Italy
post_video_view_time_by_region_id.Tuscany_-_Italy
post_video_view_time_by_region_id.Tyrol_-_Austria
post_video_view_time_by_region_id.Upper_Austria_-_Austria
post_video_view_time_by_region_id.Uppsala_County_-_Sweden
post_video_view_time_by_region_id.Utah_-_United_States
post_video_view_time_by_region_id.Uttarakhand_-_India
post_video_view_time_by_region_id.Uusimaa_-_Finland
post_video_view_time_by_region_id.Veneto_-_Italy
post_video_view_time_by_region_id.Vermont_-_United_States
post_video_view_time_by_region_id.Vest-Agder_-_Norway
post_video_view_time_by_region_id.Victoria_-_Australia
post_video_view_time_by_region_id.Vienna_-_Austria
post_video_view_time_by_region_id.Virginia_-_United_States
post_video_view_time_by_region_id.Vorarlberg_-_Austria
post_video_view_time_by_region_id.Värmlands_Län_-_Sweden
post_video_view_time_by_region_id.Västerbottens_Län_-_Sweden
post_video_view_time_by_region_id.Västmanlands_Län_-_Sweden
post_video_view_time_by_region_id.Västra_Götaland_County_-_Sweden
post_video_view_time_by_region_id.Wales_-_United_Kingdom
post_video_view_time_by_region_id.Washington_-_United_States
post_video_view_time_by_region_id.Waterford_-_Ireland
post_video_view_time_by_region_id.Wellington_Region_-_New_Zealand
post_video_view_time_by_region_id.West_Java_-_Indonesia
post_video_view_time_by_region_id.West_Virginia_-_United_States
post_video_view_time_by_region_id.Western_Australia_-_Australia
post_video_view_time_by_region_id.Western_Cape_-_South_Africa
post_video_view_time_by_region_id.Wexford_-_Ireland
post_video_view_time_by_region_id.Wicklow_-_Ireland
post_video_view_time_by_region_id.Wisconsin_-_United_States
post_video_view_time_by_region_id.Zealand_Region_-_Denmark
post_video_view_time_by_region_id.Zug_-_Switzerland
post_video_view_time_by_region_id.Zuid-Holland_-_Netherlands
post_video_view_time_by_region_id.Zürich_-_Switzerland
post_video_view_time_by_region_id.Île-de-France_-_France
post_video_view_time_by_region_id.Örebro_County_-_Sweden
post_video_view_time_by_region_id.Östergötland_County_-_Sweden
post_video_view_time_organic
post_video_views
post_video_views_10s
post_video_views_10s_autoplayed
post_video_views_10s_clicked_to_play
post_video_views_10s_organic
post_video_views_10s_paid
post_video_views_10s_sound_on
post_video_views_10s_unique
post_video_views_autoplayed
post_video_views_by_distribution_type.page_owned
post_video_views_by_distribution_type.shared
post_video_views_clicked_to_play
post_video_views_organic
post_video_views_organic_unique
post_video_views_paid
post_video_views_paid_unique
post_video_views_sound_on
post_video_views_unique
shares
shares.count

#For our data to be really high-powered, we need to get the dates into datetimes.
#first, can we handle the date time
#'%m/%d/%y'
vice_data['asof_date'] = pd.to_datetime(vice_data['asof_date'],\
                                             format='%Y-%m-%d-000') 
vice_data['created_time'] = pd.to_datetime(vice_data['created_time'],\
                                                format='%Y-%m-%dT%H:%M:%S+0000')

vice_data.head(3)

HOORAY! We've got a working Pandas dataframe! One more thing I want to do to it now... ¶

#let's make it query-able so that we can do more complex analysis to the table
#connecting
conn = sql.connect("vice.db") #reading in takehome data assignment
#notice that we used "con" with 1 n for the MySQL database 
#and we are using "conn" with 2 n's for the sqlite inline database
#prepaing for SQL
vice_data.to_sql("vice",conn,if_exists='replace',index=False)

pd.read_sql_query("""
SELECT
    *
FROM vice
limit 4
""", conn)

👆🏿Now that's what I'm talking about!! 😊 ¶

2. Recall that all of the records are "point-in-time" or "stock" data. For many of the below questions, you'll need to use "over time" or "flow" data. Develop a methodology that converts the stock data for a field, for example impressions into flow data to see how many impressions a post received between two timestamps¶

The key to converting the ‘point-in-time’ data to ‘flow’ data is that we are dealing with cumulative data. This is a calculus-esque area-under-the-curve concept. We can find the flow data by finding the difference between the max and the min given a time window constraint. One cool thing about cumulative numbers is that—at least in this case—they are one-way directional. So they should either stay the same or get better, but we can’t really lose a cumulative impression.

So my methodology is basically to query the Pandas dataframe for a certain time window, for a certain column value, and simply subtract the difference between the max and min value for that period to get the incremental or ‘flow’ data.

As I said in Part 0 above, and as I will say at the end of the assignment, we’d want to institute a practice like this at the ETL state because it will make the tables easier to query and to understand, and a simple SQL aggregation function will get us to the cumulative numbers should we need to see them.

#consider the following for a random story I selected from the data:
pd.read_sql_query("""
SELECT
    id,
    name,
    asof_date,
    created_time,
    post_impressions
FROM vice
WHERE id = '130581413665173_1772390549484243'
ORDER BY asof_date DESC
""", conn)

#let's say we want to see the impressions it gained from March 4th to March 4th
#we just will limit to those days and do a max - min for the difference
#NOTE: in the BETWEEN SQL function, on the upper bound date by 1 day because all the dates
#are at midnight, and since BETWEEN is an exlusive function, I think it gets confused
pd.read_sql_query("""
SELECT
    id,
    name,
    max(post_impressions) - min(post_impressions) as period_incremental_impressions,
    min(date(asof_date)) as period_start,
    max(date(asof_date)) as period_end
FROM vice
WHERE id = '130581413665173_1772390549484243'
AND asof_date BETWEEN '2018-03-04' AND '2018-03-06' --here is where we set the time period we want to check 
GROUP BY 1,2
""", conn)

#this is just what we wanted...it checks out:
41354 - 38076

3278

3. Which post id received the most total impressions?¶

#which ID got the most impressions
pd.read_sql_query("""
SELECT
    id,
    name,
    date(asof_date) as date,
    created_time,
    post_impressions
FROM vice
ORDER BY post_impressions DESC
LIMIT 1
""", conn)

#by the way we can also look at this post overtime, just out of curiosity:
modern_slavery = pd.read_sql_query("""
SELECT
    id,
    name,
    asof_date,
    created_time,
    post_impressions
FROM vice
WHERE id = '167115176655082_1773445632712068'
ORDER BY asof_date ASC
""", conn)

modern_slavery

p1 = plt.plot(modern_slavery.asof_date, modern_slavery.post_impressions)
ax_ = plt.subplot()
vals = ax_.get_yticks()
ax_.set_yticklabels(['{:,.1f}'.format(x/1000000) for x in vals])
ax_.set_xticklabels(['March 3','March 4', 'March 5', 'March 6','March 7', 'March 8',\
                   'March 9'], style='italic')
plt.xlabel("Day", fontsize = 12)
plt.ylabel("Millions of Impressions", fontsize = 12)
plt.suptitle("'Investigating Modern-Day Slavery in the South'", fontsize = 14, fontweight='bold')
plt.title("Cumulative Impressions: March 2 - March 9, 2018")
plt.savefig("ex_2_modern_slavery_post_cumulative_impressions.png", bbox_inches = "tight")
plt.show()

👆🏿This is very impressive, and it speaks to the public's hunger for powerful journalism. ¶

4. How many total impressions across all posts were there on 2018-03-06?¶

cumulative_impressions = pd.read_sql_query("""
SELECT
    date(asof_date) as date,
    sum(post_impressions) as cumulative_impressions
FROM vice
GROUP BY 1
ORDER BY 1 ASC
""", conn)

cumulative_impressions

#impressions across VICE on March 6
print(str(cumulative_impressions.cumulative_impressions[4] - cumulative_impressions.cumulative_impressions[3])\
+ " impressions")

39066274 impressions

Please Note: I will want to talk with the team to see if ~40 million impressions in a day is reasonable. At first, I thought it was high, but if we do a rough back-of-the-envelope calculation, it doesn't seem unheard of. We have about 3,000 rows of data across the database-dataframe, which include duplicate articles over 8 days. Let's say we have, on average, 3000/8 = 375 articles a day. Then, if we divide 40 million impressions by 375, we get about 107,000 impressions per article per day on average. Considering that there are some blockbuster articles/videos, I think this isn't unreasonable for an average, but I would certainly flag this and check with the team.

Assumption: I assume that the impressions listed for, say, the March 6th entry are all the impressions accumulated by the very end of March 6th. Thus, if I subtract the cumulative March 5th entry from the cumulative March 6th entry, I'll get the incremental March 6th numbers.

Please Also Note: Notice that March 9th has fewer cumulative impressions than March 8th does. This should not be possible, so we'll want to look further. Likely an article has been taken down, or is no longer in the database.

5. Facebook posts have a permalink of the format https://www.facebook.com/[page_id]/[posts|videos]/post_id/. The id field in the raw JSON file consists of the page_id and the post_id separated by an underscore. Add a column to your dataset that creates a working permalink for each post¶

#first we wnat to check what various sources wew have in the database-dataframe
pd.read_sql_query("""
SELECT DISTINCT
    from_name
FROM vice
""", conn)

👆🏿Assumption: For simplicity's sake, I assume that if the post is a video it MUST be from the "VICE Video" from_name category.

#now I just iterate through the list following the permanlink naming convention logic
#As a reminder: https://www.facebook.com/[page_id]/[posts|videos]/post_id/
id_confirm = [] #this I use just for my backend checking process, but I won't print id_confirm here
facebook_permalinks = []
part1= 'https://www.facebook.com/'
part2_posts = '/posts/'
part2_videos = '/videos/'
end = '/'
for i in range(len(vice_data.from_name)):
    id_confirm.append(vice_data.id[i])
    if vice_data.from_name[i] == 'VICE Video':
        split = vice_data.id[i].split("_")
        facebook_permalinks.append(part1 + split[0] + part2_videos + split[1] + end)
    else:
        other_split = vice_data.id[i].split("_")
        facebook_permalinks.append(part1 + other_split[0] + part2_posts + other_split[1] + end)

Now I can tack this new column on to the table. The order is fine because I iterated through the data structure line by line and appended line by line. However, not to be shown here, but as a fail safe, I have the option of doing a more complex join on a unique id (I'd have to concatenate the id_confirm with something else, like the asof_date to make it truly unique.

vice_data['facebook_permalink'] = facebook_permalinks

#you can see here that it's lining up as it's supposed to:
vice_data[['id','facebook_permalink']].head()

#and here're 3 rows from the full table:
#if you scroll alllllllll the way to the right, you'll see the new facebook_permalink column at the end
vice_data.head(3)

6. It's important for our social editors to be able to quickly evaluate the success of a Facebook post. Impressions is not a good benchmark for this since different pages get different amounts of traffic. We also are concerned with other data points like total engagements, reactions, etc. Design and implement a metric that encompasses some of the available fields to evaluate the relative success of an individual post¶

There are many ways to approach this problem, but the key is that you want a relative metric that compares posts in an apples-to-apples way. Ratios and multiples are great metrics for this purpose.

From my point of view, I really like shares / impressions and likes / impressions. They give us a good idea of what people who actually saw the content do having seen the content. I like to think of this ratio as a percentage. So our of how many impressions was there a share; out of how many impressions was there a like. In my experience hitting 10% for either of those metrics is unheard of. You can actually get a good feel for these metrics by looking at YouTube video views and likes and dislikes counts. So I like these metrics because they are relatively well understood.

The only thing is I'll have to do a some Python looping to get us from cumulative numbers to incremental numbers, and I'll do that below.

7. Create a visualization using your metric. Be creative, it could be over time for one or many posts, a comparison of different posts, etc.¶

#let's look at these metrics across VICE and overtime
engage = pd.read_sql_query("""
SELECT
    date(asof_date) as date,
    max(post_impressions) as impressions,
    max([shares.count]) as shares,
    max(1.0*post_reactions_like_total) as likes,
    round(100*(max(1.0*post_reactions_like_total) / max(post_impressions)),3) as likes_per_imp,
    round(100*(max([shares.count]) / max(post_impressions)),3) as shares_per_imp
FROM vice
GROUP BY 1
ORDER BY 1 ASC
""", conn)

#remember these are STILL CUMULATIVE
engage

#this next bit iterates through the above table and gives us incremental numbers, which I'll then graph
day = []
impressions = []
shares = []
likes = []
for i in range(len(engage.date)):
    if i == 0: #this just helps us figure out how to get an 'incremental'-ish number for the first entry 
               #to do it, I'll just accept whatever numbers we have for the first date as its 'incremental' numbers
        day.append(i+1)
        impressions.append(engage.impressions[i])
        shares.append(engage.shares[i])
        likes.append(engage.likes[i])
    else:
        incremental_impressions = engage.impressions[i] - engage.impressions[i-1]
        incremental_shares = engage.shares[i] - engage.shares[i-1]
        incremental_likes = engage.likes[i] - engage.likes[i-1]
        day.append(i+1)
        impressions.append(incremental_impressions)
        shares.append(incremental_shares)
        likes.append(incremental_likes)

#now I've got to get these lists into ratios to fit my metrics
likes_per_impression = [ 100*((l*1.0) / (i*1.0)) for l,i in zip(likes, impressions)]
shares_per_impression = [ 100*((s*1.0) / (i*1.0)) for s,i in zip(shares, impressions)]

#now let's visualize them!
#plt.scatter(day, impressions)
p1 = plt.plot(day, likes_per_impression)
p2 = plt.plot(day, shares_per_impression)
ax = plt.subplot()
vals = ax.get_yticks()
ax.set_yticklabels(['{:,.2%}'.format(x/100) for x in vals])
ax.set_xticklabels(['0','March 2','March 3','March 4', 'March 5', 'March 6','March 7', 'March 8',\
                   'March 9'], style='italic')
plt.xticks(rotation=-25)
plt.xlabel("Day", fontsize = 12)
plt.ylabel("Percentage", fontsize = 12)
plt.legend((p1[0],p2[0]),('Likes to Impression Ratio', 'Shares to Impression Ratio'),\
           loc='center left', bbox_to_anchor=(1, 0.5))
plt.suptitle("VICE Media Overall Daily Engagement", fontsize = 14, fontweight='bold')
plt.title("March 2 - March 9, 2018")
plt.savefig("ex_3_engagement_metrics.png", bbox_inches = "tight")
plt.show()

Please Note: Here, we can really see how much a power-post can move our numbers. I would show this to the team as evidence that even one big story can make a huge impact. I would want to look deeper here, if time allows, but I think the rise of "Investigating Modern-Day Slavery in the South" had a large impact.

8. What caveats would you have to add to an analysis using this data, especially around data quality, consistency or completeness? What changes or improvements would you ask the Data Engineering team to make to the data? What are some transformations you'd have to define and implement in order to make this data usable to a junior analyst who was only skilled in SQL?¶

There are many caveats to be discussed; here a few I’d highlight:

Meeting with Data Engineering Team.¶

Build Incremental Numbers into the ETL Pipeline. We have to figure out how we want to handle the Facebook API’s output. We want to setup an ETL pipeline to first incrementalize this data (rather than looking at it cumulatively), and then get that incremental information into a relational database that analysts can work with.

Choose the Data Wisely. The JSON files have an immense amount of data, especially when you flatten them, but we don’t need all of it. We should decided what are the say, 10 things, we really need to track and get good at those. If we have enough financial resources and enough engineering horsepower, I’m OK with storing and saving all of it, but in practice you rarely have that luxury.

Write Up Documentation. We also need to setup documentation for what each column means, and what the distinct range of values are. For example, I had to do a number of ‘select distinct’s’ to see how many categories were in a certain column; we will want to have that documented.

Set up a Weekly Call with Facebook API dev team. We’ll want to make sure we have a contact in Facebook, which they should have for their larger content-providers. I was unsure how some cumulative data seemed to go down, and I am thinking that as VICE grows there will need to be more of a live feed approach to a data warehouse. But, for this question, I’d want to know why any cumulative numbers would go down…which in this case is likely because an article in a former JSON was not in a subsequent JSON, and then we’ll probably start to want to build a ‘history table’ that keeps track of everything for us.

More Demographic Info. There was a lot of wonderful data, and we’d definitely want to know about WHO is liking, reacting, viewing, and sharing the post. Of course, we would need to observe privacy rules. I am a lawyer and I can look into this further.

Looker? I have heard great things about Looker, and we may want to set that up, so everyone can get access to the data even if they don’t know how to code. For the data team to be real stakeholders, we must get buy in from the whole organization, and I think Looker is a great first step.

Overall, really great stuff. Lots of hard work here from the team. Overall, I’m really impressed by the shear mount of things that are tracked. We’ve got a lot of information on what kinds of posts resonate. And I actually followed a few of the Facebook Permalinks, and I was really impressed by the journalism quality. I like how VICE can sort of get the viewer right there in the event, and just roll the camera. It allows viewers to make their own conclusion.

BONUS. I just wanted to do one more data visualization to look at overall post impressions broken up by 'from_name', which I'm asusming is the Facebook data's equivalent of vertical.¶

#we canjust use max fucntions here since it's all cumulative
vertical_impressions = pd.read_sql_query("""
SELECT
    from_name,
    max(post_impressions) as impressions
FROM vice
GROUP BY 1
ORDER BY 2 desc
""", conn)

vertical_impressions

#make pie chart
pie_labels = vertical_impressions.from_name
colors = ['lightskyblue','sandybrown','limegreen','hotpink','orchid']
piefig = plt.figure(figsize=(10,9))
pie_explode = (0.3, 0.4, 0.5, 0.6, 0.7) 
plt.pie(vertical_impressions.impressions, labels=pie_labels, autopct='%1.1f%%',\
       explode=pie_explode, pctdistance=0.05, labeldistance=1.1, colors=colors,\
       textprops={'fontsize': 11})
plt.suptitle("Total Impressions By Vertical\nMarch 2 - March 9, 2018",\
             fontsize = 18, fontweight = 'bold')
plt.savefig("ex_4_total_impressions_by_vertical.png", bbox_inches = "tight")
plt.show()

One interesting takeaway from this is that VICE Video makes up fewer impressions than I would've expected. This could be because there fewer videos, but I'd use this as the kick-off to a deeper analysis on whether VICE videos should get more resources.

	article_id
0	j539yy
1	qv9wn5
2	wjy8en
3	gyeaqb
4	gyea53
5	a3p8mg
6	594nwq
7	598xaa
8	wjyzgx
9	j5393d

	date	articles
0	2018-09-01	60
1	2018-09-02	59
2	2018-09-03	289
3	2018-09-04	438
4	2018-09-05	415

	day_of_week	articles
0	1	650
1	7	653
2	6	3271
3	2	3529
4	5	3931
5	3	3984
6	4	4050

	veritcal	article_count	prct_of_whole
0	VICE	9597	47.82
1	i-D	2288	11.40
2	Noisey	2251	11.22
3	Motherboard	1337	6.66
4	Munchies	1169	5.83

	locale	article_count	list_locale_verticals	count_locale_verticals
0	en_us	4225	Amuse,Broadly,FREE,Garage,i-D,Motherboard,Munc...	13
1	en_uk	1564	Broadly,FREE,i-D,Motherboard,Munchies,Noisey,T...	8
2	en_au	1465	Broadly,Creators,FREE,i-D,Motherboard,Munchies...	9
3	en_ca	1418	FREE,Noisey,VICE,VICE News,VICE Sports	5
4	es_latam	1119	Amuse,Broadly,Motherboard,Munchies,Noisey,Toni...	7

Table of Contents¶

Part 0. - Opening Remarks and Thoughts¶

Overall here’s the gameplan I used for this analysis:¶

Part 1. - SQL¶

1. Each unique article is represented by a six charater, alphanumeric ID in the URL string. Start this exercise by using a regular expression to extract the article_id from the URL.¶

For example, xwpd7w is the article_id here https://www.vice.com/en_us/article/xwpd7w/how-a-brooklyn-gang-may-have-gotten-crazy-rich-dealing-for-el-chapo ¶

2. Using the published_day field, calculate the unique daily and weekly article output. How does the content output trend throughout the week?¶

3. VICE's editorial department is structured into different verticals (e.g. Noisey covers music and Motherboard covers tech).¶

4. VICE publishes content across a range of global offices. Each unique office is identified by their locale which is represented using a locale url parameter (e.g. en_us for the United States and en_uk for the United Kingdom). However, not every vertical publishes content in every locale.¶

Which verticals are published in which locales? Write a query creating a table showing each locale, their total article output, and a concatenated list of all of the verticals publishing in each locale.¶

Part 2. - Python¶

1. Please read in all of the files into a single data structure that will be usable for further analysis (for example, a pandas DataFrame)¶

HOORAY! We've got a working Pandas dataframe! One more thing I want to do to it now... ¶

👆🏿Now that's what I'm talking about!! 😊 ¶

3. Which post id received the most total impressions?¶

👆🏿This is very impressive, and it speaks to the public's hunger for powerful journalism. ¶

4. How many total impressions across all posts were there on 2018-03-06?¶

5. Facebook posts have a permalink of the format https://www.facebook.com/[page_id]/[posts|videos]/post_id/. The id field in the raw JSON file consists of the page_id and the post_id separated by an underscore. Add a column to your dataset that creates a working permalink for each post¶

Top 5 Posts by Shares per Impression¶

Top 5 Posts by Likes per Impression¶

7. Create a visualization using your metric. Be creative, it could be over time for one or many posts, a comparison of different posts, etc.¶

Meeting with Data Engineering Team.¶

BONUS. I just wanted to do one more data visualization to look at overall post impressions broken up by 'from_name', which I'm asusming is the Facebook data's equivalent of vertical.¶

Thank you so much for your time and consideration.¶

Best,¶

George John Jordan Thomas Aquinas Hayward, Optimist¶

	asof_date	comments_total_count	created_time	from_id	from_name	id	link	name	post_consumptions	post_consumptions_by_type.link_clicks	post_consumptions_by_type.other_clicks	post_consumptions_by_type.photo_view	post_consumptions_by_type.video_play	post_consumptions_by_type_unique.link_clicks	post_consumptions_by_type_unique.other_clicks	post_consumptions_by_type_unique.photo_view	post_consumptions_by_type_unique.video_play	post_consumptions_unique	post_engaged_fan	post_engaged_users	post_engagements	post_fan_reach	post_impressions	post_impressions_by_paid_non_paid.total	post_impressions_by_paid_non_paid.unpaid	post_impressions_by_paid_non_paid_unique.total	post_impressions_by_paid_non_paid_unique.unpaid	post_impressions_by_story_type.other	post_impressions_by_story_type_unique.other	post_impressions_fan	post_impressions_fan_unique	post_impressions_organic	post_impressions_organic_unique	post_impressions_unique	post_impressions_viral	post_impressions_viral_unique	post_negative_feedback	post_negative_feedback_by_type.hide_all_clicks	post_negative_feedback_by_type.hide_clicks	post_negative_feedback_by_type.report_spam_clicks	post_negative_feedback_by_type.unlike_page_clicks	post_negative_feedback_by_type_unique.hide_all_clicks	post_negative_feedback_by_type_unique.hide_clicks	post_negative_feedback_by_type_unique.report_spam_clicks	post_negative_feedback_by_type_unique.unlike_page_clicks	post_reactions_anger_total	post_reactions_by_type_total.anger	post_reactions_by_type_total.haha	post_reactions_by_type_total.like	post_reactions_by_type_total.love	post_reactions_by_type_total.sorry	post_reactions_by_type_total.wow	post_reactions_haha_total	post_reactions_like_total	post_reactions_love_total	post_reactions_sorry_total	post_reactions_wow_total	post_video_avg_time_watched	post_video_complete_views_organic	post_video_complete_views_organic_unique	post_video_length	post_video_retention_graph_autoplayed.0	post_video_retention_graph_autoplayed.1	post_video_retention_graph_autoplayed.10	post_video_retention_graph_autoplayed.11	post_video_retention_graph_autoplayed.12	post_video_retention_graph_autoplayed.13	post_video_retention_graph_autoplayed.14	post_video_retention_graph_autoplayed.15	post_video_retention_graph_autoplayed.16	post_video_retention_graph_autoplayed.17	post_video_retention_graph_autoplayed.18	post_video_retention_graph_autoplayed.19	post_video_retention_graph_autoplayed.2	post_video_retention_graph_autoplayed.20	post_video_retention_graph_autoplayed.21	post_video_retention_graph_autoplayed.22	post_video_retention_graph_autoplayed.23	post_video_retention_graph_autoplayed.24	post_video_retention_graph_autoplayed.25	post_video_retention_graph_autoplayed.26	post_video_retention_graph_autoplayed.27	post_video_retention_graph_autoplayed.28	post_video_retention_graph_autoplayed.29	post_video_retention_graph_autoplayed.3	post_video_retention_graph_autoplayed.30	post_video_retention_graph_autoplayed.31	post_video_retention_graph_autoplayed.32	post_video_retention_graph_autoplayed.33	post_video_retention_graph_autoplayed.34	post_video_retention_graph_autoplayed.35	post_video_retention_graph_autoplayed.36	post_video_retention_graph_autoplayed.37	post_video_retention_graph_autoplayed.38	post_video_retention_graph_autoplayed.39	post_video_retention_graph_autoplayed.4	post_video_retention_graph_autoplayed.40	post_video_retention_graph_autoplayed.5	post_video_retention_graph_autoplayed.6	post_video_retention_graph_autoplayed.7	post_video_retention_graph_autoplayed.8	post_video_retention_graph_autoplayed.9	post_video_retention_graph_clicked_to_play.0	post_video_retention_graph_clicked_to_play.1	post_video_retention_graph_clicked_to_play.10	post_video_retention_graph_clicked_to_play.11	post_video_retention_graph_clicked_to_play.12	post_video_retention_graph_clicked_to_play.13	post_video_retention_graph_clicked_to_play.14	post_video_retention_graph_clicked_to_play.15	post_video_retention_graph_clicked_to_play.16	post_video_retention_graph_clicked_to_play.17	post_video_retention_graph_clicked_to_play.18	post_video_retention_graph_clicked_to_play.19	post_video_retention_graph_clicked_to_play.2	post_video_retention_graph_clicked_to_play.20	post_video_retention_graph_clicked_to_play.21	post_video_retention_graph_clicked_to_play.22	post_video_retention_graph_clicked_to_play.23	post_video_retention_graph_clicked_to_play.24	post_video_retention_graph_clicked_to_play.25	post_video_retention_graph_clicked_to_play.26	post_video_retention_graph_clicked_to_play.27	post_video_retention_graph_clicked_to_play.28	post_video_retention_graph_clicked_to_play.29	post_video_retention_graph_clicked_to_play.3	post_video_retention_graph_clicked_to_play.30	post_video_retention_graph_clicked_to_play.31	post_video_retention_graph_clicked_to_play.32	post_video_retention_graph_clicked_to_play.33	post_video_retention_graph_clicked_to_play.34	post_video_retention_graph_clicked_to_play.35	post_video_retention_graph_clicked_to_play.36	post_video_retention_graph_clicked_to_play.37	post_video_retention_graph_clicked_to_play.38	post_video_retention_graph_clicked_to_play.39	post_video_retention_graph_clicked_to_play.4	post_video_retention_graph_clicked_to_play.40	post_video_retention_graph_clicked_to_play.5	post_video_retention_graph_clicked_to_play.6	post_video_retention_graph_clicked_to_play.7	post_video_retention_graph_clicked_to_play.8	post_video_retention_graph_clicked_to_play.9	post_video_view_time_by_age_bucket_and_gender.F.13-17	post_video_view_time_by_age_bucket_and_gender.F.18-24	post_video_view_time_by_age_bucket_and_gender.F.25-34	post_video_view_time_by_age_bucket_and_gender.F.35-44	post_video_view_time_by_age_bucket_and_gender.F.45-54	post_video_view_time_by_age_bucket_and_gender.F.55-64	post_video_view_time_by_age_bucket_and_gender.F.65+	post_video_view_time_by_age_bucket_and_gender.M.13-17	post_video_view_time_by_age_bucket_and_gender.M.18-24	post_video_view_time_by_age_bucket_and_gender.M.25-34	post_video_view_time_by_age_bucket_and_gender.M.35-44	post_video_view_time_by_age_bucket_and_gender.M.45-54	post_video_view_time_by_age_bucket_and_gender.M.55-64	post_video_view_time_by_age_bucket_and_gender.M.65+	post_video_view_time_by_age_bucket_and_gender.U.13-17	post_video_view_time_by_age_bucket_and_gender.U.18-24	post_video_view_time_by_age_bucket_and_gender.U.25-34	post_video_view_time_by_age_bucket_and_gender.U.35-44	post_video_view_time_by_age_bucket_and_gender.U.45-54	post_video_view_time_by_age_bucket_and_gender.U.55-64	post_video_view_time_by_age_bucket_and_gender.U.65+	post_video_view_time_by_country_id.Afghanistan_(AF)	post_video_view_time_by_country_id.Albania_(AL)	post_video_view_time_by_country_id.Algeria_(DZ)	post_video_view_time_by_country_id.Argentina_(AR)	post_video_view_time_by_country_id.Aruba_(AW)	post_video_view_time_by_country_id.Australia_(AU)	post_video_view_time_by_country_id.Austria_(AT)	post_video_view_time_by_country_id.Bahrain_(BH)	post_video_view_time_by_country_id.Bangladesh_(BD)	post_video_view_time_by_country_id.Barbados_(BB)	post_video_view_time_by_country_id.Belgium_(BE)	post_video_view_time_by_country_id.Belize_(BZ)	post_video_view_time_by_country_id.Bolivia_(BO)	post_video_view_time_by_country_id.Bosnia_and_Herzegovina_(BA)	post_video_view_time_by_country_id.Brazil_(BR)	post_video_view_time_by_country_id.Brunei_(BN)	post_video_view_time_by_country_id.Bulgaria_(BG)	post_video_view_time_by_country_id.Cambodia_(KH)	post_video_view_time_by_country_id.Canada_(CA)	post_video_view_time_by_country_id.Cayman_Islands_(KY)	post_video_view_time_by_country_id.Chile_(CL)	post_video_view_time_by_country_id.China_(CN)	post_video_view_time_by_country_id.Colombia_(CO)	post_video_view_time_by_country_id.Costa_Rica_(CR)	post_video_view_time_by_country_id.Croatia_(HR)	post_video_view_time_by_country_id.Curaçao_(CW)	post_video_view_time_by_country_id.Cyprus_(CY)	post_video_view_time_by_country_id.Czech_Republic_(CZ)	post_video_view_time_by_country_id.Denmark_(DK)	post_video_view_time_by_country_id.Ecuador_(EC)	post_video_view_time_by_country_id.Egypt_(EG)	post_video_view_time_by_country_id.El_Salvador_(SV)	post_video_view_time_by_country_id.Estonia_(EE)	post_video_view_time_by_country_id.Finland_(FI)	post_video_view_time_by_country_id.France_(FR)	post_video_view_time_by_country_id.Georgia_(GE)	post_video_view_time_by_country_id.Germany_(DE)	post_video_view_time_by_country_id.Ghana_(GH)	post_video_view_time_by_country_id.Greece_(GR)	post_video_view_time_by_country_id.Grenada_(GD)	post_video_view_time_by_country_id.Guadeloupe_(GP)	post_video_view_time_by_country_id.Guam_(GU)	post_video_view_time_by_country_id.Guatemala_(GT)	post_video_view_time_by_country_id.Guernsey_(GG)	post_video_view_time_by_country_id.Guyana_(GY)	post_video_view_time_by_country_id.Hong_Kong_(HK)	post_video_view_time_by_country_id.Hungary_(HU)	post_video_view_time_by_country_id.Iceland_(IS)	post_video_view_time_by_country_id.India_(IN)	post_video_view_time_by_country_id.Indonesia_(ID)	post_video_view_time_by_country_id.Iraq_(IQ)	post_video_view_time_by_country_id.Ireland_(IE)	post_video_view_time_by_country_id.Isle_Of_Man_(IM)	post_video_view_time_by_country_id.Israel_(IL)	post_video_view_time_by_country_id.Italy_(IT)	post_video_view_time_by_country_id.Jamaica_(JM)	post_video_view_time_by_country_id.Japan_(JP)	post_video_view_time_by_country_id.Jersey_(JE)	post_video_view_time_by_country_id.Jordan_(JO)	post_video_view_time_by_country_id.Kenya_(KE)	post_video_view_time_by_country_id.Kosovo_(XK)	post_video_view_time_by_country_id.Kuwait_(KW)	post_video_view_time_by_country_id.Latvia_(LV)	post_video_view_time_by_country_id.Lebanon_(LB)	post_video_view_time_by_country_id.Liechtenstein_(LI)	post_video_view_time_by_country_id.Lithuania_(LT)	post_video_view_time_by_country_id.Luxembourg_(LU)	post_video_view_time_by_country_id.Macedonia_(MK)	post_video_view_time_by_country_id.Madagascar_(MG)	post_video_view_time_by_country_id.Malaysia_(MY)	post_video_view_time_by_country_id.Malta_(MT)	post_video_view_time_by_country_id.Mexico_(MX)	post_video_view_time_by_country_id.Moldova_(MD)	post_video_view_time_by_country_id.Mongolia_(MN)	post_video_view_time_by_country_id.Montenegro_(ME)	post_video_view_time_by_country_id.Morocco_(MA)	post_video_view_time_by_country_id.Mozambique_(MZ)	post_video_view_time_by_country_id.Myanmar_(MM)	post_video_view_time_by_country_id.Nepal_(NP)	post_video_view_time_by_country_id.Netherlands_(NL)	post_video_view_time_by_country_id.New_Caledonia_(NC)	post_video_view_time_by_country_id.New_Zealand_(NZ)	post_video_view_time_by_country_id.Nigeria_(NG)	post_video_view_time_by_country_id.Norway_(NO)	post_video_view_time_by_country_id.Pakistan_(PK)	post_video_view_time_by_country_id.Palestine_(PS)	post_video_view_time_by_country_id.Paraguay_(PY)	post_video_view_time_by_country_id.Peru_(PE)	post_video_view_time_by_country_id.Philippines_(PH)	post_video_view_time_by_country_id.Poland_(PL)	post_video_view_time_by_country_id.Portugal_(PT)	post_video_view_time_by_country_id.Puerto_Rico_(PR)	post_video_view_time_by_country_id.Qatar_(QA)	post_video_view_time_by_country_id.Romania_(RO)	post_video_view_time_by_country_id.Russia_(RU)	post_video_view_time_by_country_id.Samoa_(WS)	post_video_view_time_by_country_id.Saudi_Arabia_(SA)	post_video_view_time_by_country_id.Serbia_(RS)	post_video_view_time_by_country_id.Singapore_(SG)	post_video_view_time_by_country_id.Sint_Maarten_(SX)	post_video_view_time_by_country_id.Slovakia_(SK)	post_video_view_time_by_country_id.Slovenia_(SI)	post_video_view_time_by_country_id.South_Africa_(ZA)	post_video_view_time_by_country_id.South_Korea_(KR)	post_video_view_time_by_country_id.Spain_(ES)	post_video_view_time_by_country_id.Sri_Lanka_(LK)	post_video_view_time_by_country_id.Suriname_(SR)	post_video_view_time_by_country_id.Sweden_(SE)	post_video_view_time_by_country_id.Switzerland_(CH)	post_video_view_time_by_country_id.Taiwan_(TW)	post_video_view_time_by_country_id.Thailand_(TH)	post_video_view_time_by_country_id.The_Bahamas_(BS)	post_video_view_time_by_country_id.Trinidad_and_Tobago_(TT)	post_video_view_time_by_country_id.Tunisia_(TN)	post_video_view_time_by_country_id.Turkey_(TR)	post_video_view_time_by_country_id.US_Virgin_Islands_(VI)	post_video_view_time_by_country_id.Ukraine_(UA)	post_video_view_time_by_country_id.United_Arab_Emirates_(AE)	post_video_view_time_by_country_id.United_Kingdom_(GB)	post_video_view_time_by_country_id.United_States_(US)	post_video_view_time_by_country_id.Uruguay_(UY)	post_video_view_time_by_country_id.Venezuela_(VE)	post_video_view_time_by_country_id.Vietnam_(VN)	post_video_view_time_by_country_id.Zambia_(ZM)	post_video_view_time_by_distribution_type.page_owned	post_video_view_time_by_distribution_type.shared	post_video_view_time_by_region_id.Aargau_-_Switzerland	post_video_view_time_by_region_id.Abu_Dhabi_-_United_Arab_Emirates	post_video_view_time_by_region_id.Alabama_-_United_States	post_video_view_time_by_region_id.Alberta_-_Canada	post_video_view_time_by_region_id.Aquitaine_-_France	post_video_view_time_by_region_id.Arizona_-_United_States	post_video_view_time_by_region_id.Arkansas_-_United_States	post_video_view_time_by_region_id.Attica_(region)_-_Greece	post_video_view_time_by_region_id.Auckland_Region_-_New_Zealand	post_video_view_time_by_region_id.Baden-Württemberg_-_Germany	post_video_view_time_by_region_id.Bali_-_Indonesia	post_video_view_time_by_region_id.Bangkok_-_Thailand	post_video_view_time_by_region_id.Banten_-_Indonesia	post_video_view_time_by_region_id.Basel-City_-_Switzerland	post_video_view_time_by_region_id.Bayern_-_Germany	post_video_view_time_by_region_id.Berlin_-_Germany	post_video_view_time_by_region_id.Bern_-_Switzerland	post_video_view_time_by_region_id.Brandenburg_-_Germany	post_video_view_time_by_region_id.Bremen_-_Germany	post_video_view_time_by_region_id.British_Columbia_-_Canada	post_video_view_time_by_region_id.Bucharest_-_Romania	post_video_view_time_by_region_id.Budapest_-_Hungary	post_video_view_time_by_region_id.Burgenland_-_Austria	post_video_view_time_by_region_id.Cairo_Governorate_-_Egypt	post_video_view_time_by_region_id.Calabarzon_-_Philippines	post_video_view_time_by_region_id.California_-_United_States	post_video_view_time_by_region_id.Canton_of_St._Gallen_-_Switzerland	post_video_view_time_by_region_id.Capital_Region_-_Iceland	post_video_view_time_by_region_id.Capital_Region_of_Denmark_-_Denmark	post_video_view_time_by_region_id.Carinthia_-_Austria	post_video_view_time_by_region_id.Carlow_-_Ireland	post_video_view_time_by_region_id.Cataluña_-_Spain	post_video_view_time_by_region_id.Cavan_-_Ireland	post_video_view_time_by_region_id.Ceará_-_Brazil	post_video_view_time_by_region_id.Central_Denmark_Region_-_Denmark	post_video_view_time_by_region_id.Central_Finland_-_Finland	post_video_view_time_by_region_id.Central_Java_-_Indonesia	post_video_view_time_by_region_id.Central_Macedonia_-_Greece	post_video_view_time_by_region_id.Central_Region_-_Singapore	post_video_view_time_by_region_id.Chon_Buri_-_Thailand	post_video_view_time_by_region_id.Colorado_-_United_States	post_video_view_time_by_region_id.Connecticut_-_United_States	post_video_view_time_by_region_id.County_Clare_-_Ireland	post_video_view_time_by_region_id.County_Cork_-_Ireland	post_video_view_time_by_region_id.County_Laois_-_Ireland	post_video_view_time_by_region_id.County_Leitrim_-_Ireland	post_video_view_time_by_region_id.County_Longford_-_Ireland	post_video_view_time_by_region_id.County_Louth_-_Ireland	post_video_view_time_by_region_id.County_Mayo_-_Ireland	post_video_view_time_by_region_id.County_Meath_-_Ireland	post_video_view_time_by_region_id.County_Monaghan_-_Ireland	post_video_view_time_by_region_id.County_Offaly_-_Ireland	post_video_view_time_by_region_id.County_Tipperary_-_Ireland	post_video_view_time_by_region_id.County_Westmeath_-_Ireland	post_video_view_time_by_region_id.Dalarna_County_-_Sweden	post_video_view_time_by_region_id.Delaware_-_United_States	post_video_view_time_by_region_id.Delhi_-_India	post_video_view_time_by_region_id.Dhaka_Division_-_Bangladesh	post_video_view_time_by_region_id.District_of_Columbia_-_United_States	post_video_view_time_by_region_id.Distrito_Especial_-_Colombia	post_video_view_time_by_region_id.Distrito_Federal_-_Mexico	post_video_view_time_by_region_id.Donegal_-_Ireland	post_video_view_time_by_region_id.Dubai_-_United_Arab_Emirates	post_video_view_time_by_region_id.Dublin_-_Ireland	post_video_view_time_by_region_id.East_Java_-_Indonesia	post_video_view_time_by_region_id.East_Kalimantan_-_Indonesia	post_video_view_time_by_region_id.Emilia-Romagna_-_Italy	post_video_view_time_by_region_id.England_-_United_Kingdom	post_video_view_time_by_region_id.Flemish_Region_-_Belgium	post_video_view_time_by_region_id.Florida_-_United_States	post_video_view_time_by_region_id.Galway_-_Ireland	post_video_view_time_by_region_id.Georgia_-_United_States	post_video_view_time_by_region_id.Goa_-_India	post_video_view_time_by_region_id.Gujarat_-_India	post_video_view_time_by_region_id.Gävleborg_County_-_Sweden	post_video_view_time_by_region_id.Halland_County_-_Sweden	post_video_view_time_by_region_id.Hamburg_-_Germany	post_video_view_time_by_region_id.Hawaii_-_United_States	post_video_view_time_by_region_id.Hessen_-_Germany	post_video_view_time_by_region_id.Idaho_-_United_States	post_video_view_time_by_region_id.Illinois_-_United_States	post_video_view_time_by_region_id.Indiana_-_United_States	post_video_view_time_by_region_id.Iowa_-_United_States	post_video_view_time_by_region_id.Jakarta_-_Indonesia	post_video_view_time_by_region_id.Jönköping_County_-_Sweden	post_video_view_time_by_region_id.Kalmar_County_-_Sweden	post_video_view_time_by_region_id.Kansas_-_United_States	post_video_view_time_by_region_id.Karnataka_-_India	post_video_view_time_by_region_id.Kaunas_County_-_Lithuania	post_video_view_time_by_region_id.Kentucky_-_United_States	post_video_view_time_by_region_id.Kerala_-_India	post_video_view_time_by_region_id.Kerry_-_Ireland	post_video_view_time_by_region_id.Kiev_-_Ukraine	post_video_view_time_by_region_id.Kildare_-_Ireland	post_video_view_time_by_region_id.Kilkenny_-_Ireland	post_video_view_time_by_region_id.Kuala_Lumpur_-_Malaysia	post_video_view_time_by_region_id.Kurzeme_Region_-_Latvia	post_video_view_time_by_region_id.Lampung_-_Indonesia	post_video_view_time_by_region_id.Languedoc-Roussillon_-_France	post_video_view_time_by_region_id.Lazio_-_Italy	post_video_view_time_by_region_id.Lefkoşa_District_-_Cyprus	post_video_view_time_by_region_id.Liguria_-_Italy	post_video_view_time_by_region_id.Limburg_-_Netherlands	post_video_view_time_by_region_id.Limerick_-_Ireland	post_video_view_time_by_region_id.Lisbon_District_-_Portugal	post_video_view_time_by_region_id.Lombardia_-_Italy	post_video_view_time_by_region_id.Louisiana_-_United_States	post_video_view_time_by_region_id.Lower_Austria_-_Austria	post_video_view_time_by_region_id.Luxembourg_District_-_Luxembourg	post_video_view_time_by_region_id.Magdalena_-_Colombia	post_video_view_time_by_region_id.Maharashtra_-_India	post_video_view_time_by_region_id.Maine_-_United_States	post_video_view_time_by_region_id.Manitoba_-_Canada	post_video_view_time_by_region_id.Maryland_-_United_States	post_video_view_time_by_region_id.Masovian_Voivodeship_-_Poland	post_video_view_time_by_region_id.Massachusetts_-_United_States	post_video_view_time_by_region_id.Mecklenburg-Vorpommern_-_Germany	post_video_view_time_by_region_id.Metro_Manila_-_Philippines	post_video_view_time_by_region_id.Michigan_-_United_States	post_video_view_time_by_region_id.Minnesota_-_United_States	post_video_view_time_by_region_id.Mississippi_-_United_States	post_video_view_time_by_region_id.Missouri_-_United_States	post_video_view_time_by_region_id.Montana_-_United_States	post_video_view_time_by_region_id.Moscow_-_Russia	post_video_view_time_by_region_id.Nebraska_-_United_States	post_video_view_time_by_region_id.Nevada_-_United_States	post_video_view_time_by_region_id.New_Brunswick_-_Canada	post_video_view_time_by_region_id.New_Hampshire_-_United_States	post_video_view_time_by_region_id.New_Jersey_-_United_States	post_video_view_time_by_region_id.New_Mexico_-_United_States	post_video_view_time_by_region_id.New_South_Wales_-_Australia	post_video_view_time_by_region_id.New_York_-_United_States	post_video_view_time_by_region_id.Newfoundland_and_Labrador_-_Canada	post_video_view_time_by_region_id.Niedersachsen_-_Germany	post_video_view_time_by_region_id.Noord-Holland_-_Netherlands	post_video_view_time_by_region_id.Nordrhein-Westfalen_-_Germany	post_video_view_time_by_region_id.Norrbotten_County_-_Sweden	post_video_view_time_by_region_id.North_Carolina_-_United_States	post_video_view_time_by_region_id.North_Denmark_Region_-_Denmark	post_video_view_time_by_region_id.North_Sumatra_-_Indonesia	post_video_view_time_by_region_id.Northern_Ireland_-_United_Kingdom	post_video_view_time_by_region_id.Northern_Ostrobothnia_-_Finland	post_video_view_time_by_region_id.Nova_Scotia_-_Canada	post_video_view_time_by_region_id.Ohio_-_United_States	post_video_view_time_by_region_id.Oklahoma_-_United_States	post_video_view_time_by_region_id.Ontario_-_Canada	post_video_view_time_by_region_id.Oregon_-_United_States	post_video_view_time_by_region_id.Oslo_-_Norway	post_video_view_time_by_region_id.Ostrobothnia_(region)_-_Finland	post_video_view_time_by_region_id.Paraná_-_Brazil	post_video_view_time_by_region_id.Pennsylvania_-_United_States	post_video_view_time_by_region_id.Piedmont_-_Italy	post_video_view_time_by_region_id.Pirkanmaa_-_Finland	post_video_view_time_by_region_id.Prague_-_Czech_Republic	post_video_view_time_by_region_id.Provence-Alpes-Côte_d'Azur_-_France	post_video_view_time_by_region_id.Puducherry_-_India	post_video_view_time_by_region_id.Punjab_region_-_India	post_video_view_time_by_region_id.Quebec_-_Canada	post_video_view_time_by_region_id.Queensland_-_Australia	post_video_view_time_by_region_id.Rajasthan_-_India	post_video_view_time_by_region_id.Region_of_Southern_Denmark_-_Denmark	post_video_view_time_by_region_id.Rheinland-Pfalz_-_Germany	post_video_view_time_by_region_id.Rhode_Island_-_United_States	post_video_view_time_by_region_id.Rhône-Alpes_-_France	post_video_view_time_by_region_id.Riau_Islands_Province_-_Indonesia	post_video_view_time_by_region_id.Rogaland_-_Norway	post_video_view_time_by_region_id.Roscommon_-_Ireland	post_video_view_time_by_region_id.Saarland_-_Germany	post_video_view_time_by_region_id.Sachsen_-_Germany	post_video_view_time_by_region_id.Saint_Michael_-_Barbados	post_video_view_time_by_region_id.Salzburg_-_Austria	post_video_view_time_by_region_id.Santiago_Metropolitan_Region_-_Chile	post_video_view_time_by_region_id.Saskatchewan_-_Canada	post_video_view_time_by_region_id.Saxony-Anhalt_-_Germany	post_video_view_time_by_region_id.Schaan_-_Liechtenstein	post_video_view_time_by_region_id.Schleswig-Holstein_-_Germany	post_video_view_time_by_region_id.Scotland_-_United_Kingdom	post_video_view_time_by_region_id.Selangor_-_Malaysia	post_video_view_time_by_region_id.Skåne_County_-_Sweden	post_video_view_time_by_region_id.Sligo_-_Ireland	post_video_view_time_by_region_id.Solothurn_-_Switzerland	post_video_view_time_by_region_id.South_Australia_-_Australia	post_video_view_time_by_region_id.South_Carolina_-_United_States	post_video_view_time_by_region_id.South_Dakota_-_United_States	post_video_view_time_by_region_id.South_Sulawesi_-_Indonesia	post_video_view_time_by_region_id.South_Sumatra_-_Indonesia	post_video_view_time_by_region_id.Southwest_Finland_-_Finland	post_video_view_time_by_region_id.Special_Region_of_Yogyakarta_-_Indonesia	post_video_view_time_by_region_id.Stockholm_County_-_Sweden	post_video_view_time_by_region_id.Styria_-_Austria	post_video_view_time_by_region_id.São_Paulo_(state)_-_Brazil	post_video_view_time_by_region_id.Södermanland_County_-_Sweden	post_video_view_time_by_region_id.Tennessee_-_United_States	post_video_view_time_by_region_id.Texas_-_United_States	post_video_view_time_by_region_id.Thüringen_-_Germany	post_video_view_time_by_region_id.Tokyo_-_Japan	post_video_view_time_by_region_id.Trentino-Alto_Adige_-_Italy	post_video_view_time_by_region_id.Tuscany_-_Italy	post_video_view_time_by_region_id.Tyrol_-_Austria	post_video_view_time_by_region_id.Upper_Austria_-_Austria	post_video_view_time_by_region_id.Uppsala_County_-_Sweden	post_video_view_time_by_region_id.Utah_-_United_States	post_video_view_time_by_region_id.Uttarakhand_-_India	post_video_view_time_by_region_id.Uusimaa_-_Finland	post_video_view_time_by_region_id.Veneto_-_Italy	post_video_view_time_by_region_id.Vermont_-_United_States	post_video_view_time_by_region_id.Vest-Agder_-_Norway	post_video_view_time_by_region_id.Victoria_-_Australia	post_video_view_time_by_region_id.Vienna_-_Austria	post_video_view_time_by_region_id.Virginia_-_United_States	post_video_view_time_by_region_id.Vorarlberg_-_Austria	post_video_view_time_by_region_id.Värmlands_Län_-_Sweden	post_video_view_time_by_region_id.Västerbottens_Län_-_Sweden	post_video_view_time_by_region_id.Västmanlands_Län_-_Sweden	post_video_view_time_by_region_id.Västra_Götaland_County_-_Sweden	post_video_view_time_by_region_id.Wales_-_United_Kingdom	post_video_view_time_by_region_id.Washington_-_United_States	post_video_view_time_by_region_id.Waterford_-_Ireland	post_video_view_time_by_region_id.Wellington_Region_-_New_Zealand	post_video_view_time_by_region_id.West_Java_-_Indonesia	post_video_view_time_by_region_id.West_Virginia_-_United_States	post_video_view_time_by_region_id.Western_Australia_-_Australia	post_video_view_time_by_region_id.Western_Cape_-_South_Africa	post_video_view_time_by_region_id.Wexford_-_Ireland	post_video_view_time_by_region_id.Wicklow_-_Ireland	post_video_view_time_by_region_id.Wisconsin_-_United_States	post_video_view_time_by_region_id.Zealand_Region_-_Denmark	post_video_view_time_by_region_id.Zug_-_Switzerland	post_video_view_time_by_region_id.Zuid-Holland_-_Netherlands	post_video_view_time_by_region_id.Zürich_-_Switzerland	post_video_view_time_by_region_id.Île-de-France_-_France	post_video_view_time_by_region_id.Örebro_County_-_Sweden	post_video_view_time_by_region_id.Östergötland_County_-_Sweden	post_video_views_10s_autoplayed	post_video_views_10s_clicked_to_play	post_video_views_10s_organic	post_video_views_10s_sound_on	post_video_views_10s_unique	post_video_views_autoplayed	post_video_views_by_distribution_type.page_owned	post_video_views_by_distribution_type.shared	post_video_views_clicked_to_play	post_video_views_organic	post_video_views_organic_unique	post_video_views_sound_on	post_video_views_unique	shares.count
0	2018-03-09-000	40	2018-03-07T23:30:00+0000	167115176655082	VICE	167115176655082_2094008024166264	https://www.facebook.com/VICE/videos/209400802...	Being A Trans Women's Hockey Player	6366	355.0	5430.0	2.0	579.0	340.0	4039.0	2.0	584.0	4469	4357	4541	6583	225447	278195	278195	278195	230021	230021	1397.0	1049.0	271070	225447	276798	229621	230021	1397	1049	6	3.0	3.0	NaN	NaN	3.0	3.0	NaN	NaN	0	0	7	81	15	0	0	7	81	15	0	0	6574	1311	1284	211049	1.0	0.5906	0.1299	0.1222	0.1169	0.1101	0.1027	0.0994	0.0969	0.0944	0.0903	0.0863	0.3318	0.0822	0.079	0.0765	0.0744	0.0701	0.0649	0.0638	0.0621	0.0591	0.0556	0.2771	0.0505	0.0483	0.047	0.0426	0.0412	0.0383	0.036	0.0312	0.0264	0.024	0.2271	0.0176	0.1978	0.169	0.1552	0.1466	0.1396	1.0	0.9086	0.5185	0.5086	0.484	0.4815	0.4667	0.4667	0.4691	0.4691	0.4617	0.442	0.8074	0.4272	0.4049	0.4025	0.3951	0.3852	0.3778	0.3679	0.3506	0.3309	0.316	0.7704	0.2988	0.2864	0.2741	0.2568	0.2593	0.2346	0.2296	0.2049	0.1753	0.1531	0.7309	0.1086	0.6963	0.637	0.6025	0.5802	0.5481	2314221.0	111336016.0	215130380.0	69935016.0	14857937.0	7356273.0	7481435.0	3951051.0	253258527.0	489476559.0	165090202.0	38183184.0	10104701.0	14985793.0	137176.0	4027709.0	9070035.0	5026767.0	1121871.0	87972.0	1094463.0	NaN	NaN	NaN	NaN	NaN	976.0	297.0	NaN	NaN	NaN	169.0	NaN	NaN	22.0	66.0	NaN	29.0	NaN	3879.0	NaN	22.0	NaN	27.0	NaN	21.0	NaN	NaN	65.0	241.0	NaN	NaN	NaN	32.0	120.0	430.0	NaN	1092.0	NaN	355.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36.0	NaN	36.0	21.0	NaN	281.0	NaN	27.0	263.0	NaN	68.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.0	NaN	NaN	NaN	29.0	NaN	147.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	486.0	NaN	237.0	NaN	91.0	NaN	NaN	NaN	NaN	38.0	136.0	83.0	NaN	NaN	117.0	NaN	NaN	NaN	68.0	40.0	NaN	NaN	NaN	35.0	29.0	180.0	NaN	NaN	295.0	149.0	NaN	34.0	NaN	NaN	NaN	NaN	NaN	NaN	37.0	3078.0	9394.0	NaN	NaN	NaN	NaN	1.421316e+09	3365730.0	NaN	NaN	NaN	29811730.0	NaN	8997445.0	NaN	9735939.0	NaN	NaN	NaN	NaN	NaN	NaN	10800620.0	12501285.0	NaN	NaN	NaN	35035164.0	NaN	NaN	NaN	NaN	NaN	81166619.0	NaN	NaN	8415916.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22050894.0	7889381.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9416478.0	NaN	NaN	NaN	150780697.0	7977170.0	24807180.0	NaN	8843002.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30718008.0	8281605.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8929210.0	NaN	25456004.0	NaN	NaN	18832158.0	16039035.0	NaN	10204134.0	NaN	NaN	NaN	NaN	8618399.0	NaN	17280606.0	NaN	17858038.0	44477230.0	NaN	NaN	10358092.0	12991690.0	NaN	12919234.0	NaN	NaN	NaN	NaN	NaN	15396758.0	NaN	88817417.0	13514484.0	NaN	NaN	NaN	23581631.0	NaN	NaN	NaN	NaN	NaN	NaN	42355065.0	11355052.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10296381.0	NaN	NaN	NaN	20342348.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29285576.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18985415.0	9897714.0	11169450.0	NaN	NaN	NaN	NaN	NaN	8964712.0	20910659.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11395354.0	NaN	NaN	NaN	NaN	10522094.0	NaN	NaN	15755	345	16100	4916	16100	44778	45124.0	64.0	410	45188	45041	7548	45041	11.0
1	2018-03-09-000	139	2018-03-07T23:01:30+0000	167115176655082	VICE	167115176655082_2061072230592691	https://motherboard.vice.com/en_us/article/pam...	Google Engineers Think This 72-Qubit Processor...	31706	21592.0	10110.0	4.0	NaN	20440.0	7638.0	4.0	NaN	26855	27040	28404	34358	416752	581612	581612	581612	449338	449338	37921.0	28114.0	541844	416752	543691	419092	449338	37921	28114	13	6.0	7.0	NaN	NaN	6.0	7.0	NaN	NaN	0	0	25	1647	83	1	237	25	1647	83	1	237	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	372.0
2	2018-03-09-000	106	2018-03-07T22:30:27+0000	167115176655082	VICE	167115176655082_2061036290596285	https://noisey.vice.com/en_us/article/9kz7jp/v...	I, Like Vince Staples, Will "Shut the Fuck Up ...	19233	9664.0	9568.0	1.0	NaN	9251.0	7528.0	1.0	NaN	15031	15083	16008	21563	274787	380562	380562	380562	291179	291179	18032.0	12695.0	360346	274787	362530	276565	291179	18032	12695	17	5.0	12.0	NaN	NaN	5.0	12.0	NaN	NaN	0	0	212	1494	115	1	4	212	1494	115	1	4	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	165.0
3	2018-03-09-000	54	2018-03-07T22:01:21+0000	167115176655082	VICE	167115176655082_2061006690599245	https://www.vice.com/en_us/article/qve9yq/my-t...	Here Are Some Solid Options for Trump's Next W...	3244	1771.0	1472.0	1.0	NaN	1673.0	1133.0	1.0	NaN	2681	2796	2880	3678	200117	267465	267465	267465	204979	204979	2894.0	2222.0	260253	200117	264571	203956	204979	2894	2222	13	6.0	7.0	NaN	NaN	6.0	4.0	NaN	NaN	1	1	85	196	7	0	1	85	196	7	0	1	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	26.0

	asof_date	comments_total_count	created_time	from_id	from_name	id	link	name	post_consumptions	post_consumptions_by_type.link_clicks	post_consumptions_by_type.other_clicks	post_consumptions_by_type.photo_view	post_consumptions_by_type.video_play	post_consumptions_by_type_unique.link_clicks	post_consumptions_by_type_unique.other_clicks	post_consumptions_by_type_unique.photo_view	post_consumptions_by_type_unique.video_play	post_consumptions_unique	post_engaged_fan	post_engaged_users	post_engagements	post_fan_reach	post_impressions	post_impressions_by_paid_non_paid.total	post_impressions_by_paid_non_paid.unpaid	post_impressions_by_paid_non_paid_unique.total	post_impressions_by_paid_non_paid_unique.unpaid	post_impressions_by_story_type.other	post_impressions_by_story_type_unique.other	post_impressions_fan	post_impressions_fan_unique	post_impressions_organic	post_impressions_organic_unique	post_impressions_unique	post_impressions_viral	post_impressions_viral_unique	post_negative_feedback	post_negative_feedback_by_type.hide_all_clicks	post_negative_feedback_by_type.hide_clicks	post_negative_feedback_by_type.report_spam_clicks	post_negative_feedback_by_type.unlike_page_clicks	post_negative_feedback_by_type_unique.hide_all_clicks	post_negative_feedback_by_type_unique.hide_clicks	post_negative_feedback_by_type_unique.report_spam_clicks	post_negative_feedback_by_type_unique.unlike_page_clicks	post_reactions_by_type_total.haha	post_reactions_by_type_total.like	post_reactions_by_type_total.love	post_reactions_by_type_total.sorry	post_reactions_by_type_total.wow	post_reactions_haha_total	post_reactions_like_total	post_reactions_love_total	post_reactions_sorry_total	post_reactions_wow_total	post_video_avg_time_watched	post_video_complete_views_organic	post_video_complete_views_organic_unique	post_video_length	post_video_retention_graph_autoplayed.0	post_video_retention_graph_autoplayed.1	post_video_retention_graph_autoplayed.10	post_video_retention_graph_autoplayed.11	post_video_retention_graph_autoplayed.12	post_video_retention_graph_autoplayed.13	post_video_retention_graph_autoplayed.14	post_video_retention_graph_autoplayed.15	post_video_retention_graph_autoplayed.16	post_video_retention_graph_autoplayed.17	post_video_retention_graph_autoplayed.18	post_video_retention_graph_autoplayed.19	post_video_retention_graph_autoplayed.2	post_video_retention_graph_autoplayed.20	post_video_retention_graph_autoplayed.21	post_video_retention_graph_autoplayed.22	post_video_retention_graph_autoplayed.23	post_video_retention_graph_autoplayed.24	post_video_retention_graph_autoplayed.25	post_video_retention_graph_autoplayed.26	post_video_retention_graph_autoplayed.27	post_video_retention_graph_autoplayed.28	post_video_retention_graph_autoplayed.29	post_video_retention_graph_autoplayed.3	post_video_retention_graph_autoplayed.30	post_video_retention_graph_autoplayed.31	post_video_retention_graph_autoplayed.32	post_video_retention_graph_autoplayed.33	post_video_retention_graph_autoplayed.34	post_video_retention_graph_autoplayed.35	post_video_retention_graph_autoplayed.36	post_video_retention_graph_autoplayed.37	post_video_retention_graph_autoplayed.38	post_video_retention_graph_autoplayed.39	post_video_retention_graph_autoplayed.4	post_video_retention_graph_autoplayed.40	post_video_retention_graph_autoplayed.5	post_video_retention_graph_autoplayed.6	post_video_retention_graph_autoplayed.7	post_video_retention_graph_autoplayed.8	post_video_retention_graph_autoplayed.9	post_video_retention_graph_clicked_to_play.0	post_video_retention_graph_clicked_to_play.1	post_video_retention_graph_clicked_to_play.10	post_video_retention_graph_clicked_to_play.11	post_video_retention_graph_clicked_to_play.12	post_video_retention_graph_clicked_to_play.13	post_video_retention_graph_clicked_to_play.14	post_video_retention_graph_clicked_to_play.15	post_video_retention_graph_clicked_to_play.16	post_video_retention_graph_clicked_to_play.17	post_video_retention_graph_clicked_to_play.18	post_video_retention_graph_clicked_to_play.19	post_video_retention_graph_clicked_to_play.2	post_video_retention_graph_clicked_to_play.20	post_video_retention_graph_clicked_to_play.21	post_video_retention_graph_clicked_to_play.22	post_video_retention_graph_clicked_to_play.23	post_video_retention_graph_clicked_to_play.24	post_video_retention_graph_clicked_to_play.25	post_video_retention_graph_clicked_to_play.26	post_video_retention_graph_clicked_to_play.27	post_video_retention_graph_clicked_to_play.28	post_video_retention_graph_clicked_to_play.29	post_video_retention_graph_clicked_to_play.3	post_video_retention_graph_clicked_to_play.30	post_video_retention_graph_clicked_to_play.31	post_video_retention_graph_clicked_to_play.32	post_video_retention_graph_clicked_to_play.33	post_video_retention_graph_clicked_to_play.34	post_video_retention_graph_clicked_to_play.35	post_video_retention_graph_clicked_to_play.36	post_video_retention_graph_clicked_to_play.37	post_video_retention_graph_clicked_to_play.38	post_video_retention_graph_clicked_to_play.39	post_video_retention_graph_clicked_to_play.4	post_video_retention_graph_clicked_to_play.40	post_video_retention_graph_clicked_to_play.5	post_video_retention_graph_clicked_to_play.6	post_video_retention_graph_clicked_to_play.7	post_video_retention_graph_clicked_to_play.8	post_video_retention_graph_clicked_to_play.9	post_video_view_time_by_age_bucket_and_gender.F.13-17	post_video_view_time_by_age_bucket_and_gender.F.18-24	post_video_view_time_by_age_bucket_and_gender.F.25-34	post_video_view_time_by_age_bucket_and_gender.F.35-44	post_video_view_time_by_age_bucket_and_gender.F.45-54	post_video_view_time_by_age_bucket_and_gender.F.55-64	post_video_view_time_by_age_bucket_and_gender.F.65+	post_video_view_time_by_age_bucket_and_gender.M.13-17	post_video_view_time_by_age_bucket_and_gender.M.18-24	post_video_view_time_by_age_bucket_and_gender.M.25-34	post_video_view_time_by_age_bucket_and_gender.M.35-44	post_video_view_time_by_age_bucket_and_gender.M.45-54	post_video_view_time_by_age_bucket_and_gender.M.55-64	post_video_view_time_by_age_bucket_and_gender.M.65+	post_video_view_time_by_age_bucket_and_gender.U.13-17	post_video_view_time_by_age_bucket_and_gender.U.18-24	post_video_view_time_by_age_bucket_and_gender.U.25-34	post_video_view_time_by_age_bucket_and_gender.U.35-44	post_video_view_time_by_age_bucket_and_gender.U.45-54	post_video_view_time_by_age_bucket_and_gender.U.55-64	post_video_view_time_by_age_bucket_and_gender.U.65+	post_video_view_time_by_country_id.Afghanistan_(AF)	post_video_view_time_by_country_id.Albania_(AL)	post_video_view_time_by_country_id.Algeria_(DZ)	post_video_view_time_by_country_id.Argentina_(AR)	post_video_view_time_by_country_id.Aruba_(AW)	post_video_view_time_by_country_id.Australia_(AU)	post_video_view_time_by_country_id.Austria_(AT)	post_video_view_time_by_country_id.Bahrain_(BH)	post_video_view_time_by_country_id.Bangladesh_(BD)	post_video_view_time_by_country_id.Barbados_(BB)	post_video_view_time_by_country_id.Belgium_(BE)	post_video_view_time_by_country_id.Belize_(BZ)	post_video_view_time_by_country_id.Bolivia_(BO)	post_video_view_time_by_country_id.Bosnia_and_Herzegovina_(BA)	post_video_view_time_by_country_id.Brazil_(BR)	post_video_view_time_by_country_id.Brunei_(BN)	post_video_view_time_by_country_id.Bulgaria_(BG)	post_video_view_time_by_country_id.Cambodia_(KH)	post_video_view_time_by_country_id.Canada_(CA)	post_video_view_time_by_country_id.Cayman_Islands_(KY)	post_video_view_time_by_country_id.Chile_(CL)	post_video_view_time_by_country_id.China_(CN)	post_video_view_time_by_country_id.Colombia_(CO)	post_video_view_time_by_country_id.Costa_Rica_(CR)	post_video_view_time_by_country_id.Croatia_(HR)	post_video_view_time_by_country_id.Curaçao_(CW)	post_video_view_time_by_country_id.Cyprus_(CY)	post_video_view_time_by_country_id.Czech_Republic_(CZ)	post_video_view_time_by_country_id.Denmark_(DK)	post_video_view_time_by_country_id.Ecuador_(EC)	post_video_view_time_by_country_id.Egypt_(EG)	post_video_view_time_by_country_id.El_Salvador_(SV)	post_video_view_time_by_country_id.Estonia_(EE)	post_video_view_time_by_country_id.Finland_(FI)	post_video_view_time_by_country_id.France_(FR)	post_video_view_time_by_country_id.Georgia_(GE)	post_video_view_time_by_country_id.Germany_(DE)	post_video_view_time_by_country_id.Ghana_(GH)	post_video_view_time_by_country_id.Greece_(GR)	post_video_view_time_by_country_id.Grenada_(GD)	post_video_view_time_by_country_id.Guadeloupe_(GP)	post_video_view_time_by_country_id.Guam_(GU)	post_video_view_time_by_country_id.Guatemala_(GT)	post_video_view_time_by_country_id.Guernsey_(GG)	post_video_view_time_by_country_id.Guyana_(GY)	post_video_view_time_by_country_id.Hong_Kong_(HK)	post_video_view_time_by_country_id.Hungary_(HU)	post_video_view_time_by_country_id.Iceland_(IS)	post_video_view_time_by_country_id.India_(IN)	post_video_view_time_by_country_id.Indonesia_(ID)	post_video_view_time_by_country_id.Iraq_(IQ)	post_video_view_time_by_country_id.Ireland_(IE)	post_video_view_time_by_country_id.Isle_Of_Man_(IM)	post_video_view_time_by_country_id.Israel_(IL)	post_video_view_time_by_country_id.Italy_(IT)	post_video_view_time_by_country_id.Jamaica_(JM)	post_video_view_time_by_country_id.Japan_(JP)	post_video_view_time_by_country_id.Jersey_(JE)	post_video_view_time_by_country_id.Jordan_(JO)	post_video_view_time_by_country_id.Kenya_(KE)	post_video_view_time_by_country_id.Kosovo_(XK)	post_video_view_time_by_country_id.Kuwait_(KW)	post_video_view_time_by_country_id.Latvia_(LV)	post_video_view_time_by_country_id.Lebanon_(LB)	post_video_view_time_by_country_id.Liechtenstein_(LI)	post_video_view_time_by_country_id.Lithuania_(LT)	post_video_view_time_by_country_id.Luxembourg_(LU)	post_video_view_time_by_country_id.Macedonia_(MK)	post_video_view_time_by_country_id.Madagascar_(MG)	post_video_view_time_by_country_id.Malaysia_(MY)	post_video_view_time_by_country_id.Malta_(MT)	post_video_view_time_by_country_id.Mexico_(MX)	post_video_view_time_by_country_id.Moldova_(MD)	post_video_view_time_by_country_id.Mongolia_(MN)	post_video_view_time_by_country_id.Montenegro_(ME)	post_video_view_time_by_country_id.Morocco_(MA)	post_video_view_time_by_country_id.Mozambique_(MZ)	post_video_view_time_by_country_id.Myanmar_(MM)	post_video_view_time_by_country_id.Nepal_(NP)	post_video_view_time_by_country_id.Netherlands_(NL)	post_video_view_time_by_country_id.New_Caledonia_(NC)	post_video_view_time_by_country_id.New_Zealand_(NZ)	post_video_view_time_by_country_id.Nigeria_(NG)	post_video_view_time_by_country_id.Norway_(NO)	post_video_view_time_by_country_id.Pakistan_(PK)	post_video_view_time_by_country_id.Palestine_(PS)	post_video_view_time_by_country_id.Paraguay_(PY)	post_video_view_time_by_country_id.Peru_(PE)	post_video_view_time_by_country_id.Philippines_(PH)	post_video_view_time_by_country_id.Poland_(PL)	post_video_view_time_by_country_id.Portugal_(PT)	post_video_view_time_by_country_id.Puerto_Rico_(PR)	post_video_view_time_by_country_id.Qatar_(QA)	post_video_view_time_by_country_id.Romania_(RO)	post_video_view_time_by_country_id.Russia_(RU)	post_video_view_time_by_country_id.Samoa_(WS)	post_video_view_time_by_country_id.Saudi_Arabia_(SA)	post_video_view_time_by_country_id.Serbia_(RS)	post_video_view_time_by_country_id.Singapore_(SG)	post_video_view_time_by_country_id.Sint_Maarten_(SX)	post_video_view_time_by_country_id.Slovakia_(SK)	post_video_view_time_by_country_id.Slovenia_(SI)	post_video_view_time_by_country_id.South_Africa_(ZA)	post_video_view_time_by_country_id.South_Korea_(KR)	post_video_view_time_by_country_id.Spain_(ES)	post_video_view_time_by_country_id.Sri_Lanka_(LK)	post_video_view_time_by_country_id.Suriname_(SR)	post_video_view_time_by_country_id.Sweden_(SE)	post_video_view_time_by_country_id.Switzerland_(CH)	post_video_view_time_by_country_id.Taiwan_(TW)	post_video_view_time_by_country_id.Thailand_(TH)	post_video_view_time_by_country_id.The_Bahamas_(BS)	post_video_view_time_by_country_id.Trinidad_and_Tobago_(TT)	post_video_view_time_by_country_id.Tunisia_(TN)	post_video_view_time_by_country_id.Turkey_(TR)	post_video_view_time_by_country_id.US_Virgin_Islands_(VI)	post_video_view_time_by_country_id.Ukraine_(UA)	post_video_view_time_by_country_id.United_Arab_Emirates_(AE)	post_video_view_time_by_country_id.United_Kingdom_(GB)	post_video_view_time_by_country_id.United_States_(US)	post_video_view_time_by_country_id.Uruguay_(UY)	post_video_view_time_by_country_id.Venezuela_(VE)	post_video_view_time_by_country_id.Vietnam_(VN)	post_video_view_time_by_country_id.Zambia_(ZM)	post_video_view_time_by_distribution_type.page_owned	post_video_view_time_by_distribution_type.shared	post_video_view_time_by_region_id.Aargau_-_Switzerland	post_video_view_time_by_region_id.Abu_Dhabi_-_United_Arab_Emirates	post_video_view_time_by_region_id.Alabama_-_United_States	post_video_view_time_by_region_id.Alberta_-_Canada	post_video_view_time_by_region_id.Aquitaine_-_France	post_video_view_time_by_region_id.Arizona_-_United_States	post_video_view_time_by_region_id.Arkansas_-_United_States	post_video_view_time_by_region_id.Attica_(region)_-_Greece	post_video_view_time_by_region_id.Auckland_Region_-_New_Zealand	post_video_view_time_by_region_id.Baden-Württemberg_-_Germany	post_video_view_time_by_region_id.Bali_-_Indonesia	post_video_view_time_by_region_id.Bangkok_-_Thailand	post_video_view_time_by_region_id.Banten_-_Indonesia	post_video_view_time_by_region_id.Basel-City_-_Switzerland	post_video_view_time_by_region_id.Bayern_-_Germany	post_video_view_time_by_region_id.Berlin_-_Germany	post_video_view_time_by_region_id.Bern_-_Switzerland	post_video_view_time_by_region_id.Brandenburg_-_Germany	post_video_view_time_by_region_id.Bremen_-_Germany	post_video_view_time_by_region_id.British_Columbia_-_Canada	post_video_view_time_by_region_id.Bucharest_-_Romania	post_video_view_time_by_region_id.Budapest_-_Hungary	post_video_view_time_by_region_id.Burgenland_-_Austria	post_video_view_time_by_region_id.Cairo_Governorate_-_Egypt	post_video_view_time_by_region_id.Calabarzon_-_Philippines	post_video_view_time_by_region_id.California_-_United_States	post_video_view_time_by_region_id.Canton_of_St._Gallen_-_Switzerland	post_video_view_time_by_region_id.Capital_Region_-_Iceland	post_video_view_time_by_region_id.Capital_Region_of_Denmark_-_Denmark	post_video_view_time_by_region_id.Carinthia_-_Austria	post_video_view_time_by_region_id.Carlow_-_Ireland	post_video_view_time_by_region_id.Cataluña_-_Spain	post_video_view_time_by_region_id.Cavan_-_Ireland	post_video_view_time_by_region_id.Ceará_-_Brazil	post_video_view_time_by_region_id.Central_Denmark_Region_-_Denmark	post_video_view_time_by_region_id.Central_Finland_-_Finland	post_video_view_time_by_region_id.Central_Java_-_Indonesia	post_video_view_time_by_region_id.Central_Macedonia_-_Greece	post_video_view_time_by_region_id.Central_Region_-_Singapore	post_video_view_time_by_region_id.Chon_Buri_-_Thailand	post_video_view_time_by_region_id.Colorado_-_United_States	post_video_view_time_by_region_id.Connecticut_-_United_States	post_video_view_time_by_region_id.County_Clare_-_Ireland	post_video_view_time_by_region_id.County_Cork_-_Ireland	post_video_view_time_by_region_id.County_Laois_-_Ireland	post_video_view_time_by_region_id.County_Leitrim_-_Ireland	post_video_view_time_by_region_id.County_Longford_-_Ireland	post_video_view_time_by_region_id.County_Louth_-_Ireland	post_video_view_time_by_region_id.County_Mayo_-_Ireland	post_video_view_time_by_region_id.County_Meath_-_Ireland	post_video_view_time_by_region_id.County_Monaghan_-_Ireland	post_video_view_time_by_region_id.County_Offaly_-_Ireland	post_video_view_time_by_region_id.County_Tipperary_-_Ireland	post_video_view_time_by_region_id.County_Westmeath_-_Ireland	post_video_view_time_by_region_id.Dalarna_County_-_Sweden	post_video_view_time_by_region_id.Delaware_-_United_States	post_video_view_time_by_region_id.Delhi_-_India	post_video_view_time_by_region_id.Dhaka_Division_-_Bangladesh	post_video_view_time_by_region_id.District_of_Columbia_-_United_States	post_video_view_time_by_region_id.Distrito_Especial_-_Colombia	post_video_view_time_by_region_id.Distrito_Federal_-_Mexico	post_video_view_time_by_region_id.Donegal_-_Ireland	post_video_view_time_by_region_id.Dubai_-_United_Arab_Emirates	post_video_view_time_by_region_id.Dublin_-_Ireland	post_video_view_time_by_region_id.East_Java_-_Indonesia	post_video_view_time_by_region_id.East_Kalimantan_-_Indonesia	post_video_view_time_by_region_id.Emilia-Romagna_-_Italy	post_video_view_time_by_region_id.England_-_United_Kingdom	post_video_view_time_by_region_id.Flemish_Region_-_Belgium	post_video_view_time_by_region_id.Florida_-_United_States	post_video_view_time_by_region_id.Galway_-_Ireland	post_video_view_time_by_region_id.Georgia_-_United_States	post_video_view_time_by_region_id.Goa_-_India	post_video_view_time_by_region_id.Gujarat_-_India	post_video_view_time_by_region_id.Gävleborg_County_-_Sweden	post_video_view_time_by_region_id.Halland_County_-_Sweden	post_video_view_time_by_region_id.Hamburg_-_Germany	post_video_view_time_by_region_id.Hawaii_-_United_States	post_video_view_time_by_region_id.Hessen_-_Germany	post_video_view_time_by_region_id.Idaho_-_United_States	post_video_view_time_by_region_id.Illinois_-_United_States	post_video_view_time_by_region_id.Indiana_-_United_States	post_video_view_time_by_region_id.Iowa_-_United_States	post_video_view_time_by_region_id.Jakarta_-_Indonesia	post_video_view_time_by_region_id.Jönköping_County_-_Sweden	post_video_view_time_by_region_id.Kalmar_County_-_Sweden	post_video_view_time_by_region_id.Kansas_-_United_States	post_video_view_time_by_region_id.Karnataka_-_India	post_video_view_time_by_region_id.Kaunas_County_-_Lithuania	post_video_view_time_by_region_id.Kentucky_-_United_States	post_video_view_time_by_region_id.Kerala_-_India	post_video_view_time_by_region_id.Kerry_-_Ireland	post_video_view_time_by_region_id.Kiev_-_Ukraine	post_video_view_time_by_region_id.Kildare_-_Ireland	post_video_view_time_by_region_id.Kilkenny_-_Ireland	post_video_view_time_by_region_id.Kuala_Lumpur_-_Malaysia	post_video_view_time_by_region_id.Kurzeme_Region_-_Latvia	post_video_view_time_by_region_id.Lampung_-_Indonesia	post_video_view_time_by_region_id.Languedoc-Roussillon_-_France	post_video_view_time_by_region_id.Lazio_-_Italy	post_video_view_time_by_region_id.Lefkoşa_District_-_Cyprus	post_video_view_time_by_region_id.Liguria_-_Italy	post_video_view_time_by_region_id.Limburg_-_Netherlands	post_video_view_time_by_region_id.Limerick_-_Ireland	post_video_view_time_by_region_id.Lisbon_District_-_Portugal	post_video_view_time_by_region_id.Lombardia_-_Italy	post_video_view_time_by_region_id.Louisiana_-_United_States	post_video_view_time_by_region_id.Lower_Austria_-_Austria	post_video_view_time_by_region_id.Luxembourg_District_-_Luxembourg	post_video_view_time_by_region_id.Magdalena_-_Colombia	post_video_view_time_by_region_id.Maharashtra_-_India	post_video_view_time_by_region_id.Maine_-_United_States	post_video_view_time_by_region_id.Manitoba_-_Canada	post_video_view_time_by_region_id.Maryland_-_United_States	post_video_view_time_by_region_id.Masovian_Voivodeship_-_Poland	post_video_view_time_by_region_id.Massachusetts_-_United_States	post_video_view_time_by_region_id.Mecklenburg-Vorpommern_-_Germany	post_video_view_time_by_region_id.Metro_Manila_-_Philippines	post_video_view_time_by_region_id.Michigan_-_United_States	post_video_view_time_by_region_id.Minnesota_-_United_States	post_video_view_time_by_region_id.Mississippi_-_United_States	post_video_view_time_by_region_id.Missouri_-_United_States	post_video_view_time_by_region_id.Montana_-_United_States	post_video_view_time_by_region_id.Moscow_-_Russia	post_video_view_time_by_region_id.Nebraska_-_United_States	post_video_view_time_by_region_id.Nevada_-_United_States	post_video_view_time_by_region_id.New_Brunswick_-_Canada	post_video_view_time_by_region_id.New_Hampshire_-_United_States	post_video_view_time_by_region_id.New_Jersey_-_United_States	post_video_view_time_by_region_id.New_Mexico_-_United_States	post_video_view_time_by_region_id.New_South_Wales_-_Australia	post_video_view_time_by_region_id.New_York_-_United_States	post_video_view_time_by_region_id.Newfoundland_and_Labrador_-_Canada	post_video_view_time_by_region_id.Niedersachsen_-_Germany	post_video_view_time_by_region_id.Noord-Holland_-_Netherlands	post_video_view_time_by_region_id.Nordrhein-Westfalen_-_Germany	post_video_view_time_by_region_id.Norrbotten_County_-_Sweden	post_video_view_time_by_region_id.North_Carolina_-_United_States	post_video_view_time_by_region_id.North_Denmark_Region_-_Denmark	post_video_view_time_by_region_id.North_Sumatra_-_Indonesia	post_video_view_time_by_region_id.Northern_Ireland_-_United_Kingdom	post_video_view_time_by_region_id.Northern_Ostrobothnia_-_Finland	post_video_view_time_by_region_id.Nova_Scotia_-_Canada	post_video_view_time_by_region_id.Ohio_-_United_States	post_video_view_time_by_region_id.Oklahoma_-_United_States	post_video_view_time_by_region_id.Ontario_-_Canada	post_video_view_time_by_region_id.Oregon_-_United_States	post_video_view_time_by_region_id.Oslo_-_Norway	post_video_view_time_by_region_id.Ostrobothnia_(region)_-_Finland	post_video_view_time_by_region_id.Paraná_-_Brazil	post_video_view_time_by_region_id.Pennsylvania_-_United_States	post_video_view_time_by_region_id.Piedmont_-_Italy	post_video_view_time_by_region_id.Pirkanmaa_-_Finland	post_video_view_time_by_region_id.Prague_-_Czech_Republic	post_video_view_time_by_region_id.Provence-Alpes-Côte_d'Azur_-_France	post_video_view_time_by_region_id.Puducherry_-_India	post_video_view_time_by_region_id.Punjab_region_-_India	post_video_view_time_by_region_id.Quebec_-_Canada	post_video_view_time_by_region_id.Queensland_-_Australia	post_video_view_time_by_region_id.Rajasthan_-_India	post_video_view_time_by_region_id.Region_of_Southern_Denmark_-_Denmark	post_video_view_time_by_region_id.Rheinland-Pfalz_-_Germany	post_video_view_time_by_region_id.Rhode_Island_-_United_States	post_video_view_time_by_region_id.Rhône-Alpes_-_France	post_video_view_time_by_region_id.Riau_Islands_Province_-_Indonesia	post_video_view_time_by_region_id.Rogaland_-_Norway	post_video_view_time_by_region_id.Roscommon_-_Ireland	post_video_view_time_by_region_id.Saarland_-_Germany	post_video_view_time_by_region_id.Sachsen_-_Germany	post_video_view_time_by_region_id.Saint_Michael_-_Barbados	post_video_view_time_by_region_id.Salzburg_-_Austria	post_video_view_time_by_region_id.Santiago_Metropolitan_Region_-_Chile	post_video_view_time_by_region_id.Saskatchewan_-_Canada	post_video_view_time_by_region_id.Saxony-Anhalt_-_Germany	post_video_view_time_by_region_id.Schaan_-_Liechtenstein	post_video_view_time_by_region_id.Schleswig-Holstein_-_Germany	post_video_view_time_by_region_id.Scotland_-_United_Kingdom	post_video_view_time_by_region_id.Selangor_-_Malaysia	post_video_view_time_by_region_id.Skåne_County_-_Sweden	post_video_view_time_by_region_id.Sligo_-_Ireland	post_video_view_time_by_region_id.Solothurn_-_Switzerland	post_video_view_time_by_region_id.South_Australia_-_Australia	post_video_view_time_by_region_id.South_Carolina_-_United_States	post_video_view_time_by_region_id.South_Dakota_-_United_States	post_video_view_time_by_region_id.South_Sulawesi_-_Indonesia	post_video_view_time_by_region_id.South_Sumatra_-_Indonesia	post_video_view_time_by_region_id.Southwest_Finland_-_Finland	post_video_view_time_by_region_id.Special_Region_of_Yogyakarta_-_Indonesia	post_video_view_time_by_region_id.Stockholm_County_-_Sweden	post_video_view_time_by_region_id.Styria_-_Austria	post_video_view_time_by_region_id.São_Paulo_(state)_-_Brazil	post_video_view_time_by_region_id.Södermanland_County_-_Sweden	post_video_view_time_by_region_id.Tennessee_-_United_States	post_video_view_time_by_region_id.Texas_-_United_States	post_video_view_time_by_region_id.Thüringen_-_Germany	post_video_view_time_by_region_id.Tokyo_-_Japan	post_video_view_time_by_region_id.Trentino-Alto_Adige_-_Italy	post_video_view_time_by_region_id.Tuscany_-_Italy	post_video_view_time_by_region_id.Tyrol_-_Austria	post_video_view_time_by_region_id.Upper_Austria_-_Austria	post_video_view_time_by_region_id.Uppsala_County_-_Sweden	post_video_view_time_by_region_id.Utah_-_United_States	post_video_view_time_by_region_id.Uttarakhand_-_India	post_video_view_time_by_region_id.Uusimaa_-_Finland	post_video_view_time_by_region_id.Veneto_-_Italy	post_video_view_time_by_region_id.Vermont_-_United_States	post_video_view_time_by_region_id.Vest-Agder_-_Norway	post_video_view_time_by_region_id.Victoria_-_Australia	post_video_view_time_by_region_id.Vienna_-_Austria	post_video_view_time_by_region_id.Virginia_-_United_States	post_video_view_time_by_region_id.Vorarlberg_-_Austria	post_video_view_time_by_region_id.Värmlands_Län_-_Sweden	post_video_view_time_by_region_id.Västerbottens_Län_-_Sweden	post_video_view_time_by_region_id.Västmanlands_Län_-_Sweden	post_video_view_time_by_region_id.Västra_Götaland_County_-_Sweden	post_video_view_time_by_region_id.Wales_-_United_Kingdom	post_video_view_time_by_region_id.Washington_-_United_States	post_video_view_time_by_region_id.Waterford_-_Ireland	post_video_view_time_by_region_id.Wellington_Region_-_New_Zealand	post_video_view_time_by_region_id.West_Java_-_Indonesia	post_video_view_time_by_region_id.West_Virginia_-_United_States	post_video_view_time_by_region_id.Western_Australia_-_Australia	post_video_view_time_by_region_id.Western_Cape_-_South_Africa	post_video_view_time_by_region_id.Wexford_-_Ireland	post_video_view_time_by_region_id.Wicklow_-_Ireland	post_video_view_time_by_region_id.Wisconsin_-_United_States	post_video_view_time_by_region_id.Zealand_Region_-_Denmark	post_video_view_time_by_region_id.Zug_-_Switzerland	post_video_view_time_by_region_id.Zuid-Holland_-_Netherlands	post_video_view_time_by_region_id.Zürich_-_Switzerland	post_video_view_time_by_region_id.Île-de-France_-_France	post_video_view_time_by_region_id.Örebro_County_-_Sweden	post_video_view_time_by_region_id.Östergötland_County_-_Sweden	post_video_views_10s_autoplayed	post_video_views_10s_clicked_to_play	post_video_views_10s_organic	post_video_views_10s_sound_on	post_video_views_10s_unique	post_video_views_autoplayed	post_video_views_by_distribution_type.page_owned	post_video_views_by_distribution_type.shared	post_video_views_clicked_to_play	post_video_views_organic	post_video_views_organic_unique	post_video_views_sound_on	post_video_views_unique	shares.count
0	2018-03-09	40	2018-03-07 23:30:00	167115176655082	VICE	167115176655082_2094008024166264	https://www.facebook.com/VICE/videos/209400802...	Being A Trans Women's Hockey Player	6366	355.0	5430.0	2.0	579.0	340.0	4039.0	2.0	584.0	4469	4357	4541	6583	225447	278195	278195	278195	230021	230021	1397.0	1049.0	271070	225447	276798	229621	230021	1397	1049	6	3.0	3.0	NaN	NaN	3.0	3.0	NaN	NaN	7	81	15	0	0	7	81	15	0	0	6574	1311	1284	211049	1.0	0.5906	0.1299	0.1222	0.1169	0.1101	0.1027	0.0994	0.0969	0.0944	0.0903	0.0863	0.3318	0.0822	0.079	0.0765	0.0744	0.0701	0.0649	0.0638	0.0621	0.0591	0.0556	0.2771	0.0505	0.0483	0.047	0.0426	0.0412	0.0383	0.036	0.0312	0.0264	0.024	0.2271	0.0176	0.1978	0.169	0.1552	0.1466	0.1396	1.0	0.9086	0.5185	0.5086	0.484	0.4815	0.4667	0.4667	0.4691	0.4691	0.4617	0.442	0.8074	0.4272	0.4049	0.4025	0.3951	0.3852	0.3778	0.3679	0.3506	0.3309	0.316	0.7704	0.2988	0.2864	0.2741	0.2568	0.2593	0.2346	0.2296	0.2049	0.1753	0.1531	0.7309	0.1086	0.6963	0.637	0.6025	0.5802	0.5481	2314221.0	111336016.0	215130380.0	69935016.0	14857937.0	7356273.0	7481435.0	3951051.0	253258527.0	489476559.0	165090202.0	38183184.0	10104701.0	14985793.0	137176.0	4027709.0	9070035.0	5026767.0	1121871.0	87972.0	1094463.0	NaN	NaN	NaN	NaN	NaN	976.0	297.0	NaN	NaN	NaN	169.0	NaN	NaN	22.0	66.0	NaN	29.0	NaN	3879.0	NaN	22.0	NaN	27.0	NaN	21.0	NaN	NaN	65.0	241.0	NaN	NaN	NaN	32.0	120.0	430.0	NaN	1092.0	NaN	355.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36.0	NaN	36.0	21.0	NaN	281.0	NaN	27.0	263.0	NaN	68.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.0	NaN	NaN	NaN	29.0	NaN	147.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	486.0	NaN	237.0	NaN	91.0	NaN	NaN	NaN	NaN	38.0	136.0	83.0	NaN	NaN	117.0	NaN	NaN	NaN	68.0	40.0	NaN	NaN	NaN	35.0	29.0	180.0	NaN	NaN	295.0	149.0	NaN	34.0	NaN	NaN	NaN	NaN	NaN	NaN	37.0	3078.0	9394.0	NaN	NaN	NaN	NaN	1.421316e+09	3365730.0	NaN	NaN	NaN	29811730.0	NaN	8997445.0	NaN	9735939.0	NaN	NaN	NaN	NaN	NaN	NaN	10800620.0	12501285.0	NaN	NaN	NaN	35035164.0	NaN	NaN	NaN	NaN	NaN	81166619.0	NaN	NaN	8415916.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22050894.0	7889381.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9416478.0	NaN	NaN	NaN	150780697.0	7977170.0	24807180.0	NaN	8843002.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30718008.0	8281605.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8929210.0	NaN	25456004.0	NaN	NaN	18832158.0	16039035.0	NaN	10204134.0	NaN	NaN	NaN	NaN	8618399.0	NaN	17280606.0	NaN	17858038.0	44477230.0	NaN	NaN	10358092.0	12991690.0	NaN	12919234.0	NaN	NaN	NaN	NaN	NaN	15396758.0	NaN	88817417.0	13514484.0	NaN	NaN	NaN	23581631.0	NaN	NaN	NaN	NaN	NaN	NaN	42355065.0	11355052.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10296381.0	NaN	NaN	NaN	20342348.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29285576.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18985415.0	9897714.0	11169450.0	NaN	NaN	NaN	NaN	NaN	8964712.0	20910659.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11395354.0	NaN	NaN	NaN	NaN	10522094.0	NaN	NaN	15755	345	16100	4916	16100	44778	45124.0	64.0	410	45188	45041	7548	45041	11.0
1	2018-03-09	139	2018-03-07 23:01:30	167115176655082	VICE	167115176655082_2061072230592691	https://motherboard.vice.com/en_us/article/pam...	Google Engineers Think This 72-Qubit Processor...	31706	21592.0	10110.0	4.0	NaN	20440.0	7638.0	4.0	NaN	26855	27040	28404	34358	416752	581612	581612	581612	449338	449338	37921.0	28114.0	541844	416752	543691	419092	449338	37921	28114	13	6.0	7.0	NaN	NaN	6.0	7.0	NaN	NaN	25	1647	83	1	237	25	1647	83	1	237	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	372.0
2	2018-03-09	106	2018-03-07 22:30:27	167115176655082	VICE	167115176655082_2061036290596285	https://noisey.vice.com/en_us/article/9kz7jp/v...	I, Like Vince Staples, Will "Shut the Fuck Up ...	19233	9664.0	9568.0	1.0	NaN	9251.0	7528.0	1.0	NaN	15031	15083	16008	21563	274787	380562	380562	380562	291179	291179	18032.0	12695.0	360346	274787	362530	276565	291179	18032	12695	17	5.0	12.0	NaN	NaN	5.0	12.0	NaN	NaN	212	1494	115	1	4	212	1494	115	1	4	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	165.0

	asof_date	comments_total_count	created_time	from_id	from_name	id	link	name	post_consumptions	post_consumptions_by_type.link_clicks	post_consumptions_by_type.other_clicks	post_consumptions_by_type.photo_view	post_consumptions_by_type.video_play	post_consumptions_by_type_unique.link_clicks	post_consumptions_by_type_unique.other_clicks	post_consumptions_by_type_unique.photo_view	post_consumptions_by_type_unique.video_play	post_consumptions_unique	post_engaged_fan	post_engaged_users	post_engagements	post_fan_reach	post_impressions	post_impressions_by_paid_non_paid.total	post_impressions_by_paid_non_paid.unpaid	post_impressions_by_paid_non_paid_unique.total	post_impressions_by_paid_non_paid_unique.unpaid	post_impressions_by_story_type.other	post_impressions_by_story_type_unique.other	post_impressions_fan	post_impressions_fan_unique	post_impressions_organic	post_impressions_organic_unique	post_impressions_unique	post_impressions_viral	post_impressions_viral_unique	post_negative_feedback	post_negative_feedback_by_type.hide_all_clicks	post_negative_feedback_by_type.hide_clicks	post_negative_feedback_by_type.report_spam_clicks	post_negative_feedback_by_type.unlike_page_clicks	post_negative_feedback_by_type_unique.hide_all_clicks	post_negative_feedback_by_type_unique.hide_clicks	post_negative_feedback_by_type_unique.report_spam_clicks	post_negative_feedback_by_type_unique.unlike_page_clicks	post_reactions_anger_total	post_reactions_by_type_total.anger	post_reactions_by_type_total.haha	post_reactions_by_type_total.like	post_reactions_by_type_total.love	post_reactions_by_type_total.sorry	post_reactions_by_type_total.wow	post_reactions_haha_total	post_reactions_like_total	post_reactions_love_total	post_reactions_sorry_total	post_reactions_wow_total	post_video_avg_time_watched	post_video_complete_views_organic	post_video_complete_views_organic_unique	post_video_length	post_video_retention_graph_autoplayed.0	post_video_retention_graph_autoplayed.1	post_video_retention_graph_autoplayed.10	post_video_retention_graph_autoplayed.11	post_video_retention_graph_autoplayed.12	post_video_retention_graph_autoplayed.13	post_video_retention_graph_autoplayed.14	post_video_retention_graph_autoplayed.15	post_video_retention_graph_autoplayed.16	post_video_retention_graph_autoplayed.17	post_video_retention_graph_autoplayed.18	post_video_retention_graph_autoplayed.19	post_video_retention_graph_autoplayed.2	post_video_retention_graph_autoplayed.20	post_video_retention_graph_autoplayed.21	post_video_retention_graph_autoplayed.22	post_video_retention_graph_autoplayed.23	post_video_retention_graph_autoplayed.24	post_video_retention_graph_autoplayed.25	post_video_retention_graph_autoplayed.26	post_video_retention_graph_autoplayed.27	post_video_retention_graph_autoplayed.28	post_video_retention_graph_autoplayed.29	post_video_retention_graph_autoplayed.3	post_video_retention_graph_autoplayed.30	post_video_retention_graph_autoplayed.31	post_video_retention_graph_autoplayed.32	post_video_retention_graph_autoplayed.33	post_video_retention_graph_autoplayed.34	post_video_retention_graph_autoplayed.35	post_video_retention_graph_autoplayed.36	post_video_retention_graph_autoplayed.37	post_video_retention_graph_autoplayed.38	post_video_retention_graph_autoplayed.39	post_video_retention_graph_autoplayed.4	post_video_retention_graph_autoplayed.40	post_video_retention_graph_autoplayed.5	post_video_retention_graph_autoplayed.6	post_video_retention_graph_autoplayed.7	post_video_retention_graph_autoplayed.8	post_video_retention_graph_autoplayed.9	post_video_retention_graph_clicked_to_play.0	post_video_retention_graph_clicked_to_play.1	post_video_retention_graph_clicked_to_play.10	post_video_retention_graph_clicked_to_play.11	post_video_retention_graph_clicked_to_play.12	post_video_retention_graph_clicked_to_play.13	post_video_retention_graph_clicked_to_play.14	post_video_retention_graph_clicked_to_play.15	post_video_retention_graph_clicked_to_play.16	post_video_retention_graph_clicked_to_play.17	post_video_retention_graph_clicked_to_play.18	post_video_retention_graph_clicked_to_play.19	post_video_retention_graph_clicked_to_play.2	post_video_retention_graph_clicked_to_play.20	post_video_retention_graph_clicked_to_play.21	post_video_retention_graph_clicked_to_play.22	post_video_retention_graph_clicked_to_play.23	post_video_retention_graph_clicked_to_play.24	post_video_retention_graph_clicked_to_play.25	post_video_retention_graph_clicked_to_play.26	post_video_retention_graph_clicked_to_play.27	post_video_retention_graph_clicked_to_play.28	post_video_retention_graph_clicked_to_play.29	post_video_retention_graph_clicked_to_play.3	post_video_retention_graph_clicked_to_play.30	post_video_retention_graph_clicked_to_play.31	post_video_retention_graph_clicked_to_play.32	post_video_retention_graph_clicked_to_play.33	post_video_retention_graph_clicked_to_play.34	post_video_retention_graph_clicked_to_play.35	post_video_retention_graph_clicked_to_play.36	post_video_retention_graph_clicked_to_play.37	post_video_retention_graph_clicked_to_play.38	post_video_retention_graph_clicked_to_play.39	post_video_retention_graph_clicked_to_play.4	post_video_retention_graph_clicked_to_play.40	post_video_retention_graph_clicked_to_play.5	post_video_retention_graph_clicked_to_play.6	post_video_retention_graph_clicked_to_play.7	post_video_retention_graph_clicked_to_play.8	post_video_retention_graph_clicked_to_play.9	post_video_view_time_by_age_bucket_and_gender.F.13-17	post_video_view_time_by_age_bucket_and_gender.F.18-24	post_video_view_time_by_age_bucket_and_gender.F.25-34	post_video_view_time_by_age_bucket_and_gender.F.35-44	post_video_view_time_by_age_bucket_and_gender.F.45-54	post_video_view_time_by_age_bucket_and_gender.F.55-64	post_video_view_time_by_age_bucket_and_gender.F.65+	post_video_view_time_by_age_bucket_and_gender.M.13-17	post_video_view_time_by_age_bucket_and_gender.M.18-24	post_video_view_time_by_age_bucket_and_gender.M.25-34	post_video_view_time_by_age_bucket_and_gender.M.35-44	post_video_view_time_by_age_bucket_and_gender.M.45-54	post_video_view_time_by_age_bucket_and_gender.M.55-64	post_video_view_time_by_age_bucket_and_gender.M.65+	post_video_view_time_by_age_bucket_and_gender.U.13-17	post_video_view_time_by_age_bucket_and_gender.U.18-24	post_video_view_time_by_age_bucket_and_gender.U.25-34	post_video_view_time_by_age_bucket_and_gender.U.35-44	post_video_view_time_by_age_bucket_and_gender.U.45-54	post_video_view_time_by_age_bucket_and_gender.U.55-64	post_video_view_time_by_age_bucket_and_gender.U.65+	post_video_view_time_by_country_id.Afghanistan_(AF)	post_video_view_time_by_country_id.Albania_(AL)	post_video_view_time_by_country_id.Algeria_(DZ)	post_video_view_time_by_country_id.Argentina_(AR)	post_video_view_time_by_country_id.Aruba_(AW)	post_video_view_time_by_country_id.Australia_(AU)	post_video_view_time_by_country_id.Austria_(AT)	post_video_view_time_by_country_id.Bahrain_(BH)	post_video_view_time_by_country_id.Bangladesh_(BD)	post_video_view_time_by_country_id.Barbados_(BB)	post_video_view_time_by_country_id.Belgium_(BE)	post_video_view_time_by_country_id.Belize_(BZ)	post_video_view_time_by_country_id.Bolivia_(BO)	post_video_view_time_by_country_id.Bosnia_and_Herzegovina_(BA)	post_video_view_time_by_country_id.Brazil_(BR)	post_video_view_time_by_country_id.Brunei_(BN)	post_video_view_time_by_country_id.Bulgaria_(BG)	post_video_view_time_by_country_id.Cambodia_(KH)	post_video_view_time_by_country_id.Canada_(CA)	post_video_view_time_by_country_id.Cayman_Islands_(KY)	post_video_view_time_by_country_id.Chile_(CL)	post_video_view_time_by_country_id.China_(CN)	post_video_view_time_by_country_id.Colombia_(CO)	post_video_view_time_by_country_id.Costa_Rica_(CR)	post_video_view_time_by_country_id.Croatia_(HR)	post_video_view_time_by_country_id.Curaçao_(CW)	post_video_view_time_by_country_id.Cyprus_(CY)	post_video_view_time_by_country_id.Czech_Republic_(CZ)	post_video_view_time_by_country_id.Denmark_(DK)	post_video_view_time_by_country_id.Ecuador_(EC)	post_video_view_time_by_country_id.Egypt_(EG)	post_video_view_time_by_country_id.El_Salvador_(SV)	post_video_view_time_by_country_id.Estonia_(EE)	post_video_view_time_by_country_id.Finland_(FI)	post_video_view_time_by_country_id.France_(FR)	post_video_view_time_by_country_id.Georgia_(GE)	post_video_view_time_by_country_id.Germany_(DE)	post_video_view_time_by_country_id.Ghana_(GH)	post_video_view_time_by_country_id.Greece_(GR)	post_video_view_time_by_country_id.Grenada_(GD)	post_video_view_time_by_country_id.Guadeloupe_(GP)	post_video_view_time_by_country_id.Guam_(GU)	post_video_view_time_by_country_id.Guatemala_(GT)	post_video_view_time_by_country_id.Guernsey_(GG)	post_video_view_time_by_country_id.Guyana_(GY)	post_video_view_time_by_country_id.Hong_Kong_(HK)	post_video_view_time_by_country_id.Hungary_(HU)	post_video_view_time_by_country_id.Iceland_(IS)	post_video_view_time_by_country_id.India_(IN)	post_video_view_time_by_country_id.Indonesia_(ID)	post_video_view_time_by_country_id.Iraq_(IQ)	post_video_view_time_by_country_id.Ireland_(IE)	post_video_view_time_by_country_id.Isle_Of_Man_(IM)	post_video_view_time_by_country_id.Israel_(IL)	post_video_view_time_by_country_id.Italy_(IT)	post_video_view_time_by_country_id.Jamaica_(JM)	post_video_view_time_by_country_id.Japan_(JP)	post_video_view_time_by_country_id.Jersey_(JE)	post_video_view_time_by_country_id.Jordan_(JO)	post_video_view_time_by_country_id.Kenya_(KE)	post_video_view_time_by_country_id.Kosovo_(XK)	post_video_view_time_by_country_id.Kuwait_(KW)	post_video_view_time_by_country_id.Latvia_(LV)	post_video_view_time_by_country_id.Lebanon_(LB)	post_video_view_time_by_country_id.Liechtenstein_(LI)	post_video_view_time_by_country_id.Lithuania_(LT)	post_video_view_time_by_country_id.Luxembourg_(LU)	post_video_view_time_by_country_id.Macedonia_(MK)	post_video_view_time_by_country_id.Madagascar_(MG)	post_video_view_time_by_country_id.Malaysia_(MY)	post_video_view_time_by_country_id.Malta_(MT)	post_video_view_time_by_country_id.Mexico_(MX)	post_video_view_time_by_country_id.Moldova_(MD)	post_video_view_time_by_country_id.Mongolia_(MN)	post_video_view_time_by_country_id.Montenegro_(ME)	post_video_view_time_by_country_id.Morocco_(MA)	post_video_view_time_by_country_id.Mozambique_(MZ)	post_video_view_time_by_country_id.Myanmar_(MM)	post_video_view_time_by_country_id.Nepal_(NP)	post_video_view_time_by_country_id.Netherlands_(NL)	post_video_view_time_by_country_id.New_Caledonia_(NC)	post_video_view_time_by_country_id.New_Zealand_(NZ)	post_video_view_time_by_country_id.Nigeria_(NG)	post_video_view_time_by_country_id.Norway_(NO)	post_video_view_time_by_country_id.Pakistan_(PK)	post_video_view_time_by_country_id.Palestine_(PS)	post_video_view_time_by_country_id.Paraguay_(PY)	post_video_view_time_by_country_id.Peru_(PE)	post_video_view_time_by_country_id.Philippines_(PH)	post_video_view_time_by_country_id.Poland_(PL)	post_video_view_time_by_country_id.Portugal_(PT)	post_video_view_time_by_country_id.Puerto_Rico_(PR)	post_video_view_time_by_country_id.Qatar_(QA)	post_video_view_time_by_country_id.Romania_(RO)	post_video_view_time_by_country_id.Russia_(RU)	post_video_view_time_by_country_id.Samoa_(WS)	post_video_view_time_by_country_id.Saudi_Arabia_(SA)	post_video_view_time_by_country_id.Serbia_(RS)	post_video_view_time_by_country_id.Singapore_(SG)	post_video_view_time_by_country_id.Sint_Maarten_(SX)	post_video_view_time_by_country_id.Slovakia_(SK)	post_video_view_time_by_country_id.Slovenia_(SI)	post_video_view_time_by_country_id.South_Africa_(ZA)	post_video_view_time_by_country_id.South_Korea_(KR)	post_video_view_time_by_country_id.Spain_(ES)	post_video_view_time_by_country_id.Sri_Lanka_(LK)	post_video_view_time_by_country_id.Suriname_(SR)	post_video_view_time_by_country_id.Sweden_(SE)	post_video_view_time_by_country_id.Switzerland_(CH)	post_video_view_time_by_country_id.Taiwan_(TW)	post_video_view_time_by_country_id.Thailand_(TH)	post_video_view_time_by_country_id.The_Bahamas_(BS)	post_video_view_time_by_country_id.Trinidad_and_Tobago_(TT)	post_video_view_time_by_country_id.Tunisia_(TN)	post_video_view_time_by_country_id.Turkey_(TR)	post_video_view_time_by_country_id.US_Virgin_Islands_(VI)	post_video_view_time_by_country_id.Ukraine_(UA)	post_video_view_time_by_country_id.United_Arab_Emirates_(AE)	post_video_view_time_by_country_id.United_Kingdom_(GB)	post_video_view_time_by_country_id.United_States_(US)	post_video_view_time_by_country_id.Uruguay_(UY)	post_video_view_time_by_country_id.Venezuela_(VE)	post_video_view_time_by_country_id.Vietnam_(VN)	post_video_view_time_by_country_id.Zambia_(ZM)	post_video_view_time_by_distribution_type.page_owned	post_video_view_time_by_distribution_type.shared	post_video_view_time_by_region_id.Aargau_-_Switzerland	post_video_view_time_by_region_id.Abu_Dhabi_-_United_Arab_Emirates	post_video_view_time_by_region_id.Alabama_-_United_States	post_video_view_time_by_region_id.Alberta_-_Canada	post_video_view_time_by_region_id.Aquitaine_-_France	post_video_view_time_by_region_id.Arizona_-_United_States	post_video_view_time_by_region_id.Arkansas_-_United_States	post_video_view_time_by_region_id.Attica_(region)_-_Greece	post_video_view_time_by_region_id.Auckland_Region_-_New_Zealand	post_video_view_time_by_region_id.Baden-Württemberg_-_Germany	post_video_view_time_by_region_id.Bali_-_Indonesia	post_video_view_time_by_region_id.Bangkok_-_Thailand	post_video_view_time_by_region_id.Banten_-_Indonesia	post_video_view_time_by_region_id.Basel-City_-_Switzerland	post_video_view_time_by_region_id.Bayern_-_Germany	post_video_view_time_by_region_id.Berlin_-_Germany	post_video_view_time_by_region_id.Bern_-_Switzerland	post_video_view_time_by_region_id.Brandenburg_-_Germany	post_video_view_time_by_region_id.Bremen_-_Germany	post_video_view_time_by_region_id.British_Columbia_-_Canada	post_video_view_time_by_region_id.Bucharest_-_Romania	post_video_view_time_by_region_id.Budapest_-_Hungary	post_video_view_time_by_region_id.Burgenland_-_Austria	post_video_view_time_by_region_id.Cairo_Governorate_-_Egypt	post_video_view_time_by_region_id.Calabarzon_-_Philippines	post_video_view_time_by_region_id.California_-_United_States	post_video_view_time_by_region_id.Canton_of_St._Gallen_-_Switzerland	post_video_view_time_by_region_id.Capital_Region_-_Iceland	post_video_view_time_by_region_id.Capital_Region_of_Denmark_-_Denmark	post_video_view_time_by_region_id.Carinthia_-_Austria	post_video_view_time_by_region_id.Carlow_-_Ireland	post_video_view_time_by_region_id.Cataluña_-_Spain	post_video_view_time_by_region_id.Cavan_-_Ireland	post_video_view_time_by_region_id.Ceará_-_Brazil	post_video_view_time_by_region_id.Central_Denmark_Region_-_Denmark	post_video_view_time_by_region_id.Central_Finland_-_Finland	post_video_view_time_by_region_id.Central_Java_-_Indonesia	post_video_view_time_by_region_id.Central_Macedonia_-_Greece	post_video_view_time_by_region_id.Central_Region_-_Singapore	post_video_view_time_by_region_id.Chon_Buri_-_Thailand	post_video_view_time_by_region_id.Colorado_-_United_States	post_video_view_time_by_region_id.Connecticut_-_United_States	post_video_view_time_by_region_id.County_Clare_-_Ireland	post_video_view_time_by_region_id.County_Cork_-_Ireland	post_video_view_time_by_region_id.County_Laois_-_Ireland	post_video_view_time_by_region_id.County_Leitrim_-_Ireland	post_video_view_time_by_region_id.County_Longford_-_Ireland	post_video_view_time_by_region_id.County_Louth_-_Ireland	post_video_view_time_by_region_id.County_Mayo_-_Ireland	post_video_view_time_by_region_id.County_Meath_-_Ireland	post_video_view_time_by_region_id.County_Monaghan_-_Ireland	post_video_view_time_by_region_id.County_Offaly_-_Ireland	post_video_view_time_by_region_id.County_Tipperary_-_Ireland	post_video_view_time_by_region_id.County_Westmeath_-_Ireland	post_video_view_time_by_region_id.Dalarna_County_-_Sweden	post_video_view_time_by_region_id.Delaware_-_United_States	post_video_view_time_by_region_id.Delhi_-_India	post_video_view_time_by_region_id.Dhaka_Division_-_Bangladesh	post_video_view_time_by_region_id.District_of_Columbia_-_United_States	post_video_view_time_by_region_id.Distrito_Especial_-_Colombia	post_video_view_time_by_region_id.Distrito_Federal_-_Mexico	post_video_view_time_by_region_id.Donegal_-_Ireland	post_video_view_time_by_region_id.Dubai_-_United_Arab_Emirates	post_video_view_time_by_region_id.Dublin_-_Ireland	post_video_view_time_by_region_id.East_Java_-_Indonesia	post_video_view_time_by_region_id.East_Kalimantan_-_Indonesia	post_video_view_time_by_region_id.Emilia-Romagna_-_Italy	post_video_view_time_by_region_id.England_-_United_Kingdom	post_video_view_time_by_region_id.Flemish_Region_-_Belgium	post_video_view_time_by_region_id.Florida_-_United_States	post_video_view_time_by_region_id.Galway_-_Ireland	post_video_view_time_by_region_id.Georgia_-_United_States	post_video_view_time_by_region_id.Goa_-_India	post_video_view_time_by_region_id.Gujarat_-_India	post_video_view_time_by_region_id.Gävleborg_County_-_Sweden	post_video_view_time_by_region_id.Halland_County_-_Sweden	post_video_view_time_by_region_id.Hamburg_-_Germany	post_video_view_time_by_region_id.Hawaii_-_United_States	post_video_view_time_by_region_id.Hessen_-_Germany	post_video_view_time_by_region_id.Idaho_-_United_States	post_video_view_time_by_region_id.Illinois_-_United_States	post_video_view_time_by_region_id.Indiana_-_United_States	post_video_view_time_by_region_id.Iowa_-_United_States	post_video_view_time_by_region_id.Jakarta_-_Indonesia	post_video_view_time_by_region_id.Jönköping_County_-_Sweden	post_video_view_time_by_region_id.Kalmar_County_-_Sweden	post_video_view_time_by_region_id.Kansas_-_United_States	post_video_view_time_by_region_id.Karnataka_-_India	post_video_view_time_by_region_id.Kaunas_County_-_Lithuania	post_video_view_time_by_region_id.Kentucky_-_United_States	post_video_view_time_by_region_id.Kerala_-_India	post_video_view_time_by_region_id.Kerry_-_Ireland	post_video_view_time_by_region_id.Kiev_-_Ukraine	post_video_view_time_by_region_id.Kildare_-_Ireland	post_video_view_time_by_region_id.Kilkenny_-_Ireland	post_video_view_time_by_region_id.Kuala_Lumpur_-_Malaysia	post_video_view_time_by_region_id.Kurzeme_Region_-_Latvia	post_video_view_time_by_region_id.Lampung_-_Indonesia	post_video_view_time_by_region_id.Languedoc-Roussillon_-_France	post_video_view_time_by_region_id.Lazio_-_Italy	post_video_view_time_by_region_id.Lefkoşa_District_-_Cyprus	post_video_view_time_by_region_id.Liguria_-_Italy	post_video_view_time_by_region_id.Limburg_-_Netherlands	post_video_view_time_by_region_id.Limerick_-_Ireland	post_video_view_time_by_region_id.Lisbon_District_-_Portugal	post_video_view_time_by_region_id.Lombardia_-_Italy	post_video_view_time_by_region_id.Louisiana_-_United_States	post_video_view_time_by_region_id.Lower_Austria_-_Austria	post_video_view_time_by_region_id.Luxembourg_District_-_Luxembourg	post_video_view_time_by_region_id.Magdalena_-_Colombia	post_video_view_time_by_region_id.Maharashtra_-_India	post_video_view_time_by_region_id.Maine_-_United_States	post_video_view_time_by_region_id.Manitoba_-_Canada	post_video_view_time_by_region_id.Maryland_-_United_States	post_video_view_time_by_region_id.Masovian_Voivodeship_-_Poland	post_video_view_time_by_region_id.Massachusetts_-_United_States	post_video_view_time_by_region_id.Mecklenburg-Vorpommern_-_Germany	post_video_view_time_by_region_id.Metro_Manila_-_Philippines	post_video_view_time_by_region_id.Michigan_-_United_States	post_video_view_time_by_region_id.Minnesota_-_United_States	post_video_view_time_by_region_id.Mississippi_-_United_States	post_video_view_time_by_region_id.Missouri_-_United_States	post_video_view_time_by_region_id.Montana_-_United_States	post_video_view_time_by_region_id.Moscow_-_Russia	post_video_view_time_by_region_id.Nebraska_-_United_States	post_video_view_time_by_region_id.Nevada_-_United_States	post_video_view_time_by_region_id.New_Brunswick_-_Canada	post_video_view_time_by_region_id.New_Hampshire_-_United_States	post_video_view_time_by_region_id.New_Jersey_-_United_States	post_video_view_time_by_region_id.New_Mexico_-_United_States	post_video_view_time_by_region_id.New_South_Wales_-_Australia	post_video_view_time_by_region_id.New_York_-_United_States	post_video_view_time_by_region_id.Newfoundland_and_Labrador_-_Canada	post_video_view_time_by_region_id.Niedersachsen_-_Germany	post_video_view_time_by_region_id.Noord-Holland_-_Netherlands	post_video_view_time_by_region_id.Nordrhein-Westfalen_-_Germany	post_video_view_time_by_region_id.Norrbotten_County_-_Sweden	post_video_view_time_by_region_id.North_Carolina_-_United_States	post_video_view_time_by_region_id.North_Denmark_Region_-_Denmark	post_video_view_time_by_region_id.North_Sumatra_-_Indonesia	post_video_view_time_by_region_id.Northern_Ireland_-_United_Kingdom	post_video_view_time_by_region_id.Northern_Ostrobothnia_-_Finland	post_video_view_time_by_region_id.Nova_Scotia_-_Canada	post_video_view_time_by_region_id.Ohio_-_United_States	post_video_view_time_by_region_id.Oklahoma_-_United_States	post_video_view_time_by_region_id.Ontario_-_Canada	post_video_view_time_by_region_id.Oregon_-_United_States	post_video_view_time_by_region_id.Oslo_-_Norway	post_video_view_time_by_region_id.Ostrobothnia_(region)_-_Finland	post_video_view_time_by_region_id.Paraná_-_Brazil	post_video_view_time_by_region_id.Pennsylvania_-_United_States	post_video_view_time_by_region_id.Piedmont_-_Italy	post_video_view_time_by_region_id.Pirkanmaa_-_Finland	post_video_view_time_by_region_id.Prague_-_Czech_Republic	post_video_view_time_by_region_id.Provence-Alpes-Côte_d'Azur_-_France	post_video_view_time_by_region_id.Puducherry_-_India	post_video_view_time_by_region_id.Punjab_region_-_India	post_video_view_time_by_region_id.Quebec_-_Canada	post_video_view_time_by_region_id.Queensland_-_Australia	post_video_view_time_by_region_id.Rajasthan_-_India	post_video_view_time_by_region_id.Region_of_Southern_Denmark_-_Denmark	post_video_view_time_by_region_id.Rheinland-Pfalz_-_Germany	post_video_view_time_by_region_id.Rhode_Island_-_United_States	post_video_view_time_by_region_id.Rhône-Alpes_-_France	post_video_view_time_by_region_id.Riau_Islands_Province_-_Indonesia	post_video_view_time_by_region_id.Rogaland_-_Norway	post_video_view_time_by_region_id.Roscommon_-_Ireland	post_video_view_time_by_region_id.Saarland_-_Germany	post_video_view_time_by_region_id.Sachsen_-_Germany	post_video_view_time_by_region_id.Saint_Michael_-_Barbados	post_video_view_time_by_region_id.Salzburg_-_Austria	post_video_view_time_by_region_id.Santiago_Metropolitan_Region_-_Chile	post_video_view_time_by_region_id.Saskatchewan_-_Canada	post_video_view_time_by_region_id.Saxony-Anhalt_-_Germany	post_video_view_time_by_region_id.Schaan_-_Liechtenstein	post_video_view_time_by_region_id.Schleswig-Holstein_-_Germany	post_video_view_time_by_region_id.Scotland_-_United_Kingdom	post_video_view_time_by_region_id.Selangor_-_Malaysia	post_video_view_time_by_region_id.Skåne_County_-_Sweden	post_video_view_time_by_region_id.Sligo_-_Ireland	post_video_view_time_by_region_id.Solothurn_-_Switzerland	post_video_view_time_by_region_id.South_Australia_-_Australia	post_video_view_time_by_region_id.South_Carolina_-_United_States	post_video_view_time_by_region_id.South_Dakota_-_United_States	post_video_view_time_by_region_id.South_Sulawesi_-_Indonesia	post_video_view_time_by_region_id.South_Sumatra_-_Indonesia	post_video_view_time_by_region_id.Southwest_Finland_-_Finland	post_video_view_time_by_region_id.Special_Region_of_Yogyakarta_-_Indonesia	post_video_view_time_by_region_id.Stockholm_County_-_Sweden	post_video_view_time_by_region_id.Styria_-_Austria	post_video_view_time_by_region_id.São_Paulo_(state)_-_Brazil	post_video_view_time_by_region_id.Södermanland_County_-_Sweden	post_video_view_time_by_region_id.Tennessee_-_United_States	post_video_view_time_by_region_id.Texas_-_United_States	post_video_view_time_by_region_id.Thüringen_-_Germany	post_video_view_time_by_region_id.Tokyo_-_Japan	post_video_view_time_by_region_id.Trentino-Alto_Adige_-_Italy	post_video_view_time_by_region_id.Tuscany_-_Italy	post_video_view_time_by_region_id.Tyrol_-_Austria	post_video_view_time_by_region_id.Upper_Austria_-_Austria	post_video_view_time_by_region_id.Uppsala_County_-_Sweden	post_video_view_time_by_region_id.Utah_-_United_States	post_video_view_time_by_region_id.Uttarakhand_-_India	post_video_view_time_by_region_id.Uusimaa_-_Finland	post_video_view_time_by_region_id.Veneto_-_Italy	post_video_view_time_by_region_id.Vermont_-_United_States	post_video_view_time_by_region_id.Vest-Agder_-_Norway	post_video_view_time_by_region_id.Victoria_-_Australia	post_video_view_time_by_region_id.Vienna_-_Austria	post_video_view_time_by_region_id.Virginia_-_United_States	post_video_view_time_by_region_id.Vorarlberg_-_Austria	post_video_view_time_by_region_id.Värmlands_Län_-_Sweden	post_video_view_time_by_region_id.Västerbottens_Län_-_Sweden	post_video_view_time_by_region_id.Västmanlands_Län_-_Sweden	post_video_view_time_by_region_id.Västra_Götaland_County_-_Sweden	post_video_view_time_by_region_id.Wales_-_United_Kingdom	post_video_view_time_by_region_id.Washington_-_United_States	post_video_view_time_by_region_id.Waterford_-_Ireland	post_video_view_time_by_region_id.Wellington_Region_-_New_Zealand	post_video_view_time_by_region_id.West_Java_-_Indonesia	post_video_view_time_by_region_id.West_Virginia_-_United_States	post_video_view_time_by_region_id.Western_Australia_-_Australia	post_video_view_time_by_region_id.Western_Cape_-_South_Africa	post_video_view_time_by_region_id.Wexford_-_Ireland	post_video_view_time_by_region_id.Wicklow_-_Ireland	post_video_view_time_by_region_id.Wisconsin_-_United_States	post_video_view_time_by_region_id.Zealand_Region_-_Denmark	post_video_view_time_by_region_id.Zug_-_Switzerland	post_video_view_time_by_region_id.Zuid-Holland_-_Netherlands	post_video_view_time_by_region_id.Zürich_-_Switzerland	post_video_view_time_by_region_id.Île-de-France_-_France	post_video_view_time_by_region_id.Örebro_County_-_Sweden	post_video_view_time_by_region_id.Östergötland_County_-_Sweden	post_video_views_10s_autoplayed	post_video_views_10s_clicked_to_play	post_video_views_10s_organic	post_video_views_10s_sound_on	post_video_views_10s_unique	post_video_views_autoplayed	post_video_views_by_distribution_type.page_owned	post_video_views_by_distribution_type.shared	post_video_views_clicked_to_play	post_video_views_organic	post_video_views_organic_unique	post_video_views_sound_on	post_video_views_unique	shares.count
0	2018-03-09 00:00:00	40	2018-03-07 23:30:00	167115176655082	VICE	167115176655082_2094008024166264	https://www.facebook.com/VICE/videos/209400802...	Being A Trans Women's Hockey Player	6366	355.0	5430.0	2.0	579.0	340.0	4039.0	2.0	584.0	4469	4357	4541	6583	225447	278195	278195	278195	230021	230021	1397.0	1049.0	271070	225447	276798	229621	230021	1397	1049	6	3.0	3.0	None	None	3.0	3.0	None	None	0	0	7	81	15	0	0	7	81	15	0	0	6574	1311	1284	211049	1.0	0.5906	0.1299	0.1222	0.1169	0.1101	0.1027	0.0994	0.0969	0.0944	0.0903	0.0863	0.3318	0.0822	0.079	0.0765	0.0744	0.0701	0.0649	0.0638	0.0621	0.0591	0.0556	0.2771	0.0505	0.0483	0.047	0.0426	0.0412	0.0383	0.036	0.0312	0.0264	0.024	0.2271	0.0176	0.1978	0.169	0.1552	0.1466	0.1396	1.0	0.9086	0.5185	0.5086	0.484	0.4815	0.4667	0.4667	0.4691	0.4691	0.4617	0.442	0.8074	0.4272	0.4049	0.4025	0.3951	0.3852	0.3778	0.3679	0.3506	0.3309	0.316	0.7704	0.2988	0.2864	0.2741	0.2568	0.2593	0.2346	0.2296	0.2049	0.1753	0.1531	0.7309	0.1086	0.6963	0.637	0.6025	0.5802	0.5481	2314221.0	111336016.0	215130380.0	69935016.0	14857937.0	7356273.0	7481435.0	3951051.0	253258527.0	489476559.0	165090202.0	38183184.0	10104701.0	14985793.0	137176.0	4027709.0	9070035.0	5026767.0	1121871.0	87972.0	1094463.0	None	None	None	None	None	976.0	297.0	None	None	None	169.0	None	None	22.0	66.0	None	29.0	None	3879.0	None	22.0	None	27.0	None	21.0	None	None	65.0	241.0	None	None	None	32.0	120.0	430.0	None	1092.0	None	355.0	None	None	None	None	None	None	None	36.0	None	36.0	21.0	None	281.0	None	27.0	263.0	None	68.0	None	None	None	None	None	None	None	None	38.0	None	None	None	29.0	None	147.0	None	None	None	None	None	None	None	486.0	None	237.0	None	91.0	None	None	None	None	38.0	136.0	83.0	None	None	117.0	None	None	None	68.0	40.0	None	None	None	35.0	29.0	180.0	None	None	295.0	149.0	None	34.0	None	None	None	None	None	None	37.0	3078.0	9394.0	None	None	None	None	1.421316e+09	3365730.0	None	None	None	29811730.0	None	8997445.0	None	9735939.0	None	None	None	None	None	None	10800620.0	12501285.0	None	None	None	35035164.0	None	None	None	None	None	81166619.0	None	None	8415916.0	None	None	None	None	None	None	None	None	None	None	None	22050894.0	7889381.0	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	9416478.0	None	None	None	150780697.0	7977170.0	24807180.0	None	8843002.0	None	None	None	None	None	None	None	None	30718008.0	8281605.0	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	8929210.0	None	25456004.0	None	None	18832158.0	16039035.0	None	10204134.0	None	None	None	None	8618399.0	None	17280606.0	None	17858038.0	44477230.0	None	None	10358092.0	12991690.0	None	12919234.0	None	None	None	None	None	15396758.0	None	88817417.0	13514484.0	None	None	None	23581631.0	None	None	None	None	None	None	42355065.0	11355052.0	None	None	None	None	None	None	None	None	None	None	None	None	None	10296381.0	None	None	None	20342348.0	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	29285576.0	None	None	None	None	None	None	None	None	None	None	None	None	None	18985415.0	9897714.0	11169450.0	None	None	None	None	None	8964712.0	20910659.0	None	None	None	None	None	None	None	None	11395354.0	None	None	None	None	10522094.0	None	None	15755	345	16100	4916	16100	44778	45124.0	64.0	410	45188	45041	7548	45041	11.0
1	2018-03-09 00:00:00	139	2018-03-07 23:01:30	167115176655082	VICE	167115176655082_2061072230592691	https://motherboard.vice.com/en_us/article/pam...	Google Engineers Think This 72-Qubit Processor...	31706	21592.0	10110.0	4.0	NaN	20440.0	7638.0	4.0	NaN	26855	27040	28404	34358	416752	581612	581612	581612	449338	449338	37921.0	28114.0	541844	416752	543691	419092	449338	37921	28114	13	6.0	7.0	None	None	6.0	7.0	None	None	0	0	25	1647	83	1	237	25	1647	83	1	237	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	None	None	None	None	None	NaN	NaN	None	None	None	NaN	None	None	NaN	NaN	None	NaN	None	NaN	None	NaN	None	NaN	None	NaN	None	None	NaN	NaN	None	None	None	NaN	NaN	NaN	None	NaN	None	NaN	None	None	None	None	None	None	None	NaN	None	NaN	NaN	None	NaN	None	NaN	NaN	None	NaN	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	None	NaN	None	None	None	None	None	None	None	NaN	None	NaN	None	NaN	None	None	None	None	NaN	NaN	NaN	None	None	NaN	None	None	None	NaN	NaN	None	None	None	NaN	NaN	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	None	None	NaN	NaN	NaN	None	None	None	None	NaN	NaN	None	None	None	NaN	None	NaN	None	NaN	None	None	None	None	None	None	NaN	NaN	None	None	None	NaN	None	None	None	None	None	NaN	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	NaN	NaN	None	NaN	None	None	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	NaN	None	NaN	None	NaN	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	None	NaN	None	NaN	NaN	None	None	None	NaN	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	NaN	NaN	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	NaN	None	None	None	None	NaN	None	None	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	372.0
2	2018-03-09 00:00:00	106	2018-03-07 22:30:27	167115176655082	VICE	167115176655082_2061036290596285	https://noisey.vice.com/en_us/article/9kz7jp/v...	I, Like Vince Staples, Will "Shut the Fuck Up ...	19233	9664.0	9568.0	1.0	NaN	9251.0	7528.0	1.0	NaN	15031	15083	16008	21563	274787	380562	380562	380562	291179	291179	18032.0	12695.0	360346	274787	362530	276565	291179	18032	12695	17	5.0	12.0	None	None	5.0	12.0	None	None	0	0	212	1494	115	1	4	212	1494	115	1	4	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	None	None	None	None	None	NaN	NaN	None	None	None	NaN	None	None	NaN	NaN	None	NaN	None	NaN	None	NaN	None	NaN	None	NaN	None	None	NaN	NaN	None	None	None	NaN	NaN	NaN	None	NaN	None	NaN	None	None	None	None	None	None	None	NaN	None	NaN	NaN	None	NaN	None	NaN	NaN	None	NaN	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	None	NaN	None	None	None	None	None	None	None	NaN	None	NaN	None	NaN	None	None	None	None	NaN	NaN	NaN	None	None	NaN	None	None	None	NaN	NaN	None	None	None	NaN	NaN	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	None	None	NaN	NaN	NaN	None	None	None	None	NaN	NaN	None	None	None	NaN	None	NaN	None	NaN	None	None	None	None	None	None	NaN	NaN	None	None	None	NaN	None	None	None	None	None	NaN	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	NaN	NaN	None	NaN	None	None	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	NaN	None	NaN	None	NaN	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	None	NaN	None	NaN	NaN	None	None	None	NaN	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	NaN	NaN	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	NaN	None	None	None	None	NaN	None	None	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	165.0
3	2018-03-09 00:00:00	54	2018-03-07 22:01:21	167115176655082	VICE	167115176655082_2061006690599245	https://www.vice.com/en_us/article/qve9yq/my-t...	Here Are Some Solid Options for Trump's Next W...	3244	1771.0	1472.0	1.0	NaN	1673.0	1133.0	1.0	NaN	2681	2796	2880	3678	200117	267465	267465	267465	204979	204979	2894.0	2222.0	260253	200117	264571	203956	204979	2894	2222	13	6.0	7.0	None	None	6.0	4.0	None	None	1	1	85	196	7	0	1	85	196	7	0	1	0	0	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	None	None	None	None	None	NaN	NaN	None	None	None	NaN	None	None	NaN	NaN	None	NaN	None	NaN	None	NaN	None	NaN	None	NaN	None	None	NaN	NaN	None	None	None	NaN	NaN	NaN	None	NaN	None	NaN	None	None	None	None	None	None	None	NaN	None	NaN	NaN	None	NaN	None	NaN	NaN	None	NaN	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	None	NaN	None	None	None	None	None	None	None	NaN	None	NaN	None	NaN	None	None	None	None	NaN	NaN	NaN	None	None	NaN	None	None	None	NaN	NaN	None	None	None	NaN	NaN	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	None	None	NaN	NaN	NaN	None	None	None	None	NaN	NaN	None	None	None	NaN	None	NaN	None	NaN	None	None	None	None	None	None	NaN	NaN	None	None	None	NaN	None	None	None	None	None	NaN	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	NaN	NaN	None	NaN	None	None	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	NaN	None	NaN	None	NaN	NaN	None	None	NaN	NaN	None	NaN	None	None	None	None	None	NaN	None	NaN	NaN	None	None	None	NaN	None	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	NaN	NaN	None	None	None	None	None	NaN	NaN	None	None	None	None	None	None	None	None	NaN	None	None	None	None	NaN	None	None	0	0	0	0	0	0	NaN	NaN	0	0	0	0	0	26.0

	id	name	asof_date	created_time	post_impressions
0	130581413665173_1772390549484243	Blunted	2018-03-08 00:00:00	2018-03-01 22:30:00	43452
1	130581413665173_1772390549484243	Blunted	2018-03-07 00:00:00	2018-03-01 22:30:00	43359
2	130581413665173_1772390549484243	Blunted	2018-03-06 00:00:00	2018-03-01 22:30:00	43207
3	130581413665173_1772390549484243	Blunted	2018-03-05 00:00:00	2018-03-01 22:30:00	41354
4	130581413665173_1772390549484243	Blunted	2018-03-04 00:00:00	2018-03-01 22:30:00	38076
5	130581413665173_1772390549484243	Blunted	2018-03-03 00:00:00	2018-03-01 22:30:00	33666
6	130581413665173_1772390549484243	Blunted	2018-03-02 00:00:00	2018-03-01 22:30:00	7323

	id	name	asof_date	created_time	post_impressions
0	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-03 00:00:00	2018-03-02 20:30:00	254108
1	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-04 00:00:00	2018-03-02 20:30:00	2920010
2	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-05 00:00:00	2018-03-02 20:30:00	7409355
3	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-06 00:00:00	2018-03-02 20:30:00	9440545
4	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-07 00:00:00	2018-03-02 20:30:00	10481088
5	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-08 00:00:00	2018-03-02 20:30:00	11929361
6	167115176655082_1773445632712068	Investigating Modern-Day Slavery in the South	2018-03-09 00:00:00	2018-03-02 20:30:00	13090657

	date	cumulative_impressions
0	2018-03-02	21046132
1	2018-03-03	49947726
2	2018-03-04	86610270
3	2018-03-05	129327061
4	2018-03-06	168393335
5	2018-03-07	205730913
6	2018-03-08	235716760
7	2018-03-09	210838373

	from_name
0	VICE
1	VICE Video
2	MOTHERBOARD
3	Broadly
4	MOTHERBOARD Deutschland

	id	facebook_permalink
0	167115176655082_2094008024166264	https://www.facebook.com/167115176655082/posts...
1	167115176655082_2061072230592691	https://www.facebook.com/167115176655082/posts...
2	167115176655082_2061036290596285	https://www.facebook.com/167115176655082/posts...
3	167115176655082_2061006690599245	https://www.facebook.com/167115176655082/posts...
4	167115176655082_2060978567268724	https://www.facebook.com/167115176655082/posts...

	id	name	impressions	shares	likes	likes_per_imp	shares_per_imp
0	814185111976252_1696961070365314	Outfit Repeater Tiffany Haddish Will Forever B...	47378	29.0	876.0	1.849	0.061
1	814185111976252_1698000250261396	Science Has Consistently Underestimated Women ...	27376	47.0	405.0	1.479	0.172
2	130581413665173_1773364596053505	The Rebirth of Indonesian Drag	283670	1408.0	3978.0	1.402	0.496
3	814185111976252_1696915760369845	Daniela Vega Makes History as First Trans Pres...	36154	34.0	493.0	1.364	0.094
4	167115176655082_2060358483997399	That Chance the Rapper and Childish Gambino Jo...	369914	443.0	4985.0	1.348	0.120

	date	impressions	shares	likes	likes_per_imp	shares_per_imp
0	2018-03-02	2303375	2837.0	7078.0	0.307	0.123
1	2018-03-03	3336573	5234.0	11066.0	0.332	0.157
2	2018-03-04	3544463	21190.0	12593.0	0.355	0.598
3	2018-03-05	7409355	51415.0	32856.0	0.443	0.694
4	2018-03-06	9440545	63131.0	41996.0	0.445	0.669
5	2018-03-07	10481088	69848.0	47070.0	0.449	0.666
6	2018-03-08	11929361	81181.0	54979.0	0.461	0.681
7	2018-03-09	13090657	89490.0	60972.0	0.466	0.684

Table of Contents¶

Part 0. - Opening Remarks and Thoughts¶

Overall here’s the gameplan I used for this analysis:¶

Part 1. - SQL¶

1. Each unique article is represented by a six charater, alphanumeric ID in the URL string. Start this exercise by using a regular expression to extract the article_id from the URL.¶

For example, xwpd7w is the article_id here https://www.vice.com/en_us/article/xwpd7w/how-a-brooklyn-gang-may-have-gotten-crazy-rich-dealing-for-el-chapo¶

2. Using the published_day field, calculate the unique daily and weekly article output. How does the content output trend throughout the week?¶

3. VICE's editorial department is structured into different verticals (e.g. Noisey covers music and Motherboard covers tech).¶

How does each vertical contribute to the editorial output? Write a query creating a table showing each vertical, its unique content output, and that vertical's share of the total output over the full data period.¶

4. VICE publishes content across a range of global offices. Each unique office is identified by their locale which is represented using a locale url parameter (e.g. en_us for the United States and en_uk for the United Kingdom). However, not every vertical publishes content in every locale.¶

Which verticals are published in which locales? Write a query creating a table showing each locale, their total article output, and a concatenated list of all of the verticals publishing in each locale.¶

Part 2. - Python¶

1. Please read in all of the files into a single data structure that will be usable for further analysis (for example, a pandas DataFrame)¶

HOORAY! We've got a working Pandas dataframe! One more thing I want to do to it now... ¶

👆🏿Now that's what I'm talking about!! 😊 ¶

3. Which post id received the most total impressions?¶

👆🏿This is very impressive, and it speaks to the public's hunger for powerful journalism. ¶

4. How many total impressions across all posts were there on 2018-03-06?¶

5. Facebook posts have a permalink of the format https://www.facebook.com/[page_id]/[posts|videos]/post_id/. The id field in the raw JSON file consists of the page_id and the post_id separated by an underscore. Add a column to your dataset that creates a working permalink for each post¶

Top 5 Posts by Shares per Impression¶

Top 5 Posts by Likes per Impression¶

7. Create a visualization using your metric. Be creative, it could be over time for one or many posts, a comparison of different posts, etc.¶

Meeting with Data Engineering Team.¶

BONUS. I just wanted to do one more data visualization to look at overall post impressions broken up by 'from_name', which I'm asusming is the Facebook data's equivalent of vertical.¶

Thank you so much for your time and consideration.¶

Best,¶

George John Jordan Thomas Aquinas Hayward, Optimist¶

For example, xwpd7w is the article_id here https://www.vice.com/en_us/article/xwpd7w/how-a-brooklyn-gang-may-have-gotten-crazy-rich-dealing-for-el-chapo ¶