senate_cand_exp
51 rows where expenditure_type = "Consultant & Professional Services" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, expenditure_amount, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | Senate District 04 | Smallwood, James | Republican | 143.78 | 3/1/17 0:00 | Menio Park | CA | 94025-1452 | Consultant & Professional Services | ||
420 | 420 | Senate District 08 | Hanlon, Karl | Democratic | 16.27 | 8/21/20 0:00 | Zoom | San Jose | CA | 95113 | Consultant & Professional Services | |
431 | 431 | Senate District 08 | Hanlon, Karl | Democratic | 191.79 | 9/4/20 0:00 | Tech For Campaigns | San Francisco | CA | 94102 | Consultant & Professional Services | Fundraising Software/Services |
456 | 456 | Senate District 08 | Hanlon, Karl | Democratic | 250.0 | 10/2/20 0:00 | Tech For Campaigns | San Francisco | CA | 94102 | Consultant & Professional Services | Polaris Fundraising Software |
471 | 471 | Senate District 08 | Hanlon, Karl | Democratic | 16.27 | 10/21/20 0:00 | Zoom | San Jose | CA | 95113 | Consultant & Professional Services | |
2193 | 2193 | Senate District 19 | Gerber, Lynn | Republican | 372.59 | 10/30/20 0:00 | Adobe Stock | San Jose | CA | 95110 | Consultant & Professional Services | |
5247 | 5247 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 1/2/19 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5251 | 5251 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 2/1/19 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5259 | 5259 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 3/4/19 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5264 | 5264 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 4/2/19 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5269 | 5269 | Senate District 29 | Fields, Rhonda | Democratic | 59.66 | 5/2/19 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5275 | 5275 | Senate District 29 | Fields, Rhonda | Democratic | 60.0 | 6/3/19 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5298 | 5298 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 10/1/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5304 | 5304 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 11/1/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5309 | 5309 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 12/3/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5325 | 5325 | Senate District 29 | Fields, Rhonda | Democratic | 84.0 | 7/3/20 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5333 | 5333 | Senate District 29 | Fields, Rhonda | Democratic | 84.0 | 8/3/20 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5346 | 5346 | Senate District 29 | Fields, Rhonda | Democratic | 32.06 | 8/31/20 0:00 | Zoom | San Jose | CA | 95113 | Consultant & Professional Services | |
5348 | 5348 | Senate District 29 | Fields, Rhonda | Democratic | 84.0 | 9/3/20 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5360 | 5360 | Senate District 29 | Fields, Rhonda | Democratic | 16.03 | 10/1/20 0:00 | Zoom | San Jose | CA | 95113 | Consultant & Professional Services | |
5362 | 5362 | Senate District 29 | Fields, Rhonda | Democratic | 84.0 | 10/2/20 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5374 | 5374 | Senate District 29 | Fields, Rhonda | Democratic | 16.03 | 10/30/20 0:00 | Zoom | San Jose | CA | 95113 | Consultant & Professional Services | |
5375 | 5375 | Senate District 29 | Fields, Rhonda | Democratic | 84.0 | 11/2/20 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5386 | 5386 | Senate District 29 | Fields, Rhonda | Democratic | 16.03 | 11/30/20 0:00 | Zoom | San Jose | CA | 95113 | Consultant & Professional Services | |
5396 | 5396 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 1/3/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5405 | 5405 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 2/2/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5415 | 5415 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 3/2/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5424 | 5424 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 4/3/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5431 | 5431 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 5/2/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5434 | 5434 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 6/7/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5437 | 5437 | Senate District 29 | Fields, Rhonda | Democratic | 53.22 | 7/5/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5444 | 5444 | Senate District 29 | Fields, Rhonda | Democratic | 46.78 | 8/2/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5451 | 5451 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 9/5/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5455 | 5455 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 12/2/16 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5475 | 5475 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 1/2/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5485 | 5485 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 2/2/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5493 | 5493 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 3/2/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5500 | 5500 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 4/2/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5505 | 5505 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 5/2/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5510 | 5510 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 6/4/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5514 | 5514 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 7/2/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5518 | 5518 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 8/1/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5525 | 5525 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 9/1/18 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5529 | 5529 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 10/2/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
5536 | 5536 | Senate District 29 | Fields, Rhonda | Democratic | 50.0 | 12/4/17 0:00 | Google Service Apps | Mountain View | CA | 94043 | Consultant & Professional Services | |
6050 | 6050 | Senate District 31 | Orms, Maria | Democratic | 54.37 | 5/2/20 0:00 | Google Suite | Mountain View | CA | 94043 | Consultant & Professional Services | Google Suite |
6056 | 6056 | Senate District 31 | Orms, Maria | Democratic | 118.0 | 5/7/20 0:00 | Insightly, Inc | San Francisco | CA | 94107 | Consultant & Professional Services | |
6145 | 6145 | Senate District 31 | Orms, Maria | Democratic | 62.25 | 7/1/20 0:00 | Google Suite | Mountain View | CA | 94043 | Consultant & Professional Services | Google Suite |
6146 | 6146 | Senate District 31 | Orms, Maria | Democratic | -62.25 | 7/1/20 0:00 | Google Suite | Mountain View | CA | 94043 | Consultant & Professional Services | Offset Due To Update Of Filed Item - Google Suite |
6390 | 6390 | Senate District 35 | Lopez, Carlos | Democratic | 250.0 | 9/3/20 0:00 | Tech For Campaigns | San Francisco | CA | 94147 | Consultant & Professional Services | Consultation/ Software |
6434 | 6434 | Senate District 35 | Lopez, Carlos | Democratic | 250.0 | 10/1/20 0:00 | Tech For Campaigns | San Francisco | CA | 94147 | Consultant & Professional Services | Fundraising Software |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_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 );