school_board_loans
2 rows where payment_date = "10/27/21" sorted by loan_balance
This data as json, CSV (advanced)
Link | rowid | district | candidate | loan_amount | loan_date | payment_amount | payment_date | loan_balance ▼ | filed_date |
---|---|---|---|---|---|---|---|---|---|
42 | 42 | POUDRE R-1 | GAITER, JEANNETTE | 1000.0 | 8/11/21 | 1000.0 | 10/27/21 | 0.0 | 10/29/21 |
44 | 44 | ENGLEWOOD 1 | HOAG, JULIE | 240.0 | 9/22/21 | 240.0 | 10/27/21 | 0.0 | 10/27/21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "school_board_loans" ( "district" TEXT, "candidate" TEXT, "loan_amount" REAL, "loan_date" TEXT, "payment_amount" REAL, "payment_date" TEXT, "loan_balance" REAL, "filed_date" TEXT );