house_cand_exp
13 rows where candidate = "Mclachlan, Barbara" and expenditure_type = "Telephone"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, state, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
14130 | 14130 | House District 59 | Mclachlan, Barbara | Democratic | 5.0 | 7/30/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14132 | 14132 | House District 59 | Mclachlan, Barbara | Democratic | 150.0 | 8/8/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14148 | 14148 | House District 59 | Mclachlan, Barbara | Democratic | 5.0 | 9/7/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14149 | 14149 | House District 59 | Mclachlan, Barbara | Democratic | 149.0 | 9/7/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14154 | 14154 | House District 59 | Mclachlan, Barbara | Democratic | 28.0 | 9/12/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14174 | 14174 | House District 59 | Mclachlan, Barbara | Democratic | 25.0 | 9/28/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14201 | 14201 | House District 59 | Mclachlan, Barbara | Democratic | 149.0 | 10/8/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14210 | 14210 | House District 59 | Mclachlan, Barbara | Democratic | 20.0 | 10/11/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14211 | 14211 | House District 59 | Mclachlan, Barbara | Democratic | 10.0 | 10/12/20 0:00 | Google G Suite | Mountain View | CA | 94043 | Telephone | |
14217 | 14217 | House District 59 | Mclachlan, Barbara | Democratic | 24.0 | 10/19/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14223 | 14223 | House District 59 | Mclachlan, Barbara | Democratic | 54.63 | 10/27/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14229 | 14229 | House District 59 | Mclachlan, Barbara | Democratic | 3.0 | 11/3/20 0:00 | Robodial.Org | Arlington | VA | 22203 | Telephone | |
14234 | 14234 | House District 59 | Mclachlan, Barbara | Democratic | 177.96 | 11/12/20 0:00 | Colorado Democratic Party | Denver | CO | 80203 | Telephone |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );