About this Dataset

Fundraiser Notices Filed By Hawaii State And County Candidates

Fundraiser Notices Filed By Hawaii State and County Candidates
Organization: State of Hawaii
Last updated: 2024-04-10T22:37:20.452505
Tags: campaign, campaign-finance, campaign-spending-commission, candidates, csc, elections, fundraiser, fundraiser-notices, hawaii-candidates

Tables

Fundraiser Notices Filed By Hawaii State And County Candidates

@usgov.state_of_hawaii_fundraiser_notices_filed_by_hawaii_sta_53667a4a.fundraiser_notices_filed_by_hawaii_state_and_county_candidates

136.02 kB
2,060 rows
26 columns

CREATE TABLE fundraiser_notices_filed_by_hawaii_state_and_county_candidates (
  "candidate_name" VARCHAR,
  "person_in_charge" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "fundraiser_date" TIMESTAMP,
  "hour_time" VARCHAR  -- Hour (Time),
  "place_of_fundraiser" VARCHAR,
  "fundraiser_address_1" VARCHAR,
  "fundraiser_address_2" VARCHAR,
  "fundraiser_city" VARCHAR,
  "fundraiser_state" VARCHAR,
  "fundraiser_zip_code" DOUBLE,
  "price_or_suggested_contribution_range" VARCHAR  -- Price Or Suggested Contribution (Range),
  "price_or_suggested_contribution_max_range_if_applicable" DOUBLE  -- Price Or Suggested Contribution (Max Range, If Applicable),
  "office" VARCHAR,
  "district" VARCHAR,
  "county" VARCHAR,
  "reg_no" VARCHAR,
  "election_period" VARCHAR,
  "election" VARCHAR,
  "mapping_location" VARCHAR,
  "fundraiser_date_text" TIMESTAMP  -- Fundraiser Date(text),
  "during_session" VARCHAR
);