Enforcement Audit Determinations
City of New York
@usgov.city_of_new_york_enforcement_audit_determinations
City of New York
@usgov.city_of_new_york_enforcement_audit_determinations
This dataset lists the audit determinations that the New York City Campaign Finance Board has imposed on New York City political campaigns from the year 2000 to the present.
Organization: City of New York
Last updated: 2024-07-26T21:07:40.823894
Tags: campaign, campaign-finance, campaign-finance-board, contributions, elections, finance, funding, politics
CREATE TABLE table_1 (
"name" VARCHAR,
"candidate_id" VARCHAR,
"election_cycle" VARCHAR,
"candidate_program_participation_status" VARCHAR,
"amount_contributions" DOUBLE,
"amount_expenditures" DOUBLE,
"amount_public_funds_received" BIGINT,
"date_draft_audit_report_dar_sent_to_campaign" TIMESTAMP -- Date Draft Audit Report (DAR) Sent To Campaign,
"date_final_audit_report_far_sent_to_campaign" TIMESTAMP -- Date Final Audit Report (FAR) Sent To Campaign,
"audit_complete_date" TIMESTAMP,
"date_final_board_determination_fbd_sent_to_campaign" TIMESTAMP -- Date Final Board Determination (FBD) Sent To Campaign,
"penalties" DOUBLE,
"public_funds_repayment_obligation" DOUBLE,
"penalties_still_outstanding" DOUBLE,
"public_funds_repayments_still_outstanding" DOUBLE,
"penalty_or_public_funds_still_outstanding" VARCHAR
);Anyone who has the link will be able to view this.