ed_cand_exp
601 rows where state = "CO" sorted by affiliation
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation ▼ | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
150 | 150 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 52.38 | 10/28/19 0:00 | C & D Printing, Inc. | Denver | CO | 80212 | Advertising | Business Cards |
151 | 151 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 11/4/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
152 | 152 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 11/8/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
153 | 153 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 32.88 | 11/8/19 0:00 | Blair Taylor | Denver | CO | 80207 | Office Equipment & Supplies | Reimbursement For Name Tag Order |
154 | 154 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 11/18/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
155 | 155 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 10.0 | 11/18/19 0:00 | Blair Taylor | Denver | CO | 80207 | Office Equipment & Supplies | Reimbursement For 2020 Planning Calendar. |
156 | 156 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 12/3/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
157 | 157 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 12/3/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
159 | 159 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 12/16/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
160 | 160 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 94.23 | 12/16/19 0:00 | Blair Taylor | Denver | CO | 80207 | Advertising | Reimbursement For Flyers Printed By Office Depot. |
161 | 161 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 12/16/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
162 | 162 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 270.26 | 12/16/19 0:00 | C & D Printing, Inc. | Denver | CO | 80212 | Advertising | Flyers For Walking |
163 | 163 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 12/21/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
166 | 166 | Bd. Ed. District 01 | Morganstern, Donna | Democratic | 700.0 | 12/30/19 0:00 | Blair Taylor | Denver | CO | 80207 | Consultant & Professional Services | Campaign Management |
178 | 178 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 11.2 | 3/11/20 0:00 | Jefferson Co Democratic Party: Multi Purpose | Lakewood | CO | 80215 | Fundraising Expenses | Purchased Mailing List |
179 | 179 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | -11.2 | 3/11/20 0:00 | Jefferson Co Democratic Party: Multi Purpose | Lakewood | CO | 80215 | Fundraising Expenses | Offset Due To Deletion Of Filed Item - Purchased Mailing List |
193 | 193 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 330.0 | 6/5/20 0:00 | Monte Vista Journal | Monte Vista | CO | 81144 | Advertising | Half Page Color Ads In San Luis Valley Newspapers |
195 | 195 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 150.0 | 6/18/20 0:00 | Colorado Democratic Party | Denver | CO | 80203 | Miscellaneous | Fee To Attend Colorado Democratic Political Event |
210 | 210 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 500.0 | 7/20/20 0:00 | Colorado Democratic Party | Denver | CO | 80203 | Other | Van Voter List |
214 | 214 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 500.0 | 8/4/20 0:00 | Steele Strategies, Llc | Denver | CO | 80203 | Consultant & Professional Services | Nathan Steele July Campaign Management |
218 | 218 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 165.0 | 8/27/20 0:00 | Olive Welsh | Colorado Springs | CO | 80903 | Consultant & Professional Services | |
221 | 221 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 1000.0 | 8/31/20 0:00 | Steele Strategies, Llc | Denver | CO | 80203 | Consultant & Professional Services | |
223 | 223 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 1082.04 | 9/10/20 0:00 | Northwest Graphics | Steamboat Springs | CO | 80487 | Advertising | |
225 | 225 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 33.55 | 9/14/20 0:00 | Wallmart | Steamboat Springs | CO | 80487 | Office Equipment & Supplies | Office Supplies (Paper, Tape, Boxes And Envelopes |
226 | 226 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 106.61 | 9/15/20 0:00 | Ups Store | Steamboat Springs | CO | 80487 | Miscellaneous | Ups Shipment Of Campaign Materials |
228 | 228 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 23.37 | 9/16/20 0:00 | Ups Store | Steamboat Springs | CO | 80487 | Miscellaneous | Shipping Campaign Materials |
229 | 229 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 31.37 | 9/18/20 0:00 | Conoco | Steamboat Springs | CO | 80487 | Travel & Lodging | |
230 | 230 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 92.8 | 9/20/20 0:00 | Jack Dysart | Steamboat Springs | CO | 80477-6149 | Travel & Lodging | Travel Reimbursement - Delivered Yard Signs To Grand Junction |
232 | 232 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 24.11 | 9/20/20 0:00 | Ups Store | Steamboat Springs | CO | 80487 | Miscellaneous | Ups Shipping Of Campaign Materials |
233 | 233 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 5.0 | 9/21/20 0:00 | Colorado Mesa University | Grand Junction | CO | 81501 | Travel & Lodging | Parking Fee |
234 | 234 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 1500.0 | 9/25/20 0:00 | Colorado Democratic Party | Denver | CO | 80203 | Advertising | |
236 | 236 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 200.0 | 9/28/20 0:00 | Margaret Smith | Steamboat Springs | CO | 80487 | Other | Refund Of Excess Donation Made On 9/24/20 |
237 | 237 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 2500.0 | 9/28/20 0:00 | Steele Strategies, Llc | Denver | CO | 80203 | Advertising | Yard Signs Production And Delivery |
238 | 238 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 1000.0 | 9/28/20 0:00 | Steele Strategies, Llc | Denver | CO | 80203 | Consultant & Professional Services | |
241 | 241 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 194.0 | 10/4/20 0:00 | Laura Baker | Montrose | CO | 81401 | Travel & Lodging | Campaign Signs Delivery |
243 | 243 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 28.08 | 10/5/20 0:00 | Ups Store | Steamboat Springs | CO | 80487 | Miscellaneous | Ups Shipment Of Campaign Materials |
260 | 260 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 1400.0 | 10/19/20 0:00 | Brightstar Strategies | Grand Junction | CO | 81507 | Consultant & Professional Services | |
266 | 266 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 363.0 | 10/25/20 0:00 | Montezuma County Democratic Committee | Cortez | CO | 81321 | Advertising | Purchased Large Signs For Mayling Simpson Campaign |
269 | 269 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | -363.0 | 10/25/20 0:00 | Montezuma County Democratic Committee | Cortez | CO | 81321 | Advertising | Offset Due To Deletion Of Filed Item - Purchased Large Signs For Mayling Simpson Campaign |
273 | 273 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 1250.0 | 10/28/20 0:00 | Steele Strategies, Llc | Denver | CO | 80203 | Consultant & Professional Services | |
274 | 274 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 500.0 | 10/28/20 0:00 | Laura Baker | Montrose | CO | 81401 | Travel & Lodging | Reimbursement To Laura For Mileage And Meals |
275 | 275 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 500.0 | 10/29/20 0:00 | Choozle, Inc. | Denver | CO | 80238 | Advertising | Unused Funds Returned To Campaign By Choozle, Inc On Nov 3, 2020 |
279 | 279 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 190.0 | 10/30/20 0:00 | Grand Junction Media, Inc | Grand Junction | CO | 80501 | Advertising | |
280 | 280 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 760.0 | 10/30/20 0:00 | Grand Junction Media, Inc | Grand Junction | CO | 80501 | Advertising | |
284 | 284 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 99.0 | 11/5/20 0:00 | U. S. Postmaster | Steamboat Springs | CO | 80487 | Miscellaneous | Postage For Letters And Thank-You Cards |
340 | 340 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1450.0 | 8/29/19 0:00 | Bold Text Llc | Parker | CO | 80138 | Consultant & Professional Services | Development Of Webpage Expenditure By Candidate |
341 | 341 | Bd. Ed. District 07 | Esser, Karla | Democratic | 11.0 | 9/16/19 0:00 | Us Postal Service | Lakewood | CO | 80228 | Office Equipment & Supplies | Postage Stamps |
342 | 342 | Bd. Ed. District 07 | Esser, Karla | Democratic | 500.0 | 9/30/19 0:00 | Colorado Democratic Party | Denver | CO | 80203 | Other | Voter File Access At Fair Market Value Paid To The Cdp Federal Account |
344 | 344 | Bd. Ed. District 07 | Esser, Karla | Democratic | 17.15 | 1/2/20 0:00 | Us Postal Service | Denver | CO | 80227 | Office Equipment & Supplies | 40 Postcard Stamps |
345 | 345 | Bd. Ed. District 07 | Esser, Karla | Democratic | 700.0 | 1/3/20 0:00 | Bold Text Llc | Parker | CO | 80138 | Consultant & Professional Services | Consultant Fees |
346 | 346 | Bd. Ed. District 07 | Esser, Karla | Democratic | 283.28 | 1/10/20 0:00 | Bold Text Llc | Parker | CO | 80138 | Advertising | Facebook Advertisement Expenses |
348 | 348 | Bd. Ed. District 07 | Esser, Karla | Democratic | 705.71 | 1/26/20 0:00 | Bold Text Llc | Parker | CO | 80138 | Consultant & Professional Services | Campaign Consulting |
349 | 349 | Bd. Ed. District 07 | Esser, Karla | Democratic | 3000.0 | 1/29/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting Check #1002 |
352 | 352 | Bd. Ed. District 07 | Esser, Karla | Democratic | 54.99 | 2/1/20 0:00 | Karla Esser | Lakewood | CO | 80228 | Food, Beverages and Meals | Food And Beverage For Fundraising Event On 2/1/2020 Check #1003 Costco Receipt Available |
353 | 353 | Bd. Ed. District 07 | Esser, Karla | Democratic | 45.0 | 2/5/20 0:00 | Us Postal Service | Lakewood | CO | 80226 | Office Equipment & Supplies | 50 Postcards And 50 Stamps |
354 | 354 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 2/21/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Consulting $1500 Check #1004 Invoice #165 Inv0065 |
355 | 355 | Bd. Ed. District 07 | Esser, Karla | Democratic | 592.17 | 2/21/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Fundraising Expenses | Check #1004 500 Postcards Invoice #165 Inv0065 |
358 | 358 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 3/3/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting $1500 Check #1005 Invoice #169 Inv0069 |
359 | 359 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1726.28 | 3/3/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Walk Pieces And Yard Sign Development Check #1005 Invoice #169 Inv0069 |
361 | 361 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 4/2/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting Check #1006 |
364 | 364 | Bd. Ed. District 07 | Esser, Karla | Democratic | 7.15 | 4/13/20 0:00 | Vinzenz Esser | Lakewood | CO | 80228 | Office Equipment & Supplies | Reimbursement For Purchase Of Stamps Check #1007 |
369 | 369 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 5/1/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting Check #1008 Invoice #176 |
370 | 370 | Bd. Ed. District 07 | Esser, Karla | Democratic | 166.16 | 5/1/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Banner Check #1008 Invoice #176 |
372 | 372 | Bd. Ed. District 07 | Esser, Karla | Democratic | 70.0 | 5/8/20 0:00 | Us Postal Service | Denver | CO | 80227 | Advertising | 200 Postcard Stamps |
376 | 376 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 6/1/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting Check #1009 Invoice #184 |
377 | 377 | Bd. Ed. District 07 | Esser, Karla | Democratic | 479.81 | 6/1/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Fundraising Expenses | 5000 Postcards Check #1009 Invoice #184 |
380 | 380 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 7/2/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Check #1010 Campaign Consulting |
381 | 381 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 7/16/20 0:00 | Blue Summit Consultants Llc | Highlands Ranch | CO | 80129 | Consultant & Professional Services | Check #1011 Website Reconstruction |
382 | 382 | Bd. Ed. District 07 | Esser, Karla | Democratic | 5465.0 | 7/16/20 0:00 | Blue Summit Consultants Llc | Highlands Ranch | CO | 80129 | Advertising | Digital Marketing Check # 1011 |
384 | 384 | Bd. Ed. District 07 | Esser, Karla | Democratic | 140.0 | 7/27/20 0:00 | Us Postal Service | Lakewood | CO | 80226 | Advertising | 400 Postcard Stamps |
385 | 385 | Bd. Ed. District 07 | Esser, Karla | Democratic | 210.0 | 8/4/20 0:00 | Us Postal Service | Lakewood | CO | 80226 | Advertising | 600 Postcard Stamps |
386 | 386 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 8/5/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting Invoice #201 Check #1012 |
387 | 387 | Bd. Ed. District 07 | Esser, Karla | Democratic | 481.49 | 8/5/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Postcards Invoice #201 Check #1012 |
388 | 388 | Bd. Ed. District 07 | Esser, Karla | Democratic | 60.0 | 8/7/20 0:00 | Halcyon Digital | Lakewood | CO | 80228 | Consultant & Professional Services | Video Editing |
391 | 391 | Bd. Ed. District 07 | Esser, Karla | Democratic | 27.18 | 8/14/20 0:00 | Costco | Arvada | CO | 80002 | Advertising | Snacks For Literature Walkers |
394 | 394 | Bd. Ed. District 07 | Esser, Karla | Democratic | 4.0 | 8/27/20 0:00 | 1St Bank | Lakewood | CO | 80215 | Bank Fees | Fee For 2 Visa Atm Cards |
396 | 396 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 9/8/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Check #1014 Invoice #201 Campaign Consulting |
397 | 397 | Bd. Ed. District 07 | Esser, Karla | Democratic | 694.72 | 9/8/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Check #1014 Invoice #201 Yard Signs And Stakes |
398 | 398 | Bd. Ed. District 07 | Esser, Karla | Democratic | 5465.0 | 9/14/20 0:00 | Blue Summit Consultants Llc | Highlands Ranch | CO | 80129 | Advertising | Digital Marketing Check #1015 Invoice #65E0596B-0002 |
400 | 400 | Bd. Ed. District 07 | Esser, Karla | Democratic | 700.0 | 9/18/20 0:00 | Us Postal Service | Lakewood | CO | 80226 | Advertising | 2000 Postcard Stamps |
401 | 401 | Bd. Ed. District 07 | Esser, Karla | Democratic | 420.0 | 9/28/20 0:00 | Vinzenz Esser | Lakewood | CO | 80228 | Advertising | Electronic Transfer Of Funds Reimbursement For 1,200 Postcard Stamps Post Office Receipt # 840-58000063-5-4422216-1 |
402 | 402 | Bd. Ed. District 07 | Esser, Karla | Democratic | 4.0 | 9/29/20 0:00 | 1St Bank | Lakewood | CO | 80215 | Bank Fees | Monthly Fee For 2 Visa Atm Cards |
404 | 404 | Bd. Ed. District 07 | Esser, Karla | Democratic | 608.75 | 10/1/19 0:00 | Bold Text Llc | Parker | CO | 80138 | Consultant & Professional Services | Graphic Design And Campaign Consulting |
405 | 405 | Bd. Ed. District 07 | Esser, Karla | Democratic | 2250.0 | 10/1/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Campaign Consulting Invoice #204 Check #1016 |
406 | 406 | Bd. Ed. District 07 | Esser, Karla | Democratic | 6.65 | 10/2/19 0:00 | Us Postal Service | Lakewood | CO | 80228 | Office Equipment & Supplies | 19 Postcard Stamps For Mailing Thank You Cards |
407 | 407 | Bd. Ed. District 07 | Esser, Karla | Democratic | 700.0 | 10/3/20 0:00 | Us Postal Service | Lakewood | CO | 80226 | Advertising | 2000 Postcard Stamps |
408 | 408 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1500.0 | 10/3/20 0:00 | Colorado Democratic Party | Denver | CO | 80203 | Advertising | Check #1017 Coordinated Slate Advertising Buy-In |
409 | 409 | Bd. Ed. District 07 | Esser, Karla | Democratic | 153.4 | 10/4/20 0:00 | Halcyon Digital | Lakewood | CO | 80228 | Advertising | Video Editing Invoice #14573 |
410 | 410 | Bd. Ed. District 07 | Esser, Karla | Democratic | 700.0 | 10/5/20 0:00 | Us Postal Service | Lakewood | CO | 80226 | Advertising | 2000 Postcard Stamps |
411 | 411 | Bd. Ed. District 07 | Esser, Karla | Democratic | 244.07 | 10/7/19 0:00 | C&D Printing | Denver | CO | 80212 | Advertising | Campaign Flyers |
412 | 412 | Bd. Ed. District 07 | Esser, Karla | Democratic | 7000.0 | 10/7/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Digital Targeting Invoice #204 Check #1018 |
413 | 413 | Bd. Ed. District 07 | Esser, Karla | Democratic | 466.66 | 10/7/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Walk-Piece Flyer Invoice #204 Check #1018 |
414 | 414 | Bd. Ed. District 07 | Esser, Karla | Democratic | 280.0 | 10/7/20 0:00 | Us Postal Service | Englewood | CO | 80113 | Advertising | 800 Postcard Stamps |
416 | 416 | Bd. Ed. District 07 | Esser, Karla | Democratic | 10.5 | 10/15/19 0:00 | Us Postal Service | Lakewood | CO | 80228 | Office Equipment & Supplies | Stamps For Thank You Cards |
417 | 417 | Bd. Ed. District 07 | Esser, Karla | Democratic | 39.83 | 10/15/20 0:00 | Costco | Littleton | CO | 80123 | Food, Beverages and Meals | Snacks For Volunteer Literature Walkers |
418 | 418 | Bd. Ed. District 07 | Esser, Karla | Democratic | 2100.0 | 10/21/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Advertising | Digital Targeting Invoice #213 Check #1017 |
419 | 419 | Bd. Ed. District 07 | Esser, Karla | Democratic | 89.04 | 10/23/19 0:00 | C&D Printing | Denver | CO | 80212 | Advertising | Business Cards |
420 | 420 | Bd. Ed. District 07 | Esser, Karla | Democratic | 700.0 | 10/27/19 0:00 | Bold Text Llc | Parker | CO | 80138 | Consultant & Professional Services | Consultant Fees |
422 | 422 | Bd. Ed. District 07 | Esser, Karla | Democratic | 4.0 | 10/29/20 0:00 | 1St Bank | Lakewood | CO | 80215 | Bank Fees | Monthly Fee For 2 Visa Atm Cards |
425 | 425 | Bd. Ed. District 07 | Esser, Karla | Democratic | 1000.0 | 11/7/20 0:00 | Engage Strategies Llc | Denver | CO | 80202 | Consultant & Professional Services | Check #1020 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ed_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );