Egypt at a glance.← DashboardMethodology / Sources
Sources, refresh schedules, calculations, and the limits of a small public dashboard.
Refresh architecture
Scheduled GitHub Actions fetch external data, write JSON into the repository, and commit only when the staged file changes. That commit triggers a Cloudflare Pages rebuild. API keys remain in GitHub Actions secrets and never reach the browser bundle.
Source register
“Updated” stamps reflect the fetched_at field committed with each JSON dataset. A Pages rebuild preserves that timestamp.
sources/Exchange Rates Historical.xlsx → data/dashboard.jsonA scheduled session submits the official historical-data form for US dollar observations. The dashboard uses the published selling rate and compares it with the preceding observation.
Central Bank of Egyptsources/EGX*.csv → data/dashboard.jsonA scheduled fetch downloads delayed historical index data after the market closes, with a separate latest-close fallback. Changes are versus the previous close.
Egyptian Exchangedata/air-quality.jsonAQI category bands follow the US AQI scale. PM2.5 and the dominant pollutant are passed through from the reporting station.
World Air Quality Index projectdata/prayer-times.jsonCairo timings use calculation method 5, the Egyptian General Authority of Survey.
AlAdhandata/gold-price.jsonThe XAU/EGP quote is converted from one troy ounce to grams. The 21K figure is 87.5% of the resulting 24K per-gram price.
GoldAPIdata/earthquakes.jsonThe query covers the prior 30 days inside 22–32°N and 25–35°E, spanning Egypt, Sinai, and the nearby Red Sea.
US Geological Surveydata/public-holiday.jsonThe first item returned by the Egypt next-holiday endpoint is displayed.
Nager.Datesources/CPI- Monthly_.xls → data/dashboard.jsonThe consolidated workbook is downloaded from its official media URL. All-items observations are chained across published base-year changes. See Adjustments below.
Central Bank of Egyptdata/public-services.jsondata/public-services.jsondata/public-services.jsonCurrent and previous tariff links are discovered from the official navigation, then residential brackets are parsed in Egyptian piasters per kWh.
EgyptERAdata/public-services.jsonDistinct archived captures provide unemployment, external debt by maturities, and population readings.
Ministry of Planning and Economic Development via the Wayback Machinedata/world-bank.json → data/dashboard.jsonPopulation, GDP per capita, life expectancy, internet use, urban population, CO₂ emissions, and modelled unemployment are retrieved from the World Bank API.
World Bank DataBrowser onlyThis keyless masthead utility is currently requested directly by the browser and is not a dashboard data card.
Open-MeteoBrowser onlyAdjustments
Monthly all-items observations are ordered and de-duplicated across fiscal-year sheets. Adjacent ratios between 0.75 and 1.25 are chained onto a continuous index starting at 100. A larger discontinuity is treated as a base-year reset and continuity is preserved for that month. Annual inflation compares the latest chained observation with the same month one year earlier.
The XAU/EGP spot quote is divided by 31.1034768 grams per troy ounce. The 21K estimate multiplies that 24K per-gram value by 0.875. It is a metal-value reference, not a retail quote, and excludes fabrication charges, dealer spreads, and taxes.
EGX percentage changes compare the latest index close with the preceding close. USD/EGP compares the latest published selling-rate observation with the preceding observation. Color is supplementary; every change also includes a plus or minus sign and a written comparison window.
The November 2016 EGP flotation and March 2020 COVID-19 onset markers are static contextual annotations. They do not alter World Bank observations or imply that either event alone caused a series movement.
Reading the data