About this Dataset

Marketing And Outreach Advertising Materials Purchase

On September 30, 2020, AB 323 (Ch. 341, Stats. 2020) was passed and chaptered into law thereby establishing the requirement for DGS to post on its Internet website purchases related to marketing and outreach advertising materials for every state office, officer, department, division, bureau, board, and commission identified in GC 11000, and including the California State University. These purchases must be further disaggregated to show placement of marketing and outreach advertising materials targeting communications with specific ethnic communities including but not limited to Latino, African American, Asian-Pacific Islander, Indigenous, Middle Eastern and LGTBQIA communities as outlined by Public Contract Code 11800-11804.
Organization: State of California
Last updated: 2021-08-20T07:38:44.694396
Tags: dgs, marketing, outreach-advertising, procurement

Tables

Marketing And Outreach Advertising Dataset 2023

@usgov.ca_gov_marketing_and_outreach_advertising_materials_pu_89da1b68.marketing_and_outreach_advertising_dataset_2023

72.47 KB
665 rows
63 columns


CREATE TABLE marketing_and_outreach_advertising_dataset_2023 (
  "report_period" VARCHAR,
  "business_unit" BIGINT,
  "department_name" VARCHAR,
  "procurement_transaction_id" VARCHAR,
  "campaign_name" VARCHAR,
  "creation_date" TIMESTAMP,
  "contract_start" TIMESTAMP,
  "contract_end" TIMESTAMP,
  "sub_or_prime_contractor" VARCHAR,
  "fi_cal_supplier_name" VARCHAR,
  "fi_cal_supplier_id" VARCHAR,
  "supplier_paid" VARCHAR,
  "contract_amount_reported" VARCHAR,
  "digital_latinx" VARCHAR,
  "in_person_meetings_african_american" VARCHAR,
  "in_person_meetings_asian_pacific_islander" VARCHAR,
  "in_person_meetings_general_public" VARCHAR,
  "in_person_meetings_indigenous" VARCHAR,
  "in_person_meetings_latinx" VARCHAR,
  "in_person_meetings_lgbtqia" VARCHAR,
  "internet_african_american" VARCHAR,
  "internet_asian_pacific_islander" VARCHAR,
  "internet_deaf_and_disabled_community" VARCHAR,
  "internet_general_public" VARCHAR,
  "internet_indigenous" VARCHAR,
  "internet_latinx" VARCHAR,
  "internet_lgbtqia" VARCHAR,
  "internet_middle_eastern" VARCHAR,
  "internet_non_specified_community_type" VARCHAR,
  "newspaper_african_american" VARCHAR,
  "newspaper_asian_pacific_islander" VARCHAR,
  "newspaper_deaf_and_disabled_community" VARCHAR,
  "newspaper_general_public" VARCHAR,
  "newspaper_indigenous" VARCHAR,
  "newspaper_latinx" VARCHAR,
  "newspaper_lgbtqia" VARCHAR,
  "newspaper_middle_eastern" VARCHAR,
  "non_specified_media_type_african_american" VARCHAR,
  "non_specified_media_type_deaf_and_disabled_community" VARCHAR,
  "print_african_american" VARCHAR,
  "print_asian_pacific_islander" VARCHAR,
  "print_deaf_and_disabled_community" VARCHAR,
  "print_general_public" VARCHAR,
  "print_latinx" VARCHAR,
  "print_lgbtqia" VARCHAR,
  "print_middle_eastern" VARCHAR,
  "radio_african_american" VARCHAR,
  "radio_asian_pacific_islander" VARCHAR,
  "radio_deaf_and_disabled_community" VARCHAR,
  "radio_general_public" VARCHAR,
  "radio_indigenous" VARCHAR,
  "radio_latinx" VARCHAR,
  "radio_lgbtqia" VARCHAR,
  "radio_middle_eastern" VARCHAR,
  "social_media_latinx" VARCHAR,
  "sponsorship_deaf_and_disabled_community" VARCHAR,
  "sponsorship_latinx" VARCHAR,
  "television_african_american" VARCHAR,
  "television_asian_pacific_islander" VARCHAR,
  "television_deaf_and_disabled_community" VARCHAR,
  "television_general_public" VARCHAR,
  "television_indigenous" VARCHAR,
  "television_latinx" VARCHAR
);

Matadata 2022

@usgov.ca_gov_marketing_and_outreach_advertising_materials_pu_89da1b68.matadata_2022

3.31 KB
25 rows
2 columns


CREATE TABLE matadata_2022 (
  "field" VARCHAR,
  "value" VARCHAR
);

Metadata 2021

@usgov.ca_gov_marketing_and_outreach_advertising_materials_pu_89da1b68.metadata_2021

5.3 KB
24 rows
4 columns


CREATE TABLE metadata_2021 (
  "field" VARCHAR,
  "value" VARCHAR,
  "field_1" VARCHAR,
  "value_1" VARCHAR
);

Metadata 2023

@usgov.ca_gov_marketing_and_outreach_advertising_materials_pu_89da1b68.metadata_2023

3.31 KB
25 rows
2 columns


CREATE TABLE metadata_2023 (
  "field" VARCHAR,
  "value" VARCHAR
);