Last active
July 3, 2026 06:41
-
-
Save flodolo/c2d86dd415ef78de163a750502896adc to your computer and use it in GitHub Desktop.
Backfill CHS data
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| Backfill Community Health Score (CHS) history into Pontoon's | |
| LocaleHealthSnapshot table from the spreadsheet data extracted by | |
| extract_chs_backfill.py. | |
| Scores and the final CHS are RECOMPUTED here from the raw inputs using the live | |
| pontoon.insights.chs.compute_chs, so stored values stay consistent with the | |
| current formula (rather than copying the sheet's precomputed totals). The sheet | |
| total is used only to print a verification diff. | |
| Existing (locale, created_at) snapshots are never overwritten: the script only | |
| inserts missing rows, so it is safe to re-run. | |
| How to run: | |
| 1. Run extract_chs_backfill.py locally to produce chs_backfill.json. | |
| 2. Open a Django shell, e.g.: | |
| heroku run --app mozilla-pontoon ./manage.py shell | |
| 3. Paste the contents of chs_backfill.json between the triple quotes of | |
| CHS_JSON below, then paste this whole script into the shell. | |
| """ | |
| # --------------------------------------------------------------------------- | |
| # Paste the contents of chs_backfill.json between the triple quotes below. | |
| # --------------------------------------------------------------------------- | |
| CHS_JSON = r""" | |
| [ | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "ar", | |
| "completion": 71.67, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 54.29 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "cs", | |
| "completion": 99.5, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.8 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "de", | |
| "completion": 99.91, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "el", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "es-AR", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "es-CL", | |
| "completion": 99.72, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.33 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "es-ES", | |
| "completion": 99.12, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.1 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "es-MX", | |
| "completion": 93.25, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 4, | |
| "all_contributors": 5, | |
| "new_signups": 5, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 96.9 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "fi", | |
| "completion": 97.04, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.6 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "fr", | |
| "completion": 99.78, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "hu", | |
| "completion": 99.96, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "id", | |
| "completion": 92.45, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "ja", | |
| "completion": 93.77, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.6 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "nl", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "pl", | |
| "completion": 98.29, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.56 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "pt-BR", | |
| "completion": 99.45, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.2 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "pt-PT", | |
| "completion": 98.92, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 84.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "ro", | |
| "completion": 59.94, | |
| "active_managers": 0, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 34.46 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "ru", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "sk", | |
| "completion": 99.94, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "tr", | |
| "completion": 99.63, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.3 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "vi", | |
| "completion": 98.71, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 62.83 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "zh-CN", | |
| "completion": 99.96, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-07-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "ar", | |
| "completion": 70.69, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 53.79 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "cs", | |
| "completion": 98.92, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.5 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "de", | |
| "completion": 99.36, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.2 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "el", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "es-AR", | |
| "completion": 99.94, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "es-CL", | |
| "completion": 99.51, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.23 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "es-ES", | |
| "completion": 98.05, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.6 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "es-MX", | |
| "completion": 91.45, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 4, | |
| "all_contributors": 5, | |
| "new_signups": 5, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 96.1 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "fi", | |
| "completion": 95.61, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "fr", | |
| "completion": 99.9, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "hu", | |
| "completion": 99.86, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.9 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "id", | |
| "completion": 90.95, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 80.8 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "it", | |
| "completion": 99.97, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "ja", | |
| "completion": 93.83, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.7 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "nl", | |
| "completion": 99.85, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "pl", | |
| "completion": 97.72, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.36 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "pt-BR", | |
| "completion": 98.5, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.8 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "pt-PT", | |
| "completion": 97.35, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 83.8 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "ro", | |
| "completion": 87.05, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 72.86 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "ru", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 80 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "sk", | |
| "completion": 99.77, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.4 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "tr", | |
| "completion": 99.59, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.3 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "vi", | |
| "completion": 98.46, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 62.73 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "zh-CN", | |
| "completion": 99.86, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2025-08-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "ar", | |
| "completion": 69.75, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 53.39 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "cs", | |
| "completion": 99.39, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.7 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "de", | |
| "completion": 99.85, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.9 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "el", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "es-AR", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "es-CL", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "es-ES", | |
| "completion": 96.72, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "es-MX", | |
| "completion": 89.74, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 4, | |
| "all_contributors": 5, | |
| "new_signups": 5, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 87.8 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "fi", | |
| "completion": 95.83, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.1 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "fr", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.5 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "hu", | |
| "completion": 99.51, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.8 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "id", | |
| "completion": 91.28, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "ja", | |
| "completion": 93.39, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.5 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "nl", | |
| "completion": 99.87, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "pl", | |
| "completion": 98.01, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.46 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "pt-BR", | |
| "completion": 98.58, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.8 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "pt-PT", | |
| "completion": 95.53, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.9 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "ro", | |
| "completion": 93.08, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 75.66 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "ru", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "sk", | |
| "completion": 100, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.5 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "tr", | |
| "completion": 99.5, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.3 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "vi", | |
| "completion": 98.67, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 60.83 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "zh-CN", | |
| "completion": 99.84, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2025-09-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "ar", | |
| "completion": 68.88, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 52.99 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "cs", | |
| "completion": 99.82, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 71.9 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "de", | |
| "completion": 99.97, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 86.5 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "el", | |
| "completion": 99.72, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "es-AR", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "es-CL", | |
| "completion": 99.93, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "es-ES", | |
| "completion": 98.39, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.8 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "es-MX", | |
| "completion": 89.91, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 4, | |
| "all_contributors": 5, | |
| "new_signups": 5, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 87.9 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "fi", | |
| "completion": 96.68, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.5 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "fr", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.5 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "hu", | |
| "completion": 98.72, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.4 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "id", | |
| "completion": 91.91, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.3 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "it", | |
| "completion": 99.99, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "ja", | |
| "completion": 93.86, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.7 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "nl", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "pl", | |
| "completion": 98.03, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.46 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "pt-BR", | |
| "completion": 98.28, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.2 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "pt-PT", | |
| "completion": 95.55, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 83 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "ro", | |
| "completion": 93.98, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 3, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 76.06 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "ru", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "sk", | |
| "completion": 99.64, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.3 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "sv-SE", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "tr", | |
| "completion": 99.28, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.2 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "vi", | |
| "completion": 98.7, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 60.83 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "zh-CN", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-10-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "ar", | |
| "completion": 68.06, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 3, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 52.59 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "cs", | |
| "completion": 99.78, | |
| "active_managers": 2, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.9 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "de", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 89.5 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "el", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "es-AR", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "es-CL", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "es-ES", | |
| "completion": 98.63, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 5, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.9 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "es-MX", | |
| "completion": 91.39, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 5, | |
| "all_contributors": 5, | |
| "new_signups": 3, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 96 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "fi", | |
| "completion": 96.14, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.2 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "fr", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.5 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "hu", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "id", | |
| "completion": 91.48, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.1 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "ja", | |
| "completion": 94.27, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.9 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "nl", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "pl", | |
| "completion": 97.24, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.06 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "pt-BR", | |
| "completion": 98.43, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.8 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "pt-PT", | |
| "completion": 94.23, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.3 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "ro", | |
| "completion": 95.19, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 76.66 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "ru", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "sk", | |
| "completion": 100, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.5 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "tr", | |
| "completion": 99.26, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.2 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "vi", | |
| "completion": 98.67, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 58.33 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "zh-CN", | |
| "completion": 99.66, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.3 | |
| }, | |
| { | |
| "created_at": "2025-11-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "ar", | |
| "completion": 67.78, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 44.99 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "cs", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "de", | |
| "completion": 99.97, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 89.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "el", | |
| "completion": 99.93, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "es-AR", | |
| "completion": 99.96, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 71.93 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "es-CL", | |
| "completion": 99.58, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.23 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "es-ES", | |
| "completion": 99.19, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 5, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.1 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "es-MX", | |
| "completion": 90.62, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 4, | |
| "all_contributors": 4, | |
| "new_signups": 3, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 95.7 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "fi", | |
| "completion": 97.1, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.7 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "fr", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "hu", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "id", | |
| "completion": 91.16, | |
| "active_managers": 3, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 73.4 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "ja", | |
| "completion": 94.49, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "nl", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "pl", | |
| "completion": 99.36, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 91.06 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "pt-BR", | |
| "completion": 98.5, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.8 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "pt-PT", | |
| "completion": 93.44, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "ro", | |
| "completion": 97.94, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 74.96 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "ru", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "sk", | |
| "completion": 100, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "tr", | |
| "completion": 99.28, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.2 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "vi", | |
| "completion": 98.79, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.33 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "zh-CN", | |
| "completion": 99.92, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2025-12-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "ar", | |
| "completion": 66.89, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 44.59 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "cs", | |
| "completion": 99.82, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.4 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "de", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 89.5 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "el", | |
| "completion": 99.81, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "es-AR", | |
| "completion": 99.91, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 71.93 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "es-CL", | |
| "completion": 99.93, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "es-ES", | |
| "completion": 98.22, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.7 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "es-MX", | |
| "completion": 89.61, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 4, | |
| "all_contributors": 4, | |
| "new_signups": 3, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 95.2 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "fi", | |
| "completion": 96.21, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.3 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "fr", | |
| "completion": 99.77, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.4 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "hu", | |
| "completion": 99.29, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.7 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "id", | |
| "completion": 90.56, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.2 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "ja", | |
| "completion": 93.66, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.6 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "nl", | |
| "completion": 99.77, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "pl", | |
| "completion": 98.36, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.56 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "pt-BR", | |
| "completion": 98.5, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.8 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "pt-PT", | |
| "completion": 93.73, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.1 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "ro", | |
| "completion": 99.64, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 95.66 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "ru", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 80 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "sk", | |
| "completion": 100, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.5 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "tr", | |
| "completion": 99.27, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.2 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "vi", | |
| "completion": 98.65, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.33 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "zh-CN", | |
| "completion": 99.83, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-01-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "ar", | |
| "completion": 66.22, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 44.29 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "cs", | |
| "completion": 99.41, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.2 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "de", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 89.5 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "el", | |
| "completion": 99.39, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.2 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "es-AR", | |
| "completion": 99.91, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 71.93 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "es-CL", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "es-ES", | |
| "completion": 98.43, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.8 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "es-MX", | |
| "completion": 88.8, | |
| "active_managers": 0, | |
| "active_translators": 3, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.8 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "fi", | |
| "completion": 96.1, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.2 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "fr", | |
| "completion": 99.91, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.5 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "hu", | |
| "completion": 99.59, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.8 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "id", | |
| "completion": 89.8, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.8 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "ja", | |
| "completion": 93.65, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.6 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "nl", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "pl", | |
| "completion": 98.54, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.66 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "pt-BR", | |
| "completion": 98.41, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.3 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "pt-PT", | |
| "completion": 93.87, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.2 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "ro", | |
| "completion": 99.66, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 95.66 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "ru", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 80 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "sk", | |
| "completion": 99.77, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.4 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "tr", | |
| "completion": 99.36, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.2 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "vi", | |
| "completion": 98.51, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.23 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "zh-CN", | |
| "completion": 99.58, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.3 | |
| }, | |
| { | |
| "created_at": "2026-02-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "ar", | |
| "completion": 70.0, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 51.49 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "cs", | |
| "completion": 99.26, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.2 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "de", | |
| "completion": 99.98, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 89.5 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "el", | |
| "completion": 99.73, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "es-AR", | |
| "completion": 99.42, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.13 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "es-CL", | |
| "completion": 99.3, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.13 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "es-ES", | |
| "completion": 98.61, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.4 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "es-MX", | |
| "completion": 92.21, | |
| "active_managers": 0, | |
| "active_translators": 3, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 71.4 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "fi", | |
| "completion": 95.59, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "fr", | |
| "completion": 99.87, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.4 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "hu", | |
| "completion": 99.43, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.7 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "id", | |
| "completion": 88.47, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.2 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "ja", | |
| "completion": 92.99, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.3 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "nl", | |
| "completion": 99.9, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "pl", | |
| "completion": 98.41, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.66 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "pt-BR", | |
| "completion": 97.83, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "pt-PT", | |
| "completion": 93.43, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "ro", | |
| "completion": 98.99, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 95.36 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "ru", | |
| "completion": 99.89, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.9 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "sk", | |
| "completion": 99.6, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.3 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "tr", | |
| "completion": 98.97, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "vi", | |
| "completion": 98.65, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.33 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "zh-CN", | |
| "completion": 99.1, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.1 | |
| }, | |
| { | |
| "created_at": "2026-03-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "ar", | |
| "completion": 69.26, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 1, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 51.19 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "cs", | |
| "completion": 99.72, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.4 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "de", | |
| "completion": 99.99, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 87.5 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "el", | |
| "completion": 99.79, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "es-AR", | |
| "completion": 99.89, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.33 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "es-CL", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.43 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "es-ES", | |
| "completion": 98.19, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 4, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.2 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "es-MX", | |
| "completion": 91.41, | |
| "active_managers": 0, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 3, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 65 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "fi", | |
| "completion": 95.52, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 67.9 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "fr", | |
| "completion": 99.83, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.9 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "hu", | |
| "completion": 99.99, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "id", | |
| "completion": 87.53, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.8 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "ja", | |
| "completion": 92.87, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.2 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "nl", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "pl", | |
| "completion": 98.38, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.66 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "pt-BR", | |
| "completion": 98.0, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.1 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "pt-PT", | |
| "completion": 93.85, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 3, | |
| "all_contributors": 3, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.2 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "ro", | |
| "completion": 98.84, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 95.36 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "ru", | |
| "completion": 99.95, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 80 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "sk", | |
| "completion": 99.16, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.1 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "tr", | |
| "completion": 98.87, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "vi", | |
| "completion": 98.45, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.23 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "zh-CN", | |
| "completion": 98.25, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.7 | |
| }, | |
| { | |
| "created_at": "2026-04-01", | |
| "locale": "zh-TW", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "ar", | |
| "completion": 76.21, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 56.89 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "cs", | |
| "completion": 99.07, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.1 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "de", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 87.5 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "el", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "es-AR", | |
| "completion": 99.42, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.13 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "es-CL", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 71.93 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "es-ES", | |
| "completion": 96.33, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.3 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "es-MX", | |
| "completion": 93.18, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.9 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "fi", | |
| "completion": 95.04, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 67.7 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "fr", | |
| "completion": 99.94, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "hu", | |
| "completion": 99.7, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 71.9 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "id", | |
| "completion": 85.15, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 67.2 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "ja", | |
| "completion": 91.44, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.6 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "nl", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.5 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "pl", | |
| "completion": 96.71, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 3, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 84.86 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "pt-BR", | |
| "completion": 96.2, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.3 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "pt-PT", | |
| "completion": 96.28, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 68.3 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "ro", | |
| "completion": 97.32, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 1, | |
| "all_contributors": 3, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 94.66 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "ru", | |
| "completion": 99.98, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "sk", | |
| "completion": 99.69, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.4 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "tr", | |
| "completion": 98.72, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 81.9 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "vi", | |
| "completion": 98.33, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.13 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "zh-CN", | |
| "completion": 98.42, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.8 | |
| }, | |
| { | |
| "created_at": "2026-05-01", | |
| "locale": "zh-TW", | |
| "completion": 99.96, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "ar", | |
| "completion": 76.14, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 56.79 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "cs", | |
| "completion": 99.99, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.5 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "de", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 87.5 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "el", | |
| "completion": 99.87, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "es-AR", | |
| "completion": 99.84, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 69.33 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "es-CL", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 71.93 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "es-ES", | |
| "completion": 98.02, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.1 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "es-MX", | |
| "completion": 95.81, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 83.1 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "fi", | |
| "completion": 95.24, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 67.8 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "fr", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "hu", | |
| "completion": 99.73, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.9 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "id", | |
| "completion": 84.33, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 66.8 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "ja", | |
| "completion": 92.09, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.9 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "nl", | |
| "completion": 99.71, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "pl", | |
| "completion": 97.57, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 85.26 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "pt-BR", | |
| "completion": 96.67, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.5 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "pt-PT", | |
| "completion": 94.47, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 67.5 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "ro", | |
| "completion": 99.57, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 4, | |
| "new_signups": 3, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 88.16 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "ru", | |
| "completion": 99.8, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.9 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "sk", | |
| "completion": 99.34, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57.2 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "sv-SE", | |
| "completion": 100, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "tr", | |
| "completion": 98.95, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79.5 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "vi", | |
| "completion": 98.82, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.43 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "zh-CN", | |
| "completion": 99.5, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.3 | |
| }, | |
| { | |
| "created_at": "2026-06-01", | |
| "locale": "zh-TW", | |
| "completion": 99.97, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 70 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "ar", | |
| "completion": 75.13, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 2, | |
| "enabled_projects_score": 2.29, | |
| "sheet_chs": 56.39 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "cs", | |
| "completion": 98.5, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 78.8 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "de", | |
| "completion": 99.67, | |
| "active_managers": 2, | |
| "active_translators": 1, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 87.3 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "el", | |
| "completion": 99.72, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77.4 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "es-AR", | |
| "completion": 98.84, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 68.93 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "es-CL", | |
| "completion": 98.91, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 71.43 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "es-ES", | |
| "completion": 96.45, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.4 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "es-MX", | |
| "completion": 95.31, | |
| "active_managers": 1, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 82.8 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "fi", | |
| "completion": 94.31, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 67.4 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "fr", | |
| "completion": 99.85, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.9 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "hu", | |
| "completion": 98.93, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.5 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "id", | |
| "completion": 82.62, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 66 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "it", | |
| "completion": 100, | |
| "active_managers": 2, | |
| "active_translators": 2, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 85 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "ja", | |
| "completion": 91.95, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.8 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "nl", | |
| "completion": 98.97, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 77 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "pl", | |
| "completion": 96.61, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 84.76 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "pt-BR", | |
| "completion": 96.28, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 1, | |
| "new_signups": 2, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 75.3 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "pt-PT", | |
| "completion": 93.25, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 1, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.4 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "ro", | |
| "completion": 98.56, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 2, | |
| "all_contributors": 4, | |
| "new_signups": 3, | |
| "enabled_projects_score": 2.86, | |
| "sheet_chs": 90.66 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "ru", | |
| "completion": 99.53, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.8 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "sk", | |
| "completion": 98.97, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 57 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "sv-SE", | |
| "completion": 98.8, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 1, | |
| "all_contributors": 1, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 74.4 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "tr", | |
| "completion": 97.92, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 2, | |
| "all_contributors": 2, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 79 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "vi", | |
| "completion": 97.94, | |
| "active_managers": 0, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 3.43, | |
| "sheet_chs": 56.03 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "zh-CN", | |
| "completion": 98.52, | |
| "active_managers": 1, | |
| "active_translators": 1, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 76.8 | |
| }, | |
| { | |
| "created_at": "2026-07-01", | |
| "locale": "zh-TW", | |
| "completion": 99.06, | |
| "active_managers": 1, | |
| "active_translators": 0, | |
| "active_contributors": 0, | |
| "all_contributors": 0, | |
| "new_signups": 0, | |
| "enabled_projects_score": 4, | |
| "sheet_chs": 69.6 | |
| } | |
| ] | |
| """ | |
| import django | |
| import os | |
| os.environ.setdefault("DJANGO_SETTINGS_MODULE", "pontoon.settings") | |
| django.setup() | |
| import json | |
| from datetime import date | |
| from django.conf import settings | |
| from pontoon.base.models import Locale | |
| from pontoon.insights.chs import KEY_PROJECT_SLUGS, compute_chs | |
| from pontoon.insights.models import LocaleHealthSnapshot | |
| data = json.loads(CHS_JSON) | |
| # Resolve locale codes to objects up front; report any unknown codes. | |
| codes = {row["locale"] for row in data} | |
| locales_by_code = {loc.code: loc for loc in Locale.objects.filter(code__in=codes)} | |
| missing_codes = sorted(codes - set(locales_by_code)) | |
| # Existing (locale_id, created_at) pairs to skip. | |
| dates = sorted({date.fromisoformat(row["created_at"]) for row in data}) | |
| existing = set( | |
| LocaleHealthSnapshot.objects.filter(created_at__in=dates).values_list( | |
| "locale_id", "created_at" | |
| ) | |
| ) | |
| snapshots = [] | |
| skipped_existing = 0 | |
| skipped_no_locale = 0 | |
| max_diff = 0.0 | |
| max_diff_row = None | |
| for row in data: | |
| locale = locales_by_code.get(row["locale"]) | |
| if locale is None: | |
| skipped_no_locale += 1 | |
| continue | |
| created_at = date.fromisoformat(row["created_at"]) | |
| if (locale.pk, created_at) in existing: | |
| skipped_existing += 1 | |
| continue | |
| # Back-compute the raw enabled-projects count from its weighted score, | |
| # using the live settings (mirrors get_key_projects_enabled_by_locale). | |
| key_projects_enabled = round( | |
| row["enabled_projects_score"] | |
| / settings.ENABLED_PROJECT_POINTS | |
| * len(KEY_PROJECT_SLUGS) | |
| ) | |
| args = { | |
| "completion": row["completion"], | |
| "key_projects_enabled": key_projects_enabled, | |
| "active_managers": row["active_managers"], | |
| "active_translators": row["active_translators"], | |
| "active_contributors": row["active_contributors"], | |
| "all_contributors": row["all_contributors"], | |
| "new_signups": row["new_signups"], | |
| } | |
| chs_fields = compute_chs(args) | |
| diff = abs(float(chs_fields["chs"]) - float(row["sheet_chs"])) | |
| if diff > max_diff: | |
| max_diff = diff | |
| max_diff_row = (row["created_at"], row["locale"], chs_fields["chs"], row["sheet_chs"]) | |
| snapshots.append( | |
| LocaleHealthSnapshot(locale=locale, created_at=created_at, **args, **chs_fields) | |
| ) | |
| LocaleHealthSnapshot.objects.bulk_create(snapshots, ignore_conflicts=True) | |
| print(f"Created: {len(snapshots)}") | |
| print(f"Skipped (existing): {skipped_existing}") | |
| print(f"Skipped (no locale):{skipped_no_locale}") | |
| if missing_codes: | |
| print(f"Unknown locale codes: {', '.join(missing_codes)}") | |
| print(f"Max CHS diff vs sheet: {round(max_diff, 3)} at {max_diff_row}") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment