WeRateDog Data wrangling¶

Bo Fan¶

This report described the details in data wrangling including gathering, assessment and cleaning.

I gain a few insights after doing data wrangling and putting the data from 3 sources into a master data frame. The following figure shows the histogram of the rating score, which is the rating numerator divided by the denominator. We find that most of the people like to rate the dogs above 0.9 or more (9/10, 10/10 or more).

alt text

When plotting the rating scores as a function of timestamp, we find that the standard deviation of the scores in a given timeframe becomes smaller in the recent few months or years. In the end of 2015, the score fluctuates in a big range from 0.2 to 1.25. In 2017, however, the range becomes smaller from 0.5 to 1.4. It may be because people are becoming more objective in rating dogs.

alt text

It is also intuitive to look into the relationship between retweet count and favorite count, since dogs with large favorite counts are more likely to be revisited. The following figure also shows the strong positive correlation between favorite count and retweet count. One can see that for favorite count around 20,000 the retweet counts are roughly 10,000. When favorite count becomes 200,000, the retweet count goes up to 60,000.

alt text

Additionally, we also provide the distributions of the prediction confidence scores according to the image prediction data set. The predictions are generated by a neural network. As shown in the figure, I use blue, green and red to display the histograms from 3 candidates. For the 1st prediction in blue, the confidence scores are uniformly distributed in the range of 0.2 to 0.8. The 2nd and 3rd place prediction scores are mostly skewed to the left, which satisfies the common sense that the classifier is more confident about the top ranked label.

alt text

Code¶

import os
import requests
import urllib.request
import pandas as pd
import tweepy
import json
import re
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt

Gather data¶

Load the twitter archive data set

twitter_archive = pd.read_csv('twitter-archive-enhanced.csv')

get the image predictions data set

url="https://d17h27t6h515a5.cloudfront.net/topher/2017/August/599fd2ad_image-predictions/image-predictions.tsv"
response = requests.get(url)
with open('image_predictions.tsv', 'wb') as file:
    file.write(response.content) 
image_predictions = pd.read_csv('image_predictions.tsv', sep='\t')

Acquire the additional data via tweepy (twitter api)

# personal info (should be removed)
consumer_key = 'li2KMwomY36BaHafE6kh'
consumer_secret = 'A2Om6ASQjyUqkBMB9UBg9s87klInFoNAObKp'
access_token = '8062558817343KfnBkI0yKRvddEgLG33H1zk32naLGC'
access_secret = 'o9rj0Wd9FVTe3mBZ0qDMWLzFyLgFi5W4nsn'

auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_secret)
api = tweepy.API(auth, wait_on_rate_limit = True, wait_on_rate_limit_notify = True)

# Use twitter api to acquire additional info. should only be run once ()
with open('tweet_json.txt', 'a', encoding='utf8') as f:
    for tweet_id in twitter_archive['tweet_id']:
        try:
            tweet = api.get_status(tweet_id, tweet_mode='extended')
            json.dump(tweet._json, f)
            f.write('\n')
        except:
            continue

tweet_api_data = []
tweet_api_file = open('tweet_json.txt', "r")
for line in tweet_api_file:
    try:
        line_info = json.loads(line)
        tweet_api_data.append(line_info)
    except:
        continue
tweet_api_file.close()

Assess the data¶

Assess the twitter_archive data¶

twitter_archive.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2356 entries, 0 to 2355
Data columns (total 17 columns):
tweet_id                      2356 non-null int64
in_reply_to_status_id         78 non-null float64
in_reply_to_user_id           78 non-null float64
timestamp                     2356 non-null object
source                        2356 non-null object
text                          2356 non-null object
retweeted_status_id           181 non-null float64
retweeted_status_user_id      181 non-null float64
retweeted_status_timestamp    181 non-null object
expanded_urls                 2297 non-null object
rating_numerator              2356 non-null int64
rating_denominator            2356 non-null int64
name                          2356 non-null object
doggo                         2356 non-null object
floofer                       2356 non-null object
pupper                        2356 non-null object
puppo                         2356 non-null object
dtypes: float64(4), int64(3), object(10)
memory usage: 313.0+ KB

pd.set_option('display.max_colwidth', -1)
twitter_archive['rating_numerator'].value_counts()

12      558
11      464
10      461
13      351
9       158
8       102
7       55 
14      54 
5       37 
6       32 
3       19 
4       17 
1       9  
2       9  
420     2  
0       2  
15      2  
75      2  
80      1  
20      1  
24      1  
26      1  
44      1  
50      1  
60      1  
165     1  
84      1  
88      1  
144     1  
182     1  
143     1  
666     1  
960     1  
1776    1  
17      1  
27      1  
45      1  
99      1  
121     1  
204     1  
Name: rating_numerator, dtype: int64

twitter_archive[twitter_archive.text.str.contains(r"(\d+\.\d*\/\d+)")]

/opt/conda/lib/python3.6/site-packages/ipykernel_launcher.py:1: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.
  """Entry point for launching an IPython kernel.

twitter_archive['name'].sort_values()

1035    Abby        
1021    Abby        
938     Ace         
1933    Acro        
1327    Adele       
1934    Aiden       
77      Aja         
480     Akumi       
820     Al          
875     Albert      
1954    Albert      
144     Albus       
412     Albus       
1115    Aldrick     
2046    Alejandro   
374     Alexander   
1189    Alexanderson
486     Alf         
2238    Alfie       
661     Alfie       
367     Alfie       
1616    Alfie       
858     Alfie       
51      Alfy        
201     Alice       
1701    Alice       
1495    Amber       
1334    Ambrose     
2078    Amy         
2195    Amélie      
         ...        
852     my          
988     not         
335     not         
1747    officially  
1206    old         
993     one         
1936    one         
924     one         
369     one         
2326    quite       
169     quite       
118     quite       
193     quite       
2030    space       
22      such        
2345    the         
2346    the         
1603    the         
2037    the         
2212    the         
1815    the         
1797    the         
1527    the         
1120    this        
1121    unacceptable
1031    very        
773     very        
1097    very        
819     very        
1385    very        
Name: name, Length: 2356, dtype: object

twitter_archive['rating_denominator'].value_counts()

10     2333
11     3   
50     3   
80     2   
20     2   
2      1   
16     1   
40     1   
70     1   
15     1   
90     1   
110    1   
120    1   
130    1   
150    1   
170    1   
7      1   
0      1   
Name: rating_denominator, dtype: int64

pd.set_option('display.max_colwidth', -1)
temp_df = pd.DataFrame()
temp_df = twitter_archive[twitter_archive['rating_denominator'] != 10]
temp_df = temp_df[['tweet_id', 'text','rating_numerator','rating_denominator']]
temp_df

Summary of data issues¶

Quality issues:¶

The types of time_stamp, dog_stages, tweet_id, are incorrect
745 names are missing
some names are meaningless such as lowercase 'the', 'a', etc.
59 expanded_urls are missing
rating_numerator has outliers with counts less than or equal to 2
some ratings of rating_numerator are decimal in the text column
rating_denominator values are not all 10
data set contains retweets
& amp; can be replaced by &
some columns are useless including 'in_reply_to_status_id', 'in_reply_to_user_id', 'retweeted_status_id', 'retweeted_status_user_id' and 'retweeted_status_timestamp

Tidiness issues:¶

Doggo, floofer, pupper, puppo columns can be combined to one

Assess the image_predictions data set¶

image_predictions.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2075 entries, 0 to 2074
Data columns (total 12 columns):
tweet_id    2075 non-null int64
jpg_url     2075 non-null object
img_num     2075 non-null int64
p1          2075 non-null object
p1_conf     2075 non-null float64
p1_dog      2075 non-null bool
p2          2075 non-null object
p2_conf     2075 non-null float64
p2_dog      2075 non-null bool
p3          2075 non-null object
p3_conf     2075 non-null float64
p3_dog      2075 non-null bool
dtypes: bool(3), float64(3), int64(2), object(4)
memory usage: 152.1+ KB

Summary of data issues¶

Quality issues:¶

No issues are found

Tidiness issues:¶

tweet_id also appears in the twitter archive data set
some tweet ids in the twitter archive datat set do not have corresponding images

Assess the data through tweepy¶

tweet_api_df = pd.DataFrame(tweet_api_data)
tweet_api_df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 3236 entries, 0 to 3235
Data columns (total 31 columns):
contributors                     0 non-null object
coordinates                      0 non-null object
created_at                       3236 non-null object
display_text_range               3236 non-null object
entities                         3236 non-null object
extended_entities                2798 non-null object
favorite_count                   3236 non-null int64
favorited                        3236 non-null bool
full_text                        3236 non-null object
geo                              0 non-null object
id                               3236 non-null int64
id_str                           3236 non-null object
in_reply_to_screen_name          109 non-null object
in_reply_to_status_id            109 non-null float64
in_reply_to_status_id_str        109 non-null object
in_reply_to_user_id              109 non-null float64
in_reply_to_user_id_str          109 non-null object
is_quote_status                  3236 non-null bool
lang                             3236 non-null object
place                            2 non-null object
possibly_sensitive               2990 non-null object
possibly_sensitive_appealable    2990 non-null object
quoted_status                    50 non-null object
quoted_status_id                 52 non-null float64
quoted_status_id_str             52 non-null object
retweet_count                    3236 non-null int64
retweeted                        3236 non-null bool
retweeted_status                 330 non-null object
source                           3236 non-null object
truncated                        3236 non-null bool
user                             3236 non-null object
dtypes: bool(4), float64(3), int64(3), object(21)
memory usage: 695.3+ KB

Summary of data issues¶

Quality issues:¶

id is confusing

Tidiness issues:¶

only id, retweet_count, and favorite_count are usefull

Clean the data¶

Define¶

Remove rows where expanded_urls are None
Remove rows where in_reply_to_status_id or retweeted_status_id are not None

Code¶

twitter_archive_clean = twitter_archive.copy()
twitter_archive_clean = twitter_archive_clean.dropna(subset = ['expanded_urls'])
twitter_archive_clean =  twitter_archive_clean[twitter_archive_clean.in_reply_to_status_id.isnull()]
twitter_archive_clean =  twitter_archive_clean[twitter_archive_clean.retweeted_status_id.isnull()]

Test¶

twitter_archive_clean.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 2094 entries, 0 to 2355
Data columns (total 17 columns):
tweet_id                      2094 non-null int64
in_reply_to_status_id         0 non-null float64
in_reply_to_user_id           0 non-null float64
timestamp                     2094 non-null object
source                        2094 non-null object
text                          2094 non-null object
retweeted_status_id           0 non-null float64
retweeted_status_user_id      0 non-null float64
retweeted_status_timestamp    0 non-null object
expanded_urls                 2094 non-null object
rating_numerator              2094 non-null int64
rating_denominator            2094 non-null int64
name                          2094 non-null object
doggo                         2094 non-null object
floofer                       2094 non-null object
pupper                        2094 non-null object
puppo                         2094 non-null object
dtypes: float64(4), int64(3), object(10)
memory usage: 294.5+ KB

Define¶

Replace amp&; by '&'

Code¶

twitter_archive_clean['text'] = twitter_archive_clean['text'].str.replace('&amp;', '&')

Test¶

# test the results
twitter_archive_clean[twitter_archive_clean.text.str.contains('&amp;')]

Define¶

Combine floofer, doggo, puppo and pupper into one column and remove the extra columns

Code¶

twitter_archive_clean['dog_stage'] = twitter_archive_clean.text.str.extract \
         ('(floofer|doggo|puppo|pupper)', expand = True)
removed_cols = [ 'puppo','doggo','floofer', 'pupper']
twitter_archive_clean = twitter_archive_clean.drop(removed_cols, axis=1)

Test¶

twitter_archive_clean

Define¶

find the locations of all the names that are invalid and change them to correct ones (no names --> None)

Code¶

# show the names which might be invalid
twitter_archive_clean.loc[(twitter_archive_clean['name'].str.islower()) & (twitter_archive_clean['text'].str.contains('named'))]
# find the locations of all the names that are invalid
named_replaced = twitter_archive_clean.loc[twitter_archive_clean.name.str.islower() &\
                                         twitter_archive_clean.text.str.contains('named')]
nameis_replaced = twitter_archive_clean.loc[twitter_archive_clean.name.str.islower() &\
                                         twitter_archive_clean.text.str.contains('name is')]
lower_replaced = twitter_archive_clean.loc[twitter_archive_clean.name.str.islower()]

named_replaced_l = named_replaced.text.tolist()
nameis_replaced_l = nameis_replaced.text.tolist()
lower_replaced_l = lower_replaced.text.tolist()

for ele in named_replaced_l:
    eleloc = (twitter_archive_clean.text == ele)
    twitter_archive_clean.loc[eleloc, 'name'] = re.findall(r"named\s(\w+)", ele)
    
for ele in nameis_replaced_l:
    eleloc = (twitter_archive_clean.text == ele)
    twitter_archive_clean.loc[eleloc, 'name'] = re.findall(r"name is\s(\w+)", ele)    

for ele in lower_replaced_l:
    eleloc = (twitter_archive_clean.text == ele)
    twitter_archive_clean.loc[eleloc, 'name'] = 'None'

Test¶

twitter_archive_clean

Define¶

remove useless columns

Code¶

removed_cols = ['in_reply_to_status_id', 'in_reply_to_user_id', 'retweeted_status_id', \
                'retweeted_status_user_id', 'retweeted_status_timestamp']
twitter_archive_clean = twitter_archive_clean.drop(labels = removed_cols, axis = 1)

Test¶

twitter_archive_clean

Define¶

remove rows containing outliers (numerator)

Code¶

selected_numerators = [12,11,10,13,9,8,7,14,5,6,3,4,1,2]
twitter_archive_clean = twitter_archive_clean[twitter_archive_clean.rating_numerator.isin(selected_numerators)]

Test¶

# test whether the outlier rows are removed or not
twitter_archive_clean[~twitter_archive_clean.rating_numerator.isin(selected_numerators)]

Define¶

Check and update denominators which are not 10 or not consistent with the text column. Then, update the scores according to the following table

1068: 9/11 -> 14/10
1165: 4/20 -> 13/10
1662: 7/11 -> 10/10
2335: 1/2 -> 9/10

twitter_archive_clean[twitter_archive_clean.rating_denominator != 10]

interested_rows = [1068, 1165, 1662, 2335]
for i in range(len(interested_rows)):
    print (twitter_archive_clean.at[interested_rows[i], 'text'])

After so many requests, this is Bretagne. She was the last surviving 9/11 search dog, and our second ever 14/10. RIP https://t.co/XAVDNDaVgQ
Happy 4/20 from the squad! 13/10 for all https://t.co/eV1diwds8a
This is Darrel. He just robbed a 7/11 and is in a high speed police chase. Was just spotted by the helicopter 10/10 https://t.co/7EsP8LmSp5
This is an Albanian 3 1/2 legged  Episcopalian. Loves well-polished hardwood flooring. Penis on the collar. 9/10 https://t.co/d9NcXFKwLv

Code¶

new_numerator = [14, 13, 10, 10]
for i in range(len(new_numerator)):
    twitter_archive_clean.at[interested_rows[i], 'rating_numerator'] = new_numerator[i]
    twitter_archive_clean.at[interested_rows[i], 'rating_denominator'] = 10

Test¶

twitter_archive_clean[twitter_archive_clean.rating_denominator != 10]

twitter_archive_clean['rating_score'] = twitter_archive_clean.rating_numerator * 1.0 \
/ twitter_archive_clean.rating_denominator

/opt/conda/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  """Entry point for launching an IPython kernel.

Define¶

After outlier removal, one row has fractional numerator 13.5 from the text column but set as 5 om the numerator column.

twitter_archive_clean[twitter_archive_clean.text.str.contains(r"(\d+\.\d*\/\d+)")]

/opt/conda/lib/python3.6/site-packages/ipykernel_launcher.py:1: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.
  """Entry point for launching an IPython kernel.

Code¶

twitter_archive_clean.loc[(twitter_archive_clean.tweet_id == 883482846933004288), ['rating_numerator']] = 13.5

/opt/conda/lib/python3.6/site-packages/pandas/core/indexing.py:517: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  self.obj[item] = s

Test¶

twitter_archive_clean[twitter_archive_clean.tweet_id == 883482846933004288]

clean the tweet api data¶

image_predictions.duplicated(subset = 'tweet_id').value_counts()

False    2075
dtype: int64

Define¶

keep 'id', 'favorite_count', 'retweet_count' in the additional data (tweepy) and replace 'id' by 'tweet_id'

Code¶

cols_kept = ['id', 'favorite_count', 'retweet_count']
tweet_api_clean = tweet_api_df.filter(cols_kept, axis = 1)
tweet_api_clean = tweet_api_clean.rename(columns = {'id':'tweet_id'})

Test¶

tweet_api_clean.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 3236 entries, 0 to 3235
Data columns (total 3 columns):
tweet_id          3236 non-null int64
favorite_count    3236 non-null int64
retweet_count     3236 non-null int64
dtypes: int64(3)
memory usage: 75.9 KB

Define¶

Merge the three data sets, and remove duplicated columns like tweet_id

Code¶

merged_df = pd.merge(twitter_archive_clean, tweet_api_clean, on='tweet_id', how='inner')
master_df = pd.merge(merged_df, image_predictions, on='tweet_id', how='inner')

Test¶

master_df.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 2603 entries, 0 to 2602
Data columns (total 23 columns):
tweet_id              2603 non-null int64
timestamp             2603 non-null object
source                2603 non-null object
text                  2603 non-null object
expanded_urls         2603 non-null object
rating_numerator      2603 non-null float64
rating_denominator    2603 non-null int64
name                  2603 non-null object
dog_stage             427 non-null object
rating_score          2603 non-null float64
favorite_count        2603 non-null int64
retweet_count         2603 non-null int64
jpg_url               2603 non-null object
img_num               2603 non-null int64
p1                    2603 non-null object
p1_conf               2603 non-null float64
p1_dog                2603 non-null bool
p2                    2603 non-null object
p2_conf               2603 non-null float64
p2_dog                2603 non-null bool
p3                    2603 non-null object
p3_conf               2603 non-null float64
p3_dog                2603 non-null bool
dtypes: bool(3), float64(5), int64(5), object(10)
memory usage: 434.7+ KB

Define¶

convert tweet_id, timestamp, rating_numerator, rating_denominator, dog_stage, to correct data types

Code¶

master_df['tweet_id'] = master_df['tweet_id'].astype('str')
master_df['timestamp'] = pd.to_datetime(master_df['timestamp'])
master_df['dog_stage'] = master_df['dog_stage'].astype('category')
master_df['rating_numerator'] = master_df['rating_numerator'].astype('float')
master_df['rating_denominator'] = master_df['rating_denominator'].astype('float')

Test¶

master_df.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 2603 entries, 0 to 2602
Data columns (total 23 columns):
tweet_id              2603 non-null object
timestamp             2603 non-null datetime64[ns]
source                2603 non-null object
text                  2603 non-null object
expanded_urls         2603 non-null object
rating_numerator      2603 non-null float64
rating_denominator    2603 non-null float64
name                  2603 non-null object
dog_stage             427 non-null category
rating_score          2603 non-null float64
favorite_count        2603 non-null int64
retweet_count         2603 non-null int64
jpg_url               2603 non-null object
img_num               2603 non-null int64
p1                    2603 non-null object
p1_conf               2603 non-null float64
p1_dog                2603 non-null bool
p2                    2603 non-null object
p2_conf               2603 non-null float64
p2_dog                2603 non-null bool
p3                    2603 non-null object
p3_conf               2603 non-null float64
p3_dog                2603 non-null bool
dtypes: bool(3), category(1), datetime64[ns](1), float64(6), int64(3), object(9)
memory usage: 417.1+ KB

master_df.to_csv('twitter_archive_master.csv', encoding='utf-8', index=False)

Analysis and visualizations¶

ana_df = pd.read_csv('twitter_archive_master.csv')

% pylab inline
sns.set(style="whitegrid",  font_scale=1.3);
plt.hist(ana_df.rating_score)
plt.xlabel('Rating Score');
plt.ylabel('Count');
plt.title('Rating Score Distribution');

Populating the interactive namespace from numpy and matplotlib

plt.scatter(x=ana_df.favorite_count, y=ana_df.retweet_count)
plt.xlabel('Favorite Count');
plt.ylabel('Retweet Count');
plt.title('Favorite Count vs Retweet Count');

plt.hist(ana_df['p1_conf'],  alpha=0.6, label='1st Prediction');
plt.hist(ana_df['p2_conf'],  alpha=0.6, label='2nd Prediction');
plt.hist(ana_df['p3_conf'],  alpha=0.6, label='3rd Prediction');
plt.xlim(0,1.0)
plt.xlabel('Prediction Confidence Score');
plt.ylabel('Count');
plt.title('Prediction Confidence Score Distribution');
plt.legend(loc='upper right');

ana_time_df = ana_df.copy()
ana_time_df['timestamp'] = pd.to_datetime(ana_df['timestamp'])
ana_time_df.set_index('timestamp', inplace=True)
ana_time_df['rating_score'].plot()
plt.ylabel('Rating Score')

Text(0,0.5,'Rating Score')

Conclusion¶

For data collection, I downloaded the twitter archive data manually, wrote http request to download the image prediction files from Udacity server programmatically, and queried the tweeter API to save all the JSON data into a txt file.

For data assessment, especially in the twitter archive data set, there were quite a lot of issues. Some data types were incorrect, for example, timestamp, dog stages, tweet id, etc. In the name column, 745 name values were missing (None). Some names especially shown in lower cases were meaningless, for example, “a”, ‘the’, ‘very’, etc. In the expanded urls’s column, 59 elements were missing. The rating numerator column had outliers of which the total counts were less than or equal to 2. Some numerator values were inconsistent with the data from the text column where fractional numerators appeared. The rating denominator were not all 10, and a few scores were not consistent with the information from the text column. Some rows contained retweet information. The “&” string in the text column was quite redundant. Columns such as ‘in_reply_to_status_id’, 'in_reply_to_user_id', 'retweeted_status_id were useless. For the additional data set acquired via tweepy, only ‘id’, ‘favorite count’ and ‘retweet count’ were useful, but ‘id’ was confusing. For data tidiness issues, in the tweet archive data set, four columns: doggo, floofer, pupper and puppo were redundant. Some tweet id did not have corresponding images in the image prediction data set. Tweet id appeared 3 times in 3 different sources.

For data cleaning, I solved all the issues. For the name issues, I cleaned the data in 3 cases. When the names were shown in lower case and the text column contained key words such as ‘name’ or ‘name is’, I used the real name extracted from the text column to replace the lower-case names. Otherwise, those names were set as None. I removed the rows where the expanded url values were missing, the ‘retweeted status id’ values were not none, or the rating numerator values were outliers. For the rows where denominators were not 10, I visually checked the text column and replaced the old denominators and numerators. After removing all the outliers, the numerator value set as 5 (it was 13.5 in the text column) was replaced by 13.5. The “&” in the text column were all replaced by “&”. I also filtered the additional data set by keeping “id”, “favorite count” and ‘retweet count’, where ‘id’ was also changed to ‘tweeter id’ to remove ambiguity. Useless columns such as in_reply_to_status_id', 'in_reply_to_user_id' and 'retweeted_status_id’ were removed. The data types of timestamp, tweet id, dog stage, rating numerator and denominator were all set to the correct ones. For data quality issues, the four columns (‘doggo’, ‘floofer’, ‘pupper’, and ‘puppo’) were combined to one. Redundant column tweet_id was cleaned and three tables were joined to a master table using inner join.

	tweet_id	in_reply_to_status_id	in_reply_to_user_id	timestamp	source	text	retweeted_status_id	retweeted_status_user_id	retweeted_status_timestamp	expanded_urls	rating_numerator	rating_denominator	name	doggo	floofer	pupper	puppo
45	883482846933004288	NaN	NaN	2017-07-08 00:28:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Bella. She hopes her smile made you smile. If not, she is also offering you her favorite monkey. 13.5/10 https://t.co/qjrljjt948	NaN	NaN	NaN	https://twitter.com/dog_rates/status/883482846933004288/photo/1,https://twitter.com/dog_rates/status/883482846933004288/photo/1	5	10	Bella	None	None	None	None
340	832215909146226688	NaN	NaN	2017-02-16 13:11:49 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	RT @dog_rates: This is Logan, the Chow who lived. He solemnly swears he's up to lots of good. H*ckin magical af 9.75/10 https://t.co/yBO5wu…	7.867091e+17	4.196984e+09	2016-10-13 23:23:56 +0000	https://twitter.com/dog_rates/status/786709082849828864/photo/1	75	10	Logan	None	None	None	None
695	786709082849828864	NaN	NaN	2016-10-13 23:23:56 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Logan, the Chow who lived. He solemnly swears he's up to lots of good. H*ckin magical af 9.75/10 https://t.co/yBO5wuqaPS	NaN	NaN	NaN	https://twitter.com/dog_rates/status/786709082849828864/photo/1	75	10	Logan	None	None	None	None
763	778027034220126208	NaN	NaN	2016-09-20 00:24:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Sophie. She's a Jubilant Bush Pupper. Super h*ckin rare. Appears at random just to smile at the locals. 11.27/10 would smile back https://t.co/QFaUiIHxHq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/778027034220126208/photo/1	27	10	Sophie	None	None	pupper	None
1689	681340665377193984	6.813394e+17	4.196984e+09	2015-12-28 05:07:27 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	I've been told there's a slight possibility he's checking his mirror. We'll bump to 9.5/10. Still a menace	NaN	NaN	NaN	NaN	5	10	None	None	None	None	None
1712	680494726643068929	NaN	NaN	2015-12-25 21:06:00 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have uncovered an entire battalion of holiday puppers. Average of 11.26/10 https://t.co/eNm2S6p9BD	NaN	NaN	NaN	https://twitter.com/dog_rates/status/680494726643068929/photo/1	26	10	None	None	None	None	None

	tweet_id	text	rating_numerator	rating_denominator
313	835246439529840640	@jonnysun @Lin_Manuel ok jomny I know you're excited but 960/00 isn't a valid rating, 13/10 is tho	960	0
342	832088576586297345	@docmisterio account started on 11/15/15	11	15
433	820690176645140481	The floofs have been released I repeat the floofs have been released. 84/70 https://t.co/NIYC820tmd	84	70
516	810984652412424192	Meet Sam. She smiles 24/7 & secretly aspires to be a reindeer. \nKeep Sam smiling by clicking and sharing this link:\nhttps://t.co/98tB8y7y7t https://t.co/LouL5vdvxx	24	7
784	775096608509886464	RT @dog_rates: After so many requests, this is Bretagne. She was the last surviving 9/11 search dog, and our second ever 14/10. RIP https:/…	9	11
902	758467244762497024	Why does this never happen at my front door... 165/150 https://t.co/HmwrdfEfUE	165	150
1068	740373189193256964	After so many requests, this is Bretagne. She was the last surviving 9/11 search dog, and our second ever 14/10. RIP https://t.co/XAVDNDaVgQ	9	11
1120	731156023742988288	Say hello to this unbelievably well behaved squad of doggos. 204/170 would try to pet all at once https://t.co/yGQI3He3xv	204	170
1165	722974582966214656	Happy 4/20 from the squad! 13/10 for all https://t.co/eV1diwds8a	4	20
1202	716439118184652801	This is Bluebert. He just saw that both #FinalFur match ups are split 50/50. Amazed af. 11/10 https://t.co/Kky1DPG4iq	50	50
1228	713900603437621249	Happy Saturday here's 9 puppers on a bench. 99/90 good work everybody https://t.co/mpvaVxKmc1	99	90
1254	710658690886586372	Here's a brigade of puppers. All look very prepared for whatever happens next. 80/80 https://t.co/0eb7R1Om12	80	80
1274	709198395643068416	From left to right:\nCletus, Jerome, Alejandro, Burp, & Titson\nNone know where camera is. 45/50 would hug all at once https://t.co/sedre1ivTK	45	50
1351	704054845121142784	Here is a whole flock of puppers. 60/50 I'll take the lot https://t.co/9dpcw6MdWa	60	50
1433	697463031882764288	Happy Wednesday here's a bucket of pups. 44/40 would pet all at once https://t.co/HppvrYuamZ	44	40
1598	686035780142297088	Yes I do realize a rating of 4/20 would've been fitting. However, it would be unjust to give these cooperative pups that low of a rating	4	20
1634	684225744407494656	Two sneaky puppers were not initially seen, moving the rating to 143/130. Please forgive us. Thank you https://t.co/kRK51Y5ac3	143	130
1635	684222868335505415	Someone help the girl is being mugged. Several are distracting her while two steal her shoes. Clever puppers 121/110 https://t.co/1zfnTJLt55	121	110
1662	682962037429899265	This is Darrel. He just robbed a 7/11 and is in a high speed police chase. Was just spotted by the helicopter 10/10 https://t.co/7EsP8LmSp5	7	11
1663	682808988178739200	I'm aware that I could've said 20/16, but here at WeRateDogs we are very professional. An inconsistent rating scale is simply irresponsible	20	16
1779	677716515794329600	IT'S PUPPERGEDDON. Total of 144/120 ...I think https://t.co/ZanVtAtvIq	144	120
1843	675853064436391936	Here we have an entire platoon of puppers. Total score: 88/80 would pet all at once https://t.co/y93p6FLvVw	88	80
2335	666287406224695296	This is an Albanian 3 1/2 legged Episcopalian. Loves well-polished hardwood flooring. Penis on the collar. 9/10 https://t.co/d9NcXFKwLv	1	2

	tweet_id	in_reply_to_status_id	in_reply_to_user_id	timestamp	source	text	retweeted_status_id	retweeted_status_user_id	retweeted_status_timestamp	expanded_urls	rating_numerator	rating_denominator	name	dog_stage
0	892420643555336193	NaN	NaN	2017-08-01 16:23:56 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU	NaN	NaN	NaN	https://twitter.com/dog_rates/status/892420643555336193/photo/1	13	10	Phineas	NaN
1	892177421306343426	NaN	NaN	2017-08-01 00:17:27 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Tilly. She's just checking pup on you. Hopes you're doing ok. If not, she's available for pats, snugs, boops, the whole bit. 13/10 https://t.co/0Xxu71qeIV	NaN	NaN	NaN	https://twitter.com/dog_rates/status/892177421306343426/photo/1	13	10	Tilly	NaN
2	891815181378084864	NaN	NaN	2017-07-31 00:18:03 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Archie. He is a rare Norwegian Pouncing Corgo. Lives in the tall grass. You never know when one may strike. 12/10 https://t.co/wUnZnhtVJB	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891815181378084864/photo/1	12	10	Archie	NaN
3	891689557279858688	NaN	NaN	2017-07-30 15:58:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Darla. She commenced a snooze mid meal. 13/10 happens to the best of us https://t.co/tD36da7qLQ	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891689557279858688/photo/1	13	10	Darla	NaN
4	891327558926688256	NaN	NaN	2017-07-29 16:00:24 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Franklin. He would like you to stop calling him "cute." He is a very fierce shark and should be respected as such. 12/10 #BarkWeek https://t.co/AtUZn91f7f	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891327558926688256/photo/1,https://twitter.com/dog_rates/status/891327558926688256/photo/1	12	10	Franklin	NaN
5	891087950875897856	NaN	NaN	2017-07-29 00:08:17 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a majestic great white breaching off South Africa's coast. Absolutely h*ckin breathtaking. 13/10 (IG: tucker_marlo) #BarkWeek https://t.co/kQ04fDDRmh	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891087950875897856/photo/1	13	10	None	NaN
6	890971913173991426	NaN	NaN	2017-07-28 16:27:12 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Meet Jax. He enjoys ice cream so much he gets nervous around it. 13/10 help Jax enjoy more things by clicking below\n\nhttps://t.co/Zr4hWfAs1H https://t.co/tVJBRMnhxl	NaN	NaN	NaN	https://gofundme.com/ydvmve-surgery-for-jax,https://twitter.com/dog_rates/status/890971913173991426/photo/1	13	10	Jax	NaN
7	890729181411237888	NaN	NaN	2017-07-28 00:22:40 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	When you watch your owner call another dog a good boy but then they turn back to you and say you're a great boy. 13/10 https://t.co/v0nONBcwxq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890729181411237888/photo/1,https://twitter.com/dog_rates/status/890729181411237888/photo/1	13	10	None	NaN
8	890609185150312448	NaN	NaN	2017-07-27 16:25:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Zoey. She doesn't want to be one of the scary sharks. Just wants to be a snuggly pettable boatpet. 13/10 #BarkWeek https://t.co/9TwLuAGH0b	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890609185150312448/photo/1	13	10	Zoey	NaN
9	890240255349198849	NaN	NaN	2017-07-26 15:59:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Cassie. She is a college pup. Studying international doggo communication and stick theory. 14/10 so elegant much sophisticate https://t.co/t1bfwz5S2A	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890240255349198849/photo/1	14	10	Cassie	doggo
10	890006608113172480	NaN	NaN	2017-07-26 00:31:25 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Koda. He is a South Australian deckshark. Deceptively deadly. Frighteningly majestic. 13/10 would risk a petting #BarkWeek https://t.co/dVPW0B0Mme	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890006608113172480/photo/1,https://twitter.com/dog_rates/status/890006608113172480/photo/1	13	10	Koda	NaN
11	889880896479866881	NaN	NaN	2017-07-25 16:11:53 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Bruno. He is a service shark. Only gets out of the water to assist you. 13/10 terrifyingly good boy https://t.co/u1XPQMl29g	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889880896479866881/photo/1	13	10	Bruno	NaN
12	889665388333682689	NaN	NaN	2017-07-25 01:55:32 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here's a puppo that seems to be on the fence about something haha no but seriously someone help her. 13/10 https://t.co/BxvuXk0UCm	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889665388333682689/photo/1	13	10	None	puppo
13	889638837579907072	NaN	NaN	2017-07-25 00:10:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Ted. He does his best. Sometimes that's not enough. But it's ok. 12/10 would assist https://t.co/f8dEDcrKSR	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889638837579907072/photo/1,https://twitter.com/dog_rates/status/889638837579907072/photo/1	12	10	Ted	NaN
14	889531135344209921	NaN	NaN	2017-07-24 17:02:04 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Stuart. He's sporting his favorite fanny pack. Secretly filled with bones only. 13/10 puppared puppo #BarkWeek https://t.co/y70o6h3isq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889531135344209921/photo/1	13	10	Stuart	puppo
15	889278841981685760	NaN	NaN	2017-07-24 00:19:32 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Oliver. You're witnessing one of his many brutal attacks. Seems to be playing with his victim. 13/10 fr*ckin frightening #BarkWeek https://t.co/WpHvrQedPb	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889278841981685760/video/1	13	10	Oliver	NaN
16	888917238123831296	NaN	NaN	2017-07-23 00:22:39 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Jim. He found a fren. Taught him how to sit like the good boys. 12/10 for both https://t.co/chxruIOUJN	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888917238123831296/photo/1	12	10	Jim	NaN
17	888804989199671297	NaN	NaN	2017-07-22 16:56:37 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Zeke. He has a new stick. Very proud of it. Would like you to throw it for him without taking it. 13/10 would do my best https://t.co/HTQ77yNQ5K	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888804989199671297/photo/1,https://twitter.com/dog_rates/status/888804989199671297/photo/1	13	10	Zeke	NaN
18	888554962724278272	NaN	NaN	2017-07-22 00:23:06 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Ralphus. He's powering up. Attempting maximum borkdrive. 13/10 inspirational af https://t.co/YnYAFCTTiK	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1	13	10	Ralphus	NaN
20	888078434458587136	NaN	NaN	2017-07-20 16:49:33 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Gerald. He was just told he didn't get the job he interviewed for. A h*ckin injustice. 12/10 didn't want the job anyway https://t.co/DK7iDPfuRX	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888078434458587136/photo/1,https://twitter.com/dog_rates/status/888078434458587136/photo/1	12	10	Gerald	NaN
21	887705289381826560	NaN	NaN	2017-07-19 16:06:48 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Jeffrey. He has a monopoly on the pool noodles. Currently running a 'boop for two' midweek sale. 13/10 h*ckin strategic https://t.co/PhrUk20Q64	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887705289381826560/photo/1	13	10	Jeffrey	NaN
22	887517139158093824	NaN	NaN	2017-07-19 03:39:09 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	I've yet to rate a Venezuelan Hover Wiener. This is such an honor. 14/10 paw-inspiring af (IG: roxy.thedoxy) https://t.co/20VrLAA8ba	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887517139158093824/video/1	14	10	such	NaN
23	887473957103951883	NaN	NaN	2017-07-19 00:47:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Canela. She attempted some fancy porch pics. They were unsuccessful. 13/10 someone help her https://t.co/cLyzpcUcMX	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887473957103951883/photo/1,https://twitter.com/dog_rates/status/887473957103951883/photo/1	13	10	Canela	NaN
24	887343217045368832	NaN	NaN	2017-07-18 16:08:03 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	You may not have known you needed to see this today. 13/10 please enjoy (IG: emmylouroo) https://t.co/WZqNqygEyV	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887343217045368832/video/1	13	10	None	NaN
25	887101392804085760	NaN	NaN	2017-07-18 00:07:08 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This... is a Jubilant Antarctic House Bear. We only rate dogs. Please only send dogs. Thank you... 12/10 would suffocate in floof https://t.co/4Ad1jzJSdp	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887101392804085760/photo/1	12	10	None	NaN
26	886983233522544640	NaN	NaN	2017-07-17 16:17:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Maya. She's very shy. Rarely leaves her cup. 13/10 would find her an environment to thrive in https://t.co/I6oNy0CgiT	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886983233522544640/photo/1,https://twitter.com/dog_rates/status/886983233522544640/photo/1	13	10	Maya	NaN
27	886736880519319552	NaN	NaN	2017-07-16 23:58:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Mingus. He's a wonderful father to his smol pup. Confirmed 13/10, but he needs your help\n\nhttps://t.co/bVi0Yr4Cff https://t.co/ISvKOSkd5b	NaN	NaN	NaN	https://www.gofundme.com/mingusneedsus,https://twitter.com/dog_rates/status/886736880519319552/photo/1,https://twitter.com/dog_rates/status/886736880519319552/photo/1	13	10	Mingus	NaN
28	886680336477933568	NaN	NaN	2017-07-16 20:14:00 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Derek. He's late for a dog meeting. 13/10 pet...al to the metal https://t.co/BCoWue0abA	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886680336477933568/photo/1	13	10	Derek	NaN
29	886366144734445568	NaN	NaN	2017-07-15 23:25:31 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Roscoe. Another pupper fallen victim to spontaneous tongue ejections. Get the BlepiPen immediate. 12/10 deep breaths Roscoe https://t.co/RGE08MIJox	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886366144734445568/photo/1,https://twitter.com/dog_rates/status/886366144734445568/photo/1	12	10	Roscoe	pupper
31	886258384151887873	NaN	NaN	2017-07-15 16:17:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Waffles. His doggles are pupside down. Unsure how to fix. 13/10 someone assist Waffles https://t.co/xZDA9Qsq1O	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886258384151887873/photo/1	13	10	Waffles	NaN
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2326	666411507551481857	NaN	NaN	2015-11-17 00:24:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is quite the dog. Gets really excited when not in water. Not very soft tho. Bad at fetch. Can't do tricks. 2/10 https://t.co/aMCTNWO94t	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666411507551481857/photo/1	2	10	quite	NaN
2327	666407126856765440	NaN	NaN	2015-11-17 00:06:54 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a southern Vesuvius bumblegruff. Can drive a truck (wow). Made friends with 5 other nifty dogs (neat). 7/10 https://t.co/LopTBkKa8h	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666407126856765440/photo/1	7	10	a	NaN
2328	666396247373291520	NaN	NaN	2015-11-16 23:23:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Oh goodness. A super rare northeast Qdoba kangaroo mix. Massive feet. No pouch (disappointing). Seems alert. 9/10 https://t.co/Dc7b0E8qFE	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666396247373291520/photo/1	9	10	None	NaN
2329	666373753744588802	NaN	NaN	2015-11-16 21:54:18 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Those are sunglasses and a jean jacket. 11/10 dog cool af https://t.co/uHXrPkUEyl	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666373753744588802/photo/1	11	10	None	NaN
2330	666362758909284353	NaN	NaN	2015-11-16 21:10:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Unique dog here. Very small. Lives in container of Frosted Flakes (?). Short legs. Must be rare 6/10 would still pet https://t.co/XMD9CwjEnM	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666362758909284353/photo/1	6	10	None	NaN
2331	666353288456101888	NaN	NaN	2015-11-16 20:32:58 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a mixed Asiago from the Galápagos Islands. Only one ear working. Big fan of marijuana carpet. 8/10 https://t.co/tltQ5w9aUO	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666353288456101888/photo/1	8	10	None	NaN
2332	666345417576210432	NaN	NaN	2015-11-16 20:01:42 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Look at this jokester thinking seat belt laws don't apply to him. Great tongue tho 10/10 https://t.co/VFKG1vxGjB	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666345417576210432/photo/1	10	10	None	NaN
2333	666337882303524864	NaN	NaN	2015-11-16 19:31:45 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an extremely rare horned Parthenon. Not amused. Wears shoes. Overall very nice. 9/10 would pet aggressively https://t.co/QpRjllzWAL	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666337882303524864/photo/1	9	10	an	NaN
2334	666293911632134144	NaN	NaN	2015-11-16 16:37:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a funny dog. Weird toes. Won't come down. Loves branch. Refuses to eat his food. Hard to cuddle with. 3/10 https://t.co/IIXis0zta0	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666293911632134144/photo/1	3	10	a	NaN
2335	666287406224695296	NaN	NaN	2015-11-16 16:11:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an Albanian 3 1/2 legged Episcopalian. Loves well-polished hardwood flooring. Penis on the collar. 9/10 https://t.co/d9NcXFKwLv	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666287406224695296/photo/1	1	2	an	NaN
2336	666273097616637952	NaN	NaN	2015-11-16 15:14:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Can take selfies 11/10 https://t.co/ws2AMaNwPW	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666273097616637952/photo/1	11	10	None	NaN
2337	666268910803644416	NaN	NaN	2015-11-16 14:57:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Very concerned about fellow dog trapped in computer. 10/10 https://t.co/0yxApIikpk	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666268910803644416/photo/1	10	10	None	NaN
2338	666104133288665088	NaN	NaN	2015-11-16 04:02:55 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Not familiar with this breed. No tail (weird). Only 2 legs. Doesn't bark. Surprisingly quick. Shits eggs. 1/10 https://t.co/Asgdc6kuLX	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666104133288665088/photo/1	1	10	None	NaN
2339	666102155909144576	NaN	NaN	2015-11-16 03:55:04 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Oh my. Here you are seeing an Adobe Setter giving birth to twins!!! The world is an amazing place. 11/10 https://t.co/11LvqN4WLq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666102155909144576/photo/1	11	10	None	NaN
2340	666099513787052032	NaN	NaN	2015-11-16 03:44:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Can stand on stump for what seems like a while. Built that birdhouse? Impressive. Made friends with a squirrel. 8/10 https://t.co/Ri4nMTLq5C	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666099513787052032/photo/1	8	10	None	NaN
2341	666094000022159362	NaN	NaN	2015-11-16 03:22:39 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This appears to be a Mongolian Presbyterian mix. Very tired. Tongue slip confirmed. 9/10 would lie down with https://t.co/mnioXo3IfP	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666094000022159362/photo/1	9	10	None	NaN
2342	666082916733198337	NaN	NaN	2015-11-16 02:38:37 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a well-established sunblockerspaniel. Lost his other flip-flop. 6/10 not very waterproof https://t.co/3RU6x0vHB7	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666082916733198337/photo/1	6	10	None	NaN
2343	666073100786774016	NaN	NaN	2015-11-16 01:59:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Let's hope this flight isn't Malaysian (lol). What a dog! Almost completely camouflaged. 10/10 I trust this pilot https://t.co/Yk6GHE9tOY	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666073100786774016/photo/1	10	10	None	NaN
2344	666071193221509120	NaN	NaN	2015-11-16 01:52:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a northern speckled Rhododendron. Much sass. Gives 0 fucks. Good tongue. 9/10 would caress sensually https://t.co/ZoL8kq2XFx	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666071193221509120/photo/1	9	10	None	NaN
2345	666063827256086533	NaN	NaN	2015-11-16 01:22:45 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is the happiest dog you will ever see. Very committed owner. Nice couch. 10/10 https://t.co/RhUEAloehK	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666063827256086533/photo/1	10	10	the	NaN
2346	666058600524156928	NaN	NaN	2015-11-16 01:01:59 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is the Rand Paul of retrievers folks! He's probably good at poker. Can drink beer (lol rad). 8/10 good dog https://t.co/pYAJkAe76p	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666058600524156928/photo/1	8	10	the	NaN
2347	666057090499244032	NaN	NaN	2015-11-16 00:55:59 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	My oh my. This is a rare blond Canadian terrier on wheels. Only $8.98. Rather docile. 9/10 very rare https://t.co/yWBqbrzy8O	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666057090499244032/photo/1	9	10	a	NaN
2348	666055525042405380	NaN	NaN	2015-11-16 00:49:46 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is a Siberian heavily armored polar bear mix. Strong owner. 10/10 I would do unspeakable things to pet this dog https://t.co/rdivxLiqEt	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666055525042405380/photo/1	10	10	a	NaN
2349	666051853826850816	NaN	NaN	2015-11-16 00:35:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an odd dog. Hard on the outside but loving on the inside. Petting still fun. Doesn't play catch well. 2/10 https://t.co/v5A4vzSDdc	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666051853826850816/photo/1	2	10	an	NaN
2350	666050758794694657	NaN	NaN	2015-11-16 00:30:50 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a truly beautiful English Wilson Staff retriever. Has a nice phone. Privileged. 10/10 would trade lives with https://t.co/fvIbQfHjIe	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666050758794694657/photo/1	10	10	a	NaN
2351	666049248165822465	NaN	NaN	2015-11-16 00:24:50 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a 1949 1st generation vulpix. Enjoys sweat tea and Fox News. Cannot be phased. 5/10 https://t.co/4B7cOc1EDq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666049248165822465/photo/1	5	10	None	NaN
2352	666044226329800704	NaN	NaN	2015-11-16 00:04:52 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a purebred Piers Morgan. Loves to Netflix and chill. Always looks like he forgot to unplug the iron. 6/10 https://t.co/DWnyCjf2mx	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666044226329800704/photo/1	6	10	a	NaN
2353	666033412701032449	NaN	NaN	2015-11-15 23:21:54 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is a very happy pup. Big fan of well-maintained decks. Just look at that tongue. 9/10 would cuddle af https://t.co/y671yMhoiR	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666033412701032449/photo/1	9	10	a	NaN
2354	666029285002620928	NaN	NaN	2015-11-15 23:05:30 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a western brown Mitsubishi terrier. Upset about leaf. Actually 2 dogs here. 7/10 would walk the shit out of https://t.co/r7mOb2m0UI	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666029285002620928/photo/1	7	10	a	NaN
2355	666020888022790149	NaN	NaN	2015-11-15 22:32:08 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a Japanese Irish Setter. Lost eye in Vietnam (?). Big fan of relaxing on stair. 8/10 would pet https://t.co/BLDqew2Ijj	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666020888022790149/photo/1	8	10	None	NaN

	tweet_id	in_reply_to_status_id	in_reply_to_user_id	timestamp	source	text	retweeted_status_id	retweeted_status_user_id	retweeted_status_timestamp	expanded_urls	rating_numerator	rating_denominator	name	dog_stage
0	892420643555336193	NaN	NaN	2017-08-01 16:23:56 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU	NaN	NaN	NaN	https://twitter.com/dog_rates/status/892420643555336193/photo/1	13	10	Phineas	NaN
1	892177421306343426	NaN	NaN	2017-08-01 00:17:27 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Tilly. She's just checking pup on you. Hopes you're doing ok. If not, she's available for pats, snugs, boops, the whole bit. 13/10 https://t.co/0Xxu71qeIV	NaN	NaN	NaN	https://twitter.com/dog_rates/status/892177421306343426/photo/1	13	10	Tilly	NaN
2	891815181378084864	NaN	NaN	2017-07-31 00:18:03 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Archie. He is a rare Norwegian Pouncing Corgo. Lives in the tall grass. You never know when one may strike. 12/10 https://t.co/wUnZnhtVJB	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891815181378084864/photo/1	12	10	Archie	NaN
3	891689557279858688	NaN	NaN	2017-07-30 15:58:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Darla. She commenced a snooze mid meal. 13/10 happens to the best of us https://t.co/tD36da7qLQ	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891689557279858688/photo/1	13	10	Darla	NaN
4	891327558926688256	NaN	NaN	2017-07-29 16:00:24 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Franklin. He would like you to stop calling him "cute." He is a very fierce shark and should be respected as such. 12/10 #BarkWeek https://t.co/AtUZn91f7f	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891327558926688256/photo/1,https://twitter.com/dog_rates/status/891327558926688256/photo/1	12	10	Franklin	NaN
5	891087950875897856	NaN	NaN	2017-07-29 00:08:17 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a majestic great white breaching off South Africa's coast. Absolutely h*ckin breathtaking. 13/10 (IG: tucker_marlo) #BarkWeek https://t.co/kQ04fDDRmh	NaN	NaN	NaN	https://twitter.com/dog_rates/status/891087950875897856/photo/1	13	10	None	NaN
6	890971913173991426	NaN	NaN	2017-07-28 16:27:12 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Meet Jax. He enjoys ice cream so much he gets nervous around it. 13/10 help Jax enjoy more things by clicking below\n\nhttps://t.co/Zr4hWfAs1H https://t.co/tVJBRMnhxl	NaN	NaN	NaN	https://gofundme.com/ydvmve-surgery-for-jax,https://twitter.com/dog_rates/status/890971913173991426/photo/1	13	10	Jax	NaN
7	890729181411237888	NaN	NaN	2017-07-28 00:22:40 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	When you watch your owner call another dog a good boy but then they turn back to you and say you're a great boy. 13/10 https://t.co/v0nONBcwxq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890729181411237888/photo/1,https://twitter.com/dog_rates/status/890729181411237888/photo/1	13	10	None	NaN
8	890609185150312448	NaN	NaN	2017-07-27 16:25:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Zoey. She doesn't want to be one of the scary sharks. Just wants to be a snuggly pettable boatpet. 13/10 #BarkWeek https://t.co/9TwLuAGH0b	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890609185150312448/photo/1	13	10	Zoey	NaN
9	890240255349198849	NaN	NaN	2017-07-26 15:59:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Cassie. She is a college pup. Studying international doggo communication and stick theory. 14/10 so elegant much sophisticate https://t.co/t1bfwz5S2A	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890240255349198849/photo/1	14	10	Cassie	doggo
10	890006608113172480	NaN	NaN	2017-07-26 00:31:25 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Koda. He is a South Australian deckshark. Deceptively deadly. Frighteningly majestic. 13/10 would risk a petting #BarkWeek https://t.co/dVPW0B0Mme	NaN	NaN	NaN	https://twitter.com/dog_rates/status/890006608113172480/photo/1,https://twitter.com/dog_rates/status/890006608113172480/photo/1	13	10	Koda	NaN
11	889880896479866881	NaN	NaN	2017-07-25 16:11:53 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Bruno. He is a service shark. Only gets out of the water to assist you. 13/10 terrifyingly good boy https://t.co/u1XPQMl29g	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889880896479866881/photo/1	13	10	Bruno	NaN
12	889665388333682689	NaN	NaN	2017-07-25 01:55:32 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here's a puppo that seems to be on the fence about something haha no but seriously someone help her. 13/10 https://t.co/BxvuXk0UCm	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889665388333682689/photo/1	13	10	None	puppo
13	889638837579907072	NaN	NaN	2017-07-25 00:10:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Ted. He does his best. Sometimes that's not enough. But it's ok. 12/10 would assist https://t.co/f8dEDcrKSR	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889638837579907072/photo/1,https://twitter.com/dog_rates/status/889638837579907072/photo/1	12	10	Ted	NaN
14	889531135344209921	NaN	NaN	2017-07-24 17:02:04 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Stuart. He's sporting his favorite fanny pack. Secretly filled with bones only. 13/10 puppared puppo #BarkWeek https://t.co/y70o6h3isq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889531135344209921/photo/1	13	10	Stuart	puppo
15	889278841981685760	NaN	NaN	2017-07-24 00:19:32 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Oliver. You're witnessing one of his many brutal attacks. Seems to be playing with his victim. 13/10 fr*ckin frightening #BarkWeek https://t.co/WpHvrQedPb	NaN	NaN	NaN	https://twitter.com/dog_rates/status/889278841981685760/video/1	13	10	Oliver	NaN
16	888917238123831296	NaN	NaN	2017-07-23 00:22:39 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Jim. He found a fren. Taught him how to sit like the good boys. 12/10 for both https://t.co/chxruIOUJN	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888917238123831296/photo/1	12	10	Jim	NaN
17	888804989199671297	NaN	NaN	2017-07-22 16:56:37 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Zeke. He has a new stick. Very proud of it. Would like you to throw it for him without taking it. 13/10 would do my best https://t.co/HTQ77yNQ5K	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888804989199671297/photo/1,https://twitter.com/dog_rates/status/888804989199671297/photo/1	13	10	Zeke	NaN
18	888554962724278272	NaN	NaN	2017-07-22 00:23:06 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Ralphus. He's powering up. Attempting maximum borkdrive. 13/10 inspirational af https://t.co/YnYAFCTTiK	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1	13	10	Ralphus	NaN
20	888078434458587136	NaN	NaN	2017-07-20 16:49:33 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Gerald. He was just told he didn't get the job he interviewed for. A h*ckin injustice. 12/10 didn't want the job anyway https://t.co/DK7iDPfuRX	NaN	NaN	NaN	https://twitter.com/dog_rates/status/888078434458587136/photo/1,https://twitter.com/dog_rates/status/888078434458587136/photo/1	12	10	Gerald	NaN
21	887705289381826560	NaN	NaN	2017-07-19 16:06:48 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Jeffrey. He has a monopoly on the pool noodles. Currently running a 'boop for two' midweek sale. 13/10 h*ckin strategic https://t.co/PhrUk20Q64	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887705289381826560/photo/1	13	10	Jeffrey	NaN
22	887517139158093824	NaN	NaN	2017-07-19 03:39:09 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	I've yet to rate a Venezuelan Hover Wiener. This is such an honor. 14/10 paw-inspiring af (IG: roxy.thedoxy) https://t.co/20VrLAA8ba	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887517139158093824/video/1	14	10	None	NaN
23	887473957103951883	NaN	NaN	2017-07-19 00:47:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Canela. She attempted some fancy porch pics. They were unsuccessful. 13/10 someone help her https://t.co/cLyzpcUcMX	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887473957103951883/photo/1,https://twitter.com/dog_rates/status/887473957103951883/photo/1	13	10	Canela	NaN
24	887343217045368832	NaN	NaN	2017-07-18 16:08:03 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	You may not have known you needed to see this today. 13/10 please enjoy (IG: emmylouroo) https://t.co/WZqNqygEyV	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887343217045368832/video/1	13	10	None	NaN
25	887101392804085760	NaN	NaN	2017-07-18 00:07:08 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This... is a Jubilant Antarctic House Bear. We only rate dogs. Please only send dogs. Thank you... 12/10 would suffocate in floof https://t.co/4Ad1jzJSdp	NaN	NaN	NaN	https://twitter.com/dog_rates/status/887101392804085760/photo/1	12	10	None	NaN
26	886983233522544640	NaN	NaN	2017-07-17 16:17:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Maya. She's very shy. Rarely leaves her cup. 13/10 would find her an environment to thrive in https://t.co/I6oNy0CgiT	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886983233522544640/photo/1,https://twitter.com/dog_rates/status/886983233522544640/photo/1	13	10	Maya	NaN
27	886736880519319552	NaN	NaN	2017-07-16 23:58:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Mingus. He's a wonderful father to his smol pup. Confirmed 13/10, but he needs your help\n\nhttps://t.co/bVi0Yr4Cff https://t.co/ISvKOSkd5b	NaN	NaN	NaN	https://www.gofundme.com/mingusneedsus,https://twitter.com/dog_rates/status/886736880519319552/photo/1,https://twitter.com/dog_rates/status/886736880519319552/photo/1	13	10	Mingus	NaN
28	886680336477933568	NaN	NaN	2017-07-16 20:14:00 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Derek. He's late for a dog meeting. 13/10 pet...al to the metal https://t.co/BCoWue0abA	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886680336477933568/photo/1	13	10	Derek	NaN
29	886366144734445568	NaN	NaN	2017-07-15 23:25:31 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Roscoe. Another pupper fallen victim to spontaneous tongue ejections. Get the BlepiPen immediate. 12/10 deep breaths Roscoe https://t.co/RGE08MIJox	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886366144734445568/photo/1,https://twitter.com/dog_rates/status/886366144734445568/photo/1	12	10	Roscoe	pupper
31	886258384151887873	NaN	NaN	2017-07-15 16:17:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Waffles. His doggles are pupside down. Unsure how to fix. 13/10 someone assist Waffles https://t.co/xZDA9Qsq1O	NaN	NaN	NaN	https://twitter.com/dog_rates/status/886258384151887873/photo/1	13	10	Waffles	NaN
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2326	666411507551481857	NaN	NaN	2015-11-17 00:24:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is quite the dog. Gets really excited when not in water. Not very soft tho. Bad at fetch. Can't do tricks. 2/10 https://t.co/aMCTNWO94t	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666411507551481857/photo/1	2	10	None	NaN
2327	666407126856765440	NaN	NaN	2015-11-17 00:06:54 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a southern Vesuvius bumblegruff. Can drive a truck (wow). Made friends with 5 other nifty dogs (neat). 7/10 https://t.co/LopTBkKa8h	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666407126856765440/photo/1	7	10	None	NaN
2328	666396247373291520	NaN	NaN	2015-11-16 23:23:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Oh goodness. A super rare northeast Qdoba kangaroo mix. Massive feet. No pouch (disappointing). Seems alert. 9/10 https://t.co/Dc7b0E8qFE	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666396247373291520/photo/1	9	10	None	NaN
2329	666373753744588802	NaN	NaN	2015-11-16 21:54:18 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Those are sunglasses and a jean jacket. 11/10 dog cool af https://t.co/uHXrPkUEyl	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666373753744588802/photo/1	11	10	None	NaN
2330	666362758909284353	NaN	NaN	2015-11-16 21:10:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Unique dog here. Very small. Lives in container of Frosted Flakes (?). Short legs. Must be rare 6/10 would still pet https://t.co/XMD9CwjEnM	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666362758909284353/photo/1	6	10	None	NaN
2331	666353288456101888	NaN	NaN	2015-11-16 20:32:58 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a mixed Asiago from the Galápagos Islands. Only one ear working. Big fan of marijuana carpet. 8/10 https://t.co/tltQ5w9aUO	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666353288456101888/photo/1	8	10	None	NaN
2332	666345417576210432	NaN	NaN	2015-11-16 20:01:42 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Look at this jokester thinking seat belt laws don't apply to him. Great tongue tho 10/10 https://t.co/VFKG1vxGjB	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666345417576210432/photo/1	10	10	None	NaN
2333	666337882303524864	NaN	NaN	2015-11-16 19:31:45 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an extremely rare horned Parthenon. Not amused. Wears shoes. Overall very nice. 9/10 would pet aggressively https://t.co/QpRjllzWAL	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666337882303524864/photo/1	9	10	None	NaN
2334	666293911632134144	NaN	NaN	2015-11-16 16:37:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a funny dog. Weird toes. Won't come down. Loves branch. Refuses to eat his food. Hard to cuddle with. 3/10 https://t.co/IIXis0zta0	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666293911632134144/photo/1	3	10	None	NaN
2335	666287406224695296	NaN	NaN	2015-11-16 16:11:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an Albanian 3 1/2 legged Episcopalian. Loves well-polished hardwood flooring. Penis on the collar. 9/10 https://t.co/d9NcXFKwLv	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666287406224695296/photo/1	1	2	None	NaN
2336	666273097616637952	NaN	NaN	2015-11-16 15:14:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Can take selfies 11/10 https://t.co/ws2AMaNwPW	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666273097616637952/photo/1	11	10	None	NaN
2337	666268910803644416	NaN	NaN	2015-11-16 14:57:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Very concerned about fellow dog trapped in computer. 10/10 https://t.co/0yxApIikpk	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666268910803644416/photo/1	10	10	None	NaN
2338	666104133288665088	NaN	NaN	2015-11-16 04:02:55 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Not familiar with this breed. No tail (weird). Only 2 legs. Doesn't bark. Surprisingly quick. Shits eggs. 1/10 https://t.co/Asgdc6kuLX	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666104133288665088/photo/1	1	10	None	NaN
2339	666102155909144576	NaN	NaN	2015-11-16 03:55:04 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Oh my. Here you are seeing an Adobe Setter giving birth to twins!!! The world is an amazing place. 11/10 https://t.co/11LvqN4WLq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666102155909144576/photo/1	11	10	None	NaN
2340	666099513787052032	NaN	NaN	2015-11-16 03:44:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Can stand on stump for what seems like a while. Built that birdhouse? Impressive. Made friends with a squirrel. 8/10 https://t.co/Ri4nMTLq5C	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666099513787052032/photo/1	8	10	None	NaN
2341	666094000022159362	NaN	NaN	2015-11-16 03:22:39 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This appears to be a Mongolian Presbyterian mix. Very tired. Tongue slip confirmed. 9/10 would lie down with https://t.co/mnioXo3IfP	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666094000022159362/photo/1	9	10	None	NaN
2342	666082916733198337	NaN	NaN	2015-11-16 02:38:37 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a well-established sunblockerspaniel. Lost his other flip-flop. 6/10 not very waterproof https://t.co/3RU6x0vHB7	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666082916733198337/photo/1	6	10	None	NaN
2343	666073100786774016	NaN	NaN	2015-11-16 01:59:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Let's hope this flight isn't Malaysian (lol). What a dog! Almost completely camouflaged. 10/10 I trust this pilot https://t.co/Yk6GHE9tOY	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666073100786774016/photo/1	10	10	None	NaN
2344	666071193221509120	NaN	NaN	2015-11-16 01:52:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a northern speckled Rhododendron. Much sass. Gives 0 fucks. Good tongue. 9/10 would caress sensually https://t.co/ZoL8kq2XFx	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666071193221509120/photo/1	9	10	None	NaN
2345	666063827256086533	NaN	NaN	2015-11-16 01:22:45 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is the happiest dog you will ever see. Very committed owner. Nice couch. 10/10 https://t.co/RhUEAloehK	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666063827256086533/photo/1	10	10	None	NaN
2346	666058600524156928	NaN	NaN	2015-11-16 01:01:59 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is the Rand Paul of retrievers folks! He's probably good at poker. Can drink beer (lol rad). 8/10 good dog https://t.co/pYAJkAe76p	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666058600524156928/photo/1	8	10	None	NaN
2347	666057090499244032	NaN	NaN	2015-11-16 00:55:59 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	My oh my. This is a rare blond Canadian terrier on wheels. Only $8.98. Rather docile. 9/10 very rare https://t.co/yWBqbrzy8O	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666057090499244032/photo/1	9	10	None	NaN
2348	666055525042405380	NaN	NaN	2015-11-16 00:49:46 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is a Siberian heavily armored polar bear mix. Strong owner. 10/10 I would do unspeakable things to pet this dog https://t.co/rdivxLiqEt	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666055525042405380/photo/1	10	10	None	NaN
2349	666051853826850816	NaN	NaN	2015-11-16 00:35:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an odd dog. Hard on the outside but loving on the inside. Petting still fun. Doesn't play catch well. 2/10 https://t.co/v5A4vzSDdc	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666051853826850816/photo/1	2	10	None	NaN
2350	666050758794694657	NaN	NaN	2015-11-16 00:30:50 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a truly beautiful English Wilson Staff retriever. Has a nice phone. Privileged. 10/10 would trade lives with https://t.co/fvIbQfHjIe	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666050758794694657/photo/1	10	10	None	NaN
2351	666049248165822465	NaN	NaN	2015-11-16 00:24:50 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a 1949 1st generation vulpix. Enjoys sweat tea and Fox News. Cannot be phased. 5/10 https://t.co/4B7cOc1EDq	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666049248165822465/photo/1	5	10	None	NaN
2352	666044226329800704	NaN	NaN	2015-11-16 00:04:52 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a purebred Piers Morgan. Loves to Netflix and chill. Always looks like he forgot to unplug the iron. 6/10 https://t.co/DWnyCjf2mx	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666044226329800704/photo/1	6	10	None	NaN
2353	666033412701032449	NaN	NaN	2015-11-15 23:21:54 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is a very happy pup. Big fan of well-maintained decks. Just look at that tongue. 9/10 would cuddle af https://t.co/y671yMhoiR	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666033412701032449/photo/1	9	10	None	NaN
2354	666029285002620928	NaN	NaN	2015-11-15 23:05:30 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a western brown Mitsubishi terrier. Upset about leaf. Actually 2 dogs here. 7/10 would walk the shit out of https://t.co/r7mOb2m0UI	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666029285002620928/photo/1	7	10	None	NaN
2355	666020888022790149	NaN	NaN	2015-11-15 22:32:08 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a Japanese Irish Setter. Lost eye in Vietnam (?). Big fan of relaxing on stair. 8/10 would pet https://t.co/BLDqew2Ijj	NaN	NaN	NaN	https://twitter.com/dog_rates/status/666020888022790149/photo/1	8	10	None	NaN

	tweet_id	timestamp	source	text	expanded_urls	rating_numerator	rating_denominator	name	dog_stage
0	892420643555336193	2017-08-01 16:23:56 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU	https://twitter.com/dog_rates/status/892420643555336193/photo/1	13	10	Phineas	NaN
1	892177421306343426	2017-08-01 00:17:27 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Tilly. She's just checking pup on you. Hopes you're doing ok. If not, she's available for pats, snugs, boops, the whole bit. 13/10 https://t.co/0Xxu71qeIV	https://twitter.com/dog_rates/status/892177421306343426/photo/1	13	10	Tilly	NaN
2	891815181378084864	2017-07-31 00:18:03 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Archie. He is a rare Norwegian Pouncing Corgo. Lives in the tall grass. You never know when one may strike. 12/10 https://t.co/wUnZnhtVJB	https://twitter.com/dog_rates/status/891815181378084864/photo/1	12	10	Archie	NaN
3	891689557279858688	2017-07-30 15:58:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Darla. She commenced a snooze mid meal. 13/10 happens to the best of us https://t.co/tD36da7qLQ	https://twitter.com/dog_rates/status/891689557279858688/photo/1	13	10	Darla	NaN
4	891327558926688256	2017-07-29 16:00:24 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Franklin. He would like you to stop calling him "cute." He is a very fierce shark and should be respected as such. 12/10 #BarkWeek https://t.co/AtUZn91f7f	https://twitter.com/dog_rates/status/891327558926688256/photo/1,https://twitter.com/dog_rates/status/891327558926688256/photo/1	12	10	Franklin	NaN
5	891087950875897856	2017-07-29 00:08:17 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a majestic great white breaching off South Africa's coast. Absolutely h*ckin breathtaking. 13/10 (IG: tucker_marlo) #BarkWeek https://t.co/kQ04fDDRmh	https://twitter.com/dog_rates/status/891087950875897856/photo/1	13	10	None	NaN
6	890971913173991426	2017-07-28 16:27:12 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Meet Jax. He enjoys ice cream so much he gets nervous around it. 13/10 help Jax enjoy more things by clicking below\n\nhttps://t.co/Zr4hWfAs1H https://t.co/tVJBRMnhxl	https://gofundme.com/ydvmve-surgery-for-jax,https://twitter.com/dog_rates/status/890971913173991426/photo/1	13	10	Jax	NaN
7	890729181411237888	2017-07-28 00:22:40 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	When you watch your owner call another dog a good boy but then they turn back to you and say you're a great boy. 13/10 https://t.co/v0nONBcwxq	https://twitter.com/dog_rates/status/890729181411237888/photo/1,https://twitter.com/dog_rates/status/890729181411237888/photo/1	13	10	None	NaN
8	890609185150312448	2017-07-27 16:25:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Zoey. She doesn't want to be one of the scary sharks. Just wants to be a snuggly pettable boatpet. 13/10 #BarkWeek https://t.co/9TwLuAGH0b	https://twitter.com/dog_rates/status/890609185150312448/photo/1	13	10	Zoey	NaN
9	890240255349198849	2017-07-26 15:59:51 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Cassie. She is a college pup. Studying international doggo communication and stick theory. 14/10 so elegant much sophisticate https://t.co/t1bfwz5S2A	https://twitter.com/dog_rates/status/890240255349198849/photo/1	14	10	Cassie	doggo
10	890006608113172480	2017-07-26 00:31:25 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Koda. He is a South Australian deckshark. Deceptively deadly. Frighteningly majestic. 13/10 would risk a petting #BarkWeek https://t.co/dVPW0B0Mme	https://twitter.com/dog_rates/status/890006608113172480/photo/1,https://twitter.com/dog_rates/status/890006608113172480/photo/1	13	10	Koda	NaN
11	889880896479866881	2017-07-25 16:11:53 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Bruno. He is a service shark. Only gets out of the water to assist you. 13/10 terrifyingly good boy https://t.co/u1XPQMl29g	https://twitter.com/dog_rates/status/889880896479866881/photo/1	13	10	Bruno	NaN
12	889665388333682689	2017-07-25 01:55:32 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here's a puppo that seems to be on the fence about something haha no but seriously someone help her. 13/10 https://t.co/BxvuXk0UCm	https://twitter.com/dog_rates/status/889665388333682689/photo/1	13	10	None	puppo
13	889638837579907072	2017-07-25 00:10:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Ted. He does his best. Sometimes that's not enough. But it's ok. 12/10 would assist https://t.co/f8dEDcrKSR	https://twitter.com/dog_rates/status/889638837579907072/photo/1,https://twitter.com/dog_rates/status/889638837579907072/photo/1	12	10	Ted	NaN
14	889531135344209921	2017-07-24 17:02:04 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Stuart. He's sporting his favorite fanny pack. Secretly filled with bones only. 13/10 puppared puppo #BarkWeek https://t.co/y70o6h3isq	https://twitter.com/dog_rates/status/889531135344209921/photo/1	13	10	Stuart	puppo
15	889278841981685760	2017-07-24 00:19:32 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Oliver. You're witnessing one of his many brutal attacks. Seems to be playing with his victim. 13/10 fr*ckin frightening #BarkWeek https://t.co/WpHvrQedPb	https://twitter.com/dog_rates/status/889278841981685760/video/1	13	10	Oliver	NaN
16	888917238123831296	2017-07-23 00:22:39 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Jim. He found a fren. Taught him how to sit like the good boys. 12/10 for both https://t.co/chxruIOUJN	https://twitter.com/dog_rates/status/888917238123831296/photo/1	12	10	Jim	NaN
17	888804989199671297	2017-07-22 16:56:37 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Zeke. He has a new stick. Very proud of it. Would like you to throw it for him without taking it. 13/10 would do my best https://t.co/HTQ77yNQ5K	https://twitter.com/dog_rates/status/888804989199671297/photo/1,https://twitter.com/dog_rates/status/888804989199671297/photo/1	13	10	Zeke	NaN
18	888554962724278272	2017-07-22 00:23:06 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Ralphus. He's powering up. Attempting maximum borkdrive. 13/10 inspirational af https://t.co/YnYAFCTTiK	https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1,https://twitter.com/dog_rates/status/888554962724278272/photo/1	13	10	Ralphus	NaN
20	888078434458587136	2017-07-20 16:49:33 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Gerald. He was just told he didn't get the job he interviewed for. A h*ckin injustice. 12/10 didn't want the job anyway https://t.co/DK7iDPfuRX	https://twitter.com/dog_rates/status/888078434458587136/photo/1,https://twitter.com/dog_rates/status/888078434458587136/photo/1	12	10	Gerald	NaN
21	887705289381826560	2017-07-19 16:06:48 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Jeffrey. He has a monopoly on the pool noodles. Currently running a 'boop for two' midweek sale. 13/10 h*ckin strategic https://t.co/PhrUk20Q64	https://twitter.com/dog_rates/status/887705289381826560/photo/1	13	10	Jeffrey	NaN
22	887517139158093824	2017-07-19 03:39:09 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	I've yet to rate a Venezuelan Hover Wiener. This is such an honor. 14/10 paw-inspiring af (IG: roxy.thedoxy) https://t.co/20VrLAA8ba	https://twitter.com/dog_rates/status/887517139158093824/video/1	14	10	None	NaN
23	887473957103951883	2017-07-19 00:47:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Canela. She attempted some fancy porch pics. They were unsuccessful. 13/10 someone help her https://t.co/cLyzpcUcMX	https://twitter.com/dog_rates/status/887473957103951883/photo/1,https://twitter.com/dog_rates/status/887473957103951883/photo/1	13	10	Canela	NaN
24	887343217045368832	2017-07-18 16:08:03 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	You may not have known you needed to see this today. 13/10 please enjoy (IG: emmylouroo) https://t.co/WZqNqygEyV	https://twitter.com/dog_rates/status/887343217045368832/video/1	13	10	None	NaN
25	887101392804085760	2017-07-18 00:07:08 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This... is a Jubilant Antarctic House Bear. We only rate dogs. Please only send dogs. Thank you... 12/10 would suffocate in floof https://t.co/4Ad1jzJSdp	https://twitter.com/dog_rates/status/887101392804085760/photo/1	12	10	None	NaN
26	886983233522544640	2017-07-17 16:17:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Maya. She's very shy. Rarely leaves her cup. 13/10 would find her an environment to thrive in https://t.co/I6oNy0CgiT	https://twitter.com/dog_rates/status/886983233522544640/photo/1,https://twitter.com/dog_rates/status/886983233522544640/photo/1	13	10	Maya	NaN
27	886736880519319552	2017-07-16 23:58:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Mingus. He's a wonderful father to his smol pup. Confirmed 13/10, but he needs your help\n\nhttps://t.co/bVi0Yr4Cff https://t.co/ISvKOSkd5b	https://www.gofundme.com/mingusneedsus,https://twitter.com/dog_rates/status/886736880519319552/photo/1,https://twitter.com/dog_rates/status/886736880519319552/photo/1	13	10	Mingus	NaN
28	886680336477933568	2017-07-16 20:14:00 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Derek. He's late for a dog meeting. 13/10 pet...al to the metal https://t.co/BCoWue0abA	https://twitter.com/dog_rates/status/886680336477933568/photo/1	13	10	Derek	NaN
29	886366144734445568	2017-07-15 23:25:31 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Roscoe. Another pupper fallen victim to spontaneous tongue ejections. Get the BlepiPen immediate. 12/10 deep breaths Roscoe https://t.co/RGE08MIJox	https://twitter.com/dog_rates/status/886366144734445568/photo/1,https://twitter.com/dog_rates/status/886366144734445568/photo/1	12	10	Roscoe	pupper
31	886258384151887873	2017-07-15 16:17:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Waffles. His doggles are pupside down. Unsure how to fix. 13/10 someone assist Waffles https://t.co/xZDA9Qsq1O	https://twitter.com/dog_rates/status/886258384151887873/photo/1	13	10	Waffles	NaN
...	...	...	...	...	...	...	...	...	...
2326	666411507551481857	2015-11-17 00:24:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is quite the dog. Gets really excited when not in water. Not very soft tho. Bad at fetch. Can't do tricks. 2/10 https://t.co/aMCTNWO94t	https://twitter.com/dog_rates/status/666411507551481857/photo/1	2	10	None	NaN
2327	666407126856765440	2015-11-17 00:06:54 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a southern Vesuvius bumblegruff. Can drive a truck (wow). Made friends with 5 other nifty dogs (neat). 7/10 https://t.co/LopTBkKa8h	https://twitter.com/dog_rates/status/666407126856765440/photo/1	7	10	None	NaN
2328	666396247373291520	2015-11-16 23:23:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Oh goodness. A super rare northeast Qdoba kangaroo mix. Massive feet. No pouch (disappointing). Seems alert. 9/10 https://t.co/Dc7b0E8qFE	https://twitter.com/dog_rates/status/666396247373291520/photo/1	9	10	None	NaN
2329	666373753744588802	2015-11-16 21:54:18 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Those are sunglasses and a jean jacket. 11/10 dog cool af https://t.co/uHXrPkUEyl	https://twitter.com/dog_rates/status/666373753744588802/photo/1	11	10	None	NaN
2330	666362758909284353	2015-11-16 21:10:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Unique dog here. Very small. Lives in container of Frosted Flakes (?). Short legs. Must be rare 6/10 would still pet https://t.co/XMD9CwjEnM	https://twitter.com/dog_rates/status/666362758909284353/photo/1	6	10	None	NaN
2331	666353288456101888	2015-11-16 20:32:58 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a mixed Asiago from the Galápagos Islands. Only one ear working. Big fan of marijuana carpet. 8/10 https://t.co/tltQ5w9aUO	https://twitter.com/dog_rates/status/666353288456101888/photo/1	8	10	None	NaN
2332	666345417576210432	2015-11-16 20:01:42 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Look at this jokester thinking seat belt laws don't apply to him. Great tongue tho 10/10 https://t.co/VFKG1vxGjB	https://twitter.com/dog_rates/status/666345417576210432/photo/1	10	10	None	NaN
2333	666337882303524864	2015-11-16 19:31:45 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an extremely rare horned Parthenon. Not amused. Wears shoes. Overall very nice. 9/10 would pet aggressively https://t.co/QpRjllzWAL	https://twitter.com/dog_rates/status/666337882303524864/photo/1	9	10	None	NaN
2334	666293911632134144	2015-11-16 16:37:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a funny dog. Weird toes. Won't come down. Loves branch. Refuses to eat his food. Hard to cuddle with. 3/10 https://t.co/IIXis0zta0	https://twitter.com/dog_rates/status/666293911632134144/photo/1	3	10	None	NaN
2335	666287406224695296	2015-11-16 16:11:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an Albanian 3 1/2 legged Episcopalian. Loves well-polished hardwood flooring. Penis on the collar. 9/10 https://t.co/d9NcXFKwLv	https://twitter.com/dog_rates/status/666287406224695296/photo/1	1	2	None	NaN
2336	666273097616637952	2015-11-16 15:14:19 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Can take selfies 11/10 https://t.co/ws2AMaNwPW	https://twitter.com/dog_rates/status/666273097616637952/photo/1	11	10	None	NaN
2337	666268910803644416	2015-11-16 14:57:41 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Very concerned about fellow dog trapped in computer. 10/10 https://t.co/0yxApIikpk	https://twitter.com/dog_rates/status/666268910803644416/photo/1	10	10	None	NaN
2338	666104133288665088	2015-11-16 04:02:55 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Not familiar with this breed. No tail (weird). Only 2 legs. Doesn't bark. Surprisingly quick. Shits eggs. 1/10 https://t.co/Asgdc6kuLX	https://twitter.com/dog_rates/status/666104133288665088/photo/1	1	10	None	NaN
2339	666102155909144576	2015-11-16 03:55:04 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Oh my. Here you are seeing an Adobe Setter giving birth to twins!!! The world is an amazing place. 11/10 https://t.co/11LvqN4WLq	https://twitter.com/dog_rates/status/666102155909144576/photo/1	11	10	None	NaN
2340	666099513787052032	2015-11-16 03:44:34 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Can stand on stump for what seems like a while. Built that birdhouse? Impressive. Made friends with a squirrel. 8/10 https://t.co/Ri4nMTLq5C	https://twitter.com/dog_rates/status/666099513787052032/photo/1	8	10	None	NaN
2341	666094000022159362	2015-11-16 03:22:39 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This appears to be a Mongolian Presbyterian mix. Very tired. Tongue slip confirmed. 9/10 would lie down with https://t.co/mnioXo3IfP	https://twitter.com/dog_rates/status/666094000022159362/photo/1	9	10	None	NaN
2342	666082916733198337	2015-11-16 02:38:37 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a well-established sunblockerspaniel. Lost his other flip-flop. 6/10 not very waterproof https://t.co/3RU6x0vHB7	https://twitter.com/dog_rates/status/666082916733198337/photo/1	6	10	None	NaN
2343	666073100786774016	2015-11-16 01:59:36 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Let's hope this flight isn't Malaysian (lol). What a dog! Almost completely camouflaged. 10/10 I trust this pilot https://t.co/Yk6GHE9tOY	https://twitter.com/dog_rates/status/666073100786774016/photo/1	10	10	None	NaN
2344	666071193221509120	2015-11-16 01:52:02 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a northern speckled Rhododendron. Much sass. Gives 0 fucks. Good tongue. 9/10 would caress sensually https://t.co/ZoL8kq2XFx	https://twitter.com/dog_rates/status/666071193221509120/photo/1	9	10	None	NaN
2345	666063827256086533	2015-11-16 01:22:45 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is the happiest dog you will ever see. Very committed owner. Nice couch. 10/10 https://t.co/RhUEAloehK	https://twitter.com/dog_rates/status/666063827256086533/photo/1	10	10	None	NaN
2346	666058600524156928	2015-11-16 01:01:59 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is the Rand Paul of retrievers folks! He's probably good at poker. Can drink beer (lol rad). 8/10 good dog https://t.co/pYAJkAe76p	https://twitter.com/dog_rates/status/666058600524156928/photo/1	8	10	None	NaN
2347	666057090499244032	2015-11-16 00:55:59 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	My oh my. This is a rare blond Canadian terrier on wheels. Only $8.98. Rather docile. 9/10 very rare https://t.co/yWBqbrzy8O	https://twitter.com/dog_rates/status/666057090499244032/photo/1	9	10	None	NaN
2348	666055525042405380	2015-11-16 00:49:46 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is a Siberian heavily armored polar bear mix. Strong owner. 10/10 I would do unspeakable things to pet this dog https://t.co/rdivxLiqEt	https://twitter.com/dog_rates/status/666055525042405380/photo/1	10	10	None	NaN
2349	666051853826850816	2015-11-16 00:35:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an odd dog. Hard on the outside but loving on the inside. Petting still fun. Doesn't play catch well. 2/10 https://t.co/v5A4vzSDdc	https://twitter.com/dog_rates/status/666051853826850816/photo/1	2	10	None	NaN
2350	666050758794694657	2015-11-16 00:30:50 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a truly beautiful English Wilson Staff retriever. Has a nice phone. Privileged. 10/10 would trade lives with https://t.co/fvIbQfHjIe	https://twitter.com/dog_rates/status/666050758794694657/photo/1	10	10	None	NaN
2351	666049248165822465	2015-11-16 00:24:50 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a 1949 1st generation vulpix. Enjoys sweat tea and Fox News. Cannot be phased. 5/10 https://t.co/4B7cOc1EDq	https://twitter.com/dog_rates/status/666049248165822465/photo/1	5	10	None	NaN
2352	666044226329800704	2015-11-16 00:04:52 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a purebred Piers Morgan. Loves to Netflix and chill. Always looks like he forgot to unplug the iron. 6/10 https://t.co/DWnyCjf2mx	https://twitter.com/dog_rates/status/666044226329800704/photo/1	6	10	None	NaN
2353	666033412701032449	2015-11-15 23:21:54 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here is a very happy pup. Big fan of well-maintained decks. Just look at that tongue. 9/10 would cuddle af https://t.co/y671yMhoiR	https://twitter.com/dog_rates/status/666033412701032449/photo/1	9	10	None	NaN
2354	666029285002620928	2015-11-15 23:05:30 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is a western brown Mitsubishi terrier. Upset about leaf. Actually 2 dogs here. 7/10 would walk the shit out of https://t.co/r7mOb2m0UI	https://twitter.com/dog_rates/status/666029285002620928/photo/1	7	10	None	NaN
2355	666020888022790149	2015-11-15 22:32:08 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Here we have a Japanese Irish Setter. Lost eye in Vietnam (?). Big fan of relaxing on stair. 8/10 would pet https://t.co/BLDqew2Ijj	https://twitter.com/dog_rates/status/666020888022790149/photo/1	8	10	None	NaN

	tweet_id	timestamp	source	text	expanded_urls	rating_numerator	rating_denominator	name	dog_stage
1068	740373189193256964	2016-06-08 02:41:38 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	After so many requests, this is Bretagne. She was the last surviving 9/11 search dog, and our second ever 14/10. RIP https://t.co/XAVDNDaVgQ	https://twitter.com/dog_rates/status/740373189193256964/photo/1,https://twitter.com/dog_rates/status/740373189193256964/photo/1,https://twitter.com/dog_rates/status/740373189193256964/photo/1,https://twitter.com/dog_rates/status/740373189193256964/photo/1	9	11	None	NaN
1165	722974582966214656	2016-04-21 02:25:47 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	Happy 4/20 from the squad! 13/10 for all https://t.co/eV1diwds8a	https://twitter.com/dog_rates/status/722974582966214656/photo/1	4	20	None	NaN
1662	682962037429899265	2016-01-01 16:30:13 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is Darrel. He just robbed a 7/11 and is in a high speed police chase. Was just spotted by the helicopter 10/10 https://t.co/7EsP8LmSp5	https://twitter.com/dog_rates/status/682962037429899265/photo/1	7	11	Darrel	NaN
2335	666287406224695296	2015-11-16 16:11:11 +0000	<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>	This is an Albanian 3 1/2 legged Episcopalian. Loves well-polished hardwood flooring. Penis on the collar. 9/10 https://t.co/d9NcXFKwLv	https://twitter.com/dog_rates/status/666287406224695296/photo/1	1	2	None	NaN