Philippines PSA OpenStat Scraper

Philippines PSA OpenStat Scraper

Scrape official Philippine statistical data from the PSA OpenStat portal, from census figures to economic indicators. Extract catalog listings or full table cell values with a single run. Export structured data to CSV, JSON, Excel, or XML.

The Philippine Statistics Authority publishes census, demographic, economic, and social datasets through its OpenStat PXWeb portal, but manual browsing and downloading is slow and repetitive. This Actor reads the catalog tree or fetches cell-level data from any table by its PXWeb path and table ID, returning each dataset or cell row in a consistent flat schema. No API key or authentication is needed.

Who uses it	What they scrape Philippine Statistics Authority OpenStat for
Economic researchers	Pull regional GDP or labor force statistics for time-series analysis.
Policy analysts	Monitor demographic projections and poverty indicators across provinces.
Data journalists	Gather census data for infographics and public-interest reporting.
Academic researchers	Collect population and housing census datasets for social science studies.

What it does

This Actor collects Philippine PSA OpenStat catalog entries or table cell values by folder path and table ID, and returns each item as a structured row.

• 📂 Catalog mode: Browse the OpenStat folder tree and list all available tables under a given path.
• 📊 Table mode: Fetch every cell value from a specific PXWeb table, including dimensions and metadata.
• 🔢 Volume control: Set a maximum number of datasets to cap the run and manage data size.

Results export to CSV, JSON, Excel, or XML, or straight from the API.

What you can do with Philippine Statistics Authority OpenStat data

📈 Track regional economic indicators.

An economist fetches quarterly GDP by region from OpenStat to feed a forecasting model.

🗳️ Analyze demographic shifts.

A policy researcher pulls population projections by age group and province to support local government planning.

📰 Build data-driven stories.

A journalist extracts poverty incidence tables to create a report on inequality trends.

🎓 Support academic research.

A graduate student collects census housing data for a thesis on urbanization patterns.

Why choose this scraper

	What you get
Official source	Data comes directly from the Philippine Statistics Authority OpenStat portal.
Structured output	Every catalog entry or table cell is returned as a flat row ready for analysis.
No coding required	provide a path or table ID and run the Actor on Apify.
Flexible export	Save results as CSV, JSON, Excel, or XML for use in any tool.

How it compares

No other Store actor targets Philippine Statistics Authority OpenStat the same way, so the honest comparison is with the alternatives teams actually weigh.

	Philippines PSA OpenStat Scraper	Build it in-house	By hand
Setup	Run it now, zero config	Days of engineering	None, but hours per pull
When Philippine Statistics Authority OpenStat changes	Maintained for you	You fix it	You re-learn the page
Proxies, retries, anti-bot	Built in	Your problem	Browser only
Output	Fixed JSON schema, CSV/Excel export	Whatever you build	Copy-paste
Cost	Pay per result	Engineering time	Analyst hours

Configure the run

Drive the Actor with a PXWeb folder path for catalog browsing or a specific table ID for cell-level extraction, and limit the total datasets collected per run. The Input tab lists every parameter.

A first run with the defaults:

{
 "maxItems": 10
}

A larger pull:

{
 "maxItems": 200
}

Pricing

Pay-per-result: $0.0085 per result collected. You pay only for the results written to your dataset.

Results collected	Approximate cost
100 results	$0.85
1,000 results	$8.50
10,000 results	$85.00

New Apify accounts start with $5 in free credit.

Free users

Free-plan runs return up to 10 results as a preview. Upgrade your Apify plan to collect up to 1,000,000 results per run.

Run it

1. Create a free Apify account with $5 in credit.
2. Open the Philippines PSA OpenStat Scraper.
3. Set your inputs and any filters, then click Start.
4. Export the results as CSV, Excel, JSON, or XML from the Dataset tab.

Run it programmatically through the Apify API (run-sync-get-dataset-items) or the ApifyClient for JavaScript and Python.

Use with AI agents (MCP)

Give an AI agent live access to Philippine Statistics Authority OpenStat through the Model Context Protocol. Add the Actor to Claude, Cursor, or any MCP client:

$claude mcp add --transport http apify "https://mcp.apify.com?tools=parseforge/philippines-psa-openstat-scraper"

Then prompt it in plain language to run the scraper and read back the results.

Troubleshooting

Why am I getting no results?

Check that the PXWeb path or table ID is correct and exists on the OpenStat portal. Try browsing the portal manually to verify the path structure.

The run takes too long or times out.

Reduce the maximum datasets limit or choose a smaller table. Very large tables with many dimensions can take longer to fetch.

I see an error about an invalid table ID.

Ensure the table ID includes the.px extension and matches exactly what appears in the OpenStat catalog. Use catalog mode first to confirm the ID.

The output contains unexpected characters or encoding issues.

The Actor returns UTF-8 encoded data. If you see garbled text, check your CSV import settings to ensure UTF-8 is selected.

FAQ

Question	Answer
What is the Philippine Statistics Authority OpenStat portal?	OpenStat is the PSA's public PXWeb database of official statistics, covering census, demographic, economic, and social indicators for the Philippines.
Do I need an API key or login to scrape OpenStat?	No. The Actor reads the public PXWeb interface directly, so no registration or authentication is required.
How do I find the PXWeb path for a dataset?	Browse the OpenStat website and note the folder structure in the URL or breadcrumb trail. The path follows the format like 0_OD/G_Census/B_PopProj.
What is the difference between catalog and table mode?	Catalog mode lists all tables available under a folder path. Table mode fetches the actual cell values from a specific table file you specify by ID.
Can I scrape multiple tables in one run?	The Actor processes one path or table per run. To collect multiple tables, run the Actor multiple times with different inputs or use catalog mode to discover table IDs first.
What format does the output data come in?	You can export the scraped data to CSV, JSON, Excel, or XML from your Apify dataset.
Is the data in English or Filipino?	The PSA OpenStat portal presents metadata and labels primarily in English, with some localized terms.
How much data can I scrape at once?	You set the maximum number of datasets per run, up to 1,000,000. Large tables may take longer to fetch completely.
Does this Actor handle historical data?	Yes. If the table includes historical time series, the Actor returns all available years and periods.
Can I filter which cells to fetch in table mode?	The Actor fetches all cells in the specified table. You can filter the output after the run using your own analysis tools.

Related actors

Browse the full ParseForge collection for more scrapers.

🆘 Need help? Email parseforge@protonmail.com with your run ID, your input, and what you expected.

⚠️ Disclaimer. This Actor is unofficial and is not affiliated with, endorsed by, or sponsored by Philippine Statistics Authority. It collects only publicly available data. You are responsible for using the collected data in compliance with the source's terms of service and applicable data-protection laws, including GDPR, CCPA, and PIPL. Do not use it to collect personal data unlawfully.