house_cand_exp
65 rows where candidate = "Ortiz, David" and expenditure_type = "Advertising"
This data as json, CSV (advanced)
Suggested facets: recipient, city, state, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9326 | 9326 | House District 38 | Ortiz, David | Democratic | 25.0 | 5/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
9327 | 9327 | House District 38 | Ortiz, David | Democratic | 25.0 | 5/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
9328 | 9328 | House District 38 | Ortiz, David | Democratic | 25.0 | 5/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
9331 | 9331 | House District 38 | Ortiz, David | Democratic | 35.0 | 5/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
9334 | 9334 | House District 38 | Ortiz, David | Democratic | 50.0 | 6/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
9335 | 9335 | House District 38 | Ortiz, David | Democratic | 75.0 | 6/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
9338 | 9338 | House District 38 | Ortiz, David | Democratic | 75.0 | 6/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
9339 | 9339 | House District 38 | Ortiz, David | Democratic | 125.0 | 6/5/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
9343 | 9343 | House District 38 | Ortiz, David | Democratic | 350.0 | 6/9/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Advertisements | |
9344 | 9344 | House District 38 | Ortiz, David | Democratic | 175.0 | 6/9/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
9350 | 9350 | House District 38 | Ortiz, David | Democratic | 250.0 | 6/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
9351 | 9351 | House District 38 | Ortiz, David | Democratic | 17.89 | 6/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
9353 | 9353 | House District 38 | Ortiz, David | Democratic | 500.0 | 6/19/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
9357 | 9357 | House District 38 | Ortiz, David | Democratic | 400.0 | 6/24/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
9361 | 9361 | House District 38 | Ortiz, David | Democratic | 29.72 | 6/29/20 0:00 | Robodial | Media | PA | 19063 | Advertising | |
9362 | 9362 | House District 38 | Ortiz, David | Democratic | 500.0 | 6/29/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9366 | 9366 | House District 38 | Ortiz, David | Democratic | 95.88 | 6/30/20 0:00 | Crello | Limassol | CY | 3035 | Advertising | |
9370 | 9370 | House District 38 | Ortiz, David | Democratic | 29.99 | 7/1/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
9372 | 9372 | House District 38 | Ortiz, David | Democratic | 875.0 | 7/2/20 0:00 | Bluelink | Washington | DC | 20016 | Advertising | |
9374 | 9374 | House District 38 | Ortiz, David | Democratic | 500.0 | 7/6/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9379 | 9379 | House District 38 | Ortiz, David | Democratic | 25.0 | 7/13/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9380 | 9380 | House District 38 | Ortiz, David | Democratic | 205.73 | 7/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
9384 | 9384 | House District 38 | Ortiz, David | Democratic | 500.0 | 7/23/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9387 | 9387 | House District 38 | Ortiz, David | Democratic | 56.22 | 7/27/20 0:00 | Squarespace | New York | NY | 10014 | Advertising | |
9394 | 9394 | House District 38 | Ortiz, David | Democratic | 15.0 | 8/4/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9396 | 9396 | House District 38 | Ortiz, David | Democratic | 1192.15 | 8/10/20 0:00 | C&D Printing, Inc | Denver | CO | 80212 | Advertising | |
9397 | 9397 | House District 38 | Ortiz, David | Democratic | 25.0 | 8/11/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9403 | 9403 | House District 38 | Ortiz, David | Democratic | 2550.0 | 8/19/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | |
9405 | 9405 | House District 38 | Ortiz, David | Democratic | 21.22 | 8/24/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9406 | 9406 | House District 38 | Ortiz, David | Democratic | 3.47 | 8/24/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
9412 | 9412 | House District 38 | Ortiz, David | Democratic | 1257.5 | 8/31/20 0:00 | Campaign Products Of The Rockies | Denver | CO | 80121 | Advertising | |
9416 | 9416 | House District 38 | Ortiz, David | Democratic | 25.0 | 9/8/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9417 | 9417 | House District 38 | Ortiz, David | Democratic | 919.38 | 9/9/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | |
9419 | 9419 | House District 38 | Ortiz, David | Democratic | 25.0 | 9/11/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9421 | 9421 | House District 38 | Ortiz, David | Democratic | 45.1 | 9/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
9425 | 9425 | House District 38 | Ortiz, David | Democratic | 24708.9 | 9/17/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | |
9428 | 9428 | House District 38 | Ortiz, David | Democratic | 19.45 | 9/22/20 0:00 | Firstbank | Lakewood | CO | 80215 | Advertising | |
9429 | 9429 | House District 38 | Ortiz, David | Democratic | 4.37 | 9/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
9439 | 9439 | House District 38 | Ortiz, David | Democratic | 29.99 | 9/30/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
9442 | 9442 | House District 38 | Ortiz, David | Democratic | 106.74 | 10/2/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9445 | 9445 | House District 38 | Ortiz, David | Democratic | 24708.9 | 10/5/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | Mailers |
9447 | 9447 | House District 38 | Ortiz, David | Democratic | 184.24 | 10/5/20 0:00 | Scale To Win | Santa Ana | CA | 92703 | Advertising | Texting |
9449 | 9449 | House District 38 | Ortiz, David | Democratic | 8000.0 | 10/6/20 0:00 | Boulder Strategies | Boulder | CO | 80302 | Advertising | Digital Advertising |
9455 | 9455 | House District 38 | Ortiz, David | Democratic | 4000.0 | 10/13/20 0:00 | Boulder Strategies | Boulder | CO | 80302 | Advertising | Digital Advertising |
9456 | 9456 | House District 38 | Ortiz, David | Democratic | 2550.0 | 10/14/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | Walk Lit |
9457 | 9457 | House District 38 | Ortiz, David | Democratic | 27568.14 | 10/14/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | Mailing |
9461 | 9461 | House District 38 | Ortiz, David | Democratic | 2550.0 | 10/15/20 0:00 | Kabza | Wheatridge | CO | 80034 | Advertising | Mailers |
9462 | 9462 | House District 38 | Ortiz, David | Democratic | 69.22 | 10/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
9471 | 9471 | House District 38 | Ortiz, David | Democratic | 10000.0 | 10/23/20 0:00 | Boulder Strategies | Boulder | CO | 80302 | Advertising | Cable Advertising |
9477 | 9477 | House District 38 | Ortiz, David | Democratic | 25.0 | 10/27/20 0:00 | Bluelink | Washington | DC | 20016 | Advertising | |
9480 | 9480 | House District 38 | Ortiz, David | Democratic | 625.02 | 10/28/20 0:00 | Scale To Win | Santa Ana | CA | 92703 | Advertising | |
9484 | 9484 | House District 38 | Ortiz, David | Democratic | 4500.0 | 10/30/20 0:00 | Boulder Strategies | Boulder | CO | 80302 | Advertising | |
9490 | 9490 | House District 38 | Ortiz, David | Democratic | 29.99 | 11/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
9492 | 9492 | House District 38 | Ortiz, David | Democratic | 83.25 | 11/2/20 0:00 | Mountainview | CA | 94043 | Advertising | ||
9504 | 9504 | House District 38 | Ortiz, David | Democratic | 25.0 | 11/6/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9506 | 9506 | House District 38 | Ortiz, David | Democratic | 22.7 | 11/9/20 0:00 | Scale To Win | Santa Ana | CA | 92703 | Advertising | |
9515 | 9515 | House District 38 | Ortiz, David | Democratic | 384.0 | 11/13/20 0:00 | Survey Monkey | San Mateo | CA | 94403 | Advertising | |
9516 | 9516 | House District 38 | Ortiz, David | Democratic | 221.64 | 11/13/20 0:00 | Streamyard | Tualatin | OR | 97062 | Advertising | |
9517 | 9517 | House District 38 | Ortiz, David | Democratic | 429.0 | 11/13/20 0:00 | Zoom | San Jose | CA | 95113 | Advertising | |
9518 | 9518 | House District 38 | Ortiz, David | Democratic | 154.02 | 11/13/20 0:00 | Zoom | San Jose | CA | 95113 | Advertising | |
9528 | 9528 | House District 38 | Ortiz, David | Democratic | 20.0 | 11/27/20 0:00 | Squarespace | New York | NY | 10014 | Advertising | |
9529 | 9529 | House District 38 | Ortiz, David | Democratic | 20.0 | 11/27/20 0:00 | Squarespace | New York | NY | 10014 | Advertising | |
9530 | 9530 | House District 38 | Ortiz, David | Democratic | 20.0 | 11/27/20 0:00 | Squarespace | New York | NY | 10014 | Advertising | |
9531 | 9531 | House District 38 | Ortiz, David | Democratic | 20.0 | 11/27/20 0:00 | Squarespace | New York | NY | 10014 | Advertising | |
9533 | 9533 | House District 38 | Ortiz, David | Democratic | 30.99 | 11/30/20 0:00 | Mailchimp | Atlanta | GA | 30308 | 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 );