Charitable Solicitation Campaigns
State of Connecticut
@usgov.state_of_connecticut_charitable_solicitation_campaigns
State of Connecticut
@usgov.state_of_connecticut_charitable_solicitation_campaigns
CREATE TABLE table_1 (
"charitable_organization_name" VARCHAR,
"charitable_organization_address_line_1" VARCHAR,
"charitable_organization_address_line_2" VARCHAR,
"charitable_organization_city_state_zip" VARCHAR,
"charitable_organization_registration_no" VARCHAR,
"paid_solicitor_name" VARCHAR,
"paid_solicitor_address_line_1" VARCHAR,
"paid_solicitor_address_line_2" VARCHAR,
"paid_solicitor_city_state_zip" VARCHAR,
"campaign_registration_no" VARCHAR,
"campaign_start_date" TIMESTAMP,
"campaign_end_date" TIMESTAMP,
"campaign_status" VARCHAR,
"minimum_percentage_of_gross_receipts_guaranteed_to_the_5d626f59" DOUBLE,
"method_of_solicitation" VARCHAR,
"gross_revenue" DOUBLE,
"campaign_expenses" DOUBLE,
"amount_retained_by_charity" DOUBLE,
"percentage_to_charity_from_report" DOUBLE,
"report_number" VARCHAR,
"start_reporting_period" TIMESTAMP,
"end_reporting_period" TIMESTAMP
);
Anyone who has the link will be able to view this.