State Agency Buy Recycled Campaign (SABRC)
State of California
@usgov.ca_gov_state_agency_buy_recycled_campaign_sabrc
State of California
@usgov.ca_gov_state_agency_buy_recycled_campaign_sabrc
CREATE TABLE sabrc_report_results_2013_2014 (
"agency_id" BIGINT,
"agency_name" VARCHAR,
"report_period" VARCHAR,
"report_year" VARCHAR,
"sabrc_category" VARCHAR,
"sub_category" VARCHAR,
"reportable_dollars" VARCHAR,
"compliant_dollars" VARCHAR,
"percentage_sabrc" VARCHAR
);
CREATE TABLE sabrc_report_status_2013_2014 (
"agency_id" BIGINT,
"agency_name" VARCHAR,
"report_period" VARCHAR,
"report_year" VARCHAR,
"report_status" VARCHAR,
"comment" VARCHAR
);
CREATE TABLE sabrc_report_results_2014_2015 (
"agency_id" BIGINT,
"agency_name" VARCHAR,
"sabrc_category" VARCHAR,
"reportable_dollars" VARCHAR,
"compliant_dollars" VARCHAR,
"percentage_sabrc" VARCHAR
);
CREATE TABLE sabrc_report_results_2012_2013 (
"agency_id" BIGINT,
"agency_name" VARCHAR,
"sabrc_category" VARCHAR,
"reportable_dollars" VARCHAR,
"compliant_dollars" VARCHAR,
"percentage_sabrc" VARCHAR
);
CREATE TABLE sabrc_report_results_2015_2016 (
"agency_id" BIGINT,
"agency_name" VARCHAR,
"sabrc_category" VARCHAR,
"reportable_dollars" VARCHAR,
"compliant_dollars" VARCHAR,
"percentage_sabrc" VARCHAR
);
Anyone who has the link will be able to view this.