da_loans

5 rows

View and edit SQL

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

Link rowid ▼ district candidate affiliation loan_amount loan_date payment_amount payment_date loan_balance filed_date
1 DA 1 Jeffco Durkin, Matthew Republican 12000 5/1/20 0:00     12000 5/18/20 0:00
2 DA 17 Adams Mason, Brian Democratic 5000 2/27/19 0:00     0 4/15/19 0:00
3 DA 17 Adams Mason, Brian Democratic 5000 2/27/19 0:00 5000 11/2/19 0:00 0 1/15/20 0:00
4 DA 18 Arapahoe, Douglas, Lincoln, Elbert Padden, Amy Democratic 80000 7/27/19 0:00     80000 10/15/19 0:00
5 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"	TEXT,
	"payment_date"	TEXT,
	"loan_balance"	INTEGER,
	"filed_date"	TEXT
);
Powered by Datasette · Query took 38.468ms