Introduction
This page includes interactive data dashboards related to SDDT revenue over time, how funds have been allocated over the past five years, numbers and demographics of people paid with SDDT funds, and numbers and demographics of participants of SDDT-funded programs, Scroll down the page to view and interact with each of the dashboards.
History of Sugary Drinks Distributor Tax Revenue
This dashboard visualizes the total amount of SDDT tax revenue by fiscal year. Please click the expand button at the bottom right corner to view the dashboard in full screen. In fiscal year 2017-2018, the Mayor and Board of Supervisors allocated projected SDDT revenue before the SDDT Advisory Committee (SDDTAC) was established. For FY 2017-2018, the SDDTAC recommended that the $200,000 of uncommitted SDDT revenue be used for community outreach, data, and marketing.
Change in SDDT Revenue Over Time with Comparison
This dashboard visualizes the overall 5-year percentage change and individual fiscal year growth rates of SDDT tax v.s. Sales & Use tax revenues. Please click the expand button at the bottom right corner to view the dashboard in full screen.
SDDTAC Funding Recommendations and Actual Budgets
This dashboard shows year-to-year SDDT funding recommendations made by the SDDT Advisory Committee (SDDTAC) and actual budgets organized by category. Use the filter checkboxes on the right to filter the data. Please click the expand button at the bottom right corner to view the dashboard in full screen.
SDDT Funds Allocated by Primary Focus of Funded Organization or Work
This dashboard shows how much funding was allocated over five fiscal years (2018-19 through 2022-23) to organizations based on the primary focus of funded organizations. (Although many funded organizations offer some programming that addresses focus areas other than their primary focus, that information is not presented in this data visualization.) These allocations include some adjustments to account for unspent funds that “rolled over” and were used the fiscal year after they were allocated or for additional funds allocated during the add-back process. Use the filter checkboxes on the right to filter the data (SDDTAC Monitored Funding Categories are those presented in the dashboard above titled “SDDTAC Funding Recommendations and Actual Budgets”). Please click the expand button at the bottom right corner to view the dashboard in full screen.
SDDT Funds Allocated to Specific Organizations by Funded Intervention/Purpose
This dashboard shows how much funding was allocated to support different interventions or purposes over five fiscal years (2018-19 through 2022-23). These allocations include some adjustments to account for unspent funds that “rolled over” and were used the fiscal year after they were allocated or for additional funds allocated during the add-back process. Use the filter checkboxes on the right to filter the data (SDDTAC Monitored Funding Categories are those presented in the dashboard above titled “SDDTAC Funding Recommendations and Actual Budgets”). Please click the expand button at the bottom right corner to view the dashboard in full screen.
People Paid with SDDT Funds
This dashboard shows data about people paid with SDDT funds each fiscal year (primarily employees of SDDT-funded organizations, but also some participants who received large stipends). These include: 1) the number of people paid each fiscal year; 2) the breakdown of people paid by whether or not they lived in San Francisco; and 3) the percentage of people paid each fiscal year who are only white, whose race/ethnicity was not reported, and who are BIPOC (Black, indigenous, or people of color). To see additional graphs, click the right or left arrow at the bottom of the embedded dashboard (the numbers in between the arrows indicate which graph you are currently viewing). Please click the expand button at the bottom right corner to view the dashboard in full screen.
* Please note that in fiscal years 2019-20 and 2020-21, most (but not all) funded programs reported data on people paid with SDDT funds. Therefore, the numbers presented for 2019-20 and 2020-21 are an undercount.
Participants in SDDT-Funded Programming and Services
This dashboard shows the minimum number* of unduplicated people who participated in SDDT-funded programs in each of the past four fiscal years and the racial/ethnic demographics of program participants in each fiscal year. To see additional graphs, click the right or left arrow at the bottom of the embedded dashboard (the numbers in between the arrows indicate which graph you are currently viewing). Please click the expand button at the bottom right corner to view the dashboard in full screen.
* Please note that in fiscal years 2019-20 and 2020-21, most (but not all) funded programs reported data on people paid with SDDT funds. Therefore, the numbers presented for 2019-20 and 2020-21 are an undercount.
Data Sources
SDDT Revenue and Change in Sales Tax vs SDDT Revenue
- City and County of San Francisco. “SF OpenBook: Spending and Revenue.” https://openbook-report.sfgov.org/OBMiddleware/report.aspx?reportname=3
SDDT funding recommendations vs actual allocations
- Source for FY 2022-2023 SDDTAC recommendations and final SDDT funding allocations: “Mayor’s FY 2022-23 and 2023-24 Sugar-Sweetened Beverage Distributor Tax Programming.” https://sf.gov/sites/default/files/2022-07/SSBDT%20Summary%20060622-FINAL_0.pdf
- Source for FY 2021-2022 SDDTAC recommendations and final SDDT funding allocations: “SDDTAC Budget Recommendations FY 21-22 and Mayor’s Recommendations.” https://www.sfdph.org/dph/files/SDDTAC/Comparison_of_SDDTAC_Rx_Mayors_Rx_FY21_22_FY_22_23.pdf
- Source for FY 2020-2021 SDDTAC recommendations and final SDDT funding allocations: “SDDTAC & Mayor’s Proposed Soda Tax Allocations FY 20-21.” https://www.sfdph.org/dph/files/SDDTAC/Copy_of_SDDTAC_v_Mayor_Comparison_FY20_21.pdf
- Source for final SDDT funding allocations for FY 2018-2019 and FY 2019-2020: “Soda Tax Allocation ‐ FY 2019‐20 and FY 2020‐21.” https://www.sfdph.org/dph/files/SDDTAC/FINAL%20BUDGET%20RECOMMENDATIONS_APPROVED%20AND%20MODIFIED%20BY%20MO_BOS.pdf
- Source for FY 2019-2020 SDDTAC recommendations: “Final SDDTAC Budget Recommendations for FY19-20 and FY20-21.” https://www.sfdph.org/dph/files/SDDTAC/FY19_20-20_21SDDTACRX-final.pdf
- Source for FY 2018-2019 SDDTAC recommendations: “SDDTAC Allocation Recommendations.” https://www.sfdph.org/dph/files/SDDTAC/sddtac_Rx_chart.pdf
- Source for FY 2017-2018 SDDTAC recommendations: “SDDTAC Allocation Recommendations.” https://www.sfdph.org/dph/files/SDDTAC/SDDTAC-2018-Annual-Report.pdfhttps://www.sfdph.org/dph/files/SDDTAC/sddtac_Rx_chart.pdf
Data Disclaimer:
The data presented in these maps and data dashboards was created by SFDPH and R+A for SDDT Evaluation purposes only; the maps and data dashboards were designed and operated solely for SFDPH staff, SDDT Funded Entities and general public education. SFDPH and R+A do not guarantee the accuracy of the data presented. By entering this site, you acknowledge that SFDPH and R+A will not be responsible for any damage, loss or injury resulting from use of the information herein. Site users agree to defend, indemnify, and hold harmless SFDPH and R+A, its directors, officers, and employees, from and against any and all actions, damages, costs, liabilities, claims, demands, losses, judgments, penalties, costs and expenses, including attorney’s fees, arising out of, or in any way connected with, the use of the applications and/or the data contained therein.