Skip to content

[FEATURE] Let LEHD LODES query back 1 or more years when data not available #188

@bryce-sandag

Description

@bryce-sandag

Is your feature request related to a problem? Please describe

The QCEW data has newer data than published LEHD LODES data. For example QCEW has 2024 annual data published but but 2023 is most current year of LEHD LODES DATA

Describe the solution you'd like

Want to create functionality that if LEHD LODES data is missing for given year it grabs the most recent year of data available. For example if given 2024 it would recognize data doesn't exist and go back one year and grab 2023 data. Would like to try to implement with same logic already uses in read_sql_query_acs function in utils. But would require some changes because checks for "ACS 5-Year Table does not exist" message returned from other queries.

Describe alternatives you've considered

Create similar function to read_sql_query_acs if don't want to mess with it

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions