dnc-emails
-----BEGIN PGP PUBLIC KEY BLOCK-----
mQQBBGBjDtIBH6DJa80zDBgR+VqlYGaXu5bEJg9HEgAtJeCLuThdhXfl5Zs32RyB
I1QjIlttvngepHQozmglBDmi2FZ4S+wWhZv10bZCoyXPIPwwq6TylwPv8+buxuff
B6tYil3VAB9XKGPyPjKrlXn1fz76VMpuTOs7OGYR8xDidw9EHfBvmb+sQyrU1FOW
aPHxba5lK6hAo/KYFpTnimsmsz0Cvo1sZAV/EFIkfagiGTL2J/NhINfGPScpj8LB
bYelVN/NU4c6Ws1ivWbfcGvqU4lymoJgJo/l9HiV6X2bdVyuB24O3xeyhTnD7laf
epykwxODVfAt4qLC3J478MSSmTXS8zMumaQMNR1tUUYtHCJC0xAKbsFukzbfoRDv
m2zFCCVxeYHvByxstuzg0SurlPyuiFiy2cENek5+W8Sjt95nEiQ4suBldswpz1Kv
n71t7vd7zst49xxExB+tD+vmY7GXIds43Rb05dqksQuo2yCeuCbY5RBiMHX3d4nU
041jHBsv5wY24j0N6bpAsm/s0T0Mt7IO6UaN33I712oPlclTweYTAesW3jDpeQ7A
ioi0CMjWZnRpUxorcFmzL/Cc/fPqgAtnAL5GIUuEOqUf8AlKmzsKcnKZ7L2d8mxG
QqN16nlAiUuUpchQNMr+tAa1L5S1uK/fu6thVlSSk7KMQyJfVpwLy6068a1WmNj4
yxo9HaSeQNXh3cui+61qb9wlrkwlaiouw9+bpCmR0V8+XpWma/D/TEz9tg5vkfNo
eG4t+FUQ7QgrrvIkDNFcRyTUO9cJHB+kcp2NgCcpCwan3wnuzKka9AWFAitpoAwx
L6BX0L8kg/LzRPhkQnMOrj/tuu9hZrui4woqURhWLiYi2aZe7WCkuoqR/qMGP6qP
EQRcvndTWkQo6K9BdCH4ZjRqcGbY1wFt/qgAxhi+uSo2IWiM1fRI4eRCGifpBtYK
Dw44W9uPAu4cgVnAUzESEeW0bft5XXxAqpvyMBIdv3YqfVfOElZdKbteEu4YuOao
FLpbk4ajCxO4Fzc9AugJ8iQOAoaekJWA7TjWJ6CbJe8w3thpznP0w6jNG8ZleZ6a
jHckyGlx5wzQTRLVT5+wK6edFlxKmSd93jkLWWCbrc0Dsa39OkSTDmZPoZgKGRhp
Yc0C4jePYreTGI6p7/H3AFv84o0fjHt5fn4GpT1Xgfg+1X/wmIv7iNQtljCjAqhD
6XN+QiOAYAloAym8lOm9zOoCDv1TSDpmeyeP0rNV95OozsmFAUaKSUcUFBUfq9FL
uyr+rJZQw2DPfq2wE75PtOyJiZH7zljCh12fp5yrNx6L7HSqwwuG7vGO4f0ltYOZ
dPKzaEhCOO7o108RexdNABEBAAG0Rldpa2lMZWFrcyBFZGl0b3JpYWwgT2ZmaWNl
IEhpZ2ggU2VjdXJpdHkgQ29tbXVuaWNhdGlvbiBLZXkgKDIwMjEtMjAyNCmJBDEE
EwEKACcFAmBjDtICGwMFCQWjmoAFCwkIBwMFFQoJCAsFFgIDAQACHgECF4AACgkQ
nG3NFyg+RUzRbh+eMSKgMYOdoz70u4RKTvev4KyqCAlwji+1RomnW7qsAK+l1s6b
ugOhOs8zYv2ZSy6lv5JgWITRZogvB69JP94+Juphol6LIImC9X3P/bcBLw7VCdNA
mP0XQ4OlleLZWXUEW9EqR4QyM0RkPMoxXObfRgtGHKIkjZYXyGhUOd7MxRM8DBzN
yieFf3CjZNADQnNBk/ZWRdJrpq8J1W0dNKI7IUW2yCyfdgnPAkX/lyIqw4ht5UxF
VGrva3PoepPir0TeKP3M0BMxpsxYSVOdwcsnkMzMlQ7TOJlsEdtKQwxjV6a1vH+t
k4TpR4aG8fS7ZtGzxcxPylhndiiRVwdYitr5nKeBP69aWH9uLcpIzplXm4DcusUc
Bo8KHz+qlIjs03k8hRfqYhUGB96nK6TJ0xS7tN83WUFQXk29fWkXjQSp1Z5dNCcT
sWQBTxWxwYyEI8iGErH2xnok3HTyMItdCGEVBBhGOs1uCHX3W3yW2CooWLC/8Pia
qgss3V7m4SHSfl4pDeZJcAPiH3Fm00wlGUslVSziatXW3499f2QdSyNDw6Qc+chK
hUFflmAaavtpTqXPk+Lzvtw5SSW+iRGmEQICKzD2chpy05mW5v6QUy+G29nchGDD
rrfpId2Gy1VoyBx8FAto4+6BOWVijrOj9Boz7098huotDQgNoEnidvVdsqP+P1RR
QJekr97idAV28i7iEOLd99d6qI5xRqc3/QsV+y2ZnnyKB10uQNVPLgUkQljqN0wP
XmdVer+0X+aeTHUd1d64fcc6M0cpYefNNRCsTsgbnWD+x0rjS9RMo+Uosy41+IxJ
6qIBhNrMK6fEmQoZG3qTRPYYrDoaJdDJERN2E5yLxP2SPI0rWNjMSoPEA/gk5L91
m6bToM/0VkEJNJkpxU5fq5834s3PleW39ZdpI0HpBDGeEypo/t9oGDY3Pd7JrMOF
zOTohxTyu4w2Ql7jgs+7KbO9PH0Fx5dTDmDq66jKIkkC7DI0QtMQclnmWWtn14BS
KTSZoZekWESVYhORwmPEf32EPiC9t8zDRglXzPGmJAPISSQz+Cc9o1ipoSIkoCCh
2MWoSbn3KFA53vgsYd0vS/+Nw5aUksSleorFns2yFgp/w5Ygv0D007k6u3DqyRLB
W5y6tJLvbC1ME7jCBoLW6nFEVxgDo727pqOpMVjGGx5zcEokPIRDMkW/lXjw+fTy
c6misESDCAWbgzniG/iyt77Kz711unpOhw5aemI9LpOq17AiIbjzSZYt6b1Aq7Wr
aB+C1yws2ivIl9ZYK911A1m69yuUg0DPK+uyL7Z86XC7hI8B0IY1MM/MbmFiDo6H
dkfwUckE74sxxeJrFZKkBbkEAQRgYw7SAR+gvktRnaUrj/84Pu0oYVe49nPEcy/7
5Fs6LvAwAj+JcAQPW3uy7D7fuGFEQguasfRrhWY5R87+g5ria6qQT2/Sf19Tpngs
d0Dd9DJ1MMTaA1pc5F7PQgoOVKo68fDXfjr76n1NchfCzQbozS1HoM8ys3WnKAw+
Neae9oymp2t9FB3B+To4nsvsOM9KM06ZfBILO9NtzbWhzaAyWwSrMOFFJfpyxZAQ
8VbucNDHkPJjhxuafreC9q2f316RlwdS+XjDggRY6xD77fHtzYea04UWuZidc5zL
VpsuZR1nObXOgE+4s8LU5p6fo7jL0CRxvfFnDhSQg2Z617flsdjYAJ2JR4apg3Es
G46xWl8xf7t227/0nXaCIMJI7g09FeOOsfCmBaf/ebfiXXnQbK2zCbbDYXbrYgw6
ESkSTt940lHtynnVmQBvZqSXY93MeKjSaQk1VKyobngqaDAIIzHxNCR941McGD7F
qHHM2YMTgi6XXaDThNC6u5msI1l/24PPvrxkJxjPSGsNlCbXL2wqaDgrP6LvCP9O
uooR9dVRxaZXcKQjeVGxrcRtoTSSyZimfjEercwi9RKHt42O5akPsXaOzeVjmvD9
EB5jrKBe/aAOHgHJEIgJhUNARJ9+dXm7GofpvtN/5RE6qlx11QGvoENHIgawGjGX
Jy5oyRBS+e+KHcgVqbmV9bvIXdwiC4BDGxkXtjc75hTaGhnDpu69+Cq016cfsh+0
XaRnHRdh0SZfcYdEqqjn9CTILfNuiEpZm6hYOlrfgYQe1I13rgrnSV+EfVCOLF4L
P9ejcf3eCvNhIhEjsBNEUDOFAA6J5+YqZvFYtjk3efpM2jCg6XTLZWaI8kCuADMu
yrQxGrM8yIGvBndrlmmljUqlc8/Nq9rcLVFDsVqb9wOZjrCIJ7GEUD6bRuolmRPE
SLrpP5mDS+wetdhLn5ME1e9JeVkiSVSFIGsumZTNUaT0a90L4yNj5gBE40dvFplW
7TLeNE/ewDQk5LiIrfWuTUn3CqpjIOXxsZFLjieNgofX1nSeLjy3tnJwuTYQlVJO
3CbqH1k6cOIvE9XShnnuxmiSoav4uZIXnLZFQRT9v8UPIuedp7TO8Vjl0xRTajCL
PdTk21e7fYriax62IssYcsbbo5G5auEdPO04H/+v/hxmRsGIr3XYvSi4ZWXKASxy
a/jHFu9zEqmy0EBzFzpmSx+FrzpMKPkoU7RbxzMgZwIYEBk66Hh6gxllL0JmWjV0
iqmJMtOERE4NgYgumQT3dTxKuFtywmFxBTe80BhGlfUbjBtiSrULq59np4ztwlRT
wDEAVDoZbN57aEXhQ8jjF2RlHtqGXhFMrg9fALHaRQARAQABiQQZBBgBCgAPBQJg
Yw7SAhsMBQkFo5qAAAoJEJxtzRcoPkVMdigfoK4oBYoxVoWUBCUekCg/alVGyEHa
ekvFmd3LYSKX/WklAY7cAgL/1UlLIFXbq9jpGXJUmLZBkzXkOylF9FIXNNTFAmBM
3TRjfPv91D8EhrHJW0SlECN+riBLtfIQV9Y1BUlQthxFPtB1G1fGrv4XR9Y4TsRj
VSo78cNMQY6/89Kc00ip7tdLeFUHtKcJs+5EfDQgagf8pSfF/TWnYZOMN2mAPRRf
fh3SkFXeuM7PU/X0B6FJNXefGJbmfJBOXFbaSRnkacTOE9caftRKN1LHBAr8/RPk
pc9p6y9RBc/+6rLuLRZpn2W3m3kwzb4scDtHHFXXQBNC1ytrqdwxU7kcaJEPOFfC
XIdKfXw9AQll620qPFmVIPH5qfoZzjk4iTH06Yiq7PI4OgDis6bZKHKyyzFisOkh
DXiTuuDnzgcu0U4gzL+bkxJ2QRdiyZdKJJMswbm5JDpX6PLsrzPmN314lKIHQx3t
NNXkbfHL/PxuoUtWLKg7/I3PNnOgNnDqCgqpHJuhU1AZeIkvewHsYu+urT67tnpJ
AK1Z4CgRxpgbYA4YEV1rWVAPHX1u1okcg85rc5FHK8zh46zQY1wzUTWubAcxqp9K
1IqjXDDkMgIX2Z2fOA1plJSwugUCbFjn4sbT0t0YuiEFMPMB42ZCjcCyA1yysfAd
DYAmSer1bq47tyTFQwP+2ZnvW/9p3yJ4oYWzwMzadR3T0K4sgXRC2Us9nPL9k2K5
TRwZ07wE2CyMpUv+hZ4ja13A/1ynJZDZGKys+pmBNrO6abxTGohM8LIWjS+YBPIq
trxh8jxzgLazKvMGmaA6KaOGwS8vhfPfxZsu2TJaRPrZMa/HpZ2aEHwxXRy4nm9G
Kx1eFNJO6Ues5T7KlRtl8gflI5wZCCD/4T5rto3SfG0s0jr3iAVb3NCn9Q73kiph
PSwHuRxcm+hWNszjJg3/W+Fr8fdXAh5i0JzMNscuFAQNHgfhLigenq+BpCnZzXya
01kqX24AdoSIbH++vvgE0Bjj6mzuRrH5VJ1Qg9nQ+yMjBWZADljtp3CARUbNkiIg
tUJ8IJHCGVwXZBqY4qeJc3h/RiwWM2UIFfBZ+E06QPznmVLSkwvvop3zkr4eYNez
cIKUju8vRdW6sxaaxC/GECDlP0Wo6lH0uChpE3NJ1daoXIeymajmYxNt+drz7+pd
jMqjDtNA2rgUrjptUgJK8ZLdOQ4WCrPY5pP9ZXAO7+mK7S3u9CTywSJmQpypd8hv
8Bu8jKZdoxOJXxj8CphK951eNOLYxTOxBUNB8J2lgKbmLIyPvBvbS1l1lCM5oHlw
WXGlp70pspj3kaX4mOiFaWMKHhOLb+er8yh8jspM184=
=5a6T
-----END PGP PUBLIC KEY BLOCK-----
Yeah, sounds good.
From: Parrish, Daniel
Sent: Friday, May 13, 2016 5:22 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: Re: NFC sheet
Interesting. I know it's technically an off week, but could we discuss that more on Tuesday? That might be really useful, but I want to talk to some of the people in our dept first.
On May 13, 2016, at 5:06 PM, Johnson, Matt <[email protected]<mailto:[email protected]>> wrote:
My understanding is that FEC data can't be used for prospecting donors, but can be used on our current donors.
So, for example, if we have a donor that has dropped off, we can see where else they are giving/etc. I don't think that's overly useful, but it might be nice to know how they ARE spending their money before jumping on the phone.
In addition, without the aggregate amounts across campaigns/committees, we could see how much they are giving in general.
I dunno; I'm just spitballing ideas right now.
-Matt
From: Parrish, Daniel
Sent: Friday, May 13, 2016 4:12 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Haha I know, it would make life so much easier.
From: Johnson, Matt
Sent: Friday, May 13, 2016 4:05 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Yeah, no problem.
If only the FEC allowed us to do it for other organizations as well. :/
-Matt
From: Parrish, Daniel
Sent: Friday, May 13, 2016 4:02 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet
That's perfect. Thank you so much for this!
From: Johnson, Matt
Sent: Friday, May 13, 2016 3:19 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Hey Team,
I added these to the yearly report!
It should be anyone who gave more than $5k over the years.
The totals are a huge blanket of donations. It doesn't matter how/where the money is coming from, just that it came in.
-Matt
From: Parrish, Daniel
Sent: Thursday, May 12, 2016 10:02 AM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Hey, one more question - could we add email, work phone, and home phone after the region column? We should be all set then.
Thanks!
From: Parrish, Daniel
Sent: Wednesday, May 11, 2016 6:14 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: Re: NFC sheet
Looks great! And thank you for the other report- that's going to be a huge help. Is this everyone from 5k+ to any account? I forget where we ended up on who to pull from. And this also updates nightly?
Thanks again!
On May 11, 2016, at 5:36 PM, Johnson, Matt <[email protected]<mailto:[email protected]>> wrote:
Yeah! Take a look.
From: Parrish, Daniel
Sent: Wednesday, May 11, 2016 5:36 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: Re: NFC sheet
Haha sounds good. Thanks!
On May 11, 2016, at 5:33 PM, Johnson, Matt <[email protected]<mailto:[email protected]>> wrote:
Hey! I didn't think we could but apparently we can.
-Matt
From: Parrish, Daniel
Sent: Wednesday, May 11, 2016 5:01 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Yep! All looks good. We just had one more request from Max - could we combine TX/OK and South on the regional tabs? He does both, so it's helpful to see the distinction, but he'd like them in one place. Is that possible?
Thanks!
From: Johnson, Matt
Sent: Wednesday, May 11, 2016 10:43 AM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Looping back: everything working with this at least? The formula are still there, and it says everything ran last night.
-Matt
From: Parrish, Daniel
Sent: Tuesday, May 10, 2016 3:41 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Perfect. Thank you so much! And no rush on the other report - by the end of the week is definitely fine.
Thanks again!
From: Johnson, Matt
Sent: Tuesday, May 10, 2016 3:40 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Cool; I've updated the scripts and we are good for tomorrow.
I'll try and tackle the report we talked about later today.
-Matt
From: Parrish, Daniel
Sent: Tuesday, May 10, 2016 3:32 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Thanks! I just updated it on the master, let me know if you have any questions!
From: Johnson, Matt
Sent: Tuesday, May 10, 2016 2:16 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet
Yeah, absolutely! You want to add the columns and formulas and I'll update the script?
We could knock this out today.
-Matt
From: Parrish, Daniel
Sent: Tuesday, May 10, 2016 10:50 AM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: NFC sheet
Hi Matt,
We'd like to add two columns just to the right of the convention package column that will not be overwritten (so we can add formulas). Is it possible to add them this afternoon? Some of the finance staff asked about the possibility of including it just after we got back, so we'd love to get it all set today.
Thanks!
Dan
-------------
Daniel Parrish
Democratic National Committee
Finance | Director of Data & Strategic Initiatives
Phone: (202) 479-5141 | Mobile: (717) 283-7521
430 South Capitol Street, SE | Washington, DC 20003
ℹ️ Document Details
SHA-256
6ca52ef2a7bd009d1fadbd3251ee983744e42a5b3dc5defbcc6bdef71ed744aa
Dataset
dnc-emails
Document Type
email
Comments 0