Database Development from Open Source - Global Indices & Econometrics (1995 - 2025)

Creation of a database in excel format of 75 open-source global metrics. These metrics / indices are from World Bank, Public Websites. I will require an excel extraction of scores / ranks for all countries in the metric - for all years published between 1995 and 2025. All metrics have data sets with 100 + countries. You can use AI to undertake this data scrape, with the appropriate quality checks to ensure the data extraction is clean. Where data sets require paid amounts - I will pay for the required access.

Deliverables: 3 excel workbooks - with comprehensive data sets for all required metrics (Work book 1 - 36 indices | Work book 2 - 32 indices | Work book 3 - 7 indices). There should be 1 tab for each metric containing - time series data X axis (top) left to right: 1995 - 2025, with data populated from the time of first publication (if after 1995), and the full list of countries on the Y axis - top to bottom in alphabetical order. Each tab should include:

Title: Indicator / sub-indicator / metric name
Author / Publishing entity:
Date of first publication:
Last year of publication:
Frequency of publication:
Date data extracted:
Link to source content online:

------

The data table should then be structured per below:

- Row 20: Column A: Country | Column B - xx = Years from 1995 - 2025.
- Row 21: Column B (Years) should have 2 columns per year, which shows score / raw data | rank - ie. Column B = 1995 - Score / Figure; Column C = 1995 - Country Rank; Column D = 1996 - Score / Figure; Column E = 1996 - Country Rank.

The ranking should be provided for that year by the publisher, or you should calculate it from the Score / Figure column - looking at relative performance of each nation.