super_pacs_exp

3 rows where state = "NM"

✎ 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
1200 1200 Forward Progress Independent Expenditure Committee 3000.0 11/1/21 Rio Strategies Albuquerque NM 87196 Advertising Digital Advertising Opposing Scott Esserman For Denver Board Of Education
1201 1201 Forward Progress Independent Expenditure Committee 1000.0 11/1/21 Rio Strategies Albuquerque NM 87196 Advertising Digital Advertising Opposing Marla Benavidez For Denver Board Of Education
1202 1202 Forward Progress Independent Expenditure Committee 5500.0 11/1/21 Rio Strategies Albuquerque NM 87196 Advertising Digital Advertising In Support Of Gene Fashaw, Karolina Villagrana, And Vernon Jones Jr. For Denver Board Of Education

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
);