How to Seamlessly Extract Historical Data for Regional Economic Analysis Using DBnomics and 'What's Our State' Navigation?

Community
1

As an avid user of DBnomics, I’ve been exploring various ways to make the most out of the platform’s extensive economic data. I’m particularly interested in analyzing historical economic data for specific regions and am trying to streamline the process of extracting and navigating this information efficiently. Given the vast array of datasets available on DBnomics, I sometimes find it challenging to filter and access the exact historical data points I need, especially when focusing on specific regions or states.

Recently, I came across a tool called “whats our state” that seems promising for navigating regional data. However, I’m unsure how best to integrate or utilize this tool alongside DBnomics for a more targeted analysis. My main goal is to use DBnomics to extract comprehensive historical economic data for a particular state or region and then seamlessly navigate this data to identify trends, make comparisons, and possibly even generate visualizations.

For example, when attempting to analyze the unemployment rates in a specific state over the past decade, I noticed that filtering by region isn’t always straightforward. I would love to know if there’s a way to enhance the precision of data extraction within DBnomics, particularly when combined with navigation tools like “What’s Our State.” Are there any recommended steps or workflows that can help in narrowing down data to the state or regional level more effectively? Additionally, how can I use “What’s Our State” to complement this process and ensure that I am not missing out on any critical datasets?

I am also curious about any tips or best practices for managing the data once it’s extracted. For instance, are there specific features within DBnomics that allow for better data management or integration with navigation tools? Or, is there a particular approach that other users have found successful when dealing with regional economic data?

Any insights, advice, or shared experiences from fellow users would be greatly appreciated. I’m particularly interested in learning more about how “What’s Our State” can be leveraged within the DBnomics platform to improve the overall data analysis process for regional economic studies. Thank you in advance for your help!

2

Dear Therese,

you raise an interesting and difficult question. Just a few remarks:

  • I couldn’t find a way to add data to “whats our state”. Could you give us a short example of what to you try to achieve?
  • DBnomics relies entirely on the information provided by each data provider. Therefor, the codes for countries, states, regions or cities may vary from on provider to the next. It would be your responsibility to build the appropriate matching tables.
  • For each dataset, the tab “Dimensions” near the top of the left column will describe among otheres, the regional dimensions. See AFDB/bbkawjf | DBnomics
  • Concerning the "exact historical data points¨, DBnomics handles the entire time series available. The best is to download the entire time series and select the periods that you are interested in in your Python or R application. The format used to describe the period of observation is uniform in DBnomics