devinit / devinit/datahub

Fact Schema Track

Open
#401 3 comments 0 reactions 0 assignees View on GitHub
database
Dominant language
TypeScript
Stars
15
Forks
4
PR merge metrics
No merged PRs in 30d

Description

Issue for tracking actual update on tables and table dependencies for fact schema.
When update on the tables is completed, the checkbox will be marked to indicate updated.
Every table that has a dependency has its dependency listed and a link to the issue list for it

**Table list**

- [x] ssc_percent_gni
- [x] out_ssc_net_constant
- [x] out_oof_net_constant
- [x] oda_percent_gni [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_oda_percent_gni.sql)
- [x] out_oda_net_constant
- [x] in_oda_net_constant
- [x] in_oda_gross_constant
- [x] out_debt_relief/out_debt_relief_constant
- [x] oda_crs [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_oda.sql)
- [x] oda/oda_constant [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_oda.sql)
References
dimension.di_itep_sector
dimension.oda_budnle
- [x] gni_constant [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_gni.sql)
- [x] gni [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_gni.sql)
- [x] gni_pc_usd_current/gni_pc_usd_constant
- [x] Submitted for review
- [x] gni_usd_constant/gni_usd_current
- [ ] in_oda_gross
- [x] in_oda_net_constant/in_oda_net [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_in_oda_net.sql)
- [x] in_oof_gross_constant
- [x] income_share_bottom_20pc
- [x] income_share_by_quintile_2nd
- [x] income_share_by_quintile_3rd
- [x] income_share_by_quintile_4th
- [x] gdp_pc_usd_constant
- [x] gdp_pc_current
- [x] Submitted for review
- [ ] gdp_usd_constant
- [x] Submitted for review
- [x] gdp_usd_current
- [x] income_share_by_quintile
- [x] income_share_by_quintile_5th
- [x] life_expectancy_at_birth
- [x] Submitted for review
- [x] maternal_mortality
- [x] Submitted for review
- [x] oda_new/oda_constant_new [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_oda_new.sql)
- [ ] oda_to_ldcs_percent_gni
- [x] oof/oof_constant [Code](https://github.com/devinit/ddh_donata_scripts/blob/master/data_etl/dh/fact_oecd/CREATE_TABLE_oof.sql)
References
dimension.oof_bundle
dimension.di_itep_sector
- [ ] out_oda_gross_constant
- [ ] out_oda_gross
- [x] out_oda_net
- [x] population_by_age
- [x] population_by_age_0_14
- [x] population_by_age_15_64
- [x] population_by_age_65_and_above
- [x] population_rural
- [x] population_rural_urban
- [x] population_total
- [x] population_urban

**All Reference**
- [x] dimension.di_id
- [x] dimenstion.time

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.