Baselight

Charitable Solicitation Campaigns

State of Connecticut

@usgov.state_of_connecticut_charitable_solicitation_campaigns

Loading...
Loading...

About this Dataset

Charitable Solicitation Campaigns

All active and inactive campaigns
Organization: State of Connecticut
Last updated: 2023-08-12T15:22:16.410100
Tags: charitable-solicitation, charities

Tables

Table 1

@usgov.state_of_connecticut_charitable_solicitation_campaigns.table_1
  • 420.53 KB
  • 7043 rows
  • 22 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.