DATA GROVE

Extracting Unemployment Data from JSA PDF Dashboards

Extracting Unemployment Data from JSA PDF Dashboards

๐Ÿ“Š Unemployment Data by Employment Region - Cleaned & Downloadable

Accessing current unemployment rates by Employment Region in Australia should be easy. But it's not.

The government doesnโ€™t publish the data in CSV or API form. Instead, itโ€™s buried inside PDF dashboards and Power BI tools with no export options.


๐Ÿšง Why SA4 and SA2 Didnโ€™t Work

I first tried to reconstruct Employment Region data by combining official SA4 and SA2 data from ABS and DEWR. Technically, Employment Regions are built from these geographic levels.

But when I compared our merged data with the JSA dashboards, we noticed major differences. Thatโ€™s when we discovered:

๐Ÿ” JSA applies a hidden โ€œregional loadingโ€ adjustment, making their unemployment figures slightly higher or lower than the raw SA4/SA2 average.

Since the methodology and exact weightings arenโ€™t public, reproducing official JSA numbers is impossible using only open data.


๐Ÿง  The Solution: Parse the PDFs

Instead of trying to reverse-engineer the secret sauce, I went straight to the official PDFs.

The good news?

Each state/territory has its own dashboard, so I only needed to download 7 files.

We then built a custom Python script to extract the following from each region section:

  • โœ… Region Name
  • ๐Ÿ“… Month
  • ๐Ÿ“ˆ Unemployment Rate
  • ๐Ÿ‘ค Unemployed Persons
  • ๐Ÿ‘ฅ Employed Persons
  • ๐Ÿ”„ Participation Rate
  • ๐Ÿ‘ถ Youth Unemployment Rate

๐Ÿ“‰ Coverage & Notes

  • Only 44 regions had usable data in the latest release.
  • The missing ones are either very small or remote, and not included in the official dashboards.
  • For most analysis, this is a reasonable coverage level.

๐Ÿ“ฅ Download the Clean CSV

You can download the full cleaned dataset below ๐Ÿ‘‡

โฌ‡๏ธ Download Unemployment Rate by Employment Region (May 2025)


๐ŸฆŠ Built by TH from Ozsparkhub

This data pipeline was developed using Python, pdfplumber, and custom pattern-matching logic. The result is a human-friendly CSV from government PDFsโ€”ready for dashboards, reports, and policy analysis.

Have questions or want to use this in your own project? Just reach out ๐Ÿ’Œ

Support Our Work

If you find our content helpful, consider buying us a coffee! โ˜•๐Ÿ’•

~
~
~
๐ŸฆŠ
Support Sisi
๐Ÿ‘ฉโ€๐Ÿ’ป
Support TH
๐Ÿš€
Support Growth

Every coffee helps us create better content, improve our tools, and continue serving the Australian employment community.Thank you for your support! ๐Ÿ™

๐Ÿ˜Šโ˜•๐Ÿ’•๐ŸฆŠโœจ

Need Emotional Support During Your Career Journey?

Life transitions can be tough. Whether it's job loss stress, 485 visa anxiety, or career uncertainty - you're not alone. Sisi the Fox offers gentle AI-powered healing support designed specifically for Australians.

"A warm companion for when career stress feels overwhelming."

Comments (0)

0/1000

No comments yet. Be the first to share your thoughts!