Campaign Financial Analysis
City of New York
@usgov.city_of_new_york_2021_financial_analysis
City of New York
@usgov.city_of_new_york_2021_financial_analysis
Financial Analysis of election campaign.
Organization: City of New York
Last updated: 2021-08-07T17:19:21.682612
Tags: cfb, financial-analysis
CREATE TABLE table_1 (
"el_cycle" BIGINT,
"from_stmt" BIGINT,
"to_stmt" BIGINT,
"office" BIGINT,
"cand_name" VARCHAR,
"cand_id" VARCHAR,
"boro_dist" VARCHAR,
"termnd" VARCHAR,
"incumbent" VARCHAR,
"cntrs_no" BIGINT,
"cntns_no" BIGINT,
"net_cntns" DOUBLE,
"match_amt" BIGINT,
"i_no" BIGINT,
"i_cntns_no" BIGINT,
"i_amt" DOUBLE,
"sml_no" BIGINT,
"sml_amt" DOUBLE,
"pubfnd_pmt" BIGINT,
"net_expnd" DOUBLE,
"cand_class_cd" VARCHAR,
"max_no" BIGINT,
"max_amt" DOUBLE,
"limit" BIGINT,
"outstanding_bills" DOUBLE,
"no_match" DOUBLE
);Anyone who has the link will be able to view this.