User Details
- User Since
- Jan 4 2022, 7:07 PM (32 w, 2 d)
- Availability
- Available
- LDAP User
- Unknown
- MediaWiki User
- NMaphophe (WMF) [ Global Accounts ]
Tue, Aug 2
Tue, Jul 26
Mon, Jul 25
Jul 11 2022
Update world bank series pulled from:
Jul 8 2022
Note to remember to format number on the grants csv and make sure that the data never overlaps between lines when the spreadsheet is updated.
Jun 22 2022
Got PySpark to work with Airflow
Jun 15 2022
Data currently loaded on
Loaded data onto
Loaded data onto:
Lua table is not to be used at the moment, use the csv for now
Added table:
Country data loaded on
SELECT * FROM ntsako.country_meta_data }
Jun 7 2022
Affiliate leadership data loaded on
SELECT * FROM ntsako.affiliate_leadership WHERE year = 2021
lua data loaded on
SELECT * FROM ntsako.organizational_info WHERE year = 2021;
Jun 6 2022
Jun 1 2022
May 31 2022
Overall Engagement (Percentile) and Total Population Presence*Growth Percentile depend on Affilate and Overall Engagement being completed
May 27 2022
Data loaded onto:
May 26 2022
CSV loaded onto:
SELECT * FROM programs_data
Loaded input metrics on:
Data loaded on
SELECT * FROM ntsako.world_bank_data
Data loaded on
SELECT * FROM ntsako.wiki_db_map
Loaded updated grants csv on:
Editorship input metrics created and stored in:
SELECT * FROM ntsako.georeadership_metrics WHERE year=2021
Readership metric created for sample on ntsako.georeadership_metrics
May 24 2022
Raw grants data loaded under
ntsako.grants
May 17 2022
Created database on hive.