Pipedream Policy Brief — The Philippines Has 45 Days of Fuel Left

# Pipedream Policy Brief > Interactive policy dashboard for the Philippine energy crisis. Presented > to the UPLIFT Committee, the Department of Energy, and the Department of > Finance. Open source under AGPL v3. ## What this is A single-page Next.js 16 application that consolidates real-time market data, policy framework, infrastructure mapping, and legislative tracking into a single decision-support tool for Philippine energy policymakers. ## Data freshness tiers - Live (Every 5–10 min) — Market data and news polled continuously from public APIs. Refreshes while you read. - Daily (Every 24h · 06:00 PHT) — Factual snapshots refreshed once per day via scheduled scrape + agent synthesis. - Weekly (Every Monday · 06:00 PHT) — Institutional reports and legislative statuses refreshed weekly. - Published (Versioned manually) — Fundamentals — analytical frameworks that don't change with today's news. Versioned via commits. ## Data sources - Yahoo Finance — Brent Crude (BZ=F) (live, polled every 10 min) — Brent crude spot price (USD/bbl) - Frankfurter / ECB (live, polled every 10 min) — USD/PHP foreign exchange rate - Google News + Al Jazeera + r/Philippines RSS (live, polled every 5 min) — Energy and policy news headlines - DOE Oil Industry Monitor (daily, scraped daily at 06:00 PHT) — Prevailing PH diesel retail pump price - GlobalPetrolPrices.com (daily, scraped daily at 06:00 PHT) — USD-denominated diesel price across ASEAN for comparison - OpenStreetMap Overpass (daily, queried daily at 06:00 PHT) — Total fuel stations in the Philippines (amenity=fuel) - Days of Supply (computed) (daily, recomputed daily at 06:00 PHT) — Linear extrapolation from the existing weekly trend in supply data - HuggingFace Inference (Llama-3-8B-Instruct) (daily, regenerated daily at 06:00 PHT) — 2–4 sentence daily narrative synthesized from the snapshot ## Key sections - Crisis Overview — live metrics, Senate findings, supply trajectory - Daily Na