data-diff

generated 2026-08-10 12:10 UTC · etl diff report
❌ Found differences in 3 of 9 compared datasets
1
changed
2
new
6
identical
0
skipped
counts are datasets
Of the 3 datasets with differences, the changes are: 🔴 1 large · 🟢 2 small (tiered by worst-column anomaly score; coverage loss ⇒ 🔴)
Top changes — what to watch
Indicators
  1. 🔴 garden/regions/2023-01-01/regions · regions− lost 14 data point(s): EI_AFR, EI_APAC, EI_CIS, EI_EUR…
  2. 🟡 garden/regions/2023-01-01/regions · regions.defined_bymedian anomaly score 3.2% · 3% of rows
  3. 🟡 garden/regions/2023-01-01/regions · regions.is_historicalmedian anomaly score 3.2% · 3% of rows
  4. 🟡 garden/regions/2023-01-01/regions · regions.membersmedian anomaly score 3.2% · 3% of rows
  5. 🟡 garden/regions/2023-01-01/regions · regions.namemedian anomaly score 3.2% · 3% of rows
  6. 🟡 garden/regions/2023-01-01/regions · regions.region_typemedian anomaly score 3.2% · 3% of rows
  7. 🟡 garden/regions/2023-01-01/regions · regions.short_namemedian anomaly score 3.2% · 3% of rows
