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

74.21 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  -- DIGITAL : LATINX,
  "in_person_meetings_african_american" VARCHAR  -- IN-PERSON MEETINGS : AFRICAN AMERICAN,
  "in_person_meetings_asian_pacific_islander" VARCHAR  -- IN-PERSON MEETINGS : ASIAN-PACIFIC ISLANDER,
  "in_person_meetings_general_public" VARCHAR  -- IN-PERSON MEETINGS : GENERAL PUBLIC,
  "in_person_meetings_indigenous" VARCHAR  -- IN-PERSON MEETINGS : INDIGENOUS,
  "in_person_meetings_latinx" VARCHAR  -- IN-PERSON MEETINGS : LATINX,
  "in_person_meetings_lgbtqia" VARCHAR  -- IN-PERSON MEETINGS : LGBTQIA,
  "internet_african_american" VARCHAR  -- INTERNET : AFRICAN AMERICAN,
  "internet_asian_pacific_islander" VARCHAR  -- INTERNET : ASIAN-PACIFIC ISLANDER,
  "internet_deaf_and_disabled_community" VARCHAR  -- INTERNET : DEAF AND DISABLED COMMUNITY,
  "internet_general_public" VARCHAR  -- INTERNET : GENERAL PUBLIC,
  "internet_indigenous" VARCHAR  -- INTERNET : INDIGENOUS,
  "internet_latinx" VARCHAR  -- INTERNET : LATINX,
  "internet_lgbtqia" VARCHAR  -- INTERNET : LGBTQIA,
  "internet_middle_eastern" VARCHAR  -- INTERNET : MIDDLE EASTERN,
  "internet_non_specified_community_type" VARCHAR  -- INTERNET : NON-SPECIFIED COMMUNITY TYPE,
  "newspaper_african_american" VARCHAR  -- NEWSPAPER : AFRICAN AMERICAN,
  "newspaper_asian_pacific_islander" VARCHAR  -- NEWSPAPER : ASIAN-PACIFIC ISLANDER,
  "newspaper_deaf_and_disabled_community" VARCHAR  -- NEWSPAPER : DEAF AND DISABLED COMMUNITY,
  "newspaper_general_public" VARCHAR  -- NEWSPAPER : GENERAL PUBLIC,
  "newspaper_indigenous" VARCHAR  -- NEWSPAPER : INDIGENOUS,
  "newspaper_latinx" VARCHAR  -- NEWSPAPER : LATINX,
  "newspaper_lgbtqia" VARCHAR  -- NEWSPAPER : LGBTQIA,
  "newspaper_middle_eastern" VARCHAR  -- NEWSPAPER : MIDDLE EASTERN,
  "non_specified_media_type_african_american" VARCHAR  -- NON-SPECIFIED MEDIA TYPE : AFRICAN AMERICAN,
  "non_specified_media_type_deaf_and_disabled_community" VARCHAR  -- NON-SPECIFIED MEDIA TYPE : DEAF AND DISABLED COMMUNITY,
  "print_african_american" VARCHAR  -- PRINT : AFRICAN AMERICAN,
  "print_asian_pacific_islander" VARCHAR  -- PRINT : ASIAN-PACIFIC ISLANDER,
  "print_deaf_and_disabled_community" VARCHAR  -- PRINT : DEAF AND DISABLED COMMUNITY,
  "print_general_public" VARCHAR  -- PRINT : GENERAL PUBLIC,
  "print_latinx" VARCHAR  -- PRINT : LATINX,
  "print_lgbtqia" VARCHAR  -- PRINT : LGBTQIA,
  "print_middle_eastern" VARCHAR  -- PRINT : MIDDLE EASTERN,
  "radio_african_american" VARCHAR  -- RADIO : AFRICAN AMERICAN,
  "radio_asian_pacific_islander" VARCHAR  -- RADIO : ASIAN-PACIFIC ISLANDER,
  "radio_deaf_and_disabled_community" VARCHAR  -- RADIO : DEAF AND DISABLED COMMUNITY,
  "radio_general_public" VARCHAR  -- RADIO : GENERAL PUBLIC,
  "radio_indigenous" VARCHAR  -- RADIO : INDIGENOUS,
  "radio_latinx" VARCHAR  -- RADIO : LATINX,
  "radio_lgbtqia" VARCHAR  -- RADIO : LGBTQIA,
  "radio_middle_eastern" VARCHAR  -- RADIO : MIDDLE EASTERN,
  "social_media_latinx" VARCHAR  -- SOCIAL MEDIA : LATINX,
  "sponsorship_deaf_and_disabled_community" VARCHAR  -- SPONSORSHIP : DEAF AND DISABLED COMMUNITY,
  "sponsorship_latinx" VARCHAR  -- SPONSORSHIP : LATINX,
  "television_african_american" VARCHAR  -- TELEVISION : AFRICAN AMERICAN,
  "television_asian_pacific_islander" VARCHAR  -- TELEVISION : ASIAN-PACIFIC ISLANDER,
  "television_deaf_and_disabled_community" VARCHAR  -- TELEVISION : DEAF AND DISABLED COMMUNITY,
  "television_general_public" VARCHAR  -- TELEVISION : GENERAL PUBLIC,
  "television_indigenous" VARCHAR  -- TELEVISION : INDIGENOUS,
  "television_latinx" VARCHAR  -- TELEVISION : LATINX
);

Matadata 2022

@usgov.ca_gov_marketing_and_outreach_advertising_materials_pu_89da1b68.matadata_2022

3.39 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.43 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.39 kB
25 rows
2 columns

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