ParseForge
Philippines PSA OpenStat Scraper
parseforge/philippines-psa-openstat-scraper
Developer toolsBusinessEducation
Scrapes Philippine Statistics Authority OpenStat PXWeb catalog entries and table cell values. Returns each dataset or cell as a flat row for export to CSV, JSON, Excel, or XML.
- Total users
- 2
- Monthly active
- 1
- Total runs
- 45
- Bookmarked
- 0
- Rating
- Not rated yet
- Last modified
- 9 days ago
Overview
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
- Create a free Apify account with $5 in credit.
- Open the Philippines PSA OpenStat Scraper.
- Set your inputs and any filters, then click Start.
- 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.
Input
| Field | Type | What it does | Default |
|---|---|---|---|
| maxItems | integer | Maximum number of datasets to collect per run. | 10 |
| mode | string (2 options) | Browse the catalog tree or fetch cells from a specific table. | catalog |
| path | string | Folder path inside OpenStat (e.g. 0_OD/G_Census/B_PopProj). Empty for root. | not set |
| tableId | string | Table file (e.g. 0012K4APP01.px). Required when mode is table. | not set |
Pricing
from $7.50 per 1,000 results
| Charged for | What it is | Price each |
|---|---|---|
| result | Single result in the default dataset. | $0.0075 to $0.0085 |
Tiered: the lower figure is the price on a higher Apify plan. Billing and the free credit live on Apify.
API
One POST returns the dataset directly. Same shape for every scraper in the library, so swapping the slug is the only change.
curl -X POST "https://api.apify.com/v2/acts/parseforge~philippines-psa-openstat-scraper/run-sync-get-dataset-items?token=$APIFY_TOKEN" \
-H "Content-Type: application/json" \
-d '{
"helloWorld": 123
}' Examples
Input that runs as-is.
{
"helloWorld": 123
} Reviews
No reviews yet. Be the first.
Issues
We build and maintain this scraper, so a problem with it comes to us. Report it on the Apify listing and the thread stays attached to the scraper where the next person can find it: open an issue.
Broken and urgent, or you would rather not post in public? Write to parseforge@protonmail.com and it reaches the people who wrote it.