owid / etl

A compute graph for loading and transforming OWID's data
https://docs.owid.io/projects/etl
MIT License
58 stars 18 forks source link

:bug: Fill historical data for Equaldex #2868

Closed paarriagadap closed 1 week ago

paarriagadap commented 1 week ago

Use the same method to fill missing dates in the current data for the historical data.

owidbot commented 1 week ago
Quick links (staging server): Site Admin Wizard

Login: ssh owid@staging-site-fill-historical-data-equaldex

chart-diff: ✅ No charts for review.
data-diff: ❌ Found differences ```diff = Dataset garden/lgbt_rights/2024-06-03/equaldex = Table equaldex ~ Column adoption (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 891 / 15075 (5.91%) country year adoption - adoption + Andorra 1981 NaN Illegal Czechia 1999 NaN Illegal Israel 1958 NaN Illegal Portugal 1953 NaN Illegal Russia 1967 NaN Illegal ~ Column adoption_ambiguous_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 146 / 15075 (0.97%) country year adoption_ambiguous_count - adoption_ambiguous_count + Europe 1957 0 1 Europe 1974 0 1 Europe 1977 0 1 World 1996 2 3 World 2019 4 5 ~ Column adoption_ambiguous_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 146 / 15075 (0.97%) country year adoption_ambiguous_pop - adoption_ambiguous_pop + Europe 1957 0 17884930 Europe 1974 0 20889666 Europe 1977 0 21678700 World 1996 130770144 153188016 World 2019 418794364 438318576 ~ Column adoption_current (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1 / 15075 (0.01%) country year adoption_current - adoption_current + Antigua and Barbuda 2024 Single only NaN ~ Column adoption_illegal_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 282 / 15075 (1.87%) country year adoption_illegal_count - adoption_illegal_count + Asia 2014 21 23 Europe 1967 3 9 Europe 1995 4 10 South America 2012 0 1 World 2014 43 49 ~ Column adoption_illegal_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 282 / 15075 (1.87%) country year adoption_illegal_pop - adoption_illegal_pop + Asia 2014 2199550719 2213077727 Europe 1967 12682452 205991791 Europe 1995 22226190 242678449 South America 2012 0 5923327 World 2014 2751463126 2827193387 ~ Column adoption_legal_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column adoption_legal_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column adoption_missing_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 366 / 15075 (2.43%) country year adoption_missing_count - adoption_missing_count + Asia 1976 15 13 Asia 1995 12 10 Europe 1955 35 26 Europe 1983 34 26 South America 1988 10 8 ~ Column adoption_missing_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 366 / 15075 (2.43%) country year adoption_missing_pop - adoption_missing_pop + Asia 1976 1221121565 1215061158 Asia 1995 347575970 337870607 Europe 1955 545372910 330222178 Europe 1983 626101652 389694693 South America 1988 264480633 247717796 ~ Column adoption_second_parent_adoption_only_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column adoption_second_parent_adoption_only_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column adoption_single_only_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 272 / 15075 (1.80%) country year adoption_single_only_count - adoption_single_only_count + North America 2000 12 11 South America 2015 4 5 World 1964 72 73 World 1984 73 74 World 2005 78 79 ~ Column adoption_single_only_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 278 / 15075 (1.84%) country year adoption_single_only_pop - adoption_single_only_pop + Europe 1965 53878282 55547736 Europe 2005 62608056 64612836 South America 2005 28663488 44838803 World 1966 841284599 852070127 World 1973 981027284 993055878 ~ Column adoption_varies_by_region_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column adoption_varies_by_region_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column age_of_consent (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 138 / 15075 (0.92%) country year age_of_consent - age_of_consent + Bahrain 1955 NaN Equal Bahrain 1971 NaN Equal Bahrain 1974 NaN Equal Iraq 1954 NaN Ambiguous Iraq 2004 NaN Ambiguous ~ Column age_of_consent_ambiguous_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 148 / 15075 (0.98%) country year age_of_consent_ambiguous_count - age_of_consent_ambiguous_count + Asia 1957 0 1 Asia 1974 0 1 Asia 1977 0 1 Asia 1987 0 1 World 1990 2 3 ~ Column age_of_consent_ambiguous_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 148 / 15075 (0.98%) country year age_of_consent_ambiguous_pop - age_of_consent_ambiguous_pop + Asia 1957 0 6683810 Asia 1974 0 11243145 Asia 1977 0 12400193 Asia 1987 0 16598017 World 1990 84341 17742725 ~ Column age_of_consent_current (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1 / 15075 (0.01%) country year age_of_consent_current - age_of_consent_current + Antigua and Barbuda 2024 Equal NaN ~ Column age_of_consent_equal_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 128 / 15075 (0.85%) country year age_of_consent_equal_count - age_of_consent_equal_count + Asia 1958 14 15 Asia 1974 14 15 Asia 1990 15 16 Asia 2001 22 23 World 1972 53 54 ~ Column age_of_consent_equal_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 128 / 15075 (0.85%) country year age_of_consent_equal_pop - age_of_consent_equal_pop + Asia 1958 850048988 850198080 Asia 1974 1181697596 1181968233 Asia 1990 1513870112 1514387541 Asia 2001 1861302424 1862032687 World 1972 1715558145 1715801304 ~ Column age_of_consent_female_equal__male_illegal_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column age_of_consent_female_equal__male_illegal_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column age_of_consent_missing_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 150 / 15075 (1.00%) country year age_of_consent_missing_count - age_of_consent_missing_count + Asia 1957 32 30 Asia 1983 30 28 Asia 2012 22 21 World 1980 114 112 World 1987 111 109 ~ Column age_of_consent_missing_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 152 / 15075 (1.01%) country year age_of_consent_missing_pop - age_of_consent_missing_pop + Asia 1974 1023809282 1012295500 Asia 1994 1624245624 1603404291 Asia 2012 1993864367 1959999915 World 1971 1941024676 1930638738 World 1975 1960585515 1948682759 ~ Column age_of_consent_unequal_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column age_of_consent_unequal_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column age_of_consent_varies_by_region_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column age_of_consent_varies_by_region_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1229 / 15075 (8.15%) country year blood - blood + Antigua and Barbuda 1968 Legal NaN Germany 1986 NaN Banned (indefinite deferral) Hungary 1972 NaN Banned (1-year deferral) Norway 1965 NaN Banned (indefinite deferral) Uruguay 1995 NaN Banned (1-year deferral) ~ Column blood_ambiguous_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_ambiguous_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_banned__1_year_deferral__count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 214 / 15075 (1.42%) country year blood_banned__1_year_deferral__count - blood_banned__1_year_deferral__count + Europe 1987 2 4 South America 1967 0 1 World 1978 3 6 World 1984 3 6 World 2005 6 9 ~ Column blood_banned__1_year_deferral__pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 214 / 15075 (1.42%) country year blood_banned__1_year_deferral__pop - blood_banned__1_year_deferral__pop + Europe 1987 15503256 26727484 South America 1967 0 2731850 World 1978 15241244 29495927 World 1984 15581551 29890411 World 2005 350612459 365040728 ~ Column blood_banned__5_year_deferral__count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_banned__5_year_deferral__pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_banned__6_month_deferral__count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_banned__6_month_deferral__pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_banned__indefinite_deferral__count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 216 / 15075 (1.43%) country year blood_banned__indefinite_deferral__count - blood_banned__indefinite_deferral__count + Africa 1987 10 11 Europe 1967 1 14 World 1958 32 46 World 1975 32 46 World 2005 48 61 ~ Column blood_banned__indefinite_deferral__pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 216 / 15075 (1.43%) country year blood_banned__indefinite_deferral__pop - blood_banned__indefinite_deferral__pop + Africa 1987 88424890 109306986 Europe 1967 3579248 202699200 World 1958 200564635 393483490 World 1975 314534288 536264352 World 2005 2761223293 2960359451 ~ Column blood_banned__less_than_6_month_deferral__count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_banned__less_than_6_month_deferral__pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_current (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1 / 15075 (0.01%) country year blood_current - blood_current + Antigua and Barbuda 2024 Legal NaN ~ Column blood_legal_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 150 / 15075 (1.00%) country year blood_legal_count - blood_legal_count + Europe 1957 6 7 North America 1950 12 11 North America 1979 13 12 North America 2024 18 17 World 1989 76 75 ~ Column blood_legal_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 183 / 15075 (1.21%) country year blood_legal_pop - blood_legal_pop + Europe 1968 51920302 101567574 North America 1950 9019461 8974005 North America 2011 45992418 45905669 North America 2015 168087294 167997336 World 2015 1387603167 1387513209 ~ Column blood_legal_with_restrictions_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_legal_with_restrictions_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_missing_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 364 / 15075 (2.41%) country year blood_missing_count - blood_missing_count + Africa 1976 12 11 Africa 1995 12 11 South America 1950 7 6 South America 1989 7 6 World 1969 75 58 ~ Column blood_missing_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 364 / 15075 (2.41%) country year blood_missing_pop - blood_missing_pop + Africa 1976 165218073 151115802 Africa 1995 282377512 255499162 South America 1950 100204756 97970604 South America 1989 254654394 251556498 World 1969 2774612446 2498088320 ~ Column blood_varies_by_region_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column blood_varies_by_region_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 509 / 15075 (3.38%) country year censorship - censorship + El Salvador 1963 NaN No censorship El Salvador 1980 NaN No censorship Kuwait 2007 NaN Imprisonment as punishment Kyrgyzstan 2003 NaN No censorship Kyrgyzstan 2022 NaN No censorship ~ Column censorship_ambiguous_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship_ambiguous_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship_current (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship_fine_as_punishment_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship_fine_as_punishment_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship_imprisonment_as_punishment_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 144 / 15075 (0.96%) country year censorship_imprisonment_as_punishment_count - censorship_imprisonment_as_punishment_count + Asia 1957 5 6 Asia 1976 6 7 World 1967 13 14 World 1975 13 14 World 1988 14 15 ~ Column censorship_imprisonment_as_punishment_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 144 / 15075 (0.96%) country year censorship_imprisonment_as_punishment_pop - censorship_imprisonment_as_punishment_pop + Asia 1957 16569917 16793202 Asia 1976 31273281 32442080 World 1967 132860487 133481738 World 1975 163847706 164943710 World 1988 242072558 244201718 ~ Column censorship_missing_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 329 / 15075 (2.18%) country year censorship_missing_count - censorship_missing_count + Asia 2016 5 2 Europe 1999 6 5 Europe 2019 4 3 North America 1953 2 0 South America 1979 2 1 ~ Column censorship_missing_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 329 / 15075 (2.18%) country year censorship_missing_pop - censorship_missing_pop + Asia 2016 68939583 53004622 Europe 1999 279770884 241415932 Europe 2019 114025386 75531786 North America 1953 160853592 3066445 South America 1979 122513222 3065918 ~ Column censorship_no_censorship_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 221 / 15075 (1.47%) country year censorship_no_censorship_count - censorship_no_censorship_count + Asia 2016 20 21 North America 2006 21 23 North America 2015 21 23 World 1983 130 133 World 2005 134 137 ~ Column censorship_no_censorship_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 221 / 15075 (1.47%) country year censorship_no_censorship_pop - censorship_no_censorship_pop + Asia 2016 1929837370 1935855673 North America 2006 209227855 515015382 North America 2015 234532311 565371159 World 1983 1946167223 2185169145 World 2005 3022191372 3330264957 ~ Column censorship_other_punishment_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 144 / 15075 (0.96%) country year censorship_other_punishment_count - censorship_other_punishment_count + Asia 1957 0 1 Asia 1976 0 1 World 1967 0 1 World 1975 0 1 World 1988 1 2 ~ Column censorship_other_punishment_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 144 / 15075 (0.96%) country year censorship_other_punishment_pop - censorship_other_punishment_pop + Asia 1957 0 1448677 Asia 1976 0 2592282 World 1967 0 2018029 World 1975 0 2525761 World 1988 56952648 60477764 ~ Column censorship_state_enforced_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 178 / 15075 (1.18%) country year censorship_state_enforced_count - censorship_state_enforced_count + Europe 2004 0 1 Europe 2005 0 1 Europe 2013 0 1 World 1965 19 22 World 1993 19 20 ~ Column censorship_state_enforced_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 178 / 15075 (1.18%) country year censorship_state_enforced_pop - censorship_state_enforced_pop + Europe 2004 0 38596040 Europe 2005 0 38575912 Europe 2013 0 38607352 World 1965 1041777172 1165870090 World 1993 1820655507 1858974807 ~ Column censorship_varies_by_region_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column censorship_varies_by_region_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column changing_gender (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1486 / 15075 (9.86%) country year changing_gender - changing_gender + Albania 1959 NaN Illegal Botswana 2009 NaN Illegal Cyprus 1996 NaN Illegal Kyrgyzstan 2010 NaN Legal, surgery required Peru 2012 NaN Illegal ~ Column changing_gender_ambiguous_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 134 / 15075 (0.89%) country year changing_gender_ambiguous_count - changing_gender_ambiguous_count + North America 1958 0 1 North America 1976 0 1 World 1951 4 5 World 1978 4 5 World 1983 4 5 ~ Column changing_gender_ambiguous_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 134 / 15075 (0.89%) country year changing_gender_ambiguous_pop - changing_gender_ambiguous_pop + North America 1958 0 2637605 North America 1976 0 4166894 World 1951 3078801 5310955 World 1978 6908796 11255331 World 1983 8014453 12704138 ~ Column changing_gender_current (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1 / 15075 (0.01%) country year changing_gender_current - changing_gender_current + Antigua and Barbuda 2024 Illegal NaN ~ Column changing_gender_illegal_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 426 / 15075 (2.83%) country year changing_gender_illegal_count - changing_gender_illegal_count + Africa 1960 43 47 Africa 2004 43 46 Europe 1971 3 10 North America 2014 16 15 South America 1974 3 4 ~ Column changing_gender_illegal_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 426 / 15075 (2.83%) country year changing_gender_illegal_pop - changing_gender_illegal_pop + Africa 1960 204021238 224431130 Africa 2004 647827769 703249820 Europe 1971 20188118 138003386 North America 2014 57605508 57516256 South America 1974 16182015 31239197 ~ Column changing_gender_legal__medical_diagnosis_required_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column changing_gender_legal__medical_diagnosis_required_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column changing_gender_legal__no_restrictions_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 116 / 15075 (0.77%) country year changing_gender_legal__no_restrictions_count - changing_gender_legal__no_restrictions_count + North America 1957 0 1 North America 1960 0 1 North America 2001 0 1 World 1958 0 1 World 1966 0 1 ~ Column changing_gender_legal__no_restrictions_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 116 / 15075 (0.77%) country year changing_gender_legal__no_restrictions_pop - changing_gender_legal__no_restrictions_pop + North America 1957 0 33239524 North America 1960 0 36268048 North America 2001 0 99394288 World 1958 0 34180100 World 1966 0 44180444 ~ Column changing_gender_legal__surgery_required_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 340 / 15075 (2.26%) country year changing_gender_legal__surgery_required_count - changing_gender_legal__surgery_required_count + North America 2011 2 3 South America 1970 0 1 World 1954 7 15 World 1957 7 15 World 1982 26 34 ~ Column changing_gender_legal__surgery_required_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 340 / 15075 (2.26%) country year changing_gender_legal__surgery_required_pop - changing_gender_legal__surgery_required_pop + North America 2011 14987392 49310928 South America 1970 0 23842804 World 1954 50877881 108625126 World 1957 55301818 116520786 World 1982 737989148 828326930 ~ Column changing_gender_missing_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 425 / 15075 (2.82%) country year changing_gender_missing_count - changing_gender_missing_count + Africa 1960 7 3 Africa 2004 4 1 Europe 1967 36 25 Europe 2016 9 7 North America 1964 7 5 ~ Column changing_gender_missing_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 431 / 15075 (2.86%) country year changing_gender_missing_pop - changing_gender_missing_pop + Africa 1960 48785015 28375123 Africa 2004 83907206 28485155 Europe 1962 592285305 467589292 Europe 2007 59918184 37547790 World 1983 3310877763 1942070868 ~ Column changing_gender_varies_by_region_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column changing_gender_varies_by_region_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column conversion_therapy (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1135 / 15075 (7.53%) country year conversion_therapy - conversion_therapy + Chile 1984 NaN Not banned Iceland 1994 NaN Not banned Portugal 1987 NaN Not banned Spain 1996 NaN Varies by region Turkmenistan 2005 NaN Not banned ~ Column conversion_therapy_ambiguous_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 150 / 15075 (1.00%) country year conversion_therapy_ambiguous_count - conversion_therapy_ambiguous_count + Europe 1957 1 2 Europe 1983 1 2 Europe 2012 1 2 North America 1991 2 1 North America 1998 2 1 ~ Column conversion_therapy_ambiguous_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 216 / 15075 (1.43%) country year conversion_therapy_ambiguous_pop - conversion_therapy_ambiguous_pop + Europe 1987 56644528 56999705 North America 1973 2009808 1945324 World 1961 55658508 55939371 World 1978 63098907 63362038 World 2008 65898574 66228714 ~ Column conversion_therapy_banned_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column conversion_therapy_banned_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column conversion_therapy_current (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 1 / 15075 (0.01%) country year conversion_therapy_current - conversion_therapy_current + Antigua and Barbuda 2024 Ambiguous NaN ~ Column conversion_therapy_missing_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 361 / 15075 (2.39%) country year conversion_therapy_missing_count - conversion_therapy_missing_count + Asia 1976 11 8 Asia 1995 10 7 North America 1990 4 3 South America 1950 9 8 South America 1989 9 8 ~ Column conversion_therapy_missing_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 367 / 15075 (2.43%) country year conversion_therapy_missing_pop - conversion_therapy_missing_pop + Asia 1976 940272637 252065319 Asia 1995 1394504440 352239599 Europe 1956 195693204 92086541 Europe 1984 234911852 106701446 South America 1988 278061906 265143511 ~ Column conversion_therapy_not_banned_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 361 / 15075 (2.39%) country year conversion_therapy_not_banned_count - conversion_therapy_not_banned_count + Asia 1976 34 37 Asia 1995 35 38 North America 1990 16 18 South America 1950 3 4 South America 1989 3 4 ~ Column conversion_therapy_not_banned_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 361 / 15075 (2.39%) country year conversion_therapy_not_banned_pop - conversion_therapy_not_banned_pop + Asia 1976 1495141994 2183349312 Asia 1995 2080390665 3122655506 North America 1990 40785088 150162718 South America 1950 3703350 10327000 South America 1989 8110429 21239054 ~ Column conversion_therapy_sexual_orientation_only_count (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column conversion_therapy_sexual_orientation_only_pop (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column conversion_therapy_varies_by_region_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 144 / 15075 (0.96%) country year conversion_therapy_varies_by_region_count - conversion_therapy_varies_by_region_count + Europe 1957 0 1 Europe 1976 0 1 World 1967 2 3 World 1975 2 3 World 1988 2 3 ~ Column conversion_therapy_varies_by_region_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 144 / 15075 (0.96%) country year conversion_therapy_varies_by_region_pop - conversion_therapy_varies_by_region_pop + Europe 1957 0 29577444 Europe 1976 0 36139072 World 1967 205591546 238405770 World 1975 225161409 260921841 World 1988 258813709 297595433 ~ Column discrimination (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 839 / 15075 (5.57%) country year discrimination - discrimination + Dominica 1977 NaN No protections Indonesia 1993 NaN No protections Montenegro 1963 NaN No protections Sri Lanka 2005 NaN Ambiguous Thailand 1967 Illegal No protections ~ Column discrimination_ambiguous_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 128 / 15075 (0.85%) country year discrimination_ambiguous_count - discrimination_ambiguous_count + Asia 1958 0 1 Asia 1974 0 1 Asia 1990 0 1 Asia 2001 0 1 World 1972 0 1 ~ Column discrimination_ambiguous_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 128 / 15075 (0.85%) country year discrimination_ambiguous_pop - discrimination_ambiguous_pop + Asia 1958 0 9329673 Asia 1974 0 13418276 Asia 1990 0 17204098 Asia 2001 0 18920278 World 1972 0 12914457 ~ Column discrimination_current (changed metadata) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Column discrimination_illegal_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 132 / 15075 (0.88%) country year discrimination_illegal_count - discrimination_illegal_count + Europe 1955 0 1 Europe 1973 0 1 Europe 1977 0 1 World 1950 1 2 World 1977 1 2 ~ Column discrimination_illegal_in_some_contexts_count (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 4 / 15075 (0.03%) country year discrimination_illegal_in_some_contexts_count - discrimination_illegal_in_some_contexts_count + North America 2020 14 13 North America 2021 14 13 World 2020 60 59 World 2021 61 60 ~ Column discrimination_illegal_in_some_contexts_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 4 / 15075 (0.03%) country year discrimination_illegal_in_some_contexts_pop - discrimination_illegal_in_some_contexts_pop + North America 2020 50650108 50557436 North America 2021 51175891 51082662 World 2020 2800811405 2800718733 World 2021 2826585661 2826492432 ~ Column discrimination_illegal_pop (changed metadata, changed data) - - date_accessed: '2024-06-17' ? - + + date_accessed: '2024-06-21' ? + ~ Changed values: 199 / 15075 (1.32%) country year discrimination_illegal_pop - discrimination_illegal_pop + Asia 1968 33807356 102819280 Europe 1974 ...diff too long, truncated... ``` Automatically updated datasets matching _weekly_wildfires|excess_mortality|covid|fluid|flunet|country_profile|garden/ihme_gbd/2019/gbd_risk_ are not included

Edited: 2024-06-21 12:58:17 UTC Execution time: 21.41 seconds