Off-Year And Special Elections Intermediary
City of New York
@usgov.city_of_new_york_off_year_special_elections_intermediary
City of New York
@usgov.city_of_new_york_off_year_special_elections_intermediary
This dataset contains each intermediaries contribution to a campaign during an off-year or special election.
Organization: City of New York
Last updated: 2021-08-07T17:58:01.108294
Tags: cfb, intermediaries, off-year
CREATE TABLE table_1 (
"election" VARCHAR,
"officecd" BIGINT,
"candid" VARCHAR,
"canclass" VARCHAR,
"candlast" VARCHAR,
"candfirst" VARCHAR,
"candmi" VARCHAR,
"committee" VARCHAR,
"name" VARCHAR,
"c_code" VARCHAR,
"strno" VARCHAR,
"strname" VARCHAR,
"apartment" VARCHAR,
"boroughcd" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"occupation" VARCHAR,
"empname" VARCHAR,
"empstrno" VARCHAR,
"empstrname" VARCHAR,
"empcity" VARCHAR,
"empstate" VARCHAR,
"amnt" DOUBLE
);Anyone who has the link will be able to view this.