REPORT PARAMETERS

There is a more recent run of this report. Click here to view the most recent run of this report.

Report not found

There was a problem finding this report.
Created in the Mode Community
July 18, 2014 · Refreshed about 3 years ago
FEC Data example 3
Description
Fast food spending by candidate.

Collaborators

Run History
SELECT recipient_name, candidate_name, SUM(disbursement_amount) AS amount_spent, COUNT(*) AS transactions FROM cooldata.fec_2012_presidential_campaign_expenditures WHERE recipient_name ILIKE 'taco bell%' GROUP BY 1,2 ORDER BY 1,2
SELECT recipient_name, candidate_name, SUM(disbursement_amount) AS amount_spent, COUNT(*) AS transactions FROM cooldata.fec_2012_presidential_campaign_expenditures WHERE recipient_name ILIKE '{{restaurant}}%' GROUP BY 1,2 ORDER BY 1,2 {% form %} restaurant: type: text default: wendy {% endform %}
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-table id="table_faaa7136208d" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query. Get help here.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled