CSV

Marketing and outreach advertising dataset 2021

Data dictionary

Field definitions supplied by the publishing agency in CKAN.

Column	Type	Label	Description
Report Period	text	Report Period	—
Business Unit	text	Business Unit	—
Department Name	text	Department Name	—
Procurement Transaction ID	text	Procurement Transaction ID	—
Campaign Name	text	Campaign Name	—
contract_procurement_description	text	Contract/Procurement Description	—
Contract Start	text	Contract Start	—
Contract End	text	Contract End	—
Contract Amount Reported	text	Contract Amount Reported	—
fi_cal_supplier_id	text	FI$Cal Supplier ID	—
fi_cal_supplier_name	text	FI$Cal Supplier Name	—
Supplier Paid	text	Supplier Paid	—
Sub or Prime Contractor	text	Sub or Prime Contractor	—
N-LATINX	text	N-LATINX	—
N-AA	text	N-AA	—
N-API	text	N-API	—
N-I	text	N-I	—
N-MI	text	N-MI	—
N-LGBTQIA	text	N-LGBTQIA	—
N-ENGLISH	text	N-ENGLISH	—
N-O GENERAL PUBLIC	text	N-O GENERAL PUBLIC	—
n_o_architecture___engineering	text	N-O ARCHITECTURE & ENGINEERING	—
R-LATINX	text	R-LATINX	—
R-AA	text	R-AA	—
R-API	text	R-API	—
R-I	text	R-I	—
R-MI	text	R-MI	—
R-LGBTQIA	text	R-LGBTQIA	—
R-O GENERAL PUBLIC	text	R-O GENERAL PUBLIC	—
R-O-White	text	R-O-White	—
IN-LATINX	text	IN-LATINX	—
IN-AA	text	IN-AA	—
IN-API	text	IN-API	—
IN-I	text	IN-I	—
IN-MI	text	IN-MI	—
IN-LGBTQIA	text	IN-LGBTQIA	—
IN-O NON-SPECIFIED COMMUNITY	text	IN-O NON-SPECIFIED COMMUNITY	—
IN-O GENERAL PUBLIC	text	IN-O GENERAL PUBLIC	—
IN-O WHITE	text	IN-O WHITE	—
IN-O FARMWORKERS	text	IN-O FARMWORKERS	—
IN-O ESSENTIAL WORKERS	text	IN-O ESSENTIAL WORKERS	—
in_o_workers___employers	text	IN-O WORKERS & EMPLOYERS	—
IN-O DISABLED	text	IN-O DISABLED	—
IN-O MULTI-ETHNIC	text	IN-O MULTI-ETHNIC	—
IN-O SMALL BUSINESS OWNERS	text	IN-O SMALL BUSINESS OWNERS	—
IN-O VETERAN BUSINESS OWNERS	text	IN-O VETERAN BUSINESS OWNERS	—
P-LATINX	text	P-LATINX	—
P-AA	text	P-AA	—
P-API	text	P-API	—
P-I	text	P-I	—
P-MI	text	P-MI	—
P-LGBTQIA	text	P-LGBTQIA	—
P-O GENERAL PUBLIC	text	P-O GENERAL PUBLIC	—
P-O WHITE	text	P-O WHITE	—
P-O FARMWORKERS	text	P-O FARMWORKERS	—
P-O ESSENTIAL WORKERS	text	P-O ESSENTIAL WORKERS	—
p_o_workers___employers	text	P-O WORKERS & EMPLOYERS	—
P-O STATE EMPLOYEE	text	P-O STATE EMPLOYEE	—
O-O CANVASSING - LATINX	text	O-O CANVASSING - LATINX	—
O-O CANVASSING - AA	text	O-O CANVASSING - AA	—
O-O CANVASSING - API	text	O-O CANVASSING - API	—
O-O CANVASSING - I	text	O-O CANVASSING - I	—
O-O CANVASSING - MI	text	O-O CANVASSING - MI	—
O-O CANVASSING - LGBTQIA	text	O-O CANVASSING - LGBTQIA	—
O-O CANVASSING - NON-SPECIFIED	text	O-O CANVASSING - NON-SPECIFIED	—
O-O EVENTS - LATINX	text	O-O EVENTS - LATINX	—
O-O EVENTS - AA	text	O-O EVENTS - AA	—
O-O EVENTS - API	text	O-O EVENTS - API	—
O-O EVENTS - I	text	O-O EVENTS - I	—
O-O EVENTS - MI	text	O-O EVENTS - MI	—
O-O EVENTS - LGBTQIA	text	O-O EVENTS - LGBTQIA	—
O-O EVENTS - NON-SPECIFIED	text	O-O EVENTS - NON-SPECIFIED	—
O-O SM GRP MEETING - GENERAL PUBLIC	text	O-O SM GRP MEETING - GENERAL PUBLIC	—
O-O SM GRP MEETING - FARMWORKERS	text	O-O SM GRP MEETING - FARMWORKERS	—
O-O SM GRP MEETING - ESSENTIAL WORKERS	text	O-O SM GRP MEETING - ESSENTIAL WORKERS	—
o_o_sm_grp_meeting___workers___employers	text	O-O SM GRP MEETING - WORKERS & EMPLOYERS	—
O-O IN PERSON MEETING - GENERAL PUBLIC	text	O-O IN PERSON MEETING - GENERAL PUBLIC	—
o_o_in_person_meeting___workers___employers	text	O-O IN PERSON MEETING - WORKERS & EMPLOYERS	—
O-O IN PERSON MEETING - LATINX	text	O-O IN PERSON MEETING - LATINX	—
O-O IN PERSON MEETING - AA	text	O-O IN PERSON MEETING - AA	—
O-O IN PERSON MEETING - API	text	O-O IN PERSON MEETING - API	—
O-O IN PERSON MEETING - I	text	O-O IN PERSON MEETING - I	—
O-O IN PERSON MEETING - MI	text	O-O IN PERSON MEETING - MI	—
O-O IN PERSON MEETING - LGBTQIA	text	O-O IN PERSON MEETING - LGBTQIA	—
O-O IN PERSON MEETING - NON-SPECIFIED	text	O-O IN PERSON MEETING - NON-SPECIFIED	—
O-O HANDS ON EXPERIENCES - LOW INCOME	text	O-O HANDS ON EXPERIENCES - LOW INCOME	—
O-O VIDEO - GENERAL PUBLIC	text	O-O VIDEO - GENERAL PUBLIC	—
O-O VIDEO - FARMWORKERS	text	O-O VIDEO - FARMWORKERS	—
O-O VIDEO - ESSENTIAL WORKERS	text	O-O VIDEO - ESSENTIAL WORKERS	—
o_o_video___workers___employers	text	O-O VIDEO - WORKERS & EMPLOYERS	—
O-O TELECOMS - FARMWORKERS	text	O-O TELECOMS - FARMWORKERS	—
O-O TELECOMS - ESSENTIAL WORKERS	text	O-O TELECOMS - ESSENTIAL WORKERS	—
O-O TELECOMS - LATINX	text	O-O TELECOMS - LATINX	—
O-O TELECOMS - AA	text	O-O TELECOMS - AA	—
O-O TELECOMS - API	text	O-O TELECOMS - API	—
O-O TELECOMS - I	text	O-O TELECOMS - I	—
O-O TELECOMS - MI	text	O-O TELECOMS - MI	—
O-O TELECOMS - LGBTQIA	text	O-O TELECOMS - LGBTQIA	—
O-O TELECOMS - NON-SPECIFIED	text	O-O TELECOMS - NON-SPECIFIED	—
O-O TELEVISION - GENERAL PUBLIC	text	O-O TELEVISION - GENERAL PUBLIC	—
O-O TELEVISION - DISABLED	text	O-O TELEVISION - DISABLED	—
O-O HIGHWAY SIGNAGE - GENERAL PUBLIC	text	O-O HIGHWAY SIGNAGE - GENERAL PUBLIC	—
O-O NON-SPECIFIC - GENERAL PUBLIC	text	O-O NON-SPECIFIC - GENERAL PUBLIC	—
O-O SPONSORSHIP - DISABLED	text	O-O SPONSORSHIP - DISABLED	—

Resource details

Format	CSV
Size	84 KB
Rows	170
Last updated	Sep 30, 2026
Part of	Marketing and Outreach Advertising Materials Purchase

Other resources in this dataset

CKAN Data API

Access resource data through the CKAN DataStore API. The examples below use this resource's ID.

Endpoints

The Data API provides these actions. Creating or updating records requires appropriate permissions; the query actions read public DataStore records.

Create	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_create`
Update / insert	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_upsert`
Query	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search`
Query via SQL	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql`

Query examples

First five results

"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=90c8eea3-de04-460c-bb0d-97b9d7ba8aa1&limit=5"

Results containing "jones"

"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=90c8eea3-de04-460c-bb0d-97b9d7ba8aa1&q=jones"

SQL query

"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql?sql=SELECT%20%2A%20FROM%20%2290c8eea3-de04-460c-bb0d-97b9d7ba8aa1%22%20LIMIT%205"

SQL queries depend on whether SQL search is enabled by the portal.

OData query

Use the resource's OData URL and its field names for paging, selecting columns, or filtering rows.

ODATA_RESOURCE_URL?$top=5
ODATA_RESOURCE_URL?$skip=5&$top=5
ODATA_RESOURCE_URL?$select=FIELD_NAME&$filter=FIELD_NAME eq 'VALUE'

Replace ODATA_RESOURCE_URL, FIELD_NAME, and VALUE with the details for the selected resource. See the OData query options guide (opens in a new tab) for more examples.

Use the API in code

JavaScript (JSONP)

var data = { resource_id: '90c8eea3-de04-460c-bb0d-97b9d7ba8aa1', limit: 5, q: 'jones' };
$.ajax({
  url: 'https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function (response) {
    console.log(response.result.total, response.result.records);
  }
});

Python

import json
from urllib.request import urlopen

url = 'https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=90c8eea3-de04-460c-bb0d-97b9d7ba8aa1&limit=5'
with urlopen(url) as response:
    result = json.load(response)['result']
print(result['total'], result['records'])

For parameters and response fields, see the CKAN DataStore documentation (opens in a new tab).