house_cand_exp
2,378 rows where expenditure_type = "Advertising" sorted by zip descending
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip ▲ | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1320 | 1320 | House District 06 | Paletz, Steven | Democratic | 500.0 | 6/25/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | Google Advertising |
1323 | 1323 | House District 06 | Paletz, Steven | Democratic | 500.0 | 6/27/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | Google Ads |
1325 | 1325 | House District 06 | Paletz, Steven | Democratic | 500.0 | 6/28/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | Google Ads |
1327 | 1327 | House District 06 | Paletz, Steven | Democratic | 1000.0 | 6/30/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | Google Ads |
1330 | 1330 | House District 06 | Paletz, Steven | Democratic | 500.0 | 7/1/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | Google Ads |
1592 | 1592 | House District 06 | Woodrow, Steven | Democratic | 40.92 | 10/1/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
1618 | 1618 | House District 06 | Woodrow, Steven | Democratic | 63.23 | 10/13/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
1655 | 1655 | House District 06 | Woodrow, Steven | Democratic | 123.56 | 11/2/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
1656 | 1656 | House District 06 | Woodrow, Steven | Democratic | 22.39 | 11/2/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
1680 | 1680 | House District 06 | Woodrow, Steven | Democratic | 10.85 | 11/12/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2001 | 2001 | House District 08 | Herod, Leslie | Democratic | 30.0 | 5/4/20 0:00 | Google Gsuite | Mountain View | CA | 94043 | Advertising | |
2009 | 2009 | House District 08 | Herod, Leslie | Democratic | 1.99 | 5/26/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2013 | 2013 | House District 08 | Herod, Leslie | Democratic | 30.0 | 6/3/20 0:00 | Google Gsuite | Mountain View | CA | 94043 | Advertising | |
2025 | 2025 | House District 08 | Herod, Leslie | Democratic | 24.0 | 8/3/20 0:00 | Google Gsuite | Mountain View | CA | 94043 | Advertising | |
2029 | 2029 | House District 08 | Herod, Leslie | Democratic | 9.99 | 8/24/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2033 | 2033 | House District 08 | Herod, Leslie | Democratic | 24.0 | 9/2/20 0:00 | Google Gsuite | Mountain View | CA | 94043 | Advertising | |
2063 | 2063 | House District 08 | Herod, Leslie | Democratic | 9.99 | 10/23/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2199 | 2199 | House District 09 | Sirota, Emily | Democratic | 12.0 | 1/23/20 0:00 | Google Domains | Mountain View | CA | 94043 | Advertising | |
3759 | 3759 | House District 18 | Snyder, Marc | Democratic | 30.0 | 1/7/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3763 | 3763 | House District 18 | Snyder, Marc | Democratic | 30.0 | 2/7/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3769 | 3769 | House District 18 | Snyder, Marc | Democratic | 30.0 | 3/6/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3788 | 3788 | House District 18 | Snyder, Marc | Democratic | 36.0 | 7/8/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3791 | 3791 | House District 18 | Snyder, Marc | Democratic | 36.0 | 8/6/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3794 | 3794 | House District 18 | Snyder, Marc | Democratic | 36.0 | 9/9/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3800 | 3800 | House District 18 | Snyder, Marc | Democratic | 2.33 | 12/6/18 0:00 | Mountain View | CA | 94043 | Advertising | ||
3838 | 3838 | House District 18 | Snyder, Marc | Democratic | 45.09 | 8/6/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3851 | 3851 | House District 18 | Snyder, Marc | Democratic | 48.0 | 9/8/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3866 | 3866 | House District 18 | Snyder, Marc | Democratic | 36.0 | 10/2/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3883 | 3883 | House District 18 | Snyder, Marc | Democratic | 36.0 | 11/6/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
4477 | 4477 | House District 22 | Larson, Colin | Republican | 350.0 | 6/19/20 0:00 | Mountain View | CO | 94043 | Advertising | Google Advertising | |
4493 | 4493 | House District 22 | Larson, Colin | Republican | 500.0 | 6/27/20 0:00 | Mountain View | CO | 94043 | Advertising | Google Ads | |
4510 | 4510 | House District 22 | Larson, Colin | Republican | 305.99 | 7/27/20 0:00 | Mountain View | CO | 94043 | Advertising | ||
4563 | 4563 | House District 22 | Larson, Colin | Republican | 293.83 | 10/7/20 0:00 | Mountain View | CO | 94043 | Advertising | Digital Advertising | |
4583 | 4583 | House District 22 | Larson, Colin | Republican | 468.9 | 10/24/20 0:00 | Mountain View | CO | 94043 | Advertising | Digital Advertising | |
4599 | 4599 | House District 22 | Larson, Colin | Republican | 126.37 | 11/12/20 0:00 | Mountain View | CO | 94043 | Advertising | Digital Advertising | |
7128 | 7128 | House District 29 | Warren-Demott, Vanessa | Republican | 350.0 | 10/26/20 0:00 | Mountain Views Pkwy | CA | 94043 | Advertising | ||
7132 | 7132 | House District 29 | Warren-Demott, Vanessa | Republican | 128.69 | 11/4/20 0:00 | Mountain Views Pkwy | CA | 94043 | Advertising | ||
7133 | 7133 | House District 29 | Warren-Demott, Vanessa | Republican | 135.74 | 11/4/20 0:00 | Mountain View Pakway | CA | 94043 | Advertising | ||
8552 | 8552 | House District 37 | Cornell, Caroline | Republican | 350.0 | 9/21/20 0:00 | Mountain View | CA | 94043 | Advertising | Advertising | |
8573 | 8573 | House District 37 | Cornell, Caroline | Republican | 1400.0 | 9/24/20 0:00 | Mountain View | CA | 94043 | Advertising | Youtube And Google Ads | |
8582 | 8582 | House District 37 | Cornell, Caroline | Republican | 887.0 | 9/28/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8608 | 8608 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/14/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8613 | 8613 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/16/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8621 | 8621 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/20/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8626 | 8626 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/22/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8632 | 8632 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/25/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8636 | 8636 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/27/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8638 | 8638 | House District 37 | Cornell, Caroline | Republican | 500.0 | 10/28/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8644 | 8644 | House District 37 | Cornell, Caroline | Republican | 1000.0 | 11/2/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8646 | 8646 | House District 37 | Cornell, Caroline | Republican | 500.0 | 11/4/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8651 | 8651 | House District 37 | Cornell, Caroline | Republican | 405.2 | 11/16/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
8736 | 8736 | House District 37 | Sullivan, Tom | Democratic | 308.0 | 1/13/20 0:00 | Square Space | Mountain View | CA | 94043 | Advertising | |
8741 | 8741 | House District 37 | Sullivan, Tom | Democratic | 216.0 | 1/27/20 0:00 | Square Space | Mountain View | CA | 94043 | Advertising | |
9343 | 9343 | House District 38 | Ortiz, David | Democratic | 350.0 | 6/9/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Advertisements | |
9353 | 9353 | House District 38 | Ortiz, David | Democratic | 500.0 | 6/19/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
9362 | 9362 | House District 38 | Ortiz, David | Democratic | 500.0 | 6/29/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9374 | 9374 | House District 38 | Ortiz, David | Democratic | 500.0 | 7/6/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9384 | 9384 | House District 38 | Ortiz, David | Democratic | 500.0 | 7/23/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9405 | 9405 | House District 38 | Ortiz, David | Democratic | 21.22 | 8/24/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9442 | 9442 | House District 38 | Ortiz, David | Democratic | 106.74 | 10/2/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9492 | 9492 | House District 38 | Ortiz, David | Democratic | 83.25 | 11/2/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
12814 | 12814 | House District 49 | Zokaie, Yara | Democratic | 765.24 | 11/2/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
6293 | 6293 | House District 26 | Roberts, Dylan | Democratic | 9.71 | 12/7/18 0:00 | Mountain View | CA | 94039 | Advertising | Google Ad Words | |
11644 | 11644 | House District 46 | Ambler, Jonathan | Republican | 250.0 | 10/19/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebook Boost |
11646 | 11646 | House District 46 | Ambler, Jonathan | Republican | 250.0 | 10/21/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebook Boost |
11648 | 11648 | House District 46 | Ambler, Jonathan | Republican | 250.0 | 10/26/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebook Ads |
11650 | 11650 | House District 46 | Ambler, Jonathan | Republican | 250.0 | 10/27/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebook Ads |
11651 | 11651 | House District 46 | Ambler, Jonathan | Republican | 400.0 | 10/29/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebook Ads |
11652 | 11652 | House District 46 | Ambler, Jonathan | Republican | 600.0 | 11/2/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebook Ads |
11653 | 11653 | House District 46 | Ambler, Jonathan | Republican | 50.0 | 11/9/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025-1452 | Advertising | Facebookads |
212 | 212 | House District 01 | Koch, Samantha | Republican | 325.0 | 11/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | Ad Advertising On Facebook | |
942 | 942 | House District 05 | Woodley, Jonathan | Republican | 50.0 | 4/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
946 | 946 | House District 05 | Woodley, Jonathan | Republican | 87.82 | 7/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads. | |
958 | 958 | House District 05 | Woodley, Jonathan | Republican | 127.48 | 9/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | Ad Cost | |
965 | 965 | House District 05 | Woodley, Jonathan | Republican | 180.21 | 10/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
1268 | 1268 | House District 06 | Paletz, Steven | Democratic | 1145.54 | 4/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
1280 | 1280 | House District 06 | Paletz, Steven | Democratic | 20.0 | 5/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
1290 | 1290 | House District 06 | Paletz, Steven | Democratic | 400.0 | 6/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Advertising | |
1294 | 1294 | House District 06 | Paletz, Steven | Democratic | 400.0 | 6/10/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Advertising | |
1299 | 1299 | House District 06 | Paletz, Steven | Democratic | 400.0 | 6/11/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1301 | 1301 | House District 06 | Paletz, Steven | Democratic | 600.0 | 6/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1302 | 1302 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1311 | 1311 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/20/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1313 | 1313 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/22/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1316 | 1316 | House District 06 | Paletz, Steven | Democratic | 368.5 | 6/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1319 | 1319 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/25/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
1322 | 1322 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
1324 | 1324 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/28/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1326 | 1326 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1328 | 1328 | House District 06 | Paletz, Steven | Democratic | 900.0 | 6/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1334 | 1334 | House District 06 | Paletz, Steven | Democratic | 335.78 | 7/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1435 | 1435 | House District 06 | Woodrow, Steven | Democratic | 6.09 | 4/9/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1436 | 1436 | House District 06 | Woodrow, Steven | Democratic | 3.0 | 4/10/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1437 | 1437 | House District 06 | Woodrow, Steven | Democratic | 3.0 | 4/10/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1438 | 1438 | House District 06 | Woodrow, Steven | Democratic | 5.0 | 4/10/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1441 | 1441 | House District 06 | Woodrow, Steven | Democratic | 7.0 | 4/13/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1442 | 1442 | House District 06 | Woodrow, Steven | Democratic | 10.0 | 4/13/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1443 | 1443 | House District 06 | Woodrow, Steven | Democratic | 15.0 | 4/15/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1444 | 1444 | House District 06 | Woodrow, Steven | Democratic | 15.0 | 4/17/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising | |
1446 | 1446 | House District 06 | Woodrow, Steven | Democratic | 25.0 | 4/20/20 0:00 | Facebook, Inc. | Menlo Park | CA | 94025 | Advertising |
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 );