da_cand_exp
10 rows where city = "Tempe" and expenditure_type = "Bank Fees"
This data as json, CSV (advanced)
Suggested facets: expenditure_date, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
799 | 799 | DA 2 Denver | Mccann, Beth | Democratic | 152.22 | 1/2/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Merchant |
806 | 806 | DA 2 Denver | Mccann, Beth | Democratic | 268.77 | 2/4/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Fees |
809 | 809 | DA 2 Denver | Mccann, Beth | Democratic | 129.58 | 3/2/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Fees |
810 | 810 | DA 2 Denver | Mccann, Beth | Democratic | 148.97 | 3/2/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Fees |
828 | 828 | DA 2 Denver | Mccann, Beth | Democratic | 41.86 | 8/3/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Cadr Feess |
833 | 833 | DA 2 Denver | Mccann, Beth | Democratic | 145.0 | 9/2/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Platform |
837 | 837 | DA 2 Denver | Mccann, Beth | Democratic | 128.83 | 10/2/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Platform |
842 | 842 | DA 2 Denver | Mccann, Beth | Democratic | 251.1 | 11/2/20 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | |
845 | 845 | DA 2 Denver | Mccann, Beth | Democratic | 99.0 | 11/4/19 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees | Credit Card Platform |
853 | 853 | DA 2 Denver | Mccann, Beth | Democratic | 214.72 | 12/2/19 0:00 | Paragon Solutions | Tempe | AZ | 85282 | Bank Fees |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "da_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 );