Data is here: https://www.dropbox.com/s/4cbpwdcd802av1z/11-homework-data.zip?dl=0 [ www.dropbox.com/s/4cbpwdcd802av1z/11-homework-data.zip?dl=0 ]
Read this: http://iquantny.tumblr.com/post/144197004989/the-nypd-was-systematically-ticketing-legally
And the then we can take a peek at some data on parking. After you've cleaned up the data as instructed below, feel free to browse in other directions than the ones I say. When fixing up the data, you'll probably making a lot of use of date parsing and .apply.
In [1]:
import pandas as pd
df = pd.read_csv('violations.csv', dtype = 'str', parse_dates = True)
In [2]:
# test to make sure we haven't lost leading zeroes
# type(df['Plate ID'][0])
In [3]:
# test to make sure we haven't lost leading zeroes
# df['Plate ID'][0][0]
In [4]:
# test to make sure we haven't lost leading zeroes
# number_of_plates = range(len(df['Plate ID']))
# for number in number_of_plates:
# if str(df['Plate ID'][number])[0] == '0': #used str as a workaround for the nan value at 2743
# print(df['Plate ID'][number])
In [5]:
# # troubleshooting bc 2743 is na
# type(df['Plate ID'][2743])
# # if df['Plate ID'][2743]:
# # print(df['Plate ID'][2743])
In [6]:
# df['Vehicle Year'].head(10)
In [7]:
# Turns "0"s into the string "NaN"
# df['Vehicle Year'] = ['NaN' if item == '0' else item for item in df['Vehicle Year']]
In [8]:
# Turns "0"s into NoneType
df['Vehicle Year'] = df['Vehicle Year'].where(df['Vehicle Year'] != '0', None)
In [9]:
# seeing if parse_dates = True worked:
# df['Issue Date'].head()
In [10]:
df['Date First Observed'][30: 35]
Out[10]:
30 0
31 0
32 0
33 20130719
34 20130719
Name: Date First Observed, dtype: object
In [11]:
# 33 is a date
# Did it for the whole dataframe instead of for each row
# def year(row):
# return df['Date First Observed'][row][:4]
# def month(row):
# return df['Date First Observed'][row][4:6]
# def day(row):
# return df['Date First Observed'][row][-2:]
# def date(row):
# return {
# 'year': year(row),
# 'month': month(row),
# 'day': day(row)
# }
def year(row):
return row[:4]
def month(row):
return row[4:6]
def day(row):
return row[-2:]
def date(row):
if len(row) == 8:
dictionary = {
'year': year(row),
'month': month(row),
'day': day(row)
}
return '{year}-{month}-{day}'.format(**dictionary)
else:
return None
df['Date First Observed Formatted'] = df['Date First Observed'].apply(date)
In [12]:
df['Date First Observed Formatted'][30: 35]
Out[12]:
30 None
31 None
32 None
33 2013-07-19
34 2013-07-19
Name: Date First Observed Formatted, dtype: object
In [13]:
df['Violation Time'].head()
Out[13]:
0 0752A
1 1240P
2 1243P
3 0232P
4 1239P
Name: Violation Time, dtype: object
In [18]:
def hour(row):
if row[0] == '.':
return 'ERROR'
elif row[-1] == 'P' and row[:2] != '12':
try:
return str(int(row[:2]) + 12)
except:
return 'ERROR'
else:
return row[:2]
def minute(row):
return row[2:4]
def time(row):
if pd.isnull(row):
return None
elif len(row) == 5:
dictionary = {
'hour': hour(row),
'minute': minute(row)
}
return '{hour}:{minute}'.format(**dictionary)
In [15]:
number = -1
for item in df['Violation Time']:
number += 1
if isinstance(item, float):
pass
elif item.startswith('.6'):
print(item)
print(number)
.633P
424306
In [19]:
df['Violation Time Formatted'] = df['Violation Time'].apply(time)
In [20]:
df['Violation Time Formatted'][424306]
Out[20]:
'ERROR:33'
In [21]:
df['Vehicle Color'].value_counts()
Out[21]:
WHITE 728250
GY 661576
WH 640616
BK 511959
BLACK 370401
BL 242381
GREY 234869
SILVE 177730
BLUE 167820
RED 150914
RD 150134
BROWN 141007
GR 110889
GREEN 83711
TN 73952
OTHER 49844
BLK 41123
TAN 40580
BR 40150
YW 38974
GRAY 36264
GL 29839
GOLD 29379
YELLO 23987
WHT 23672
MR 17112
GRY 16625
WT 8664
ORANG 7546
BRN 7534
...
GR SL 1
GEAY 1
ORTN 1
NAY 1
CNI 1
LWH 1
RD/ W 1
PUE 1
BVLAC 1
BRAW 1
HIK 1
DKWH 1
WU.CK 1
BRURG 1
BLU W 1
BUGY 1
GRAYH 1
GR WH 1
DREY 1
BEIGO 1
DA RE 1
ORSNG 1
JV 1
I 1
I.Y.A 1
IVORY 1
TN-WH 1
BKC 1
BUK 1
IVY/I 1
Name: Vehicle Color, dtype: int64
In [22]:
def color(row):
# white
if row == 'WH' or row == 'WHT' or row == 'WT' or row == 'WHI' or row == 'W':
return 'WHITE'
# gray
elif row == 'GY' or row == 'GREY' or row == 'GRY' or row == 'GREW':
return 'GRAY'
# black
elif row == 'BK' or row == 'BLK' or row == 'BCK':
return 'BLACK'
# blue. I'm guessing BL is BLUE since there are two-letter codes and BK is BLACK
elif row == 'NAVYB' or row == 'BL' or row == 'B LU' or row == 'BLU':
return 'BLUE'
# silver
elif row == 'SILVE' or row == 'SLVIR' or row == 'SL' or row == 'SIL' or row == 'SILVR' or row == 'SILV' or row == 'SILIV':
return 'SILVER'
# red
elif row == 'RD' or row == 'REDD':
return 'RED'
# green
elif row == 'GR' or row == 'GRN' or row == 'GN':
return 'GREEN'
# tan
elif row == 'TN' or row == 'BEIGE':
return 'TAN'
# brown
elif row == 'BR' or row == 'BRN' or row == 'BN' or row == 'BRWN' or row == 'BRW' or row == 'BRO':
return 'BROWN'
# yellow
elif row =='YW' or row == 'YELLO' or row == 'YE' or row == 'YELL' or row == 'YEL':
return 'YELLOW'
# gold
elif row == 'GL' or row == 'GD' or row == 'GLD':
return 'GOLD'
# orange
elif row == 'ORANG' or row == 'ORNAG' or row == 'OR':
return 'ORANGE'
# purple
elif row == 'PURPL' or row == 'LAVEN':
return 'PURPLE'
# turquoise
elif row == 'TQ' or row == 'TURQ':
return 'TURQUOISE'
# maroon
elif row == 'MAROO' or row == 'BRGND' or row == 'BURG':
return 'MAROON'
else:
return row
In [23]:
df['Vehicle Color Formatted'] = df['Vehicle Color'].apply(color)
df['Vehicle Color Formatted'].value_counts()
Out[23]:
WHITE 1404696
GRAY 949337
BLACK 923492
BLUE 414139
RED 301050
GREEN 201566
BROWN 193329
SILVER 190321
TAN 115556
YELLOW 64222
GOLD 60272
OTHER 49844
MR 17112
ORANGE 13282
LTG 7234
PURPLE 5414
LT/ 3767
DKG 3355
DK/ 3328
PR 2619
DKB 1847
MAROON 1631
LTGY 1103
BLG 969
LTB 832
DKR 771
RD/ 735
NOC 700
GY/ 692
WH/ 480
...
ORTN 1
NAY 1
CNI 1
LWH 1
RUTT 1
GN GR 1
GRBBN 1
BRRG 1
WU.CK 1
RD/ W 1
BRURG 1
BLU W 1
BUGY 1
GRAYH 1
GR WH 1
DREY 1
BEIGO 1
DA RE 1
ORSNG 1
JV 1
I 1
I.Y.A 1
IVORY 1
TN-WH 1
BKC 1
BUK 1
BRAW 1
BVLAC 1
PUE 1
IVY/I 1
Name: Vehicle Color Formatted, dtype: int64
In [24]:
df_codes = pd.read_csv('Uniform_Violation_Codes.csv', dtype = str)
In [25]:
df_merged = df.merge(df_codes, how = 'left', left_on = 'Violation Code', right_on = 'CODE')
In [26]:
def fix_counties(county_name):
if county_name == 'RICH':
return 'R'
elif county_name == 'BRONX':
return 'BX'
elif county_name == 'KINGS':
return 'K'
else:
return county_name
In [27]:
df_merged['Violation County'] = df_merged['Violation County'].apply(fix_counties)
'All Other Areas' and 'Manhattan 96th st and below' were not integers:
In [28]:
def int_dollar(str_dollar):
try:
if pd.isnull(str_dollar):
return None
else:
return int(str_dollar)
except:
return None
In [29]:
df_merged['All Other Areas Int'] = df_merged['All Other Areas'].apply(int_dollar)
df_merged['Manhattan\xa096th st and below Int'] = df_merged['Manhattan\xa096th st and below'].apply(int_dollar)
In [30]:
df_merged.columns
Out[30]:
Index(['Summons Number', 'Plate ID', 'Registration State', 'Plate Type',
'Issue Date', 'Violation Code', 'Vehicle Body Type', 'Vehicle Make',
'Issuing Agency', 'Street Code1', 'Street Code2', 'Street Code3',
'Vehicle Expiration Date', 'Violation Location', 'Violation Precinct',
'Issuer Precinct', 'Issuer Code', 'Issuer Command', 'Issuer Squad',
'Violation Time', 'Time First Observed', 'Violation County',
'Violation In Front Of Or Opposite', 'House Number', 'Street Name',
'Intersecting Street', 'Date First Observed', 'Law Section',
'Sub Division', 'Violation Legal Code', 'Days Parking In Effect ',
'From Hours In Effect', 'To Hours In Effect', 'Vehicle Color',
'Unregistered Vehicle?', 'Vehicle Year', 'Meter Number',
'Feet From Curb', 'Violation Post Code', 'Violation Description',
'No Standing or Stopping Violation', 'Hydrant Violation',
'Double Parking Violation', 'Date First Observed Formatted',
'Violation Time Formatted', 'Vehicle Color Formatted', 'CODE',
'DEFINITION', 'Manhattan 96th st and below', 'All Other Areas',
'All Other Areas Int', 'Manhattan 96th st and below Int'],
dtype='object')
In [31]:
precincts = df_merged['Violation Precinct'].unique()
One precinct straddles 96th St, but for simplicity, I'm only going to county precincts entirely below 96th.
In [32]:
precincts_below_96 = ["22", "20", "19", "18", "17", "13", "10", "9", "7", "6", "5", "1"]
# row_numbers = range(len(df_merged['Violation Precinct']))
# Make below_96_list = [
# {'Violation Precinct': '22', 'Below 96th St?': True},
# {'Violation Precinct': '20', 'Below 96th St?': True},
# ...
# ]
below_96_list = []
below_96_dict = {}
for precinct in precincts:
below_96_dict['Violation Precinct'] = precinct
if precinct in precincts_below_96:
below_96_dict['Below 96th St?'] = True
else:
below_96_dict['Below 96th St?'] = False
below_96_list.append(below_96_dict)
below_96_dict = {}
In [33]:
# Make below_96_list a DataFrame and then merge it with df_merged
In [34]:
df_below_96 = pd.DataFrame(below_96_list)
In [35]:
df_merged = df_below_96.merge(df_merged, how = 'left', on = 'Violation Precinct')
In [36]:
# make it so
# if Below 96th St? == True, Fee for This Precinct = Manhattan 96th st and below Int
# else, Fee for This Precinct = 'All Other Areas Int'
In [37]:
row_numbers = range(len(df_merged['Below 96th St?']))
fees_list = []
fees_dict = {}
for row in row_numbers:
fees_dict['Summons Number'] = df_merged['Summons Number'][row]
if df_merged['Below 96th St?'][row] == True:
fees_dict['Fee for This Precinct'] = df_merged['Manhattan\xa096th st and below Int'][row]
else:
fees_dict['Fee for This Precinct'] = df_merged['All Other Areas Int'][row]
fees_list.append(fees_dict)
fees_dict = {}
df_fees = pd.DataFrame(fees_list)
In [38]:
df_fees['Fee for This Precinct'].unique()
Out[38]:
array([ 115., nan, 45., 60., 65., 35., 165., 95., 180.,
200., 265., 50., 100.])
That's because some fees in the columns 'Manhattan 96th st and below' and 'All Other Areas' are nan
In [39]:
df_merged['Manhattan\xa096th st and below'].unique()
Out[39]:
array(['115 ', nan, '65 ', '165 ', 'vary', '95 ', '115\xa0', '180 ', '60 ',
'100', '265', '50\xa0\xa0', '50'], dtype=object)
That's because there are violation codes that I now see were not in the DOF_Parking_Violation_Codes.csv we got: ['41', '9', '8', '6', '95', '15', '88', '54', '76', '4', '30', '1', '87', '5', '7', '90', '3', '36', '0', '2', '29']
The problems with:
The ones dealing with intercity buses, I'm not going to add, since this is more about individuals.
The other ones in the document, I can't find online.
I can fix the ones that started with '0' and code 36.
In [40]:
df_merged[df_merged['Manhattan\xa096th st and below'].isnull()]['Violation Code'].unique()
Out[40]:
array(['41', '90', '95', '54', '29', '15', '3', '88', '76', '87', '30',
'1', '0', '2'], dtype=object)
In [41]:
df_merged = df_fees.merge(df_merged)
In [42]:
df_merged.head()
Out[42]:
Fee for This Precinct
Summons Number
Below 96th St?
Violation Precinct
Plate ID
Registration State
Plate Type
Issue Date
Violation Code
Vehicle Body Type
...
Double Parking Violation
Date First Observed Formatted
Violation Time Formatted
Vehicle Color Formatted
CODE
DEFINITION
Manhattan 96th st and below
All Other Areas
All Other Areas Int
Manhattan 96th st and below Int
0
115.0
1283294138
False
33
GBB9093
NY
PAS
08/04/2013
46
SUBN
...
NaN
None
07:52
GRAY
46
Standing or parking on the roadway side of a v...
115
115
115.0
115.0
1
115.0
1283294151
False
33
62416MB
NY
COM
08/04/2013
46
VAN
...
NaN
None
12:40
WHITE
46
Standing or parking on the roadway side of a v...
115
115
115.0
115.0
2
115.0
1283294163
False
33
78755JZ
NY
COM
08/05/2013
46
P-U
...
NaN
None
12:43
NaN
46
Standing or parking on the roadway side of a v...
115
115
115.0
115.0
3
115.0
1283294175
False
33
63009MA
NY
COM
08/05/2013
46
VAN
...
NaN
None
14:32
WHITE
46
Standing or parking on the roadway side of a v...
115
115
115.0
115.0
4
NaN
1283294187
False
33
91648MC
NY
COM
08/08/2013
41
TRLR
...
NaN
None
12:39
BROWN
NaN
NaN
NaN
NaN
NaN
NaN
5 rows × 54 columns
In [43]:
total_fees = 0
for fee in df_merged['Fee for This Precinct']:
try:
total_fees += int(fee)
except:
pass
total_fees
Out[43]:
369962385
In [44]:
# total_fees = 0
# for fee in df_merged[df_merged['Below 96th St?'] == False]['Fee for This Precinct']:
# try:
# total_fees += int(fee)
# except:
# pass
# total_fees
In [45]:
# df_non_Manhattan = df_merged[df_merged['Violation County'] != 'NY']
# non_manhattan_sum = df_non_Manhattan['All Other Areas Int'].sum()
In [46]:
# total_fees = 0
# for fee in df_merged[df_merged['Below 96th St?'] == True]['Fee for This Precinct']:
# try:
# total_fees += int(fee)
# except:
# pass
# total_fees
In [47]:
# Midtown North is 18
# Midtwon South is 22
# part of 24 is also below 96, but I'm not counting it
# precincts_below_96 = ["22", "20", "19", "18", "17", "13", "10", "9", "7", "6", "5", "1"]
In [48]:
# # go through rows in precincts. If row is in precinct list, save row because we want to get the sum of what was charged for those rows.
# row_numbers = range(len(df_merged['Violation Precinct']))
# row_numbers_for_violations_occuring_below_96 = []
# for row_number in row_numbers:
# precinct = df_merged['Violation Precinct'][row_number]
# if precinct in precincts_below_96:
# row_numbers_for_violations_occuring_below_96.append(row_number)
In [49]:
# # fines_occuring_below_96 = [df_merged['Manhattan\xa096th st and below Int'][row_number] for row_number in row_numbers_for_rows_occuring_below_96]
# def fines_occuring_below_96(row_number):
# try:
# return int(df_merged['Manhattan\xa096th st and below Int'][row_number])
# except:
# return None
# below_96_fee_sum = 0
# for row_number in row_numbers_for_violations_occuring_below_96:
# fine = fines_occuring_below_96(row_number)
# if pd.isnull(fine):
# pass
# else:
# below_96_fee_sum += fine
# below_96_fee_sum
In [50]:
# # If County is NY but the precincts are not the ones listed above
# # we're getting precincts that aren't listed above
# row_numbers_for_violations_occuring_above_96 = []
# for row_number in row_numbers:
# precinct = df_merged['Violation Precinct'][row_number]
# if not precinct in precincts_below_96:
# row_numbers_for_violations_occuring_above_96.append(row_number)
# # Only counting the ones in NY
# df_Manhattan = df_merged[df_merged['Violation County'] == 'NY']
# def fines_occuring_above_96(row_number):
# try:
# return int(df_Manhattan['All Other Areas Int'][row_number])
# except:
# return None
In [51]:
# above_96_fee_sum = 0
# for row_number in row_numbers_for_violations_occuring_above_96:
# fine = fines_occuring_above_96(row_number)
# if pd.isnull(fine):
# pass
# else:
# above_96_fee_sum += fine
# above_96_fee_sum
In [52]:
# total_sum = non_manhattan_sum + below_96_fee_sum + above_96_fee_sum
# print('At least $' + str(total_sum))
In [53]:
df_merged['DEFINITION'].value_counts()
Out[53]:
Street Cleaning: No parking where parking is not allowed by sign, street marking or traffic control device. 706228
Failing to show a receipt or tag in the windshield. Drivers get a 5-minute grace period past the expired time on Muni-Meter receipts." 674091
General No Standing: Standing or parking where standing is not allowed by sign, street marking or; traffic control device. 468987
Parking in excess of the allowed time. Drivers get a 5-minute grace period past the expired time on Muni-Meter receipts." 407106
General No Parking: No parking where parking is not allowed by sign, street marking or traffic control device. 299391
Standing or parking a vehicle without showing a current inspection sticker. 281492
Vehicles photographed going through a red light at an intersection 269793
Standing or parking on the roadway side of a vehicle stopped, standing or parked at the curb; in other words also known as "double parking". However, a person may stand a Commercial Vehicle alongside a vehicle parked at the curb at such locations and during such hours that stopping, standing and parking is allowed when quickly making pickups, deliveries or service calls. This is allowed if there is no parking space or marked loading zone on either side of the street within 100 feet. "Double parking" any type of vehicle is not allowed in Midtown Manhattan (the area from 14th Street to 60th Street, between First Avenue and Eighth Avenue inclusive). Midtown double parking is not allowed between 7:00am – 7:00pm daily except Sundays. (See Code 47.) 257686
Stopping, standing or parking closer than 15 feet of a fire hydrant. Between sunrise and sunset, a passenger vehicle may stand alongside a fire hydrant as long as a driver remains behind the wheel and is ready to move the vehicle if required to do so. 251035
Bus Stop: Standing or parking where standing is not allowed by sign, street marking or; traffic control device. 157422
Failing to show a muni-meter receipt, commercial meter zone. 135480
Truck Loading/Unloading: Standing or parking where standing is not allowed by sign, street marking or; traffic control device. 120607
Standing or parking a vehicle without showing a current registration sticker. 115674
Standing of a non-commercial vehicle in a commercial metered zone. 98088
Failure to make a right turn from a bus lane. 75435
Stopping, standing or parking a vehicle in Midtown Manhattan (the area from 14th Street to 60th Street, between First Avenue and Eighth Avenue) other than parallel or close to the curb. 64260
Authorized Vehicles Only: Standing or parking where standing is not allowed by sign, street marking or; traffic control device. 58144
Parking in a Muni Metered space in a commercial metered zone in which that Muni Meter is working and indicates the time has ended. 44940
Parking a Commercial Vehicle on a residential street between 9PM and 5AM unless doing business within 3 blocks. Parking is allowed during this time if the vehicle is owned or operated by a gas or oil supplier or maintenance company or by any public utility. 44904
Standing or parking a vehicle without properly showing its current plates on the outside of the vehicle attached tightly not more than 48, or less than 12, inches from the ground, clean, not covered by glass or plastic, with nothing preventing it from being read clearly. 44408
Stopping, standing or parking in a crosswalk. Note: Crosswalks are not always identified by painted street markings. 42759
Stopping, standing or parking on a sidewalk. 32917
Stopping, standing or parking within a marked bicycle lane. 28537
Parking a Commercial Vehicle on any city street with its platform lift in the lowered position while no one is with the vehicle. 26228
Standing or parking in front of a public or private driveway. The owner or renter of a lot accessed by a private driveway may park a passenger vehicle registered to him / her at that address in front of the driveway provided the lot does not contain more than 2 dwelling units and that parking does not violate any other rule or restriction. 23062
Parking in front of a pedestrian ramp 18946
Stopping, standing or parking in a traffic lane; or if a vehicle extends more than 8 feet from the nearest curb, blocking traffic. 18575
Standing or parking a Commercial Vehicle unless all seats, except the front seats, and rear seat equipment removed. The name and address of the owner must be on the registration certificate plainly marked on both sides of the vehicle in letters and numerals not less than 3 inches in height. (Vehicles with Commercial Plates are considered to be Commercial Vehicles and must be altered accordingly. 16333
Taxi Stand: Standing or parking where standing is not allowed by sign, street marking or; traffic control device. 15746
Parking a Commercial Vehicle more than 3 hours, where parking is allowed. 15698
...
Vehicle Release Agreement code associated with NYPD's Violation Tow Program. 1320
Taxi Stand: No parking where parking is not allowed by sign, street marking or traffic control device. 1202
Stopping, standing or parking alongside or opposite any street construction or obstruction and thereby blocking traffic. 997
Stopping, standing or parking within an intersection. 599
Expired Meter -- parking in a metered space where the meter works and the time has ended. Drivers get a 5-minute grace period past the expired time on Alternate Side Parking signs and any other parking spaces with specific times listed (i.e.. 8:30am - 9:30am). During the 5-minute grace period, parking tickets cannot be issued. 523
For a bus without passengers, waiting at a curb or other street location i.e., a layover; with passengers, waiting at a curb or other street location for more than five minutes, except in locations allowed by sign or by the Commissioner in writing. 468
Standing or parking a vehicle in any park between one-half hour after sunset and one-half hour before sunrise, except at places allowed for the parking of vehicles. 382
Vehicles parked illegally south of Houston Street in Manhattan in metered spaces reserved for buses from 7am - 7pm daily. Vehicles with bus plate types parked longer than the 3 hour maximum and/or not displaying a DOT-issued bus permit. 354
Parking in a commercial metered zone in which the meter is working and indicates that the time has ended. (Note: the difference is that 42 is Muni Meter and 43 is Meter) 288
Standing or parking at an angle to the curb, except where allowed by rule or sign. Where angle parking is not authorized by a sign, a Commercial Vehicle may stand or park at an angle only for loading or unloading and if it leaves enough space for traffic flow. 272
Stopping, standing or parking within a highway tunnel or on a raised or controlled access roadway. 199
Standing at a commuter van stop, other than temporarily for the purpose of quickly picking up or dropping off passengers. 192
Parking a tractor-trailer on a residential street between 9PM and 5AM. 180
Parking at a broken or missing meter for longer than the maximum time permitted. 141
No standing except diplomat 126
Overtime standing consul / diplomat vehicles 30-minute limit D decals only. 115
Parking in a vacant lot. A vehicle may be parked on a vacant lot having a municipally authorized driveway upon written permission of the owner. 112
Parking a vehicle within the area designated as The Blue Zone, Monday through Friday 7:00am -7:00pm. The Blue Zone is bounded by the northern property line of Frankfort Street, the northern property line of Dover Street, the eastern property line of South Street, the western property line of State Street, the center line of Broadway and the center line of Park Row. 108
Stopping, standing or parking alongside a barrier or divided highway unless permitted by sign. 98
Standing at a for-hire vehicle stop, other than temporarily for the purpose of quickly picking up or dropping off passengers. 94
Parking in order to wash, grease, or repair a vehicle by a person who regularly repairs vehicles. 90
Standing or parking a vehicle to make pickups, deliveries or service calls for more than 3 hours, unless allowed by posted signs, between 7AM and 7PM, except Sundays, in Manhattan from 14th to 60th Streets and First to Eighth Avenues. 86
Standing or parking within 50 feet of the nearest rail of a railroad crossing. 79
Stopping, standing or parking on paved roadway to change a flat tire, unless permitted by posted sign. 44
Parking a vehicle on a marginal street or waterfront i.e. any street, road, place, area or way that connects or runs along waterfront property. Parking on a marginal street or waterfront is permitted if authorized by posted sign. 41
Parking in a commercial metered zone for longer than the maximum time allowed. 29
Snow Emergency: Standing or parking where standing is not allowed by sign, street marking or; traffic control device. 27
Hotel Loading/Unloading: No parking where parking is not allowed by sign, street marking or traffic control device. 15
"Feeding Meter" -- parking in a metered space for a consecutive period of time longer than allowed, whether or not an additional coin or coins are deposited or another method of payment is used. 15
Overtime standing (diplomat) 11
Name: DEFINITION, dtype: int64
In [54]:
df_merged[['DEFINITION', 'Fee for This Precinct']].groupby('DEFINITION').sum().sort_values('Fee for This Precinct', ascending = False)
Out[54]:
Fee for This Precinct
DEFINITION
General No Standing: Standing or parking where standing is not allowed by sign, street marking or; traffic control device.
53933505.0
Street Cleaning: No parking where parking is not allowed by sign, street marking or traffic control device.
33467600.0
Standing or parking on the roadway side of a vehicle stopped, standing or parked at the curb; in other words also known as "double parking". However, a person may stand a Commercial Vehicle alongside a vehicle parked at the curb at such locations and during such hours that stopping, standing and parking is allowed when quickly making pickups, deliveries or service calls. This is allowed if there is no parking space or marked loading zone on either side of the street within 100 feet. "Double parking" any type of vehicle is not allowed in Midtown Manhattan (the area from 14th Street to 60th Street, between First Avenue and Eighth Avenue inclusive). Midtown double parking is not allowed between 7:00am – 7:00pm daily except Sundays. (See Code 47.)
29633890.0
Stopping, standing or parking closer than 15 feet of a fire hydrant. Between sunrise and sunset, a passenger vehicle may stand alongside a fire hydrant as long as a driver remains behind the wheel and is ready to move the vehicle if required to do so.
28869025.0
Failing to show a receipt or tag in the windshield. Drivers get a 5-minute grace period past the expired time on Muni-Meter receipts."
28757175.0
General No Parking: No parking where parking is not allowed by sign, street marking or traffic control device.
18415790.0
Standing or parking a vehicle without showing a current inspection sticker.
18296980.0
Bus Stop: Standing or parking where standing is not allowed by sign, street marking or; traffic control device.
18103530.0
Parking in excess of the allowed time. Drivers get a 5-minute grace period past the expired time on Muni-Meter receipts."
17826180.0
Vehicles photographed going through a red light at an intersection
13489650.0
Truck Loading/Unloading: Standing or parking where standing is not allowed by sign, street marking or; traffic control device.
11457665.0
Standing of a non-commercial vehicle in a commercial metered zone.
11280120.0
Failing to show a muni-meter receipt, commercial meter zone.
8806200.0
Failure to make a right turn from a bus lane.
8675025.0
Standing or parking a vehicle without showing a current registration sticker.
7518810.0
Stopping, standing or parking a vehicle in Midtown Manhattan (the area from 14th Street to 60th Street, between First Avenue and Eighth Avenue) other than parallel or close to the curb.
7389900.0
Authorized Vehicles Only: Standing or parking where standing is not allowed by sign, street marking or; traffic control device.
5523680.0
Stopping, standing or parking in a crosswalk. Note: Crosswalks are not always identified by painted street markings.
4917285.0
Stopping, standing or parking on a sidewalk.
3785455.0
Stopping, standing or parking within a marked bicycle lane.
3281755.0
Parking in front of a pedestrian ramp
3126090.0
Parking a Commercial Vehicle on a residential street between 9PM and 5AM unless doing business within 3 blocks. Parking is allowed during this time if the vehicle is owned or operated by a gas or oil supplier or maintenance company or by any public utility.
2918760.0
Standing or parking a vehicle without properly showing its current plates on the outside of the vehicle attached tightly not more than 48, or less than 12, inches from the ground, clean, not covered by glass or plastic, with nothing preventing it from being read clearly.
2886520.0
Parking in a Muni Metered space in a commercial metered zone in which that Muni Meter is working and indicates the time has ended.
2462790.0
Standing or parking in front of a public or private driveway. The owner or renter of a lot accessed by a private driveway may park a passenger vehicle registered to him / her at that address in front of the driveway provided the lot does not contain more than 2 dwelling units and that parking does not violate any other rule or restriction.
2190890.0
Stopping, standing or parking in a traffic lane; or if a vehicle extends more than 8 feet from the nearest curb, blocking traffic.
2136125.0
Standing or parking a Commercial Vehicle unless all seats, except the front seats, and rear seat equipment removed. The name and address of the owner must be on the registration certificate plainly marked on both sides of the vehicle in letters and numerals not less than 3 inches in height. (Vehicles with Commercial Plates are considered to be Commercial Vehicles and must be altered accordingly.
1878295.0
Taxi Stand: Standing or parking where standing is not allowed by sign, street marking or; traffic control device.
1810790.0
Stopping, standing or parking where a sign, street marking, or traffic control device does not allow stopping.
1701310.0
Standing or parking in a safety zone, between a safety zone and the nearest curb, or within 30 feet of points on the curb immediately opposite the ends of a safety zone.
1551465.0
...
...
Taxi Stand: No parking where parking is not allowed by sign, street marking or traffic control device.
76055.0
Stopping, standing or parking within an intersection.
68885.0
Parking in order to sell a vehicle by a person who regularly sells vehicles.
64330.0
For a bus without passengers, waiting at a curb or other street location i.e., a layover; with passengers, waiting at a curb or other street location for more than five minutes, except in locations allowed by sign or by the Commissioner in writing.
53820.0
Parking a tractor-trailer on a residential street between 9PM and 5AM.
47700.0
Vehicles parked illegally south of Houston Street in Manhattan in metered spaces reserved for buses from 7am - 7pm daily. Vehicles with bus plate types parked longer than the 3 hour maximum and/or not displaying a DOT-issued bus permit.
36340.0
Standing or parking a vehicle in any park between one-half hour after sunset and one-half hour before sunrise, except at places allowed for the parking of vehicles.
36290.0
Standing or parking at an angle to the curb, except where allowed by rule or sign. Where angle parking is not authorized by a sign, a Commercial Vehicle may stand or park at an angle only for loading or unloading and if it leaves enough space for traffic flow.
31280.0
Expired Meter -- parking in a metered space where the meter works and the time has ended. Drivers get a 5-minute grace period past the expired time on Alternate Side Parking signs and any other parking spaces with specific times listed (i.e.. 8:30am - 9:30am). During the 5-minute grace period, parking tickets cannot be issued.
23465.0
Stopping, standing or parking within a highway tunnel or on a raised or controlled access roadway.
22885.0
Standing at a commuter van stop, other than temporarily for the purpose of quickly picking up or dropping off passengers.
22080.0
Parking in a commercial metered zone in which the meter is working and indicates that the time has ended. (Note: the difference is that 42 is Muni Meter and 43 is Meter)
17070.0
No standing except diplomat
11970.0
Stopping, standing or parking alongside a barrier or divided highway unless permitted by sign.
11270.0
Overtime standing consul / diplomat vehicles 30-minute limit D decals only.
10925.0
Standing at a for-hire vehicle stop, other than temporarily for the purpose of quickly picking up or dropping off passengers.
10810.0
Standing or parking a vehicle to make pickups, deliveries or service calls for more than 3 hours, unless allowed by posted signs, between 7AM and 7PM, except Sundays, in Manhattan from 14th to 60th Streets and First to Eighth Avenues.
9890.0
Standing or parking within 50 feet of the nearest rail of a railroad crossing.
7505.0
Parking a vehicle within the area designated as The Blue Zone, Monday through Friday 7:00am -7:00pm. The Blue Zone is bounded by the northern property line of Frankfort Street, the northern property line of Dover Street, the eastern property line of South Street, the western property line of State Street, the center line of Broadway and the center line of Park Row.
7020.0
Parking at a broken or missing meter for longer than the maximum time permitted.
5985.0
Parking in a vacant lot. A vehicle may be parked on a vacant lot having a municipally authorized driveway upon written permission of the owner.
5640.0
Parking in order to wash, grease, or repair a vehicle by a person who regularly repairs vehicles.
4090.0
Stopping, standing or parking on paved roadway to change a flat tire, unless permitted by posted sign.
2860.0
Snow Emergency: Standing or parking where standing is not allowed by sign, street marking or; traffic control device.
2565.0
Parking a vehicle on a marginal street or waterfront i.e. any street, road, place, area or way that connects or runs along waterfront property. Parking on a marginal street or waterfront is permitted if authorized by posted sign.
1985.0
Parking in a commercial metered zone for longer than the maximum time allowed.
1375.0
Overtime standing (diplomat)
1045.0
Hotel Loading/Unloading: No parking where parking is not allowed by sign, street marking or traffic control device.
900.0
"Feeding Meter" -- parking in a metered space for a consecutive period of time longer than allowed, whether or not an additional coin or coins are deposited or another method of payment is used.
705.0
All other parking, standing or stopping violations.
NaN
86 rows × 1 columns
I want: [ {'DEFINITION': 'Street Cleaning...', 'freq': 140329, 'All Other Areas Int': 45}, {'DEFINITION': 'Failing to show a receipt', 'freq': 125716, 'All Other Areas Int': 35}, ... ]
Then I'll turn that to a DataFrame.
Then I'll multiply 'freq' and 'All Other Areas Int' to make a 'How Lucrative' column
In [55]:
# def_list = df_merged['DEFINITION'].unique()
In [56]:
# def first_fee_result(partial_df):
# number = 0
# for row in partial_df:
# number += 1
# if number == 1:
# return row
In [57]:
# lucrative_list = []
# lucrative_dict = {}
# for definition in def_list:
# all_rows_in_df_with_def = df_merged[df_merged['DEFINITION'] == definition]
# how_many_rows = all_rows_in_df_with_def['DEFINITION'].count()
# fee = first_fee_result(all_rows_in_df_with_def['All Other Areas Int'])
# if how_many_rows > 0:
# lucrative_dict['DEFINITION'] = definition
# lucrative_dict['freq'] = how_many_rows
# lucrative_dict['All Other Areas Int'] = fee
# lucrative_dict['How Lucrative'] = how_many_rows * fee
# lucrative_list.append(lucrative_dict)
# lucrative_dict = {}
In [58]:
# df_lucrative = pd.DataFrame(lucrative_list)
In [59]:
# df_lucrative.sort_values('How Lucrative', ascending=False).head()
In [60]:
df_non_NY = df_merged[df_merged['Registration State'] != 'NY']
In [61]:
df_non_NY['Fee for This Precinct'].sum()
Out[61]:
90889560.0
Make a list of all of the non-NY registration states and grab the top 10.
for each of the top 10, find the frequency
[
{'Registration State': '99', 'total fees': '999' },
{'Registration State': 'AB', 'total fees': '999' } ...
]
then put them in a dataframe and use matplotlib
In [62]:
df_non_NY['Registration State'].value_counts()
Out[62]:
NJ 488864
PA 127073
CT 77794
FL 63349
MA 44862
VA 34990
MD 29031
NC 26826
99 23691
IN 21765
IL 17858
GA 17602
AZ 13533
TX 13484
OH 12492
CA 11636
OK 11282
SC 11252
ME 11146
TN 10538
MI 9219
DE 8418
RI 7879
MN 6649
NH 6075
IA 4249
VT 4168
WA 3470
AL 3265
WI 3185
...
MS 1903
KY 1778
MO 1681
NM 1656
AR 1481
LA 1429
NV 1227
WV 980
NE 802
GV 752
KS 644
AK 547
UT 539
SD 383
MT 311
ND 216
HI 208
BC 197
WY 174
NS 164
AB 151
PR 123
NB 77
MX 64
PE 39
SK 17
MB 13
YT 8
NT 6
FO 4
Name: Registration State, dtype: int64
In [63]:
top_out_of_state = ['NJ', 'PA', 'CT', 'FL', 'MA', 'VA', 'MD', '99', 'NC', 'IL']
In [64]:
out_of_state_list = []
out_of_state_dict = {}
for state in top_out_of_state:
df_this_state = df_merged[df_merged['Registration State'] == state]
fees = df_this_state['Fee for This Precinct'].sum()
out_of_state_dict['Registration State'] = state
out_of_state_dict['total fees'] = fees
out_of_state_list.append(out_of_state_dict)
out_of_state_dict = {}
In [65]:
df_out_of_state = pd.DataFrame(out_of_state_list)
In [66]:
%matplotlib inline
In [67]:
ax = df_out_of_state.plot(kind = 'bar', x = 'Registration State', y = 'total fees', legend = None)
ax.set_title('Violation Fees Collected by NY from Non-NY Cars from 1973 to 2060')
Out[67]:
<matplotlib.text.Text at 0x151658160>
In [70]:
def time_to_words(first_two_digits_are_your_hour):
if not first_two_digits_are_your_hour:
return None
elif first_two_digits_are_your_hour.startswith('ERROR'):
return None
else:
try:
hour = int(first_two_digits_are_your_hour[:2])
if hour < 6:
return 'early_morning'
elif hour < 12:
return 'morning'
elif hour < 18:
return 'afternoon'
elif hour < 24:
return 'evening'
else:
return 'ERROR'
except:
return 'ERROR'
In [72]:
df_merged['Violation Time in Words'] = df_merged['Violation Time Formatted'].apply(time_to_words)
In [73]:
df_merged['Violation Time in Words'].value_counts()
Out[73]:
morning 2184903
afternoon 2144727
evening 447130
early_morning 221829
ERROR 134
Name: Violation Time in Words, dtype: int64
In [74]:
total_fees/len(df)
Out[74]:
73.99249179849836
In [75]:
df_merged['Issue Date'].value_counts().head()
Out[75]:
11/29/2013 46010
10/03/2013 41359
10/08/2013 41103
10/01/2013 40664
11/14/2013 39265
Name: Issue Date, dtype: int64
Let's try this:
We can turn the issue dates into a list
We can also turn the value_counts into a list
See if they are both the same length, and then match them up into a dictionary:
tix_per_diem = [
{ 'Issue Date': 07/30/2013 , 'tickets this day': 36500},
{ 'Issue Date': 08/06/2013 , 'tickets this day': 36080}, ...
]
In [76]:
issue_dates_list = [unique_date for unique_date in set(df_merged['Issue Date'])]
len(issue_dates_list)
Out[76]:
1957
In [77]:
import datetime
def to_datetime_version(str_date):
datetime_version = datetime.datetime.strptime(str_date, "%m/%d/%Y")
return datetime_version
def to_string_version(datetime_date):
string_version = datetime.datetime.strftime(datetime_date, "%m/%d/%Y")
return string_version
In [78]:
def list_to_sorted_datetime(str_list):
datetime_version = [to_datetime_version(item) for item in str_list]
sorted_datetime_version = sorted(datetime_version)
sorted_string_version = [to_string_version(item) for item in sorted_datetime_version]
return sorted_string_version
In [79]:
sorted_issue_dates_list = list_to_sorted_datetime(issue_dates_list)
In [80]:
value_counts_list = [value_count for value_count in df_merged['Issue Date'].value_counts()]
len(value_counts_list)
Out[80]:
1957
In [81]:
tix_per_diem = []
tix_dict = {}
for unique_date in sorted_issue_dates_list:
tix_dict['Issue Date'] = unique_date
tix_dict['tickets this day'] = len(df_merged[df_merged['Issue Date'] == unique_date])
tix_per_diem.append(tix_dict)
tix_dict = {}
In [82]:
df_tix_per_diem = pd.DataFrame(tix_per_diem)
In [83]:
df_tix_per_diem.plot(kind = 'line', x = 'Issue Date', y = 'tickets this day', legend = None)
Out[83]:
<matplotlib.axes._subplots.AxesSubplot at 0x15168f208>
Let's try this:
We already have the issue dates into a list
We can also group the information by date and find the sum of that revenue. Let's do that and see where we can take it from there.
In [84]:
df_revenue_per_day = df_merged[['Issue Date', 'Fee for This Precinct']].groupby('Issue Date').sum()
In [85]:
df_revenue_per_day
Out[85]:
Fee for This Precinct
Issue Date
01/01/1981
115.0
01/01/2000
295.0
01/01/2004
295.0
01/01/2009
95.0
01/01/2011
65.0
01/01/2012
65.0
01/01/2013
5290.0
01/01/2014
391355.0
01/01/2015
295.0
01/01/2017
65.0
01/01/2018
115.0
01/01/2019
65.0
01/01/2041
65.0
01/02/2004
160.0
01/02/2013
7450.0
01/02/2014
1997315.0
01/02/2015
225.0
01/02/2018
115.0
01/02/2019
115.0
01/03/2012
115.0
01/03/2013
3535.0
01/03/2014
107555.0
01/03/2017
60.0
01/03/2018
115.0
01/04/2000
460.0
01/04/2007
60.0
01/04/2012
115.0
01/04/2013
9445.0
01/04/2014
265555.0
01/04/2015
455.0
...
...
12/28/2014
345.0
12/28/2015
210.0
12/28/2018
115.0
12/28/2032
60.0
12/29/2001
115.0
12/29/2011
115.0
12/29/2013
600915.0
12/29/2014
475.0
12/29/2029
60.0
12/29/2030
165.0
12/29/2031
95.0
12/29/2063
115.0
12/30/2000
300.0
12/30/2001
345.0
12/30/2012
380.0
12/30/2013
1970310.0
12/30/2014
1000.0
12/30/2015
565.0
12/30/2019
115.0
12/30/2030
230.0
12/30/2031
115.0
12/31/2000
210.0
12/31/2001
230.0
12/31/2003
115.0
12/31/2010
60.0
12/31/2012
215.0
12/31/2013
1841905.0
12/31/2014
765.0
12/31/2015
175.0
12/31/2031
595.0
1957 rows × 1 columns
In [86]:
date_and_revenue_dict = df_revenue_per_day.to_dict()['Fee for This Precinct']
In [87]:
rev_today = []
rev_dict = {}
for date in sorted_issue_dates_list:
rev_dict['Issue Date'] = date
if date_and_revenue_dict[date]:
rev_dict['Revenue Today'] = date_and_revenue_dict[date]
else:
rev_dict['Revenue Today'] = 0
rev_today.append(rev_dict)
rev_dict = {}
print(rev_today)
[{'Revenue Today': 60.0, 'Issue Date': '12/18/1970'}, {'Revenue Today': 135.0, 'Issue Date': '09/18/1971'}, {'Revenue Today': 115.0, 'Issue Date': '10/10/1971'}, {'Revenue Today': 115.0, 'Issue Date': '07/22/1973'}, {'Revenue Today': 45.0, 'Issue Date': '08/12/1973'}, {'Revenue Today': 45.0, 'Issue Date': '09/22/1973'}, {'Revenue Today': 90.0, 'Issue Date': '09/25/1973'}, {'Revenue Today': 115.0, 'Issue Date': '10/15/1973'}, {'Revenue Today': 115.0, 'Issue Date': '10/30/1973'}, {'Revenue Today': 115.0, 'Issue Date': '11/12/1973'}, {'Revenue Today': 45.0, 'Issue Date': '11/13/1973'}, {'Revenue Today': 115.0, 'Issue Date': '01/15/1974'}, {'Revenue Today': 65.0, 'Issue Date': '12/27/1976'}, {'Revenue Today': 115.0, 'Issue Date': '01/01/1981'}, {'Revenue Today': 155.0, 'Issue Date': '02/11/1981'}, {'Revenue Today': 130.0, 'Issue Date': '01/11/1987'}, {'Revenue Today': 65.0, 'Issue Date': '02/09/1987'}, {'Revenue Today': 115.0, 'Issue Date': '12/09/1990'}, {'Revenue Today': 115.0, 'Issue Date': '01/12/1991'}, {'Revenue Today': 295.0, 'Issue Date': '01/01/2000'}, {'Revenue Today': 460.0, 'Issue Date': '01/04/2000'}, {'Revenue Today': 65.0, 'Issue Date': '01/05/2000'}, {'Revenue Today': 275.0, 'Issue Date': '01/06/2000'}, {'Revenue Today': 325.0, 'Issue Date': '01/07/2000'}, {'Revenue Today': 325.0, 'Issue Date': '01/08/2000'}, {'Revenue Today': 140.0, 'Issue Date': '01/09/2000'}, {'Revenue Today': 245.0, 'Issue Date': '01/13/2000'}, {'Revenue Today': 115.0, 'Issue Date': '01/14/2000'}, {'Revenue Today': 230.0, 'Issue Date': '01/15/2000'}, {'Revenue Today': 115.0, 'Issue Date': '01/17/2000'}, {'Revenue Today': 60.0, 'Issue Date': '01/20/2000'}, {'Revenue Today': 45.0, 'Issue Date': '01/28/2000'}, {'Revenue Today': 65.0, 'Issue Date': '01/29/2000'}, {'Revenue Today': 65.0, 'Issue Date': '01/30/2000'}, {'Revenue Today': 115.0, 'Issue Date': '02/04/2000'}, {'Revenue Today': 115.0, 'Issue Date': '02/06/2000'}, {'Revenue Today': 280.0, 'Issue Date': '02/07/2000'}, {'Revenue Today': 115.0, 'Issue Date': '02/08/2000'}, {'Revenue Today': 115.0, 'Issue Date': '02/09/2000'}, {'Revenue Today': 390.0, 'Issue Date': '02/11/2000'}, {'Revenue Today': 115.0, 'Issue Date': '02/12/2000'}, {'Revenue Today': 225.0, 'Issue Date': '02/14/2000'}, {'Revenue Today': 65.0, 'Issue Date': '03/14/2000'}, {'Revenue Today': 115.0, 'Issue Date': '05/20/2000'}, {'Revenue Today': 65.0, 'Issue Date': '06/29/2000'}, {'Revenue Today': 65.0, 'Issue Date': '07/06/2000'}, {'Revenue Today': 115.0, 'Issue Date': '07/13/2000'}, {'Revenue Today': 180.0, 'Issue Date': '07/16/2000'}, {'Revenue Today': 65.0, 'Issue Date': '07/20/2000'}, {'Revenue Today': 115.0, 'Issue Date': '07/22/2000'}, {'Revenue Today': 165.0, 'Issue Date': '07/24/2000'}, {'Revenue Today': 115.0, 'Issue Date': '07/25/2000'}, {'Revenue Today': 175.0, 'Issue Date': '07/26/2000'}, {'Revenue Today': 115.0, 'Issue Date': '07/27/2000'}, {'Revenue Today': 245.0, 'Issue Date': '07/28/2000'}, {'Revenue Today': 110.0, 'Issue Date': '07/29/2000'}, {'Revenue Today': 115.0, 'Issue Date': '07/30/2000'}, {'Revenue Today': 180.0, 'Issue Date': '07/31/2000'}, {'Revenue Today': 275.0, 'Issue Date': '08/01/2000'}, {'Revenue Today': 270.0, 'Issue Date': '08/02/2000'}, {'Revenue Today': 60.0, 'Issue Date': '08/03/2000'}, {'Revenue Today': 45.0, 'Issue Date': '08/06/2000'}, {'Revenue Today': 230.0, 'Issue Date': '08/07/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/08/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/09/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/10/2000'}, {'Revenue Today': 180.0, 'Issue Date': '08/11/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/12/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/13/2000'}, {'Revenue Today': 195.0, 'Issue Date': '08/14/2000'}, {'Revenue Today': 45.0, 'Issue Date': '08/16/2000'}, {'Revenue Today': 65.0, 'Issue Date': '08/18/2000'}, {'Revenue Today': 165.0, 'Issue Date': '08/19/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/20/2000'}, {'Revenue Today': 410.0, 'Issue Date': '08/24/2000'}, {'Revenue Today': 180.0, 'Issue Date': '08/26/2000'}, {'Revenue Today': 115.0, 'Issue Date': '08/27/2000'}, {'Revenue Today': 270.0, 'Issue Date': '08/29/2000'}, {'Revenue Today': 180.0, 'Issue Date': '08/31/2000'}, {'Revenue Today': 65.0, 'Issue Date': '09/09/2000'}, {'Revenue Today': 60.0, 'Issue Date': '09/10/2000'}, {'Revenue Today': 90.0, 'Issue Date': '09/13/2000'}, {'Revenue Today': 115.0, 'Issue Date': '09/18/2000'}, {'Revenue Today': 115.0, 'Issue Date': '09/19/2000'}, {'Revenue Today': 180.0, 'Issue Date': '09/22/2000'}, {'Revenue Today': 510.0, 'Issue Date': '09/23/2000'}, {'Revenue Today': 115.0, 'Issue Date': '09/26/2000'}, {'Revenue Today': 65.0, 'Issue Date': '09/27/2000'}, {'Revenue Today': 115.0, 'Issue Date': '09/28/2000'}, {'Revenue Today': 95.0, 'Issue Date': '09/29/2000'}, {'Revenue Today': 355.0, 'Issue Date': '10/01/2000'}, {'Revenue Today': 115.0, 'Issue Date': '10/02/2000'}, {'Revenue Today': 750.0, 'Issue Date': '10/04/2000'}, {'Revenue Today': 130.0, 'Issue Date': '10/06/2000'}, {'Revenue Today': 345.0, 'Issue Date': '10/07/2000'}, {'Revenue Today': 150.0, 'Issue Date': '10/08/2000'}, {'Revenue Today': 230.0, 'Issue Date': '10/09/2000'}, {'Revenue Today': 45.0, 'Issue Date': '10/14/2000'}, {'Revenue Today': 65.0, 'Issue Date': '10/15/2000'}, {'Revenue Today': 295.0, 'Issue Date': '10/16/2000'}, {'Revenue Today': 60.0, 'Issue Date': '10/21/2000'}, {'Revenue Today': 45.0, 'Issue Date': '10/23/2000'}, {'Revenue Today': 115.0, 'Issue Date': '10/24/2000'}, {'Revenue Today': 280.0, 'Issue Date': '10/26/2000'}, {'Revenue Today': 115.0, 'Issue Date': '10/27/2000'}, {'Revenue Today': 165.0, 'Issue Date': '10/30/2000'}, {'Revenue Today': 230.0, 'Issue Date': '10/31/2000'}, {'Revenue Today': 165.0, 'Issue Date': '11/01/2000'}, {'Revenue Today': 165.0, 'Issue Date': '11/02/2000'}, {'Revenue Today': 115.0, 'Issue Date': '11/03/2000'}, {'Revenue Today': 65.0, 'Issue Date': '11/05/2000'}, {'Revenue Today': 345.0, 'Issue Date': '11/06/2000'}, {'Revenue Today': 180.0, 'Issue Date': '11/07/2000'}, {'Revenue Today': 45.0, 'Issue Date': '11/08/2000'}, {'Revenue Today': 275.0, 'Issue Date': '11/13/2000'}, {'Revenue Today': 115.0, 'Issue Date': '11/14/2000'}, {'Revenue Today': 115.0, 'Issue Date': '11/17/2000'}, {'Revenue Today': 45.0, 'Issue Date': '11/18/2000'}, {'Revenue Today': 115.0, 'Issue Date': '11/19/2000'}, {'Revenue Today': 60.0, 'Issue Date': '11/20/2000'}, {'Revenue Today': 115.0, 'Issue Date': '11/22/2000'}, {'Revenue Today': 115.0, 'Issue Date': '11/23/2000'}, {'Revenue Today': 110.0, 'Issue Date': '11/25/2000'}, {'Revenue Today': 130.0, 'Issue Date': '11/26/2000'}, {'Revenue Today': 45.0, 'Issue Date': '11/30/2000'}, {'Revenue Today': 210.0, 'Issue Date': '12/01/2000'}, {'Revenue Today': 115.0, 'Issue Date': '12/03/2000'}, {'Revenue Today': 115.0, 'Issue Date': '12/05/2000'}, {'Revenue Today': 115.0, 'Issue Date': '12/08/2000'}, {'Revenue Today': 115.0, 'Issue Date': '12/11/2000'}, {'Revenue Today': 455.0, 'Issue Date': '12/12/2000'}, {'Revenue Today': 345.0, 'Issue Date': '12/13/2000'}, {'Revenue Today': 180.0, 'Issue Date': '12/18/2000'}, {'Revenue Today': 65.0, 'Issue Date': '12/20/2000'}, {'Revenue Today': 230.0, 'Issue Date': '12/22/2000'}, {'Revenue Today': 400.0, 'Issue Date': '12/23/2000'}, {'Revenue Today': 115.0, 'Issue Date': '12/24/2000'}, {'Revenue Today': 115.0, 'Issue Date': '12/25/2000'}, {'Revenue Today': 290.0, 'Issue Date': '12/26/2000'}, {'Revenue Today': 280.0, 'Issue Date': '12/27/2000'}, {'Revenue Today': 95.0, 'Issue Date': '12/28/2000'}, {'Revenue Today': 300.0, 'Issue Date': '12/30/2000'}, {'Revenue Today': 210.0, 'Issue Date': '12/31/2000'}, {'Revenue Today': 95.0, 'Issue Date': '01/06/2001'}, {'Revenue Today': 115.0, 'Issue Date': '01/07/2001'}, {'Revenue Today': 115.0, 'Issue Date': '01/08/2001'}, {'Revenue Today': 180.0, 'Issue Date': '01/09/2001'}, {'Revenue Today': 230.0, 'Issue Date': '01/11/2001'}, {'Revenue Today': 165.0, 'Issue Date': '01/16/2001'}, {'Revenue Today': 115.0, 'Issue Date': '01/25/2001'}, {'Revenue Today': 115.0, 'Issue Date': '01/26/2001'}, {'Revenue Today': 115.0, 'Issue Date': '01/27/2001'}, {'Revenue Today': 65.0, 'Issue Date': '01/28/2001'}, {'Revenue Today': 95.0, 'Issue Date': '02/07/2001'}, {'Revenue Today': 115.0, 'Issue Date': '02/11/2001'}, {'Revenue Today': 115.0, 'Issue Date': '02/12/2001'}, {'Revenue Today': 115.0, 'Issue Date': '08/01/2001'}, {'Revenue Today': 115.0, 'Issue Date': '08/23/2001'}, {'Revenue Today': 60.0, 'Issue Date': '09/08/2001'}, {'Revenue Today': 115.0, 'Issue Date': '09/10/2001'}, {'Revenue Today': 115.0, 'Issue Date': '09/30/2001'}, {'Revenue Today': 45.0, 'Issue Date': '10/01/2001'}, {'Revenue Today': 65.0, 'Issue Date': '11/11/2001'}, {'Revenue Today': 115.0, 'Issue Date': '12/12/2001'}, {'Revenue Today': 345.0, 'Issue Date': '12/13/2001'}, {'Revenue Today': 115.0, 'Issue Date': '12/15/2001'}, {'Revenue Today': 255.0, 'Issue Date': '12/20/2001'}, {'Revenue Today': 345.0, 'Issue Date': '12/22/2001'}, {'Revenue Today': 390.0, 'Issue Date': '12/23/2001'}, {'Revenue Today': 115.0, 'Issue Date': '12/26/2001'}, {'Revenue Today': 230.0, 'Issue Date': '12/27/2001'}, {'Revenue Today': 180.0, 'Issue Date': '12/28/2001'}, {'Revenue Today': 115.0, 'Issue Date': '12/29/2001'}, {'Revenue Today': 345.0, 'Issue Date': '12/30/2001'}, {'Revenue Today': 230.0, 'Issue Date': '12/31/2001'}, {'Revenue Today': 45.0, 'Issue Date': '08/02/2002'}, {'Revenue Today': 115.0, 'Issue Date': '09/08/2002'}, {'Revenue Today': 115.0, 'Issue Date': '09/30/2002'}, {'Revenue Today': 130.0, 'Issue Date': '10/17/2002'}, {'Revenue Today': 115.0, 'Issue Date': '07/16/2003'}, {'Revenue Today': 65.0, 'Issue Date': '07/25/2003'}, {'Revenue Today': 60.0, 'Issue Date': '07/27/2003'}, {'Revenue Today': 65.0, 'Issue Date': '08/04/2003'}, {'Revenue Today': 115.0, 'Issue Date': '08/06/2003'}, {'Revenue Today': 115.0, 'Issue Date': '08/16/2003'}, {'Revenue Today': 115.0, 'Issue Date': '08/20/2003'}, {'Revenue Today': 65.0, 'Issue Date': '09/01/2003'}, {'Revenue Today': 115.0, 'Issue Date': '09/18/2003'}, {'Revenue Today': 45.0, 'Issue Date': '09/25/2003'}, {'Revenue Today': 35.0, 'Issue Date': '09/27/2003'}, {'Revenue Today': 210.0, 'Issue Date': '10/01/2003'}, {'Revenue Today': 230.0, 'Issue Date': '10/03/2003'}, {'Revenue Today': 115.0, 'Issue Date': '10/04/2003'}, {'Revenue Today': 65.0, 'Issue Date': '10/05/2003'}, {'Revenue Today': 225.0, 'Issue Date': '10/06/2003'}, {'Revenue Today': 115.0, 'Issue Date': '10/09/2003'}, {'Revenue Today': 95.0, 'Issue Date': '10/10/2003'}, {'Revenue Today': 65.0, 'Issue Date': '10/15/2003'}, {'Revenue Today': 115.0, 'Issue Date': '11/04/2003'}, {'Revenue Today': 65.0, 'Issue Date': '11/11/2003'}, {'Revenue Today': 115.0, 'Issue Date': '11/12/2003'}, {'Revenue Today': nan, 'Issue Date': '11/14/2003'}, {'Revenue Today': 65.0, 'Issue Date': '11/15/2003'}, {'Revenue Today': 60.0, 'Issue Date': '12/01/2003'}, {'Revenue Today': 45.0, 'Issue Date': '12/02/2003'}, {'Revenue Today': 115.0, 'Issue Date': '12/05/2003'}, {'Revenue Today': 115.0, 'Issue Date': '12/08/2003'}, {'Revenue Today': 65.0, 'Issue Date': '12/11/2003'}, {'Revenue Today': 115.0, 'Issue Date': '12/16/2003'}, {'Revenue Today': 115.0, 'Issue Date': '12/18/2003'}, {'Revenue Today': 35.0, 'Issue Date': '12/21/2003'}, {'Revenue Today': 65.0, 'Issue Date': '12/24/2003'}, {'Revenue Today': 65.0, 'Issue Date': '12/26/2003'}, {'Revenue Today': 115.0, 'Issue Date': '12/31/2003'}, {'Revenue Today': 295.0, 'Issue Date': '01/01/2004'}, {'Revenue Today': 160.0, 'Issue Date': '01/02/2004'}, {'Revenue Today': 115.0, 'Issue Date': '01/06/2004'}, {'Revenue Today': 60.0, 'Issue Date': '01/10/2004'}, {'Revenue Today': 160.0, 'Issue Date': '01/11/2004'}, {'Revenue Today': 115.0, 'Issue Date': '01/12/2004'}, {'Revenue Today': 115.0, 'Issue Date': '01/25/2004'}, {'Revenue Today': 65.0, 'Issue Date': '01/27/2004'}, {'Revenue Today': 115.0, 'Issue Date': '01/29/2004'}, {'Revenue Today': 590.0, 'Issue Date': '01/31/2004'}, {'Revenue Today': 230.0, 'Issue Date': '02/03/2004'}, {'Revenue Today': 115.0, 'Issue Date': '02/04/2004'}, {'Revenue Today': 45.0, 'Issue Date': '02/06/2004'}, {'Revenue Today': 575.0, 'Issue Date': '02/11/2004'}, {'Revenue Today': 95.0, 'Issue Date': '02/13/2004'}, {'Revenue Today': 45.0, 'Issue Date': '08/06/2004'}, {'Revenue Today': 45.0, 'Issue Date': '09/04/2004'}, {'Revenue Today': 165.0, 'Issue Date': '09/24/2004'}, {'Revenue Today': 115.0, 'Issue Date': '02/06/2005'}, {'Revenue Today': 115.0, 'Issue Date': '08/03/2005'}, {'Revenue Today': 115.0, 'Issue Date': '09/10/2005'}, {'Revenue Today': 95.0, 'Issue Date': '12/09/2005'}, {'Revenue Today': 95.0, 'Issue Date': '12/22/2005'}, {'Revenue Today': 115.0, 'Issue Date': '07/25/2006'}, {'Revenue Today': 45.0, 'Issue Date': '10/08/2006'}, {'Revenue Today': 45.0, 'Issue Date': '10/18/2006'}, {'Revenue Today': 60.0, 'Issue Date': '01/04/2007'}, {'Revenue Today': 115.0, 'Issue Date': '02/07/2007'}, {'Revenue Today': 65.0, 'Issue Date': '08/09/2007'}, {'Revenue Today': 115.0, 'Issue Date': '08/16/2007'}, {'Revenue Today': 115.0, 'Issue Date': '09/06/2007'}, {'Revenue Today': 115.0, 'Issue Date': '10/24/2007'}, {'Revenue Today': 115.0, 'Issue Date': '11/11/2007'}, {'Revenue Today': 95.0, 'Issue Date': '12/07/2007'}, {'Revenue Today': 115.0, 'Issue Date': '01/07/2008'}, {'Revenue Today': 115.0, 'Issue Date': '08/06/2008'}, {'Revenue Today': 115.0, 'Issue Date': '08/15/2008'}, {'Revenue Today': 115.0, 'Issue Date': '12/12/2008'}, {'Revenue Today': 95.0, 'Issue Date': '01/01/2009'}, {'Revenue Today': 65.0, 'Issue Date': '01/08/2009'}, {'Revenue Today': 65.0, 'Issue Date': '08/09/2009'}, {'Revenue Today': 165.0, 'Issue Date': '09/09/2009'}, {'Revenue Today': 115.0, 'Issue Date': '09/21/2009'}, {'Revenue Today': 60.0, 'Issue Date': '10/08/2009'}, {'Revenue Today': 45.0, 'Issue Date': '10/10/2009'}, {'Revenue Today': 390.0, 'Issue Date': '01/09/2010'}, {'Revenue Today': 230.0, 'Issue Date': '01/10/2010'}, {'Revenue Today': 120.0, 'Issue Date': '01/11/2010'}, {'Revenue Today': 180.0, 'Issue Date': '01/13/2010'}, {'Revenue Today': 45.0, 'Issue Date': '01/16/2010'}, {'Revenue Today': 115.0, 'Issue Date': '01/30/2010'}, {'Revenue Today': 115.0, 'Issue Date': '02/04/2010'}, {'Revenue Today': 115.0, 'Issue Date': '02/07/2010'}, {'Revenue Today': 115.0, 'Issue Date': '02/17/2010'}, {'Revenue Today': 115.0, 'Issue Date': '05/08/2010'}, {'Revenue Today': 115.0, 'Issue Date': '07/10/2010'}, {'Revenue Today': 115.0, 'Issue Date': '07/20/2010'}, {'Revenue Today': 230.0, 'Issue Date': '07/21/2010'}, {'Revenue Today': 65.0, 'Issue Date': '07/22/2010'}, {'Revenue Today': 230.0, 'Issue Date': '07/23/2010'}, {'Revenue Today': 65.0, 'Issue Date': '07/25/2010'}, {'Revenue Today': 115.0, 'Issue Date': '07/30/2010'}, {'Revenue Today': 230.0, 'Issue Date': '08/09/2010'}, {'Revenue Today': 115.0, 'Issue Date': '08/13/2010'}, {'Revenue Today': 60.0, 'Issue Date': '08/17/2010'}, {'Revenue Today': 45.0, 'Issue Date': '08/22/2010'}, {'Revenue Today': 65.0, 'Issue Date': '08/23/2010'}, {'Revenue Today': 115.0, 'Issue Date': '09/11/2010'}, {'Revenue Today': 45.0, 'Issue Date': '09/20/2010'}, {'Revenue Today': 60.0, 'Issue Date': '09/21/2010'}, {'Revenue Today': 115.0, 'Issue Date': '09/22/2010'}, {'Revenue Today': 180.0, 'Issue Date': '09/26/2010'}, {'Revenue Today': 115.0, 'Issue Date': '09/29/2010'}, {'Revenue Today': 115.0, 'Issue Date': '09/30/2010'}, {'Revenue Today': 65.0, 'Issue Date': '10/02/2010'}, {'Revenue Today': 115.0, 'Issue Date': '10/04/2010'}, {'Revenue Today': 65.0, 'Issue Date': '10/05/2010'}, {'Revenue Today': 115.0, 'Issue Date': '10/06/2010'}, {'Revenue Today': 60.0, 'Issue Date': '10/07/2010'}, {'Revenue Today': 165.0, 'Issue Date': '10/09/2010'}, {'Revenue Today': 350.0, 'Issue Date': '10/10/2010'}, {'Revenue Today': 295.0, 'Issue Date': '10/11/2010'}, {'Revenue Today': 295.0, 'Issue Date': '10/13/2010'}, {'Revenue Today': 65.0, 'Issue Date': '10/14/2010'}, {'Revenue Today': 230.0, 'Issue Date': '10/15/2010'}, {'Revenue Today': 115.0, 'Issue Date': '10/16/2010'}, {'Revenue Today': 115.0, 'Issue Date': '10/17/2010'}, {'Revenue Today': 45.0, 'Issue Date': '10/23/2010'}, {'Revenue Today': 115.0, 'Issue Date': '10/24/2010'}, {'Revenue Today': 115.0, 'Issue Date': '10/25/2010'}, {'Revenue Today': 45.0, 'Issue Date': '10/29/2010'}, {'Revenue Today': 160.0, 'Issue Date': '10/31/2010'}, {'Revenue Today': 65.0, 'Issue Date': '11/01/2010'}, {'Revenue Today': 60.0, 'Issue Date': '11/10/2010'}, {'Revenue Today': 65.0, 'Issue Date': '11/11/2010'}, {'Revenue Today': 115.0, 'Issue Date': '12/04/2010'}, {'Revenue Today': 115.0, 'Issue Date': '12/08/2010'}, {'Revenue Today': 35.0, 'Issue Date': '12/10/2010'}, {'Revenue Today': 115.0, 'Issue Date': '12/16/2010'}, {'Revenue Today': 130.0, 'Issue Date': '12/23/2010'}, {'Revenue Today': 60.0, 'Issue Date': '12/31/2010'}, {'Revenue Today': 65.0, 'Issue Date': '01/01/2011'}, {'Revenue Today': 210.0, 'Issue Date': '01/06/2011'}, {'Revenue Today': 115.0, 'Issue Date': '01/07/2011'}, {'Revenue Today': 115.0, 'Issue Date': '01/08/2011'}, {'Revenue Today': 115.0, 'Issue Date': '01/09/2011'}, {'Revenue Today': 180.0, 'Issue Date': '01/10/2011'}, {'Revenue Today': 410.0, 'Issue Date': '01/11/2011'}, {'Revenue Today': 225.0, 'Issue Date': '01/12/2011'}, {'Revenue Today': 345.0, 'Issue Date': '01/13/2011'}, {'Revenue Today': 65.0, 'Issue Date': '01/16/2011'}, {'Revenue Today': 35.0, 'Issue Date': '01/19/2011'}, {'Revenue Today': 115.0, 'Issue Date': '01/22/2011'}, {'Revenue Today': 115.0, 'Issue Date': '01/23/2011'}, {'Revenue Today': 175.0, 'Issue Date': '01/29/2011'}, {'Revenue Today': 45.0, 'Issue Date': '01/30/2011'}, {'Revenue Today': 410.0, 'Issue Date': '01/31/2011'}, {'Revenue Today': 115.0, 'Issue Date': '02/02/2011'}, {'Revenue Today': 95.0, 'Issue Date': '02/04/2011'}, {'Revenue Today': 325.0, 'Issue Date': '02/10/2011'}, {'Revenue Today': 360.0, 'Issue Date': '02/11/2011'}, {'Revenue Today': 160.0, 'Issue Date': '02/12/2011'}, {'Revenue Today': 115.0, 'Issue Date': '07/22/2011'}, {'Revenue Today': 65.0, 'Issue Date': '07/23/2011'}, {'Revenue Today': 230.0, 'Issue Date': '07/25/2011'}, {'Revenue Today': 35.0, 'Issue Date': '07/29/2011'}, {'Revenue Today': 45.0, 'Issue Date': '07/30/2011'}, {'Revenue Today': 260.0, 'Issue Date': '08/04/2011'}, {'Revenue Today': 115.0, 'Issue Date': '08/06/2011'}, {'Revenue Today': 115.0, 'Issue Date': '08/07/2011'}, {'Revenue Today': 115.0, 'Issue Date': '08/08/2011'}, {'Revenue Today': 115.0, 'Issue Date': '08/10/2011'}, {'Revenue Today': 320.0, 'Issue Date': '08/12/2011'}, {'Revenue Today': 65.0, 'Issue Date': '08/14/2011'}, {'Revenue Today': 65.0, 'Issue Date': '08/17/2011'}, {'Revenue Today': 115.0, 'Issue Date': '08/22/2011'}, {'Revenue Today': 290.0, 'Issue Date': '08/23/2011'}, {'Revenue Today': 60.0, 'Issue Date': '08/26/2011'}, {'Revenue Today': 65.0, 'Issue Date': '08/31/2011'}, {'Revenue Today': 295.0, 'Issue Date': '09/02/2011'}, {'Revenue Today': 115.0, 'Issue Date': '09/07/2011'}, {'Revenue Today': 65.0, 'Issue Date': '09/09/2011'}, {'Revenue Today': 770.0, 'Issue Date': '09/10/2011'}, {'Revenue Today': 210.0, 'Issue Date': '09/11/2011'}, {'Revenue Today': 130.0, 'Issue Date': '09/12/2011'}, {'Revenue Today': 345.0, 'Issue Date': '09/13/2011'}, {'Revenue Today': 115.0, 'Issue Date': '09/16/2011'}, {'Revenue Today': 230.0, 'Issue Date': '09/18/2011'}, {'Revenue Today': 115.0, 'Issue Date': '09/19/2011'}, {'Revenue Today': 45.0, 'Issue Date': '09/23/2011'}, {'Revenue Today': 65.0, 'Issue Date': '09/25/2011'}, {'Revenue Today': 115.0, 'Issue Date': '09/26/2011'}, {'Revenue Today': 95.0, 'Issue Date': '09/27/2011'}, {'Revenue Today': 65.0, 'Issue Date': '09/29/2011'}, {'Revenue Today': 205.0, 'Issue Date': '10/01/2011'}, {'Revenue Today': 230.0, 'Issue Date': '10/03/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/08/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/09/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/10/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/14/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/15/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/19/2011'}, {'Revenue Today': 115.0, 'Issue Date': '10/25/2011'}, {'Revenue Today': 175.0, 'Issue Date': '10/27/2011'}, {'Revenue Today': 210.0, 'Issue Date': '11/01/2011'}, {'Revenue Today': 180.0, 'Issue Date': '11/02/2011'}, {'Revenue Today': 295.0, 'Issue Date': '11/05/2011'}, {'Revenue Today': 60.0, 'Issue Date': '11/07/2011'}, {'Revenue Today': 65.0, 'Issue Date': '11/10/2011'}, {'Revenue Today': 130.0, 'Issue Date': '11/11/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/12/2011'}, {'Revenue Today': 240.0, 'Issue Date': '11/13/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/19/2011'}, {'Revenue Today': 180.0, 'Issue Date': '11/20/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/21/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/22/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/23/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/24/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/26/2011'}, {'Revenue Today': 95.0, 'Issue Date': '11/27/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/28/2011'}, {'Revenue Today': 115.0, 'Issue Date': '11/30/2011'}, {'Revenue Today': 115.0, 'Issue Date': '12/10/2011'}, {'Revenue Today': 230.0, 'Issue Date': '12/11/2011'}, {'Revenue Today': 115.0, 'Issue Date': '12/12/2011'}, {'Revenue Today': 115.0, 'Issue Date': '12/13/2011'}, {'Revenue Today': 115.0, 'Issue Date': '12/19/2011'}, {'Revenue Today': 165.0, 'Issue Date': '12/21/2011'}, {'Revenue Today': 180.0, 'Issue Date': '12/22/2011'}, {'Revenue Today': 45.0, 'Issue Date': '12/23/2011'}, {'Revenue Today': 115.0, 'Issue Date': '12/27/2011'}, {'Revenue Today': 115.0, 'Issue Date': '12/29/2011'}, {'Revenue Today': 65.0, 'Issue Date': '01/01/2012'}, {'Revenue Today': 115.0, 'Issue Date': '01/03/2012'}, {'Revenue Today': 115.0, 'Issue Date': '01/04/2012'}, {'Revenue Today': 65.0, 'Issue Date': '01/06/2012'}, {'Revenue Today': 230.0, 'Issue Date': '01/08/2012'}, {'Revenue Today': 35.0, 'Issue Date': '01/13/2012'}, {'Revenue Today': 115.0, 'Issue Date': '01/14/2012'}, {'Revenue Today': 115.0, 'Issue Date': '01/26/2012'}, {'Revenue Today': 95.0, 'Issue Date': '02/02/2012'}, {'Revenue Today': 115.0, 'Issue Date': '02/03/2012'}, {'Revenue Today': 115.0, 'Issue Date': '02/09/2012'}, {'Revenue Today': 45.0, 'Issue Date': '02/10/2012'}, {'Revenue Today': 115.0, 'Issue Date': '02/11/2012'}, {'Revenue Today': 440.0, 'Issue Date': '02/12/2012'}, {'Revenue Today': 115.0, 'Issue Date': '02/14/2012'}, {'Revenue Today': 60.0, 'Issue Date': '03/28/2012'}, {'Revenue Today': 115.0, 'Issue Date': '04/25/2012'}, {'Revenue Today': 115.0, 'Issue Date': '05/10/2012'}, {'Revenue Today': 115.0, 'Issue Date': '05/28/2012'}, {'Revenue Today': 190.0, 'Issue Date': '06/25/2012'}, {'Revenue Today': 230.0, 'Issue Date': '07/03/2012'}, {'Revenue Today': 130.0, 'Issue Date': '07/08/2012'}, {'Revenue Today': 115.0, 'Issue Date': '07/09/2012'}, {'Revenue Today': 160.0, 'Issue Date': '07/10/2012'}, {'Revenue Today': 45.0, 'Issue Date': '07/13/2012'}, {'Revenue Today': 180.0, 'Issue Date': '07/15/2012'}, {'Revenue Today': 65.0, 'Issue Date': '07/16/2012'}, {'Revenue Today': 95.0, 'Issue Date': '07/17/2012'}, {'Revenue Today': 115.0, 'Issue Date': '07/18/2012'}, {'Revenue Today': 115.0, 'Issue Date': '07/19/2012'}, {'Revenue Today': 160.0, 'Issue Date': '07/20/2012'}, {'Revenue Today': 180.0, 'Issue Date': '07/22/2012'}, {'Revenue Today': 670.0, 'Issue Date': '07/23/2012'}, {'Revenue Today': 775.0, 'Issue Date': '07/24/2012'}, {'Revenue Today': 230.0, 'Issue Date': '07/25/2012'}, {'Revenue Today': 550.0, 'Issue Date': '07/26/2012'}, {'Revenue Today': 180.0, 'Issue Date': '07/27/2012'}, {'Revenue Today': 230.0, 'Issue Date': '07/28/2012'}, {'Revenue Today': 475.0, 'Issue Date': '07/30/2012'}, {'Revenue Today': 455.0, 'Issue Date': '07/31/2012'}, {'Revenue Today': 65.0, 'Issue Date': '08/01/2012'}, {'Revenue Today': 230.0, 'Issue Date': '08/02/2012'}, {'Revenue Today': 470.0, 'Issue Date': '08/03/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/04/2012'}, {'Revenue Today': 45.0, 'Issue Date': '08/05/2012'}, {'Revenue Today': 665.0, 'Issue Date': '08/06/2012'}, {'Revenue Today': 65.0, 'Issue Date': '08/07/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/08/2012'}, {'Revenue Today': 425.0, 'Issue Date': '08/09/2012'}, {'Revenue Today': 160.0, 'Issue Date': '08/10/2012'}, {'Revenue Today': 505.0, 'Issue Date': '08/11/2012'}, {'Revenue Today': 525.0, 'Issue Date': '08/12/2012'}, {'Revenue Today': 515.0, 'Issue Date': '08/13/2012'}, {'Revenue Today': 495.0, 'Issue Date': '08/14/2012'}, {'Revenue Today': 95.0, 'Issue Date': '08/16/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/17/2012'}, {'Revenue Today': 45.0, 'Issue Date': '08/18/2012'}, {'Revenue Today': 230.0, 'Issue Date': '08/21/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/22/2012'}, {'Revenue Today': 275.0, 'Issue Date': '08/23/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/24/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/25/2012'}, {'Revenue Today': 225.0, 'Issue Date': '08/26/2012'}, {'Revenue Today': 280.0, 'Issue Date': '08/27/2012'}, {'Revenue Today': 115.0, 'Issue Date': '08/28/2012'}, {'Revenue Today': 525.0, 'Issue Date': '08/30/2012'}, {'Revenue Today': 575.0, 'Issue Date': '08/31/2012'}, {'Revenue Today': 405.0, 'Issue Date': '09/02/2012'}, {'Revenue Today': 945.0, 'Issue Date': '09/03/2012'}, {'Revenue Today': 115.0, 'Issue Date': '09/04/2012'}, {'Revenue Today': 110.0, 'Issue Date': '09/05/2012'}, {'Revenue Today': 295.0, 'Issue Date': '09/06/2012'}, {'Revenue Today': 180.0, 'Issue Date': '09/07/2012'}, {'Revenue Today': 540.0, 'Issue Date': '09/09/2012'}, {'Revenue Today': 270.0, 'Issue Date': '09/10/2012'}, {'Revenue Today': 210.0, 'Issue Date': '09/11/2012'}, {'Revenue Today': 295.0, 'Issue Date': '09/12/2012'}, {'Revenue Today': 945.0, 'Issue Date': '09/13/2012'}, {'Revenue Today': 210.0, 'Issue Date': '09/14/2012'}, {'Revenue Today': 230.0, 'Issue Date': '09/15/2012'}, {'Revenue Today': 115.0, 'Issue Date': '09/16/2012'}, {'Revenue Today': 110.0, 'Issue Date': '09/17/2012'}, {'Revenue Today': 160.0, 'Issue Date': '09/20/2012'}, {'Revenue Today': 210.0, 'Issue Date': '09/21/2012'}, {'Revenue Today': 130.0, 'Issue Date': '09/22/2012'}, {'Revenue Today': 115.0, 'Issue Date': '09/23/2012'}, {'Revenue Today': 345.0, 'Issue Date': '09/24/2012'}, {'Revenue Today': 230.0, 'Issue Date': '09/25/2012'}, {'Revenue Today': 115.0, 'Issue Date': '09/26/2012'}, {'Revenue Today': 115.0, 'Issue Date': '09/28/2012'}, {'Revenue Today': 230.0, 'Issue Date': '09/29/2012'}, {'Revenue Today': 1180.0, 'Issue Date': '09/30/2012'}, {'Revenue Today': 200.0, 'Issue Date': '10/01/2012'}, {'Revenue Today': 95.0, 'Issue Date': '10/02/2012'}, {'Revenue Today': 480.0, 'Issue Date': '10/03/2012'}, {'Revenue Today': 275.0, 'Issue Date': '10/04/2012'}, {'Revenue Today': 635.0, 'Issue Date': '10/05/2012'}, {'Revenue Today': 180.0, 'Issue Date': '10/06/2012'}, {'Revenue Today': 105.0, 'Issue Date': '10/07/2012'}, {'Revenue Today': 180.0, 'Issue Date': '10/08/2012'}, {'Revenue Today': 230.0, 'Issue Date': '10/09/2012'}, {'Revenue Today': 115.0, 'Issue Date': '10/10/2012'}, {'Revenue Today': 1115.0, 'Issue Date': '10/11/2012'}, {'Revenue Today': 330.0, 'Issue Date': '10/12/2012'}, {'Revenue Today': 1050.0, 'Issue Date': '10/13/2012'}, {'Revenue Today': 115.0, 'Issue Date': '10/14/2012'}, {'Revenue Today': 230.0, 'Issue Date': '10/15/2012'}, {'Revenue Today': 115.0, 'Issue Date': '10/16/2012'}, {'Revenue Today': 290.0, 'Issue Date': '10/18/2012'}, {'Revenue Today': 345.0, 'Issue Date': '10/20/2012'}, {'Revenue Today': 210.0, 'Issue Date': '10/21/2012'}, {'Revenue Today': 390.0, 'Issue Date': '10/22/2012'}, {'Revenue Today': 525.0, 'Issue Date': '10/23/2012'}, {'Revenue Today': 160.0, 'Issue Date': '10/24/2012'}, {'Revenue Today': 45.0, 'Issue Date': '10/25/2012'}, {'Revenue Today': 175.0, 'Issue Date': '10/27/2012'}, {'Revenue Today': 45.0, 'Issue Date': '10/28/2012'}, {'Revenue Today': 65.0, 'Issue Date': '10/29/2012'}, {'Revenue Today': 830.0, 'Issue Date': '10/30/2012'}, {'Revenue Today': 180.0, 'Issue Date': '10/31/2012'}, {'Revenue Today': 230.0, 'Issue Date': '11/01/2012'}, {'Revenue Today': 180.0, 'Issue Date': '11/02/2012'}, {'Revenue Today': 160.0, 'Issue Date': '11/03/2012'}, {'Revenue Today': 115.0, 'Issue Date': '11/04/2012'}, {'Revenue Today': 410.0, 'Issue Date': '11/05/2012'}, {'Revenue Today': 115.0, 'Issue Date': '11/06/2012'}, {'Revenue Today': 230.0, 'Issue Date': '11/07/2012'}, {'Revenue Today': 115.0, 'Issue Date': '11/08/2012'}, {'Revenue Today': 210.0, 'Issue Date': '11/09/2012'}, {'Revenue Today': 385.0, 'Issue Date': '11/10/2012'}, {'Revenue Today': 280.0, 'Issue Date': '11/11/2012'}, {'Revenue Today': 45.0, 'Issue Date': '11/12/2012'}, {'Revenue Today': 505.0, 'Issue Date': '11/13/2012'}, {'Revenue Today': 275.0, 'Issue Date': '11/14/2012'}, {'Revenue Today': 160.0, 'Issue Date': '11/17/2012'}, {'Revenue Today': nan, 'Issue Date': '11/18/2012'}, {'Revenue Today': 115.0, 'Issue Date': '11/19/2012'}, {'Revenue Today': 115.0, 'Issue Date': '11/23/2012'}, {'Revenue Today': 115.0, 'Issue Date': '11/24/2012'}, {'Revenue Today': 45.0, 'Issue Date': '11/27/2012'}, {'Revenue Today': 95.0, 'Issue Date': '11/28/2012'}, {'Revenue Today': 275.0, 'Issue Date': '11/29/2012'}, {'Revenue Today': 140.0, 'Issue Date': '11/30/2012'}, {'Revenue Today': 175.0, 'Issue Date': '12/01/2012'}, {'Revenue Today': 425.0, 'Issue Date': '12/02/2012'}, {'Revenue Today': 390.0, 'Issue Date': '12/03/2012'}, {'Revenue Today': 295.0, 'Issue Date': '12/04/2012'}, {'Revenue Today': 355.0, 'Issue Date': '12/05/2012'}, {'Revenue Today': 455.0, 'Issue Date': '12/06/2012'}, {'Revenue Today': 110.0, 'Issue Date': '12/07/2012'}, {'Revenue Today': 235.0, 'Issue Date': '12/08/2012'}, {'Revenue Today': 620.0, 'Issue Date': '12/09/2012'}, {'Revenue Today': 995.0, 'Issue Date': '12/10/2012'}, {'Revenue Today': 395.0, 'Issue Date': '12/11/2012'}, {'Revenue Today': 470.0, 'Issue Date': '12/12/2012'}, {'Revenue Today': 1730.0, 'Issue Date': '12/13/2012'}, {'Revenue Today': 160.0, 'Issue Date': '12/14/2012'}, {'Revenue Today': 485.0, 'Issue Date': '12/15/2012'}, {'Revenue Today': 275.0, 'Issue Date': '12/17/2012'}, {'Revenue Today': 345.0, 'Issue Date': '12/18/2012'}, {'Revenue Today': 115.0, 'Issue Date': '12/19/2012'}, {'Revenue Today': 115.0, 'Issue Date': '12/20/2012'}, {'Revenue Today': 620.0, 'Issue Date': '12/21/2012'}, {'Revenue Today': 45.0, 'Issue Date': '12/22/2012'}, {'Revenue Today': 735.0, 'Issue Date': '12/23/2012'}, {'Revenue Today': 115.0, 'Issue Date': '12/24/2012'}, {'Revenue Today': 305.0, 'Issue Date': '12/26/2012'}, {'Revenue Today': 35.0, 'Issue Date': '12/27/2012'}, {'Revenue Today': 520.0, 'Issue Date': '12/28/2012'}, {'Revenue Today': 380.0, 'Issue Date': '12/30/2012'}, {'Revenue Today': 215.0, 'Issue Date': '12/31/2012'}, {'Revenue Today': 5290.0, 'Issue Date': '01/01/2013'}, {'Revenue Today': 7450.0, 'Issue Date': '01/02/2013'}, {'Revenue Today': 3535.0, 'Issue Date': '01/03/2013'}, {'Revenue Today': 9445.0, 'Issue Date': '01/04/2013'}, {'Revenue Today': 6985.0, 'Issue Date': '01/05/2013'}, {'Revenue Today': 11080.0, 'Issue Date': '01/06/2013'}, {'Revenue Today': 10040.0, 'Issue Date': '01/07/2013'}, {'Revenue Today': 10140.0, 'Issue Date': '01/08/2013'}, {'Revenue Today': 7830.0, 'Issue Date': '01/09/2013'}, {'Revenue Today': 5090.0, 'Issue Date': '01/10/2013'}, {'Revenue Today': 2620.0, 'Issue Date': '01/11/2013'}, {'Revenue Today': 4470.0, 'Issue Date': '01/12/2013'}, {'Revenue Today': 2280.0, 'Issue Date': '01/13/2013'}, {'Revenue Today': 6400.0, 'Issue Date': '01/14/2013'}, {'Revenue Today': 2945.0, 'Issue Date': '01/15/2013'}, {'Revenue Today': 3790.0, 'Issue Date': '01/16/2013'}, {'Revenue Today': 3120.0, 'Issue Date': '01/17/2013'}, {'Revenue Today': 3095.0, 'Issue Date': '01/18/2013'}, {'Revenue Today': 2470.0, 'Issue Date': '01/19/2013'}, {'Revenue Today': 2565.0, 'Issue Date': '01/20/2013'}, {'Revenue Today': 940.0, 'Issue Date': '01/21/2013'}, {'Revenue Today': 1810.0, 'Issue Date': '01/22/2013'}, {'Revenue Today': 2350.0, 'Issue Date': '01/23/2013'}, {'Revenue Today': 3905.0, 'Issue Date': '01/24/2013'}, {'Revenue Today': 1600.0, 'Issue Date': '01/25/2013'}, {'Revenue Today': 1530.0, 'Issue Date': '01/26/2013'}, {'Revenue Today': 2745.0, 'Issue Date': '01/27/2013'}, {'Revenue Today': 1985.0, 'Issue Date': '01/28/2013'}, {'Revenue Today': 2980.0, 'Issue Date': '01/29/2013'}, {'Revenue Today': 1625.0, 'Issue Date': '01/30/2013'}, {'Revenue Today': 1030.0, 'Issue Date': '01/31/2013'}, {'Revenue Today': 590.0, 'Issue Date': '02/01/2013'}, {'Revenue Today': 590.0, 'Issue Date': '02/02/2013'}, {'Revenue Today': 965.0, 'Issue Date': '02/03/2013'}, {'Revenue Today': 1970.0, 'Issue Date': '02/04/2013'}, {'Revenue Today': 1490.0, 'Issue Date': '02/05/2013'}, {'Revenue Today': 1720.0, 'Issue Date': '02/06/2013'}, {'Revenue Today': 510.0, 'Issue Date': '02/07/2013'}, {'Revenue Today': 475.0, 'Issue Date': '02/08/2013'}, {'Revenue Today': 1215.0, 'Issue Date': '02/09/2013'}, {'Revenue Today': 345.0, 'Issue Date': '02/10/2013'}, {'Revenue Today': 870.0, 'Issue Date': '02/11/2013'}, {'Revenue Today': 865.0, 'Issue Date': '02/12/2013'}, {'Revenue Today': 505.0, 'Issue Date': '02/13/2013'}, {'Revenue Today': 585.0, 'Issue Date': '02/14/2013'}, {'Revenue Today': 805.0, 'Issue Date': '02/15/2013'}, {'Revenue Today': 205.0, 'Issue Date': '02/16/2013'}, {'Revenue Today': 455.0, 'Issue Date': '02/17/2013'}, {'Revenue Today': 390.0, 'Issue Date': '02/18/2013'}, {'Revenue Today': 720.0, 'Issue Date': '02/19/2013'}, {'Revenue Today': 320.0, 'Issue Date': '02/20/2013'}, {'Revenue Today': 685.0, 'Issue Date': '02/21/2013'}, {'Revenue Today': 435.0, 'Issue Date': '02/22/2013'}, {'Revenue Today': 225.0, 'Issue Date': '02/23/2013'}, {'Revenue Today': 205.0, 'Issue Date': '02/24/2013'}, {'Revenue Today': 355.0, 'Issue Date': '02/25/2013'}, {'Revenue Today': 110.0, 'Issue Date': '02/26/2013'}, {'Revenue Today': 570.0, 'Issue Date': '02/27/2013'}, {'Revenue Today': 195.0, 'Issue Date': '02/28/2013'}, {'Revenue Today': 65.0, 'Issue Date': '03/01/2013'}, {'Revenue Today': 360.0, 'Issue Date': '03/02/2013'}, {'Revenue Today': 60.0, 'Issue Date': '03/03/2013'}, {'Revenue Today': 180.0, 'Issue Date': '03/04/2013'}, {'Revenue Today': 180.0, 'Issue Date': '03/05/2013'}, {'Revenue Today': 490.0, 'Issue Date': '03/06/2013'}, {'Revenue Today': 180.0, 'Issue Date': '03/09/2013'}, {'Revenue Today': 195.0, 'Issue Date': '03/10/2013'}, {'Revenue Today': 505.0, 'Issue Date': '03/11/2013'}, {'Revenue Today': 65.0, 'Issue Date': '03/12/2013'}, {'Revenue Today': 205.0, 'Issue Date': '03/13/2013'}, {'Revenue Today': 115.0, 'Issue Date': '03/14/2013'}, {'Revenue Today': 230.0, 'Issue Date': '03/15/2013'}, {'Revenue Today': 230.0, 'Issue Date': '03/16/2013'}, {'Revenue Today': 410.0, 'Issue Date': '03/17/2013'}, {'Revenue Today': 65.0, 'Issue Date': '03/18/2013'}, {'Revenue Today': 870.0, 'Issue Date': '03/19/2013'}, {'Revenue Today': 245.0, 'Issue Date': '03/20/2013'}, {'Revenue Today': 115.0, 'Issue Date': '03/21/2013'}, {'Revenue Today': 295.0, 'Issue Date': '03/22/2013'}, {'Revenue Today': 460.0, 'Issue Date': '03/23/2013'}, {'Revenue Today': 115.0, 'Issue Date': '03/24/2013'}, {'Revenue Today': 110.0, 'Issue Date': '03/25/2013'}, {'Revenue Today': 35.0, 'Issue Date': '03/26/2013'}, {'Revenue Today': 195.0, 'Issue Date': '03/27/2013'}, {'Revenue Today': 475.0, 'Issue Date': '03/28/2013'}, {'Revenue Today': 275.0, 'Issue Date': '03/29/2013'}, {'Revenue Today': 45.0, 'Issue Date': '03/30/2013'}, {'Revenue Today': 230.0, 'Issue Date': '03/31/2013'}, {'Revenue Today': 2030.0, 'Issue Date': '04/02/2013'}, {'Revenue Today': 1890.0, 'Issue Date': '04/03/2013'}, {'Revenue Today': 410.0, 'Issue Date': '04/04/2013'}, {'Revenue Today': 685.0, 'Issue Date': '04/05/2013'}, {'Revenue Today': 180.0, 'Issue Date': '04/06/2013'}, {'Revenue Today': 600.0, 'Issue Date': '04/07/2013'}, {'Revenue Today': 425.0, 'Issue Date': '04/08/2013'}, {'Revenue Today': 340.0, 'Issue Date': '04/09/2013'}, {'Revenue Today': 4295.0, 'Issue Date': '04/10/2013'}, {'Revenue Today': 595.0, 'Issue Date': '04/11/2013'}, {'Revenue Today': 625.0, 'Issue Date': '04/12/2013'}, {'Revenue Today': 405.0, 'Issue Date': '04/13/2013'}, {'Revenue Today': 245.0, 'Issue Date': '04/14/2013'}, {'Revenue Today': 495.0, 'Issue Date': '04/15/2013'}, {'Revenue Today': 230.0, 'Issue Date': '04/16/2013'}, {'Revenue Today': 705.0, 'Issue Date': '04/17/2013'}, {'Revenue Today': 735.0, 'Issue Date': '04/18/2013'}, {'Revenue Today': 360.0, 'Issue Date': '04/19/2013'}, {'Revenue Today': 415.0, 'Issue Date': '04/20/2013'}, {'Revenue Today': 590.0, 'Issue Date': '04/21/2013'}, {'Revenue Today': 175.0, 'Issue Date': '04/22/2013'}, {'Revenue Today': 2535.0, 'Issue Date': '04/23/2013'}, {'Revenue Today': 640.0, 'Issue Date': '04/24/2013'}, {'Revenue Today': 890.0, 'Issue Date': '04/25/2013'}, {'Revenue Today': 890.0, 'Issue Date': '04/26/2013'}, {'Revenue Today': 1415.0, 'Issue Date': '04/27/2013'}, {'Revenue Today': 450.0, 'Issue Date': '04/28/2013'}, {'Revenue Today': 550.0, 'Issue Date': '04/29/2013'}, {'Revenue Today': 1400.0, 'Issue Date': '04/30/2013'}, {'Revenue Today': 225.0, 'Issue Date': '05/01/2013'}, {'Revenue Today': 45.0, 'Issue Date': '05/02/2013'}, {'Revenue Today': 405.0, 'Issue Date': '05/03/2013'}, {'Revenue Today': 375.0, 'Issue Date': '05/04/2013'}, {'Revenue Today': 745.0, 'Issue Date': '05/05/2013'}, {'Revenue Today': 390.0, 'Issue Date': '05/06/2013'}, {'Revenue Today': 235.0, 'Issue Date': '05/07/2013'}, {'Revenue Today': 115.0, 'Issue Date': '05/08/2013'}, {'Revenue Today': 230.0, 'Issue Date': '05/09/2013'}, {'Revenue Today': 440.0, 'Issue Date': '05/10/2013'}, {'Revenue Today': 405.0, 'Issue Date': '05/11/2013'}, {'Revenue Today': 555.0, 'Issue Date': '05/12/2013'}, {'Revenue Today': 295.0, 'Issue Date': '05/13/2013'}, {'Revenue Today': 115.0, 'Issue Date': '05/14/2013'}, {'Revenue Today': 275.0, 'Issue Date': '05/15/2013'}, {'Revenue Today': 945.0, 'Issue Date': '05/16/2013'}, {'Revenue Today': 110.0, 'Issue Date': '05/17/2013'}, {'Revenue Today': 115.0, 'Issue Date': '05/18/2013'}, {'Revenue Today': 370.0, 'Issue Date': '05/19/2013'}, {'Revenue Today': 230.0, 'Issue Date': '05/20/2013'}, {'Revenue Today': 345.0, 'Issue Date': '05/21/2013'}, {'Revenue Today': 555.0, 'Issue Date': '05/22/2013'}, {'Revenue Today': 765.0, 'Issue Date': '05/23/2013'}, {'Revenue Today': 1280.0, 'Issue Date': '05/24/2013'}, {'Revenue Today': 215.0, 'Issue Date': '05/25/2013'}, {'Revenue Today': 610.0, 'Issue Date': '05/26/2013'}, {'Revenue Today': 925.0, 'Issue Date': '05/27/2013'}, {'Revenue Today': 745.0, 'Issue Date': '05/28/2013'}, {'Revenue Today': 605.0, 'Issue Date': '05/29/2013'}, {'Revenue Today': 485.0, 'Issue Date': '05/30/2013'}, {'Revenue Today': 1850.0, 'Issue Date': '05/31/2013'}, {'Revenue Today': 615.0, 'Issue Date': '06/01/2013'}, {'Revenue Today': 295.0, 'Issue Date': '06/02/2013'}, {'Revenue Today': 11315.0, 'Issue Date': '06/03/2013'}, {'Revenue Today': 8180.0, 'Issue Date': '06/04/2013'}, {'Revenue Today': 16160.0, 'Issue Date': '06/05/2013'}, {'Revenue Today': 20735.0, 'Issue Date': '06/06/2013'}, {'Revenue Today': 26725.0, 'Issue Date': '06/07/2013'}, {'Revenue Today': 1180.0, 'Issue Date': '06/08/2013'}, {'Revenue Today': 4470.0, 'Issue Date': '06/09/2013'}, {'Revenue Today': 14500.0, 'Issue Date': '06/10/2013'}, {'Revenue Today': 9770.0, 'Issue Date': '06/11/2013'}, {'Revenue Today': 7730.0, 'Issue Date': '06/12/2013'}, {'Revenue Today': 10635.0, 'Issue Date': '06/13/2013'}, {'Revenue Today': 1200.0, 'Issue Date': '06/14/2013'}, {'Revenue Today': 1285.0, 'Issue Date': '06/15/2013'}, {'Revenue Today': 825.0, 'Issue Date': '06/16/2013'}, {'Revenue Today': 4040.0, 'Issue Date': '06/17/2013'}, {'Revenue Today': 2225.0, 'Issue Date': '06/18/2013'}, {'Revenue Today': 4105.0, 'Issue Date': '06/19/2013'}, {'Revenue Today': 3440.0, 'Issue Date': '06/20/2013'}, {'Revenue Today': 4275.0, 'Issue Date': '06/21/2013'}, {'Revenue Today': 2990.0, 'Issue Date': '06/22/2013'}, {'Revenue Today': 3810.0, 'Issue Date': '06/23/2013'}, {'Revenue Today': 8035.0, 'Issue Date': '06/24/2013'}, {'Revenue Today': 22985.0, 'Issue Date': '06/25/2013'}, {'Revenue Today': 22020.0, 'Issue Date': '06/26/2013'}, {'Revenue Today': 19825.0, 'Issue Date': '06/27/2013'}, {'Revenue Today': 31650.0, 'Issue Date': '06/28/2013'}, {'Revenue Today': 26245.0, 'Issue Date': '06/29/2013'}, {'Revenue Today': 25815.0, 'Issue Date': '06/30/2013'}, {'Revenue Today': 13580.0, 'Issue Date': '07/01/2013'}, {'Revenue Today': 29910.0, 'Issue Date': '07/02/2013'}, {'Revenue Today': 31250.0, 'Issue Date': '07/03/2013'}, {'Revenue Today': 12410.0, 'Issue Date': '07/04/2013'}, {'Revenue Today': 26665.0, 'Issue Date': '07/05/2013'}, {'Revenue Today': 19115.0, 'Issue Date': '07/06/2013'}, {'Revenue Today': 35515.0, 'Issue Date': '07/07/2013'}, {'Revenue Today': 47345.0, 'Issue Date': '07/08/2013'}, {'Revenue Today': 77005.0, 'Issue Date': '07/09/2013'}, {'Revenue Today': 69305.0, 'Issue Date': '07/10/2013'}, {'Revenue Today': 80195.0, 'Issue Date': '07/11/2013'}, {'Revenue Today': 60455.0, 'Issue Date': '07/12/2013'}, {'Revenue Today': 49880.0, 'Issue Date': '07/13/2013'}, {'Revenue Today': 54030.0, 'Issue Date': '07/14/2013'}, {'Revenue Today': 129170.0, 'Issue Date': '07/15/2013'}, {'Revenue Today': 197985.0, 'Issue Date': '07/16/2013'}, {'Revenue Today': 287010.0, 'Issue Date': '07/17/2013'}, {'Revenue Today': 319980.0, 'Issue Date': '07/18/2013'}, {'Revenue Today': 311235.0, 'Issue Date': '07/19/2013'}, {'Revenue Today': 299615.0, 'Issue Date': '07/20/2013'}, {'Revenue Today': 295050.0, 'Issue Date': '07/21/2013'}, {'Revenue Today': 468020.0, 'Issue Date': '07/22/2013'}, {'Revenue Today': 540760.0, 'Issue Date': '07/23/2013'}, {'Revenue Today': 534160.0, 'Issue Date': '07/24/2013'}, {'Revenue Today': 556160.0, 'Issue Date': '07/25/2013'}, {'Revenue Today': 552175.0, 'Issue Date': '07/26/2013'}, {'Revenue Today': 354230.0, 'Issue Date': '07/27/2013'}, {'Revenue Today': 333955.0, 'Issue Date': '07/28/2013'}, {'Revenue Today': 2356540.0, 'Issue Date': '07/29/2013'}, {'Revenue Today': 2739365.0, 'Issue Date': '07/30/2013'}, {'Revenue Today': 2582800.0, 'Issue Date': '07/31/2013'}, {'Revenue Today': 2588815.0, 'Issue Date': '08/01/2013'}, {'Revenue Today': 2679970.0, 'Issue Date': '08/02/2013'}, {'Revenue Today': 1411045.0, 'Issue Date': '08/03/2013'}, {'Revenue Today': 728415.0, 'Issue Date': '08/04/2013'}, {'Revenue Today': 2401215.0, 'Issue Date': '08/05/2013'}, {'Revenue Today': 2679910.0, 'Issue Date': '08/06/2013'}, {'Revenue Today': 2434705.0, 'Issue Date': '08/07/2013'}, {'Revenue Today': 2024875.0, 'Issue Date': '08/08/2013'}, {'Revenue Today': 2070795.0, 'Issue Date': '08/09/2013'}, {'Revenue Today': 1298195.0, 'Issue Date': '08/10/2013'}, {'Revenue Today': 677720.0, 'Issue Date': '08/11/2013'}, {'Revenue Today': 2184775.0, 'Issue Date': '08/12/2013'}, {'Revenue Today': 2192725.0, 'Issue Date': '08/13/2013'}, {'Revenue Today': 2458365.0, 'Issue Date': '08/14/2013'}, {'Revenue Today': 2373380.0, 'Issue Date': '08/15/2013'}, {'Revenue Today': 2355170.0, 'Issue Date': '08/16/2013'}, {'Revenue Today': 1037690.0, 'Issue Date': '08/17/2013'}, {'Revenue Today': 645550.0, 'Issue Date': '08/18/2013'}, {'Revenue Today': 2257800.0, 'Issue Date': '08/19/2013'}, {'Revenue Today': 2485105.0, 'Issue Date': '08/20/2013'}, {'Revenue Today': 2257930.0, 'Issue Date': '08/21/2013'}, {'Revenue Today': 2374950.0, 'Issue Date': '08/22/2013'}, {'Revenue Today': 2494490.0, 'Issue Date': '08/23/2013'}, {'Revenue Today': 1335280.0, 'Issue Date': '08/24/2013'}, {'Revenue Today': 671815.0, 'Issue Date': '08/25/2013'}, {'Revenue Today': 2311855.0, 'Issue Date': '08/26/2013'}, {'Revenue Today': 2662385.0, 'Issue Date': '08/27/2013'}, {'Revenue Today': 2294045.0, 'Issue Date': '08/28/2013'}, {'Revenue Today': 2569350.0, 'Issue Date': '08/29/2013'}, {'Revenue Today': 2480530.0, 'Issue Date': '08/30/2013'}, {'Revenue Today': 1432825.0, 'Issue Date': '08/31/2013'}, {'Revenue Today': 688440.0, 'Issue Date': '09/01/2013'}, {'Revenue Today': 479005.0, 'Issue Date': '09/02/2013'}, {'Revenue Today': 2643550.0, 'Issue Date': '09/03/2013'}, {'Revenue Today': 2655115.0, 'Issue Date': '09/04/2013'}, {'Revenue Today': 2589425.0, 'Issue Date': '09/05/2013'}, {'Revenue Today': 2550605.0, 'Issue Date': '09/06/2013'}, {'Revenue Today': 1634860.0, 'Issue Date': '09/07/2013'}, {'Revenue Today': 762575.0, 'Issue Date': '09/08/2013'}, {'Revenue Today': 2429270.0, 'Issue Date': '09/09/2013'}, {'Revenue Today': 2636630.0, 'Issue Date': '09/10/2013'}, {'Revenue Today': 2369180.0, 'Issue Date': '09/11/2013'}, {'Revenue Today': 2598610.0, 'Issue Date': '09/12/2013'}, {'Revenue Today': 2733880.0, 'Issue Date': '09/13/2013'}, {'Revenue Today': 1681325.0, 'Issue Date': '09/14/2013'}, {'Revenue Today': 777135.0, 'Issue Date': '09/15/2013'}, {'Revenue Today': 2461200.0, 'Issue Date': '09/16/2013'}, {'Revenue Today': 2775505.0, 'Issue Date': '09/17/2013'}, {'Revenue Today': 2695010.0, 'Issue Date': '09/18/2013'}, {'Revenue Today': 2575115.0, 'Issue Date': '09/19/2013'}, {'Revenue Today': 2568245.0, 'Issue Date': '09/20/2013'}, {'Revenue Today': 1775575.0, 'Issue Date': '09/21/2013'}, {'Revenue Today': 778530.0, 'Issue Date': '09/22/2013'}, {'Revenue Today': 2281055.0, 'Issue Date': '09/23/2013'}, {'Revenue Today': 2585675.0, 'Issue Date': '09/24/2013'}, {'Revenue Today': 2446645.0, 'Issue Date': '09/25/2013'}, {'Revenue Today': 2384820.0, 'Issue Date': '09/26/2013'}, {'Revenue Today': 2343235.0, 'Issue Date': '09/27/2013'}, {'Revenue Today': 1703090.0, 'Issue Date': '09/28/2013'}, {'Revenue Today': 784795.0, 'Issue Date': '09/29/2013'}, {'Revenue Today': 2686265.0, 'Issue Date': '09/30/2013'}, {'Revenue Today': 2930410.0, 'Issue Date': '10/01/2013'}, {'Revenue Today': 2730605.0, 'Issue Date': '10/02/2013'}, {'Revenue Today': 3014525.0, 'Issue Date': '10/03/2013'}, {'Revenue Today': 2836400.0, 'Issue Date': '10/04/2013'}, {'Revenue Today': 1759715.0, 'Issue Date': '10/05/2013'}, {'Revenue Today': 872130.0, 'Issue Date': '10/06/2013'}, {'Revenue Today': 2446330.0, 'Issue Date': '10/07/2013'}, {'Revenue Today': 3028565.0, 'Issue Date': '10/08/2013'}, {'Revenue Today': 2830245.0, 'Issue Date': '10/09/2013'}, {'Revenue Today': 2728955.0, 'Issue Date': '10/10/2013'}, {'Revenue Today': 2689065.0, 'Issue Date': '10/11/2013'}, {'Revenue Today': 1392415.0, 'Issue Date': '10/12/2013'}, {'Revenue Today': 621590.0, 'Issue Date': '10/13/2013'}, {'Revenue Today': 1553355.0, 'Issue Date': '10/14/2013'}, {'Revenue Today': 2355785.0, 'Issue Date': '10/15/2013'}, {'Revenue Today': 2299755.0, 'Issue Date': '10/16/2013'}, {'Revenue Today': 2619115.0, 'Issue Date': '10/17/2013'}, {'Revenue Today': 2758265.0, 'Issue Date': '10/18/2013'}, {'Revenue Today': 1668520.0, 'Issue Date': '10/19/2013'}, {'Revenue Today': 864810.0, 'Issue Date': '10/20/2013'}, {'Revenue Today': 2562250.0, 'Issue Date': '10/21/2013'}, {'Revenue Today': 2847820.0, 'Issue Date': '10/22/2013'}, {'Revenue Today': 2624925.0, 'Issue Date': '10/23/2013'}, {'Revenue Today': 2775060.0, 'Issue Date': '10/24/2013'}, {'Revenue Today': 2498685.0, 'Issue Date': '10/25/2013'}, {'Revenue Today': 1710575.0, 'Issue Date': '10/26/2013'}, {'Revenue Today': 859130.0, 'Issue Date': '10/27/2013'}, {'Revenue Today': 2560890.0, 'Issue Date': '10/28/2013'}, {'Revenue Today': 2821825.0, 'Issue Date': '10/29/2013'}, {'Revenue Today': 2575805.0, 'Issue Date': '10/30/2013'}, {'Revenue Today': 2470810.0, 'Issue Date': '10/31/2013'}, {'Revenue Today': 2455405.0, 'Issue Date': '11/01/2013'}, {'Revenue Today': 1664700.0, 'Issue Date': '11/02/2013'}, {'Revenue Today': 668905.0, 'Issue Date': '11/03/2013'}, {'Revenue Today': 2557830.0, 'Issue Date': '11/04/2013'}, {'Revenue Today': 1969855.0, 'Issue Date': '11/05/2013'}, {'Revenue Today': 2687030.0, 'Issue Date': '11/06/2013'}, {'Revenue Today': 2657620.0, 'Issue Date': '11/07/2013'}, {'Revenue Today': 2782750.0, 'Issue Date': '11/08/2013'}, {'Revenue Today': 1758855.0, 'Issue Date': '11/09/2013'}, {'Revenue Today': 835945.0, 'Issue Date': '11/10/2013'}, {'Revenue Today': 1710185.0, 'Issue Date': '11/11/2013'}, {'Revenue Today': 2656665.0, 'Issue Date': '11/12/2013'}, {'Revenue Today': 2624270.0, 'Issue Date': '11/13/2013'}, {'Revenue Today': 2863560.0, 'Issue Date': '11/14/2013'}, {'Revenue Today': 2764260.0, 'Issue Date': '11/15/2013'}, {'Revenue Today': 1614115.0, 'Issue Date': '11/16/2013'}, {'Revenue Today': 781085.0, 'Issue Date': '11/17/2013'}, {'Revenue Today': 2489115.0, 'Issue Date': '11/18/2013'}, {'Revenue Today': 2811890.0, 'Issue Date': '11/19/2013'}, {'Revenue Today': 2602065.0, 'Issue Date': '11/20/2013'}, {'Revenue Today': 2624470.0, 'Issue Date': '11/21/2013'}, {'Revenue Today': 2602505.0, 'Issue Date': '11/22/2013'}, {'Revenue Today': 1722150.0, 'Issue Date': '11/23/2013'}, {'Revenue Today': 776715.0, 'Issue Date': '11/24/2013'}, {'Revenue Today': 2393085.0, 'Issue Date': '11/25/2013'}, {'Revenue Today': 2486295.0, 'Issue Date': '11/26/2013'}, {'Revenue Today': 1678630.0, 'Issue Date': '11/27/2013'}, {'Revenue Today': 336175.0, 'Issue Date': '11/28/2013'}, {'Revenue Today': 2846270.0, 'Issue Date': '11/29/2013'}, {'Revenue Today': 1457985.0, 'Issue Date': '11/30/2013'}, {'Revenue Today': 747100.0, 'Issue Date': '12/01/2013'}, {'Revenue Today': 1988505.0, 'Issue Date': '12/02/2013'}, {'Revenue Today': 2390215.0, 'Issue Date': '12/03/2013'}, {'Revenue Today': 2196570.0, 'Issue Date': '12/04/2013'}, {'Revenue Today': 2307695.0, 'Issue Date': '12/05/2013'}, {'Revenue Today': 1867470.0, 'Issue Date': '12/06/2013'}, {'Revenue Today': 1494925.0, 'Issue Date': '12/07/2013'}, {'Revenue Today': 821335.0, 'Issue Date': '12/08/2013'}, {'Revenue Today': 1994805.0, 'Issue Date': '12/09/2013'}, {'Revenue Today': 1450660.0, 'Issue Date': '12/10/2013'}, {'Revenue Today': 2237950.0, 'Issue Date': '12/11/2013'}, {'Revenue Today': 2370305.0, 'Issue Date': '12/12/2013'}, {'Revenue Today': 2341680.0, 'Issue Date': '12/13/2013'}, {'Revenue Today': 903455.0, 'Issue Date': '12/14/2013'}, {'Revenue Today': 711865.0, 'Issue Date': '12/15/2013'}, {'Revenue Today': 2088605.0, 'Issue Date': '12/16/2013'}, {'Revenue Today': 1333515.0, 'Issue Date': '12/17/2013'}, {'Revenue Today': 2133415.0, 'Issue Date': '12/18/2013'}, {'Revenue Today': 2326915.0, 'Issue Date': '12/19/2013'}, {'Revenue Today': 2217130.0, 'Issue Date': '12/20/2013'}, {'Revenue Today': 1587360.0, 'Issue Date': '12/21/2013'}, {'Revenue Today': 773835.0, 'Issue Date': '12/22/2013'}, {'Revenue Today': 1761880.0, 'Issue Date': '12/23/2013'}, {'Revenue Today': 1961705.0, 'Issue Date': '12/24/2013'}, {'Revenue Today': 228065.0, 'Issue Date': '12/25/2013'}, {'Revenue Today': 2171320.0, 'Issue Date': '12/26/2013'}, {'Revenue Today': 2111065.0, 'Issue Date': '12/27/2013'}, {'Revenue Today': 1441355.0, 'Issue Date': '12/28/2013'}, {'Revenue Today': 600915.0, 'Issue Date': '12/29/2013'}, {'Revenue Today': 1970310.0, 'Issue Date': '12/30/2013'}, {'Revenue Today': 1841905.0, 'Issue Date': '12/31/2013'}, {'Revenue Today': 391355.0, 'Issue Date': '01/01/2014'}, {'Revenue Today': 1997315.0, 'Issue Date': '01/02/2014'}, {'Revenue Today': 107555.0, 'Issue Date': '01/03/2014'}, {'Revenue Today': 265555.0, 'Issue Date': '01/04/2014'}, {'Revenue Today': 313035.0, 'Issue Date': '01/05/2014'}, {'Revenue Today': 2189100.0, 'Issue Date': '01/06/2014'}, {'Revenue Today': 1856500.0, 'Issue Date': '01/07/2014'}, {'Revenue Today': 2336825.0, 'Issue Date': '01/08/2014'}, {'Revenue Today': 2710285.0, 'Issue Date': '01/09/2014'}, {'Revenue Today': 2294710.0, 'Issue Date': '01/10/2014'}, {'Revenue Today': 1642280.0, 'Issue Date': '01/11/2014'}, {'Revenue Today': 837330.0, 'Issue Date': '01/12/2014'}, {'Revenue Today': 2482945.0, 'Issue Date': '01/13/2014'}, {'Revenue Today': 2317140.0, 'Issue Date': '01/14/2014'}, {'Revenue Today': 2379070.0, 'Issue Date': '01/15/2014'}, {'Revenue Today': 2723800.0, 'Issue Date': '01/16/2014'}, {'Revenue Today': 2605245.0, 'Issue Date': '01/17/2014'}, {'Revenue Today': 1677250.0, 'Issue Date': '01/18/2014'}, {'Revenue Today': 771520.0, 'Issue Date': '01/19/2014'}, {'Revenue Today': 1834940.0, 'Issue Date': '01/20/2014'}, {'Revenue Today': 795885.0, 'Issue Date': '01/21/2014'}, {'Revenue Today': 342310.0, 'Issue Date': '01/22/2014'}, {'Revenue Today': 1508050.0, 'Issue Date': '01/23/2014'}, {'Revenue Today': 1893225.0, 'Issue Date': '01/24/2014'}, {'Revenue Today': 1201930.0, 'Issue Date': '01/25/2014'}, {'Revenue Today': 519885.0, 'Issue Date': '01/26/2014'}, {'Revenue Today': 1962850.0, 'Issue Date': '01/27/2014'}, {'Revenue Today': 2141345.0, 'Issue Date': '01/28/2014'}, {'Revenue Today': 226750.0, 'Issue Date': '01/29/2014'}, {'Revenue Today': 241200.0, 'Issue Date': '01/30/2014'}, {'Revenue Today': 223320.0, 'Issue Date': '01/31/2014'}, {'Revenue Today': 131500.0, 'Issue Date': '02/01/2014'}, {'Revenue Today': 128325.0, 'Issue Date': '02/02/2014'}, {'Revenue Today': 81745.0, 'Issue Date': '02/03/2014'}, {'Revenue Today': 217795.0, 'Issue Date': '02/04/2014'}, {'Revenue Today': 127820.0, 'Issue Date': '02/05/2014'}, {'Revenue Today': 229320.0, 'Issue Date': '02/06/2014'}, {'Revenue Today': 226285.0, 'Issue Date': '02/07/2014'}, {'Revenue Today': 129620.0, 'Issue Date': '02/08/2014'}, {'Revenue Today': 123750.0, 'Issue Date': '02/09/2014'}, {'Revenue Today': 155690.0, 'Issue Date': '02/10/2014'}, {'Revenue Today': 184775.0, 'Issue Date': '02/11/2014'}, {'Revenue Today': 212205.0, 'Issue Date': '02/12/2014'}, {'Revenue Today': 46585.0, 'Issue Date': '02/13/2014'}, {'Revenue Today': 85815.0, 'Issue Date': '02/14/2014'}, {'Revenue Today': 80775.0, 'Issue Date': '02/15/2014'}, {'Revenue Today': 64860.0, 'Issue Date': '02/16/2014'}, {'Revenue Today': 51850.0, 'Issue Date': '02/17/2014'}, {'Revenue Today': 19015.0, 'Issue Date': '02/18/2014'}, {'Revenue Today': 15570.0, 'Issue Date': '02/19/2014'}, {'Revenue Today': 6145.0, 'Issue Date': '02/20/2014'}, {'Revenue Today': 6100.0, 'Issue Date': '02/21/2014'}, {'Revenue Today': 175.0, 'Issue Date': '02/22/2014'}, {'Revenue Today': 390.0, 'Issue Date': '02/23/2014'}, {'Revenue Today': 5130.0, 'Issue Date': '02/24/2014'}, {'Revenue Today': 2000.0, 'Issue Date': '02/25/2014'}, {'Revenue Today': 180.0, 'Issue Date': '02/26/2014'}, {'Revenue Today': 95.0, 'Issue Date': '02/27/2014'}, {'Revenue Today': 1240.0, 'Issue Date': '02/28/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/01/2014'}, {'Revenue Today': 210.0, 'Issue Date': '03/02/2014'}, {'Revenue Today': 45.0, 'Issue Date': '03/03/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/04/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/05/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/06/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/08/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/09/2014'}, {'Revenue Today': 65.0, 'Issue Date': '03/10/2014'}, {'Revenue Today': 45.0, 'Issue Date': '03/13/2014'}, {'Revenue Today': 60.0, 'Issue Date': '03/14/2014'}, {'Revenue Today': 115.0, 'Issue Date': '03/17/2014'}, {'Revenue Today': 65.0, 'Issue Date': '04/01/2014'}, {'Revenue Today': 230.0, 'Issue Date': '04/02/2014'}, {'Revenue Today': 295.0, 'Issue Date': '04/04/2014'}, {'Revenue Today': 65.0, 'Issue Date': '04/05/2014'}, {'Revenue Today': 115.0, 'Issue Date': '04/06/2014'}, {'Revenue Today': 575.0, 'Issue Date': '04/07/2014'}, {'Revenue Today': 295.0, 'Issue Date': '04/08/2014'}, {'Revenue Today': 345.0, 'Issue Date': '04/10/2014'}, {'Revenue Today': 45.0, 'Issue Date': '04/11/2014'}, {'Revenue Today': 45.0, 'Issue Date': '04/14/2014'}, {'Revenue Today': 65.0, 'Issue Date': '04/16/2014'}, {'Revenue Today': 180.0, 'Issue Date': '04/17/2014'}, {'Revenue Today': 115.0, 'Issue Date': '04/23/2014'}, {'Revenue Today': 115.0, 'Issue Date': '04/25/2014'}, {'Revenue Today': 295.0, 'Issue Date': '04/27/2014'}, {'Revenue Today': 115.0, 'Issue Date': '04/29/2014'}, {'Revenue Today': 65.0, 'Issue Date': '05/02/2014'}, {'Revenue Today': 345.0, 'Issue Date': '05/04/2014'}, {'Revenue Today': 95.0, 'Issue Date': '05/12/2014'}, {'Revenue Today': 115.0, 'Issue Date': '05/13/2014'}, {'Revenue Today': 95.0, 'Issue Date': '05/15/2014'}, {'Revenue Today': 90.0, 'Issue Date': '05/16/2014'}, {'Revenue Today': 60.0, 'Issue Date': '05/18/2014'}, {'Revenue Today': 115.0, 'Issue Date': '05/19/2014'}, {'Revenue Today': 95.0, 'Issue Date': '05/22/2014'}, {'Revenue Today': 115.0, 'Issue Date': '05/26/2014'}, {'Revenue Today': 95.0, 'Issue Date': '05/29/2014'}, {'Revenue Today': 65.0, 'Issue Date': '05/30/2014'}, {'Revenue Today': 345.0, 'Issue Date': '05/31/2014'}, {'Revenue Today': 65.0, 'Issue Date': '06/04/2014'}, {'Revenue Today': 115.0, 'Issue Date': '06/06/2014'}, {'Revenue Today': 95.0, 'Issue Date': '06/07/2014'}, {'Revenue Today': 65.0, 'Issue Date': '06/14/2014'}, {'Revenue Today': 95.0, 'Issue Date': '06/22/2014'}, {'Revenue Today': 160.0, 'Issue Date': '06/30/2014'}, {'Revenue Today': 130.0, 'Issue Date': '07/01/2014'}, {'Revenue Today': 180.0, 'Issue Date': '07/02/2014'}, {'Revenue Today': 115.0, 'Issue Date': '07/03/2014'}, {'Revenue Today': 685.0, 'Issue Date': '07/04/2014'}, {'Revenue Today': 340.0, 'Issue Date': '07/05/2014'}, {'Revenue Today': 620.0, 'Issue Date': '07/06/2014'}, {'Revenue Today': 655.0, 'Issue Date': '07/07/2014'}, {'Revenue Today': 525.0, 'Issue Date': '07/08/2014'}, {'Revenue Today': 405.0, 'Issue Date': '07/09/2014'}, {'Revenue Today': 230.0, 'Issue Date': '07/10/2014'}, {'Revenue Today': 390.0, 'Issue Date': '07/11/2014'}, {'Revenue Today': 125.0, 'Issue Date': '07/12/2014'}, {'Revenue Today': 345.0, 'Issue Date': '07/13/2014'}, {'Revenue Today': 585.0, 'Issue Date': '07/14/2014'}, {'Revenue Today': 660.0, 'Issue Date': '07/15/2014'}, {'Revenue Today': 460.0, 'Issue Date': '07/16/2014'}, {'Revenue Today': 390.0, 'Issue Date': '07/17/2014'}, {'Revenue Today': 180.0, 'Issue Date': '07/18/2014'}, {'Revenue Today': 65.0, 'Issue Date': '07/19/2014'}, {'Revenue Today': 110.0, 'Issue Date': '07/20/2014'}, {'Revenue Today': 245.0, 'Issue Date': '07/21/2014'}, {'Revenue Today': 505.0, 'Issue Date': '07/22/2014'}, {'Revenue Today': 1640.0, 'Issue Date': '07/23/2014'}, {'Revenue Today': 345.0, 'Issue Date': '07/24/2014'}, {'Revenue Today': 65.0, 'Issue Date': '07/25/2014'}, {'Revenue Today': 230.0, 'Issue Date': '07/27/2014'}, {'Revenue Today': 45.0, 'Issue Date': '07/28/2014'}, {'Revenue Today': 180.0, 'Issue Date': '07/29/2014'}, {'Revenue Today': 610.0, 'Issue Date': '07/30/2014'}, {'Revenue Today': 575.0, 'Issue Date': '07/31/2014'}, {'Revenue Today': 570.0, 'Issue Date': '08/02/2014'}, {'Revenue Today': 645.0, 'Issue Date': '08/03/2014'}, {'Revenue Today': 180.0, 'Issue Date': '08/04/2014'}, {'Revenue Today': 210.0, 'Issue Date': '08/05/2014'}, {'Revenue Today': 160.0, 'Issue Date': '08/06/2014'}, {'Revenue Today': 495.0, 'Issue Date': '08/07/2014'}, {'Revenue Today': 245.0, 'Issue Date': '08/08/2014'}, {'Revenue Today': nan, 'Issue Date': '08/09/2014'}, {'Revenue Today': 130.0, 'Issue Date': '08/10/2014'}, {'Revenue Today': 640.0, 'Issue Date': '08/11/2014'}, {'Revenue Today': 315.0, 'Issue Date': '08/12/2014'}, {'Revenue Today': 620.0, 'Issue Date': '08/13/2014'}, {'Revenue Today': 1220.0, 'Issue Date': '08/14/2014'}, {'Revenue Today': 1225.0, 'Issue Date': '08/15/2014'}, {'Revenue Today': 700.0, 'Issue Date': '08/16/2014'}, {'Revenue Today': 290.0, 'Issue Date': '08/17/2014'}, {'Revenue Today': 245.0, 'Issue Date': '08/18/2014'}, {'Revenue Today': 355.0, 'Issue Date': '08/20/2014'}, {'Revenue Today': 210.0, 'Issue Date': '08/21/2014'}, {'Revenue Today': 115.0, 'Issue Date': '08/22/2014'}, {'Revenue Today': 960.0, 'Issue Date': '08/23/2014'}, {'Revenue Today': 165.0, 'Issue Date': '08/24/2014'}, {'Revenue Today': 115.0, 'Issue Date': '08/25/2014'}, {'Revenue Today': 325.0, 'Issue Date': '08/26/2014'}, {'Revenue Today': 195.0, 'Issue Date': '08/28/2014'}, {'Revenue Today': 290.0, 'Issue Date': '08/29/2014'}, {'Revenue Today': 710.0, 'Issue Date': '08/30/2014'}, {'Revenue Today': 320.0, 'Issue Date': '08/31/2014'}, {'Revenue Today': 130.0, 'Issue Date': '09/01/2014'}, {'Revenue Today': 125.0, 'Issue Date': '09/02/2014'}, {'Revenue Today': 810.0, 'Issue Date': '09/03/2014'}, {'Revenue Today': 595.0, 'Issue Date': '09/04/2014'}, {'Revenue Today': 180.0, 'Issue Date': '09/05/2014'}, {'Revenue Today': 240.0, 'Issue Date': '09/06/2014'}, {'Revenue Today': 545.0, 'Issue Date': '09/07/2014'}, {'Revenue Today': 820.0, 'Issue Date': '09/08/2014'}, {'Revenue Today': 680.0, 'Issue Date': '09/09/2014'}, {'Revenue Today': 115.0, 'Issue Date': '09/10/2014'}, {'Revenue Today': 230.0, 'Issue Date': '09/11/2014'}, {'Revenue Today': 270.0, 'Issue Date': '09/12/2014'}, {'Revenue Today': 275.0, 'Issue Date': '09/13/2014'}, {'Revenue Today': 1170.0, 'Issue Date': '09/14/2014'}, {'Revenue Today': 605.0, 'Issue Date': '09/15/2014'}, {'Revenue Today': 240.0, 'Issue Date': '09/16/2014'}, {'Revenue Today': 575.0, 'Issue Date': '09/17/2014'}, {'Revenue Today': 275.0, 'Issue Date': '09/18/2014'}, {'Revenue Today': 410.0, 'Issue Date': '09/19/2014'}, {'Revenue Today': 240.0, 'Issue Date': '09/20/2014'}, {'Revenue Today': 290.0, 'Issue Date': '09/21/2014'}, {'Revenue Today': 500.0, 'Issue Date': '09/22/2014'}, {'Revenue Today': 405.0, 'Issue Date': '09/23/2014'}, {'Revenue Today': 450.0, 'Issue Date': '09/24/2014'}, {'Revenue Today': 475.0, 'Issue Date': '09/25/2014'}, {'Revenue Today': 345.0, 'Issue Date': '09/26/2014'}, {'Revenue Today': 180.0, 'Issue Date': '09/27/2014'}, {'Revenue Today': 475.0, 'Issue Date': '09/28/2014'}, {'Revenue Today': 405.0, 'Issue Date': '09/29/2014'}, {'Revenue Today': 1395.0, 'Issue Date': '09/30/2014'}, {'Revenue Today': 615.0, 'Issue Date': '10/01/2014'}, {'Revenue Today': 230.0, 'Issue Date': '10/02/2014'}, {'Revenue Today': 1165.0, 'Issue Date': '10/03/2014'}, {'Revenue Today': 320.0, 'Issue Date': '10/04/2014'}, {'Revenue Today': 230.0, 'Issue Date': '10/05/2014'}, {'Revenue Today': 345.0, 'Issue Date': '10/06/2014'}, {'Revenue Today': 600.0, 'Issue Date': '10/07/2014'}, {'Revenue Today': 835.0, 'Issue Date': '10/08/2014'}, {'Revenue Today': 375.0, 'Issue Date': '10/09/2014'}, {'Revenue Today': 910.0, 'Issue Date': '10/10/2014'}, {'Revenue Today': 735.0, 'Issue Date': '10/11/2014'}, {'Revenue Today': 430.0, 'Issue Date': '10/12/2014'}, {'Revenue Today': 245.0, 'Issue Date': '10/13/2014'}, {'Revenue Today': 440.0, 'Issue Date': '10/14/2014'}, {'Revenue Today': 365.0, 'Issue Date': '10/15/2014'}, {'Revenue Today': 275.0, 'Issue Date': '10/16/2014'}, {'Revenue Today': 470.0, 'Issue Date': '10/17/2014'}, {'Revenue Today': 230.0, 'Issue Date': '10/18/2014'}, {'Revenue Today': 65.0, 'Issue Date': '10/19/2014'}, {'Revenue Today': 535.0, 'Issue Date': '10/20/2014'}, {'Revenue Today': 455.0, 'Issue Date': '10/21/2014'}, {'Revenue Today': 335.0, 'Issue Date': '10/22/2014'}, {'Revenue Today': 1885.0, 'Issue Date': '10/23/2014'}, {'Revenue Today': 185.0, 'Issue Date': '10/24/2014'}, {'Revenue Today': 345.0, 'Issue Date': '10/25/2014'}, {'Revenue Today': 290.0, 'Issue Date': '10/26/2014'}, {'Revenue Today': 215.0, 'Issue Date': '10/28/2014'}, {'Revenue Today': 430.0, 'Issue Date': '10/29/2014'}, {'Revenue Today': 345.0, 'Issue Date': '10/30/2014'}, {'Revenue Today': 505.0, 'Issue Date': '10/31/2014'}, {'Revenue Today': 1030.0, 'Issue Date': '11/01/2014'}, {'Revenue Today': 745.0, 'Issue Date': '11/02/2014'}, {'Revenue Today': 1355.0, 'Issue Date': '11/03/2014'}, {'Revenue Today': 175.0, 'Issue Date': '11/04/2014'}, {'Revenue Today': 345.0, 'Issue Date': '11/05/2014'}, {'Revenue Today': 320.0, 'Issue Date': '11/06/2014'}, {'Revenue Today': 1655.0, 'Issue Date': '11/07/2014'}, {'Revenue Today': 635.0, 'Issue Date': '11/08/2014'}, {'Revenue Today': 700.0, 'Issue Date': '11/09/2014'}, {'Revenue Today': 725.0, 'Issue Date': '11/10/2014'}, {'Revenue Today': 335.0, 'Issue Date': '11/11/2014'}, {'Revenue Today': 1345.0, 'Issue Date': '11/12/2014'}, {'Revenue Today': 1300.0, 'Issue Date': '11/13/2014'}, {'Revenue Today': 1545.0, 'Issue Date': '11/14/2014'}, {'Revenue Today': 2005.0, 'Issue Date': '11/15/2014'}, {'Revenue Today': 450.0, 'Issue Date': '11/16/2014'}, {'Revenue Today': 735.0, 'Issue Date': '11/17/2014'}, {'Revenue Today': 1330.0, 'Issue Date': '11/18/2014'}, {'Revenue Today': 595.0, 'Issue Date': '11/19/2014'}, {'Revenue Today': 680.0, 'Issue Date': '11/20/2014'}, {'Revenue Today': 1030.0, 'Issue Date': '11/21/2014'}, {'Revenue Today': 640.0, 'Issue Date': '11/22/2014'}, {'Revenue Today': 1100.0, 'Issue Date': '11/23/2014'}, {'Revenue Today': 645.0, 'Issue Date': '11/24/2014'}, {'Revenue Today': 750.0, 'Issue Date': '11/25/2014'}, {'Revenue Today': 345.0, 'Issue Date': '11/26/2014'}, {'Revenue Today': 320.0, 'Issue Date': '11/27/2014'}, {'Revenue Today': 695.0, 'Issue Date': '11/28/2014'}, {'Revenue Today': 1310.0, 'Issue Date': '11/29/2014'}, {'Revenue Today': 1685.0, 'Issue Date': '11/30/2014'}, {'Revenue Today': 450.0, 'Issue Date': '12/01/2014'}, {'Revenue Today': 685.0, 'Issue Date': '12/02/2014'}, {'Revenue Today': 570.0, 'Issue Date': '12/03/2014'}, {'Revenue Today': 1120.0, 'Issue Date': '12/04/2014'}, {'Revenue Today': 845.0, 'Issue Date': '12/05/2014'}, {'Revenue Today': 745.0, 'Issue Date': '12/06/2014'}, {'Revenue Today': 1330.0, 'Issue Date': '12/07/2014'}, {'Revenue Today': 410.0, 'Issue Date': '12/08/2014'}, {'Revenue Today': 360.0, 'Issue Date': '12/09/2014'}, {'Revenue Today': 1060.0, 'Issue Date': '12/10/2014'}, {'Revenue Today': 1755.0, 'Issue Date': '12/11/2014'}, {'Revenue Today': 635.0, 'Issue Date': '12/12/2014'}, {'Revenue Today': 2210.0, 'Issue Date': '12/13/2014'}, {'Revenue Today': 1175.0, 'Issue Date': '12/14/2014'}, {'Revenue Today': 690.0, 'Issue Date': '12/15/2014'}, {'Revenue Today': 570.0, 'Issue Date': '12/16/2014'}, {'Revenue Today': 405.0, 'Issue Date': '12/17/2014'}, {'Revenue Today': 390.0, 'Issue Date': '12/18/2014'}, {'Revenue Today': 585.0, 'Issue Date': '12/19/2014'}, {'Revenue Today': 565.0, 'Issue Date': '12/20/2014'}, {'Revenue Today': 480.0, 'Issue Date': '12/21/2014'}, {'Revenue Today': 665.0, 'Issue Date': '12/22/2014'}, {'Revenue Today': 1125.0, 'Issue Date': '12/23/2014'}, {'Revenue Today': 445.0, 'Issue Date': '12/24/2014'}, {'Revenue Today': 225.0, 'Issue Date': '12/25/2014'}, {'Revenue Today': 340.0, 'Issue Date': '12/26/2014'}, {'Revenue Today': 845.0, 'Issue Date': '12/27/2014'}, {'Revenue Today': 345.0, 'Issue Date': '12/28/2014'}, {'Revenue Today': 475.0, 'Issue Date': '12/29/2014'}, {'Revenue Today': 1000.0, 'Issue Date': '12/30/2014'}, {'Revenue Today': 765.0, 'Issue Date': '12/31/2014'}, {'Revenue Today': 295.0, 'Issue Date': '01/01/2015'}, {'Revenue Today': 225.0, 'Issue Date': '01/02/2015'}, {'Revenue Today': 455.0, 'Issue Date': '01/04/2015'}, {'Revenue Today': 295.0, 'Issue Date': '01/05/2015'}, {'Revenue Today': 115.0, 'Issue Date': '01/06/2015'}, {'Revenue Today': 535.0, 'Issue Date': '01/07/2015'}, {'Revenue Today': 275.0, 'Issue Date': '01/09/2015'}, {'Revenue Today': 755.0, 'Issue Date': '01/10/2015'}, {'Revenue Today': 525.0, 'Issue Date': '01/11/2015'}, {'Revenue Today': 165.0, 'Issue Date': '01/12/2015'}, {'Revenue Today': 295.0, 'Issue Date': '01/13/2015'}, {'Revenue Today': 590.0, 'Issue Date': '01/14/2015'}, {'Revenue Today': 1045.0, 'Issue Date': '01/15/2015'}, {'Revenue Today': 1305.0, 'Issue Date': '01/16/2015'}, {'Revenue Today': 225.0, 'Issue Date': '01/17/2015'}, {'Revenue Today': 275.0, 'Issue Date': '01/18/2015'}, {'Revenue Today': 230.0, 'Issue Date': '01/20/2015'}, {'Revenue Today': 65.0, 'Issue Date': '01/22/2015'}, {'Revenue Today': 575.0, 'Issue Date': '01/23/2015'}, {'Revenue Today': 585.0, 'Issue Date': '01/24/2015'}, {'Revenue Today': 345.0, 'Issue Date': '01/25/2015'}, {'Revenue Today': 620.0, 'Issue Date': '01/27/2015'}, {'Revenue Today': 45.0, 'Issue Date': '01/28/2015'}, {'Revenue Today': 115.0, 'Issue Date': '01/29/2015'}, {'Revenue Today': 430.0, 'Issue Date': '01/30/2015'}, {'Revenue Today': 345.0, 'Issue Date': '01/31/2015'}, {'Revenue Today': 345.0, 'Issue Date': '02/01/2015'}, {'Revenue Today': 95.0, 'Issue Date': '02/02/2015'}, {'Revenue Today': 510.0, 'Issue Date': '02/03/2015'}, {'Revenue Today': 475.0, 'Issue Date': '02/04/2015'}, {'Revenue Today': 210.0, 'Issue Date': '02/05/2015'}, {'Revenue Today': 230.0, 'Issue Date': '02/06/2015'}, {'Revenue Today': 180.0, 'Issue Date': '02/07/2015'}, {'Revenue Today': 210.0, 'Issue Date': '02/08/2015'}, {'Revenue Today': 65.0, 'Issue Date': '02/10/2015'}, {'Revenue Today': 115.0, 'Issue Date': '02/11/2015'}, {'Revenue Today': 460.0, 'Issue Date': '02/12/2015'}, {'Revenue Today': 160.0, 'Issue Date': '02/13/2015'}, {'Revenue Today': 115.0, 'Issue Date': '02/14/2015'}, {'Revenue Today': 420.0, 'Issue Date': '02/16/2015'}, {'Revenue Today': 115.0, 'Issue Date': '02/27/2015'}, {'Revenue Today': 115.0, 'Issue Date': '03/20/2015'}, {'Revenue Today': 115.0, 'Issue Date': '04/09/2015'}, {'Revenue Today': 95.0, 'Issue Date': '05/10/2015'}, {'Revenue Today': 65.0, 'Issue Date': '05/12/2015'}, {'Revenue Today': 115.0, 'Issue Date': '06/18/2015'}, {'Revenue Today': 175.0, 'Issue Date': '06/25/2015'}, {'Revenue Today': 95.0, 'Issue Date': '06/26/2015'}, {'Revenue Today': 115.0, 'Issue Date': '06/30/2015'}, {'Revenue Today': 65.0, 'Issue Date': '07/01/2015'}, {'Revenue Today': 180.0, 'Issue Date': '07/02/2015'}, {'Revenue Today': 65.0, 'Issue Date': '07/06/2015'}, {'Revenue Today': 115.0, 'Issue Date': '07/07/2015'}, {'Revenue Today': 115.0, 'Issue Date': '07/11/2015'}, {'Revenue Today': 230.0, 'Issue Date': '07/13/2015'}, {'Revenue Today': 115.0, 'Issue Date': '07/14/2015'}, {'Revenue Today': 115.0, 'Issue Date': '07/15/2015'}, {'Revenue Today': 460.0, 'Issue Date': '07/16/2015'}, {'Revenue Today': 205.0, 'Issue Date': '07/17/2015'}, {'Revenue Today': 65.0, 'Issue Date': '07/20/2015'}, {'Revenue Today': 510.0, 'Issue Date': '07/22/2015'}, {'Revenue Today': 655.0, 'Issue Date': '07/23/2015'}, {'Revenue Today': 300.0, 'Issue Date': '07/24/2015'}, {'Revenue Today': 230.0, 'Issue Date': '07/25/2015'}, {'Revenue Today': 115.0, 'Issue Date': '07/26/2015'}, {'Revenue Today': 320.0, 'Issue Date': '07/27/2015'}, {'Revenue Today': 230.0, 'Issue Date': '07/29/2015'}, {'Revenue Today': 610.0, 'Issue Date': '07/30/2015'}, {'Revenue Today': 390.0, 'Issue Date': '07/31/2015'}, {'Revenue Today': 115.0, 'Issue Date': '08/01/2015'}, {'Revenue Today': 490.0, 'Issue Date': '08/02/2015'}, {'Revenue Today': 295.0, 'Issue Date': '08/03/2015'}, {'Revenue Today': 275.0, 'Issue Date': '08/04/2015'}, {'Revenue Today': 340.0, 'Issue Date': '08/05/2015'}, {'Revenue Today': 575.0, 'Issue Date': '08/06/2015'}, {'Revenue Today': 230.0, 'Issue Date': '08/07/2015'}, {'Revenue Today': 65.0, 'Issue Date': '08/10/2015'}, {'Revenue Today': 165.0, 'Issue Date': '08/11/2015'}, {'Revenue Today': 45.0, 'Issue Date': '08/12/2015'}, {'Revenue Today': 230.0, 'Issue Date': '08/13/2015'}, {'Revenue Today': 520.0, 'Issue Date': '08/14/2015'}, {'Revenue Today': 345.0, 'Issue Date': '08/15/2015'}, {'Revenue Today': 640.0, 'Issue Date': '08/16/2015'}, {'Revenue Today': 230.0, 'Issue Date': '08/17/2015'}, {'Revenue Today': 505.0, 'Issue Date': '08/18/2015'}, {'Revenue Today': 115.0, 'Issue Date': '08/19/2015'}, {'Revenue Today': nan, 'Issue Date': '08/21/2015'}, {'Revenue Today': 230.0, 'Issue Date': '08/22/2015'}, {'Revenue Today': 290.0, 'Issue Date': '08/23/2015'}, {'Revenue Today': 230.0, 'Issue Date': '08/24/2015'}, {'Revenue Today': 115.0, 'Issue Date': '08/25/2015'}, {'Revenue Today': 115.0, 'Issue Date': '08/26/2015'}, {'Revenue Today': 180.0, 'Issue Date': '08/27/2015'}, {'Revenue Today': 220.0, 'Issue Date': '08/28/2015'}, {'Revenue Today': 780.0, 'Issue Date': '08/30/2015'}, {'Revenue Today': 1035.0, 'Issue Date': '08/31/2015'}, {'Revenue Today': 295.0, 'Issue Date': '09/01/2015'}, {'Revenue Today': 180.0, 'Issue Date': '09/02/2015'}, {'Revenue Today': 585.0, 'Issue Date': '09/03/2015'}, {'Revenue Today': 215.0, 'Issue Date': '09/04/2015'}, {'Revenue Today': 430.0, 'Issue Date': '09/05/2015'}, {'Revenue Today': 180.0, 'Issue Date': '09/06/2015'}, {'Revenue Today': 180.0, 'Issue Date': '09/07/2015'}, {'Revenue Today': 335.0, 'Issue Date': '09/08/2015'}, {'Revenue Today': 455.0, 'Issue Date': '09/09/2015'}, {'Revenue Today': 345.0, 'Issue Date': '09/10/2015'}, {'Revenue Today': 65.0, 'Issue Date': '09/11/2015'}, {'Revenue Today': 245.0, 'Issue Date': '09/12/2015'}, {'Revenue Today': 225.0, 'Issue Date': '09/13/2015'}, {'Revenue Today': 230.0, 'Issue Date': '09/14/2015'}, {'Revenue Today': 695.0, 'Issue Date': '09/15/2015'}, {'Revenue Today': 295.0, 'Issue Date': '09/16/2015'}, {'Revenue Today': 345.0, 'Issue Date': '09/17/2015'}, {'Revenue Today': 455.0, 'Issue Date': '09/18/2015'}, {'Revenue Today': 295.0, 'Issue Date': '09/20/2015'}, {'Revenue Today': 210.0, 'Issue Date': '09/21/2015'}, {'Revenue Today': 470.0, 'Issue Date': '09/22/2015'}, {'Revenue Today': 240.0, 'Issue Date': '09/23/2015'}, {'Revenue Today': 160.0, 'Issue Date': '09/24/2015'}, {'Revenue Today': 140.0, 'Issue Date': '09/25/2015'}, {'Revenue Today': 45.0, 'Issue Date': '09/26/2015'}, {'Revenue Today': 390.0, 'Issue Date': '09/27/2015'}, {'Revenue Today': 325.0, 'Issue Date': '09/28/2015'}, {'Revenue Today': 540.0, 'Issue Date': '09/30/2015'}, {'Revenue Today': 360.0, 'Issue Date': '10/01/2015'}, {'Revenue Today': 305.0, 'Issue Date': '10/02/2015'}, {'Revenue Today': 920.0, 'Issue Date': '10/03/2015'}, {'Revenue Today': 405.0, 'Issue Date': '10/04/2015'}, {'Revenue Today': 510.0, 'Issue Date': '10/05/2015'}, {'Revenue Today': 410.0, 'Issue Date': '10/06/2015'}, {'Revenue Today': 160.0, 'Issue Date': '10/07/2015'}, {'Revenue Today': 320.0, 'Issue Date': '10/08/2015'}, {'Revenue Today': 180.0, 'Issue Date': '10/09/2015'}, {'Revenue Today': 405.0, 'Issue Date': '10/10/2015'}, {'Revenue Today': 555.0, 'Issue Date': '10/11/2015'}, {'Revenue Today': 230.0, 'Issue Date': '10/12/2015'}, {'Revenue Today': 295.0, 'Issue Date': '10/13/2015'}, {'Revenue Today': 475.0, 'Issue Date': '10/14/2015'}, {'Revenue Today': 115.0, 'Issue Date': '10/15/2015'}, {'Revenue Today': 640.0, 'Issue Date': '10/16/2015'}, {'Revenue Today': 755.0, 'Issue Date': '10/17/2015'}, {'Revenue Today': 150.0, 'Issue Date': '10/18/2015'}, {'Revenue Today': 555.0, 'Issue Date': '10/19/2015'}, {'Revenue Today': 225.0, 'Issue Date': '10/20/2015'}, {'Revenue Today': 325.0, 'Issue Date': '10/21/2015'}, {'Revenue Today': 445.0, 'Issue Date': '10/22/2015'}, {'Revenue Today': 225.0, 'Issue Date': '10/23/2015'}, {'Revenue Today': 410.0, 'Issue Date': '10/24/2015'}, {'Revenue Today': 115.0, 'Issue Date': '10/25/2015'}, {'Revenue Today': 35.0, 'Issue Date': '10/26/2015'}, {'Revenue Today': 465.0, 'Issue Date': '10/27/2015'}, {'Revenue Today': 700.0, 'Issue Date': '10/28/2015'}, {'Revenue Today': 295.0, 'Issue Date': '10/29/2015'}, {'Revenue Today': 45.0, 'Issue Date': '10/30/2015'}, {'Revenue Today': 620.0, 'Issue Date': '10/31/2015'}, {'Revenue Today': 590.0, 'Issue Date': '11/01/2015'}, {'Revenue Today': 395.0, 'Issue Date': '11/02/2015'}, {'Revenue Today': 210.0, 'Issue Date': '11/03/2015'}, {'Revenue Today': 445.0, 'Issue Date': '11/04/2015'}, {'Revenue Today': 275.0, 'Issue Date': '11/06/2015'}, {'Revenue Today': 345.0, 'Issue Date': '11/07/2015'}, {'Revenue Today': 285.0, 'Issue Date': '11/08/2015'}, {'Revenue Today': 45.0, 'Issue Date': '11/09/2015'}, {'Revenue Today': 115.0, 'Issue Date': '11/10/2015'}, {'Revenue Today': 175.0, 'Issue Date': '11/11/2015'}, {'Revenue Today': 180.0, 'Issue Date': '11/12/2015'}, {'Revenue Today': 275.0, 'Issue Date': '11/13/2015'}, {'Revenue Today': 395.0, 'Issue Date': '11/14/2015'}, {'Revenue Today': 300.0, 'Issue Date': '11/15/2015'}, {'Revenue Today': 225.0, 'Issue Date': '11/16/2015'}, {'Revenue Today': 65.0, 'Issue Date': '11/17/2015'}, {'Revenue Today': 65.0, 'Issue Date': '11/18/2015'}, {'Revenue Today': 265.0, 'Issue Date': '11/19/2015'}, {'Revenue Today': 115.0, 'Issue Date': '11/20/2015'}, {'Revenue Today': 105.0, 'Issue Date': '11/21/2015'}, {'Revenue Today': 575.0, 'Issue Date': '11/22/2015'}, {'Revenue Today': 525.0, 'Issue Date': '11/23/2015'}, {'Revenue Today': 115.0, 'Issue Date': '11/24/2015'}, {'Revenue Today': 175.0, 'Issue Date': '11/25/2015'}, {'Revenue Today': 275.0, 'Issue Date': '11/26/2015'}, {'Revenue Today': 355.0, 'Issue Date': '11/27/2015'}, {'Revenue Today': 45.0, 'Issue Date': '11/29/2015'}, {'Revenue Today': 240.0, 'Issue Date': '11/30/2015'}, {'Revenue Today': 295.0, 'Issue Date': '12/01/2015'}, {'Revenue Today': 295.0, 'Issue Date': '12/02/2015'}, {'Revenue Today': 335.0, 'Issue Date': '12/03/2015'}, {'Revenue Today': 65.0, 'Issue Date': '12/04/2015'}, {'Revenue Today': 230.0, 'Issue Date': '12/05/2015'}, {'Revenue Today': 290.0, 'Issue Date': '12/06/2015'}, {'Revenue Today': 115.0, 'Issue Date': '12/07/2015'}, {'Revenue Today': 65.0, 'Issue Date': '12/08/2015'}, {'Revenue Today': 385.0, 'Issue Date': '12/09/2015'}, {'Revenue Today': 295.0, 'Issue Date': '12/11/2015'}, {'Revenue Today': 295.0, 'Issue Date': '12/12/2015'}, {'Revenue Today': 355.0, 'Issue Date': '12/13/2015'}, {'Revenue Today': 690.0, 'Issue Date': '12/14/2015'}, {'Revenue Today': 880.0, 'Issue Date': '12/15/2015'}, {'Revenue Today': 285.0, 'Issue Date': '12/16/2015'}, {'Revenue Today': 115.0, 'Issue Date': '12/17/2015'}, {'Revenue Today': 575.0, 'Issue Date': '12/19/2015'}, {'Revenue Today': 540.0, 'Issue Date': '12/20/2015'}, {'Revenue Today': 290.0, 'Issue Date': '12/21/2015'}, {'Revenue Today': 115.0, 'Issue Date': '12/22/2015'}, {'Revenue Today': 490.0, 'Issue Date': '12/23/2015'}, {'Revenue Today': 115.0, 'Issue Date': '12/25/2015'}, {'Revenue Today': 90.0, 'Issue Date': '12/26/2015'}, {'Revenue Today': 95.0, 'Issue Date': '12/27/2015'}, {'Revenue Today': 210.0, 'Issue Date': '12/28/2015'}, {'Revenue Today': 565.0, 'Issue Date': '12/30/2015'}, {'Revenue Today': 175.0, 'Issue Date': '12/31/2015'}, {'Revenue Today': 180.0, 'Issue Date': '01/05/2016'}, {'Revenue Today': 230.0, 'Issue Date': '01/07/2016'}, {'Revenue Today': 115.0, 'Issue Date': '01/09/2016'}, {'Revenue Today': 345.0, 'Issue Date': '01/10/2016'}, {'Revenue Today': 65.0, 'Issue Date': '01/11/2016'}, {'Revenue Today': 230.0, 'Issue Date': '01/12/2016'}, {'Revenue Today': 115.0, 'Issue Date': '01/13/2016'}, {'Revenue Today': 160.0, 'Issue Date': '01/14/2016'}, {'Revenue Today': 115.0, 'Issue Date': '01/16/2016'}, {'Revenue Today': 180.0, 'Issue Date': '01/17/2016'}, {'Revenue Today': 60.0, 'Issue Date': '01/20/2016'}, {'Revenue Today': 115.0, 'Issue Date': '01/23/2016'}, {'Revenue Today': 230.0, 'Issue Date': '01/24/2016'}, {'Revenue Today': 115.0, 'Issue Date': '01/27/2016'}, {'Revenue Today': 115.0, 'Issue Date': '01/29/2016'}, {'Revenue Today': 115.0, 'Issue Date': '02/01/2016'}, {'Revenue Today': 230.0, 'Issue Date': '02/04/2016'}, {'Revenue Today': 115.0, 'Issue Date': '02/18/2016'}, {'Revenue Today': 115.0, 'Issue Date': '07/16/2016'}, {'Revenue Today': 65.0, 'Issue Date': '08/03/2016'}, {'Revenue Today': 65.0, 'Issue Date': '08/05/2016'}, {'Revenue Today': 210.0, 'Issue Date': '08/07/2016'}, {'Revenue Today': 555.0, 'Issue Date': '08/08/2016'}, {'Revenue Today': 115.0, 'Issue Date': '08/13/2016'}, {'Revenue Today': 230.0, 'Issue Date': '08/14/2016'}, {'Revenue Today': 180.0, 'Issue Date': '08/15/2016'}, {'Revenue Today': 45.0, 'Issue Date': '08/16/2016'}, {'Revenue Today': 105.0, 'Issue Date': '08/17/2016'}, {'Revenue Today': 115.0, 'Issue Date': '08/19/2016'}, {'Revenue Today': 115.0, 'Issue Date': '08/20/2016'}, {'Revenue Today': 115.0, 'Issue Date': '08/25/2016'}, {'Revenue Today': 115.0, 'Issue Date': '08/26/2016'}, {'Revenue Today': 45.0, 'Issue Date': '08/27/2016'}, {'Revenue Today': 65.0, 'Issue Date': '09/01/2016'}, {'Revenue Today': 65.0, 'Issue Date': '09/13/2016'}, {'Revenue Today': 90.0, 'Issue Date': '09/17/2016'}, {'Revenue Today': 60.0, 'Issue Date': '09/22/2016'}, {'Revenue Today': 165.0, 'Issue Date': '09/24/2016'}, {'Revenue Today': 60.0, 'Issue Date': '09/25/2016'}, {'Revenue Today': 95.0, 'Issue Date': '09/26/2016'}, {'Revenue Today': 115.0, 'Issue Date': '10/04/2016'}, {'Revenue Today': 95.0, 'Issue Date': '10/09/2016'}, {'Revenue Today': 115.0, 'Issue Date': '10/13/2016'}, {'Revenue Today': 160.0, 'Issue Date': '10/15/2016'}, {'Revenue Today': 115.0, 'Issue Date': '10/16/2016'}, {'Revenue Today': 115.0, 'Issue Date': '10/17/2016'}, {'Revenue Today': 115.0, 'Issue Date': '10/18/2016'}, {'Revenue Today': 115.0, 'Issue Date': '10/23/2016'}, {'Revenue Today': 95.0, 'Issue Date': '10/27/2016'}, {'Revenue Today': 115.0, 'Issue Date': '11/03/2016'}, {'Revenue Today': 65.0, 'Issue Date': '11/05/2016'}, {'Revenue Today': 45.0, 'Issue Date': '11/07/2016'}, {'Revenue Today': 45.0, 'Issue Date': '11/14/2016'}, {'Revenue Today': 210.0, 'Issue Date': '11/15/2016'}, {'Revenue Today': 65.0, 'Issue Date': '11/16/2016'}, {'Revenue Today': 180.0, 'Issue Date': '11/17/2016'}, {'Revenue Today': 60.0, 'Issue Date': '11/19/2016'}, {'Revenue Today': 115.0, 'Issue Date': '11/23/2016'}, {'Revenue Today': 45.0, 'Issue Date': '11/25/2016'}, {'Revenue Today': 125.0, 'Issue Date': '11/27/2016'}, {'Revenue Today': 115.0, 'Issue Date': '12/05/2016'}, {'Revenue Today': 115.0, 'Issue Date': '12/10/2016'}, {'Revenue Today': 65.0, 'Issue Date': '12/11/2016'}, {'Revenue Today': 45.0, 'Issue Date': '12/13/2016'}, {'Revenue Today': 210.0, 'Issue Date': '12/17/2016'}, {'Revenue Today': 115.0, 'Issue Date': '12/18/2016'}, {'Revenue Today': 65.0, 'Issue Date': '12/19/2016'}, {'Revenue Today': 45.0, 'Issue Date': '12/23/2016'}, {'Revenue Today': 65.0, 'Issue Date': '01/01/2017'}, {'Revenue Today': 60.0, 'Issue Date': '01/03/2017'}, {'Revenue Today': 230.0, 'Issue Date': '01/04/2017'}, {'Revenue Today': 95.0, 'Issue Date': '01/05/2017'}, {'Revenue Today': 45.0, 'Issue Date': '01/07/2017'}, {'Revenue Today': 180.0, 'Issue Date': '01/09/2017'}, {'Revenue Today': 160.0, 'Issue Date': '01/10/2017'}, {'Revenue Today': 65.0, 'Issue Date': '01/11/2017'}, {'Revenue Today': 115.0, 'Issue Date': '01/13/2017'}, {'Revenue Today': 115.0, 'Issue Date': '01/14/2017'}, {'Revenue Today': 45.0, 'Issue Date': '01/15/2017'}, {'Revenue Today': 160.0, 'Issue Date': '01/16/2017'}, {'Revenue Today': 115.0, 'Issue Date': '01/18/2017'}, {'Revenue Today': 65.0, 'Issue Date': '01/19/2017'}, {'Revenue Today': 115.0, 'Issue Date': '01/24/2017'}, {'Revenue Today': 65.0, 'Issue Date': '01/26/2017'}, {'Revenue Today': 115.0, 'Issue Date': '01/27/2017'}, {'Revenue Today': 305.0, 'Issue Date': '01/28/2017'}, {'Revenue Today': 95.0, 'Issue Date': '02/03/2017'}, {'Revenue Today': 115.0, 'Issue Date': '02/04/2017'}, {'Revenue Today': 115.0, 'Issue Date': '02/05/2017'}, {'Revenue Today': 115.0, 'Issue Date': '02/06/2017'}, {'Revenue Today': 115.0, 'Issue Date': '02/07/2017'}, {'Revenue Today': 115.0, 'Issue Date': '02/08/2017'}, {'Revenue Today': 160.0, 'Issue Date': '02/11/2017'}, {'Revenue Today': 115.0, 'Issue Date': '02/14/2017'}, {'Revenue Today': 160.0, 'Issue Date': '02/16/2017'}, {'Revenue Today': 65.0, 'Issue Date': '04/07/2017'}, {'Revenue Today': 95.0, 'Issue Date': '07/07/2017'}, {'Revenue Today': 115.0, 'Issue Date': '07/15/2017'}, {'Revenue Today': 115.0, 'Issue Date': '07/17/2017'}, {'Revenue Today': 130.0, 'Issue Date': '07/18/2017'}, {'Revenue Today': 160.0, 'Issue Date': '07/24/2017'}, {'Revenue Today': 230.0, 'Issue Date': '07/30/2017'}, {'Revenue Today': 65.0, 'Issue Date': '08/01/2017'}, {'Revenue Today': 180.0, 'Issue Date': '08/03/2017'}, {'Revenue Today': 60.0, 'Issue Date': '08/04/2017'}, {'Revenue Today': 110.0, 'Issue Date': '08/05/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/06/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/14/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/15/2017'}, {'Revenue Today': 340.0, 'Issue Date': '08/16/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/17/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/19/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/21/2017'}, {'Revenue Today': 65.0, 'Issue Date': '08/27/2017'}, {'Revenue Today': 115.0, 'Issue Date': '08/28/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/06/2017'}, {'Revenue Today': 295.0, 'Issue Date': '09/08/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/15/2017'}, {'Revenue Today': 230.0, 'Issue Date': '09/16/2017'}, {'Revenue Today': 45.0, 'Issue Date': '09/17/2017'}, {'Revenue Today': 180.0, 'Issue Date': '09/18/2017'}, {'Revenue Today': 230.0, 'Issue Date': '09/20/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/21/2017'}, {'Revenue Today': 65.0, 'Issue Date': '09/22/2017'}, {'Revenue Today': 160.0, 'Issue Date': '09/23/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/24/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/25/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/26/2017'}, {'Revenue Today': 115.0, 'Issue Date': '09/27/2017'}, {'Revenue Today': 60.0, 'Issue Date': '09/28/2017'}, {'Revenue Today': 65.0, 'Issue Date': '09/30/2017'}, {'Revenue Today': 45.0, 'Issue Date': '10/03/2017'}, {'Revenue Today': 220.0, 'Issue Date': '10/08/2017'}, {'Revenue Today': 345.0, 'Issue Date': '10/10/2017'}, {'Revenue Today': 65.0, 'Issue Date': '10/11/2017'}, {'Revenue Today': 65.0, 'Issue Date': '10/12/2017'}, {'Revenue Today': 115.0, 'Issue Date': '10/15/2017'}, {'Revenue Today': 540.0, 'Issue Date': '10/16/2017'}, {'Revenue Today': 345.0, 'Issue Date': '10/18/2017'}, {'Revenue Today': 115.0, 'Issue Date': '10/22/2017'}, {'Revenue Today': 45.0, 'Issue Date': '10/24/2017'}, {'Revenue Today': 230.0, 'Issue Date': '10/28/2017'}, {'Revenue Today': 230.0, 'Issue Date': '10/31/2017'}, {'Revenue Today': 60.0, 'Issue Date': '11/05/2017'}, {'Revenue Today': 115.0, 'Issue Date': '11/09/2017'}, {'Revenue Today': 95.0, 'Issue Date': '11/13/2017'}, {'Revenue Today': 115.0, 'Issue Date': '11/14/2017'}, {'Revenue Today': 115.0, 'Issue Date': '11/15/2017'}, {'Revenue Today': 240.0, 'Issue Date': '11/16/2017'}, {'Revenue Today': 115.0, 'Issue Date': '11/18/2017'}, {'Revenue Today': 295.0, 'Issue Date': '11/19/2017'}, {'Revenue Today': 230.0, 'Issue Date': '11/21/2017'}, {'Revenue Today': 330.0, 'Issue Date': '11/23/2017'}, {'Revenue Today': 65.0, 'Issue Date': '11/24/2017'}, {'Revenue Today': 205.0, 'Issue Date': '11/27/2017'}, {'Revenue Today': 275.0, 'Issue Date': '11/30/2017'}, {'Revenue Today': 60.0, 'Issue Date': '12/01/2017'}, {'Revenue Today': 180.0, 'Issue Date': '12/05/2017'}, {'Revenue Today': 65.0, 'Issue Date': '12/08/2017'}, {'Revenue Today': 115.0, 'Issue Date': '12/11/2017'}, {'Revenue Today': 160.0, 'Issue Date': '12/13/2017'}, {'Revenue Today': 575.0, 'Issue Date': '12/16/2017'}, {'Revenue Today': 65.0, 'Issue Date': '12/18/2017'}, {'Revenue Today': 35.0, 'Issue Date': '12/20/2017'}, {'Revenue Today': 95.0, 'Issue Date': '12/21/2017'}, {'Revenue Today': 180.0, 'Issue Date': '12/22/2017'}, {'Revenue Today': 115.0, 'Issue Date': '01/01/2018'}, {'Revenue Today': 115.0, 'Issue Date': '01/02/2018'}, {'Revenue Today': 115.0, 'Issue Date': '01/03/2018'}, {'Revenue Today': 95.0, 'Issue Date': '01/04/2018'}, {'Revenue Today': 65.0, 'Issue Date': '01/05/2018'}, {'Revenue Today': 230.0, 'Issue Date': '01/07/2018'}, {'Revenue Today': 275.0, 'Issue Date': '01/10/2018'}, {'Revenue Today': 65.0, 'Issue Date': '01/15/2018'}, {'Revenue Today': 45.0, 'Issue Date': '01/16/2018'}, {'Revenue Today': 275.0, 'Issue Date': '01/17/2018'}, {'Revenue Today': 115.0, 'Issue Date': '01/19/2018'}, {'Revenue Today': 115.0, 'Issue Date': '01/23/2018'}, {'Revenue Today': 115.0, 'Issue Date': '01/26/2018'}, {'Revenue Today': 95.0, 'Issue Date': '01/27/2018'}, {'Revenue Today': 115.0, 'Issue Date': '01/29/2018'}, {'Revenue Today': 65.0, 'Issue Date': '01/30/2018'}, {'Revenue Today': 230.0, 'Issue Date': '02/08/2018'}, {'Revenue Today': 115.0, 'Issue Date': '02/14/2018'}, {'Revenue Today': 115.0, 'Issue Date': '02/17/2018'}, {'Revenue Today': 345.0, 'Issue Date': '07/17/2018'}, {'Revenue Today': 65.0, 'Issue Date': '07/23/2018'}, {'Revenue Today': 230.0, 'Issue Date': '07/24/2018'}, {'Revenue Today': 115.0, 'Issue Date': '07/29/2018'}, {'Revenue Today': 115.0, 'Issue Date': '07/31/2018'}, {'Revenue Today': 115.0, 'Issue Date': '08/06/2018'}, {'Revenue Today': 65.0, 'Issue Date': '08/14/2018'}, {'Revenue Today': 505.0, 'Issue Date': '08/18/2018'}, {'Revenue Today': 65.0, 'Issue Date': '08/21/2018'}, {'Revenue Today': 115.0, 'Issue Date': '08/23/2018'}, {'Revenue Today': 115.0, 'Issue Date': '08/26/2018'}, {'Revenue Today': 95.0, 'Issue Date': '08/28/2018'}, {'Revenue Today': 460.0, 'Issue Date': '08/30/2018'}, {'Revenue Today': 115.0, 'Issue Date': '09/03/2018'}, {'Revenue Today': 45.0, 'Issue Date': '09/07/2018'}, {'Revenue Today': 165.0, 'Issue Date': '09/09/2018'}, {'Revenue Today': 115.0, 'Issue Date': '09/10/2018'}, {'Revenue Today': 95.0, 'Issue Date': '09/13/2018'}, {'Revenue Today': 115.0, 'Issue Date': '09/16/2018'}, {'Revenue Today': 65.0, 'Issue Date': '09/17/2018'}, {'Revenue Today': 115.0, 'Issue Date': '09/18/2018'}, {'Revenue Today': 115.0, 'Issue Date': '09/19/2018'}, {'Revenue Today': 115.0, 'Issue Date': '09/28/2018'}, {'Revenue Today': 230.0, 'Issue Date': '09/30/2018'}, {'Revenue Today': 45.0, 'Issue Date': '10/09/2018'}, {'Revenue Today': 230.0, 'Issue Date': '10/11/2018'}, {'Revenue Today': 165.0, 'Issue Date': '10/17/2018'}, {'Revenue Today': 225.0, 'Issue Date': '10/21/2018'}, {'Revenue Today': 160.0, 'Issue Date': '10/22/2018'}, {'Revenue Today': 115.0, 'Issue Date': '10/23/2018'}, {'Revenue Today': 45.0, 'Issue Date': '10/31/2018'}, {'Revenue Today': 65.0, 'Issue Date': '11/02/2018'}, {'Revenue Today': 60.0, 'Issue Date': '11/03/2018'}, {'Revenue Today': 325.0, 'Issue Date': '11/17/2018'}, {'Revenue Today': 475.0, 'Issue Date': '11/19/2018'}, {'Revenue Today': 115.0, 'Issue Date': '11/22/2018'}, {'Revenue Today': 45.0, 'Issue Date': '11/25/2018'}, {'Revenue Today': 115.0, 'Issue Date': '11/28/2018'}, {'Revenue Today': 65.0, 'Issue Date': '12/09/2018'}, {'Revenue Today': 200.0, 'Issue Date': '12/13/2018'}, {'Revenue Today': 115.0, 'Issue Date': '12/16/2018'}, {'Revenue Today': 245.0, 'Issue Date': '12/17/2018'}, {'Revenue Today': 115.0, 'Issue Date': '12/18/2018'}, {'Revenue Today': 115.0, 'Issue Date': '12/28/2018'}, {'Revenue Today': 65.0, 'Issue Date': '01/01/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/02/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/06/2019'}, {'Revenue Today': 290.0, 'Issue Date': '01/07/2019'}, {'Revenue Today': 230.0, 'Issue Date': '01/08/2019'}, {'Revenue Today': 315.0, 'Issue Date': '01/09/2019'}, {'Revenue Today': 230.0, 'Issue Date': '01/10/2019'}, {'Revenue Today': 295.0, 'Issue Date': '01/11/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/12/2019'}, {'Revenue Today': 230.0, 'Issue Date': '01/14/2019'}, {'Revenue Today': 325.0, 'Issue Date': '01/15/2019'}, {'Revenue Today': 345.0, 'Issue Date': '01/16/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/17/2019'}, {'Revenue Today': 205.0, 'Issue Date': '01/18/2019'}, {'Revenue Today': 460.0, 'Issue Date': '01/19/2019'}, {'Revenue Today': 295.0, 'Issue Date': '01/20/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/21/2019'}, {'Revenue Today': 95.0, 'Issue Date': '01/26/2019'}, {'Revenue Today': 65.0, 'Issue Date': '01/27/2019'}, {'Revenue Today': 295.0, 'Issue Date': '01/28/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/30/2019'}, {'Revenue Today': 230.0, 'Issue Date': '02/05/2019'}, {'Revenue Today': 230.0, 'Issue Date': '02/06/2019'}, {'Revenue Today': 230.0, 'Issue Date': '02/07/2019'}, {'Revenue Today': 60.0, 'Issue Date': '02/10/2019'}, {'Revenue Today': 115.0, 'Issue Date': '02/11/2019'}, {'Revenue Today': 210.0, 'Issue Date': '02/12/2019'}, {'Revenue Today': 230.0, 'Issue Date': '02/14/2019'}, {'Revenue Today': 60.0, 'Issue Date': '02/16/2019'}, {'Revenue Today': 65.0, 'Issue Date': '02/17/2019'}, {'Revenue Today': 180.0, 'Issue Date': '07/18/2019'}, {'Revenue Today': 640.0, 'Issue Date': '07/20/2019'}, {'Revenue Today': 255.0, 'Issue Date': '07/22/2019'}, {'Revenue Today': 65.0, 'Issue Date': '07/25/2019'}, {'Revenue Today': 160.0, 'Issue Date': '07/31/2019'}, {'Revenue Today': 65.0, 'Issue Date': '08/06/2019'}, {'Revenue Today': 65.0, 'Issue Date': '08/09/2019'}, {'Revenue Today': 115.0, 'Issue Date': '08/15/2019'}, {'Revenue Today': 65.0, 'Issue Date': '08/17/2019'}, {'Revenue Today': 115.0, 'Issue Date': '08/19/2019'}, {'Revenue Today': 535.0, 'Issue Date': '08/20/2019'}, {'Revenue Today': 295.0, 'Issue Date': '08/23/2019'}, {'Revenue Today': 115.0, 'Issue Date': '08/30/2019'}, {'Revenue Today': 115.0, 'Issue Date': '09/01/2019'}, {'Revenue Today': 65.0, 'Issue Date': '09/06/2019'}, {'Revenue Today': 115.0, 'Issue Date': '09/09/2019'}, {'Revenue Today': 115.0, 'Issue Date': '09/11/2019'}, {'Revenue Today': 345.0, 'Issue Date': '09/13/2019'}, {'Revenue Today': 115.0, 'Issue Date': '09/16/2019'}, {'Revenue Today': 245.0, 'Issue Date': '09/18/2019'}, {'Revenue Today': 275.0, 'Issue Date': '09/19/2019'}, {'Revenue Today': 405.0, 'Issue Date': '09/20/2019'}, {'Revenue Today': 165.0, 'Issue Date': '09/21/2019'}, {'Revenue Today': 65.0, 'Issue Date': '09/23/2019'}, {'Revenue Today': 115.0, 'Issue Date': '09/24/2019'}, {'Revenue Today': 115.0, 'Issue Date': '09/30/2019'}, {'Revenue Today': 45.0, 'Issue Date': '10/02/2019'}, {'Revenue Today': 180.0, 'Issue Date': '10/03/2019'}, {'Revenue Today': 165.0, 'Issue Date': '10/04/2019'}, {'Revenue Today': 230.0, 'Issue Date': '10/08/2019'}, {'Revenue Today': 95.0, 'Issue Date': '10/09/2019'}, {'Revenue Today': 65.0, 'Issue Date': '10/10/2019'}, {'Revenue Today': 115.0, 'Issue Date': '10/11/2019'}, {'Revenue Today': 210.0, 'Issue Date': '10/18/2019'}, {'Revenue Today': 180.0, 'Issue Date': '10/20/2019'}, {'Revenue Today': 115.0, 'Issue Date': '10/21/2019'}, {'Revenue Today': 115.0, 'Issue Date': '10/31/2019'}, {'Revenue Today': 65.0, 'Issue Date': '11/03/2019'}, {'Revenue Today': 115.0, 'Issue Date': '11/09/2019'}, {'Revenue Today': 110.0, 'Issue Date': '11/11/2019'}, {'Revenue Today': 45.0, 'Issue Date': '11/12/2019'}, {'Revenue Today': 280.0, 'Issue Date': '11/15/2019'}, {'Revenue Today': 240.0, 'Issue Date': '11/18/2019'}, {'Revenue Today': 180.0, 'Issue Date': '11/20/2019'}, {'Revenue Today': 95.0, 'Issue Date': '11/21/2019'}, {'Revenue Today': 65.0, 'Issue Date': '11/22/2019'}, {'Revenue Today': 115.0, 'Issue Date': '11/24/2019'}, {'Revenue Today': 45.0, 'Issue Date': '11/30/2019'}, {'Revenue Today': 65.0, 'Issue Date': '12/02/2019'}, {'Revenue Today': 115.0, 'Issue Date': '12/13/2019'}, {'Revenue Today': 95.0, 'Issue Date': '12/15/2019'}, {'Revenue Today': 115.0, 'Issue Date': '12/16/2019'}, {'Revenue Today': 605.0, 'Issue Date': '12/18/2019'}, {'Revenue Today': 390.0, 'Issue Date': '12/20/2019'}, {'Revenue Today': 115.0, 'Issue Date': '12/23/2019'}, {'Revenue Today': 115.0, 'Issue Date': '12/30/2019'}, {'Revenue Today': 115.0, 'Issue Date': '01/18/2020'}, {'Revenue Today': 65.0, 'Issue Date': '08/18/2020'}, {'Revenue Today': 45.0, 'Issue Date': '08/19/2020'}, {'Revenue Today': 115.0, 'Issue Date': '01/12/2021'}, {'Revenue Today': 115.0, 'Issue Date': '02/02/2021'}, {'Revenue Today': 65.0, 'Issue Date': '02/08/2021'}, {'Revenue Today': 60.0, 'Issue Date': '07/18/2021'}, {'Revenue Today': 115.0, 'Issue Date': '08/02/2021'}, {'Revenue Today': 95.0, 'Issue Date': '08/05/2021'}, {'Revenue Today': 180.0, 'Issue Date': '08/07/2021'}, {'Revenue Today': 65.0, 'Issue Date': '09/05/2021'}, {'Revenue Today': 115.0, 'Issue Date': '09/12/2021'}, {'Revenue Today': 60.0, 'Issue Date': '09/19/2021'}, {'Revenue Today': 115.0, 'Issue Date': '10/30/2021'}, {'Revenue Today': 65.0, 'Issue Date': '11/10/2021'}, {'Revenue Today': 45.0, 'Issue Date': '11/29/2021'}, {'Revenue Today': 180.0, 'Issue Date': '12/26/2021'}, {'Revenue Today': 60.0, 'Issue Date': '01/04/2023'}, {'Revenue Today': 65.0, 'Issue Date': '07/18/2023'}, {'Revenue Today': 115.0, 'Issue Date': '08/08/2023'}, {'Revenue Today': 115.0, 'Issue Date': '08/13/2023'}, {'Revenue Today': 115.0, 'Issue Date': '08/17/2023'}, {'Revenue Today': 115.0, 'Issue Date': '08/22/2023'}, {'Revenue Today': 65.0, 'Issue Date': '08/30/2023'}, {'Revenue Today': 210.0, 'Issue Date': '09/01/2023'}, {'Revenue Today': 65.0, 'Issue Date': '09/02/2023'}, {'Revenue Today': 115.0, 'Issue Date': '09/06/2023'}, {'Revenue Today': 65.0, 'Issue Date': '09/18/2023'}, {'Revenue Today': 180.0, 'Issue Date': '09/19/2023'}, {'Revenue Today': 45.0, 'Issue Date': '09/23/2023'}, {'Revenue Today': 115.0, 'Issue Date': '09/25/2023'}, {'Revenue Today': 95.0, 'Issue Date': '09/29/2023'}, {'Revenue Today': 115.0, 'Issue Date': '10/06/2023'}, {'Revenue Today': 115.0, 'Issue Date': '10/11/2023'}, {'Revenue Today': 115.0, 'Issue Date': '10/22/2023'}, {'Revenue Today': 115.0, 'Issue Date': '10/23/2023'}, {'Revenue Today': 115.0, 'Issue Date': '10/24/2023'}, {'Revenue Today': 115.0, 'Issue Date': '11/01/2023'}, {'Revenue Today': 115.0, 'Issue Date': '11/06/2023'}, {'Revenue Today': 230.0, 'Issue Date': '11/25/2023'}, {'Revenue Today': 180.0, 'Issue Date': '12/03/2023'}, {'Revenue Today': 65.0, 'Issue Date': '12/16/2023'}, {'Revenue Today': 105.0, 'Issue Date': '12/19/2023'}, {'Revenue Today': 180.0, 'Issue Date': '12/23/2023'}, {'Revenue Today': 115.0, 'Issue Date': '01/05/2024'}, {'Revenue Today': 95.0, 'Issue Date': '01/14/2024'}, {'Revenue Today': 115.0, 'Issue Date': '09/29/2024'}, {'Revenue Today': 115.0, 'Issue Date': '10/10/2024'}, {'Revenue Today': 45.0, 'Issue Date': '12/10/2024'}, {'Revenue Today': 115.0, 'Issue Date': '01/06/2025'}, {'Revenue Today': 115.0, 'Issue Date': '01/09/2025'}, {'Revenue Today': 115.0, 'Issue Date': '01/16/2025'}, {'Revenue Today': 60.0, 'Issue Date': '03/02/2025'}, {'Revenue Today': 65.0, 'Issue Date': '10/16/2025'}, {'Revenue Today': 45.0, 'Issue Date': '11/11/2025'}, {'Revenue Today': 115.0, 'Issue Date': '10/09/2027'}, {'Revenue Today': 95.0, 'Issue Date': '10/29/2027'}, {'Revenue Today': 115.0, 'Issue Date': '01/13/2028'}, {'Revenue Today': 130.0, 'Issue Date': '11/30/2028'}, {'Revenue Today': 115.0, 'Issue Date': '11/11/2029'}, {'Revenue Today': 60.0, 'Issue Date': '12/29/2029'}, {'Revenue Today': 115.0, 'Issue Date': '01/15/2030'}, {'Revenue Today': 65.0, 'Issue Date': '06/29/2030'}, {'Revenue Today': 115.0, 'Issue Date': '07/30/2030'}, {'Revenue Today': 115.0, 'Issue Date': '08/01/2030'}, {'Revenue Today': 45.0, 'Issue Date': '08/19/2030'}, {'Revenue Today': 115.0, 'Issue Date': '08/28/2030'}, {'Revenue Today': 290.0, 'Issue Date': '08/29/2030'}, {'Revenue Today': 115.0, 'Issue Date': '09/01/2030'}, {'Revenue Today': 65.0, 'Issue Date': '09/28/2030'}, {'Revenue Today': 160.0, 'Issue Date': '09/29/2030'}, {'Revenue Today': 45.0, 'Issue Date': '09/30/2030'}, {'Revenue Today': 45.0, 'Issue Date': '10/19/2030'}, {'Revenue Today': 60.0, 'Issue Date': '10/20/2030'}, {'Revenue Today': 115.0, 'Issue Date': '10/25/2030'}, {'Revenue Today': 65.0, 'Issue Date': '10/28/2030'}, {'Revenue Today': 630.0, 'Issue Date': '10/29/2030'}, {'Revenue Today': 45.0, 'Issue Date': '11/12/2030'}, {'Revenue Today': 115.0, 'Issue Date': '11/20/2030'}, {'Revenue Today': 650.0, 'Issue Date': '11/29/2030'}, {'Revenue Today': 60.0, 'Issue Date': '11/30/2030'}, {'Revenue Today': 115.0, 'Issue Date': '12/17/2030'}, {'Revenue Today': 115.0, 'Issue Date': '12/19/2030'}, {'Revenue Today': 115.0, 'Issue Date': '12/21/2030'}, {'Revenue Today': 115.0, 'Issue Date': '12/27/2030'}, {'Revenue Today': 165.0, 'Issue Date': '12/29/2030'}, {'Revenue Today': 230.0, 'Issue Date': '12/30/2030'}, {'Revenue Today': 115.0, 'Issue Date': '01/11/2031'}, {'Revenue Today': 115.0, 'Issue Date': '01/13/2031'}, {'Revenue Today': 115.0, 'Issue Date': '01/23/2031'}, {'Revenue Today': 115.0, 'Issue Date': '02/03/2031'}, {'Revenue Today': 115.0, 'Issue Date': '07/13/2031'}, {'Revenue Today': 115.0, 'Issue Date': '07/15/2031'}, {'Revenue Today': 95.0, 'Issue Date': '07/29/2031'}, {'Revenue Today': 115.0, 'Issue Date': '07/30/2031'}, {'Revenue Today': 310.0, 'Issue Date': '07/31/2031'}, {'Revenue Today': 245.0, 'Issue Date': '08/01/2031'}, {'Revenue Today': 115.0, 'Issue Date': '08/07/2031'}, {'Revenue Today': 115.0, 'Issue Date': '08/13/2031'}, {'Revenue Today': 65.0, 'Issue Date': '08/27/2031'}, {'Revenue Today': 65.0, 'Issue Date': '08/28/2031'}, {'Revenue Today': 390.0, 'Issue Date': '08/29/2031'}, {'Revenue Today': 180.0, 'Issue Date': '09/01/2031'}, {'Revenue Today': 115.0, 'Issue Date': '09/13/2031'}, {'Revenue Today': 65.0, 'Issue Date': '09/21/2031'}, {'Revenue Today': 45.0, 'Issue Date': '10/01/2031'}, {'Revenue Today': 115.0, 'Issue Date': '10/09/2031'}, {'Revenue Today': 115.0, 'Issue Date': '10/10/2031'}, {'Revenue Today': 115.0, 'Issue Date': '10/11/2031'}, {'Revenue Today': 65.0, 'Issue Date': '10/13/2031'}, {'Revenue Today': 115.0, 'Issue Date': '10/17/2031'}, {'Revenue Today': 115.0, 'Issue Date': '10/28/2031'}, {'Revenue Today': 140.0, 'Issue Date': '10/29/2031'}, {'Revenue Today': 115.0, 'Issue Date': '10/30/2031'}, {'Revenue Today': 410.0, 'Issue Date': '10/31/2031'}, {'Revenue Today': 340.0, 'Issue Date': '11/01/2031'}, {'Revenue Today': 45.0, 'Issue Date': '11/02/2031'}, {'Revenue Today': 65.0, 'Issue Date': '11/08/2031'}, {'Revenue Today': 45.0, 'Issue Date': '11/12/2031'}, {'Revenue Today': 60.0, 'Issue Date': '11/14/2031'}, {'Revenue Today': 115.0, 'Issue Date': '11/17/2031'}, {'Revenue Today': nan, 'Issue Date': '11/18/2031'}, {'Revenue Today': nan, 'Issue Date': '11/21/2031'}, {'Revenue Today': 115.0, 'Issue Date': '11/23/2031'}, {'Revenue Today': 60.0, 'Issue Date': '11/29/2031'}, {'Revenue Today': 115.0, 'Issue Date': '11/30/2031'}, {'Revenue Today': 115.0, 'Issue Date': '12/06/2031'}, {'Revenue Today': 160.0, 'Issue Date': '12/08/2031'}, {'Revenue Today': 440.0, 'Issue Date': '12/13/2031'}, {'Revenue Today': 345.0, 'Issue Date': '12/15/2031'}, {'Revenue Today': 115.0, 'Issue Date': '12/18/2031'}, {'Revenue Today': 115.0, 'Issue Date': '12/19/2031'}, {'Revenue Today': 65.0, 'Issue Date': '12/21/2031'}, {'Revenue Today': 45.0, 'Issue Date': '12/22/2031'}, {'Revenue Today': 65.0, 'Issue Date': '12/23/2031'}, {'Revenue Today': 65.0, 'Issue Date': '12/27/2031'}, {'Revenue Today': 95.0, 'Issue Date': '12/29/2031'}, {'Revenue Today': 115.0, 'Issue Date': '12/30/2031'}, {'Revenue Today': 595.0, 'Issue Date': '12/31/2031'}, {'Revenue Today': 65.0, 'Issue Date': '07/28/2032'}, {'Revenue Today': 115.0, 'Issue Date': '08/16/2032'}, {'Revenue Today': 60.0, 'Issue Date': '12/28/2032'}, {'Revenue Today': 115.0, 'Issue Date': '09/04/2033'}, {'Revenue Today': 65.0, 'Issue Date': '10/12/2033'}, {'Revenue Today': 65.0, 'Issue Date': '10/23/2033'}, {'Revenue Today': 115.0, 'Issue Date': '11/27/2033'}, {'Revenue Today': 45.0, 'Issue Date': '12/11/2033'}, {'Revenue Today': 175.0, 'Issue Date': '12/15/2033'}, {'Revenue Today': 115.0, 'Issue Date': '01/19/2040'}, {'Revenue Today': 65.0, 'Issue Date': '01/01/2041'}, {'Revenue Today': 65.0, 'Issue Date': '02/01/2041'}, {'Revenue Today': 65.0, 'Issue Date': '02/04/2041'}, {'Revenue Today': 115.0, 'Issue Date': '07/22/2041'}, {'Revenue Today': 65.0, 'Issue Date': '08/03/2041'}, {'Revenue Today': 45.0, 'Issue Date': '08/18/2041'}, {'Revenue Today': 95.0, 'Issue Date': '09/25/2041'}, {'Revenue Today': 45.0, 'Issue Date': '10/01/2041'}, {'Revenue Today': 115.0, 'Issue Date': '10/22/2041'}, {'Revenue Today': 115.0, 'Issue Date': '11/07/2041'}, {'Revenue Today': 95.0, 'Issue Date': '11/11/2041'}, {'Revenue Today': 60.0, 'Issue Date': '11/22/2041'}, {'Revenue Today': 65.0, 'Issue Date': '12/04/2041'}, {'Revenue Today': 115.0, 'Issue Date': '12/19/2041'}, {'Revenue Today': 160.0, 'Issue Date': '12/27/2041'}, {'Revenue Today': 115.0, 'Issue Date': '09/19/2043'}, {'Revenue Today': 65.0, 'Issue Date': '09/24/2043'}, {'Revenue Today': 115.0, 'Issue Date': '10/07/2043'}, {'Revenue Today': 45.0, 'Issue Date': '10/11/2043'}, {'Revenue Today': 115.0, 'Issue Date': '10/28/2043'}, {'Revenue Today': 115.0, 'Issue Date': '10/31/2043'}, {'Revenue Today': 115.0, 'Issue Date': '11/25/2043'}, {'Revenue Today': 115.0, 'Issue Date': '12/14/2043'}, {'Revenue Today': 95.0, 'Issue Date': '12/15/2043'}, {'Revenue Today': 95.0, 'Issue Date': '08/04/2044'}, {'Revenue Today': 115.0, 'Issue Date': '08/26/2044'}, {'Revenue Today': 95.0, 'Issue Date': '12/11/2044'}, {'Revenue Today': 115.0, 'Issue Date': '09/11/2045'}, {'Revenue Today': 115.0, 'Issue Date': '10/11/2045'}, {'Revenue Today': 115.0, 'Issue Date': '01/04/2046'}, {'Revenue Today': 165.0, 'Issue Date': '11/14/2046'}, {'Revenue Today': 115.0, 'Issue Date': '02/13/2047'}, {'Revenue Today': 65.0, 'Issue Date': '08/29/2047'}, {'Revenue Today': 115.0, 'Issue Date': '02/12/2049'}, {'Revenue Today': 65.0, 'Issue Date': '08/12/2049'}, {'Revenue Today': 45.0, 'Issue Date': '01/31/2050'}, {'Revenue Today': 35.0, 'Issue Date': '01/22/2051'}, {'Revenue Today': 115.0, 'Issue Date': '09/28/2051'}, {'Revenue Today': 60.0, 'Issue Date': '10/18/2051'}, {'Revenue Today': 115.0, 'Issue Date': '11/11/2051'}, {'Revenue Today': 115.0, 'Issue Date': '11/12/2051'}, {'Revenue Today': 65.0, 'Issue Date': '01/18/2052'}, {'Revenue Today': 65.0, 'Issue Date': '08/02/2053'}, {'Revenue Today': 65.0, 'Issue Date': '01/17/2060'}, {'Revenue Today': 115.0, 'Issue Date': '08/09/2060'}, {'Revenue Today': 115.0, 'Issue Date': '08/19/2060'}, {'Revenue Today': 95.0, 'Issue Date': '01/11/2061'}, {'Revenue Today': 65.0, 'Issue Date': '09/12/2061'}, {'Revenue Today': 115.0, 'Issue Date': '11/12/2061'}, {'Revenue Today': 115.0, 'Issue Date': '12/19/2061'}, {'Revenue Today': 115.0, 'Issue Date': '12/22/2061'}, {'Revenue Today': 45.0, 'Issue Date': '09/30/2063'}, {'Revenue Today': 115.0, 'Issue Date': '11/04/2063'}, {'Revenue Today': 115.0, 'Issue Date': '11/05/2063'}, {'Revenue Today': 230.0, 'Issue Date': '11/06/2063'}, {'Revenue Today': 115.0, 'Issue Date': '12/20/2063'}, {'Revenue Today': 115.0, 'Issue Date': '12/29/2063'}, {'Revenue Today': 115.0, 'Issue Date': '11/03/2066'}, {'Revenue Today': 115.0, 'Issue Date': '12/23/2069'}]
I want to get the dictionary underneath 'All Other Areas Int' and have move all of the keys and values into dictionaries.
also want to replace all nan values for the revenue with 0
so dictionary_name['All Other Areas Int'] ->
rev_today = [
{'Issue Date': '01/04/2012', 'Revenue Today': 115.0},
{'Issue Date': '01/05/2013', 'Revenue Today': 115.0},
...
{'Issue Date': '01/14/2013', 'Revenue Today': 0},
...
]
In [88]:
df_revenue_per_day = pd.DataFrame(rev_today)
df_revenue_per_day
Out[88]:
Issue Date
Revenue Today
0
12/18/1970
60.0
1
09/18/1971
135.0
2
10/10/1971
115.0
3
07/22/1973
115.0
4
08/12/1973
45.0
5
09/22/1973
45.0
6
09/25/1973
90.0
7
10/15/1973
115.0
8
10/30/1973
115.0
9
11/12/1973
115.0
10
11/13/1973
45.0
11
01/15/1974
115.0
12
12/27/1976
65.0
13
01/01/1981
115.0
14
02/11/1981
155.0
15
01/11/1987
130.0
16
02/09/1987
65.0
17
12/09/1990
115.0
18
01/12/1991
115.0
19
01/01/2000
295.0
20
01/04/2000
460.0
21
01/05/2000
65.0
22
01/06/2000
275.0
23
01/07/2000
325.0
24
01/08/2000
325.0
25
01/09/2000
140.0
26
01/13/2000
245.0
27
01/14/2000
115.0
28
01/15/2000
230.0
29
01/17/2000
115.0
...
...
...
1927
01/04/2046
115.0
1928
11/14/2046
165.0
1929
02/13/2047
115.0
1930
08/29/2047
65.0
1931
02/12/2049
115.0
1932
08/12/2049
65.0
1933
01/31/2050
45.0
1934
01/22/2051
35.0
1935
09/28/2051
115.0
1936
10/18/2051
60.0
1937
11/11/2051
115.0
1938
11/12/2051
115.0
1939
01/18/2052
65.0
1940
08/02/2053
65.0
1941
01/17/2060
65.0
1942
08/09/2060
115.0
1943
08/19/2060
115.0
1944
01/11/2061
95.0
1945
09/12/2061
65.0
1946
11/12/2061
115.0
1947
12/19/2061
115.0
1948
12/22/2061
115.0
1949
09/30/2063
45.0
1950
11/04/2063
115.0
1951
11/05/2063
115.0
1952
11/06/2063
230.0
1953
12/20/2063
115.0
1954
12/29/2063
115.0
1955
11/03/2066
115.0
1956
12/23/2069
115.0
1957 rows × 2 columns
In [89]:
ax = df_revenue_per_day.plot(kind = 'line', x = 'Issue Date', y = 'Revenue Today', legend = None)
ax.set_title('Revenue for Traffic Violations Collected Per Day')
Out[89]:
<matplotlib.text.Text at 0x15174d6a0>
In [90]:
df_licenses = pd.read_csv('driver_licenses.csv')
df_licenses
Out[90]:
borough name
abbreviation
number of licensed drivers
0
Bronx
BX
456847
1
Brooklyn
K
983769
2
Manhattan
NY
748583
3
Queens
Q
1134064
4
StatenIsland
R
304250
In [91]:
df_fees_per_county = df_merged[['Violation County', 'Fee for This Precinct']].groupby('Violation County').sum()
In [92]:
df_fees_per_county['Violation County'] = df_fees_per_county.index
In [93]:
df_fees_per_county
Out[93]:
Fee for This Precinct
Violation County
Violation County
103
115.0
103
BX
34721700.0
BX
K
72797900.0
K
NY
168979815.0
NY
NYC
180.0
NYC
Q
64471035.0
Q
QUEEN
230.0
QUEEN
R
3511060.0
R
RC
280.0
RC
In [94]:
df_last_question = df_licenses.merge(df_fees_per_county, right_on = 'Violation County', left_on = 'abbreviation')
In [95]:
df_last_question
Out[95]:
borough name
abbreviation
number of licensed drivers
Fee for This Precinct
Violation County
0
Bronx
BX
456847
34721700.0
BX
1
Brooklyn
K
983769
72797900.0
K
2
Manhattan
NY
748583
168979815.0
NY
3
Queens
Q
1134064
64471035.0
Q
4
StatenIsland
R
304250
3511060.0
R
In [96]:
df_last_question['Fee for This Precinct'] / df_last_question['number of licensed drivers']
Out[96]:
0 76.002907
1 73.998977
2 225.732905
3 56.849556
4 11.540049
dtype: float64
Content source: raschuetz/foundations-homework
Similar notebooks: