Update Google Docs Meta Data

[github-actions]

Updating Google Docs Meta Data

• (followup to Update Google Docs Meta Data #1671)

TL;DR:

• removed defunct and erroneously copypasta'd anosmia/agusia signals from beta_google_symptoms
• added "BETA" to the provider names in db_sources sheet
• (not seen/reflected here) added new "BETA" signal sets to signal sets sheet
• changed signal set membership of beta_* signals to the new BETA sets

TODO: the sheet still needs the addition of the various permutations of the *_fa and *_fz signals, but im not sure the status of those is settled yet.

[sonarqubecloud]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud

[melange396]

output from comparison code at #1612 (comment) :

added columns: []
removed columns: []
# rows in dev file: 517
# rows in new file: 511
row count difference: -6
added signals: []
removed signals: [('beta_google_symptoms', 'ageusia_raw_search'), ('beta_google_symptoms', 'ageusia_smoothed_search'), ('beta_google_symptoms', 'anosmia_raw_search'), ('beta_google_symptoms', 'anosmia_smoothed_search'), ('beta_google_symptoms', 'sum_anosmia_ageusia_raw_search'), ('beta_google_symptoms', 'sum_anosmia_ageusia_smoothed_search')]



MISMATCH!!  [ beta_google_symptoms : s01_raw_search ]  dev row: 494 / new row: 488
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s01_smoothed_search ]  dev row: 495 / new row: 489
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s02_raw_search ]  dev row: 496 / new row: 490
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s02_smoothed_search ]  dev row: 497 / new row: 491
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s03_raw_search ]  dev row: 498 / new row: 492
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s03_smoothed_search ]  dev row: 499 / new row: 493
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s04_raw_search ]  dev row: 500 / new row: 494
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s04_smoothed_search ]  dev row: 501 / new row: 495
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s05_raw_search ]  dev row: 502 / new row: 496
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s05_smoothed_search ]  dev row: 503 / new row: 497
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s06_raw_search ]  dev row: 504 / new row: 498
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s06_smoothed_search ]  dev row: 505 / new row: 499
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s07_raw_search ]  dev row: 506 / new row: 500
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : s07_smoothed_search ]  dev row: 507 / new row: 501
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : scontrol_raw_search ]  dev row: 508 / new row: 502
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_google_symptoms : scontrol_smoothed_search ]  dev row: 509 / new row: 503
  Indicator Set:
    Google Symptoms Searches
    -->
    BETA Google Symptoms Searches

MISMATCH!!  [ beta_nssp : pct_ed_visits_covid ]  dev row: 510 / new row: 504
  Indicator Set:
    NSSP COVID-19 Emergency Department Visits
    -->
    BETA NSSP COVID-19 Emergency Department Visits

MISMATCH!!  [ beta_nssp : pct_ed_visits_influenza ]  dev row: 511 / new row: 505
  Indicator Set:
    NSSP Influenza Emergency Department Visits
    -->
    BETA NSSP Influenza Emergency Department Visits

MISMATCH!!  [ beta_nssp : pct_ed_visits_rsv ]  dev row: 512 / new row: 506
  Indicator Set:
    NSSP RSV Emergency Department Visits
    -->
    BETA NSSP RSV Emergency Department Visits

MISMATCH!!  [ beta_nssp : pct_ed_visits_combined ]  dev row: 513 / new row: 507
  Indicator Set:
    NSSP Emergency Department Visits for COVID-19, Influenza, and RSV Combined
    -->
    BETA NSSP Emergency Department Visits for COVID-19, Influenza, and RSV Combined

MISMATCH!!  [ beta_nssp : smoothed_pct_ed_visits_covid ]  dev row: 514 / new row: 508
  Indicator Set:
    NSSP COVID-19 Emergency Department Visits
    -->
    BETA NSSP COVID-19 Emergency Department Visits

MISMATCH!!  [ beta_nssp : smoothed_pct_ed_visits_influenza ]  dev row: 515 / new row: 509
  Indicator Set:
    NSSP Influenza Emergency Department Visits
    -->
    BETA NSSP Influenza Emergency Department Visits

MISMATCH!!  [ beta_nssp : smoothed_pct_ed_visits_rsv ]  dev row: 516 / new row: 510
  Indicator Set:
    NSSP RSV Emergency Department Visits
    -->
    BETA NSSP RSV Emergency Department Visits

MISMATCH!!  [ beta_nssp : smoothed_pct_ed_visits_combined ]  dev row: 517 / new row: 511
  Indicator Set:
    NSSP Emergency Department Visits for COVID-19, Influenza, and RSV Combined
    -->
    BETA NSSP Emergency Department Visits for COVID-19, Influenza, and RSV Combined


lines with changes: 24