search

starschema / COVID-19-data

Unpivoted and cleaned data sets on the COVID-19 pandemic
https://starschema.github.io/COVID-19-data
BSD 3-Clause "New" or "Revised" License
85 stars 19 forks source link

Data quality issue: `CT_US_COVID_TESTS` #351

Closed joelash closed 3 years ago

joelash commented 3 years ago

Describe the bug In CT_US_COVID_TESTS, no new data since March 7, 2021

Describe the expected result CT_US_COVID_TESTS should have recent data

Verification DATE should be recent.

SELECT *
FROM COVID19_STAR.PUBLIC.CT_US_COVID_TESTS
ORDER BY DATE desc;
tfoldi commented 3 years ago

hi Joelash, the issue was fixed in the meantime - it should be replicated within 60 minutes to all snowflake region.

joelash commented 3 years ago

Thanks @tfoldi, I still don't see this correct in our database. Is there anything I need to do on my side?

chrisvoncsefalvay commented 3 years ago

Hi @joelash – the table you're looking at is the Covid Tracking Project's data set. As noted here, this table is no longer updated because the source data set is no longer updated (see also this). You may find the data points you need in other tables, however. Please feel free to let me know if there's anything else I can assist you with!

joelash commented 3 years ago

Thanks @chrisvoncsefalvay, I sort of assumed that but couldn't find info about it.