state_exp
19 rows where expenditure_type = "Advertising" and state = "NY"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9538 | 9538 | Attorney General | Phil Weiser | Democratic | 27138.0 | 9/20/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9539 | 9539 | Attorney General | Phil Weiser | Democratic | 119636.0 | 9/22/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9543 | 9543 | Attorney General | Phil Weiser | Democratic | 109811.0 | 9/26/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9545 | 9545 | Attorney General | Phil Weiser | Democratic | -109811.0 | 9/26/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Offset Due To Update Of Filed Item - Advertising |
9546 | 9546 | Attorney General | Phil Weiser | Democratic | 109811.0 | 9/26/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9556 | 9556 | Attorney General | Phil Weiser | Democratic | 20709.85 | 10/3/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9568 | 9568 | Attorney General | Phil Weiser | Democratic | 20709.85 | 10/6/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9569 | 9569 | Attorney General | Phil Weiser | Democratic | -20709.85 | 10/6/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Offset Due To Update Of Filed Item - Advertising |
9570 | 9570 | Attorney General | Phil Weiser | Democratic | 20709.85 | 10/6/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9574 | 9574 | Attorney General | Phil Weiser | Democratic | 10899.07 | 10/11/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9575 | 9575 | Attorney General | Phil Weiser | Democratic | 108241.0 | 10/12/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9584 | 9584 | Attorney General | Phil Weiser | Democratic | 20709.85 | 10/14/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9588 | 9588 | Attorney General | Phil Weiser | Democratic | 9810.78 | 10/17/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9595 | 9595 | Attorney General | Phil Weiser | Democratic | 133755.0 | 10/19/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9601 | 9601 | Attorney General | Phil Weiser | Democratic | 192754.0 | 10/25/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9605 | 9605 | Attorney General | Phil Weiser | Democratic | 22759.07 | 10/26/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9612 | 9612 | Attorney General | Phil Weiser | Democratic | 2000.0 | 10/31/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9620 | 9620 | Attorney General | Phil Weiser | Democratic | 138754.0 | 11/2/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
9625 | 9625 | Attorney General | Phil Weiser | Democratic | 38000.0 | 11/4/22 | Berlin Rosen, Ltd | New York | NY | 10038 | Advertising | Advertising |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_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 );