Skip to content

[FEATURE] Update Regional GQ Distribution to use 2024 5-year PUMS #201

@GregorSchroeder

Description

@GregorSchroeder

Is your feature request related to a problem? Please describe

The sql/ase/get_region_gq_ase_dist.sql script has year-specific logic that does not include 2024.

Describe the solution you'd like

Update sql/ase/get_region_gq_ase_dist.sql with year-specific logic for the 2024 5-year ACS PUMS when it is released on March 5th, 2026.

Describe alternatives you've considered

There is an argument to be made for adding a warning if the 5-year ACS PUMS exists but isn't being considered in the year-specific logic but the following portion of the code will just throw an error which is probably sufficient.

    -- Build ACS PUMS query based on year
    DECLARE @pums_qry nvarchar(max) =
        CASE 
            WHEN @year BETWEEN 2010 AND 2011 THEN 'SELECT [SCHG], [ESR], NULL AS [DIS], [AGEP], [SEX], [HISP], [RAC1P], NULL AS [RELSHIPP], [RELP], [PWGTP] FROM [acs].[pums].[vi_5y_' + CONVERT(nvarchar, @year-4) + '_' + CONVERT(nvarchar, @year) + '_persons_sd]'
            WHEN @year BETWEEN 2012 AND 2018 THEN 'SELECT [SCHG], [ESR], [DIS], [AGEP], [SEX], [HISP], [RAC1P], NULL AS [RELSHIPP], [RELP], [PWGTP] FROM [acs].[pums].[vi_5y_' + CONVERT(nvarchar, @year-4) + '_' + CONVERT(nvarchar, @year) + '_persons_sd]'
            WHEN @year BETWEEN 2019 AND 2023 THEN 'SELECT [SCHG], [ESR], [DIS], [AGEP], [SEX], [HISP], [RAC1P], [RELSHIPP], NULL AS [RELP], [PWGTP] FROM [acs].[pums].[vi_5y_' + CONVERT(nvarchar, @year-4) + '_' + CONVERT(nvarchar, @year) + '_persons_sd]'
        ELSE NULL END;

Additional context

https://www.census.gov/programs-surveys/acs/news/data-releases/2024/release-schedule.html

Metadata

Metadata

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions