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

Add additional fields to support NTIA, and to simplify M-Lab DataStudio report queries #71

Open
critzo opened this issue Sep 9, 2021 · 1 comment

Comments

@critzo
Copy link

critzo commented Sep 9, 2021

NTIA currently uses a custom query to extract data when they could be querying stats-pipeline output tables instead.

Needed to support NTIA:

  • US State/Territory FIPS Code
  • Q10 down & up
  • Q90 down & up
critzo pushed a commit that referenced this issue Oct 4, 2021
@critzo
Copy link
Author

critzo commented Jan 20, 2022

Updated list of fields requested and/or needed for internal use:

  • For US Counties:
    • county_geoid
    • county_name
    • state_name
    • download_Q10
    • download_Q90
    • upload_Q10
    • upload_Q90
    • rttVar_min (Jitter)
    • rttVar_Q10
    • rttVar_Q25
    • rttVar_MED
    • rttVar_Q75
    • rttVar_Q90
    • rttVar_MAX
    • rttVar_LOG_AVG
    • rtt_MIN
    • rtt_Q10
    • rtt_Q25
    • rtt_MED
    • rtt_Q75
    • rtt_Q90
    • rtt_MAX
    • rtt_LOG_AVG
    • num_ASNs_day
    • num_ASNs_bucket
    • num_IPs_day
    • num_IPs_bucket
  • For US States:
    • state_geoid
    • state_name
    • additional metrics listed above
  • For all other queries:
    • additional metrics listed above
    • ASName (where applicable)
    • CountryName (where applicable)
    • Subdivision1Name

@critzo critzo changed the title Add FIPS code and additional quartiles (Q10, Q90) to support data NTIA Add additional fields to support NTIA, and to simplify M-Lab DataStudio report queries Jan 20, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant