senate_exp
16 rows where explanation = "Phone Messaging"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2393 | 2393 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 10/27/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2394 | 2394 | Senate District 15 | Janice Marchman | Democratic | 32.0 | 10/27/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2400 | 2400 | Senate District 15 | Janice Marchman | Democratic | 300.0 | 10/28/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2402 | 2402 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 10/31/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2403 | 2403 | Senate District 15 | Janice Marchman | Democratic | 32.0 | 10/31/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2406 | 2406 | Senate District 15 | Janice Marchman | Democratic | 3000.0 | 11/1/22 | Balance Payments | San Francisco | CA | 94114 | Advertising | Phone Messaging |
2407 | 2407 | Senate District 15 | Janice Marchman | Democratic | 32.0 | 11/1/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2408 | 2408 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 11/1/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2410 | 2410 | Senate District 15 | Janice Marchman | Democratic | 300.0 | 11/2/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2420 | 2420 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 11/7/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2421 | 2421 | Senate District 15 | Janice Marchman | Democratic | 32.0 | 11/7/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2422 | 2422 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 11/8/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2426 | 2426 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 11/9/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2430 | 2430 | Senate District 15 | Janice Marchman | Democratic | 600.0 | 11/10/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2431 | 2431 | Senate District 15 | Janice Marchman | Democratic | 300.0 | 11/10/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
2434 | 2434 | Senate District 15 | Janice Marchman | Democratic | 9.0 | 11/14/22 | Callfire.Com | Santa Monica | CA | 90401 | Advertising | Phone Messaging |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );