senate_exp
7 rows where zip = 94507
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
606 | 606 | Senate District 03 | Stephen A. Varela | Republican | 1000.0 | 9/29/22 | Norhtext.Com | Alamo | CA | 94507 | Advertising | Text Advertising |
705 | 705 | Senate District 03 | Stephen A. Varela | Republican | 396.27 | 11/2/22 | Northtext | Alamo | CA | 94507 | Advertising | Advertising |
707 | 707 | Senate District 03 | Stephen A. Varela | Republican | 154.31 | 11/3/22 | Northtext | Alamo | CA | 94507 | Advertising | Advertising Texting |
708 | 708 | Senate District 03 | Stephen A. Varela | Republican | 440.0 | 11/3/22 | Northtext | Alamo | CA | 94507 | Advertising | Advertising Texting |
712 | 712 | Senate District 03 | Stephen A. Varela | Republican | 396.27 | 11/4/22 | Northtext | Alamo | CA | 94507 | Advertising | Advertising Texting |
719 | 719 | Senate District 03 | Stephen A. Varela | Republican | 376.37 | 11/7/22 | Northtext | Alamo | CA | 94507 | Advertising | Advertising Text Messaging |
720 | 720 | Senate District 03 | Stephen A. Varela | Republican | 218.29 | 11/7/22 | Northtext | Alamo | CA | 94507 | Advertising | Text 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 );