home / campaign_finance

da_loans

12 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: district, candidate, affiliation, loan_amount, loan_date, payment_amount, loan_balance, filed_date

Link rowid ▼ district candidate affiliation loan_amount loan_date payment_amount payment_date loan_balance filed_date
1 1 DA 1 Jeffco Durkin, Matthew Republican 12000 5/1/20 0:00     12000 5/18/20 0:00
2 2 DA 1 Jeffco Durkin, Matthew Republican -12000 5/1/20 0:00     -12000 12/3/20 0:00
3 3 DA 8 Larimer Mclaughlin, Gordon Democratic 6000 10/15/20 0:00     0 11/2/20 0:00
4 4 DA 8 Larimer Mclaughlin, Gordon Democratic 10000 10/20/20 0:00     10000 11/2/20 0:00
5 5 DA 8 Larimer Mclaughlin, Gordon Democratic 6000 10/15/20 0:00 6000 11/9/20 0:00 0 12/3/20 0:00
6 6 DA 17 Adams Mason, Brian Democratic 5000 2/27/19 0:00     0 4/15/19 0:00
7 7 DA 17 Adams Mason, Brian Democratic 5000 2/27/19 0:00 5000 11/2/19 0:00 0 1/15/20 0:00
8 8 DA 18 Arapahoe, Douglas, Lincoln, Elbert Padden, Amy Democratic 80000 7/27/19 0:00     80000 10/15/19 0:00
9 9 DA 11 Park et al Stanley, Linda Republican 5000 9/22/20 0:00     0 11/2/20 0:00
10 10 DA 11 Park et al Stanley, Linda Republican 5000 9/30/20 0:00     5000 11/2/20 0:00
11 11 DA 11 Park et al Stanley, Linda Republican 5000 9/22/20 0:00 5000 11/16/20 0:00 0 12/3/20 0:00
12 12 DA 11 Park et al Turner, Kaitlin Democratic 1000 1/25/20 0:00     1000 5/3/20 0:00

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "da_loans" (
"district" TEXT,
  "candidate" TEXT,
  "affiliation" TEXT,
  "loan_amount" INTEGER,
  "loan_date" TEXT,
  "payment_amount" INTEGER,
  "payment_date" TEXT,
  "loan_balance" INTEGER,
  "filed_date" TEXT
);
Powered by Datasette · Queries took 12.304ms