state_iec
653 rows where type = "Mailing"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
748 | 748 | Coloradans For Constitutional Values | Polestar | 8815.0 | 5/30/20 | 6/3/20 | Mailing | Supporting | Simpson, Cleave Alan | Republican | Senate District 35 |
749 | 749 | Coloradans For Constitutional Values | Polestar | 6558.0 | 5/30/20 | 6/1/20 | Mailing | Supporting | Van Beber, Tonya | Republican | House District 48 |
750 | 750 | Coloradans For Constitutional Values | Polestar | 6558.0 | 6/3/20 | 6/5/20 | Mailing | Supporting | Van Beber, Tonya | Republican | House District 48 |
753 | 753 | Coloradans For Constitutional Values | Polestar | 6558.0 | 6/19/20 | 6/22/20 | Mailing | Supporting/Opposing | Van Beber, Tonya/Nouis, Graydon | Republican | House District 48 |
755 | 755 | Coloradans For Constitutional Values | Polestar | 6558.0 | 6/20/20 | 6/23/20 | Mailing | Supporting | Van Beber, Tonya | Republican | House District 48 |
757 | 757 | Coloradans For Constitutional Values | Polestar | 6558.0 | 6/22/20 | 6/24/20 | Mailing | Supporting | Van Beber, Tonya | Republican | House District 48 |
760 | 760 | Coloradans For Constitutional Values | Polestar | 6910.0 | 5/30/20 | 6/3/20 | Mailing | Supporting | Woog, Dan | Republican | House District 63 |
762 | 762 | Coloradans For Constitutional Values | Polestar | 6910.0 | 6/6/20 | 6/10/20 | Mailing | Supporting | Woog, Dan | Republican | House District 63 |
764 | 764 | Coloradans For Constitutional Values | Polestar | 6910.0 | 6/16/20 | 6/24/20 | Mailing | Supporting | Woog, Dan | Republican | House District 63 |
765 | 765 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 2340.26 | 10/20/20 | 10/21/20 | Mailing | Opposing | Buentello, Brianna Anastasia | Democratic | House District 47 |
771 | 771 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 657.33 | 10/8/20 | 10/9/20 | Mailing | Supporting/Opposing | Harris, Marilyn/Mclachlan, Barbara | Republican | House District 59 |
772 | 772 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 2386.52 | 10/12/20 | 10/14/20 | Mailing | Supporting/Opposing | Harris, Marilyn/Mclachlan, Barbara | Republican | House District 59 |
774 | 774 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 657.32 | 10/8/20 | 10/9/20 | Mailing | Supporting/Opposing | Luck, Stephanie/Buentello, Brianna Anastasia | Republican | House District 47 |
775 | 775 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 2386.52 | 10/12/20 | 10/14/20 | Mailing | Supporting/Opposing | Luck, Stephanie/Buentello, Brianna Anastasia | Republican | House District 47 |
777 | 777 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 2340.26 | 10/20/20 | 10/21/20 | Mailing | Opposing | Mclachlan, Barbara | Democratic | House District 59 |
781 | 781 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 657.33 | 10/8/20 | 10/9/20 | Mailing | Supporting/Opposing | Pyne, Vicki C/Titone, Brianna Caterina | Republican | House District 27 |
782 | 782 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 2386.53 | 10/12/20 | 10/14/20 | Mailing | Supporting/Opposing | Pyne, Vicki C/Titone, Brianna Caterina | Republican | House District 27 |
784 | 784 | Coloradans For Safer Neighborhoods | Cottrell Printing Company, Inc. | 2340.25 | 10/20/20 | 10/21/20 | Mailing | Opposing | Titone, Brianna Caterina | Democratic | House District 27 |
804 | 804 | Colorado Ceasefire Independent Expenditure Committee | Campaign Products Of The Rockies | 3431.52 | 10/14/20 | 10/15/2020 - 10/31/2020 | Mailing | Supporting/Opposing | Kolker, Chris/Staiert, Suzanne | Democratic | Senate District 27 |
805 | 805 | Colorado Citizens For Accountable Government | Insight Colorado | 52502.7 | 10/10/20 | 10/13/2020-11/3/2020 | Mailing | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
806 | 806 | Colorado Citizens For Accountable Government | Insight Colorado | 42831.15 | 10/16/20 | 10/16/2020-11/3/2020 | Mailing | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
807 | 807 | Colorado Citizens For Accountable Government | Insight Colorado | 29014.65 | 10/22/20 | 10/23/2020-11/3/2020 | Mailing | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
808 | 808 | Colorado Citizens For Accountable Government | Insight Colorado | 29014.65 | 10/16/20 | 10/16/2020-11/3/2020 | Mailing | Supporting/Opposing | Priola, Kevin/Dickerson, Paula Jane | Republican | Senate District 25 |
809 | 809 | Colorado Citizens For Accountable Government | Insight Colorado | 29014.65 | 10/16/20 | 10/16/2020-11/3/2020 | Mailing | Supporting | Priola, Kevin | Republican | Senate District 25 |
810 | 810 | Colorado Citizens For Accountable Government | Insight Colorado | 26251.35 | 10/22/20 | 10/23/2020-11/3/2020 | Mailing | Supporting | Priola, Kevin | Republican | Senate District 25 |
1085 | 1085 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 6560.82 | 10/6/20 | 10/16/20 | Mailing | Opposing | Cutter, Lisa Ann | Democratic | House District 25 |
1086 | 1086 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 5809.58 | 10/9/20 | 10/14/20 | Mailing | Opposing | Cutter, Lisa Ann | Democratic | House District 25 |
1087 | 1087 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 12712.14 | 10/13/20 | 10/16/20 | Mailing | Opposing | Cutter, Lisa Ann | Democratic | House District 25 |
1088 | 1088 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 12173.22 | 10/13/20 | 10/16/20 | Mailing | Opposing | Cutter, Lisa Ann | Democratic | House District 25 |
1093 | 1093 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 6196.33 | 10/4/20 | 13-Oct | Mailing | Supporting/Opposing | Rosier, Don/Cutter, Lisa | Republican | House District 25 |
1094 | 1094 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 6501.6 | 10/4/20 | 13-Oct | Mailing | Opposing | Titone, Brianna Caterina | Democratic | House District 27 |
1095 | 1095 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 5312.5 | 10/18/20 | 10/20/20 | Mailing | Opposing | Titone, Brianna Caterina | Democratic | House District 27 |
1096 | 1096 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 12460.5 | 10/13/20 | 10/16/20 | Mailing | Opposing | Titone, Brianna Caterina | Democratic | House District 27 |
1097 | 1097 | Colorado Republican Committee Independent Expenditure Committee | Majority Strategies | 6140.0 | 10/13/20 | 10/20/20 | Mailing | Opposing | Titone, Brianna Caterina | Democratic | House District 27 |
1108 | 1108 | Colorado Rural Voters | Grand Mesa Graphics | 1019.9 | 10/19/20 | 10/21/20 | Mailing | Supporting | Bedell, Kathryn Louise; Beilfuss, Scott; Mclachlan, Barbara; Niece, Jake; Padgett, Lynn M; Robinson, Leslie A; Soto, Beatriz | Democratic | multiple |
1109 | 1109 | Colorado Rural Voters | Studio Verde Creative | 1740.0 | 10/30/20 | 10/30/20 | Mailing | Supporting | Bedell, Kathryn Louise; Beilfuss, Scott; Mclachlan, Barbara; Niece, Jake; Padgett, Lynn M; Robinson, Leslie A; Soto, Beatriz | Democratic | multiple |
1110 | 1110 | Colorado Rural Voters | Petel & Co. | 1967.68 | 10/19/20 | 10/19/20 | Mailing | Supporting | Mclachlan, Barbara; Niece, Jake; Padgett, Lynn M | Democratic | multiple |
1111 | 1111 | Colorado Rural Voters | Petel & Co. | 6356.96 | 10/19/20 | 10/19/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1112 | 1112 | Colorado Sierra Club Independent Action | Mission Control | 6297.25 | 10/13/20 | 10/13/20 | Mailing | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
1113 | 1113 | Colorado Sierra Club Independent Action | Mission Control | 7200.25 | 10/16/20 | 10/20/20 | Mailing | Supporting/Opposing | Hanlon, Karl/Rankin, Bob | Democratic | Senate District 08 |
1114 | 1114 | Colorado Sierra Club Independent Action | Mission Control | 7502.56 | 10/21/20 | 10/26/20 | Mailing | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
1116 | 1116 | Colorado Sierra Club Independent Action | Mission Control | 3831.18 | 10/13/20 | 10/13/20 | Mailing | Supporting | Holen, Bill Lee | Democratic | Arapahoe County Commissioner |
1117 | 1117 | Colorado Sierra Club Independent Action | Mission Control | 3896.18 | 10/16/20 | 10/20/20 | Mailing | Supporting | Holen, Bill Lee | Democratic | Arapahoe County Commissioner |
1118 | 1118 | Colorado Sierra Club Independent Action | Mission Control | 3728.56 | 10/21/20 | 10/26/20 | Mailing | Supporting | Holen, Bill Lee | Democratic | Arapahoe County Commissioner |
1119 | 1119 | Colorado Sierra Club Independent Action | Mission Control | 5139.69 | 10/13/20 | 10/13/20 | Mailing | Supporting | Keith, Idris | Democratic | Arapahoe County Commissioner |
1120 | 1120 | Colorado Sierra Club Independent Action | Mission Control | 5204.69 | 10/16/20 | 10/20/20 | Mailing | Supporting | Keith, Idris | Democratic | Arapahoe County Commissioner |
1121 | 1121 | Colorado Sierra Club Independent Action | Mission Control | 4850.48 | 10/21/20 | 10/26/20 | Mailing | Supporting | Keith, Idris | Democratic | Arapahoe County Commissioner |
1122 | 1122 | Colorado Sierra Club Independent Action | Mission Control | 5747.5 | 10/13/20 | 10/13/20 | Mailing | Supporting | Kolker, Chris | Democratic | Senate District 27 |
1123 | 1123 | Colorado Sierra Club Independent Action | Mission Control | 6384.9 | 10/16/20 | 10/19/20 | Mailing | Supporting/Opposing | Kolker, Chris/Staiert, Suzanne | Democratic | Senate District 27 |
1124 | 1124 | Colorado Sierra Club Independent Action | Mission Control | 7103.19 | 10/21/20 | 10/26/20 | Mailing | Supporting | Kolker, Chris | Democratic | Senate District 27 |
1126 | 1126 | Colorado Sierra Club Independent Action | Mission Control | 8212.31 | 10/13/20 | 10/13/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1127 | 1127 | Colorado Sierra Club Independent Action | Mission Control | 8277.31 | 10/16/20 | 10/20/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1128 | 1128 | Colorado Sierra Club Independent Action | Mission Control | 6249.52 | 10/21/20 | 10/26/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1130 | 1130 | Colorado Sierra Club Independent Action | Mission Control | -12237.67 | 10/13/20 | 10/13/20 | Mailing | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
1131 | 1131 | Colorado Sierra Club Independent Action | Mission Control | 12237.67 | 10/13/20 | 10/13/20 | Mailing | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
1132 | 1132 | Colorado Sierra Club Independent Action | Mission Control | 12237.67 | 10/13/20 | 10/13/20 | Mailing | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
1134 | 1134 | Colorado Sierra Club Independent Action | Mission Control | 12746.8 | 10/21/20 | 10/26/20 | Mailing | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
1136 | 1136 | Colorado Sierra Club Independent Action | Mission Control | 5290.44 | 10/13/20 | 10/13/20 | Mailing | Supporting | Warren-Gully, Carrie L | Democratic | Arapahoe County Commissioner |
1137 | 1137 | Colorado Sierra Club Independent Action | Mission Control | 5355.44 | 10/16/20 | 10/20/20 | Mailing | Supporting | Warren-Gully, Carrie L | Democratic | Arapahoe County Commissioner |
1138 | 1138 | Colorado Sierra Club Independent Action | Mission Control | 5254.32 | 10/21/20 | 10/26/20 | Mailing | Supporting | Warren-Gully, Carrie L | Democratic | Arapahoe County Commissioner |
1163 | 1163 | Colorado Working Families Party Independent Expenditure Committee | Strategies 360 | 5600.0 | 6/15/20 | 6/15/2020 TO 6/25/2020 | Mailing | Supporting | Martinez, Matthew | Democratic | House District 62 |
1176 | 1176 | Colorado Working Families Party Independent Expenditure Committee | Flatirons Political Art Llc | 6259.32 | 6/24/20 | 6/19/2020 TO 6/30/2020 | Mailing | Supporting | Payne, Alonzo Christopher | Democratic | District 12 Attorney |
1184 | 1184 | Colorado's District Attorney Association Action | Clear Creek Strategies | 21000.0 | 10/10/20 | 10/13/2020-11/3/2020 | Mailing | Supporting/Opposing | Murray, Mitch/Mclaughlin, Gordon | Republican | Larimer County DA |
1190 | 1190 | Conservation Colorado Victory Fund | Moxie Media | 23967.61 | 10/5/20 | 10/5/20 | Mailing | Supporting | Henry, Eva J | Democratic | Adams County Commissioner |
1191 | 1191 | Conservation Colorado Victory Fund | Moxie Media | 9881.49 | 10/26/20 | 10/26/20 | Mailing | Supporting | Henry, Eva J | Democratic | Adams County Commissioner |
1192 | 1192 | Conservation Colorado Victory Fund | Moxie Media | 16603.11 | 10/27/20 | 10/28/20 | Mailing | Supporting | Henry, Eva J | Democratic | Adams County Commissioner |
1202 | 1202 | Conservation Colorado Victory Fund | Solidarity Strategies, Llc | 16701.22 | 10/23/20 | 10/23/20 | Mailing | Supporting | Henry, Eva J; Tedesco, Charles "Chaz" | Democratic | Adams County Commissioner |
1218 | 1218 | Conservation Colorado Victory Fund | Moxie Media | 7191.22 | 10/26/20 | 10/26/20 | Mailing | Supporting | Holen, Bill Lee | Democratic | Arapahoe County Commissioner |
1227 | 1227 | Conservation Colorado Victory Fund | Moxie Media | 4870.2 | 10/27/20 | 10/28/20 | Mailing | Supporting | Keith, Idris | Democratic | Arapahoe County Commissioner |
1229 | 1229 | Conservation Colorado Victory Fund | Moxie Media | 11579.67 | 10/26/20 | 10/26/20 | Mailing | Supporting | Kerr, Andy; Kraft-Tharp, Tracy | Democratic | Jefferson County Commissioner |
1246 | 1246 | Conservation Colorado Victory Fund | Moxie Media | 6860.48 | 10/12/20 | 10/14/20 | Mailing | Opposing | Martin, John Francis | Republican | Garfield County Commissioner |
1247 | 1247 | Conservation Colorado Victory Fund | Moxie Media | 6830.48 | 10/20/20 | 10/20/20 | Mailing | Opposing | Martin, John Francis; Samson, David Michael | Republican | Garfield County Commissioner |
1248 | 1248 | Conservation Colorado Victory Fund | Moxie Media | 5341.83 | 10/27/20 | 10/28/20 | Mailing | Supporting | Neal-Graves, Lisa | Democratic | Douglas County Commission |
1252 | 1252 | Conservation Colorado Victory Fund | Moxie Media | 13842.21 | 9/18/20 | 9/18/20 | Mailing | Opposing | Rankin, Bob | Republican | Senate District 08 |
1253 | 1253 | Conservation Colorado Victory Fund | Moxie Media | 13842.21 | 9/20/20 | 9/14/20 | Mailing | Opposing | Rankin, Bob | Republican | Senate District 08 |
1254 | 1254 | Conservation Colorado Victory Fund | Moxie Media | 13842.21 | 9/22/20 | 9/22/20 | Mailing | Opposing | Rankin, Bob | Republican | Senate District 08 |
1255 | 1255 | Conservation Colorado Victory Fund | Moxie Media | 7425.25 | 10/5/20 | 10/5/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1256 | 1256 | Conservation Colorado Victory Fund | Moxie Media | 4099.13 | 10/26/20 | 10/26/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1265 | 1265 | Conservation Colorado Victory Fund | Solidarity Strategies, Llc | 6860.48 | 10/23/20 | 10/23/20 | Mailing | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1278 | 1278 | Conservation Colorado Victory Fund | Solidarity Strategies, Llc | 1188.48 | 10/12/20 | 10/9-10/19 | Mailing | Supporting | Tedesco, Charles "Chaz" | Democratic | Adams County Commissioner |
1280 | 1280 | Conservation Colorado Victory Fund | Moxie Media | 10247.64 | 10/5/20 | 10/5/20 | Mailing | Supporting | Warren-Gully, Carrie L | Democratic | Arapahoe County Commissioner |
1281 | 1281 | Conservation Colorado Victory Fund | Moxie Media | 10247.64 | 10/12/20 | 10/14/20 | Mailing | Supporting/Opposing | Warren-Gully, Carrie L/Conti, Kathleen R | Democratic | Arapahoe County Commissioner |
1282 | 1282 | Conservation Colorado Victory Fund | Moxie Media | 4304.82 | 10/26/20 | 10/26/20 | Mailing | Supporting | Warren-Gully, Carrie L | Democratic | Arapahoe County Commissioner |
1302 | 1302 | Earthworks Action Fund Ie Committee | Colorado Sierra Club Independent Action | 9300.0 | 10/14/20 | 10/17/20 | Mailing | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
1317 | 1317 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 302.63 | 10/19/20 | 10/20/20 | Mailing | Supporting/Opposing | Gerber, Lynn T/Zenzinger, Rachel | Republican | Senate District 19 |
1318 | 1318 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 825.03 | 10/20/20 | 10/20/20 | Mailing | Supporting/Opposing | Gerber, Lynn T/Zenzinger, Rachel | Republican | Senate District 19 |
1319 | 1319 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 813.12 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Gerber, Lynn T/Zenzinger, Rachel | Republican | Senate District 19 |
1320 | 1320 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 754.26 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Gerber, Lynn T/Zenzinger, Rachel | Republican | Senate District 19 |
1323 | 1323 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 586.59 | 10/19/20 | 10/20/20 | Mailing | Supporting/Opposing | Kirkmeyer, Barbara/Boccella, Sally | Republican | Senate District 23 |
1324 | 1324 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1277.37 | 10/20/20 | 10/20/20 | Mailing | Supporting/Opposing | Kirkmeyer, Barbara/Boccella, Sally | Republican | Senate District 23 |
1325 | 1325 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1296.96 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Kirkmeyer, Barbara/Boccella, Sally | Republican | Senate District 23 |
1326 | 1326 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1474.97 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Kirkmeyer, Barbara/Boccella, Sally | Republican | Senate District 23 |
1328 | 1328 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 607.14 | 10/19/20 | 10/20/20 | Mailing | Supporting/Opposing | Liston, Larry G./Mccallian, Randal | Republican | Senate District 10 |
1329 | 1329 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1316.84 | 10/20/20 | 10/20/20 | Mailing | Supporting/Opposing | Liston, Larry G./Mccallian, Randal | Republican | Senate District 10 |
1330 | 1330 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1369.62 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Liston, Larry G./Mccallian, Randal | Republican | Senate District 10 |
1331 | 1331 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1568.42 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Liston, Larry G./Mccallian, Randal | Republican | Senate District 10 |
1334 | 1334 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 1642.49 | 9/22/20 | 9/23/20 | Mailing | Supporting/Opposing | Priola, Kevin/Dickerson, Paula Jane | Republican | Senate District 25 |
1335 | 1335 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 842.85 | 9/23/20 | 9/23/20 | Mailing | Supporting/Opposing | Priola, Kevin/Dickerson, Paula Jane | Republican | Senate District 25 |
1336 | 1336 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 983.77 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Priola, Kevin/Dickerson, Paula Jane | Republican | Senate District 25 |
1337 | 1337 | Family Policy Alliance Independent Expenditure Committee | CP Solutions | 991.41 | 10/23/20 | 10/23/20 | Mailing | Supporting/Opposing | Priola, Kevin/Dickerson, Paula Jane | Republican | Senate District 25 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_iec" ( "committee" TEXT, "vendor" TEXT, "amount_spent" REAL, "date_spent" TEXT, "date_delivered" TEXT, "type" TEXT, "position" TEXT, "candidate" TEXT, "affiliation" TEXT, "district" TEXT );