~ garden/regions/2023-01-01/regions🟡 6 column(s) changed− 14 row(s) removed: EI_AFR, EI_APAC, EI_CIS, EI_EUR…7 columns in 1 table
= Table regions🟡 median anomaly score 3.2%
~ regions.code dimremoved data
- Removed values: 14 / 436 (3.21%)
code
EI_AFR
EI_APAC
EI_CIS
EI_EUR
EI_MEA
EI_NAM
EI_SCA
EMBER_AFR
EMBER_ASIA
EMBER_EUR
EMBER_LAC
EMBER_MEA
EMBER_NAM
EMBER_OCE
~ regions.defined_by 🟡 median anomaly score 3.2%changed data
- Removed values: 14 / 436 (3.21%)
codedefined_by
EI_AFRei
EI_APACei
EI_CISei
EI_EURei
EI_MEAei
EI_NAMei
EI_SCAei
EMBER_AFRember
EMBER_ASIAember
EMBER_EURember
EMBER_LACember
EMBER_MEAember
EMBER_NAMember
EMBER_OCEember
~ regions.is_historical 🟡 median anomaly score 3.2%changed data
- Removed values: 14 / 436 (3.21%)
codeis_historical
EI_AFRFalse
EI_APACFalse
EI_CISFalse
EI_EURFalse
EI_MEAFalse
EI_NAMFalse
EI_SCAFalse
EMBER_AFRFalse
EMBER_ASIAFalse
EMBER_EURFalse
EMBER_LACFalse
EMBER_MEAFalse
EMBER_NAMFalse
EMBER_OCEFalse
~ regions.members 🟡 median anomaly score 3.2%changed data
- Removed values: 14 / 436 (3.21%)
codemembers
EI_AFR["AGO", "BDI", "BEN", "BFA", "BWA", "CAF", "CIV", "CMR", "COD", "COG", "COM", "CPV", "DJI", "DZA", "EGY", "ERI", "ESH", "ETH", "GAB", "GHA", "GIN", "GMB", "GNB", "GNQ", "KEN", "LBR", "LBY", "LSO", "MAR", "MDG", "MLI", "MOZ", "MRT", "MUS", "MWI", "MYT", "NAM", "NER", "NGA", "REU", "RWA", "SDN", "SEN", "SHN", "SLE", "SOM", "SSD", "STP", "SWZ", "SYC", "TCD", "TGO", "TUN", "TZA", "UGA", "ZAF", "ZMB", "ZWE"]
EI_APAC["AFG", "ASM", "AUS", "BGD", "BRN", "BTN", "CCK", "CHN", "COK", "CXR", "FJI", "FSM", "GUM", "HKG", "IDN", "IND", "JPN", "KHM", "KIR", "KOR", "LAO", "LKA", "MAC", "MDV", "MHL", "MMR", "MNG", "MNP", "MYS", "NCL", "NFK", "NIU", "NPL", "NRU", "NZL", "PAK", "PCN", "PHL", "PLW", "PNG", "PRK", "PYF", "SGP", "SLB", "THA", "TKL", "TLS", "TON", "TUV", "TWN", "VNM", "VUT", "WLF", "WSM"]
EI_CIS["ARM", "AZE", "BLR", "KAZ", "KGZ", "MDA", "RUS", "TJK", "TKM", "UZB"]
EI_EUR["ALA", "ALB", "AND", "AUT", "BEL", "BGR", "BIH", "CHE", "CYP", "CZE", "DEU", "DNK", "ESP", "EST", "FIN", "FRA", "FRO", "GBR", "GEO", "GGY", "GIB", "GRC", "HRV", "HUN", "IMN", "IRL", "ISL", "ITA", "JEY", "LIE", "LTU", "LUX", "LVA", "MCO", "MKD", "MLT", "MNE", "NLD", "NOR", "OWID_KOS", "POL", "PRT", "ROU", "SMR", "SRB", "SVK", "SVN", "SWE", "TUR", "UKR", "VAT"]
EI_MEA["ARE", "BHR", "IRN", "IRQ", "ISR", "JOR", "KWT", "LBN", "OMN", "PSE", "QAT", "SAU", "SYR", "YEM"]
EI_NAM["CAN", "MEX", "USA"]
EI_SCA["ABW", "AIA", "ARG", "ATG", "BES", "BHS", "BLM", "BLZ", "BMU", "BOL", "BRA", "BRB", "CHL", "COL", "CRI", "CUB", "CUW", "CYM", "DMA", "DOM", "ECU", "FLK", "GLP", "GRD", "GTM", "GUF", "GUY", "HND", "HTI", "JAM", "KNA", "LCA", "MAF", "MSR", "MTQ", "NIC", "PAN", "PER", "PRI", "PRY", "SLV", "SUR", "SXM", "TCA", "TTO", "URY", "VCT", "VEN", "VGB", "VIR"]
EMBER_AFR["AGO", "BDI", "BEN", "BFA", "BWA", "CAF", "CIV", "CMR", "COD", "COG", "COM", "CPV", "DJI", "DZA", "EGY", "ERI", "ESH", "ETH", "GAB", "GHA", "GIN", "GMB", "GNB", "GNQ", "KEN", "LBR", "LBY", "LSO", "MAR", "MDG", "MLI", "MOZ", "MRT", "MUS", "MWI", "NAM", "NER", "NGA", "REU", "RWA", "SDN", "SEN", "SHN", "SLE", "SOM", "SSD", "STP", "SWZ", "SYC", "TCD", "TGO", "TUN", "TZA", "UGA", "ZAF", "ZMB", "ZWE"]
EMBER_ASIA["AFG", "ARM", "AZE", "BGD", "BRN", "BTN", "CHN", "GEO", "HKG", "IDN", "IND", "JPN", "KAZ", "KGZ", "KHM", "KOR", "LAO", "LKA", "MAC", "MDV", "MMR", "MNG", "MYS", "NPL", "PAK", "PHL", "PRK", "SGP", "THA", "TJK", "TKM", "TLS", "TWN", "UZB", "VNM"]
EMBER_EUR["ALB", "AUT", "BEL", "BGR", "BIH", "BLR", "CHE", "CYP", "CZE", "DEU", "DNK", "ESP", "EST", "FIN", "FRA", "FRO", "GBR", "GIB", "GRC", "HRV", "HUN", "IRL", "ISL", "ITA", "LTU", "LUX", "LVA", "MDA", "MKD", "MLT", "MNE", "NLD", "NOR", "OWID_KOS", "POL", "PRT", "ROU", "RUS", "SRB", "SVK", "SVN", "SWE", "TUR", "UKR"]
EMBER_LAC["ABW", "ARG", "ATG", "BHS", "BLZ", "BMU", "BOL", "BRA", "BRB", "CHL", "COL", "CRI", "CUB", "CYM", "DMA", "DOM", "ECU", "FLK", "GLP", "GRD", "GTM", "GUF", "GUY", "HND", "HTI", "JAM", "KNA", "LCA", "MEX", "MSR", "MTQ", "NIC", "PAN", "PER", "PRI", "PRY", "SLV", "SPM", "SUR", "TCA", "TTO", "URY", "VCT", "VEN", "VGB", "VIR"]
EMBER_MEA["ARE", "BHR", "IRN", "IRQ", "ISR", "JOR", "KWT", "LBN", "OMN", "PSE", "QAT", "SAU", "SYR", "YEM"]
EMBER_NAM["CAN", "GRL", "USA"]
EMBER_OCE["ASM", "AUS", "COK", "FJI", "GUM", "KIR", "NCL", "NIU", "NRU", "NZL", "PNG", "PYF", "SLB", "TON", "VUT", "WSM"]
~ regions.name 🟡 median anomaly score 3.2%changed data
- Removed values: 14 / 436 (3.21%)
codename
EI_AFRAfrica (EI)
EI_APACAsia Pacific (EI)
EI_CISCIS (EI)
EI_EUREurope (EI)
EI_MEAMiddle East (EI)
EI_NAMNorth America (EI)
EI_SCASouth and Central America (EI)
EMBER_AFRAfrica (Ember)
EMBER_ASIAAsia (Ember)
EMBER_EUREurope (Ember)
EMBER_LACLatin America and Caribbean (Ember)
EMBER_MEAMiddle East (Ember)
EMBER_NAMNorth America (Ember)
EMBER_OCEOceania (Ember)
~ regions.region_type 🟡 median anomaly score 3.2%changed data
- Removed values: 14 / 436 (3.21%)
coderegion_type
EI_AFRaggregate
EI_APACaggregate
EI_CISaggregate
EI_EURaggregate
EI_MEAaggregate
EI_NAMaggregate
EI_SCAaggregate
EMBER_AFRaggregate
EMBER_ASIAaggregate
EMBER_EURaggregate
EMBER_LACaggregate
EMBER_MEAaggregate
EMBER_NAMaggregate
EMBER_OCEaggregate
~ regions.short_name 🟡 median anomaly score 3.2%changed data
- Removed values: 14 / 436 (3.21%)
codeshort_name
EI_AFRAfrica (EI)
EI_APACAsia Pacific (EI)
EI_CISCIS (EI)
EI_EUREurope (EI)
EI_MEAMiddle East (EI)
EI_NAMNorth America (EI)
EI_SCASouth and Central America (EI)
EMBER_AFRAfrica (Ember)
EMBER_ASIAAsia (Ember)
EMBER_EUREurope (Ember)
EMBER_LACLatin America and Caribbean (Ember)
EMBER_MEAMiddle East (Ember)
EMBER_NAMNorth America (Ember)
EMBER_OCEOceania (Ember)
+ garden/migration/2026-07-22/us_foreign_born_populationnew dataset
+ Table by_country_of_birth
+ by_country_of_birth.foreign_born_population
+ Table by_region_of_birth
+ by_region_of_birth.foreign_born_population
+ Table share_by_origin_group
+ share_by_origin_group.share_of_population
+ Table us_foreign_born_population
+ us_foreign_born_population.foreign_born_population
+ us_foreign_born_population.share_foreign_born
+ garden/migration/2026-07-22/us_lawful_permanent_residentsnew dataset
+ Table by_country_of_origin
+ by_country_of_origin.immigrants
+ Table by_region_of_origin
+ by_region_of_origin.immigrants
+ Table us_lawful_permanent_residents
+ us_lawful_permanent_residents.immigrants
+ us_lawful_permanent_residents.immigrants_per_1000
= garden/demography/2024-07-15/populationidentical
= garden/faostat/2024-03-14/faostat_rl_auxiliaryidentical
= garden/gapminder/2023-03-31/populationidentical
= garden/hyde/2024-01-02/all_indicatorsidentical
= garden/un/2024-07-12/un_wppidentical
= garden/wb/2026-07-01/income_groupsidentical