The BC Liberal Party disclosed donations received during the run-up to the 41st British Columbia general election held May 9, 2017. The data was shared in the form of PDF files containing donations during time intervals of varying length. In this format, the disclosed donations data is not presented for easy analysis using a computer.
Disclosed donations data were munged into CSV format. The collection is available as an open Google docs spreadsheet.
This notebook explores the donations data and achieves the following objectives:
string
.import pandas as pd
import numpy as np
from datetime import *
from dateutil.relativedelta import *
import calendar
from dateutil.rrule import *
from dateutil.parser import *
import matplotlib.pyplot as plt
from bokeh.plotting import output_notebook
# from bokeh.plotting import figure, output_notebook, show
# from holoviews import Bar
# from bokeh.models import DatetimeTickFormatter
%matplotlib inline
## Import multisheet Google doc in as an Excel file.
xl = pd.ExcelFile('https://docs.google.com/spreadsheets/d/1K26qXaaKPaXV4FAmce9W7xX_lCy2RGfDSBO2lwRxfkA/export?format=xlsx&id',
)
xl
<pandas.io.excel.ExcelFile at 0x7f5442624358>
## List the names of the sheets in the imported Excel file.
## The sheet names correspond to the filenames used to label the disclosed files.
xl.sheet_names
['Copy-of-2016-Contributions-v4', '2017-Contributions-June-2', '2017-Contributions-May-26-2017', '2017-Contributions-May-19', '2017-Contributions-May-12', '2017-Contributions-May-5', '2017-Contributions-April-28-201', '2017-Contributions-April-21', '2017-Contributions-April-14', '2017-Contributions-April-7', '2017-Contributions-March-31-201', '2017-Contributions-March-23', '2017-Contributions-—-March-17-2', '2017-Contributions-March-10', '2017-Contributions-March-3-2017', '2017-Contributions-_-February-2', '2017-Contributions-February-17', 'Copy-of-2017-Contributions-Janu', 'Sheet2', '2017-Contributions-—-February-3', '2017-Contributions-—-February-1', 'Real-Time-Donations-Jan-25V3']
## Make a dictionary of Pandas Dataframes for each sheet
dict = pd.ExcelFile.parse(xl, sheetname=None)
## Merge the data frames in the dictionary into a single large data frame.
## The `df` file contains the list of disclosed BC Liberal Party data in the form of a Pandas Dataframe.
df = pd.concat(dict)
## List descriptive statistics of the collection of all donations.
df.describe()
Amount | |
---|---|
count | 29509.000000 |
mean | 628.985388 |
std | 2279.642803 |
min | 0.000000 |
25% | 36.000000 |
50% | 100.000000 |
75% | 300.000000 |
max | 85000.000000 |
## Convert Date to a better Format for ordering
df['datetime'] = pd.to_datetime(df['Date'])
## Number of unique Donor Names
len(df['Donor Name'].unique())
15306
There were 29,509 donation transactions reported. These donations were made by 15,306 unique donors. The mean
donation is $628.99 with a maximum single donation of $85,000.
## Calculate total amount donated.
df['Amount'].sum()
18560729.800000001
## Plot donations vs. time
df.sort_values(by='datetime').plot(x='datetime',y="Amount", style ="x")
<matplotlib.axes._subplots.AxesSubplot at 0x7f5440846dd8>
## Accumulate donations vs. time starting from oldest donation
df['cumsum'] = df.sort_values(by='datetime')['Amount'].cumsum()
## Accumulated Donations vs. Time
df.plot(x='datetime',y='cumsum')
<matplotlib.axes._subplots.AxesSubplot at 0x7f544001e828>
## Restrict attention to donations exceeding a threshold amount
big = df.loc[df['Amount'] > 30000]
## Big Donations as a fraction of total donations
big['Amount'].sum()/df['Amount'].sum()
0.061702853947046846
## 20 biggest single donations
big.sort_values(by="Amount", ascending = False).head(n=20)
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
2017-Contributions-May-5 | 945 | Sandman Hotels, Inns & Suites Ltd | 85000.0 | 2017-04-28 00:00:00 | 2017-04-28 | 15239725.38 |
2017-Contributions-May-19 | 433 | Wesgroup Properties Ltd | 75000.0 | 2017-05-12 00:00:00 | 2017-05-12 | 18053801.51 |
Copy-of-2016-Contributions-v4 | 779 | Aquilini Investment Group LP | 75000.0 | 2016-11-10 00:00:00 | 2016-11-10 | 8234965.96 |
6602 | Independent Contractors & Businesses Associati... | 60000.0 | 2016-08-07 00:00:00 | 2016-08-07 | 6123515.38 | |
15516 | Westbridge Finance Inc | 50000.0 | 2016-04-15 00:00:00 | 2016-04-15 | 3092883.44 | |
2017-Contributions-May-12 | 34 | Anthem Properties Group Ltd. | 50000.0 | 2017-05-06 00:00:00 | 2017-05-06 | 16739929.01 |
259 | Interfor Corporation | 50000.0 | 2017-05-06 00:00:00 | 2017-05-06 | 16994279.01 | |
Copy-of-2016-Contributions-v4 | 14013 | Starline Windows (2001) Ltd. | 50000.0 | 2016-03-06 00:00:00 | 2016-03-06 | 1788467.44 |
13635 | Shape Properties Corp. | 50000.0 | 2016-07-13 00:00:00 | 2016-07-13 | 5701462.88 | |
2017-Contributions-May-19 | 283 | Maple Ridge Plaza Properties Ltd. | 50000.0 | 2017-05-12 00:00:00 | 2017-05-12 | 17573426.01 |
Copy-of-2016-Contributions-v4 | 11933 | Peter Redekop | 50000.0 | 2016-01-15 00:00:00 | 2016-01-15 | 322847.79 |
2017-Contributions-March-31-201 | 1665 | The Pacific Investment Corporation Ltd. | 50000.0 | 2017-03-25 00:00:00 | 2017-03-25 | 12894264.39 |
Copy-of-2016-Contributions-v4 | 3481 | Dayhu Investments Ltd. | 50000.0 | 2016-10-06 00:00:00 | 2016-10-06 | 7088503.35 |
14471 | Tech Projects Ltd | 40000.0 | 2016-02-26 00:00:00 | 2016-02-26 | 1086720.44 | |
6721 | ITC Management Inc | 40000.0 | 2016-02-26 00:00:00 | 2016-02-26 | 868810.44 | |
2017-Contributions-March-31-201 | 1360 | Polygon Homes Ltd | 40000.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13138710.53 |
2017-Contributions-May-12 | 493 | Robert Lee | 40000.0 | 2017-05-06 00:00:00 | 2017-05-06 | 16816079.01 |
2017-Contributions-March-31-201 | 1759 | West Fraser Mills Ltd | 37500.0 | 2017-03-25 00:00:00 | 2017-03-25 | 12645513.57 |
Copy-of-2016-Contributions-v4 | 1947 | Canadian Classified Network Inc | 35000.0 | 2016-01-15 00:00:00 | 2016-01-15 | 371222.79 |
12149 | Progressive Waste Solutions Canada Inc | 35000.0 | 2016-03-06 00:00:00 | 2016-03-06 | 1583542.44 |
string
in 'Donor Name'¶def df_filter(name):
return df.loc[df['Donor Name'].str.contains(name)].sort_values(by='datetime')
df_filter('Retailers')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 911 | Automotive Retailers Association | 1750.0 | 2016-01-01 00:00:00 | 2016-01-01 | 12600.00 |
912 | Automotive Retailers Association | 625.0 | 2016-02-29 00:00:00 | 2016-02-29 | 1370150.44 | |
913 | Automotive Retailers Association | 2300.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2102728.44 | |
914 | Automotive Retailers Association | 300.0 | 2016-05-31 00:00:00 | 2016-05-31 | 4558536.45 | |
915 | Automotive Retailers Association | 1150.0 | 2016-05-31 00:00:00 | 2016-05-31 | 4564366.45 | |
916 | Automotive Retailers Association | 700.0 | 2016-08-17 00:00:00 | 2016-08-17 | 6135315.38 | |
Copy-of-2017-Contributions-Janu | 10 | Automotive Retailers Association | 300.0 | 1/13/2017 | 2017-01-13 | 10818058.78 |
2017-Contributions-—-February-3 | 34 | Automotive Retailers Association | 875.0 | 2017-01-27 00:00:00 | 2017-01-27 | 11202575.63 |
35 | Automotive Retailers Association | 1750.0 | 2017-02-01 00:00:00 | 2017-02-01 | 11262125.63 | |
2017-Contributions-—-February-1 | 12 | Automotive Retailers Association | 250.0 | 2017-02-03 00:00:00 | 2017-02-03 | 11416550.63 |
2017-Contributions-—-March-17-2 | 5 | Automotive Retailers Association | 500.0 | 2017-03-10 00:00:00 | 2017-03-10 | 12065799.34 |
df_filter('Encana')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 4611 | Encana Corporation Ltd | 1000.0 | 2016-02-26 00:00:00 | 2016-02-26 | 1147310.44 |
4612 | Encana Corporation Ltd | 10000.0 | 2016-03-24 00:00:00 | 2016-03-24 | 2086525.44 | |
4613 | Encana Corporation Ltd | 1500.0 | 2016-04-15 00:00:00 | 2016-04-15 | 2816448.44 | |
4614 | Encana Corporation Ltd | 1500.0 | 2016-04-22 00:00:00 | 2016-04-22 | 3202678.44 | |
4616 | Encana Corporation Ltd | 750.0 | 2016-05-20 00:00:00 | 2016-05-20 | 4241072.78 | |
4617 | Encana Corporation Ltd | 5000.0 | 2016-05-27 00:00:00 | 2016-05-27 | 4363478.11 | |
4615 | Encana Corporation Ltd | 8000.0 | 2016-06-05 00:00:00 | 2016-06-05 | 4669701.45 | |
4618 | Encana Corporation Ltd | 5000.0 | 2016-06-24 00:00:00 | 2016-06-24 | 5201365.78 | |
4619 | Encana Corporation Ltd | 500.0 | 2016-07-13 00:00:00 | 2016-07-13 | 5605597.88 | |
4620 | Encana Corporation Ltd | 300.0 | 2016-07-15 00:00:00 | 2016-07-15 | 5724372.88 | |
4621 | Encana Corporation Ltd | 25000.0 | 2016-09-22 00:00:00 | 2016-09-22 | 6641549.54 | |
4622 | Encana Corporation Ltd | 5200.0 | 2016-10-31 00:00:00 | 2016-10-31 | 7863872.96 | |
4623 | Encana Corporation Ltd | 1500.0 | 2016-12-19 00:00:00 | 2016-12-19 | 9754678.36 | |
Real-Time-Donations-Jan-25V3 | 572 | Encana Corporation Ltd | 17500.0 | 2017-01-11 00:00:00 | 2017-01-11 | 10805103.78 |
2017-Contributions-March-31-201 | 544 | Encana Corporation Ltd | 3700.0 | 2017-03-28 00:00:00 | 2017-03-28 | 13431757.53 |
2017-Contributions-April-21 | 403 | Encana Corporation Ltd | 250.0 | 2017-04-14 00:00:00 | 2017-04-14 | 14658385.86 |
2017-Contributions-May-5 | 326 | Encana Corporation Ltd | 29500.0 | 2017-05-04 00:00:00 | 2017-05-04 | 16022469.49 |
2017-Contributions-May-19 | 147 | Encana Corporation Ltd | 5000.0 | 2017-05-12 00:00:00 | 2017-05-12 | 17318690.01 |
df_filter('Encana')['Amount'].sum()
121200.0
df_filter('Ledcor')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 9070 | Ledcor Industries Inc. | 9000.0 | 2016-05-08 00:00:00 | 2016-05-08 | 3592482.44 |
9069 | Ledcor Industries Inc. | 7500.0 | 2016-06-24 00:00:00 | 2016-06-24 | 5151360.78 | |
9067 | Ledcor Industries Inc. | 5000.0 | 2016-08-04 00:00:00 | 2016-08-04 | 6003540.38 | |
9068 | Ledcor Industries Inc. | 700.0 | 2016-10-06 00:00:00 | 2016-10-06 | 7105143.35 | |
9071 | Ledcor Industries Inc. | 1200.0 | 2016-11-21 00:00:00 | 2016-11-21 | 8514081.96 | |
9072 | Ledcor Industries Inc. | 2000.0 | 2016-11-28 00:00:00 | 2016-11-28 | 8723601.69 | |
9073 | Ledcor Industries Inc. | 5100.0 | 2016-12-19 00:00:00 | 2016-12-19 | 9717643.36 | |
Real-Time-Donations-Jan-25V3 | 595 | Ledcor Industries Inc. | 1000.0 | 2017-01-11 00:00:00 | 2017-01-11 | 10760763.67 |
2017-Contributions-March-31-201 | 1028 | Ledcor Industries Inc. | 1000.0 | 2017-03-28 00:00:00 | 2017-03-28 | 13513287.53 |
2017-Contributions-April-28-201 | 277 | Ledcor Industries Inc. | 1000.0 | 2017-04-21 00:00:00 | 2017-04-21 | 14971133.38 |
2017-Contributions-May-5 | 666 | Ledcor Industries Inc. | 5000.0 | 2017-05-03 00:00:00 | 2017-05-03 | 15866549.49 |
2017-Contributions-May-12 | 332 | Ledcor Industries Inc. | 1300.0 | 2017-05-05 00:00:00 | 2017-05-05 | 16323461.82 |
df_filter('LNG')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 11439 | Pacific Northwest LNG Ltd. | 500.0 | 2016-01-01 00:00:00 | 2016-01-01 | 10850.00 |
14016 | Steelhead LNG Corp. | 4000.0 | 2016-02-15 00:00:00 | 2016-02-15 | 750390.44 | |
14017 | Steelhead LNG Corp. | 4000.0 | 2016-02-29 00:00:00 | 2016-02-29 | 1330105.44 | |
11441 | Pacific Northwest LNG Ltd. | 2500.0 | 2016-02-29 00:00:00 | 2016-02-29 | 1415020.44 | |
15791 | Woodfibre LNG Ltd. | 10000.0 | 2016-04-22 00:00:00 | 2016-04-22 | 3263228.44 | |
15792 | Woodfibre LNG Ltd. | 1000.0 | 2016-06-24 00:00:00 | 2016-06-24 | 5196240.78 | |
14018 | Steelhead LNG Corp. | 7500.0 | 2016-06-24 00:00:00 | 2016-06-24 | 5254369.52 | |
11440 | Pacific Northwest LNG Ltd. | 1250.0 | 2016-08-01 00:00:00 | 2016-08-01 | 5964181.38 | |
15793 | Woodfibre LNG Ltd. | 5000.0 | 2016-11-15 00:00:00 | 2016-11-15 | 8440181.96 | |
11438 | Pacific North West LNG | 1000.0 | 2016-12-08 00:00:00 | 2016-12-08 | 9328597.66 | |
15794 | Woodfibre LNG Ltd. | 5000.0 | 2016-12-22 00:00:00 | 2016-12-22 | 9898556.36 | |
Copy-of-2017-Contributions-Janu | 203 | Woodfibre LNG Ltd. | 7500.0 | 1/18/2017 | 2017-01-18 | 10931198.78 |
2017-Contributions-—-February-1 | 186 | Woodfibre LNG Ltd. | 4500.0 | 2017-02-08 00:00:00 | 2017-02-08 | 11474535.63 |
2017-Contributions-February-17 | 159 | Steelhead LNG | 300.0 | 2017-02-10 00:00:00 | 2017-02-10 | 11551075.63 |
2017-Contributions-March-10 | 159 | Steelhead LNG | 300.0 | 2017-02-10 00:00:00 | 2017-02-10 | 11614400.63 |
2017-Contributions-—-March-17-2 | 162 | Steelhead LNG | 2225.0 | 2017-03-10 00:00:00 | 2017-03-10 | 12102489.34 |
2017-Contributions-April-7 | 720 | Woodfibre LNG Ltd. | 7500.0 | 2017-04-03 00:00:00 | 2017-04-03 | 13877625.86 |
2017-Contributions-April-14 | 740 | Woodfibre LNG Ltd. | 2500.0 | 2017-04-09 00:00:00 | 2017-04-09 | 14431192.86 |
2017-Contributions-April-21 | 1310 | Woodfibre LNG Ltd. | 10000.0 | 2017-04-14 00:00:00 | 2017-04-14 | 14695085.86 |
2017-Contributions-April-28-201 | 507 | Woodfibre LNG Ltd. | 2500.0 | 2017-04-21 00:00:00 | 2017-04-21 | 14921129.38 |
2017-Contributions-May-5 | 1117 | Woodfibre LNG Ltd. | 2000.0 | 2017-04-29 00:00:00 | 2017-04-29 | 15625016.49 |
1118 | Woodfibre LNG Ltd. | 10000.0 | 2017-05-03 00:00:00 | 2017-05-03 | 15921484.49 | |
2017-Contributions-May-19 | 402 | Steelhead LNG | 4000.0 | 2017-05-12 00:00:00 | 2017-05-12 | 17818626.51 |
2017-Contributions-June-2 | 419 | Pacific Rim LNG Ltd | 250.0 | 2017-05-30 00:00:00 | 2017-05-30 | 18451503.09 |
df_filter('Telus')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 14507 | Telus | 250.0 | 2016-01-01 00:00:00 | 2016-01-01 | 75850.00 |
14508 | Telus | 2500.0 | 2016-01-22 00:00:00 | 2016-01-22 | 379822.79 | |
14509 | Telus | 450.0 | 2016-01-31 00:00:00 | 2016-01-31 | 627937.09 | |
14510 | Telus | 7500.0 | 2016-03-02 00:00:00 | 2016-03-02 | 1495920.44 | |
14511 | Telus | 5000.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2238668.44 | |
14512 | Telus | 300.0 | 2016-04-15 00:00:00 | 2016-04-15 | 3116243.44 | |
14513 | Telus | 1300.0 | 2016-05-31 00:00:00 | 2016-05-31 | 4551621.45 | |
14514 | Telus | 4450.0 | 2016-06-30 00:00:00 | 2016-06-30 | 5549187.88 | |
14516 | Telus | 1250.0 | 2016-10-30 00:00:00 | 2016-10-30 | 7386385.60 | |
14517 | Telus | 500.0 | 2016-10-31 00:00:00 | 2016-10-31 | 7855587.96 | |
14519 | Telus Communications | 2000.0 | 2016-11-30 00:00:00 | 2016-11-30 | 8849172.69 | |
14518 | Telus | 1500.0 | 2016-11-30 00:00:00 | 2016-11-30 | 8850772.69 | |
2017-Contributions-—-February-1 | 171 | Telus | 1200.0 | 2017-02-03 00:00:00 | 2017-02-03 | 11383729.63 |
2017-Contributions-_-February-2 | 124 | Telus | 380.0 | 2017-02-17 00:00:00 | 2017-02-17 | 11700150.63 |
2017-Contributions-March-3-2017 | 1231 | Telus | 5000.0 | 2017-02-24 00:00:00 | 2017-02-24 | 11920854.34 |
2017-Contributions-April-14 | 688 | Telus | 2000.0 | 2017-04-07 00:00:00 | 2017-04-07 | 14101890.86 |
2017-Contributions-April-21 | 1211 | Telus | 5000.0 | 2017-04-14 00:00:00 | 2017-04-14 | 14576488.86 |
df_filter('Bank')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 980 | Bank of Montreal | 250.0 | 2016-01-31 00:00:00 | 2016-01-31 | 547793.09 |
6448 | HSBC Bank Canada | 5000.0 | 2016-03-02 00:00:00 | 2016-03-02 | 1448195.44 | |
14858 | Toronto Dominion Bank | 5000.0 | 2016-03-24 00:00:00 | 2016-03-24 | 2068255.44 | |
6449 | HSBC Bank Canada | 50.0 | 2016-04-03 00:00:00 | 2016-04-03 | 2579401.44 | |
14639 | The Toronto-Dominion Bank | 350.0 | 2016-04-22 00:00:00 | 2016-04-22 | 3291665.44 | |
981 | Bank of Montreal | 20.0 | 2016-04-30 00:00:00 | 2016-04-30 | 3449089.44 | |
15353 | Wayne Banks | 150.0 | 2016-05-08 00:00:00 | 2016-05-08 | 3596632.44 | |
8454 | KEB Hana Bank Canada | 300.0 | 2016-05-20 00:00:00 | 2016-05-20 | 4252072.78 | |
13263 | Royal Bank of Canada | 1000.0 | 2016-05-27 00:00:00 | 2016-05-27 | 4340733.11 | |
14859 | Toronto Dominion Bank | 20000.0 | 2016-09-13 00:00:00 | 2016-09-13 | 6457109.55 | |
1049 | Bard & Banker Pub Company Ltd | 12500.0 | 2016-10-21 00:00:00 | 2016-10-21 | 7287393.35 | |
14640 | The Toronto-Dominion Bank | 360.0 | 2016-11-10 00:00:00 | 2016-11-10 | 8109975.96 | |
7033 | James W. Banks | 100.0 | 2016-12-31 00:00:00 | 2016-12-31 | 10278986.32 | |
Real-Time-Donations-Jan-25V3 | 469 | The Toronto-Dominion Bank | 50.0 | 2017-01-04 00:00:00 | 2017-01-04 | 10678908.67 |
440 | Royal Bank of Canada | 25.0 | 2017-01-04 00:00:00 | 2017-01-04 | 10635003.67 | |
Copy-of-2017-Contributions-Janu | 189 | Toronto-Dominion Bank | 400.0 | 1/18/2017 | 2017-01-18 | 10933283.78 |
2017-Contributions-—-February-3 | 490 | TD Bank Group | 450.0 | 2017-01-27 00:00:00 | 2017-01-27 | 11179878.63 |
2017-Contributions-March-31-201 | 1667 | The Toronto-Dominion Bank | 100.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13005168.86 |
1644 | The Toronto-Dominion Bank | 750.0 | 2017-03-25 00:00:00 | 2017-03-25 | 12793189.39 | |
736 | HSBC Bank Canada | 50.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13257895.53 | |
2017-Contributions-April-14 | 59 | Bard & Banker Pub Company Ltd | 500.0 | 2017-04-09 00:00:00 | 2017-04-09 | 14223712.86 |
2017-Contributions-May-5 | 1015 | TD Bank Financial Group | 5000.0 | 2017-05-03 00:00:00 | 2017-05-03 | 15911034.49 |
2017-Contributions-May-19 | 414 | The Toronto-Dominion Bank | 15000.0 | 2017-05-12 00:00:00 | 2017-05-12 | 17854346.51 |
df_filter('Casino')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 5270 | Gateway Casinos and Entertainment Limited | 3500.00 | 2016-01-01 00:00:00 | 2016-01-01 | 44550.00 |
5272 | Gateway Casinos and Entertainment Limited | 1575.00 | 2016-01-15 00:00:00 | 2016-01-15 | 266045.00 | |
5273 | Gateway Casinos and Entertainment Limited | 2000.00 | 2016-01-22 00:00:00 | 2016-01-22 | 395097.79 | |
12657 | River Rock Casino Resort | 500.00 | 2016-01-25 00:00:00 | 2016-01-25 | 430684.09 | |
5274 | Gateway Casinos and Entertainment Limited | 200.00 | 2016-01-29 00:00:00 | 2016-01-29 | 455258.09 | |
5276 | Gateway Casinos and Entertainment Limited | 2200.00 | 2016-02-26 00:00:00 | 2016-02-26 | 1099230.44 | |
5288 | Gateway Casinos and Entertainment Limited | 750.00 | 2016-03-06 00:00:00 | 2016-03-06 | 1598617.44 | |
5300 | Gateway Casinos and Entertainment Limited | 10300.00 | 2016-03-11 00:00:00 | 2016-03-11 | 1871084.44 | |
4449 | Elements Casino | 1775.00 | 2016-03-18 00:00:00 | 2016-03-18 | 1964010.44 | |
5278 | Gateway Casinos and Entertainment Limited | 460.00 | 2016-03-18 00:00:00 | 2016-03-18 | 2015285.44 | |
5279 | Gateway Casinos and Entertainment Limited | 50.00 | 2016-03-31 00:00:00 | 2016-03-31 | 2332648.44 | |
5292 | Gateway Casinos and Entertainment Limited | 520.00 | 2016-04-07 00:00:00 | 2016-04-07 | 2774038.44 | |
5281 | Gateway Casinos and Entertainment Limited | 7000.00 | 2016-04-15 00:00:00 | 2016-04-15 | 2977653.44 | |
2179 | Cascades Casino Ltd | 500.00 | 2016-04-22 00:00:00 | 2016-04-22 | 3171278.44 | |
5282 | Gateway Casinos and Entertainment Limited | 25.00 | 2016-04-28 00:00:00 | 2016-04-28 | 3341275.44 | |
5283 | Gateway Casinos and Entertainment Limited | 728.00 | 2016-04-30 00:00:00 | 2016-04-30 | 3491337.44 | |
13982 | St. Eugene Golf Resort & Casino | 1500.00 | 2016-05-13 00:00:00 | 2016-05-13 | 4084787.78 | |
5285 | Gateway Casinos and Entertainment Limited | 17080.00 | 2016-05-13 00:00:00 | 2016-05-13 | 3790625.44 | |
5286 | Gateway Casinos and Entertainment Limited | 760.00 | 2016-05-27 00:00:00 | 2016-05-27 | 4297732.78 | |
5287 | Gateway Casinos and Entertainment Limited | 80.00 | 2016-05-31 00:00:00 | 2016-05-31 | 4548281.45 | |
13983 | St. Eugene Golf Resort & Casino | 400.00 | 2016-05-31 00:00:00 | 2016-05-31 | 4454708.11 | |
5284 | Gateway Casinos and Entertainment Limited | 4000.00 | 2016-06-05 00:00:00 | 2016-06-05 | 4728652.45 | |
5289 | Gateway Casinos and Entertainment Limited | 4000.00 | 2016-06-17 00:00:00 | 2016-06-17 | 5090575.78 | |
5290 | Gateway Casinos and Entertainment Limited | 1823.74 | 2016-06-24 00:00:00 | 2016-06-24 | 5236344.52 | |
13984 | St. Eugene Golf Resort & Casino | 50.00 | 2016-06-30 00:00:00 | 2016-06-30 | 5432487.88 | |
5291 | Gateway Casinos and Entertainment Limited | 150.00 | 2016-06-30 00:00:00 | 2016-06-30 | 5365654.52 | |
5293 | Gateway Casinos and Entertainment Limited | 3000.00 | 2016-07-13 00:00:00 | 2016-07-13 | 5616517.88 | |
5294 | Gateway Casinos and Entertainment Limited | 3000.00 | 2016-07-19 00:00:00 | 2016-07-19 | 5734497.88 | |
5271 | Gateway Casinos and Entertainment Limited | 475.00 | 2016-08-01 00:00:00 | 2016-08-01 | 5962931.38 | |
5280 | Gateway Casinos and Entertainment Limited | 2000.00 | 2016-08-04 00:00:00 | 2016-08-04 | 6030365.38 | |
5295 | Gateway Casinos and Entertainment Limited | 520.00 | 2016-09-16 00:00:00 | 2016-09-16 | 6502268.55 | |
5296 | Gateway Casinos and Entertainment Limited | 1000.00 | 2016-09-26 00:00:00 | 2016-09-26 | 6689289.85 | |
5297 | Gateway Casinos and Entertainment Limited | 1050.00 | 2016-09-30 00:00:00 | 2016-09-30 | 6778523.10 | |
5298 | Gateway Casinos and Entertainment Limited | 600.00 | 2016-10-21 00:00:00 | 2016-10-21 | 7222158.35 | |
5299 | Gateway Casinos and Entertainment Limited | 5892.00 | 2016-10-31 00:00:00 | 2016-10-31 | 7723590.60 | |
5277 | Gateway Casinos and Entertainment Limited | 1200.00 | 2016-11-03 00:00:00 | 2016-11-03 | 8044460.96 | |
5301 | Gateway Casinos and Entertainment Limited | 500.00 | 2016-11-21 00:00:00 | 2016-11-21 | 8527731.96 | |
5275 | Gateway Casinos and Entertainment Limited | 7500.00 | 2016-12-02 00:00:00 | 2016-12-02 | 9250927.66 | |
5302 | Gateway Casinos and Entertainment Limited | 500.00 | 2016-12-12 00:00:00 | 2016-12-12 | 9488007.66 | |
5303 | Gateway Casinos and Entertainment Limited | 200.00 | 2016-12-22 00:00:00 | 2016-12-22 | 9853261.36 | |
Copy-of-2017-Contributions-Janu | 64 | Gateway Casinos and Entertainment Limited | 1500.00 | 1/18/2017 | 2017-01-18 | 10991938.78 |
Sheet2 | 357 | Gateway Casinos | 44.00 | 1/20/2017 | 2017-01-20 | 11070178.63 |
358 | Gateway Casinos and Entertainment Limited | 2500.00 | 1/25/2017 | 2017-01-25 | 11132928.63 | |
2017-Contributions-—-February-3 | 176 | Gateway Casinos | 5045.00 | 2017-02-01 00:00:00 | 2017-02-01 | 11273795.63 |
2017-Contributions-_-February-2 | 35 | Gateway Casinos and Entertainment Limited | 1400.00 | 2017-02-22 00:00:00 | 2017-02-22 | 11736840.63 |
2017-Contributions-March-31-201 | 613 | Gateway Casinos and Entertainment Limited | 4000.00 | 2017-03-25 00:00:00 | 2017-03-25 | 12738199.39 |
614 | Gateway Casinos and Entertainment Limited | 8800.00 | 2017-03-28 00:00:00 | 2017-03-28 | 13391502.53 | |
2017-Contributions-April-21 | 455 | Gateway Casinos and Entertainment Limited | 2900.00 | 2017-04-14 00:00:00 | 2017-04-14 | 14677850.86 |
2017-Contributions-April-28-201 | 53 | Billy Barker Casino | 500.00 | 2017-04-21 00:00:00 | 2017-04-21 | 15072170.38 |
df_filter('Casino')['Amount'].sum()
116052.73999999999
df_filter('Ernst')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 4732 | Ernst & Young LLP | 250.0 | 2016-01-01 00:00:00 | 2016-01-01 | 121225.00 |
4733 | Ernst & Young LLP | 10000.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2390868.44 | |
1769 | Bruce Ernst Pydee | 200.0 | 2016-07-31 00:00:00 | 2016-07-31 | 5925572.63 | |
4730 | Ernst & Young | 4000.0 | 2016-07-31 00:00:00 | 2016-07-31 | 5919218.88 | |
4731 | Ernst & Young | 200.0 | 2016-09-29 00:00:00 | 2016-09-29 | 6727990.10 | |
8355 | Karl Ernst | 35.0 | 2016-10-31 00:00:00 | 2016-10-31 | 7704379.60 | |
4734 | Ernst & Young LLP | 3500.0 | 2016-12-12 00:00:00 | 2016-12-12 | 9465647.66 | |
4735 | Ernst & Young LLP | 4500.0 | 2016-12-19 00:00:00 | 2016-12-19 | 9821501.36 | |
Real-Time-Donations-Jan-25V3 | 290 | Karl Ernst | 25.0 | 2017-01-04 00:00:00 | 2017-01-04 | 10476198.67 |
2017-Contributions-—-February-3 | 160 | Ernst & Young LLP | 3500.0 | 2017-02-01 00:00:00 | 2017-02-01 | 11255375.63 |
df_filter('Seaspan')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 13558 | Seaspan ULC | 1000.0 | 2016-01-31 00:00:00 | 2016-01-31 | 506793.09 |
13559 | Seaspan ULC 1 | 0.0 | 2016-02-26 00:00:00 | 2016-02-26 | 1093755.44 | |
13560 | Seaspan ULC | 5000.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2306368.44 | |
13557 | Seaspan International Ltd | 15000.0 | 2016-05-13 00:00:00 | 2016-05-13 | 3961107.11 | |
13561 | Seaspan ULC | 1050.0 | 2016-06-17 00:00:00 | 2016-06-17 | 5084075.78 | |
2017-Contributions-March-3-2017 | 1151 | Seaspan ULC | 5000.0 | 2017-02-24 00:00:00 | 2017-02-24 | 11898429.17 |
2017-Contributions-March-31-201 | 1540 | Seaspan ULC | 1000.0 | 2017-03-25 00:00:00 | 2017-03-25 | 12701904.39 |
2017-Contributions-April-21 | 1130 | Seaspan ULC | 1000.0 | 2017-04-14 00:00:00 | 2017-04-14 | 14560783.86 |
2017-Contributions-May-19 | 392 | Seaspan ULC | 15000.0 | 2017-05-12 00:00:00 | 2017-05-12 | 17791001.51 |
df_filter('Polygon')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 12056 | Polygon Homes Ltd | 500.0 | 2016-01-29 00:00:00 | 2016-01-29 | 442038.09 |
12057 | Polygon Homes Ltd | 15000.0 | 2016-04-15 00:00:00 | 2016-04-15 | 3041158.44 | |
12058 | Polygon Homes Ltd | 10000.0 | 2016-05-13 00:00:00 | 2016-05-13 | 4188977.78 | |
12059 | Polygon Homes Ltd | 1500.0 | 2016-11-15 00:00:00 | 2016-11-15 | 8442131.96 | |
2017-Contributions-March-31-201 | 1360 | Polygon Homes Ltd | 40000.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13138710.53 |
2017-Contributions-May-12 | 452 | Polygon Homes Ltd | 10000.0 | 2017-05-05 00:00:00 | 2017-05-05 | 16520391.82 |
df_filter('Car Dealers')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 11088 | New Car Dealers Association of BC | 6000.0 | 2016-01-15 00:00:00 | 2016-01-15 | 335372.79 |
11089 | New Car Dealers Association of BC | 8500.0 | 2016-01-22 00:00:00 | 2016-01-22 | 412097.79 | |
11090 | New Car Dealers Association of BC | 500.0 | 2016-01-31 00:00:00 | 2016-01-31 | 507768.09 | |
11092 | New Car Dealers Association of BC | 2000.0 | 2016-02-29 00:00:00 | 2016-02-29 | 1409995.44 | |
11100 | New Car Dealers Association of BC | 1500.0 | 2016-03-06 00:00:00 | 2016-03-06 | 1690442.44 | |
11106 | New Car Dealers Association of BC | 8500.0 | 2016-03-11 00:00:00 | 2016-03-11 | 1857934.44 | |
11093 | New Car Dealers Association of BC | 5000.0 | 2016-03-24 00:00:00 | 2016-03-24 | 2038055.44 | |
11094 | New Car Dealers Association of BC | 10000.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2380073.44 | |
11102 | New Car Dealers Association of BC | 300.0 | 2016-04-07 00:00:00 | 2016-04-07 | 2768668.44 | |
11096 | New Car Dealers Association of BC | 1250.0 | 2016-04-30 00:00:00 | 2016-04-30 | 3401549.44 | |
11103 | New Car Dealers Association of BC | 7250.0 | 2016-05-08 00:00:00 | 2016-05-08 | 3572132.44 | |
11097 | New Car Dealers Association of BC | 2200.0 | 2016-05-13 00:00:00 | 2016-05-13 | 4083287.78 | |
11098 | New Car Dealers Association of BC | 3000.0 | 2016-05-20 00:00:00 | 2016-05-20 | 4251772.78 | |
11099 | New Car Dealers Association of BC | 1500.0 | 2016-05-31 00:00:00 | 2016-05-31 | 4474758.11 | |
11101 | New Car Dealers Association of BC | 30750.0 | 2016-06-17 00:00:00 | 2016-06-17 | 4926212.45 | |
11095 | New Car Dealers Association of BC | 5000.0 | 2016-08-04 00:00:00 | 2016-08-04 | 6060415.38 | |
11104 | New Car Dealers Association of BC | 9600.0 | 2016-09-16 00:00:00 | 2016-09-16 | 6511998.55 | |
11105 | New Car Dealers Association of BC | 2000.0 | 2016-09-30 00:00:00 | 2016-09-30 | 6959594.35 | |
11091 | New Car Dealers Association of BC | 3000.0 | 2016-12-02 00:00:00 | 2016-12-02 | 9061112.66 | |
11107 | New Car Dealers Association of BC | 2000.0 | 2016-12-19 00:00:00 | 2016-12-19 | 9571630.36 | |
Real-Time-Donations-Jan-25V3 | 532 | New Car Dealers Association of BC | 2500.0 | 2017-01-05 00:00:00 | 2017-01-05 | 10709433.67 |
Sheet2 | 718 | New Car Dealers Association | 250.0 | 1/20/2017 | 2017-01-20 | 11016471.29 |
2017-Contributions-—-February-3 | 378 | New Car Dealers Association of BC | 3600.0 | 2017-01-27 00:00:00 | 2017-01-27 | 11156269.63 |
2017-Contributions-March-10 | 128 | New Car Dealers Association of BC | 1200.0 | 2017-02-10 00:00:00 | 2017-02-10 | 11595500.63 |
2017-Contributions-February-17 | 128 | New Car Dealers Association of BC | 1200.0 | 2017-02-10 00:00:00 | 2017-02-10 | 11554850.63 |
2017-Contributions-_-February-2 | 86 | New Car Dealers Association of BC | 1500.0 | 2017-02-17 00:00:00 | 2017-02-17 | 11683700.63 |
2017-Contributions-—-March-17-2 | 118 | New Car Dealers Association | 2000.0 | 2017-03-10 00:00:00 | 2017-03-10 | 12154141.34 |
2017-Contributions-March-23 | 95 | New Car Dealers Association | 1800.0 | 2017-03-17 00:00:00 | 2017-03-17 | 12160066.34 |
2017-Contributions-March-31-201 | 1247 | New Car Dealers Association | 2000.0 | 2017-03-24 00:00:00 | 2017-03-24 | 12318748.19 |
2017-Contributions-April-14 | 503 | New Car Dealers Association of BC | 7000.0 | 2017-04-07 00:00:00 | 2017-04-07 | 14041240.86 |
504 | New Car Dealers Association of BC | 3700.0 | 2017-04-08 00:00:00 | 2017-04-08 | 14186017.86 | |
2017-Contributions-May-12 | 405 | New Car Dealers Association of BC | 2000.0 | 2017-05-08 00:00:00 | 2017-05-08 | 17140784.01 |
406 | New Car Dealers Association of BC | 4000.0 | 2017-05-09 00:00:00 | 2017-05-09 | 17230500.01 |
df_filter('Car Dealers')['Amount'].sum()
142600.0
df_filter('Aquilini')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 774 | Aquilini Investment Group LP | 2500.0 | 2016-01-01 00:00:00 | 2016-01-01 | 78350.00 |
777 | Aquilini Investment Group LP | 10000.0 | 2016-01-04 00:00:00 | 2016-01-04 | 220045.00 | |
775 | Aquilini Investment Group LP | 2500.0 | 2016-01-31 00:00:00 | 2016-01-31 | 667362.09 | |
776 | Aquilini Investment Group LP | 10000.0 | 2016-02-26 00:00:00 | 2016-02-26 | 983310.44 | |
778 | Aquilini Investment Group LP | 25000.0 | 2016-04-22 00:00:00 | 2016-04-22 | 3328120.44 | |
780 | Aquilini Investment Group LP | 5000.0 | 2016-10-30 00:00:00 | 2016-10-30 | 7479604.85 | |
781 | Aquilini Investment Group LP | 1000.0 | 2016-10-31 00:00:00 | 2016-10-31 | 7713993.60 | |
779 | Aquilini Investment Group LP | 75000.0 | 2016-11-10 00:00:00 | 2016-11-10 | 8234965.96 | |
2017-Contributions-—-February-3 | 25 | Aquilini Investment Group | 2500.0 | 2017-01-27 00:00:00 | 2017-01-27 | 11185925.63 |
26 | Aquilini Investments | 2500.0 | 2017-01-27 00:00:00 | 2017-01-27 | 11188425.63 | |
2017-Contributions-March-31-201 | 86 | Aquilini Investment Group LP | 2400.0 | 2017-03-28 00:00:00 | 2017-03-28 | 13536152.53 |
df_filter('Robert J Macdonald')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 12784 | Robert J Macdonald | 500.0 | 2016-01-31 00:00:00 | 2016-01-31 | 671187.09 |
12789 | Robert J Macdonald | 1000.0 | 2016-03-11 00:00:00 | 2016-03-11 | 1877254.44 | |
12788 | Robert J Macdonald | 500.0 | 2016-05-08 00:00:00 | 2016-05-08 | 3601962.44 | |
12786 | Robert J Macdonald | 10000.0 | 2016-05-27 00:00:00 | 2016-05-27 | 4319305.11 | |
12787 | Robert J Macdonald | 1000.0 | 2016-06-28 00:00:00 | 2016-06-28 | 5293254.52 | |
12785 | Robert J Macdonald | 10000.0 | 2016-11-03 00:00:00 | 2016-11-03 | 8062085.96 | |
Real-Time-Donations-Jan-25V3 | 426 | Robert J Macdonald | 1000.0 | 2017-01-04 00:00:00 | 2017-01-04 | 10658903.67 |
2017-Contributions-March-31-201 | 1453 | Robert J Macdonald | 3000.0 | 2017-03-28 00:00:00 | 2017-03-28 | 13634677.53 |
df_filter('Insurance')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 6634 | Insurance Brokers Association of BC | 1000.0 | 2016-01-04 00:00:00 | 2016-01-04 | 172750.00 |
6639 | Insurance Bureau of Canada | 1000.0 | 2016-01-04 00:00:00 | 2016-01-04 | 201100.00 | |
932 | B & W Insurance Brokers | 250.0 | 2016-02-29 00:00:00 | 2016-02-29 | 1387680.44 | |
6647 | Insurance Bureau of Canada | 1350.0 | 2016-03-11 00:00:00 | 2016-03-11 | 1874704.44 | |
6637 | Insurance Bureau of Canada | 1100.0 | 2016-03-18 00:00:00 | 2016-03-18 | 2007325.44 | |
6638 | Insurance Bureau of Canada | 250.0 | 2016-03-24 00:00:00 | 2016-03-24 | 2025700.44 | |
1464 | Boehmer Insurance And Investment Group Inc. | 180.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2198873.44 | |
10575 | Michael K Wong Magc Insurance Adjus | 100.0 | 2016-03-31 00:00:00 | 2016-03-31 | 2151828.44 | |
2008 | Capri Insurance Services Ltd. | 1000.0 | 2016-04-15 00:00:00 | 2016-04-15 | 3159703.44 | |
6641 | Insurance Bureau of Canada | 7500.0 | 2016-05-13 00:00:00 | 2016-05-13 | 4103787.78 | |
6642 | Insurance Bureau of Canada | 428.0 | 2016-05-27 00:00:00 | 2016-05-27 | 4339693.11 | |
933 | B & W Insurance Brokers | 1000.0 | 2016-05-31 00:00:00 | 2016-05-31 | 4578481.45 | |
6644 | Insurance Bureau of Canada | 400.0 | 2016-06-17 00:00:00 | 2016-06-17 | 4963812.45 | |
6635 | Insurance Brokers Association of BC | 2500.0 | 2016-06-17 00:00:00 | 2016-06-17 | 4928712.45 | |
6645 | Insurance Bureau of Canada | 8000.0 | 2016-07-13 00:00:00 | 2016-07-13 | 5597897.88 | |
6640 | Insurance Bureau of Canada | 250.0 | 2016-08-04 00:00:00 | 2016-08-04 | 6036315.38 | |
6646 | Insurance Bureau of Canada | 100.0 | 2016-08-19 00:00:00 | 2016-08-19 | 6149840.38 | |
6643 | Insurance Bureau of Canada | 1000.0 | 2016-10-06 00:00:00 | 2016-10-06 | 7145593.35 | |
6041 | Halsey Insurance & Investment Services Ltd | 5000.0 | 2016-10-14 00:00:00 | 2016-10-14 | 7211098.35 | |
14844 | Tony Lau Insurance | 100.0 | 2016-10-30 00:00:00 | 2016-10-30 | 7396145.60 | |
11084 | Network Bonding & Insurance Services Inc | 550.0 | 2016-11-03 00:00:00 | 2016-11-03 | 8020129.96 | |
6636 | Insurance Bureau of Canada | 500.0 | 2016-11-03 00:00:00 | 2016-11-03 | 8091375.96 | |
7985 | Johnston Meier Insurance Agencies Group | 100.0 | 2016-11-10 00:00:00 | 2016-11-10 | 8110075.96 | |
430 | Allied Insurance Services Inc | 100.0 | 2016-11-15 00:00:00 | 2016-11-15 | 8372891.96 | |
485 | AMC Insurance Services Ltd | 1000.0 | 2016-11-15 00:00:00 | 2016-11-15 | 8489556.96 | |
6042 | Halsey Insurance & Investment Services Ltd | 1000.0 | 2016-11-15 00:00:00 | 2016-11-15 | 8339225.96 | |
6648 | Insurance Bureau of Canada | 2500.0 | 2016-11-21 00:00:00 | 2016-11-21 | 8506761.96 | |
15417 | Waypoint Insurance | 500.0 | 2016-11-30 00:00:00 | 2016-11-30 | 8961176.66 | |
13336 | RW Schmunk Insurance Services Ltd. | 2500.0 | 2016-12-02 00:00:00 | 2016-12-02 | 9201597.66 | |
4746 | ES3 Insurance Services Ltd | 2600.0 | 2016-12-02 00:00:00 | 2016-12-02 | 9237312.66 | |
Real-Time-Donations-Jan-25V3 | 318 | Lynn Valley Insurance Agency Ltd. | 250.0 | 2017-01-04 00:00:00 | 2017-01-04 | 10466453.67 |
239 | Insurance Bureau of Canada | 300.0 | 2017-01-04 00:00:00 | 2017-01-04 | 10511948.67 | |
2017-Contributions-—-February-3 | 238 | Insurance Bureau of Canada | 550.0 | 2017-02-01 00:00:00 | 2017-02-01 | 11318230.63 |
2017-Contributions-March-3-2017 | 789 | Londsdale Insurance Brokers | 100.0 | 2017-02-28 00:00:00 | 2017-02-28 | 12018259.34 |
2017-Contributions-March-31-201 | 745 | Insurance Bureau of Canada | 250.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13203430.53 |
41 | Allied Insurance Services Inc | 100.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13028725.53 | |
746 | Insurance Bureau of Canada | 2300.0 | 2017-03-28 00:00:00 | 2017-03-28 | 13416807.53 | |
241 | Capital West Insurance Services LTD. | 3000.0 | 2017-03-28 00:00:00 | 2017-03-28 | 13447007.53 | |
2017-Contributions-April-7 | 22 | Allwest Insurance Services Ltd | 2500.0 | 2017-04-03 00:00:00 | 2017-04-03 | 13841525.86 |
276 | Greg Andrews Insurance Services Inc. | 500.0 | 2017-04-03 00:00:00 | 2017-04-03 | 13929475.86 | |
2017-Contributions-April-14 | 474 | Maxxam Insurance Services Inc | 1000.0 | 2017-04-09 00:00:00 | 2017-04-09 | 14510418.86 |
73 | Boehmer Insurance And Investment Group Inc. | 500.0 | 2017-04-09 00:00:00 | 2017-04-09 | 14233162.86 | |
2017-Contributions-April-21 | 556 | Insurance Bureau of Canada | 3100.0 | 2017-04-14 00:00:00 | 2017-04-14 | 14618678.86 |
15 | AKT Insurance Services Ltd | 1000.0 | 2017-04-14 00:00:00 | 2017-04-14 | 14805486.53 | |
2017-Contributions-April-28-201 | 210 | Insurance Bureau of Canada | 500.0 | 2017-04-21 00:00:00 | 2017-04-21 | 15130680.38 |
209 | Insurance Brokers Association of BC | 1000.0 | 2017-04-21 00:00:00 | 2017-04-21 | 15131680.38 | |
24 | Alport Insurance Agencies Inc | 1000.0 | 2017-04-21 00:00:00 | 2017-04-21 | 14841622.38 | |
11 | A & S Insurance Services Ltd. | 2500.0 | 2017-04-21 00:00:00 | 2017-04-21 | 14875454.38 | |
2017-Contributions-May-5 | 497 | Insurance Bureau of Canada | 1000.0 | 2017-04-28 00:00:00 | 2017-04-28 | 15439965.38 |
495 | Insurance Bureau of Canada | 4000.0 | 2017-04-29 00:00:00 | 2017-04-29 | 15592516.49 | |
496 | Insurance Bureau of Canada | 1500.0 | 2017-05-03 00:00:00 | 2017-05-03 | 15718034.49 | |
2017-Contributions-June-2 | 228 | Great Pacific Captive Insurance Ltd. | 10000.0 | 2017-05-26 00:00:00 | 2017-05-26 | 18157627.59 |
260 | Insurance Bureau of Canada | 1050.0 | 2017-05-30 00:00:00 | 2017-05-30 | 18345298.09 | |
244 | Hendry Swinton McKenzie Insurance Services (We... | 300.0 | 2017-05-30 00:00:00 | 2017-05-30 | 18325148.09 |
df_filter('Insurance')['Amount'].sum()
82158.0
df_filter('Automotive')['Amount'].sum()
23492.0
pd.pivot_table(df,index=['Donor Name'],
aggfunc = sum, values = ['Amount']).sort_values(by=['Amount'],
ascending=[False]).head(n=30).plot(kind='bar')
<matplotlib.axes._subplots.AxesSubplot at 0x7f4c637ab1d0>
## Top 25 Donors
pd.pivot_table(df,index=['Donor Name'],
aggfunc = sum, values = ['Amount']).sort_values(by=['Amount'], ascending=[False]).head(n=25)
Amount | |
---|---|
Donor Name | |
Independent Contractors & Businesses Association of BC | 174700.00 |
New Car Dealers Association of BC | 136550.00 |
Aquilini Investment Group LP | 133400.00 |
Progressive Waste Solutions Canada Inc | 123700.00 |
Wesgroup Properties Ltd | 121750.00 |
Encana Corporation Ltd | 121200.00 |
West Fraser Mills Ltd | 114300.00 |
Gateway Casinos and Entertainment Limited | 105738.74 |
Interfor Corporation | 97050.00 |
Sandman Hotels, Inns & Suites Ltd | 95000.00 |
Canadian Forest Products Ltd | 90650.00 |
LifeLabs Inc | 85955.00 |
Anthem Properties Group Ltd. | 84000.00 |
Fasken Martineau DuMoulin LLP | 83025.00 |
Polygon Homes Ltd | 77000.00 |
Starline Windows (2001) Ltd. | 75000.00 |
Wesbild Holdings Ltd | 72500.00 |
Shato Holdings Ltd. | 70200.00 |
Great Canadian Gaming Corp. | 68995.00 |
Anthem Properties Corp Ltd | 68200.00 |
Tolko Industries Ltd | 67850.00 |
Woodfibre LNG Ltd. | 67500.00 |
The Pacific Investment Corporation Ltd. | 65000.00 |
Burnco Rock Products Ltd. | 64000.00 |
Western Forest Products Inc. | 63300.00 |
## Most frequent Donors
pd.pivot_table(df,index=['Donor Name'],
aggfunc = len, values = ['Amount']).sort_values(by=['Amount'], ascending=[False]).head(n=25)
Amount | |
---|---|
Donor Name | |
Gateway Casinos and Entertainment Limited | 40.0 |
Great Canadian Gaming Corp. | 30.0 |
New Car Dealers Association of BC | 29.0 |
Insurance Bureau of Canada | 23.0 |
Janet Smukowich | 22.0 |
Independent Contractors & Businesses Association of BC | 20.0 |
LifeLabs Inc | 20.0 |
Stewart Vinnels | 19.0 |
Stephen P. Roberts | 19.0 |
Wazuku Advisory Group Inc. | 18.0 |
Encana Corporation Ltd | 18.0 |
Marina Guest | 17.0 |
Jess Ketchum | 17.0 |
Telus | 16.0 |
Tek S. Manhas | 15.0 |
Richard Lane | 15.0 |
Michael Lee | 15.0 |
Mark Robertson | 15.0 |
Anthem Properties Corp Ltd | 15.0 |
Cynthia Shore | 14.0 |
Lonnie Neufeld | 14.0 |
Niall Paltiel | 14.0 |
FortisBC Energy Inc. | 14.0 |
Wesbild Holdings Ltd | 14.0 |
Jeff Guignard | 14.0 |
## Donation yield from top 100 donors
pd.pivot_table(df,index=['Donor Name'],
aggfunc = sum, values = ['Amount']).sort_values(by=['Amount'], ascending=[False]).head(n=100)['Amount'].sum()
5012371.4699999997
## Donation yield from top 100 donors
pd.pivot_table(df,index=['Donor Name'],
aggfunc = sum, values = ['Amount']).sort_values(by=['Amount'],
ascending=[False]).head(n=100)['Amount'].plot(kind='hist')
<matplotlib.axes._subplots.AxesSubplot at 0x7f54366c6fd0>
## Fraction of total donations from top 100 donors
pd.pivot_table(df,index=['Donor Name'],
aggfunc = sum,
values = ['Amount']).sort_values(by=['Amount'], ascending=[False]).head(n=100)['Amount'].sum()/df['Amount'].sum()
0.27005249922877489
len(df['Donor Name'].unique())
15306
pd.pivot_table(df,index=['datetime'],
aggfunc = sum, values = ['Amount']).sort_values(by=['Amount'],
ascending=[False]).head(n=30).plot(kind='bar')
<matplotlib.axes._subplots.AxesSubplot at 0x7f4c63b094a8>
pd.pivot_table(df,index=['datetime'],
aggfunc = sum, values = ['Amount']).sort_values(by=['Amount'],
ascending=[False]).head(n=4)
Amount | |
---|---|
datetime | |
2017-03-25 | 938817.34 |
2017-05-12 | 814751.50 |
2016-02-26 | 548565.00 |
2017-05-05 | 546109.52 |
The BC Liberal Party received $939K in donations on 2017-03-25.
Copied from UBCBoG site
Appointed by the Province
Stuart Belkin (Chair) December 2018
Sandra Cawley December 2018
Raghwa Gopal December 2017
Celeste Haldane December 2017
Michael Korenberg (Vice-Chair) December 2017
Graham Lee December 2017
Fiona Macfarlane December 2018
Beverlee Park December 2017
Alan Shuster February 2020
David Sidoo December 2017
Kevin Smith December 2018
ubc_board = ['Stuart Belkin',
'Sandra Cawley',
'Raghwa Gopal',
'Celeste Haldane',
'Michael Korenberg',
'Graham Lee',
'Fiona Macfarlan',
'Beverlee Park',
'Alan Shuster',
'David Sidoo',
'Kevin Smith',
]
for name in ubc_board:
print(name, df_filter(name)['Amount'].sum())
Stuart Belkin 0 Sandra Cawley 0 Raghwa Gopal 1000.0 Celeste Haldane 0 Michael Korenberg 2500.0 Graham Lee 2300.0 Fiona Macfarlan 1800.0 Beverlee Park 0 Alan Shuster 0 David Sidoo 10000.0 Kevin Smith 0
df_filter('Graham Lee')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 5813 | Graham Lee | 1150.0 | 2016-04-30 00:00:00 | 2016-04-30 | 3389935.44 |
2017-Contributions-March-3-2017 | 490 | Graham Lee | 1150.0 | 2017-02-24 00:00:00 | 2017-02-24 | 11745080.63 |
df_filter('David Sidoo')
Donor Name | Amount | Date | datetime | cumsum | ||
---|---|---|---|---|---|---|
Copy-of-2016-Contributions-v4 | 3416 | David Sidoo | 2500.0 | 2016-01-31 00:00:00 | 2016-01-31 | 470908.09 |
3417 | David Sidoo | 5000.0 | 2016-02-29 00:00:00 | 2016-02-29 | 1306830.44 | |
2017-Contributions-March-31-201 | 390 | David Sidoo | 2500.0 | 2017-03-25 00:00:00 | 2017-03-25 | 13079040.53 |