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

patch google symptom early 2017-08-15 - 2020-02-19 #2107

Open
aysim319 opened this issue Jan 22, 2025 · 1 comment
Open

patch google symptom early 2017-08-15 - 2020-02-19 #2107

aysim319 opened this issue Jan 22, 2025 · 1 comment
Assignees
Labels
data quality Missing data, weird data, broken data
Milestone

Comments

@aysim319
Copy link
Contributor

aysim319 commented Jan 22, 2025

In the API, we only have them starting Feb 2020, but Google added earlier dates at some point starting from mid 2017

@aysim319 aysim319 added the data quality Missing data, weird data, broken data label Jan 22, 2025
@aysim319 aysim319 added this to the Data patching milestone Jan 22, 2025
@aysim319 aysim319 self-assigned this Jan 22, 2025
@aysim319 aysim319 changed the title patch google symptom early 2018 - 2020-02-19 patch google symptom early 2017-08-15 - 2020-02-19 Jan 24, 2025
@aysim319
Copy link
Contributor Author

county level

    select
        min(date),
       max(date)
    from `bigquery-public-data.covid19_symptom_search.symptom_search_sub_region_2_daily`
    where 
    timestamp(date) between timestamp("2017-01-01") and timestamp("2018-01-01") and
        country_region_code = "US"

state level

    select
        min(date),
       max(date)
    from `bigquery-public-data.covid19_symptom_search.symptom_search_sub_region_1_daily`
    where 
    timestamp(date) between timestamp("2017-01-01") and timestamp("2018-01-01") and
        country_region_code = "US"

returned [2017-08-15,2025-01-12]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data quality Missing data, weird data, broken data
Projects
None yet
Development

No branches or pull requests

1 participant