Page MenuHomePhabricator

Grants Metrics Transformation
Open, Needs TriagePublic

Description

SQL / Python code to transform input data in to Output Rank Metrics

Input MetricsOutput Rank Metrics
Historical Grants 2010 to current USD ($), Total Grants Calendar Year 2021 USD ($), Historical Grants 2010-2021 Count, Annual Grants presence weighted by PPP (Current international $) (Percentile), Historical Grants presence weighted by PPP (2017 constant international $) (Percentile), Historical Grants 2010-2021 Count (Percentile)Grants Presence
Five Year Grants ChangeGrants Growth
Annual Grants (PPP Weighted )* (5-year growth/5), Historical Grants (PPP weighted ) * (5-year growth/5), Historical Grants 2010-2021 Count (Percentile), Annual Grants 2021 Count (Percentile)Grants Leadership

Event Timeline

Raw grants data loaded under

ntsako.grants

initial roll-up at

kcv.grants_output_rank_metrics

pending:

  • 3-letter to 2-letter country codes
  • not having all countries causes issues with percent rank