Sales Tax Commodity Report

  • An interesting and useful dataset
  • Published quarterly by DOR
  • Shows monthly distributions of sales tax revenue to all GA counties
  • Distributions based on 1% county-wide LOST or ELOST
  • Breaks the distributions down by NAICS Commodity Sector
  • 2016 - present

NAICS Commodity Sectors

  • Accommodations
  • Automotive
  • Construction
  • Food and Bars
  • General Merchandise
  • Home Furnishing
  • Manufacturing
  • Miscellaneous
  • Other Retail
  • Other Services
  • Utilities
  • Wholesale

Data

CountyName DCARegion date Accommodations Auto Construction FoodBars GeneralMerch Home Furnishing Manufacturing Misc Service Other Retail Other Services Utility Wholesale Total
Appling 9 2026-01-01 2740.11 24800.38 1587.36 58513.53 NA 23795.17 20718.56 24367.66 200593.18 27613.04 47672.15 50673.12 483074.27
Appling 9 2026-02-01 3208.12 16128.80 3154.10 48476.26 NA 24220.93 13551.82 14095.22 143044.81 16720.80 59705.06 44694.63 387000.57
Appling 9 2026-03-01 3860.31 17517.86 3716.36 45565.05 NA 20206.43 14875.14 7197.79 148422.42 16603.53 83994.74 42617.57 404577.19
Atkinson 11 2026-01-01 3.37 2774.68 3180.03 7600.01 NA 3394.35 2210.93 9314.84 39561.74 2735.52 12017.10 5649.63 88442.19
Atkinson 11 2026-02-01 11.24 2799.81 530.60 9486.33 NA 2919.59 6164.37 9612.81 28982.11 2184.61 12917.89 6767.79 82377.15
Atkinson 11 2026-03-01 13.21 3554.09 331.79 7540.81 NA 2021.45 2267.77 8526.89 30857.55 2546.94 12010.42 3678.99 73349.91
Bacon 11 2026-01-01 468.68 5034.82 1061.32 33516.03 NA 8951.09 9302.99 9048.41 73213.22 7092.15 19936.64 28447.64 196073.00

Uses

  • Monitoring state and local sales tax bases
  • Indicator of consumer spending
  • Economic sectoral composition
  • Comparing state and local economies across time and geography

Limitations

  • Time lag
  • PDF format
  • Missing values
  • Sales tax exemptions

Historic Statewide Distributions + Forecast

2025 Sector Breakdown

YoY Change in Distributions by Category

Tidy Census

  • R package designed to facilitate the process of acquiring and working with US Census Bureau population data
  • Aims to make census data readily available in a user friendly format
  • Streamlines data cleaning / wrangling process
  • Facilitates mapping and spatial analysis
  • Developed by Kyle Walker (TCU) and Matt Herman (The Council of State Governments Justice Center)

Basic Usage

https://walker-data.com/census-r/an-introduction-to-tidycensus.html

# install.packages("tidycensus")
# census_api_key("YOUR KEY GOES HERE", install = TRUE)
library(tidycensus) # load the package 
acs_variable_dictionary = load_variables(2023, dataset = "acs5")

Dictionary

name label concept geography
B01001A_001 Estimate!!Total: Sex by Age (White Alone) tract
B01001A_002 Estimate!!Total:!!Male: Sex by Age (White Alone) tract
B01001A_003 Estimate!!Total:!!Male:!!Under 5 years Sex by Age (White Alone) tract
B01001A_004 Estimate!!Total:!!Male:!!5 to 9 years Sex by Age (White Alone) tract
B01001A_005 Estimate!!Total:!!Male:!!10 to 14 years Sex by Age (White Alone) tract

Pulling Data

my_data = get_acs(
  year = 2023,
  geography = "county",
  state = "13",
  variables = c(median_income_male = "B19326_002",
                median_income_female = "B19326_005"),
  geometry = TRUE,
  survey = "acs5",
  output = "wide"
) |> 
  mutate(gender_pay_gap = median_income_maleE - median_income_femaleE) |> 
  select(! ends_with("M"))

GEOID NAME median_income_maleE median_income_femaleE gender_pay_gap geometry
13185 Lowndes County, Georgia 40587 26813 13774 MULTIPOLYGON (((-83.48448 3...
13127 Glynn County, Georgia 45558 28394 17164 MULTIPOLYGON (((-81.78263 3...
13051 Chatham County, Georgia 41177 31595 9582 MULTIPOLYGON (((-81.3917 32...
13179 Liberty County, Georgia 41618 26401 15217 MULTIPOLYGON (((-81.8244 32...
13073 Columbia County, Georgia 58510 33745 24765 MULTIPOLYGON (((-82.44285 3... 

my_data |> 
  ggplot(aes(geometry = geometry, fill = gender_pay_gap))+
  geom_sf()+
  scale_fill_viridis(labels = label_dollar(),
                     option = "F", 
                     direction = -1)+
  theme_void()+
  labs(fill = "Median Pay Gender Gap")