{"id":42919,"date":"2026-10-10T14:27:06","date_gmt":"2026-10-10T12:27:06","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/self-promotion-2024-drinking-water-access-two-csvs-for-comparing-coverage-and-missing-values\/"},"modified":"2026-10-10T14:27:06","modified_gmt":"2026-10-10T12:27:06","slug":"self-promotion-2024-drinking-water-access-two-csvs-for-comparing-coverage-and-missing-values","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/self-promotion-2024-drinking-water-access-two-csvs-for-comparing-coverage-and-missing-values\/","title":{"rendered":"[self-promotion] 2024 Drinking-water Access: Two CSVs For Comparing Coverage And Missing Values"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>For anyone practicing country-level joins or exploring water access, these two CSVs use the same reporting year and country IDs:<\/p>\n<ul>\n<li>At least basic drinking water: 217 country\/area rows, with 202 reported values<\/li>\n<li>Safely managed drinking water: 217 country\/area rows, with 148 reported values<\/li>\n<\/ul>\n<p>Original data: WHO\/UNICEF Joint Monitoring Programme (JMP), distributed through the World Bank\u2019s World Development Indicators. <a href=\"https:\/\/data.worldbank.org\/indicator\/SH.H2O.BASW.ZS\">At least basic source<\/a> \u00b7 <a href=\"https:\/\/data.worldbank.org\/indicator\/SH.H2O.SMDW.ZS\">Safely managed source<\/a><\/p>\n<p>Disclosure: I work on <a href=\"https:\/\/globaldatatracker.com\/\">Global Data Tracker<\/a>, which hosts the CSV exports below. They\u2019re free to download without an account.<\/p>\n<p><a href=\"https:\/\/globaldatatracker.com\/api\/v1\/exports\/basic_drinking_water?year=2024&amp;publication=wdi-2026-09-19-4d53fce7897c\">Download at least basic, 2024 CSV<\/a> <a href=\"https:\/\/globaldatatracker.com\/api\/v1\/exports\/safe_drinking_water?year=2024&amp;publication=wdi-2026-09-19-4d53fce7897c\">Download safely managed, 2024 CSV<\/a><\/p>\n<p>Each file includes country_id, country, value, unit, year, source, publication and provider-note fields. Blank values mean no published observation for that selection; they are not zeros. The files retain all 217 countries\/areas, including those with missing values. World and regional aggregate rows are excluded.<\/p>\n<p>A useful exercise: join on country_id, count missing values first, then compare the two percentages for the 148 countries\/areas with both observations. \u201cAt least basic\u201d already includes safely managed service, so don\u2019t add the columns. Safely managed also requires an improved source on premises, available when needed and free from specified contamination. <a href=\"https:\/\/washdata.org\/topics\/drinking-water\">JMP definitions<\/a><\/p>\n<p>These links pin the saved September 19, 2026 release; the observations are for 2024. Checked October 10: the values and missing entries in both files match the current World Bank API. National estimates can hide local differences and may be revised. <a href=\"https:\/\/globaldatatracker.com\/methodology\">Release\/method notes<\/a> \u00b7 <a href=\"https:\/\/data.worldbank.org\/summary-terms-of-use\">World Bank data-use terms and attribution<\/a><\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/TrekkingAround10\"> \/u\/TrekkingAround10 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1x2d1mq\/selfpromotion_2024_drinkingwater_access_two_csvs\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1x2d1mq\/selfpromotion_2024_drinkingwater_access_two_csvs\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-42919 jlk' href='javascript:void(0)' data-task='like' data-post_id='42919' data-nonce='b9a40cecc8' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-42919 lc'>0<\/span><\/a><\/div><\/div> <div class='status-42919 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>For anyone practicing country-level joins or exploring water access, these two CSVs use the same reporting year&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-42919","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/42919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=42919"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/42919\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=42919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=42919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=42919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}