Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[bug] Duplicate entries in baseline cog table #4459

Open
Tracked by #4402
danswick opened this issue Nov 14, 2024 · 0 comments
Open
Tracked by #4402

[bug] Duplicate entries in baseline cog table #4459

danswick opened this issue Nov 14, 2024 · 0 comments
Labels
bug Something isn't working data

Comments

@danswick
Copy link
Contributor

danswick commented Nov 14, 2024

While researching some issues with Cognizant / Oversight assignment, @gsa-suk discovered that a lot of historical Census records are duplicated in the baseline table. Some appear to be "real" and others possibly the result of some internal testing that got overlooked. For example:

report_ID source date_added
001 Census 2023-10-11
002 CENSUS 2021-03-04

In the example above, it appears that all entries with source=Census (initial cap) have the same date of 2023-10-11, suggesting they were all created or at least updated at the same time as part of some batch operation. Entries with source=CENSUS (all cap) appear to have unique dates.

As far as we can tell, this doesn't impact functionality, but it is confusing and could cause problems in the future if the cog assignment and calculation logic changes.

@danswick danswick added bug Something isn't working data labels Nov 14, 2024
@github-project-automation github-project-automation bot moved this to Triage in FAC Nov 14, 2024
@danswick danswick changed the title Duplicate entries in baseline table [bug] Duplicate entries in baseline cog table Nov 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working data
Projects
Status: Triage
Development

No branches or pull requests

1 participant