SDG data files

Contents of the work_data folder

Main data files

• refAreas-allData.txt : Normalized dataset, tab-delimited (UTF-8). See Catalog files, Code lists, and Reference metadata files below for description of codes in this table.
• countryData-ByRegion.txt: Normalized country dataset for each region, tab-delimited (UTF-8).
• regionalData.txt: Normalized regional dataset, tab-delimited (UTF-8).

Summary tables

• countryDataAvailability-ByRegion.txt : Number of countries with available data for each region/series, across years
• countryData-ByRegion-values.txt : Country data - values for each region/series, across years
• countryData-ByRegion-nature.txt : Country data - nature of data values for each region/series, across years
• regionalData-values.txt : Regional data - values for each series, across years
• regionalData-nature.txt : Regional data - nature of data values for each series, across years

Code lists

• nature.txt: Description of data nature codes (Country Data/Country Adjusted/Estimated...)

Display grids

• grid-gtis.txt : Row titles for tabular display of series catalog (Goal/Target/Indicators/Series), tab-delimited (see gtisGrid.json below)
• grid-refAreas.txt: Row titles for tabular display of areas catalog (Level/Parent/Area/...), tab-delimited (see refAreasGrid.json below)

Reference metadata files

• refAreas-footnotes.txt : Full text of footnotes referenced in refAreas-AllData.txt
• refAreas-sourceDetails.txt : Full text of sourceDetails referenced in refAreas-AllData.txt
• refAreas-timeDetails.txt : Full text of timeDetails referenced in refAreas-AllData.txt

Contents of the app_data folder

Catalog files

• CATALOG_AREAS.json: All areas in the DSD
• CATALOG_SERIES.json: All data series in the DSD

Code lists

• CL_AGE_GROUP_SDG.json: Age group (Total/Under 1/Under 5/...)
• CL_FREQ.json: Frequency (Annual, Quarterly...)
• CL_LOCATION_SDG.json: Location (Total/Urban/Rural)
• CL_NATURE_SDG.json: Nature (Country Data/Country Adjusted/Estimated...)
• CL_REF_AREA_SDG.json: Reference area
• CL_SERIES_SDG.json: Series ( unique code for each data series )
• CL_SEX_SDG.json: Sex (Not applicable / Female / Male / Total)
• CL_SOURCE_TYPE_SDG.json: Source Type ( Household based surveys / Administrative records / Census / Other / Not available)
• CL_UNIT_MULT.json: Unit Multiplier (Units / Tens / Hundreds ...)
• CL_UNIT_SDG.json: Units (Local currency / USD / ...)

Raw data sets (codes with no description)

• sdgData.json: Original data file (series:dimensions:observations)
• REFAREAS-[xxx].json: Flattened data for area xxx
• SERIES-[xxx].json : Flattened data for series xxx

Main data files

• data2-AREA-[xxx].json: Flat data files for area code xxx
• data2-IND-[xxx].json: Flat data files for indicator xxx (including all its associated series)

Reference metadata files

• metadata.json: Main metadata files for all available indicators
• footnotes-AREA-[xxx].json: Footnote IDs and Text for area xxx
• footnotes-IND-[xxx].json: Footnote IDs and Text for indicator xxx
• sourceDetails-AREA-[xxx].json: Source detail IDs and Text for area xxx
• sourceDetails-IND-[xxx].json: Source detail IDs and Text for indicator xxx
• timeDetails-AREA-[xxx].json: Reference period detail IDs and Text for area xxx
• timeDetails-IND-[xxx].json: Reference period detail IDs and Text for indicator xxx

Display grids

• displayGrid-AREA-[xxx].json: Row titles for tabular display of data on area xxx(Goal/Target/Indicator/Series/Area...)
• displayGrid-IND-[xxx].json: Row titles for tabular display of data on indicator xxx(Goal/Target/Indicator/Series/Area...)
• gtisGrid.json : Row titles for tabular display of series catalog (Goal/Target/Indicator/Series)
• refAreasGrid.json : Row titles for tabular display of areas catalog (Level/Parent/Area/isSIDS/isLDC/isLLDC/order/number of children)