senate_exp

33 rows where city = "Waltham" and state = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District, candidate_name, Party, expenditure_amount, recipient, zip, expenditure_type, explanation

Link rowid ▼ District candidate_name Party expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
568 568 Senate District 03 Stephen A. Varela Republican 398.63 9/20/22 Vistaprint Waltham MA 2451 Advertising Advertising
971 971 Senate District 04 Jeff Ravage Democratic 53.94 9/25/22 Constant Contact Waltham MA 2451 Other Email Platform
985 985 Senate District 07 Janice Rich Republican 41.76 7/6/21 Vistaprint Waltham MA 2451 Advertising  
1261 1261 Senate District 08 Matt Solomon Republican 95.56 2/8/22 Vista Print Waltham MA 2451 Advertising  
1285 1285 Senate District 08 Matt Solomon Republican 136.51 3/3/22 Vista Print Waltham MA 2451 Advertising  
1343 1343 Senate District 08 Matt Solomon Republican 2899.47 5/4/22 Vista Print Waltham MA 2451 Advertising  
1355 1355 Senate District 08 Matt Solomon Republican 149.19 5/12/22 Vista Print Waltham MA 2451 Advertising  
1364 1364 Senate District 08 Matt Solomon Republican 621.67 5/20/22 Vista Print Waltham MA 2451 Advertising  
1425 1425 Senate District 08 Matt Solomon Republican 175.87 7/16/22 Vista Print Waltham MA 2451 Advertising  
1873 1873 Senate District 09 Arik Dougherty Democratic 783.23 8/15/22 Vistaprint.Com Waltham MA 2451 Advertising Advertising
1906 1906 Senate District 11 Tony Exum Democratic 187.0 3/8/22 Constant Contact Waltham MA 2451 Other Communication
2476 2476 Senate District 15 Rob Woodward Republican 45.0 7/1/21 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2478 2478 Senate District 15 Rob Woodward Republican 45.0 7/29/21 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2495 2495 Senate District 15 Rob Woodward Republican 45.0 8/30/21 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2553 2553 Senate District 15 Rob Woodward Republican 65.0 3/1/22 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2572 2572 Senate District 15 Rob Woodward Republican 65.0 3/23/22 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2632 2632 Senate District 15 Rob Woodward Republican 125.0 6/22/22 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2670 2670 Senate District 15 Rob Woodward Republican 125.0 7/28/22 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2671 2671 Senate District 15 Rob Woodward Republican 125.0 7/28/22 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2745 2745 Senate District 15 Rob Woodward Republican 45.0 10/4/21 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2760 2760 Senate District 15 Rob Woodward Republican 125.0 10/13/22 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
2786 2786 Senate District 15 Rob Woodward Republican 45.0 11/1/21 Constant Contact Waltham MA 2451 Other 7350 ∑ Email Service
3714 3714 Senate District 24 Courtney Potter Republican 199.97 4/21/22 Vista Print Waltham MA 2451 Advertising  
3847 3847 Senate District 25 Melody Peotter Republican 65.77 6/27/22 Vista Print Waltham MA 2451 Advertising  
3848 3848 Senate District 25 Melody Peotter Republican 271.02 7/10/22 Vista Print Waltham MA 2451 Advertising  
3853 3853 Senate District 25 Melody Peotter Republican 106.0 8/23/22 Vista Print Waltham MA 2451 Advertising  
3856 3856 Senate District 25 Melody Peotter Republican 1372.44 10/4/22 Vista Print Waltham MA 2451 Advertising  
5116 5116 Senate District 35 Rod Pelton Republican 98.34 2/18/22 Vista Print Waltham MA 2421 Advertising  
5117 5117 Senate District 35 Rod Pelton Republican 112.43 2/18/22 Vista Print Waltham MA 2421 Advertising  
5159 5159 Senate District 35 Rod Pelton Republican 1142.18 5/8/22 Vista Print Waltham MA 2421 Advertising Yard Signs
5179 5179 Senate District 35 Rod Pelton Republican 68.42 6/9/22 Vista Print Waltham MA 2421 Advertising  
5278 5278 Senate District 35 Rod Pelton Republican 106.18 10/1/22 Vista Print Waltham MA 2421 Advertising Palm Cards
5339 5339 Senate District 35 Rod Pelton Republican 146.33 12/28/21 Vistaprint Waltham MA 2421 Advertising Magnet Signs

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "senate_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
);