super_pacs_exp

3 rows where committee = "Blueflower Action" and state = "CT"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee committee_type expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
317 317 Blueflower Action Independent Expenditure Committee 14913.65 3/12/21 Mission Control Glastonbury CT 6033 Consultant & Professional Services Mail
348 348 Blueflower Action Independent Expenditure Committee 15034.65 3/19/21 Mission Control Glastonbury CT 6033 Consultant & Professional Services Mail
365 365 Blueflower Action Independent Expenditure Committee 14942.65 3/24/21 Mission Control Glastonbury CT 6033 Consultant & Professional Services Mail

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "super_pacs_exp" (
"committee" TEXT,
  "committee_type" TEXT,
  "expenditure_amount" REAL,
  "expenditure_date" TEXT,
  "recipient" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zip" TEXT,
  "expenditure_type" TEXT,
  "explanation" TEXT
);